Generic placeholder image

Combinatorial Chemistry & High Throughput Screening

Editor-in-Chief

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

Research Article

Evaluation of Therapeutic Mechanism of Hedyotis Diffusa Willd (HDW)‒ Scutellaria Barbata (SB) in Clear Cell Renal Cell Carcinoma via Singlecell RNA Sequencing and Network Pharmacology

Author(s): Yangyang Bai, Ruiting Chen, Jijian Sun and Yilin Guo*

Volume 27, Issue 6, 2024

Published on: 15 August, 2023

Page: [910 - 921] Pages: 12

DOI: 10.2174/1386207326666230731155309

Price: $65

Abstract

Objective: The present study aimed to investigate the therapeutic mechanism of Hedyotis diffusa Willd (HDW) and Scutellaria barbata (SB) in ccRCC using a combination of single-cell RNA sequencing (scRNA-seq) and network pharmacology.

Methods: The active ingredients and potential molecular targets of HDW-SB were obtained from the Traditional Chinese Medicine Systems Pharmacology Database and Analysis Platform. Gene expression data (GSE53757) were obtained from the Gene Expression Omnibus database. The hub genes of HDW-SB against ccRCC were identified via the protein–protein interaction network, and further analyzed by molecular complex detection. The roles of these genes in the diagnosis and immune infiltration of ccRCC were analyzed. The clinical significance of hub genes was verified using scRNA-seq data (GSE121638) and molecular docking.

Results: Following the PPI network analysis, 29 hub genes of HDW-SB against ccRCC were identified. All hub genes, except for CENPE, had significantly different expressions in tumor tissue and a more accurate diagnosis of ccRCC. Fifteen cell clusters were defined based on the scRNA-seq dataset, and the clusters were annotated as six cell types using marker genes. TYMS and KIAA0101 from hub genes were highly expressed in NK cells. Three active compounds, quercetin, luteolin, and baicalein, were found to target TYMS and KIAA0101 from the compound-target interaction network.

Conclusion: 29 hub genes of HDW-SB against ccRCC were identified and showed good performance in terms of diagnosis and prognosis. Moreover, among these hub genes docking with the main ingredients of HDW-SB, TYMS and KIAA0101 exerted anti-ccRCC effects through NK cells.

Graphical Abstract

[1]
Sung, H.; Ferlay, J.; Siegel, R.L. 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-249.
[http://dx.doi.org/10.3322/caac.21660] [PMID: 33538338]
[2]
Escudier, B.; Porta, C.; Schmidinger, M.; Rioux-Leclercq, N.; Bex, A.; Khoo, V.; Grünwald, V.; Gillessen, S.; Horwich, A. Renal cell carcinoma: ESMO clinical practice guidelines for diagnosis, treatment and follow-up. Ann. Oncol., 2019, 30(5), 706-720.
[http://dx.doi.org/10.1093/annonc/mdz056] [PMID: 30788497]
[3]
Makhov, P.; Joshi, S.; Ghatalia, P.; Kutikov, A.; Uzzo, R.G.; Kolenko, V.M. Resistance to systemic therapies in clear cell renal cell carcinoma: Mechanisms and management strategies. Mol. Cancer Ther., 2018, 17(7), 1355-1364.
[http://dx.doi.org/10.1158/1535-7163.MCT-17-1299] [PMID: 29967214]
[4]
Tao, W.; Luo, X.; Cui, B.; Liang, D.; Wang, C.; Duan, Y.; Li, X.; Zhou, S.; Zhao, M.; Li, Y.; He, Y.; Wang, S.; Kelley, K.W.; Jiang, P.; Liu, Q. Practice of traditional Chinese medicine for psycho-behavioral intervention improves quality of life in cancer patients: A systematic review and meta-analysis. Oncotarget, 2015, 6(37), 39725-39739.
[http://dx.doi.org/10.18632/oncotarget.5388] [PMID: 26498685]
[5]
Lin, L.; Cheng, K.; Xie, Z.; Chen, C.; Chen, L.; Huang, Y.; Liang, Z. Purification and characterization a polysaccharide from Hedyotis diffusa and its apoptosis inducing activity toward human lung cancer cell line A549. Int. J. Biol. Macromol., 2019, 122, 64-71.
[http://dx.doi.org/10.1016/j.ijbiomac.2018.10.077] [PMID: 30342944]
[6]
Kuo, Y.J.; Yang, J.S.; Lu, C.C.; Chiang, S.; Lin, J.G.; Chung, J.G. Ethanol extract of Hedyotis diffusa willd upregulates G0/G1 phase arrest and induces apoptosis in human leukemia cells by modulating caspase cascade signaling and altering associated genes expression was assayed by cDNA microarray. Environ. Toxicol., 2015, 30(10), 1162-1177.
[http://dx.doi.org/10.1002/tox.21989] [PMID: 24677778]
[7]
Zhang, P.; Zhang, B.; Gu, J.; Hao, L.; Hu, F.; Han, C. The study of the effect of hedyotis diffusa on the proliferation and the apoptosis of the cervical tumor in nude mouse model. Cell Biochem. Biophys., 2015, 72(3), 783-789.
[http://dx.doi.org/10.1007/s12013-015-0532-9] [PMID: 25677988]
[8]
Su, X.; Li, Y.; Jiang, M.; Zhu, J.; Zheng, C.; Chen, X.; Zhou, J.; Li, Y.; Xiao, W.; Wang, Y. Systems pharmacology uncover the mechanism of anti-non-small cell lung cancer for Hedyotis diffusa Willd. Biomed. Pharmacother., 2019, 109, 969-984.
[http://dx.doi.org/10.1016/j.biopha.2018.10.162] [PMID: 30551551]
[9]
Sun, P.; Sun, D.; Wang, X. Effects of Scutellaria barbata polysaccharide on the proliferation, apoptosis and EMT of human colon cancer HT29 Cells. Carbohydr. Polym., 2017, 167, 90-96.
[http://dx.doi.org/10.1016/j.carbpol.2017.03.022] [PMID: 28433181]
[10]
Lin, J.; Feng, J.; Yang, H.; Yan, Z.; Li, Q.; Wei, L.; Lai, Z.; Jin, Y.; Peng, J. Scutellaria barbata D. Don inhibits 5-fluorouracil resistance in colorectal cancer by regulating PI3K/AKT pathway. Oncol. Rep., 2017, 38(4), 2293-2300.
[http://dx.doi.org/10.3892/or.2017.5892] [PMID: 28849113]
[11]
Kan, X.; Zhang, W.; You, R.; Niu, Y.; Guo, J.; Xue, J. Scutellaria barbata D. Don extract inhibits the tumor growth through down-regulating of Treg cells and manipulating Th1/Th17 immune response in hepatoma H22-bearing mice. BMC Complement. Altern. Med., 2017, 17(1), 41.
[http://dx.doi.org/10.1186/s12906-016-1551-9] [PMID: 28086772]
[12]
Xu, Y.; Chen, X.X.; Jiang, Y.X.; Zhang, D.D. Ethyl acetate fraction from hedyotis diffusa plus scutellaria barbata exerts anti-inflammatory effects by regulating miR-155 expression and JNK signaling pathway. Evid. Based Complement. Altern. Med., 2018, 2018, 3593408.
[http://dx.doi.org/10.1155/2018/3593408] [PMID: 29725352]
[13]
Xu, X.; Chen, F.; Zhang, L.; Liu, L.; Zhang, C.; Zhang, Z.; Li, W. Exploring the mechanisms of anti-ovarian cancer of Hedyotis diffusa Willd and Scutellaria barbata D. Don through focal adhesion pathway. J. Ethnopharmacol., 2021, 279, 114343.
[http://dx.doi.org/10.1016/j.jep.2021.114343] [PMID: 34147618]
[14]
Wang, X.; Shen, Y.; Wang, S.; Li, S.; Zhang, W.; Liu, X.; Lai, L.; Pei, J.; Li, H. PharmMapper 2017 update: A web server for potential drug target identification with a comprehensive target pharmacophore database. Nucleic Acids Res., 2017, 45(W1), W356-W360.
[http://dx.doi.org/10.1093/nar/gkx374] [PMID: 28472422]
[15]
Liu, W.; Xu, W.; Li, C.; Xu, J.; Huang, K.; Hu, R.; Huang, H.; Liu, X. Network pharmacological systems study of Huang-Lian-Tang in the treatment of glioblastoma multiforme. Oncol. Lett., 2021, 21(1), 18.
[PMID: 33240424]
[16]
Wesołowski, W.; Szklarczyk, M.; Szalonek, M.; Słowińska, J. Analysis of the mitochondrial proteome in cytoplasmic male-sterile and male-fertile beets. J. Proteomics, 2015, 119, 61-74.
[http://dx.doi.org/10.1016/j.jprot.2014.12.013] [PMID: 25573812]
[17]
Bader, G.D.; Hogue, C.W.V. An automated method for finding molecular complexes in large protein interaction networks. BMC Bioinformatics, 2003, 4(1), 2.
[http://dx.doi.org/10.1186/1471-2105-4-2] [PMID: 12525261]
[18]
Liu, Y.; Lv, H.; Li, X.; Liu, J.; Chen, S.; Chen, Y.; Jin, Y.; An, R.; Yu, S.; Wang, Z. Cyclovirobuxine inhibits the progression of clear cell renal cell carcinoma by suppressing the IGFBP3-AKT/STAT3/MAPK-Snail signalling pathway. Int. J. Biol. Sci., 2021, 17(13), 3522-3537.
[http://dx.doi.org/10.7150/ijbs.62114] [PMID: 34512163]
[19]
Teekaraman, D.; Elayapillai, S.P.; Viswanathan, M.P.; Jagadeesan, A. Quercetin inhibits human metastatic ovarian cancer cell growth and modulates components of the intrinsic apoptotic pathway in PA-1 cell line. Chem. Biol. Interact., 2019, 300, 91-100.
[http://dx.doi.org/10.1016/j.cbi.2019.01.008] [PMID: 30639267]
[20]
Liu, H.; Zeng, Z.; Wang, S.; Li, T.; Mastriani, E.; Li, Q.H.; Bao, H.X.; Zhou, Y.J.; Wang, X.; Liu, Y.; Liu, W.; Hu, S.; Gao, S.; Yu, M.; Qi, Y.; Shen, Z.; Wang, H.; Gao, T.; Dong, L.; Johnston, R.N.; Liu, S.L. Main components of pomegranate, ellagic acid and luteolin, inhibit metastasis of ovarian cancer by down-regulating MMP2 and MMP9. Cancer Biol. Ther., 2017, 18(12), 990-999.
[http://dx.doi.org/10.1080/15384047.2017.1394542] [PMID: 29173024]
[21]
Lv, Y.X.; Pan, H.R.; Song, X.Y.; Chang, Q.Q.; Zhang, D.D. Hedyotis diffusa plus scutellaria barbata suppress the growth of non-small-cell lung cancer via NLRP3/NF- κ B/MAPK signaling pathways. Evid. Based Complement. Alternat. Med., 2021, 2021, 1-8.
[http://dx.doi.org/10.1155/2021/6666499] [PMID: 34239588]
[22]
Ma, T.T.; Zhang, G.L.; Dai, C.F.; Zhang, B.R.; Cao, K.X.; Wang, C.G.; Yang, G.W.; Wang, X.M. Scutellaria barbata and Hedyotis diffusa herb pair for breast cancer treatment: Potential mechanism based on network pharmacology. J. Ethnopharmacol., 2020, 259, 112929.
[http://dx.doi.org/10.1016/j.jep.2020.112929] [PMID: 32416245]
[23]
Xiao, G.F.; Yan, X.; Chen, Z.; Zhang, R.J.; Liu, T.Z.; Hu, W.L. Identification of a novel immune-related prognostic biomarker and small-molecule drugs in Clear Cell Renal Cell Carcinoma (ccRCC) by a merged microarray-acquired dataset and TCGA database. Front. Genet., 2020, 11, 810.
[http://dx.doi.org/10.3389/fgene.2020.00810] [PMID: 33014010]
[24]
Chen, J.; Li, Z.; Chen, A.; Ye, X.; Luo, H.; Rankin, G.; Chen, Y. Inhibitory effect of baicalin and baicalein on ovarian cancer cells. Int. J. Mol. Sci., 2013, 14(3), 6012-6025.
[http://dx.doi.org/10.3390/ijms14036012] [PMID: 23502466]
[25]
Liu, Z.; Sun, T.; Piao, C.; Zhang, Z.; Kong, C. METTL13 inhibits progression of clear cell renal cell carcinoma with repression on PI3K/AKT/mTOR/HIF-1α pathway and c-Myc expression. J. Transl. Med., 2021, 19(1), 209.
[http://dx.doi.org/10.1186/s12967-021-02879-2] [PMID: 33985542]
[26]
Mizumoto, A.; Yamamoto, K.; Nakayama, Y.; Takara, K.; Nakagawa, T.; Hirano, T.; Hirai, M. Induction of epithelial-mesenchymal transition via activation of epidermal growth factor receptor contributes to sunitinib resistance in human renal cell carcinoma cell lines. J. Pharmacol. Exp. Ther., 2015, 355(2), 152-158.
[http://dx.doi.org/10.1124/jpet.115.226639] [PMID: 26306766]
[27]
Reyes-Farias, M.; Carrasco-Pozo, C. The anti-cancer effect of quercetin: Molecular implications in cancer metabolism. Int. J. Mol. Sci., 2019, 20(13), 3177.
[http://dx.doi.org/10.3390/ijms20133177] [PMID: 31261749]
[28]
Han, S.; Lin, F.; Qi, Y.; Liu, C.; Zhou, L.; Xia, Y.; Chen, K.; Xing, J.; Liu, Z.; Yu, W.; Zhang, Y.; Zhou, X.; Rao, T.; Cheng, F. HO-1 contributes to luteolin-triggered ferroptosis in clear cell renal cell carcinoma via increasing the labile iron pool and promoting lipid peroxidation. Oxid. Med. Cell. Longev., 2022, 2022, 3846217.
[http://dx.doi.org/10.1155/2022/3846217] [PMID: 35656025]
[29]
Rahmani, A.H.; Almatroudi, A.; Khan, A.A.; Babiker, A.Y.; Alanezi, M.; Allemailem, K.S. The multifaceted role of baicalein in cancer management through modulation of cell signalling pathways. Molecules, 2022, 27(22), 8023.
[http://dx.doi.org/10.3390/molecules27228023] [PMID: 36432119]
[30]
Varghese, V.; Magnani, L.; Harada-Shoji, N.; Mauri, F.; Szydlo, R.M.; Yao, S.; Lam, E.W.F.; Kenny, L.M. FOXM1 modulates 5-FU resistance in colorectal cancer through regulating TYMS expression. Sci. Rep., 2019, 9(1), 1505.
[http://dx.doi.org/10.1038/s41598-018-38017-0] [PMID: 30728402]
[31]
Shichijo, S.; Azuma, K.; Komatsu, N.; Ito, M.; Maeda, Y.; Ishihara, Y.; Itoh, K. Two proliferation-related proteins, TYMS and PGK1, could be new cytotoxic T lymphocyte-directed tumor-associated antigens of HLA-A2+ colon cancer. Clin. Cancer Res., 2004, 10(17), 5828-5836.
[http://dx.doi.org/10.1158/1078-0432.CCR-04-0350] [PMID: 15355913]
[32]
Yuan, R.H.; Jeng, Y.M.; Pan, H.W.; Hu, F.C.; Lai, P.L.; Lee, P.H.; Hsu, H.C. Overexpression of KIAA0101 predicts high stage, early tumor recurrence, and poor prognosis of hepatocellular carcinoma. Clin. Cancer Res., 2007, 13(18), 5368-5376.
[http://dx.doi.org/10.1158/1078-0432.CCR-07-1113] [PMID: 17875765]
[33]
Sun, T.; An, Q.; Yan, R.; Li, K.; Zhu, K.; Dang, C.; Yuan, D. MicroRNA 216a 5p suppresses esophageal squamous cell carcinoma progression by targeting KIAA0101. Oncol. Rep., 2020, 44(5), 1971-1984.
[http://dx.doi.org/10.3892/or.2020.7751] [PMID: 32901882]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version897msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:14:40] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:14:41] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:14:41] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:14:41] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (173ms)time
  • Application (724ms)time
  • 1 x Application (80.73%)
    724ms
    1 x Booting (19.26%)
    173ms
    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 duplicated567ms
    • 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 ('316589210','',1,1740773680,1740773680) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740773680
      31.56msalphaeurekaselec_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 ('316589210','/article/133284',1,1740773680,1740773680)
      260μ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 >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) 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 >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) 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 >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) 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 >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) 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 >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) 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 >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316589210 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316589210) limit 1
      40.98msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316589210
      • 1: 316589210
      • 2: 316589210
      • 3: 316589210
      • 4: 316589210
      • 5: 316589210
      • 6: 316589210
      • 7: 316589210
      • 8: 316589210
      • 9: 316589210
      • 10: 316589210
      • 11: 316589210
      • 12: 316589210
      • 13: 316589210
      • 14: 316589210
      • 15: 316589210
      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=133284
      3.93msalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 8 limit 1
      13.51msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 8
      Backtrace
      • 14. app/Models/Journal.php:64
      • 15. app/Http/Controllers/ArticleController.php:2516
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=8) and sj.journal_id!=8 group by `j`.`nid`) as `aggregate_table`
      1.67msalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=8) and sj.journal_id!=8 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.43msalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=8) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      53.54msalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 16. app/Models/Subject.php:220
      • 17. app/Http/Controllers/ArticleController.php:2518
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=8) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      75.03msalphaeurekaselec_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` = '133284'
      500μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 133284
      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` = '133284'
      7.45msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 133284
      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` = '133284' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      5.82msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 133284
      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
      1.1msalphaeurekaselec_live_10_06_2022Article.php#1960
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1960
      • 14. app/Http/Controllers/ArticleController.php:2062
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • Select j.subtitle, v.volume_id as volume_id,v.year_id,y.year as year,v.volume_name, v.total_no_of_issues, i.issue_id as issue_id,i.title as issue, i.publication_date as issue_pub_date from journal j join volume v on j.journal_id = v.journal_id join issue i on v.volume_id = i.volume_id join article a on a.issue_id = i.issue_id join year y on v.year_id = y.id where j.journal_id = 8 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      165msalphaeurekaselec_live_10_06_2022Issue.php#298
      Backtrace
      • 11. app/Models/Issue.php:298
      • 12. app/Http/Controllers/ArticleController.php:2068
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 1 and a.journal_id = 8 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      46.3msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2070
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 8 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      38.59msalphaeurekaselec_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` = 133284 limit 1
      280μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 133284
      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 = 133284 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` = 219308 limit 1
      280μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 219308
      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.25msalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CCHTS' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      460μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CCHTS
      Backtrace
      • 13. app/Models/Article.php:2025
      • 14. app/Http/Controllers/ArticleController.php:2112
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '133284' 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) )
      560μ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 = '13103' 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) )
      470μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '3488' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      430μ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 <= 316589210 and j.to_ip >=316589210 )) and ((j.from_date <= 1740773681 and j.to_date >= 1740773681 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3488) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316589210 and j.to_ip >=316589210 )) and ((j.from_date <= 1740773681 and j.to_date >= 1740773681 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3488) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316589210 and j.to_ip >=316589210 )) and ((j.from_date <= 1740773681 and j.to_date >= 1740773681 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3488)
      36.89msalphaeurekaselec_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 <= 316589210 and j.to_ip >=316589210 )) and ((j.from_date <= 1740773681 and j.to_date >= 1740773681 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13103) 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 <= 316589210 and j.to_ip >=316589210 )) and ((j.from_date <= 1740773681 and j.to_date >= 1740773681 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13103) 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 <= 316589210 and j.to_ip >=316589210 )) and ((j.from_date <= 1740773681 and j.to_date >= 1740773681 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13103)
      1.15msalphaeurekaselec_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 <= 316589210 and j.to_ip >=316589210 )) and ((j.from_date <= 1740773681 and j.to_date >= 1740773681 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 133284) 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 <= 316589210 and j.to_ip >=316589210 )) and ((j.from_date <= 1740773681 and j.to_date >= 1740773681 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 133284) 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 <= 316589210 and j.to_ip >=316589210 )) and ((j.from_date <= 1740773681 and j.to_date >= 1740773681 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 133284)
      930μ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` < '910' and is_uploaded = 1 and issue_id = 13103 order by cast(first_page as SIGNED) desc limit 1
      750μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 910
      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` > '921' and is_uploaded = 1 and issue_id = 13103 order by cast(first_page as SIGNED) asc limit 1
      630μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 921
      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'
      16.54msalphaeurekaselec_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
      340μ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` = 133284 limit 1
      3.84msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 133284
      Backtrace
      • 16. app/Http/Controllers/ArticleController.php:2506
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select b.banner_link, b.banner_name, b.banner_script, b.banner_remarks, b.banner_file_name, b.banner_placement, bd.content_type, bd.content_id from `tbl_banner` as `b` inner join `tbl_banner_detail` as `bd` on `bd`.`banner_id` = `b`.`banner_id` inner join `users` as `u` on `u`.`id` = `b`.`updated_by` inner join `journal` as `j` on `j`.`journal_id` = `bd`.`content_id` where `b`.`banner_journal` = 1 and `bd`.`content_type` = 'J' and `bd`.`content_id` = 8 and `b`.`banner_from_date` <= 1740773681 and `b`.`banner_to_date` >= 1740773681 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      4.48msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 8
      • 3: 1740773681
      • 4: 1740773681
      • 5: A
      Backtrace
      • 13. app/Models/Banner.php:95
      • 14. app/Http/helpers.php:404
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • select b.banner_link, b.banner_name, b.banner_script, b.banner_remarks, b.banner_file_name, b.banner_placement, bd.content_type, bd.content_id from `tbl_banner` as `b` inner join `tbl_banner_detail` as `bd` on `bd`.`banner_id` = `b`.`banner_id` inner join `users` as `u` on `u`.`id` = `b`.`updated_by` inner join `journal` as `j` on `j`.`journal_id` = `bd`.`content_id` where `b`.`banner_journal` = 1 and `bd`.`content_type` = 'J' and `bd`.`content_id` = 8 and `b`.`banner_from_date` <= 1740773681 and `b`.`banner_to_date` >= 1740773681 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.63msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 8
      • 3: 1740773681
      • 4: 1740773681
      • 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='d08af2e0312315285bc5ef990eb1da2d'
      340μ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
        Js3yBaJYvUeqhFletJlncGh85LdJvyvpEhkEHB00
        uc_cart_id
        d08af2e0312315285bc5ef990eb1da2d
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/133284" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/133284
        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=eyJpdiI6IjFHMVdHR3R5UTB5RnRQSGZsMTlmVGc9PSIsInZhbHVlIjoiVEFhdy8wZFc0REVzdEtZcXJ4QThjL2o4V1RBaG9Ta0RrZ3Bya2lPdFA5VT0iLCJtYWMiOiI4YTFmMWZkYTQ5NzRkNjZkNTVlMDAyNWMzMzMyODI1NmYzOGJjMzU4NGNhYjQwMjVhY2VjZGFkZWNkZWIwMTcyIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IjFHMVdHR3R5UTB5RnRQSGZsMTlmVGc9PSIsInZhbHVlIjoiVEFhdy8wZFc0REVzdEtZcXJ4QThjL2o4V1RBaG9Ta0RrZ3Bya2lPdFA5VT0iLCJtYWMiOiI4YTFmMWZkYTQ5NzRk" ] "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 => "Fri, 28 Feb 2025 20:14:41 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ing4VDNTT3hWWEdlUlFNSFFxaUdtK3c9PSIsInZhbHVlIjoiOHJWRjVtM2x4VG02MjdTaU0xclpPOGI5Z0VacitqRnV4cytXcWV3SEs0Y1VDN3dYT1pXd2l3c3pUSGQ1K3R5S0treXMvdzlpNWQ3aVYzNUl2YVo2SGgxZlFZZURLL01kQVZ1YkhWcVd2TFRRdE0wcEZDU2p1SW5scVpTWWgyeXMiLCJtYWMiOiI3ODMzMjYyODY4OGI0ZDI4ODk2ZmRjMjViY2UyNWQ5NTRkNGMyZWMxOTEzNTk3YTI3NDkzZjAyYmViZDk2Nzg0IiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 08:14:41 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ing4VDNTT3hWWEdlUlFNSFFxaUdtK3c9PSIsInZhbHVlIjoiOHJWRjVtM2x4VG02MjdTaU0xclpPOGI5Z0VacitqRnV4cytXcWV3SEs0Y1VDN3dYT1pXd2l3c3pUSGQ1K3R5S0treXMvd" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImR1UzhJSjUrM3NRMTBNVzFRYS95Umc9PSIsInZhbHVlIjoiaFkxYW5MK1dScnN0UEM0bU9TalA5eGJaMU9UVjFSVGl3ZkU0ZzhtZGJIRnFsYnlNYTM1elZBMmZNdWc0YzFWTFFiZGRFUllOeFpuSUF5TGVia2Q0elRKdXNoRTNVQmVNU1pBbE1hWC8wYjJkN0dod1ZVODU4bU9SR0VwTTZFSlAiLCJtYWMiOiJlZWU3ZDQ0Yjc5MWE5MTgyMmQ3NTdkODY1ZjM1MDkwNzBmZjNjMmY4ODdiZjczYzhlMzIyNTUzNDhjOGYxZjJjIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6ImR1UzhJSjUrM3NRMTBNVzFRYS95Umc9PSIsInZhbHVlIjoiaFkxYW5MK1dScnN0UEM0bU9TalA5eGJaMU9UVjFSVGl3ZkU0ZzhtZGJIRnFsYnlNYTM1elZBMmZ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ing4VDNTT3hWWEdlUlFNSFFxaUdtK3c9PSIsInZhbHVlIjoiOHJWRjVtM2x4VG02MjdTaU0xclpPOGI5Z0VacitqRnV4cytXcWV3SEs0Y1VDN3dYT1pXd2l3c3pUSGQ1K3R5S0treXMvdzlpNWQ3aVYzNUl2YVo2SGgxZlFZZURLL01kQVZ1YkhWcVd2TFRRdE0wcEZDU2p1SW5scVpTWWgyeXMiLCJtYWMiOiI3ODMzMjYyODY4OGI0ZDI4ODk2ZmRjMjViY2UyNWQ5NTRkNGMyZWMxOTEzNTk3YTI3NDkzZjAyYmViZDk2Nzg0IiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 08:14:41 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ing4VDNTT3hWWEdlUlFNSFFxaUdtK3c9PSIsInZhbHVlIjoiOHJWRjVtM2x4VG02MjdTaU0xclpPOGI5Z0VacitqRnV4cytXcWV3SEs0Y1VDN3dYT1pXd2l3c3pUSGQ1K3R5S0treXMvd" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImR1UzhJSjUrM3NRMTBNVzFRYS95Umc9PSIsInZhbHVlIjoiaFkxYW5MK1dScnN0UEM0bU9TalA5eGJaMU9UVjFSVGl3ZkU0ZzhtZGJIRnFsYnlNYTM1elZBMmZNdWc0YzFWTFFiZGRFUllOeFpuSUF5TGVia2Q0elRKdXNoRTNVQmVNU1pBbE1hWC8wYjJkN0dod1ZVODU4bU9SR0VwTTZFSlAiLCJtYWMiOiJlZWU3ZDQ0Yjc5MWE5MTgyMmQ3NTdkODY1ZjM1MDkwNzBmZjNjMmY4ODdiZjczYzhlMzIyNTUzNDhjOGYxZjJjIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6ImR1UzhJSjUrM3NRMTBNVzFRYS95Umc9PSIsInZhbHVlIjoiaFkxYW5MK1dScnN0UEM0bU9TalA5eGJaMU9UVjFSVGl3ZkU0ZzhtZGJIRnFsYnlNYTM1elZBMmZ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "Js3yBaJYvUeqhFletJlncGh85LdJvyvpEhkEHB00" "uc_cart_id" => "d08af2e0312315285bc5ef990eb1da2d" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/133284" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 20:14:41GET/article/133284414361