Generic placeholder image

Current Drug Metabolism

Editor-in-Chief

ISSN (Print): 1389-2002
ISSN (Online): 1875-5453

Research Article

A Comparative Study on Sedation Efficacy Between General and Regional Anesthesia with Dexmedetomidine in Patients Under Maxillofacial Surgery

Author(s): Jiang Yanan, Ding Hui, Guo Jianwei, Liu Ronglin, Zhu Lijuan and Zhao Jing*

Volume 23, Issue 11, 2022

Published on: 24 June, 2022

Page: [920 - 927] Pages: 8

DOI: 10.2174/1389200223666220413113412

Price: $65

Abstract

Background and Objective: Securing the airway in the surgery of maxillofacial disorders and traumas is fundamental during the operation. The present study aims to investigate the beneficial sedative effects of dexmedetomidine (DEX) in patients who underwent maxillofacial surgery with regional anesthesia compared to general anesthesia.

Methods: Fifty patients, aged 20-45 years old were randomly divided into two groups of regional anesthesia (RA) and general anesthesia (GA) (each n=25). The group RA received regional block with sedation (DEX: 1 μg/kg infused over 10 min followed by the maintenance dose of 0.5 μg/kg/h) and the group GA underwent general anesthesia (DEX: 0.1 μg/kg/min over 10 min followed by 0.4–0.7 μg/kg/h). Postoperative pain scores, anesthesia outcomes, hemodynamic parameters, the time of the post-anesthesia care unit (PACU) discharge and intra and postoperative complications were comparatively assessed in both groups.

Results: The baseline characteristics of the patients (age, gender, BMI, and ASA physical status) showed no differences between the two groups (P>0.05). Although the duration of surgery and recovery time showed no differences between the groups, the duration of anesthesia and extubation time was remarkably lower in the RA group than in the GA group (P<0.01). Administration of nerve blocks demonstrated less pain and longer sleep time in the postoperative phase as compared to the GA group. Heart rate and mean arterial blood pressure were significantly less in the RA group at the end of the loading dose of DEX and incision time (P<0.05). SpO2, respiration rate and Ramsay sedation scale did not exhibit any significant differences between the two groups at all-time points (P>0.05). No significant differences were observed with regard to the adverse events between the two groups (P>0.05).

Conclusions: Although our findings revealed that both methods are suitable and safe methods for maxillofacial surgery, the outcomes of anesthesia with regional block and sedation include less pain in the postoperative phase, shorter extubation time and earlier discharge from the PACU demonstrated that this method is more reliable for maxillofacial surgery. Further controlled studies are needed to compare the effectiveness and safety profiles of two RA and GA techniques and also to compare DEX with other anesthetic agents to achieve optimum outcomes in maxillofacial surgeries.

Keywords: Dexmedetomidine, Regional anesthesia, General anesthesia, Maxillofacial surgery, Sedation.

Graphical Abstract

[1]
Li, N.; Kong, H.; Li, S-L.; Zhu, S-N.; Wang, D-X. Combined epidural-general anesthesia was associated with lower risk of postoperative complications in patients undergoing open abdominal surgery for pheochromocytoma: A retrospective cohort study. PLoS One, 2018, 13(2), e0192924.
[http://dx.doi.org/10.1371/journal.pone.0192924] [PMID: 29466473]
[2]
Gautam, V.; Desai, P.; Shah, K. Retrospective Comparison of Two Different Techniques of Airway Management in Temporomandibular Joint Ankylosis Patients within Paediatric Age Group. Med. Surg., 2018, 8(11), 1348-1350.
[3]
Wang, Y-H.; Wang, D-R.; Liu, J-Y.; Pan, J. Local anesthesia in oral and maxillofacial surgery: A review of current opinion. J. Dent. Sci., 2021, 16(4), 1055-1065.
[PMID: 34484571]
[4]
Gajiwala, K.J. Surgery of temporomandibular joint under local anaesthesia. Indian J. Plast. Surg., 2008, 41(2), 175-182.
[http://dx.doi.org/10.4103/0970-0358.44941] [PMID: 19753260]
[5]
Walz, C.; Pape, H.D.; Lenz, M. Miniplate osteosynthesis of mandibular fracture in local anesthesia--indications and outcome in 316 pa-tients Fortschr. Kiefer Gesichtschir., 1996, 41, 133-135.
[PMID: 8755424]
[6]
Rastogi, A.; Gyanesh, P.; Nisha, S.; Agarwal, A.; Mishra, P.; Tiwari, A.K. Comparison of general anaesthesia versus regional anaesthesia with sedation in selected maxillofacial surgery: A randomized controlled trial. J. Craniomaxillofac. Surg., 2014, 42(3), 250-254.
[http://dx.doi.org/10.1016/j.jcms.2013.05.010] [PMID: 23800753]
[7]
Cummings, D.R.; Yamashita, D-D.R.; McAndrews, J.P. Complications of local anesthesia used in oral and maxillofacial surgery. Oral Maxillofac. Surg. Clin. North Am., 2011, 23(3), 369-377.
[http://dx.doi.org/10.1016/j.coms.2011.04.009] [PMID: 21798437]
[8]
Haas, D.A. An update on local anesthetics in dentistry. J. Can. Dent. Assoc., 2002, 68(9), 546-551.
[PMID: 12366885]
[9]
Peng, W.; Zhang, T.; Wang, Y. Comparison of propofol-hydromorphone and propofol-dexmedetomidine in patients with intubation after maxillofacial plastic surgery. Ther. Clin. Risk Manag., 2016, 12, 373-377.
[PMID: 27022268]
[10]
Faust, A.C.; Rajan, P.; Sheperd, L.A.; Alvarez, C.A.; McCorstin, P.; Doebele, R.L. Impact of an analgesia-based sedation protocol on mechan-ically ventilated patients in a medical intensive care unit. Anesth. Analg., 2016, 123(4), 903-909.
[http://dx.doi.org/10.1213/ANE.0000000000001393] [PMID: 27644010]
[11]
General assembly of the world medical association. World medical association declaration of helsinki: Ethical principles for medical research involving human subjects. J. Am. Coll. Dent., 2014, 81(3), 14-18.
[PMID: 25951678]
[12]
Dawson, R.; von Fintel, N.; Nairn, S. Sedation assessment using the Ramsay scale. Emerg. Nurse, 2010, 18(3), 18-20.
[http://dx.doi.org/10.7748/en2010.06.18.3.18.c7825] [PMID: 20608397]
[13]
Mukhopadhyay, S. A retrospective study of mandibular fractures in children. J. Korean Assoc. Oral Maxillofac. Surg., 2018, 44(6), 269-274.
[http://dx.doi.org/10.5125/jkaoms.2018.44.6.269] [PMID: 30637240]
[14]
Barak, M.; Bahouth, H.; Leiser, Y.; Abu El-Naaj, I. Airway management of the patient with maxillofacial trauma: Review of the literature and suggested clinical approach. BioMed Res. Int., 2015, 2015, 24032.
[http://dx.doi.org/10.1155/2015/724032]
[15]
Dhasmana, S.; Singh, V.; Mohammad, S.; Pal, U.S. Temporomandibular joint interpositional gap arthroplasty under intravenous (I.V) con-scious sedation. J. Maxillofac. Oral Surg., 2009, 8(4), 372-374.
[http://dx.doi.org/10.1007/s12663-009-0089-5] [PMID: 23139547]
[16]
Yan, Y-B.; Liang, S-X.; Shen, J.; Zhang, J-C.; Zhang, Y. Current concepts in the pathogenesis of traumatic temporomandibular joint ankylo-sis. Head Face Med., 2014, 10(1), 35.
[http://dx.doi.org/10.1186/1746-160X-10-35] [PMID: 25189735]
[17]
Stratmann, G.; Lee, J.; Sall, J.W.; Lee, B.H.; Alvi, R.S.; Shih, J.; Rowe, A.M.; Ramage, T.M.; Chang, F.L.; Alexander, T.G.; Lempert, D.K.; Lin, N.; Siu, K.H.; Elphick, S.A.; Wong, A.; Schnair, C.I.; Vu, A.F.; Chan, J.T.; Zai, H.; Wong, M.K.; Anthony, A.M.; Barbour, K.C.; Ben-Tzur, D.; Kazarian, N.E.; Lee, J.Y.; Shen, J.R.; Liu, E.; Behniwal, G.S.; Lammers, C.R.; Quinones, Z.; Aggarwal, A.; Cedars, E.; Yonelinas, A.P.; Ghetti, S. Effect of general anesthesia in infancy on long-term recognition memory in humans and rats. Neuropsychopharmacology, 2014, 39(10), 2275-2287.
[http://dx.doi.org/10.1038/npp.2014.134] [PMID: 24910347]
[18]
Jain, G.; Yadav, G.; Singh, A.P.; Singh, Y.; Singh, D.K. Efficacy of ultrasound-guided mandibular block in predicting safer anesthetic induc-tion. Anesth. Essays Res., 2016, 10(2), 184-188.
[http://dx.doi.org/10.4103/0259-1162.176406] [PMID: 27212744]
[19]
Goswami, D.; Singh, S.; Bhutia, O.; Baidya, D.; Sawhney, C. Management of young patients with temporomandibular joint ankylosis—a sur-gical and anesthetic challenge. Indian J. Surg., 2016, 78(6), 482-489.
[http://dx.doi.org/10.1007/s12262-016-1551-5] [PMID: 28100946]
[20]
Memtsoudis, S.G.; Cozowicz, C.; Nagappa, M.; Wong, J.; Joshi, G.P.; Wong, D.T.; Doufas, A.G.; Yilmaz, M.; Stein, M.H.; Krajewski, M.L.; Singh, M.; Pichler, L.; Ramachandran, S.K.; Chung, F. Society of anesthesia and sleep medicine guideline on intraoperative management of adult patients with obstructive sleep apnea. Anesth. Analg., 2018, 127(4), 967-987.
[http://dx.doi.org/10.1213/ANE.0000000000003434] [PMID: 29944522]
[21]
Abdul Hadi, B.; Sbeitan, S.M.; Shakya, A.K. Fentanyl vs. fentanyl-dexmedetomidine in lumbar foraminotomy surgery. Ther. Clin. Risk Manag., 2019, 15, 885-890.
[http://dx.doi.org/10.2147/TCRM.S195108] [PMID: 31406463]
[22]
Lu, W.; Fu, Q.; Luo, X.; Fu, S.; Hu, K. Effects of dexmedetomidine on sleep quality of patients after surgery without mechanical ventilation in ICU. Medicine (Baltimore), 2017, 96(23), e7081.
[http://dx.doi.org/10.1097/MD.0000000000007081] [PMID: 28591048]
[23]
Su, X.; Meng, Z.T.; Wu, X.H.; Cui, F.; Li, H.L.; Wang, D.X.; Zhu, X.; Zhu, S.N.; Maze, M.; Ma, D. Dexmedetomidine for prevention of delir-ium in elderly patients after non-cardiac surgery: A randomised, double-blind, placebo-controlled trial. Lancet, 2016, 388(10054), 1893-1902.
[http://dx.doi.org/10.1016/S0140-6736(16)30580-3] [PMID: 27542303]
[24]
Liu, Y.; Zhu, X.; Zhou, D.; Han, F.; Yang, X. Dexmedetomidine for prevention of postoperative pulmonary complications in patients after oral and maxillofacial surgery with fibular free flap reconstruction: A prospective, double-blind, randomized, placebo-controlled trial. BMC Anesthesiol., 2020, 20(1), 127.
[http://dx.doi.org/10.1186/s12871-020-01045-3] [PMID: 32460699]
[25]
Wang, L; Zhang, T; Huang, L; Peng, W Comparison between dexmedetomidine and midazolam for sedation in patients with intubation after oral and maxillofacial surgery. Biomed Res Int, 2020, 2020
[http://dx.doi.org/10.1155/2020/7082597]
[26]
Weinstein, EJ; Levene, JL; Cohen, MS; Andreae, DA; Chao, JY; Johnson, M Local anaesthetics and regional anaesthesia versus conventional analgesia for preventing persistent postoperative pain in adults and children., Cochrane Database Syst Rev., 2018, (6)
[27]
Hines, S.; Steels, E.; Chang, A.; Gibbons, K. Aromatherapy for treatment of postoperative nausea and vomiting. Cochrane Database Syst. Rev., 2018, 2018(3), CD007958.
[http://dx.doi.org/10.1002/14651858.CD007598.pub3]
[28]
Perisanidis, C.; Saranteas, T.; Kostopanagiotou, G. Ultrasound-guided combined intermediate and deep cervical plexus nerve block for re-gional anaesthesia in oral and maxillofacial surgery. Dentomaxillofac. Radiol., 2013, 42(2), 29945724.
[http://dx.doi.org/10.1259/dmfr/29945724] [PMID: 22933534]
[29]
Uys, M.M.; Shahid, M.; Harvey, B.H. Therapeutic potential of selectively targeting the α2c-adrenoceptor in cognition, depression, and schizo-phrenia-new developments and future perspective. Front. Psychiatry, 2017, 8(AUG), 144.
[http://dx.doi.org/10.3389/fpsyt.2017.00144] [PMID: 28855875]
[30]
Aantaa, R.; Jalonen, J. Perioperative use of alpha2-adrenoceptor agonists and the cardiac patient. Eur. J. Anaesthesiol., 2006, 23(5), 361-372.
[http://dx.doi.org/10.1017/S0265021506000378] [PMID: 16507202]
[31]
Sprinks, J.; Worcester, F.; Breedon, P.; Watts, P.; Hewson, D.; Bedforth, N. A prototype patient-maintained propofol sedation system using target controlled infusion for primary lower-limb arthroplasty. J. Med. Syst., 2019, 43(8), 247.
[http://dx.doi.org/10.1007/s10916-019-1377-3] [PMID: 31243603]
[32]
Wu, Y.; Zhang, Y.; Hu, X.; Qian, C.; Zhou, Y.; Xie, J. A comparison of propofol vs. dexmedetomidine for sedation, haemodynamic control and satisfaction, during esophagogastroduodenoscopy under conscious sedation. J. Clin. Pharm. Ther., 2015, 40(4), 419-425.
[http://dx.doi.org/10.1111/jcpt.12282] [PMID: 25970229]
[33]
Cheng, X.; Zuo, Y.; Zhao, Q.; Gu, E.; Huang, Y. Comparison of the effects of dexmedetomidine and propofol on hemodynamics and oxygen balance in children with complex congenital heart disease undergoing cardiac surgery. Congenit. Heart Dis., 2015, 10(3), E123-E130.
[http://dx.doi.org/10.1111/chd.12228] [PMID: 25346460]
[34]
Ebert, T.J.; Hall, J.E.; Barney, J.A.; Uhrich, T.D.; Colinco, M.D. The effects of increasing plasma concentrations of dexmedetomidine in hu-mans. Anesthesiology, 2000, 93(2), 382-394.
[http://dx.doi.org/10.1097/00000542-200008000-00016] [PMID: 10910487]
[35]
Hsu, Y.W.; Cortinez, L.I.; Robertson, K.M.; Keifer, J.C.; Sum-Ping, S.T.; Moretti, E.W.; Young, C.C.; Wright, D.R.; Macleod, D.B.; Somma, J. Dexmedetomidine pharmacodynamics: Part I: Crossover comparison of the respiratory effects of dexmedetomidine and remifentanil in healthy volunteers. Anesthesiology, 2004, 101(5), 1066-1076.
[http://dx.doi.org/10.1097/00000542-200411000-00005] [PMID: 15505441]
[36]
Techanivate, A.; Verawattaganon, T.; Chuleepor Saiyuenyong, P.A. A comparison of dexmedetomidine versus propofol on hypotension during colonoscopy under sedation. J. Anesth. Clin. Res., 2012, 3(11), 2-6.
[http://dx.doi.org/10.4172/2155-6148.1000257]
[37]
Koroglu, A.; Teksan, H.; Sagir, O.; Yucel, A.; Toprak, H.I.; Ersoy, O.M. A comparison of the sedative, hemodynamic, and respiratory effects of dexmedetomidine and propofol in children undergoing magnetic resonance imaging. Anesth. Analg., 2006, 103(1), 63-67.
[http://dx.doi.org/10.1213/01.ANE.0000219592.82598.AA] [PMID: 16790627]
[38]
Yalcin, B.K. Complications associated with local anesthesia in oral and maxillofacial surgery. Topics in Local Anesthetics; IntechOpen, 2019.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version283msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[13:35:25] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[13:35:25] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[13:35:25] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[13:35:25] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (102ms)time
  • Application (180ms)time
  • 1 x Application (63.78%)
    180ms
    1 x Booting (36.22%)
    102ms
    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 duplicated106ms
    • 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 ('314536017','',1,1739972125,1739972125) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739972125
      1.12msalphaeurekaselec_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 ('314536017','/article/122534',1,1739972125,1739972125)
      210μ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 >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) 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 >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) 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 >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) 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 >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) 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 >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) 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 >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314536017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314536017) limit 1
      19.14msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314536017
      • 1: 314536017
      • 2: 314536017
      • 3: 314536017
      • 4: 314536017
      • 5: 314536017
      • 6: 314536017
      • 7: 314536017
      • 8: 314536017
      • 9: 314536017
      • 10: 314536017
      • 11: 314536017
      • 12: 314536017
      • 13: 314536017
      • 14: 314536017
      • 15: 314536017
      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=122534
      910μ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` = 15 limit 1
      1msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 15
      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=15) and sj.journal_id!=15 group by `j`.`nid`) as `aggregate_table`
      1.55msalphaeurekaselec_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=15) and sj.journal_id!=15 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.28msalphaeurekaselec_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=15) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.75msalphaeurekaselec_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=15) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      2.52msalphaeurekaselec_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` = '122534'
      1.63msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 122534
      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` = '122534'
      2.69msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 122534
      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` = '122534' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.08msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 122534
      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
      270μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      490μsalphaeurekaselec_live_10_06_2022Article.php#1960
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1960
      • 14. app/Http/Controllers/ArticleController.php:2062
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • Select j.subtitle, v.volume_id as volume_id,v.year_id,y.year as year,v.volume_name, v.total_no_of_issues, i.issue_id as issue_id,i.title as issue, i.publication_date as issue_pub_date from journal j join volume v on j.journal_id = v.journal_id join issue i on v.volume_id = i.volume_id join article a on a.issue_id = i.issue_id join year y on v.year_id = y.id where j.journal_id = 15 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      27.26msalphaeurekaselec_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 = 15 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      12.22msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2070
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 15 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      10.26msalphaeurekaselec_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` = 122534 limit 1
      280μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 122534
      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 = 122534 and content_type = 'article' order by status desc limit 1
      280μ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` = 203518 limit 1
      240μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 203518
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      260μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CDM' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      320μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CDM
      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 = '122534' 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) )
      410μ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 = '12105' 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 = '3252' 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) )
      310μ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 <= 314536017 and j.to_ip >=314536017 )) and ((j.from_date <= 1739972125 and j.to_date >= 1739972125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3252) 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 <= 314536017 and j.to_ip >=314536017 )) and ((j.from_date <= 1739972125 and j.to_date >= 1739972125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3252) 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 <= 314536017 and j.to_ip >=314536017 )) and ((j.from_date <= 1739972125 and j.to_date >= 1739972125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3252)
      7.81msalphaeurekaselec_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 <= 314536017 and j.to_ip >=314536017 )) and ((j.from_date <= 1739972125 and j.to_date >= 1739972125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12105) 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 <= 314536017 and j.to_ip >=314536017 )) and ((j.from_date <= 1739972125 and j.to_date >= 1739972125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12105) 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 <= 314536017 and j.to_ip >=314536017 )) and ((j.from_date <= 1739972125 and j.to_date >= 1739972125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12105)
      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 <= 314536017 and j.to_ip >=314536017 )) and ((j.from_date <= 1739972125 and j.to_date >= 1739972125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 122534) 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 <= 314536017 and j.to_ip >=314536017 )) and ((j.from_date <= 1739972125 and j.to_date >= 1739972125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 122534) 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 <= 314536017 and j.to_ip >=314536017 )) and ((j.from_date <= 1739972125 and j.to_date >= 1739972125 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 122534)
      610μ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` < '920' and is_uploaded = 1 and issue_id = 12105 order by cast(first_page as SIGNED) desc limit 1
      520μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 920
      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` > '927' and is_uploaded = 1 and issue_id = 12105 order by cast(first_page as SIGNED) asc limit 1
      450μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 927
      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'
      190μ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
      230μ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` = 122534 limit 1
      2.49msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 122534
      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` = 15 and `b`.`banner_from_date` <= 1739972125 and `b`.`banner_to_date` >= 1739972125 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.61msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 15
      • 3: 1739972125
      • 4: 1739972125
      • 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` = 15 and `b`.`banner_from_date` <= 1739972125 and `b`.`banner_to_date` >= 1739972125 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.76msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 15
      • 3: 1739972125
      • 4: 1739972125
      • 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='4a9f197bc7c1ecc2961481a6e7511045'
      290μ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
        PuVmgYzZR7gf8B2mLlpYj1yqlhF9QewLma69vZ05
        uc_cart_id
        4a9f197bc7c1ecc2961481a6e7511045
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/122534" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/122534
        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=eyJpdiI6IlBvYlZUSkEwZEMxYmVENnRSeU5DcHc9PSIsInZhbHVlIjoiZTEvdGc0c0h3TEloRGgzR3VoWGg4enhxTlBnOG1HMFpLM3QvOXMvR3VIST0iLCJtYWMiOiIxM2Q0MzFhZWYwZjYxMjQ0OWFkMTk3N2U5OTQ2ZjYwM2NiNmQ4NjI1NmFjYTkxOTZmNGRiNDgxMzViOTA4OWY3IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IlBvYlZUSkEwZEMxYmVENnRSeU5DcHc9PSIsInZhbHVlIjoiZTEvdGc0c0h3TEloRGgzR3VoWGg4enhxTlBnOG1HMFpLM3QvOXMvR3VIST0iLCJtYWMiOiIxM2Q0MzFhZWYwZjYx" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 19 Feb 2025 13:35:25 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InV5eU4xRy9yeXRUN1Y5YjJuUkc5Umc9PSIsInZhbHVlIjoiS1QrTHdoQ1RXVGZWY3M1NnNkV0szTStZcGpkZVZCbE9TcytrYW5NMEl4UU9uY3puVFNXV0dWNDBYSGdTalBQTkZNSTJZMWxkZlVqUnF5QisxOVppbnF0UXVTNzU4NGU3amIwajNpV1pocnoxOEdGZ3ROQnVoOEc1dmdjWVhOT3MiLCJtYWMiOiIxZDc2N2IzNGI4YTJlOTJlMmI4OTMwMTViYTA3ODRmNzYyNjEyODQ1MDE1ZmI0NzViNjc4YmIyYzM4YjUwMWRlIiwidGFnIjoiIn0%3D; expires=Sat, 22 Feb 2025 01:35:25 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InV5eU4xRy9yeXRUN1Y5YjJuUkc5Umc9PSIsInZhbHVlIjoiS1QrTHdoQ1RXVGZWY3M1NnNkV0szTStZcGpkZVZCbE9TcytrYW5NMEl4UU9uY3puVFNXV0dWNDBYSGdTalBQTkZNSTJZM" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlhuUThKTm5lVXRIUXplUXlEa2NHSmc9PSIsInZhbHVlIjoiMFAzc2U1b25GdUdOdXdtclV0akEzRmdYRmhZcnlpUlBUQUxHbWRFWEZTMDE3RkJHWmVlK0tkZk5pd2R1cWpIWk9UMVJST0tmVFdRSkl2R3ZYeEdKME4wamI3SjZQMTcvT0E5RWplRjJnVDN4TDFBQTUyS3ZvN3JGWEQwWVNSTkgiLCJtYWMiOiIwODI0ODZkNTI0MjE0ZTQ4NWQ1Y2I0YWQ5ZGU4NmQ5ZWQ0ZDgwYTVhMTJhNTJjMmFjZmRlYzA3YWIzYTRmMDJhIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlhuUThKTm5lVXRIUXplUXlEa2NHSmc9PSIsInZhbHVlIjoiMFAzc2U1b25GdUdOdXdtclV0akEzRmdYRmhZcnlpUlBUQUxHbWRFWEZTMDE3RkJHWmVlK0tkZk5" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InV5eU4xRy9yeXRUN1Y5YjJuUkc5Umc9PSIsInZhbHVlIjoiS1QrTHdoQ1RXVGZWY3M1NnNkV0szTStZcGpkZVZCbE9TcytrYW5NMEl4UU9uY3puVFNXV0dWNDBYSGdTalBQTkZNSTJZMWxkZlVqUnF5QisxOVppbnF0UXVTNzU4NGU3amIwajNpV1pocnoxOEdGZ3ROQnVoOEc1dmdjWVhOT3MiLCJtYWMiOiIxZDc2N2IzNGI4YTJlOTJlMmI4OTMwMTViYTA3ODRmNzYyNjEyODQ1MDE1ZmI0NzViNjc4YmIyYzM4YjUwMWRlIiwidGFnIjoiIn0%3D; expires=Sat, 22-Feb-2025 01:35:25 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InV5eU4xRy9yeXRUN1Y5YjJuUkc5Umc9PSIsInZhbHVlIjoiS1QrTHdoQ1RXVGZWY3M1NnNkV0szTStZcGpkZVZCbE9TcytrYW5NMEl4UU9uY3puVFNXV0dWNDBYSGdTalBQTkZNSTJZM" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlhuUThKTm5lVXRIUXplUXlEa2NHSmc9PSIsInZhbHVlIjoiMFAzc2U1b25GdUdOdXdtclV0akEzRmdYRmhZcnlpUlBUQUxHbWRFWEZTMDE3RkJHWmVlK0tkZk5pd2R1cWpIWk9UMVJST0tmVFdRSkl2R3ZYeEdKME4wamI3SjZQMTcvT0E5RWplRjJnVDN4TDFBQTUyS3ZvN3JGWEQwWVNSTkgiLCJtYWMiOiIwODI0ODZkNTI0MjE0ZTQ4NWQ1Y2I0YWQ5ZGU4NmQ5ZWQ0ZDgwYTVhMTJhNTJjMmFjZmRlYzA3YWIzYTRmMDJhIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlhuUThKTm5lVXRIUXplUXlEa2NHSmc9PSIsInZhbHVlIjoiMFAzc2U1b25GdUdOdXdtclV0akEzRmdYRmhZcnlpUlBUQUxHbWRFWEZTMDE3RkJHWmVlK0tkZk5" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "PuVmgYzZR7gf8B2mLlpYj1yqlhF9QewLma69vZ05" "uc_cart_id" => "4a9f197bc7c1ecc2961481a6e7511045" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/122534" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-19 13:35:25GET/article/122534414361