Generic placeholder image

Reviews on Recent Clinical Trials

Editor-in-Chief

ISSN (Print): 1574-8871
ISSN (Online): 1876-1038

Review Article

Liver Cirrhosis Complications Management at the Emergency Department

Author(s): Emidio Scarpellini, Carmelo Luigiano, Gianluca Svegliati-Baroni, Dan Dumitrascu, Tiziana Larussa, Valeria Santori, Francesco Luzza and Ludovico Abenavoli*

Volume 15, Issue 4, 2020

Page: [331 - 338] Pages: 8

DOI: 10.2174/1574887115666200603160816

Price: $65

Abstract

Background and Aims: Liver cirrhosis (LC) of any origin has always been a source of several emergencies for physicians working at the Emergency Department (ER). LC patients can present with several complications that are sometimes difficult to recognize and treat.

Thus, we reviewed the literature evidence for the diagnosis and management of several LC related emergencies.

Methods: We conducted a search on the main medical databases for papers, reviews, metanalyses, case series, and RCTs using the following keywords and their associations: liver cirrhosis, variceal hemorrhage, ascites, hepatic encephalopathy, spontaneous bacterial peritonitis, hepato-renal syndrome, emergency.

Results: Main LC emergencies are upper gastrointestinal hemorrhage, decompensated ascites and spontaneous bacterial peritonitis, hepatic encephalopathy, hepato-renal syndrome. Their management is partly medical and interventional. Very often, the final cure of some complications, such as hepato-renal syndrome, is represented by liver transplantation.

Conclusion: Although LC prevalence is going to fall in the following years, due to HBV and HCV optimized treatments, its complications represent a significant admission percentage at the ER and challenge for physicians’ skills.

Keywords: Liver cirrhosis, variceal hemorrhage, ascites, spontaneous bacterial peritonitis, hepato-renal syndrome, emergency.

Graphical Abstract

[1]
Murray CJ, Atkinson C, Bhalla K, et al. U.S. Burden of Disease Collaborators. The state of US health, 1990-2010: Burden of diseases, injuries, and risk factors. JAMA 2013; 310(6): 591-608.
[http://dx.doi.org/10.1001/jama.2013.13805] [PMID: 23842577]
[2]
Tsochatzis EA, Bosch J, Burroughs AK. Liver cirrhosis. Lancet 2014; 383(9930): 1749-61.
[http://dx.doi.org/10.1016/S0140-6736(14)60121-5] [PMID: 24480518]
[3]
Garcia-Tsao G, Sanyal AJ, Grace ND, Carey W. Practice guidelines committee of the american association for the study of liver diseases; practice parameters committee of the american college of gastroenterology. Prevention and management of gastroesophageal varices and variceal hemorrhage in cirrhosis. Hepatology 2007; 46(3): 922-38.
[http://dx.doi.org/10.1002/hep.21907] [PMID: 17879356]
[4]
Nusrat S, Khan MS, Fazili J, Madhoun MF. Cirrhosis and its complications: Evidence based treatment. World J Gastroenterol 2014; 20(18): 5442-60.
[http://dx.doi.org/10.3748/wjg.v20.i18.5442] [PMID: 24833875]
[5]
Garcia-Tsao G. Current management of the complications of cirrhosis and portal hypertension: Variceal hemorrhage, ascites, and spontaneous bacterial peritonitis. Dig Dis 2016; 34(4): 382-6.
[http://dx.doi.org/10.1159/000444551] [PMID: 27170392]
[6]
Agrawal K, Kumar P, Markert R, Agrawal S. Risk Factors for 30-day readmissions of individuals with decompensated cirrhosis. South Med J 2015; 108(11): 682-7.
[http://dx.doi.org/10.14423/SMJ.0000000000000371] [PMID: 26539950]
[7]
Bajaj JS, O’Leary JG, Reddy KR, et al. NACSELD. Second infections independently increase mortality in hospitalized patients with cirrhosis: The North American consortium for the study of end-stage liver disease (NACSELD) experience. Hepatology 2012; 56(6): 2328-35.
[http://dx.doi.org/10.1002/hep.25947] [PMID: 22806618]
[9]
D’Amico G, Garcia-Tsao G, Pagliaro L. Natural history and prognostic indicators of survival in cirrhosis: A systematic review of 118 studies. J Hepatol 2006; 44(1): 217-31.
[http://dx.doi.org/10.1016/j.jhep.2005.10.013] [PMID: 16298014]
[10]
Nishikawa H, Osaki Y. Liver cirrhosis: Evaluation, nutritional Status, and prognosis. Mediators Inflamm 2015; 2015872152
[http://dx.doi.org/10.1155/2015/872152] [PMID: 26494949]
[11]
Fukui H, Saito H, Ueno Y, et al. Evidence-based clinical practice guidelines for liver cirrhosis 2015. J Gastroenterol 2016; 51(7): 629-50.
[http://dx.doi.org/10.1007/s00535-016-1216-y] [PMID: 27246107]
[12]
Weingart SD. EMCrit Podcast 5 – intubating the critical GI bleeder. EMCrit blog. Published on 21 June 2009. Available from: http://emcrit.org/podcasts/intubating-gi-bleeds/ Accessed date: 18 June 2017
[13]
Weingart SD. Preoxygenation, reoxygenation, and delayed sequence intubation in the emergency department. J Emerg Med 2011; 40(6): 661-7.
[http://dx.doi.org/10.1016/j.jemermed.2010.02.014] [PMID: 20378297]
[14]
Leung FW. The venerable nasogastric tube. Gastrointest Endosc 2004; 59(2): 255-60.
[http://dx.doi.org/10.1016/S0016-5107(03)02691-9] [PMID: 14745400]
[15]
Barkun AN, Bardou M, Kuipers EJ, et al. International Consensus Upper Gastrointestinal Bleeding Conference Group. International consensus recommendations on the management of patients with nonvariceal upper gastrointestinal bleeding. Ann Intern Med 2010; 152(2): 101-13.
[http://dx.doi.org/10.7326/0003-4819-152-2-201001190-00009] [PMID: 20083829]
[16]
Kei J, Mebust DP. Comparing the effectiveness of a novel suction set-up using an adult endotracheal tube connected to a meconium aspirator vs. a traditional yankauer suction instrument. J Emerg Med 2017; 52(4): 433-7.
[http://dx.doi.org/10.1016/j.jemermed.2016.09.006] [PMID: 27751699]
[17]
Lyon RM, Perkins ZB, Chatterjee D, Lockey DJ, Russell MQ. Kent, Surrey & Sussex Air Ambulance Trust. Significant modification of traditional rapid sequence induction improves safety and effectiveness of pre-hospital trauma anaesthesia. Crit Care 2015; 19: 134.
[http://dx.doi.org/10.1186/s13054-015-0872-2] [PMID: 25879683]
[18]
Long B, Koyfman A. The emergency medicine evaluation and management of the patient with cirrhosis. Am J Emerg Med 2018; 36(4): 689-98.
[http://dx.doi.org/10.1016/j.ajem.2017.12.047] [PMID: 29290508]
[19]
Merli M, Nicolini G, Angeloni S, et al. Incidence and natural history of small esophageal varices in cirrhotic patients. J Hepatol 2003; 38(3): 266-72.
[http://dx.doi.org/10.1016/S0168-8278(02)00420-8] [PMID: 12586291]
[20]
Northup PG, Caldwell SH. Coagulation in liver disease: A guide for the clinician. Clin Gastroenterol Hepatol 2013; 11(9): 1064-74.
[http://dx.doi.org/10.1016/j.cgh.2013.02.026] [PMID: 23506859]
[21]
Clevenger B, Mallett SV. Transfusion and coagulation management in liver transplantation. World J Gastroenterol 2014; 20(20): 6146-58.
[http://dx.doi.org/10.3748/wjg.v20.i20.6146] [PMID: 24876736]
[22]
Weeder PD, Porte RJ, Lisman T. Hemostasis in liver disease: implications of new concepts for perioperative management. Transfus Med Rev 2014; 28(3): 107-13.
[http://dx.doi.org/10.1016/j.tmrv.2014.03.002] [PMID: 24721432]
[23]
Tripodi A, Mannucci PM. The coagulopathy of chronic liver disease. N Engl J Med 2011; 365(2): 147-56.
[http://dx.doi.org/10.1056/NEJMra1011170] [PMID: 21751907]
[24]
Ewe K. Bleeding after liver biopsy does not correlate with indices of peripheral coagulation. Dig Dis Sci 1981; 26(5): 388-93.
[http://dx.doi.org/10.1007/BF01313579] [PMID: 7249879]
[25]
Caldwell SH. Management of coagulopathy in liver disease. Gastroenterol Hepatol (N Y) 2014; 10(5): 330-2.
[PMID: 24987319]
[26]
Villanueva C, Colomo A, Bosch A, et al. Transfusion strategies for acute upper gastrointestinal bleeding. N Engl J Med 2013; 368(1): 11-21.
[http://dx.doi.org/10.1056/NEJMoa1211801] [PMID: 23281973]
[27]
Noval-Padillo JA, León-Justel A, Mellado-Miras P, et al. Introduction of fibrinogen in the treatment of hemostatic disorders during orthotopic liver transplantation: Implications in the use of allogenic blood. Transplant Proc 2010; 42(8): 2973-4.
[http://dx.doi.org/10.1016/j.transproceed.2010.08.011] [PMID: 20970586]
[28]
Bennett C, Klingenberg SL, Langholz E, Gluud LL. Tranexamic acid for upper gastrointestinal bleeding. Cochrane Database Syst Rev 2014; (11): CD006640
[PMID: 25414987]
[29]
Hou MC, Lin HC, Liu TT, et al. Antibiotic prophylaxis after endoscopic therapy prevents rebleeding in acute variceal hemorrhage: A randomized trial. Hepatology 2004; 39(3): 746-53.
[http://dx.doi.org/10.1002/hep.20126] [PMID: 14999693]
[30]
Luigiano C, Iabichino G, Judica A, Virgilio C, Peta V, Abenavoli L. Role of endoscopy in management of gastrointestinal complications of portal hypertension. World J Gastrointest Endosc 2015; 7(1): 1-12.
[http://dx.doi.org/10.4253/wjge.v7.i1.1] [PMID: 25610530]
[31]
Wells M, Chande N, Adams P, et al. Meta-analysis: Vasoactive medications for the management of acute variceal bleeds. Aliment Pharmacol Ther 2012; 35(11): 1267-78.
[http://dx.doi.org/10.1111/j.1365-2036.2012.05088.x] [PMID: 22486630]
[32]
Chojkier M, Conn HO. Esophageal tamponade in the treatment of bleeding varices. A decadel progress report. Dig Dis Sci 1980; 25(4): 267-72.
[http://dx.doi.org/10.1007/BF01308516] [PMID: 6967005]
[33]
Monescillo A, Martínez-Lagares F, Ruiz-del-Arbol L, et al. Influence of portal hypertension and its early decompression by TIPS placement on the outcome of variceal bleeding. Hepatology 2004; 40(4): 793-801.
[http://dx.doi.org/10.1002/hep.20386] [PMID: 15382120]
[34]
Kuiper JJ, de Man RA, van Buuren HR. Review article: Management of ascites and associated complications in patients with cirrhosis. Aliment Pharmacol Ther 2007; 26(Suppl. 2): 183-93.
[http://dx.doi.org/10.1111/j.1365-2036.2007.03482.x] [PMID: 18081661]
[35]
Ginés P, Arroyo V, Quintero E, et al. Comparison of paracentesis and diuretics in the treatment of cirrhotics with tense ascites. Results of a randomized study. Gastroenterology 1987; 93(2): 234-41.
[http://dx.doi.org/10.1016/0016-5085(87)91007-9] [PMID: 3297907]
[36]
Bernardi M, Caraceni P, Navickis RJ, Wilkes MM. Albumin infusion in patients undergoing large-volume paracentesis: A meta-analysis of randomized trials. Hepatology 2012; 55(4): 1172-81.
[http://dx.doi.org/10.1002/hep.24786] [PMID: 22095893]
[37]
Garcia-Tsao G. Spontaneous bacterial peritonitis: A historical perspective. J Hepatol 2004; 41(4): 522-7.
[http://dx.doi.org/10.1016/j.jhep.2004.09.001] [PMID: 15464231]
[38]
Kim JJ, Tsukamoto MM, Mathur AK, et al. Delayed paracentesis is associated with increased in-hospital mortality in patients with spontaneous bacterial peritonitis. Am J Gastroenterol 2014; 109(9): 1436-42.
[http://dx.doi.org/10.1038/ajg.2014.212] [PMID: 25091061]
[39]
Hoefs JC, Canawati HN, Sapico FL, Hopkins RR, Weiner J, Montgomerie JZ. Spontaneous bacterial peritonitis. Hepatology 1982; 2(4): 399-407.
[http://dx.doi.org/10.1002/hep.1840020402] [PMID: 7095741]
[40]
Runyon BA, Hoefs JC. Culture-negative neutrocytic ascites: A variant of spontaneous bacterial peritonitis. Hepatology 1984; 4(6): 1209-11.
[http://dx.doi.org/10.1002/hep.1840040619] [PMID: 6500513]
[41]
Téllez-Ávila FI, Chávez-Tapia NC, Franco-Guzmán AM, Uribe M, Vargas-Vorackova F. Rapid diagnosis of spontaneous bacterial peritonitis using leukocyte esterase reagent strips in emergency department: uri-quick clini-10SG® vs. Multistix 10SG®. Ann Hepatol 2012; 11(5): 696-9.
[http://dx.doi.org/10.1016/S1665-2681(19)31445-0] [PMID: 22947532]
[42]
Chavez-Tapia NC, Soares-Weiser K, Brezis M, Leibovici L. Antibiotics for spontaneous bacterial peritonitis in cirrhotic patients. Cochrane Database Syst Rev 2009; (1): CD002232
[http://dx.doi.org/10.1002/14651858.CD002232.pub2] [PMID: 19160207]
[43]
Sort P, Navasa M, Arroyo V, et al. Effect of intravenous albumin on renal impairment and mortality in patients with cirrhosis and spontaneous bacterial peritonitis. N Engl J Med 1999; 341(6): 403-9.
[http://dx.doi.org/10.1056/NEJM199908053410603] [PMID: 10432325]
[44]
Fernández J, Gustot T. Management of bacterial infections in cirrhosis. J Hepatol 2012; 56(Suppl. 1): S1-S12.
[http://dx.doi.org/10.1016/S0168-8278(12)60002-6] [PMID: 22300459]
[45]
Wong F, Bernardi M, Balk R, et al. International Ascites Club. Sepsis in cirrhosis: Report on the 7th meeting of the International Ascites Club. Gut 2005; 54(5): 718-25.
[http://dx.doi.org/10.1136/gut.2004.038679] [PMID: 15831923]
[46]
Tandon P, Garcia-Tsao G. Bacterial infections, sepsis, and multiorgan failure in cirrhosis. Semin Liver Dis 2008; 28(1): 26-42.
[http://dx.doi.org/10.1055/s-2008-1040319] [PMID: 18293275]
[47]
Poordad FF. Review article: The burden of hepatic encephalopathy. Aliment Pharmacol Ther 2007; 25(Suppl. 1): 3-9.
[http://dx.doi.org/10.1111/j.1746-6342.2006.03215.x] [PMID: 17295846]
[48]
Hadjihambi A, Arias N, Sheikh M, Jalan R. Hepatic encephalopathy: A critical current review. Hepatol Int 2018; 12(Suppl. 1): 135-47.
[http://dx.doi.org/10.1007/s12072-017-9812-3] [PMID: 28770516]
[49]
Weissenborn K. Hepatic Encephalopathy: Definition, clinical grading and diagnostic principles. Drugs 2019; 79(Suppl. 1): 5-9.
[http://dx.doi.org/10.1007/s40265-018-1018-z] [PMID: 30706420]
[50]
Vilstrup H, Amodio P, Bajaj J, et al. Hepatic encephalopathy in chronic liver disease: 2014 Practice Guideline by the American Association for the Study of Liver Diseases and the European Association for the Study of the Liver. Hepatology 2014; 60(2): 715-35.
[http://dx.doi.org/10.1002/hep.27210] [PMID: 25042402]
[51]
Prasad S, Dhiman RK, Duseja A, Chawla YK, Sharma A, Agarwal R. Lactulose improves cognitive functions and health-related quality of life in patients with cirrhosis who have minimal hepatic encephalopathy. Hepatology 2007; 45(3): 549-59.
[http://dx.doi.org/10.1002/hep.21533] [PMID: 17326150]
[52]
Amodio P, Bemeur C, Butterworth R, et al. The nutritional management of hepatic encephalopathy in patients with cirrhosis: International Society for Hepatic Encephalopathy and Nitrogen Metabolism Consensus. Hepatology 2013; 58(1): 325-36.
[http://dx.doi.org/10.1002/hep.26370] [PMID: 23471642]
[53]
Hudson M, Schuchmann M. Long-term management of hepatic encephalopathy with lactulose and/or rifaximin: A review of the evidence. Eur J Gastroenterol Hepatol 2019; 31(4): 434-50.
[http://dx.doi.org/10.1097/MEG.0000000000001311] [PMID: 30444745]
[54]
Montoliu S, Ballesté B, Planas R, et al. Incidence and prognosis of different types of functional renal failure in cirrhotic patients with ascites. Clin Gastroenterol Hepatol 2010; 8(7): 616-22. [quiz: e80].
[http://dx.doi.org/10.1016/j.cgh.2010.03.029] [PMID: 20399905]
[55]
Ginès P, Guevara M, Arroyo V, Rodés J. Hepatorenal syndrome. Lancet 2003; 362(9398): 1819-27.
[http://dx.doi.org/10.1016/S0140-6736(03)14903-3] [PMID: 14654322]
[56]
Wong F. Recent advances in our understanding of hepatorenal syndrome. Nat Rev Gastroenterol Hepatol 2012; 9(7): 382-91.
[http://dx.doi.org/10.1038/nrgastro.2012.96] [PMID: 22614754]
[57]
Arroyo V, Guevara M, Ginès P. Hepatorenal syndrome in cirrhosis: pathogenesis and treatment. Gastroenterology 2002; 122(6): 1658-76.
[http://dx.doi.org/10.1053/gast.2002.33575] [PMID: 12016430]
[58]
Arroyo V, Ginès P, Gerbes AL, et al. Definition and diagnostic criteria of refractory ascites and hepatorenal syndrome in cirrhosis. International Ascites Club. Hepatology 1996; 23(1): 164-76.
[http://dx.doi.org/10.1002/hep.510230122] [PMID: 8550036]
[59]
Velez JC, Nietert PJ. Therapeutic response to vasoconstrictors in hepatorenal syndrome parallels increase in mean arterial pressure: a pooled analysis of clinical trials. Am J Kidney Dis 2011; 58(6): 928-38.
[http://dx.doi.org/10.1053/j.ajkd.2011.07.017] [PMID: 21962618]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version323msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:23:50] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:23:50] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:23:50] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[20:23:50] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[20:23:50] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (140ms)time
  • Application (183ms)time
  • 1 x Application (56.63%)
    183ms
    1 x Booting (43.37%)
    140ms
    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
    36 statements were executed, 4 of which were duplicates, 32 unique. Show only duplicated83.82ms
    • 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 ('316524867','',1,1740515030,1740515030) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740515030
      1.38msalphaeurekaselec_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 ('316524867','/article/107076',1,1740515030,1740515030)
      150μ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 >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) 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 >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) 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 >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) 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 >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) 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 >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) 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 >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316524867 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316524867) limit 1
      11.17msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316524867
      • 1: 316524867
      • 2: 316524867
      • 3: 316524867
      • 4: 316524867
      • 5: 316524867
      • 6: 316524867
      • 7: 316524867
      • 8: 316524867
      • 9: 316524867
      • 10: 316524867
      • 11: 316524867
      • 12: 316524867
      • 13: 316524867
      • 14: 316524867
      • 15: 316524867
      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=107076
      700μ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` = 63 limit 1
      1.04msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 63
      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=63) and sj.journal_id!=63 group by `j`.`nid`) as `aggregate_table`
      1.37msalphaeurekaselec_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=63) and sj.journal_id!=63 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.26msalphaeurekaselec_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=63) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.79msalphaeurekaselec_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=63) 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.4msalphaeurekaselec_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` = '107076'
      280μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 107076
      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` = '107076'
      2.43msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 107076
      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` = '107076' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      880μsalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 107076
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ArticleController.php:2533
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      250μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      470μ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 = 63 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      24.73msalphaeurekaselec_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 = 63 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      3.48msalphaeurekaselec_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 = 63 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      2.9msalphaeurekaselec_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` = 107076 limit 1
      230μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 107076
      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 = 107076 and content_type = 'article' order by status desc limit 1
      250μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 182484 limit 1
      220μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 182484
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      220μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'RRCT' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      240μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: RRCT
      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 = '107076' and content_type = 'a' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      350μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2186
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '10363' 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) )
      290μ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 = '2743' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      270μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2231
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316524867 and j.to_ip >=316524867 )) and ((j.from_date <= 1740515030 and j.to_date >= 1740515030 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2743) 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 <= 316524867 and j.to_ip >=316524867 )) and ((j.from_date <= 1740515030 and j.to_date >= 1740515030 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2743) 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 <= 316524867 and j.to_ip >=316524867 )) and ((j.from_date <= 1740515030 and j.to_date >= 1740515030 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2743)
      18.97msalphaeurekaselec_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 <= 316524867 and j.to_ip >=316524867 )) and ((j.from_date <= 1740515030 and j.to_date >= 1740515030 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10363) 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 <= 316524867 and j.to_ip >=316524867 )) and ((j.from_date <= 1740515030 and j.to_date >= 1740515030 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10363) 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 <= 316524867 and j.to_ip >=316524867 )) and ((j.from_date <= 1740515030 and j.to_date >= 1740515030 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10363)
      580μ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 <= 316524867 and j.to_ip >=316524867 )) and ((j.from_date <= 1740515030 and j.to_date >= 1740515030 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 107076) 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 <= 316524867 and j.to_ip >=316524867 )) and ((j.from_date <= 1740515030 and j.to_date >= 1740515030 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 107076) 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 <= 316524867 and j.to_ip >=316524867 )) and ((j.from_date <= 1740515030 and j.to_date >= 1740515030 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 107076)
      560μ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` < '331' and is_uploaded = 1 and issue_id = 10363 order by cast(first_page as SIGNED) desc limit 1
      520μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 331
      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` > '338' and is_uploaded = 1 and issue_id = 10363 order by cast(first_page as SIGNED) asc limit 1
      460μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 338
      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'
      170μ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
      210μ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` = 107076 limit 1
      2.32msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 107076
      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` = 63 and `b`.`banner_from_date` <= 1740515030 and `b`.`banner_to_date` >= 1740515030 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.08msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 63
      • 3: 1740515030
      • 4: 1740515030
      • 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` = 63 and `b`.`banner_from_date` <= 1740515030 and `b`.`banner_to_date` >= 1740515030 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.02msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 63
      • 3: 1740515030
      • 4: 1740515030
      • 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='92890b0e39555403f85a9400ea1dbadb'
      180μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        izaeeQJLDumsE5BkolVePbfwtoIzBhnnGpxs0Jxg
        uc_cart_id
        92890b0e39555403f85a9400ea1dbadb
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/107076" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/107076
        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=eyJpdiI6ImRHU1AxMWlMb3B3UzJmaDhlbTlTZlE9PSIsInZhbHVlIjoibWRpdUtKampCKzlUYlM1UXQvclUvN2pWYlVTMjdERm9LdGNmNFF0Y0ZXZz0iLCJtYWMiOiJiMTA3MGRjMjY5YTExMDEwNDNlOTUxMzg5MGU0Y2VhYTRjYWZjNmZmNjNmNjE4NDQwYjg2MGQ4MWE3OWZhMWQyIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6ImRHU1AxMWlMb3B3UzJmaDhlbTlTZlE9PSIsInZhbHVlIjoibWRpdUtKampCKzlUYlM1UXQvclUvN2pWYlVTMjdERm9LdGNmNFF0Y0ZXZz0iLCJtYWMiOiJiMTA3MGRjMjY5YTEx" ] "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, 25 Feb 2025 20:23:50 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InRmWHZGZTJMWG0xdlVqakNua3BIS3c9PSIsInZhbHVlIjoibGxMM2F5RXNIUzBYYnFWSDhnejkxbE9IdUVWVzhVdVc0WEhjSllKMkRaQk4wTmRYTHpHSmI1NkxPMEEvS1lUSU40eW5HeDd0cjZlQWdlNFBrS2poN3hSS0dPUTVwa280RUJRUVMvUkkvVkdueDFOZUJFWXNEeXhEVGlsUUQvaisiLCJtYWMiOiJhYjVjNzA4ZDlhZDc3NTk3ZTAwNmZhMDQ0NTdlOTY3ZjRlNjNkM2YyOTE0ODQ3ZTk3NDE5MzE0YmRjZDk0ZjllIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 08:23:50 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InRmWHZGZTJMWG0xdlVqakNua3BIS3c9PSIsInZhbHVlIjoibGxMM2F5RXNIUzBYYnFWSDhnejkxbE9IdUVWVzhVdVc0WEhjSllKMkRaQk4wTmRYTHpHSmI1NkxPMEEvS1lUSU40eW5He" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkdXQXpaTUVLZ01Sb3paUE1wNkNtc3c9PSIsInZhbHVlIjoiLzlKWGt2cUxhWkJyL1JzQitVWGFaZjAwMjRlTzdSLzUzb2NRclgvSXFVa2RaOW8xVVg2WjMzMmFWZWdTdFprdVZsSGR3V2pyY2g5R25MWnkyT2F4UENBRVdzTm1pWmZ4Z3BsT2xpcy9mVzIxdElmSElab3J5YlVrZCtqc3A0MnkiLCJtYWMiOiJkM2E2ZjJhMzU0ZjhkNDI0OWMwODM3YmM5NjY3MjE2OWU5OTAwZTU3YTIyN2NhNTI2NTAzODhhNWIxOGVlNWEwIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkdXQXpaTUVLZ01Sb3paUE1wNkNtc3c9PSIsInZhbHVlIjoiLzlKWGt2cUxhWkJyL1JzQitVWGFaZjAwMjRlTzdSLzUzb2NRclgvSXFVa2RaOW8xVVg2WjMzMmF" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InRmWHZGZTJMWG0xdlVqakNua3BIS3c9PSIsInZhbHVlIjoibGxMM2F5RXNIUzBYYnFWSDhnejkxbE9IdUVWVzhVdVc0WEhjSllKMkRaQk4wTmRYTHpHSmI1NkxPMEEvS1lUSU40eW5HeDd0cjZlQWdlNFBrS2poN3hSS0dPUTVwa280RUJRUVMvUkkvVkdueDFOZUJFWXNEeXhEVGlsUUQvaisiLCJtYWMiOiJhYjVjNzA4ZDlhZDc3NTk3ZTAwNmZhMDQ0NTdlOTY3ZjRlNjNkM2YyOTE0ODQ3ZTk3NDE5MzE0YmRjZDk0ZjllIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 08:23:50 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InRmWHZGZTJMWG0xdlVqakNua3BIS3c9PSIsInZhbHVlIjoibGxMM2F5RXNIUzBYYnFWSDhnejkxbE9IdUVWVzhVdVc0WEhjSllKMkRaQk4wTmRYTHpHSmI1NkxPMEEvS1lUSU40eW5He" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkdXQXpaTUVLZ01Sb3paUE1wNkNtc3c9PSIsInZhbHVlIjoiLzlKWGt2cUxhWkJyL1JzQitVWGFaZjAwMjRlTzdSLzUzb2NRclgvSXFVa2RaOW8xVVg2WjMzMmFWZWdTdFprdVZsSGR3V2pyY2g5R25MWnkyT2F4UENBRVdzTm1pWmZ4Z3BsT2xpcy9mVzIxdElmSElab3J5YlVrZCtqc3A0MnkiLCJtYWMiOiJkM2E2ZjJhMzU0ZjhkNDI0OWMwODM3YmM5NjY3MjE2OWU5OTAwZTU3YTIyN2NhNTI2NTAzODhhNWIxOGVlNWEwIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkdXQXpaTUVLZ01Sb3paUE1wNkNtc3c9PSIsInZhbHVlIjoiLzlKWGt2cUxhWkJyL1JzQitVWGFaZjAwMjRlTzdSLzUzb2NRclgvSXFVa2RaOW8xVVg2WjMzMmF" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "izaeeQJLDumsE5BkolVePbfwtoIzBhnnGpxs0Jxg" "uc_cart_id" => "92890b0e39555403f85a9400ea1dbadb" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/107076" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 20:23:50GET/article/107076514361