Generic placeholder image

Current Diabetes Reviews

Editor-in-Chief

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

Systematic Review Article

Comparing the Efficacy of Supervised and Unsupervised Exercise Training on Glycaemic Control in Type 2 Diabetes: A Systematic Review

Author(s): Trishan Gajanand, Shelley E. Keating, Wendy J. Brown, Matthew D. Hordern, Robert G. Fassett and Jeff S. Coombes*

Volume 16, Issue 6, 2020

Page: [570 - 579] Pages: 10

DOI: 10.2174/1573399815666190212120404

Price: $65

Abstract

Background: Exercise training is vital for glycaemic control in patients with type 2 diabetes mellitus (T2D). While the positive effects of supervised exercise training are well established, unsupervised training may offer an alternative and more sustainable means of realising the benefits of exercise away from a resource-heavy supervised setting.

Objective: To evaluate the available literature and compare the efficacy of supervised and unsupervised exercise training programs on glycemic control in patients with T2D.

Methods: CINAHL, MEDLINE, PubMed, and EMBASE, searched from inception to 20 July 2018. Only studies that included both supervised and unsupervised training were included.

Results: Four studies, involving 115 participants, were included. One compared supervised with unsupervised exercise training and three investigated the efficacy of unsupervised training following supervised training. While supervised training is effective for improving glycaemic control in patients with T2D, unsupervised training may not maintain these changes. Included studies lacked detail relating to the supervised and unsupervised training programs.

Conclusions: Given that exercise is a critical component for maintenance of glycaemic control in patients with T2D, and because unsupervised training has been shown to be effective in improving clinical outcomes in other disease populations, further research is warranted to compare supervised and unsupervised exercise training in patients with T2D. It is important that future studies report standardised and detailed descriptions of key elements that form the basis of supervised and unsupervised exercise training groups.

Keywords: Diabetes mellitus, Type 2, glycated hemoglobin A, exercise, resistance training, practice guideline.

[1]
Zimmet P, Alberti KGMM, Shaw J. Global and societal implications of the diabetes epidemic. Nature 2001; 414(6865): 782-7.
[http://dx.doi.org/10.1038/414782a] [PMID: 11742409]
[2]
Wild S, Roglic G, Green A, Sicree R, King H. Global prevalence of diabetes: estimates for the year 2000 and projections for 2030. Diabetes Care 2004; 27(5): 1047-53.
[http://dx.doi.org/10.2337/diacare.27.5.1047] [PMID: 15111519]
[3]
Sladek R, Rocheleau G, Rung J, et al. A genome-wide association study identifies novel risk loci for type 2 diabetes. Nature 2007; 445(7130): 881-5.
[http://dx.doi.org/10.1038/nature05616] [PMID: 17293876]
[4]
Solomon TP, Thyfault JP. Type 2 diabetes sits in a chair. Diabetes Obes Metab 2013; 15(11): 987-92.
[http://dx.doi.org/10.1111/dom.12105] [PMID: 23551885]
[5]
Cho NH, Shaw JE, Karuranga S, et al. IDF Diabetes Atlas: Global estimates of diabetes prevalence for 2017 and projections for 2045. Diabetes Res Clin Pract 2018; 138: 271-81.
[http://dx.doi.org/10.1016/j.diabres.2018.02.023] [PMID: 29496507]
[6]
[7]
Lee CM, Colagiuri R, Magliano DJ, et al. The cost of diabetes in adults in Australia. Diabetes Res Clin Pract 2013; 99(3): 385-90.
[http://dx.doi.org/10.1016/j.diabres.2012.12.002] [PMID: 23298663]
[8]
Colberg SR, Albright AL, Blissmer BJ, et al. American College of Sports Medicine.American Diabetes Association.Exercise and type 2 diabetes: American College of Sports Medicine and the American Diabetes Association: joint position statement. Exercise and type 2 diabetes. Med Sci Sports Exerc 2010; 42(12): 2282-303.
[http://dx.doi.org/10.1249/MSS.0b013e3181eeb61c] [PMID: 21084931]
[9]
Pfeiffer AFH, Klein HH. The treatment of type 2 diabetes. Dtsch Arztebl Int 2014; 111(5): 69-81.
[PMID: 24612534]
[10]
De Feo P, Schwarz P. Is physical exercise a core therapeutical element for most patients with type 2 diabetes? Diabetes Care 2013; 36(Suppl. 2): S149-54.
[http://dx.doi.org/10.2337/dcS13-2024] [PMID: 23882040]
[11]
Caspersen CJ, Powell KE, Christenson GM. Physical activity, exercise, and physical fitness: definitions and distinctions for health-related research. Public Health Rep 1985; 100(2): 126-31.
[PMID: 3920711]
[12]
O’Hagan C, De Vito G, Boreham CA. Exercise prescription in the treatment of type 2 diabetes mellitus : current practices, existing guidelines and future directions. Sports Med 2013; 43(1): 39-49.
[http://dx.doi.org/10.1007/s40279-012-0004-y] [PMID: 23315755]
[13]
Dixit S, Maiya A, Shastry B. Effect of aerobic exercise on quality of life in population with diabetic peripheral neuropathy in type 2 diabetes: a single blind, randomized controlled trial. Qual Life Res 2014; 23(5): 1629-40.
[http://dx.doi.org/10.1007/s11136-013-0602-7] [PMID: 24326731]
[14]
Daly RM, Dunstan DW, Owen N, Jolley D, Shaw JE, Zimmet PZ. Does high-intensity resistance training maintain bone mass during moderate weight loss in older overweight adults with type 2 diabetes? Osteoporos Int 2005; 16(12): 1703-12.
[http://dx.doi.org/10.1007/s00198-005-1906-4] [PMID: 15937634]
[15]
Dobrosielski DA, Gibbs BB, Ouyang P, et al. Effect of exercise on blood pressure in type 2 diabetes: a randomized controlled trial. J Gen Intern Med 2012; 27(11): 1453-9.
[http://dx.doi.org/10.1007/s11606-012-2103-8] [PMID: 22610907]
[16]
Morrato EH, Hill JO, Wyatt HR, Ghushchyan V, Sullivan PW. Physical activity in U.S. adults with diabetes and at risk for developing diabetes, 2003. Diabetes Care 2007; 30(2): 203-9.
[http://dx.doi.org/10.2337/dc06-1128] [PMID: 17259482]
[17]
Thomas N, Alder E, Leese GP. Barriers to physical activity in patients with diabetes. Postgrad Med J 2004; 80(943): 287-91.
[http://dx.doi.org/10.1136/pgmj.2003.010553] [PMID: 15138320]
[18]
Jelleyman C, Yates T, O’Donovan G, et al. The effects of high-intensity interval training on glucose regulation and insulin resistance: a meta-analysis. Obes Rev 2015; 16(11): 942-61.
[http://dx.doi.org/10.1111/obr.12317] [PMID: 26481101]
[19]
Oliveira C, Simões M, Carvalho J, Ribeiro J. Combined exercise for people with type 2 diabetes mellitus: a systematic review. Diabetes Res Clin Pract 2012; 98(2): 187-98.
[http://dx.doi.org/10.1016/j.diabres.2012.08.004] [PMID: 22981711]
[20]
Umpierre D, Ribeiro PA, Kramer CK, et al. Physical activity advice only or structured exercise training and association with HbA1c levels in type 2 diabetes: a systematic review and meta-analysis. JAMA 2011; 305(17): 1790-9.
[http://dx.doi.org/10.1001/jama.2011.576] [PMID: 21540423]
[21]
Umpierre D, Ribeiro PA, Schaan BD, Ribeiro JP. Volume of supervised exercise training impacts glycaemic control in patients with type 2 diabetes: a systematic review with meta-regression analysis. Diabetologia 2013; 56(2): 242-51.
[http://dx.doi.org/10.1007/s00125-012-2774-z] [PMID: 23160642]
[22]
Yang Z, Scott CA, Mao C, Tang J, Farmer AJ. Resistance exercise versus aerobic exercise for type 2 diabetes: a systematic review and meta-analysis. Sports Med 2014; 44(4): 487-99.
[http://dx.doi.org/10.1007/s40279-013-0128-8] [PMID: 24297743]
[23]
Hayashino Y, Jackson JL, Fukumori N, Nakamura F, Fukuhara S. Effects of supervised exercise on lipid profiles and blood pressure control in people with type 2 diabetes mellitus: a meta-analysis of randomized controlled trials. Diabetes Res Clin Pract 2012; 98(3): 349-60.
[http://dx.doi.org/10.1016/j.diabres.2012.10.004] [PMID: 23116535]
[24]
Hayashino Y, Jackson JL, Hirata T, et al. Effects of exercise on C-reactive protein, inflammatory cytokine and adipokine in patients with type 2 diabetes: a meta-analysis of randomized controlled trials. Metabolism 2014; 63(3): 431-40.
[http://dx.doi.org/10.1016/j.metabol.2013.08.018] [PMID: 24355625]
[25]
Montero D, Walther G, Benamo E, Perez-Martin A, Vinet A. Effects of exercise training on arterial function in type 2 diabetes mellitus: a systematic review and meta-analysis. Sports Med 2013; 43(11): 1191-9.
[http://dx.doi.org/10.1007/s40279-013-0085-2] [PMID: 23912806]
[26]
van der Heijden MMP, van Dooren FEP, Pop VJM, Pouwer F. Effects of exercise training on quality of life, symptoms of depression, symptoms of anxiety and emotional well-being in type 2 diabetes mellitus: a systematic review. Diabetologia 2013; 56(6): 1210-25.
[http://dx.doi.org/10.1007/s00125-013-2871-7] [PMID: 23525683]
[27]
Egan AM, Mahmood WAW, Fenton R, et al. Barriers to exercise in obese patients with type 2 diabetes. QJM 2013; 106(7): 635-8.
[http://dx.doi.org/10.1093/qjmed/hct075] [PMID: 23525164]
[28]
Shultz JA, Sprague MA, Branen LJ, Lambeth S. A comparison of views of individuals with type 2 diabetes mellitus and diabetes educators about barriers to diet and exercise. J Health Commun 2001; 6(2): 99-115.
[http://dx.doi.org/10.1080/108107301750254457] [PMID: 11405082]
[29]
Dalal HM, Zawada A, Jolly K, Moxham T, Taylor RS. Home based versus centre based cardiac rehabilitation: Cochrane systematic review and meta-analysis. BMJ 2010; 340: b5631.
[http://dx.doi.org/10.1136/bmj.b5631] [PMID: 20085991]
[30]
Liberati A, Altman DG, Tetzlaff J, et al. The PRISMA statement for reporting systematic reviews and meta-analyses of studies that evaluate healthcare interventions: explanation and elaboration. BMJ 2009; 339: b2700.
[http://dx.doi.org/10.1136/bmj.b2700] [PMID: 19622552]
[31]
Higgins JPT, Altman DG, Gøtzsche PC, et al. Cochrane Bias Methods Group.Cochrane Statistical Methods Group.The Cochrane Collaboration’s tool for assessing risk of bias in randomised trials. BMJ 2011; 343: d5928.
[http://dx.doi.org/10.1136/bmj.d5928] [PMID: 22008217]
[32]
Mshunqane N, Cohen D, Kalk JK. Effects of an exercise pro-gramme on non-insulin dependant diabetes mellitus. S Afr J Physiother 2004; 60(4): 26-35.
[http://dx.doi.org/10.4102/sajp.v60i4.192]
[33]
Dunstan DW, Daly RM, Owen N, et al. Home-based resistance training is not sufficient to maintain improved glycemic control following supervised training in older individuals with type 2 diabetes. Diabetes Care 2005; 28(1): 3-9.
[http://dx.doi.org/10.2337/diacare.28.1.3] [PMID: 15616225]
[34]
Dunstan DW, Vulikh E, Owen N, Jolley D, Shaw J, Zimmet P. Community center-based resistance training for the maintenance of glycemic control in adults with type 2 diabetes. Diabetes Care 2006; 29(12): 2586-91.
[http://dx.doi.org/10.2337/dc06-1310] [PMID: 17130189]
[35]
Leehey DJ, Collins E, Kramer HJ, et al. Structured exercise in obese diabetic patients with chronic kidney disease: a randomized controlled trial. Am J Nephrol 2016; 44(1): 54-62.
[http://dx.doi.org/10.1159/000447703] [PMID: 27385652]
[36]
Boulé NG, Haddad E, Kenny GP, Wells GA, Sigal RJ. Effects of exercise on glycemic control and body mass in type 2 diabetes mellitus: a meta-analysis of controlled clinical trials. JAMA 2001; 286(10): 1218-27.
[http://dx.doi.org/10.1001/jama.286.10.1218] [PMID: 11559268]
[37]
Castaneda C, Layne JE, Munoz-Orians L, et al. A randomized controlled trial of resistance exercise training to improve glycemic control in older adults with type 2 diabetes. Diabetes Care 2002; 25(12): 2335-41.
[http://dx.doi.org/10.2337/diacare.25.12.2335] [PMID: 12453982]
[38]
Sigal RJ, Kenny GP, Boulé NG, et al. Effects of aerobic training, resistance training, or both on glycemic control in type 2 diabetes: a randomized trial. Ann Intern Med 2007; 147(6): 357-69.
[http://dx.doi.org/10.7326/0003-4819-147-6-200709180-00005] [PMID: 17876019]
[39]
Church TS, Blair SN, Cocreham S, et al. Effects of aerobic and resistance training on hemoglobin A1c levels in patients with type 2 diabetes: a randomized controlled trial. JAMA 2010; 304(20): 2253-62.
[http://dx.doi.org/10.1001/jama.2010.1710] [PMID: 21098771]
[40]
Mitranun W, Deerochanawong C, Tanaka H, Suksom D. Continuous vs interval training on glycemic control and macro- and microvascular reactivity in type 2 diabetic patients. Scand J Med Sci Sports 2014; 24(2): e69-76.
[http://dx.doi.org/10.1111/sms.12112] [PMID: 24102912]
[41]
Hollekim-Strand SM, Bjørgaas MR, Albrektsen G, Tjønna AE, Wisløff U, Ingul CB. High-intensity interval exercise effectively improves cardiac function in patients with type 2 diabetes mellitus and diastolic dysfunction: a randomized controlled trial. J Am Coll Cardiol 2014; 64(16): 1758-60.
[http://dx.doi.org/10.1016/j.jacc.2014.07.971] [PMID: 25323267]
[42]
Madsen SM, Thorup AC, Overgaard K, Jeppesen PB. High intensity interval training improves glycaemic control and pancreatic β cell function of type 2 diabetes patients. PLoS One 2015; 10(8)e0133286
[http://dx.doi.org/10.1371/journal.pone.0133286] [PMID: 26258597]
[43]
Hamasaki H. Interval exercise therapy for type 2 diabetes. Curr Diabetes Rev 2018; 14(2): 129-37.
[http://dx.doi.org/10.2174/1573399812666161101103655] [PMID: 27804850]
[44]
Lee SF, Pei D, Chi MJ, Jeng C. An investigation and comparison of the effectiveness of different exercise programmes in improving glucose metabolism and pancreatic β cell function of type 2 diabetes patients. Int J Clin Pract 2015; 69(10): 1159-70.
[http://dx.doi.org/10.1111/ijcp.12679] [PMID: 26119968]
[45]
Dadgostar H, Firouzinezhad S, Ansari M, Younespour S, Mahmoudpour A, Khamseh ME. Supervised group-exercise therapy versus home-based exercise therapy: Their effects on Quality of Life and cardiovascular risk factors in women with type 2 diabetes. Diabetes Metab Syndr 2016; 10(2)(Suppl. 1): S30-6.
[http://dx.doi.org/10.1016/j.dsx.2016.01.016] [PMID: 26822461]
[46]
Alam S, Stolinski M, Pentecost C, et al. The effect of a six-month exercise program on very low-density lipoprotein apolipoprotein B secretion in type 2 diabetes. J Clin Endocrinol Metab 2004; 89(2): 688-94.
[http://dx.doi.org/10.1210/jc.2003-031036] [PMID: 14764782]
[47]
Labrunée M, Antoine D, Vergès B, Robin I, Casillas JM, Gremeaux V. Effects of a home-based rehabilitation program in obese type 2 diabetics. Ann Phys Rehabil Med 2012; 55(6): 415-29.
[http://dx.doi.org/10.1016/j.rehab.2012.06.001] [PMID: 22921557]
[48]
Olsen DB, Scheede-Bergdahl C, Reving D, Boushel R, Dela F. The effect of rowing on endothelial function and insulin action in healthy controls and in patients with type 2 diabetes. Scand J Med Sci Sports 2011; 21(3): 420-30.
[http://dx.doi.org/10.1111/j.1600-0838.2009.01012.x] [PMID: 20146753]
[49]
Plotnikoff RC, Eves N, Jung M, Sigal RJ, Padwal R, Karunamuni N. Multicomponent, home-based resistance training for obese adults with type 2 diabetes: a randomized controlled trial. Int J Obes 2010; 34(12): 1733-41.
[http://dx.doi.org/10.1038/ijo.2010.109] [PMID: 20531348]
[50]
Yang P, Oh P. Predicting aerobic fitness improvements after participation in a hybrid supervised and home-based exercise program in people with type 2 diabetes. Can J Diabetes 2013; 37(6): 388-93.
[http://dx.doi.org/10.1016/j.jcjd.2013.09.004] [PMID: 24321719]
[51]
Hordern MD, Dunstan DW, Prins JB, Baker MK, Singh MA, Coombes JS. Exercise prescription for patients with type 2 diabetes and pre-diabetes: a position statement from Exercise and Sport Science Australia. J Sci Med Sport 2012; 15(1): 25-31.
[http://dx.doi.org/10.1016/j.jsams.2011.04.005] [PMID: 21621458]
[52]
Francois ME, Baldi JC, Manning PJ, et al. ‘Exercise snacks’ before meals: a novel strategy to improve glycaemic control in individuals with insulin resistance. Diabetologia 2014; 57(7): 1437-45.
[http://dx.doi.org/10.1007/s00125-014-3244-6] [PMID: 24817675]
[53]
Slade SC, Dionne CE, Underwood M, et al. Consensus on exercise reporting template (cert): modified delphi study. Phys Ther 2016; 96(10): 1514-24.
[http://dx.doi.org/10.2522/ptj.20150668] [PMID: 27149962]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version436msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[21:53:33] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[21:53:33] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[21:53:33] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (141ms)time
  • Application (295ms)time
  • 1 x Application (67.73%)
    295ms
    1 x Booting (32.27%)
    141ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated198ms
    • 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 ('316574772','',1,1740347613,1740347613) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740347613
      940μsalphaeurekaselec_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 ('316574772','/article/96582',1,1740347613,1740347613)
      140μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) 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 >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) 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 >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) 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 >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) 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 >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) 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 >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) limit 1
      15.05msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316574772
      • 1: 316574772
      • 2: 316574772
      • 3: 316574772
      • 4: 316574772
      • 5: 316574772
      • 6: 316574772
      • 7: 316574772
      • 8: 316574772
      • 9: 316574772
      • 10: 316574772
      • 11: 316574772
      • 12: 316574772
      • 13: 316574772
      • 14: 316574772
      • 15: 316574772
      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=96582
      670μ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
      810μsalphaeurekaselec_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.19msalphaeurekaselec_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
      990μ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=10) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      5.36msalphaeurekaselec_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.5msalphaeurekaselec_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` = '96582'
      300μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 96582
      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` = '96582'
      1.69msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 96582
      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` = '96582' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.24msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 96582
      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
      350μ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
      710μ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
      55.69msalphaeurekaselec_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
      16.02msalphaeurekaselec_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
      10.25msalphaeurekaselec_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` = 96582 limit 1
      280μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 96582
      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 = 96582 and content_type = 'article' order by status desc limit 1
      390μ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!=96582 and cd.content_type = 'article' order by rand() limit 20
      54.16msalphaeurekaselec_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` = 169906 limit 1
      240μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 169906
      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
      220μ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
      300μ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 = '96582' 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 count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '9860' and content_type = 'i' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      310μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '2714' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      270μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2231
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1740347613 and j.to_date >= 1740347613 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2714) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1740347613 and j.to_date >= 1740347613 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2714) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1740347613 and j.to_date >= 1740347613 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2714)
      14.41msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2272
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1740347613 and j.to_date >= 1740347613 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9860) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1740347613 and j.to_date >= 1740347613 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9860) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1740347613 and j.to_date >= 1740347613 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9860)
      630μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2297
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1740347613 and j.to_date >= 1740347613 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96582) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1740347613 and j.to_date >= 1740347613 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96582) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1740347613 and j.to_date >= 1740347613 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96582)
      540μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2329
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `article` where `first_page` < '570' and is_uploaded = 1 and issue_id = 9860 order by cast(first_page as SIGNED) desc limit 1
      470μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 570
      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` > '579' and is_uploaded = 1 and issue_id = 9860 order by cast(first_page as SIGNED) asc limit 1
      450μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 579
      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'
      180μ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
      270μ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` = 96582 limit 1
      2.5msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 96582
      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` <= 1740347613 and `b`.`banner_to_date` >= 1740347613 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.31msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 10
      • 3: 1740347613
      • 4: 1740347613
      • 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` <= 1740347613 and `b`.`banner_to_date` >= 1740347613 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.67msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 10
      • 3: 1740347613
      • 4: 1740347613
      • 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='7e0f835c990abeec82d0da7505697328'
      300μ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
        yfMXSeckmKTI6E1z2bQ3iFSTNc6iLlRw23OOHP8F
        uc_cart_id
        7e0f835c990abeec82d0da7505697328
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/96582" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/96582
        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 => "Sun, 23 Feb 2025 21:53:33 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InFRRDJYTHNIRjBQR1lhR0NqcGFBRUE9PSIsInZhbHVlIjoiTlo2QUpiNW5EcHRjRXdhZHdla2lvN3BxVXlSYzhQUlltNlRhTVQ2MVZtbkU3MmV3bFBvcEJZaTd6MnBINHpURGJGNFlNdzV1ejVvS0ErMGlxSmp5VmdkZUhFZFE0MVhrNVRjV2Y1Q2JxT09Ha1l3VDlkSUJ1N1plV0ZYNXBobEciLCJtYWMiOiJlNGFjMGNlODk3NzczZjBjNWEyMDIzNjBjYjg2MmIzNGEwYTEzOWExYzIzYTczYzYyOWJmNzE4MWE4MzhkNGZiIiwidGFnIjoiIn0%3D; expires=Wed, 26 Feb 2025 09:53:33 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InFRRDJYTHNIRjBQR1lhR0NqcGFBRUE9PSIsInZhbHVlIjoiTlo2QUpiNW5EcHRjRXdhZHdla2lvN3BxVXlSYzhQUlltNlRhTVQ2MVZtbkU3MmV3bFBvcEJZaTd6MnBINHpURGJGNFlNd" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkpqZ1MzUEliNmtqRWhiMDZJZmhhUVE9PSIsInZhbHVlIjoiTHNPUGV0TW9vZ2M1a3VxQjZXNmVvcXBHQWs3M0JLSHREZTRVTjg2Tk9mSTNQMkRFSkg5VDl1bnJoSk9IWExyY0Y3aGl4NWRXY0RzYkZPRmZFQjBFUVBHdURMT2lEVkxzVjl2MTJReDdlMXd6cnBja1R4cTUwSVFwVTRxbVNOUkQiLCJtYWMiOiI5N2NjMzUwOGFmMGY4ZTBkNDVlYzAyZWI1OGUxYjJjZGM0ODBmZjUzZTY1YWMwZTEyYTZhMDE3YjllYTZiODFkIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkpqZ1MzUEliNmtqRWhiMDZJZmhhUVE9PSIsInZhbHVlIjoiTHNPUGV0TW9vZ2M1a3VxQjZXNmVvcXBHQWs3M0JLSHREZTRVTjg2Tk9mSTNQMkRFSkg5VDl1bnJ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InFRRDJYTHNIRjBQR1lhR0NqcGFBRUE9PSIsInZhbHVlIjoiTlo2QUpiNW5EcHRjRXdhZHdla2lvN3BxVXlSYzhQUlltNlRhTVQ2MVZtbkU3MmV3bFBvcEJZaTd6MnBINHpURGJGNFlNdzV1ejVvS0ErMGlxSmp5VmdkZUhFZFE0MVhrNVRjV2Y1Q2JxT09Ha1l3VDlkSUJ1N1plV0ZYNXBobEciLCJtYWMiOiJlNGFjMGNlODk3NzczZjBjNWEyMDIzNjBjYjg2MmIzNGEwYTEzOWExYzIzYTczYzYyOWJmNzE4MWE4MzhkNGZiIiwidGFnIjoiIn0%3D; expires=Wed, 26-Feb-2025 09:53:33 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InFRRDJYTHNIRjBQR1lhR0NqcGFBRUE9PSIsInZhbHVlIjoiTlo2QUpiNW5EcHRjRXdhZHdla2lvN3BxVXlSYzhQUlltNlRhTVQ2MVZtbkU3MmV3bFBvcEJZaTd6MnBINHpURGJGNFlNd" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkpqZ1MzUEliNmtqRWhiMDZJZmhhUVE9PSIsInZhbHVlIjoiTHNPUGV0TW9vZ2M1a3VxQjZXNmVvcXBHQWs3M0JLSHREZTRVTjg2Tk9mSTNQMkRFSkg5VDl1bnJoSk9IWExyY0Y3aGl4NWRXY0RzYkZPRmZFQjBFUVBHdURMT2lEVkxzVjl2MTJReDdlMXd6cnBja1R4cTUwSVFwVTRxbVNOUkQiLCJtYWMiOiI5N2NjMzUwOGFmMGY4ZTBkNDVlYzAyZWI1OGUxYjJjZGM0ODBmZjUzZTY1YWMwZTEyYTZhMDE3YjllYTZiODFkIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkpqZ1MzUEliNmtqRWhiMDZJZmhhUVE9PSIsInZhbHVlIjoiTHNPUGV0TW9vZ2M1a3VxQjZXNmVvcXBHQWs3M0JLSHREZTRVTjg2Tk9mSTNQMkRFSkg5VDl1bnJ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "yfMXSeckmKTI6E1z2bQ3iFSTNc6iLlRw23OOHP8F" "uc_cart_id" => "7e0f835c990abeec82d0da7505697328" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/96582" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-23 21:53:33GET/article/96582314371