Generic placeholder image

Current Bioinformatics

Editor-in-Chief

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

Research Article

Characterization, Potential Prognostic Value, and Immune Heterogeneity of Cathepsin C in Diffuse Glioma

Author(s): Quanwei Zhou, Shasha Li, Xuejun Yan, Hecheng Zhu, Weidong Liu, Youwei Guo, Hongjuan Xu, Wen Yin, Xuewen Li, Qian Yang, Hui Liu*, Xingjun Jiang* and Caiping Ren*

Volume 18, Issue 1, 2023

Published on: 23 December, 2022

Page: [76 - 91] Pages: 16

DOI: 10.2174/1574893618666221101144857

Price: $65

Abstract

Background: Diffuse glioma is the most frequent intracranial tumor and remains universally lethal. Prognostic biomarkers have remained a focus in diffuse glioma during the last decades. More reliable predictors to adequately characterize the prognosis of diffuse glioma are essential. Cathepsin C (CTSC), a lysosomal cysteine protease, is an essential component of the lysosomal hydrolase family, with their potential roles in diffuse glioma remaining to be characterized.

Objective: We aimed to investigate the performance of CTSC in predicting prognosis and therapeutic targets in diffuse glioma.

Methods: The expression profile of CTSC in multiple tumors and more than 2000 glioma samples with corresponding clinical data were collected through authoritative public databases. The expression level of CTSC was evaluated by qPCR and IHC. The prognostic value of CTSC was assessed using the univariate and multivariate cox regression analysis. The ESTIMATE R package was used to evaluate the immune and stromal scores based on the gene expression profile. The CIBERSORT was applied to evaluate the relative levels of 22 immune cell subtypes by using the R package 'CIBERSORT' to define the cell composition of tumor tissues. In addition, the MCP counter was used to assess the absolute abundance of neutrophils.

Results/Discussion: CTSC was aberrantly expressed and significantly correlated with clinical outcomes in multiple tumors. CTSC was heterogeneously expressed across histologic types and tumor grades for diffuse glioma and highly enriched in IDH or IDH1-wildtype glioma. CTSC was positively associated with immune and stromal scores and infiltrating levels of M2 macrophages and neutrophils and negatively associated with infiltrating levels of NK cells. Additionally, CTSC was closely correlated with some immune checkpoint molecules, including CD276, CD80, CD86 and PD-L2.

Conclusion: CTSC was involved in shaping the immunosuppressive microenvironment and acted as an independent indicator of a poor prognosis in diffuse glioma. Targeting CTSC for glioma therapies might provide promising prospects.

« Previous
Graphical Abstract

[1]
Aldape K, Amin SB, Ashley DM, et al. Glioma through the looking glass: Molecular evolution of diffuse gliomas and the glioma longitudinal analysis consortium. Neuro-oncol 2018; 20(7): 873-84.
[http://dx.doi.org/10.1093/neuonc/noy020] [PMID: 29432615]
[2]
Claes A, Idema AJ, Wesseling P. Diffuse glioma growth: A guerilla war. Acta Neuropathol 2007; 114(5): 443-58.
[http://dx.doi.org/10.1007/s00401-007-0293-7] [PMID: 17805551]
[3]
Zhou Q, Yan X, Liu W, et al. Three immune-associated subtypes of diffuse glioma differ in immune infiltration, immune checkpoint molecules, and prognosis. Front Oncol 2020; 10586019
[http://dx.doi.org/10.3389/fonc.2020.586019] [PMID: 33425739]
[4]
Friebel E, Kapolou K, Unger S, et al. Single-cell mapping of human brain cancer reveals tumor-specific instruction of tissue-invading leukocytes. Cell 2020; 181(7): 1626-1642.e20.
[http://dx.doi.org/10.1016/j.cell.2020.04.055] [PMID: 32470397]
[5]
Quail DF, Joyce JA. The microenvironmental landscape of brain tumors. Cancer Cell 2017; 31(3): 326-41.
[http://dx.doi.org/10.1016/j.ccell.2017.02.009] [PMID: 28292436]
[6]
Graeber MB, Scheithauer BW, Kreutzberg GW. Microglia in brain tumors. Glia 2002; 40(2): 252-9.
[http://dx.doi.org/10.1002/glia.10147] [PMID: 12379912]
[7]
Hambardzumyan D, Gutmann DH, Kettenmann H. The role of microglia and macrophages in glioma maintenance and progression. Nat Neurosci 2016; 19(1): 20-7.
[http://dx.doi.org/10.1038/nn.4185] [PMID: 26713745]
[8]
Komohara Y, Ohnishi K, Kuratsu J, Takeya M. Possible involvement of the M2 anti-inflammatory macrophage phenotype in growth of human gliomas. J Pathol 2008; 216(1): 15-24.
[http://dx.doi.org/10.1002/path.2370] [PMID: 18553315]
[9]
Majety M, Runza V, Lehmann C, Hoves S, Ries CH. A drug development perspective on targeting tumor-associated myeloid cells. FEBS J 2018; 285(4): 763-76.
[http://dx.doi.org/10.1111/febs.14277] [PMID: 28941174]
[10]
Weiskopf K. Cancer immunotherapy targeting the CD47/SIRPα axis. Eur J Cancer 2017; 76: 100-9.
[http://dx.doi.org/10.1016/j.ejca.2017.02.013] [PMID: 28286286]
[11]
Hussain SF, Yang D, Suki D, Aldape K, Grimm E, Heimberger AB. The role of human glioma-infiltrating microglia/macrophages in mediating antitumor immune responses1. Neuro-oncol 2006; 8(3): 261-79.
[http://dx.doi.org/10.1215/15228517-2006-008] [PMID: 16775224]
[12]
Fossati G, Ricevuti G, Edwards SW, Walker C, Dalton A, Rossi ML. Neutrophil infiltration into human gliomas. Acta Neuropathol 1999; 98(4): 349-54.
[http://dx.doi.org/10.1007/s004010051093] [PMID: 10502039]
[13]
Joice SL, Mydeen F, Couraud PO, et al. Modulation of blood–brain barrier permeability by neutrophils: In vitro and in vivo studies. Brain Res 2009; 1298: 13-23.
[http://dx.doi.org/10.1016/j.brainres.2009.08.076] [PMID: 19728990]
[14]
Yee PP, Wei Y, Kim SY, et al. Neutrophil-induced ferroptosis promotes tumor necrosis in glioblastoma progression. Nat Commun 2020; 11(1): 5424.
[http://dx.doi.org/10.1038/s41467-020-19193-y] [PMID: 33110073]
[15]
Postma TJ, Heimans JJ, Luykx SA, et al. A phase II study of paclitaxel in chemonaïve patients with recurrent high-grade glioma. Ann Oncol 2000; 11(4): 409-13.
[http://dx.doi.org/10.1023/A:1008376123066] [PMID: 10847458]
[16]
Adkison AM, Raptis SZ, Kelley DG, Pham CTN. Dipeptidyl peptidase I activates neutrophil-derived serine proteases and regulates the development of acute experimental arthritis. J Clin Invest 2002; 109(3): 363-71.
[http://dx.doi.org/10.1172/JCI0213462] [PMID: 11827996]
[17]
Korkmaz B, Caughey GH, Chapple I, et al. Therapeutic targeting of cathepsin C: From pathophysiology to treatment. Pharmacol Ther 2018; 190: 202-36.
[http://dx.doi.org/10.1016/j.pharmthera.2018.05.011] [PMID: 29842917]
[18]
Pham CTN, Ley TJ. Dipeptidyl peptidase I is required for the processing and activation of granzymes A and B in vivo. Proc Natl Acad Sci USA 1999; 96(15): 8627-32.
[http://dx.doi.org/10.1073/pnas.96.15.8627] [PMID: 10411926]
[19]
Pham CTN, Ivanovich JL, Raptis SZ, Zehnbauer B, Ley TJ. Papillon-Lefèvre syndrome: Correlating the molecular, cellular, and clinical consequences of cathepsin C/dipeptidyl peptidase I deficiency in humans. J Immunol 2004; 173(12): 7277-81.
[http://dx.doi.org/10.4049/jimmunol.173.12.7277] [PMID: 15585850]
[20]
Hart TC, Hart PS, Michalec MD, et al. Haim-Munk syndrome and papillon-lefevre syndrome are allelic mutations in cathepsin C. J Med Genet 2000; 37(2): 88-94.
[http://dx.doi.org/10.1136/jmg.37.2.88] [PMID: 10662807]
[21]
Andoniou CE, Fleming P, Sutton VR, Trapani JA, Degli-Esposti MA. Cathepsin C limits acute viral infection independently of NK cell and CD8 + T-cell cytolytic function. Immunol Cell Biol 2011; 89(4): 540-8.
[http://dx.doi.org/10.1038/icb.2010.115] [PMID: 20975734]
[22]
Korkmaz B, Lesner A, Letast S, et al. Neutrophil proteinase 3 and dipeptidyl peptidase I (cathepsin C) as pharmacological targets in granulomatosis with polyangiitis (Wegener granulomatosis). Semin Immunopathol 2013; 35(4): 411-21.
[http://dx.doi.org/10.1007/s00281-013-0362-z] [PMID: 23385856]
[23]
Hamon Y, Legowska M, Hervé V, et al. Neutrophilic cathepsin C Is maturated by a multistep proteolytic process and secreted by activated cells during inflammatory lung diseases. J Biol Chem 2016; 291(16): 8486-99.
[http://dx.doi.org/10.1074/jbc.M115.707109] [PMID: 26884336]
[24]
Xiao Y, Cong M, Li J, et al. Cathepsin C promotes breast cancer lung metastasis by modulating neutrophil infiltration and neutrophil extracellular trap formation. Cancer Cell 2021; 39(3): 423-437.e7.
[http://dx.doi.org/10.1016/j.ccell.2020.12.012] [PMID: 33450198]
[25]
Khaket TP, Singh MP, Khan I, Bhardwaj M, Kang SC. Targeting of cathepsin C induces autophagic dysregulation that directs ER stress mediated cellular cytotoxicity in colorectal cancer cells. Cell Signal 2018; 46: 92-102.
[http://dx.doi.org/10.1016/j.cellsig.2018.02.017] [PMID: 29501728]
[26]
Zhang GP, Yue X, Li SQ, Cathepsin C. Cathepsin C interacts with TNF-α/p38 MAPK signaling pathway to promote proliferation and metastasis in hepatocellular carcinoma. Cancer Res Treat 2020; 52(1): 10-23.
[http://dx.doi.org/10.4143/crt.2019.145] [PMID: 31048666]
[27]
Jewett A, Cacalano NA, Teruel A, et al. Inhibition of nuclear factor kappa B (NFκB) activity in oral tumor cells prevents depletion of NK cells and increases their functional activation. Cancer Immunol Immunother 2006; 55(9): 1052-63.
[http://dx.doi.org/10.1007/s00262-005-0093-7] [PMID: 16328384]
[28]
Yan X, Zhou Q, Zhu H, et al. The clinical features, prognostic significance, and immune heterogeneity of CD37 in diffuse gliomas. iScience 2021; 24(11): 103249.
[http://dx.doi.org/10.1016/j.isci.2021.103249] [PMID: 34755091]
[29]
Subramanian A, Tamayo P, Mootha VK, et al. Gene set enrichment analysis: A knowledge-based approach for interpreting genome-wide expression profiles. Proc Natl Acad Sci USA 2005; 102(43): 15545-50.
[http://dx.doi.org/10.1073/pnas.0506580102] [PMID: 16199517]
[30]
Yu G, Wang LG, Han Y, He QY. clusterProfiler: An R package for comparing biological themes among gene clusters. OMICS 2012; 16(5): 284-7.
[http://dx.doi.org/10.1089/omi.2011.0118] [PMID: 22455463]
[31]
Yoshihara K, Shahmoradgoli M, Martínez E, et al. Inferring tumour purity and stromal and immune cell admixture from expression data. Nat Commun 2013; 4(1): 2612.
[http://dx.doi.org/10.1038/ncomms3612] [PMID: 24113773]
[32]
Newman AM, Liu CL, Green MR, et al. Robust enumeration of cell subsets from tissue expression profiles. Nat Methods 2015; 12(5): 453-7.
[http://dx.doi.org/10.1038/nmeth.3337] [PMID: 25822800]
[33]
Becht E, Giraldo NA, Lacroix L, et al. Estimating the population abundance of tissue-infiltrating immune and stromal cell populations using gene expression. Genome Biol 2016; 17(1): 218.
[http://dx.doi.org/10.1186/s13059-016-1070-5] [PMID: 27765066]
[34]
Ma Q, Long W, Xing C, et al. Cancer stem cells and immunosuppressive microenvironment in glioma. Front Immunol 2018; 9: 2924.
[http://dx.doi.org/10.3389/fimmu.2018.02924] [PMID: 30619286]
[35]
Ribas A, Wolchok JD. Cancer immunotherapy using checkpoint blockade. Science 2018; 359(6382): 1350-5.
[http://dx.doi.org/10.1126/science.aar4060] [PMID: 29567705]
[36]
Feng E, Liang T, Wang X, et al. Correlation of alteration of HLA-F expression and clinical characterization in 593 brain glioma samples. J Neuroinflammation 2019; 16(1): 33.
[http://dx.doi.org/10.1186/s12974-019-1418-3] [PMID: 30755240]
[37]
Zhang C, Cheng W, Ren X, et al. Tumor purity as an underlying key factor in glioma. Clin Cancer Res 2017; 23(20): 6279-91.
[http://dx.doi.org/10.1158/1078-0432.CCR-16-2598] [PMID: 28754819]
[38]
Balkwill F. Tumour necrosis factor and cancer. Nat Rev Cancer 2009; 9(5): 361-71.
[http://dx.doi.org/10.1038/nrc2628] [PMID: 19343034]
[39]
Voronov E, Apte RN. IL-1 in colon inflammation, colon carcinogenesis and invasiveness of colon cancer. Cancer Microenviron 2015; 8(3): 187-200.
[http://dx.doi.org/10.1007/s12307-015-0177-7] [PMID: 26686225]
[40]
Wright HL, Chikura B, Bucknall RC, Moots RJ, Edwards SW. Changes in expression of membrane TNF, NF-κB activation and neutrophil apoptosis during active and resolved inflammation. Ann Rheum Dis 2011; 70(3): 537-43.
[http://dx.doi.org/10.1136/ard.2010.138065] [PMID: 21109521]
[41]
Han S, Liu Y, Li Q, Li Z, Hou H, Wu A. Pre-treatment neutrophil-to-lymphocyte ratio is associated with neutrophil and T-cell infiltration and predicts clinical outcome in patients with glioblastoma. BMC Cancer 2015; 15(1): 617.
[http://dx.doi.org/10.1186/s12885-015-1629-7] [PMID: 26341881]
[42]
Hagemann T, Lawrence T, McNeish I, et al. “Re-educating” tumor-associated macrophages by targeting NF-κB. J Exp Med 2008; 205(6): 1261-8.
[http://dx.doi.org/10.1084/jem.20080108] [PMID: 18490490]
[43]
Huang C, Bi E, Hu Y, et al. A novel NF-kappaB binding site controls human granzyme B gene transcription. J Immunol 2006; 176(7): 4173-81.
[http://dx.doi.org/10.4049/jimmunol.176.7.4173] [PMID: 16547254]
[44]
Xiao G, Zhang X, Zhang X, et al. Aging-related genes are potential prognostic biomarkers for patients with gliomas. Aging (Albany NY) 2021; 13(9): 13239-63.
[http://dx.doi.org/10.18632/aging.203008] [PMID: 33946049]
[45]
Taniguchi K, Karin M. IL-6 and related cytokines as the critical lynchpins between inflammation and cancer. Semin Immunol 2014; 26(1): 54-74.
[http://dx.doi.org/10.1016/j.smim.2014.01.001] [PMID: 24552665]
[46]
Grivennikov SI, Karin M. Inflammatory cytokines in cancer: Tumour necrosis factor and interleukin 6 take the stage. Ann Rheum Dis 2011; 70 (Suppl. 1): i104-8.
[http://dx.doi.org/10.1136/ard.2010.140145] [PMID: 21339211]
[47]
Huang J, Liu F, Liu Z, et al. Immune checkpoint in glioblastoma: Promising and challenging. Front Pharmacol 2017; 8: 242.
[http://dx.doi.org/10.3389/fphar.2017.00242] [PMID: 28536525]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version1.08sRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:26:47] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:26:48] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:26:48] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:26:48] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (245ms)time
  • Application (832ms)time
  • 1 x Application (77.28%)
    832ms
    1 x Booting (22.72%)
    245ms
    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 duplicated658ms
    • 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 ('314383442','',1,1740774407,1740774407) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740774407
      2.63msalphaeurekaselec_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 ('314383442','/article/127325',1,1740774407,1740774407)
      16.02msalphaeurekaselec_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 >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) 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 >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) 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 >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) 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 >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) 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 >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) 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 >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) limit 1
      39.35msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314383442
      • 1: 314383442
      • 2: 314383442
      • 3: 314383442
      • 4: 314383442
      • 5: 314383442
      • 6: 314383442
      • 7: 314383442
      • 8: 314383442
      • 9: 314383442
      • 10: 314383442
      • 11: 314383442
      • 12: 314383442
      • 13: 314383442
      • 14: 314383442
      • 15: 314383442
      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=127325
      1.43msalphaeurekaselec_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.88msalphaeurekaselec_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.32msalphaeurekaselec_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
      7.62msalphaeurekaselec_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
      16.8msalphaeurekaselec_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` = '127325'
      320μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 127325
      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` = '127325'
      53.6msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 127325
      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` = '127325' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      8.9msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 127325
      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
      730μ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
      151msalphaeurekaselec_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
      58.48msalphaeurekaselec_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
      87.57msalphaeurekaselec_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` = 127325 limit 1
      280μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 127325
      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 = 127325 and content_type = 'article' order by status desc limit 1
      370μ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` = 210546 limit 1
      2.49msalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 210546
      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
      350μ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
      470μ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 = '127325' 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) )
      5.43msalphaeurekaselec_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 = '12252' 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) )
      510μ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 = '3373' 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) )
      480μ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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740774408 and j.to_date >= 1740774408 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3373) 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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740774408 and j.to_date >= 1740774408 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3373) 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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740774408 and j.to_date >= 1740774408 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3373)
      152msalphaeurekaselec_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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740774408 and j.to_date >= 1740774408 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12252) 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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740774408 and j.to_date >= 1740774408 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12252) 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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740774408 and j.to_date >= 1740774408 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12252)
      880μ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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740774408 and j.to_date >= 1740774408 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 127325) 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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740774408 and j.to_date >= 1740774408 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 127325) 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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740774408 and j.to_date >= 1740774408 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 127325)
      960μ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` < '76' and is_uploaded = 1 and issue_id = 12252 order by cast(first_page as SIGNED) desc limit 1
      1.48msalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 76
      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` > '91' and is_uploaded = 1 and issue_id = 12252 order by cast(first_page as SIGNED) asc limit 1
      13.96msalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 91
      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'
      250μ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
      3.43msalphaeurekaselec_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` = 127325 limit 1
      3.93msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 127325
      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` <= 1740774408 and `b`.`banner_to_date` >= 1740774408 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      7.49msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 65
      • 3: 1740774408
      • 4: 1740774408
      • 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` <= 1740774408 and `b`.`banner_to_date` >= 1740774408 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      9.09msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 65
      • 3: 1740774408
      • 4: 1740774408
      • 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='210867d801339c7f5d1af2e114012204'
      1.88msalphaeurekaselec_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
        G845RYmQGsExH8V6iWtGGIwKCQ0Jxkf2RYHeYRIt
        uc_cart_id
        210867d801339c7f5d1af2e114012204
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/127325" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/127325
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:9 [ "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6IjBIRUJhVGR3YnNpYW0vbldWMkJON0E9PSIsInZhbHVlIjoiOWc2N2pNUzVGNWU3T3JUWW5rQ1dINzUrOEoxMy81TXprdFVlOS9lbVFERT0iLCJtYWMiOiI3NzU4YzliMGMwZTkxMmI1NTNiYmVlZGI1M2ViMWI5MzZiODFmYmRiZTRiMzczZmNmMGYxZmI2MTEzNTExNzZiIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IjBIRUJhVGR3YnNpYW0vbldWMkJON0E9PSIsInZhbHVlIjoiOWc2N2pNUzVGNWU3T3JUWW5rQ1dINzUrOEoxMy81TXprdFVlOS9lbVFERT0iLCJtYWMiOiI3NzU4YzliMGMwZTkx" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 28 Feb 2025 20:26:48 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImZERm9xclBjaW1VTk90Q2hrZXlsVVE9PSIsInZhbHVlIjoibUpQdmpLWTZvUjFFdDlqUFJobXI4QjM5RUxpeWtQS0V6WWFSVFpORFVjL3JSSVg4c2UzbXkzYnA1MkhnRzltMytRN1B2d043WkJETnZNVWNucG5odEdOMTdqQjZPS0RSZFRhbHpTbm9SSmNpVm5IbUNRSmpzUE13RFI0WTNJc0siLCJtYWMiOiI3ZWVmZGEwMzMxZTIwMGE2NzlkOTJmOWQyMTUzNjI0NmI2YjZiZmRiNTBmMjA2YWI3NTI3YzMzNmZkOGU5NDVmIiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 08:26:48 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImZERm9xclBjaW1VTk90Q2hrZXlsVVE9PSIsInZhbHVlIjoibUpQdmpLWTZvUjFFdDlqUFJobXI4QjM5RUxpeWtQS0V6WWFSVFpORFVjL3JSSVg4c2UzbXkzYnA1MkhnRzltMytRN1B2d" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImRmdjEzVDFkUHdlSzhZQzZEWDYwc2c9PSIsInZhbHVlIjoiTFFCY2RuZDJXYngxRjQxbGdocnpxUG5NMWJQazJ5eHpPNUhQQXp0T3AyelNnV1ZLKytKdW8vTlVNbTRUbzFRZ2hKdVc5SHF0ZVhKNHZsZ1ZCMCtJTkVyMDMxSXI0SVAzeTAxY3h6SGlHUEpkUWdCbGNvUkFsOWxtUm94Nk5qNUEiLCJtYWMiOiJkYWZmMzM5MTllYmZkZWRhZThiYzFiMzY0YmE3MzU5ZmM5ZWE4ZmQzOTAyMzZhNDkzMGYxNjA1ODQ2NGEzNWE2IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6ImRmdjEzVDFkUHdlSzhZQzZEWDYwc2c9PSIsInZhbHVlIjoiTFFCY2RuZDJXYngxRjQxbGdocnpxUG5NMWJQazJ5eHpPNUhQQXp0T3AyelNnV1ZLKytKdW8vTlV" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImZERm9xclBjaW1VTk90Q2hrZXlsVVE9PSIsInZhbHVlIjoibUpQdmpLWTZvUjFFdDlqUFJobXI4QjM5RUxpeWtQS0V6WWFSVFpORFVjL3JSSVg4c2UzbXkzYnA1MkhnRzltMytRN1B2d043WkJETnZNVWNucG5odEdOMTdqQjZPS0RSZFRhbHpTbm9SSmNpVm5IbUNRSmpzUE13RFI0WTNJc0siLCJtYWMiOiI3ZWVmZGEwMzMxZTIwMGE2NzlkOTJmOWQyMTUzNjI0NmI2YjZiZmRiNTBmMjA2YWI3NTI3YzMzNmZkOGU5NDVmIiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 08:26:48 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImZERm9xclBjaW1VTk90Q2hrZXlsVVE9PSIsInZhbHVlIjoibUpQdmpLWTZvUjFFdDlqUFJobXI4QjM5RUxpeWtQS0V6WWFSVFpORFVjL3JSSVg4c2UzbXkzYnA1MkhnRzltMytRN1B2d" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImRmdjEzVDFkUHdlSzhZQzZEWDYwc2c9PSIsInZhbHVlIjoiTFFCY2RuZDJXYngxRjQxbGdocnpxUG5NMWJQazJ5eHpPNUhQQXp0T3AyelNnV1ZLKytKdW8vTlVNbTRUbzFRZ2hKdVc5SHF0ZVhKNHZsZ1ZCMCtJTkVyMDMxSXI0SVAzeTAxY3h6SGlHUEpkUWdCbGNvUkFsOWxtUm94Nk5qNUEiLCJtYWMiOiJkYWZmMzM5MTllYmZkZWRhZThiYzFiMzY0YmE3MzU5ZmM5ZWE4ZmQzOTAyMzZhNDkzMGYxNjA1ODQ2NGEzNWE2IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6ImRmdjEzVDFkUHdlSzhZQzZEWDYwc2c9PSIsInZhbHVlIjoiTFFCY2RuZDJXYngxRjQxbGdocnpxUG5NMWJQazJ5eHpPNUhQQXp0T3AyelNnV1ZLKytKdW8vTlV" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "G845RYmQGsExH8V6iWtGGIwKCQ0Jxkf2RYHeYRIt" "uc_cart_id" => "210867d801339c7f5d1af2e114012204" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/127325" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 20:26:48GET/article/127325414361