Generic placeholder image

当代阿耳茨海默病研究

Editor-in-Chief

ISSN (Print): 1567-2050
ISSN (Online): 1875-5828

Research Article

中性粒细胞-淋巴细胞比率与中国老年人轻度认知障碍的关系:病例对照研究

卷 16, 期 14, 2019

页: [1309 - 1315] 页: 7

弟呕挨: 10.2174/1567205017666200103110521

价格: $65

摘要

背景:在先前的研究中,炎症在认知障碍的病理生理中起着重要作用。中性粒细胞-淋巴细胞比率(NLR)是系统性炎症的可靠指标。 目的:本研究旨在探讨NLR与轻度认知障碍(MCI)之间的关联,并进一步探索NLR炎症标志物对中国老年人MCI的诊断潜力。 方法:本研究连续评估了186名MCI受试者和153名认知功能正常的受试者。在空腹血样中测量中性粒细胞(NEUT)计数和淋巴细胞(LYM)计数。通过将绝对NEUT计数除以绝对LYM计数来计算NLR。多变量logistic回归用于评估NLR和MCI之间的潜在关联。使用接收器工作特性(ROC)曲线分析对用于预测MCI的NLR进行了分析。 结果:MCI组的NLR明显高于具有正常认知功能的受试者的NLR(2.39×0.55对1.94×0.51,P <0.001)。 Logistic回归分析显示,较高的NLR是MCI的独立危险因素(OR:4.549,95%CI:2.623-7.889,P <0.001)。 ROC分析表明,MCI的最佳NLR截止点为2.07,敏感性为73.66%,特异性为69.28%,阳性预测值(PPV)为74.48%,阴性预测值(NPV)为68.36%。相对于NLR <2.07,NLR≥2.07的受试者表现出更高的风险(或:5.933,95%CI:3.467-10.155,P <0.001)。 结论:NLR升高与MCI风险增加显着相关。特别是,高于2.07阈值的NLR水平与MCI的可能性显着相关。

关键词: 中性粒细胞-淋巴细胞比率,轻度认知障碍,全身性炎症,临界值,老年人,病例对照研究。

[1]
Rubenstein E, Hartley S, Bishop L. Epidemiology of dementia and Alzheimer disease in individuals with down syndrome. JAMA Neurol 2019.
[http://dx.doi.org/10.1001/jamaneurol.2019.3666] [PMID: 31657825]
[2]
Sanford AM. Mild cognitive impairment. Clin Geriatr Med 33(3): 325-37. (2017)
[http://dx.doi.org/10.1016/j.cger.2017.02.005] [PMID: 28689566]
[3]
Behrman S, Valkanova V, Allan CL. Diagnosing and managing mild cognitive impairment 261(1804): 17-20. (2017)
[4]
Alzheimer’s Association. 2015 Alzheimer’s disease facts and figures. Alzheimers Dement 11(3): 332-84. (2015)
[http://dx.doi.org/10.1016/j.jalz.2015.02.003] [PMID: 25984581]
[5]
Morris JC. Revised criteria for mild cognitive impairment may compromise the diagnosis of Alzheimer disease dementia. Arch Neurol 69(6): 700-8. (2012)
[http://dx.doi.org/10.1001/archneurol.2011.3152] [PMID: 22312163]
[6]
Bettcher BM, Fitch R, Wynn MJ, Lalli MA, Elofson J, Jastrzab L, et al. MCP-1 and eotaxin-1 selectively and negatively associate with memory in MCI and Alzheimer’s disease dementia phenotypes. Alzheimers Dement (Amst) 3: 91-7. (2016)
[http://dx.doi.org/10.1016/j.dadm.2016.05.004] [PMID: 27453930]
[7]
Moyse E, Haddad M, Benlabiod C, Ramassamy C, Krantic S. Common pathological mechanisms and risk factors for Alzheimer’s disease and type-2 diabetes: focus on inflammation. Curr Alzheimer Res 2019; 16(11): 986-1006.
[http://dx.doi.org/10.2174/1567205016666191106094356] [PMID: 31692443]
[8]
Lathe R, Sapronova A, Kotelevtsev Y. Atherosclerosis and Alzheimer--diseases with a common cause? Inflammation, oxysterols, vasculature. BMC Geriatr 14: 36. (2014)
[http://dx.doi.org/10.1186/1471-2318-14-36] [PMID: 24656052]
[9]
de Oliveira FF, de Almeida SS, Chen ES, Smith MC, Naffah-Mazzacoratti MDG, Bertolucci PHF. Lifetime risk factors for functional and cognitive outcomes in patients with Alzheimer’s disease. J Alzheimers Dis 65(4): 1283-99. (2018)
[http://dx.doi.org/10.3233/JAD-180303] [PMID: 30149448]
[10]
Paouri E, Georgopoulos S. Systemic and CNS inflammation crosstalk: implications for Alzheimer’s disease. Curr Alzheimer Res 16(6): 559-74. (2019)
[http://dx.doi.org/10.2174/1567205016666190321154618] [PMID: 30907316]
[11]
Magalhães CA, Ferreira CN, Loures CMG, Fraga VG, Chaves AC, Oliveira ACR, et al. Leptin, hsCRP, TNF-α and IL-6 levels from normal aging to dementia: relationship with cognitive and functional status. J Clin Neurosci 56: 150-5. (2018)
[http://dx.doi.org/10.1016/j.jocn.2018.08.027] [PMID: 30150062]
[12]
Heneka MT, Carson MJ, El Khoury J, Landreth GE, Brosseron F, Feinstein DL, et al. Neuroinflammation in Alzheimer’s disease. Lancet Neurol 14(4): 388-405. (2015)
[http://dx.doi.org/10.1016/S1474-4422(15)70016-5] [PMID: 25792098]
[13]
Bettcher BM, Kramer JH. Inflammation and clinical presentation in neurodegenerative disease: a volatile relationship. Neurocase 19(2): 182-200. (2013)
[http://dx.doi.org/10.1080/13554794.2011.654227] [PMID: 22515699]
[14]
Popp J, Oikonomidi A, Tautvydaitė D, Dayon L, Bacher M, Migliavacca E, et al. Markers of neuroinflammation associated with Alzheimer’s disease pathology in older adults. Brain Behav Immun 62: 203-11. (2017)
[http://dx.doi.org/10.1016/j.bbi.2017.01.020] [PMID: 28161476]
[15]
Kuyumcu ME, Yesil Y, Oztürk ZA, Kizilarslanoğlu C, Etgül S, Halil M, et al. The evaluation of neutrophil-lymphocyte ratio in Alzheimer’s disease. Dement Geriatr Cogn Disord 34(2): 69-74. (2012)
[http://dx.doi.org/10.1159/000341583] [PMID: 22922667]
[16]
Halazun HJ, Mergeche JL, Mallon KA, Connolly ES, Heyer EJ. Neutrophil-lymphocyte ratio as a predictor of cognitive dysfunction in carotid endarterectomy patients. J Vasc Surg 59(3): 768-73. (2014)
[http://dx.doi.org/10.1016/j.jvs.2013.08.095] [PMID: 24571940]
[17]
Malhotra K, Goyal N, Chang JJ, Broce M, Pandhi A, Kerro A, et al. Differential leukocyte counts on admission predict outcomes in patients with acute ischaemic stroke treated with intravenous thrombolysis. Eur J Neurol 25(12): 1417-24. (2018)
[http://dx.doi.org/10.1111/ene.13741] [PMID: 29953701]
[18]
Zhang J, Ren Q, Song Y, He M, Zeng Y, Liu Z, et al. Prognostic role of neutrophil-lymphocyte ratio in patients with acute ischemic stroke. Medicine (Baltimore) 96(45) e8624 (2017)
[http://dx.doi.org/10.1097/MD.0000000000008624] [PMID: 29137097]
[19]
Petersen RC. Mild cognitive impairment as a diagnostic entity. J Intern Med 256(3): 183-94. (2004)
[http://dx.doi.org/10.1111/j.1365-2796.2004.01388.x] [PMID: 15324362]
[20]
Ritchie K, Artero S, Touchon J. Classification criteria for mild cognitive impairment: a population-based validation study. Neurology 56(1): 37-42. (2001)
[http://dx.doi.org/10.1212/WNL.56.1.37] [PMID: 11148233]
[21]
Perneczky R, Pohl C, Sorg C, Hartmann J, Komossa K, Alexopoulos P, et al. Complex activities of daily living in mild cognitive impairment: conceptual and diagnostic issues. Age Ageing 35(3): 240-5. (2006)
[http://dx.doi.org/10.1093/ageing/afj054] [PMID: 16513677]
[22]
Biggerstaff BJ. Comparing diagnostic tests: a simple graphic using likelihood ratios. Stat Med 19(5): 649-63. (2000)
[http://dx.doi.org/10.1002/(SICI)1097-0258(20000315)19:5<649:AID-SIM371>3.0.CO;2-H] [PMID: 10700737]
[23]
Lopez OL, Chang Y, Ives DG, Snitz BE, Fitzpatrick AL, Carlson MC, et al. Blood amyloid levels and risk of dementia in the Ginkgo Evaluation of Memory Study (GEMS): a longitudinal analysis. Alzheimers Dement 15(8): 1029-38. (2019)
[http://dx.doi.org/10.1016/j.jalz.2019.04.008] [PMID: 31255494]
[24]
Wang J, Qiao F, Shang S, Li P, Chen C, Dang L, et al. Elevation of plasma amyloid-β level is more significant in early stage of cognitive impairment: a population-based cross-sectional study. J Alzheimers Dis 64(1): 61-9. (2018)
[http://dx.doi.org/10.3233/JAD-180140] [PMID: 29865072]
[25]
Hilal S, Wolters FJ, Verbeek MM, Vanderstichele H, Ikram MK, Stoops E, et al. Plasma amyloid-β levels, cerebral atrophy and risk of dementia: a population-based study. Alzheimers Res Ther 10(1): 63. (2018)
[http://dx.doi.org/10.1186/s13195-018-0395-6] [PMID: 29960604]
[26]
Cervellati C, Trentini A, Bosi C, Valacchi G, Morieri ML, Zurlo A, et al. Low-grade systemic inflammation is associated with functional disability in elderly people affected by dementia. Geroscience 40(1): 61-9. (2018)
[http://dx.doi.org/10.1007/s11357-018-0010-6] [PMID: 29428983]
[27]
van Harten AE, Scheeren TW, Absalom AR. A review of postoperative cognitive dysfunction and neuroinflammation associated with cardiac surgery and anaesthesia. Anaesthesia 67(3): 280-93. (2012)
[http://dx.doi.org/10.1111/j.1365-2044.2011.07008.x] [PMID: 22321085]
[28]
Ohtani R, Nirengi S, Nakamura M, Murase N, Sainouchi M, Kuwata Y, et al. High-Density lipoprotein subclasses and mild cognitive impairment: study of outcome and apolipoproteins in dementia (STOP-Dementia)1. J Alzheimers Dis 66(1): 289-96. (2018)
[http://dx.doi.org/10.3233/JAD-180135] [PMID: 30248050]
[29]
Rembach A, Watt AD, Wilson WJ, Rainey-Smith S, Ellis KA, Rowe CC, et al. AIBL Research Group. An increased neutrophil-lymphocyte ratio in Alzheimer’s disease is a function of age and is weakly correlated with neocortical amyloid accumulation. J Neuroimmunol 273(1-2): 65-71. (2014)
[http://dx.doi.org/10.1016/j.jneuroim.2014.05.005] [PMID: 24907904]
[30]
Arima Y, Kamimura D, Sabharwal L, Yamada M, Bando H, Ogura H, et al. Regulation of immune cell infiltration into the CNS by regional neural inputs explained by the gate theory. Mediators Inflamm 2013 898165 (2013)
[http://dx.doi.org/10.1155/2013/898165] [PMID: 23990699]
[31]
Baruch K, Deczkowska A, David E, Castellano JM, Miller O, Kertser A, et al. Aging. Aging-induced type I interferon response at the choroid plexus negatively affects brain function. Science 346(6205): 89-93. (2014)
[http://dx.doi.org/10.1126/science.1252945] [PMID: 25147279]
[32]
Louveau A, Smirnov I, Keyes TJ, Eccles JD, Rouhani SJ, Peske JD, et al. Structural and functional features of central nervous system lymphatic vessels. Nature 523(7560): 337-41. (2015)
[http://dx.doi.org/10.1038/nature14432] [PMID: 26030524]
[33]
Bu XL, Xiang Y, Jin WS, Wang J, Shen LL, Huang ZL, et al. Blood-derived amyloid-β protein induces Alzheimer’s disease pathologies. Mol Psychiatry 23(9): 1948-56. (2018)
[http://dx.doi.org/10.1038/mp.2017.204] [PMID: 29086767]
[34]
Wendeln AC, Degenhardt K, Kaurani L, Gertig M, Ulas T, Jain G, et al. Innate immune memory in the brain shapes neurological disease hallmarks. Nature 556(7701): 332-8. (2018)
[http://dx.doi.org/10.1038/s41586-018-0023-4] [PMID: 29643512]
[35]
Maitra U, Deng H, Glaros T, Baker B, Capelluto DG, Li Z, et al. Molecular mechanisms responsible for the selective and low-grade induction of proinflammatory mediators in murine macrophages by lipopolysaccharide. J Immunol 189(2): 1014-23. (2012)
[http://dx.doi.org/10.4049/jimmunol.1200857] [PMID: 22706082]
[36]
Colton CA, Mott RT, Sharpe H, Xu Q, Van Nostrand WE, Vitek MP. Expression profiles for macrophage alternative activation genes in AD and in mouse models of AD. J Neuroinflammation 3: 27. (2006)
[http://dx.doi.org/10.1186/1742-2094-3-27] [PMID: 17005052]
[37]
Kyrkanides S, Tallents RH, Miller JN, Olschowka ME, Johnson R, Yang M, et al. Osteoarthritis accelerates and exacerbates Alzheimer’s disease pathology in mice. J Neuroinflammation 8: 112. (2011)
[http://dx.doi.org/10.1186/1742-2094-8-112] [PMID: 21899735]
[38]
Ma F, Wu T, Zhao J, Ji L, Song A, Zhang M, et al. Plasma homocysteine and serum folate and vitamin b12 levels in mild cognitive impairment and Alzheimer’s disease: a case-control study. Nutrients 9(7): 725. (2017)
[http://dx.doi.org/10.3390/nu9070725] [PMID: 28698453]
[39]
Kim G, Kim H, Kim KN, Son JI, Kim SY, Tamura T, et al. Relationship of cognitive function with B vitamin status, homocysteine, and tissue factor pathway inhibitor in cognitively impaired elderly: a cross-sectional survey. J Alzheimers Dis 33(3): 853-62. (2013)
[http://dx.doi.org/10.3233/JAD-2012-121345] [PMID: 23042212]
[40]
Pierozan P, Biasibetti-Brendler H, Schmitz F, Ferreira F, Netto CA, Wyse ATS. synergistic toxicity of the neurometabolites quinolinic acid and homocysteine in cortical neurons and astrocytes: implications in Alzheimer’s disease. Neurotox Res 34(1): 147-63. (2018)
[http://dx.doi.org/10.1007/s12640-017-9834-6] [PMID: 29124681]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version328msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[02:52:14] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[02:52:14] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[02:52:14] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (96.4ms)time
  • Application (232ms)time
  • 1 x Application (70.64%)
    232ms
    1 x Booting (29.35%)
    96.40ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    41 statements were executed, 4 of which were duplicates, 37 unique. Show only duplicated156ms
    • 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 ('59694094','',1,1739847134,1739847134) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739847134
      910μ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 ('59694094','/article/103443/cn',1,1739847134,1739847134)
      640μ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 >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) 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 >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) 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 >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) 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 >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) 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 >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) 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 >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59694094 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59694094) limit 1
      12.46msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59694094
      • 1: 59694094
      • 2: 59694094
      • 3: 59694094
      • 4: 59694094
      • 5: 59694094
      • 6: 59694094
      • 7: 59694094
      • 8: 59694094
      • 9: 59694094
      • 10: 59694094
      • 11: 59694094
      • 12: 59694094
      • 13: 59694094
      • 14: 59694094
      • 15: 59694094
      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=103443
      720μ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` = 66 limit 1
      820μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 66
      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=66) and sj.journal_id!=66 group by `j`.`nid`) as `aggregate_table`
      780μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=66) and sj.journal_id!=66 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      650μ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=66) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      4.61msalphaeurekaselec_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=66) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      3.8msalphaeurekaselec_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` = '103443'
      290μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 103443
      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` = '103443'
      2.21msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 103443
      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` = '103443' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      910μsalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 103443
      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
      490μsalphaeurekaselec_live_10_06_2022Article.php#1960
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1960
      • 14. app/Http/Controllers/ArticleController.php:2062
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • Select j.subtitle, v.volume_id as volume_id,v.year_id,y.year as year,v.volume_name, v.total_no_of_issues, i.issue_id as issue_id,i.title as issue, i.publication_date as issue_pub_date from journal j join volume v on j.journal_id = v.journal_id join issue i on v.volume_id = i.volume_id join article a on a.issue_id = i.issue_id join year y on v.year_id = y.id where j.journal_id = 66 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      25.71msalphaeurekaselec_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 = 66 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      9.13msalphaeurekaselec_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 = 66 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      9.81msalphaeurekaselec_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` = 103443 limit 1
      300μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 103443
      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 = 103443 and content_type = 'article' order by status desc limit 1
      490μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 281 and cd.sub_disease_id = 518 and content_id!=103443 and cd.content_type = 'article' order by rand() limit 20
      52.83msalphaeurekaselec_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` = 178047 limit 1
      230μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 178047
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      210μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CAR' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      360μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CAR
      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 = '103443' 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) )
      360μ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 = '9631' 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) )
      260μ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 = '2542' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      250μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2231
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59694094 and j.to_ip >=59694094 )) and ((j.from_date <= 1739847134 and j.to_date >= 1739847134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2542) 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 <= 59694094 and j.to_ip >=59694094 )) and ((j.from_date <= 1739847134 and j.to_date >= 1739847134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2542) 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 <= 59694094 and j.to_ip >=59694094 )) and ((j.from_date <= 1739847134 and j.to_date >= 1739847134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2542)
      7.63msalphaeurekaselec_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 <= 59694094 and j.to_ip >=59694094 )) and ((j.from_date <= 1739847134 and j.to_date >= 1739847134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9631) 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 <= 59694094 and j.to_ip >=59694094 )) and ((j.from_date <= 1739847134 and j.to_date >= 1739847134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9631) 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 <= 59694094 and j.to_ip >=59694094 )) and ((j.from_date <= 1739847134 and j.to_date >= 1739847134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9631)
      620μ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 <= 59694094 and j.to_ip >=59694094 )) and ((j.from_date <= 1739847134 and j.to_date >= 1739847134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 103443) 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 <= 59694094 and j.to_ip >=59694094 )) and ((j.from_date <= 1739847134 and j.to_date >= 1739847134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 103443) 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 <= 59694094 and j.to_ip >=59694094 )) and ((j.from_date <= 1739847134 and j.to_date >= 1739847134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 103443)
      600μ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` < '1309' and is_uploaded = 1 and issue_id = 9631 order by cast(first_page as SIGNED) desc limit 1
      490μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 1309
      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` > '1315' and is_uploaded = 1 and issue_id = 9631 order by cast(first_page as SIGNED) asc limit 1
      460μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 1315
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'cn'
      200μsalphaeurekaselec_live_10_06_2022ArticleController.php#2486
      Bindings
      • 0: cn
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2486
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 2
      270μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 2
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2487
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `multilanguage_article` where (`language_id` = 2 and `article_id` = 103443)
      5.65msalphaeurekaselec_live_10_06_2022ArticleController.php#2488
      Bindings
      • 0: 2
      • 1: 103443
      Backtrace
      • 15. app/Http/Controllers/ArticleController.php:2488
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `keyword` from `multilanguage_keywords` where (`language_id` = 2 and `article_id` = 103443)
      2.52msalphaeurekaselec_live_10_06_2022ArticleController.php#2489
      Bindings
      • 0: 2
      • 1: 103443
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2489
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select CONCAT_WS(' ',au.first_name, ' ', ifnull(au.initials,''), ' ', au.last_name) as authors, CONCAT_WS(' ',au.last_name, ', ', ifnull(au.initials,''), ' ', au.first_name) as authorsRIS, CONCAT_WS(' ',au.last_name, ' ', ifnull(au.initials,''), ' ', au.first_name) as authorsCiteAs , `au`.*, (GROUP_CONCAT(TRIM(BOTH ', ' FROM CONCAT(ifnull(concat(af.institution,','),''), ifnull(concat(af.department,','),''), ifnull(concat(af.address,','),''), ifnull(concat(af.city,','),''), ifnull(concat(af.country,','),''), ifnull(concat(af.postal_code,','),''), ifnull(concat(af.phone,','),''), ifnull(concat(af.fax,','),''))) SEPARATOR '|')) as `author_affiliation`, (GROUP_CONCAT(TRIM(BOTH ', ' FROM CONCAT(ifnull(concat(af.web_view,','),''))) SEPARATOR '|')) as `web_view` from `multilanguage_authors` as `au` left join `multilanguage_author_affiliation` as `af` on `au`.`id` = `af`.`author_id` where `au`.`article_id` = 103443 group by `au`.`id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.66msalphaeurekaselec_live_10_06_2022MultiLangAuthor.php#30
      Bindings
      • 0: 103443
      Backtrace
      • 13. app/Models/MultiLangAuthor.php:30
      • 14. app/Http/Controllers/ArticleController.php:2493
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `multilanguage_journal`.`title` from `multilanguage_journal` where `multilanguage_journal`.`journal_id` = 66 and `language_id` = 2
      230μsalphaeurekaselec_live_10_06_2022ArticleController.php#2495
      Bindings
      • 0: 66
      • 1: 2
      Backtrace
      • 13. app/Http/Controllers/ArticleController.php:2495
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `id` from `multilanguage_article` where `article_id` = 103443 limit 1
      1.79msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 103443
      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` = 66 and `b`.`banner_from_date` <= 1739847134 and `b`.`banner_to_date` >= 1739847134 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.23msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 66
      • 3: 1739847134
      • 4: 1739847134
      • 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` = 66 and `b`.`banner_from_date` <= 1739847134 and `b`.`banner_to_date` >= 1739847134 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.13msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 66
      • 3: 1739847134
      • 4: 1739847134
      • 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='5be61622ebfad0581983bb4296fe65b4'
      220μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLangArticle
    2MultiLangArticle.php#?
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        6NSMxlppdu0POwzz03EMNFibtm3fGIwWNE4Vs35D
        uc_cart_id
        5be61622ebfad0581983bb4296fe65b4
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/103443/cn" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/103443/cn
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:9 [ "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6ImY0eVlUZko1Zmw3QUQ4VWFBdzNIb0E9PSIsInZhbHVlIjoieGNxbjAwS3hkeTVDYVFUUEY2R3BFRStJOGdwU1lGOGdhdVROUlg4R29DST0iLCJtYWMiOiIwN2E3NjliMDE5ZDQzMGVkYjVkYmFmZTQ1YTkwM2I1ZTA5YjMwNTQ4YzQwM2ExMWQyMGUzMThiMmM5MmY0YjA3IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6ImY0eVlUZko1Zmw3QUQ4VWFBdzNIb0E9PSIsInZhbHVlIjoieGNxbjAwS3hkeTVDYVFUUEY2R3BFRStJOGdwU1lGOGdhdVROUlg4R29DST0iLCJtYWMiOiIwN2E3NjliMDE5ZDQz" ] "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:52:14 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlpuQlk2QUo2dlEzc0ZEYk1lcXZCN0E9PSIsInZhbHVlIjoiL0UrbWs2NmJZUjdMSnhicWlycGNScXphRDE5R0c4T2dmZURta2V6NW9NTXNKdDFLS0d3U3pTZTFkWHFYQ0IxV3JBZ29GSTFMLzV3TlMxdWg4MUJZVDdXYzhNQlIrbUNEbVJmUzBpZEp6a1pXUXpYelBGWEhzMHhTUE5aWVVEWisiLCJtYWMiOiI0MGQ5OWM0OGIxMzc5YjZmZTdiMDgyNzRjNjk5ZTI4MDc5M2Q0MTlmMGViMDFjNzA4MTQxYjcwZjczOWIzMmQ1IiwidGFnIjoiIn0%3D; expires=Thu, 20 Feb 2025 14:52:14 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlpuQlk2QUo2dlEzc0ZEYk1lcXZCN0E9PSIsInZhbHVlIjoiL0UrbWs2NmJZUjdMSnhicWlycGNScXphRDE5R0c4T2dmZURta2V6NW9NTXNKdDFLS0d3U3pTZTFkWHFYQ0IxV3JBZ29GS" 1 => "alphaeurekaselectnet_session=eyJpdiI6InJzVml6cEFzWCsveUcxeVlXMjVuUnc9PSIsInZhbHVlIjoiRWdjZ3M4TUJxVjBHemdiKzVxcWw2d1dJZ0dkWHdMbVR2c0s1S1J4V2hiWG45WklvU1pBYjRmRVlZb2xuL1JTckNzRGdXOXV3WlpBVmptR0x4QktTbktnYUxPSXJFazR1bkMvdTIwM2pFMkVvYTZIRWp5QVZSaUp6Q1hlek43ZWciLCJtYWMiOiI0NmQxMmMzNmY0MDUzYjNiNDYyOTc4MmRlN2YxN2U3OTI4NWNkYjNmZDhkZDYwZjgzYjU3ZDQ4ZWU1YTZhMWM1IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6InJzVml6cEFzWCsveUcxeVlXMjVuUnc9PSIsInZhbHVlIjoiRWdjZ3M4TUJxVjBHemdiKzVxcWw2d1dJZ0dkWHdMbVR2c0s1S1J4V2hiWG45WklvU1pBYjRmRVl" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlpuQlk2QUo2dlEzc0ZEYk1lcXZCN0E9PSIsInZhbHVlIjoiL0UrbWs2NmJZUjdMSnhicWlycGNScXphRDE5R0c4T2dmZURta2V6NW9NTXNKdDFLS0d3U3pTZTFkWHFYQ0IxV3JBZ29GSTFMLzV3TlMxdWg4MUJZVDdXYzhNQlIrbUNEbVJmUzBpZEp6a1pXUXpYelBGWEhzMHhTUE5aWVVEWisiLCJtYWMiOiI0MGQ5OWM0OGIxMzc5YjZmZTdiMDgyNzRjNjk5ZTI4MDc5M2Q0MTlmMGViMDFjNzA4MTQxYjcwZjczOWIzMmQ1IiwidGFnIjoiIn0%3D; expires=Thu, 20-Feb-2025 14:52:14 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlpuQlk2QUo2dlEzc0ZEYk1lcXZCN0E9PSIsInZhbHVlIjoiL0UrbWs2NmJZUjdMSnhicWlycGNScXphRDE5R0c4T2dmZURta2V6NW9NTXNKdDFLS0d3U3pTZTFkWHFYQ0IxV3JBZ29GS" 1 => "alphaeurekaselectnet_session=eyJpdiI6InJzVml6cEFzWCsveUcxeVlXMjVuUnc9PSIsInZhbHVlIjoiRWdjZ3M4TUJxVjBHemdiKzVxcWw2d1dJZ0dkWHdMbVR2c0s1S1J4V2hiWG45WklvU1pBYjRmRVlZb2xuL1JTckNzRGdXOXV3WlpBVmptR0x4QktTbktnYUxPSXJFazR1bkMvdTIwM2pFMkVvYTZIRWp5QVZSaUp6Q1hlek43ZWciLCJtYWMiOiI0NmQxMmMzNmY0MDUzYjNiNDYyOTc4MmRlN2YxN2U3OTI4NWNkYjNmZDhkZDYwZjgzYjU3ZDQ4ZWU1YTZhMWM1IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6InJzVml6cEFzWCsveUcxeVlXMjVuUnc9PSIsInZhbHVlIjoiRWdjZ3M4TUJxVjBHemdiKzVxcWw2d1dJZ0dkWHdMbVR2c0s1S1J4V2hiWG45WklvU1pBYjRmRVl" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "6NSMxlppdu0POwzz03EMNFibtm3fGIwWNE4Vs35D" "uc_cart_id" => "5be61622ebfad0581983bb4296fe65b4" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/103443/cn" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-18 02:52:14GET/article/103443/cn314413