Generic placeholder image

Current Cardiology Reviews

Editor-in-Chief

ISSN (Print): 1573-403X
ISSN (Online): 1875-6557

A Practical Guide for the Treatment of Symptomatic Heart Failure with Reduced Ejection Fraction (HFrEF)

Author(s): Brent N. Reed and Carla A. Sueta

Volume 11, Issue 1, 2015

Page: [23 - 32] Pages: 10

DOI: 10.2174/1574884708666131117125508

Price: $65

Abstract

This review will outline the management of patients with symptomatic systolic heart failure or heart failure with reduced ejection fraction (HFrEF), i.e., those with structural heart disease and previous or current symptoms. Determination of volume status and appropriate diuretic administration is important in heart failure management. Inhibition of the renin-angiotensin-aldosterone and sympathetic nervous systems improves survival and decreases hospitalizations in patients with systolic or reduced ejection fraction HF (HFrEF). Beta blockers and aldosterone antagonists improve ejection fraction. Indications for additional agents including nitrates plus hydralazine, digoxin, statins, omega 3 polyunsaturated fatty acids, anticoagulants, and antiarrhythmics will be discussed. Choice of agents, dose-related effects, strategies to minimize adverse effects, and medications to avoid will be presented.

Keywords: ACE inhibitor, aldosterone antagonist, angiotensin receptor blocker, beta blocker, heart failure with reduced ejection fraction, systolic heart failure.

Graphical Abstract

[1]
The CONSENSUS Trial Study Group Effects of enalapril on mortality in severe congestive heart failure. Results of the Cooperative North Scandinavian Enalapril Survival Study (CONSENSUS). N Engl J Med 1987; 316: 1429-35.
[2]
The SOLVD Investigators Effect of enalapril on survival in patients with reduced left ventricular ejection fractions and congestive heart failure. N Engl J Med 1991; 325: 293-302.
[3]
Effect of ramipril on mortality and morbidity of survivors of acute myocardial infarction with clinical evidence of heart failure. The Acute Infarction Ramipril Efficacy (AIRE). Study Investigators Lancet 1993; 342: 821-8.
[4]
Pitt B, Poole-Wilson PA, Segal R, et al. Effect of losartan compared with captopril on mortality in patients with symptomatic heart failure: randomised trial - the Losartan Heart Failure Survival Study, ELITE II. Lancet 2000; 355: 1582-7.
[5]
Granger CB, McMurray JJ, Yusuf S, et al. Effects of candesartan in patients with chronic heart failure and reduced left-ventricular systolic function intolerant to angiotensin-converting-enzyme inhibitors: the CHARM-Alternative trial. Lancet 2003; 362: 772-6.
[6]
Heran BS, Musini VM, Bassett K, et al. Angiotensin receptor blockers for heart failure. Cochrane Database Syst Rev 2012; 4CD003040
[7]
Dickstein K, Kjekshus J. OPTIMAAL Steering Committee of the OPTIMAAL Study Group Effects of losartan and captopril on mortality and morbidity in high-risk patients after acute myocardial infarction: the OPTIMAAL randomised trial. Optimal Trial in Myocardial Infarction with Angiotensin II Antagonist Losartan. Lancet 2002; 360: 752-60.
[8]
Pfeffer MA, McMurray JJ, Velazquez EJ, et al. Valsartan, captopril, or both in myocardial infarction complicated by heart failure, left ventricular dysfunction, or both. N Engl J Med 2003; 349: 1893-906.
[9]
Cohn JN, Tognoni G. Valsartan Heart Failure Trial Investigators A randomized trial of the angiotensin-receptor blocker valsartan in chronic heart failure. N Engl J Med 2001; 345: 1667-75.
[10]
McMurray JJ, Ostergren J, Swedberg K, et al. Effects of candesartan in patients with chronic heart failure and reduced left-ventricular systolic function taking angiotensin-converting-enzyme inhibitors: the CHARM-Added trial. Lancet 2003; 362: 767-71.
[11]
Packer M, Poole-Wilson PA, Armstrong PW, et al. Comparative effects of low and high doses of the angiotensin-converting enzyme inhibitor, lisinopril, on morbidity and mortality in chronic heart failure. ATLAS Study Group. Circulation 1999; 100: 2312-8.
[12]
Konstam MA, Neaton JD, Dickstein K, et al. Effects of high-dose versus low-dose losartan on clinical outcomes in patients with heart failure (HEAAL study): a randomised, double-blind trial. Lancet 2009; 374: 1840-8.
[13]
Packer M, Bristow MR, Cohn JN, et al. The effect of carvedilol on morbidity and mortality in patients with chronic heart failure. N Engl J Med 1996; 334: 1349-55.
[14]
Metoprolol CR/XL Randomised Intervention Trial in Congestive Heart Failure (MERIT-HF) Study Group Effect of metoprolol CR/XL in chronic heart failure. Lancet 1999; 353: 2001-7.
[15]
Hjalmarson A, Goldstein S, Fagerberg B, et al. Effects of controlled-release metoprolol on total mortality, hospitalizations, and well-being in patients with heart failure: the Metoprolol CR/XL Randomized Intervention Trial in congestive heart failure (MERIT-HF). JAMA 2000; 283: 1295-302.
[16]
CIBIS II The Cardiac Insufficiency Bisoprolol Study II (CIBIS-II) a randomised trial. Lancet 1999; 353: 9-13.
[17]
Packer M, Coats AJ, Fowler MB, et al. Effect of carvedilol on survival in severe chronic heart failure. N Engl J Med 2001; 344: 1651-8.
[18]
Fowler MB, Vera-Llonch M, Oster G, et al. Influence of carvedilol on hospitalizations in heart failure: incidence, resource utilization and costs. U.S. Carvedilol Heart Failure Study Group. J Am Coll Cardiol 2001; 37: 1692-9.
[19]
Bristow MR, Gilbert EM, Abraham WT, et al. Carvedilol produces dose-related improvements in left ventricular function and survival in subjects with chronic heart failure. MOCHA Investigators. Circulation 1996; 94: 2807-16.
[20]
Metra M, Nodari S, Parrinello G, et al. Marked improvement in left ventricular ejection fraction during long-term β-blockade in patients with chronic heart failure: Clinical correlates and prognostic significance. Am Heart J 2003; 145: 292-9.
[21]
Chattergee S, Biondi-Zoccai G, Abbate A, et al. Benefits of β blockers in patients with heart failure and reduced ejection fraction: network meta-analysis. Br Med J 2013; 346: f55.
[22]
Dargie HJ. Effect of carvedilol on outcome after myocardial infarction in patients with left-ventricular dysfunction: the CAPRICORN randomised trial. Lancet 2001; 357: 1385-90.
[23]
Gattis WA, O’Connor CM, Gallup DS, et al. Predischarge initiation of carvedilol in patients hospitalized for decompensated heart failure: results of the Initiation Management Predischarge: Process for Assessment of Carvedilol Therapy in Heart Failure (IMPACT-HF) trial. J Am Coll Cardiol 2004; 43: 1534-41.
[24]
Fonarow GC, Abraham WT, Albert NM, et al. Influence of beta-blocker continuation or withdrawal on outcomes in patients hospitalized with heart failure: findings from the OPTIMIZE-HF program. J Am Coll Cardiol 2008; 52: 190-9.
[25]
Lindenfeld J, Albert NM, Boehmer JP, et al. Executive summary: HFSA 2010 comprehensive heart failure practice guideline. J Card Fail 2010; 16: 475-539.
[26]
McMurray JJ, Adamopoulos S, Anker SD, et al. ESC guidelines for the diagnosis and treatment of acute and chronic heart failure 2012: the Task Force for the Diagnosis and Treatment of Acute and Chronic Heart Failure 2012 of the European Society of Cardiology developed in collaboration with the Heart Failure Association (HFA) of the ESC. Eur Heart J 2012; 33: 1787-847.
[27]
Yancy CW, Jessup M, Bozkurt B, et al. 2013 ACC/AHA guideline for the management of heart failure: a report of the American College of Cardiology Foundation/American Heart Association Task Force on Practice Guidelines. J Am Coll Cardiol 2013; 62: e147-239.
[28]
Wikstrand J, Hjalmarson A, Waagstein F, et al. Dose of metoprolol CR/XL and clinical outcomes in patients with heart failure: analysis of the experience in metoprolol CR/XL randomized intervention trial in chronic heart failure (MERIT-HF). J Am Coll Cardiol 2002; 40: 491-8.
[29]
Simon T, Mary-Krause M, Funck-Brentano C. on behalf of CIBIS II investigators. Bisoprolol dose–response relationship in patients with congestive heart failure: a subgroup analysis in the cardiac insufficiency bisoprolol study (CIBIS II). Eur Heart J 2003; 24: 552-9.
[30]
McAlister FA. Meta-analysis: β-Blocker Dose. Heart Rate Reduction, and Death in Patients With Heart Failure Ann Intern Med 2009; 150: 784-94.
[31]
Eichorn EJ, Bristow MR. Medical therapy can improve the biological properties of the chronically failing heart. Circulation 1996; 94: 2285-96.
[32]
Pitt B, Zannad F, Remme WJ, et al. for the Randomized Aldactone Evaluation Study Investigators The effect of spironolactone on morbidity and mortality in patients with severe heart failure. N Engl J Med 1999; 341: 709-17.
[33]
Zannad F, McMurray JJ, Krum H, et al. Eplerenone in patients with systolic heart failure and mild symptoms. N Engl J Med 2011; 364: 11-21.
[34]
Rogers JK, McMurray JJV, Pocock SJ, et al. Eplerenone in patients with systolic heart failure and mild symptoms. Analysis of Repeat Hospitalizations. Circulation 2012; 126: 2317-23.
[35]
Pitt B, Remme W, Zannad F, et al. Eplerenone, a selective aldosterone blocker, in patients with left ventricular dysfunction after myocardial infarction. N Engl J Med 2003; 348: 1309-21.
[36]
Phelan D, Thavendiranathan P, Collier P, et al. Aldosterone antagonists improve ejection fraction and functional capacity independently of functional class: a meta-analysis of randomised controlled trials. Heart 2012; 98: 1693-700.
[37]
Taylor AL, Ziesche S, Yancy C, et al. African-American Heart Failure Trial, I. Combination of isosorbide dinitrate and hydralazine in blacks with heart failure. N Engl J Med 2004; 351: 2049-57.
[38]
The Digitalis Investigation Group The effect of digoxin on mortality and morbidity in patients with heart failure. N Engl J Med 1997; 336: 525-33.
[39]
Adams KF Jr, Patterson JH, Gattis WA, et al. Relationship of serum digoxin concentration to mortality and morbidity in women in the digitalis investigation group trial: a retrospective analysis. J Am Coll Cardiol 2005; 46: 497-504.
[40]
GISSI-HF Investigators Tavazzi L, Maggioni AP, et al. Effect of n-3 polyunsaturated fatty acids in patients with chronic heart failure (the GISSI-HF trial): a randomised, double-blind, placebo-controlled trial. Lancet 2008; 372: 1223-30.
[41]
Ghio S, Scelsi L, Latini R, et al. Effects of n-3 polyunsaturated fatty acids and of rosuvastatin on left ventricular function in chronic heart failure: a substudy of GISSI-HF trial. Eur J Heart Fail 2010; 12: 1345-53.
[42]
Nodari S, Triggiani M, Campia U, et al. Effects of n-3 polyunsaturated fatty acids (PUFAs) on left ventricular function and functional capacity in patients with dilated cardiomyopathy. J Am Coll Cardiol 2011; 57: 870-9.
[43]
Doval HC, Nul DR, Grancelli HO, Perrone SV, Bortman GR, Curiel R. Randomised trial of low-dose amiodarone in severe congestive heart failure. Grupo de Estudio de la Sobrevida en la Insuficiencia Cardiaca en Argentina (GESICA). Lancet 1994; 344: 493-8.
[44]
Singh SN, Fletcher RD, Fisher SG, et al. Amiodarone in patients with congestive heart failure and asymptomatic ventricular arrhythmia. Survival Trial of Antiarrhythmic Therapy in Congestive Heart Failure. N Engl J Med 1995; 333: 77-82.
[45]
Moss AJ, Hall WJ, Cannom DS, et al. Improved Survival with an Implanted Defibrillator in Patients with Coronary Disease at High Risk for Ventricular Arrhythmia. N Engl J Med 1996; 335: 1933-40.
[46]
Møller M, Torp-Pedersen CT, Køber L. Dofetilide in patients with congestive heart failure and left ventricular dysfunction: safety aspects and effect on atrial fibrillation. The Danish Investigators of Arrhythmia and Mortality on Dofetilide (DIAMOND) Study Group. Congest Heart Fail 2001; 7: 146-50.
[47]
Granger CB, Alexander JH, McMurray JJV, et al. Apixaban versus Warfarin in Patients with Atrial Fibrillation. N Engl J Med 2011; 365: 981-92.
[48]
Connolly SJ, Ezekowitz MD, Yusuf S, et al. Dabigatran versus Warfarin in Patients with Atrial Fibrillation. N Engl J Med 2009; 361: 1139-51.
[49]
Patel MR, Mahaffey KW, Garg J, et al. Rivaroxaban versus warfarin in nonvalvular atrial fibrillation. N Engl J Med 2011; 365: 883-91.
[50]
Massie BM, Collins JF, Ammon SE, et al. Randomized trial of warfarin, aspirin, and clopidogrel in patients with chronic heart failure. The Warfarin and Antiplatelet Therapy in Chronic Heart Failure (WATCH) Trial. Circulation 2009; 119: 1616-24.
[51]
Homma S, Thompson JLP, Pullicino PM, et al. Warfarin and Aspirin in Patients with Heart Failure and Sinus Rhythm. N Engl J Med 2012; 366: 1859-69.
[52]
Packer M, O’Connor CM, Ghali JK, et al. Effect of Amlodipine on Morbidity and Mortality in Severe Chronic Heart Failure. N Engl J Med 1996; 335: 1107-14.
[53]
Cohn JN, Ziesche S, Smith R, et al. Effect of the calcium antagonist felodipine as supplementary vasodilator therapy in patients with chronic heart failure treated with enalapril: V-HeFT III. Vasodilator-Heart Failure Trial (V-HeFT) Study Group. Circulation 1997; 96: 856-63.
[54]
Køber L, Torp-Pedersen C, McMurray JJV, et al. Increased mortality after dronedarone therapy for severe heart failure. N Engl J Med 2008; 358: 2678-87.
[55]
Connolly SJ, Camm AJ, Halperin JL, et al. Dronedarone in high-risk permanent atrial fibrillation. N Engl J Med 2011; 365: 2268-76.
[56]
O’Connor CM, Whellan DJ, Lee KL, et al. Efficacy and Safety of Exercise Training in Patients With Chronic Heart Failure: HF-ACTION Randomized Controlled Trial. JAMA 2009; 301: 1439-50.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version299msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[23:23:20] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[23:23:20] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[23:23:20] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (101ms)time
  • Application (198ms)time
  • 1 x Application (66.34%)
    198ms
    1 x Booting (33.66%)
    101ms
    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
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated126ms
    • 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 ('51718564','',1,1739834600,1739834600) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739834600
      1.03msalphaeurekaselec_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 ('51718564','/article/57440',1,1739834600,1739834600)
      140μ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 >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) 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 >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) 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 >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) 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 >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) 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 >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) 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 >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51718564 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51718564) limit 1
      13.05msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51718564
      • 1: 51718564
      • 2: 51718564
      • 3: 51718564
      • 4: 51718564
      • 5: 51718564
      • 6: 51718564
      • 7: 51718564
      • 8: 51718564
      • 9: 51718564
      • 10: 51718564
      • 11: 51718564
      • 12: 51718564
      • 13: 51718564
      • 14: 51718564
      • 15: 51718564
      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=57440
      750μsalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 16 limit 1
      800μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 16
      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=16) and sj.journal_id!=16 group by `j`.`nid`) as `aggregate_table`
      560μsalphaeurekaselec_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=16) and sj.journal_id!=16 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      430μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=16) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      790μsalphaeurekaselec_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=16) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      700μsalphaeurekaselec_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` = '57440'
      270μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 57440
      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` = '57440'
      1.66msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 57440
      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` = '57440' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.98msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 57440
      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
      210μ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
      460μ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 = 16 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      24.77msalphaeurekaselec_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 = 16 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.4msalphaeurekaselec_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 = 16 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      4.8msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2071
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select pdf, html, epub, prc from `article_metrics` where `article_id` = 57440 limit 1
      220μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 57440
      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 = 57440 and content_type = 'article' order by status desc limit 1
      2.89msalphaeurekaselec_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 = 258 and cd.sub_disease_id = 357 and content_id!=57440 and cd.content_type = 'article' order by rand() limit 20
      51.51msalphaeurekaselec_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` = 118003 limit 1
      270μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 118003
      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
      210μ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` = 'CCR' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      250μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CCR
      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 = '57440' 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) )
      330μ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 = '6009' 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) )
      290μ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 = '1546' 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) )
      250μ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 <= 51718564 and j.to_ip >=51718564 )) and ((j.from_date <= 1739834600 and j.to_date >= 1739834600 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1546) 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 <= 51718564 and j.to_ip >=51718564 )) and ((j.from_date <= 1739834600 and j.to_date >= 1739834600 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1546) 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 <= 51718564 and j.to_ip >=51718564 )) and ((j.from_date <= 1739834600 and j.to_date >= 1739834600 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1546)
      5.36msalphaeurekaselec_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 <= 51718564 and j.to_ip >=51718564 )) and ((j.from_date <= 1739834600 and j.to_date >= 1739834600 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6009) 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 <= 51718564 and j.to_ip >=51718564 )) and ((j.from_date <= 1739834600 and j.to_date >= 1739834600 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6009) 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 <= 51718564 and j.to_ip >=51718564 )) and ((j.from_date <= 1739834600 and j.to_date >= 1739834600 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6009)
      560μ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 <= 51718564 and j.to_ip >=51718564 )) and ((j.from_date <= 1739834600 and j.to_date >= 1739834600 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 57440) 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 <= 51718564 and j.to_ip >=51718564 )) and ((j.from_date <= 1739834600 and j.to_date >= 1739834600 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 57440) 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 <= 51718564 and j.to_ip >=51718564 )) and ((j.from_date <= 1739834600 and j.to_date >= 1739834600 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 57440)
      540μ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` < '23' and is_uploaded = 1 and issue_id = 6009 order by cast(first_page as SIGNED) desc limit 1
      480μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 23
      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` > '32' and is_uploaded = 1 and issue_id = 6009 order by cast(first_page as SIGNED) asc limit 1
      390μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 32
      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'
      150μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      170μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 57440 limit 1
      2.36msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 57440
      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` = 16 and `b`.`banner_from_date` <= 1739834600 and `b`.`banner_to_date` >= 1739834600 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.1msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 16
      • 3: 1739834600
      • 4: 1739834600
      • 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` = 16 and `b`.`banner_from_date` <= 1739834600 and `b`.`banner_to_date` >= 1739834600 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.05msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 16
      • 3: 1739834600
      • 4: 1739834600
      • 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='dc02d8d543e8e8862ff90eb3021d97a2'
      190μ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
        Duf4ayfAAjQF8V01SceafwE5J60ssFnCb4iPldqy
        uc_cart_id
        dc02d8d543e8e8862ff90eb3021d97a2
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/57440" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/57440
        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=eyJpdiI6ImdKb2dYL2F1QThIQ00zUmpOb1diaXc9PSIsInZhbHVlIjoiUWl3QVZZVzBNTjdjVE54UEtoWElUaTE2bHpLSGd1NFRuMnZiNkNXTnpaYz0iLCJtYWMiOiI2NWQyYWJiM2U0OWM0YTNlYTJmMWYyZmJmYTRlYjIxMjY3MTJkZDFkNTc0OTBkYWI1M2I0OGJlZjI5ZmNkMTE4IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6ImdKb2dYL2F1QThIQ00zUmpOb1diaXc9PSIsInZhbHVlIjoiUWl3QVZZVzBNTjdjVE54UEtoWElUaTE2bHpLSGd1NFRuMnZiNkNXTnpaYz0iLCJtYWMiOiI2NWQyYWJiM2U0OWM0" ] "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 => "Mon, 17 Feb 2025 23:23:20 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IndORnpINWpCa0lwRURkVndZb0pUOVE9PSIsInZhbHVlIjoib2htcytXN25nSmpRNklINFBhK3VNNW9jYzdER1NNSG53RDJMODFSMHBtWjZab1ppMVEyTEJMRll0RmxqK1dPYTMxcDZvK2REd1BBRWNaKzFyM0UxK05RUkpvUUVEZno4ZnA5dHB3SE5hQzZGUUxlTTdLcWdOTjBHZ0ZZRHBRZUkiLCJtYWMiOiJmZGZhMTY1ODQ5ZTdiN2EzNDdhZDY3YTYzNTQ4MjI0ZGM4Y2IwYjZjNGE5MzQxY2NiODBlZWI1ZDY2MDg3YzQ2IiwidGFnIjoiIn0%3D; expires=Thu, 20 Feb 2025 11:23:20 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IndORnpINWpCa0lwRURkVndZb0pUOVE9PSIsInZhbHVlIjoib2htcytXN25nSmpRNklINFBhK3VNNW9jYzdER1NNSG53RDJMODFSMHBtWjZab1ppMVEyTEJMRll0RmxqK1dPYTMxcDZvK" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkJhT1pHNmtSNlBsYTZ5QVY4NVZqOXc9PSIsInZhbHVlIjoiWHU1SzdZTEgxdVZ4bEdGdnlpZFdFMjBWQ2RMUGRUU29jTlFUR0liWm5RMy91SWRDRTgySnBVTGxPWENleUJlVThjSEVhT3U3ZkZ0aG05eHZOL3pYQzk0anRzUW1acTg2NXE0UnpFa0lsNWwrYmNxaUVtWllDaWJORks2bGwzelkiLCJtYWMiOiIxMDM3MTg1YWVjMjZlZWI4NjQ2OGEyZTIxMDk1OGUzZDQ2MTBkOWI5YmEwMDZhMjQyZWEyNGI0OWY0NjRjMGZkIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkJhT1pHNmtSNlBsYTZ5QVY4NVZqOXc9PSIsInZhbHVlIjoiWHU1SzdZTEgxdVZ4bEdGdnlpZFdFMjBWQ2RMUGRUU29jTlFUR0liWm5RMy91SWRDRTgySnBVTGx" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IndORnpINWpCa0lwRURkVndZb0pUOVE9PSIsInZhbHVlIjoib2htcytXN25nSmpRNklINFBhK3VNNW9jYzdER1NNSG53RDJMODFSMHBtWjZab1ppMVEyTEJMRll0RmxqK1dPYTMxcDZvK2REd1BBRWNaKzFyM0UxK05RUkpvUUVEZno4ZnA5dHB3SE5hQzZGUUxlTTdLcWdOTjBHZ0ZZRHBRZUkiLCJtYWMiOiJmZGZhMTY1ODQ5ZTdiN2EzNDdhZDY3YTYzNTQ4MjI0ZGM4Y2IwYjZjNGE5MzQxY2NiODBlZWI1ZDY2MDg3YzQ2IiwidGFnIjoiIn0%3D; expires=Thu, 20-Feb-2025 11:23:20 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IndORnpINWpCa0lwRURkVndZb0pUOVE9PSIsInZhbHVlIjoib2htcytXN25nSmpRNklINFBhK3VNNW9jYzdER1NNSG53RDJMODFSMHBtWjZab1ppMVEyTEJMRll0RmxqK1dPYTMxcDZvK" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkJhT1pHNmtSNlBsYTZ5QVY4NVZqOXc9PSIsInZhbHVlIjoiWHU1SzdZTEgxdVZ4bEdGdnlpZFdFMjBWQ2RMUGRUU29jTlFUR0liWm5RMy91SWRDRTgySnBVTGxPWENleUJlVThjSEVhT3U3ZkZ0aG05eHZOL3pYQzk0anRzUW1acTg2NXE0UnpFa0lsNWwrYmNxaUVtWllDaWJORks2bGwzelkiLCJtYWMiOiIxMDM3MTg1YWVjMjZlZWI4NjQ2OGEyZTIxMDk1OGUzZDQ2MTBkOWI5YmEwMDZhMjQyZWEyNGI0OWY0NjRjMGZkIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkJhT1pHNmtSNlBsYTZ5QVY4NVZqOXc9PSIsInZhbHVlIjoiWHU1SzdZTEgxdVZ4bEdGdnlpZFdFMjBWQ2RMUGRUU29jTlFUR0liWm5RMy91SWRDRTgySnBVTGx" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "Duf4ayfAAjQF8V01SceafwE5J60ssFnCb4iPldqy" "uc_cart_id" => "dc02d8d543e8e8862ff90eb3021d97a2" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/57440" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-17 23:23:20GET/article/57440314371