Generic placeholder image

Current Drug Safety

Editor-in-Chief

ISSN (Print): 1574-8863
ISSN (Online): 2212-3911

Research Article

Clinical Pharmacists’ Contribution to Medication Reconciliation in Outpatient Specialty Clinics in Iran

Author(s): Maryam Mehrpooya, Mohammad-Reza Khorami, Mojdeh Mohammadi, Younes Mohammadi and Davoud Ahmadimoghaddam*

Volume 17, Issue 3, 2022

Published on: 01 February, 2022

Page: [259 - 268] Pages: 10

DOI: 10.2174/1574886316666211123101002

Price: $65

Abstract

Background: The majority of research in medication reconciliation has focused on the inpatient settings, and little is known about the outpatient settings, particularly in developing countries. As such, we conducted this study to evaluate direct clinical pharmacist involvement in medication reconciliation in outpatient specialty clinics in Iran.

Methods: This prospective interventional study was conducted from September 2019 to February 2020 in a University-affiliated clinic in Iran. For 196 patients over 18 years of age who were scheduled for an appointment with a physician, medication reconciliation intervention was carried out by a clinical pharmacist. The number and type of unintentional discrepancies, their potential harm to the patients, their correlation with the patients' demographic and clinical characteristics, and the number of accepted recommendations upon the unintentional discrepancies by the clinicians were assessed and recorded. Additionally, patients' understanding of any change made to their current medication regimen was also assessed.

Results: In total, 57.14% of patients had at least one or more unintentional medication discrepancies, with an overall rate of 1.51 (±0.62) per patient. This is while the patient understanding of their medication changes was inadequate in a significant proportion of the study patients (62.2%). Patients with older ages, lower educational levels, and a higher number of medications and comorbidities were at a higher risk of having unintentional discrepancies. The most common type of unintentional discrepancy was the omission of a drug, and almost half of the reconciliation errors might have had the potential to cause moderate or severe harm to the patient. From 145 recommendations suggested by the clinical pharmacist upon unintentional discrepancies, 131 cases (90.34%) were accepted and implemented by the clinicians.

Conclusion: These findings further support the need for conducting medication reconciliation in outpatient settings to identify discrepancies and enhance the safety of patient medication use.

Keywords: Medication reconciliation, medication discrepancy, outpatient setting, medication error, medication safety, patient safety, clinical pharmacist.

Graphical Abstract

[1]
Ernst FR, Grizzle AJ. Drug-related morbidity and mortality: Updating the cost-of-illness model. J Am Pharm Assoc 2001; 41(2): 192-9.
[http://dx.doi.org/10.1016/S1086-5802(16)31229-3]
[2]
Gandhi TK, Weingart SN, Borus J, et al. Adverse drug events in ambulatory care. N Engl J Med 2003; 348(16): 1556-64.
[http://dx.doi.org/10.1056/NEJMsa020703] [PMID: 12700376]
[3]
Bates DW, Cullen DJ, Laird N, et al. Incidence of adverse drug events and potential adverse drug events. Implications for prevention. JAMA 1995; 274(1): 29-34.
[http://dx.doi.org/10.1001/jama.1995.03530010043033] [PMID: 7791255]
[4]
von Laue NC, Schwappach DL, Koeck CM. The epidemiology of preventable adverse drug events: A review of the literature. Wien Klin Wochenschr 2003; 115(12): 407-15.
[http://dx.doi.org/10.1007/BF03040432] [PMID: 12918183]
[5]
Health UDo, Services H. National Action Plan for Adverse Drug Event Prevention. Washington, DC. 2018. 2018. Available from: https://health.gov/our-work/national-health-initiatives/health- care-quality/adverse-drug-events/national-ade-action-plan
[6]
Improvement IfH. Medication reconciliation to prevent adverse drug events. 2017.
[7]
Sullivan C, Gleason KM, Rooney D, Groszek JM, Barnard C. Medication reconciliation in the acute care setting: Opportunity and challenge for nursing. J Nurs Care Qual 2005; 20(2): 95-8.
[http://dx.doi.org/10.1097/00001786-200504000-00001] [PMID: 15839287]
[8]
Hennen CR, Jorgenson JA. Importance of medication reconciliation in the continuum of care. Am J Pharm Benefits 2014; 6(2): 71-5.
[9]
Forjuoh SN, Reis MD, Couchman GR, Symm B, Mason S, O’Banon R. Physician response to written feedback on a medication discrepancy found with their elderly ambulatory patients. J Am Geriatr Soc 2005; 53(12): 2173-7.
[http://dx.doi.org/10.1111/j.1532-5415.2005.00497.x] [PMID: 16398905]
[10]
Plews-Ogan ML, Nadkarni MM, Forren S, et al. Patient safety in the ambulatory setting. A clinician-based approach. J Gen Intern Med 2004; 19(7): 719-25.
[http://dx.doi.org/10.1111/j.1525-1497.2004.30386.x] [PMID: 15209584]
[11]
Bedell SE, Jabbour S, Goldberg R, et al. Discrepancies in the use of medications: Their extent and predictors in an outpatient practice. Arch Intern Med 2000; 160(14): 2129-34.
[http://dx.doi.org/10.1001/archinte.160.14.2129] [PMID: 10904455]
[12]
Bikowski RM, Ripsin CM, Lorraine VL. Physician-patient congruence regarding medication regimens. J Am Geriatr Soc 2001; 49(10): 1353-7.
[http://dx.doi.org/10.1046/j.1532-5415.2001.49265.x] [PMID: 11890495]
[13]
Nassaralla CL, Naessens JM, Chaudhry R, Hansen MA, Scheitel SM. Implementation of a medication reconciliation process in an ambulatory internal medicine clinic. Qual Saf Health Care 2007; 16(2): 90-4.
[http://dx.doi.org/10.1136/qshc.2006.021113] [PMID: 17403752]
[14]
Radfar M, Rastegarpanah M, Gholami K. The evolution of clinical pharmacy in Iran, past to present. Iran J Public Health 2009; 38(Suppl. 1): 136-7.
[15]
Noormandi A, Karimzadeh I, Mirjalili M, Khalili H. Clinical and economic impacts of clinical pharmacists’ interventions in Iran: A systematic review. Daru 2019; 27(1): 361-78.
[http://dx.doi.org/10.1007/s40199-019-00245-8] [PMID: 30674033]
[16]
Tan EC, Stewart K, Elliott RA, George J. Pharmacist consultations in general practice clinics: The Pharmacists in Practice Study (PIPS). Res Social Adm Pharm 2014; 10(4): 623-32.
[http://dx.doi.org/10.1016/j.sapharm.2013.08.005] [PMID: 24095088]
[17]
Skrbo A, Begović B, Skrbo S. Classification of drugs using the ATC system (Anatomic, Therapeutic, Chemical Classification) and the latest changes. Med Arh 2004; 58(1)(Suppl. 2): 138-41.
[PMID: 15137231]
[18]
Cornish PL, Knowles SR, Marchesano R, et al. Unintended medication discrepancies at the time of hospital admission. Arch Intern Med 2005; 165(4): 424-9.
[http://dx.doi.org/10.1001/archinte.165.4.424] [PMID: 15738372]
[19]
Friedman AL, Geoghegan SR, Sowers NM, Kulkarni S, Formica RN Jr. Medication errors in the outpatient setting: Classification and root cause analysis. Arch Surg 2007; 142(3): 278-83.
[http://dx.doi.org/10.1001/archsurg.142.3.278] [PMID: 17372053]
[20]
Kwan JL, Lo L, Sampson M, Shojania KG. Medication reconciliation during transitions of care as a patient safety strategy: A systematic review. Ann Intern Med 2013; 158(5 Pt 2): 397-403.
[http://dx.doi.org/10.7326/0003-4819-158-5-201303051-00006] [PMID: 23460096]
[21]
Stewart AL, Lynch KJ. Identifying discrepancies in electronic medical records through pharmacist medication reconciliation. J Am Pharm Assoc (Wash DC) 2012; 52(1): 59-66.
[http://dx.doi.org/10.1331/JAPhA.2012.10123] [PMID: 22257617]
[22]
Milone AS, Philbrick AM, Harris IM, Fallert CJ. Medication reconciliation by clinical pharmacists in an outpatient family medicine clinic. J Am Pharm Assoc (Wash DC) 2014; 54(2): 181-7.
[http://dx.doi.org/10.1331/JAPhA.2014.12230] [PMID: 24531920]
[23]
Johnson CM, Marcy TR, Harrison DL, Young RE, Stevens EL, Shadid J. Medication reconciliation in a community pharmacy setting. J Am Pharm Assoc (Wash DC) 2010; 50(4): 523-6.
[http://dx.doi.org/10.1331/JAPhA.2010.09121] [PMID: 20621871]
[24]
Simoons M, Mulder H, Risselada AJ, Wilmink FW, Schoevers R, Ruhé HG. Medication discrepancies at outpatient departments for mood and anxiety disorders in the Netherlands: risks and clinical relevance. J clin psych 2016; 77(11)
[http://dx.doi.org/10.4088/JCP.15m10376]
[25]
Varkey P, Cunningham J, Bisping DS. Improving medication reconciliation in the outpatient setting. Jt Comm J Qual Patient Saf 2007; 33(5): 286-92.
[http://dx.doi.org/10.1016/S1553-7250(07)33033-X] [PMID: 17503684]
[26]
Hias J, Van der Linden L, Spriet I, et al. Predictors for unintentional medication reconciliation discrepancies in preadmission medication: A systematic review. Eur J Clin Pharmacol 2017; 73(11): 1355-77.
[http://dx.doi.org/10.1007/s00228-017-2308-1] [PMID: 28744584]
[27]
Gleason KM, McDaniel MR, Feinglass J, et al. Results of the Medications at Transitions and Clinical Handoffs (MATCH) study: An analysis of medication reconciliation errors and risk factors at hospital admission. J Gen Intern Med 2010; 25(5): 441-7.
[http://dx.doi.org/10.1007/s11606-010-1256-6] [PMID: 20180158]
[28]
Coffey M, Cornish P, Koonthanam T, Etchells E, Matlow A. Implementation of admission medication reconciliation at two academic health sciences centres: Challenges and success factors. Healthcare quarterly (Toronto, Ont) 2009; 12: 102-9.
[29]
Gattari TB, Krieger LN, Hu HM, Mychaliska KP. Medication discrepancies at pediatric hospital discharge. Hosp Pediatr 2015; 5(8): 439-45.
[http://dx.doi.org/10.1542/hpeds.2014-0085] [PMID: 26231634]
[30]
Huynh C, Jani Y, Tomlin S, Terry D, Sinclair A, Wilson K. Epidemiology of medication discrepancies upon hospital admission in children–A systematic review. Archives of Disease in Childhood 2012; 97(5): e7.
[http://dx.doi.org/10.1136/archdischild-2012-301728.14]
[31]
Fernandes O, Shojania KG. Medication reconciliation in the hospital: What, why, where, when, who and how? Healthc Q 2012; 15(Spec No): 42-9.
[http://dx.doi.org/10.12927/hcq.2012.22842] [PMID: 22874446]
[32]
Tam VC, Knowles SR, Cornish PL, Fine N, Marchesano R, Etchells EE. Frequency, type and clinical importance of medication history errors at admission to hospital: A systematic review. CMAJ 2005; 173(5): 510-5.
[http://dx.doi.org/10.1503/cmaj.045311] [PMID: 16129874]
[33]
Barrett P, Cooper J, Douglas J, Edwards MS, Gleason KM, Hansen K. ASHP statement on the pharmacist’s role in medication reconciliation. Am J Health Syst Pharm 2013; 70(5): 453-6.
[http://dx.doi.org/10.2146/sp120009] [PMID: 23413171]
[34]
Reeder TA, Mutnick A. Pharmacist- versus physician-obtained medication histories. Am J Health Syst Pharm 2008; 65(9): 857-60.
[http://dx.doi.org/10.2146/ajhp070292] [PMID: 18436732]
[35]
Patel E, Pevnick JM, Kennelty KA. Pharmacists and medication reconciliation: A review of recent literature. Integr Pharm Res Pract 2019; 8: 39-45.
[http://dx.doi.org/10.2147/IPRP.S169727] [PMID: 31119096]
[36]
Mira JJ, Orozco-Beltrán D, Pérez-Jover V, et al. Physician patient communication failure facilitates medication errors in older polymedicated patients with multiple comorbidities. Fam Pract 2013; 30(1): 56-63.
[http://dx.doi.org/10.1093/fampra/cms046] [PMID: 22904014]
[37]
Guide H-T. Prevent adverse drug events by implementing medication reconciliation. Institute for Healthcare Improvement 2011; pp. 2020-12.
[38]
Ramjaun A, Sudarshan M, Patakfalvi L, Tamblyn R, Meguerditchian AN. Educating medical trainees on medication reconciliation: A systematic review. BMC Med Educ 2015; 15(1): 33.
[http://dx.doi.org/10.1186/s12909-015-0306-5] [PMID: 25879196]
[39]
Gortney JS, Moser LR, Patel P, Raub JN. Clinical outcomes of student pharmacist-driven medication histories at an Academic Medical Center. J Pharm Pract 2019; 32(4): 404-11.
[http://dx.doi.org/10.1177/0897190018759224] [PMID: 29463169]
[40]
Ziaeian B, Araujo KL, Van Ness PH, Horwitz LI. Medication reconciliation accuracy and patient understanding of intended medication changes on hospital discharge. J Gen Intern Med 2012; 27(11): 1513-20.
[http://dx.doi.org/10.1007/s11606-012-2168-4] [PMID: 22798200]
[41]
Freyer J, Greißing C, Buchal P, Kabitz H, Kasprick L, Schuchmann M. Discharge medication-what do patients know about their medication on discharge? Deutsche Medizinische Wochenschrift 2016; 141(15): e150-156.
[42]
Maniaci MJ, Heckman MG, Dawson NL. Functional health literacy and understanding of medications at discharge. Mayo Clinic Proc 2008; 83(5): 554-8.
[43]
Botermann L, Krueger K, Eickhoff C, Kloft C, Schulz M. Patients’ handling of a standardized medication plan: A pilot study and method development. Patient Prefer Adherence 2016; 10: 621-30.
[http://dx.doi.org/10.2147/PPA.S96431] [PMID: 27175062]
[44]
Tarn DM, Heritage J, Paterniti DA, Hays RD, Kravitz RL, Wenger NS. Physician communication when prescribing new medications. Arch Intern Med 2006; 166(17): 1855-62.
[http://dx.doi.org/10.1001/archinte.166.17.1855] [PMID: 17000942]
[45]
Allende Bandrés MÁ, Arenere Mendoza M, Gutiérrez Nicolás F, Calleja Hernández MÁ, Ruiz La Iglesia F. Pharmacist-led medication reconciliation to reduce discrepancies in transitions of care in Spain. Int J Clin Pharm 2013; 35(6): 1083-90.
[http://dx.doi.org/10.1007/s11096-013-9824-6] [PMID: 23881347]
[46]
Lin M, Hackenyos D, Savidge N, Weidner RA, Murphy-Banks R, Fleckner T. Enhancing patients’ understanding of and adherence to oral anticancer medication: Results of a longitudinal pilot intervention. J Oncol Pharm Pract 2020; 1078155220960800.
[PMID: 32996363]
[47]
Elberkawi E, Ed. Application of Electronic Health Records in Polyclinics: Barriers & Benefits. International Conference on Data Science, E-learning and Information Systems. 5-7 April 2021; Ma’an, Jordan. New York. ACM, Inc. 2021.
[48]
Phansalkar S, Her QL, Tucker AD, et al. Impact of incorporating pharmacy claims data into electronic medication reconciliation. Am J Health Syst Pharm 2015; 72(3): 212-7.
[http://dx.doi.org/10.2146/ajhp140082] [PMID: 25596605]
[49]
Staroselsky M, Volk LA, Tsurikova R, et al. An effort to improve electronic health record medication list accuracy between visits: Patients’ and physicians’ response. Int J Med Inform 2008; 77(3): 153-60.
[http://dx.doi.org/10.1016/j.ijmedinf.2007.03.001] [PMID: 17434337]
[50]
Zoni AC, Durán García ME, Jiménez Muñoz AB, Salomón Pérez R, Martin P, Herranz Alonso A. The impact of medication reconciliation program at admission in an internal medicine department. Eur J Intern Med 2012; 23(8): 696-700.
[http://dx.doi.org/10.1016/j.ejim.2012.08.013] [PMID: 23021790]
[51]
Salameh LK, Abu Farha RK, Abu Hammour KM, Basheti IA. Impact of pharmacist’s directed medication reconciliation on reducing medication discrepancies during transition of care in hospital setting. J Pharm Health Serv Res 2019; 10(1): 149-56.
[http://dx.doi.org/10.1111/jphs.12261]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version280msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[18:58:57] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[18:58:57] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[18:58:57] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[18:58:57] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (103ms)time
  • Application (177ms)time
  • 1 x Application (63.19%)
    177ms
    1 x Booting (36.8%)
    103ms
    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 duplicated103ms
    • 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 ('51322660','',1,1740423537,1740423537) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740423537
      1.56msalphaeurekaselec_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 ('51322660','/article/119010',1,1740423537,1740423537)
      250μ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 >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) 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 >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) 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 >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) 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 >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) 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 >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) 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 >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51322660 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51322660) limit 1
      36.31msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51322660
      • 1: 51322660
      • 2: 51322660
      • 3: 51322660
      • 4: 51322660
      • 5: 51322660
      • 6: 51322660
      • 7: 51322660
      • 8: 51322660
      • 9: 51322660
      • 10: 51322660
      • 11: 51322660
      • 12: 51322660
      • 13: 51322660
      • 14: 51322660
      • 15: 51322660
      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=119010
      960μ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` = 11 limit 1
      920μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 11
      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=11) and sj.journal_id!=11 group by `j`.`nid`) as `aggregate_table`
      2.04msalphaeurekaselec_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=11) and sj.journal_id!=11 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      890μ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=11) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.8msalphaeurekaselec_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=11) 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.62msalphaeurekaselec_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` = '119010'
      830μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 119010
      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` = '119010'
      2.95msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 119010
      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` = '119010' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.94msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 119010
      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
      260μ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
      510μ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 = 11 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      23.77msalphaeurekaselec_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 = 11 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.33msalphaeurekaselec_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 = 11 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      3.75msalphaeurekaselec_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` = 119010 limit 1
      500μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 119010
      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 = 119010 and content_type = 'article' order by status desc limit 1
      330μ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` = 198207 limit 1
      250μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 198207
      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
      270μ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` = 'CDS' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      300μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CDS
      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 = '119010' 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) )
      430μ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 = '11548' 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) )
      350μ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 = '3208' 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) )
      330μ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 <= 51322660 and j.to_ip >=51322660 )) and ((j.from_date <= 1740423537 and j.to_date >= 1740423537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3208) 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 <= 51322660 and j.to_ip >=51322660 )) and ((j.from_date <= 1740423537 and j.to_date >= 1740423537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3208) 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 <= 51322660 and j.to_ip >=51322660 )) and ((j.from_date <= 1740423537 and j.to_date >= 1740423537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3208)
      5.68msalphaeurekaselec_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 <= 51322660 and j.to_ip >=51322660 )) and ((j.from_date <= 1740423537 and j.to_date >= 1740423537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11548) 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 <= 51322660 and j.to_ip >=51322660 )) and ((j.from_date <= 1740423537 and j.to_date >= 1740423537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11548) 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 <= 51322660 and j.to_ip >=51322660 )) and ((j.from_date <= 1740423537 and j.to_date >= 1740423537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11548)
      620μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2297
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51322660 and j.to_ip >=51322660 )) and ((j.from_date <= 1740423537 and j.to_date >= 1740423537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 119010) 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 <= 51322660 and j.to_ip >=51322660 )) and ((j.from_date <= 1740423537 and j.to_date >= 1740423537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 119010) 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 <= 51322660 and j.to_ip >=51322660 )) and ((j.from_date <= 1740423537 and j.to_date >= 1740423537 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 119010)
      620μ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` < '259' and is_uploaded = 1 and issue_id = 11548 order by cast(first_page as SIGNED) desc limit 1
      550μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 259
      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` > '268' and is_uploaded = 1 and issue_id = 11548 order by cast(first_page as SIGNED) asc limit 1
      490μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 268
      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'
      200μ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` = 119010 limit 1
      2.44msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 119010
      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` = 11 and `b`.`banner_from_date` <= 1740423537 and `b`.`banner_to_date` >= 1740423537 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.2msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 11
      • 3: 1740423537
      • 4: 1740423537
      • 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` = 11 and `b`.`banner_from_date` <= 1740423537 and `b`.`banner_to_date` >= 1740423537 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.19msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 11
      • 3: 1740423537
      • 4: 1740423537
      • 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='663bff794020d0f41381e91d0a85621f'
      260μ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
        a2Q06nZd5tNzGdQIl0RExttBB1BHjVlSx3DakaDQ
        uc_cart_id
        663bff794020d0f41381e91d0a85621f
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/119010" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/119010
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Mon, 24 Feb 2025 18:58:57 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImlJWWlnOHhjQ2ZzbExtSDAyOWd1Wnc9PSIsInZhbHVlIjoiMCtBWFdhNGprYldRdWNpUXJvdEZsVzNXcndsbm0zcnY5aG1IejMwOG1EL1N6dEVjL0RrQjhiajFVTzVHQXk3NVFsS04wZXh6eFNuQTROVkVtZll3OVdvcHRNdmkyRVF2SmxRd0k1cjBHY25xNUp0aHB0aUJuemxhQ1VrZzFHcDkiLCJtYWMiOiIwZmJlZmE4NGZiOTc5YzYyYzNhY2M5NWU5NWNhMDEwYWRlYjAzNDM5NWNjZDYzOWIyZDcxYjYzYTYwNjdmNDc4IiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 06:58:57 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImlJWWlnOHhjQ2ZzbExtSDAyOWd1Wnc9PSIsInZhbHVlIjoiMCtBWFdhNGprYldRdWNpUXJvdEZsVzNXcndsbm0zcnY5aG1IejMwOG1EL1N6dEVjL0RrQjhiajFVTzVHQXk3NVFsS04wZ" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImhxU1ZkWHRRWHFMKzRSa2pVRENWMkE9PSIsInZhbHVlIjoiU1lLRmZYRTF0a3BkSmpTR3BIdzJ4SytVZmVhRDBQS3EyS3dqb00wODJIbkVLU3haanozcXJXSlhPb1Q5TENiWHVMMTkvcXZHOG1DWHp6bzFNMmtzNFhwQTY4Yjd2aDM2ZE5RYVorT2FYSWxwY2xFc0JXeDBHS0Y1bEZDbjJLOEciLCJtYWMiOiJmYzY0MTllYjJkY2Y3ZjVjODcyY2U0NjE3MjljNDI1YTExYTA1ZTFjZWZlZTA5YWEzNWNjOWQ4Nzc5YzU1MTc1IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6ImhxU1ZkWHRRWHFMKzRSa2pVRENWMkE9PSIsInZhbHVlIjoiU1lLRmZYRTF0a3BkSmpTR3BIdzJ4SytVZmVhRDBQS3EyS3dqb00wODJIbkVLU3haanozcXJXSlh" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImlJWWlnOHhjQ2ZzbExtSDAyOWd1Wnc9PSIsInZhbHVlIjoiMCtBWFdhNGprYldRdWNpUXJvdEZsVzNXcndsbm0zcnY5aG1IejMwOG1EL1N6dEVjL0RrQjhiajFVTzVHQXk3NVFsS04wZXh6eFNuQTROVkVtZll3OVdvcHRNdmkyRVF2SmxRd0k1cjBHY25xNUp0aHB0aUJuemxhQ1VrZzFHcDkiLCJtYWMiOiIwZmJlZmE4NGZiOTc5YzYyYzNhY2M5NWU5NWNhMDEwYWRlYjAzNDM5NWNjZDYzOWIyZDcxYjYzYTYwNjdmNDc4IiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 06:58:57 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImlJWWlnOHhjQ2ZzbExtSDAyOWd1Wnc9PSIsInZhbHVlIjoiMCtBWFdhNGprYldRdWNpUXJvdEZsVzNXcndsbm0zcnY5aG1IejMwOG1EL1N6dEVjL0RrQjhiajFVTzVHQXk3NVFsS04wZ" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImhxU1ZkWHRRWHFMKzRSa2pVRENWMkE9PSIsInZhbHVlIjoiU1lLRmZYRTF0a3BkSmpTR3BIdzJ4SytVZmVhRDBQS3EyS3dqb00wODJIbkVLU3haanozcXJXSlhPb1Q5TENiWHVMMTkvcXZHOG1DWHp6bzFNMmtzNFhwQTY4Yjd2aDM2ZE5RYVorT2FYSWxwY2xFc0JXeDBHS0Y1bEZDbjJLOEciLCJtYWMiOiJmYzY0MTllYjJkY2Y3ZjVjODcyY2U0NjE3MjljNDI1YTExYTA1ZTFjZWZlZTA5YWEzNWNjOWQ4Nzc5YzU1MTc1IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6ImhxU1ZkWHRRWHFMKzRSa2pVRENWMkE9PSIsInZhbHVlIjoiU1lLRmZYRTF0a3BkSmpTR3BIdzJ4SytVZmVhRDBQS3EyS3dqb00wODJIbkVLU3haanozcXJXSlh" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "a2Q06nZd5tNzGdQIl0RExttBB1BHjVlSx3DakaDQ" "uc_cart_id" => "663bff794020d0f41381e91d0a85621f" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/119010" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-24 18:58:57GET/article/119010414361