Generic placeholder image

Current Molecular Medicine

Editor-in-Chief

ISSN (Print): 1566-5240
ISSN (Online): 1875-5666

Research Article

The Prognostic Value of Cytokeratin and Extracellular Collagen Expression in Urinary Bladder Cancer

Author(s): Marc Ingenwerth, Péter Nyirády, Boris Hadaschik, Tibor Szarvas* and Henning Reis*

Volume 22, Issue 10, 2022

Published on: 25 March, 2022

Page: [941 - 949] Pages: 9

DOI: 10.2174/1566524021666210225100041

Price: $65

Abstract

Background: Expression levels of collagens have been implicated in the progression of various cancers and interaction with cytokeratins but are not well studied in bladder cancer (BC). Therefore, we analyzed the gene and protein expression levels of collagen 1A1 (Col1a1/COL1A1), collagen 3A1 (col3a1/COL3A1), collagen 5A2 (col5a2/COL5A2), cytokeratin 14 (krt14/CK14), and cytokeratin 17 (krt17/CK17) in urothelial BC samples of different stages.

Methods: In total, 102 fresh frozen and 190 formalin-fixed and paraffin-embedded (FFPE) samples were tested using immunohistochemistry and RT-qPCR. Expression levels were correlated with clinicopathological and follow-up data.

Results: Col1a1, col3a1, col5a2 and krt14 mRNA levels were significantly overexpressed in high-grade and muscle-invasive BC (MIBC) compared to low-grade and non-muscle invasive BC (NMIBC) cases. Disease-specific survival (DSS) was shorter in patients with high expression levels of col1a1 (p = 0.004), col3a1 (p = 0.004), and col5a2 (p = 0.028). CK14 (p = 0.020), COL3A1 (p = 0.006), and Col5A2 (p = 0.006) protein expression levels were significantly higher and protein expression levels of CK17 (p = 0.05) were significantly lower in MIBC compared to NMIBC. Furthermore, CK14 (p = 0.002) and COL5A2 (p = 0.006) protein expression level were significantly higher in high-grade compared to low-grade BC. DSS was shorter in patients with high expression levels of COL5A2 (p = 0.033) and CK14 (p = 0.042).

Conclusion: Expression changes of collagens and cytokeratins are univariable prognostic markers in BC.

Keywords: COL1A1, COL3A1, COL5A2, CK14, CK17, bladder cancer, epithelial-mesenchymal-transition.

[1]
Antoni S, Ferlay J, Soerjomataram I, Znaor A, Jemal A, Bray F. Bladder cancer incidence and mortality: a global overview and recent trends. Eur Urol 2017; 71(1): 96-108.
[http://dx.doi.org/10.1016/j.eururo.2016.06.010] [PMID: 27370177]
[2]
Chalasani V, Chin JL, Izawa JI. Histologic variants of urothelial bladder cancer and nonurothelial histology in bladder cancer. Can Urol Assoc J 2009; 3(6)(Suppl. 4): S193-8.
[PMID: 20019984]
[3]
Sylvester RJ, van der Meijden AP, Oosterlinck W, et al. Predicting recurrence and progression in individual patients with stage Ta T1 bladder cancer using EORTC risk tables: a combined analysis of 2596 patients from seven EORTC trials. Eur Urol 2006; 49(3): 466-5.
[http://dx.doi.org/10.1016/j.eururo.2005.12.031] [PMID: 16442208]
[4]
Witjes JA, Compérat E, Cowan NC, et al. European Association of Urology. EAU guidelines on muscle-invasive and metastatic bladder cancer: summary of the 2013 guidelines. Eur Urol 2014; 65(4): 778-92.
[http://dx.doi.org/10.1016/j.eururo.2013.11.046] [PMID: 24373477]
[5]
Samaratunga H, Fairweather P, Purdie D. Significance of stromal reaction patterns in invasive urothelial carcinoma. Am J Clin Pathol 2005; 123(6): 851-7.
[http://dx.doi.org/10.1309/EE8RTB6X1611G6TU] [PMID: 15899775]
[6]
Quail DF, Joyce JA. Microenvironmental regulation of tumor progression and metastasis. Nat Med 2013; 19(11): 1423-37.
[http://dx.doi.org/10.1038/nm.3394] [PMID: 24202395]
[7]
Paterson RF, Ulbright TM, MacLennan GT, et al. Molecular genetic alterations in the laser-capture-microdissected stroma adjacent to bladder carcinoma. Cancer 2003; 98(9): 1830-6.
[http://dx.doi.org/10.1002/cncr.11747] [PMID: 14584063]
[8]
Enkelmann A, Heinzelmann J, von Eggeling F, et al. Specific protein and miRNA patterns characterise tumour-associated fibroblasts in bladder cancer. J Cancer Res Clin Oncol 2011; 137(5): 751-9.
[http://dx.doi.org/10.1007/s00432-010-0932-6] [PMID: 20607552]
[9]
Wang HB, Dembo M, Wang YL. Substrate flexibility regulates growth and apoptosis of normal but not transformed cells. Am J Physiol Cell Physiol 2000; 279(5): C1345-50.
[http://dx.doi.org/10.1152/ajpcell.2000.279.5.C1345] [PMID: 11029281]
[10]
Li J, Ding Y, Li A. Identification of COL1A1 and COL1A2 as candidate prognostic factors in gastric cancer. World J Surg Oncol 2016; 14(1): 297.
[http://dx.doi.org/10.1186/s12957-016-1056-5] [PMID: 27894325]
[11]
Boguslawska J, Kedzierska H, Poplawski P, Rybicka B, Tanski Z, Piekielko-Witkowska A. Expression of genes involved in cellular adhesion and extracellular matrix remodeling correlates with poor survival of patients with renal cancer. J Urol 2016; 195(6): 1892-902.
[http://dx.doi.org/10.1016/j.juro.2015.11.050] [PMID: 26631499]
[12]
Wang Y, Resnick MB, Lu S, et al. Collagen type III α1 as a useful diagnostic immunohistochemical marker for fibroepithelial lesions of the breast. Hum Pathol 2016; 57: 176-81.
[http://dx.doi.org/10.1016/j.humpath.2016.07.017] [PMID: 27498063]
[13]
Fischer H, Stenling R, Rubio C, Lindblom A. Colorectal carcinogenesis is associated with stromal expression of COL11A1 and COL5A2. Carcinogenesis 2001; 22(6): 875-8.
[http://dx.doi.org/10.1093/carcin/22.6.875] [PMID: 11375892]
[14]
Kamoun A, de Reyniès A, Allory Y, et al. Bladder cancer molecular taxonomy group. A consensus molecular classification of muscle-invasive bladder cancer. Eur Urol 2020; 77(4): 420-33.
[http://dx.doi.org/10.1016/j.eururo.2019.09.006] [PMID: 31563503]
[15]
Ho PL, Kurtova A, Chan KS. Normal and neoplastic urothelial stem cells: getting to the root of the problem. Nat Rev Urol 2012; 9(10): 583-94.
[http://dx.doi.org/10.1038/nrurol.2012.142] [PMID: 22890301]
[16]
Papafotiou G, Paraskevopoulou V, Vasilaki E, Kanaki Z, Paschalidis N, Klinakis A. KRT14 marks a subpopulation of bladder basal cells with pivotal role in regeneration and tumorigenesis. Nat Commun 2016; 7: 11914.
[http://dx.doi.org/10.1038/ncomms11914] [PMID: 27320313]
[17]
Volkmer JP, Sahoo D, Chin RK, et al. Three differentiation states risk-stratify bladder cancer into distinct subtypes. Proc Natl Acad Sci USA 2012; 109(6): 2078-83.
[http://dx.doi.org/10.1073/pnas.1120605109] [PMID: 22308455]
[18]
Guelstein VI, Tchipysheva TA, Ermilova VD, Troyanovsky SM. Immunohistochemical localization of cytokeratin 17 in transitional cell carcinomas of the human urinary tract. Virchows Arch B Cell Pathol Incl Mol Pathol 1993; 64(1): 1-5.
[http://dx.doi.org/10.1007/BF02915089] [PMID: 7691361]
[19]
Tschirdewahn S, Reis H, Niedworok C, et al. Prognostic effect of serum and tissue YKL-40 levels in bladder cancer. Urol Oncol 2014; 32(5): 663-9.
[http://dx.doi.org/10.1016/j.urolonc.2014.02.004] [PMID: 24814404]
[20]
Brooks M, Mo Q, Krasnow R, et al. Positive association of collagen type I with non-muscle invasive bladder cancer progression. Oncotarget 2016; 7(50): 82609-19.
[http://dx.doi.org/10.18632/oncotarget.12089] [PMID: 27655672]
[21]
Pudova EA, Kudryavtseva AV, Fedorova MS, et al. HK3 overexpression associated with epithelial-mesenchymal transition in colorectal cancer. BMC Genomics 2018; 19(Suppl. 3): 113.
[http://dx.doi.org/10.1186/s12864-018-4477-4] [PMID: 29504907]
[22]
Zhang Z, Wang Y, Zhang J, Zhong J, Yang R. COL1A1 promotes metastasis in colorectal cancer by regulating the WNT/PCP pathway. Mol Med Rep 2018; 17(4): 5037-42.
[http://dx.doi.org/10.3892/mmr.2018.8533] [PMID: 29393423]
[23]
Yuan L, Shu B, Chen L, et al. Overexpression of COL3A1 confers a poor prognosis in human bladder cancer identified by co-expression analysis. Oncotarget 2017; 8(41): 70508-20.
[http://dx.doi.org/10.18632/oncotarget.19733] [PMID: 29050298]
[24]
Su B, Zhao W, Shi B, et al. Let-7d suppresses growth, metastasis, and tumor macrophage infiltration in renal cell carcinoma by targeting COL3A1 and CCL7. Mol Cancer 2014; 13: 206.
[http://dx.doi.org/10.1186/1476-4598-13-206] [PMID: 25193015]
[25]
Zeng XT, Liu XP, Liu TZ, Wang XH. The clinical significance of COL5A2 in patients with bladder cancer: A retrospective analysis of bladder cancer gene expression data. Medicine (Baltimore) 2018; 97(10)e0091
[http://dx.doi.org/10.1097/MD.0000000000010091] [PMID: 29517678]
[26]
Vargas AC, McCart Reed AE, Waddell N, et al. Gene expression profiling of tumour epithelial and stromal compartments during breast cancer progression. Breast Cancer Res Treat 2012; 135(1): 153-65.
[http://dx.doi.org/10.1007/s10549-012-2123-4] [PMID: 22718308]
[27]
Nissen NI, Karsdal M, Willumsen N. Collagens and Cancer associated fibroblasts in the reactive stroma and its relation to Cancer biology. J Exp Clin Cancer Res 2019; 38(1): 115.
[http://dx.doi.org/10.1186/s13046-019-1110-6] [PMID: 30841909]
[28]
Coulson-Thomas VJ, Coulson-Thomas YM, Gesteira TF, et al. Colorectal cancer desmoplastic reaction up-regulates collagen synthesis and restricts cancer cell invasion. Cell Tissue Res 2011; 346(2): 223-36.
[http://dx.doi.org/10.1007/s00441-011-1254-y] [PMID: 21987222]
[29]
Robertson AG, Kim J, Al-Ahmadie H, et al. Comprehensive Molecular Characterization of Muscle-Invasive Bladder. Cancer Cell 2017; 171(3): 540-56 e25.
[http://dx.doi.org/10.1016/j.cell.2017.09.007]
[30]
Kim SP, Frank I, Cheville JC, et al. The impact of squamous and glandular differentiation on survival after radical cystectomy for urothelial carcinoma. J Urol 2012; 188(2): 405-9.
[http://dx.doi.org/10.1016/j.juro.2012.04.020] [PMID: 22704101]
[31]
Mitra AP, Bartsch CC, Bartsch G Jr, Miranda G, Skinner EC, Daneshmand S. Does presence of squamous and glandular differentiation in urothelial carcinoma of the bladder at cystectomy portend poor prognosis? An intensive case-control analysis. Urol Oncol 2014; 32(2): 117-27.
[http://dx.doi.org/10.1016/j.urolonc.2012.08.017] [PMID: 23477878]
[32]
Bertucci F, Finetti P, Birnbaum D. Basal breast cancer: a complex and deadly molecular subtype. Curr Mol Med 2012; 12(1): 96-110.
[http://dx.doi.org/10.2174/156652412798376134] [PMID: 22082486]
[33]
Choi W, Porten S, Kim S, et al. Identification of distinct basal and luminal subtypes of muscle-invasive bladder cancer with different sensitivities to frontline chemotherapy. Cancer Cell 2014; 25(2): 152-65.
[http://dx.doi.org/10.1016/j.ccr.2014.01.009] [PMID: 24525232]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version312msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[18:12:55] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[18:12:55] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[18:12:55] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[18:12:55] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (96.25ms)time
  • Application (216ms)time
  • 1 x Application (69.17%)
    216ms
    1 x Booting (30.83%)
    96.25ms
    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 duplicated142ms
    • 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 ('316674267','',1,1739988775,1739988775) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739988775
      1.01msalphaeurekaselec_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 ('316674267','/article/114544',1,1739988775,1739988775)
      160μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) 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 >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) 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 >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) 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 >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) 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 >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) 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 >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) limit 1
      12.24msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316674267
      • 1: 316674267
      • 2: 316674267
      • 3: 316674267
      • 4: 316674267
      • 5: 316674267
      • 6: 316674267
      • 7: 316674267
      • 8: 316674267
      • 9: 316674267
      • 10: 316674267
      • 11: 316674267
      • 12: 316674267
      • 13: 316674267
      • 14: 316674267
      • 15: 316674267
      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=114544
      730μ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` = 23 limit 1
      810μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 23
      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=23) and sj.journal_id!=23 group by `j`.`nid`) as `aggregate_table`
      890μsalphaeurekaselec_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=23) and sj.journal_id!=23 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      750μ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=23) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.79msalphaeurekaselec_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=23) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      2.39msalphaeurekaselec_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` = '114544'
      290μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 114544
      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` = '114544'
      790μsalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 114544
      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` = '114544' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      780μsalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 114544
      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
      220μ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
      440μ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 = 23 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      26.28msalphaeurekaselec_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 = 23 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      11.92msalphaeurekaselec_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 = 23 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      9.45msalphaeurekaselec_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` = 114544 limit 1
      250μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 114544
      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 = 114544 and content_type = 'article' order by status desc limit 1
      310μ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 = 433 and content_id!=114544 and cd.content_type = 'article' order by rand() limit 20
      46.54msalphaeurekaselec_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` = 191818 limit 1
      320μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 191818
      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
      290μ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` = 'CMM' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      350μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CMM
      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 = '114544' 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) )
      500μ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 = '11566' 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) )
      380μ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 = '3237' 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) )
      390μ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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739988775 and j.to_date >= 1739988775 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3237) 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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739988775 and j.to_date >= 1739988775 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3237) 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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739988775 and j.to_date >= 1739988775 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3237)
      12.96msalphaeurekaselec_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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739988775 and j.to_date >= 1739988775 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11566) 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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739988775 and j.to_date >= 1739988775 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11566) 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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739988775 and j.to_date >= 1739988775 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11566)
      630μ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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739988775 and j.to_date >= 1739988775 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 114544) 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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739988775 and j.to_date >= 1739988775 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 114544) 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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739988775 and j.to_date >= 1739988775 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 114544)
      610μ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` < '941' and is_uploaded = 1 and issue_id = 11566 order by cast(first_page as SIGNED) desc limit 1
      530μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 941
      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` > '949' and is_uploaded = 1 and issue_id = 11566 order by cast(first_page as SIGNED) asc limit 1
      460μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 949
      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'
      200μ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
      250μ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` = 114544 limit 1
      2.44msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 114544
      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` = 23 and `b`.`banner_from_date` <= 1739988775 and `b`.`banner_to_date` >= 1739988775 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: 23
      • 3: 1739988775
      • 4: 1739988775
      • 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` = 23 and `b`.`banner_from_date` <= 1739988775 and `b`.`banner_to_date` >= 1739988775 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.17msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 23
      • 3: 1739988775
      • 4: 1739988775
      • 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='239d7324c86bd4cf7f996e6884d7f61e'
      230μ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#?
    App\Models\MultiLangArticle
    1MultiLangArticle.php#?
        _token
        UkXY1spKFkWzDcRDIsvmuZ9hX329CbcspeS4P4o6
        uc_cart_id
        239d7324c86bd4cf7f996e6884d7f61e
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/114544" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/114544
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 19 Feb 2025 18:12:55 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlBKOTd1V21yMlVwV0dqY1B1ZW45WFE9PSIsInZhbHVlIjoibUFKOFlOQWNja1l4K0NGU0t3RDdKQ1NzVGZ3a09hWXpCSDJRempETFdmY29Bd2l6WVI5bGh0VGdQU1U1OFA5VjlOc1BDNmVrSm9rWU9vUmhEK0dWbzVOUGN6cXAyd3NVeXZsMWhFclFya3pINm9PNFpweURVUXplZXcycWQ1cloiLCJtYWMiOiJjMWFkODRlZmZjZTUxZjEwYzI4MDQ2NmU2YTM5N2JkZjIxMmUxZjBjNmFjNGFhNjhmYTBlNGUzMDhmZjZjYzY3IiwidGFnIjoiIn0%3D; expires=Sat, 22 Feb 2025 06:12:55 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlBKOTd1V21yMlVwV0dqY1B1ZW45WFE9PSIsInZhbHVlIjoibUFKOFlOQWNja1l4K0NGU0t3RDdKQ1NzVGZ3a09hWXpCSDJRempETFdmY29Bd2l6WVI5bGh0VGdQU1U1OFA5VjlOc1BDN" 1 => "alphaeurekaselectnet_session=eyJpdiI6InBMUmVEckljNzgxdXNwLy9IeXQ4Vmc9PSIsInZhbHVlIjoiME8raG82R2tVbEMrcnMwalZPajJtUVJsYlM0OEVEbkNHaHRUMTJlZjNsdVZHaVlKekZ3QzlqbGtCeS80QUNJNEd1Q094TVZXdzcwTzcxazkwM0hDeGl2Z2hnWTFEVEd3ZWtEYTFtbHo3N3IxZmZXM1dhSzZPYmZlRi8rQ3V2czAiLCJtYWMiOiJlMjBmMjNhMmM2ZmNiYzI4MzkyYzRkMzkwYzRlZTczZDBlNGU4MjY3NzJmNTU4NzI4ZDk3NjQ0Yzk0OGNlYTk4IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6InBMUmVEckljNzgxdXNwLy9IeXQ4Vmc9PSIsInZhbHVlIjoiME8raG82R2tVbEMrcnMwalZPajJtUVJsYlM0OEVEbkNHaHRUMTJlZjNsdVZHaVlKekZ3QzlqbGt" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlBKOTd1V21yMlVwV0dqY1B1ZW45WFE9PSIsInZhbHVlIjoibUFKOFlOQWNja1l4K0NGU0t3RDdKQ1NzVGZ3a09hWXpCSDJRempETFdmY29Bd2l6WVI5bGh0VGdQU1U1OFA5VjlOc1BDNmVrSm9rWU9vUmhEK0dWbzVOUGN6cXAyd3NVeXZsMWhFclFya3pINm9PNFpweURVUXplZXcycWQ1cloiLCJtYWMiOiJjMWFkODRlZmZjZTUxZjEwYzI4MDQ2NmU2YTM5N2JkZjIxMmUxZjBjNmFjNGFhNjhmYTBlNGUzMDhmZjZjYzY3IiwidGFnIjoiIn0%3D; expires=Sat, 22-Feb-2025 06:12:55 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlBKOTd1V21yMlVwV0dqY1B1ZW45WFE9PSIsInZhbHVlIjoibUFKOFlOQWNja1l4K0NGU0t3RDdKQ1NzVGZ3a09hWXpCSDJRempETFdmY29Bd2l6WVI5bGh0VGdQU1U1OFA5VjlOc1BDN" 1 => "alphaeurekaselectnet_session=eyJpdiI6InBMUmVEckljNzgxdXNwLy9IeXQ4Vmc9PSIsInZhbHVlIjoiME8raG82R2tVbEMrcnMwalZPajJtUVJsYlM0OEVEbkNHaHRUMTJlZjNsdVZHaVlKekZ3QzlqbGtCeS80QUNJNEd1Q094TVZXdzcwTzcxazkwM0hDeGl2Z2hnWTFEVEd3ZWtEYTFtbHo3N3IxZmZXM1dhSzZPYmZlRi8rQ3V2czAiLCJtYWMiOiJlMjBmMjNhMmM2ZmNiYzI4MzkyYzRkMzkwYzRlZTczZDBlNGU4MjY3NzJmNTU4NzI4ZDk3NjQ0Yzk0OGNlYTk4IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6InBMUmVEckljNzgxdXNwLy9IeXQ4Vmc9PSIsInZhbHVlIjoiME8raG82R2tVbEMrcnMwalZPajJtUVJsYlM0OEVEbkNHaHRUMTJlZjNsdVZHaVlKekZ3QzlqbGt" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "UkXY1spKFkWzDcRDIsvmuZ9hX329CbcspeS4P4o6" "uc_cart_id" => "239d7324c86bd4cf7f996e6884d7f61e" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/114544" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-19 18:12:55GET/article/114544414372