Generic placeholder image

Current Pharmaceutical Design

Editor-in-Chief

ISSN (Print): 1381-6128
ISSN (Online): 1873-4286

Review Article

The Emergence of Human Pathogenic Coronaviruses: Lectins as Antivirals for SARS-CoV-2

Author(s): Sayed S. Sohrab*, Mohd. Suhail, Mohammad A. Kamal, Fahim Ahmad and Esam I. Azhar

Volume 26, Issue 41, 2020

Page: [5286 - 5292] Pages: 7

DOI: 10.2174/1381612826666200821120409

Price: $65

Abstract

Background: Human coronaviruses (HCoV) are common viruses and known to be associated with respiratory diseases, including pneumonia. Currently, seven human coronaviruses have been identified and known to cause upper and lower respiratory infections as well as nosocomial viral infections in humans. The bats, palm civets, and camels are identified as the reservoir of human coronaviruses. In 2002-2003, the emergence of SARS-CoV resulted in an outbreak and led towards the more awareness and importance of scientific research and medical urgency.

Methods: The recently identified SARS-CoV-2 was identified from the seafood market of the city Wuhan, China, in December 2019 and caused a global pandemic. This virus has now spread to more than 213 countries. This is the third highly pathogenic human coronavirus after SARS and MERS-CoV. The coronaviruses have RNA as genetic material and are known to have frequent recombination and mutations in their genome, which lead to the emergence and re-emergence of new virus strains and isolates with novel properties and extended hosts. The genetic mutations and suitable environmental conditions result in the emergence and re-emergence of pathogenic coronaviruses and cause a serious issue to human health and the economy globally. Lectins are the ubiquitous group of proteins that bind to glycosylated molecules.

Conclusion: The plant lectins are known to have significant antiviral activities against coronaviruses. Additionally, the plant lectins can be used as potential therapeutics against bacteria, fungus, yeast, and protozoa. In this review, we have discussed the current status of human pathogenic coronavirus emergence and the use of plant lectins as antivirals against SARS-CoV-2.

Keywords: Emergence, coronaviruses, SARS-CoV-2, natural products, antivirals, lectins, inhibitors.

[1]
Lai MM, Cavanagh D. The molecular biology of coronaviruses. Adv Virus Res 1997; 48: 1-100.
[http://dx.doi.org/10.1016/S0065-3527(08)60286-9] [PMID: 9233431]
[2]
Cheng VCC, Lau SKP, Woo PCY, Yuen KY. Severe acute respiratory syndrome coronavirus as an agent of emerging and reemerging infection. Clin Microbiol Rev 2007; 20(4): 660-94.
[http://dx.doi.org/10.1128/CMR.00023-07] [PMID: 17934078]
[3]
Zhou P, Yang X-L, Wang X-G, et al. A pneumonia outbreak associated with a new coronavirus of probable bat origin. Nature 2020; 579(7798): 270-3.
[http://dx.doi.org/10.1038/s41586-020-2012-7] [PMID: 32015507]
[4]
WHO. Coronavirus disease 2019 (COVID-19) Situation Report -59. 2019. Available at: https://www.who.int/docs/default-source/coronaviruse/situation-reports/20200319-sitrep-59-covid-19.pdf? sfvrsn=c3dcdef9_2
[5]
Worldometer.. Available at: https://www.worldometers.info/coronavirus/
[6]
Leibowitz JL. Coronaviruses: Molecular and Cellular Biology. Emerg Infect Dis 2008; 14(4): 693-4.
[http://dx.doi.org/10.3201/eid1404.080016]
[7]
Cui J, Li F, Shi Z-L. Origin and evolution of pathogenic coronaviruses. Nat Rev Microbiol 2019; 17(3): 181-92.
[http://dx.doi.org/10.1038/s41579-018-0118-9] [PMID: 30531947]
[8]
Mitchell CA, Ramessar K, O’Keefe BR. Antiviral lectins: Selective inhibitors of viral entry. Antiviral Res 2017; 142: 37-54.
[http://dx.doi.org/10.1016/j.antiviral.2017.03.007] [PMID: 28322922]
[9]
Lusvarghi S, Bewley CA. Griffithsin: An Antiviral Lectin with Outstanding Therapeutic Potential. Viruses 2016; 8(10)E296
[http://dx.doi.org/10.3390/v8100296] [PMID: 27783038]
[10]
Woodrum BW, Maxwell J, Allen DM, et al. A Designed “Nested” Dimer of Cyanovirin-N Increases Antiviral Activity. Viruses 2016; 8(6)E158
[http://dx.doi.org/10.3390/v8060158] [PMID: 27275831]
[11]
Millet JK, Séron K, Labitt RN, et al. Middle East respiratory syndrome coronavirus infection is inhibited by griffithsin. Antiviral Res 2016; 133: 1-8.
[http://dx.doi.org/10.1016/j.antiviral.2016.07.011] [PMID: 27424494]
[12]
Mazalovska M, Kouokam JC. Lectins as Promising Therapeutics for the Prevention and Treatment of HIV and Other Potential Coinfections. BioMed Res Int 2018.20183750646
[http://dx.doi.org/10.1155/2018/3750646] [PMID: 29854749]
[13]
Li L, Yu X, Zhang H, et al. In vitro antiviral activity of Griffithsin against porcine epidemic diarrhea virus. Virus Genes 2019; 55(2): 174-81.
[http://dx.doi.org/10.1007/s11262-019-01633-7] [PMID: 30637608]
[14]
Covés-Datson EM, Dyall J, DeWald LE, et al. Inhibition of Ebola Virus by a Molecularly Engineered Banana Lectin. PLoS Negl Trop Dis 2019; 13(7)e0007595
[http://dx.doi.org/10.1371/journal.pntd.0007595] [PMID: 31356611]
[15]
Mani JS, Johnson JB, Steel JC, et al. Natural product-derived phytochemicals as potential agents against coronaviruses: A review. Virus Res 2020.284197989
[http://dx.doi.org/10.1016/j.virusres.2020.197989] [PMID: 32360300]
[16]
Boyd WC, Shapleigh E. Specific Precipitating Activity of Plant Agglutinins (Lectins). Science 1954; 119(3091): 419.
[http://dx.doi.org/10.1126/science.119.3091.419] [PMID: 17842730]
[17]
Santos AF, Da Silva MD, Napoleão TH, Paiva PM, Correia MD, Coelho LC. Lectins: Function, structure, biological properties andpotential applications
[18]
Aranda-Souza MA, Rossato FA. A lectin from Bothrops leucurus snake venom raises cytosolic calcium levels and promotes B16-F10 melanoma necrotic cell death via mitochondrial permeability transition Web of Science 2014.
[19]
Wallis R. Interactions between mannose-binding lectin and MASPs during complement activation by the lectin pathway. Immunobiology 2007; 212(4-5): 289-99.
[http://dx.doi.org/10.1016/j.imbio.2006.11.004] [PMID: 17544814]
[20]
Krupovic M, Cvirkaite-Krupovic V, Bamford DH. Protein A33 responsible for antibody-resistant spread of Vaccinia virus is homologous to C-type lectin-like proteins. Virus Res 2010; 151(1): 97-101.
[http://dx.doi.org/10.1016/j.virusres.2010.03.004] [PMID: 20302896]
[21]
Francis F, Jaber K, Colinet F, Portetelle D, Haubruge E. Purification of a new fungal mannose-specific lectin from Penicillium chrysogenum and its aphicidal properties. Fungal Biol 2011; 115(11): 1093-9.
[http://dx.doi.org/10.1016/j.funbio.2011.06.010] [PMID: 22036288]
[22]
Wong ACP, Li X, Lau SKP, Woo PCY. Global Epidemiology of Bat Coronaviruses. Viruses 2019; 11(2)E174
[http://dx.doi.org/10.3390/v11020174] [PMID: 30791586]
[23]
Ge X-Y, Li J-L, Yang X-L, et al. Isolation and characterization of a bat SARS-like coronavirus that uses the ACE2 receptor. Nature 2013; 503(7477): 535-8.
[http://dx.doi.org/10.1038/nature12711] [PMID: 24172901]
[24]
Lau SKP, Woo PCY, Yip CCY, et al. Coronavirus HKU1 and other coronavirus infections in Hong Kong. J Clin Microbiol 2006; 44(6): 2063-71.
[http://dx.doi.org/10.1128/JCM.02614-05] [PMID: 16757599]
[25]
Vabret A, Dina J, Gouarin S, Petitjean J, Corbet S, Freymuth F. Detection of the new human coronavirus HKU1: a report of 6 cases. Clin Infect Dis 2006; 42(5): 634-9.
[http://dx.doi.org/10.1086/500136] [PMID: 16447108]
[26]
Lim YX, Ng YL, Tam JP, Liu DX. Human Coronaviruses: A Review of Virus-Host Interactions. Diseases 2016; 4(3)E26
[http://dx.doi.org/10.3390/diseases4030026] [PMID: 28933406]
[27]
Abdul-Rasool S, Fielding BC. Understanding Human Coronavirus HCoV-NL63. Open Virol J 2010; 4: 76-84.
[http://dx.doi.org/10.2174/1874357901004010076] [PMID: 20700397]
[28]
van der Hoek L, Pyrc K, Jebbink MF, et al. Identification of a new human coronavirus. Nat Med 2004; 10(4): 368-73.
[http://dx.doi.org/10.1038/nm1024] [PMID: 15034574]
[29]
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]
[30]
Corman VM, Muth D, Niemeyer D, Drosten C. Hosts and Sources of Endemic Human Coronaviruses. Adv Virus Res 2018; 100: 163-88.
[http://dx.doi.org/10.1016/bs.aivir.2018.01.001] [PMID: 29551135]
[31]
Sabir JSM, Lam TTY, Ahmed MMM, et al. Co-circulation of three camel coronavirus species and recombination of MERS-CoVs in Saudi Arabia. Science 2016; 351(6268): 81-4.
[http://dx.doi.org/10.1126/science.aac8608] [PMID: 26678874]
[32]
Zaki AM, van Boheemen S, Bestebroer TM, Osterhaus ADME, Fouchier RAM. Isolation of a novel coronavirus from a man with pneumonia in Saudi Arabia. N Engl J Med 2012; 367(19): 1814-20.
[http://dx.doi.org/10.1056/NEJMoa1211721] [PMID: 23075143]
[33]
Azhar EI, Hashem AM, El-Kafrawy SA, et al. Detection of the Middle East respiratory syndrome coronavirus genome in an air sample originating from a camel barn owned by an infected patient. MBio 2014; 5(4): e01450-14.
[http://dx.doi.org/10.1128/mBio.01450-14] [PMID: 25053787]
[34]
Lam TT-Y, Jia N, Zhang Y-W, et al. Identifying SARS-CoV-2-related coronaviruses in Malayan pangolins. Nature 2020; 583(7815): 282-5.
[http://dx.doi.org/10.1038/s41586-020-2169-0] [PMID: 32218527]
[35]
Xu X, Chen P, Wang J, et al. Evolution of the novel coronavirus from the ongoing Wuhan outbreak and modeling of its spike protein for risk of human transmission. Sci China Life Sci 2020; 63(3): 457-60.
[http://dx.doi.org/10.1007/s11427-020-1637-5] [PMID: 32009228]
[36]
Kan B, Wang M, Jing H, et al. Molecular evolution analysis and geographic investigation of severe acute respiratory syndrome coronavirus-like virus in palm civets at an animal market and on farms. J Virol 2005; 79(18): 11892-900.
[http://dx.doi.org/10.1128/JVI.79.18.11892-11900.2005] [PMID: 16140765]
[37]
Che XY, Di B, Zhao GP, et al. A patient with asymptomatic severe acute respiratory syndrome (SARS) and antigenemia from the 2003-2004 community outbreak of SARS in Guangzhou, China. Clin Infect Dis 2006; 43(1): e1-5.
[http://dx.doi.org/10.1086/504943] [PMID: 16758408]
[38]
Pm dS, Mc dM, Fs G, D dST, Ap SdO, Gsv dM, et al. PgTeL, the lectin found in Punica granatum juice, is an antifungal agent against Candida albicans and Candida krusei International journal of biological macromolecules 2018.
[39]
Ramos EL, Santana SS, Silva MV, Santiago FM, Mineo TW, Mineo JR. Leandro Peixoto Ferreira de Souza. Lectins from Synadenium carinatum (ScLL) and Artocarpus heterophyllus (ArtinM) Are Able to Induce Beneficial Immunomodulatory Effects in a Murine Model for Treatment of Toxoplasma gondii Infection. Front Cell Infect Microbiol 2016; 6: 164.
[http://dx.doi.org/10.3389/fcimb.2016.00164] [PMID: 27933277]
[40]
Lucas JM, Heinlein C, Kim T, et al. The androgen-regulated protease TMPRSS2 activates a proteolytic cascade involving components of the tumor microenvironment and promotes prostate cancer metastasis. Cancer Discov 2014; 4(11): 1310-25.
[http://dx.doi.org/10.1158/2159-8290.CD-13-1010] [PMID: 25122198]
[41]
Azimi A. TMPRSS2 inhibitors, Bromhexine, Aprotinin, Camostat and Nafamostat as potential treatments for COVID-19 Frenxiv. 2020. Available at: https://frenxiv.org/a3rvm/
[42]
Stopsack KH, Mucci LA, Antonarakis ES, Nelson PS, Kantoff PW. TMPRSS2 and COVID-19: Serendipity or Opportunity for Intervention? Cancer Discov 2020; 10(6): 779-82.
[http://dx.doi.org/10.1158/2159-8290.CD-20-0451] [PMID: 32276929]
[43]
Jankun J. COVID-19 pandemic; transmembrane protease serine 2 (TMPRSS2) inhibitors as potential drugs. Translation. University of Toledo Journal of Medical Sciences 2020; 7: 1-5.
[44]
McKee DL, Sternberg A, Stange U, Laufer S, Naujokat C. Candidate drugs against SARS-CoV-2 and COVID-19. Pharmacol Res 2020.157104859
[http://dx.doi.org/10.1016/j.phrs.2020.104859] [PMID: 32360480]
[45]
Liu M, Wang T, Zhou Y, Zhao Y, Zhang Y, Li J. Potential Role of ACE2 in Coronavirus Disease 2019 (COVID-19) Prevention and Management. J Transl Int Med 2020; 8(1): 9-19.
[http://dx.doi.org/10.2478/jtim-2020-0003] [PMID: 32435607]
[46]
Yao X, Ye F, Zhang M, et al. In Vitro Antiviral Activity and Projection of Optimized Dosing Design of Hydroxychloroquine for the Treatment of Severe Acute Respiratory Syndrome Coronavirus 2 (SARS-CoV-2). Clin Infect Dis 2020; 71(15): 732-9.
[http://dx.doi.org/10.1093/cid/ciaa237] [PMID: 32150618]
[47]
Fan H-H, Wang L-Q, Liu W-L, et al. Repurposing of clinically approved drugs for treatment of coronavirus disease 2019 in a 2019-novel coronavirus-related coronavirus model. Chin Med J (Engl) 2020; 133(9): 1051-6.
[http://dx.doi.org/10.1097/CM9.0000000000000797] [PMID: 32149769]
[48]
Monteil V, Kwon H, Prado P, et al. Inhibition of SARS-CoV-2 Infections in Engineered Human Tissues Using Clinical-Grade Soluble Human ACE2. Cell 2020; 181(4): 905-913. e7.
[http://dx.doi.org/10.1016/j.cell.2020.04.004] [PMID: 32333836]
[49]
Keyaerts E, Vijgen L, Pannecouque C, et al. Plant lectins are potent inhibitors of coronaviruses by interfering with two targets in the viral replication cycle. Antiviral Res 2007; 75(3): 179-87.
[http://dx.doi.org/10.1016/j.antiviral.2007.03.003] [PMID: 17428553]
[50]
Michelow IC, Lear C, Scully C, et al. High-dose mannose-binding lectin therapy for Ebola virus infection. J Infect Dis 2011; 203(2): 175-9.
[http://dx.doi.org/10.1093/infdis/jiq025] [PMID: 21288816]
[51]
Kumaki Y, Wandersee MK, Smith AJ, et al. Inhibition of severe acute respiratory syndrome coronavirus replication in a lethal SARS-CoV BALB/c mouse model by stinging nettle lectin, Urtica dioica agglutinin. Antiviral Res 2011; 90(1): 22-32.
[http://dx.doi.org/10.1016/j.antiviral.2011.02.003] [PMID: 21338626]
[52]
Covés-Datson EM, King SR, Legendre M, et al. A molecularly engineered antiviral banana lectin inhibits fusion and is efficacious against influenza virus infection in vivo. Proc Natl Acad Sci USA 2020; 117(4): 2122-32.
[http://dx.doi.org/10.1073/pnas.1915152117] [PMID: 31932446]
[53]
Hwang H-J, Han J-W, Jeon H, et al. Characterization of a Novel Mannose-Binding Lectin with Antiviral Activities from Red Alga, Grateloupia chiangii. Biomolecules 2020; 10(2)E333
[http://dx.doi.org/10.3390/biom10020333] [PMID: 32092955]
[54]
Petersen KA, Matthiesen F, Agger T, et al. Phase I safety, tolerability, and pharmacokinetic study of recombinant human mannan-binding lectin. J Clin Immunol 2006; 26(5): 465-75.
[http://dx.doi.org/10.1007/s10875-006-9037-z] [PMID: 16990992]
[55]
WHO. A Coordinated Global Research Roadmap: 2019 novel coronavirus 2019. Available at: https://www.who.int/blueprint/priority-diseases/key-action/Coronavirus_Roadmap_V9.pdf?ua=1

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version438msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[21:13:23] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[21:13:23] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[21:13:23] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (152ms)time
  • Application (286ms)time
  • 1 x Application (65.37%)
    286ms
    1 x Booting (34.62%)
    152ms
    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 duplicated197ms
    • 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 ('59071403','',1,1740345203,1740345203) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740345203
      1.25msalphaeurekaselec_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 ('59071403','/article/109399',1,1740345203,1740345203)
      190μ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 >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) 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 >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) 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 >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) 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 >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) 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 >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) 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 >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59071403 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59071403) limit 1
      16.22msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59071403
      • 1: 59071403
      • 2: 59071403
      • 3: 59071403
      • 4: 59071403
      • 5: 59071403
      • 6: 59071403
      • 7: 59071403
      • 8: 59071403
      • 9: 59071403
      • 10: 59071403
      • 11: 59071403
      • 12: 59071403
      • 13: 59071403
      • 14: 59071403
      • 15: 59071403
      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=109399
      1msalphaeurekaselec_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` = 29 limit 1
      4.05msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 29
      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=29) and sj.journal_id!=29 group by `j`.`nid`) as `aggregate_table`
      1.53msalphaeurekaselec_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=29) and sj.journal_id!=29 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.29msalphaeurekaselec_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=29) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.57msalphaeurekaselec_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=29) 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.51msalphaeurekaselec_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` = '109399'
      1.05msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 109399
      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` = '109399'
      2.88msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 109399
      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` = '109399' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.2msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 109399
      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
      1.19msalphaeurekaselec_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
      670μ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 = 29 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      52.1msalphaeurekaselec_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 = 29 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      51.95msalphaeurekaselec_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 = 29 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      32.4msalphaeurekaselec_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` = 109399 limit 1
      760μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 109399
      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 = 109399 and content_type = 'article' order by status desc limit 1
      340μ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!=109399 and cd.content_type = 'article' order by rand() limit 20
      7msalphaeurekaselec_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` = 185208 limit 1
      210μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 185208
      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
      190μ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` = 'CPD' 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: CPD
      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 = '109399' 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) )
      330μ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 = '10235' and content_type = 'i' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      270μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '2790' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      240μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2231
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59071403 and j.to_ip >=59071403 )) and ((j.from_date <= 1740345203 and j.to_date >= 1740345203 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2790) 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 <= 59071403 and j.to_ip >=59071403 )) and ((j.from_date <= 1740345203 and j.to_date >= 1740345203 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2790) 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 <= 59071403 and j.to_ip >=59071403 )) and ((j.from_date <= 1740345203 and j.to_date >= 1740345203 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2790)
      5.9msalphaeurekaselec_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 <= 59071403 and j.to_ip >=59071403 )) and ((j.from_date <= 1740345203 and j.to_date >= 1740345203 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10235) 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 <= 59071403 and j.to_ip >=59071403 )) and ((j.from_date <= 1740345203 and j.to_date >= 1740345203 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10235) 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 <= 59071403 and j.to_ip >=59071403 )) and ((j.from_date <= 1740345203 and j.to_date >= 1740345203 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10235)
      780μ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 <= 59071403 and j.to_ip >=59071403 )) and ((j.from_date <= 1740345203 and j.to_date >= 1740345203 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 109399) 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 <= 59071403 and j.to_ip >=59071403 )) and ((j.from_date <= 1740345203 and j.to_date >= 1740345203 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 109399) 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 <= 59071403 and j.to_ip >=59071403 )) and ((j.from_date <= 1740345203 and j.to_date >= 1740345203 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 109399)
      760μ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` < '5286' and is_uploaded = 1 and issue_id = 10235 order by cast(first_page as SIGNED) desc limit 1
      550μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 5286
      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` > '5292' and is_uploaded = 1 and issue_id = 10235 order by cast(first_page as SIGNED) asc limit 1
      480μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 5292
      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'
      210μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      220μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 109399 limit 1
      2.39msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 109399
      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` = 29 and `b`.`banner_from_date` <= 1740345203 and `b`.`banner_to_date` >= 1740345203 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.15msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 29
      • 3: 1740345203
      • 4: 1740345203
      • 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` = 29 and `b`.`banner_from_date` <= 1740345203 and `b`.`banner_to_date` >= 1740345203 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.06msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 29
      • 3: 1740345203
      • 4: 1740345203
      • 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='9e293ce87d07e096e27b66e0309438eb'
      210μ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
        5t8ENMTDhm6SJJQqzs99dCslFnfuwILBbGYK2wp7
        uc_cart_id
        9e293ce87d07e096e27b66e0309438eb
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/109399" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/109399
        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=eyJpdiI6ImxQL0lDVnlxVTFBSHpaZ0c0ZnNwSlE9PSIsInZhbHVlIjoiNGpubmJUOUxMQUg1VkYyYmxRWld4MmlPTFlGQTBoSTJXUWNhTm1EYnBOST0iLCJtYWMiOiIwOTMzZmYzY2ZjOGZlM2YzMmQ4NGYzN2FiZjUxYjU5MjA4OWE4ZDQzM2FmNzQwYzQ1YWEwNGMxZjA5MDkyZDczIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6ImxQL0lDVnlxVTFBSHpaZ0c0ZnNwSlE9PSIsInZhbHVlIjoiNGpubmJUOUxMQUg1VkYyYmxRWld4MmlPTFlGQTBoSTJXUWNhTm1EYnBOST0iLCJtYWMiOiIwOTMzZmYzY2ZjOGZl" ] "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 => "Sun, 23 Feb 2025 21:13:23 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjRjM0xraXlTczZsQWZqN0t5MCtoc1E9PSIsInZhbHVlIjoiK2tiQzdIQjJ1QUwwWTJWZHM2OTlObGtjcUh2SythTW0zYzBNWHk5cCsyd2dZRy94cVRvSlZvdi91NEhvTmNBU1lQNkpVYXdJUHJ3Y0tmamRLYmlJVHYvSkNBSG5yd1RTSUQ5QVRETXNHREp5ZUFXNnl5ZlF1cG1RMnlneTBIbEoiLCJtYWMiOiJkMjgxZjY1YjhiYzIyMzhmMDZiNDM1MzllZTE4MTRkNmUxMGE2MjBhYTA0YWMzNmExNTgzYzMyYTg5MTIwY2Q2IiwidGFnIjoiIn0%3D; expires=Wed, 26 Feb 2025 09:13:23 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjRjM0xraXlTczZsQWZqN0t5MCtoc1E9PSIsInZhbHVlIjoiK2tiQzdIQjJ1QUwwWTJWZHM2OTlObGtjcUh2SythTW0zYzBNWHk5cCsyd2dZRy94cVRvSlZvdi91NEhvTmNBU1lQNkpVY" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImJZbXpUMTRuZi9VejlYMFFHU01LV1E9PSIsInZhbHVlIjoiS01CZERKYWRUbDB1TFVKMTV6SVB4eTZsaXRXazBDS0VOOWNoUGJWa1dtNUJKT0pNRzVYUDl2aDNqZjZuRkpjY3JER0x3VzkxaDYrSFdKNUd6eHZJRUpwek1EUmZ0YmtYNW9QeDBIejVKVUxZVGFBaHp0YXRacU9UUzh5aHR0Q04iLCJtYWMiOiI2ZTFkMDA5YTI5ZTc5MTZlNDQyODAzOWY3YzAyNDRhMmFjOGU5ZWYxMTQ2MTE1MjljZjJjMjk2MGJkMzA4ZTE1IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6ImJZbXpUMTRuZi9VejlYMFFHU01LV1E9PSIsInZhbHVlIjoiS01CZERKYWRUbDB1TFVKMTV6SVB4eTZsaXRXazBDS0VOOWNoUGJWa1dtNUJKT0pNRzVYUDl2aDN" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjRjM0xraXlTczZsQWZqN0t5MCtoc1E9PSIsInZhbHVlIjoiK2tiQzdIQjJ1QUwwWTJWZHM2OTlObGtjcUh2SythTW0zYzBNWHk5cCsyd2dZRy94cVRvSlZvdi91NEhvTmNBU1lQNkpVYXdJUHJ3Y0tmamRLYmlJVHYvSkNBSG5yd1RTSUQ5QVRETXNHREp5ZUFXNnl5ZlF1cG1RMnlneTBIbEoiLCJtYWMiOiJkMjgxZjY1YjhiYzIyMzhmMDZiNDM1MzllZTE4MTRkNmUxMGE2MjBhYTA0YWMzNmExNTgzYzMyYTg5MTIwY2Q2IiwidGFnIjoiIn0%3D; expires=Wed, 26-Feb-2025 09:13:23 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjRjM0xraXlTczZsQWZqN0t5MCtoc1E9PSIsInZhbHVlIjoiK2tiQzdIQjJ1QUwwWTJWZHM2OTlObGtjcUh2SythTW0zYzBNWHk5cCsyd2dZRy94cVRvSlZvdi91NEhvTmNBU1lQNkpVY" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImJZbXpUMTRuZi9VejlYMFFHU01LV1E9PSIsInZhbHVlIjoiS01CZERKYWRUbDB1TFVKMTV6SVB4eTZsaXRXazBDS0VOOWNoUGJWa1dtNUJKT0pNRzVYUDl2aDNqZjZuRkpjY3JER0x3VzkxaDYrSFdKNUd6eHZJRUpwek1EUmZ0YmtYNW9QeDBIejVKVUxZVGFBaHp0YXRacU9UUzh5aHR0Q04iLCJtYWMiOiI2ZTFkMDA5YTI5ZTc5MTZlNDQyODAzOWY3YzAyNDRhMmFjOGU5ZWYxMTQ2MTE1MjljZjJjMjk2MGJkMzA4ZTE1IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6ImJZbXpUMTRuZi9VejlYMFFHU01LV1E9PSIsInZhbHVlIjoiS01CZERKYWRUbDB1TFVKMTV6SVB4eTZsaXRXazBDS0VOOWNoUGJWa1dtNUJKT0pNRzVYUDl2aDN" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "5t8ENMTDhm6SJJQqzs99dCslFnfuwILBbGYK2wp7" "uc_cart_id" => "9e293ce87d07e096e27b66e0309438eb" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/109399" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-23 21:13:23GET/article/109399314371