Generic placeholder image

Combinatorial Chemistry & High Throughput Screening

Editor-in-Chief

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

Research Article

The Expression and Prognostic Value of Co-stimulatory Molecules in Clear Cell Renal Cell Carcinoma (CcRcc)

Author(s): Chengjiang Wu, Xiaojie Cai and Chunyan He*

Volume 27, Issue 2, 2024

Published on: 13 June, 2023

Page: [335 - 345] Pages: 11

DOI: 10.2174/1386207326666230511153724

Price: $65

Abstract

Background: Renal cell carcinoma (RCC) was one of the most common malignant cancers in the urinary system. Clear cell carcinoma (ccRCC) is the most common pathological type, accounting for approximately 80% of RCC. The lack of accurate and effective prognosis prediction methods has been a weak link in ccRCC treatment. Co-stimulatory molecules played the main role in increasing anti-tumor immune response, which determined the prognosis of patients. Therefore, the main objective of the present study was to explore the prognostic value of co-stimulatory molecules genes in ccRCC patients.

Methods: The TCGA database was used to get gene expression and clinical characteristics of patients with ccRCC. A total of 60 co-stimulatory molecule genes were also obtained from TCGAccRCC, including 13 genes of the B7/ CD28 co-stimulatory molecules family and 47 genes of the TNF family. In the TCGA cohort, the least absolute shrinkage and selection operator (LASSO) Cox regression model was used to generate a multigene signature. R and Perl programming languages were used for data processing and drawing. Real-time PCR was used to verify the expression of differentially expressed genes.

Results: The study's initial dataset included 539 ccRCC samples and 72 normal samples. The 13 samples have been eliminated. According to FDR<0.05, there were differences in the expression of 55 co-stimulatory molecule genes in ccRCC and normal tissues. LASSO Cox regression analysis results indicated that 13 risk genes were optimally used to construct a prognostic model of ccRCC. The patients were divided into a high-risk group and a low-risk group. Those in the high-risk group had significantly lower OS (Overall Survival rate) than patients in the low-risk group. Receiver operating characteristic (ROC) curve analysis confirmed the predictive value of the prognosis model of ccRCC (AUC>0.7). There are substantial differences in immune cell infiltration between high and low-risk groups. Functional analysis revealed that immune-related pathways were enriched, and immune status was different between the two risk groups. Real-time PCR results for genes were consistent with TCGA DEGs.

Conclusion: By stratifying patients with all independent risk factors, the prognostic score model developed in this study may improve the accuracy of prognosis prediction for patients with ccRCC.

Graphical Abstract

[1]
Sato, Y.; Yoshizato, T.; Shiraishi, Y.; Maekawa, S.; Okuno, Y.; Kamura, T.; Shimamura, T.; Sato-Otsubo, A.; Nagae, G.; Suzuki, H.; Nagata, Y.; Yoshida, K.; Kon, A.; Suzuki, Y.; Chiba, K.; Tanaka, H.; Niida, A.; Fujimoto, A.; Tsunoda, T.; Morikawa, T.; Maeda, D.; Kume, H.; Sugano, S.; Fukayama, M.; Aburatani, H.; Sanada, M.; Miyano, S.; Homma, Y.; Ogawa, S. Integrated molecular analysis of clear-cell renal cell carcinoma. Nat. Genet., 2013, 45(8), 860-867.
[http://dx.doi.org/10.1038/ng.2699] [PMID: 23797736]
[2]
Serzan, M.T.; Atkins, M.B. Current and emerging therapies for first line treatment of metastatic clear cell renal cell carcinoma. J. Cancer Metastasis Treat., 2021, 7, 39.
[http://dx.doi.org/10.20517/2394-4722.2021.76] [PMID: 35295921]
[3]
Sanchez, D.J.; Simon, M.C. Genetic and metabolic hallmarks of clear cell renal cell carcinoma. Biochim. Biophys. Acta Rev. Cancer, 2018, 1870(1), 23-31.
[http://dx.doi.org/10.1016/j.bbcan.2018.06.003] [PMID: 29959988]
[4]
Cairns, P. Renal cell carcinoma. Cancer Biomark., 2011, 9(1-6), 461-473.
[http://dx.doi.org/10.3233/CBM-2011-0176] [PMID: 22112490]
[5]
Miller, K.D.; Nogueira, L.; Mariotto, A.B.; Rowland, J.H.; Yabroff, K.R.; Alfano, C.M.; Jemal, A.; Kramer, J.L.; Siegel, R.L. Cancer treatment and survivorship statistics, 2019. CA Cancer J. Clin., 2019, 69(5), 363-385.
[http://dx.doi.org/10.3322/caac.21565] [PMID: 31184787]
[6]
Vera-Badillo, F.E.; Templeton, A.J.; Duran, I.; Ocana, A.; de Gouveia, P.; Aneja, P.; Knox, J.J.; Tannock, I.F.; Escudier, B.; Amir, E. Systemic therapy for non-clear cell renal cell carcinomas: A systematic review and meta-analysis. Eur. Urol., 2015, 67(4), 740-749.
[http://dx.doi.org/10.1016/j.eururo.2014.05.010] [PMID: 24882670]
[7]
Herbst, R.S.; Baas, P.; Kim, D.W.; Felip, E.; Pérez-Gracia, J.L.; Han, J.Y.; Molina, J.; Kim, J.H.; Arvis, C.D.; Ahn, M.J.; Majem, M.; Fidler, M.J.; de Castro, G., Jr; Garrido, M.; Lubiniecki, G.M.; Shentu, Y. Im, E.; Dolled-Filhart, M.; Garon, E.B. Pembrolizumab versus docetaxel for previously treated, PD-L1-positive, advanced non-small-cell lung cancer (KEYNOTE-010): A randomised controlled trial. Lancet, 2016, 387(10027), 1540-1550.
[http://dx.doi.org/10.1016/S0140-6736(15)01281-7] [PMID: 26712084]
[8]
Borghaei, H.; Paz-Ares, L.; Horn, L.; Spigel, D.R.; Steins, M.; Ready, N.E.; Chow, L.Q.; Vokes, E.E.; Felip, E.; Holgado, E.; Barlesi, F.; Kohlhäufl, M.; Arrieta, O.; Burgio, M.A.; Fayette, J.; Lena, H.; Poddubskaya, E.; Gerber, D.E.; Gettinger, S.N.; Rudin, C.M.; Rizvi, N.; Crinò, L.; Blumenschein, G.R., Jr; Antonia, S.J.; Dorange, C.; Harbison, C.T.; Graf Finckenstein, F.; Brahmer, J.R. Nivolumab versus docetaxel in advanced nonsquamous non–small-cell lung cancer. N. Engl. J. Med., 2015, 373(17), 1627-1639.
[http://dx.doi.org/10.1056/NEJMoa1507643] [PMID: 26412456]
[9]
Lou, Q.; Lü, M.; Yu, M. Anti-CD28 antibody costimulation enhances anti-CD3 antibody activating T cells and lowering TGF-beta expression in vitro. Zhongguo Shi Yan Xue Ye Xue Za Zhi, 2006, 14(3), 547-551.
[10]
Sanmamed, M.F.; Chen, L. A Paradigm Shift in Cancer Immunotherapy: From enhancement to normalization. Cell, 2019, 176(3), 677.
[http://dx.doi.org/10.1016/j.cell.2019.01.008] [PMID: 30682374]
[11]
Janakiram, M.; Chinai, J.M.; Zhao, A.; Sparano, J.A.; Zang, X. HHLA2 and TMIGD2: New immunotherapeutic targets of the B7 and CD28 families. OncoImmunology, 2015, 4(8), e1026534.
[http://dx.doi.org/10.1080/2162402X.2015.1026534]
[12]
Croft, M.; Benedict, C.A.; Ware, C.F. Clinical targeting of the TNF and TNFR superfamilies. Nat. Rev. Drug Discov., 2013, 12(2), 147-168.
[http://dx.doi.org/10.1038/nrd3930] [PMID: 23334208]
[13]
Gajewski, T.F.; Schreiber, H.; Fu, Y.X. Innate and adaptive immune cells in the tumor microenvironment. Nat. Immunol., 2013, 14(10), 1014-1022.
[http://dx.doi.org/10.1038/ni.2703] [PMID: 24048123]
[14]
Pan, Q.; Wang, L.; Chai, S.; Zhang, H.; Li, B. The immune infiltration in clear cell Renal Cell Carcinoma and their clinical implications: A study based on TCGA and GEO databases. J. Cancer, 2020, 11(11), 3207-3215.
[http://dx.doi.org/10.7150/jca.37285]
[15]
Christinat, Y.; Krek, W. Integrated genomic analysis identifies subclasses and prognosis signatures of kidney cancer. Oncotarget, 2015, 6(12), 10521-10531.
[http://dx.doi.org/10.18632/oncotarget.3294] [PMID: 25826081]
[16]
Leibler, C.; Thiolat, A.; Elsner, R.A.; El Karoui, K.; Samson, C.; Grimbert, P. Costimulatory blockade molecules and B-cell-mediated immune response: Current knowledge and perspectives. Kidney Int., 2019, 95(4), 774-786.
[http://dx.doi.org/10.1016/j.kint.2018.10.028] [PMID: 30711200]
[17]
So, T.; Ishii, N. The TNF-TNFR family of co-signal molecules. Adv. Exp. Med. Biol., 2019, 1189, 53-84.
[http://dx.doi.org/10.1007/978-981-32-9717-3_3] [PMID: 31758531]
[18]
Schorer, M.; Kuchroo, V.K.; Joller, N. Role of Co-stimulatory molecules in T helper cell differentiation. Adv. Exp. Med. Biol., 2019, 1189, 153-177.
[http://dx.doi.org/10.1007/978-981-32-9717-3_6] [PMID: 31758534]
[19]
Vecchiarelli, A. Cytokines and costimulatory molecules: Positive and negative regulation of the immune response to Cryptococcus neoformans. Arch. Immunol. Ther. Exp. (Warsz.), 2000, 48(6), 465-472.
[PMID: 11197600]
[20]
Kusztal, M.; Jezior, D.; Weyde, W. The immune response to kidney allograft. Part II: The role of costimulatory and accessory molecules in T-cell activation; the effector phase of response Postepy Hig. Med. Dosw., 2007, 61, 21-27.
[21]
Janakiram, M.; Shah, U.A.; Liu, W.; Zhao, A.; Schoenberg, M.P.; Zang, X. The third group of the B7- CD 28 immune checkpoint family: HHLA 2, TMIGD 2, B7x, and B7-H3. Immunol. Rev., 2017, 276(1), 26-39.
[http://dx.doi.org/10.1111/imr.12521] [PMID: 28258693]
[22]
Krummel, M.F.; Allison, J.P. CD28 and CTLA-4 have opposing effects on the response of T cells to stimulation. J. Exp. Med., 1995, 182(2), 459-465.
[http://dx.doi.org/10.1084/jem.182.2.459] [PMID: 7543139]
[23]
Watts, T.H. TNF/TNFR family members in costimulation of T cell responses. Annu. Rev. Immunol., 2005, 23(1), 23-68.
[http://dx.doi.org/10.1146/annurev.immunol.23.021704.115839] [PMID: 15771565]
[24]
Croft, M. The TNF family in T cell differentiation and function - Unanswered questions and future directions. Semin. Immunol., 2014, 26(3), 183-190.
[http://dx.doi.org/10.1016/j.smim.2014.02.005] [PMID: 24613728]
[25]
Izda, V.; Jeffries, M.A.; Sawalha, A.H. COVID-19: A review of therapeutic strategies and vaccine candidates. Clin. Immunol., 2021, 222, 108634.
[http://dx.doi.org/10.1016/j.clim.2020.108634] [PMID: 33217545]
[26]
Cardona, G.; Rosselló, F.; Valiente, G. A perl package and an alignment tool for phylogenetic networks. BMC Bioinformatics, 2008, 9(175)
[http://dx.doi.org/10.1186/1471-2105-9-175]
[27]
Chan, B.K.C. Data analysis using r programming. Adv. Exp. Med. Biol., 2018, 1082, 47-122.
[http://dx.doi.org/10.1007/978-3-319-93791-5_2] [PMID: 30357717]
[28]
Ritchie, M.E.; Phipson, B.; Wu, D.; Hu, Y.; Law, C.W.; Shi, W.; Smyth, G.K. limma powers differential expression analyses for RNA-sequencing and microarray studies. Nucleic Acids Res., 2015, 43(7), e47.
[http://dx.doi.org/10.1093/nar/gkv007] [PMID: 25605792]
[29]
Wang, R.; Zhu, Y.; Liu, X. The Clinicopathological features and survival outcomes of patients with different metastatic sites in stage IV breast cancer. BMC Cancer, 2019, 19, 1091.
[http://dx.doi.org/10.1186/s12885-019-6311-z]
[30]
Szklarczyk, D.; Gable, A.L.; Nastou, K.C.; Lyon, D.; Kirsch, R.; Pyysalo, S.; Doncheva, N.T.; Legeay, M.; Fang, T.; Bork, P.; Jensen, L.J.; von Mering, C. The STRING database in 2021: Customizable protein-protein networks, and functional characterization of user-uploaded gene/measurement sets. Nucleic Acids Res., 2021, 49(D1), D605-D612.
[http://dx.doi.org/10.1093/nar/gkaa1074] [PMID: 33237311]
[31]
Qiu, H.; Hu, X.; He, C.; Yu, B.; Li, Y.; Li, J. Identification and validation of an individualized prognostic signature of bladder cancer based on seven immune related genes. Front. Genet., 2020, 11, 12.
[http://dx.doi.org/10.3389/fgene.2020.00012]
[32]
Wang, Q.; Wang, Z.; Li, G.; Zhang, C.; Bao, Z.; Wang, Z.; You, G.; Jiang, T. Identification of IDH-mutant gliomas by a prognostic signature according to gene expression profiling. Aging (Albany NY), 2018, 10(8), 1977-1988.
[http://dx.doi.org/10.18632/aging.101521] [PMID: 30115812]
[33]
Xiao, B.; Liu, L.; Li, A. Identification and Verification of Immune-Related Gene Prognostic Signature Based on ssGSEA for Osteosarcoma. Front. Oncol., 2020, 10, 607622.
[http://dx.doi.org/10.3389/fonc.2020.607622]
[34]
Zimpfer, A.; Glass, Ä.; Zettl, H.; Maruschke, M.; Hakenberg, O.W.; Erbersdobler, A. Renal cell carcinoma diagnosis and prognosis within the context of the WHO classification 2016. Urologe A, 2019, 58(9), 1057-1065.
[http://dx.doi.org/10.1007/s00120-019-0952-z] [PMID: 31093717]
[35]
Wu, C.; Cai, X.; Yan, J.; Deng, A.; Cao, Y.; Zhu, X. Identification of novel glycolysis-related gene signatures associated with prognosis of patients with clear cell renal cell carcinoma based on TCGA. Front. Genet., 2020, 11, 589663.
[http://dx.doi.org/10.3389/fgene.2020.589663]
[36]
Livak, K.J.; Schmittgen, T.D. Analysis of relative gene expression data using real-time quantitative PCR and the 2(-Delta Delta C (T)). Method. Methods, 2001, 25(4), 402-408.
[http://dx.doi.org/10.1006/meth.2001.1262] [PMID: 11846609]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version346msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:35:22] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:35:22] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:35:22] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:35:22] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (142ms)time
  • Application (204ms)time
  • 1 x Application (58.9%)
    204ms
    1 x Booting (41.1%)
    142ms
    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 duplicated126ms
    • 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 ('314520267','',1,1740774922,1740774922) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740774922
      940μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#24
      Backtrace
      • 11. middleware::check_user_access:24
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('314520267','/article/131726',1,1740774922,1740774922)
      190μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) 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 >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) 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 >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) 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 >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) 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 >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) 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 >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) limit 1
      14.61msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314520267
      • 1: 314520267
      • 2: 314520267
      • 3: 314520267
      • 4: 314520267
      • 5: 314520267
      • 6: 314520267
      • 7: 314520267
      • 8: 314520267
      • 9: 314520267
      • 10: 314520267
      • 11: 314520267
      • 12: 314520267
      • 13: 314520267
      • 14: 314520267
      • 15: 314520267
      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=131726
      700μ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
      800μ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.12msalphaeurekaselec_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
      920μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=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.89msalphaeurekaselec_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` = '131726'
      190μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 131726
      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` = '131726'
      2.84msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 131726
      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` = '131726' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.99msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 131726
      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
      210μ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
      430μ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
      28.87msalphaeurekaselec_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
      19.66msalphaeurekaselec_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
      12.49msalphaeurekaselec_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` = 131726 limit 1
      210μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 131726
      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 = 131726 and content_type = 'article' order by status desc limit 1
      280μ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` = 216812 limit 1
      230μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 216812
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      230μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CCHTS' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      330μ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 = '131726' 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) )
      400μ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 = '13066' 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) )
      360μ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 = '3488' 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) )
      320μ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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740774922 and j.to_date >= 1740774922 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3488) 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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740774922 and j.to_date >= 1740774922 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3488) 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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740774922 and j.to_date >= 1740774922 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3488)
      25.15msalphaeurekaselec_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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740774922 and j.to_date >= 1740774922 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13066) 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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740774922 and j.to_date >= 1740774922 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13066) 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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740774922 and j.to_date >= 1740774922 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13066)
      700μ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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740774922 and j.to_date >= 1740774922 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 131726) 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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740774922 and j.to_date >= 1740774922 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 131726) 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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740774922 and j.to_date >= 1740774922 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 131726)
      630μ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` < '335' and is_uploaded = 1 and issue_id = 13066 order by cast(first_page as SIGNED) desc limit 1
      530μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 335
      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` > '345' and is_uploaded = 1 and issue_id = 13066 order by cast(first_page as SIGNED) asc limit 1
      480μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 345
      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'
      190μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      220μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 131726 limit 1
      2.51msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 131726
      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` <= 1740774922 and `b`.`banner_to_date` >= 1740774922 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.16msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 8
      • 3: 1740774922
      • 4: 1740774922
      • 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` <= 1740774922 and `b`.`banner_to_date` >= 1740774922 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.14msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 8
      • 3: 1740774922
      • 4: 1740774922
      • 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='3c991ad0413cd2b3ee78c3116e7ab6c3'
      270μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:291
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        vYWbd7MTJDNl8UGnzXpwazk60OFXyUL5revSJNIs
        uc_cart_id
        3c991ad0413cd2b3ee78c3116e7ab6c3
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/131726" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/131726
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 28 Feb 2025 20:35:22 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Imt1R2NsRUdaK1VMMzRGeEdzaGdPMFE9PSIsInZhbHVlIjoiR1cxUXNiU0FzVUU2MzlxVk5hY3dmNlRPazJDQk0wdmVVYytHYktQWVYwUi9HRTloNXpCWXgyZ2w1TkwrZTdBN05uWTlBdnlEcitDL01NWFFRSnhlRzJVU1h5WERMY3NDZWVXc0JZUTJUUXpYb1RBMXVHTUJyNHVSRG4zK05YN1oiLCJtYWMiOiIwZmU2YzE1YzdkMzc0ODA1NzczNzA5YTg0NzgxZTQzMmM1ZTg3ZGQxZDA5YmExMTRmMzRlNTliNTA2ZWU5MGZkIiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 08:35:22 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Imt1R2NsRUdaK1VMMzRGeEdzaGdPMFE9PSIsInZhbHVlIjoiR1cxUXNiU0FzVUU2MzlxVk5hY3dmNlRPazJDQk0wdmVVYytHYktQWVYwUi9HRTloNXpCWXgyZ2w1TkwrZTdBN05uWTlBd" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkJ0Y29KVTRmaW4ra1ZkclBnRm0wV3c9PSIsInZhbHVlIjoiMzdRK1NFVW9acGNYNVk1amJrc21WSUJzbjdsblBYdUZZVDhFMThveGR5S2c0ZUlJQ0ZqU2hnaDNDU1JBVkdwejVmUHppUER6Z0c0RFFZRkNJKzc5ek43RjluZm9acTVFNTRMN2V4Mkd4NUZ6SzRpWFVvc1RQamFKTDFUUDRVRGciLCJtYWMiOiJkOWI0ZGQ4MmRmMTMzZGI4MjE0YTg0YmFmNWIwYzhhNGIxYzFkNGI2NWZkZGY2ZTUxMGZkNzYxZGUyNzQwZmI2IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkJ0Y29KVTRmaW4ra1ZkclBnRm0wV3c9PSIsInZhbHVlIjoiMzdRK1NFVW9acGNYNVk1amJrc21WSUJzbjdsblBYdUZZVDhFMThveGR5S2c0ZUlJQ0ZqU2hnaDN" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Imt1R2NsRUdaK1VMMzRGeEdzaGdPMFE9PSIsInZhbHVlIjoiR1cxUXNiU0FzVUU2MzlxVk5hY3dmNlRPazJDQk0wdmVVYytHYktQWVYwUi9HRTloNXpCWXgyZ2w1TkwrZTdBN05uWTlBdnlEcitDL01NWFFRSnhlRzJVU1h5WERMY3NDZWVXc0JZUTJUUXpYb1RBMXVHTUJyNHVSRG4zK05YN1oiLCJtYWMiOiIwZmU2YzE1YzdkMzc0ODA1NzczNzA5YTg0NzgxZTQzMmM1ZTg3ZGQxZDA5YmExMTRmMzRlNTliNTA2ZWU5MGZkIiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 08:35:22 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Imt1R2NsRUdaK1VMMzRGeEdzaGdPMFE9PSIsInZhbHVlIjoiR1cxUXNiU0FzVUU2MzlxVk5hY3dmNlRPazJDQk0wdmVVYytHYktQWVYwUi9HRTloNXpCWXgyZ2w1TkwrZTdBN05uWTlBd" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkJ0Y29KVTRmaW4ra1ZkclBnRm0wV3c9PSIsInZhbHVlIjoiMzdRK1NFVW9acGNYNVk1amJrc21WSUJzbjdsblBYdUZZVDhFMThveGR5S2c0ZUlJQ0ZqU2hnaDNDU1JBVkdwejVmUHppUER6Z0c0RFFZRkNJKzc5ek43RjluZm9acTVFNTRMN2V4Mkd4NUZ6SzRpWFVvc1RQamFKTDFUUDRVRGciLCJtYWMiOiJkOWI0ZGQ4MmRmMTMzZGI4MjE0YTg0YmFmNWIwYzhhNGIxYzFkNGI2NWZkZGY2ZTUxMGZkNzYxZGUyNzQwZmI2IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkJ0Y29KVTRmaW4ra1ZkclBnRm0wV3c9PSIsInZhbHVlIjoiMzdRK1NFVW9acGNYNVk1amJrc21WSUJzbjdsblBYdUZZVDhFMThveGR5S2c0ZUlJQ0ZqU2hnaDN" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "vYWbd7MTJDNl8UGnzXpwazk60OFXyUL5revSJNIs" "uc_cart_id" => "3c991ad0413cd2b3ee78c3116e7ab6c3" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/131726" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 20:35:22GET/article/131726414361