Generic placeholder image

Current Medical Imaging

Editor-in-Chief

ISSN (Print): 1573-4056
ISSN (Online): 1875-6603

Review Article

Ultrasound-guided Treatments for the Painful Shoulder

Author(s): Nicolas Papalexis, Federico Ponti, Raffaella Rinaldi, Giuliano Peta, Riccardo Bruno, Marco Miceli, Milva Battaglia, Alessandro Marinelli and Paolo Spinnato*

Volume 18, Issue 7, 2022

Published on: 14 February, 2022

Article ID: e061221198582 Pages: 8

DOI: 10.2174/1573405617666211206112752

Price: $65

Abstract

Shoulder pain is an extremely common condition. The painful shoulder may be the result of a wide spectrum of underlying pathological conditions, including calcific tendinopathy of the rotator cuff, subacromial-subdeltoid bursitis, acromioclavicular or glenohumeral arthritis, tenosynovitis of the long biceps tendon, rotator cuff lesions, and many other less common conditions. Ultrasound imaging is an effective tool for the diagnosis and also for the image guidance of treatment of the majority of these conditions. Several ultrasound-guided procedures are effective for pain relief, such as percutaneous irrigation, intra-bursal or intra-articular drugs injection, fluid aspiration, neural block. This review article aims to summarize and discuss the most common treatment possibilities with ultrasound guidance for the painful shoulder.

Keywords: Ultrasonography, interventional, tendinopathy, shoulder pain, shoulder joint, arthritis, bursitis, injections, intra-articular, radiology.

Graphical Abstract

[1]
Messina C, Banfi G, Orlandi D, et al. Ultrasound-guided interventional procedures around the shoulder. Br J Radiol 2016; 89(1057): 20150372.
[http://dx.doi.org/10.1259/bjr.20150372] [PMID: 26313499]
[2]
Huygen F, Patijn J, Rohof O, et al. 9. Painful shoulder complaints. Pain Pract 2010; 10(4): 318-26.
[http://dx.doi.org/10.1111/j.1533-2500.2010.00389.x] [PMID: 20456651]
[3]
Andrews JR. Diagnosis and treatment of chronic painful shoulder: Review of nonsurgical interventions. Arthroscopy 2005; 21(3): 333-47.
[http://dx.doi.org/10.1016/j.arthro.2004.11.003] [PMID: 15756189]
[4]
ElShewy MT. Calcific tendinitis of the rotator cuff. World J Orthop 2016; 7(1): 55-60.
[http://dx.doi.org/10.5312/wjo.v7.i1.55] [PMID: 26807357]
[5]
Bloom JE, Rischin A, Johnston RV, Buchbinder R. Image-guided versus blind glucocorticoid injection for shoulder pain. Cochrane Database Syst Rev 2012; (8): CD009147.
[http://dx.doi.org/10.1002/14651858.CD009147.pub2] [PMID: 22895984]
[6]
Cho CH, Min BW, Bae KC, Lee KJ, Kim DH. A prospective double-blind randomized trial on ultrasound-guided versus blind intra-articular corticosteroid injections for primary frozen shoulder. Bone Joint J 2021; 103-B(2): 353-9.
[http://dx.doi.org/10.1302/0301-620X.103B2.BJJ-2020-0755.R1] [PMID: 33517741]
[7]
Sconfienza LM, Adriaensen M, Albano D, et al. Clinical indications for image-guided interventional procedures in the musculoskeletal system: A Delphi-based consensus paper from the European Society of Musculoskeletal Radiology (ESSR)-part I, shoulder. Eur Radiol 2020; 30(2): 903-13.
[http://dx.doi.org/10.1007/s00330-019-06419-x] [PMID: 31529252]
[8]
Amber KT, Landy DC, Amber I, Knopf D, Guerra J. Comparing the accuracy of ultrasound versus fluoroscopy in glenohumeral injections: A systematic review and meta-analysis. J Clin Ultrasound 2014; 42(7): 411-6.
[http://dx.doi.org/10.1002/jcu.22154] [PMID: 24668738]
[9]
Aly AR, Rajasekaran S, Ashworth N. Ultrasound-guided shoulder girdle injections are more accurate and more effective than landmark-guided injections: A systematic review and meta-analysis. Br J Sports Med 2015; 49(16): 1042-9.
[http://dx.doi.org/10.1136/bjsports-2014-093573] [PMID: 25403682]
[10]
Bot SD, van der Waal JM, Terwee CB, et al. Incidence and prevalence of complaints of the neck and upper extremity in general practice. Ann Rheum Dis 2005; 64(1): 118-23.
[http://dx.doi.org/10.1136/ard.2003.019349] [PMID: 15608309]
[11]
Feleus A, Bierma-Zeinstra SM, Miedema HS, Bernsen RM, Verhaar JA, Koes BW. Incidence of non-traumatic complaints of arm, neck and shoulder in general practice. Man Ther 2008; 13(5): 426-33.
[http://dx.doi.org/10.1016/j.math.2007.05.010] [PMID: 17681866]
[12]
Linsell L, Dawson J, Zondervan K, et al. Prevalence and incidence of adults consulting for shoulder conditions in UK primary care; patterns of diagnosis and referral. Rheumatology (Oxford) 2006; 45(2): 215-21.
[http://dx.doi.org/10.1093/rheumatology/kei139] [PMID: 16263781]
[13]
van der Windt DA, Koes BW, de Jong BA, Bouter LM. Shoulder disorders in general practice: Incidence, patient characteristics, and management. Ann Rheum Dis 1995; 54(12): 959-64.
[http://dx.doi.org/10.1136/ard.54.12.959] [PMID: 8546527]
[14]
Greving K, Dorrestijn O, Winters JC, et al. Incidence, prevalence, and consultation rates of shoulder complaints in general practice. Scand J Rheumatol 2012; 41(2): 150-5.
[http://dx.doi.org/10.3109/03009742.2011.605390] [PMID: 21936616]
[15]
Picavet HS, Schouten JS. Musculoskeletal pain in the Netherlands: Prevalences, consequences and risk groups, the DMC(3)-study. Pain 2003; 102(1-2): 167-78.
[http://dx.doi.org/10.1016/s0304-3959(02)00372-x] [PMID: 12620608]
[16]
Luime JJ, Koes BW, Hendriksen IJ, et al. Prevalence and incidence of shoulder pain in the general population; a systematic review. Scand J Rheumatol 2004; 33(2): 73-81.
[http://dx.doi.org/10.1080/03009740310004667] [PMID: 15163107]
[17]
Urwin M, Symmons D, Allison T, et al. Estimating the burden of musculoskeletal disorders in the community: The comparative prevalence of symptoms at different anatomical sites, and the relation to social deprivation. Ann Rheum Dis 1998; 57(11): 649-55.
[http://dx.doi.org/10.1136/ard.57.11.649] [PMID: 9924205]
[18]
Meislin RJ, Sperling JW, Stitik TP. Persistent shoulder pain: Epidemiology, pathophysiology, and diagnosis. Am J Orthop 2005; 34(12)(Suppl.): 5-9.
[PMID: 16450690]
[19]
Chianca V, Albano D, Messina C, et al. Rotator cuff calcific tendinopathy: From diagnosis to treatment. Acta Biomed 2018; 89(1): 186-96.
[http://dx.doi.org/10.23750/abm.v89i1-S.7022]
[20]
Katz WA. Musculoskeletal pain and its socioeconomic implications. Clin Rheumatol 2002; 21(Suppl. 1): S2-4.
[http://dx.doi.org/10.1007/s100670200028] [PMID: 11954899]
[21]
Uhthoff HK, Sarkar K. Calcifying tendinitis. Baillieres Clin Rheumatol 1989; 3(3): 567-81.
[http://dx.doi.org/10.1016/S0950-3579(89)80009-3] [PMID: 2624948]
[22]
Tagliafico A, Russo G, Boccalini S, et al. Ultrasound-guided interventional procedures around the shoulder. Radiol Med (Torino) 2014; 119(5): 318-26.
[http://dx.doi.org/10.1007/s11547-013-0351-2] [PMID: 24297588]
[23]
Faruqi T, Rizvi TJ. Subacromial Bursitis. In: StatPearls. Treasure Island (FL): StatPearls Publishing 2020.
[24]
Aaron DL. Four common types of bursitis: Diagnosis and management. J Am Acad Orthop Surg 2011; 19(6): 359-67.
[25]
Awerbuch MS. The clinical utility of ultrasonography for rotator cuff disease, shoulder impingement syndrome and subacromial bursitis. Med J Aust 2008; 188(1): 50-3.
[http://dx.doi.org/10.5694/j.1326-5377.2008.tb01507.x] [PMID: 18205566]
[26]
Macías-Hernández SI, Morones-Alba JD, Miranda-Duarte A, et al. Glenohumeral osteoarthritis: Overview, therapy, and rehabilitation. Disabil Rehabil 2017; 39(16): 1674-82.
[http://dx.doi.org/10.1080/09638288.2016.1207206] [PMID: 27416338]
[27]
Saltzman BM. Glenohumeral osteoarthritis in the young patient. J Am Acad Orthop Surg 2018; 26(17): 361-70.
[http://dx.doi.org/10.5435/JAAOS-D-16-00657]
[28]
Burbank KM, Stevenson JH, Czarnecki GR, Dorfman J. Chronic shoulder pain: Part I. Evaluation and diagnosis. Am Fam Physician 2008; 77(4): 453-60.
[PMID: 18326164]
[29]
Raynor MB, Kuhn JE. Utility of features of the patient’s history in the diagnosis of atraumatic shoulder pain: A systematic review. J Shoulder Elbow Surg 2016; 25(4): 688-94.
[http://dx.doi.org/10.1016/j.jse.2015.09.023] [PMID: 26711472]
[30]
Sethi N, Wright R, Yamaguchi K. Disorders of the long head of the biceps tendon. J Shoulder Elbow Surg 1999; 8(6): 644-54.
[http://dx.doi.org/10.1016/S1058-2746(99)90105-2] [PMID: 10633904]
[31]
Bicipital Tenosynovitis. Clinical Orthopaedics 2001; 18: 261-8.
[32]
Patton WC, McCluskey GM III. Biceps tendinitis and subluxation. Clin Sports Med 2001; 20(3): 505-29.
[http://dx.doi.org/10.1016/S0278-5919(05)70266-0] [PMID: 11494838]
[33]
Middleton WD, Reinus WR, Totty WG, Melson GL, Murphy WA. US of the biceps tendon apparatus. Radiology 1985; 157(1): 211-5.
[http://dx.doi.org/10.1148/radiology.157.1.3898217] [PMID: 3898217]
[34]
Lanza E, Piccoli F, Intrieri C, et al. US-guided percutaneous irrigation of calcific tendinopathy of the rotator cuff in patients with or without previous external shockwave therapy. Radiol Med (Torino) 2021; 126(1): 117-23.
[http://dx.doi.org/10.1007/s11547-020-01229-4] [PMID: 32451885]
[35]
Serafini G, Sconfienza LM, Lacelli F, Silvestri E, Aliprandi A, Sardanelli F. Rotator cuff calcific tendonitis: Short-term and 10-year outcomes after two-needle us-guided percutaneous treatment- nonrandomized controlled trial. Radiology 2009; 252(1): 157-64.
[http://dx.doi.org/10.1148/radiol.2521081816] [PMID: 19561254]
[36]
Pagnini F, D'Amuri FV, Bevilacqua A, et al. Ultrasound-guided percutaneous irrigation of calcific tendinopathy: Technical developments. Acta Biomed 2019; 90(5): 95-100.
[http://dx.doi.org/10.23750/abm.v90i5-S.8333]
[37]
Messina C, Sconfienza LM. Ultrasound-guided percutaneous irrigation of calcific tendinopathy. Semin Musculoskelet Radiol 2016; 20(5): 409-13.
[http://dx.doi.org/10.1055/s-0036-1594285] [PMID: 28002862]
[38]
Pasquotti G, Faccinetto A, Marchioro U, et al. US-guided percutaneous treatment and physical therapy in rotator cuff calcific tendinopathy of the shoulder: Outcome at 3 and 12 months. Eur Radiol 2016; 26(8): 2819-27.
[http://dx.doi.org/10.1007/s00330-015-4102-8] [PMID: 26694061]
[39]
de Witte PB, Selten JW, Navas A, et al. Calcific tendinitis of the rotator cuff: A randomized controlled trial of ultrasound-guided needling and lavage versus subacromial corticosteroids. Am J Sports Med 2013; 41(7): 1665-73.
[http://dx.doi.org/10.1177/0363546513487066] [PMID: 23696211]
[40]
Robinson CM, Seah KT, Chee YH, Hindle P, Murray IR. Frozen shoulder. J Bone Joint Surg Br 2012; 94(1): 1-9.
[http://dx.doi.org/10.1302/0301-620X.94B1.27093] [PMID: 22219239]
[41]
Uppal HS, Evans JP, Smith C. Frozen shoulder: A systematic review of therapeutic options. World J Orthop 2015; 6(2): 263-8.
[http://dx.doi.org/10.5312/wjo.v6.i2.263] [PMID: 25793166]
[42]
Buchbinder R, Green S, Youd JM. Corticosteroid injections for shoulder pain. Cochrane Database Syst Rev 2003; 2003(1): CD004016.
[http://dx.doi.org/10.1002/14651858.CD004016] [PMID: 12535501]
[43]
Zuckerman JD, Cuomo F. Frozen shoulder. In: Matsen FA, III, Fu FH, Hawkins RJ, Eds. The Shoulder: A balance of Mobility and Stability. Rosemont: American Academy of Orthopedic Surgery 1993; pp. 99-109.
[44]
Bryant M, Gough A, Selfe J, Richards J, Burgess E. The effectiveness of ultrasound guided hydrodistension and physiotherapy in the treatment of frozen shoulder/adhesive capsulitis in primary care: A single centre service evaluation. Shoulder Elbow 2017; 9(4): 292-8.
[http://dx.doi.org/10.1177/1758573217701063] [PMID: 28932287]
[45]
Buchbinder R, Green S, Forbes A, Hall S, Lawler G. Arthrographic joint distension with saline and steroid improves function and reduces pain in patients with painful stiff shoulder: Results of a randomised, double blind, placebo controlled trial. Ann Rheum Dis 2004; 63(3): 302-9.
[http://dx.doi.org/10.1136/ard.2002.004655] [PMID: 14962967]
[46]
Koh KH. Corticosteroid injection for adhesive capsulitis in primary care: A systematic review of randomised clinical trials. Singapore Med J 2016; 57(12): 646-57.
[http://dx.doi.org/10.11622/smedj.2016146] [PMID: 27570870]
[47]
Tagliafico A, Serafini G, Sconfienza LM, et al. Ultrasound-guided viscosupplementation of subacromial space in elderly patients with cuff tear arthropathy using a high weight hyaluronic acid: Prospective open-label non-randomized trial. Eur Radiol 2011; 21(1): 182-7.
[http://dx.doi.org/10.1007/s00330-010-1894-4] [PMID: 20658295]
[48]
Pourcho AM, Colio SW, Hall MM. Ultrasound-guided interventional procedures about the shoulder: Anatomy, indications, and techniques. Phys Med Rehabil Clin N Am 2016; 27(3): 555-72.
[http://dx.doi.org/10.1016/j.pmr.2016.04.001] [PMID: 27468666]
[49]
Fessell D, Holsbeeck M. Ultrasound guided musculoskeletal procedures. Ultrasound Clin 2007; 2(2): 737-57.
[50]
Hansford BG, Stacy GS. Musculoskeletal aspiration procedures. Semin Intervent Radiol 2012; 29(4): 270-85.
[http://dx.doi.org/10.1055/s-0032-1330061] [PMID: 24293800]
[51]
Fernandes MR, Barbosa MA, Sousa AL, Ramos GC. Suprascapular nerve block: Important procedure in clinical practice. Rev Bras Anestesiol 2012; 62(1): 96-104.
[http://dx.doi.org/10.1016/S0034-7094(12)70108-3] [PMID: 22248771]
[52]
Joshi G, Gandhi K, Shah N, Gadsden J, Corman SL. Peripheral nerve blocks in the management of postoperative pain: Challenges and opportunities. J Clin Anesth 2016; 35: 524-9.
[http://dx.doi.org/10.1016/j.jclinane.2016.08.041] [PMID: 27871587]
[53]
Peng PW, Cheng P. Ultrasound-guided interventional procedures in pain medicine: A review of anatomy, sonoanatomy, and procedures. Part III: Shoulder. Reg Anesth Pain Med 2011; 36(6): 592-605.
[http://dx.doi.org/10.1097/AAP.0b013e318231e068] [PMID: 22005657]
[54]
Chan CW, Peng PW. Suprascapular nerve block: a narrative review. Reg Anesth Pain Med 2011; 36(4): 358-73.
[http://dx.doi.org/10.1097/AAP.0b013e3182204ec0] [PMID: 21654552]
[55]
Chang KV, Hung CY, Wu WT, Han DS, Yang RS, Lin CP. Comparison of the effectiveness of suprascapular nerve block with physical therapy, placebo, and intra-articular injection in management of chronic shoulder pain: A meta-analysis of randomized controlled Trials. Arch Phys Med Rehabil 2016; 97(8): 1366-80.
[http://dx.doi.org/10.1016/j.apmr.2015.11.009] [PMID: 26701762]
[56]
Strakowski JA. Ultrasound-guided peripheral nerve procedures. Phys Med Rehabil Clin N Am 2016; 27(3): 687-715.
[http://dx.doi.org/10.1016/j.pmr.2016.04.006] [PMID: 27468673]
[57]
Hewson DW, Bedforth NM, Hardman JG. Peripheral nerve injury arising in anaesthesia practice. Anaesthesia 2018; 73(Suppl. 1): 51-60.
[http://dx.doi.org/10.1111/anae.14140] [PMID: 29313904]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version269msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[06:03:07] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[06:03:08] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[06:03:08] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[06:03:08] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[06:03:08] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[06:03:08] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (91.65ms)time
  • Application (177ms)time
  • 1 x Application (65.93%)
    177ms
    1 x Booting (34.07%)
    91.65ms
    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 duplicated96.42ms
    • 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 ('222023364','',1,1740549787,1740549787) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740549787
      1.04msalphaeurekaselec_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 ('222023364','/article/119244',1,1740549787,1740549787)
      580μ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 >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) 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 >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) 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 >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) 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 >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) 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 >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) 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 >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) limit 1
      12.41msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 222023364
      • 1: 222023364
      • 2: 222023364
      • 3: 222023364
      • 4: 222023364
      • 5: 222023364
      • 6: 222023364
      • 7: 222023364
      • 8: 222023364
      • 9: 222023364
      • 10: 222023364
      • 11: 222023364
      • 12: 222023364
      • 13: 222023364
      • 14: 222023364
      • 15: 222023364
      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=119244
      720μ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` = 33 limit 1
      910μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 33
      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=33) and sj.journal_id!=33 group by `j`.`nid`) as `aggregate_table`
      560μsalphaeurekaselec_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=33) and sj.journal_id!=33 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      480μ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=33) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      670μsalphaeurekaselec_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=33) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      600μsalphaeurekaselec_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` = '119244'
      1.33msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 119244
      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` = '119244'
      3.8msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 119244
      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` = '119244' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.14msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 119244
      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
      320μ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
      650μ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 = 33 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      31.97msalphaeurekaselec_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 = 33 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      11.83msalphaeurekaselec_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 = 33 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      8.16msalphaeurekaselec_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` = 119244 limit 1
      960μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 119244
      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 = 119244 and content_type = 'article' order by status desc limit 1
      260μ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` = 198582 limit 1
      910μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 198582
      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` = 'CMIM' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      340μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CMIM
      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 = '119244' 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 = '11646' 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 = '3238' 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 <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740549787 and j.to_date >= 1740549787 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3238) 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 <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740549787 and j.to_date >= 1740549787 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3238) 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 <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740549787 and j.to_date >= 1740549787 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3238)
      5.84msalphaeurekaselec_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 <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740549787 and j.to_date >= 1740549787 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11646) 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 <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740549787 and j.to_date >= 1740549787 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11646) 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 <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740549787 and j.to_date >= 1740549787 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11646)
      610μ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 <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740549787 and j.to_date >= 1740549787 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 119244) 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 <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740549787 and j.to_date >= 1740549787 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 119244) 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 <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740549787 and j.to_date >= 1740549787 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 119244)
      630μ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` < '693' and is_uploaded = 1 and issue_id = 11646 order by cast(first_page as SIGNED) desc limit 1
      550μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 693
      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` > '700' and is_uploaded = 1 and issue_id = 11646 order by cast(first_page as SIGNED) asc limit 1
      500μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 700
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'en'
      200μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      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` = 119244 limit 1
      2.34msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 119244
      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` = 33 and `b`.`banner_from_date` <= 1740549788 and `b`.`banner_to_date` >= 1740549788 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.24msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 33
      • 3: 1740549788
      • 4: 1740549788
      • 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` = 33 and `b`.`banner_from_date` <= 1740549788 and `b`.`banner_to_date` >= 1740549788 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.11msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 33
      • 3: 1740549788
      • 4: 1740549788
      • 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='5e89fdcb852404c4ac6ef94cfde28005'
      200μ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
        tY1ATlSAF2nVcCyRyXsB1mfULfo67xbcVxon8A3S
        uc_cart_id
        5e89fdcb852404c4ac6ef94cfde28005
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/119244" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/119244
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 26 Feb 2025 06:03:08 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InhMWWQvRktYc0twTzlBQ05mQjFrRkE9PSIsInZhbHVlIjoiVkdjV2VhUFplQlNOOVhlTDFmMURjNnBlZk1kbE9TeUhldDNhYnBmRnNIbGVGYjMvTkMycWFDb1BWeXowZitXVzRPZTAweS9IUC9xSitldDRveFpqVXZGeWMvUXZnV3ZnLzNubGptZEMxODNJcWZIcEI0VXNzTHA5OGtCQTJiNlUiLCJtYWMiOiIwM2JkNzI1NGU0N2M1YzZmY2RmYzRjOGU5Zjg1YTYwYmE1YjNmODVjNzJkMDQ4NGY5ZjA5MjQ3OWViZmE0ZDhlIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 18:03:08 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InhMWWQvRktYc0twTzlBQ05mQjFrRkE9PSIsInZhbHVlIjoiVkdjV2VhUFplQlNOOVhlTDFmMURjNnBlZk1kbE9TeUhldDNhYnBmRnNIbGVGYjMvTkMycWFDb1BWeXowZitXVzRPZTAwe" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ik8wdEk3N3Q2VmZUdS90emJBdXFNelE9PSIsInZhbHVlIjoiSEs4Q1p6RDJFcVM4MFFYeWU5dmFqN0dPbnh6WlRzU1BOOXR4bVByeXBYam9Iam1hYjc2UWpveUdzbi8vcVdNMTN0c29Wdy9iMVBnMWt0Y1p2MlRKWFJ0MWsvS1pBMkZoSExkcFRWS2dRQ1ZHcStoYmh2VHlXaWFKRUc2OU5DOEIiLCJtYWMiOiIyYzg5ZjdkNWM5YTE2MTllMDEwNTkxMTQyZmFkNDM0MjY0MmM2OWEyZGY4ZjAzZmU2NDYyN2VjOGFmNDc5NWRmIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ik8wdEk3N3Q2VmZUdS90emJBdXFNelE9PSIsInZhbHVlIjoiSEs4Q1p6RDJFcVM4MFFYeWU5dmFqN0dPbnh6WlRzU1BOOXR4bVByeXBYam9Iam1hYjc2UWpveUd" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InhMWWQvRktYc0twTzlBQ05mQjFrRkE9PSIsInZhbHVlIjoiVkdjV2VhUFplQlNOOVhlTDFmMURjNnBlZk1kbE9TeUhldDNhYnBmRnNIbGVGYjMvTkMycWFDb1BWeXowZitXVzRPZTAweS9IUC9xSitldDRveFpqVXZGeWMvUXZnV3ZnLzNubGptZEMxODNJcWZIcEI0VXNzTHA5OGtCQTJiNlUiLCJtYWMiOiIwM2JkNzI1NGU0N2M1YzZmY2RmYzRjOGU5Zjg1YTYwYmE1YjNmODVjNzJkMDQ4NGY5ZjA5MjQ3OWViZmE0ZDhlIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 18:03:08 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InhMWWQvRktYc0twTzlBQ05mQjFrRkE9PSIsInZhbHVlIjoiVkdjV2VhUFplQlNOOVhlTDFmMURjNnBlZk1kbE9TeUhldDNhYnBmRnNIbGVGYjMvTkMycWFDb1BWeXowZitXVzRPZTAwe" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ik8wdEk3N3Q2VmZUdS90emJBdXFNelE9PSIsInZhbHVlIjoiSEs4Q1p6RDJFcVM4MFFYeWU5dmFqN0dPbnh6WlRzU1BOOXR4bVByeXBYam9Iam1hYjc2UWpveUdzbi8vcVdNMTN0c29Wdy9iMVBnMWt0Y1p2MlRKWFJ0MWsvS1pBMkZoSExkcFRWS2dRQ1ZHcStoYmh2VHlXaWFKRUc2OU5DOEIiLCJtYWMiOiIyYzg5ZjdkNWM5YTE2MTllMDEwNTkxMTQyZmFkNDM0MjY0MmM2OWEyZGY4ZjAzZmU2NDYyN2VjOGFmNDc5NWRmIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ik8wdEk3N3Q2VmZUdS90emJBdXFNelE9PSIsInZhbHVlIjoiSEs4Q1p6RDJFcVM4MFFYeWU5dmFqN0dPbnh6WlRzU1BOOXR4bVByeXBYam9Iam1hYjc2UWpveUd" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "tY1ATlSAF2nVcCyRyXsB1mfULfo67xbcVxon8A3S" "uc_cart_id" => "5e89fdcb852404c4ac6ef94cfde28005" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/119244" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-26 06:03:08GET/article/119244614361