Research Article

细胞角蛋白和细胞外胶原蛋白表达在膀胱癌预后中的价值

卷 22, 期 10, 2022

发表于: 25 March, 2022

页: [941 - 949] 页: 9

弟呕挨: 10.2174/1566524021666210225100041

价格: $65

摘要

背景:胶原蛋白的表达水平与各种癌症的进展以及与细胞角蛋白的相互作用有关,但在膀胱癌(BC)中尚未得到充分的研究。因此,我们分析了1A1胶原蛋白(Col1a1/COL1A1)、3A1胶原蛋白(col3a1/COL3A1)、5A2胶原蛋白(col5a2/COL5A2)、细胞角蛋白14 (krt14/CK14)和细胞角蛋白17 (krt17/CK17)在不同分期BC尿路上皮标本中的基因和蛋白表达水平。 方法:对102份新鲜冷冻标本和190份福尔马林固定石蜡包埋(FFPE)标本进行免疫组化和RT-qPCR检测。表达水平与临床病理及随访数据相关。 结果: Col1a1, col3a1, col5a2 和 krt14 mRNA水平在高级别和肌肉浸润性BC (MIBC)中显著过表达,而在低级别和非肌肉浸润性BC (NMIBC)中显著过表达。col1a1 (p = 0.004)、col3a1 (p = 0.004)和col5a2 (p = 0.028)高表达患者的疾病特异性生存期(DSS)较短。与NMIBC相比,MIBC中CK14 (p = 0.020)、COL3A1 (p = 0.006)和Col5A2 (p = 0.006)蛋白表达水平显著升高,而CK17蛋白表达水平显著降低(p = 0.05)。此外,高级别BC中CK14 (p = 0.002)和COL5A2 (p = 0.006)蛋白表达水平显著高于低级别BC。COL5A2和CK14高表达组DSS较短(p = 0.033), CK14高表达组DSS较短(p = 0.042)。 结论:胶原和细胞角蛋白的表达变化是BC的单变量预后标志。

关键词: COL1A1, COL3A1, COL5A2, CK14, CK17,膀胱癌,上皮-间充质转化。

[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 Version338msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[18:11:34] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[18:11:34] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[18:11:34] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[18:11:34] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (112ms)time
  • Application (226ms)time
  • 1 x Application (66.94%)
    226ms
    1 x Booting (33.06%)
    112ms
    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
    41 statements were executed, 4 of which were duplicates, 37 unique. Show only duplicated134ms
    • 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 ('51803705','',1,1739988694,1739988694) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739988694
      920μ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 ('51803705','/article/114544/cn',1,1739988694,1739988694)
      200μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) 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 >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) 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 >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) 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 >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) 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 >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) 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 >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51803705 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51803705) limit 1
      11.94msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51803705
      • 1: 51803705
      • 2: 51803705
      • 3: 51803705
      • 4: 51803705
      • 5: 51803705
      • 6: 51803705
      • 7: 51803705
      • 8: 51803705
      • 9: 51803705
      • 10: 51803705
      • 11: 51803705
      • 12: 51803705
      • 13: 51803705
      • 14: 51803705
      • 15: 51803705
      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
      740μsalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 23 limit 1
      2.21msalphaeurekaselec_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`
      960μ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
      830μ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.85msalphaeurekaselec_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.41msalphaeurekaselec_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'
      300μ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'
      3.28msalphaeurekaselec_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
      2.52msalphaeurekaselec_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
      240μ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
      520μ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.77msalphaeurekaselec_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.57msalphaeurekaselec_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
      10.31msalphaeurekaselec_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
      290μ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
      400μ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
      30.21msalphaeurekaselec_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
      220μ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
      210μ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
      340μ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) )
      1.13msalphaeurekaselec_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) )
      310μ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) )
      270μ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 <= 51803705 and j.to_ip >=51803705 )) and ((j.from_date <= 1739988694 and j.to_date >= 1739988694 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 <= 51803705 and j.to_ip >=51803705 )) and ((j.from_date <= 1739988694 and j.to_date >= 1739988694 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 <= 51803705 and j.to_ip >=51803705 )) and ((j.from_date <= 1739988694 and j.to_date >= 1739988694 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)
      2.75msalphaeurekaselec_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 <= 51803705 and j.to_ip >=51803705 )) and ((j.from_date <= 1739988694 and j.to_date >= 1739988694 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 <= 51803705 and j.to_ip >=51803705 )) and ((j.from_date <= 1739988694 and j.to_date >= 1739988694 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 <= 51803705 and j.to_ip >=51803705 )) and ((j.from_date <= 1739988694 and j.to_date >= 1739988694 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)
      570μ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 <= 51803705 and j.to_ip >=51803705 )) and ((j.from_date <= 1739988694 and j.to_date >= 1739988694 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 <= 51803705 and j.to_ip >=51803705 )) and ((j.from_date <= 1739988694 and j.to_date >= 1739988694 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 <= 51803705 and j.to_ip >=51803705 )) and ((j.from_date <= 1739988694 and j.to_date >= 1739988694 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)
      560μ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
      570μ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
      450μ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` = 'cn'
      170μsalphaeurekaselec_live_10_06_2022ArticleController.php#2486
      Bindings
      • 0: cn
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2486
      • 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` = 2
      280μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 2
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2487
      • 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 `multilanguage_article` where (`language_id` = 2 and `article_id` = 114544)
      5.71msalphaeurekaselec_live_10_06_2022ArticleController.php#2488
      Bindings
      • 0: 2
      • 1: 114544
      Backtrace
      • 15. app/Http/Controllers/ArticleController.php:2488
      • 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
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `keyword` from `multilanguage_keywords` where (`language_id` = 2 and `article_id` = 114544)
      2.55msalphaeurekaselec_live_10_06_2022ArticleController.php#2489
      Bindings
      • 0: 2
      • 1: 114544
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2489
      • 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 CONCAT_WS(' ',au.first_name, ' ', ifnull(au.initials,''), ' ', au.last_name) as authors, CONCAT_WS(' ',au.last_name, ', ', ifnull(au.initials,''), ' ', au.first_name) as authorsRIS, CONCAT_WS(' ',au.last_name, ' ', ifnull(au.initials,''), ' ', au.first_name) as authorsCiteAs , `au`.*, (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 `multilanguage_authors` as `au` left join `multilanguage_author_affiliation` as `af` on `au`.`id` = `af`.`author_id` where `au`.`article_id` = 114544 group by `au`.`id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.66msalphaeurekaselec_live_10_06_2022MultiLangAuthor.php#30
      Bindings
      • 0: 114544
      Backtrace
      • 13. app/Models/MultiLangAuthor.php:30
      • 14. app/Http/Controllers/ArticleController.php:2493
      • 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 `multilanguage_journal`.`title` from `multilanguage_journal` where `multilanguage_journal`.`journal_id` = 23 and `language_id` = 2
      200μsalphaeurekaselec_live_10_06_2022ArticleController.php#2495
      Bindings
      • 0: 23
      • 1: 2
      Backtrace
      • 13. app/Http/Controllers/ArticleController.php:2495
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `id` from `multilanguage_article` where `article_id` = 114544 limit 1
      2.43msalphaeurekaselec_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` <= 1739988694 and `b`.`banner_to_date` >= 1739988694 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: 1739988694
      • 4: 1739988694
      • 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` <= 1739988694 and `b`.`banner_to_date` >= 1739988694 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.1msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 23
      • 3: 1739988694
      • 4: 1739988694
      • 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='0d0ff074e5b02cfc7634a80e3607e0c4'
      300μ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\MultiLangArticle
    2MultiLangArticle.php#?
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        1Tt7anmDAmk3s5Y8HxkAWU2Rci6bcSVPplibPKl7
        uc_cart_id
        0d0ff074e5b02cfc7634a80e3607e0c4
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/114544/cn" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/114544/cn
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:9 [ "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6IkUwTHMrOXFTR0VXbXhKRzdkZWxFU1E9PSIsInZhbHVlIjoiZE9PV2IxZUtpMU81dHRUTENHRnpXbkptUzBrZlkwL2dFOWdhQTZ2UHNBQT0iLCJtYWMiOiJiOTA3OTA1N2U3Nzg0YzcyMTI4NzQ3OWZlMzQ2MWRiZDMwYTk1ZDY3ZDlhYzdhN2UzMjA3N2ZlZDg4ZjIwNTdhIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IkUwTHMrOXFTR0VXbXhKRzdkZWxFU1E9PSIsInZhbHVlIjoiZE9PV2IxZUtpMU81dHRUTENHRnpXbkptUzBrZlkwL2dFOWdhQTZ2UHNBQT0iLCJtYWMiOiJiOTA3OTA1N2U3Nzg0" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 19 Feb 2025 18:11:34 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjJnLzRiL0VFVlJ4RmVYalBTMWNwc0E9PSIsInZhbHVlIjoiSUpDSHUrVVJ3OU5VOVhHdzh0d0VFR2sxaDFLN2xua0dwaGZ5SXlmblptS0xKYWdiZ2krOGZDektIOE54YWRjYmhlQnk1S3Z5VjR4NjR0eTVoWU41a0l4TGlYbnc5Q2NXMG5wNjNmZDU2MEhWdnNzUU1jUnppbjFWNS8yQ0pVYk8iLCJtYWMiOiJmZWYxMGI0NzJhODZlZmUzZWZlMTkyYjEyNTUzMmM1M2IwZTM5ZTYyMzEwN2NlYjgwNDA4ZDUzYWU0ODdmOTliIiwidGFnIjoiIn0%3D; expires=Sat, 22 Feb 2025 06:11:34 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjJnLzRiL0VFVlJ4RmVYalBTMWNwc0E9PSIsInZhbHVlIjoiSUpDSHUrVVJ3OU5VOVhHdzh0d0VFR2sxaDFLN2xua0dwaGZ5SXlmblptS0xKYWdiZ2krOGZDektIOE54YWRjYmhlQnk1S" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlV6YW0xNjhHU1hCMHRNOWRLOThla2c9PSIsInZhbHVlIjoidmZ5NGNJUHZxNEFwOG5WR1lsdElhOXNzazBzT0xCQ3YxUlYwck9xMGUwbXE3VC81VHJHcWRuZTYvam93R0k0bDhYSVArSnhhbzZTR1Q0TXFjSEVBQ24vRldVTmVMK1hNcHdKWUR3eDh6a2Y0TG80OEVpeVZCbmJBT20zc0sra1ciLCJtYWMiOiJjN2U3YzFlYzYzNzJiOGExOWYyNWY2ZGM2NzQ0Y2JkZTVkZGZmZTg2YWE1ZTQxMWY4ZWZlY2QyY2M4OGU0N2ZlIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlV6YW0xNjhHU1hCMHRNOWRLOThla2c9PSIsInZhbHVlIjoidmZ5NGNJUHZxNEFwOG5WR1lsdElhOXNzazBzT0xCQ3YxUlYwck9xMGUwbXE3VC81VHJHcWRuZTY" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjJnLzRiL0VFVlJ4RmVYalBTMWNwc0E9PSIsInZhbHVlIjoiSUpDSHUrVVJ3OU5VOVhHdzh0d0VFR2sxaDFLN2xua0dwaGZ5SXlmblptS0xKYWdiZ2krOGZDektIOE54YWRjYmhlQnk1S3Z5VjR4NjR0eTVoWU41a0l4TGlYbnc5Q2NXMG5wNjNmZDU2MEhWdnNzUU1jUnppbjFWNS8yQ0pVYk8iLCJtYWMiOiJmZWYxMGI0NzJhODZlZmUzZWZlMTkyYjEyNTUzMmM1M2IwZTM5ZTYyMzEwN2NlYjgwNDA4ZDUzYWU0ODdmOTliIiwidGFnIjoiIn0%3D; expires=Sat, 22-Feb-2025 06:11:34 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjJnLzRiL0VFVlJ4RmVYalBTMWNwc0E9PSIsInZhbHVlIjoiSUpDSHUrVVJ3OU5VOVhHdzh0d0VFR2sxaDFLN2xua0dwaGZ5SXlmblptS0xKYWdiZ2krOGZDektIOE54YWRjYmhlQnk1S" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlV6YW0xNjhHU1hCMHRNOWRLOThla2c9PSIsInZhbHVlIjoidmZ5NGNJUHZxNEFwOG5WR1lsdElhOXNzazBzT0xCQ3YxUlYwck9xMGUwbXE3VC81VHJHcWRuZTYvam93R0k0bDhYSVArSnhhbzZTR1Q0TXFjSEVBQ24vRldVTmVMK1hNcHdKWUR3eDh6a2Y0TG80OEVpeVZCbmJBT20zc0sra1ciLCJtYWMiOiJjN2U3YzFlYzYzNzJiOGExOWYyNWY2ZGM2NzQ0Y2JkZTVkZGZmZTg2YWE1ZTQxMWY4ZWZlY2QyY2M4OGU0N2ZlIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlV6YW0xNjhHU1hCMHRNOWRLOThla2c9PSIsInZhbHVlIjoidmZ5NGNJUHZxNEFwOG5WR1lsdElhOXNzazBzT0xCQ3YxUlYwck9xMGUwbXE3VC81VHJHcWRuZTY" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "1Tt7anmDAmk3s5Y8HxkAWU2Rci6bcSVPplibPKl7" "uc_cart_id" => "0d0ff074e5b02cfc7634a80e3607e0c4" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/114544/cn" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-19 18:11:34GET/article/114544/cn414413