Generic placeholder image

Current Psychiatry Research and Reviews

Editor-in-Chief

ISSN (Print): 2666-0822
ISSN (Online): 2666-0830

Mini-Review Article

A Narrative Review on Dialectical Behavior Therapy for Patients with Depressive Difficulties

Author(s): Aryendu Kumar Saini*, Pranay Wal, Ankita Wal, Rashmi Saxena Pal and Om Prakash Verma

Volume 18, Issue 1, 2022

Published on: 01 February, 2022

Page: [3 - 16] Pages: 14

DOI: 10.2174/2666082218666211220153312

Price: $65

Abstract

Background: Dialectical behavior therapy (DBT) is a type of cognitive behavioral therapy (CBT) that was earlier intended to treat only patients with borderline personality disorder (BPD), but researchers have found DBT to treat several psychological disorders, including depression.

Aim: The article aims to review the clinical shreds of evidence regarding the use of DBT to treat depression.

Methods: PubMed literature search was done by applying the year filter range, 2010 to 2021. Another filter applied was “Randomized controlled trial”, so that the strength of evidence could be enhanced. The keywords used were “Dialectical Behavior Therapy” AND “Depression”.

Results: 33 articles were found, out of which only 20 relevant articles were reviewed. DBT was found to alleviate depressive symptoms associated with different psychological disorders like bipolar disorder and BPD but the number of studies that validated the aforementioned were less than those studies which showed that DBT had no significant effect on the patients with depressive difficulties. The long-term effect of DBT for treating depression is under suspect, as studies showed that DBT got ineffective during the follow-ups.

Conclusion: DBT shows benefits in depression, but further studies are still required to validate this concretely as DBT did not show a significant effect when compared to its control counterparts. There is much need for future studies which can evaluate the long-term efficacy of DBT in depression, which is another challenging area because follow-up data did not favor DBT.

Keywords: Depression, borderline personality disorder, psychotherapy, group, behavior therapy, diagnostic and statistical manual of mental disorders, bipolar disorder.

Graphical Abstract

[1]
May JM, Richardi TM, Barth KS. Dialectical behavior therapy as treatment for borderline personality disorder. Ment Health Clin 2016; 6(2): 62-7.
[http://dx.doi.org/10.9740/mhc.2016.03.62] [PMID: 29955449]
[2]
American Psychiatric Association. Diagnostic and Statistical Manual of Mental Disorders. (5th ed),. Washington: American Psychiatric Association 2013.
[3]
Chapman AL. Dialectical behavior therapy: Current indications and unique elements. Psychiatry (Edgmont) 2006; 3(9): 62-8.
[PMID: 20975829]
[4]
O’Connell B, Dowling M. Dialectical behaviour therapy (DBT) in the treatment of borderline personality disorder. J Psychiatr Ment Health Nurs 2014; 21(6): 518-25.
[http://dx.doi.org/10.1111/jpm.12116] [PMID: 24191948]
[5]
Fassbinder E, Assmann N, Schaich A, et al. PRO*BPD: effectiveness of outpatient treatment programs for borderline personality disorder: A comparison of Schema therapy and dialectical behavior therapy: Study protocol for a randomized trial. BMC Psychiat 2018; 18(1): 341.
[http://dx.doi.org/10.1186/s12888-018-1905-6] [PMID: 30340474]
[6]
Zeifman RJ, Boritz T, Barnhart R, Labrish C, McMain SF. The independent roles of mindfulness and distress tolerance in treatment outcomes in dialectical behavior therapy skills training. Pers Disord 2020; 11(3): 181-90.
[http://dx.doi.org/10.1037/per0000368] [PMID: 31647267]
[7]
McMain SF, Guimond T, Barnhart R, Habinski L, Streiner DL. A randomized trial of brief dialectical behaviour therapy skills training in suicidal patients suffering from borderline disorder. Acta Psychiat Scand 2017; 135(2): 138-48.
[http://dx.doi.org/10.1111/acps.12664] [PMID: 27858962]
[8]
Bohus M, Dyer AS, Priebe K, et al. Dialectical behaviour therapy for post-traumatic stress disorder after childhood sexual abuse in patients with and without borderline personality disorder: A randomised controlled trial. Psychother Psychosom 2013; 82(4): 221-33.
[http://dx.doi.org/10.1159/000348451] [PMID: 23712109]
[9]
Hidaka BH. Depression as a disease of modernity: Explanations for increasing prevalence. J Affect Disord 2012; 140(3): 205-14.
[http://dx.doi.org/10.1016/j.jad.2011.12.036] [PMID: 22244375]
[10]
World Health Organization (WHO). Available from: https://www.who.int/health-topics/depression#tab= tab_1
[11]
Kanter JW, Busch AM, Weeks CE, Landes SJ. The nature of clinical depression: Symptoms, syndromes, and behavior analysis. Behav Anal 2008; 31(1): 1-21.
[http://dx.doi.org/10.1007/BF03392158] [PMID: 22478499]
[12]
Cuijpers P, Sijbrandij M, Koole SL, Andersson G, Beekman AT, Reynolds CF III. The efficacy of psychotherapy and pharmacotherapy in treating depressive and anxiety disorders: A meta-analysis of direct comparisons. World Psychiatry 2013; 12(2): 137-48.
[http://dx.doi.org/10.1002/wps.20038] [PMID: 23737423]
[13]
Carvalho AF, Sharma MS, Brunoni AR, Vieta E, Fava GA. The safety, tolerability and risks associated with the use of newer generation antidepressant drugs: A critical review of the literature. Psychother Psychosom 2016; 85(5): 270-88.
[http://dx.doi.org/10.1159/000447034] [PMID: 27508501]
[14]
Fenn MK, Byrne B. The key principles of cognitive behavioral therapy. InnovAiT 2013; 6: 579-85.
[http://dx.doi.org/10.1177/1755738012471029]
[15]
David D, Cristea I, Hofmann SG. Why cognitive behavioral therapy is the current gold standard of psychotherapy. Front Psychiat 2018; 9: 4.
[http://dx.doi.org/10.3389/fpsyt.2018.00004] [PMID: 29434552]
[16]
Rudge S, Feigenbaum JD, Fonagy P. Mechanisms of change in dialectical behaviour therapy and cognitive behaviour therapy for borderline personality disorder: A critical review of the literature. J Ment Health 2020; 29(1): 92-102.
[http://dx.doi.org/10.1080/09638237.2017.1322185] [PMID: 28480806]
[17]
Linehan MM. DBT® Skills Training Handouts and Worksheets. (2nd ed.), New York, USA: Guilford Press 2015. In:
[18]
Keng SL, Smoski MJ, Robins CJ. Effects of mindfulness on psychological health: A review of empirical studies. Clin Psychol Rev 2011; 31(6): 1041-56.
[http://dx.doi.org/10.1016/j.cpr.2011.04.006] [PMID: 21802619]
[19]
Soler J, Elices M, Pascual JC, et al. Effects of mindfulness training on different components of impulsivity in borderline personality disorder: Results from a pilot randomized study. Borderline Personal Disord Emot Dysregul 2016; 3: 1.
[http://dx.doi.org/10.1186/s40479-015-0035-8] [PMID: 26759718]
[20]
What are the benefits of mindfulness? 2012. Available from: https://www.apa.org/education/ce/mindfulness-benefits.pdf.
[21]
Soler J, Pascual JC, Tiana T, et al. Dialectical behaviour therapy skills training compared to standard group therapy in borderline personality disorder: A 3-month randomised controlled clinical trial. Behav Res Ther 2009; 47(5): 353-8.
[http://dx.doi.org/10.1016/j.brat.2009.01.013] [PMID: 19246029]
[22]
Muhomba M, Chugani CD, Amanda A, Kannan U, Divya U. Distress tolerance skills for college students: A pilot investigation of a brief DBT group skills training program. J Coll Stud Psychother 2017; 31(3): 247-56.
[http://dx.doi.org/10.1080/87568225.2017.1294469]
[23]
Perepletchikova F, Axelrod SR, Kaufman J, Rounsaville BJ, Douglas-Palumberi H, Miller AL. Adapting dialectical behaviour therapy for children: Towards a new research agenda for paediatric suicidal and non- suicidal self-injurious behaviours. Child Adolesc Ment Health 2011; 16(2): 116-21.
[http://dx.doi.org/10.1111/j.1475-3588.2010.00583.x] [PMID: 21643467]
[24]
Salsman NL, Linehan MM. Dialectical-behavioral therapy for borderline personality disorder. Prim Psychiat 2006; 13(5): 51-8.
[25]
Luberto CM, Cotton S, McLeish AC, et al. Mindfulness skills and emotion regulation: The mediating role of coping self-efficacy. Mindfulness 2014; 5: 373-80.
[http://dx.doi.org/10.1007/s12671-012-0190-6]
[26]
Lynch TR, Hempel RJ, Whalley B, et al. Refractory depression - mechanisms and efficacy of radically open dialectical behaviour therapy (RefraMED): Findings of a randomised trial on benefits and harms. Br J Psychiat 2020; 216(4): 204-12.
[http://dx.doi.org/10.1192/bjp.2019.53] [PMID: 31317843]
[27]
Goldstein TR, Fersch-Podrat RK, Rivera M, et al. Dialectical behavior therapy for adolescents with bipolar disorder: Results from a pilot randomized trial. J Child Adolesc Psychopharmacol 2015; 25(2): 140-9.
[http://dx.doi.org/10.1089/cap.2013.0145] [PMID: 25010702]
[28]
Van Dijk S, Jeffrey J, Katz MR. A randomized, controlled, pilot study of dialectical behavior therapy skills in a psychoeducational group for individuals with bipolar disorder. J Affect Disord 2013; 145(3): 386-93.
[http://dx.doi.org/10.1016/j.jad.2012.05.054] [PMID: 22858264]
[29]
Pistorello J, Fruzzetti AE, Maclane C, Gallop R, Iverson KM. Dialectical behavior therapy (DBT) applied to college students: A randomized clinical trial. J Consult Clin Psychol 2012; 80(6): 982-94.
[http://dx.doi.org/10.1037/a0029096] [PMID: 22730955]
[30]
Javaras KN, Pope HG, Lalonde JK, et al. Co-occurrence of binge eating disorder with psychiatric and medical disorders. J Clin Psychiat 2008; 69(2): 266-73.
[http://dx.doi.org/10.4088/JCP.v69n0213] [PMID: 18348600]
[31]
Araujo DM, Santos GF, Nardi AE. Binge eating disorder and depression: A systematic review. World J Biol Psychiat 2010; 11(2 Pt 2): 199-207.
[http://dx.doi.org/10.3109/15622970802563171] [PMID: 20218783]
[32]
Courbasson C, Nishikawa Y, Dixon L. Outcome of dialectical behaviour therapy for concurrent eating and substance use disorders. Clin Psychol Psychother 2012; 19(5): 434-49.
[http://dx.doi.org/10.1002/cpp.748] [PMID: 21416557]
[33]
Cancian ACM, de Souza LAS, Liboni RPA, Machado WL, Oliveira MDS. Effects of a dialectical behavior therapy-based skills group intervention for obese individuals: A Brazilian pilot study. Eat Weight Disord 2019; 24(6): 1099-111.
[http://dx.doi.org/10.1007/s40519-017-0461-2] [PMID: 29197947]
[34]
Goodman M, Banthin D, Blair NJ, et al. A randomized trial of dialectical behavior therapy in high-risk suicidal veterans. J Clin Psychiat 2016; 77(12): e1591-600.
[http://dx.doi.org/10.4088/JCP.15m10235] [PMID: 27780335]
[35]
Lin TJ, Ko HC, Wu JY, Oei TP, Lane HY, Chen CH. The effectiveness of dialectical behavior therapy skills training group vs. Cognitive Therapy Group on reducing depression and suicide attempts for borderline personality disorder in Taiwan. Arch Suicide Res 2019; 23(1): 82-99.
[http://dx.doi.org/10.1080/13811118.2018.1436104] [PMID: 29528807]
[36]
Mehlum L, Ramberg M, Tørmoen AJ, et al. Dialectical behavior therapy compared with enhanced usual care for adolescents with repeated suicidal and self-harming behavior: Outcomes over a one-year follow-up. J Am Acad Child Adolesc Psychiat 2016; 55(4): 295-300.
[http://dx.doi.org/10.1016/j.jaac.2016.01.005] [PMID: 27015720]
[37]
Boersma K, Södermark M, Hesser H, Flink IK, Gerdle B, Linton SJ. Efficacy of a transdiagnostic emotion-focused exposure treatment for chronic pain patients with comorbid anxiety and depression: A randomized controlled trial. Pain 2019; 160(8): 1708-18.
[http://dx.doi.org/10.1097/j.pain.0000000000001575] [PMID: 31335641]
[38]
Mehlum L, Ramleth RK, Tørmoen AJ, et al. Long term effectiveness of dialectical behavior therapy versus enhanced usual care for adolescents with self-harming and suicidal behavior. J Child Psychol Psychiat 2019; 60(10): 1112-22.
[http://dx.doi.org/10.1111/jcpp.13077] [PMID: 31127612]
[39]
Mehlum L, Tørmoen AJ, Ramberg M, et al. Dialectical behavior therapy for adolescents with repeated suicidal and self-harming behavior: A randomized trial. J Am Acad Child Adolesc Psychiat 2014; 53(10): 1082-91.
[http://dx.doi.org/10.1016/j.jaac.2014.07.003] [PMID: 25245352]
[40]
Andreasson K, Krogh J, Wenneberg C, et al. Effectiveness of dialectical behavior therapy versus collaborative assessment and management of suicidality treatment for reduction of self-harm in adults with borderline personality traits and disorder-a randomized observer-blinded clinical trial. Depress Anxiety 2016; 33(6): 520-30.
[http://dx.doi.org/10.1002/da.22472] [PMID: 26854478]
[41]
Linehan MM, Korslund KE, Harned MS, et al. Dialectical behavior therapy for high suicide risk in individuals with borderline personality disorder: A randomized clinical trial and component analysis. JAMA Psychiat 2015; 72(5): 475-82.
[http://dx.doi.org/10.1001/jamapsychiatry.2014.3039] [PMID: 25806661]
[42]
McMain SF, Guimond T, Streiner DL, Cardish RJ, Links PS. Dialectical behavior therapy compared with general psychiatric management for borderline personality disorder: Clinical outcomes and functioning over a 2-year follow-up. Am J Psychiat 2012; 169(6): 650-61.
[http://dx.doi.org/10.1176/appi.ajp.2012.11091416] [PMID: 22581157]
[43]
Shamloo N, Gharavi M, Asgharipour N. The effectiveness of dialectical behavior therapy based on emotion regulation training on depression symptoms. JFMH 2014; 16(63): 261-71.
[44]
Neacsiu AD, Rizvi SL, Linehan MM. Dialectical behavior therapy skills use as a mediator and outcome of treatment for borderline personality disorder. Behav Res Ther 2010; 48(9): 832-9.
[http://dx.doi.org/10.1016/j.brat.2010.05.017] [PMID: 20579633]
[45]
Nyamathi AM, Shin SS, Smeltzer J, et al. Achieving drug and alcohol abstinence among recently incarcerated homeless women: A randomized controlled trial comparing dialectical behavioral therapy-case management with a health promotion program. Nurs Res 2017; 66(6): 432-41.
[http://dx.doi.org/10.1097/NNR.0000000000000249] [PMID: 29095374]
[46]
Harned MS, Korslund KE, Linehan MM. A pilot randomized controlled trial of dialectical behavior therapy with and without the dialectical behavior therapy prolonged exposure protocol for suicidal and self-injuring women with borderline personality disorder and PTSD. Behav Res Ther 2014; 55: 7-17.
[http://dx.doi.org/10.1016/j.brat.2014.01.008] [PMID: 24562087]
[47]
Ward-Ciesielski EF, Jones CB, Wielgus MD, Wilks CR, Linehan MM. Single-session dialectical behavior therapy skills training versus relaxation training for non-treatment-engaged suicidal adults: A randomized controlled trial. BMC Psychol 2016; 4: 13.
[http://dx.doi.org/10.1186/s40359-016-0117-4] [PMID: 27009317]
[48]
Bohus M, Kleindienst N, Hahn C, et al. Dialectical behavior therapy for posttraumatic stress disorder (DBT-PTSD) compared with cognitive processing therapy (CPT) in complex presentations of PTSD in women survivors of childhood abuse: A randomized clinical trial. JAMA Psychiat 2020; 77(12): 1235-45.
[http://dx.doi.org/10.1001/jamapsychiatry.2020.2148] [PMID: 32697288]
[49]
Carter JC, Kenny TE, Singleton C, Van Wijk M, Heath O. Dialectical behavior therapy self-help for binge-eating disorder: A randomized controlled study. Int J Eat Disord 2020; 53(3): 451-60.
[http://dx.doi.org/10.1002/eat.23208] [PMID: 31821592]
[50]
DiRocco A, Liu L, Burrets M. Enhancing dialectical behavior therapy for the treatment of bipolar disorder. Psychiatr Q 2020; 91(3): 629-54.
[http://dx.doi.org/10.1007/s11126-020-09709-6] [PMID: 32144641]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version285msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[21:24:45] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[21:24:45] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[21:24:45] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[21:24:45] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (101ms)time
  • Application (184ms)time
  • 1 x Application (64.67%)
    184ms
    1 x Booting (35.33%)
    101ms
    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
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated107ms
    • 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 ('316600437','',1,1740345885,1740345885) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740345885
      990μsalphaeurekaselec_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 ('316600437','/article/119538',1,1740345885,1740345885)
      240μ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 >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) 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 >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) 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 >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) 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 >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) 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 >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) 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 >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) limit 1
      18.07msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316600437
      • 1: 316600437
      • 2: 316600437
      • 3: 316600437
      • 4: 316600437
      • 5: 316600437
      • 6: 316600437
      • 7: 316600437
      • 8: 316600437
      • 9: 316600437
      • 10: 316600437
      • 11: 316600437
      • 12: 316600437
      • 13: 316600437
      • 14: 316600437
      • 15: 316600437
      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=119538
      980μ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` = 174 limit 1
      520μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 174
      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=174) and sj.journal_id!=174 group by `j`.`nid`) as `aggregate_table`
      710μ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=174) and sj.journal_id!=174 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      570μ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=174) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      810μ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=174) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      680μ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` = '119538'
      800μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 119538
      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` = '119538'
      2.61msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 119538
      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` = '119538' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.65msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 119538
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ArticleController.php:2533
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      270μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      620μ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 = 174 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      42.25msalphaeurekaselec_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 = 174 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      3.21msalphaeurekaselec_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 = 174 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      1.97msalphaeurekaselec_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` = 119538 limit 1
      240μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 119538
      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 = 119538 and content_type = 'article' order by status desc limit 1
      380μ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 a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 258 and cd.sub_disease_id = 317 and content_id!=119538 and cd.content_type = 'article' order by rand() limit 20
      4.37msalphaeurekaselec_live_10_06_2022Article.php#769
      Backtrace
      • 11. app/Models/Article.php:769
      • 12. app/Http/Controllers/ArticleController.php:2098
      • 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` = 199178 limit 1
      210μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 199178
      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
      240μ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` = 'CPRR' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      360μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CPRR
      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 = '119538' 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) )
      480μ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 = '11746' 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) )
      400μ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 = '3216' 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) )
      390μ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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740345885 and j.to_date >= 1740345885 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3216) 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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740345885 and j.to_date >= 1740345885 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3216) 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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740345885 and j.to_date >= 1740345885 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3216)
      15.83msalphaeurekaselec_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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740345885 and j.to_date >= 1740345885 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11746) 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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740345885 and j.to_date >= 1740345885 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11746) 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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740345885 and j.to_date >= 1740345885 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11746)
      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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740345885 and j.to_date >= 1740345885 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 119538) 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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740345885 and j.to_date >= 1740345885 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 119538) 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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740345885 and j.to_date >= 1740345885 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 119538)
      620μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2329
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `article` where `first_page` < '3' and is_uploaded = 1 and issue_id = 11746 order by cast(first_page as SIGNED) desc limit 1
      440μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 3
      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` > '16' and is_uploaded = 1 and issue_id = 11746 order by cast(first_page as SIGNED) asc limit 1
      360μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 16
      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'
      150μ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
      160μ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` = 119538 limit 1
      2.32msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 119538
      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` = 174 and `b`.`banner_from_date` <= 1740345885 and `b`.`banner_to_date` >= 1740345885 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.12msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 174
      • 3: 1740345885
      • 4: 1740345885
      • 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` = 174 and `b`.`banner_from_date` <= 1740345885 and `b`.`banner_to_date` >= 1740345885 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.06msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 174
      • 3: 1740345885
      • 4: 1740345885
      • 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='efded98d189f5c8f2dd2bee21944284f'
      210μ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
        n2DBsdkYUv17LIEmyxmXNlxgUlQRYl4l1T8UqDHJ
        uc_cart_id
        efded98d189f5c8f2dd2bee21944284f
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/119538" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/119538
        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=eyJpdiI6Imo3dEh5YjU3dG9iaHhKRnhJVWVtZlE9PSIsInZhbHVlIjoiSm9Md0NjS1hrbDhMelJES3FlVGdkL0UzTjlDbnM2T2JLSVg0NWhsejR6ND0iLCJtYWMiOiJiNDRkNWJlYTBiMTgwZjZhN2JiYTUyMjNhMWNjMDM4MTM2MWNjMjFiZTBiODFiYjkwZjM1MDJiMjRmMzI0M2FkIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6Imo3dEh5YjU3dG9iaHhKRnhJVWVtZlE9PSIsInZhbHVlIjoiSm9Md0NjS1hrbDhMelJES3FlVGdkL0UzTjlDbnM2T2JLSVg0NWhsejR6ND0iLCJtYWMiOiJiNDRkNWJlYTBiMTgw" ] "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:24:45 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlRhZjhTcjVyNm9GNEhqbXhwS2YwOHc9PSIsInZhbHVlIjoidFExTllJb1VWbS93VkIzZWhiVm9GMXpib2NZZ254eG51VDB6NmhrdXZnSTVyRUVxelhubFNsdUc0QXh3RU9GN3NjeWZXZEVQTzBVTFQ4SmUxOHVpWitaNWttMExwYWxvem5ZQ0VGTFB6ejFXd2MxR2hTQytRUjZURW9kSkt6aW8iLCJtYWMiOiIyMTc2YTNlMjAzYzU0MWQ0Mjg0NTI5NjRhYjhhMGVlMzJjZWEyNzVhN2M2NWZjYTFlNTc2MzQ0NmEwYzQ5MjQ3IiwidGFnIjoiIn0%3D; expires=Wed, 26 Feb 2025 09:24:45 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlRhZjhTcjVyNm9GNEhqbXhwS2YwOHc9PSIsInZhbHVlIjoidFExTllJb1VWbS93VkIzZWhiVm9GMXpib2NZZ254eG51VDB6NmhrdXZnSTVyRUVxelhubFNsdUc0QXh3RU9GN3NjeWZXZ" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ii92RzJDN1JtbDlwdEI0UlZjdElrb0E9PSIsInZhbHVlIjoiMnpNeEZtS05leVlBdFUvZWlCc1ZmWmd0cEV2TElDRkJOSjdsUW11SUx3UkM1eVZQOTd2TnlXU09tMy80b29GaDNwcHlES1NCUUR6bHpybEFrbE5McnZSUEJYZE04VXYxOU1HZzIyOURZeEtGLzBUL1M0TEN5WVpqZFNXeksyaWMiLCJtYWMiOiI2MzMzMzc5YWEwMjA5ZTc0MzYwNzBkZDEyN2FiNjgwOWMxNGEyNWEwMWQxNjQwZTc3ZDAxYTY1MzlkODJkZmFlIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ii92RzJDN1JtbDlwdEI0UlZjdElrb0E9PSIsInZhbHVlIjoiMnpNeEZtS05leVlBdFUvZWlCc1ZmWmd0cEV2TElDRkJOSjdsUW11SUx3UkM1eVZQOTd2TnlXU09" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlRhZjhTcjVyNm9GNEhqbXhwS2YwOHc9PSIsInZhbHVlIjoidFExTllJb1VWbS93VkIzZWhiVm9GMXpib2NZZ254eG51VDB6NmhrdXZnSTVyRUVxelhubFNsdUc0QXh3RU9GN3NjeWZXZEVQTzBVTFQ4SmUxOHVpWitaNWttMExwYWxvem5ZQ0VGTFB6ejFXd2MxR2hTQytRUjZURW9kSkt6aW8iLCJtYWMiOiIyMTc2YTNlMjAzYzU0MWQ0Mjg0NTI5NjRhYjhhMGVlMzJjZWEyNzVhN2M2NWZjYTFlNTc2MzQ0NmEwYzQ5MjQ3IiwidGFnIjoiIn0%3D; expires=Wed, 26-Feb-2025 09:24:45 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlRhZjhTcjVyNm9GNEhqbXhwS2YwOHc9PSIsInZhbHVlIjoidFExTllJb1VWbS93VkIzZWhiVm9GMXpib2NZZ254eG51VDB6NmhrdXZnSTVyRUVxelhubFNsdUc0QXh3RU9GN3NjeWZXZ" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ii92RzJDN1JtbDlwdEI0UlZjdElrb0E9PSIsInZhbHVlIjoiMnpNeEZtS05leVlBdFUvZWlCc1ZmWmd0cEV2TElDRkJOSjdsUW11SUx3UkM1eVZQOTd2TnlXU09tMy80b29GaDNwcHlES1NCUUR6bHpybEFrbE5McnZSUEJYZE04VXYxOU1HZzIyOURZeEtGLzBUL1M0TEN5WVpqZFNXeksyaWMiLCJtYWMiOiI2MzMzMzc5YWEwMjA5ZTc0MzYwNzBkZDEyN2FiNjgwOWMxNGEyNWEwMWQxNjQwZTc3ZDAxYTY1MzlkODJkZmFlIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ii92RzJDN1JtbDlwdEI0UlZjdElrb0E9PSIsInZhbHVlIjoiMnpNeEZtS05leVlBdFUvZWlCc1ZmWmd0cEV2TElDRkJOSjdsUW11SUx3UkM1eVZQOTd2TnlXU09" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "n2DBsdkYUv17LIEmyxmXNlxgUlQRYl4l1T8UqDHJ" "uc_cart_id" => "efded98d189f5c8f2dd2bee21944284f" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/119538" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-23 21:24:45GET/article/119538414371