Generic placeholder image

Current Stem Cell Research & Therapy

Editor-in-Chief

ISSN (Print): 1574-888X
ISSN (Online): 2212-3946

Meta-Analysis

Mesenchymal Stem Cell Transplantation For Hepatitis B Virus-Related Acute-on-Chronic Liver Failure: A Systematic Review and Meta-Analysis

Author(s): Fang Cheng*, Zhong Huang, Wei Wei and Zhi Li

Volume 18, Issue 6, 2023

Published on: 13 January, 2023

Page: [834 - 842] Pages: 9

DOI: 10.2174/1574888X18666221214123844

Price: $65

Abstract

Background: Hepatitis B virus-related acute-on-chronic liver failure (HBV-ACLF) is a severe complication with a poor prognosis. Recently, mesenchymal stem cell (MSC)-based therapy for HBVACLF has shown considerable promise. Therefore, this systematic review and meta-analysis aimed to evaluate the efficacy and safety of MSC transplantation for patients with HBV-ACLF.

Methods: The PubMed, Cochrane Library, CNKI, and Embase databases were searched from their inception to March 2021 for reports on MSC therapy for HBV-ACLF. We used RevMan 5.3 to perform the systematic review and meta-analysis.

Results: Four studies were ultimately included. Compared with the control treatment, allogeneic MSC treatment resulted in a higher cumulative survival rate among ACLF patients (OR=2.27; 95% CI 1.35, 3.81; p=0.002). The umbilical cord-derived MSC (UC-MSC) group obtained a higher survival rate than the control group (OR = 2.33; 95% CI 1.17, 4.63; p=0.02). The group with multiple interval peripheral vein injections of MSCs obtained a higher survival rate than the control group (OR = 2.09; 95% CI 1.20, 3.67; p=0.01). None of the adverse events were MSC-related.

Conclusion: Our study indicates that MSC transplantation can significantly increase survival rates by improving liver function without severe adverse events. UC-MSCs harvested for allogeneic infusion via peripheral veins appear to provide superior treatment for patients.

Graphical Abstract

[1]
Sarin SK, Choudhury A, Sharma MK, et al. Acute-on-chronic liver failure: Consensus recommendations of the Asian Pacific association for the study of the liver (APASL): An update. Hepatol Int 2019; 13(4): 353-90.
[http://dx.doi.org/10.1007/s12072-019-09946-3] [PMID: 31172417]
[2]
Gu W, Xu B, Zheng X, et al. Acute-on-chronic liver failure in China: Rationale for developing a patient registry and baseline characteristics. Am J Epidemiol 2018; 187(9): 1829-39.
[http://dx.doi.org/10.1093/aje/kwy083] [PMID: 29762630]
[3]
Wu D, Zhang S, Xie Z, et al. Plasminogen as a prognostic biomarker for HBV-related acute-on-chronic liver failure. J Clin Invest 2020; 130(4): 2069-80.
[http://dx.doi.org/10.1172/JCI130197] [PMID: 32175919]
[4]
Volarevic V, Nurkovic J, Arsenijevic N, Stojkovic M. Concise review: Therapeutic potential of mesenchymal stem cells for the treatment of acute liver failure and cirrhosis. Stem Cells 2014; 32(11): 2818-23.
[http://dx.doi.org/10.1002/stem.1818] [PMID: 25154380]
[5]
Lee KD, Kuo TKC, Whang-Peng J, et al. In vitro hepatic differentiation of human mesenchymal stem cells. Hepatology 2004; 40(6): 1275-84.
[http://dx.doi.org/10.1002/hep.20469] [PMID: 15562440]
[6]
Honczarenko M, Le Y, Swierkowski M, Ghiran I, Glodek AM, Silberstein LE. Human bone marrow stromal cells express a distinct set of biologically functional chemokine receptors. Stem Cells 2006; 24(4): 1030-41.
[http://dx.doi.org/10.1634/stemcells.2005-0319] [PMID: 16253981]
[7]
Shi M, Liu Z-W, Wang F-S. Immunomodulatory properties and therapeutic application of mesenchymal stem cells. Clin Exp Immunol 2011; 164(1): 1-8.
[http://dx.doi.org/10.1111/j.1365-2249.2011.04327.x] [PMID: 21352202]
[8]
Moher D, Liberati A, Tetzlaff J, Altman DG. Preferred reporting items for systematic reviews and meta-analyses: The PRISMA statement. PLoS Med 2009; 6(7): e1000097.
[http://dx.doi.org/10.1371/journal.pmed.1000097] [PMID: 19621072]
[9]
Higgins J, Green S. Cochrane handbook for systematic reviews for interventions. Cochrane Database Syst Rev 2011; 2011(2): S38.
[10]
Shi M, Zhang Z, Xu R, et al. Human mesenchymal stem cell transfusion is safe and improves liver function in acute-on-chronic liver failure patients. Stem Cells Transl Med 2012; 1(10): 725-31.
[http://dx.doi.org/10.5966/sctm.2012-0034] [PMID: 23197664]
[11]
Li YH, Xu Y, Wu HM, Yang J, Yang LH, Yue-Meng W. Umbilical cord-derived mesenchymal stem cell transplantation in Hepatitis B virus related acute-on-chronic liver failure treated with plasma exchange and entecavir: A 24-month prospective study. Stem Cell Rev 2016; 12(6): 645-53.
[http://dx.doi.org/10.1007/s12015-016-9683-3] [PMID: 27687792]
[12]
Lin B, Chen J, Qiu W, et al. Allogeneic bone marrow-derived mesenchymal stromal cells for hepatitis B virus-related acute-on-chronic liver failure: A randomized controlled trial. Hepatology 2017; 66(1): 209-19.
[http://dx.doi.org/10.1002/hep.29189] [PMID: 28370357]
[13]
Xu W, He H, Pan S, et al. Combination treatments of plasma exchange and umbilical cord-derived mesenchymal stem cell transplantation for patients with Hepatitis B virus-related acute-on-chronic liver failure: A clinical trial in China. Stem Cells Int 2019; 2019: 1-10.
[http://dx.doi.org/10.1155/2019/4130757] [PMID: 30863450]
[14]
Flink HJ, Sprengers D, Hansen BE, et al. Flares in chronic hepatitis B patients induced by the host or the virus? Relation to treatment response during Peg-interferon α-2b therapy. Gut 2005; 54(11): 1604-9.
[http://dx.doi.org/10.1136/gut.2004.062208] [PMID: 15923670]
[15]
Garg H, Kumar A, Garg V, Sharma P, Sharma BC, Sarin SK. Clinical profile and predictors of mortality in patients of acute-on-chronic liver failure. Dig Liver Dis 2012; 44(2): 166-71.
[http://dx.doi.org/10.1016/j.dld.2011.08.029] [PMID: 21978580]
[16]
Mohamadnejad M, Vosough M, Moossavi S, et al. Intraportal infusion of bone marrow mononuclear or CD133+ cells in patients with decompensated cirrhosis: A double-blind randomized controlled trial. Stem Cells Transl Med 2016; 5(1): 87-94.
[http://dx.doi.org/10.5966/sctm.2015-0004] [PMID: 26659833]
[17]
Suk KT, Yoon JH, Kim MY, et al. Transplantation with autologous bone marrow-derived mesenchymal stem cells for alcoholic cirrhosis: Phase 2 trial. Hepatology 2016; 64(6): 2185-97.
[http://dx.doi.org/10.1002/hep.28693] [PMID: 27339398]
[18]
Wu YZ, Yang L, Zhai YF, Zhang HH, Huo LY. Therapeutic effect of autologous bone marrow mesenchymal stem cells on hepatic fibrosis, liver function, MELD score and 1-year survival rate in patients with decompensated hepatitis B. Chin J Tissue Eng Res 2017; 21(13): 2049-55.
[19]
Cao Z, Liu Y, Wang S, et al. The impact of HBV flare on the outcome of HBV‐related decompensated cirrhosis patients with bacterial infection. Liver Int 2019; 39(10): 1943-53.
[http://dx.doi.org/10.1111/liv.14176] [PMID: 31206235]
[20]
Peng L, Xie D, Lin BL, et al. Autologous bone marrow mesenchymal stem cell transplantation in liver failure patients caused by hepatitis B: Short-term and long-term outcomes. Hepatology 2011; 54(3): 820-8.
[http://dx.doi.org/10.1002/hep.24434] [PMID: 21608000]
[21]
Peng L, Li H, Gu L, Peng XM, Huang YS, Gao ZL. Comparison of biological characteristics of marrow mesenchymal stem cells in hepatitis B patients and normal adults. World J Gastroenterol 2007; 13(11): 1743-6.
[http://dx.doi.org/10.3748/wjg.v13.i11.1743] [PMID: 17461481]
[22]
Juhas S, Martínek J, Ryska O, Dolezel R, Ryska M, Juhásová J. Autologous transplantation of mesenchymal stem cells into the portal vein of the miniature pig; a preliminary experiment for NOTES approach. Perspectives in Surgery 2019; 98(9): 350-5.
[http://dx.doi.org/10.33699/PIS.2019.98.9.350-355] [PMID: 31698910]
[23]
Sang JF, Shi XL, Han B, et al. Intraportal mesenchymal stem cell transplantation prevents acute liver failure through promoting cell proliferation and inhibiting apoptosis. Hepatobiliary Pancreat Dis Int 2016; 15(6): 602-11.
[http://dx.doi.org/10.1016/S1499-3872(16)60141-8] [PMID: 27919849]
[24]
Cao H, Yang J, Yu J, et al. Therapeutic potential of transplanted placental mesenchymal stem cells in treating Chinese miniature pigs with acute liver failure. BMC Med 2012; 10(1): 56.
[http://dx.doi.org/10.1186/1741-7015-10-56] [PMID: 22673529]
[25]
Xiang GA, Zhang GQ, Fang CH, Gao P, Chen KY. A preliminary study of the homing capacity of allograft mesenchymal stem cells to rat liver. J First Mil Med Univ 2005; 25(8): 994-7. [J].
[PMID: 16109558]
[26]
Kharaziha P, Hellström PM, Noorinayer B, et al. Improvement of liver function in liver cirrhosis patients after autologous mesenchymal stem cell injection: A phase I–II clinical trial. Eur J Gastroenterol Hepatol 2009; 21(10): 1199-205.
[http://dx.doi.org/10.1097/MEG.0b013e32832a1f6c] [PMID: 19455046]
[27]
Terai S, Ishikawa T, Omori K, et al. Improved liver function in patients with liver cirrhosis after autologous bone marrow cell infusion therapy. Stem Cells 2006; 24(10): 2292-8.
[http://dx.doi.org/10.1634/stemcells.2005-0542] [PMID: 16778155]
[28]
Sun L, Fan X, Zhang L, et al. Bone mesenchymal stem cell transplantation via four routes for the treatment of acute liver failure in rats. Int J Mol Med 2014; 34(4): 987-96.
[http://dx.doi.org/10.3892/ijmm.2014.1890] [PMID: 25110277]
[29]
Piscaglia AC, Campanale M, Gasbarrini A, Gasbarrini G. Stem cell-based therapies for liver diseases: State of the art and new perspectives. Stem Cells Int 2010; 2010: 1-10.
[http://dx.doi.org/10.4061/2010/259461] [PMID: 21048845]
[30]
Zekri AR, Salama H, Medhat E, et al. The impact of repeated autologous infusion of haematopoietic stem cells in patients with liver insufficiency. Stem Cell Res Ther 2015; 6(1): 118.
[http://dx.doi.org/10.1186/s13287-015-0106-1]
[31]
Zhong YS, Lin N, Deng MH, Zhang FC, Tang ZF, Xu RY. Deficient proliferation of bone marrow-derived mesenchymal stem cells in patients with chronic hepatitis B viral infections and cirrhosis of the liver. Dig Dis Sci 2010; 55(2): 438-45.
[http://dx.doi.org/10.1007/s10620-009-0733-4] [PMID: 19242797]
[32]
Bongso A, Fong CY. The therapeutic potential, challenges and future clinical directions of stem cells from the Wharton’s jelly of the human umbilical cord. Stem Cell Rev 2013; 9(2): 226-40.
[http://dx.doi.org/10.1007/s12015-012-9418-z] [PMID: 23233233]
[33]
Ding DC, Chang YH, Shyu WC, Lin SZ. Human umbilical cord mesenchymal stem cells: A new era for stem cell therapy. Cell Transplant 2015; 24(3): 339-47.
[http://dx.doi.org/10.3727/096368915X686841] [PMID: 25622293]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version277msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[15:42:11] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[15:42:11] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[15:42:11] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[15:42:11] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (105ms)time
  • Application (173ms)time
  • 1 x Application (62.24%)
    173ms
    1 x Booting (37.76%)
    105ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    36 statements were executed, 4 of which were duplicates, 32 unique. Show only duplicated89.36ms
    • Connection Establishedalphaeurekaselec_live_10_06_2022UserAccessCheck.php#24
      Backtrace
      • 9. middleware::check_user_access:24
      • 10. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 11. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • INSERT INTO visitor_ip_address (ip_address,visitor_agent,visitor_count, created_on,updated_on) VALUES ('222023364','',1,1740498131,1740498131) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740498131
      1.23msalphaeurekaselec_live_10_06_2022UserAccessCheck.php#24
      Backtrace
      • 11. middleware::check_user_access:24
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('222023364','/article/128259',1,1740498131,1740498131)
      170μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_corporate WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_token WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_trail WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_corporate WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_token WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 222023364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222023364) limit 1
      14.67msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 222023364
      • 1: 222023364
      • 2: 222023364
      • 3: 222023364
      • 4: 222023364
      • 5: 222023364
      • 6: 222023364
      • 7: 222023364
      • 8: 222023364
      • 9: 222023364
      • 10: 222023364
      • 11: 222023364
      • 12: 222023364
      • 13: 222023364
      • 14: 222023364
      • 15: 222023364
      Backtrace
      • 14. app/Models/UserAccess/UserAccess.php:784
      • 15. middleware::check_user_access:114
      • 16. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • SELECT at.type_name, p.copyright, p.publisher_location,m.month,y.year, a.publish_on, a.nid article_nid,a.article_id, a.pmid, a.issue_id, a.title, a.abstract,a.podcast,a.altmetric_score,a.altmetric_url,a.kudos_url, a.page_count, a.first_page, a.elocator, a.last_page, i.publication_date, a.file_name, a.file_path, a.doi, a.is_epub,a.epub_type, a.volume_id, a.is_uploaded, a.editor_choice, a.is_epub, j.image_file_name, a.article_no, a.art_type AS article_type, a.supplementary_filename,a.html_filename,a.prc_filename,a.epub_filename, a.graph_abs_lg_filename, a.graph_abs_sm_filename, a.oa_image_lg_filename, a.oa_image_sm_filename, j.journal_banner,a.animated_abstract,a.erratum_in,a.erratum_for, (CASE WHEN a.issue_id =0 THEN j.epub_price ELSE j.price END) AS sell_price, j.epub_price, j.nid AS jour_nid, j.title AS journal_title, j.issn, j.eissn,j.journal_id, j.subtitle AS jour_subtitle, v.volume_id,v.volume_name AS volume, v.year_id, i.title AS issue, i.month_id ,i.type issue_type, j.subtitle,j.formerly_title, ac.subtitle AS epub_title,a.crossmark_enabled,a.text_mining_urls,a.license_urls,a.created, a.receivedate, a.revisedate, a.acceptdate,js.js_title FROM article a LEFT JOIN article_section ac ON a.is_epub = ac.art_sec_id LEFT JOIN journal_section js ON a.js_id = js.js_id LEFT JOIN article_type at ON a.art_type = at.art_type_id LEFT JOIN issue i ON a.issue_id = i.issue_id LEFT JOIN month m ON m.id = i.month_id LEFT JOIN volume v ON v.volume_id = a.volume_id INNER JOIN year y ON y.id = v.year_id INNER JOIN journal j ON j.journal_id = a.journal_id INNER JOIN publisher p ON p.publisher_id = j.publisher_id WHERE a.article_id=128259
      730μ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` = 60 limit 1
      800μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 60
      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=60) and sj.journal_id!=60 group by `j`.`nid`) as `aggregate_table`
      910μ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=60) and sj.journal_id!=60 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      760μ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=60) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      4.38msalphaeurekaselec_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=60) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      3.8msalphaeurekaselec_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` = '128259'
      210μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 128259
      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` = '128259'
      1.93msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 128259
      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` = '128259' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.43msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 128259
      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
      250μ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
      450μ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 = 60 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      26.97msalphaeurekaselec_live_10_06_2022Issue.php#298
      Backtrace
      • 11. app/Models/Issue.php:298
      • 12. app/Http/Controllers/ArticleController.php:2068
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 1 and a.journal_id = 60 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      8.61msalphaeurekaselec_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 = 60 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      6.12msalphaeurekaselec_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` = 128259 limit 1
      170μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 128259
      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 = 128259 and content_type = 'article' order by status desc limit 1
      210μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 211950 limit 1
      170μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 211950
      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
      180μ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` = 'CSCRT' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      260μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CSCRT
      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 = '128259' 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) )
      320μ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 = '12390' 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) )
      270μ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 = '3368' 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) )
      360μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2231
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740498131 and j.to_date >= 1740498131 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3368) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740498131 and j.to_date >= 1740498131 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3368) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740498131 and j.to_date >= 1740498131 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3368)
      5.16msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2272
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740498131 and j.to_date >= 1740498131 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12390) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740498131 and j.to_date >= 1740498131 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12390) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740498131 and j.to_date >= 1740498131 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12390)
      660μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2297
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740498131 and j.to_date >= 1740498131 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 128259) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740498131 and j.to_date >= 1740498131 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 128259) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 222023364 and j.to_ip >=222023364 )) and ((j.from_date <= 1740498131 and j.to_date >= 1740498131 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 128259)
      600μ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` < '834' and is_uploaded = 1 and issue_id = 12390 order by cast(first_page as SIGNED) desc limit 1
      540μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 834
      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` > '842' and is_uploaded = 1 and issue_id = 12390 order by cast(first_page as SIGNED) asc limit 1
      520μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 842
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'en'
      200μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      250μ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` = 128259 limit 1
      2.44msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 128259
      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` = 60 and `b`.`banner_from_date` <= 1740498131 and `b`.`banner_to_date` >= 1740498131 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.16msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 60
      • 3: 1740498131
      • 4: 1740498131
      • 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` = 60 and `b`.`banner_from_date` <= 1740498131 and `b`.`banner_to_date` >= 1740498131 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.24msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 60
      • 3: 1740498131
      • 4: 1740498131
      • 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='93020372efc86fefd077f87971303705'
      230μ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
        pOUKKyrzyQpXWUeekgimzflEPwcnKvmUH31WaiRk
        uc_cart_id
        93020372efc86fefd077f87971303705
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/128259" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/128259
        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=eyJpdiI6Ilg5VW5aNm9YcmJ5aE1LdUVBcUJQVEE9PSIsInZhbHVlIjoiSlc0K3J5ZGR5b1Z6UmErUCt1VVB3aXhkSWlWeDlYckFDck1nNmpQQ2lZbz0iLCJtYWMiOiI2NWVlMzA2Mzc0NTZiZTk4YTJkMDUzZTU1NjliOGQ2N2QwNzVmNzE4Nzk2NmNkNjE1NDMyNjc2OWYwZDRmYjExIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6Ilg5VW5aNm9YcmJ5aE1LdUVBcUJQVEE9PSIsInZhbHVlIjoiSlc0K3J5ZGR5b1Z6UmErUCt1VVB3aXhkSWlWeDlYckFDck1nNmpQQ2lZbz0iLCJtYWMiOiI2NWVlMzA2Mzc0NTZi" ] "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 => "Tue, 25 Feb 2025 15:42:11 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InlMQStYbmlUek9iM0RuWldIdlorSFE9PSIsInZhbHVlIjoid0lsdDMrdWVzRUs4TEFhVFNjRmRsTko1UDJGOE1XeSs1aHZidXhQT3BEdENicjJiNStab1lNdEJETWI4dTVUcWlWL0xvb1cvSzRiQnFXTGlkWUZyVXlMQUJwdzgzTmpkTXl5aXdQVituNjYrUlFGaHMwcGJiTU9ORCtVUi9yM2ciLCJtYWMiOiI5ZDA0OWI0MmIyMDNiZjc1OTgzNDhiMDQwMGQ2OTc5NTY1MDFlYjEyYjNkMzg0MDg3ODRiMWViMGVmZGIxNWJhIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 03:42:11 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InlMQStYbmlUek9iM0RuWldIdlorSFE9PSIsInZhbHVlIjoid0lsdDMrdWVzRUs4TEFhVFNjRmRsTko1UDJGOE1XeSs1aHZidXhQT3BEdENicjJiNStab1lNdEJETWI4dTVUcWlWL0xvb" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkR3TzlWcHJDRnlwbWpYOEtBdGdKb1E9PSIsInZhbHVlIjoieGRZQUxSSjVGZXdYQWlIamlzVFJMRzU3WFNNOXczcHh3RnhFWUZGOTVHWDdORjFBT3FRL3lZNHFJM1ZnSHhab2p4ekwrbjd3MnQ0YUJhakxSZTZrWHpYZ0Z3OWlsVDc1Tm5TOW1NUFd6VERhZi9HQ1hTNi9tbnp5RDdZbEk0ZFAiLCJtYWMiOiJlYTc1ZmNmMTI1NGViZGIyZDJiMWJkNWVhYzMxOGE5NmRiZTgyMGM5NWUxOGIyZWY2NzdkMzg3ZWM0ZWJjMDNmIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkR3TzlWcHJDRnlwbWpYOEtBdGdKb1E9PSIsInZhbHVlIjoieGRZQUxSSjVGZXdYQWlIamlzVFJMRzU3WFNNOXczcHh3RnhFWUZGOTVHWDdORjFBT3FRL3lZNHF" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InlMQStYbmlUek9iM0RuWldIdlorSFE9PSIsInZhbHVlIjoid0lsdDMrdWVzRUs4TEFhVFNjRmRsTko1UDJGOE1XeSs1aHZidXhQT3BEdENicjJiNStab1lNdEJETWI4dTVUcWlWL0xvb1cvSzRiQnFXTGlkWUZyVXlMQUJwdzgzTmpkTXl5aXdQVituNjYrUlFGaHMwcGJiTU9ORCtVUi9yM2ciLCJtYWMiOiI5ZDA0OWI0MmIyMDNiZjc1OTgzNDhiMDQwMGQ2OTc5NTY1MDFlYjEyYjNkMzg0MDg3ODRiMWViMGVmZGIxNWJhIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 03:42:11 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InlMQStYbmlUek9iM0RuWldIdlorSFE9PSIsInZhbHVlIjoid0lsdDMrdWVzRUs4TEFhVFNjRmRsTko1UDJGOE1XeSs1aHZidXhQT3BEdENicjJiNStab1lNdEJETWI4dTVUcWlWL0xvb" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkR3TzlWcHJDRnlwbWpYOEtBdGdKb1E9PSIsInZhbHVlIjoieGRZQUxSSjVGZXdYQWlIamlzVFJMRzU3WFNNOXczcHh3RnhFWUZGOTVHWDdORjFBT3FRL3lZNHFJM1ZnSHhab2p4ekwrbjd3MnQ0YUJhakxSZTZrWHpYZ0Z3OWlsVDc1Tm5TOW1NUFd6VERhZi9HQ1hTNi9tbnp5RDdZbEk0ZFAiLCJtYWMiOiJlYTc1ZmNmMTI1NGViZGIyZDJiMWJkNWVhYzMxOGE5NmRiZTgyMGM5NWUxOGIyZWY2NzdkMzg3ZWM0ZWJjMDNmIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkR3TzlWcHJDRnlwbWpYOEtBdGdKb1E9PSIsInZhbHVlIjoieGRZQUxSSjVGZXdYQWlIamlzVFJMRzU3WFNNOXczcHh3RnhFWUZGOTVHWDdORjFBT3FRL3lZNHF" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "pOUKKyrzyQpXWUeekgimzflEPwcnKvmUH31WaiRk" "uc_cart_id" => "93020372efc86fefd077f87971303705" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/128259" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 15:42:11GET/article/128259414361