Generic placeholder image

Current Bioinformatics

Editor-in-Chief

ISSN (Print): 1574-8936
ISSN (Online): 2212-392X

Research Article

ProtPathDB: A Web-based Resource of Parasite Proteases

Author(s): Sadaf Shehzad, Rajan Pandey, Sushmita Sharma and Dinesh Gupta*

Volume 17, Issue 8, 2022

Published on: 22 August, 2022

Page: [710 - 722] Pages: 13

DOI: 10.2174/1574893617666220509185649

Price: $65

Abstract

Background: Proteases regulate cell proliferation, cell growth, biological processes, and overall homeostasis. Several proteases are extensively annotated and well-characterized in pathogenic organisms such as bacteria, parasites, and microbial species as anti-bacterial, anti-parasitic and antimicrobial. Several of these proteins are being explored as viable targets for various drug discovery researches in various microbial diseases. Despite multiple studies on pathogen proteases, comprehensive information on pathogen proteases is scattered or redundant, if available.

Methods: We have developed a comprehensive and integrative protease database resource, Prot- PathDB, for 23 pathogen species distributed among five taxa, Amoebozoa, Apicomplexa, Heterolob osea, Kinetoplastida and Fungi. ProtPathDB collects and organizes sequences, class division, signal peptides, localization, post-translational modifications, three-dimensional structure and related structural information regarding binding sites, and binding scores of annotated proteases.

Results: The ProtPathDB is publicly available at http://bioinfo.icgeb.res.in/ProtPathDB.

Conclusion: We believe that the database will be a one-stop resource for integrative and comparative analysis of pathogen proteases to better understand the functions of the microbial proteases and help drug discovery efforts targeting proteases.

Keywords: Proteases, apicomplexan, database, Post-translational modification, prodomain, parasite.

Graphical Abstract

[1]
Neurath H, Walsh KA, Winter WP. Evolution of structure and function of proteases. Science 1967; 158(3809): 1638-44.
[http://dx.doi.org/10.1126/science.158.3809.1638] [PMID: 4862530]
[2]
López-Otín C, Bond JS. Proteases: Multifunctional enzymes in life and disease. J Biol Chem 2008; 283(45): 30433-7.
[http://dx.doi.org/10.1074/jbc.R800035200] [PMID: 18650443]
[3]
Salvesen GS, Hempel A, Coll NS. Protease signaling in animal and plant-regulated cell death. FEBS J 2016; 283(14): 2577-98.
[http://dx.doi.org/10.1111/febs.13616] [PMID: 26648190]
[4]
Li H, Child MA, Bogyo M. Proteases as regulators of pathogenesis: Examples from the Apicomplexa. Biochim Biophys Acta 2012; 1824(1): 177-85.
[5]
Rawlings ND. Protease Families, Evolution and Mechanism of Action Proteases: Structure and Function. Vienna: Springer Vienna 2013; pp. 1-36.
[http://dx.doi.org/10.1007/978-3-7091-0885-7_1]
[6]
Betanzos A, Bañuelos C, Orozco E. Host invasion by pathogenic Amoebae: Epithelial disruption by parasite proteins. Genes (Basel) 2019; 10(8): 618.
[http://dx.doi.org/10.3390/genes10080618] [PMID: 31416298]
[7]
Lam C, Jamerson M, Cabral G, Carlesso AM, Marciano-Cabral F. Expression of matrix metalloproteinases in Naegleria fowleri and their role in invasion of the central nervous system. Microbiology 2017; 163(10): 1436-44.
[http://dx.doi.org/10.1099/mic.0.000537] [PMID: 28954644]
[8]
Zyserman I, Mondal D, Sarabia F, McKerrow JH, Roush WR, Debnath A. Identification of cysteine protease inhibitors as new drug leads against Naegleria fowleri. Exp Parasitol 2018; 188: 36-41.
[http://dx.doi.org/10.1016/j.exppara.2018.03.010] [PMID: 29551628]
[9]
Rascón AA Jr, McKerrow JH. Synthetic and natural protease inhibitors provide insights into parasite development, virulence and pathogenesis. Curr Med Chem 2013; 20(25): 3078-102.
[http://dx.doi.org/10.2174/0929867311320250005] [PMID: 23514418]
[10]
Monroy VS, Flores OM, García CG, Maya YC, Fernández TD, Pérez Ishiwara DG. Calpain-like: A Ca2+ dependent cystein protease in Entamoeba histolytica cell death. Exp Parasitol 2015; 159: 245-51.
[http://dx.doi.org/10.1016/j.exppara.2015.10.005] [PMID: 26496790]
[11]
Alam MN, Das P, De T, Chakraborti T. Identification and characterization of a Leishmania donovani serine protease inhibitor: Possible role in regulation of host serine proteases. Life Sci 2016; 144: 218-25.
[http://dx.doi.org/10.1016/j.lfs.2015.12.004] [PMID: 26656469]
[12]
Alves CR, Souza RS, Charret KDS, et al. Understanding serine proteases implications on Leishmania spp lifecycle. Exp Parasitol 2018; 184: 67-81.
[http://dx.doi.org/10.1016/j.exppara.2017.11.008] [PMID: 29175018]
[13]
Bossard G, Cuny G, Geiger A. Secreted proteases of Trypanosoma brucei gambiense: Possible targets for sleeping sickness control? Biofactors 2013; 39(4): 407-14.
[http://dx.doi.org/10.1002/biof.1100] [PMID: 23553721]
[14]
Korde R, Bhardwaj A, Singh R, et al. A prodomain peptide of Plasmodium falciparum cysteine protease (falcipain-2) inhibits malaria parasite development. J Med Chem 2008; 51(11): 3116-23.
[http://dx.doi.org/10.1021/jm070735f] [PMID: 18461922]
[15]
Tanveer A, Allen SM, Jackson KE, Charan M, Ralph SA, Habib S. An FtsH protease Is recruited to the mitochondrion of Plasmodium falciparum. PLoS One 2013; 8: 74408.
[http://dx.doi.org/10.1371/journal.pone.0074408]
[16]
Klemba M, Goldberg DE. Characterization of plasmepsin V, a membrane-bound aspartic protease homolog in the endoplasmic reticulum of Plasmodium falciparum. Mol Biochem Parasitol 2005; 143(2): 183-91.
[http://dx.doi.org/10.1016/j.molbiopara.2005.05.015] [PMID: 16024107]
[17]
Deu E, Leyva MJ, Albrow VE, Rice MJ, Ellman JA, Bogyo M. Functional studies of Plasmodium falciparum dipeptidyl aminopeptidase I using small molecule inhibitors and active site probes. Chem Biol 2010; 17(8): 808-19.
[http://dx.doi.org/10.1016/j.chembiol.2010.06.007] [PMID: 20797610]
[18]
Shehzad S, Pandey R, Malhotra P, Gupta D. Computational design of novel allosteric inhibitors for Plasmodium falciparum DegP. Molecules 2021; 26(9): 2742.
[http://dx.doi.org/10.3390/molecules26092742] [PMID: 34066964]
[19]
Gao B-J, Mou Y-N, Tong S-M, Ying S-H, Feng M-G. Subtilisin-like Pr1 proteases marking the evolution of pathogenicity in a wide-spectrum insect-pathogenic fungus. Virulence 2020; 11(1): 365-80.
[http://dx.doi.org/10.1080/21505594.2020.1749487] [PMID: 32253991]
[20]
Kajfasz JK, Martinez AR, Rivera-Ramos I, et al. Role of Clp proteins in expression of virulence properties of Streptococcus mutans. J Bacteriol 2009; 191(7): 2060-8.
[http://dx.doi.org/10.1128/JB.01609-08] [PMID: 19181818]
[21]
Ruiz-Perez F, Nataro JP. Bacterial serine proteases secreted by the autotransporter pathway: Classification, specificity, and role in virulence. Cell Mol Life Sci 2014; 71(5): 745-70.
[http://dx.doi.org/10.1007/s00018-013-1355-8] [PMID: 23689588]
[22]
Lee JH, Ancona V, Zhao Y. Lon protease modulates virulence traits in Erwinia amylovora by direct monitoring of major regulators and indirectly through the Rcs and Gac-Csr regulatory systems. Mol Plant Pathol 2018; 19(4): 827-40.
[http://dx.doi.org/10.1111/mpp.12566] [PMID: 28509355]
[23]
Bhattacharjee S, Stahelin RV, Haldar K. Host targeting of virulence determinants and phosphoinositides in blood stage malaria parasites. Trends Parasitol 2012; 28(12): 555-62.
[http://dx.doi.org/10.1016/j.pt.2012.09.004] [PMID: 23084821]
[24]
Sanman LE, Bogyo M. Activity-based profiling of proteases. Annu Rev Biochem 2014; 83(1): 249-73.
[http://dx.doi.org/10.1146/annurev-biochem-060713-035352] [PMID: 24905783]
[25]
Hauske P, Ottmann C, Meltzer M, Ehrmann M, Kaiser M. Allosteric regulation of proteases. ChemBioChem 2008; 9(18): 2920-8.
[http://dx.doi.org/10.1002/cbic.200800528] [PMID: 19021141]
[26]
Rawlings ND, Barrett AJ, Thomas PD, Huang X, Bateman A, Finn RD. The MEROPS database of proteolytic enzymes, their substrates and inhibitors in 2017 and a comparison with peptidases in the PANTHER database. Nucleic Acids Res 2018; 46(D1): D624-32.
[http://dx.doi.org/10.1093/nar/gkx1134] [PMID: 29145643]
[27]
Pérez-Silva JG, Español Y, Velasco G, Quesada V. The Degradome database: Expanding roles of mammalian proteases in life and disease. Nucleic Acids Res 2016; 44(D1): D351-5.
[http://dx.doi.org/10.1093/nar/gkv1201] [PMID: 26553809]
[28]
Deu E. Proteases as antimalarial targets: Strategies for genetic, chemical, and therapeutic validation. FEBS J 2017; 284(16): 2604-28.
[http://dx.doi.org/10.1111/febs.14130] [PMID: 28599096]
[29]
Warrenfeltz S, Basenko EY, Crouch K, et al. EuPathDB: The Eukaryotic Pathogen Genomics Database Resource Eukaryotic Genomic Databases. New York, NY: Springer New York 2018. http://link.springer.com/10.1007/978-1-4939-7737-6_5
[30]
UniProt. The universal protein knowledgebase. Nucleic Acids Res 2017; 45(D1): D158-69.
[http://dx.doi.org/10.1093/nar/gkw1099] [PMID: 27899622]
[31]
Marchler-Bauer A, Lu S, Anderson JB, et al. CDD: A conserved domain database for the functional annotation of proteins Nucleic Acids Res 2011; 39(DATABASE): 225-9.
[http://dx.doi.org/10.1093/nar/gkq1189]
[32]
Quevillon E, Silventoinen V, Pillai S, et al. InterProScan: Protein domains identifier. Nucleic Acids Res 2005; 33(WEB SERVER): 116-20.
[http://dx.doi.org/10.1093/nar/gki442]
[33]
Agbowuro AA, Huston WM, Gamble AB, Tyndall JDA. Proteases and protease inhibitors in infectious diseases. Med Res Rev 2018; 38(4): 1295-331.
[http://dx.doi.org/10.1002/med.21475] [PMID: 29149530]
[34]
Li L, Stoeckert CJ Jr, Roos DS. OrthoMCL: Identification of ortholog groups for eukaryotic genomes. Genome Res 2003; 13(9): 2178-89.
[http://dx.doi.org/10.1101/gr.1224503] [PMID: 12952885]
[35]
Petersen TN, Brunak S, von Heijne G, Nielsen H. SignalP 4.0: Discriminating signal peptides from transmembrane regions. Nat Methods 2011; 8(10): 785-6.
[http://dx.doi.org/10.1038/nmeth.1701] [PMID: 21959131]
[36]
Predicting Subcellular Localization of Proteins Based on their Nterminal Amino Acid Sequence | Elsevier Enhanced Reader. 2011; 12.
[37]
Claros’ MG, Vincens P. Molkculaire L de Gc, Ura C. Computational method to predict mitochondri and their targeting sequences. Eur J Biochem 1996; 241(3): 779-86.
[38]
Duckert P, Brunak S, Blom N. Prediction of proprotein convertase cleavage sites. Protein Eng Des Sel 2004; 17(1): 107-12.
[http://dx.doi.org/10.1093/protein/gzh013] [PMID: 14985543]
[39]
Jacobson MP, Friesner RA, Xiang Z, Honig B. On the role of the crystal environment in determining protein side-chain conformations. J Mol Biol 2002; 320(3): 597-608.
[http://dx.doi.org/10.1016/S0022-2836(02)00470-9] [PMID: 12096912]
[40]
Jacobson MP, Pincus DL, Rapp CS, et al. A hierarchical approach to all-atom protein loop prediction. Proteins 2004; 55(2): 351-67.
[http://dx.doi.org/10.1002/prot.10613] [PMID: 15048827]
[41]
Halgren T. New method for fast and accurate binding-site identification and analysis. Chem Biol Drug Des 2007; 69(2): 146-8.
[http://dx.doi.org/10.1111/j.1747-0285.2007.00483.x] [PMID: 17381729]
[42]
Halgren TA. Identifying and characterizing binding sites and assessing drug ability. J Chem Inf Model 2009; 49(2): 377-89.
[http://dx.doi.org/10.1021/ci800324m] [PMID: 19434839]
[43]
Steentoft C, Vakhrushev SY, Joshi HJ, et al. Precision mapping of the human O-GalNAc glycoproteome through SimpleCell technology. EMBO J 2013; 32(10): 1478-88.
[http://dx.doi.org/10.1038/emboj.2013.79] [PMID: 23584533]
[44]
Gupta R, Brunak S. Prediction of glycosylation across the human proteome and the correlation to protein function. Pac Symp Biocomput 2002; 13: 310-22.
[45]
Blom N, Gammeltoft S, Brunak S. Sequence and structure-based prediction of eukaryotic protein phosphorylation sites. J Mol Biol 1999; 294(5): 1351-62.
[46]
Kumar TA. locBLAST v2.0 - an improved PHP library for embedding standalone NCBI BLAST+ program to an interactive graphical user interface. bioRxiv 2019.
[http://dx.doi.org/10.1101/556225]
[47]
Rawlings ND, Barrett AJ. Evolutionary families of peptidases. Biochem J 1993; 290(Pt 1): 205-18.
[http://dx.doi.org/10.1042/bj2900205] [PMID: 8439290]
[48]
Chen J-M, Rawlings ND, Stevens RAE, Barrett AJ. Identification of the active site of legumain links it to caspases, clostripain and gingipains in a new clan of cysteine endopeptidases. FEBS Lett 1998; 441(3): 361-5.
[49]
Turk D. Gunčar G, Podobnik M, Turk B. Revised definition of substrate binding sites of papain-like cysteine proteases. Biol Chem 1998; 379(2): 137-47.https://www.degruyter.com/document/doi/10.1515/bchm.1998.379.2.137/html
[http://dx.doi.org/10.1515/bchm.1998.379.2.137] [PMID: 9524065]
[50]
Hong L, Tang J. Flap position of free memapsin 2 (β-secretase), a model for flap opening in aspartic protease catalysis. Biochemistry 2004; 43(16): 4689-95.
[http://dx.doi.org/10.1021/bi0498252] [PMID: 15096037]
[51]
Fastrezx J, Fersht AR. Demonstration of the acyl-enzyme mechanism for the hydrolysis of peptides and anilides by chymotrypsint. Biochemistry 1973; 12(11): 2025-34.
[52]
Rao MB, Tanksale AM, Ghatge MS, Deshpande VV. Molecular and biotechnological aspects of microbial proteases. Microbiol Mol Biol Rev 1998; 62(3): 597-635.
[http://dx.doi.org/10.1128/MMBR.62.3.597-635.1998] [PMID: 9729602]
[53]
SeemOller E. Lupas A, Stock D, Lowe J, Huber R, Baumeister W. Proteasome from Thermoplasma acidophilum: A threonine proteas. Science 1995; 268(5210): 579-82.
[54]
Almagro Armenteros JJ, Tsirigos KD, Sønderby CK, et al. SignalP 5.0 improves signal peptide predictions using deep neural networks. Nat Biotechnol 2019; 37(4): 420-3.
[http://dx.doi.org/10.1038/s41587-019-0036-z] [PMID: 30778233]
[55]
Almagro Armenteros JJ, Salvatore M, Emanuelsson O, et al. Detecting sequence signals in targeting peptides using deep learning. Life Sci Alliance 2019; 2(5): e201900429.
[http://dx.doi.org/10.26508/lsa.201900429] [PMID: 31570514]
[56]
Bhuiyan MS, Fukunaga K. Activation of HtrA2, a mitochondrial serine protease mediates apoptosis: Current knowledge on HtrA2 mediated myocardial ischemia/reperfusion injury. Cardiovasc Ther 2008; 26(3): 224-32.
[http://dx.doi.org/10.1111/j.1755-5922.2008.00052.x] [PMID: 18786092]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version668msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:52:26] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:52:26] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:52:26] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:52:26] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (285ms)time
  • Application (383ms)time
  • 1 x Application (57.35%)
    383ms
    1 x Booting (42.65%)
    285ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    36 statements were executed, 4 of which were duplicates, 32 unique. Show only duplicated221ms
    • 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 ('60060432','',1,1740775946,1740775946) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740775946
      1.37msalphaeurekaselec_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 ('60060432','/article/123263',1,1740775946,1740775946)
      510μ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 >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) 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 >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) 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 >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) 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 >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) 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 >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) 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 >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 60060432 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60060432) limit 1
      21.72msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 60060432
      • 1: 60060432
      • 2: 60060432
      • 3: 60060432
      • 4: 60060432
      • 5: 60060432
      • 6: 60060432
      • 7: 60060432
      • 8: 60060432
      • 9: 60060432
      • 10: 60060432
      • 11: 60060432
      • 12: 60060432
      • 13: 60060432
      • 14: 60060432
      • 15: 60060432
      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=123263
      1.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` = 65 limit 1
      1.05msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 65
      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=65) and sj.journal_id!=65 group by `j`.`nid`) as `aggregate_table`
      1.03msalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=65) and sj.journal_id!=65 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      920μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=65) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      4.28msalphaeurekaselec_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=65) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      3.82msalphaeurekaselec_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` = '123263'
      12.8msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 123263
      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` = '123263'
      4.17msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 123263
      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` = '123263' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.54msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 123263
      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
      440μ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
      780μ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 = 65 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      70.79msalphaeurekaselec_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 = 65 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      13.29msalphaeurekaselec_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 = 65 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      9.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` = 123263 limit 1
      1.42msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 123263
      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 = 123263 and content_type = 'article' order by status desc limit 1
      380μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 204474 limit 1
      310μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 204474
      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
      340μ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` = 'CBIO' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      410μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CBIO
      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 = '123263' 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) )
      560μ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 = '11907' 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) )
      470μ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 = '3263' 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) )
      440μ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 <= 60060432 and j.to_ip >=60060432 )) and ((j.from_date <= 1740775946 and j.to_date >= 1740775946 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3263) 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 <= 60060432 and j.to_ip >=60060432 )) and ((j.from_date <= 1740775946 and j.to_date >= 1740775946 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3263) 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 <= 60060432 and j.to_ip >=60060432 )) and ((j.from_date <= 1740775946 and j.to_date >= 1740775946 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3263)
      29.44msalphaeurekaselec_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 <= 60060432 and j.to_ip >=60060432 )) and ((j.from_date <= 1740775946 and j.to_date >= 1740775946 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11907) 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 <= 60060432 and j.to_ip >=60060432 )) and ((j.from_date <= 1740775946 and j.to_date >= 1740775946 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11907) 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 <= 60060432 and j.to_ip >=60060432 )) and ((j.from_date <= 1740775946 and j.to_date >= 1740775946 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11907)
      12.68msalphaeurekaselec_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 <= 60060432 and j.to_ip >=60060432 )) and ((j.from_date <= 1740775946 and j.to_date >= 1740775946 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 123263) 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 <= 60060432 and j.to_ip >=60060432 )) and ((j.from_date <= 1740775946 and j.to_date >= 1740775946 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 123263) 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 <= 60060432 and j.to_ip >=60060432 )) and ((j.from_date <= 1740775946 and j.to_date >= 1740775946 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 123263)
      2.04msalphaeurekaselec_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` < '710' and is_uploaded = 1 and issue_id = 11907 order by cast(first_page as SIGNED) desc limit 1
      2.98msalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 710
      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` > '722' and is_uploaded = 1 and issue_id = 11907 order by cast(first_page as SIGNED) asc limit 1
      9.85msalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 722
      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'
      340μ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
      330μ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` = 123263 limit 1
      4.01msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 123263
      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` = 65 and `b`.`banner_from_date` <= 1740775946 and `b`.`banner_to_date` >= 1740775946 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.63msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 65
      • 3: 1740775946
      • 4: 1740775946
      • 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` = 65 and `b`.`banner_from_date` <= 1740775946 and `b`.`banner_to_date` >= 1740775946 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.64msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 65
      • 3: 1740775946
      • 4: 1740775946
      • 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='d10f564ee99b3680480d383ad6876203'
      330μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:291
      • 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
        LRxgsZ1OTTrmG700shAJ92xzjlkYy9PrQjBCikPl
        uc_cart_id
        d10f564ee99b3680480d383ad6876203
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/123263" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/123263
        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 => "Fri, 28 Feb 2025 20:52:26 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ilc4WTNvdmYvb21oZkg2RjhacWp1aXc9PSIsInZhbHVlIjoiNjhiclA2QThZTTJqVDR6Y3ZNelZzeEtoemx4VndTRGpBOXIxYTVoaHZMY0UwKzQ0UjNnUk9uS041UmVKZ2NmTGZjNDIzczkzWUJpS0swUnVZbmVhNklWWHg0cEozb1RCQlZNL1gyWDI5ajJJejhMSEt5Sk9yYnhhL0JzYmV1bS8iLCJtYWMiOiI0NjZhZTgwMjc3OWExZjZkOWQ2YzcwNWM0ZDYxYzY5YzMzZDUwNjhkMDE4NWQ2ODYyMjFmOWQxMTViMTY4ZDBmIiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 08:52:26 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ilc4WTNvdmYvb21oZkg2RjhacWp1aXc9PSIsInZhbHVlIjoiNjhiclA2QThZTTJqVDR6Y3ZNelZzeEtoemx4VndTRGpBOXIxYTVoaHZMY0UwKzQ0UjNnUk9uS041UmVKZ2NmTGZjNDIzc" 1 => "alphaeurekaselectnet_session=eyJpdiI6Imk4VlloWE1GVEZhZ2QxVk0rYm02bXc9PSIsInZhbHVlIjoiank1eVN4anhydFloMTZXdCtBVFkvK25Jc1RBS2NBcGZ5ZFZLN1BycCtkTVh1Ukl0Tk1tQ1lKSWEwenV6b0xIUk5oRXpQSDNHQjZtVjBOV2RyUXNVdjFqSi9Rc3M0YnZ4WGZSRENiMXFFTUMybnBCRlNEalYvZTd3YVRNOStsN1ciLCJtYWMiOiI0ZjM5NTZhMzZhZTYyYmRkMjhlMmY2MmY0MjJjYzBlY2ViOTZkN2RjNGUwMGFiNDkxZWVlOGExY2EyMjE5NjQ1IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Imk4VlloWE1GVEZhZ2QxVk0rYm02bXc9PSIsInZhbHVlIjoiank1eVN4anhydFloMTZXdCtBVFkvK25Jc1RBS2NBcGZ5ZFZLN1BycCtkTVh1Ukl0Tk1tQ1lKSWE" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ilc4WTNvdmYvb21oZkg2RjhacWp1aXc9PSIsInZhbHVlIjoiNjhiclA2QThZTTJqVDR6Y3ZNelZzeEtoemx4VndTRGpBOXIxYTVoaHZMY0UwKzQ0UjNnUk9uS041UmVKZ2NmTGZjNDIzczkzWUJpS0swUnVZbmVhNklWWHg0cEozb1RCQlZNL1gyWDI5ajJJejhMSEt5Sk9yYnhhL0JzYmV1bS8iLCJtYWMiOiI0NjZhZTgwMjc3OWExZjZkOWQ2YzcwNWM0ZDYxYzY5YzMzZDUwNjhkMDE4NWQ2ODYyMjFmOWQxMTViMTY4ZDBmIiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 08:52:26 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ilc4WTNvdmYvb21oZkg2RjhacWp1aXc9PSIsInZhbHVlIjoiNjhiclA2QThZTTJqVDR6Y3ZNelZzeEtoemx4VndTRGpBOXIxYTVoaHZMY0UwKzQ0UjNnUk9uS041UmVKZ2NmTGZjNDIzc" 1 => "alphaeurekaselectnet_session=eyJpdiI6Imk4VlloWE1GVEZhZ2QxVk0rYm02bXc9PSIsInZhbHVlIjoiank1eVN4anhydFloMTZXdCtBVFkvK25Jc1RBS2NBcGZ5ZFZLN1BycCtkTVh1Ukl0Tk1tQ1lKSWEwenV6b0xIUk5oRXpQSDNHQjZtVjBOV2RyUXNVdjFqSi9Rc3M0YnZ4WGZSRENiMXFFTUMybnBCRlNEalYvZTd3YVRNOStsN1ciLCJtYWMiOiI0ZjM5NTZhMzZhZTYyYmRkMjhlMmY2MmY0MjJjYzBlY2ViOTZkN2RjNGUwMGFiNDkxZWVlOGExY2EyMjE5NjQ1IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Imk4VlloWE1GVEZhZ2QxVk0rYm02bXc9PSIsInZhbHVlIjoiank1eVN4anhydFloMTZXdCtBVFkvK25Jc1RBS2NBcGZ5ZFZLN1BycCtkTVh1Ukl0Tk1tQ1lKSWE" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "LRxgsZ1OTTrmG700shAJ92xzjlkYy9PrQjBCikPl" "uc_cart_id" => "d10f564ee99b3680480d383ad6876203" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/123263" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 20:52:26GET/article/123263414361