Generic placeholder image

Current Drug Therapy

Editor-in-Chief

ISSN (Print): 1574-8855
ISSN (Online): 2212-3903

Review Article

Natural Product-derived Phytochemicals as Potential Inhibitors of Angiotensin Converting Enzyme 2 (ACE2): Promising Drug Candidates for COVID-19

Author(s): Aparna D. Palshetkar, Aarti U. Rasal, Aruna Murugan and Namita D. Desai*

Volume 19, Issue 1, 2024

Published on: 19 May, 2023

Page: [13 - 19] Pages: 7

DOI: 10.2174/1574885518666230502103159

Price: $65

Abstract

COVID-19 was deemed a global pandemic by the World Health Organization in February 2020. The prevalence of viral diseases worldwide has increased the importance of receiving immediate medical attention. There is currently no specific medication or vaccine under consideration to treat coronavirus infection. For reducing or preventing COVID-19 infections, a number of alternative therapies are anticipated, including the use of synthetic drugs, vaccines, interferon therapy etc. Due to the serious side effects of the utilized drug therapies, it is crucial to comprehend the pathogenesis of the coronavirus and explore safe and efficient treatment.

Considering the contribution of plants and herbs in the management of viruses like HIV, Herpes Simplex, MERS-CoV, and influenza, they can be further utilised for COVID-19 treatment. According to reports, SARS-CoV2 infects host cells through Angiotensin-converting enzyme 2 receptors, causing pneumonia linked to COVID-19 as well as acute myocardial injury and long-term cardiovascular damage. A cure for SARS-CoV2 may lie in understanding the receptor, its targets, and the mechanism of viral replication. This review article highlights several plants that have the potential to inhibit ACE2, including Punica granatum, Citrus aurantium, Allium sativum, Piper longum, Curcuma longa, and Coriandrum sativum as well as their extracts and phytoconstituents, such as flavonoids, alkaloids, anthraquinone glycosides, phenolic acids, and others. This review will provide opportunities for researchers to explore the possibility of developing promising dosage forms that will increase the bioavailability and in vivo effectiveness of the lead candidates.

Graphical Abstract

[1]
Pal M, Berhanu G, Desalegn C, Kandi V. Severe Acute Respiratory Syndrome Coronavirus-2 (SARS-CoV-2): An update. Cureus 2020; 12(3): e7423.
[http://dx.doi.org/10.7759/cureus.7423] [PMID: 32337143]
[2]
Singhal T. A review of coronavirus disease-2019 (COVID-19). Indian J Pediatr 2020; 87(4): 281-6.
[http://dx.doi.org/10.1007/s12098-020-03263-6] [PMID: 32166607]
[3]
Khuroo MS, Sofi AA, Khuroo M. Chloroquine and hydroxychloroquine in coronavirus disease 2019 (COVID-19). Facts, fiction and the hype: A critical appraisal. Int J Antimicrob Agents 2020; 56(3): 106101.
[http://dx.doi.org/10.1016/j.ijantimicag.2020.106101] [PMID: 32687949]
[4]
Qomara WF, Primanissa DN, Amalia SH, Purwadi FV, Zakiyah N. Effectiveness of remdesivir, lopinavir/ritonavir, and favipiravir for COVID-19 treatment: A systematic review. Int J Gen Med 2021; 14: 8557-71.
[http://dx.doi.org/10.2147/IJGM.S332458] [PMID: 34849001]
[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]
Ganjhu RK, Mudgal PP, Maity H, et al. Herbal plants and plant preparations as remedial approach for viral diseases. Virusdisease 2015; 26(4): 225-36.
[http://dx.doi.org/10.1007/s13337-015-0276-6] [PMID: 26645032]
[7]
Fehr AR, Perlman S. Coronaviruses: An overview of their replication and pathogenesis. Methods Mol Biol 2015; 1282: 1-23.
[http://dx.doi.org/10.1007/978-1-4939-2438-7_1] [PMID: 25720466]
[8]
Siu YL, Teoh KT, Lo J, et al. The M, E, and N structural proteins of the severe acute respiratory syndrome coronavirus are required for efficient assembly, trafficking, and release of virus-like particles. J Virol 2008; 82(22): 11318-30.
[http://dx.doi.org/10.1128/JVI.01052-08] [PMID: 18753196]
[9]
Tang T, Bidon M, Jaimes JA, Whittaker GR, Daniel S. Coronavirus membrane fusion mechanism offers a potential target for antiviral development. Antiviral Res 2020; 178: 104792.
[http://dx.doi.org/10.1016/j.antiviral.2020.104792] [PMID: 32272173]
[10]
Shang J, Ye G, Shi K, et al. Structural basis of receptor recognition by SARS-CoV-2. Nature 2020; 581(7807): 221-4.
[http://dx.doi.org/10.1038/s41586-020-2179-y] [PMID: 32225175]
[11]
Ni W, Yang X, Yang D, et al. Role of angiotensin-converting enzyme 2 (ACE2) in COVID-19. Crit Care 2020; 24(1): 422.
[http://dx.doi.org/10.1186/s13054-020-03120-0] [PMID: 32660650]
[12]
Bourgonje AR, Abdulle AE, Timens W, et al. Angiotensi CoV 2 and the pathophysiology of coronavirus disease 2019 (COVID 19). J Pathol 2020; 251(3): 228-48.
[http://dx.doi.org/10.1002/path.5471] [PMID: 32418199]
[13]
Duan L, Zheng Q, Zhang H, Niu Y, Lou Y, Wang H. The SARS-CoV-2 spike glycoprotein biosynthesis, structure, function, and antigenicity: Implications for the design of spike-based vaccine immunogens. Front Immunol 2020; 11: 576622.
[http://dx.doi.org/10.3389/fimmu.2020.576622] [PMID: 33117378]
[14]
Burrell LM, Johnston CI, Tikellis C, Cooper ME. ACE2, a new regulator of the renin–angiotensin system. Trends Endocrinol Metab 2004; 15(4): 166-9.
[http://dx.doi.org/10.1016/j.tem.2004.03.001] [PMID: 15109615]
[15]
Barbosa-Filho JM, Martins VKM, Rabelo LA, et al. Natural products inhibitors of the angiotensin converting enzyme (ACE): A review between 1980 - 2000. Rev Bras Farmacogn 2006; 16(3): 421-46.
[http://dx.doi.org/10.1590/S0102-695X2006000300021]
[16]
Antonio AS, Wiedemann LSM, Veiga-Junior VF. Natural products’ role against COVID-19. RSC Advances 2020; 10(39): 23379-93.
[http://dx.doi.org/10.1039/D0RA03774E] [PMID: 35693131]
[17]
Guerrero L, Castillo J, Quiñones M, et al. Inhibition of angiotensin-converting enzyme activity by flavonoids: structure-activity relationship studies. PLoS One 2012; 7(11): e49493.
[http://dx.doi.org/10.1371/journal.pone.0049493] [PMID: 23185345]
[18]
Pande M, Kundu D, Srivastava R. Drugs repurposing against SARS-CoV2 and the new variant B.1.1.7 (alpha strain) targeting the spike protein: molecular docking and simulation studies. Heliyon 2021; 7(8): e07803.
[http://dx.doi.org/10.1016/j.heliyon.2021.e07803] [PMID: 34423145]
[19]
Xu J, Gao L, Liang H, Chen S. In silico screening of potential anti–COVID-19 bioactive natural constituents from food sources by molecular docking. Nutrition 2021; 82: 111049.
[http://dx.doi.org/10.1016/j.nut.2020.111049] [PMID: 33290972]
[20]
Panche AN, Diwan AD, Chandra SR. Flavonoids: An overview. J Nutr Sci 2016; 5(e47): e47.
[http://dx.doi.org/10.1017/jns.2016.41] [PMID: 28620474]
[21]
Siegel AB, Stebbing J. Milk thistle: Early seeds of potential. Lancet Oncol 2013; 14(10): 929-30.
[http://dx.doi.org/10.1016/S1470-2045(13)70414-5] [PMID: 23993379]
[22]
Tungmunnithum D, Thongboonyou A, Pholboon A, Yangsabai A. Flavonoids and other phenolic compounds from medicinal plants for pharmaceutical and medical aspects: An overview. Medicines 2018; 5(3): 93.
[http://dx.doi.org/10.3390/medicines5030093] [PMID: 30149600]
[23]
Godinho PIC, Soengas RG, Silva VLM. Therapeutic potential of glycosyl flavonoids as anti-coronaviral agents. Pharmaceuticals 2021; 14(6): 546.
[http://dx.doi.org/10.3390/ph14060546] [PMID: 34200456]
[24]
Dirks ML, Seale JT, Collins JM, McDougal OM. Review: Veratrum californicum Alkaloids. Molecules 2021; 26(19): 5934.
[http://dx.doi.org/10.3390/molecules26195934] [PMID: 34641477]
[25]
Rahman Md. In silico investigation and potential therapeutic approaches of natural products for COVID-19: Computer-aided drug design perspective. Front Cell Infect Microbiol 2022; 12: 929430.
[http://dx.doi.org/10.3389/fcimb.2022.929430]
[26]
Ho T, Wu S, Chen J, Li C, Hsiang C. Emodin blocks the SARS coronavirus spike protein and angiotensin-converting enzyme 2 interaction. Antiviral Res 2007; 74(2): 92-101.
[http://dx.doi.org/10.1016/j.antiviral.2006.04.014] [PMID: 16730806]
[27]
Jamal QMS. Antiviral potential of plants against COVID-19 during outbreaks—An update. Int J Mol Sci 2022; 23(21): 13564.
[http://dx.doi.org/10.3390/ijms232113564] [PMID: 36362351]
[28]
Paudel P, Shrestha S, Park SE, et al. Emodin derivatives as multi-target-directed ligands inhibiting monoamine oxidase and antagonizing vasopressin V 1A receptors. ACS Omega 2020; 5(41): 26720-31.
[http://dx.doi.org/10.1021/acsomega.0c03649] [PMID: 33110998]
[29]
Deng YF, Aluko RE, Jin Q, Zhang Y, Yuan LJ. Inhibitory activities of baicalin against renin and angiotensin-converting enzyme. Pharm Biol 2012; 50(4): 401-6.
[http://dx.doi.org/10.3109/13880209.2011.608076] [PMID: 22136493]
[30]
Nong NTP, Sutopo CCY, Hung WT, Wu PH, Hsu JL. The molecular docking and inhibition kinetics of angiotensin I-converting enzyme inhibitory peptides derived from soft-shelled turtle yolk. Appl Sci 2022; 12(23): 12340.
[http://dx.doi.org/10.3390/app122312340]
[31]
Khamto N, Utama K, Tateing S, et al. Discovery of natural bisbenzylisoquinoline analogs from the library of Thai traditional plants as SARS-CoV-2 3CLPro inhibitors: In silico molecular docking, molecular dynamics, and in vitro enzymatic activity. J Chem Inf Model 2023.
[http://dx.doi.org/10.1021/acs.jcim.2c01309]
[32]
Yang Y, Islam MS, Wang J, Li Y, Chen X. Traditional Chinese medicine in the treatment of patients infected with 2019-new coronavirus (SARS-CoV-2): A review and perspective. Int J Biol Sci 2020; 16(10): 1708-17.
[http://dx.doi.org/10.7150/ijbs.45538] [PMID: 32226288]
[33]
Liskova A, Samec M, Koklesova L, et al. Flavonoids against the SARS-CoV-2 induced inflammatory storm. Biomed Pharmacother 2021; 138: 111430.
[http://dx.doi.org/10.1016/j.biopha.2021.111430] [PMID: 33662680]
[34]
Vimalanathan S, Ignacimuthu S, Hudson JB. Medicinal plants of Tamil Nadu (Southern India) are a rich source of antiviral activities. Pharm Biol 2009; 47(5): 422-9.
[http://dx.doi.org/10.1080/13880200902800196]
[35]
Mukherjee PK, Maity N, Nema NK, Sarkar BK. Standardized Clitoria ternatea leaf extract as hyaluronidase, elastase and matrix-metalloproteinase-1 inhibitor. Indian J Pharmacol 2012; 44(5): 584-7.
[http://dx.doi.org/10.4103/0253-7613.100381] [PMID: 23112418]
[36]
Vellingiri B, Jayaramayya K, Iyer M, et al. COVID-19: A promising cure for the global panic. Sci Total Environ 2020; 725: 138277.
[http://dx.doi.org/10.1016/j.scitotenv.2020.138277] [PMID: 32278175]
[37]
Jough SS, Saini RK, Parveen A. A Comprehensive Study on Anti-hypertensive properties of Punica granatum (Pomegranate), Cynara scolymus (Artichoke), Coscinium fenestratum (Yellow vine) in Phytopharmacological, Molecular Biology Researches. Asian J Res Pharm Sci 2021; 11(2): 126-32.
[http://dx.doi.org/10.52711/2231-5659.2021-11-2-6]
[38]
Hussain F, Jahan N, Rahman K, Sultana B, Jamil S. Identification of hypotensive biofunctional compounds of Coriandrum sativum and evaluation of their angiotensin-converting enzyme (ACE) inhibition potential. Oxid Med Cell Longev 2018; 2018: 1-11.
[http://dx.doi.org/10.1155/2018/4643736] [PMID: 30581531]
[39]
Khan MY, Kumar V. Mechanism & inhibition kinetics of bioassay-guided fractions of Indian medicinal plants and foods as ACE inhibitors. J Tradit Complement Med 2019; 9(1): 73-84.
[http://dx.doi.org/10.1016/j.jtcme.2018.02.001] [PMID: 30671369]
[40]
He L, Qi Y, Rong X, et al. The Ayurvedic Medicine Salacia oblonga Attenuates Diabetic Renal Fibrosis in Rats: Suppression of Angiotensin II/AT1 Signaling. Evid Based Complement Alternat Med 2011; 2011: nep095.
[http://dx.doi.org/10.1093/ecam/nep095] [PMID: 19706694]
[41]
AYUSH Ministry of Health Corona Advisory – D.O. No. S. 16030/18/2019 – NAM.. 2020.
[42]
Joshi T, Joshi T, Sharma P, et al. In silico screening of natural compounds against COVID-19 by targeting Mpro and ACE2 using molecular docking. Eur Rev Med Pharmacol Sci 2020; 24(8): 4529-36.
[http://dx.doi.org/10.26355/eurrev_202004_21036] [PMID: 32373991]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version337msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[23:35:37] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[23:35:37] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[23:35:37] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[23:35:37] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (139ms)time
  • Application (198ms)time
  • 1 x Application (58.78%)
    198ms
    1 x Booting (41.22%)
    139ms
    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
    36 statements were executed, 4 of which were duplicates, 32 unique. Show only duplicated105ms
    • 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 ('873368187','',1,1740526537,1740526537) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740526537
      1.22msalphaeurekaselec_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 ('873368187','/article/131368',1,1740526537,1740526537)
      230μ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 >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) 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 >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) 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 >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) 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 >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) 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 >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) 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 >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 873368187 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873368187) limit 1
      18.26msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 873368187
      • 1: 873368187
      • 2: 873368187
      • 3: 873368187
      • 4: 873368187
      • 5: 873368187
      • 6: 873368187
      • 7: 873368187
      • 8: 873368187
      • 9: 873368187
      • 10: 873368187
      • 11: 873368187
      • 12: 873368187
      • 13: 873368187
      • 14: 873368187
      • 15: 873368187
      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=131368
      960μ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` = 14 limit 1
      2.34msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 14
      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=14) and sj.journal_id!=14 group by `j`.`nid`) as `aggregate_table`
      1.39msalphaeurekaselec_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=14) and sj.journal_id!=14 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.12msalphaeurekaselec_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=14) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.36msalphaeurekaselec_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=14) 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.26msalphaeurekaselec_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` = '131368'
      240μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 131368
      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` = '131368'
      2.4msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 131368
      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` = '131368' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.7msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 131368
      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
      220μ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
      430μ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 = 14 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      27.77msalphaeurekaselec_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 = 14 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      6.46msalphaeurekaselec_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 = 14 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      4.35msalphaeurekaselec_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` = 131368 limit 1
      230μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 131368
      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 = 131368 and content_type = 'article' order by status desc limit 1
      290μ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 * from `node_meta` where `nid` = 216407 limit 1
      270μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 216407
      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
      280μ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` = 'CDTH' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      310μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CDTH
      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 = '131368' 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) )
      460μ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 = '12730' 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) )
      400μ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 = '3451' 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) )
      370μ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 <= 873368187 and j.to_ip >=873368187 )) and ((j.from_date <= 1740526537 and j.to_date >= 1740526537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3451) 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 <= 873368187 and j.to_ip >=873368187 )) and ((j.from_date <= 1740526537 and j.to_date >= 1740526537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3451) 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 <= 873368187 and j.to_ip >=873368187 )) and ((j.from_date <= 1740526537 and j.to_date >= 1740526537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3451)
      23.93msalphaeurekaselec_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 <= 873368187 and j.to_ip >=873368187 )) and ((j.from_date <= 1740526537 and j.to_date >= 1740526537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12730) 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 <= 873368187 and j.to_ip >=873368187 )) and ((j.from_date <= 1740526537 and j.to_date >= 1740526537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12730) 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 <= 873368187 and j.to_ip >=873368187 )) and ((j.from_date <= 1740526537 and j.to_date >= 1740526537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12730)
      630μ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 <= 873368187 and j.to_ip >=873368187 )) and ((j.from_date <= 1740526537 and j.to_date >= 1740526537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 131368) 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 <= 873368187 and j.to_ip >=873368187 )) and ((j.from_date <= 1740526537 and j.to_date >= 1740526537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 131368) 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 <= 873368187 and j.to_ip >=873368187 )) and ((j.from_date <= 1740526537 and j.to_date >= 1740526537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 131368)
      600μ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` < '13' and is_uploaded = 1 and issue_id = 12730 order by cast(first_page as SIGNED) desc limit 1
      510μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 13
      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` > '19' and is_uploaded = 1 and issue_id = 12730 order by cast(first_page as SIGNED) asc limit 1
      430μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 19
      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'
      170μ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
      190μ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` = 131368 limit 1
      2.31msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 131368
      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` = 14 and `b`.`banner_from_date` <= 1740526537 and `b`.`banner_to_date` >= 1740526537 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.08msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 14
      • 3: 1740526537
      • 4: 1740526537
      • 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` = 14 and `b`.`banner_from_date` <= 1740526537 and `b`.`banner_to_date` >= 1740526537 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.08msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 14
      • 3: 1740526537
      • 4: 1740526537
      • 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='537d8e8ffb913835f6481819db3cc416'
      180μ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
        fbfhNclvARbWTl41uA8IQ9NJB27kDU5vsWgg7Xzv
        uc_cart_id
        537d8e8ffb913835f6481819db3cc416
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/article/131368" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/131368
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:17 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6IlNEN2N1OGxQWFVTN0lsVjd6RnpWU3c9PSIsInZhbHVlIjoiYm9oK0VsTGhvUS9GOFlIT1lpWUtHd2drbDlSaVI2dExIRy9KSkhqSVVZTT0iLCJtYWMiOiJmNWM0MGFiOGU5YWU5NDRmNTE1OGU3NDAxNjBmMDhiMzA4MDU0YzZjYjViMmQ2MDY0ODE0Mzk4NjU1YjZlMGJjIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IlNEN2N1OGxQWFVTN0lsVjd6RnpWU3c9PSIsInZhbHVlIjoiYm9oK0VsTGhvUS9GOFlIT1lpWUtHd2drbDlSaVI2dExIRy9KSkhqSVVZTT0iLCJtYWMiOiJmNWM0MGFiOGU5YWU5" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_cookies
        0 of 0
        array: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 23:35:37 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InpCYVByQ212SDg5QWJ5VGxsbjFUTkE9PSIsInZhbHVlIjoibFl2aVA5YWJyaVpjTUNtelhUMmk4WjBqNFBWa0V2ZEFnTG9yanBvc3YzLzB2TVBpQjNKVktZZThONG4zZUNRRGtHcDIyNDRsTnk5UzlrRzhUSFpGZnFDSFByQis2cGR4TXJvQWk3WnhkK0U0MXVCcVA5TE1BZm1JcndNcUpEZUoiLCJtYWMiOiI5YTA0NTE2ZmFmZTJhM2RlMTBhNTY3MzBiMTZlYmRkNmVjZTE1ZWQwMTQ2YTZlNWU1YjM4MzU3ODVhZWMyZjI4IiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 11:35:37 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InpCYVByQ212SDg5QWJ5VGxsbjFUTkE9PSIsInZhbHVlIjoibFl2aVA5YWJyaVpjTUNtelhUMmk4WjBqNFBWa0V2ZEFnTG9yanBvc3YzLzB2TVBpQjNKVktZZThONG4zZUNRRGtHcDIyN" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkFScFBqdnk5QWdWMzlVODNUY2J0eWc9PSIsInZhbHVlIjoiZDZ6a1BNOEdXRkVXUWRGbTAvNy9NVjQyMHZSWDdlb3FTcWczWG9HcytoU1FNRmFqdTZvZkwyMGdrS2cwM2tMQzFDKzZIVVpORFhQSkFEREpwZCsyUldsdXljZmZWNDVFaFFRRjluRzJqNDVtRWR0UUhwQUI0Y1lZeForZmE0K3UiLCJtYWMiOiJiYjlhNWZmNDY5NmIzOWIyMTA4ZmUxZGUwMThmZTc1ZjYzNjZjZWViYjAwMWFkNjA3MTU5MTNmOTE5MDdhMjU2IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkFScFBqdnk5QWdWMzlVODNUY2J0eWc9PSIsInZhbHVlIjoiZDZ6a1BNOEdXRkVXUWRGbTAvNy9NVjQyMHZSWDdlb3FTcWczWG9HcytoU1FNRmFqdTZvZkwyMGd" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InpCYVByQ212SDg5QWJ5VGxsbjFUTkE9PSIsInZhbHVlIjoibFl2aVA5YWJyaVpjTUNtelhUMmk4WjBqNFBWa0V2ZEFnTG9yanBvc3YzLzB2TVBpQjNKVktZZThONG4zZUNRRGtHcDIyNDRsTnk5UzlrRzhUSFpGZnFDSFByQis2cGR4TXJvQWk3WnhkK0U0MXVCcVA5TE1BZm1JcndNcUpEZUoiLCJtYWMiOiI5YTA0NTE2ZmFmZTJhM2RlMTBhNTY3MzBiMTZlYmRkNmVjZTE1ZWQwMTQ2YTZlNWU1YjM4MzU3ODVhZWMyZjI4IiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 11:35:37 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InpCYVByQ212SDg5QWJ5VGxsbjFUTkE9PSIsInZhbHVlIjoibFl2aVA5YWJyaVpjTUNtelhUMmk4WjBqNFBWa0V2ZEFnTG9yanBvc3YzLzB2TVBpQjNKVktZZThONG4zZUNRRGtHcDIyN" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkFScFBqdnk5QWdWMzlVODNUY2J0eWc9PSIsInZhbHVlIjoiZDZ6a1BNOEdXRkVXUWRGbTAvNy9NVjQyMHZSWDdlb3FTcWczWG9HcytoU1FNRmFqdTZvZkwyMGdrS2cwM2tMQzFDKzZIVVpORFhQSkFEREpwZCsyUldsdXljZmZWNDVFaFFRRjluRzJqNDVtRWR0UUhwQUI0Y1lZeForZmE0K3UiLCJtYWMiOiJiYjlhNWZmNDY5NmIzOWIyMTA4ZmUxZGUwMThmZTc1ZjYzNjZjZWViYjAwMWFkNjA3MTU5MTNmOTE5MDdhMjU2IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkFScFBqdnk5QWdWMzlVODNUY2J0eWc9PSIsInZhbHVlIjoiZDZ6a1BNOEdXRkVXUWRGbTAvNy9NVjQyMHZSWDdlb3FTcWczWG9HcytoU1FNRmFqdTZvZkwyMGd" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "fbfhNclvARbWTl41uA8IQ9NJB27kDU5vsWgg7Xzv" "uc_cart_id" => "537d8e8ffb913835f6481819db3cc416" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/article/131368" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 23:35:37GET/article/131368414361