Generic placeholder image

Infectious Disorders - Drug Targets

Editor-in-Chief

ISSN (Print): 1871-5265
ISSN (Online): 2212-3989

Research Article

In Silico Identification of a Potent Arsenic Based Approved Drug Darinaparsin against SARS-CoV-2: Inhibitor of RNA Dependent RNA polymerase (RdRp) and Essential Proteases

Author(s): Trinath Chowdhury, Gourisankar Roymahapatra and Santi M. Mandal*

Volume 21, Issue 4, 2021

Published on: 27 July, 2020

Page: [608 - 618] Pages: 11

DOI: 10.2174/1871526520666200727153643

Price: $65

Abstract

Background: COVID-19 is a life-threatening novel corona viral infection to our civilization and spreading rapidly. Tremendousefforts have been made by the researchers to search for a drug to control SARS-CoV-2.

Methods: Here, a series of arsenical derivatives were optimized and analyzed with in silico study to search the inhibitor of RNA dependent RNA polymerase (RdRp), the major replication factor of SARS-CoV-2. All the optimized derivatives were blindly docked with RdRp of SARS-CoV-2 using iGEMDOCK v2.1.

Results: Based on the lower idock score in the catalytic pocket of RdRp, darinaparsin (-82.52 kcal/- mol) was revealed to be the most effective among them. Darinaparsin strongly binds with both Nsp9 replicase protein (-8.77 kcal/mol) and Nsp15 endoribonuclease (-8.3 kcal/mol) of SARS-- CoV-2 as confirmed from the AutoDock analysis. During infection, the ssRNA of SARS-CoV-2 is translated into large polyproteins forming viral replication complex by specific proteases like 3CL protease and papain protease. This is also another target to control the virus infection where darinaparsin also performs the inhibitory role to proteases of 3CL protease (-7.69 kcal/mol) and papain protease (-8.43 kcal/mol).

Conclusion: In the host cell, the furin protease serves as a gateway to the viral entry and darinaparsin docked with furin protease, which revealed a strong binding affinity. Thus, screening of potential arsenic drugs would help in providing the fast in-vitro to in-vivo analysis towards the development of therapeutics against SARS-CoV-2.

Keywords: COVID-19, novel-corona virus, arsenical drug, darinaparsin, RNA dependent RNA polymerase, proteases.

Graphical Abstract

[1]
Yan, R.; Zhang, Y.; Li, Y.; Xia, L.; Guo, Y.; Zhou, Q. Structural basis for the recognition of SARS-CoV-2 by full-length human ACE2. Science, 2020, 367(6485), 1444-1448.
[http://dx.doi.org/10.1126/science.abb2762] [PMID: 32132184]
[2]
Clinical trails, Arnea, 2020. Available from: https://www.clinicaltrialsarena.com/analysis/coronavirus-mers-cov-drugs/
[3]
Dayer, M.R.; Taleb-Gassabi, S.; Saaid Dayer, M. Lopinavir; A potent drug against coronavirus infection: insight from molecular docking study. Arch. Clin. Infect. Dis., 2017, 12(4), e13823.
[http://dx.doi.org/10.5812/archcid.13823]
[4]
Liu, J.; Cao, R.; Xu, M.; Wang, X.; Zhang, H.; Hu, H.; Li, Y.; Hu, Z.; Zhong, W.; Wang, M. Hydroxychloroquine, a less toxic derivative of chloroquine, is effective in inhibiting SARS-CoV-2 infection in vitro. Cell Discov., 2020, 6, 16.
[http://dx.doi.org/10.1038/s41421-020-0156-0] [PMID: 32194981]
[5]
Smith, M.; Smith, J.C. Repurposing therapeutics for COVID-19: supercomputer-based docking to the SARS-CoV-2 viral spike protein and viral spike protein-human ACE2 interface. ChemRxiv, 2020.
[http://dx.doi.org/10.26434/chemrxiv.11871402.v3]
[6]
Lee, H.; Mittal, A.; Patel, K.; Gatuz, J.L.; Truong, L.; Torres, J.; Mulhearn, D.C.; Johnson, M.E. Identification of novel drug scaffolds for inhibition of SARS-CoV 3-Chymotrypsin-like protease using virtual and high-throughput screenings. Bioorg. Med. Chem., 2014, 22(1), 167-177.
[http://dx.doi.org/10.1016/j.bmc.2013.11.041] [PMID: 24332657]
[7]
Berry, M.; Fielding, B.C.; Gamieldien, J. Potential broad spectrum inhibitors of the coronavirus 3clpro: a virtual screening and structure-based drug design study. Viruses, 2015, 7(12), 6642-6660.
[http://dx.doi.org/10.3390/v7122963] [PMID: 26694449]
[8]
Elfiky, A.A.; Mahdy, S.M.; Elshemey, W.M. Quantitative structure-activity relationship and molecular docking revealed a potency of anti-hepatitis C virus drugs against human corona viruses. J. Med. Virol., 2017, 89(6), 1040-1047.
[http://dx.doi.org/10.1002/jmv.24736] [PMID: 27864902]
[9]
Zaher, N.H.; Mostafa, M.I.; Altaher, A.Y. Design, synthesis and molecular docking of novel triazole derivatives as potential CoV helicase inhibitors. Acta Pharm., 2020, 70(2), 145-159.
[http://dx.doi.org/10.2478/acph-2020-0024] [PMID: 31955138]
[10]
Hilgenfeld, R. From SARS to MERS: crystallographic studies on coronaviral proteases enable antiviral drug design. FEBS J., 2014, 281(18), 4085-4096.
[http://dx.doi.org/10.1111/febs.12936] [PMID: 25039866]
[11]
Zhou, Y.; Hou, Y.; Shen, J.; Huang, Y.; Martin, W.; Cheng, F. Network-based drug repurposing for novel coronavirus 2019-nCoV/SARS-CoV-2. Cell Discov., 2020, 6(1), 14.
[http://dx.doi.org/10.1038/s41421-020-0153-3] [PMID: 32194980]
[12]
Cui, J.; Li, F.; Shi, Z.L. Origin and evolution of pathogenic coronaviruses. Nat. Rev. Microbiol., 2019, 17(3), 181-192.
[http://dx.doi.org/10.1038/s41579-018-0118-9] [PMID: 30531947]
[13]
El-Sayed, S.M.; Ali, M.A.M.; El-Gendy, B.E.M.; Dandash, S.S.; Issac, Y.; Saad, R.; Azab, M.M.; Mohamed, M.R. Identification of novel small molecule inhibitors against the NS3/4A protease of hepatitis C virus genotype 4a. Curr. Pharm. Des., 2018, 24(37), 4484-4491.
[http://dx.doi.org/10.2174/1381612825666181203153835] [PMID: 30501598]
[14]
Szollosi, D.; Bill, A. Potential role of endonuclease inhibition and other targets in the treatment of influenza. Curr. Drug Targets, 2020, 21(2), 202-211.
[http://dx.doi.org/10.2174/1389450120666190801115130] [PMID: 31368872]
[15]
Giacchello, I.; Musumeci, F.; D’Agostino, I.; Greco, C.; Grossi, G.; Schenone, S. Insights into rna-dependent rna polymerase inhibitors as anti-influenza virus agents. Curr. Med. Chem., 2020, 27, 1-23.
[http://dx.doi.org/10.2174/0929867327666200114115632] [PMID: 31942843]
[16]
Mahmud, S.M.N.; Rahman, M.M.; Kar, A.; Jahan, N.; Khan, M.A. Designing of an epitope-based universal peptide vaccine against highly conserved regions in rna dependent rna polymerase protein of human marburg virus: a computational assay. Antiinfect. Agents, 2019, 17, 1-12.
[http://dx.doi.org/10.2174/2211352517666190717143949]
[17]
Li, W. A Furin Cleavage Site Inserted into the Spike Protein of SARS-CoV-2: A Structural Implication? Preprints , 2020.
[18]
Del Razo, L.M.; Quintanilla-Vega, B.; Brambila-Colombres, E.; Calderón-Aranda, E.S.; Manno, M.; Albores, A. Stress proteins induced by arsenic. Toxicol. Appl. Pharmacol., 2001, 177(2), 132-148.
[http://dx.doi.org/10.1006/taap.2001.9291] [PMID: 11740912]
[19]
Chou, W-C.; Dang, C.V. Acute promyelocytic leukemia: recent advances in therapy and molecular basis of response to arsenic therapies. Curr. Opin. Hematol., 2005, 12(1), 1-6.
[http://dx.doi.org/10.1097/01.moh.0000148552.93303.45] [PMID: 15604884]
[20]
Hu, J.; Fang, J.; Dong, Y.; Chen, S.J.; Chen, Z. Arsenic in cancer therapy. Anticancer Drugs, 2005, 16(2), 119-127.
[http://dx.doi.org/10.1097/00001813-200502000-00002] [PMID: 15655408]
[21]
Douer, D.; Tallman, M.S. Arsenic trioxide: new clinical experience with an old medication in hematologic malignancies. J. Clin. Oncol., 2005, 23(10), 2396-2410.
[http://dx.doi.org/10.1200/JCO.2005.10.217] [PMID: 15800332]
[22]
Kuroki, M.; Ariumi, Y.; Ikeda, M.; Dansako, H.; Wakita, T.; Kato, N. Arsenic trioxide inhibits hepatitis C virus RNA replication through modulation of the glutathione redox system and oxidative stress. J. Virol., 2009, 83(5), 2338-2348.
[http://dx.doi.org/10.1128/JVI.01840-08] [PMID: 19109388]
[23]
Samanta, T.; Roymahapatra, G.; Porto, W.F.; Seth, S.; Ghorai, S.; Saha, S.; Sengupta, J.; Franco, O.L.; Dinda, J.; Mandal, S.M. N, N′-Olefin functionalized bis-imidazolium gold(I) salt is an efficient candidate to control keratitis-associated eye infection. PLoS One, 2013, 8(3), e58346.
[http://dx.doi.org/10.1371/journal.pone.0058346] [PMID: 23554886]
[24]
Gaussian 09, Revision D.01, Gaussian, Inc., Wallingford CT, 2013; Gaussian 16, Revision C.01, Gaussian, Inc., Wallingford CT. 2016.
[25]
Parr, R.G.; Szentpaly, Lv.; Liu, S. Electrophilicty index. J. Am. Chem. Soc., 1999, 121, 1922-1924.
[http://dx.doi.org/10.1021/ja983494x]
[26]
Roymahapatra, G.; Mandal, S.M.; Porto, W.F.; Samanta, T.; Giri, S.; Dinda, J.; Franco, O.L.; Chattaraj, P.K. Pyrazine functionalized Ag(I) and Au(I)-NHC complexes are potential antibacterial agents. Curr. Med. Chem., 2012, 19(24), 4184-4193.
[http://dx.doi.org/10.2174/092986712802430090] [PMID: 22680631]
[27]
Hsu, K-C.; Chen, Y-F.; Lin, S-R.; Yang, J-M. iGEMDOCK: a graphical environment of enhancing GEMDOCK using pharmacological interactions and post-screening analysis. BMC Bioinformatics, 2011, 12(Suppl. 1), S33.
[http://dx.doi.org/10.1186/1471-2105-12-S1-S33] [PMID: 21342564]
[28]
Trott, O.; Olson, A.J. AutoDock Vina: improving the speed and accuracy of docking with a new scoring function, efficient optimization, and multithreading. J. Comput. Chem., 2010, 31(2), 455-461.
[PMID: 19499576]
[29]
Morris, G.M.; Huey, R.; Lindstrom, W.; Sanner, M.F.; Belew, R.K.; Goodsell, D.S.; Olson, A.J. AutoDock4 and AutoDockTools4: Automated docking with selective receptor flexibility. J. Comput. Chem., 2009, 30(16), 2785-2791.
[http://dx.doi.org/10.1002/jcc.21256] [PMID: 19399780]
[30]
Lill, M.A.; Danielson, M.L. Computer-aided drug design platform using PyMOL. J. Comput. Aided Mol. Des., 2011, 25(1), 13-19.
[http://dx.doi.org/10.1007/s10822-010-9395-8] [PMID: 21053052]
[31]
Hofmarcher, M.; Mayr, A.; Rumetshofer, E.; Ruch, P.; Renz, P. Large-scale ligand based virtual screening for SARS CoV-2 inhibitors using deep neural networks. Biomolecules arXiv:2004.00979, 2020.
[http://dx.doi.org/10.2139/ssrn.3561442]
[32]
Seo, S.; Park, J.W.; An, D.; Yoon, J.; Paik, H. Supercomputer aided drug repositioning at scale: virtual screening for SARS-CoV-2 protease inhibitor. ChemRxiv, 2020.
[33]
Furuta, Y.; Komeno, T.; Nakamura, T. Favipiravir (T-705), a broad spectrum inhibitor of viral RNA polymerase. Proc. Jpn. Acad., Ser. B, Phys. Biol. Sci., 2017, 93(7), 449-463.
[http://dx.doi.org/10.2183/pjab.93.027] [PMID: 28769016]
[34]
Pharmaceuticals and Medical Devices Agency:Avigan (favipiravir) Review Report
[35]
Wu, J.Z.; Larson, G.; Walker, H.; Shim, J.H.; Hong, Z. Phosphorylation of ribavirin and viramidine by adenosine kinase and cytosolic 5′-nucleotidase II: Implications for ribavirin metabolism in erythrocytes. Antimicrob. Agents Chemother., 2005, 49(6), 2164-2171.
[http://dx.doi.org/10.1128/AAC.49.6.2164-2171.2005] [PMID: 15917509]
[36]
Charan, N.; Lavanya, N.; Praveen, B.; Praveen, A.; Sridevi, A. Antiviral activity of antimony and arsenic oxides. Pharma Chem., 2012, 4(2), 687-689.
[37]
Hwang, D-R.; Tsai, Y-C.; Lee, J-C.; Huang, K-K.; Lin, R-K.; Ho, C.H.; Chiou, J.M.; Lin, Y.T.; Hsu, J.T.; Yeh, C.T. Inhibition of hepatitis C virus replication by arsenic trioxide. Antimicrob. Agents Chemother., 2004, 48(8), 2876-2882.
[http://dx.doi.org/10.1128/AAC.48.8.2876-2882.2004] [PMID: 15273095]
[38]
Gu, Y.; Xu, X. Extended Koopmans’ theorem at the second-order perturbation theory. J. Comput. Chem., 2020, 41(12), 1165-1174.
[http://dx.doi.org/10.1002/jcc.26163] [PMID: 32003902]
[39]
Kirchdoerfer, R.N.; Ward, A.B. Structure of the SARS-CoV nsp12 polymerase bound to nsp7 and nsp8 co-factors. Nat. Commun., 2019, 10(1), 2342.
[http://dx.doi.org/10.1038/s41467-019-10280-3] [PMID: 31138817]
[40]
Appleby, T.C.; Perry, J.K.; Murakami, E.; Barauskas, O.; Feng, J.; Cho, A.; Fox, D., III; Wetmore, D.R.; McGrath, M.E.; Ray, A.S.; Sofia, M.J.; Swaminathan, S.; Edwards, T.E. Viral replication. Structural basis for RNA replication by the hepatitis C virus polymerase. Science, 2015, 347(6223), 771-775.
[http://dx.doi.org/10.1126/science.1259210] [PMID: 25678663]
[41]
Gong, P.; Peersen, O.B. Structural basis for active site closure by the poliovirus RNA-dependent RNA polymerase. Proc. Natl. Acad. Sci. USA, 2010, 107(52), 22505-22510.
[http://dx.doi.org/10.1073/pnas.1007626107] [PMID: 21148772]
[42]
Gao, Y.; Yan, L.; Huang, Y.; Liu, F.; Zhao, Y.; Cao, L.; Wang, T.; Sun, Q.; Ming, Z.; Zhang, L.; Ge, J.; Zheng, L.; Zhang, Y.; Wang, H.; Zhu, Y.; Zhu, C.; Hu, T.; Hua, T.; Zhang, B.; Yang, X.; Li, J.; Yang, H.; Liu, Z.; Xu, W.; Guddat, L.W.; Wang, Q.; Lou, Z.; Rao, Z. Structure of the RNA-dependent RNA polymerase from COVID-19 virus. Science, 2020, 368(6492), 779-782. [DOI: 10.1126/science.abb7498].
[http://dx.doi.org/10.1126/science.abb7498] [PMID: 32277040]
[43]
Snijder, E.J.; Bredenbeek, P.J.; Dobbe, J.C.; Thiel, V.; Ziebuhr, J.; Poon, L.L.; Guan, Y.; Rozanov, M.; Spaan, W.J.; Gorbalenya, A.E. Unique and conserved features of genome and proteome of SARS-coronavirus, an early split-off from the coronavirus group 2 lineage. J. Mol. Biol., 2003, 331(5), 991-1004.
[http://dx.doi.org/10.1016/S0022-2836(03)00865-9] [PMID: 12927536]
[44]
Sutton, G.; Fry, E.; Carter, L.; Sainsbury, S.; Walter, T.; Nettleship, J.; Berrow, N.; Owens, R.; Gilbert, R.; Davidson, A.; Siddell, S.; Poon, L.L.; Diprose, J.; Alderton, D.; Walsh, M.; Grimes, J.M.; Stuart, D.I. The nsp9 replicase protein of SARS-coronavirus, structure and functional insights. Structure, 2004, 12(2), 341-353.
[http://dx.doi.org/10.1016/j.str.2004.01.016] [PMID: 14962394]
[45]
Ortiz-Alcantara, J.; Bhardwaj, K.; Palaninathan, S.; Frieman, M.; Baric, R.S.; Kao, C.C. Small molecule inhibitors of the SARS CoV Nsp15 endoribonuclease. Virus Adaptation and Treatment., 2010, 2(1), 125-133.
[46]
Walls, A.C.; Park, Y-J.; Tortorici, M.A.; Wall, A.; McGuire, A.T.; Veesler, D. Structure, function and antigenicity of the SARS CoV-2 spike glycoprotein. Cell, 2020, 181(2), 281-292.e6.
[http://dx.doi.org/10.1016/j.cell.2020.02.058] [PMID: 32155444]
[47]
Wu, C.; Liu, Y.; Yang, Y.; Zhang, P.; Zhong, W.; Wang, Y.; Wang, Q.; Xu, Y.; Li, M.; Li, X.; Zheng, M.; Chen, L.; Li, H. Analysis of therapeutic targets for SARS-CoV-2 and discovery of potential drugs by computational methods. Acta Pharm Sin B, 2020, 10(5), 766-88.
[http://dx.doi.org/10.1016/j.apsb.2020.02.008] [PMID: 32292689]
[48]
Elfiky, A.A. SARS-CoV-2 RNA dependent RNA polymerase (RdRp) targeting: an in silico perspective. J Biomol Struct Dyn, 2020, 39(9), 3204-12.
[PMID: 32338164]
[49]
Martin, P.; Jensen, D.M. Ribavirin in the treatment of chronic hepatitis C. J. Gastroenterol. Hepatol., 2008, 23(6), 844-855.
[http://dx.doi.org/10.1111/j.1440-1746.2008.05398.x] [PMID: 18565019]
[50]
Mann, K.K.; Wallner, B.; Lossos, I.S.; Miller, W.H., Jr Darinaparsin: a novel organic arsenical with promising anticancer activity. Expert Opin. Investig. Drugs, 2009, 18(11), 1727-1734.
[http://dx.doi.org/10.1517/13543780903282759] [PMID: 19780704]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version309msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[17:57:05] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[17:57:05] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[17:57:05] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[17:57:05] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (92.46ms)time
  • Application (216ms)time
  • 1 x Application (70.05%)
    216ms
    1 x Booting (29.95%)
    92.46ms
    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 duplicated146ms
    • 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 ('51399716','',1,1739987825,1739987825) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739987825
      940μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#24
      Backtrace
      • 11. middleware::check_user_access:24
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('51399716','/article/108513',1,1739987825,1739987825)
      160μ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 >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) 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 >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) 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 >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) 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 >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) 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 >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) 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 >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51399716 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51399716) limit 1
      12.59msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51399716
      • 1: 51399716
      • 2: 51399716
      • 3: 51399716
      • 4: 51399716
      • 5: 51399716
      • 6: 51399716
      • 7: 51399716
      • 8: 51399716
      • 9: 51399716
      • 10: 51399716
      • 11: 51399716
      • 12: 51399716
      • 13: 51399716
      • 14: 51399716
      • 15: 51399716
      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=108513
      660μ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` = 54 limit 1
      820μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 54
      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=54) and sj.journal_id!=54 group by `j`.`nid`) as `aggregate_table`
      1.29msalphaeurekaselec_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=54) and sj.journal_id!=54 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.04msalphaeurekaselec_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=54) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      6.24msalphaeurekaselec_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=54) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      6.87msalphaeurekaselec_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` = '108513'
      3.97msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 108513
      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` = '108513'
      3.31msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 108513
      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` = '108513' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.04msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 108513
      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
      300μ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
      630μ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 = 54 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      30.81msalphaeurekaselec_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 = 54 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      11.23msalphaeurekaselec_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 = 54 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      8.44msalphaeurekaselec_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` = 108513 limit 1
      1.04msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 108513
      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 = 108513 and content_type = 'article' order by status desc limit 1
      2.2msalphaeurekaselec_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 = 16 and cd.sub_disease_id = 597 and content_id!=108513 and cd.content_type = 'article' order by rand() limit 20
      35.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` = 184168 limit 1
      190μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 184168
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      230μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'IDDT' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      240μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: IDDT
      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 = '108513' 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) )
      350μ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 = '10741' 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) )
      260μ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 = '2994' 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 <= 51399716 and j.to_ip >=51399716 )) and ((j.from_date <= 1739987825 and j.to_date >= 1739987825 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2994) 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 <= 51399716 and j.to_ip >=51399716 )) and ((j.from_date <= 1739987825 and j.to_date >= 1739987825 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2994) 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 <= 51399716 and j.to_ip >=51399716 )) and ((j.from_date <= 1739987825 and j.to_date >= 1739987825 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2994)
      5.77msalphaeurekaselec_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 <= 51399716 and j.to_ip >=51399716 )) and ((j.from_date <= 1739987825 and j.to_date >= 1739987825 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10741) 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 <= 51399716 and j.to_ip >=51399716 )) and ((j.from_date <= 1739987825 and j.to_date >= 1739987825 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10741) 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 <= 51399716 and j.to_ip >=51399716 )) and ((j.from_date <= 1739987825 and j.to_date >= 1739987825 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10741)
      560μ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 <= 51399716 and j.to_ip >=51399716 )) and ((j.from_date <= 1739987825 and j.to_date >= 1739987825 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 108513) 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 <= 51399716 and j.to_ip >=51399716 )) and ((j.from_date <= 1739987825 and j.to_date >= 1739987825 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 108513) 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 <= 51399716 and j.to_ip >=51399716 )) and ((j.from_date <= 1739987825 and j.to_date >= 1739987825 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 108513)
      550μ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` < '608' and is_uploaded = 1 and issue_id = 10741 order by cast(first_page as SIGNED) desc limit 1
      570μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 608
      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` > '618' and is_uploaded = 1 and issue_id = 10741 order by cast(first_page as SIGNED) asc limit 1
      530μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 618
      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'
      160μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      170μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 108513 limit 1
      2.41msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 108513
      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` = 54 and `b`.`banner_from_date` <= 1739987825 and `b`.`banner_to_date` >= 1739987825 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.09msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 54
      • 3: 1739987825
      • 4: 1739987825
      • 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` = 54 and `b`.`banner_from_date` <= 1739987825 and `b`.`banner_to_date` >= 1739987825 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: 54
      • 3: 1739987825
      • 4: 1739987825
      • 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='1b7277316c0510f8bc00e689ecef8a8b'
      200μ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
        tm9X3JDTOqMnFhSU4tQ5qKTAa0YxBM4UCXWGr3tv
        uc_cart_id
        1b7277316c0510f8bc00e689ecef8a8b
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/108513" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/108513
        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:8 [ "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
        []
        
        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 => "Wed, 19 Feb 2025 17:57:05 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlhIcFlncHZDMS95TE01UTBMbDN4eWc9PSIsInZhbHVlIjoiaHhWeDIvbFdNRXdhTTY2V3pYQlJpeXlzMVlBSUZmUGtrMXhHWEU0VDBJbkdUZ1J5L043Nk1GQzh0QncyczRJNThqVTI2QnY1NWNqQnpSZS81YUl4YVJwNE1hOXdBc2NxYlVhVk1GUWpGMDFTNEY5djlhOHJVS2NaclFUVXdoc24iLCJtYWMiOiIwMTQ5OTNjZjgwNjFiMmUzMmQ4NjRiODdiOWIzNjRlNWIwYTI4ZmZmMjZmMTQ3NGNmZjIxNzljZjU5MmNhOTg2IiwidGFnIjoiIn0%3D; expires=Sat, 22 Feb 2025 05:57:05 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlhIcFlncHZDMS95TE01UTBMbDN4eWc9PSIsInZhbHVlIjoiaHhWeDIvbFdNRXdhTTY2V3pYQlJpeXlzMVlBSUZmUGtrMXhHWEU0VDBJbkdUZ1J5L043Nk1GQzh0QncyczRJNThqVTI2Q" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ik9PdUFDdC9BeUdwTU9JaGhWcTNtUnc9PSIsInZhbHVlIjoiR1l4NHQ5elozaTZTUjNyVVpLMUZHUFlnd1RYZ3N6TXArdXNuN2RzOWNkc1cyY2VrNjdranJFWVV6MHNTbXRtUEwwd294RW5SZnBuWGhaR1dwR2RVeDg0YXRnc3lvSUZOS0xaVkY0TWt4cnpCWTQyck85NkFGKzN3b2VZWXZJNm4iLCJtYWMiOiIzMTYxZGVmYmRiYzNlYjMyMDA3NzEwZDJlNmQ3NmU2NzJmYmZhNzU0Mzg4Yzg5ZTRiMWUxOWU0NTk1MDFlNDM4IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ik9PdUFDdC9BeUdwTU9JaGhWcTNtUnc9PSIsInZhbHVlIjoiR1l4NHQ5elozaTZTUjNyVVpLMUZHUFlnd1RYZ3N6TXArdXNuN2RzOWNkc1cyY2VrNjdranJFWVV" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlhIcFlncHZDMS95TE01UTBMbDN4eWc9PSIsInZhbHVlIjoiaHhWeDIvbFdNRXdhTTY2V3pYQlJpeXlzMVlBSUZmUGtrMXhHWEU0VDBJbkdUZ1J5L043Nk1GQzh0QncyczRJNThqVTI2QnY1NWNqQnpSZS81YUl4YVJwNE1hOXdBc2NxYlVhVk1GUWpGMDFTNEY5djlhOHJVS2NaclFUVXdoc24iLCJtYWMiOiIwMTQ5OTNjZjgwNjFiMmUzMmQ4NjRiODdiOWIzNjRlNWIwYTI4ZmZmMjZmMTQ3NGNmZjIxNzljZjU5MmNhOTg2IiwidGFnIjoiIn0%3D; expires=Sat, 22-Feb-2025 05:57:05 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlhIcFlncHZDMS95TE01UTBMbDN4eWc9PSIsInZhbHVlIjoiaHhWeDIvbFdNRXdhTTY2V3pYQlJpeXlzMVlBSUZmUGtrMXhHWEU0VDBJbkdUZ1J5L043Nk1GQzh0QncyczRJNThqVTI2Q" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ik9PdUFDdC9BeUdwTU9JaGhWcTNtUnc9PSIsInZhbHVlIjoiR1l4NHQ5elozaTZTUjNyVVpLMUZHUFlnd1RYZ3N6TXArdXNuN2RzOWNkc1cyY2VrNjdranJFWVV6MHNTbXRtUEwwd294RW5SZnBuWGhaR1dwR2RVeDg0YXRnc3lvSUZOS0xaVkY0TWt4cnpCWTQyck85NkFGKzN3b2VZWXZJNm4iLCJtYWMiOiIzMTYxZGVmYmRiYzNlYjMyMDA3NzEwZDJlNmQ3NmU2NzJmYmZhNzU0Mzg4Yzg5ZTRiMWUxOWU0NTk1MDFlNDM4IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ik9PdUFDdC9BeUdwTU9JaGhWcTNtUnc9PSIsInZhbHVlIjoiR1l4NHQ5elozaTZTUjNyVVpLMUZHUFlnd1RYZ3N6TXArdXNuN2RzOWNkc1cyY2VrNjdranJFWVV" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "tm9X3JDTOqMnFhSU4tQ5qKTAa0YxBM4UCXWGr3tv" "uc_cart_id" => "1b7277316c0510f8bc00e689ecef8a8b" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/108513" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-19 17:57:05GET/article/108513414371