Generic placeholder image

Current Pharmaceutical Design

Editor-in-Chief

ISSN (Print): 1381-6128
ISSN (Online): 1873-4286

Research Article

Involvement of CHRNA6 in the Immune Response in Lung Squamous Cell Carcinoma and its Potential as a Drug Target for the Disease

Author(s): Fengyu Zhang, Meidi Zhang, Xin Yuan, Yulian Tao and Ju Wang*

Volume 29, Issue 26, 2023

Published on: 14 September, 2023

Page: [2091 - 2100] Pages: 10

DOI: 10.2174/1381612829666230901143203

Price: $65

Abstract

Background: Lung squamous cell carcinoma (LUSC) is a subtype of lung cancer with a poor prognosis and limited treatment options. Previous studies show that some components of the cholinergic pathway may play important roles in the tumorigenesis of lung cancer, including LUSC.

Objective: The purpose of this study is to investigate the involvement of cholinergic genes in immune infiltration in LUSC, and identify the key genes in the pathway and analyze their potential as targets for LUSC treatment and novel drugs.

Methods: We first screened the cholinergic genes associated with immune infiltration in LUSC based on transcriptomic samples and explored the correlation between the key genes and immune infiltrating cells and immune pathways. Then, we assessed the effect of immunotherapeutic response in the high and low-expression groups of key genes in vitro. And finally, we screened potential drugs for the treatment of LUSC.

Results: We found that the expression of CHRNA6, the gene encoding the α6 subunit of nicotinic acetylcholine receptors (nAChR), was significantly correlated with the proportion of immune infiltrating cells in LUSC, and the high expression level of the gene was associated with poor prognosis of the disease. Also, the proportion of Tregs, M1 macrophages, and resting mast cells was correlated with the expression of CHRNA6. In addition, LUSC patients with higher CHRNA6 expression levels had better immunotherapy responses. Furthermore, we found that the drugs, i.e., adavosertib, varbulin and pyrazoloacridine, had a strong affinity with CHRNA6, with adavosertib binding most stably with the protein.

Conclusion: CHRNA6 may be associated with immune infiltration in LUSC and affects patient prognosis and immunotherapeutic response by regulating immune cells and immune pathways. In addition, adavosertib may be a potential drug for the treatment of LUSC.

[1]
Sung H, Ferlay J, Siegel RL, et al. Global cancer statistics 2020: GLOBOCAN estimates of incidence and mortality worldwide for 36 cancers in 185 countries. CA Cancer J Clin 2021; 71(3): 209-49.
[http://dx.doi.org/10.3322/caac.21660] [PMID: 33538338]
[2]
Pan Y, Han H, Labbe KE, Zhang H, Wong KK. Recent advances in preclinical models for lung squamous cell carcinoma. Oncogene 2021; 40(16): 2817-29.
[http://dx.doi.org/10.1038/s41388-021-01723-7] [PMID: 33707749]
[3]
Travis WD, Brambilla E, Nicholson AG, et al. The 2015 world health organization classification of lung tumors: Impact of genetic, clinical and radiologic advances since the 2004 classification. J Thorac Oncol 2015; 10: 1243-60.
[4]
Lazarus KA, Hadi F, Zambon E, et al. BCL11A interacts with SOX2 to control the expression of epigenetic regulators in lung squamous carcinoma. Nat Commun 2018; 9(1): 3327.
[http://dx.doi.org/10.1038/s41467-018-05790-5] [PMID: 30127402]
[5]
Yuan G, Flores NM, Hausmann S, et al. Elevated NSD3 histone methylation activity drives squamous cell lung cancer. Nature 2021; 590(7846): 504-8.
[http://dx.doi.org/10.1038/s41586-020-03170-y] [PMID: 33536620]
[6]
Yang M, Lin C, Wang Y, Chen K, Zhang H, Li W. Identification of a cytokine-dominated immunosuppressive class in squamous cell lung carcinoma with implications for immunotherapy resistance. Genome Med 2022; 14(1): 72.
[http://dx.doi.org/10.1186/s13073-022-01079-x] [PMID: 35799269]
[7]
Wang C, Yu Q, Song T, et al. The heterogeneous immune landscape between lung adenocarcinoma and squamous carcinoma revealed by single-cell RNA sequencing. Signal Transduct Target Ther 2022; 7(1): 289.
[http://dx.doi.org/10.1038/s41392-022-01130-8] [PMID: 36008393]
[8]
Spindel ER. Cholinergic targets in lung cancer. Curr Pharm Des 2016; 22(14): 2152-9.
[http://dx.doi.org/10.2174/1381612822666160127114237] [PMID: 26818857]
[9]
Song P, Sekhon HS, Fu XW, et al. Activated cholinergic signaling provides a target in squamous cell lung carcinoma. Cancer Res 2008; 68(12): 4693-700.
[http://dx.doi.org/10.1158/0008-5472.CAN-08-0183] [PMID: 18559515]
[10]
Nie M, Chen N, Pang H, et al. Targeting acetylcholine signaling modulates persistent drug tolerance in EGFR-mutant lung cancer and impedes tumor relapse. J Clin Invest 2022; 132(20): e160152.
[http://dx.doi.org/10.1172/JCI160152] [PMID: 36048538]
[11]
Dubash S, Inglese M, Mauri F, et al. Spatial heterogeneity of radiolabeled choline positron emission tomography in tumors of patients with non-small cell lung cancer: First-in-patient evaluation of [(18)F]fluoromethyl-(1,2-(2)H(4))-choline. Theranostics 2020; 10: 8677-90.
[http://dx.doi.org/10.7150/thno.47298] [PMID: 32754271]
[12]
Russo P, Catassi A, Cesario A, Servent D. Development of novel therapeutic strategies for lung cancer: Targeting the cholinergic system. Curr Med Chem 2006; 13(29): 3493-512.
[http://dx.doi.org/10.2174/092986706779026192] [PMID: 17168719]
[13]
Xiao Y, Yu D. Tumor microenvironment as a therapeutic target in cancer. Pharmacol Ther 2021; 221: 107753.
[http://dx.doi.org/10.1016/j.pharmthera.2020.107753] [PMID: 33259885]
[14]
Hutchings C, Phillips JA, Djamgoz MBA. Nerve input to tumours: Pathophysiological consequences of a dynamic relationship. Biochim Biophys Acta Rev Cancer 2020; 1874(2): 188411.
[http://dx.doi.org/10.1016/j.bbcan.2020.188411] [PMID: 32828885]
[15]
Horvath L, Thienpont B, Zhao L, Wolf D, Pircher A. Overcoming immunotherapy resistance in non-small cell lung cancer (NSCLC) - novel approaches and future outlook. Mol Cancer 2020; 19(1): 141.
[http://dx.doi.org/10.1186/s12943-020-01260-z] [PMID: 32917214]
[16]
Hoft NR, Corley RP, McQueen MB, et al. Genetic association of the CHRNA6 and CHRNB3 genes with tobacco dependence in a nationally representative sample. Neuropsychopharmacol 2009; 34: 698-706.
[http://dx.doi.org/10.1038/npp.2008.122]
[17]
Zhang X, Zhang R, Liu P, et al. ATP8B1 knockdown activated the choline metabolism pathway and induced high-level intracellular REDOX homeostasis in lung squamous cell carcinoma. Cancers (Basel) 2022; 14(3): 835.
[http://dx.doi.org/10.3390/cancers14030835] [PMID: 35159102]
[18]
Kanehisa M, Furumichi M, Sato Y, Ishiguro-Watanabe M, Tanabe M. KEGG: integrating viruses and cellular organisms. Nucleic Acids Res 2021; 49(D1): D545-51.
[http://dx.doi.org/10.1093/nar/gkaa970] [PMID: 33125081]
[19]
Jassal B, Matthews L, Viteri G, et al. The reactome pathway knowledgebase. Nucleic Acids Res 2020; 48(D1): D498-503.
[PMID: 31691815]
[20]
Martens M, Ammar A, Riutta A, et al. WikiPathways: Connecting communities. Nucleic Acids Res 2021; 49(D1): D613-21.
[http://dx.doi.org/10.1093/nar/gkaa1024] [PMID: 33211851]
[21]
Rodchenkov I, Babur O, Luna A, et al. Pathway Commons 2019 Update: Integration, analysis and exploration of pathway data. Nucleic Acids Res 2020; 48(D1): D489-97.
[PMID: 31647099]
[22]
Yoshihara K, Shahmoradgoli M, Martínez E, et al. Inferring tumour purity and stromal and immune cell admixture from expression data. Nat Commun 2013; 4(1): 2612.
[http://dx.doi.org/10.1038/ncomms3612] [PMID: 24113773]
[23]
Newman AM, Liu CL, Green MR, et al. Robust enumeration of cell subsets from tissue expression profiles. Nat Methods 2015; 12(5): 453-7.
[http://dx.doi.org/10.1038/nmeth.3337] [PMID: 25822800]
[24]
Charoentong P, Finotello F, Angelova M, et al. Pan-cancer immunogenomic analyses reveal genotype-immunophenotype relationships and predictors of response to checkpoint blockade. Cell Rep 2017; 18(1): 248-62.
[http://dx.doi.org/10.1016/j.celrep.2016.12.019] [PMID: 28052254]
[25]
Jiang P, Gu S, Pan D, et al. Signatures of T cell dysfunction and exclusion predict cancer immunotherapy response. Nat Med 2018; 24(10): 1550-8.
[http://dx.doi.org/10.1038/s41591-018-0136-1] [PMID: 30127393]
[26]
Sha D, Jin Z, Budczies J, Kluck K, Stenzinger A, Sinicrope FA. Tumor mutational burden as a predictive biomarker in solid tumors. Cancer Discov 2020; 10(12): 1808-25.
[http://dx.doi.org/10.1158/2159-8290.CD-20-0522] [PMID: 33139244]
[27]
Tang B, Zhu J, Zhao Z, et al. Diagnosis and prognosis models for hepatocellular carcinoma patient’s management based on tumor mutation burden. J Adv Res 2021; 33: 153-65.
[http://dx.doi.org/10.1016/j.jare.2021.01.018] [PMID: 34603786]
[28]
Liu Z, Li M, Jiang Z, Wang X. A Comprehensive immunologic portrait of triple-negative breast cancer. Transl Oncol 2018; 11(2): 311-29.
[http://dx.doi.org/10.1016/j.tranon.2018.01.011] [PMID: 29413765]
[29]
Jumper J, Evans R, Pritzel A, et al. Highly accurate protein structure prediction with AlphaFold. Nature 2021; 596(7873): 583-9.
[http://dx.doi.org/10.1038/s41586-021-03819-2] [PMID: 34265844]
[30]
Halder N, Lal G. Cholinergic system and its therapeutic importance in inflammation and autoimmunity. Front Immunol 2021; 12: 660342.
[http://dx.doi.org/10.3389/fimmu.2021.660342] [PMID: 33936095]
[31]
Glunde K, Bhujwalla ZM. Choline kinase alpha in cancer prognosis and treatment. Lancet Oncol 2007; 8(10): 855-7.
[http://dx.doi.org/10.1016/S1470-2045(07)70289-9] [PMID: 17913651]
[32]
Grando SA. Connections of nicotine to cancer. Nat Rev Cancer 2014; 14(6): 419-29.
[http://dx.doi.org/10.1038/nrc3725] [PMID: 24827506]
[33]
Loeb LA, Ernster VL, Warner KE, Abbotts J, Laszlo J. Smoking and lung cancer: An overview. Cancer Res 1984; 44(12 Pt 1): 5940-58.
[PMID: 6388830]
[34]
Ma W, Zhao F, Yu X, et al. Immune-related lncRNAs as predictors of survival in breast cancer: a prognostic signature. J Transl Med 2020; 18(1): 442.
[http://dx.doi.org/10.1186/s12967-020-02522-6] [PMID: 33225954]
[35]
Wen L, Han H, Liu Q, et al. Significant association of the CHRNB3-CHRNA6 gene cluster with nicotine dependence in the Chinese Han population. Sci Rep 2017; 7(1): 9745.
[http://dx.doi.org/10.1038/s41598-017-09492-8] [PMID: 28851948]
[36]
Tanaka A, Sakaguchi S. Regulatory T cells in cancer immunotherapy. Cell Res 2017; 27(1): 109-18.
[http://dx.doi.org/10.1038/cr.2016.151] [PMID: 27995907]
[37]
Salamon P, Mekori YA, Shefler I. Lung cancer-derived extracellular vesicles: a possible mediator of mast cell activation in the tumor microenvironment. Cancer Immunol Immunother 2020; 69(3): 373-81.
[http://dx.doi.org/10.1007/s00262-019-02459-w] [PMID: 31897659]
[38]
Wang J, Meng F, Song W, et al. Nanostructured titanium regulates osseointegration via influencing macrophage polarization in the osteogenic environment. Int J Nanomedicine 2018; 13: 4029-43.
[http://dx.doi.org/10.2147/IJN.S163956] [PMID: 30022825]
[39]
Zhao R, Wan Q, Wang Y, et al. M1-like TAMs are required for the efficacy of PD-L1/PD-1 blockades in gastric cancer. OncoImmunology 2021; 10(1)1862520
[http://dx.doi.org/10.1080/2162402X.2020.1862520] [PMID: 33457080]
[40]
Sebolt JS, Scavone SV, Pinter CD, Hamelehle KL, Von Hoff DD, Jackson RC. Pyrazoloacridines, a new class of anticancer agents with selectivity against solid tumors in vitro. Cancer Res 1987; 47(16): 4299-304.
[PMID: 2440564]
[41]
Lallo A, Frese KK, Morrow CJ, et al. The combination of the PARP inhibitor Olaparib and the WEE1 inhibitor AZD1775 as a new therapeutic option for small cell lung cancer. Clin Cancer Res 2018; 24(20): 5153-64.
[http://dx.doi.org/10.1158/1078-0432.CCR-17-2805] [PMID: 29941481]
[42]
Kasibhatla S, Baichwal V, Cai SX, et al. MPC-6827: A small- molecule inhibitor of microtubule formation that is not a substrate for multidrug resistance pumps. Cancer Res 2007; 67(12): 5865-71.
[http://dx.doi.org/10.1158/0008-5472.CAN-07-0127] [PMID: 17575155]
[43]
Lheureux S, Cristea MC, Bruce JP, et al. Adavosertib plus gemcitabine for platinum-resistant or platinum-refractory recurrent ovarian cancer: a double-blind, randomised, placebo-controlled, phase 2 trial. Lancet 2021; 397(10271): 281-92.
[http://dx.doi.org/10.1016/S0140-6736(20)32554-X] [PMID: 33485453]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version414msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:16:11] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:16:11] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:16:11] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:16:11] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:16:11] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (104ms)time
  • Application (310ms)time
  • 1 x Application (74.85%)
    310ms
    1 x Booting (25.15%)
    104ms
    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 duplicated213ms
    • 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 ('314549955','',1,1740514571,1740514571) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740514571
      1.32msalphaeurekaselec_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 ('314549955','/article/134228',1,1740514571,1740514571)
      240μ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 >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) 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 >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) 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 >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) 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 >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) 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 >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) 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 >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) limit 1
      17.3msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314549955
      • 1: 314549955
      • 2: 314549955
      • 3: 314549955
      • 4: 314549955
      • 5: 314549955
      • 6: 314549955
      • 7: 314549955
      • 8: 314549955
      • 9: 314549955
      • 10: 314549955
      • 11: 314549955
      • 12: 314549955
      • 13: 314549955
      • 14: 314549955
      • 15: 314549955
      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=134228
      990μ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` = 29 limit 1
      1.13msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 29
      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=29) and sj.journal_id!=29 group by `j`.`nid`) as `aggregate_table`
      1.47msalphaeurekaselec_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=29) and sj.journal_id!=29 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.23msalphaeurekaselec_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=29) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.1msalphaeurekaselec_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=29) 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.07msalphaeurekaselec_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` = '134228'
      270μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 134228
      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` = '134228'
      2.64msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 134228
      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` = '134228' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.1msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 134228
      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
      320μ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
      690μ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 = 29 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      58.97msalphaeurekaselec_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 = 29 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      54.32msalphaeurekaselec_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 = 29 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      43.73msalphaeurekaselec_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` = 134228 limit 1
      300μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 134228
      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 = 134228 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` = 220640 limit 1
      280μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 220640
      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
      340μ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` = 'CPD' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      480μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CPD
      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 = '134228' 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) )
      550μ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 = '12792' 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) )
      460μ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 = '3322' 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) )
      440μ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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740514571 and j.to_date >= 1740514571 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3322) 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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740514571 and j.to_date >= 1740514571 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3322) 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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740514571 and j.to_date >= 1740514571 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3322)
      7.25msalphaeurekaselec_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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740514571 and j.to_date >= 1740514571 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12792) 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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740514571 and j.to_date >= 1740514571 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12792) 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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740514571 and j.to_date >= 1740514571 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12792)
      890μ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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740514571 and j.to_date >= 1740514571 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 134228) 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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740514571 and j.to_date >= 1740514571 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 134228) 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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740514571 and j.to_date >= 1740514571 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 134228)
      840μ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` < '2091' and is_uploaded = 1 and issue_id = 12792 order by cast(first_page as SIGNED) desc limit 1
      610μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 2091
      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` > '2100' and is_uploaded = 1 and issue_id = 12792 order by cast(first_page as SIGNED) asc limit 1
      550μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 2100
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'en'
      230μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      250μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 134228 limit 1
      3.78msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 134228
      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` = 29 and `b`.`banner_from_date` <= 1740514571 and `b`.`banner_to_date` >= 1740514571 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.56msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 29
      • 3: 1740514571
      • 4: 1740514571
      • 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` = 29 and `b`.`banner_from_date` <= 1740514571 and `b`.`banner_to_date` >= 1740514571 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.53msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 29
      • 3: 1740514571
      • 4: 1740514571
      • 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='a6d33ea8fc0bbe0c232f61f30516a4a1'
      310μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        L5VAUMbALHSP7fB0DBMjOvoGM9ttAPvg0Nx6CE3D
        uc_cart_id
        a6d33ea8fc0bbe0c232f61f30516a4a1
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/134228" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/134228
        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=eyJpdiI6IkZWQnorL2RwZncxOXdWYk9kV2twelE9PSIsInZhbHVlIjoiUDAzRTVQWWpTV1hqN1VGRHdGS1ExS2QwMkJrK2oyWWg1MWJERFBhOXBVZz0iLCJtYWMiOiI3NDA3YmY5MDAwNzk1NGZhNmMzZjFjNjdlOWMzZGRlYTViZjQxOTk4ZTRmMWQ5ZTQwMTcxM2JjOWM5ODdiYzBhIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IkZWQnorL2RwZncxOXdWYk9kV2twelE9PSIsInZhbHVlIjoiUDAzRTVQWWpTV1hqN1VGRHdGS1ExS2QwMkJrK2oyWWg1MWJERFBhOXBVZz0iLCJtYWMiOiI3NDA3YmY5MDAwNzk1" ] "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 => "Tue, 25 Feb 2025 20:16:11 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjNqSG51TmowZXhKWXN6YkQzT2dYVGc9PSIsInZhbHVlIjoiM1lrOXNwRlorTFloTjF5a3laK2lzUGFaWmtJdWdnMGl3TFlFZ01iNGs1dzA1ay81MDdqRzdmVTh4dmJXZXQ0cTRldWRkOXNZMHA4RUQyRXV2c21ZT2FuOFVQTTBEUGRFTzFsenhxT1Z2S21maTFwQjFORStQclA2eGFTM0pTaWYiLCJtYWMiOiJjZDgzZjNlOGZmMTYyOGQ4OTVmYmYyYjJmZDk1OWQzZGQ4OTMwZjA4NTRjMDNlODA4M2E2MmU4ZDYyNzM5ZmM2IiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 08:16:11 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjNqSG51TmowZXhKWXN6YkQzT2dYVGc9PSIsInZhbHVlIjoiM1lrOXNwRlorTFloTjF5a3laK2lzUGFaWmtJdWdnMGl3TFlFZ01iNGs1dzA1ay81MDdqRzdmVTh4dmJXZXQ0cTRldWRkO" 1 => "alphaeurekaselectnet_session=eyJpdiI6IitPbHdjWmRSb1lsclNzWWtML0VJdEE9PSIsInZhbHVlIjoibmo4cGxTZktmYjRwVGNzSFZGR1g4ZnN2ZEhKZVZrNUJOcnV1RWJIby9xQVVlRGNtRHlJcWdtZEdUbk10S1l5czRKOTB1M2lTanVXTzE1N2xYUUdxb3JMT04wQ0lBV1EvZ1BRY25jd2Z3RlBaMjIxeWRVZ0tVQ2hhSEJPRC9VRnEiLCJtYWMiOiI4ODE1MGU5ZWI4NGQyZDA5Mzg0ZGNmMjJkNDM0NzdhMmIyNTA5NWI0ZTExYWQ4NWNkYmU3YzdjYTE0YjU5MWE5IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IitPbHdjWmRSb1lsclNzWWtML0VJdEE9PSIsInZhbHVlIjoibmo4cGxTZktmYjRwVGNzSFZGR1g4ZnN2ZEhKZVZrNUJOcnV1RWJIby9xQVVlRGNtRHlJcWdtZEd" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjNqSG51TmowZXhKWXN6YkQzT2dYVGc9PSIsInZhbHVlIjoiM1lrOXNwRlorTFloTjF5a3laK2lzUGFaWmtJdWdnMGl3TFlFZ01iNGs1dzA1ay81MDdqRzdmVTh4dmJXZXQ0cTRldWRkOXNZMHA4RUQyRXV2c21ZT2FuOFVQTTBEUGRFTzFsenhxT1Z2S21maTFwQjFORStQclA2eGFTM0pTaWYiLCJtYWMiOiJjZDgzZjNlOGZmMTYyOGQ4OTVmYmYyYjJmZDk1OWQzZGQ4OTMwZjA4NTRjMDNlODA4M2E2MmU4ZDYyNzM5ZmM2IiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 08:16:11 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjNqSG51TmowZXhKWXN6YkQzT2dYVGc9PSIsInZhbHVlIjoiM1lrOXNwRlorTFloTjF5a3laK2lzUGFaWmtJdWdnMGl3TFlFZ01iNGs1dzA1ay81MDdqRzdmVTh4dmJXZXQ0cTRldWRkO" 1 => "alphaeurekaselectnet_session=eyJpdiI6IitPbHdjWmRSb1lsclNzWWtML0VJdEE9PSIsInZhbHVlIjoibmo4cGxTZktmYjRwVGNzSFZGR1g4ZnN2ZEhKZVZrNUJOcnV1RWJIby9xQVVlRGNtRHlJcWdtZEdUbk10S1l5czRKOTB1M2lTanVXTzE1N2xYUUdxb3JMT04wQ0lBV1EvZ1BRY25jd2Z3RlBaMjIxeWRVZ0tVQ2hhSEJPRC9VRnEiLCJtYWMiOiI4ODE1MGU5ZWI4NGQyZDA5Mzg0ZGNmMjJkNDM0NzdhMmIyNTA5NWI0ZTExYWQ4NWNkYmU3YzdjYTE0YjU5MWE5IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IitPbHdjWmRSb1lsclNzWWtML0VJdEE9PSIsInZhbHVlIjoibmo4cGxTZktmYjRwVGNzSFZGR1g4ZnN2ZEhKZVZrNUJOcnV1RWJIby9xQVVlRGNtRHlJcWdtZEd" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "L5VAUMbALHSP7fB0DBMjOvoGM9ttAPvg0Nx6CE3D" "uc_cart_id" => "a6d33ea8fc0bbe0c232f61f30516a4a1" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/134228" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 20:16:11GET/article/134228514361