Generic placeholder image

Current Drug Metabolism

Editor-in-Chief

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

Review Article

Delivery of Local Anesthesia: Current Strategies, Safety, and Future Prospects

Author(s): Guo-Liang Liu, Wen-Chao Bian, Peng Zhao and Li-Hua Sun*

Volume 20, Issue 6, 2019

Page: [533 - 539] Pages: 7

DOI: 10.2174/1389200220666190610155049

Price: $65

Abstract

Background: The systemic administration of anesthesia is associated with severe and undesirable side effects such as sedation, vomiting, nausea, allergies, respiratory problems, and neutrophil dysfunction. With the increase in the procedures of limb surgery, cosmetics, facial, skin, and cancer reconstruction, the demand for local anesthesia has increased multifold during the last one decade. Therefore, novel, safe, and cost-effective methods are being developed to deliver local anesthetics by the surgeons.

Method: To prepare a comprehensive research report on anesthesia, we performed a structured literature search of bibliographic databases for peer-reviewed articles published recently. The studies of different articles were summarized and a deductive qualitative and quantitative data analysis was applied. Subsequently, a comprehensive summary of the analysis was used to frame this review article with ample examples.

Results: A thorough analysis of the reports suggested that there have been tremendous developments of synthesizing nanoparticle-based local anesthesia drugs. The active targeting ability of nanoparticle-based drug delivery strategy can further help to deliver the desired anesthetic drug locally. It was also found that different local anesthetic drugs are developed into liposome form and show better efficacy in patients receiving anesthesia.

Conclusion: The findings of this review article endorse that safe delivery of anesthesia drugs are essential for the safety of patients. Further, nanotechnology-based strategies are extremely useful for targeted delivery of anesthetic drugs at the required dose without affecting the neighboring tissues.

Keywords: Anesthesia, liposome, drug delivery, nanotechnology, levobupivacaine, nanomedicine.

« Previous
Graphical Abstract

[1]
Hewson, D.W.; Worcester, F.; Sprinks, J.; Smith, M.D.; Buchanan, H.; Breedon, P.; Hardman, J.G.; Bedforth, N.M. Anaesthetist-controlled versus patient-maintained effect-site targeted propofol sedation during elective primary lower-limb arthroplasty performed under spinal anaesthesia: Study protocol for a parallel-group randomised comparison trial. Trials, 2019, 20(1), 129-131.
[2]
Hashim, P.W.; Nia, J.K.; Taliercio, M.; Goldenberg, G. Local anesthetics in cosmetic dermatology. Cutis, 2017, 99(6), 393-397.
[3]
Bordianu, A.; Bobirca, F. Facial skin cancer surgery under local anesthesia. J. Med. Life, 2018, 11(3), 231-237.
[4]
Visconti, G.; Salgarello, M. Free-style capillary perforator-based island flaps for reconstruction of skin cancer defects of the face, body, and extremities. Ann. Plast. Surg., 2018, 81(2), 192-197.
[5]
Reorganized text. JAMA Otolaryngol. Head Neck Surg., 2015, 141(5), 428.
[6]
Tasbihgou, S.R.; Vogels, M.F.; Absalom, A.R. Accidental awareness during general anaesthesia - a narrative review. Anaesthesia, 2018, 73(1), 112-122.
[7]
Lee, B.H.; Kumar, K.K.; Wu, E.C.; Wu, C.L. Role of regional anesthesia and analgesia in the opioid epidemic. Reg. Anesth. Pain Med., 2019, 13, 100-102.
[8]
Vahabi, S.; Eatemadi, A. Nanoliposome encapsulated anesthetics for local anesthesia application. Biomed. Pharmacother., 2017, 86, 1-7.
[9]
Sunderland, S.; Yarnold, C.H.; Head, S.J.; Osborn, J.A.; Purssell, A.; Peel, J.K.; Schwarz, S.K. Regional versus general anesthesia and the incidence of unplanned health care resource utilization for postoperative pain after wrist fracture surgery: Results from a retrospective quality improvement project. Reg. Anesth. Pain Med., 2016, 41(1), 22-27.
[10]
Raymond, S.A.; Steffensen, S.C.; Gugino, L.D.; Strichartz, G.R. The role of length of nerve exposed to local anesthetics in impulse blocking action. Anesth. Analg., 1989, 68(5), 563-670.
[11]
Saeki, S.; Kobayashi, M.; Miyake, E.; Suzuki, T. Crisis management during regional anesthesia including peripheral nerve block, epidural anesthesia and spinal anesthesia. Masui, 2009, 58(5), 595-603.
[12]
McCarthy, D.; McNamara, J.; Galbraith, J.; Loughnane, F.; Shorten, G.; Iohom, G. A comparison of the analgesic efficacy of local infiltration analgesia vs. intrathecal morphine after total knee replacement: A randomised controlled trial. Eur. J. Anaesthesiol., 2019, 36(4), 264-271.
[13]
Essving, P.; Axelsson, K.; Aberg, E.; Spannar, H.; Gupta, A.; Lundin, A. Local infiltration analgesia versus intrathecal morphine for postoperative pain management after total knee arthroplasty: A randomized controlled trial. Anesth. Analg., 2011, 113(4), 926-933.
[14]
Kampitak, W.; Tanavalee, A.; Ngarmukos, S.; Amarase, C.; Songthamwat, B.; Boonshua, A. Comparison of adductor canal block versus local infiltration analgesia on postoperative pain and functional outcome after total knee arthroplasty: A randomized controlled trial. Malays. Orthop. J., 2018, 12(1), 7-14.
[15]
Ruetsch, Y.A.; Boni, T.; Borgeat, A. From cocaine to ropivacaine: The history of local anesthetic drugs. Curr. Top. Med. Chem., 2001, 1(3), 175-182.
[16]
Swennen, C.; Bredin, S.; Eap, C.; Mensa, C.; Ohl, X.; Girard, V. Local infiltration analgesia with ropivacaine in acute fracture of thoracolumbar junction surgery. Orthop. Traumatol. Surg. Res., 2017, 103(2), 291-294.
[17]
Tam, K.W.; Chen, S.Y.; Huang, T.W.; Lin, C.C.; Su, C.M.; Li, C.L.; Ho, Y.S.; Wang, W.Y.; Wu, C.H. Effect of wound infiltration with ropivacaine or bupivacaine analgesia in breast cancer surgery: A meta-analysis of randomized controlled trials. Int. J. Surg., 2015, 22, 79-85.
[18]
Dominguez, D.A.; Ely, S.; Bach, C.; Lee, T.; Velotta, J.B. Impact of intercostal nerve blocks using liposomal versus standard bupivacaine on length of stay in minimally invasive thoracic surgery patients. J. Thorac. Dis., 2018, 10(12), 6873-6879.
[19]
Parascandola, S.A.; Ibanez, J.; Keir, G.; Anderson, J.; Plankey, M.; Flynn, D.; Cody, C.; De Marchi, L.; Margolis, M.; Blair Marshall, M. Liposomal bupivacaine versus bupivacaine/epinephrine after video-assisted thoracoscopic wedge resectiondagger. Interact. Cardiovasc. Thorac. Surg., 2017, 24(6), 925-930.
[20]
Ng, A.; Swami, A.; Smith, G.; Davidson, A.C.; Emembolu, J. The analgesic effects of intraperitoneal and incisional bupivacaine with epinephrine after total abdominal hysterectomy. Anesth. Analg., 2002, 95(1), 158-162.
[21]
Wolfe, J.W.; Butterworth, J.F. Local anesthetic systemic toxicity: update on mechanisms and treatment. Curr. Opin. Anaesthesiol., 2011, 24(5), 561-566.
[22]
Mutlu, I.N.; Kocak, B.; Baykara Ulusan, M.; Ulusan, K.; Cakir, M.S.; Kilickesmez, O. Regional anesthesia with epinephrine-containing lidocaine reduces pericatheter bleeding after tunneled hemodialysis catheter placement. Hemodial. Int., 2018, 23(1), 26-32.
[23]
Zink, W.; Graf, B.M. Local anesthetic myotoxicity. Reg. Anesth. Pain Med., 2004, 29(4), 333-340.
[24]
Singh, S.; Kumar, A.; Karakoti, A.; Seal, S.; Self, W.T. Unveiling the mechanism of uptake and sub-cellular distribution of cerium oxide nanoparticles. Mol. Biosyst., 2010, 6(10), 1813-1820.
[25]
Vassie, J.A.; Whitelock, J.M.; Lord, M.S. Endocytosis of cerium oxide nanoparticles and modulation of reactive oxygen species in human ovarian and colon cancer cells. Acta Biomater., 2017, 50, 127-141.
[26]
Chang, H.I.; Yeh, M.K. Clinical development of liposome-based drugs: formulation, characterization, and therapeutic efficacy. Int. J. Nanomedicine, 2012, 7, 49-60.
[27]
Patel, H.M.; Moghimi, S.M. Serum-mediated recognition of liposomes by phagocytic cells of the reticuloendothelial system - The concept of tissue specificity. Adv. Drug Deliv. Rev., 1998, 32(1-2), 45-60.
[28]
Benvegnu, T.; Lemiegre, L.; Cammas-Marion, S. New generation of liposomes called archaeosomes based on natural or synthetic archaeal lipids as innovative formulations for drug delivery. Recent Pat. Drug Deliv. Formul., 2009, 3(3), 206-220.
[29]
Savaliya, R.; Singh, P.; Singh, S. Pharmacological drug delivery strategies for improved therapeutic effects: Recent advances. Curr. Pharm. Des., 2016, 22(11), 1506-1520.
[30]
Savaliya, R.; Shah, D.; Singh, R.; Kumar, A.; Shanker, R.; Dhawan, A.; Singh, S. Nanotechnology in disease diagnostic techniques. Curr. Drug Metab., 2015, 16(8), 645-661.
[31]
Li, H.; Marotta, D.E.; Kim, S.; Busch, T.M.; Wileyto, E.P.; Zheng, G. High payload delivery of optical imaging and photodynamic therapy agents to tumors using phthalocyanine-reconstituted low-density lipoprotein nanoparticles. J. Biomed. Opt., 2005, 10(4), 41203.
[32]
Kim, J.K.; Yuan, H.; Nie, J.; Yang, Y.T.; Leggas, M.; Potter, P.M.; Rinehart, J.; Jay, M.; Lu, X. High payload dual therapeutic-imaging nanocarriers for triggered tumor delivery. Small, 2012, 8(18), 2895-2903.
[33]
Ambati, J.; Lopez, A.M.; Cochran, D.; Wattamwar, P.; Bean, K.; Dziubla, T.D.; Rankin, S.E. Engineered silica nanocarriers as a high-payload delivery vehicle for antioxidant enzymes. Acta Biomater., 2012, 8(6), 2096-2103.
[34]
Sudimack, J.; Lee, R.J. Targeted drug delivery via the folate receptor. Adv. Drug Deliv. Rev., 2000, 41(2), 147-162.
[35]
Arap, W.; Pasqualini, R.; Ruoslahti, E. Cancer treatment by targeted drug delivery to tumor vasculature in a mouse model. Science, 1998, 279(5349), 377-380.
[36]
Karakoti, A.S.; Shukla, R.; Shanker, R.; Singh, S. Surface functionalization of quantum dots for biological applications. Adv. Colloid Interface Sci., 2015, 215, 28-45.
[37]
Fatima, M.T.; Islam, Z.; Ahmad, E.; Barreto, G.E.; Md Ashraf, G. Ionic gradient liposomes: Recent advances in the stable entrapment and prolonged released of local anesthetics and anticancer drugs. Biomed. Pharmacother., 2018, 107, 34-43.
[38]
Haran, G.; Cohen, R.; Bar, L.K.; Barenholz, Y. Transmembrane ammonium sulfate gradients in liposomes produce efficient and stable entrapment of amphipathic weak bases. Biochim. Biophys. Acta, 1993, 1151(2), 201-215.
[39]
Oliveira, J.D.; Ribeiro, L.N.M.; Da Silva, R.G.H.; Casadei, B.R.; Couto, V.M.; Martinez, E.F.; De Paula, E. Sustained release from ionic-gradient liposomes significantly decreases etidocaine cytotoxicity. Pharm. Res., 2018, 35(12), 229.
[40]
De Paula, E.; Schreier, S.; Jarrell, H.C.; Fraceto, L.F. Preferential location of lidocaine and etidocaine in lecithin bilayers as determined by EPR, fluorescence and 2H NMR. Biophys. Chem., 2008, 132(1), 47-54.
[41]
Springer, B.D.; Mason, J.B.; Odum, S.M. Systemic safety of liposomal bupivacaine in simultaneous bilateral total knee arthroplasty. J. Arthroplasty, 2018, 33(1), 97-101.
[42]
Bagsby, D.T.; Ireland, P.H.; Meneghini, R.M. Liposomal bupivacaine versus traditional periarticular injection for pain control after total knee arthroplasty. J. Arthroplasty, 2014, 29(8), 1687-1690.
[43]
Meneghini, R.M.; Bagsby, D.; Ireland, P.H.; Ziemba-Davis, M.; Lovro, L.R. Liposomal bupivacaine injection technique in total knee arthroplasty. J. Knee Surg., 2017, 30(1), 88-96.
[44]
Wu, Z.Q.; Min, J.K.; Wang, D.; Yuan, Y.J.; Li, H. Liposome bupivacaine for pain control after total knee arthroplasty: A meta-analysis. J. Orthop. Surg. Res., 2016, 11(1), 84.
[45]
Uskova, A.; O’Connor, J.E. Liposomal bupivacaine for regional anesthesia. Curr. Opin. Anaesthesiol., 2015, 28(5), 593-597.
[46]
Franz-Montan, M.; Cereda, C.M.; Gaspari, A.; Da Silva, C.M.; de Araujo, D.R.; Padula, C.; Santi, P.; Narvaes, E.; Novaes, P.D.; Groppo, F.C.; De Paula, E. Liposomal-benzocaine gel formulation: correlation between in vitro assays and in vivo topical anesthesia in volunteers. J. Liposome Res., 2013, 23(1), 54-60.
[47]
Mura, P.; Maestrelli, F.; Gonzalez-Rodriguez, M.L.; Michelacci, I.; Ghelardini, C.; Rabasco, A.M. Development, characterization and in vivo evaluation of benzocaine-loaded liposomes. Eur. J. Pharm. Biopharm., 2007, 67(1), 86-95.
[48]
Tofoli, G.R.; Cereda, C.M.; Araujo, D.R.; Franz-Montan, M.; Groppo, F.C.; Quaglio, D.; Pedrazzoli, Junior J.; Calafatti, S.A.; Barros, F.A.; De Paula, E. Pharmacokinetic study of liposome-encapsulated and plain mepivacaine formulations injected intra-orally in volunteers. J. Pharm. Pharmacol., 2012, 64(3), 397-403.
[49]
Tofoli, G.R.; Cereda, C.M.; Groppo, F.C.; Volpato, M.C.; Franz-Montan, M.; Ranali, J.; De Araujo, D.R.; De Paula, E. Efficacy of liposome-encapsulated mepivacaine for infiltrative anesthesia in volunteers. J. Liposome Res., 2011, 21(1), 88-94.
[50]
Franz-Montan, M.; Silva, A.L.; Cogo, K.; Bergamaschi Cde, C.; Volpato, M.C.; Ranali, J.; De Paula, E.; Groppo, F.C. Liposome-encapsulated ropivacaine for topical anesthesia of human oral mucosa. Anesth. Analg., 2007, 104(6), 1528-1531.
[51]
Zhan, C.; Wang, W.; McAlvin, J.B.; Guo, S.; Timko, B.P.; Santamaria, C.; Kohane, D.S. Phototriggered local anesthesia. Nano Lett., 2016, 16(1), 177-181.
[52]
Zhan, C.; Wang, W.; Santamaria, C.; Wang, B.; Rwei, A.; Timko, B.P.; Kohane, D.S. Ultrasensitive phototriggered local anesthesia. Nano Lett., 2017, 17(2), 660-665.
[53]
Arakawa, Y.; Kawakami, S.; Yamashita, F.; Hashida, M. Effect of low-molecular-weight beta-cyclodextrin polymer on release of drugs from mucoadhesive buccal film dosage forms. Biol. Pharm. Bull., 2005, 28(9), 1679-1683.
[54]
Kamada, M.; Hirayama, F.; Udo, K.; Yano, H.; Arima, H.; Uekama, K. Cyclodextrin conjugate-based controlled release system: Repeated- and prolonged-releases of ketoprofen after oral administration in rats. J. Control. Release, 2002, 82(2-3), 407-416.
[55]
Nakanishi, K.; Masukawa, T.; Nadai, T.; Yoshii, K.; Okada, S.; Miyajima, K. Sustained release of flufenamic acid from a drug-triacetyl-beta-cyclodextrin complex. Biol. Pharm. Bull., 1997, 20(1), 66-70.
[56]
Cook, O.; Nusstein, J.; Drum, M.; Fowler, S.; Reader, A.; Draper, J. Anesthetic efficacy of a combination of 4% prilocaine/2% lidocaine with epinephrine for the inferior alveolar nerve block: A prospective, randomized, double-blind study. J. Endod., 2018, 44(5), 683-688.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version265msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[21:58:59] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[21:58:59] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[21:58:59] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (116ms)time
  • Application (149ms)time
  • 1 x Application (56.14%)
    149ms
    1 x Booting (43.86%)
    116ms
    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 duplicated81.03ms
    • 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 ('59769557','',1,1740347939,1740347939) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740347939
      1.22msalphaeurekaselec_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 ('59769557','/article/98732',1,1740347939,1740347939)
      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 >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) 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 >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) 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 >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) 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 >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) 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 >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) 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 >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59769557 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59769557) limit 1
      16.93msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59769557
      • 1: 59769557
      • 2: 59769557
      • 3: 59769557
      • 4: 59769557
      • 5: 59769557
      • 6: 59769557
      • 7: 59769557
      • 8: 59769557
      • 9: 59769557
      • 10: 59769557
      • 11: 59769557
      • 12: 59769557
      • 13: 59769557
      • 14: 59769557
      • 15: 59769557
      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=98732
      640μ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
      710μsalphaeurekaselec_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.05msalphaeurekaselec_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
      840μ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=15) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.57msalphaeurekaselec_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
      1.44msalphaeurekaselec_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` = '98732'
      260μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 98732
      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` = '98732'
      2.08msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 98732
      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` = '98732' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.19msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 98732
      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
      280μ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
      480μ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
      24.9msalphaeurekaselec_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
      7.9msalphaeurekaselec_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
      8.66msalphaeurekaselec_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` = 98732 limit 1
      210μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 98732
      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 = 98732 and content_type = 'article' order by status desc limit 1
      210μ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` = 172461 limit 1
      170μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 172461
      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
      200μ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
      250μ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 = '98732' 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) )
      310μ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 = '9147' 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) )
      280μ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 = '2559' 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) )
      240μ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 <= 59769557 and j.to_ip >=59769557 )) and ((j.from_date <= 1740347939 and j.to_date >= 1740347939 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2559) 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 <= 59769557 and j.to_ip >=59769557 )) and ((j.from_date <= 1740347939 and j.to_date >= 1740347939 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2559) 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 <= 59769557 and j.to_ip >=59769557 )) and ((j.from_date <= 1740347939 and j.to_date >= 1740347939 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2559)
      1.93msalphaeurekaselec_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 <= 59769557 and j.to_ip >=59769557 )) and ((j.from_date <= 1740347939 and j.to_date >= 1740347939 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9147) 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 <= 59769557 and j.to_ip >=59769557 )) and ((j.from_date <= 1740347939 and j.to_date >= 1740347939 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9147) 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 <= 59769557 and j.to_ip >=59769557 )) and ((j.from_date <= 1740347939 and j.to_date >= 1740347939 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9147)
      530μ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 <= 59769557 and j.to_ip >=59769557 )) and ((j.from_date <= 1740347939 and j.to_date >= 1740347939 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 98732) 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 <= 59769557 and j.to_ip >=59769557 )) and ((j.from_date <= 1740347939 and j.to_date >= 1740347939 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 98732) 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 <= 59769557 and j.to_ip >=59769557 )) and ((j.from_date <= 1740347939 and j.to_date >= 1740347939 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 98732)
      520μ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` < '533' and is_uploaded = 1 and issue_id = 9147 order by cast(first_page as SIGNED) desc limit 1
      440μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 533
      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` > '539' and is_uploaded = 1 and issue_id = 9147 order by cast(first_page as SIGNED) asc limit 1
      340μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 539
      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'
      160μ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
      180μ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` = 98732 limit 1
      2.3msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 98732
      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` <= 1740347939 and `b`.`banner_to_date` >= 1740347939 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.13msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 15
      • 3: 1740347939
      • 4: 1740347939
      • 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` <= 1740347939 and `b`.`banner_to_date` >= 1740347939 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.05msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 15
      • 3: 1740347939
      • 4: 1740347939
      • 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='bbccc9974d288542fa5b5a23a7359626'
      220μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        NIt2wX6xYqXMATYMGKnlQw8LmLiazATZlDCnZoaS
        uc_cart_id
        bbccc9974d288542fa5b5a23a7359626
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/98732" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/98732
        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=eyJpdiI6IkNjSy9VUmk3aWgxL0I5RkNib0JudVE9PSIsInZhbHVlIjoiVW8yM1ZaQmRlcVdLM1hkVlpTV0g3Z3Y2QTFWc3I0YkQ1U0NySFl1Szh1RT0iLCJtYWMiOiI0MzkyZTg1ODc3Y2QxNjM4ZDU5MTdjMTA1MWFiYjcwNjc0ZmVmOTg1OGJlMDBhOGJjY2FlMTBhZDMwNDc1ZWI1IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IkNjSy9VUmk3aWgxL0I5RkNib0JudVE9PSIsInZhbHVlIjoiVW8yM1ZaQmRlcVdLM1hkVlpTV0g3Z3Y2QTFWc3I0YkQ1U0NySFl1Szh1RT0iLCJtYWMiOiI0MzkyZTg1ODc3Y2Qx" ] "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 => "Sun, 23 Feb 2025 21:58:59 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkZ0SHlRWGFXZzNDRkxqdFdRSnBoaVE9PSIsInZhbHVlIjoiL0hlZmNRK21LNGtTMnZpWmtWek00UnZIQ1VIakZmMGs1c3I4RGYzTzFQZGVnbFQ3MlJFRG5iOTdhYy9paWNiWTBQMU1OUkFIUGFpL29kMjNZellHV0JlVTJnS0tXV0t6c1NzMG95R3ZSTjRvTDJtZHNpVUVUMURCeWpVMjVRdEoiLCJtYWMiOiI0OThiYzAzMzZhZmQzNmRlOWFiYTU0MDc5ZDdkZTA4ZWRkZTg0ZDIzZWFiOTZiNGRhYjMxMzUzZjc4YjAzOGQ3IiwidGFnIjoiIn0%3D; expires=Wed, 26 Feb 2025 09:58:59 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkZ0SHlRWGFXZzNDRkxqdFdRSnBoaVE9PSIsInZhbHVlIjoiL0hlZmNRK21LNGtTMnZpWmtWek00UnZIQ1VIakZmMGs1c3I4RGYzTzFQZGVnbFQ3MlJFRG5iOTdhYy9paWNiWTBQMU1OU" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ino2UStLZ2JaQXNlbkRlT0Y0TDk1QXc9PSIsInZhbHVlIjoidXJKMGxKRFo5NXVPQ0ZaQkF6VXAxRXdIOStuVGx3dkV3b1lNSDkyUlFUYkZ4bGxEWXFBZnhVM0ZwbTgxazExNWpIeEZub3JoMFJteGliaFhTSnA2U2EvZHBMRHFHaDN0UU9rQVU3Sys3bkxEWVFEVVoxOHplOHNqeUN1dlpYb1QiLCJtYWMiOiI2N2ZlMGRjNGE2YWQ0OGE3NjY5MTgzZjJhN2YxMzRlZjUzMzFkZmEyOTAwY2YzNmE0M2IzNzUyZjdkNzI1ZTI5IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ino2UStLZ2JaQXNlbkRlT0Y0TDk1QXc9PSIsInZhbHVlIjoidXJKMGxKRFo5NXVPQ0ZaQkF6VXAxRXdIOStuVGx3dkV3b1lNSDkyUlFUYkZ4bGxEWXFBZnhVM0Z" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkZ0SHlRWGFXZzNDRkxqdFdRSnBoaVE9PSIsInZhbHVlIjoiL0hlZmNRK21LNGtTMnZpWmtWek00UnZIQ1VIakZmMGs1c3I4RGYzTzFQZGVnbFQ3MlJFRG5iOTdhYy9paWNiWTBQMU1OUkFIUGFpL29kMjNZellHV0JlVTJnS0tXV0t6c1NzMG95R3ZSTjRvTDJtZHNpVUVUMURCeWpVMjVRdEoiLCJtYWMiOiI0OThiYzAzMzZhZmQzNmRlOWFiYTU0MDc5ZDdkZTA4ZWRkZTg0ZDIzZWFiOTZiNGRhYjMxMzUzZjc4YjAzOGQ3IiwidGFnIjoiIn0%3D; expires=Wed, 26-Feb-2025 09:58:59 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkZ0SHlRWGFXZzNDRkxqdFdRSnBoaVE9PSIsInZhbHVlIjoiL0hlZmNRK21LNGtTMnZpWmtWek00UnZIQ1VIakZmMGs1c3I4RGYzTzFQZGVnbFQ3MlJFRG5iOTdhYy9paWNiWTBQMU1OU" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ino2UStLZ2JaQXNlbkRlT0Y0TDk1QXc9PSIsInZhbHVlIjoidXJKMGxKRFo5NXVPQ0ZaQkF6VXAxRXdIOStuVGx3dkV3b1lNSDkyUlFUYkZ4bGxEWXFBZnhVM0ZwbTgxazExNWpIeEZub3JoMFJteGliaFhTSnA2U2EvZHBMRHFHaDN0UU9rQVU3Sys3bkxEWVFEVVoxOHplOHNqeUN1dlpYb1QiLCJtYWMiOiI2N2ZlMGRjNGE2YWQ0OGE3NjY5MTgzZjJhN2YxMzRlZjUzMzFkZmEyOTAwY2YzNmE0M2IzNzUyZjdkNzI1ZTI5IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ino2UStLZ2JaQXNlbkRlT0Y0TDk1QXc9PSIsInZhbHVlIjoidXJKMGxKRFo5NXVPQ0ZaQkF6VXAxRXdIOStuVGx3dkV3b1lNSDkyUlFUYkZ4bGxEWXFBZnhVM0Z" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "NIt2wX6xYqXMATYMGKnlQw8LmLiazATZlDCnZoaS" "uc_cart_id" => "bbccc9974d288542fa5b5a23a7359626" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/98732" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-23 21:58:59GET/article/98732314361