Generic placeholder image

Current Computer-Aided Drug Design

Editor-in-Chief

ISSN (Print): 1573-4099
ISSN (Online): 1875-6697

Research Article

3D-QSAR and Molecular Docking Studies on Oxadiazole Substituted Benzimidazole Derivatives: Validation of Experimental Inhibitory Potencies Towards COX-2

Author(s): Vivek Asati, Piyush Ghode, Shalini Bajaj, Sanmati K. Jain and Sanjay K. Bharti*

Volume 15, Issue 4, 2019

Page: [277 - 293] Pages: 17

DOI: 10.2174/1573409914666181003153249

Price: $65

Abstract

Background: In past few decades, computational chemistry has seen significant advancements in design and development of novel therapeutics. Benzimidazole derivatives showed promising anti-inflammatory activity through the inhibition of COX-2 enzyme.

Objective: The structural features necessary for COX-2 inhibitory activity for a series of oxadiazole substituted benzimidazoles were explored through 3D-QSAR, combinatorial library generation (Combi Lab) and molecular docking.

Methods: 3D-QSAR (using kNN-MFA (SW-FB) and PLSR (GA) methods) and Combi Lab studies were performed by using VLife MDS Molecular Design Suite. The molecular docking study was performed by using AutoDockVina.

Results: Significant QSAR models generated by PLSR exhibited r2 = 0.79, q2 = 0.68 and pred_r2 = 0. 84 values whereas kNN showed q2 = 0.71 and pred_r2 = 0.84. External validation of developed models by various parameters assures their reliability and predictive efficacy. A library of 72 compounds was generated by combinatorial technique in which 11 compounds (A1-A5 and B1-B6) showed better predicted biological activity than the most active compound 27 (pIC50 = 7.22) from the dataset. These compounds showed proximal interaction with amino acid residues like TYR355 and/or ARG120 on COX-2(PDB ID: 4RS0).

Conclusion: The present work resulted in the design of more potent benzimidazoles as COX-2 inhibitors with good interaction as compared to reference ligand. The results of the study may be helpful in the development of novel COX-2 inhibitors for inflammatory disorders.

Keywords: 3D-QSAR, k-nearest neighbor, Lipinski’s rule of five, virtual screening, COX-2, benzimidazole derivatives.

Next »
Graphical Abstract

[1]
Lawrence, T.; Willoughby, D.A.; Gilroy, D.W. Anti-inflammatory lipid mediators and insights into the resolution of inflammation. Nat. Rev. Immunol., 2002, 2, 787-795.
[2]
Kurumbail, R.G.; Stevens, A.M.; Gierse, J.K.; McDonald, J.J.; Stegeman, R.A.; Pak, J.Y.; Gildehaus, D.; Miyashiro, J.M.; Penning, T.D.; Seibert, K.; Isakson, P.C.; Stallings, W.C. Structural basis for selective inhibition of cyclooxygenase-2 by anti-inflammatory agents. Nature, 1996, 384, 644-648.
[3]
Smith, W.L.; DeWitt, D.L. Prostaglandin endoperoxide H synthases- 1 and 2. Adv. Immunol., 1996, 62, 167-215.
[4]
Herschman, H.R. Prostaglandin synthase 2. Biochim. Biophys. Acta, 1996, 1299, 125-140.
[5]
Fiorucci, S.; Meli, R.; Bucci, M.; Cirino, G. Dual inhibitors of cyclooxygenase and 5-lipoxygenase: A new avenue in anti-inflammatory therapy. Biochem. Pharmacol., 2001, 62, 1433-1438.
[6]
Amer, M.; Bead, V.R.; Bathon, J.; Blumenthal, R.S.; Edwards, D.N. Use of nonsteroidal anti-inflammatory drugs in patients with cardiovascular disease. Cardiol. Rev., 2010, 18, 204-212.
[7]
Ferreira, M.M.C. Multivariate QSAR. J. Braz. Chem. Soc., 2002, 13, 742.
[8]
Jain, S.V.; Bhadoriya, K.S.; Bari, S.B.; Sahu, N.K.; Ghate, M. Discovery of potent anticonvulsant ligands as dual NMDA and AMPA receptors antagonists by molecular modelling studies. Med. Chem. Res., 2012, 21, 3465-3484.
[9]
Bhadoriya, K.S.; Sharma, M.C.; Jain, S.V.; Kad, S.A.; Raghuvanshi, D. QSAR studies of fused 5,6-bicyclic heterocycles as c-secretase modulators. J. Pharm. Res., 2012, 5(8), 4127-4132.
[10]
Gaba, M.; Singh, D.; Singh, S.; Sharma, V.; Gaba, P. Synthesis and pharmacological evaluation of novel 5-substituted-1-(phenylsulfonyl)- 2-methylbenzimidazole derivatives as anti-inflammatory and analgesic agents. Eur. J. Med. Chem., 2010, 45, 2245-2249.
[11]
Jesudason, E.P.; Sridhar, S.K.; Malar, E.J.P.; Shanmugapandiyan, P.; Inayathullah, M.; Arul, V.; Selvaraj, D.; Jayakumar, R. Synthesis, pharmacological screening, quantum chemical and in vitro permeability studies of N-Mannich bases of benzimidazoles through bovine cornea. Eur. J. Med. Chem., 2009, 44, 2307-2312.
[12]
Refaat, H.M. Synthesis and anticancer activity of some novel 2- substituted benzimidazole derivatives. Eur. J. Med. Chem., 2010, 45, 2949-2956.
[13]
Romero-Castro, A.; Leon-Rivera, I.; Avila-Rojas, L.C.; Navarrete-Vazquez, G.; Nieto-Rodriguez, A. Synthesis and preliminary evaluation of selected 2-aryl-5(6)-nitro-1H-benzimidazole derivatives as potential anticancer agents. Arch. Pharm. Res., 2011, 34, 181-189.
[14]
Abonia, R.; Cortes, E.; Insuasty, B.; Quiroga, J.; Nogueras, M.; Cobo, J. Synthesis of novel 1,2,5-trisubstituted benzimidazoles as potential antitumor agents. Eur. J. Med. Chem., 2011, 46, 4062-4070.
[15]
Shaharyar, M.; Abdullah, M.M.; Bakht, M.A.; Majeed, J. Pyrazoline bearing benzimidazoles: Search for anticancer agents. Eur. J. Med. Chem., 2010, 45, 114-119.
[16]
Rathore, A.; Rahman, M.U.; Siddiqui, A.A.; Ali, A.; Shaharyar, M. Design and synthesis of benzimidazole analogs endowed with oxadiazole as selective COX-2 inhibitor. Arch. Pharm. Chem. Life Sci., 2014, 1, 347.
[17]
Rathore, A.; Rahman, M.U.; Siddiqui, A.A.; Ali, A.; Shaharyar, M. Synthesis and evaluation of benzimidazole derivatives as selective COX-2 inhibitors. Med. Chem., 2015, 11, 188-199.
[18]
VLife M.D.S. 4.4 Molecular design suite. Vlife Sciences Technologies Pvt. Ltd., Pune. Available at; www.vlifesciences.com2014
[19]
Ajmani, S.; Jadhav, K.; Kulkarni, S.A. Three-dimensional QSAR using the k-nearest neighbor method and its interpretation. J. Chem. Inf. Model., 2006, 46, 24-31.
[20]
Clark, M.; Cramer, R.D.; Van, O.N. Validation of the general purpose Tripose 5.2 force field. J. Comput. Chem., 1989, 10, 982-1012.
[21]
Guyon, I.; Elisseeff, A. An introduction to variable and feature selection. J. Mach. Learn. Res., 2003, 3, 1157-1182.
[22]
Darlington, R.B. Regression and linear models; McGraw-Hill: New York, 1990.
[23]
Holland, J.H. Genetic algorithms. Sci. Am., 1992, 267, 66-72.
[24]
Ghosh, P.; Bagchi, M.C. QSAR modeling for quinoxaline derivatives using genetic algorithm and simulated annealing based feature selection. Curr. Med. Chem., 2009, 16(30), 4032-4048.
[25]
Tropsha, A.; Gramatica, P.; Gombar, V. The importance of being earnest: Validation is the absolute essential for successful application and interpretation of QSPR models. Quant. Str. Act. Rel., 2003, 22, 1-9.
[26]
Shi, L.M.; Fang, H.; Tong, W.D.; Wu, J.; Perkins, R.; Blair, R.M.; Branham, W.S.; Dial, S.L.; Moland, C.I.; Sheehan, D.M. QSAR models using a large diverse set of estrogens. J. Chem. Inf. Comput. Sci., 2001, 41, 186-195.
[27]
Schüurmann, G.; Ebert, R.U.; Chen, J.; Wang, B.; Kuehne, R. External validation and prediction employing the predictive squared correlation coefficient - test set activity mean vs training set activity mean. J. Chem. Inf. Model., 2008, 48, 2140-2145.
[28]
Gramatica, P.; Chirico, N.; Papa, E.; Cassani, S.; Kovarich, S. QSARINS: A new software for the development, analysis, and validation of QSAR MLR models. J. Comp. Chem. Software News Update, 2013, 34, 2121-2132.
[29]
Tropsha, A.; Golbraikh, A. Predictive QSAR modeling work- flow, model applicability domains, and virtual screening. Curr. Pharm. Des., 2007, 13, 3494-3504.
[30]
Eriksson, L.; Jaworska, J.; Worth, A.P.; Cronin, M.T.D.; McDowell, R.M.; Gramatica, P. Methods for reliability and uncertainty assessment and for applicability evaluations of classification- and regression-based QSARs. Environ. Health Perspect., 2003, 111, 1361-1375.
[31]
Roy, P.P.; Roy, K. On some aspects of validation of predictive quantitative structure-activity relationship models. Expert Opin. Drug Discov., 2007, 2, 1567-1577.
[32]
Atkinson, A.C. Plots, Transformations and Regression; Clarendon Press: Oxford, 1985.
[33]
Jaworska, J.; Nikolova, J.N.; Aldenberg, T. QSAR applicabilty domain estimation by projection of the training set descriptor space: A review. Altern. Lab. Anim., 2005, 33, 445-459.
[34]
Lipinski, C.A.; Lombardo, F.; Dominy, B.W.; Feeney, P.J. Experimental and computational approaches to estimate solubility and permeability in drug discovery and development settings. Adv. Drug Deliv. Rev., 1997, 23, 3-25.
[35]
Trott, O.; Olson, A.J. AutoDockVina: Improving the speed and accuracy of docking with a new scoring function, efficient optimization and multithreading. J. Comput. Chem., 2010, 31, 455-461.
[36]
Seeliger, D.; Groot, B.L. Ligand docking and binding site analysis with PyMOL and Autodock/Vina. J. Comput. Aided Mol. Des., 2010, 24, 417-422.
[37]
Chang, M.W.; Ayeni, C.; Breuer, S.; Torbett, B.E. Virtual Screening for HIV protease inhibitors: A comparison of AutoDock 4 and Vina. PLoS One, 2010, 5(8), e11955.
[38]
Osterberg, F.; Morris, G.M.; Sanner, M.F.; Olson, A.J.; Goodsell, D.S. Automated docking to multiple target structures: Incorporation of protein mobility and structural water heterogeneity in autodock. Proteins: StructFunct Genet., 2002, 46, 34-40.
[39]
Stigliani, J.L.; Bernardes-Génisson, V.; Bernadoua, J.; Pratviela, G. Cross-docking study on InhA inhibitors: A combination of AutodockVina and PM6-DH2 simulations to retrieve bio-active conformations. Org. Biomol. Chem., 2012, 10, 6341-6345.
[40]
Sun, H.; Li, Y.; Shen, M.; Tian, S.; Xu, L.; Pan, P.; Guan, Y.; Hou, T. Assessing the performance of MM/PBSA and MM/GBSA methods. 5. Improved docking performance using high solute dielectric constant MM/GBSA and MM/PBSA rescoring. Phy. Chem., 2014, 16(40), 22035-22045.
[41]
Sierra, C.; Ordóñez, C.; Saavedra, A.; Gallego, J.R. Element enrichment factor calculation using grain-size distribution and functional data regression. Chemosphere, 2015, 119, 1192-1199.
[42]
Hamza, A.; Wei, N.N.; Zhan, C.G. Ligand-based virtual screening approach using a new scoring function. J. Chem. Inf. Model., 2012, 52(4), 963-974.
[43]
QikProp, version 4.3; Schrödinger, LLC: New York, NY, 2015.
[44]
Becke, A.D. A new mixing of Hartree-Fock and local densityfunctional theories. J. Chem. Phys., 1993, 98(2), 1372.
[45]
Lee, C.; Yang, W.; Parr, R.G. Development of the Colle-Salvetti correlation-energy formula into a functional of the electron density. Phys. Rev. B, 1988, 37(2), 785-789.
[46]
Lipinski, C.A.; Lombardo, F.; Dominy, B.W.; Feeney, P.J. Experimental and computational approaches to estimate solubility and permeability in drug discovery and development settings. Adv. Drug Deliv. Rev., 2001, 46, 3-26.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version435msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[04:28:57] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[04:28:57] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[04:28:57] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (110ms)time
  • Application (326ms)time
  • 1 x Application (74.82%)
    326ms
    1 x Booting (25.18%)
    110ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.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
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated226ms
    • 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 ('60015499','',1,1740457737,1740457737) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740457737
      1.02msalphaeurekaselec_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 ('60015499','/article/93409',1,1740457737,1740457737)
      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 >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) 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 >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) 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 >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) 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 >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) 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 >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) 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 >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) limit 1
      11.54msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 60015499
      • 1: 60015499
      • 2: 60015499
      • 3: 60015499
      • 4: 60015499
      • 5: 60015499
      • 6: 60015499
      • 7: 60015499
      • 8: 60015499
      • 9: 60015499
      • 10: 60015499
      • 11: 60015499
      • 12: 60015499
      • 13: 60015499
      • 14: 60015499
      • 15: 60015499
      Backtrace
      • 14. app/Models/UserAccess/UserAccess.php:784
      • 15. middleware::check_user_access:114
      • 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=93409
      680μ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` = 5 limit 1
      750μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 5
      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=5) and sj.journal_id!=5 group by `j`.`nid`) as `aggregate_table`
      640μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 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=5) and sj.journal_id!=5 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      580μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 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=5) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.79msalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 16. app/Models/Subject.php:220
      • 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=5) 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.53msalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 14. app/Models/Subject.php:220
      • 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` = '93409'
      1.25msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 93409
      Backtrace
      • 13. app/Models/Keywords.php:43
      • 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` = '93409'
      2.94msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 93409
      Backtrace
      • 13. app/Models/Article.php:1570
      • 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, CONCAT_WS(' ',au.first_name, IFNULL(CONCAT(' ', au.initials), ''), IFNULL(CONCAT(' ', au.last_name), '')) as authorsmodal , `au`.*, `af`.`ror_id`, `af`.`institution`, `af`.`department`, `af`.`country`, `af`.`city`, `af`.`address`, (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` = '93409' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.02msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 93409
      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
      240μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 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
      470μsalphaeurekaselec_live_10_06_2022Article.php#1960
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1960
      • 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 = 5 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      24.36msalphaeurekaselec_live_10_06_2022Issue.php#298
      Backtrace
      • 11. app/Models/Issue.php:298
      • 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 = 5 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      10.21msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 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 = 5 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      4.49msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 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` = 93409 limit 1
      1.39msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 93409
      Backtrace
      • 14. app/Models/Article.php:744
      • 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 = 93409 and content_type = 'article' order by status desc limit 1
      300μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 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 a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 295 and cd.sub_disease_id = 300 and content_id!=93409 and cd.content_type = 'article' order by rand() limit 20
      144msalphaeurekaselec_live_10_06_2022Article.php#769
      Backtrace
      • 11. app/Models/Article.php:769
      • 12. app/Http/Controllers/ArticleController.php:2098
      • 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` = 165923 limit 1
      250μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 165923
      Backtrace
      • 14. app/Models/Meta.php:30
      • 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
      230μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 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` = 'CCADD' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      270μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CCADD
      Backtrace
      • 13. app/Models/Article.php:2025
      • 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 = '93409' 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) )
      340μ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 = '9184' 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) )
      270μ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 = '2555' 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) )
      300μ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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1740457737 and j.to_date >= 1740457737 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2555) 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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1740457737 and j.to_date >= 1740457737 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2555) 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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1740457737 and j.to_date >= 1740457737 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2555)
      2.87msalphaeurekaselec_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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1740457737 and j.to_date >= 1740457737 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9184) 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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1740457737 and j.to_date >= 1740457737 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9184) 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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1740457737 and j.to_date >= 1740457737 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9184)
      750μ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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1740457737 and j.to_date >= 1740457737 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 93409) 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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1740457737 and j.to_date >= 1740457737 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 93409) 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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1740457737 and j.to_date >= 1740457737 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 93409)
      800μ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` < '277' and is_uploaded = 1 and issue_id = 9184 order by cast(first_page as SIGNED) desc limit 1
      520μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 277
      Backtrace
      • 14. app/Models/Article.php:1819
      • 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` > '293' and is_uploaded = 1 and issue_id = 9184 order by cast(first_page as SIGNED) asc limit 1
      490μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 293
      Backtrace
      • 14. app/Models/Article.php:1831
      • 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'
      200μ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
      220μ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` = 93409 limit 1
      3.6msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 93409
      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` = 5 and `b`.`banner_from_date` <= 1740457737 and `b`.`banner_to_date` >= 1740457737 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.71msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 5
      • 3: 1740457737
      • 4: 1740457737
      • 5: A
      Backtrace
      • 13. app/Models/Banner.php:95
      • 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 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` = 5 and `b`.`banner_from_date` <= 1740457737 and `b`.`banner_to_date` >= 1740457737 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.55msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 5
      • 3: 1740457737
      • 4: 1740457737
      • 5: A
      Backtrace
      • 13. app/Models/Banner.php:95
      • 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='0dceeaaa33d4737ada720abd7c9d2cab'
      280μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 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
        ixoCWHRd8EYFdLmfUHxfwadFQjx5aECCZfsbw2zA
        uc_cart_id
        0dceeaaa33d4737ada720abd7c9d2cab
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/93409" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/93409
        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:9 [ "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6IjBkdjFzWmtPUXB5bG9Uemx6QnE2RUE9PSIsInZhbHVlIjoiWHpQRjkvdGVVYm5Jc0ExMkRCQlJmcVVHaFVVUFJQL1RJN2l2dTFRd1dKMD0iLCJtYWMiOiI5YWQ5YzMyMTc2OGU0MjgxYjk3N2YwMmU1MWQ5NGI4OTljMjU1NmQ3MGQ4ZjgzNGFmNWIyYjdkNTQ0MGY5MWJmIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IjBkdjFzWmtPUXB5bG9Uemx6QnE2RUE9PSIsInZhbHVlIjoiWHpQRjkvdGVVYm5Jc0ExMkRCQlJmcVVHaFVVUFJQL1RJN2l2dTFRd1dKMD0iLCJtYWMiOiI5YWQ5YzMyMTc2OGU0" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "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" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => 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 => "Tue, 25 Feb 2025 04:28:57 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ii9TVXJkNWRtMmZYdXBuVmxBVGlZWkE9PSIsInZhbHVlIjoiVEtTQ3BDWStHYjFrSWFxTE5kdEt0cCtGc0Vrd2kzS0lYQ0tvQ2lSaWovcDNjS2g5NlBCTWFaSnhmRkN1RmlNV0xEUnJWY3A3NmRGdXJFSEsvWXdRL3duMkJSWkw1dnFTeXVEcGlDdklnWXFMZHFLVEJwSDVVZ0lyZGp1OTBvcnYiLCJtYWMiOiJkOWE2OTg5OWZmMTZkMjcwYzk1YmI4YzJhM2ZkN2M5ZmM1MmI2M2MzNTVhZGY0YjkyMDM1ZWI2OWY0MmE0OGUzIiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 16:28:57 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ii9TVXJkNWRtMmZYdXBuVmxBVGlZWkE9PSIsInZhbHVlIjoiVEtTQ3BDWStHYjFrSWFxTE5kdEt0cCtGc0Vrd2kzS0lYQ0tvQ2lSaWovcDNjS2g5NlBCTWFaSnhmRkN1RmlNV0xEUnJWY" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjdKbXJhTTd6S1JMclE5Y2dOQ3R2ZkE9PSIsInZhbHVlIjoieFp0dVdMS29Yb3NLL0dvZVRHVm9KQ1cyVEhaRGZlUjVvYWN3SmtFRmNxcnJUczZNZW1mdm5HSTQrWFdySTNFY09LY0FQZVpUWmx1WGcwS0NCaDNBSVJUZEtGNVRMK1R2ZStzZWkzc2NETDZ4Y0V3NVhKUkdyNldkekszREgvZGMiLCJtYWMiOiJhNGY4YTNhM2FmNGJkMDkyNjNkMzQ2ZDRmZTNjN2E0Y2NiOGQ5MDg2ZjkyN2I4ZWRlZDhlNGVmZjM0ODQ1ZDA4IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IjdKbXJhTTd6S1JMclE5Y2dOQ3R2ZkE9PSIsInZhbHVlIjoieFp0dVdMS29Yb3NLL0dvZVRHVm9KQ1cyVEhaRGZlUjVvYWN3SmtFRmNxcnJUczZNZW1mdm5HSTQ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ii9TVXJkNWRtMmZYdXBuVmxBVGlZWkE9PSIsInZhbHVlIjoiVEtTQ3BDWStHYjFrSWFxTE5kdEt0cCtGc0Vrd2kzS0lYQ0tvQ2lSaWovcDNjS2g5NlBCTWFaSnhmRkN1RmlNV0xEUnJWY3A3NmRGdXJFSEsvWXdRL3duMkJSWkw1dnFTeXVEcGlDdklnWXFMZHFLVEJwSDVVZ0lyZGp1OTBvcnYiLCJtYWMiOiJkOWE2OTg5OWZmMTZkMjcwYzk1YmI4YzJhM2ZkN2M5ZmM1MmI2M2MzNTVhZGY0YjkyMDM1ZWI2OWY0MmE0OGUzIiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 16:28:57 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ii9TVXJkNWRtMmZYdXBuVmxBVGlZWkE9PSIsInZhbHVlIjoiVEtTQ3BDWStHYjFrSWFxTE5kdEt0cCtGc0Vrd2kzS0lYQ0tvQ2lSaWovcDNjS2g5NlBCTWFaSnhmRkN1RmlNV0xEUnJWY" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjdKbXJhTTd6S1JMclE5Y2dOQ3R2ZkE9PSIsInZhbHVlIjoieFp0dVdMS29Yb3NLL0dvZVRHVm9KQ1cyVEhaRGZlUjVvYWN3SmtFRmNxcnJUczZNZW1mdm5HSTQrWFdySTNFY09LY0FQZVpUWmx1WGcwS0NCaDNBSVJUZEtGNVRMK1R2ZStzZWkzc2NETDZ4Y0V3NVhKUkdyNldkekszREgvZGMiLCJtYWMiOiJhNGY4YTNhM2FmNGJkMDkyNjNkMzQ2ZDRmZTNjN2E0Y2NiOGQ5MDg2ZjkyN2I4ZWRlZDhlNGVmZjM0ODQ1ZDA4IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IjdKbXJhTTd6S1JMclE5Y2dOQ3R2ZkE9PSIsInZhbHVlIjoieFp0dVdMS29Yb3NLL0dvZVRHVm9KQ1cyVEhaRGZlUjVvYWN3SmtFRmNxcnJUczZNZW1mdm5HSTQ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "ixoCWHRd8EYFdLmfUHxfwadFQjx5aECCZfsbw2zA" "uc_cart_id" => "0dceeaaa33d4737ada720abd7c9d2cab" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/93409" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 04:28:57GET/article/93409314371