Generic placeholder image

Current Respiratory Medicine Reviews

Editor-in-Chief

ISSN (Print): 1573-398X
ISSN (Online): 1875-6387

Review Article

Clinical Approaches to Minimize Readmissions of Patients with COPD: A Narrative Review

Author(s): Sy Duong-Quy*, Thu Vo-Pham-Minh, Van Duong-Thi-Thanh, Timothy Craig and Vinh Nguyen-Nhu

Volume 19, Issue 1, 2023

Published on: 03 October, 2022

Page: [12 - 23] Pages: 12

DOI: 10.2174/1573398X18666220903121800

open access plus

Abstract

Chronic Obstructive Pulmonary Disease (COPD) is a progressive disease and also a leading cause of morbidity and mortality worldwide. The frequent readmissions of patients with COPD may reduce lung function, mental health, and quality of life; it also increases the cost of treatment and mortality rate. Some common factors that may increase the readmission frequency of COPD patients include delay of diagnosis, advanced lung function decline, lack of adherence for COPD treatment, ineffective management of comorbidities, acute exacerbation or stable COPD, and infections. However, these factors might be well controlled with appropriate approaches to minimize the readmission of patients with COPD. In this review, we propose a strategy with a seven-step approach to reduce the readmission in COPD patients, including early diagnosis of COPD, optimal treatment for stable COPD, targeted management of comorbidities, adequate therapy for acute exacerbations, individualized action plans for COPD patients, effective prevention of bacterial and viral infections, and adaptive program of pulmonary rehabilitation. Thus, implementing this approach may reduce the risk of readmission in patients with COPD.

Keywords: COPD, readmission, acute exacerbation, comorbidities, action plan.

Graphical Abstract

[1]
World Health Organization. 2021. Available from: https://www.who.int/gard/news_events/World_Health_Statistics_2008/en/
[2]
Criner GJ, Bourbeau J, Diekemper RL, et al. Prevention of acute exacerbations of COPD: American College of Chest Physicians and Canadian Thoracic Society Guideline. Chest 2015; 147(4): 894-942.
[http://dx.doi.org/10.1378/chest.14-1676] [PMID: 25321320]
[3]
Global Initiative for Chronic Obstructive Lung Disease. Guidelines to COPD diagnosis, management and prevention. 2021. Available from: https://goldcopd.org/wp-content/uploads/2020/11/GOLD-REPORT-2021-v1.1-25Nov20_WMV.pdf
[4]
Jones RC, Price D, Ryan D, et al. Opportunities to diagnose chronic obstructive pulmonary disease in routine care in the UK: A retrospective study of a clinical cohort. Lancet Respir Med 2014; 2(4): 267-76.
[http://dx.doi.org/10.1016/S2213-2600(14)70008-6] [PMID: 24717623]
[5]
Lee J, Jung HM, Kim SK, et al. Factors associated with chronic obstructive pulmonary disease exacerbation, based on big data analysis. Sci Rep 2019; 9(1): 6679.
[http://dx.doi.org/10.1038/s41598-019-43167-w ] [PMID: 31040338]
[6]
Westerik JA, Metting EI, van Boven JF, Tiersma W, Kocks JW, Schermer TR. Associations between chronic comorbidity and exacerbation risk in primary care patients with COPD. Respir Res 2017; 18(1): 31.
[http://dx.doi.org/10.1186/s12931-017-0512-2] [PMID: 28166777]
[7]
Hurst JR, Donaldson GC, Quint JK, Goldring JJ, Baghai-Ravary R, Wedzicha JA. Temporal clustering of exacerbations in chronic obstructive pulmonary disease. Am J Respir Crit Care Med 2009; 179(5): 369-74.
[http://dx.doi.org/10.1164/rccm.200807-1067OC] [PMID: 19074596]
[8]
Tomioka R, Kawayama T, Suetomo M, et al. “Frequent exacerbator” is a phenotype of poor prognosis in Japanese patients with chronic obstructive pulmonary disease. Int J Chron Obstruct Pulmon Dis 2016; 11: 207-16.
[http://dx.doi.org/10.2147/COPD.S98205] [PMID: 26893552]
[9]
Rehman AU, Hassali MAA, Muhammad SA, et al. Economic burden of chronic obstructive pulmonary disease patients in Malaysia: A longitudinal study. Pharmacoecon Open 2021; 5(1): 35-44.
[http://dx.doi.org/10.1007/s41669-020-00214-x ] [PMID: 32291727]
[10]
Magovern M, Sawyer S. Different durations of corticosteroid therapy for COPD exacerbations. Am Fam Physician 2019; 99(5): 295-6.
[PMID: 30811167]
[11]
Stolz D, Barandun J, Borer H, et al. Diagnosis, prevention and treatment of stable COPD and acute exacerbations of COPD: The swiss recommendations 2018. Respiration 2018; 96(4): 382-98.
[http://dx.doi.org/10.1159/000490551] [PMID: 30138943]
[12]
Wedzicha JA, Calverley PMA, Albert RK, et al. Prevention of COPD exacerbations: A European Respiratory Society/American Thoracic Society guideline. Eur Respir J 2017; 50(3): 1-16.
[http://dx.doi.org/10.1183/13993003.02265-2016] [PMID: 28889106]
[13]
Mallia P, Johnston SL. Influenza infection and COPD. Int J Chron Obstruct Pulmon Dis 2007; 2(1): 55-64.
[http://dx.doi.org/10.2147/copd.2007.2.1.55] [PMID: 18044066]
[14]
Restrepo MI, Sibila O, Anzueto A. Pneumonia in patients with chronic obstructive pulmonary disease. Tuberc Respir Dis 2018; 81(3): 187-97.
[http://dx.doi.org/10.4046/trd.2018.0030] [PMID: 29962118]
[15]
Duong-Quy S, Dao P, Hua-Huy T, Guilluy C, Pacaud P, Dinh-Xuan AT. Increased Rho-kinase expression and activity and pulmonary endothelial dysfunction in smokers with normal lung function. Eur Respir J 2011; 37(2): 349-55.
[http://dx.doi.org/10.1183/09031936.00056610] [PMID: 20530044]
[16]
Bei Y, Duong-Quy S, Hua-Huy T, Dao P, Le-Dong NN, Dinh-Xuan AT. Activation of RhoA/Rho-kinase pathway accounts for pulmonary endothelial dysfunction in patients with chronic obstructive pulmonary disease. Physiol Rep 2013; 1(5): e00105.
[http://dx.doi.org/10.1002/phy2.105] [PMID: 24303177]
[17]
Di Marco F, Balbo P, de Blasio F, et al. Early management of COPD: Where are we now and where do we go from here? A Delphi consensus project. Int J Chron Obstruct Pulmon Dis 2019; 14: 353-60.
[http://dx.doi.org/10.2147/COPD.S176662] [PMID: 30787604]
[18]
Laucho-Contreras ME, Cohen-Todd M. Early diagnosis of COPD: Myth or a true perspective. Eur Respir Rev 2020; 29(158): 1-10.
[http://dx.doi.org/10.1183/16000617.0131-2020 ] [PMID: 33268437]
[19]
Savran O, Ulrik CS. Early life insults as determinants of chronic obstructive pulmonary disease in adult life. Int J Chron Obstruct Pulmon Dis 2018; 13: 683-93.
[http://dx.doi.org/10.2147/COPD.S153555 ] [PMID: 29520136]
[20]
Bhatt SP, Kim YI, Harrington KF, et al. Smoking duration alone provides stronger risk estimates of chronic obstructive pulmonary disease than pack-years. Thorax 2018; 73(5): 414-21.
[http://dx.doi.org/10.1136/thoraxjnl-2017-210722 ] [PMID: 29326298]
[21]
Hackshaw A, Morris JK, Boniface S, Tang JL. Milenković D. Low cigarette consumption and risk of coronary heart disease and stroke: Meta-analysis of 141 cohort studies in 55 study reports. BMJ 2018; 360: j5855.
[http://dx.doi.org/10.1136/bmj.j5855 ] [PMID: 29367388]
[22]
Inoue-Choi M, Liao LM, Reyes-Guzman C, et al. Association of long-term, low-intensity smoking with all-cause and cause-specific mortality in the national institutes of health-AARP diet and health study. JAMA Intern Med 2017; 177(1): 87-95.
[http://dx.doi.org/10.1001/jamainternmed.2016.7511] [PMID: 27918784]
[23]
Mathew AR, Bhatt SP, Colangelo LA, et al. Life-course smoking trajectories and risk for emphysema in middle age: The CARDIA lung study. Am J Respir Crit Care Med 2019; 199(2): 237-40.
[http://dx.doi.org/10.1164/rccm.201808-1568LE ] [PMID: 30215529]
[24]
Pleasants AR, Rivera PM, Tilley LS, et al. Both duration and pack-years of tobacco smoking should be used for clinical practice and research. Ann Am Thorac Soc 2020; 17(7): 804-6.
[http://dx.doi.org/10.1513/AnnalsATS.202002-133VP] [PMID: 32348693]
[25]
Global Initiative for Chronic Obstructive Lung Disease. Guidelines to COPD diagnosis, management and prevention Available from: https://goldcopd.org/2022-gold-reports-2/
[26]
Swanney MP, Ruppel G, Enright PL, et al. Using the lower limit of normal for the FEV1/FVC ratio reduces the misclassification of airway obstruction. Thorax 2008; 63(12): 1046-51.
[http://dx.doi.org/10.1136/thx.2008.098483 ] [PMID: 18786983]
[27]
Coxson HO, Rogers RM. Quantitative computed tomography of chronic obstructive pulmonary disease. Acad Radiol 2005; 12(11): 1457-63.
[http://dx.doi.org/10.1016/j.acra.2005.08.013 ] [PMID: 16253858]
[28]
Miniati M, Monti S, Stolk J, et al. Value of chest radiography in phenotyping chronic obstructive pulmonary disease. Eur Respir J 2008; 31(3): 509-15.
[http://dx.doi.org/10.1183/09031936.00095607 ] [PMID: 18057056]
[29]
Fazleen A, Wilkinson T. Early COPD: Current evidence for diagnosis and management. Ther Adv Respir Dis 2020; 14: 1753466620942128.
[http://dx.doi.org/10.1177/1753466620942128 ] [PMID: 32664818]
[30]
Thomas ET, Guppy M, Straus SE, Bell KJL, Glasziou P. Rate of normal lung function decline in ageing adults: A systematic review of prospective cohort studies. BMJ Open 2019; 9(6): e028150.
[http://dx.doi.org/10.1136/bmjopen-2018-028150 ] [PMID: 31248928]
[31]
Whittaker HR, Pimenta JM, Jarvis D, Kiddle SJ, Quint JK. Characteristics associated with accelerated lung function decline in a primary care population with chronic obstructive pulmonary disease. Int J Chron Obstruct Pulmon Dis 2020; 15: 3079-91.
[http://dx.doi.org/10.2147/COPD.S278981 ] [PMID: 33268984]
[32]
Oelsner CE, Balte PP, Yende S, et al. Lung function decline in former smokers and low-intensity current smokers: The NHLBI Pooled Cohorts Study. Lancet Respir Med 2020; 34-44.
[http://dx.doi.org/10.1016/S2213-2600(19)30276-0] [PMID: 31606435]
[33]
Rehman AU, Shah S, Abbas G, et al. Assessment of risk factors responsible for rapid deterioration of lung function over a period of one year in patients with chronic obstructive pulmonary disease. Sci Rep 2021; 11(1): 13578.
[http://dx.doi.org/10.1038/s41598-021-92968-5 ] [PMID: 34193949]
[34]
Cazzola M, Calzetta L, Barnes PJ, et al. Efficacy and safety profile of xanthines in COPD: A network meta-analysis. Eur Respir Rev 2018; 27(148): 1-12.
[http://dx.doi.org/10.1183/16000617.0010-2018 ] [PMID: 29720510]
[35]
Batterink J, Dahri K, Aulakh A, Rempel C. Evaluation of the use of inhaled medications by hospital inpatients with chronic obstructive pulmonary disease. Can J Hosp Pharm 2012; 65(2): 111-8.
[http://dx.doi.org/10.4212/cjhp.v65i2.1118 ] [PMID: 22529403]
[36]
Dougall S, Bolt J, Winkel T, et al. Inhaler assessment in COPD patients: A primer for pharmacists. Can Pharm J 2016; 149(5): 268-73.
[http://dx.doi.org/10.1177/1715163516660573 ] [PMID: 27708672]
[37]
Ghosh S, Ohar JA, Drummond MB. Peak inspiratory flow rate in chronic obstructive pulmonary disease: Implications for dry powder inhalers. J Aerosol Med Pulm Drug Deliv 2017; 30(6): 381-7.
[http://dx.doi.org/10.1089/jamp.2017.1416 ] [PMID: 28933581]
[38]
Chen SY, Huang CK, Peng HC, Yu CJ, Chien JY. Inappropriate peak inspiratory flow rate with dry powder inhaler in chronic obstructive pulmonary disease. Sci Rep 2020; 10(1): 7271.
[http://dx.doi.org/10.1038/s41598-020-64235-6 ] [PMID: 32350352]
[39]
Ambrosino N, Vagheggini G, Mazzoleni S, Vitacca M. Telemedicine in chronic obstructive pulmonary disease. Breathe 2016; 12(4): 350-6.
[http://dx.doi.org/10.1183/20734735.014616 ] [PMID: 28210321]
[40]
Janjua S, Carter D, Threapleton CJD, Prigmore S, Disler RT. Telehealth interventions: Remote monitoring and consultations for people with chronic obstructive pulmonary disease (COPD). Cochrane Database Syst Rev 2021; 7: CD013196.
[PMID: 34693988]
[41]
Donaldson GC, Seemungal TAR, Bhowmik A, Wedzicha JA. Relationship between exacerbation frequency and lung function decline in chronic obstructive pulmonary disease. Thorax 2002; 57(10): 847-52.
[http://dx.doi.org/10.1136/thorax.57.10.847 ] [PMID: 12324669]
[42]
Reilev M, Lykkegaard J, Halling A, Vestbo J, Søndergaard J, Pottegård A. Stability of the frequent COPD exacerbator in the general population: A Danish nationwide register-based study. NPJ Prim Care Respir Med 2017; 27(1): 25-7.
[http://dx.doi.org/10.1038/s41533-017-0029-7 ] [PMID: 28416794]
[43]
Calverley PMA, Tetzlaff K, Dusser D, et al. Determinants of exacerbation risk in patients with COPD in the TIOSPIR study. Int J Chron Obstruct Pulmon Dis 2017; 12: 3391-405.
[http://dx.doi.org/10.2147/COPD.S145814 ] [PMID: 29238184]
[44]
Fortis S, Wan ES, Kunisaki K, et al. Increased mortality associated with frequent exacerbations in COPD patients with mild-to-moderate lung function impairment, and smokers with normal spirometry. Respir Med X 2021; 3: 100025.
[http://dx.doi.org/10.1016/j.yrmex.2020.100025]
[45]
Donaldson GC, Law M, Kowlessar B, et al. Impact of prolonged exacerbation recovery in chronic obstructive pulmonary disease. Am J Respir Crit Care Med 2015; 192(8): 943-50.
[http://dx.doi.org/10.1164/rccm.201412-2269OC ] [PMID: 26151174]
[46]
Seemungal TA, Donaldson GC, Bhowmik A, Jeffries DJ, Wedzicha JA. Time course and recovery of exacerbations in patients with chronic obstructive pulmonary disease. Am J Respir Crit Care Med 2000; 161(5): 1608-13.
[http://dx.doi.org/10.1164/ajrccm.161.5.9908022 ] [PMID: 10806163]
[47]
Willaert W, Daenen M, Bomans P, Verleden G, Decramer M. What is the optimal treatment strategy for chronic obstructive pulmonary disease exacerbations? Eur Respir J 2002; 19(5): 928-35.
[http://dx.doi.org/10.1183/09031936.02.00268702] [PMID: 12030735]
[48]
Halpin DMG, Birk R, Brealey N, et al. Single-inhaler triple therapy in symptomatic COPD patients: FULFIL subgroup analyses. ERJ Open Res 2018; 4(2): 943-50.
[http://dx.doi.org/10.1183/23120541.00119-2017 ] [PMID: 29750142]
[49]
Hatipoglu US, Aboussouan LS. Treating and preventing acute exacerbations of COPD. Cleve Clin J Med 2016; 83(4): 289-300.
[http://dx.doi.org/10.3949/ccjm.83a.14188 ] [PMID: 27055203]
[50]
Agustí A, Calverley PM, Decramer M, Stockley RA, Wedzicha JA. Prevention of exacerbations in chronic obstructive pulmonary disease: Knowns and unknowns. Chronic Obstr Pulm Dis (Miami) 2014; 1(2): 166-84.
[http://dx.doi.org/10.15326/jcopdf.1.2.2014.0134 ] [PMID: 28848819]
[52]
Anzueto A. Impact of exacerbations on COPD. Eur Respir Rev 2010; 19(116): 113-8.
[http://dx.doi.org/10.1183/09059180.00002610 ] [PMID: 20956179]
[53]
Jalota L, Jain VV. Action plans for COPD: Strategies to manage exacerbations and improve outcomes. Int J Chron Obstruct Pulmon Dis 2016; 11: 1179-88.
[PMID: 27330286]
[54]
Zwerink M, Brusse-Keizer M, van der Valk PD, et al. Self management for patients with chronic obstructive pulmonary disease. Cochrane Database Syst Rev 2014; (3): CD002990.
[http://dx.doi.org/10.1002/14651858.CD002990.pub3] [PMID: 24665053]
[55]
Lenferink A, Palen VDJ, Cafarella P, et al. Exacerbation action plans for patients with COPD and comorbidities: A randomised controlled trial. Eur Respir J 2019; 54(5): 1802134.
[http://dx.doi.org/10.1183/13993003.02134-2018 ] [PMID: 31413163]
[58]
Recio Iglesias J, Díez-Manglano J, López García F, et al. Management of the COPD patient with comorbidities: An experts recommendation document. Int J Chron Obstruct Pulmon Dis 2019; 15: 1015-37.
[http://dx.doi.org/10.2147/COPD.S242009 ] [PMID: 32440113]
[59]
Smith MC, Wrobel JP. Epidemiology and clinical impact of major comorbidities in patients with COPD. Int J Chron Obstruct Pulmon Dis 2014; 9: 871-88.
[http://dx.doi.org/10.2147/COPD.S49621 ] [PMID: 25210449]
[60]
Putcha N, Drummond MB, Wise RA, Hansel NN. Comorbidities and chronic obstructive pulmonary disease: Prevalence, influence on outcomes, and management. Semin Respir Crit Care Med 2015; 36(4): 575-91.
[http://dx.doi.org/10.1055/s-0035-1556063 ] [PMID: 26238643]
[61]
Duong-Quy S, Tran Van H, Vo Thi Kim A, Pham Huy Q, Craig TJ. Clinical and functional characteristics of subjects with asthma, COPD, and asthma-COPD overlap: A multicentre study in Vietnam. Can Respir J 2018; 2018: 1732946.
[http://dx.doi.org/10.1155/2018/1732946 ] [PMID: 29808101]
[62]
Centers for Disease Control and Prevention. 2021. Available from: https://www.cdc.gov/vaccines/adults/rec-vac/health-conditions/lung-disease.html
[64]
Lee SC, Son KJ, Han HC, et al. Impact of COPD on angiotensin-converting enzyme 2 prognosis: A nationwide population-based study in South Korea. Sci Rep 2021; 11(1): 3735.
[65]
Halpin DMG, Criner GJ, Papi A, et al. Global initiative for the diagnosis, management, and prevention of chronic obstructive lung disease. The 2020 GOLD science committee report on COVID-19 and chronic obstructive pulmonary disease. Am J Respir Crit Care Med 2021; 203(1): 24-36.
[http://dx.doi.org/10.1164/rccm.202009-3533SO ] [PMID: 33146552]
[66]
Leung JM, Niikura M, Yang CWT, et al. COVID-19 and COPD. Eur Respir J 2020; 56: 2002108.
[67]
Meza D, Khuder B, Bailey JI, et al. Mortality from COVID-19 in patients with COPD: A US study in the N3C data enclave. Int J Chron Obstruct Pulmon Dis 2021; 16: 2323-6.
[http://dx.doi.org/10.2147/COPD.S318000 ] [PMID: 34413640]
[68]
Centers for Disease Control and Prevention. 2021. Available from: https://www.cdc.gov/coronavirus/2019-ncov/hcp/clinical-care/post-covid-management.html
[70]
Corhay JL, Dang DN, Van Cauwenberge H, Louis R. Pulmonary rehabilitation and COPD: Providing patients a good environment for optimizing therapy. Int J Chron Obstruct Pulmon Dis 2014; 9: 27-39.
[PMID: 24368884]
[71]
Zeng Y, Jiang F, Chen Y, et al. Exercise assessments and trainings of pulmonary rehabilitation in COPD: A literature review. Int J Chron Obstruct Pulmon Dis 2018; 13: 2013-23.
[http://dx.doi.org/10.2147/COPD.S167098 ] [PMID: 29983556]
[72]
Stefan MS, Pekow PS, Priya A, et al. Association between initiation of pulmonary rehabilitation and rehospitalizations in patients hospitalized with chronic obstructive pulmonary disease. Am J Respir Crit Care Med 2021; 204(9): 1015-23.
[http://dx.doi.org/10.1164/rccm.202012-4389OC ] [PMID: 34283694]
[73]
Spitzer KA, Stefan MS, Priya A, et al. Participation in pulmonary rehabilitation after hospitalization for chronic obstructive pulmonary disease among medicare beneficiaries. Ann Am Thorac Soc 2019; 16(1): 99-106.
[http://dx.doi.org/10.1513/AnnalsATS.201805-332OC] [PMID: 30417670]
[74]
Myers LC, Faridi MK, Hasegawa K, Camargo CA Jr. Pulmonary rehabilitation and readmission rates for medicare beneficiaries with acute exacerbation of chronic obstructive pulmonary disease. Chronic Obstr Pulm Dis 2021; 8(4): 427-40.
[http://dx.doi.org/10.15326/jcopdf.2020.0193 ] [PMID: 34329550]
[75]
Puhan MA, Gimeno-Santos E, Cates CJ, Troosters T. Pulmonary rehabilitation following exacerbations of chronic obstructive pulmonary disease. Cochrane Database Syst Rev 2016; 12(12): CD005305.
[http://dx.doi.org/10.1002/14651858.CD005305.pub4] [PMID: 27930803]
[77]
Cleveland Clinic medical professional.. 2021. Available from: https://my.clevelandclinic.org/health/articles/9450-copd-exercise--activity-guidelines
[79]
Garcia-Aymerich J, Lange P, Benet M, Schnohr P, Antó JM. Regular physical activity reduces hospital admission and mortality in chronic obstructive pulmonary disease: A population based cohort study. Thorax 2006; 61(9): 772-8.
[http://dx.doi.org/10.1136/thx.2006.060145 ] [PMID: 16738033]

© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version275msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[05:04:24] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[05:04:24] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[05:04:24] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[05:04:24] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (93.59ms)time
  • Application (182ms)time
  • 1 x Application (65.99%)
    182ms
    1 x Booting (34.01%)
    93.59ms
    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
    31 statements were executed, 4 of which were duplicates, 27 unique. Show only duplicated110ms
    • 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 ('316548017','',1,1740459864,1740459864) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740459864
      1.42msalphaeurekaselec_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 ('316548017','/article/126138',1,1740459864,1740459864)
      610μ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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) limit 1
      36.71msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316548017
      • 1: 316548017
      • 2: 316548017
      • 3: 316548017
      • 4: 316548017
      • 5: 316548017
      • 6: 316548017
      • 7: 316548017
      • 8: 316548017
      • 9: 316548017
      • 10: 316548017
      • 11: 316548017
      • 12: 316548017
      • 13: 316548017
      • 14: 316548017
      • 15: 316548017
      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=126138
      1msalphaeurekaselec_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` = 47 limit 1
      1.13msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 47
      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=47) and sj.journal_id!=47 group by `j`.`nid`) as `aggregate_table`
      1.15msalphaeurekaselec_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=47) and sj.journal_id!=47 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      980μ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=47) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      6.9msalphaeurekaselec_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=47) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      6.09msalphaeurekaselec_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` = '126138'
      1.42msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 126138
      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` = '126138'
      5.24msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 126138
      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` = '126138' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.99msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 126138
      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
      250μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      490μsalphaeurekaselec_live_10_06_2022Article.php#1960
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1960
      • 14. app/Http/Controllers/ArticleController.php:2062
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • Select j.subtitle, v.volume_id as volume_id,v.year_id,y.year as year,v.volume_name, v.total_no_of_issues, i.issue_id as issue_id,i.title as issue, i.publication_date as issue_pub_date from journal j join volume v on j.journal_id = v.journal_id join issue i on v.volume_id = i.volume_id join article a on a.issue_id = i.issue_id join year y on v.year_id = y.id where j.journal_id = 47 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      25.41msalphaeurekaselec_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 = 47 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.68msalphaeurekaselec_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 = 47 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      3.57msalphaeurekaselec_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` = 126138 limit 1
      250μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 126138
      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 = 126138 and content_type = 'article' order by status desc limit 1
      280μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 208515 limit 1
      240μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 208515
      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
      240μ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` = 'CRMR' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      860μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CRMR
      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 = '126138' 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) )
      400μ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 * from `article` where `first_page` < '12' and is_uploaded = 1 and issue_id = 12215 order by cast(first_page as SIGNED) desc limit 1
      490μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 12
      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` > '23' and is_uploaded = 1 and issue_id = 12215 order by cast(first_page as SIGNED) asc limit 1
      480μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 23
      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'
      190μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      230μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 126138 limit 1
      2.43msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 126138
      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` = 47 and `b`.`banner_from_date` <= 1740459864 and `b`.`banner_to_date` >= 1740459864 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.14msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 47
      • 3: 1740459864
      • 4: 1740459864
      • 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` = 47 and `b`.`banner_from_date` <= 1740459864 and `b`.`banner_to_date` >= 1740459864 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.13msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 47
      • 3: 1740459864
      • 4: 1740459864
      • 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='4d58140e1d694f5264ae049883feae4f'
      240μ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
        2tyo87oW7y2C6tndDtdfYYgtrwg7yjnq8LCgceY3
        uc_cart_id
        4d58140e1d694f5264ae049883feae4f
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/126138" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/126138
        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:8 [ "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
        []
        
        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 05:04:24 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im8veEtLUjFhdFFXVndEVHhDVjBRRUE9PSIsInZhbHVlIjoiYmVQVDFDdFB2R0dTUVJrbW8xa0xTWnBYdnh5QStCbFVaQUZiZStxZUNkSHR2aFNNTkVhQStuOFc4Z0h0NjlyR1NFcWVKbnE4QTNteEE2QTZoTmo4LzhuZEg2TW10SHVGNW1tTDZ1K2IyZGZvSmtEWEl1TGxLbXVvdGdOYnVueXciLCJtYWMiOiI5NzFkNzlmOGZlNGQ4NDNhOGNmNjEwZGYwN2MzNWY2ZDFhMWY2NjA4ZWQ0YTVkZmM0Y2VmNjViMzMzMGJjMzMzIiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 17:04:24 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Im8veEtLUjFhdFFXVndEVHhDVjBRRUE9PSIsInZhbHVlIjoiYmVQVDFDdFB2R0dTUVJrbW8xa0xTWnBYdnh5QStCbFVaQUZiZStxZUNkSHR2aFNNTkVhQStuOFc4Z0h0NjlyR1NFcWVKb" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlpGd0VKU1N4YU45akh3N2VuVU9sWFE9PSIsInZhbHVlIjoiUStmZmJ1MnBtekk4bktURUZITE40WnFmTmdkdkNreVppeWYzODZNRzlLV1pJN2JsL01FSnorMFpkOGcvTGZaM3daUmxRVENYcGZTVTZFQlpwTWJWdmhmTHlHMUs0ZzFzVmVYT0xhbDlqanFxVzJRa3VVRWlwa2FBdjR6N3NRMWEiLCJtYWMiOiJlNmIwZGYxYjhhZmVmMDQ1Njk4NTNmYTQ4ZTkxY2U1OTU3Y2QwYjEzMzAzNjEzZmI2ZDkzZTM0ZDcwNWIwZjI3IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlpGd0VKU1N4YU45akh3N2VuVU9sWFE9PSIsInZhbHVlIjoiUStmZmJ1MnBtekk4bktURUZITE40WnFmTmdkdkNreVppeWYzODZNRzlLV1pJN2JsL01FSnorMFp" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im8veEtLUjFhdFFXVndEVHhDVjBRRUE9PSIsInZhbHVlIjoiYmVQVDFDdFB2R0dTUVJrbW8xa0xTWnBYdnh5QStCbFVaQUZiZStxZUNkSHR2aFNNTkVhQStuOFc4Z0h0NjlyR1NFcWVKbnE4QTNteEE2QTZoTmo4LzhuZEg2TW10SHVGNW1tTDZ1K2IyZGZvSmtEWEl1TGxLbXVvdGdOYnVueXciLCJtYWMiOiI5NzFkNzlmOGZlNGQ4NDNhOGNmNjEwZGYwN2MzNWY2ZDFhMWY2NjA4ZWQ0YTVkZmM0Y2VmNjViMzMzMGJjMzMzIiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 17:04:24 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Im8veEtLUjFhdFFXVndEVHhDVjBRRUE9PSIsInZhbHVlIjoiYmVQVDFDdFB2R0dTUVJrbW8xa0xTWnBYdnh5QStCbFVaQUZiZStxZUNkSHR2aFNNTkVhQStuOFc4Z0h0NjlyR1NFcWVKb" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlpGd0VKU1N4YU45akh3N2VuVU9sWFE9PSIsInZhbHVlIjoiUStmZmJ1MnBtekk4bktURUZITE40WnFmTmdkdkNreVppeWYzODZNRzlLV1pJN2JsL01FSnorMFpkOGcvTGZaM3daUmxRVENYcGZTVTZFQlpwTWJWdmhmTHlHMUs0ZzFzVmVYT0xhbDlqanFxVzJRa3VVRWlwa2FBdjR6N3NRMWEiLCJtYWMiOiJlNmIwZGYxYjhhZmVmMDQ1Njk4NTNmYTQ4ZTkxY2U1OTU3Y2QwYjEzMzAzNjEzZmI2ZDkzZTM0ZDcwNWIwZjI3IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlpGd0VKU1N4YU45akh3N2VuVU9sWFE9PSIsInZhbHVlIjoiUStmZmJ1MnBtekk4bktURUZITE40WnFmTmdkdkNreVppeWYzODZNRzlLV1pJN2JsL01FSnorMFp" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "2tyo87oW7y2C6tndDtdfYYgtrwg7yjnq8LCgceY3" "uc_cart_id" => "4d58140e1d694f5264ae049883feae4f" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/126138" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 05:04:24GET/article/126138414311