Generic placeholder image

Combinatorial Chemistry & High Throughput Screening

Editor-in-Chief

ISSN (Print): 1386-2073
ISSN (Online): 1875-5402

Research Article

Exploring Prognostic Signatures of Hepatocellular Carcinoma and the Potential Implications in Tumor Immune Microenvironment

Author(s): Hongxu Chen, Zhijing Jiang*, Bingshi Yang, Guiling Yan, Xiaochen Wang and Shuning Zang

Volume 25, Issue 6, 2022

Published on: 09 March, 2021

Page: [998 - 1004] Pages: 7

DOI: 10.2174/1386207324666210309100923

Price: $65

Abstract

Objective: The objective of this study is to construct a prognostic model using genetic markers of liver cancer and explore the signature genes associated with the tumor immune microenvironment.

Methods: Cox proportional hazards regression analysis was carried out to screen the significant HR using the dataset of TCGA Liver Cancer (LIHC) gene expression data. Then LASSO (least absolute shrinkage and selection operator) was performed to select the minimal variables with significant HR of genes. Thus, the prognostic model was constructed by the minimal variables with their HR. Time-dependent receiver-operating characteristic (ROC) curve and area under the ROC curve (AUC) value was used to assess the prognostic performance. Then the patients were divided into high and low-risk groups by the median of the model. Survival analysis was performed on the two groups with testing and an independent dataset. Furthermore, enrichment analysis of signature mRNAs and lncRNAs and their co-expression genes was performed. Then, Spearman rank correlation was used to calculate the correlation between immune cells and genes in the prognostic model, and abundance difference of the immune cells in high and low risks groups was tested.

Results: A total of 5989 genes with significant HR were identified. 6 key genes (three mRNAs: DHX37, SMIM7, and MFSD1, three lncRNAs: PIWIL4, KCNE5, and LOC100128398) screened by LASSO were used to construct the model with their HR value respectively. The AUC values of 1 and 5-year overall survival were 0.78 and 0.76 in discovery data and 0.67 and 0.68 in testing data. Survival analysis performed significantly discriminated high and low groups with testing and independent data. Furthermore, many immune cells such as nTreg found a significant correlation with the genes in the prognostic model, and many immune cells showed significantly different abundance in high and low-risk groups.

Conclusion: In the study, we used Univariate Cox analyses and LASSO algorithm with TCGA gene expression data to construct the prognostic model in liver cancer patients. The prognostic model comprised of three mRNAs, including DHX37, SMIM7, MFSD1, and three lncRNAs, including PIWIL4, KCNE5, and LOC100128398. Furthermore, these gene expression levels were associated with the abundance of some immune cells, such as nTreg. Also, many immune cells have significantly different abundance in high and low-risk groups. All these results indicated that the combination with all these six genes could be the potential biomarker for the prognosis of liver cancer.

Keywords: Prognostic model construction, signature, lncRNA, survival analysis, ROC curve, tumor immune microenvironment.

Graphical Abstract

[1]
Allemani, C.; Matsuda, T.; Di Carlo, V.; Harewood, R.; Matz, M.; Nikšić, M.; Bonaventure, A.; Valkov, M.; Johnson, C.J.; Estève, J.; Ogunbiyi, O.J.; Azevedo, E.S.G.; Chen, W.Q.; Eser, S.; Engholm, G.; Stiller, C.A.; Monnereau, A.; Woods, R.R.; Visser, O.; Lim, G.H.; Aitken, J.; Weir, H.K.; Coleman, M.P. Global surveillance of trends in cancer survival 2000-14 (CONCORD-3): analysis of individual records for 37 513 025 patients diagnosed with one of 18 cancers from 322 population-based registries in 71 countries. Lancet, 2018, 391(10125), 1023-1075.
[2]
Maluccio, M.; Covey, A. Recent progress in understanding, diagnosing, and treating hepatocellular carcinoma. CA Cancer J. Clin., 2012, 62(6), 394-399.
[3]
Bray, F.; Ferlay, J.; Soerjomataram, I.; Siegel, R.L.; Torre, L.A.; Jemal, A. Global cancer statistics 2018: GLOBOCAN estimates of incidence and mortality worldwide for 36 cancers in 185 countries. CA Cancer J. Clin., 2018, 68(6), 394-424.
[4]
Siegel, R.L.; Miller, K.D.; Jemal, A. Cancer statistics, 2018. 2018, 68(1), 7-30.
[5]
Sun, J.H.; Luo, Q.; Liu, L.L.; Song, G.B. Liver cancer stem cell markers: Progression and therapeutic implications. World J. Gastroenterol., 2016, 22(13), 3547-3557.
[6]
Anwanwan, D.; Singh, S.K.; Singh, S.; Saikam, V.; Singh, R. Challenges in liver cancer and possible treatment approaches. Biochim. Biophys. Acta Rev. Cancer, 2020, 1873(1), 188314.
[7]
Li, L.; Wang, H. Heterogeneity of liver cancer and personalized therapy. Cancer Lett., 2016, 379(2), 191-197.
[8]
Bruix, J.; Han, K.H.; Gores, G.; Llovet, J.M.; Mazzaferro, V. Liver cancer: Approaching a personalized care. J. Hepatol., 2015, 62(1)(Suppl.), S144-S156.
[9]
Zucman-Rossi, J.; Villanueva, A.; Nault, J.C.; Llovet, J.M. Genetic Landscape and Biomarkers of Hepatocellular Carcinoma. Gastroenterology, 2015, 149(5), 1226-1239.e1224.
[10]
Scaggiante, B.; Kazemi, M.; Pozzato, G.; Dapas, B.; Farra, R.; Grassi, M.; Zanconati, F.; Grassi, G. Novel hepatocellular carcinoma molecules with prognostic and therapeutic potentials. World J. Gastroenterol., 2014, 20(5), 1268-1288.
[11]
Wang, Y.; Song, J.; Bian, H.; Bo, J.; Lv, S.; Pan, W.; Lv, X. Apelin promotes hepatic fibrosis through ERK signaling in LX-2 cells. 2019, 460(1-2), 205-215.
[12]
Xing, J.; Tian, Y.; Ji, W.; Wang, X. Comprehensive evaluation of SPATS2 expression and its prognostic potential in liver cancer. Medicine (Baltimore), 2020, 99(9), e19230.
[13]
Zhai, K.; Yang, Y.; Gao, Z.G.; Ding, J. Interleukin-6-174G>C gene promoter polymorphism and prognosis in patients with cancer. Oncotarget, 2017, 8(27), 44490-44497.
[14]
Wang, Q.; Zhu, Y.; Li, Z.; Bu, Q.; Sun, T.; Wang, H.; Sun, H.; Cao, X. Up-regulation of SPC25 promotes breast cancer. Aging (Albany NY), 2019, 11(15), 5689-5704.
[15]
Buoncervello, M.; Gabriele, L.; Toschi, E. The Janus Face of Tumor Microenvironment Targeted by Immunotherapy. Int. J. Mol. Sci., 2019, 20(17)
[16]
Houthuijzen, J.M.; Jonkers, J. Cancer-associated fibroblasts as key regulators of the breast cancer tumor microenvironment. Cancer Metastasis Rev., 2018, 37(4), 577-597.
[17]
Whiteside, T.L. Exosome and mesenchymal stem cell cross-talk in the tumor microenvironment. Semin. Immunol., 2018, 35, 69-79.
[18]
Syed, S.N.; Frank, A.C.; Raue, R.; Brüne, B. MicroRNA-A Tumor Trojan Horse for Tumor-Associated Macrophages. Cells, 2019, 8(12)
[19]
Altorki, N.K.; Markowitz, G.J.; Gao, D.; Port, J.L.; Saxena, A.; Stiles, B.; McGraw, T.; Mittal, V. The lung microenvironment: an important regulator of tumour growth and metastasis. Nat. Rev. Cancer, 2019, 19(1), 9-31.
[20]
Meurette, O.; Mehlen, P. Notch Signaling in the Tumor Microenvironment. Cancer Cell, 2018, 34(4), 536-548.
[21]
Roma-Rodrigues, C.; Mendes, R.; Baptista, P.V. Targeting Tumor Microenvironment for Cancer Therapy. 2019, 20(4)
[22]
Jarosz-Biej, M.; Smolarczyk, R.; Cichoń, T.; Kułach, N. Tumor Microenvironment as A “Game Changer” in Cancer Radiotherapy. Int. J. Mol. Sci., 2019, 20(13)
[23]
Gurin, D.; Slavik, M.; Hermanova, M. The tumor immune microenvironment and its implications for clinical outcome in patients with oropharyngeal squamous cell carcinoma., 2020.
[24]
Chandler, C.; Liu, T.; Buckanovich, R.; Coffman, L.G. The double edge sword of fibrosis in cancer. Transl. Res., 2019, 209, 55-67.
[25]
Chen, C.; Liu, J.M.; Luo, Y.P. MicroRNAs in tumor immunity: functional regulation in tumor-associated macrophages. J. Zhejiang Univ. Sci. B, 2020, 21(1), 12-28.
[26]
Eissmann, M.F.; Buchert, M.; Ernst, M. IL33 and Mast Cells-The Key Regulators of Immune Responses in Gastrointestinal Cancers? Front. Immunol., 2020, 11, 1389.
[27]
Miao, Y.R.; Zhang, Q.; Lei, Q.; Luo, M.; Xie, G.Y.; Wang, H.; Guo, A.Y. ImmuCellAI: A Unique Method for Comprehensive T-Cell Subsets Abundance Prediction and its Application in Cancer Immunotherapy. Adv. Sci. (Weinh.), 2020, 7(7), 1902880.
[28]
Zhou, Y.; Zhou, B.; Pache, L.; Chang, M. Metascape provides a biologist-oriented resource for the analysis of systems-level datasets. 2019, 35(17), 3199-3202.
[29]
Fagerberg, L.; Hallström, B.M.; Oksvold, P.; Kampf, C.; Djureinovic, D.; Odeberg, J.; Habuka, M.; Tahmasebpoor, S.; Danielsson, A.; Edlund, K.; Asplund, A.; Sjöstedt, E.; Lundberg, E.; Szigyarto, C.A.; Skogs, M.; Takanen, J.O.; Berling, H.; Tegel, H.; Mulder, J.; Nilsson, P.; Schwenk, J.M.; Lindskog, C.; Danielsson, F.; Mardinoglu, A.; Sivertsson, A.; von Feilitzen, K.; Forsberg, M.; Zwahlen, M.; Olsson, I.; Navani, S.; Huss, M.; Nielsen, J.; Ponten, F.; Uhlén, M. Analysis of the human tissue-specific expression by genome-wide integration of transcriptomics and antibody-based proteomics. Mol. Cell. Proteomics, 2014, 13(2), 397-406.
[30]
Zhang, Y.; Liu, T.; Chen, L.; Yang, J.; Yin, J.; Zhang, Y.; Yun, Z.; Xu, H.; Ning, L.; Guo, F.; Jiang, Y.; Lin, H.; Wang, D.; Huang, Y.; Huang, J. RIscoper: a tool for RNA-RNA interaction extraction from the literature. Bioinformatics, 2019, 35(17), 3199-3202.
[31]
Dong, M.B.; Wang, G.; Chow, R.D.; Ye, L.; Zhu, L.; Dai, X.; Park, J.J.; Kim, H.R.; Errami, Y.; Guzman, C.D.; Zhou, X.; Chen, K.Y.; Renauer, P.A.; Du, Y.; Shen, J.; Lam, S.Z.; Zhou, J.J.; Lannin, D.R.; Herbst, R.S.; Chen, S. Systematic Immunotherapy Target Discovery Using Genome-Scale In Vivo CRISPR Screens in CD8 T Cells. Cell, 2019, 178(5), 1189-1204.e1123.
[32]
Denisov, E.V.; Skryabin, N.A.; Gerashchenko, T.S.; Tashireva, L.A.; Wilhelm, J.; Buldakov, M.A.; Sleptcov, A.A.; Lebedev, I.N.; Vtorushin, S.V.; Zavyalova, M.V.; Cherdyntseva, N.V.; Perelmuter, V.M. Clinically relevant morphological structures in breast cancer represent transcriptionally distinct tumor cell populations with varied degrees of epithelial-mesenchymal transition and CD44(+)CD24(-) stemness. Oncotarget, 2017, 8(37), 61163-61180.
[33]
Rodrigues-Peres, R.M. de, S.C.B.; Anurag, M.; Lei, J.T.; Conz, L.; Gonçalves, R.; Cardoso Filho, C.; Ramalho, S.; de Paiva, G.R.; Derchain, S.F.M.; Lopes-Cendes, I.; Ellis, M.J.; Sarian, L.O. Copy number alterations associated with clinical features in an underrepresented population with breast cancer. Mol. Genet. Genomic Med., 2019, 7(7), e00750.
[34]
Ceder, M.M.; Lekholm, E.; Klaesson, A.; Tripathi, R.; Schweizer, N.; Weldai, L.; Patil, S.; Fredriksson, R. Glucose Availability Alters Gene and Protein Expression of Several Newly Classified and Putative Solute Carriers in Mice Cortex Cell Culture and D. melanogaster. Front. Cell Dev. Biol., 2020, 8, 579.
[35]
Zheng, J.; Liu, X.; Wang, P.; Xue, Y.; Ma, J.; Qu, C.; Liu, Y. CRNDE Promotes Malignant Progression of Glioma by Attenuating miR-384/PIWIL4/STAT3 Axis. Mol. Ther., 2016, 24(7), 1199-1215.
[36]
Wang, Z.; Liu, N.; Shi, S.; Liu, S.; Lin, H. The Role of PIWIL4, an Argonaute Family Protein, in Breast Cancer. J. Biol. Chem., 2016, 291(20), 10646-10658.
[37]
Ning, L.; Cui, T.; Zheng, B.; Wang, N.; Luo, J.; Yang, B.; Du, M.; Cheng, J.; Dou, Y.; Wang, D. MNDR v3.0: mammal ncRNA-disease repository with increased coverage and annotation. Nucleic Acids Res., 2020.
[38]
Lin, Y.; Liu, T.; Cui, T.; Wang, Z.; Zhang, Y.; Tan, P.; Huang, Y.; Yu, J.; Wang, D. RNAInter in 2020: RNA interactome repository with increased coverage and annotation. Nucleic Acids Res., 2020, 48(D1), D189-d197.
[39]
Li, Y.; Wang, C.; Miao, Z.; Bi, X.; Wu, D.; Jin, N.; Wang, L.; Wu, H.; Qian, K.; Li, C.; Zhang, T.; Zhang, C.; Yi, Y.; Lai, H.; Hu, Y.; Cheng, L.; Leung, K.S.; Li, X.; Zhang, F.; Li, K.; Li, X.; Wang, D. ViRBase: a resource for virus-host ncRNA-associated interactions., 2015. 43(Database issue), D578-582.
[40]
Abbott, G.W. KCNE4 and KCNE5: K(+) channel regulation and cardiac arrhythmogenesis. Gene, 2016, 593(2), 249-260.
[41]
Huang, Y.; Wang, J.; Zhao, Y.; Wang, H.; Liu, T.; Li, Y.; Cui, T.; Li, W.; Feng, Y.; Luo, J.; Gong, J.; Ning, L.; Zhang, Y.; Wang, D.; Zhang, Y. cncRNAdb: a manually curated resource of experimentally supported RNAs with both protein-coding and noncoding function. Nucleic Acids Res., 2020.
[42]
Szymczak, S.; Dose, J.; Torres, G.G.; Heinsen, F.A.; Venkatesh, G.; Datlinger, P.; Nygaard, M.; Mengel-From, J.; Flachsbart, F.; Klapper, W.; Christensen, K.; Lieb, W.; Schreiber, S.; Häsler, R.; Bock, C.; Franke, A.; Nebel, A. DNA methylation QTL analysis identifies new regulators of human longevity. Hum. Mol. Genet., 2020, 29(7), 1154-1167.
[43]
Jin, N.; Li, Y.; Zhang, L.; Yang, H.; Hu, Z.; Zhang, L.; Hu, C.; Li, C.; Qian, K.; Zhang, C.; Huang, Y.; Li, K.; Lin, H.; Wang, D.
[44]
Terabe, M.; Berzofsky, J.A. Tissue-Specific Roles of NKT Cells in Tumor Immunity. Front. Immunol., 2018, 9, 1838.
[45]
Paluskievicz, C.M.; Cao, X.; Abdi, R.; Zheng, P.; Liu, Y.; Bromberg, J.S. T Regulatory Cells and Priming the Suppressive Tumor Microenvironment. Front. Immunol., 2019, 10, 2453.
[46]
Downs-Canner, S.; Berkey, S.; Delgoffe, G.M.; Edwards, R.P.; Curiel, T.; Odunsi, K.; Bartlett, D.L.; Obermajer, N. Suppressive IL-17A(+)Foxp3(+) and ex-Th17 IL-17A(neg)Foxp3(+) T(reg) cells are a source of tumour-associated T(reg) cells. Nat. Commun., 2017, 8, 14649.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version365msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[21:45:25] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[21:45:25] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[21:45:25] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[21:45:25] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (115ms)time
  • Application (250ms)time
  • 1 x Application (68.46%)
    250ms
    1 x Booting (31.54%)
    115ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated172ms
    • 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 ('221938058','',1,1740347125,1740347125) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740347125
      1.54msalphaeurekaselec_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 ('221938058','/article/114785',1,1740347125,1740347125)
      200μ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 >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) 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 >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) 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 >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) 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 >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) 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 >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) 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 >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) limit 1
      16.51msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 221938058
      • 1: 221938058
      • 2: 221938058
      • 3: 221938058
      • 4: 221938058
      • 5: 221938058
      • 6: 221938058
      • 7: 221938058
      • 8: 221938058
      • 9: 221938058
      • 10: 221938058
      • 11: 221938058
      • 12: 221938058
      • 13: 221938058
      • 14: 221938058
      • 15: 221938058
      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=114785
      740μsalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 8 limit 1
      830μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 8
      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=8) and sj.journal_id!=8 group by `j`.`nid`) as `aggregate_table`
      1.07msalphaeurekaselec_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=8) and sj.journal_id!=8 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      890μ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=8) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.17msalphaeurekaselec_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=8) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      1.87msalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 14. app/Models/Subject.php:220
      • 15. app/Http/Controllers/ArticleController.php:2518
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `keywords` where `article_id` = '114785'
      910μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 114785
      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` = '114785'
      2.43msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 114785
      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` = '114785' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.53msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 114785
      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
      290μ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
      620μ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 = 8 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      46.96msalphaeurekaselec_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 = 8 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      20.23msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2070
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 8 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      10.8msalphaeurekaselec_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` = 114785 limit 1
      990μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 114785
      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 = 114785 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 a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 16 and cd.sub_disease_id = 465 and content_id!=114785 and cd.content_type = 'article' order by rand() limit 20
      42.38msalphaeurekaselec_live_10_06_2022Article.php#769
      Backtrace
      • 11. app/Models/Article.php:769
      • 12. app/Http/Controllers/ArticleController.php:2098
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 192141 limit 1
      310μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 192141
      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
      310μ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` = 'CCHTS' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      420μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CCHTS
      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 = '114785' 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) )
      540μ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 = '11358' 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) )
      420μ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 = '3115' 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) )
      380μ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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740347125 and j.to_date >= 1740347125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3115) 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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740347125 and j.to_date >= 1740347125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3115) 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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740347125 and j.to_date >= 1740347125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3115)
      5.72msalphaeurekaselec_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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740347125 and j.to_date >= 1740347125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11358) 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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740347125 and j.to_date >= 1740347125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11358) 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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740347125 and j.to_date >= 1740347125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11358)
      800μ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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740347125 and j.to_date >= 1740347125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 114785) 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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740347125 and j.to_date >= 1740347125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 114785) 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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740347125 and j.to_date >= 1740347125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 114785)
      760μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2329
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `article` where `first_page` < '998' and is_uploaded = 1 and issue_id = 11358 order by cast(first_page as SIGNED) desc limit 1
      640μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 998
      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` > '1004' and is_uploaded = 1 and issue_id = 11358 order by cast(first_page as SIGNED) asc limit 1
      590μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 1004
      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'
      230μ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
      240μ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` = 114785 limit 1
      3.5msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 114785
      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` = 8 and `b`.`banner_from_date` <= 1740347125 and `b`.`banner_to_date` >= 1740347125 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.15msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 8
      • 3: 1740347125
      • 4: 1740347125
      • 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` = 8 and `b`.`banner_from_date` <= 1740347125 and `b`.`banner_to_date` >= 1740347125 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.15msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 8
      • 3: 1740347125
      • 4: 1740347125
      • 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='c9a788a0d56e0eb7af7ccac11faa8c40'
      250μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        JcIh0KaUwapAweGe5bhf7APWqm9Dp1R9ExZw6rQC
        uc_cart_id
        c9a788a0d56e0eb7af7ccac11faa8c40
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/114785" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/114785
        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=eyJpdiI6IlV4cHhNQkphU2F1M2RyY2ZlY1lJYUE9PSIsInZhbHVlIjoiN0N2RHhBQW11MEpjdVFGL3p3aml1NHpodk0xVDJsNjJCQ0hrUXp1OVZuOD0iLCJtYWMiOiI2MjY3OTkyOTYwOWZkMzE0YWNiYmQwMjk5OWViNGRlMGE4OTI0YmYxZTAyZDRjNjJlMWM0NTljNjhmOWQ1M2I2IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IlV4cHhNQkphU2F1M2RyY2ZlY1lJYUE9PSIsInZhbHVlIjoiN0N2RHhBQW11MEpjdVFGL3p3aml1NHpodk0xVDJsNjJCQ0hrUXp1OVZuOD0iLCJtYWMiOiI2MjY3OTkyOTYwOWZk" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 23 Feb 2025 21:45:25 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJxbWc1WkozOVhELy95c0lFcFUrQUE9PSIsInZhbHVlIjoiT1dsbmdyUGhSdGRBOWRPRUdxRWlvaXg3R3dwazVpQ1BGYlFod0NhMVBqR3JHOXozQy9zZ012aDluY0pHQy9uWGdBQjh2Ylg1TEtCZnduK1h3eEFmLzUrWDFmRXJKK0M4T0xZOFpxbWhJWmdUNXByUW9xbU1pNTBhdjYzL2ozOTEiLCJtYWMiOiI1NjVkOGI0OGM0Y2I2YjFmYzcxYzBlYjAwMTgzNmVkNmZiY2U0MTQ5ZTk2MjEzOTQwOGU2OTc0NTliZWViNzBmIiwidGFnIjoiIn0%3D; expires=Wed, 26 Feb 2025 09:45:25 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlJxbWc1WkozOVhELy95c0lFcFUrQUE9PSIsInZhbHVlIjoiT1dsbmdyUGhSdGRBOWRPRUdxRWlvaXg3R3dwazVpQ1BGYlFod0NhMVBqR3JHOXozQy9zZ012aDluY0pHQy9uWGdBQjh2Y" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjBUQTVERjIwSlRrNnFZclFiN1NFd3c9PSIsInZhbHVlIjoiN2RoLzBVZWFPd3BXQnVTSXRORkQ4a250UVhWWFU0RjlyWkljdUpyd1Q2cFg3aWRkU09lRVJrdVBHdkJrL1laUXFabTFRZkNxQktqZUxLbHRJd3hDL0k3TUlhNVVmV3JkS0hnek1zckNUQ3lqSXhuTnJSMVFWbWxiV2p1WFNIQ0ciLCJtYWMiOiIyMjU4NTk2YWExYjJhMTIyZjdlY2M1YzFkMjNiYzQ3MTg4ODE2ZTY1OTQ5YzQxM2ZjOGE3YzI4YjE4YzY0YWU2IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IjBUQTVERjIwSlRrNnFZclFiN1NFd3c9PSIsInZhbHVlIjoiN2RoLzBVZWFPd3BXQnVTSXRORkQ4a250UVhWWFU0RjlyWkljdUpyd1Q2cFg3aWRkU09lRVJrdVB" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJxbWc1WkozOVhELy95c0lFcFUrQUE9PSIsInZhbHVlIjoiT1dsbmdyUGhSdGRBOWRPRUdxRWlvaXg3R3dwazVpQ1BGYlFod0NhMVBqR3JHOXozQy9zZ012aDluY0pHQy9uWGdBQjh2Ylg1TEtCZnduK1h3eEFmLzUrWDFmRXJKK0M4T0xZOFpxbWhJWmdUNXByUW9xbU1pNTBhdjYzL2ozOTEiLCJtYWMiOiI1NjVkOGI0OGM0Y2I2YjFmYzcxYzBlYjAwMTgzNmVkNmZiY2U0MTQ5ZTk2MjEzOTQwOGU2OTc0NTliZWViNzBmIiwidGFnIjoiIn0%3D; expires=Wed, 26-Feb-2025 09:45:25 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlJxbWc1WkozOVhELy95c0lFcFUrQUE9PSIsInZhbHVlIjoiT1dsbmdyUGhSdGRBOWRPRUdxRWlvaXg3R3dwazVpQ1BGYlFod0NhMVBqR3JHOXozQy9zZ012aDluY0pHQy9uWGdBQjh2Y" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjBUQTVERjIwSlRrNnFZclFiN1NFd3c9PSIsInZhbHVlIjoiN2RoLzBVZWFPd3BXQnVTSXRORkQ4a250UVhWWFU0RjlyWkljdUpyd1Q2cFg3aWRkU09lRVJrdVBHdkJrL1laUXFabTFRZkNxQktqZUxLbHRJd3hDL0k3TUlhNVVmV3JkS0hnek1zckNUQ3lqSXhuTnJSMVFWbWxiV2p1WFNIQ0ciLCJtYWMiOiIyMjU4NTk2YWExYjJhMTIyZjdlY2M1YzFkMjNiYzQ3MTg4ODE2ZTY1OTQ5YzQxM2ZjOGE3YzI4YjE4YzY0YWU2IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IjBUQTVERjIwSlRrNnFZclFiN1NFd3c9PSIsInZhbHVlIjoiN2RoLzBVZWFPd3BXQnVTSXRORkQ4a250UVhWWFU0RjlyWkljdUpyd1Q2cFg3aWRkU09lRVJrdVB" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "JcIh0KaUwapAweGe5bhf7APWqm9Dp1R9ExZw6rQC" "uc_cart_id" => "c9a788a0d56e0eb7af7ccac11faa8c40" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/114785" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-23 21:45:25GET/article/114785414371