Generic placeholder image

Current Gene Therapy

Editor-in-Chief

ISSN (Print): 1566-5232
ISSN (Online): 1875-5631

General Research Article

TRPM8 as a Potential Biomarker and Therapeutic Target for Gastric Cancer Identified by a Combination of Text Mining and RNA Sequencing

Author(s): Na Kong, Wendong Li, Jun Zhang, Xin Wang, Lin Hu and Qiqi Xu*

Volume 23, Issue 5, 2023

Published on: 13 June, 2023

Page: [391 - 399] Pages: 9

DOI: 10.2174/1566523223666230529142423

Price: $65

Abstract

Introduction: Gastric cancer is a well-known malignant tumor that causes millions of deaths worldwide every year. Due to the lack of a specific biomarker for gastric cancer, most patients are diagnosed at an advanced stage of the disease which results in a poor prognosis and a higher death rate. Therefore, novel biomarkers are urgently needed for early diagnosis and to improve the survival rate.

Methods: In this study, we conducted RNA sequencing of tumor samples from 21 patients with gastric cancer. A total of 3192 differentially expressed genes (1589 up-regulated and 1603 down-regulated) were identified. Subsequently, we applied a text-mining algorithm for further analysis of these data and selected 30 representative genes to investigate as candidates for novel biomarkers in gastric cancer.

Results: Among these genes, we confirmed transient receptor potential melastatin 8 channels (TRPM8) as a novel biomarker based on Western blot and immunochemistry validation performed on 134 samples. Compared to normal gastric tissue, the tumor tissues exhibited a significantly higher expression level of TRPM8.

Conclusion: This study provides insights into the underlying role of TRPM8 in cell proliferation. In addition, TRPM8 may be used as a potential therapeutic target for patients with gastric cancer.

Graphical Abstract

[1]
Digklia A, Wagner AD. Advanced gastric cancer: Current treatment landscape and future perspectives. World J Gastroenterol 2016; 22(8): 2403-14.
[http://dx.doi.org/10.3748/wjg.v22.i8.2403] [PMID: 26937129]
[2]
Smyth EC, Nilsson M, Grabsch HI, van Grieken NCT, Lordick F. Gastric cancer. Lancet 2020; 396(10251): 635-48.
[http://dx.doi.org/10.1016/S0140-6736(20)31288-5] [PMID: 32861308]
[3]
Ferlay J, Soerjomataram I, Dikshit R, et al. Cancer incidence and mortality worldwide: Sources, methods and major patterns in GLOBOCAN 2012. Int J Cancer 2015; 136(5): E359-86.
[http://dx.doi.org/10.1002/ijc.29210] [PMID: 25220842]
[4]
Feng RM, Zong YN, Cao SM, Xu RH. Current cancer situation in China: Good or bad news from the 2018 Global Cancer Statistics? Cancer Commun 2019; 39(1): 22.
[http://dx.doi.org/10.1186/s40880-019-0368-6] [PMID: 31030667]
[5]
Degiuli M, De Manzoni G, Di Leo A, et al. Gastric cancer: Current status of lymph node dissection. World J Gastroenterol 2016; 22(10): 2875-93.
[http://dx.doi.org/10.3748/wjg.v22.i10.2875] [PMID: 26973384]
[6]
Guo J, Dong B, Ji JF, Wu AW. Myofibrillogenesis regulator-1 overexpression is associated with poor prognosis of gastric cancer patients. World J Gastroenterol 2012; 18(38): 5434-41.
[http://dx.doi.org/10.3748/wjg.v18.i38.5434] [PMID: 23082061]
[7]
He C, Bian XY, Ni XZ, et al. Correlation of human epidermal growth factor receptor 2 expression with clinicopathological characteristics and prognosis in gastric cancer. World J Gastroenterol 2013; 19(14): 2171-8.
[http://dx.doi.org/10.3748/wjg.v19.i14.2171] [PMID: 23599643]
[8]
Jovanović J, Bagheri E. Semantic annotation in biomedicine: The current landscape. J Biomed Semantics 2017; 8(1): 44.
[http://dx.doi.org/10.1186/s13326-017-0153-x] [PMID: 28938912]
[9]
Altman RB, Bergman CM, Blake J, et al. Text mining for biology--the way forward: Opinions from leading scientists. Genome Biol 2008; 9 (Suppl. 2): S7.
[10]
Xiao Z, Hu L, Yang L, et al. TGFβ2 is a prognostic-related biomarker and correlated with immune infiltrates in gastric cancer. J Cell Mol Med 2020; 24(13): 7151-62.
[http://dx.doi.org/10.1111/jcmm.15164] [PMID: 32530106]
[11]
Xu Q, Kong N, Zhang J, Bai N, Bi J, Li W. Expression of transient receptor potential cation channel subfamily M member 8 in gastric cancer and its clinical significance. Exp Ther Med 2021; 21(4): 377.
[http://dx.doi.org/10.3892/etm.2021.9808] [PMID: 33680099]
[12]
Jensen LJ, Saric J, Bork P. Literature mining for the biologist: From information retrieval to biological discovery. Nat Rev Genet 2006; 7(2): 119-29.
[http://dx.doi.org/10.1038/nrg1768] [PMID: 16418747]
[13]
Wu J, Feng X, Guan R, Liang Y. Cancer research trend analysis based on fusion feature representation. Entropy 2021; 23(3): 338.
[http://dx.doi.org/10.3390/e23030338] [PMID: 33809188]
[14]
Hassani H, Beneki C, Unger S, Mazinani MT, Yeganegi MR. Text mining in big data analytics. Big Data Cogn 2020; 4(1): 1.
[http://dx.doi.org/10.3390/bdcc4010001]
[15]
Gonzalez GH, Tahsin T, Goodale BC, Greene AC, Greene CS. Recent advances and emerging applications in text and data mining for biomedical discovery. Brief Bioinform 2016; 17(1): 33-42.
[http://dx.doi.org/10.1093/bib/bbv087] [PMID: 26420781]
[16]
Tsavaler L, Shapero MH, Morkowski S, Laus R. Trp-p8, a novel prostate-specific gene, is up-regulated in prostate cancer and other malignancies and shares high homology with transient receptor potential calcium channel proteins. Cancer Res 2001; 61(9): 3760-9.
[PMID: 11325849]
[17]
Liu Y, Mikrani R, He Y, et al. TRPM8 channels: A review of distribution and clinical role. Eur J Pharmacol 2020; 882173312
[http://dx.doi.org/10.1016/j.ejphar.2020.173312] [PMID: 32610057]
[18]
Hantute-Ghesquier A, Haustrate A, Prevarskaya N, Lehen’kyi V. TRPM family channels in cancer. Pharmaceuticals 2018; 11(2): 58.
[http://dx.doi.org/10.3390/ph11020058] [PMID: 29875336]
[19]
Zhang L, Barritt GJ. Evidence that TRPM8 is an androgen-dependent Ca2+ channel required for the survival of prostate cancer cells. Cancer Res 2004; 64(22): 8365-73.
[http://dx.doi.org/10.1158/0008-5472.CAN-04-2146] [PMID: 15548706]
[20]
Legrand G, Humez S, Slomianny C, et al. Ca2+ pools and cell growth. Evidence for sarcoendoplasmic Ca2+-ATPases 2B involvement in human prostate cancer cell growth control. J Biol Chem 2001; 276(50): 47608-14.
[http://dx.doi.org/10.1074/jbc.M107011200] [PMID: 11606580]
[21]
Yang ZH, Wang XH, Wang HP, Hu LQ. Effects of TRPM8 on the proliferation and motility of prostate cancer PC-3 cells. Asian J Androl 2009; 11(2): 157-65.
[http://dx.doi.org/10.1038/aja.2009.1] [PMID: 19234481]
[22]
Gkika D, Flourakis M, Lemonnier L, Prevarskaya N. PSA reduces prostate cancer cell motility by stimulating TRPM8 activity and plasma membrane expression. Oncogene 2010; 29(32): 4611-6.
[http://dx.doi.org/10.1038/onc.2010.210] [PMID: 20531306]
[23]
Cucu D, Chiritoiu G, Petrescu S, et al. Characterization of functional transient receptor potential melastatin 8 channels in human pancreatic ductal adenocarcinoma cells. Pancreas 2014; 43(5): 795-800.
[http://dx.doi.org/10.1097/MPA.0000000000000106] [PMID: 24658318]
[24]
Borrelli F, Pagano E, Romano B, et al. Colon carcinogenesis is inhibited by the TRPM8 antagonist cannabigerol, a Cannabis-derived non-psychotropic cannabinoid. Carcinogenesis 2014; 35(12): 2787-97.
[http://dx.doi.org/10.1093/carcin/bgu205] [PMID: 25269802]
[25]
Yee NS, Zhou W, Lee M. Transient receptor potential channel TRPM8 is over-expressed and required for cellular proliferation in pancreatic adenocarcinoma. Cancer Lett 2010; 297(1): 49-55.
[http://dx.doi.org/10.1016/j.canlet.2010.04.023] [PMID: 20605675]
[26]
Li Q, Wang X, Yang Z, Wang B, Li S. Menthol induces cell death via the TRPM8 channel in the human bladder cancer cell line T24. Oncology 2009; 77(6): 335-41.
[http://dx.doi.org/10.1159/000264627] [PMID: 19955836]
[27]
Fan H, Shen YX, Yuan YF. Expression and prognostic roles of TRPV5 and TRPV6 in non-small cell lung cancer after curative resection. Asian Pac J Cancer Prev 2014; 15(6): 2559-63.
[http://dx.doi.org/10.7314/APJCP.2014.15.6.2559] [PMID: 24761864]
[28]
Wong KK, Banham AH, Yaacob NS, Nur Husna SM. The oncogenic roles of TRPM ion channels in cancer. J Cell Physiol 2019; 234(9): 14556-73.
[http://dx.doi.org/10.1002/jcp.28168] [PMID: 30710353]
[29]
Lashinger ESR, Steiginga MS, Hieble JP, et al. AMTB, a TRPM8 channel blocker: Evidence in rats for activity in overactive bladder and painful bladder syndrome. Am J Physiol Renal Physiol 2008; 295(3): F803-10.
[http://dx.doi.org/10.1152/ajprenal.90269.2008] [PMID: 18562636]
[30]
Liu Z, Wu H, Wei Z, et al. TRPM8: A potential target for cancer treatment. J Cancer Res Clin Oncol 2016; 142(9): 1871-81.
[http://dx.doi.org/10.1007/s00432-015-2112-1] [PMID: 26803314]
[31]
Zhao W, Xu H. High expression of TRPM8 predicts poor prognosis in patients with osteosarcoma. Oncol Lett 2016; 12(2): 1373-9.
[http://dx.doi.org/10.3892/ol.2016.4764] [PMID: 27446440]
[32]
Valero ML, Mello de Queiroz F, Stühmer W, Viana F, Pardo LA. TRPM8 ion channels differentially modulate proliferation and cell cycle distribution of normal and cancer prostate cells. PLoS One 2012; 7(12)e51825
[http://dx.doi.org/10.1371/journal.pone.0051825] [PMID: 23251635]
[33]
Yu S, Xu Z, Zou C, et al. Ion channel TRPM8 promotes hypoxic growth of prostate cancer cells via an O2 -independent and RACK1-mediated mechanism of HIF-1α stabilization. J Pathol 2014; 234(4): 514-25.
[http://dx.doi.org/10.1002/path.4413] [PMID: 25065497]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version657msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:43:46] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:43:47] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:43:47] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:43:47] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (145ms)time
  • Application (513ms)time
  • 1 x Application (78%)
    513ms
    1 x Booting (22%)
    145ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    36 statements were executed, 4 of which were duplicates, 32 unique. Show only duplicated400ms
    • 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 ('51364601','',1,1740775426,1740775426) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740775426
      1.25msalphaeurekaselec_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 ('51364601','/article/132135',1,1740775426,1740775426)
      230μ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 >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) 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 >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) 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 >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) 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 >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) 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 >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) 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 >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51364601 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51364601) limit 1
      21.23msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51364601
      • 1: 51364601
      • 2: 51364601
      • 3: 51364601
      • 4: 51364601
      • 5: 51364601
      • 6: 51364601
      • 7: 51364601
      • 8: 51364601
      • 9: 51364601
      • 10: 51364601
      • 11: 51364601
      • 12: 51364601
      • 13: 51364601
      • 14: 51364601
      • 15: 51364601
      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=132135
      16.15msalphaeurekaselec_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` = 28 limit 1
      1.17msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 28
      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=28) and sj.journal_id!=28 group by `j`.`nid`) as `aggregate_table`
      1.31msalphaeurekaselec_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=28) and sj.journal_id!=28 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      970μ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=28) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      139msalphaeurekaselec_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=28) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      12.47msalphaeurekaselec_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` = '132135'
      370μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 132135
      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` = '132135'
      5.9msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 132135
      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` = '132135' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.32msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 132135
      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
      390μ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
      740μ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 = 28 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      47.49msalphaeurekaselec_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 = 28 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      7.69msalphaeurekaselec_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 = 28 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      6.36msalphaeurekaselec_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` = 132135 limit 1
      10.55msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 132135
      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 = 132135 and content_type = 'article' order by status desc limit 1
      360μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 217416 limit 1
      260μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 217416
      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
      9.36msalphaeurekaselec_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` = 'CGT' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      500μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CGT
      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 = '132135' 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) )
      520μ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 = '12698' 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) )
      480μ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 = '3333' 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) )
      12.94msalphaeurekaselec_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 <= 51364601 and j.to_ip >=51364601 )) and ((j.from_date <= 1740775427 and j.to_date >= 1740775427 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3333) 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 <= 51364601 and j.to_ip >=51364601 )) and ((j.from_date <= 1740775427 and j.to_date >= 1740775427 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3333) 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 <= 51364601 and j.to_ip >=51364601 )) and ((j.from_date <= 1740775427 and j.to_date >= 1740775427 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3333)
      72.55msalphaeurekaselec_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 <= 51364601 and j.to_ip >=51364601 )) and ((j.from_date <= 1740775427 and j.to_date >= 1740775427 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12698) 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 <= 51364601 and j.to_ip >=51364601 )) and ((j.from_date <= 1740775427 and j.to_date >= 1740775427 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12698) 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 <= 51364601 and j.to_ip >=51364601 )) and ((j.from_date <= 1740775427 and j.to_date >= 1740775427 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12698)
      1.18msalphaeurekaselec_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 <= 51364601 and j.to_ip >=51364601 )) and ((j.from_date <= 1740775427 and j.to_date >= 1740775427 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 132135) 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 <= 51364601 and j.to_ip >=51364601 )) and ((j.from_date <= 1740775427 and j.to_date >= 1740775427 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 132135) 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 <= 51364601 and j.to_ip >=51364601 )) and ((j.from_date <= 1740775427 and j.to_date >= 1740775427 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 132135)
      1.07msalphaeurekaselec_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` < '391' and is_uploaded = 1 and issue_id = 12698 order by cast(first_page as SIGNED) desc limit 1
      1.04msalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 391
      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` > '399' and is_uploaded = 1 and issue_id = 12698 order by cast(first_page as SIGNED) asc limit 1
      850μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 399
      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'
      300μ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
      360μ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` = 132135 limit 1
      4.09msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 132135
      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` = 28 and `b`.`banner_from_date` <= 1740775427 and `b`.`banner_to_date` >= 1740775427 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.81msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 28
      • 3: 1740775427
      • 4: 1740775427
      • 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` = 28 and `b`.`banner_from_date` <= 1740775427 and `b`.`banner_to_date` >= 1740775427 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      15.95msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 28
      • 3: 1740775427
      • 4: 1740775427
      • 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='77a8051c26739ff6ccbac591b45bfeed'
      550μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:291
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        bMCTizHsyDWcxsOOn1xhmmmTZmOHb0oTmBMZVCyS
        uc_cart_id
        77a8051c26739ff6ccbac591b45bfeed
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/132135" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/132135
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 28 Feb 2025 20:43:47 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjF6citTY1NxcXZpU2ZJZGlQdDQ2RWc9PSIsInZhbHVlIjoidlF5NktlK2NqQjRkdm5VMnpabThpdHFMVTQrTVVXdHZHTnlla3hsTkllaFRTc2FMb2liOEhReFRmR3RaTW9MaGpnZ0p2TjYzbGFISUxIdWlVUzJDQkNKUG5JaVlWeGl3YmNpUlAzSGR6cyt1S2tEeFdUZy9iWHlwME1waW9qT3giLCJtYWMiOiI2ZGQ2ZmFiY2Q1MDAwNGYyNTVmMzNkN2ZmOTNkMzliYTA2ZDA4ODU0NjA0YTc5OGNhZGQwODFlOThlMmQ1MzIzIiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 08:43:47 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjF6citTY1NxcXZpU2ZJZGlQdDQ2RWc9PSIsInZhbHVlIjoidlF5NktlK2NqQjRkdm5VMnpabThpdHFMVTQrTVVXdHZHTnlla3hsTkllaFRTc2FMb2liOEhReFRmR3RaTW9MaGpnZ0p2T" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjRIakRXc09EMythVmMrVC8yTk84OGc9PSIsInZhbHVlIjoibDQ3OXhQTjJaQW9jaE9ERU96TzNOdXhQS3k5K0xQcXRWY3BlL2dvZWh4Q2E4UWRHSGZRWG5WZTVqRUFmWFNuVUlKTkh2R2N0NnpEek1nNXJqSE1lS2xsQmlkRTM5M0xiWXg5YjhVaWE2a3l1U2krQ1dTVUtSbGVqdkRlWENyL3QiLCJtYWMiOiIxZTUwMTlhMzAyN2IwZDQ5YjgxNzYyN2MxODNkMWVlZDEyZWRlODc4ZTdjOTVmMzY5YzRlNTBhYWZkYTkxYzQ4IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IjRIakRXc09EMythVmMrVC8yTk84OGc9PSIsInZhbHVlIjoibDQ3OXhQTjJaQW9jaE9ERU96TzNOdXhQS3k5K0xQcXRWY3BlL2dvZWh4Q2E4UWRHSGZRWG5WZTV" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjF6citTY1NxcXZpU2ZJZGlQdDQ2RWc9PSIsInZhbHVlIjoidlF5NktlK2NqQjRkdm5VMnpabThpdHFMVTQrTVVXdHZHTnlla3hsTkllaFRTc2FMb2liOEhReFRmR3RaTW9MaGpnZ0p2TjYzbGFISUxIdWlVUzJDQkNKUG5JaVlWeGl3YmNpUlAzSGR6cyt1S2tEeFdUZy9iWHlwME1waW9qT3giLCJtYWMiOiI2ZGQ2ZmFiY2Q1MDAwNGYyNTVmMzNkN2ZmOTNkMzliYTA2ZDA4ODU0NjA0YTc5OGNhZGQwODFlOThlMmQ1MzIzIiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 08:43:47 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjF6citTY1NxcXZpU2ZJZGlQdDQ2RWc9PSIsInZhbHVlIjoidlF5NktlK2NqQjRkdm5VMnpabThpdHFMVTQrTVVXdHZHTnlla3hsTkllaFRTc2FMb2liOEhReFRmR3RaTW9MaGpnZ0p2T" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjRIakRXc09EMythVmMrVC8yTk84OGc9PSIsInZhbHVlIjoibDQ3OXhQTjJaQW9jaE9ERU96TzNOdXhQS3k5K0xQcXRWY3BlL2dvZWh4Q2E4UWRHSGZRWG5WZTVqRUFmWFNuVUlKTkh2R2N0NnpEek1nNXJqSE1lS2xsQmlkRTM5M0xiWXg5YjhVaWE2a3l1U2krQ1dTVUtSbGVqdkRlWENyL3QiLCJtYWMiOiIxZTUwMTlhMzAyN2IwZDQ5YjgxNzYyN2MxODNkMWVlZDEyZWRlODc4ZTdjOTVmMzY5YzRlNTBhYWZkYTkxYzQ4IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IjRIakRXc09EMythVmMrVC8yTk84OGc9PSIsInZhbHVlIjoibDQ3OXhQTjJaQW9jaE9ERU96TzNOdXhQS3k5K0xQcXRWY3BlL2dvZWh4Q2E4UWRHSGZRWG5WZTV" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "bMCTizHsyDWcxsOOn1xhmmmTZmOHb0oTmBMZVCyS" "uc_cart_id" => "77a8051c26739ff6ccbac591b45bfeed" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/132135" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 20:43:47GET/article/132135414361