Systematic Review Article

The Association and Influencing Factors between Antipsychotics Exposure and the Risk of VTE and PE: A Systematic Review and Meta-analysis

Author(s): Luqi Dai, Qiunan Zuo, Fangying Chen, Lei Chen* and Yongchun Shen*

Volume 21, Issue 9, 2020

Page: [930 - 942] Pages: 13

DOI: 10.2174/1389450121666200422084414

Price: $65

Abstract

Background: Different clinical studies have given inconsistent results on whether the use of antipsychotics increases the risk of thromboembolism. In this paper, we reviewed all relevant literature to provide suggestions for clinical diagnosis and treatment.

Methods: PubMed, Web of Science, EMBASE, MEDLINE, Cochrane and Scopus databases were thoroughly searched up to June 2019. Two researchers independently searched the literature, extracted data. Data were analyzed by Stata 12.0 software.

Results: A total of 22 studies involving 31514226 subjects were included. This meta-analysis showed that patients taking the first- or second-generation antipsychotics had a higher risk of venous thromboembolism and pulmonary embolism than those who did not, and low potency first-generation agents increased the risk of venous thromboembolism more than high potency antipsychotics, and olanzapine, clozapine, haloperidol, perphenazine and risperidone also significantly increased the risk of it. The risk of venous thrombosis in obese people was higher than that in overweight people, patients not less than 65 years old had an increased risk compared with younger patients. In addition, women taking antipsychotics had a higher risk of pulmonary embolism than men.

Conclusion: The use of antipsychotics will increase the risk of venous thromboembolism and pulmonary embolism, which will be affected by the type of antipsychotics and patient characteristics.

Keywords: Antipsychotic drugs, venous thromboembolism, pulmonary embolism, systematic review, meta-analysis.

« Previous
Graphical Abstract

[1]
Alexopoulos GS, Streim J, Carpenter D, Docherty JP. Using antipsychotic agents in older patients. The Journal of clinical psychiatry 2004; 65(Suppl 2): 5-99 discussion 100-102; quiz 103-104
[2]
Kane JM, Leucht S, Carpenter D, Docherty JP. Expert Consensus Panel for Optimizing Pharmacologic Treatment of Psychotic Disorders. The expert consensus guideline series. Optimizing pharmacologic treatment of psychotic disorders. Introduction: methods, commentary, and summary. J Clin Psychiatry 2003; 64(Suppl. 12): 5-19.
[PMID: 14640142]
[3]
Stroup TS, Gray N. Management of common adverse effects of antipsychotic medications. World Psychiatry 2018; 17(3): 341-56.
[http://dx.doi.org/10.1002/wps.20567] [PMID: 30192094]
[4]
Lapeyre-Mestre M. A Review of Adverse Outcomes Associated with Psychoactive Drug Use in Nursing Home Residents with Dementia. Drugs Aging 2016; 33(12): 865-88.
[http://dx.doi.org/10.1007/s40266-016-0414-x] [PMID: 27812994]
[5]
Mahan CE, Borrego ME, Woersching AL, et al. Venous thromboembolism: annualised United States models for total, hospital-acquired and preventable costs utilising long-term attack rates. Thromb Haemost 2012; 108(2): 291-302.
[PMID: 22739656]
[6]
White RH. The epidemiology of venous thromboembolism. Circulation 2003; 107(23)(Suppl. 1): I4-8.
[PMID: 12814979]
[7]
Rosendaal FR. Venous thrombosis: a multicausal disease. Lancet 1999; 353(9159): 1167-73.
[http://dx.doi.org/10.1016/S0140-6736(98)10266-0] [PMID: 10209995]
[8]
Nielsen JD. The incidence of pulmonary embolism during deep vein thrombosis. Phlebology 2013; 28(Suppl. 1): 29-33.
[http://dx.doi.org/10.1177/0268355513477009] [PMID: 23482531]
[9]
Jackson JW, Schneeweiss S, VanderWeele TJ, Blacker D. Quantifying the role of adverse events in the mortality difference between first and second-generation antipsychotics in older adults: systematic review and meta-synthesis. PLoS One 2014; 9(8)e105376
[http://dx.doi.org/10.1371/journal.pone.0105376] [PMID: 25140533]
[10]
Keles E, Ulasli SS, Basaran NC, Babaoglu E, Koksal D. Acute massive pulmonary embolism associated with olanzapine. TheAmerican journal of emergency medicine 2017; 35(10): 1582. e1585
[http://dx.doi.org/10.1016/j.ajem.2017.07.026]
[11]
Gallerani M, Imberti D, Mari E, Marra A, Manfredini R. Risperidone and pulmonary embolism: a harmful association? Case series and review of the literature. Acta Neuropsychiatr 2012; 24(6): 361-8.
[http://dx.doi.org/10.1111/j.1601-5215.2012.00641.x] [PMID: 25287179]
[12]
Sarvaiya N, Lapitskaya Y, Dima L, Manu P. Clozapine-Associated Pulmonary Embolism: A High-Mortality, Dose-Independent and Early-Onset Adverse Effect. Am J Ther 2018; 25(4): e434-8.
[http://dx.doi.org/10.1097/MJT.0000000000000806] [PMID: 29985823]
[13]
Solmi M, Murru A, Pacchiarotti I, et al. Safety, tolerability, and risks associated with first- and second-generation antipsychotics: a state-of-the-art clinical review. Ther Clin Risk Manag 2017; 13: 757-77.
[http://dx.doi.org/10.2147/TCRM.S117321] [PMID: 28721057]
[14]
Dietrich-Muszalska A, Rabe-Jablonska J, Nowak P, Kontek B. The first- and second-generation antipsychotic drugs affect ADPinduced platelet aggregation. The world journal of biological psychiatry : the official journal of the World Federation of Societies of Biological Psychiatry 2010; 11(2 Pt 2): 268-75.
[15]
Wu CC, Tsai FM, Chen ML, et al. Antipsychotic Drugs Inhibit Platelet Aggregation via P2Y 1 and P2Y 12 Receptors. BioMed Res Int 2016; 20162532371
[PMID: 27069920]
[16]
Egger M, Davey Smith G, Schneider M, Minder C. Bias in meta-analysis detected by a simple, graphical test. BMJ 1997; 315(7109): 629-34.
[http://dx.doi.org/10.1136/bmj.315.7109.629] [PMID: 9310563]
[17]
Zornberg GL, Jick H. Antipsychotic drug use and risk of first-time idiopathic venous thromboembolism: a case-control study. Lancet 2000; 356(9237): 1219-23.
[http://dx.doi.org/10.1016/S0140-6736(00)02784-7] [PMID: 11072939]
[18]
Thomassen R, Vandenbroucke JP, Rosendaal FR. Antipsychotic medication and venous thrombosis. Br J Psychiatry 2001; 179: 63-6.
[http://dx.doi.org/10.1192/bjp.179.1.63] [PMID: 11435271]
[19]
Ray JG, Mamdani MM, Yeo EL. Antipsychotic and antidepressant drug use in the elderly and the risk of venous thromboembolism. Thromb Haemost 2002; 88(2): 205-9.
[PMID: 12195690]
[20]
Parkin L, Skegg DC, Herbison GP, Paul C. Psychotropic drugs and fatal pulmonary embolism. Pharmacoepidemiol Drug Saf 2003; 12(8): 647-52.
[http://dx.doi.org/10.1002/pds.841] [PMID: 14762980]
[21]
Hamanaka S, Kamijo Y, Nagai T, et al. Massive pulmonary thromboembolism demonstrated at necropsy in Japanese psychiatric patients treated with neuroleptics including atypical antipsychotics. Circulation journal : official journal of the Japanese Circulation Society 2004; 68(9): 850-2.
[http://dx.doi.org/10.1253/circj.68.850]
[22]
Liperoti R, Pedone C, Lapane KL, Mor V, Bernabei R, Gambassi G. Venous thromboembolism among elderly patients treated with atypical and conventional antipsychotic agents. Arch Intern Med 2005; 165(22): 2677-82.
[http://dx.doi.org/10.1001/archinte.165.22.2677] [PMID: 16344428]
[23]
Lacut K, Le Gal G, Couturaud F, et al. Association between antipsychotic drugs, antidepressant drugs and venous thromboembolism: results from the EDITH case-control study. Fundam Clin Pharmacol 2007; 21(6): 643-50.
[http://dx.doi.org/10.1111/j.1472-8206.2007.00515.x] [PMID: 18034665]
[24]
Masopust J, Malý R, Urban A, Hosák L, Cermáková E. Antipsychotic drugs as a risk factor for venous thromboembolism. Int J Psychiatry Clin Pract 2007; 11(3): 246-9.
[http://dx.doi.org/10.1080/13651500601017357] [PMID: 24941366]
[25]
Jönsson AK, Brudin L, Ahlner J, Hedenmalm K, Eriksson A, Hägg S. Antipsychotics associated with pulmonary embolism in a Swedish medicolegal autopsy series. Int Clin Psychopharmacol 2008; 23(5): 263-8.
[http://dx.doi.org/10.1097/YIC.0b013e3282fe9d44] [PMID: 18703935]
[26]
Jönsson AK, Horváth-Puhó E, Hägg S, Pedersen L, Sørensen HT. Antipsychotics and risk of venous thromboembolism: A population-based case-control study. Clin Epidemiol 2009; 1: 19-26.
[http://dx.doi.org/10.2147/CLEP.S4969] [PMID: 20865083]
[27]
Kleijer BC, Heerdink ER, Egberts TC, Jansen PA, van Marum RJ. Antipsychotic drug use and the risk of venous thromboembolism in elderly patients. J Clin Psychopharmacol 2010; 30(5): 526-30.
[http://dx.doi.org/10.1097/JCP.0b013e3181f0e87d] [PMID: 20814323]
[28]
Parker C, Coupland C, Hippisley-Cox J. Antipsychotic drugs and risk of venous thromboembolism: nested case-control study. BMJ 2010; 341: c4245.
[http://dx.doi.org/10.1136/bmj.c4245] [PMID: 20858909]
[29]
Hippisley-Cox J, Coupland C. Development and validation of risk prediction algorithm (QThrombosis) to estimate future risk of venous thromboembolism: prospective cohort study. BMJ 2011; 343: d4656.
[http://dx.doi.org/10.1136/bmj.d4656] [PMID: 21846713]
[30]
Allenet B, Schmidlin S, Genty C, Bosson JL. Antipsychotic drugs and risk of pulmonary embolism. Pharmacoepidemiol Drug Saf 2012; 21(1): 42-8.
[http://dx.doi.org/10.1002/pds.2210] [PMID: 22052683]
[31]
Schmedt N, Garbe E. Antipsychotic drug use and the risk of venous thromboembolism in elderly patients with dementia. J Clin Psychopharmacol 2013; 33(6): 753-8.
[http://dx.doi.org/10.1097/JCP.0b013e3182a412d5] [PMID: 24052055]
[32]
Wu CS, Lin CC, Chang CM, et al. Antipsychotic treatment and the occurrence of venous thromboembolism: a 10-year nationwide registry study. J Clin Psychiatry 2013; 74(9): 918-24.
[http://dx.doi.org/10.4088/JCP.12m08117] [PMID: 24107765]
[33]
Ishiguro C, Wang X, Li L, Jick S. Antipsychotic drugs and risk of idiopathic venous thromboembolism: a nested case-control study using the CPRD. Pharmacoepidemiol Drug Saf 2014; 23(11): 1168-75.
[http://dx.doi.org/10.1002/pds.3699] [PMID: 25195779]
[34]
Conti V, Venegoni M, Cocci A, Fortino I, Lora A, Barbui C. Antipsychotic drug exposure and risk of pulmonary embolism: a population-based, nested case-control study. BMC Psychiatry 2015; 15: 92.
[http://dx.doi.org/10.1186/s12888-015-0479-9] [PMID: 25924683]
[35]
Vigod SN, Gomes T, Wilton AS, Taylor VH, Ray JG. Antipsychotic drug use in pregnancy: high dimensional, propensity matched, population based cohort study. BMJ 2015; 350: h2298.
[http://dx.doi.org/10.1136/bmj.h2298] [PMID: 25972273]
[36]
Wang MT, Liou JT, Huang YW, et al. Use of antipsychotics and risk of venous thromboembolism in postmenopausal women. A population-based nested case-control study. Thromb Haemost 2016; 115(6): 1209-19.
[http://dx.doi.org/10.1160/TH15-11-0895] [PMID: 26941052]
[37]
Dennis M, Shine L, John A, et al. Risk of Adverse Outcomes for Older People with Dementia Prescribed Antipsychotic Medication: A Population Based e-Cohort Study. Neurol Ther 2017; 6(1): 57-77.
[http://dx.doi.org/10.1007/s40120-016-0060-6] [PMID: 28054240]
[38]
Ferraris A, Szmulewicz AG, Vazquez FJ, Vollmer WM, Angriman F. Antipsychotic Use Among Adult Outpatients and Venous Thromboembolic Disease: A Retrospective Cohort Study. J Clin Psychopharmacol 2017; 37(4): 405-11.
[http://dx.doi.org/10.1097/JCP.0000000000000738] [PMID: 28622161]
[39]
Barbui C, Conti V, Cipriani A. Antipsychotic drug exposure and risk of venous thromboembolism: a systematic review and meta-analysis of observational studies. Drug Saf 2014; 37(2): 79-90.
[http://dx.doi.org/10.1007/s40264-013-0127-6] [PMID: 24403009]
[40]
Zhang R, Dong L, Shao F, Tan X, Ying K. Antipsychotics and venous thromboembolism risk: a meta-analysis. Pharmacopsychiatry 2011; 44(5): 183-8.
[http://dx.doi.org/10.1055/s-0031-1280814] [PMID: 21739416]
[41]
De Clerck F, Somers Y, Mannaert E, Greenspan A, Eerdekens M. In vitro effects of risperidone and 9-hydroxy-risperidone on human platelet function, plasma coagulation, and fibrinolysis. Clin Ther 2004; 26(8): 1261-73.
[http://dx.doi.org/10.1016/S0149-2918(04)80097-3] [PMID: 15476907]
[42]
Axelsson S, Hägg S, Eriksson AC, Lindahl TL, Whiss PA. In vitro effects of antipsychotics on human platelet adhesion and aggregation and plasma coagulation. Clin Exp Pharmacol Physiol 2007; 34(8): 775-80.
[http://dx.doi.org/10.1111/j.1440-1681.2007.04650.x] [PMID: 17600556]
[43]
Newcomer JW. Second-generation (atypical) antipsychotics and metabolic effects: a comprehensive literature review. CNS Drugs 2005; 19(Suppl. 1): 1-93.
[http://dx.doi.org/10.2165/00023210-200519001-00001] [PMID: 15998156]
[44]
Kemner C, Willemsen-Swinkels SH, de Jonge M, Tuynman-Qua H, van Engeland H. Open-label study of olanzapine in children with pervasive developmental disorder. J Clin Psychopharmacol 2002; 22(5): 455-60.
[http://dx.doi.org/10.1097/00004714-200210000-00003] [PMID: 12352267]
[45]
Lamberti JS, Bellnier T, Schwarzkopf SB. Weight gain among schizophrenic patients treated with clozapine. Am J Psychiatry 1992; 149(5): 689-90.
[http://dx.doi.org/10.1176/ajp.149.5.689] [PMID: 1349460]
[46]
Sikich L, Hamer RM, Bashford RA, Sheitman BB, Lieberman JA. A pilot study of risperidone, olanzapine, and haloperidol in psychotic youth: a double-blind, randomized, 8-week trial. Neuropsychopharmacology : official publication of the American College of Neuropsychopharmacology 2004; 29(1): 133-45.
[47]
Malý R, Masopust J, Hosák L, Konupcíková K. Assessment of risk of venous thromboembolism and its possible prevention in psychiatric patients. Psychiatry Clin Neurosci 2008; 62(1): 3-8.
[http://dx.doi.org/10.1111/j.1440-1819.2007.01773.x] [PMID: 18289135]
[48]
Scahill L, Leckman JF, Schultz RT, Katsovich L, Peterson BS. A placebo-controlled trial of risperidone in Tourette syndrome. Neurology 2003; 60(7): 1130-5.
[http://dx.doi.org/10.1212/01.WNL.0000055434.39968.67] [PMID: 12682319]
[49]
Arvanitis LA, Miller BG. Multiple fixed doses of “Seroquel” (quetiapine) in patients with acute exacerbation of schizophrenia: a comparison with haloperidol and placebo. The Seroquel Trial 13 Study Group. Biol Psychiatry 1997; 42(4): 233-46.
[http://dx.doi.org/10.1016/S0006-3223(97)00190-X] [PMID: 9270900]
[50]
Marder SR, McQuade RD, Stock E, et al. Aripiprazole in the treatment of schizophrenia: safety and tolerability in short-term, placebo-controlled trials. Schizophr Res 2003; 61(2-3): 123-36.
[http://dx.doi.org/10.1016/S0920-9964(03)00050-1] [PMID: 12729864]
[51]
Allison DB, Mentore JL, Heo M, et al. Antipsychotic-induced weight gain: a comprehensive research synthesis. Am J Psychiatry 1999; 156(11): 1686-96.
[PMID: 10553730]
[52]
Wang C, Xu J, Yang L, et al. China Pulmonary Health Study Group. Prevalence and risk factors of chronic obstructive pulmonary disease in China (the China Pulmonary Health [CPH] study): a national cross-sectional study. Lancet 2018; 391(10131): 1706-17.
[http://dx.doi.org/10.1016/S0140-6736(18)30841-9] [PMID: 29650248]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version348msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[18:15:54] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[18:15:54] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[18:15:54] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (105ms)time
  • Application (244ms)time
  • 1 x Application (69.94%)
    244ms
    1 x Booting (30.06%)
    105ms
    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 duplicated164ms
    • 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 ('309813860','',1,1739988954,1739988954) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739988954
      1msalphaeurekaselec_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 ('309813860','/article/105988',1,1739988954,1739988954)
      200μ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 >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) 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 >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) 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 >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) 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 >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) 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 >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) 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 >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) limit 1
      13.43msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 309813860
      • 1: 309813860
      • 2: 309813860
      • 3: 309813860
      • 4: 309813860
      • 5: 309813860
      • 6: 309813860
      • 7: 309813860
      • 8: 309813860
      • 9: 309813860
      • 10: 309813860
      • 11: 309813860
      • 12: 309813860
      • 13: 309813860
      • 14: 309813860
      • 15: 309813860
      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=105988
      770μ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` = 13 limit 1
      860μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 13
      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=13) and sj.journal_id!=13 group by `j`.`nid`) as `aggregate_table`
      1.09msalphaeurekaselec_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=13) and sj.journal_id!=13 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      960μ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=13) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.12msalphaeurekaselec_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=13) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      1.9msalphaeurekaselec_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` = '105988'
      800μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 105988
      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` = '105988'
      2.44msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 105988
      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` = '105988' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.72msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 105988
      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
      310μ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 = 13 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      34.95msalphaeurekaselec_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 = 13 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      20.22msalphaeurekaselec_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 = 13 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      15.95msalphaeurekaselec_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` = 105988 limit 1
      1.11msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 105988
      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 = 105988 and content_type = 'article' order by status desc limit 1
      850μ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!=105988 and cd.content_type = 'article' order by rand() limit 20
      44.58msalphaeurekaselec_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` = 181168 limit 1
      260μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 181168
      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
      260μ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` = 'CDT' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      410μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CDT
      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 = '105988' 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) )
      490μ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 = '9903' 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) )
      330μ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 = '2690' 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) )
      290μ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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1739988954 and j.to_date >= 1739988954 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2690) 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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1739988954 and j.to_date >= 1739988954 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2690) 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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1739988954 and j.to_date >= 1739988954 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2690)
      6.52msalphaeurekaselec_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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1739988954 and j.to_date >= 1739988954 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9903) 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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1739988954 and j.to_date >= 1739988954 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9903) 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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1739988954 and j.to_date >= 1739988954 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9903)
      820μ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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1739988954 and j.to_date >= 1739988954 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 105988) 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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1739988954 and j.to_date >= 1739988954 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 105988) 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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1739988954 and j.to_date >= 1739988954 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 105988)
      820μ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` < '930' and is_uploaded = 1 and issue_id = 9903 order by cast(first_page as SIGNED) desc limit 1
      630μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 930
      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` > '942' and is_uploaded = 1 and issue_id = 9903 order by cast(first_page as SIGNED) asc limit 1
      530μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 942
      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'
      220μ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
      250μ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` = 105988 limit 1
      3.07msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 105988
      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` = 13 and `b`.`banner_from_date` <= 1739988954 and `b`.`banner_to_date` >= 1739988954 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.57msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 13
      • 3: 1739988954
      • 4: 1739988954
      • 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` = 13 and `b`.`banner_from_date` <= 1739988954 and `b`.`banner_to_date` >= 1739988954 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.51msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 13
      • 3: 1739988954
      • 4: 1739988954
      • 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='2e2d8ab50d0d18ad7989a8fadb1efd35'
      250μ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#?
    App\Models\MultiLangArticle
    1MultiLangArticle.php#?
        _token
        qERcRUoB9tMjJTGNf9QUelakg6eSpXZfC4ofcPwp
        uc_cart_id
        2e2d8ab50d0d18ad7989a8fadb1efd35
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/105988" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/105988
        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=eyJpdiI6IkZ5RldZZXdaL3o5Qk0wTkRmVWR1cVE9PSIsInZhbHVlIjoib0ZWNnNnaTdEQWhZUjRzS2JmcHdlWlA0dHltV1BIdlorSzA5bXhldEpiWT0iLCJtYWMiOiI3MDQ2Yjk1YjQ1NWMwZWQxMjUyNzMyOTIzYzMyZjhkMWZlZTU1ZjRkYzg3N2ZhZWYyZWMxZjI2MjdjMWRhZjA3IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IkZ5RldZZXdaL3o5Qk0wTkRmVWR1cVE9PSIsInZhbHVlIjoib0ZWNnNnaTdEQWhZUjRzS2JmcHdlWlA0dHltV1BIdlorSzA5bXhldEpiWT0iLCJtYWMiOiI3MDQ2Yjk1YjQ1NWMw" ] "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 => "Wed, 19 Feb 2025 18:15:54 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImFnTWJPdGFRWWFneDNRS2pHYjRabkE9PSIsInZhbHVlIjoiMGIwdTNrYnZmWWJqdzFhNUlOa0lsdUl2NlZUL1VxdW9EZ0pUUW1VVGxCSEt0N2JsdllRS1ozazdOL0M4cDlXVFB1OGt5YkZBL1ZlVStJNzdmTFNUTTVISU10a2hJRnAzb1JMaW9BSHNndFZlY21oQzE1TDhoUzNnMit1Rk53Wk0iLCJtYWMiOiJmODNjMzY3Njc0OWZiYzg3ODgxZTEyNGM2OWQ5MDMzZDVjZWFlMjIzZTZiYTBlNTE5MDI3ZDQyYjkzMDQ5ZDhlIiwidGFnIjoiIn0%3D; expires=Sat, 22 Feb 2025 06:15:54 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImFnTWJPdGFRWWFneDNRS2pHYjRabkE9PSIsInZhbHVlIjoiMGIwdTNrYnZmWWJqdzFhNUlOa0lsdUl2NlZUL1VxdW9EZ0pUUW1VVGxCSEt0N2JsdllRS1ozazdOL0M4cDlXVFB1OGt5Y" 1 => "alphaeurekaselectnet_session=eyJpdiI6InkrZWdtOWVtMkROOVVDMSsxMVQzcnc9PSIsInZhbHVlIjoiL2t6dFhJZDhUMDdIczhHUjNmRFBZSXJxUHdHdWF2algzNFJrRlpoQnRtMVZlWWhKcUZMamtPVVBwUFArQ1lEeXF1aGF5dEZMdkdwZDhQeVd4NGRmWk9LcDBGY0FWTysyWE9PM1RBMm5OUVRqL2g0Yk5WTk9mNE4vWVg1WHNFNHciLCJtYWMiOiJiMGQ0ZTg1NWU5OWFhNTVhNzIxMjRkZDQ3MDM3ODllM2E1ZWI5Y2Y1YWUxNGU0YTI3OGUzMGI4YWI0ZjdjMDczIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6InkrZWdtOWVtMkROOVVDMSsxMVQzcnc9PSIsInZhbHVlIjoiL2t6dFhJZDhUMDdIczhHUjNmRFBZSXJxUHdHdWF2algzNFJrRlpoQnRtMVZlWWhKcUZMamtPVVB" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImFnTWJPdGFRWWFneDNRS2pHYjRabkE9PSIsInZhbHVlIjoiMGIwdTNrYnZmWWJqdzFhNUlOa0lsdUl2NlZUL1VxdW9EZ0pUUW1VVGxCSEt0N2JsdllRS1ozazdOL0M4cDlXVFB1OGt5YkZBL1ZlVStJNzdmTFNUTTVISU10a2hJRnAzb1JMaW9BSHNndFZlY21oQzE1TDhoUzNnMit1Rk53Wk0iLCJtYWMiOiJmODNjMzY3Njc0OWZiYzg3ODgxZTEyNGM2OWQ5MDMzZDVjZWFlMjIzZTZiYTBlNTE5MDI3ZDQyYjkzMDQ5ZDhlIiwidGFnIjoiIn0%3D; expires=Sat, 22-Feb-2025 06:15:54 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImFnTWJPdGFRWWFneDNRS2pHYjRabkE9PSIsInZhbHVlIjoiMGIwdTNrYnZmWWJqdzFhNUlOa0lsdUl2NlZUL1VxdW9EZ0pUUW1VVGxCSEt0N2JsdllRS1ozazdOL0M4cDlXVFB1OGt5Y" 1 => "alphaeurekaselectnet_session=eyJpdiI6InkrZWdtOWVtMkROOVVDMSsxMVQzcnc9PSIsInZhbHVlIjoiL2t6dFhJZDhUMDdIczhHUjNmRFBZSXJxUHdHdWF2algzNFJrRlpoQnRtMVZlWWhKcUZMamtPVVBwUFArQ1lEeXF1aGF5dEZMdkdwZDhQeVd4NGRmWk9LcDBGY0FWTysyWE9PM1RBMm5OUVRqL2g0Yk5WTk9mNE4vWVg1WHNFNHciLCJtYWMiOiJiMGQ0ZTg1NWU5OWFhNTVhNzIxMjRkZDQ3MDM3ODllM2E1ZWI5Y2Y1YWUxNGU0YTI3OGUzMGI4YWI0ZjdjMDczIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6InkrZWdtOWVtMkROOVVDMSsxMVQzcnc9PSIsInZhbHVlIjoiL2t6dFhJZDhUMDdIczhHUjNmRFBZSXJxUHdHdWF2algzNFJrRlpoQnRtMVZlWWhKcUZMamtPVVB" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "qERcRUoB9tMjJTGNf9QUelakg6eSpXZfC4ofcPwp" "uc_cart_id" => "2e2d8ab50d0d18ad7989a8fadb1efd35" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/105988" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-19 18:15:54GET/article/105988314372