International Journal of Sensors, Wireless Communications and Control

Author(s): Midde Venkateswarlu Naik, D. Vasumathi* and A.P. Siva Kumar

DOI: 10.2174/2210327910999200528114552

An Improved Intelligent Approach to Enhance the Sentiment Classifier for Knowledge Discovery Using Machine Learning

Page: [582 - 593] Pages: 12

  • * (Excluding Mailing and Handling)

Abstract

Aims: The proposed research work is on an evolutionary enhanced method for sentiment or emotion classification on unstructured review text in the big data field. The sentiment analysis plays a vital role for current generation of people for extracting valid decision points about any aspect such as movie ratings, education institute or politics ratings, etc. The proposed hybrid approach combined the optimal feature selection using Particle Swarm Optimization (PSO) and sentiment classification through Support Vector Machine (SVM). The current approach performance is evaluated with statistical measures, such as precision, recall, sensitivity, specificity, and was compared with the existing approaches. The earlier authors have achieved an accuracy of sentiment classifier in the English text up to 94% as of now. In the proposed scheme, an average accuracy of sentiment classifier on distinguishing datasets outperformed as 99% by tuning various parameters of SVM, such as constant c value and kernel gamma value in association with PSO optimization technique. The proposed method utilized three datasets, such as airline sentiment data, weather, and global warming datasets, that are publically available. The current experiment produced results that are trained and tested based on 10- Fold Cross-Validations (FCV) and confusion matrix for predicting sentiment classifier accuracy.

Background: The sentiment analysis plays a vital role for current generation people for extracting valid decisions about any aspect such as movie rating, education institute or even politics ratings, etc. Sentiment Analysis (SA) or opinion mining has become fascinated scientifically as a research domain for the present environment. The key area is sentiment classification on semi-structured or unstructured data in distinguish languages, which has become a major research aspect. User-Generated Content [UGC] from distinguishing sources has been hiked significantly with rapid growth in a web environment. The huge user-generated data over social media provides substantial value for discovering hidden knowledge or correlations, patterns, and trends or sentiment extraction about any specific entity. SA is a computational analysis to determine the actual opinion of an entity which is expressed in terms of text. SA is also called as computation of emotional polarity expressed over social media as natural text in miscellaneous languages. Usually, the automatic superlative sentiment classifier model depends on feature selection and classification algorithms.

Methods: The proposed work used Support vector machine as classification technique and particle swarm optimization technique as feature selection purpose. In this methodology, we tune various permutations and combination parameters in order to obtain expected desired results with kernel and without kernel technique for sentiment classification on three datasets, including airline, global warming, weather sentiment datasets, that are freely hosted for research practices.

Results: In the proposed scheme, The proposed method has outperformed with 99.2% of average accuracy to classify the sentiment on different datasets, among other machine learning techniques. The attained high accuracy in classifying sentiment or opinion about review text proves superior effectiveness over existing sentiment classifiers. The current experiment produced results that are trained and tested based on 10- Fold Cross-Validations (FCV) and confusion matrix for predicting sentiment classifier accuracy.

Conclusion: The objective of the research issue sentiment classifier accuracy has been hiked with the help of Kernel-based Support Vector Machine (SVM) based on parameter optimization. The optimal feature selection to classify sentiment or opinion towards review documents has been determined with the help of a particle swarm optimization approach. The proposed method utilized three datasets to simulate the results, such as airline sentiment data, weather sentiment data, and global warming data that are freely available datasets.

Keywords: Sentiment analysis, knowledge discovery, machine learning, support vector machine, particle swarm optimization, global warming data.

Graphical Abstract

[1]
Montoyo A, Martinez-Barco P, Balahur A. Subjectivity and sentiment analysis: An overview of the current state of the area and envisaged developments. Decis Support Syst 2012; 53: 675-9.
[http://dx.doi.org/10.1016/j.dss.2012.05.022]
[2]
Tan S, Wu Q. A Random walk algorithm for automatic construction of domain-oriented sentiment lexicon. Expert Syst Appl 2011; 38: 12094-100.
[http://dx.doi.org/10.1016/j.eswa.2011.02.105]
[3]
Heing-Thurauan T, Kevin PG, Walsh G, Dwayne DG. Electronic word-of-mouth via consumer-opinion platforms: What motivates consumers to articulate themselves on the Internet? J Interact Market 2004; 18(1): 38-52.
[http://dx.doi.org/10.1002/dir.10073]
[4]
Kumar R, Vadlamani R. A survey on opinion mining and sentiment analysis: Tasks, approaches and applications. Knowl Base Syst 2015; 89: 14-46.
[5]
Liang CY, Wang J, Robert LK, Zhang X. Refining word embeddings using intensity scores for sentiment Analysis. IEEE/ACM Trans Audio Speech Lang Process 2018; 26(3): 671-81.
[http://dx.doi.org/10.1109/TASLP.2017.2788182]
[6]
Schouten K, Van der Weijde O, Frasincar F, Dekker R. Supervised and unsupervised aspect category detection for sentiment analysis with co-occurrence data. IEEE Trans Cybern 2018; 48(4): 1263-75.
[http://dx.doi.org/10.1109/TCYB.2017.2688801 PMID: 28422676]
[7]
Liu B. Sentiment analysis: A multifaceted problem. IEEE Intell Syst 2010; 25(3): 39-80.
[http://dx.doi.org/10.1109/MIS.2012.106]
[8]
Sun Z, Fox G. Traffic flow forecasting based on combination of multidimensional scaling and SVM. Int J Intell Transport Syst Res 2014; 12(1): 20-5.
[http://dx.doi.org/10.1007/s13177-013-0065-9]
[9]
Jackand LB, Nandi AK. Fault detection using support vector machines and artificial neural networks, augmented by genetic algorithms. Mech Syst Signal Process 2002; 16(2-3): 373-90.
[http://dx.doi.org/10.1006/mssp.2001.1454]
[10]
Kennedy J, Eberhart R, Shi Y. Swarm Intelligence. San Francisco, Calif, USA: Morgan Kaufmann Publishers 2001.
[11]
Sheng CJ, Min YC, Wu YW, Anh-Duc P. Optimizing Parameters of Support Vector machine using fast messy genetic algorithm for dispute classification. Expert Syst Appl 2014; 41(8): 3955-64.
[12]
Jurek A, Maurice D, Mulvenna YB. Improved lexicon based sentiment analysis for social media analytics. Secur Inform 2015; 4(9): 2-13.
[13]
Devi NK, Jayanthi P. Sentiment classification using SVM and PSO. Int J Adv Eng Technol 2016; 7(2): 411-3.
[14]
Vishal V, Uma V. An extensive study of sentiment analysis tools and binary classification of tweets using Rapid Miner. Procedia Comput Sci 2018; 125: 329-35.
[http://dx.doi.org/10.1016/j.procs.2017.12.044]
[15]
Abd Samad HB, Burairah HI, Gede PA. Junta Zeniarja. Opinion Mining of Movie Review using Hybrid Method of Support Vector Machine and Particle Swarm Optimization. Malaysian Technical Universities Conference on Engineering and Technology (MUCET). Procedia Eng 2013; 53: 453-62.
[16]
Jackand L.B., Nandi A.K. Fault detection using support vector machines and artificial neural networks, augmented by genetic algorithms. Mechl Syst Sign Processi. 2002; 16: 373-9.
[17]
Asriyanti IPA. On the feature selection and classification based on information gain for document sentiment analysis. Appl Comput Intell Soft Comput 2018; 2018: 1-5.
[http://dx.doi.org/10.1155/2018/1407817]
[18]
Yuan CM, Thom HT. Feature selection and parameters optimizations of SVM using particle swarm optimization for fault classification in power distribution systemsComput Intel Neurosc 2017; 1-9.4135465
[19]
Kapil S, Varun J, Ansari MD. Machine learning based support system for students to select stream. J Recent Patents Comput Sci 2019; 12: 1.
[20]
Ansari MD, Ghrera SP. Intuitionistic fuzzy local binary pattern for features extraction. Int J Inf Commun Technol 2018; 13(1): 83-98.
[http://dx.doi.org/10.1504/IJICT.2018.090435]
[21]
Abbasi A, Hsinchun C, Arab S. Sentiment analysis in multiple languages: Feature selection for opinion classification in web forums. ACM Trans Inf Syst(TOIS) 2008; 26(3): 12.
[http://dx.doi.org/10.1145/1361684.1361685]
[22]
Brezocnik L. Feature selection for classification using particle swarm optimization. IEEE EUROCON 2017 -17th International Conference on Smart Technologies Ohrid, Macedonia 2017.
[http://dx.doi.org/10.1109/EUROCON.2017.8011255]
[23]
Fang Y, Tan H, Zhang J. Multi-strategy sentiment analysis of consumer reviews based on semantic fuzzinessIEEE Access 2018; 6: 20625-31.
[http://dx.doi.org/10.1109/ACCESS.2018.2820025]
[24]
Zhao J, Gui X, Zhang X. Deep convolution neural networks for twitter sentiment analysisIEEE Access 2018; 6: 23253-60.
[25]
Chen MH, Chen WF, Ku LW. Application of sentiment analysis to Language Learning IEEE Access 2018; 6: 24433-42.
[http://dx.doi.org/10.1109/ACCESS.2018.2832137]
[26]
Shayaa S, Jaafar NI, Bahri S, et al. Sentiment Analyis of Big Data:Methods, Applications, and Open Challeges IEEE Access 2018; 6: 37807-27.
[27]
Midde VND, Vasumathi AP, Siva K. An enhanced unsupervised learning approach for sentiment analysis using extraction of Tri- Co-occurrence Words Phrases Springer Second International Conference on Computational Intelligence and Informatics, Advances in Intelligent Systems and Computing (AISC)..
[28]
Alekh A, Bhattacharya P. Sentiment analysis: A new approach for the effective use of linguistic knowledge and exploiting similarities in a set of documents to be classified. Proceedings of the international conference Natural Language Processing (ICON).
[29]
Abd. Samad Hasan Basari, Burairah Hussin I, Gede Pramudya Ananta, Junta Zeniarja. Opinion Mining of Movie Review using Hybrid Method of Support Vector Machine and Particle Swarm Optimization. Malaysian Technical Universities Conference on Engineering and Technology (MUCET), Information and Communication Technology, Elsevier Journal of Procedia Engineering. 2013; 53: 453-62.
[30]
Mochamad wahyudii, Dinar Ajeng Kristiyanti, Sentiment Analysis of Smart Phone Product Review using Support Vector Machine Algorithm Based Particle Swarm Optimization. Journal of Theoretical and Applied Information Technology. 2016; 91(1): 189-201.
[31]
Vapnik VN. Nature of Statistical Learning Theory. New York, NY, USA: Springer 1995.
[http://dx.doi.org/10.1007/978-1-4757-2440-0]
[32]
Hsu C, Chang C, Lin C. A practical guide to support vector Classification. Department of Computer Science National Taiwan University 2003.
Request history8.2.27PHP Version221msRequest Duration27MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[10:27:50] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[10:27:50] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[10:27:50] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[10:27:50] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[10:27:50] LOG.warning: Function strftime() is deprecated in /home/betabenthamscien/public_html/stor...
  • warninglog[10:27:50] LOG.warning: Function strftime() is deprecated in /home/betabenthamscien/public_html/stor...
  • Booting (101ms)time
  • Application (120ms)time
  • 1 x Application (54.21%)
    120ms
    1 x Booting (45.79%)
    101ms
    8 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    35 statements were executed, 2 of which were duplicates, 33 unique. Show only duplicated48.99ms
    • Connection Establishedalphaeurekaselec_live_10_06_2022UserAccessCheck.php#24
      Backtrace
      • 9. middleware::check_user_access:24
      • 10. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 11. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • INSERT INTO visitor_ip_address (ip_address,visitor_agent,visitor_count, created_on,updated_on) VALUES ('51365463','',1,1737109670,1737109670) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1737109670
      970μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#24
      Backtrace
      • 11. middleware::check_user_access:24
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('51365463','/article/106947',1,1737109670,1737109670)
      140μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_corporate WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_token WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_trail WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_corporate WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_token WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51365463 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51365463) limit 1
      3.78msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51365463
      • 1: 51365463
      • 2: 51365463
      • 3: 51365463
      • 4: 51365463
      • 5: 51365463
      • 6: 51365463
      • 7: 51365463
      • 8: 51365463
      • 9: 51365463
      • 10: 51365463
      • 11: 51365463
      • 12: 51365463
      • 13: 51365463
      • 14: 51365463
      • 15: 51365463
      Backtrace
      • 14. app/Models/UserAccess/UserAccess.php:784
      • 15. middleware::check_user_access:63
      • 16. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • SELECT at.type_name, p.copyright, p.publisher_location,m.month,y.year, a.publish_on, a.nid article_nid,a.article_id, a.pmid, a.issue_id, a.title, a.abstract,a.podcast,a.altmetric_score,a.altmetric_url,a.kudos_url, a.page_count, a.first_page, a.elocator, a.last_page, i.publication_date, a.file_name, a.file_path, a.doi, a.is_epub,a.epub_type, a.volume_id, a.is_uploaded, a.editor_choice, a.is_epub, j.image_file_name, a.article_no, a.art_type AS article_type, a.supplementary_filename,a.html_filename,a.prc_filename,a.epub_filename, a.graph_abs_lg_filename, a.graph_abs_sm_filename, a.oa_image_lg_filename, a.oa_image_sm_filename, j.journal_banner,a.animated_abstract,a.erratum_in,a.erratum_for, (CASE WHEN a.issue_id =0 THEN j.epub_price ELSE j.price END) AS sell_price, j.epub_price, j.nid AS jour_nid, j.title AS journal_title, j.issn, j.eissn,j.journal_id, j.subtitle AS jour_subtitle, v.volume_id,v.volume_name AS volume, v.year_id, i.title AS issue, i.month_id ,i.type issue_type, j.subtitle,j.formerly_title, ac.subtitle AS epub_title,a.crossmark_enabled,a.text_mining_urls,a.license_urls,a.created, a.receivedate, a.revisedate, a.acceptdate,js.js_title FROM article a LEFT JOIN article_section ac ON a.is_epub = ac.art_sec_id LEFT JOIN journal_section js ON a.js_id = js.js_id LEFT JOIN article_type at ON a.art_type = at.art_type_id LEFT JOIN issue i ON a.issue_id = i.issue_id LEFT JOIN month m ON m.id = i.month_id LEFT JOIN volume v ON v.volume_id = a.volume_id INNER JOIN year y ON y.id = v.year_id INNER JOIN journal j ON j.journal_id = a.journal_id INNER JOIN publisher p ON p.publisher_id = j.publisher_id WHERE a.article_id=106947
      610μsalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 115 limit 1
      680μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 115
      Backtrace
      • 14. app/Models/Journal.php:64
      • 15. app/Http/Controllers/ArticleController.php:2516
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=115) and sj.journal_id!=115 group by `j`.`nid`) as `aggregate_table`
      600μsalphaeurekaselec_live_10_06_2022Subject.php#198
      Backtrace
      • 16. app/Models/Subject.php:198
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=115) and sj.journal_id!=115 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      510μsalphaeurekaselec_live_10_06_2022Subject.php#198
      Backtrace
      • 14. app/Models/Subject.php:198
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=115) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.51msalphaeurekaselec_live_10_06_2022Subject.php#218
      Backtrace
      • 16. app/Models/Subject.php:218
      • 17. app/Http/Controllers/ArticleController.php:2518
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=115) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      1.42msalphaeurekaselec_live_10_06_2022Subject.php#218
      Backtrace
      • 14. app/Models/Subject.php:218
      • 15. app/Http/Controllers/ArticleController.php:2518
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `keywords` where `article_id` = '106947'
      260μsalphaeurekaselec_live_10_06_2022Keywords.php#85
      Bindings
      • 0: 106947
      Backtrace
      • 13. app/Models/Keywords.php:85
      • 14. app/Http/Controllers/ArticleController.php:2519
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `article_citation` where `article_id` = '106947'
      2.11msalphaeurekaselec_live_10_06_2022Article.php#1569
      Bindings
      • 0: 106947
      Backtrace
      • 13. app/Models/Article.php:1569
      • 14. app/Http/Controllers/ArticleController.php:2520
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select CONCAT_WS(' ',au.first_name, ' ', ifnull(au.initials,''), ' ', au.last_name) as authors, CONCAT(au.last_name, IFNULL(CONCAT(' ', au.initials), ''), ' ', au.first_name) AS authorsRIS, CONCAT_WS(' ',au.last_name, ' ', ifnull(au.initials,''), ' ', au.first_name) as authorsCiteAs , `au`.*, (GROUP_CONCAT(TRIM(BOTH ', ' FROM CONCAT(ifnull(concat(af.institution,','),''), ifnull(concat(af.department,','),''), ifnull(concat(af.address,','),''), ifnull(concat(af.city,','),''), ifnull(concat(af.country,','),''), ifnull(concat(af.postal_code,','),''), ifnull(concat(af.phone,','),''), ifnull(concat(af.fax,','),''))) SEPARATOR '|')) as `author_affiliation`, (GROUP_CONCAT(TRIM(BOTH ', ' FROM CONCAT(ifnull(concat(af.web_view,','),''))) SEPARATOR '|')) as `web_view` from `author` as `au` left join `author_affiliation` as `af` on `au`.`author_id` = `af`.`author_id` where `au`.`article_id` = '106947' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      600μsalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 106947
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ArticleController.php:2533
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      200μsalphaeurekaselec_live_10_06_2022BundleOffer.php#113
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:113
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      490μsalphaeurekaselec_live_10_06_2022Article.php#1959
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1959
      • 14. app/Http/Controllers/ArticleController.php:2062
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • Select j.subtitle, v.volume_id as volume_id,v.year_id,y.year as year,v.volume_name, v.total_no_of_issues, i.issue_id as issue_id,i.title as issue, i.publication_date as issue_pub_date from journal j join volume v on j.journal_id = v.journal_id join issue i on v.volume_id = i.volume_id join article a on a.issue_id = i.issue_id join year y on v.year_id = y.id where j.journal_id = 115 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      18.84msalphaeurekaselec_live_10_06_2022Issue.php#295
      Backtrace
      • 11. app/Models/Issue.php:295
      • 12. app/Http/Controllers/ArticleController.php:2068
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 1 and a.journal_id = 115 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`last_modified` desc
      4.21msalphaeurekaselec_live_10_06_2022Article.php#527
      Backtrace
      • 13. app/Models/Article.php:527
      • 14. app/Http/Controllers/ArticleController.php:2070
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 115 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`last_modified` desc
      2.86msalphaeurekaselec_live_10_06_2022Article.php#527
      Backtrace
      • 13. app/Models/Article.php:527
      • 14. app/Http/Controllers/ArticleController.php:2071
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select pdf, html, epub, prc from `article_metrics` where `article_id` = 106947 limit 1
      190μsalphaeurekaselec_live_10_06_2022Article.php#743
      Bindings
      • 0: 106947
      Backtrace
      • 14. app/Models/Article.php:743
      • 15. app/Http/Controllers/ArticleController.php:2091
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from content_by_diseases where content_id = 106947 and content_type = 'article' order by status desc limit 1
      200μsalphaeurekaselec_live_10_06_2022Article.php#750
      Backtrace
      • 11. app/Models/Article.php:750
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 182318 limit 1
      870μsalphaeurekaselec_live_10_06_2022Meta.php#59
      Bindings
      • 0: 182318
      Backtrace
      • 14. app/Models/Meta.php:59
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      220μsalphaeurekaselec_live_10_06_2022BundleOffer.php#113
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:113
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'SWCC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      300μsalphaeurekaselec_live_10_06_2022Article.php#2024
      Bindings
      • 0: SWCC
      Backtrace
      • 13. app/Models/Article.php:2024
      • 14. app/Http/Controllers/ArticleController.php:2112
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '106947' and content_type = 'a' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      320μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2186
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '10297' and content_type = 'i' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      250μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '2771' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      240μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2231
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51365463 and j.to_ip >=51365463 )) and ((j.from_date <= 1737109670 and j.to_date >= 1737109670 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2771) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51365463 and j.to_ip >=51365463 )) and ((j.from_date <= 1737109670 and j.to_date >= 1737109670 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2771) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51365463 and j.to_ip >=51365463 )) and ((j.from_date <= 1737109670 and j.to_date >= 1737109670 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2771)
      600μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2272
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51365463 and j.to_ip >=51365463 )) and ((j.from_date <= 1737109670 and j.to_date >= 1737109670 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10297) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51365463 and j.to_ip >=51365463 )) and ((j.from_date <= 1737109670 and j.to_date >= 1737109670 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10297) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51365463 and j.to_ip >=51365463 )) and ((j.from_date <= 1737109670 and j.to_date >= 1737109670 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10297)
      510μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2297
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51365463 and j.to_ip >=51365463 )) and ((j.from_date <= 1737109670 and j.to_date >= 1737109670 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 106947) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51365463 and j.to_ip >=51365463 )) and ((j.from_date <= 1737109670 and j.to_date >= 1737109670 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 106947) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51365463 and j.to_ip >=51365463 )) and ((j.from_date <= 1737109670 and j.to_date >= 1737109670 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 106947)
      540μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2329
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `article` where `first_page` < '582' and is_uploaded = 1 and issue_id = 10297 order by cast(first_page as SIGNED) desc limit 1
      520μsalphaeurekaselec_live_10_06_2022Article.php#1818
      Bindings
      • 0: 582
      Backtrace
      • 14. app/Models/Article.php:1818
      • 15. app/Http/Controllers/ArticleController.php:2470
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `article` where `last_page` > '593' and is_uploaded = 1 and issue_id = 10297 order by cast(first_page as SIGNED) asc limit 1
      450μsalphaeurekaselec_live_10_06_2022Article.php#1830
      Bindings
      • 0: 593
      Backtrace
      • 14. app/Models/Article.php:1830
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'en'
      160μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      170μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 106947 limit 1
      2.3msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 106947
      Backtrace
      • 16. app/Http/Controllers/ArticleController.php:2506
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select b.banner_link, b.banner_name, b.banner_script, b.banner_remarks, b.banner_file_name, b.banner_placement, bd.content_type, bd.content_id from `tbl_banner` as `b` inner join `tbl_banner_detail` as `bd` on `bd`.`banner_id` = `b`.`banner_id` inner join `users` as `u` on `u`.`id` = `b`.`updated_by` inner join `journal` as `j` on `j`.`journal_id` = `bd`.`content_id` where `b`.`banner_journal` = 1 and `bd`.`content_type` = 'J' and `bd`.`content_id` = 115 and `b`.`banner_from_date` <= 1737109670 and `b`.`banner_to_date` >= 1737109670 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.14msalphaeurekaselec_live_10_06_2022Banner.php#189
      Bindings
      • 0: 1
      • 1: J
      • 2: 115
      • 3: 1737109670
      • 4: 1737109670
      • 5: A
      Backtrace
      • 13. app/Models/Banner.php:189
      • 14. app/Http/helpers.php:404
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • select count(*) as aggregate from `uc_cart_products` where cart_id='18d2c5c2cbad9e036594d637539d09b2'
      220μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._main_menu:13
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        0Szps6Nti7TJM6p9O0Jku9RMPMsUeZhZhQhtGyks
        uc_cart_id
        18d2c5c2cbad9e036594d637539d09b2
        _previous
        array:1 [ "url" => "https://beta.benthamscience.com/article/106947" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/106947
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:17 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "beta.benthamscience.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6ImFmTDBsTUFBQTNUQWdvZVk0VEhVaGc9PSIsInZhbHVlIjoia1JXanFaaUlTTXZVcU83eFExNUxPNDhiK2Z4b2c2TWZlRVFsa2VlOUVycU5tVzVzeG9ZUEQ1bFF4RlRKdUtQZjVwczVWSURXMkg5NG5sNDJvWHhDaFBMSlRLR2Q2QW5JSUQxUjdiSjBBb3JjN3ZvcGY5RXBhd2dCN291WnZhR3oiLCJtYWMiOiI1MGUwODUxYWU5ZjMyMzBkNjljZmU4MmM0MjI2ZDQ3ZWRiMWUzYTZhM2I1MWVjZmQ5MTgyZWYyYTRjNDE3NGIzIiwidGFnIjoiIn0%3D; eurekaselectnew_session=eyJpdiI6ImR4N001NzZKWXZBbE9vSGcxQS9HeUE9PSIsInZhbHVlIjoiOE16TWlsaDB1OXRHZ0RaeEtURnZPc0Q3WjFmRmx5UWJENlZsRjVjbXNNRUNBOUk0TEh3UDdoVWtzdUE4STR0OUFFMzl0QnpDSmNNSW9vbDVBMjVwR1pObkRQTnpSeXMxSGxDTFBkOEhNVHVKcEdqN1BmNTJZa1hqYW41TEpXVUciLCJtYWMiOiI0Mjk3ODQ4NzJjZjFlMDM5ZDJmZjA1ZTBmMmRmNWZhYjM4ZDM0YmE3YmJhYmU2ZmJlM2NiMGJjNGRjMDcyZTY1IiwidGFnIjoiIn0%3D; _ga_9F3B5VV3T3=GS1.1.1737109668.1.0.1737109668.60.0.0; _ga=GA1.1.1308967689.1737109669XSRF-TOKEN=eyJpdiI6ImFmTDBsTUFBQTNUQWdvZVk0VEhVaGc9PSIsInZhbHVlIjoia1JXanFaaUlTTXZVcU83eFExNUxPNDhiK2Z4b2c2TWZlRVFsa2VlOUVycU5tVzVzeG9ZUEQ1bFF4RlRKdUtQZjVwczVWS" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_cookies
        0 of 0
        array:4 [ "XSRF-TOKEN" => "0Szps6Nti7TJM6p9O0Jku9RMPMsUeZhZhQhtGyks" "eurekaselectnew_session" => "I7jrfGnWyOjlA2acNuhjtGAgQuWCh9xqDag15DPY" "_ga_9F3B5VV3T3" => null "_ga" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 17 Jan 2025 10:27:50 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjBOdFNTNk9JM014Q2liUWw1VGRJR3c9PSIsInZhbHVlIjoiQmg0dUJ4Qk9HMyt0U3N2Ujc5anlpMTIwRFdjKzlaNTZ2VWs0SmFmb0lnNERkMnkrUy9xVi80YnFWNWY1Mmt4b3V1blRubGVUa2d4aks3VmRxZm9qVC9mYzk5L1R2VE44K2pCdmpqZGRoWDFNTjRXSXNPZ0Juc1hqUXJnSnUrT2IiLCJtYWMiOiJjYjJlNzRlYmZiMzY4NmNhYmI1ZWNhNzI3NTY2NzIzNjgyM2NiZmE2ZTFkNTQyNDcxOGViMzJhYWQwMWQyMWQ5IiwidGFnIjoiIn0%3D; expires=Sun, 19 Jan 2025 22:27:50 GMT; Max-Age=216000; path=/; secure; samesite=strictXSRF-TOKEN=eyJpdiI6IjBOdFNTNk9JM014Q2liUWw1VGRJR3c9PSIsInZhbHVlIjoiQmg0dUJ4Qk9HMyt0U3N2Ujc5anlpMTIwRFdjKzlaNTZ2VWs0SmFmb0lnNERkMnkrUy9xVi80YnFWNWY1Mmt4b3V1blRub" 1 => "eurekaselectnew_session=eyJpdiI6InJiYWs4MFZUT0gzUFBhUzk1QjkxOHc9PSIsInZhbHVlIjoiazhSUURjUE1ZaGhtYzlSR1BXOGh0MDYwSUNwbWRRa3lUUVpLdjhtUE5Fb3p0RU9WQTFBVWI0Z2dlQXhuZTZHcTB0Q1REajFJNFE5YWFkeTBqUUpyMzJyUGNQOWJnQlEzT1hjRkdpWXVWNVk2enlwemMwYkh0TFZjUjBNNlRUYW8iLCJtYWMiOiI2NTRhN2NkYmY0NzdhNTEzMTY0MzIyMWJkMDViNTE1YzhmMjU1MjJiMzNlMmU5MGZjYzBlNjcxYTQ2MTNkMWU0IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=stricteurekaselectnew_session=eyJpdiI6InJiYWs4MFZUT0gzUFBhUzk1QjkxOHc9PSIsInZhbHVlIjoiazhSUURjUE1ZaGhtYzlSR1BXOGh0MDYwSUNwbWRRa3lUUVpLdjhtUE5Fb3p0RU9WQTFBVWI0Z2dlQXhu" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjBOdFNTNk9JM014Q2liUWw1VGRJR3c9PSIsInZhbHVlIjoiQmg0dUJ4Qk9HMyt0U3N2Ujc5anlpMTIwRFdjKzlaNTZ2VWs0SmFmb0lnNERkMnkrUy9xVi80YnFWNWY1Mmt4b3V1blRubGVUa2d4aks3VmRxZm9qVC9mYzk5L1R2VE44K2pCdmpqZGRoWDFNTjRXSXNPZ0Juc1hqUXJnSnUrT2IiLCJtYWMiOiJjYjJlNzRlYmZiMzY4NmNhYmI1ZWNhNzI3NTY2NzIzNjgyM2NiZmE2ZTFkNTQyNDcxOGViMzJhYWQwMWQyMWQ5IiwidGFnIjoiIn0%3D; expires=Sun, 19-Jan-2025 22:27:50 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjBOdFNTNk9JM014Q2liUWw1VGRJR3c9PSIsInZhbHVlIjoiQmg0dUJ4Qk9HMyt0U3N2Ujc5anlpMTIwRFdjKzlaNTZ2VWs0SmFmb0lnNERkMnkrUy9xVi80YnFWNWY1Mmt4b3V1blRub" 1 => "eurekaselectnew_session=eyJpdiI6InJiYWs4MFZUT0gzUFBhUzk1QjkxOHc9PSIsInZhbHVlIjoiazhSUURjUE1ZaGhtYzlSR1BXOGh0MDYwSUNwbWRRa3lUUVpLdjhtUE5Fb3p0RU9WQTFBVWI0Z2dlQXhuZTZHcTB0Q1REajFJNFE5YWFkeTBqUUpyMzJyUGNQOWJnQlEzT1hjRkdpWXVWNVk2enlwemMwYkh0TFZjUjBNNlRUYW8iLCJtYWMiOiI2NTRhN2NkYmY0NzdhNTEzMTY0MzIyMWJkMDViNTE1YzhmMjU1MjJiMzNlMmU5MGZjYzBlNjcxYTQ2MTNkMWU0IiwidGFnIjoiIn0%3D; path=/; secure; httponlyeurekaselectnew_session=eyJpdiI6InJiYWs4MFZUT0gzUFBhUzk1QjkxOHc9PSIsInZhbHVlIjoiazhSUURjUE1ZaGhtYzlSR1BXOGh0MDYwSUNwbWRRa3lUUVpLdjhtUE5Fb3p0RU9WQTFBVWI0Z2dlQXhu" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "0Szps6Nti7TJM6p9O0Jku9RMPMsUeZhZhQhtGyks" "uc_cart_id" => "18d2c5c2cbad9e036594d637539d09b2" "_previous" => array:1 [ "url" => "https://beta.benthamscience.com/article/106947" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-17 10:27:50GET/article/10694768351