Generic placeholder image

Current Psychopharmacology

Editor-in-Chief

ISSN (Print): 2211-5560
ISSN (Online): 2211-5579

Research Article

A Comparative Study between Lithium and Extended-release Carbamazepine in Acute Mania: A Double-blind Clinical Trial

Author(s): Saeed S. Shafti* and Hamid Kaviani

Volume 10, Issue 2, 2021

Published on: 16 June, 2020

Page: [155 - 161] Pages: 7

DOI: 10.2174/2211556009999200616130803

Price: $65

Abstract

Background: Recently, numerous large clinical trials have been performed to evaluate the effectiveness and tolerability of extended-release formulations of carbamazepine in bipolar disorder.

Objective: In the current study, we compared lithium with a prolonged-release form of carbamazepine (Tegretol CR) to evaluate its efficiency and safety in a group of patients with a diagnosis of acute mania.

Methods: Fifty patients with the diagnosis of acute mania were selected for a three-week, doubleblind study, and were randomly administered lithium carbonate or tegretol CR. The main outcome measured in the present evaluation was the Manic State Rating Scale (MSRS), which was scored at baseline and weekly intervals up to the third week. Moreover, insight and overall illness severity and improvement were assessed using the Schedule for Assessment of Insight (SAI), the Clinical Global Impressions-Global Improvement scale (CGI-I), and the Clinical Global Impressions Severity Scale (CGI-S), respectively. The statistical significance was defined with a p-value ≤0.05, and the treatment efficacy was analyzed by independent samples t-test and repeated measures analysis of variance (ANOVA).

Results: Despite the fact that the mean total score of MSRS improved significantly with respect to both lithium carbonate and tegretol CR at the end of the third week, the between-group analysis showed a significant advantage of lithium, regarding both frequency and intensity of symptoms, at the end of the study. The mean total score of SAI, as well, showed significant improvement caused by both of them. Nevertheless, while the CGI-I demonstrated significant improvement in participants taking lithium and tegretol CR, the CGI-S showed significant progress only with lithium. Besides, Cohen’s effect size analysis showed a large improvement of MSRS by lithium and medium improvement by tegretol CR. Post-hoc power analysis showed an intermediate power of 0.42 on behalf of the current evaluation.

Conclusion: While both lithium carbonate and tegretol CR were found to be valuable for the improvement of manic symptoms, management with lithium appears to be more helpful.

Keywords: Acute mania, bipolar disorder, extended-release carbamazepine, lithium, tegreto CR, mood stabilizer.

Graphical Abstract

[1]
American Psychiatric Association (APA) Diagnostic and Statistical Manual of Mental Disorders 5th ed Washington, DC American Psychiatric Association. 2013; 123-32.
[2]
Katona C. Claudia Cooper, Mary Robertson Psychiatry at a Glance 5th ed Oxford John Wiley & Sons Ltd.. 2012; 24-5.
[3]
Burton N. Psychiatry 2nd ed Oxford: John Wiley & Sons Ltd 2010; 89-120.
[4]
Kroon JS, Wohlfarth TD, Dieleman J, et al. Incidence rates and risk factors of bipolar disorder in the general population: a population-based cohort study. Bipolar Disord 2013; 15(3): 306-13.
[http://dx.doi.org/10.1111/bdi.12058 PMID: 23531096]
[5]
Ketter TA. Diagnostic features, prevalence, and impact of bipolar disorder. J Clin Psychiatry 2010; 71(6)e14
[http://dx.doi.org/10.4088/JCP.8125tx11c ] [PMID: 20573324]
[6]
Scherk H, Pajonk FG, Leucht S. Second-generation antipsychotic agents in the treatment of acute mania: a systematic review and meta-analysis of randomized controlled trials. Arch Gen Psychiatry 2007; 64(4): 442-55.
[http://dx.doi.org/10.1001/archpsyc.64.4.442 PMID: 17404121]
[7]
Cipriani A, Barbui C, Salanti G, et al. Comparative efficacy and acceptability of antimanic drugs in acute mania: a multiple-treatments meta-analysis. Lancet 2011; 378(9799): 1306-15.
[http://dx.doi.org/10.1016/S0140-6736(11)60873-8 ] [PMID: 21851976]
[8]
Grunze H, Vieta E, Goodwin GM, et al. WFSBP task force on treatment guidelines for bipolar disorders. the world federation of societies of biological psychiatry (WFSBP) guidelines for the biological treatment of bipolar disorders: update 2010 on the treatment of acute bipolar depression. World J Biol Psychiatry 2010; 11(2): 81-109.
[http://dx.doi.org/10.3109/15622970903555881 PMID: 20148751]
[9]
Girardi P, Brugnoli R, Manfredi G, Sani G. Lithium in bipolar disorder: optimizing therapy using prolonged-release formulations. Drugs R D 2016; 16(4): 293-302.
[http://dx.doi.org/10.1007/s40268-016-0139-7 PMID: 27770296]
[10]
Benard V, Vaiva G, Masson M, Geoffroy PA. Lithium and suicide prevention in bipolar disorder. Encephale 2016; 42(3): 234-41.
[http://dx.doi.org/10.1016/j.encep.2016.02.006 PMID: 27000268]
[11]
Tondo L, Baldessarini RJ. Antisuicidal effects in mood disorders: are they unique to lithium? Pharmacopsychiatry 2018; 51(5): 177-88.
[http://dx.doi.org/10.1055/a-0596-7853 PMID: 29672801]
[12]
Weisler RH. Carbamazepine extended-release capsules in bipolar disorder. Neuropsychiatr Dis Treat 2006; 2(1): 3-11.
[PMID: 19412441]
[13]
Chen CH, Lin SK. Carbamazepine treatment of bipolar disorder: a retrospective evaluation of naturalistic long-term outcomes. BMC Psychiatry 2012; 12: 47.
[http://dx.doi.org/10.1186/1471-244X-12-47 PMID: 22620289]
[14]
Weisler RH, Kalali AH, Cutler AJ, Gazda TD, Ginsberg L. Safety of carbamazepine extended-release capsules used in combination with other psychotropic medications for the treatment of bipolar I disorder. Psychiatry (Edgmont Pa) 2008; 5(5): 49-60.
[PMID: 19727252]
[15]
Weisler RH, Hirschfeld R, Cutler AJ, et al. SPD417 Study Group Extended-release carbamazepine capsules as monotherapy in bipolar disorder: pooled results from two randomised, double-blind, placebo-controlled trials. CNS Drugs 2006; 20(3): 219-31.
[http://dx.doi.org/10.2165/00023210-200620030-00004 PMID: 16529527]
[16]
Weisler RH, Kalali AH, Ketter TA. SPD417 Study Group A multicenter, randomized, double-blind, placebo-controlled trial of extended-release carbamazepine capsules as monotherapy for bipolar disorder patients with manic or mixed episodes. J Clin Psychiatry 2004; 65(4): 478-84.
[http://dx.doi.org/10.4088/JCP.v65n0405 ] [PMID: 15119909]
[17]
Ginsberg LD. Carbamazepine extended-release capsules: a retrospective review of its use in children and adolescents. Ann Clin Psychiatry 2006; 18(1)(Suppl. 1): 3-7.
[http://dx.doi.org/10.1080/10401230600653304 PMID: 16754405]
[18]
Owen RT. Extended-release carbamazepine for acute bipolar mania: a review. Drugs Today (Barc) 2006; 42(5): 283-9.
[http://dx.doi.org/10.1358/dot.2006.42.5.985635 PMID: 16801991]
[19]
World Medical Association. World Medical Association Declaration of Helsinki: ethical principles for medical research involving human subjects. JAMA 2013; 310(20): 2191-4.
[http://dx.doi.org/10.1001/jama.2013.281053 PMID: 24141714]
[20]
Taylor DM, Barnes TRE, Young AH. The Maudsley prescribing guidelines in Psychiatry 13th ed West Sussex, UK John Wiley & Sons Ltd. 2018; 205-25.
[21]
Beigel A, Murphy DL, Bunney WE Jr. The manic-state rating scale: scale construction, reliability, and validity. Arch Gen Psychiatry 1971; 25: 256-62.
[http://dx.doi.org/10.1001/archpsyc.1971.01750150064009]
[22]
David AS. Insight and psychosis. Br J Psychiatry 1990; 156: 798-808.
[http://dx.doi.org/10.1192/bjp.156.6.798 PMID: 2207510]
[23]
Clinical Global Impressions ECDEU Assessment manual for psychopharmacologyRockville: US Department of Health, Education, and Welfare, 1976, DHEW Publication NO (ADM) 1976.pp. 76-338.
[24]
Merikangas KR, Jin R, He JP, et al. Prevalence and correlates of bipolar spectrum disorder in the world mental health survey initiative. Arch Gen Psychiatry 2011; 68(3): 241-51.
[http://dx.doi.org/10.1001/archgenpsychiatry.2011.12 ] [PMID: 21383262]
[25]
Judd LL, Schettler PJ, Akiskal HS, et al. Residual symptom recovery from major affective episodes in bipolar disorders and rapid episode relapse/recurrence. Arch Gen Psychiatry 2008; 65(4): 386-94.
[http://dx.doi.org/10.1001/archpsyc.65.4.386 PMID: 18391127]
[26]
Judd LL, Akiskal HS, Schettler PJ, et al. The long-term natural history of the weekly symptomatic status of bipolar I disorder. Arch Gen Psychiatry 2002; 59(6): 530-7.
[http://dx.doi.org/10.1001/archpsyc.59.6.530 PMID: 12044195]
[27]
Morriss RK, Faizal MA, Jones AP, Williamson PR, Bolton C, McCarthy JP. Interventions for helping people recognise early signs of recurrence in bipolar disorder. Cochrane Database Syst Rev 2007; (1): CD004854
[http://dx.doi.org/10.1002/14651858.CD004854.pub2 ] [PMID: 17253526]
[28]
Fuller MA, Dostrow V, Gupta S, Gazda TD. Practical considerations for carbamazepine use in bipolar disorder. Expert Opin Drug Saf 2006; 5(4): 501-9.
[http://dx.doi.org/10.1517/14740338.5.4.501 PMID: 16774489]
[29]
Swainston Harrison T, Keating GM. Extended-release carbamazepine capsules: in bipolar I disorder. CNS Drugs 2005; 19(8): 709-16.
[http://dx.doi.org/10.2165/00023210-200519080-00006 PMID: 16097852]
[30]
Shafti SS. Olanzapine vs. lithium in management of acute mania. J Affect Disord 2010; 122(3): 273-6.
[http://dx.doi.org/10.1016/j.jad.2009.08.013 PMID: 19740546]
[31]
Shafti SS. Aripiprazole versus lithium in management of acute mania: a randomized clinical trial. East Asian Arch Psychiatry 2018; 28(3): 80-4.
[PMID: 30146495]
[32]
Shafti SS, Shahveisi B. Comparison between lithium and valproate in the treatment of acute mania. J Clin Psychopharmacol 2008; 28(6): 718-20.
[http://dx.doi.org/10.1097/JCP.0b013e31818ce5ba ] [PMID: 19011453]
[33]
Yildiz A, Vieta E, Leucht S, Baldessarini RJ. Efficacy of antimanic treatments: meta-analysis of randomized, controlled trials. Neuropsychopharmacology 2011; 36(2): 375-89.
[http://dx.doi.org/10.1038/npp.2010.192 ] [PMID: 20980991]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version1.57sRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:43:25] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:43:26] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:43:26] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:43:26] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (301ms)time
  • Application (1.27s)time
  • 1 x Application (80.88%)
    1.27s
    1 x Booting (19.12%)
    301ms
    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 duplicated1.09s
    • 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 ('314555251','',1,1740775405,1740775405) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740775405
      11.96msalphaeurekaselec_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 ('314555251','/article/107393',1,1740775405,1740775405)
      260μ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 >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) 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 >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) 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 >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) 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 >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) 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 >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) 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 >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314555251 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314555251) limit 1
      22.27msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314555251
      • 1: 314555251
      • 2: 314555251
      • 3: 314555251
      • 4: 314555251
      • 5: 314555251
      • 6: 314555251
      • 7: 314555251
      • 8: 314555251
      • 9: 314555251
      • 10: 314555251
      • 11: 314555251
      • 12: 314555251
      • 13: 314555251
      • 14: 314555251
      • 15: 314555251
      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=107393
      1.85msalphaeurekaselec_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` = 121 limit 1
      1.19msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 121
      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=121) and sj.journal_id!=121 group by `j`.`nid`) as `aggregate_table`
      1.92msalphaeurekaselec_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=121) and sj.journal_id!=121 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.46msalphaeurekaselec_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=121) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      28.21msalphaeurekaselec_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=121) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      7.02msalphaeurekaselec_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` = '107393'
      15.04msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 107393
      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` = '107393'
      33.41msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 107393
      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` = '107393' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      27.52msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 107393
      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
      540μ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
      780μ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 = 121 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      89.52msalphaeurekaselec_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 = 121 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      13.14msalphaeurekaselec_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 = 121 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      2.35msalphaeurekaselec_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` = 107393 limit 1
      4.11msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 107393
      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 = 107393 and content_type = 'article' order by status desc limit 1
      8.57msalphaeurekaselec_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 = 281 and cd.sub_disease_id = 297 and content_id!=107393 and cd.content_type = 'article' order by rand() limit 20
      615msalphaeurekaselec_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` = 182845 limit 1
      3.14msalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 182845
      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
      330μ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` = 'CPSP' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      1.62msalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CPSP
      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 = '107393' 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) )
      990μ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 = '10659' 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) )
      940μ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 = '3009' 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) )
      1.05msalphaeurekaselec_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 <= 314555251 and j.to_ip >=314555251 )) and ((j.from_date <= 1740775406 and j.to_date >= 1740775406 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3009) 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 <= 314555251 and j.to_ip >=314555251 )) and ((j.from_date <= 1740775406 and j.to_date >= 1740775406 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3009) 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 <= 314555251 and j.to_ip >=314555251 )) and ((j.from_date <= 1740775406 and j.to_date >= 1740775406 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3009)
      180msalphaeurekaselec_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 <= 314555251 and j.to_ip >=314555251 )) and ((j.from_date <= 1740775406 and j.to_date >= 1740775406 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10659) 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 <= 314555251 and j.to_ip >=314555251 )) and ((j.from_date <= 1740775406 and j.to_date >= 1740775406 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10659) 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 <= 314555251 and j.to_ip >=314555251 )) and ((j.from_date <= 1740775406 and j.to_date >= 1740775406 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10659)
      940μ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 <= 314555251 and j.to_ip >=314555251 )) and ((j.from_date <= 1740775406 and j.to_date >= 1740775406 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 107393) 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 <= 314555251 and j.to_ip >=314555251 )) and ((j.from_date <= 1740775406 and j.to_date >= 1740775406 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 107393) 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 <= 314555251 and j.to_ip >=314555251 )) and ((j.from_date <= 1740775406 and j.to_date >= 1740775406 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 107393)
      880μ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` < '155' and is_uploaded = 1 and issue_id = 10659 order by cast(first_page as SIGNED) desc limit 1
      810μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 155
      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` > '161' and is_uploaded = 1 and issue_id = 10659 order by cast(first_page as SIGNED) asc limit 1
      650μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 161
      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'
      580μ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
      430μ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` = 107393 limit 1
      3.95msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 107393
      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` = 121 and `b`.`banner_from_date` <= 1740775406 and `b`.`banner_to_date` >= 1740775406 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.79msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 121
      • 3: 1740775406
      • 4: 1740775406
      • 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` = 121 and `b`.`banner_from_date` <= 1740775406 and `b`.`banner_to_date` >= 1740775406 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.65msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 121
      • 3: 1740775406
      • 4: 1740775406
      • 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='5e32ff860ff3814526edb7f25a6397b0'
      460μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:291
      • 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
        06awk8Fc6Yx6twkzyOWRToPUUXjcXYIavl7cGsSM
        uc_cart_id
        5e32ff860ff3814526edb7f25a6397b0
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/107393" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/107393
        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 => "Fri, 28 Feb 2025 20:43:26 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Inp4VjNmRVpXVXRlU3R3TDlWWkdMU2c9PSIsInZhbHVlIjoieE12YlhZdkx4SkdIMzNYS05jTGgvS2V4LzlITzJBMmVweFptUmhHREZOWnRrRUxUUzh1eGM4aElhTVdTeERuMXhNT3pDa3dlV051bjBydVpiUS9LTmZ5NzRoN1pwZEsrRVVnbVFOZTFibFU0dU5na2tCaE1QUm9hSmYrVm1uajQiLCJtYWMiOiI3YWU3MTdmMzliOGYzMGU2MDExNGMzNzgwNzI0YWQ5M2UyMjFkZjBkY2FiOTQxNTZhMzExZTA0ODdlZjJlNTVlIiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 08:43:26 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Inp4VjNmRVpXVXRlU3R3TDlWWkdMU2c9PSIsInZhbHVlIjoieE12YlhZdkx4SkdIMzNYS05jTGgvS2V4LzlITzJBMmVweFptUmhHREZOWnRrRUxUUzh1eGM4aElhTVdTeERuMXhNT3pDa" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkIxZWVHdEhiWnVUMnY0K3ROUU5mT0E9PSIsInZhbHVlIjoiOGQ2QmxGcWU0eW8yV1h2QnkxRnRXSHJEai9DaFo2RlQyR3M5cEhUVTlpcEtidk13ajV5eG94Rm9rdVllK1BZYzNoN1ZSSE9IbklVVi9VcEcyOFZEeWJHcm91ZmJmU3k0Rk1GVjhzdENXQmhJSG1CWTJHMy90R05kanRFSkZ2VHkiLCJtYWMiOiJiNTQ1MWZiYzU4ZDNkZWFjMGZlMjFjNzVhN2IyNDFkNjE4NTFlMWQ5YzNkMjU1NmU2Y2NkNWE1MTRhNTY4OTI2IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkIxZWVHdEhiWnVUMnY0K3ROUU5mT0E9PSIsInZhbHVlIjoiOGQ2QmxGcWU0eW8yV1h2QnkxRnRXSHJEai9DaFo2RlQyR3M5cEhUVTlpcEtidk13ajV5eG94Rm9" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Inp4VjNmRVpXVXRlU3R3TDlWWkdMU2c9PSIsInZhbHVlIjoieE12YlhZdkx4SkdIMzNYS05jTGgvS2V4LzlITzJBMmVweFptUmhHREZOWnRrRUxUUzh1eGM4aElhTVdTeERuMXhNT3pDa3dlV051bjBydVpiUS9LTmZ5NzRoN1pwZEsrRVVnbVFOZTFibFU0dU5na2tCaE1QUm9hSmYrVm1uajQiLCJtYWMiOiI3YWU3MTdmMzliOGYzMGU2MDExNGMzNzgwNzI0YWQ5M2UyMjFkZjBkY2FiOTQxNTZhMzExZTA0ODdlZjJlNTVlIiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 08:43:26 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Inp4VjNmRVpXVXRlU3R3TDlWWkdMU2c9PSIsInZhbHVlIjoieE12YlhZdkx4SkdIMzNYS05jTGgvS2V4LzlITzJBMmVweFptUmhHREZOWnRrRUxUUzh1eGM4aElhTVdTeERuMXhNT3pDa" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkIxZWVHdEhiWnVUMnY0K3ROUU5mT0E9PSIsInZhbHVlIjoiOGQ2QmxGcWU0eW8yV1h2QnkxRnRXSHJEai9DaFo2RlQyR3M5cEhUVTlpcEtidk13ajV5eG94Rm9rdVllK1BZYzNoN1ZSSE9IbklVVi9VcEcyOFZEeWJHcm91ZmJmU3k0Rk1GVjhzdENXQmhJSG1CWTJHMy90R05kanRFSkZ2VHkiLCJtYWMiOiJiNTQ1MWZiYzU4ZDNkZWFjMGZlMjFjNzVhN2IyNDFkNjE4NTFlMWQ5YzNkMjU1NmU2Y2NkNWE1MTRhNTY4OTI2IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkIxZWVHdEhiWnVUMnY0K3ROUU5mT0E9PSIsInZhbHVlIjoiOGQ2QmxGcWU0eW8yV1h2QnkxRnRXSHJEai9DaFo2RlQyR3M5cEhUVTlpcEtidk13ajV5eG94Rm9" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "06awk8Fc6Yx6twkzyOWRToPUUXjcXYIavl7cGsSM" "uc_cart_id" => "5e32ff860ff3814526edb7f25a6397b0" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/107393" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 20:43:26GET/article/107393414371