Generic placeholder image

Combinatorial Chemistry & High Throughput Screening

Editor-in-Chief

ISSN (Print): 1386-2073
ISSN (Online): 1875-5402

Research Article

Catechin Derivatives as Inhibitor of COVID-19 Main Protease (Mpro): Molecular Docking Studies Unveil an Opportunity Against CORONA

Author(s): Muhammad Nouman Arif*

Volume 25, Issue 1, 2022

Published on: 22 November, 2020

Page: [197 - 203] Pages: 7

DOI: 10.2174/1871520620666201123101002

Price: $65

Abstract

Background: A newly emergent strain of coronavirus (COVID-19) has affected almost the whole of the world’s population. Currently, there is no specific vaccine or drug against COVID-19. Xu et al. (2020) built a homolog model of SARS-CoV-2 Mpro based on SARS-CoV Mpro, which is considered as a target to inhibit the replication of CoV.

Objective: The aim of the current study was to find potential inhibitors of COVID-19 Mpro using docking analysis.

Methods: Autodockvina was used to carry out Protein-Ligand docking. COVID-19 main protease Mpro was docked with catechin and its different synthetic derivatives. Nelfinavir, an antiretroviral drug belonging to protease inhibitors, was taken as the standard.

Results: According to the result obtained, it was found that Compound (4) and Compound (1) have more affinity than nelfinavir.

Conclusion: Compounds were found to have a great potential to become COVID-19 main protease Mpro inhibitor. Nevertheless, for their medicinal use, further investigation is necessary.

Keywords: COVID-19, cetachin derivatives, docking analysis, Mpro, infection, therapy.

Graphical Abstract

[1]
Malik, Y.S.; Sircar, S.; Bhat, S.; Sharun, K.; Dhama, K.; Dadar, M.; Tiwari, R.; Chaicumpa, W. Emerging novel coronavirus (2019-nCoV)-current scenario, evolutionary perspective based on genome analysis and recent developments. Vet. Q., 2020, 40(1), 68-76.
[http://dx.doi.org/10.1080/01652176.2020.1727993] [PMID: 32036774]
[2]
Lee, P-I.; Hsueh, P-R. Emerging threats from zoonotic coronaviruses-from SARS and MERS to 2019-nCoV. J. Microbiol. Immunol. Infect., 2020, 53(3), 365-367.
[http://dx.doi.org/10.1016/j.jmii.2020.02.001] [PMID: 32035811]
[3]
Rodríguez-Morales, A.J.; MacGregor, K.; Kanagarajah, S.; Patel, D.; Schlagenhauf, P. Going global - Travel and the 2019 novel coronavirus. Travel Med. Infect. Dis., 2020, 33.
[http://dx.doi.org/10.1016/j.tmaid.2020.101578] [PMID: 32044389]
[4]
Zhu, N.; Zhang, D.; Wang, W.; Li, X.; Yang, B.; Song, J.; Zhao, X.; Huang, B.; Shi, W.; Lu, R.; Niu, P.; Zhan, F.; Ma, X.; Wang, D.; Xu, W.; Wu, G.; Gao, G.F.; Tan, W. China novel coronavirus investigating and research team. A novel coronavirus from patients with pneumonia in China, 2019. N. Engl. J. Med., 2020, 382(8), 727-733.
[http://dx.doi.org/10.1056/NEJMoa2001017] [PMID: 31978945]
[5]
Lu, H. Drug treatment options for the 2019-new coronavirus (2019-nCoV). Biosci. Trends, 2020, 14(1), 69-71.
[http://dx.doi.org/10.5582/bst.2020.01020] [PMID: 31996494]
[6]
Wang, Z.; Chen, X.; Lu, Y.; Chen, F.; Zhang, W. Clinical characteristics and therapeutic procedure for four cases with 2019 novel coronavirus pneumonia receiving combined Chinese and Western medicine treatment. Biosci. Trends, 2020, 14(1), 64-68.
[http://dx.doi.org/10.5582/bst.2020.01030] [PMID: 32037389]
[7]
Holshue, M.L.; DeBolt, C.; Lindquist, S.; Lofy, K.H.; Wiesman, J.; Bruce, H.; Spitters, C.; Ericson, K.; Wilkerson, S.; Tural, A.; Diaz, G.; Cohn, A.; Fox, L.; Patel, A.; Gerber, S.I.; Kim, L.; Tong, S.; Lu, X.; Lindstrom, S.; Pallansch, M.A.; Weldon, W.C.; Biggs, H.M.; Uyeki, T.M.; Pillai, S.K. Washington State 2019-nCoV Case Investigation Team. First case of 2019 novel coronavirus in the United States. N. Engl. J. Med., 2020, 382(10), 929-936.
[http://dx.doi.org/10.1056/NEJMoa2001191] [PMID: 32004427]
[8]
Xu, Z.; Peng, C.; Shi, Y.; Zhu, Z.; Mu, K.; Wang, X.; Zhu, W. Nelfinavir was predicted to be a potential inhibitor of 2019-nCov main protease by an integrative approach combining homology modelling, molecular docking and binding free energy calculation. bioRxiv, 2020.
[9]
Song, J-M.; Lee, K-H.; Seong, B-L. Antiviral effect of catechins in green tea on influenza virus. Antiviral Res., 2005, 68(2), 66-74.
[http://dx.doi.org/10.1016/j.antiviral.2005.06.010] [PMID: 16137775]
[10]
Balde, A.; Pieters, L.; Gergely, A.; Kolodziej, H.; Claeys, M.; Vlietinck, A. A-type proanthocyanidins from stem-bark of Pavetta owariensis. Phytochemistry, 1991, 30(1), 337-342.
[http://dx.doi.org/10.1016/0031-9422(91)84150-Q]
[11]
Lou, H.; Yamazaki, Y.; Sasaki, T.; Uchida, M.; Tanaka, H.; Oka, S. A-type proanthocyanidins from peanut skins. Phytochemistry, 1999, 51(2), 297-308.
[http://dx.doi.org/10.1016/S0031-9422(98)00736-5]
[12]
Fukuhara, K.; Nakanishi, I.; Kansui, H.; Sugiyama, E.; Kimura, M.; Shimada, T.; Urano, S.; Yamaguchi, K.; Miyata, N. Enhanced radical-scavenging activity of a planar catechin analogue. J. Am. Chem. Soc., 2002, 124(21), 5952-5953.
[http://dx.doi.org/10.1021/ja0178259] [PMID: 12022823]
[13]
Steenkamp, J.A.; Ferreira, D. An unusual reaction of flavan-3-ols with acetone of relevance to the formation of the tetracyclic ring system in peltogynoids. Tetrahedron, 1990, 46(23), 7849-7854.
[http://dx.doi.org/10.1016/S0040-4020(01)90082-1]
[14]
Ngnokam, D.; Massiot, G.; Nuzillard, J-M.; Tsamo, E. (+)-7′, 7′-Dimethyl-5-hydroxy-2R, 3S-trans-pubeschin from Entandrophragma cylindricum. Phytochemistry, 1994, 37(2), 529-531.
[http://dx.doi.org/10.1016/0031-9422(94)85093-3]
[15]
Liu, X.; Zhang, B.; Jin, Z.; Yang, H.; Rao, Z. The Crytal Structure of 2019-NCoV Main Protease in Complex with an Inhibitor N3; RCSB Protein Data Bank, 2020.
[16]
Berman, H.M.; Battistuz, T.; Bhat, T.N.; Bluhm, W.F.; Bourne, P.E.; Burkhardt, K.; Feng, Z.; Gilliland, G.L.; Iype, L.; Jain, S.; Fagan, P.; Marvin, J.; Padilla, D.; Ravichandran, V.; Schneider, B.; Thanki, N.; Weissig, H.; Westbrook, J.D.; Zardecki, C. The Protein Data Bank. Acta Crystallogr. D Biol. Crystallogr., 2002, 58(Pt No 1), 899-907.
[http://dx.doi.org/10.1107/S0907444902003451] [PMID: 12037327]
[17]
O’Boyle, N.M.; Banck, M.; James, C.A.; Morley, C.; Vandermeersch, T.; Hutchison, G.R. Open Babel: An open chemical toolbox. J. Cheminform., 2011, 3(1), 33.
[http://dx.doi.org/10.1186/1758-2946-3-33] [PMID: 21982300]
[18]
Trott, O.; Olson, A.J. AutoDock Vina: improving the speed and accuracy of docking with a new scoring function, efficient optimization, and multithreading. J. Comput. Chem., 2010, 31(2), 455-461.
[PMID: 19499576]
[19]
Xu, J.; Zhao, S.; Teng, T.; Abdalla, A.E.; Zhu, W.; Xie, L.; Wang, Y.; Guo, X. Systematic comparison of two animal-to-human transmitted human coronaviruses: SARS-CoV-2 and SARS-CoV. Viruses, 2020, 12(2), 244.
[http://dx.doi.org/10.3390/v12020244] [PMID: 32098422]
[20]
Chang, K-O.; Kim, Y.; Lovell, S.; Rathnayake, A.D.; Groutas, W.C. Antiviral drug discovery: norovirus proteases and development of inhibitors. Viruses, 2019, 11(2), 197.
[http://dx.doi.org/10.3390/v11020197] [PMID: 30823509]
[21]
Li, J-Y.; You, Z.; Wang, Q.; Zhou, Z-J.; Qiu, Y.; Luo, R.; Ge, X-Y. The epidemic of 2019-novel-coronavirus (2019-nCoV) pneumonia and insights for emerging infectious diseases in the future. Microbes Infect., 2020, 22(2), 80-85.
[http://dx.doi.org/10.1016/j.micinf.2020.02.002] [PMID: 32087334]
[22]
Yamamoto, N.; Yang, R.; Yoshinaka, Y.; Amari, S.; Nakano, T.; Cinatl, J.; Rabenau, H.; Doerr, H.W.; Hunsmann, G.; Otaka, A.; Tamamura, H.; Fujii, N.; Yamamoto, N. HIV protease inhibitor nelfinavir inhibits replication of SARS-associated coronavirus. Biochem. Biophys. Res. Commun., 2004, 318(3), 719-725.
[http://dx.doi.org/10.1016/j.bbrc.2004.04.083] [PMID: 15144898]
[23]
Wiberg, K.B. Bent bonds in organic compounds. Acc. Chem. Res., 1996, 29(5), 229-234.
[http://dx.doi.org/10.1021/ar950207a]
[24]
Wang, H.; Wang, W.; Jin, W.J. σ-Hole bond vs π-hole bond: a comparison based on halogen bond. Chem. Rev., 2016, 116(9), 5072-5104.
[http://dx.doi.org/10.1021/acs.chemrev.5b00527] [PMID: 26886515]
[25]
Custelcean, R.; Jackson, J.E. Dihydrogen bonding: structures, energetics, and dynamics. Chem. Rev., 2001, 101(7), 1963-1980.
[http://dx.doi.org/10.1021/cr000021b] [PMID: 11710237]
[26]
Kaplan, I.G. Intermolecular interactions: physical picture, computational methods and model potentials; John Wiley & Sons, 2006.
[http://dx.doi.org/10.1002/047086334X]
[27]
Schottel, B.L.; Chifotides, H.T.; Dunbar, K.R. Anion-π interactions. Chem. Soc. Rev., 2008, 37(1), 68-83.
[http://dx.doi.org/10.1039/B614208G] [PMID: 18197334]
[28]
Alcock, N-W. Secondary bonding to nonmetallic elements.Advances in Inorganic Chemistry and Radiochemistry; Elsevier, 1972, Vol. 15, pp. 1-58.
[29]
Israelachvili, J. Intermolecular and Surface Forces, 2nd ed.; Academic press: London, 1991.
[30]
Lee, L-H. Fundamentals of adhesion; Springer Science & Business Media, 2013.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version351msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[04:05:48] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[04:05:48] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[04:05:48] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[04:05:48] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (124ms)time
  • Application (227ms)time
  • 1 x Application (64.6%)
    227ms
    1 x Booting (35.4%)
    124ms
    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 duplicated136ms
    • 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 ('51716822','',1,1740456348,1740456348) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740456348
      880μ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 ('51716822','/article/111709',1,1740456348,1740456348)
      200μ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 >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) 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 >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) 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 >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) 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 >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) 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 >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) 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 >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51716822 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51716822) limit 1
      11.33msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51716822
      • 1: 51716822
      • 2: 51716822
      • 3: 51716822
      • 4: 51716822
      • 5: 51716822
      • 6: 51716822
      • 7: 51716822
      • 8: 51716822
      • 9: 51716822
      • 10: 51716822
      • 11: 51716822
      • 12: 51716822
      • 13: 51716822
      • 14: 51716822
      • 15: 51716822
      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=111709
      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` = 8 limit 1
      700μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 8
      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=8) and sj.journal_id!=8 group by `j`.`nid`) as `aggregate_table`
      1.03msalphaeurekaselec_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=8) and sj.journal_id!=8 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      820μ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=8) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.11msalphaeurekaselec_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=8) 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.73msalphaeurekaselec_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` = '111709'
      1.57msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 111709
      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` = '111709'
      2.36msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 111709
      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` = '111709' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.39msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 111709
      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#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
      510μ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 = 8 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      44.83msalphaeurekaselec_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 = 8 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      25.57msalphaeurekaselec_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 = 8 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      11.37msalphaeurekaselec_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` = 111709 limit 1
      320μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 111709
      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 = 111709 and content_type = 'article' order by status desc limit 1
      380μ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 = 622 and cd.sub_disease_id = 623 and content_id!=111709 and cd.content_type = 'article' order by rand() limit 20
      7.15msalphaeurekaselec_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` = 188249 limit 1
      240μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 188249
      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
      250μ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` = 'CCHTS' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      330μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CCHTS
      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 = '111709' 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) )
      1.73msalphaeurekaselec_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 = '10876' 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) )
      310μ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 = '3115' 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 <= 51716822 and j.to_ip >=51716822 )) and ((j.from_date <= 1740456348 and j.to_date >= 1740456348 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3115) 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 <= 51716822 and j.to_ip >=51716822 )) and ((j.from_date <= 1740456348 and j.to_date >= 1740456348 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3115) 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 <= 51716822 and j.to_ip >=51716822 )) and ((j.from_date <= 1740456348 and j.to_date >= 1740456348 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3115)
      5.54msalphaeurekaselec_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 <= 51716822 and j.to_ip >=51716822 )) and ((j.from_date <= 1740456348 and j.to_date >= 1740456348 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10876) 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 <= 51716822 and j.to_ip >=51716822 )) and ((j.from_date <= 1740456348 and j.to_date >= 1740456348 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10876) 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 <= 51716822 and j.to_ip >=51716822 )) and ((j.from_date <= 1740456348 and j.to_date >= 1740456348 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10876)
      810μ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 <= 51716822 and j.to_ip >=51716822 )) and ((j.from_date <= 1740456348 and j.to_date >= 1740456348 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 111709) 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 <= 51716822 and j.to_ip >=51716822 )) and ((j.from_date <= 1740456348 and j.to_date >= 1740456348 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 111709) 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 <= 51716822 and j.to_ip >=51716822 )) and ((j.from_date <= 1740456348 and j.to_date >= 1740456348 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 111709)
      840μ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` < '197' and is_uploaded = 1 and issue_id = 10876 order by cast(first_page as SIGNED) desc limit 1
      620μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 197
      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` > '203' and is_uploaded = 1 and issue_id = 10876 order by cast(first_page as SIGNED) asc limit 1
      510μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 203
      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'
      290μ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
      300μ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` = 111709 limit 1
      3.88msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 111709
      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` = 8 and `b`.`banner_from_date` <= 1740456348 and `b`.`banner_to_date` >= 1740456348 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.81msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 8
      • 3: 1740456348
      • 4: 1740456348
      • 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` = 8 and `b`.`banner_from_date` <= 1740456348 and `b`.`banner_to_date` >= 1740456348 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.75msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 8
      • 3: 1740456348
      • 4: 1740456348
      • 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='6e1389ebe603443773ce3508bdfe5c39'
      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
        agx3vDxS9VIaITOMgqq8kMBv5Vb3AzKsT8ZGbAYX
        uc_cart_id
        6e1389ebe603443773ce3508bdfe5c39
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/111709" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/111709
        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=eyJpdiI6IjNpM3laa1M3cGhCRy9lNXNldXJjbkE9PSIsInZhbHVlIjoiZ0FZVmNFMXo0alBDSEVMdTNwaklVUTBUTGFEeHE4UWJmSWVMWE9WS2NUQT0iLCJtYWMiOiI0NWUwNjk5ZTY3MTdlNDEzYjk5NjIzM2ZiY2UzYjI4YTM1YzBiNzVkNzc3YmY2OTdmOTA4YzZmMjg1MzdkNWE3IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IjNpM3laa1M3cGhCRy9lNXNldXJjbkE9PSIsInZhbHVlIjoiZ0FZVmNFMXo0alBDSEVMdTNwaklVUTBUTGFEeHE4UWJmSWVMWE9WS2NUQT0iLCJtYWMiOiI0NWUwNjk5ZTY3MTdl" ] "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:05:48 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InVHd202YUhBTzVOTGwwYXpVNHQ2Q1E9PSIsInZhbHVlIjoiVTlWYUxPZW9mQ2VvTW1DUFBXd2xjdWtKTm1KSktNWUJsTjJ6K0c4Smx6V1k2TXB0TnVEWjBGUVhQLzN0OGcrTStHdXRSZFVScVdMYVZxSlh2UlhWLytUaW9URC8yamxQTWFyYmNIdTYyc0pRSGtJeUxKeGJQOWQwZStBeU9hbEMiLCJtYWMiOiJmZGFjZjQ5MTBlZDI3Yzk0MTBkMzlmNmRiYmJmOGFlOTYxNzI4N2JlOGRlMzZkOWZhODUwOWE4YmQ4NDI3OWFhIiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 16:05:48 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InVHd202YUhBTzVOTGwwYXpVNHQ2Q1E9PSIsInZhbHVlIjoiVTlWYUxPZW9mQ2VvTW1DUFBXd2xjdWtKTm1KSktNWUJsTjJ6K0c4Smx6V1k2TXB0TnVEWjBGUVhQLzN0OGcrTStHdXRSZ" 1 => "alphaeurekaselectnet_session=eyJpdiI6InBjOHRYOUV4L3kwbFl4MEJjRUpmMWc9PSIsInZhbHVlIjoiaVNLYTdZQmloU1BtaU5RL2tPS2JUdVM1c0gvZWd0cnEvejdrdnJmOFJQMVdGc0MxSTdiQjlQR1J5TGdiUndGTE5xY1c3SzVwcjMwTUJQR2hpQVNVSGtqYS9vYnh1L25wa0wrNXBNcXZoNUp2QS82b3k2cWZ1Y2FMT29NbGZxcE8iLCJtYWMiOiI3OWRlOWI2ZGUyNmQ3Mjg5NjJiZjU1MjExNGMwMWM3MTg2MmU5ODgxNmFlOGU5YTk3NmNiMThhZDllMWRhODRkIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6InBjOHRYOUV4L3kwbFl4MEJjRUpmMWc9PSIsInZhbHVlIjoiaVNLYTdZQmloU1BtaU5RL2tPS2JUdVM1c0gvZWd0cnEvejdrdnJmOFJQMVdGc0MxSTdiQjlQR1J" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InVHd202YUhBTzVOTGwwYXpVNHQ2Q1E9PSIsInZhbHVlIjoiVTlWYUxPZW9mQ2VvTW1DUFBXd2xjdWtKTm1KSktNWUJsTjJ6K0c4Smx6V1k2TXB0TnVEWjBGUVhQLzN0OGcrTStHdXRSZFVScVdMYVZxSlh2UlhWLytUaW9URC8yamxQTWFyYmNIdTYyc0pRSGtJeUxKeGJQOWQwZStBeU9hbEMiLCJtYWMiOiJmZGFjZjQ5MTBlZDI3Yzk0MTBkMzlmNmRiYmJmOGFlOTYxNzI4N2JlOGRlMzZkOWZhODUwOWE4YmQ4NDI3OWFhIiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 16:05:48 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InVHd202YUhBTzVOTGwwYXpVNHQ2Q1E9PSIsInZhbHVlIjoiVTlWYUxPZW9mQ2VvTW1DUFBXd2xjdWtKTm1KSktNWUJsTjJ6K0c4Smx6V1k2TXB0TnVEWjBGUVhQLzN0OGcrTStHdXRSZ" 1 => "alphaeurekaselectnet_session=eyJpdiI6InBjOHRYOUV4L3kwbFl4MEJjRUpmMWc9PSIsInZhbHVlIjoiaVNLYTdZQmloU1BtaU5RL2tPS2JUdVM1c0gvZWd0cnEvejdrdnJmOFJQMVdGc0MxSTdiQjlQR1J5TGdiUndGTE5xY1c3SzVwcjMwTUJQR2hpQVNVSGtqYS9vYnh1L25wa0wrNXBNcXZoNUp2QS82b3k2cWZ1Y2FMT29NbGZxcE8iLCJtYWMiOiI3OWRlOWI2ZGUyNmQ3Mjg5NjJiZjU1MjExNGMwMWM3MTg2MmU5ODgxNmFlOGU5YTk3NmNiMThhZDllMWRhODRkIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6InBjOHRYOUV4L3kwbFl4MEJjRUpmMWc9PSIsInZhbHVlIjoiaVNLYTdZQmloU1BtaU5RL2tPS2JUdVM1c0gvZWd0cnEvejdrdnJmOFJQMVdGc0MxSTdiQjlQR1J" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "agx3vDxS9VIaITOMgqq8kMBv5Vb3AzKsT8ZGbAYX" "uc_cart_id" => "6e1389ebe603443773ce3508bdfe5c39" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/111709" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 04:05:48GET/article/111709414371