Systematic Review Article

绝对血嗜酸性粒细胞计数指导COPD患者的吸入性糖皮质激素治疗:系统评价和荟萃分析

卷 20, 期 16, 2019

页: [1670 - 1679] 页: 10

弟呕挨: 10.2174/1389450120666190808141625

价格: $65

摘要

简介:《 2019年全球慢性阻塞性肺疾病倡议》(GOLD)建议在慢性阻塞性肺疾病患者的药理管理中使用绝对血嗜酸性粒细胞计数作为吸入性糖皮质激素(ICS)升级和降级的指南( COPD)。在本系统评价中,我们通过绝对血液嗜酸性粒细胞阈值评估了ICS治疗逐步升级和降级的患者中度或重度加重的风险。 方法:通过对截至2019年4月的Pubmed / MEDLINE,EMBASE和临床试验站点进行全面文献检索,我们确定了相关研究。我们使用具有固定效果估计值的通用逆方差方法,比较暴露于吸入性糖皮质激素(ICS)的非嗜血性粒细胞增多的COPD患者与非ICS治疗组中度或重度加重的风险,以风险比表示。 结果:共纳入10项研究(8项随机对照试验和2项观察性研究),共计85,059名COPD患者。在我们的汇总分析中,我们发现在ICS逐步升高的患者中,绝对血液嗜酸性粒细胞阈值范围从≥100至≥340细胞/μL的患者中中度或重度加重的风险总体降低了(RR,0.77,95%CI,0.73-0.81 )。对于评估ICS降级对中度至重度加重的影响的研究,血液中嗜酸性粒细胞阈值≥300至≥340细胞/μL,在ICS降级后中度或重度加重的风险增加(RR,1.66, 95%CI,1.31-2.10)。 结论:这项研究证实了推荐的绝对血嗜酸性粒细胞绝对计数阈值对于COPD患者ICS升高和降低的有效性。但是,此建议是针对先前加重的COPD患者,而不是针对本研究中观察到的新诊断的COPD患者。具有当前或过去哮喘病史的COPD患者代表独特的表型组,应进一步评估。

关键词: 慢性阻塞性肺疾病,血液嗜酸性粒细胞增多,恶化,吸入皮质类固醇,嗜酸性粒细胞,药理学。

图形摘要

[1]
Vogelmeier CF, Criner GJ, Martinez FJ, et al. Global strategy for the diagnosis, management, and prevention of chronic obstructive lung disease 2017 report. gold executive summary. Am J Respir Crit Care Med 2017; 195: 557-82.
[2]
Franssen FME, Spruit MA, Wouters EFM. Determinants of polypharmacy and compliance with GOLD guidelines in patients with chronic obstructive pulmonary disease. Int J Chron Obstruct Pulmon Dis 2011; 6: 493-501.
[3]
Wedzicha JA, Seemungal TA. COPD exacerbations: defining their cause and prevention. Lancet 2007; 370: 786-96.
[4]
Kew KM, Seniukovich A. Inhaled steroids and risk of pneumonia for chronic obstructive pulmonary disease. Cochrane Database Syst Rev 2014; 3CD010115
[5]
Hubbard RB, Smith CJP, Smeeth L, Harrison TW, Tattersfield AE. Inhaled corticosteroids and hip fracture: a population-based case-control study. Am J Respir Crit Care Med 2002; 166: 1563-6.
[6]
GOLD. Global strategy for the prevention, diagnosis and treatment of chronic obstructive pulmonary disease (2019 Report) 2018.
[7]
Bafadhel M, McKenna S, Terry S, et al. Blood eosinophils to direct corticosteroid treatment of exacerbations of chronic obstructive pulmonary disease: A randomized placebo-controlled trial. Am J Respir Crit Care Med 2012; 186: 48-55.
[8]
Pascoe S, Locantore N, Dransfield MT, Barnes NC, Pavord I. Blood eosinophil counts as markers of response to inhaled corticosteroids in COPD? -Authors’ reply. Lancet Respir Med 2015; 3e27
[9]
Oshagbemi OA, Burden AM, Braeken DCW, et al. Stability of blood eosinophils in patients with chronic obstructive pulmonary disease and in control subjects, and the impact of sex, age, smoking, and baseline counts. Am J Respir Crit Care Med 2017; 195(10): 1402-4.
[10]
Siddiqui SH, Guasconi A, Vestbo J, et al. Blood eosinophils: a biomarker of response to extrafine beclomethasone/formoterol in chronic obstructive pulmonary disease. Am J Respir Crit Care Med 2015; 192: 523-5.
[11]
Han MK. GOLD 2019: a new way forward. Lancet Respir Med 2018; (18): 30498-.
[12]
Higgins P, Green S. Cochrane Handbook for Systematic Reviews of Interventions 2011.
[13]
Bafadhel M, Peterson S, De Blas MA, et al. Predictors of exacerbation risk and response to budesonide in patients with chronic obstructive pulmonary disease: a post-hoc analysis of three randomised trials. Lancet Respir Med 2018; 6(2): 117-26.
[14]
Lipson DA, Barnhart F, Brealey N, et al. Once-Daily Single-Inhaler Triple versus Dual Therapy in Patients with COPD. N Engl J Med 2018; 378(18): 1671-80.
[15]
Papi A, Vestbo J, Fabbri L, et al. Extrafine inhaled triple therapy versus dual bronchodilator therapy in chronic obstructive pulmonary disease (TRIBUTE): a double-blind, parallel group, randomised controlled trial. Lancet 2018; 391(10125): 1076-84.
[16]
Roche N, Chapman KR, Vogelmeier CF, et al. Blood Eosinophils and Response to Maintenance COPD Treatment: Data from the FLAME Trial. Am J Respir Crit Care Med 2017; 195: 1189-97.
[http://dx.doi.org/10.1164/rccm.201701-0193OC]
[17]
Chapman KR, Hurst JR, Frent S-M, et al. Long-term triple therapy de-escalation to indacaterol/ glycopyrronium in patients with chronic obstructive pulmonary disease (sunset): a randomized, double-blind, triple-dummy clinical trial. Am J Respir Crit Care Med 2018; 198: 329-39.
[18]
Watz H, Tetzlaff K, Wouters EFM, et al. Blood eosinophil count and exacerbations in severe chronic obstructive pulmonary disease after withdrawal of inhaled corticosteroids: A post-hoc analysis of the WISDOM trial. Lancet Respir Med 2016; 4: 390-8.
[http://dx.doi.org/10.1016/ S2213-2600(16)00100-4]
[19]
Oshagbemi OA, Franssen FME, Braeken DCW, et al. Blood eosinophilia, use of inhaled corticosteroids, and risk of COPD exacerbations and mortality. Pharmacoepidemiol Drug Saf 2018; 27: 1191-9.
[20]
Suissa S, Dell’Aniello S, Ernst P. Comparative effectiveness of LABA-ICS versus LAMA as initial treatment in COPD targeted by blood eosinophils: a population-based cohort study. Lancet Respir Med 2018; 6(11): 855-62.
[21]
Calverley PMA, Tetzlaff K, Vogelmeier C, Fabbri LM, Magnussen H, Wouters EFM, et al. Eosinophilia, Frequent Exacerbations, and Steroid Response in Chronic Obstructive Pulmonary Disease. Am J Respir Crit Care Med 2017; 196(9): 1219-21.
[22]
Barnes PJ. Corticosteroid resistance in patients with asthma and chronic obstructive pulmonary disease. J Allergy Clin Immunol 2013; 131: 636-45.
[http://dx.doi.org/10.1016/j.jaci.2012.12.1564]
[23]
Vestbo J, Anderson W, Coxson HO, et al. Evaluation of COPD Longitudinally to Identify Predictive Surrogate End-points (ECLIPSE). Eur Respir J 2008; 31: 869-73.
[24]
Barnes PJ. Asthma-COPD Overlap. Chest 2016; 149: 7-8.
[25]
Suzuki M, Makita H, Konno S, et al. Asthma-like features and clinical course of chronic obstructive pulmonary disease. an analysis from the hokkaido copd cohort study. Am J Respir Crit Care Med 2016; 194: 1358-65.
[http://dx.doi.org/10.1164/rccm.201602-0353OC]
[26]
Saha S, Brightling CE. Eosinophilic airway inflammation in COPD. Int J Chron Obstruct Pulmon Dis 2006; 1: 39-47.
[27]
Shrimanker R, Thulborn SJ, Mistry V, et al. The peripheral blood eosinophil count as a biomarker of eosinophilic airway inflammation in patients with asthma and COPD.Experience from a Single Centre. A33. Clin. Stud. Obstr. LUNG Dis., American Thoracic Society 2017; A1343-A1343.
[http://dx.doi.org/doi:doi:10.1164/ajrccmconference. 2017.195.1_ MeetingAbstracts.A1343]
[28]
Negewo N, McDonald V, Baines K, et al. Can blood eosinophils predict sputum eosinophils in stable COPD? Eur Respir J 2015; 46PA3967
[29]
Hastie AT, Martinez FJ, Curtis JL, et al. Association of sputum and blood eosinophil concentrations with clinical measures of COPD severity: an analysis of the SPIROMICS cohort. Lancet Respir Med 2017; 5: 956-67.
[30]
Balkissoon R. COPD association and repeatability of blood biomarkers in the ECLIPSE cohort. COPD J Chronic Obstr Pulm Dis 2012; 9: 84.
[31]
Landis SH, Suruki R, Hilton E, Compton C, Galwey NW. Stability of blood eosinophil count in patients with copd in the uk clinical practice research datalink. COPD J Chronic Obstr Pulm Dis 2017; 14: 382-8.
[32]
Barnes NC, Sharma R, Lettis S, Calverley PMA. Blood eosinophils as a marker of response to inhaled corticosteroids in COPD. Eur Respir J 2016; 1374-82.
[33]
Pavord ID, Lettis S, Locantore N, et al. Blood eosinophils and inhaled corticosteroid/long-acting β-2 agonist efficacy in COPD. Thorax 2016; 71: 118-25.
[34]
Zysman M, Burgel PR, Paillasseur JL, et al. Relationship between blood eosinophil count (Eos), clinical characteristics and mortality of patients with COPD. Eur Respir J 2016. 48: PA 4614.
[35]
Vos T, Flaxman AD, Naghavi M, Lozano R, Michaud C, Ezzati M, et al. Years lived with disability (YLDs) for 1160 sequelae of 289 diseases and injuries 1990-2010: A systematic analysis for the Global Burden of Disease Study 2010. Lancet 2012; 380: 2163-96.
[36]
Vedel-Krogh S, Nielsen SF, Lange P, Vestbo J, Nordestgaard BG. Blood Eosinophils and Exacerbations in Chronic Obstructive Pulmonary Disease. The Copenhagen General Population Study. Am J Respir Crit Care Med 2016; 193: 965-74.
[37]
Zeiger RS, Tran TN, Butler RK, et al. Relationship of Blood Eosinophil Count to Exacerbations in Chronic Obstructive Pulmonary Disease. J Allergy Clin Immunol Pract 2018; 6: 944-954.e5.
[38]
Yun JH, Lamb A, Chase R, et al. Blood eosinophil count thresholds and exacerbations in patients with chronic obstructive pulmonary disease. J Allergy Clin Immunol 2018; 141: 2037-2047.e10.
[39]
Morjaria JB, Rigby A, Morice AH. Inhaled Corticosteroid use and the Risk of Pneumonia and COPD Exacerbations in the UPLIFT Study. Lung 2017; 195: 281-8.
[40]
de Melo MN, Ernst P, Suissa S. Inhaled corticosteroids and the risk of a first exacerbation in COPD patients. Eur Respir J 2004; 23: 692-7.
[41]
Suh D-C, Lau H, La H-O, Choi I-S, Geba GP. Association between incidence of acute exacerbation and medication therapy in patients with COPD. Curr Med Res Opin 2010; 26: 297-306.
[42]
Funk MJ, Landi SN. Misclassification in administrative claims data: quantifying the impact on treatment effect estimates. Curr Epidemiol Rep 2014; 1: 175-85.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version1.04sRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[04:52:20] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[04:52:21] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[04:52:21] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (391ms)time
  • Application (647ms)time
  • 1 x Application (62.35%)
    647ms
    1 x Booting (37.65%)
    391ms
    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
    41 statements were executed, 4 of which were duplicates, 37 unique. Show only duplicated477ms
    • 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 ('221946642','',1,1740459140,1740459140) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740459140
      1.3msalphaeurekaselec_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 ('221946642','/article/100221/cn',1,1740459140,1740459140)
      260μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) 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 >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) 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 >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) 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 >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) 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 >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) 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 >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) limit 1
      106msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 221946642
      • 1: 221946642
      • 2: 221946642
      • 3: 221946642
      • 4: 221946642
      • 5: 221946642
      • 6: 221946642
      • 7: 221946642
      • 8: 221946642
      • 9: 221946642
      • 10: 221946642
      • 11: 221946642
      • 12: 221946642
      • 13: 221946642
      • 14: 221946642
      • 15: 221946642
      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=100221
      28.67msalphaeurekaselec_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` = 13 limit 1
      1.21msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 13
      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=13) and sj.journal_id!=13 group by `j`.`nid`) as `aggregate_table`
      1.69msalphaeurekaselec_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=13) and sj.journal_id!=13 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.29msalphaeurekaselec_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=13) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      16.31msalphaeurekaselec_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=13) 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.95msalphaeurekaselec_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` = '100221'
      2.13msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 100221
      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` = '100221'
      3.58msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 100221
      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` = '100221' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.86msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 100221
      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
      370μ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
      750μ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 = 13 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      61.17msalphaeurekaselec_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 = 13 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      18.87msalphaeurekaselec_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 = 13 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      16.64msalphaeurekaselec_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` = 100221 limit 1
      340μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 100221
      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 = 100221 and content_type = 'article' order by status desc limit 1
      490μ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 a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 295 and cd.sub_disease_id = 605 and content_id!=100221 and cd.content_type = 'article' order by rand() limit 20
      141msalphaeurekaselec_live_10_06_2022Article.php#769
      Backtrace
      • 11. app/Models/Article.php:769
      • 12. app/Http/Controllers/ArticleController.php:2098
      • 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` = 174199 limit 1
      360μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 174199
      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
      330μ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` = 'CDT' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      430μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CDT
      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 = '100221' 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) )
      8.68msalphaeurekaselec_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 = '9394' 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) )
      500μ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 = '2521' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      440μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2231
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459141 and j.to_date >= 1740459141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2521) 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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459141 and j.to_date >= 1740459141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2521) 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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459141 and j.to_date >= 1740459141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2521)
      3.74msalphaeurekaselec_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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459141 and j.to_date >= 1740459141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9394) 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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459141 and j.to_date >= 1740459141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9394) 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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459141 and j.to_date >= 1740459141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9394)
      1.36msalphaeurekaselec_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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459141 and j.to_date >= 1740459141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100221) 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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459141 and j.to_date >= 1740459141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100221) 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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459141 and j.to_date >= 1740459141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100221)
      840μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2329
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `article` where `first_page` < '1670' and is_uploaded = 1 and issue_id = 9394 order by cast(first_page as SIGNED) desc limit 1
      710μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 1670
      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` > '1679' and is_uploaded = 1 and issue_id = 9394 order by cast(first_page as SIGNED) asc limit 1
      620μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 1679
      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` = 'cn'
      7.65msalphaeurekaselec_live_10_06_2022ArticleController.php#2486
      Bindings
      • 0: cn
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2486
      • 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` = 2
      490μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 2
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2487
      • 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 `multilanguage_article` where (`language_id` = 2 and `article_id` = 100221)
      10.28msalphaeurekaselec_live_10_06_2022ArticleController.php#2488
      Bindings
      • 0: 2
      • 1: 100221
      Backtrace
      • 15. app/Http/Controllers/ArticleController.php:2488
      • 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
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `keyword` from `multilanguage_keywords` where (`language_id` = 2 and `article_id` = 100221)
      12.66msalphaeurekaselec_live_10_06_2022ArticleController.php#2489
      Bindings
      • 0: 2
      • 1: 100221
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2489
      • 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 CONCAT_WS(' ',au.first_name, ' ', ifnull(au.initials,''), ' ', au.last_name) as authors, CONCAT_WS(' ',au.last_name, ', ', ifnull(au.initials,''), ' ', au.first_name) as authorsRIS, CONCAT_WS(' ',au.last_name, ' ', ifnull(au.initials,''), ' ', au.first_name) as authorsCiteAs , `au`.*, (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 `multilanguage_authors` as `au` left join `multilanguage_author_affiliation` as `af` on `au`.`id` = `af`.`author_id` where `au`.`article_id` = 100221 group by `au`.`id` order by `au`.`article_id` asc, `au`.`sequence` asc
      7.57msalphaeurekaselec_live_10_06_2022MultiLangAuthor.php#30
      Bindings
      • 0: 100221
      Backtrace
      • 13. app/Models/MultiLangAuthor.php:30
      • 14. app/Http/Controllers/ArticleController.php:2493
      • 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 `multilanguage_journal`.`title` from `multilanguage_journal` where `multilanguage_journal`.`journal_id` = 13 and `language_id` = 2
      380μsalphaeurekaselec_live_10_06_2022ArticleController.php#2495
      Bindings
      • 0: 13
      • 1: 2
      Backtrace
      • 13. app/Http/Controllers/ArticleController.php:2495
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `id` from `multilanguage_article` where `article_id` = 100221 limit 1
      7.6msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 100221
      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` = 13 and `b`.`banner_from_date` <= 1740459141 and `b`.`banner_to_date` >= 1740459141 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.62msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 13
      • 3: 1740459141
      • 4: 1740459141
      • 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` = 13 and `b`.`banner_from_date` <= 1740459141 and `b`.`banner_to_date` >= 1740459141 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      3.42msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 13
      • 3: 1740459141
      • 4: 1740459141
      • 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='12badccd70cbef338ddb3294e21a2e3d'
      320μ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\MultiLangArticle
    2MultiLangArticle.php#?
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        UpZmz5uOdU1UsUrrUdaQryGSp1Jr3FXNbBNBWJVR
        uc_cart_id
        12badccd70cbef338ddb3294e21a2e3d
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/100221/cn" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/100221/cn
        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=eyJpdiI6ImlCTkNpdDN1NVRTSmwwd2t5T29abnc9PSIsInZhbHVlIjoiTUFhUTlwSUhhL0VuaFY5TVBFbWRvYWJqdDRtSGJoWWZ3eTcxS3diVXdFST0iLCJtYWMiOiI1NDU0Nzc4ODk0NjZlMDg0N2U1MmRmMjRjNzg0YjU2OTM0ZjM2Y2FhOTViZGRlZjI3NDk1YzVkZjY1ZGVkNGFkIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6ImlCTkNpdDN1NVRTSmwwd2t5T29abnc9PSIsInZhbHVlIjoiTUFhUTlwSUhhL0VuaFY5TVBFbWRvYWJqdDRtSGJoWWZ3eTcxS3diVXdFST0iLCJtYWMiOiI1NDU0Nzc4ODk0NjZl" ] "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:52:21 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImpJQ1lHR0pOcDZSV2lMT1V4eEllQXc9PSIsInZhbHVlIjoiK0J6WlI0Mzl6WERmeDF2MHFrREdxQkg2a0p5NG9WayswVUhpQVRUbUZPUlRoTjVFUVExVWNMeStJZHdUdVhxK3R6ck5FRWtMWmJxd3ZMdjJKNVF2dXRNeUIxaEFxcEI4aHVHbm9zTmV0VFhRNzdxbXhoSVZjcUc1ZWszUklrUHQiLCJtYWMiOiIxYzk3ZjZlMzhhNTY0NWEwYmE1OTcyZjE0MDQzMjY4Y2YyNDA0MTJkNzg3NDdlZThkMDljZTM5OWZiZWQxOTU1IiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 16:52:21 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImpJQ1lHR0pOcDZSV2lMT1V4eEllQXc9PSIsInZhbHVlIjoiK0J6WlI0Mzl6WERmeDF2MHFrREdxQkg2a0p5NG9WayswVUhpQVRUbUZPUlRoTjVFUVExVWNMeStJZHdUdVhxK3R6ck5FR" 1 => "alphaeurekaselectnet_session=eyJpdiI6InlKeUpCWTdqaEpDTHhaMnNHL0NmeHc9PSIsInZhbHVlIjoiaUd6RHVLa3R4Mmdkc0VhQTlmdzVKVUVhWTQ5ZWdHTngrb2pUeGhzUTBWSTNHMDZvVVJjNjFMR0YzaUU5ZnJDZUoveG00S1dLMVpjSWpPSFRNaHRsV09BY0NrdUdYbGcrOEdtbDJKNnh6Z2FkVlNUMk1NZ0YzdDViWHZMcGJjWGkiLCJtYWMiOiJmMjg3OGQxODYwNDg3N2ZlYTQ4N2JlNjJkMjVlNTBlNTVkMWYyZDIyMDRiZDU3NjhkMzkyZDNmYTk5MDFmMzMxIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6InlKeUpCWTdqaEpDTHhaMnNHL0NmeHc9PSIsInZhbHVlIjoiaUd6RHVLa3R4Mmdkc0VhQTlmdzVKVUVhWTQ5ZWdHTngrb2pUeGhzUTBWSTNHMDZvVVJjNjFMR0Y" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImpJQ1lHR0pOcDZSV2lMT1V4eEllQXc9PSIsInZhbHVlIjoiK0J6WlI0Mzl6WERmeDF2MHFrREdxQkg2a0p5NG9WayswVUhpQVRUbUZPUlRoTjVFUVExVWNMeStJZHdUdVhxK3R6ck5FRWtMWmJxd3ZMdjJKNVF2dXRNeUIxaEFxcEI4aHVHbm9zTmV0VFhRNzdxbXhoSVZjcUc1ZWszUklrUHQiLCJtYWMiOiIxYzk3ZjZlMzhhNTY0NWEwYmE1OTcyZjE0MDQzMjY4Y2YyNDA0MTJkNzg3NDdlZThkMDljZTM5OWZiZWQxOTU1IiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 16:52:21 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImpJQ1lHR0pOcDZSV2lMT1V4eEllQXc9PSIsInZhbHVlIjoiK0J6WlI0Mzl6WERmeDF2MHFrREdxQkg2a0p5NG9WayswVUhpQVRUbUZPUlRoTjVFUVExVWNMeStJZHdUdVhxK3R6ck5FR" 1 => "alphaeurekaselectnet_session=eyJpdiI6InlKeUpCWTdqaEpDTHhaMnNHL0NmeHc9PSIsInZhbHVlIjoiaUd6RHVLa3R4Mmdkc0VhQTlmdzVKVUVhWTQ5ZWdHTngrb2pUeGhzUTBWSTNHMDZvVVJjNjFMR0YzaUU5ZnJDZUoveG00S1dLMVpjSWpPSFRNaHRsV09BY0NrdUdYbGcrOEdtbDJKNnh6Z2FkVlNUMk1NZ0YzdDViWHZMcGJjWGkiLCJtYWMiOiJmMjg3OGQxODYwNDg3N2ZlYTQ4N2JlNjJkMjVlNTBlNTVkMWYyZDIyMDRiZDU3NjhkMzkyZDNmYTk5MDFmMzMxIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6InlKeUpCWTdqaEpDTHhaMnNHL0NmeHc9PSIsInZhbHVlIjoiaUd6RHVLa3R4Mmdkc0VhQTlmdzVKVUVhWTQ5ZWdHTngrb2pUeGhzUTBWSTNHMDZvVVJjNjFMR0Y" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "UpZmz5uOdU1UsUrrUdaQryGSp1Jr3FXNbBNBWJVR" "uc_cart_id" => "12badccd70cbef338ddb3294e21a2e3d" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/100221/cn" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 04:52:21GET/article/100221/cn314413