Generic placeholder image

Current Bioinformatics

Editor-in-Chief

ISSN (Print): 1574-8936
ISSN (Online): 2212-392X

Research Article

A Pan-cancer Analysis Reveals the Tissue Specificity and Prognostic Impact of Angiogenesis-associated Genes in Human Cancers

Author(s): Zhenshen Bao, Minzhen Liao, Wanqi Dong, Yanhao Huo, Xianbin Li*, Peng Xu* and Wenbin Liu*

Volume 18, Issue 8, 2023

Published on: 07 July, 2023

Page: [670 - 679] Pages: 10

DOI: 10.2174/1574893618666230518163353

Price: $65

Abstract

Introduction: Angiogenesis is one of the hallmarks of cancer and can impact the processes of cancer initiation, progression, and response to therapy.

Background: Anti-angiogenic therapy is thus an encouraging therapeutic option to treat cancers, but the detailed angiogenic mechanisms and the association between angiogenesis and clinical outcome remain unknown in different cancers.

Methods: Here, we systematically assess the impacts of 82 angiogenesis-associated genes (AAGs) in tumor tissue specificity and prognosis across 16 cancer types.

Results: Results demonstrate that the expression patterns of the 82 AAGs can reflect the tumor tissue specificity, and high expressions of up-regulated AAGs are significantly associated with poor prognosis of cancer. We further define a prognostic score for predicting overall survival (OS) based on the expressions of up-regulated AAGs and confirm its reliable predictive ability. Results indicate that a low prognostic score demonstrates a superior OS and vice versa.

Conclusion: The results of this study will contribute to the understanding of different tumor angiogenesis mechanisms in various tissues and cancer-personalized anti-angiogenic treatment. The code of our analysis can be accessed at https://github.com/ZhenshenBao/AAGs_analysis.git.

Graphical Abstract

[1]
Folkman J. Tumor angiogenesis. Adv Cancer Res 1985; 43: 175-203.
[http://dx.doi.org/10.1016/S0065-230X(08)60946-X] [PMID: 2581424]
[2]
Donnem T, Reynolds AR, Kuczynski EA, et al. Non-angiogenic tumours and their influence on cancer biology. Nat Rev Cancer 2018; 18(5): 323-36.
[http://dx.doi.org/10.1038/nrc.2018.14] [PMID: 29520090]
[3]
Hanahan D, Folkman J. Patterns and emerging mechanisms of the angiogenic switch during tumorigenesis. Cell 1996; 86(3): 353-64.
[http://dx.doi.org/10.1016/S0092-8674(00)80108-7] [PMID: 8756718]
[4]
Sherwood LM, Parris EE, Folkman J. Tumor angiogenesis: Therapeutic implications. N Engl J Med 1971; 285(21): 1182-6.
[http://dx.doi.org/10.1056/NEJM197111182852108] [PMID: 4938153]
[5]
Pepper MS, Montesano R, Mandriota SJ, Orci L, Vassalli JD. Angiogenesis: A paradigm for balanced extracellular proteolysis during cell migration and morphogenesis. Enzyme Protein 1996; 49(1-3): 138-62.
[http://dx.doi.org/10.1159/000468622] [PMID: 8797003]
[6]
Folkman J, Shing Y. Angiogenesis. J Biol Chem 1992; 267(16): 10931-4.
[http://dx.doi.org/10.1016/S0021-9258(19)49853-0] [PMID: 1375931]
[7]
Ramjiawan RR, Griffioen AW, Duda DG. Anti-angiogenesis for cancer revisited: Is there a role for combinations with immunotherapy? Angiogenesis 2017; 20(2): 185-204.
[http://dx.doi.org/10.1007/s10456-017-9552-y] [PMID: 28361267]
[8]
Yu WD, Sun G, Li J, Xu J, Wang X. Mechanisms and therapeutic potentials of cancer immunotherapy in combination with radiotherapy and/or chemotherapy. Cancer Lett 2019; 452: 66-70.
[http://dx.doi.org/10.1016/j.canlet.2019.02.048] [PMID: 30902563]
[9]
Guo F, Cui J. Anti-angiogenesis: Opening a new window for immunotherapy. Life Sciences 2020; 258: 118163.
[http://dx.doi.org/10.1016/j.lfs.2020.118163]
[10]
Khan KA, Kerbel RS. Improving immunotherapy outcomes with anti-angiogenic treatments and vice versa. Nat Rev Clin Oncol 2018; 15: 310-24.
[http://dx.doi.org/10.1038/nrclinonc.2018.9]
[11]
Albini A, Bruno A, Noonan DM, Mortara L. Contribution to tumor angiogenesis from innate immune cells within the tumor microenvironment: Implications for immunotherapy. Front Immunol 2018; 9: 527.
[http://dx.doi.org/10.3389/fimmu.2018.00527] [PMID: 29675018]
[12]
Viallard C, Larrivée B. Tumor angiogenesis and vascular normalization: Alternative therapeutic targets. Angiogenesis 2017; 20(4): 409-26.
[http://dx.doi.org/10.1007/s10456-017-9562-9] [PMID: 28660302]
[13]
Roy-Chowdhury S, Brown CK. Cytokines and tumor angiogenesis. In: Caligiuri MA, Lotze MT, Eds. Cytokines in the Genesis and Treatment of Cancer. Totowa, NJ: Humana Press 2007; pp. 245-66.
[http://dx.doi.org/10.1007/978-1-59745-455-1_14]
[14]
Montoya S, Soong D, Nguyen N, Affer M, Munamarty SP, Taylor J. Targeted therapies in cancer: To be or not to be, selective. Biomedicines 2021; 9(11): 1591.
[http://dx.doi.org/10.3390/biomedicines9111591] [PMID: 34829820]
[15]
Xia AL, Xu Y, Lu XJ. Cancer immunotherapy: Challenges and clinical applications. J Med Genet 2019; 56(1): 1-3.
[http://dx.doi.org/10.1136/jmedgenet-2018-105852] [PMID: 30464054]
[16]
Cassidy JW, Bruna A. Tumor Heterogeneity. In: Uthamanthil R, Tinkey P, Eds. Patient Derived Tumor Xenograft Models. Cambridge, USA: Academic Press 2017; pp. 37-55.
[http://dx.doi.org/10.1016/B978-0-12-804010-2.00004-7]
[17]
Gray M, Meehan J, Turnbull AK, et al. The importance of the tumor microenvironment and hypoxia in delivering a precision medicine approach to veterinary oncology. Front Vet Sci 2020; 7: 598338.
[http://dx.doi.org/10.3389/fvets.2020.598338] [PMID: 33282935]
[18]
Tang Z, Kang B, Li C, Chen T, Zhang Z. GEPIA2: An enhanced web server for large-scale expression profiling and interactive analysis. Nucleic Acids Res 2019; 47(W1): W556-60.
[http://dx.doi.org/10.1093/nar/gkz430] [PMID: 31114875]
[19]
van der Maaten L, Hinton G. Viualizing data using t-SNE. J Mach Learn Res 2008; 9: 2579-605.
[20]
Zheng X, Li W, Ren L, et al. The sphingosine kinase-1/sphingosine-1-phosphate axis in cancer: Potential target for anticancer therapy. Pharmacol Ther 2019; 195: 85-99.
[http://dx.doi.org/10.1016/j.pharmthera.2018.10.011]
[21]
Sun X, Chen Q, Zhang L, Chen J, Zhang X. Exploration of prognostic biomarkers and therapeutic targets in the microenvironment of bladder cancer based on CXC chemokines. Math Biosci Eng 2021; 18(5): 6262-87.
[http://dx.doi.org/10.3934/mbe.2021313] [PMID: 34517533]
[22]
Wang Z, Yuan X, Jiao N, Zhu H, Zhang Y, Tong J. CDH13 and FLBN3 gene methylation are associated with poor prognosis in colorectal cancer. Pathol Oncol Res 2012; 18(2): 263-70.
[http://dx.doi.org/10.1007/s12253-011-9437-0]
[23]
Hatano K, Saigo C, Kito Y, Shibata T, Takeuchi T. Overexpression of JAG2 is related to poor outcomes in oral squamous cell carcinoma. Clin Exp Dent Res 2020; 6(2): 174-80.
[http://dx.doi.org/10.1002/cre2.267] [PMID: 32250571]
[24]
Yang S, Wang H, Qin C, Sun H, Han Y. Up-regulation of CXCL8 expression is associated with a poor prognosis and enhances tumor cell malignant behaviors in liver cancer. Biosci Rep 2020; 40(8): BSR20201169.
[http://dx.doi.org/10.1042/BSR20201169]
[25]
Wang H, Yin J, Hong Y, et al. SCG2 is a prognostic biomarker associated with immune infiltration and macrophage polarization in colorectal cancer. Front Cell Dev Biol 2022; 9: 795133.
[http://dx.doi.org/10.3389/fcell.2021.795133] [PMID: 35047505]
[26]
Bartoschek M, Pietras K. PDGF family function and prognostic value in tumor biology. Biochemical and Biophysical Research Communications 2018; 503(2): 984-90.
[http://dx.doi.org/10.1016/j.bbrc.2018.06.106]
[27]
Yuan L, Shu B, Chen L, et al. Overexpression of COL3A1 confers a poor prognosis in human bladder cancer identified by co-expression analysis. Oncotarget 2017; 8(41): 70508-20.
[http://dx.doi.org/10.18632/oncotarget.19733] [PMID: 29050298]
[28]
Connor EV, Saygin C, Braley C, et al. Thy-1 predicts poor prognosis and is associated with self-renewal in ovarian cancer. J Ovarian Res 2019; 12(1): 112.
[http://dx.doi.org/10.1186/s13048-019-0590-5] [PMID: 31735168]
[29]
Cheng G, Fan X, Hao M, Wang J, Zhou X, Sun X. Higher levels of TIMP-1 expression are associated with a poor prognosis in triple-negative breast cancer. Mol Cancer 2016; 15(1): 30.
[http://dx.doi.org/10.1186/s12943-016-0515-5] [PMID: 27130446]
[30]
Ding YL, Sun SF, Zhao GL. COL5A2 as a potential clinical biomarker for gastric cancer and renal metastasis. Medicine 2021; 100(7): e24561.
[http://dx.doi.org/10.1097/MD.0000000000024561] [PMID: 33607786]
[31]
Cong M, Yu T, Zhu L, Zhang J. TNNI3 expression and prognostic value and correlation with tumor-infiltrating immune cells in LIHC: A bioinformatics analysis. Research Square 2022.
[32]
Ferrari N, Mohammed ZMA, Nixon C, et al. Expression of RUNX1 correlates with poor patient prognosis in triple negative breast cancer. PLoS One 2014; 9(6): e100759.
[http://dx.doi.org/10.1371/journal.pone.0100759] [PMID: 24967588]
[33]
Li W, Han F, Fu M, Wang Z. High expression of VCAN is an independent predictor of poor prognosis in gastric cancer. J Int Med Res 2020; 48(1)
[http://dx.doi.org/10.1177/0300060519891271] [PMID: 31939331]
[34]
Gil M, Kim KE. Interleukin-18 is a prognostic biomarker correlated with CD8+ T cell and natural killer cell infiltration in skin cutaneous melanoma. J Clin Med 2019; 8(11): 1993.
[http://dx.doi.org/10.3390/jcm8111993]
[35]
Sun X, et al. OLR1 is a prognostic factor and correlated with immune infiltration in breast cancer. Int Immunopharmacol 2021; 101(Pt B): 108275.
[36]
Tang H, Chen J, Han X, Feng Y, Wang F. Upregulation of SPP1 is a marker for poor lung cancer prognosis and contributes to cancer progression and cisplatin resistance. Front Cell Dev Biol 2021; 9: 646390.
[http://dx.doi.org/10.3389/fcell.2021.646390] [PMID: 33996808]
[37]
Ge W, Shentu D, Wang Y, et al. A novel angiogenesis-based molecular signature related to prognosis and tumor immune interactions of pancreatic cancer. Front Cell Dev Biol 2022; 10: 1001606.
[http://dx.doi.org/10.3389/fcell.2022.1001606]
[38]
Chang ACM, Doherty J, Huschtscha LI, et al. STC1 expression is associated with tumor growth and metastasis in breast cancer. Clin Exp Metastasis 2015; 32(1): 15-27.
[http://dx.doi.org/10.1007/s10585-014-9687-9] [PMID: 25391215]
[39]
Oh HJ, Bae JM, Wen XY, Cho NY, Kim JH, Kang GH. Overexpression of POSTN in tumor stroma is a poor prognostic indicator of colorectal cancer. J Pathol Transl Med 2017; 51(3): 306-13.
[http://dx.doi.org/10.4132/jptm.2017.01.19] [PMID: 28407462]
[40]
Heppt M V, et al. MSX1-induced neural crest-like reprogramming promotes melanoma progression. J Invest Dermatol 2018; 138(1): 141-9.
[http://dx.doi.org/10.1016/j.jid.2017.05.038]
[41]
Zhu H, Zhao H, Wang J, et al. Potential prognosis index for m6A-related mRNA in cholangiocarcinoma. BMC Cancer 2022; 22(1): 620.
[http://dx.doi.org/10.1186/s12885-022-09665-3] [PMID: 35672673]
[42]
Gray RE, Harris GT. Renal cell carcinoma: Diagnosis and management. Am Fam Physician 2019; 99(3): 179-84.
[PMID: 30702258]
[43]
Rivera LB, Bergers G. Intertwined regulation of angiogenesis and immunity by myeloid cells. Trends Immunol 2015; 36(4): 240-9.
[http://dx.doi.org/10.1016/j.it.2015.02.005] [PMID: 25770923]
[44]
Trenti A, Tedesco S, Boscaro C, Trevisi L, Bolego C, Cignarella A. Estrogen, angiogenesis, immunity and cell metabolism: Solving the puzzle. Int J Mol Sci 2018; 19(3): 859.
[http://dx.doi.org/10.3390/ijms19030859] [PMID: 29543707]
[45]
Teicher B A. Antiangiogenic agents and targets: A perspective. Biochemical Pharmacology 2011; 81(1): 6-12.
[http://dx.doi.org/10.1016/j.bcp.2010.09.023]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version276msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[04:54:41] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[04:54:41] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[04:54:41] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[04:54:41] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (92.71ms)time
  • Application (184ms)time
  • 1 x Application (66.45%)
    184ms
    1 x Booting (33.55%)
    92.71ms
    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 duplicated109ms
    • 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 ('314556225','',1,1740459281,1740459281) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740459281
      1.1msalphaeurekaselec_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 ('314556225','/article/131918',1,1740459281,1740459281)
      230μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) 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 >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) 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 >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) 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 >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) 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 >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) 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 >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314556225 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314556225) limit 1
      18.14msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314556225
      • 1: 314556225
      • 2: 314556225
      • 3: 314556225
      • 4: 314556225
      • 5: 314556225
      • 6: 314556225
      • 7: 314556225
      • 8: 314556225
      • 9: 314556225
      • 10: 314556225
      • 11: 314556225
      • 12: 314556225
      • 13: 314556225
      • 14: 314556225
      • 15: 314556225
      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=131918
      880μ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` = 65 limit 1
      1.04msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 65
      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=65) and sj.journal_id!=65 group by `j`.`nid`) as `aggregate_table`
      1.01msalphaeurekaselec_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=65) and sj.journal_id!=65 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      900μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=65) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      3.65msalphaeurekaselec_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=65) 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.24msalphaeurekaselec_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` = '131918'
      220μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 131918
      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` = '131918'
      3.2msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 131918
      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` = '131918' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.87msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 131918
      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
      260μ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
      490μ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 = 65 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      24.71msalphaeurekaselec_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 = 65 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.31msalphaeurekaselec_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 = 65 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      4.8msalphaeurekaselec_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` = 131918 limit 1
      200μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 131918
      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 = 131918 and content_type = 'article' order by status desc limit 1
      230μ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` = 217066 limit 1
      770μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 217066
      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
      280μ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` = 'CBIO' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      350μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CBIO
      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 = '131918' and content_type = 'a' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      500μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2186
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '12749' 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) )
      410μ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 = '3373' 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) )
      380μ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 <= 314556225 and j.to_ip >=314556225 )) and ((j.from_date <= 1740459281 and j.to_date >= 1740459281 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3373) 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 <= 314556225 and j.to_ip >=314556225 )) and ((j.from_date <= 1740459281 and j.to_date >= 1740459281 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3373) 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 <= 314556225 and j.to_ip >=314556225 )) and ((j.from_date <= 1740459281 and j.to_date >= 1740459281 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3373)
      27.86msalphaeurekaselec_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 <= 314556225 and j.to_ip >=314556225 )) and ((j.from_date <= 1740459281 and j.to_date >= 1740459281 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12749) 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 <= 314556225 and j.to_ip >=314556225 )) and ((j.from_date <= 1740459281 and j.to_date >= 1740459281 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12749) 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 <= 314556225 and j.to_ip >=314556225 )) and ((j.from_date <= 1740459281 and j.to_date >= 1740459281 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12749)
      690μ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 <= 314556225 and j.to_ip >=314556225 )) and ((j.from_date <= 1740459281 and j.to_date >= 1740459281 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 131918) 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 <= 314556225 and j.to_ip >=314556225 )) and ((j.from_date <= 1740459281 and j.to_date >= 1740459281 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 131918) 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 <= 314556225 and j.to_ip >=314556225 )) and ((j.from_date <= 1740459281 and j.to_date >= 1740459281 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 131918)
      570μ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` < '670' and is_uploaded = 1 and issue_id = 12749 order by cast(first_page as SIGNED) desc limit 1
      460μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 670
      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` > '679' and is_uploaded = 1 and issue_id = 12749 order by cast(first_page as SIGNED) asc limit 1
      350μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 679
      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'
      170μ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
      170μ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` = 131918 limit 1
      2.32msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 131918
      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` = 65 and `b`.`banner_from_date` <= 1740459281 and `b`.`banner_to_date` >= 1740459281 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.14msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 65
      • 3: 1740459281
      • 4: 1740459281
      • 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` = 65 and `b`.`banner_from_date` <= 1740459281 and `b`.`banner_to_date` >= 1740459281 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.15msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 65
      • 3: 1740459281
      • 4: 1740459281
      • 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='9182a2712f50061834c01dbf2bed5056'
      270μ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
        3PwblSyw2WZac07wtbd2s4IeN9i79JocAHP3Sg82
        uc_cart_id
        9182a2712f50061834c01dbf2bed5056
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/131918" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/131918
        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=eyJpdiI6IkVPeXlYbnNqZzMvNVllOTBwYktFckE9PSIsInZhbHVlIjoiK3p4WUlWbDVjZ3AxUVVidnNJQ3BaOFlwNjdiZXZDV09CNlR4akdIdW51Yz0iLCJtYWMiOiIwYWNlN2I2NjhmYjljYjQ2MjQzOWY2ZDUzNWNlN2ZjNDQ1Y2I2MGY1ZTZiMDM0YmY4MTUzNGY1MjMxYTRjMmQyIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IkVPeXlYbnNqZzMvNVllOTBwYktFckE9PSIsInZhbHVlIjoiK3p4WUlWbDVjZ3AxUVVidnNJQ3BaOFlwNjdiZXZDV09CNlR4akdIdW51Yz0iLCJtYWMiOiIwYWNlN2I2NjhmYjlj" ] "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 04:54:41 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik45QTkxSjhBNHpvRi9SbzBQc2pVVEE9PSIsInZhbHVlIjoiVDlFUEhYNUxVSHFmVHN1ME45a1FSQzFQdzZwNE5rTjlPUmxmZjFRcWVMNUY5bThNZE1TUlNlaE5PNkxoV1VqY1A2Y3VrRVhqYytwSUt0c2FvUi9abnQ0TjhFU0Zyd1NlSkY4Q3dPY2IvbWRraldzTkFOaktFVjNoRk1EY0VqNU8iLCJtYWMiOiI0ZDY3MTZhM2ViYzYzNTlhODkyYzNmOGI1MzBmNTVhNjNjOGZmMjMyOTdjZTBiYzVmOTY0MzI3N2ZjNjAzNGI0IiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 16:54:41 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ik45QTkxSjhBNHpvRi9SbzBQc2pVVEE9PSIsInZhbHVlIjoiVDlFUEhYNUxVSHFmVHN1ME45a1FSQzFQdzZwNE5rTjlPUmxmZjFRcWVMNUY5bThNZE1TUlNlaE5PNkxoV1VqY1A2Y3VrR" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImF5NDB4bG1FSUtJbG12QlpvUGFtb1E9PSIsInZhbHVlIjoiRTl1bUV1NW9oZ08vc2szc2VsRnAvZEhiNnZnOVZlTlNJeS9qK1pPSWZITXozUm1iOGJpZ0d1RnJVd0xHK3gyZllObnpmcnM1Q2MrdzQ5Q2dyNW9XRUZ3eGdGKzQ1VnF4eDZwWldJQ09lTDRNNEtsRGtMTzJPMFZQVFlUaHFMUHUiLCJtYWMiOiJmNGE1ZDAyMTlmOTc2MmIwYmRlMDBhMGI2MTQ3YjU3MDdhOWJkZDU4OTBmZGVmZGI5YmI5NzEzMzgyNjkxMmY2IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6ImF5NDB4bG1FSUtJbG12QlpvUGFtb1E9PSIsInZhbHVlIjoiRTl1bUV1NW9oZ08vc2szc2VsRnAvZEhiNnZnOVZlTlNJeS9qK1pPSWZITXozUm1iOGJpZ0d1RnJ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik45QTkxSjhBNHpvRi9SbzBQc2pVVEE9PSIsInZhbHVlIjoiVDlFUEhYNUxVSHFmVHN1ME45a1FSQzFQdzZwNE5rTjlPUmxmZjFRcWVMNUY5bThNZE1TUlNlaE5PNkxoV1VqY1A2Y3VrRVhqYytwSUt0c2FvUi9abnQ0TjhFU0Zyd1NlSkY4Q3dPY2IvbWRraldzTkFOaktFVjNoRk1EY0VqNU8iLCJtYWMiOiI0ZDY3MTZhM2ViYzYzNTlhODkyYzNmOGI1MzBmNTVhNjNjOGZmMjMyOTdjZTBiYzVmOTY0MzI3N2ZjNjAzNGI0IiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 16:54:41 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ik45QTkxSjhBNHpvRi9SbzBQc2pVVEE9PSIsInZhbHVlIjoiVDlFUEhYNUxVSHFmVHN1ME45a1FSQzFQdzZwNE5rTjlPUmxmZjFRcWVMNUY5bThNZE1TUlNlaE5PNkxoV1VqY1A2Y3VrR" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImF5NDB4bG1FSUtJbG12QlpvUGFtb1E9PSIsInZhbHVlIjoiRTl1bUV1NW9oZ08vc2szc2VsRnAvZEhiNnZnOVZlTlNJeS9qK1pPSWZITXozUm1iOGJpZ0d1RnJVd0xHK3gyZllObnpmcnM1Q2MrdzQ5Q2dyNW9XRUZ3eGdGKzQ1VnF4eDZwWldJQ09lTDRNNEtsRGtMTzJPMFZQVFlUaHFMUHUiLCJtYWMiOiJmNGE1ZDAyMTlmOTc2MmIwYmRlMDBhMGI2MTQ3YjU3MDdhOWJkZDU4OTBmZGVmZGI5YmI5NzEzMzgyNjkxMmY2IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6ImF5NDB4bG1FSUtJbG12QlpvUGFtb1E9PSIsInZhbHVlIjoiRTl1bUV1NW9oZ08vc2szc2VsRnAvZEhiNnZnOVZlTlNJeS9qK1pPSWZITXozUm1iOGJpZ0d1RnJ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "3PwblSyw2WZac07wtbd2s4IeN9i79JocAHP3Sg82" "uc_cart_id" => "9182a2712f50061834c01dbf2bed5056" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/131918" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 04:54:41GET/article/131918414361