Generic placeholder image

Current Pharmaceutical Design

Editor-in-Chief

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

Meta-Analysis

Efficacy and Safety of Atezolizumab Monotherapy or Combined Therapy with Chemotherapy in Patients with Metastatic Triple-negative Breast Cancer: A Systematic Review and Meta-analysis of Randomized Controlled Trials

Author(s): Mina Alimohammadi, Fatemeh Faramarzi, Alireza Mafi, Tahoora Mousavi, Ali Rahimi, Hamed Mirzaei* and Zatollah Asemi*

Volume 29, Issue 31, 2023

Published on: 26 October, 2023

Page: [2461 - 2476] Pages: 16

DOI: 10.2174/0113816128270102231016110637

Price: $65

Abstract

Introduction: Several successful attempts have been recorded with PD-L1 blockade via atezolizumab monotherapy or combination therapy with chemotherapy in patients with metastatic triple-negative breast cancer (mTNBC). Due to the lack of a large-scale study, we present a meta-analysis aimed at evaluating the safety and efficacy of this promising strategy in patients with mTNBC.

Methods: A comprehensive literature search was conducted using electronic databases to identify eligible RCTs. Twelve studies, including 2479 mTBNC patients treated with atezolizumab monotherapy or in combination with chemotherapy, were included up to January 2022. The PRISMA checklist protocol and the I2 statistic were applied for quality assessment and heterogeneity tests of the selected trials, respectively. Fixed and random-effects models were estimated based on the heterogeneity tests, and statistical analysis was performed using CMA.

Results: Our pooled findings demonstrated that the median overall survival (OS) and progression-free survival (PFS) were 16.526 and 5.814 months in mTNBC patients, respectively. Furthermore, when comparing efficacy indicators between PD-L1-positive and PD-L1-negative groups, mTNBC patients with PD-L1 had better OS, PFS, and ORR than PD-L1-negative patients. Also, the immune-related adverse event incident for alopecia was higher (51.9%) than other complications across atezolizumab therapy.

Conclusion: Moreover, the pooled analysis indicated that the overall rate of lung metastasis following atezolizumab therapy was 42.8%, which was higher than the rates of metastasis in bone (26.9%), brain (5.4%), and lymph node (6.5%). Atezolizumab showed a manageable safety profile and had promising and durable anti-tumor efficacy in TMBC patients. Higher PD-L1 expression may be closely correlated with better clinical efficacy.

[1]
Vinay DS, Kwon BS. Harnessing immune checkpoints for cancer therapy. Immunotherapy 2018; 10(14): 1265-84.
[http://dx.doi.org/10.2217/imt-2017-0168] [PMID: 30326786]
[2]
Eika S, Peng L, Renato B, Nicholas R, Ming Y, Yaohe W. Immune checkpoint inhibitors in cancer therapy. J Biomed Res 2018; 32(5): 317-26.
[http://dx.doi.org/10.7555/JBR.31.20160168] [PMID: 28866656]
[3]
Marra A, Viale G, Curigliano G. Recent advances in triple negative breast cancer: The immunotherapy era. BMC Med 2019; 17(1): 90.
[http://dx.doi.org/10.1186/s12916-019-1326-5] [PMID: 31068190]
[4]
Muddu V, Boindala N. Immunotherapy for triple-negative breast cancer: Time to pause? Cancer Rese Statist Treat 2022; 5(1): 182.
[http://dx.doi.org/10.4103/crst.crst_42_22]
[5]
Dixon-Douglas J, Loibl S, Denkert C, Telli M, Loi S. Integrating immunotherapy into the treatment landscape for patients with triple-negative breast cancer Am Soc Clin Oncol Educ 2022; 42(42): 47-59.
[http://dx.doi.org/10.1200/EDBK_351186] [PMID: 35649211]
[6]
Mittendorf EA, Philips AV, Meric-Bernstam F, et al. PD-L1 expression in triple-negative breast cancer. Cancer Immunol Res 2014; 2(4): 361-70.
[http://dx.doi.org/10.1158/2326-6066.CIR-13-0127] [PMID: 24764583]
[7]
Shah NJ, Kelly WJ, Liu SV, Choquette K, Spira A. Product review on the Anti-PD-L1 antibody atezolizumab Taylor Francis 2018.
[http://dx.doi.org/10.1080/21645515.2017.1403694]
[8]
Adams S, Diamond JR, Hamilton E, et al. Atezolizumab plus nab-paclitaxel in the treatment of metastatic triple-negative breast cancer with 2-year survival follow-up: A phase 1b clinical trial. JAMA Oncol 2019; 5(3): 334-42.
[http://dx.doi.org/10.1001/jamaoncol.2018.5152] [PMID: 30347025]
[9]
Emens LA, Cruz C, Eder JP, et al. Long-term clinical outcomes and biomarker analyses of atezolizumab therapy for patients with metastatic triple-negative breast cancer: A phase 1 study. JAMA Oncol 2019; 5(1): 74-82.
[http://dx.doi.org/10.1001/jamaoncol.2018.4224] [PMID: 30242306]
[10]
Schmid P, Adams S, Rugo HS, et al. Atezolizumab and nab-paclitaxel in advanced triple-negative breast cancer. N Engl J Med 2018; 379(22): 2108-21.
[http://dx.doi.org/10.1056/NEJMoa1809615] [PMID: 30345906]
[11]
Kwapisz D. Pembrolizumab and atezolizumab in triple-negative breast cancer. Cancer Immunol Immunother 2021; 70(3): 607-17.
[http://dx.doi.org/10.1007/s00262-020-02736-z] [PMID: 33015734]
[12]
Denkert C, von Minckwitz G, Darb-Esfahani S, et al. Tumour-infiltrating lymphocytes and prognosis in different subtypes of breast cancer: A pooled analysis of 3771 patients treated with neoadjuvant therapy. Lancet Oncol 2018; 19(1): 40-50.
[http://dx.doi.org/10.1016/S1470-2045(17)30904-X] [PMID: 29233559]
[13]
García-Teijido P, Cabal ML, Fernández IP, Pérez YF. Tumor-infiltrating lymphocytes in triple negative breast cancer: The future of immune targeting. Clin Med Insights Oncol 2016; 10 (Suppl. 1): 31-9.
[http://dx.doi.org/10.4137/CMO.S34540]
[14]
Stanton SE, Adams S, Disis ML. Variation in the incidence and magnitude of tumor-infiltrating lymphocytes in breast cancer subtypes: A systematic review. JAMA Oncol 2016; 2(10): 1354-60.
[http://dx.doi.org/10.1001/jamaoncol.2016.1061] [PMID: 27355489]
[15]
Abraham J, Varma R, Wright M, Kruse M. Immune checkpoint inhibition in early-stage triple-negative breast cancer. Expert Rev Anticancer Ther 2022; 22(11): 1225-38.
[16]
Tornincasa A, Canino F, Trudu L, et al. Atezolizumab-related sarcoidosis-like reaction in early breast cancer patient: Know it to diagnose it: A case report with review of the literature. Arch Clin Med Case Rep 2022; 6(4): 611-2.
[http://dx.doi.org/10.26502/acmcr.96550528]
[17]
Heinhuis KM, Ros W, Kok M, Steeghs N, Beijnen JH, Schellens JHM. Enhancing antitumor response by combining immune checkpoint inhibitors with chemotherapy in solid tumors. Ann Oncol 2019; 30(2): 219-35.
[http://dx.doi.org/10.1093/annonc/mdy551] [PMID: 30608567]
[18]
Emens LA, Molinero L, Loi S, et al. Atezolizumab and nab-paclitaxel in advanced triple-negative breast cancer: Biomarker evaluation of the IMpassion130 study. J Natl Cancer Inst 2021; 113(8): 1005-16.
[http://dx.doi.org/10.1093/jnci/djab004] [PMID: 33523233]
[19]
Hussaini S, Chehade R, Boldt RG, et al. Association between immune-related side effects and efficacy and benefit of immune checkpoint inhibitors: A systematic review and meta-analysis. Cancer Treat Rev 2021; 92: 102134.
[http://dx.doi.org/10.1016/j.ctrv.2020.102134] [PMID: 33302134]
[20]
Fujii T, Naing A, Rolfo C, Hajjar J. Biomarkers of response to immune checkpoint blockade in cancer treatment. Crit Rev Oncol Hematol 2018; 130: 108-20.
[http://dx.doi.org/10.1016/j.critrevonc.2018.07.010] [PMID: 30196907]
[21]
Zou Y, Zou X, Zheng S, et al. Efficacy and predictive factors of immune checkpoint inhibitors in metastatic breast cancer: A systematic review and meta-analysis Ther Adv Med Oncol 2020; 12
[http://dx.doi.org/10.1177/1758835920940928] [PMID: 32874208]
[22]
Latif F, Bint Abdul Jabbar H, Malik H, et al. Atezolizumab and pembrolizumab in triple-negative breast cancer: A meta-analysis. Expert Rev Anticancer Ther 2022; 22(2): 229-35.
[http://dx.doi.org/10.1080/14737140.2022.2023011] [PMID: 34949142]
[23]
Sharmni Vishnu K, Win TT, Aye SN, Basavaraj AK. Combined atezolizumab and nab-paclitaxel in the treatment of triple negative breast cancer: A meta-analysis on their efficacy and safety. BMC Cancer 2022; 22(1): 1139.
[http://dx.doi.org/10.1186/s12885-022-10225-y] [PMID: 36335316]
[24]
Liberati A, Altman DG, Tetzlaff J, et al. The PRISMA statement for reporting systematic reviews and meta-analyses of studies that evaluate healthcare interventions: Explanation and elaboration. BMJ 2009; 339(jul21 1): b2700.
[http://dx.doi.org/10.1136/bmj.b2700] [PMID: 19622552]
[25]
Higgins JPT, Altman DG, Gøtzsche PC, et al. The Cochrane Collaboration’s tool for assessing risk of bias in randomised trials BMJ 2011; 343(oct18 2): d5928.
[http://dx.doi.org/10.1136/bmj.d5928] [PMID: 22008217]
[26]
Ameri A, Tavakoli-Far B, Rostami M, et al. Recent advances in atezolizumab-based programmed death-ligand 1 (PD-L1) blockade therapy for breast cancer. Int Immunopharmacol 2022; 113(Pt A): 109334.
[http://dx.doi.org/10.1016/j.intimp.2022.109334] [PMID: 36327869]
[27]
Zhang X, Ge X, Jiang T, Yang R, Li S. Research progress on immunotherapy in triple-negative breast cancer. Review. Int J Oncol 2022; 61(2): 95.
[http://dx.doi.org/10.3892/ijo.2022.5385] [PMID: 35762339]
[28]
Abdou Y, Goudarzi A, Yu JX, Upadhaya S, Vincent B, Carey LA. Immunotherapy in triple negative breast cancer: Beyond checkpoint inhibitors. npj. Breast Cancer 2022; 8(1): 1-10.
[PMID: 35013314]
[29]
Ovcaricek T, Dobovisek L, Gasljevic G, Stefanovski D, Borstnar S. PD-L1 immune cell expression levels and clinical outcomes in advanced triple-negative breast cancer treated with atezolizumab. American Society of Clinical Oncology 2022.
[http://dx.doi.org/10.1200/JCO.2022.40.16_suppl.e13066]
[30]
Chae YK, Arya A, Iams W, et al. Current landscape and future of dual anti-CTLA4 and PD-1/PD-L1 blockade immunotherapy in cancer; lessons learned from clinical trials with melanoma and non-small cell lung cancer (NSCLC). J Immunother Cancer 2018; 6(1): 39.
[http://dx.doi.org/10.1186/s40425-018-0349-3] [PMID: 29769148]
[31]
Gianni L, Huang CS, Egle D, et al. Pathologic complete response (pCR) to neoadjuvant treatment with or without atezolizumab in triple-negative, early high-risk and locally advanced breast cancer: NeoTRIP Michelangelo randomized study. Ann Oncol 2022; 33(5): 534-43.
[http://dx.doi.org/10.1016/j.annonc.2022.02.004] [PMID: 35182721]
[32]
Loibl S, Untch M, Burchardi N, et al. Randomized phase II neoadjuvant study (GeparNuevo) to investigate the addition of durvalumab to a taxane-anthracycline containing chemotherapy in triple negative breast cancer (TNBC). J Clin Oncol 2018; 36(15) (Suppl.): 104.
[http://dx.doi.org/10.1200/JCO.2018.36.15_suppl.104]
[33]
Molinero L, Emens LA, Goldstein LD, et al. Mechanisms of action and acquired resistance to atezolizumab plus nab-paclitaxel in metastatic triple-negative breast cancer (mTNBC). American Society of Clinical Oncology 2022.
[http://dx.doi.org/10.1200/JCO.2022.40.16_suppl.1078]
[34]
Schmid P, Adams S, Rugo HS, et al. IMpassion130: updated overall survival (OS) from a global, randomized, double-blind, placebo-controlled, Phase III study of atezolizumab (atezo)+ nab-paclitaxel (nP) in previously untreated locally advanced or metastatic triple-negative breast cancer (mTNBC). American Society of Clinical Oncology 2019.
[35]
Khosravi-Shahi P, Cabezón-Gutiérrez L, Custodio-Cabello S. Metastatic triple negative breast cancer: Optimizing treatment options, new and emerging targeted therapies. Asia Pac J Clin Oncol 2018; 14(1): 32-9.
[http://dx.doi.org/10.1111/ajco.12748] [PMID: 28815913]
[36]
Mamounas E, Bandos H, Lembersky B, et al. Abstract S1-05: A randomized, double-blinded, placebo-controlled clinical trial of extended adjuvant endocrine therapy (tx) with letrozole (L) in postmenopausal women with hormone-receptor (+) breast cancer (BC) who have completed previous adjuvant tx with an aromatase inhibitor (AI): Results from NRG Oncology/NSABP B-42. Cancer Res 2017; 77: S1-5.
[http://dx.doi.org/10.1158/1538-7445.SABCS16-S1-05]
[37]
He R, Yuan X, Chen Z, Zheng Y. Combined immunotherapy for metastatic triple-negative breast cancer based on PD-1/PD-L1 immune checkpoint blocking. Int Immunopharmacol 2022; 113(Pt B): 109444.
[http://dx.doi.org/10.1016/j.intimp.2022.109444] [PMID: 36402069]
[38]
Page DB, Bear H, Prabhakaran S, et al. Two may be better than one: PD-1/PD-L1 blockade combination approaches in metastatic breast cancer. NPJ Breast Cancer 2019; 5(1): 34.
[http://dx.doi.org/10.1038/s41523-019-0130-x] [PMID: 31602395]
[39]
Aran D, Klein-Brill A, Fisch MJ, Amar-Farkash S. Real-world data comparing atezolizumab plus taxane therapy versus taxane alone as first-line treatment of metastatic triple-negative breast cancer patients in the United States American Society of Clinical Oncology 2022.
[http://dx.doi.org/10.1200/JCO.2022.40.16_suppl.e18767]
[40]
Brahmer JR, Lacchetti C, Schneider BJ, et al. Management of immune-related adverse events in patients treated with immune checkpoint inhibitor therapy: American Society of Clinical Oncology Clinical Practice Guideline. J Clin Oncol 2018; 36(17): 1714-68.
[http://dx.doi.org/10.1200/JCO.2017.77.6385] [PMID: 29442540]
[41]
Puzanov I, Diab A, Abdallah K, et al. Managing toxicities associated with immune checkpoint inhibitors: Consensus recommendations from the Society for Immunotherapy of Cancer (SITC) Toxicity Management Working Group. J Immunother Cancer 2017; 5(1): 95.
[http://dx.doi.org/10.1186/s40425-017-0300-z] [PMID: 29162153]
[42]
Brufsky A, Kim SB, Zvirbule Ž, et al. A phase II randomized trial of cobimetinib plus chemotherapy, with or without atezolizumab, as first-line treatment for patients with locally advanced or metastatic triple-negative breast cancer (COLET): Primary analysis. Ann Oncol 2021; 32(5): 652-60.
[http://dx.doi.org/10.1016/j.annonc.2021.01.065] [PMID: 33539944]
[43]
Narayan P, Wahby S, Gao JJ, et al. FDA approval summary: Atezolizumab plus paclitaxel protein-bound for the treatment of patients with advanced or metastatic tnbc whose tumors express PD-L1. Clin Cancer Res 2020; 26(10): 2284-9.
[http://dx.doi.org/10.1158/1078-0432.CCR-19-3545] [PMID: 32001481]
[44]
Miles D, Gligorov J, André F, et al. Primary results from IMpassion131, a double-blind, placebo-controlled, randomised phase III trial of first-line paclitaxel with or without atezolizumab for unresectable locally advanced/metastatic triple-negative breast cancer. Ann Oncol 2021; 32(8): 994-1004.
[http://dx.doi.org/10.1016/j.annonc.2021.05.801] [PMID: 34219000]
[45]
Wang H, Ma H, Sové RJ, Emens LA, Popel AS. Quantitative systems pharmacology model predictions for efficacy of atezolizumab and nab-paclitaxel in triple-negative breast cancer. J Immunother Cancer 2021; 9(2): e002100.
[http://dx.doi.org/10.1136/jitc-2020-002100] [PMID: 33579739]
[46]
Iwata H, Inoue K, Kaneko K, et al. Subgroup analysis of Japanese patients in a Phase 3 study of atezolizumab in advanced triple-negative breast cancer (IMpassion130). Jpn J Clin Oncol 2019; 49(12): 1083-91.
[http://dx.doi.org/10.1093/jjco/hyz135] [PMID: 31612909]
[47]
Adams S, Diamond JR, Hamilton EP, et al. Phase Ib trial of atezolizumab in combination with nab-paclitaxel in patients with metastatic triple-negative breast cancer (mTNBC). American Society of Clinical Oncology 2016.
[http://dx.doi.org/10.1200/JCO.2016.34.15_suppl.1009]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version431msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[00:17:09] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[00:17:09] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[00:17:09] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[00:17:09] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[00:17:09] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (99.32ms)time
  • Application (332ms)time
  • 1 x Application (76.95%)
    332ms
    1 x Booting (23.05%)
    99.32ms
    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 duplicated247ms
    • 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 ('873362154','',1,1740529029,1740529029) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740529029
      1.6msalphaeurekaselec_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 ('873362154','/article/135657',1,1740529029,1740529029)
      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 >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) 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 >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) 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 >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) 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 >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) 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 >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) 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 >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 873362154 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873362154) limit 1
      15.79msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 873362154
      • 1: 873362154
      • 2: 873362154
      • 3: 873362154
      • 4: 873362154
      • 5: 873362154
      • 6: 873362154
      • 7: 873362154
      • 8: 873362154
      • 9: 873362154
      • 10: 873362154
      • 11: 873362154
      • 12: 873362154
      • 13: 873362154
      • 14: 873362154
      • 15: 873362154
      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=135657
      1.22msalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 29 limit 1
      1.29msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 29
      Backtrace
      • 14. app/Models/Journal.php:64
      • 15. app/Http/Controllers/ArticleController.php:2516
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=29) and sj.journal_id!=29 group by `j`.`nid`) as `aggregate_table`
      1.55msalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=29) and sj.journal_id!=29 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.26msalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=29) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.17msalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 16. app/Models/Subject.php:220
      • 17. app/Http/Controllers/ArticleController.php:2518
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=29) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      1.91msalphaeurekaselec_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` = '135657'
      280μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 135657
      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` = '135657'
      2.63msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 135657
      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` = '135657' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.64msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 135657
      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
      280μ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 = 29 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      45.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 = 29 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      81.89msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2070
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 29 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      60.16msalphaeurekaselec_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` = 135657 limit 1
      360μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 135657
      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 = 135657 and content_type = 'article' order by status desc limit 1
      410μ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` = 222778 limit 1
      340μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 222778
      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
      360μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CPD' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      510μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CPD
      Backtrace
      • 13. app/Models/Article.php:2025
      • 14. app/Http/Controllers/ArticleController.php:2112
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '135657' 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) )
      510μ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 = '12886' 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) )
      380μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '3322' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      330μ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 <= 873362154 and j.to_ip >=873362154 )) and ((j.from_date <= 1740529029 and j.to_date >= 1740529029 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3322) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 873362154 and j.to_ip >=873362154 )) and ((j.from_date <= 1740529029 and j.to_date >= 1740529029 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3322) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 873362154 and j.to_ip >=873362154 )) and ((j.from_date <= 1740529029 and j.to_date >= 1740529029 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3322)
      14.15msalphaeurekaselec_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 <= 873362154 and j.to_ip >=873362154 )) and ((j.from_date <= 1740529029 and j.to_date >= 1740529029 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12886) 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 <= 873362154 and j.to_ip >=873362154 )) and ((j.from_date <= 1740529029 and j.to_date >= 1740529029 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12886) 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 <= 873362154 and j.to_ip >=873362154 )) and ((j.from_date <= 1740529029 and j.to_date >= 1740529029 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12886)
      920μ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 <= 873362154 and j.to_ip >=873362154 )) and ((j.from_date <= 1740529029 and j.to_date >= 1740529029 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 135657) 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 <= 873362154 and j.to_ip >=873362154 )) and ((j.from_date <= 1740529029 and j.to_date >= 1740529029 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 135657) 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 <= 873362154 and j.to_ip >=873362154 )) and ((j.from_date <= 1740529029 and j.to_date >= 1740529029 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 135657)
      710μ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` < '2461' and is_uploaded = 1 and issue_id = 12886 order by cast(first_page as SIGNED) desc limit 1
      540μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 2461
      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` > '2476' and is_uploaded = 1 and issue_id = 12886 order by cast(first_page as SIGNED) asc limit 1
      480μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 2476
      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'
      200μ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
      230μ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` = 135657 limit 1
      2.39msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 135657
      Backtrace
      • 16. app/Http/Controllers/ArticleController.php:2506
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select b.banner_link, b.banner_name, b.banner_script, b.banner_remarks, b.banner_file_name, b.banner_placement, bd.content_type, bd.content_id from `tbl_banner` as `b` inner join `tbl_banner_detail` as `bd` on `bd`.`banner_id` = `b`.`banner_id` inner join `users` as `u` on `u`.`id` = `b`.`updated_by` inner join `journal` as `j` on `j`.`journal_id` = `bd`.`content_id` where `b`.`banner_journal` = 1 and `bd`.`content_type` = 'J' and `bd`.`content_id` = 29 and `b`.`banner_from_date` <= 1740529029 and `b`.`banner_to_date` >= 1740529029 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.16msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 29
      • 3: 1740529029
      • 4: 1740529029
      • 5: A
      Backtrace
      • 13. app/Models/Banner.php:95
      • 14. app/Http/helpers.php:404
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • select b.banner_link, b.banner_name, b.banner_script, b.banner_remarks, b.banner_file_name, b.banner_placement, bd.content_type, bd.content_id from `tbl_banner` as `b` inner join `tbl_banner_detail` as `bd` on `bd`.`banner_id` = `b`.`banner_id` inner join `users` as `u` on `u`.`id` = `b`.`updated_by` inner join `journal` as `j` on `j`.`journal_id` = `bd`.`content_id` where `b`.`banner_journal` = 1 and `bd`.`content_type` = 'J' and `bd`.`content_id` = 29 and `b`.`banner_from_date` <= 1740529029 and `b`.`banner_to_date` >= 1740529029 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: 29
      • 3: 1740529029
      • 4: 1740529029
      • 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='3f6aa9b52a3829684e88d4583b535aba'
      250μ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
        LR4s1QNeAfm4bbI1PdjG7P8myW7Kn3ETkCliQeg8
        uc_cart_id
        3f6aa9b52a3829684e88d4583b535aba
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/135657" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/135657
        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=eyJpdiI6Imp4THIrakQ2WEI1TVQ0S1JIV29iUkE9PSIsInZhbHVlIjoiaUlpMEY5ZDR0VzJiSTRnKy9FeG9jV2VsbzhEV3VXckdaQ1daRkdmZS9UOD0iLCJtYWMiOiI5YWY3NjYyNTNkYzJmMTU2ZGRkNTU2NTk3ZWQ3NzhlNjBmOTc5MTA5NmE2MmNmMTZjNDY1Njc0MmQxY2IzNGI3IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6Imp4THIrakQ2WEI1TVQ0S1JIV29iUkE9PSIsInZhbHVlIjoiaUlpMEY5ZDR0VzJiSTRnKy9FeG9jV2VsbzhEV3VXckdaQ1daRkdmZS9UOD0iLCJtYWMiOiI5YWY3NjYyNTNkYzJm" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 26 Feb 2025 00:17:09 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImEvOHlnQkFBTk1INjF6aTFiWi9VM3c9PSIsInZhbHVlIjoidXI2N21sZnJsZVdhTFpSYVF1K3EzME50RVpvT0ppN0JBZExTMGIwY0lsREYzNWtsaHBqVmY0YW1DM00zYzQ4Ry9relA2WjRuWGVXODBNQUdzMUlvQlpqeVJVR3UxVEh0TGVWMXR3QmNnMURTM2I1cUdEMjhqTkU5K0w2VHgzR3MiLCJtYWMiOiI5YzczYjU0OTA1Zjc3ZGJmMzQ3YWI4ZTI2N2I4MTI0NThjNTc1NzM4MmZlZGM1ODRjZjczZjE5MWVlN2I3ODgxIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 12:17:09 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImEvOHlnQkFBTk1INjF6aTFiWi9VM3c9PSIsInZhbHVlIjoidXI2N21sZnJsZVdhTFpSYVF1K3EzME50RVpvT0ppN0JBZExTMGIwY0lsREYzNWtsaHBqVmY0YW1DM00zYzQ4Ry9relA2W" 1 => "alphaeurekaselectnet_session=eyJpdiI6InMzY0NhTTYxaU1oVXp5NjRueWhSeWc9PSIsInZhbHVlIjoiM1hackNoZjlLcS92cmlwdlJJYmFWeXZmR1llSDF2OGJoWit2cE5CVW92SVA1ZmVWenJpd2FTVUlVQ1lBR2pZdWhrU3h6RllTNlQ3YjFXcHd5L0JockNkeUdOL1BIS2tqbzhkV0ViWXZMdmZ1dE5XRWJlbUVmbVk4Nm1jVS9tSmQiLCJtYWMiOiJjYTUyZTI0OWVjOGVhODMzY2YwMzc0ZWRkNjIxOTU3ZDJjOGI0ZDI5MmU0NTY0NDNhZWQ3MTk1NmYzYWUwMzI4IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6InMzY0NhTTYxaU1oVXp5NjRueWhSeWc9PSIsInZhbHVlIjoiM1hackNoZjlLcS92cmlwdlJJYmFWeXZmR1llSDF2OGJoWit2cE5CVW92SVA1ZmVWenJpd2FTVUl" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImEvOHlnQkFBTk1INjF6aTFiWi9VM3c9PSIsInZhbHVlIjoidXI2N21sZnJsZVdhTFpSYVF1K3EzME50RVpvT0ppN0JBZExTMGIwY0lsREYzNWtsaHBqVmY0YW1DM00zYzQ4Ry9relA2WjRuWGVXODBNQUdzMUlvQlpqeVJVR3UxVEh0TGVWMXR3QmNnMURTM2I1cUdEMjhqTkU5K0w2VHgzR3MiLCJtYWMiOiI5YzczYjU0OTA1Zjc3ZGJmMzQ3YWI4ZTI2N2I4MTI0NThjNTc1NzM4MmZlZGM1ODRjZjczZjE5MWVlN2I3ODgxIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 12:17:09 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImEvOHlnQkFBTk1INjF6aTFiWi9VM3c9PSIsInZhbHVlIjoidXI2N21sZnJsZVdhTFpSYVF1K3EzME50RVpvT0ppN0JBZExTMGIwY0lsREYzNWtsaHBqVmY0YW1DM00zYzQ4Ry9relA2W" 1 => "alphaeurekaselectnet_session=eyJpdiI6InMzY0NhTTYxaU1oVXp5NjRueWhSeWc9PSIsInZhbHVlIjoiM1hackNoZjlLcS92cmlwdlJJYmFWeXZmR1llSDF2OGJoWit2cE5CVW92SVA1ZmVWenJpd2FTVUlVQ1lBR2pZdWhrU3h6RllTNlQ3YjFXcHd5L0JockNkeUdOL1BIS2tqbzhkV0ViWXZMdmZ1dE5XRWJlbUVmbVk4Nm1jVS9tSmQiLCJtYWMiOiJjYTUyZTI0OWVjOGVhODMzY2YwMzc0ZWRkNjIxOTU3ZDJjOGI0ZDI5MmU0NTY0NDNhZWQ3MTk1NmYzYWUwMzI4IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6InMzY0NhTTYxaU1oVXp5NjRueWhSeWc9PSIsInZhbHVlIjoiM1hackNoZjlLcS92cmlwdlJJYmFWeXZmR1llSDF2OGJoWit2cE5CVW92SVA1ZmVWenJpd2FTVUl" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "LR4s1QNeAfm4bbI1PdjG7P8myW7Kn3ETkCliQeg8" "uc_cart_id" => "3f6aa9b52a3829684e88d4583b535aba" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/135657" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-26 00:17:09GET/article/135657514361