Generic placeholder image

Current Diabetes Reviews

Editor-in-Chief

ISSN (Print): 1573-3998
ISSN (Online): 1875-6417

Systematic Review Article

The Patient-centered Medical Home as an Intervention Strategy for Diabetes Mellitus: A Systematic Review of the Literature

Author(s): Lisa S. McManus, Karen A. Dominguez-Cancino, Michele K. Stanek, Juan. M. Leyva-Moral, Carola E. Bravo-Tare, Oriana Rivera-Lozada and Patrick A. Palmieri*

Volume 17, Issue 3, 2021

Published on: 22 November, 2020

Page: [317 - 331] Pages: 15

DOI: 10.2174/1573399816666201123103835

Abstract

Background: Poorly managed diabetes mellitus increases health care expenditures and negatively impacts health outcomes. There are 34 million people living with diabetes in the United States with a direct annual medical cost of $237 billion. The patient-centered medical home (PCMH) was introduced to transform primary care by offering team-based care that is accessible, coordinated, and comprehensive. Although the PCMH is believed to address multiple gaps in delivering care to people living with chronic diseases, the research has not yet reported clear benefits for managing diabetes.

Objective: The study reviews the scientific literature about diabetes mellitus outcomes reported by PCMHs, and understands the impact of team-based care, interdisciplinary communication, and care coordination strategies on the clinical, financial, and health-related outcomes.

Methods: The systematic review was performed according to the Cochrane method and the Preferred Reporting Items for Systematic Reviews and Meta-Analyses. Eight databases were systematically searched for articles. The Oxford Centre for Evidence-based Medicine Levels of evidence and the Critical Appraisal Skills Programme systematic review checklist were used to evaluate the studies.

Results: The search resulted in 596 articles, of which 24 met all the inclusion criteria. Care management resulted in more screenings and better preventive care. Pharmacy-led interventions and technology were associated with positive clinical outcomes, decreased utilization, and cost savings. Most studies reported decreased emergency room visits and less inpatient admissions.

Conclusion: The quality and strength of the outcomes were largely inconclusive about the overall effectiveness of the PCMH. Defining and comparing concepts across studies was difficult as universal definitions specific to the PCMH were not often applied. More research is needed to unpack the care model of the PCMH to further understand how the individual key components, such as care bundles, contribute to improved outcomes. Further evaluations are needed for team-based care, communication, and care coordination with comparisons to patient, clinical, health, and financial outcomes.

Keywords: Patient-centered medical home, diabetes, teamwork, care coordination, multidisciplinary, communication.

[1]
Vos T, Abajobir AA, Abate KH, et al. GBD 2016 Disease and Injury Incidence and Prevalence Collaborators. Global, regional, and national incidence, prevalence, and years lived with disability for 328 diseases and injuries for 195 countries, 1990-2016: a systematic analysis for the Global Burden of Disease Study 2016. Lancet 2017; 390(10100): 1211-59.
[http://dx.doi.org/10.1016/S0140-6736(17)32154-2] [PMID: 28919117]
[2]
Williams R, Colagiuri S, Eds. IDF diabetes atlas. Brussels, Belgium: International Diabetes Federation 2019.
[3]
Saeedi P, Petersohn I, Salpea P, et al. Global and regional diabetes prevalence estimates for 2019 and projections for 2030 and 2045: Results from the International Diabetes Federation Diabetes Atlas, 9th edition. Diabetes Res Clin Pract 2019; 157.
[http://dx.doi.org/10.1016/j.diabres.2019.107843]
[4]
Bauer UE, Briss PA, Goodman RA, Bowman BA. Prevention of chronic disease in the 21st century: elimination of the leading preventable causes of premature death and disability in the USA. Lancet 2014; 384(9937): 45-52.
[http://dx.doi.org/10.1016/S0140-6736(14)60648-6] [PMID: 24996589]
[5]
Zhang P, Zhang X, Brown J, et al. Global healthcare expenditure on diabetes for 2010 and 2030. Diabetes Res Clin Pract 2010; 87(3): 293-301.
[http://dx.doi.org/10.1016/j.diabres.2010.01.026] [PMID: 20171754]
[6]
Li R, Bilik D, Brown MB, et al. Medical costs associated with type 2 diabetes complications and comorbidities. Am J Manag Care 2013; 19(5): 421-30.
[PMID: 23781894]
[7]
Hoffstad O, Mitra N, Walsh J, Margolis DJ. Diabetes, lower-extremity amputation, and death. Diabetes Care 2015; 38(10): 1852-7.
[http://dx.doi.org/10.2337/dc15-0536] [PMID: 26203063]
[8]
Narres M, Kvitkina T, Claessen H, et al. Incidence of lower extremity amputations in the diabetic compared with the non-diabetic population: A systematic review. PLoS One 2017; 12(8): e0182081.
[http://dx.doi.org/10.1371/journal.pone.0182081] [PMID: 28846690]
[9]
Markuson M, Hanson D, Anderson J, et al. The relationship between hemoglobin A(1c) values and healing time for lower extremity ulcers in individuals with diabetes. Adv Skin Wound Care 2009; 22(8): 365-72.
[http://dx.doi.org/10.1097/01.ASW.0000358639.45784.cd] [PMID: 19638800]
[10]
Margolis DJ, Jeffcoate W. Epidemiology of foot ulceration and amputation: can global variation be explained? Med Clin North Am 2013; 97(5): 791-805.
[http://dx.doi.org/10.1016/j.mcna.2013.03.008] [PMID: 23992892]
[11]
Centers for Disease Control and Prevention. National diabetes statistics report: Estimates of diabetes and its burden in the United States. Atlanta, GA: United States Department of Health and Human Services 2020.
[12]
American Diabetes Association. Economic costs of diabetes in the U.S. in 2017. Diabetes Care 2018; 41(5): 917-28.
[http://dx.doi.org/10.2337/dci18-0007] [PMID: 29567642]
[13]
Caspersen CJ, Thomas GD, Boseman LA, Beckles GLA, Albright AL. Aging, diabetes, and the public health system in the United States. Am J Public Health 2012; 102(8): 1482-97.
[http://dx.doi.org/10.2105/AJPH.2011.300616] [PMID: 22698044]
[14]
Thorpe KE, Ogden LL, Galactionova K. Chronic conditions account for rise in Medicare spending from 1987 to 2006. Health Aff (Millwood) 2010; 29(4): 718-24.
[http://dx.doi.org/10.1377/hlthaff.2009.0474] [PMID: 20167626]
[15]
Aroh D, Colella J, Douglas C, Eddings A. An example of translating value-based purchasing into value-based care. Urol Nurs 2015; 35(2): 61-74.
[http://dx.doi.org/10.7257/1053-816X.2015.35.2.61] [PMID: 26197624]
[16]
Coleman K, Austin BT, Brach C, Wagner EH. Evidence on the chronic care model in the new millennium. Health Aff (Millwood) 2009; 28(1): 75-85.
[http://dx.doi.org/10.1377/hlthaff.28.1.75] [PMID: 19124857]
[17]
Ackroyd SA, Wexler DJ. Effectiveness of diabetes interventions in the patient-centered medical home. Curr Diab Rep 2014; 14(3): 471.
[http://dx.doi.org/10.1007/s11892-013-0471-z] [PMID: 24477830]
[18]
A Salzberg C, Bitton A, Lipsitz SR, et al. The impact of alternative payment in chronically ill and older patients in the patient-centered medical home. Med Care 2017; 55(5): 483-92.
[http://dx.doi.org/10.1097/MLR.0000000000000694] [PMID: 28169976]
[19]
Bitton A, Martin C, Landon BE. A nationwide survey of patient centered medical home demonstration projects. J Gen Intern Med 2010; 25(6): 584-92.
[http://dx.doi.org/10.1007/s11606-010-1262-8] [PMID: 20467907]
[20]
Hussey PS, Schneider EC, Rudin RS, Fox DS, Lai J, Pollack CE. Continuity and the costs of care for chronic disease. JAMA Intern Med 2014; 174(5): 742-8.
[http://dx.doi.org/10.1001/jamainternmed.2014.245] [PMID: 24638880]
[21]
Ferrante JM, Balasubramanian BA, Hudson SV, Crabtree BF. Principles of the patient-centered medical home and preventive services delivery. Ann Fam Med 2010; 8(2): 108-16.
[http://dx.doi.org/10.1370/afm.1080] [PMID: 20212297]
[22]
Kellerman R, Kirk L. Principles of the patient-centered medical home. Am Fam Physician 2007; 76(6): 774-5.
[PMID: 17910291]
[23]
Hughes JR, Grayson R, Stiles FC. Fragmentation of care and the medical home. Pediatrics 1977; 60(4): 559-9.
[PMID: 905034]
[24]
Daaleman TP, Hay S, Prentice A, Gwynne MD. Embedding care management in the medical home: a case study. J Prim Care Community Health 2014; 5(2): 97-100.
[http://dx.doi.org/10.1177/2150131913519128] [PMID: 24414127]
[25]
Taliani CA, Bricker PL, Adelman AM, Cronholm PF, Gabbay RA. Implementing effective care management in the patient-centered medical home. Am J Manag Care 2013; 19(12): 957-64.
[PMID: 24512033]
[26]
Jackson GL, Powers BJ, Chatterjee R, et al. The patient centered medical home. A systematic review. Ann Intern Med 2013; 158(3): 169-78.
[http://dx.doi.org/10.7326/0003-4819-158-3-201302050-00579] [PMID: 24779044]
[27]
Veet CA, Radomski TR, D’Avella C, et al. Impact of healthcare delivery system type on clinical, utilization, and cost outcomes of patient-centered medical homes: A systematic review. J Gen Intern Med 2020; 35(4): 1276-84.
[http://dx.doi.org/10.1007/s11606-019-05594-3] [PMID: 31907790]
[28]
Melnyk BM, Fineout-Overholt E, Stillwell SB, Williamson KM. Evidence-Based Practice: Step by Step: The Seven Steps of Evidence-Based Practice The Leading Voice of Nursing Since 1900 | AJN 2010; 110(1): 51-3.
[29]
Schardt C, Adams MB, Owens T, Keitz S, Fontelo P. Utilization of the PICO framework to improve searching PubMed for clinical questions. BMC Med Inform Decis Mak 2007; 7(1): 16.
[http://dx.doi.org/10.1186/1472-6947-7-16] [PMID: 17573961]
[30]
Higgins JPT, Green S, Eds. Cochrane handbook for systematic reviews of interventions. London, United Kingdom: The Cochrane Collaboration 2011.
[31]
Moher D, Liberati A, Tetzlaff J, Altman DG. PRISMA Group. Preferred reporting items for systematic reviews and meta-analyses: the PRISMA statement. BMJ 2009; 339: b2535.
[http://dx.doi.org/10.1136/bmj.b2535] [PMID: 19622551]
[32]
Petticrew M, Roberts H. Systematic reviews in the social sciences: a practical guide. Malden, MA: Blackwell Publishing Co. 2006.
[http://dx.doi.org/10.1002/9780470754887]
[33]
Garrard J. Health sciences literature review made easy: The matrix method. 4th ed. Burlington, MA: Jones & Bartlett Learning 2013.
[34]
Howick J, Chalmers I, Glasziou P, et al. Explanation of the 2011 Oxford Centre for Evidence-Based Medicine (OCEBM) levels of evidence (background document) 2016.https://www.cebm.net/index.aspx?o=5653
[35]
Oxford Centre for Evidence-based Medicine. Levels of evidence 2009.https://www.cebm.net/2009/06/
[36]
Leyva-Moral JM, Palmieri PA, Feijoo-Cid M, et al. Reproductive decision-making in women living with human immunodeficiency virus: A systematic review. Int J Nurs Stud 2018; 77: 207-21.
[http://dx.doi.org/10.1016/j.ijnurstu.2017.10.012] [PMID: 29112908]
[37]
Gabbay RA, Friedberg MW, Miller-Day M, Cronholm PF, Adelman A, Schneider EC. A positive deviance approach to understanding key features to improving diabetes care in the medical home. Ann Fam Med 2013; 11(Suppl. 1): S99-S107.
[http://dx.doi.org/10.1370/afm.1473] [PMID: 23690393]
[38]
Sieber WJ, Newsome A, Fiorella M, Mantila H. Translating patient self-management research into primary care: challenges and successes with group medical visits. Transl Behav Med 2012; 2(4): 535-42.
[http://dx.doi.org/10.1007/s13142-012-0150-7] [PMID: 24073154]
[39]
Solberg LI, Crain AL, Tillema J, Scholle SH, Fontaine P, Whitebird R. Medical home transformation: a gradual process and a continuum of attainment. Ann Fam Med 2013; 11(Suppl. 1): S108-14.
[http://dx.doi.org/10.1370/afm.1478] [PMID: 23690379]
[40]
Moran K, Burson R, Critchett J, Olla P. Exploring the cost and clinical outcomes of integrating the registered nurse-certified diabetes educator into the patient-centered medical home. Diabetes Educ 2011; 37(6): 780-93.
[http://dx.doi.org/10.1177/0145721711423979] [PMID: 22075501]
[41]
DeVries A, Li CH, Sridhar G, Hummel JR, Breidbart S, Barron JJ. Impact of medical homes on quality, healthcare utilization, and costs. Am J Manag Care 2012; 18(9): 534-44.
[PMID: 23009304]
[42]
Flottemesch TJ, Anderson LH, Solberg LI, Fontaine P, Asche SE. Patient-centered medical home cost reductions limited to complex patients. Am J Manag Care 2012; 18(11): 677-86.
[PMID: 23198711]
[43]
David G, Gunnarsson C, Saynisch PA, Chawla R, Nigam S. Do patient-centered medical homes reduce emergency department visits? Health Serv Res 2015; 50(2): 418-39.
[http://dx.doi.org/10.1111/1475-6773.12218] [PMID: 25112834]
[44]
Rosenthal MB, Alidina S, Friedberg MW, et al. A difference-in-difference analysis of changes in quality, utilization and cost following the Colorado multi-payer patient-centered medical home pilot. J Gen Intern Med 2016; 31(3): 289-96.
[http://dx.doi.org/10.1007/s11606-015-3521-1] [PMID: 26450279]
[45]
Timbie JW, Hussey PS, Setodji CM, et al. Association between patient-centered medical home capabilities and outcomes for Medicare beneficiaries seeking care from federally qualified health centers. J Gen Intern Med 2017; 32(9): 997-1004.
[http://dx.doi.org/10.1007/s11606-017-4078-y] [PMID: 28550610]
[46]
Lauffenburger JC, Shrank WH, Bitton A, et al. Association between patient-centered medical homes and adherence to chronic disease medications: A cohort study. Ann Intern Med 2017; 166(2): 81-8.
[http://dx.doi.org/10.7326/M15-2659] [PMID: 27842386]
[47]
Miller JM, Phalen AG, Crawford A, Frisby A, Ziring BS. Text messaging in the patient-centered medical home to improve glucose control and retinopathy screening. Health Equity 2017; 1(1): 2-6.
[http://dx.doi.org/10.1089/heq.2016.0003] [PMID: 30283829]
[48]
Meo N, Wong E, Sun H, et al. Elements of the Veterans Health Administration patient-centered medical home are associated with greater adherence to oral hypoglycemic agents in patients with diabetes. Popul Health Manag 2018; 21(2): 116-22.
[http://dx.doi.org/10.1089/pop.2017.0039] [PMID: 28677990]
[49]
Gunter KE, Nocon RS, Gao Y, Casalino LP, Chin MH. Medical home characteristics and quality of diabetes care in safety net clinics. J Community Health 2017; 42(2): 303-11.
[http://dx.doi.org/10.1007/s10900-016-0256-9] [PMID: 27659297]
[50]
Shi L, Lee D-C, Chung M, Liang H, Lock D, Sripipatana A. Patient-centered medical home recognition and clinical performance in U.S. community health centers. Health Serv Res 2017; 52(3): 984-1004.
[http://dx.doi.org/10.1111/1475-6773.12523] [PMID: 27324440]
[51]
Kinsell HS, Hall AG, Harman JS, Tewary S, Brickman A. Impacts of initial transformation to a patient-centered medical home on diabetes outcomes in federally qualified health centers in Florida. J Prim Care Community Health 2017; 8(4): 192-7.
[http://dx.doi.org/10.1177/2150131917742300] [PMID: 29161972]
[52]
Carlin CS, Flottemesch TJ, Solberg LI, Werner AM. System transformation in patient-centered medical home (PCMH): Variable impact on chronically ill patients’ utilization. J Am Board Fam Med 2016; 29(4): 482-95.
[http://dx.doi.org/10.3122/jabfm.2016.04.150360] [PMID: 27390380]
[53]
Lamb KD, Baker JW, McFarland MS. Implementation of a pharmacotherapy clinic into the patient centered medical home model by a second year pharmacy resident American Journal of Health-System Pharmacy 2015; 72 (17_Supplement_2 ): 83 -9 .
[http://dx.doi.org/10.2146/sp150015]
[54]
Berdine HJ, Skomo ML. Development and integration of pharmacist clinical services into the patient-centered medical home. J Am Pharm Assoc (2003) 2012; 52(5): 661-7.
[http://dx.doi.org/10.1331/JAPhA.2012.10206] [PMID: 23023848]
[55]
Edwards HD, Webb RD, Scheid DC, Britton ML, Armor BL. A pharmacist visit improves diabetes standards in a patient-centered medical home (PCMH). Am J Med Qual 2012; 27(6): 529-34.
[http://dx.doi.org/10.1177/1062860612444304] [PMID: 22679128]
[56]
Calman NS, Hauser D, Weiss L, et al. Becoming a patient-centered medical home: a 9-year transition for a network of Federally Qualified Health Centers. Ann Fam Med 2013; 11(Suppl. 1): S68-73.
[http://dx.doi.org/10.1370/afm.1547] [PMID: 23690389]
[57]
Liss DT, Reid RJ, Grembowski D, Rutter CM, Ross TR, Fishman PA. Changes in office visit use associated with electronic messaging and telephone encounters among patients with diabetes in the PCMH. Ann Fam Med 2014; 12(4): 338-43.
[http://dx.doi.org/10.1370/afm.1642] [PMID: 25024242]
[58]
DePuccio MJ, Hoff TJ. Medical home interventions and quality outcomes for older adults: a systematic review. Qual Manag Health Care 2013; 22(4): 327-40.
[http://dx.doi.org/10.1097/QMH.0000000000000000] [PMID: 24088881]
[59]
Emerson JF, Welch M, Rossman WE, et al. A multidisciplinary intervention utilizing virtual communication tools to reduce health disparities: A pilot randomized controlled trial. Int J Environ Res Public Health 2015; 13(1): h13010031.
[http://dx.doi.org/10.3390/ijerph13010031] [PMID: 26703661]
[60]
Pagán JA, Carlson EK. Assessing long-term health and cost outcomes of patient-centered medical homes serving adults with poor diabetes control. J Prim Care Community Health 2013; 4(4): 281-5.
[http://dx.doi.org/10.1177/2150131913489885] [PMID: 23799676]
[61]
Martsolf GR, Kandrack R, Friedberg MW, Briscombe B, Hussey PS, LaBonte C. Estimating the Costs of Implementing Comprehensive Primary Care: A Narrative Review. Health Serv Res Manag Epidemiol 2019; 6: 2333392819842484.
[http://dx.doi.org/10.1177/2333392819842484] [PMID: 31069248]
[62]
Magill MK, Ehrenberger D, Scammon DL, et al. The cost of sustaining a patient-centered medical home: experience from 2 states. Ann Fam Med 2015; 13(5): 429-35.
[http://dx.doi.org/10.1370/afm.1851] [PMID: 26371263]
[63]
Friedman A, Howard J, Shaw EK, Cohen DJ, Shahidi L, Ferrante JM. Facilitators and barriers to care coordination in patient-centered medical homes (PCMHs) from coordinators’ perspectives. J Am Board Fam Med 2016; 29(1): 90-101.
[http://dx.doi.org/10.3122/jabfm.2016.01.150175] [PMID: 26769881]
[64]
Bojadzievski T, Gabbay RA. Patient-centered medical home and diabetes. Diabetes Care 2011; 34(4): 1047-53.
[http://dx.doi.org/10.2337/dc10-1671] [PMID: 21447667]
[65]
Kraschnewski JL, Gabbay RA. Role of health information technologies in the Patient-centered Medical Home. J Diabetes Sci Technol 2013; 7(5): 1376-85.
[http://dx.doi.org/10.1177/193229681300700530] [PMID: 24124967]
[66]
Schottenfeld L, Petersen D, Peikes D, et al. Creating patient-centered team-based primary care Rockville, MD Agency for Healthcare Research and Quality. 2016.
[67]
Hall AG, Webb FJ, Scuderi CB, Tamayo-Friedel C, Harman JS. Differences in patient ratings of medical home domains among adults with diabetes: comparisons across primary care sites. J Prim Care Community Health 2014; 5(4): 247-52.
[http://dx.doi.org/10.1177/2150131914538455] [PMID: 24928567]
[68]
Lavallée JF, Gray TA, Dumville J, Russell W, Cullum N. The effects of care bundles on patient outcomes: a systematic review and meta-analysis. Implement Sci 2017; 12(1): 142.
[http://dx.doi.org/10.1186/s13012-017-0670-0] [PMID: 29187217]
[69]
Nigro SC, Garwood CL, Berlie H, et al. Clinical pharmacists as key members of the patient-centered medical home: an opinion statement of the Ambulatory Care Practice and Research Network of the American College of Clinical Pharmacy. Pharmacotherapy 2014; 34(1): 96-108.
[http://dx.doi.org/10.1002/phar.1357] [PMID: 24122857]
[70]
John JR, Ghassempour S, Girosi F, Atlantis E. The effectiveness of patient-centred medical home model versus standard primary care in chronic disease management: protocol for a systematic review and meta-analysis of randomised and non-randomised controlled trials. Syst Rev 2018; 7(1): 215.
[http://dx.doi.org/10.1186/s13643-018-0887-2] [PMID: 30497523]
[71]
Alexander JA, Paustian M, Wise CG, et al. Assessment and measurement of patient-centered medical home implementation: the BCBSM experience. Ann Fam Med 2013; 11(Suppl. 1): S74-81.
[http://dx.doi.org/10.1370/afm.1472] [PMID: 23690390]

© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version330msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[02:58:48] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[02:58:48] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[02:58:48] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[02:58:48] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (116ms)time
  • Application (214ms)time
  • 1 x Application (64.88%)
    214ms
    1 x Booting (35.12%)
    116ms
    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
    32 statements were executed, 4 of which were duplicates, 28 unique. Show only duplicated145ms
    • 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 ('51872515','',1,1739847528,1739847528) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739847528
      1.01msalphaeurekaselec_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 ('51872515','/article/111713',1,1739847528,1739847528)
      190μ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 >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) 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 >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) 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 >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) 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 >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) 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 >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) 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 >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) limit 1
      17.71msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51872515
      • 1: 51872515
      • 2: 51872515
      • 3: 51872515
      • 4: 51872515
      • 5: 51872515
      • 6: 51872515
      • 7: 51872515
      • 8: 51872515
      • 9: 51872515
      • 10: 51872515
      • 11: 51872515
      • 12: 51872515
      • 13: 51872515
      • 14: 51872515
      • 15: 51872515
      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=111713
      840μ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` = 10 limit 1
      1.01msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 10
      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=10) and sj.journal_id!=10 group by `j`.`nid`) as `aggregate_table`
      1.79msalphaeurekaselec_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=10) and sj.journal_id!=10 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.41msalphaeurekaselec_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=10) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      5.13msalphaeurekaselec_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=10) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      5.45msalphaeurekaselec_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` = '111713'
      300μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 111713
      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` = '111713'
      3.23msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 111713
      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` = '111713' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.11msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 111713
      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
      230μ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
      440μ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 = 10 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      26.08msalphaeurekaselec_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 = 10 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      9.18msalphaeurekaselec_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 = 10 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      6.24msalphaeurekaselec_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` = 111713 limit 1
      210μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 111713
      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 = 111713 and content_type = 'article' order by status desc limit 1
      290μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 283 and cd.sub_disease_id = 591 and content_id!=111713 and cd.content_type = 'article' order by rand() limit 20
      54.44msalphaeurekaselec_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` = 188253 limit 1
      200μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 188253
      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
      190μ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` = 'CDR' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      260μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CDR
      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 = '111713' 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) )
      350μ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` < '317' and is_uploaded = 1 and issue_id = 10533 order by cast(first_page as SIGNED) desc limit 1
      460μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 317
      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` > '331' and is_uploaded = 1 and issue_id = 10533 order by cast(first_page as SIGNED) asc limit 1
      420μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 331
      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
      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` = 111713 limit 1
      2.36msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 111713
      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` = 10 and `b`.`banner_from_date` <= 1739847528 and `b`.`banner_to_date` >= 1739847528 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.08msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 10
      • 3: 1739847528
      • 4: 1739847528
      • 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` = 10 and `b`.`banner_from_date` <= 1739847528 and `b`.`banner_to_date` >= 1739847528 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.03msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 10
      • 3: 1739847528
      • 4: 1739847528
      • 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='563df81ad2bc11ee88bf3857f83f7a1c'
      180μ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
        4KhU5Vigjxi5sAMmliCJ1GacVV4lkqyhyYNwozt7
        uc_cart_id
        563df81ad2bc11ee88bf3857f83f7a1c
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/111713" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/111713
        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=eyJpdiI6IkwrT1I5OFVTUVI5ZnNNRk9zV01wS2c9PSIsInZhbHVlIjoiRXpaLzZOaHhYdTFZcUx2ZTVLL2JHQVdEOGY3ZDlNTlZOaEU3azZYV0paVT0iLCJtYWMiOiI4MmQzMWUzZjMwNGNmMmViZTQxNTdhNzBlZjI3MThkZDMxZGZjMTUxM2Q0ZWM3NjQ0NzNmY2M4OGMzMTA3MjI4IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IkwrT1I5OFVTUVI5ZnNNRk9zV01wS2c9PSIsInZhbHVlIjoiRXpaLzZOaHhYdTFZcUx2ZTVLL2JHQVdEOGY3ZDlNTlZOaEU3azZYV0paVT0iLCJtYWMiOiI4MmQzMWUzZjMwNGNm" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 18 Feb 2025 02:58:48 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InMzNjBqZENuMXE2emhmRXRweGpGaFE9PSIsInZhbHVlIjoielpNQTdGTS9HTisyQmlZR2Y5azRyMWVTQjdSYWh2MVVhdEhPVFJXUnR2bHpTMW1pYllaRkhPSW5OcWVCcS93NDFVUE1SYTdaTEJBSVEyY3gwVEQrcmx6TVNxTEdHR1d1VG5WcnBWRWR5OEJOaS9qdUpMVUhMNzdZb3BMSlNxdUsiLCJtYWMiOiJhYzZhNTVmZGViYWRiOTQ4NDY0OGE2MTI0ZmExOTczNzZjOGViOTQ0NGVhZGUxODI5MTU1ODM2NDNjM2ZjYWRkIiwidGFnIjoiIn0%3D; expires=Thu, 20 Feb 2025 14:58:48 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InMzNjBqZENuMXE2emhmRXRweGpGaFE9PSIsInZhbHVlIjoielpNQTdGTS9HTisyQmlZR2Y5azRyMWVTQjdSYWh2MVVhdEhPVFJXUnR2bHpTMW1pYllaRkhPSW5OcWVCcS93NDFVUE1SY" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImV2Wlh4Zy9oVmFqWFE3aG9MZ1lrR2c9PSIsInZhbHVlIjoiOHBSUnAvazYxcXpoSk9VbXNvNmpWQVR4UlpEdzNycGF6SVZ3V2JWdWRrN2tKQk93Z1BZMmp0S1BXVkhQUnNxR0RvTjNGQXpZSW52QnZwUU01eDlBUGlMMzdwK3dsVHQwa0c3c2VqMDRrWkNBVFNhQmVhbTlDS0E3ZjQreFMvdjUiLCJtYWMiOiIyZGE0MzUxMTNhNjkzYjNkNzkxMTYzOTRiYjJkODg4MmQ3OTY1ZDFlYWYxMzI3ODkwYTRjNDAwZDYxMGMyNGJlIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6ImV2Wlh4Zy9oVmFqWFE3aG9MZ1lrR2c9PSIsInZhbHVlIjoiOHBSUnAvazYxcXpoSk9VbXNvNmpWQVR4UlpEdzNycGF6SVZ3V2JWdWRrN2tKQk93Z1BZMmp0S1B" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InMzNjBqZENuMXE2emhmRXRweGpGaFE9PSIsInZhbHVlIjoielpNQTdGTS9HTisyQmlZR2Y5azRyMWVTQjdSYWh2MVVhdEhPVFJXUnR2bHpTMW1pYllaRkhPSW5OcWVCcS93NDFVUE1SYTdaTEJBSVEyY3gwVEQrcmx6TVNxTEdHR1d1VG5WcnBWRWR5OEJOaS9qdUpMVUhMNzdZb3BMSlNxdUsiLCJtYWMiOiJhYzZhNTVmZGViYWRiOTQ4NDY0OGE2MTI0ZmExOTczNzZjOGViOTQ0NGVhZGUxODI5MTU1ODM2NDNjM2ZjYWRkIiwidGFnIjoiIn0%3D; expires=Thu, 20-Feb-2025 14:58:48 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InMzNjBqZENuMXE2emhmRXRweGpGaFE9PSIsInZhbHVlIjoielpNQTdGTS9HTisyQmlZR2Y5azRyMWVTQjdSYWh2MVVhdEhPVFJXUnR2bHpTMW1pYllaRkhPSW5OcWVCcS93NDFVUE1SY" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImV2Wlh4Zy9oVmFqWFE3aG9MZ1lrR2c9PSIsInZhbHVlIjoiOHBSUnAvazYxcXpoSk9VbXNvNmpWQVR4UlpEdzNycGF6SVZ3V2JWdWRrN2tKQk93Z1BZMmp0S1BXVkhQUnNxR0RvTjNGQXpZSW52QnZwUU01eDlBUGlMMzdwK3dsVHQwa0c3c2VqMDRrWkNBVFNhQmVhbTlDS0E3ZjQreFMvdjUiLCJtYWMiOiIyZGE0MzUxMTNhNjkzYjNkNzkxMTYzOTRiYjJkODg4MmQ3OTY1ZDFlYWYxMzI3ODkwYTRjNDAwZDYxMGMyNGJlIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6ImV2Wlh4Zy9oVmFqWFE3aG9MZ1lrR2c9PSIsInZhbHVlIjoiOHBSUnAvazYxcXpoSk9VbXNvNmpWQVR4UlpEdzNycGF6SVZ3V2JWdWRrN2tKQk93Z1BZMmp0S1B" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "4KhU5Vigjxi5sAMmliCJ1GacVV4lkqyhyYNwozt7" "uc_cart_id" => "563df81ad2bc11ee88bf3857f83f7a1c" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/111713" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-18 02:58:48GET/article/111713414321