Generic placeholder image

Current Respiratory Medicine Reviews

Editor-in-Chief

ISSN (Print): 1573-398X
ISSN (Online): 1875-6387

Review Article

Antifibrotic Drugs for COVID-19: From Orphan Drugs to Blockbusters?

Author(s): Leander Corrie*, MD Muzaffar-Ur-Rehman, Latha Kukatil, Devasari Manasa and Adepu Shirisha

Volume 17, Issue 1, 2021

Published on: 04 March, 2021

Page: [8 - 12] Pages: 5

DOI: 10.2174/1573398X17666210304100043

Price: $65

Abstract

Antifibrotic agents are known to treat idiopathic pulmonary fibrosis. The two antifibrotic agents approved and in usage are Pirfenidone and Nintedanib granted by the USFDA in 2014. They are both known to decrease inflammation in the lungs. The fact that COVID-19 has shown to cause inflammation and fibrosis in the lungs frames the theory of their usage in the treatment of the disease by reducing lung scaring and allowing faster discharge of patients with post-COVID complications. The need for them to change their status from orphans to blockbusters has not happened yet due to fewer data and less research available on them as well as various other economic and patient- related factors. Since COVID-19 is widespread and causes many complications of the lungs that are similar to what these two drugs treat. We believe that the status of these drugs could be changed due to an increase in demand for them.

Keywords: Antifibrotic, COVID-19, Pirfenidone, Nintedanib, Orphan drugs, SARS-CoV-2.

Graphical Abstract

[1]
Xu Z, Shi L, Wang Y, et al. Pathological findings of COVID-19 associated with acute respiratory distress syndrome. Lancet Respir Med 2020; 8(4): 420-2.
[http://dx.doi.org/10.1016/S2213-2600(20)30076-X] [PMID: 32085846]
[2]
Guzik TJ, Mohiddin SA, Dimarco A, et al. COVID-19 and the cardiovascular system: Implications for risk assessment, diagnosis, and treatment options. Cardiovasc Res 2020; 116(10): 1666-87.
[http://dx.doi.org/10.1093/cvr/cvaa106] [PMID: 32352535]
[3]
Awasthi A, Vishwas S, Corrie L, et al. OUTBREAK of novel corona virus disease (COVID-19): Antecedence and aftermath. Eur J Pharmacol 2020; 884(April): 173381.
[http://dx.doi.org/10.1016/j.ejphar.2020.173381] [PMID: 32721449]
[4]
Wu R, Wang L, Kuo HCD, Shannar A, Peter R, Chou PJ, et al. An update on current therapeutic drugs treating COVID-19. Curr Pharmacol Rep 2020; 6: 56-70.
[5]
Li G, He X, Zhang L, et al. Assessing ACE2 expression patterns in lung tissues in the pathogenesis of COVID-19. J Autoimmun 2020; 112: 102463.
[http://dx.doi.org/10.1016/j.jaut.2020.102463] [PMID: 32303424]
[6]
Wootton SC, Kim DS, Kondoh Y, et al. Viral infection in acute exacerbation of idiopathic pulmonary fibrosis. Am J Respir Crit Care Med 2011; 183(12): 1698-702.
[http://dx.doi.org/10.1164/rccm.201010-1752OC] [PMID: 21471095]
[7]
Zhou S. CT features of Coronavirus disease 2019 (COVID-19) Pneumonia in 62 patients in Wuhan, China. 2020; 2020: 1-8.
[8]
Peter M. Pulmonary fibrosis and COVID-19: The potential role for antifibrotic therapy. Lancet Respir Med 2020; 8(8): 807-15.
[9]
Zhang J, Xie B, Hashimoto K. Current status of potential therapeutic candidates for the COVID-19 crisis. In: Brain, Behavior, and Immunity. Academic Press Inc. 2020; 87: pp. 59-73.
[10]
Cerri S, Monari M, Guerrieri A, et al. Real-life comparison of Pirfenidone and nintedanib in patients with idiopathic pulmonary fibrosis: A 24-month assessment. Respir Med 2019; 159: 105803.
[http://dx.doi.org/10.1016/j.rmed.2019.105803] [PMID: 31670147]
[11]
di Martino E, Provenzani A, Vitulo P, Polidori P. Systematic review and meta-analysis of Pirfenidone, Nintedanib, and Pamrevlumab for the treatment of Idiopathic pulmonary fibrosis. Annal Pharmacotherapy 2020.
[http://dx.doi.org/10.1177/1060028020964451]
[12]
Macías-Barragán J, Sandoval-Rodríguez A, Navarro-Partida J, Armendáriz-Borunda J. The multifaceted role of Pirfenidone and its novel targets. Fibrogenesis Tissue Repair 2010; 3(1): 16.
[http://dx.doi.org/10.1186/1755-1536-3-16] [PMID: 20809935]
[13]
Ruwanpura SM, Thomas BJ, Bardin PG. Pirfenidone: Molecular mechanisms and potential clinical applications in lung disease. Am J Respir Cell Mol Biol 2020; 62(4): 413-22.
[http://dx.doi.org/10.1165/rcmb.2019-0328TR] [PMID: 31967851]
[14]
Bahudhanapati H, Kass DJ. Unwinding the collagen fibrils: Elucidating the mechanism of Pirfenidone and Nintedanib in pulmonary fibrosis. Am J Respir Cell Mol Biol 2017; 57(1): 10-1.
[http://dx.doi.org/10.1165/rcmb.2017-0079ED] [PMID: 28665219]
[15]
Choi YH, Back KO, Kim HJ, Lee SY, Kook KH. Pirfenidone attenuates IL-1β-induced COX-2 and PGE2 production in orbital fibroblasts through suppression of NF-κB activity. Exp Eye Res 2013; 113: 1-8.
[http://dx.doi.org/10.1016/j.exer.2013.05.001] [PMID: 23664858]
[16]
Hisatomi K, Mukae H, Sakamoto N, et al. Pirfenidone inhibits TGF-β1-induced over-expression of collagen type I and heat shock protein 47 in A549 cells. BMC Pulm Med 2012; 12: 24.
[http://dx.doi.org/10.1186/1471-2466-12-24] [PMID: 22694981]
[17]
Seifirad S. Pirfenidone: A novel hypothetical treatment for COVID-19. Med Hypotheses 2020; 144: 110005.
[http://dx.doi.org/10.1016/j.mehy.2020.110005] [PMID: 32575019]
[18]
Kim HY, Kim MS, Kim SH, Joen D, Lee K. Protective effects of nintedanib against polyhexamethylene guanidine phosphate-induced lung fibrosis in mice. Molecules 2018; 23(8): E1974.
[http://dx.doi.org/10.3390/molecules23081974] [PMID: 30087305]
[19]
Adderley N, Humphreys CJ, Barnes H, Ley B, Premji ZA, Johannson KA. Bronchoalveolar lavage fluid lymphocytosis in chronic hypersensitivity pneumonitis: A systematic review and meta-analysis. Eur Respir J 2020; 56(2): 2000206.
[http://dx.doi.org/10.1183/13993003.00206-2020] [PMID: 32265306]
[20]
Wollin L, Maillet I, Quesniaux V, Holweg A, Ryffel B. Antifibrotic and anti-inflammatory activity of the tyrosine kinase inhibitor nintedanib in experimental models of lung fibrosis. J Pharmacol Exp Ther 2014; 349(2): 209-20.
[http://dx.doi.org/10.1124/jpet.113.208223] [PMID: 24556663]
[21]
Knüppel L, Ishikawa Y, Aichler M, et al. A novel antifibrotic mechanism of nintedanib and pirfenidone. Am J Respir Cell Mol Biol 2017; 57(1): 77-90.
[http://dx.doi.org/10.1165/rcmb.2016-0217OC] [PMID: 28257580]
[22]
King TE Jr, Bradford WZ, Castro-Bernardini S, et al. A phase 3 trial of Pirfenidone in patients with idiopathic pulmonary fibrosis. N Engl J Med 2014; 370(22): 2083-92.
[http://dx.doi.org/10.1056/NEJMoa1402582] [PMID: 24836312]
[23]
Richeldi L, du Bois RM, Raghu G, et al. Efficacy and safety of nintedanib in idiopathic pulmonary fibrosis. N Engl J Med 2014; 370(22): 2071-82.
[http://dx.doi.org/10.1056/NEJMoa1402584] [PMID: 24836310]
[24]
Noble PW, Albera C, Bradford WZ, et al. Pirfenidone for idiopathic pulmonary fibrosis: Analysis of pooled data from three multinational phase 3 trials. Eur Respir J 2016; 47(1): 243-53. [Internet]
[http://dx.doi.org/10.1183/13993003.00026-2015] [PMID: 26647432]
[25]
Dhooria S, Agarwal R, Dhar R, Jindal A, Madan K, Aggarwal AN. Consensus statement for the diagnosis and treatment of idiopathic pulmonary fibrosis in resource constrained settings consensus statement for the diagnosis and treatment of idiopathic pulmonary fibrosis in resource constrained settings. 2018.
[26]
Bargagli E, Piccioli C, Rosi E, et al. Pirfenidone and Nintedanib in idiopathic pulmonary fibrosis: Real-life experience in an Italian referral centre. Pulmonology 2019; 25(3): 149-53.
[http://dx.doi.org/10.1016/j.pulmoe.2018.06.003] [PMID: 30236523]
[27]
Moodley YP, Scaffidi AK, Misso NL, et al. Fibroblasts isolated from normal lungs and those with idiopathic pulmonary fibrosis differ in interleukin-6/gp130-mediated cell signaling and proliferation. Am J Pathol 2003; 163(1): 345-54.
[http://dx.doi.org/10.1016/S0002-9440(10)63658-9] [PMID: 12819039]
[28]
Hadda V, Guleria R. Antifibrotic drugs for idiopathic pulmonary fibrosis: What we should know? Indian J Med Res 2020; 152(3): 177-80.
[http://dx.doi.org/10.4103/ijmr.IJMR_90_20] [PMID: 33107479]
[29]
Li Y, Li H, Liu S, et al. Pirfenidone ameliorates lipopolysaccharide-induced pulmonary inflammation and fibrosis by blocking NLRP3 inflammasome activation. Mol Immunol 2018; 99(87): 134-44.
[http://dx.doi.org/10.1016/j.molimm.2018.05.003] [PMID: 29783158]
[30]
Sathiyamoorthy G, Sehgal S, Ashton RW. Pirfenidone and Nintedanib for treatment of idiopathic pulmonary fibrosis. South Med J 2017; 110(6): 393-8.
[http://dx.doi.org/10.14423/SMJ.0000000000000655] [PMID: 28575896]
[31]
Trawinska MA, Rupesinghe RD, Hart SP. Patient considerations and drug selection in the treatment of idiopathic pulmonary fibrosis. Ther Clin Risk Manag 2016; 12: 563-74.
[PMID: 27114711]
[32]
Borthwick LA. The IL-1 cytokine family and its role in inflammation and fibrosis in the lung. Semin Immunopathol 2016; 38(4): 517-34.
[http://dx.doi.org/10.1007/s00281-016-0559-z] [PMID: 27001429]
[33]
Gad ES, Salama AAA, El-Shafie MF, Arafa HMM, Abdelsalam RM, Khattab M. The anti-fibrotic and anti-inflammatory potential of bone marrow-derived mesenchymal stem cells and nintedanib in bleomycin-induced lung fibrosis in rats. Inflammation 2020; 43(1): 123-34.
[http://dx.doi.org/10.1007/s10753-019-01101-2] [PMID: 31646446]
[34]
Chen WC, Chen NJ, Chen HP, et al. Nintedanib reduces neutrophil chemotaxis via activating GRK2 in bleomycin-induced pulmonary fibrosis. Int J Mol Sci 2020; 21(13): 1-16.
[http://dx.doi.org/10.3390/ijms21134735] [PMID: 32630825]
[35]
Li T, Guo L, Chen Z, et al. Pirfenidone in patients with rapidly progressive interstitial lung disease associated with clinically amyopathic dermatomyositis. Sci Rep 2016; 6(September): 33226.
[http://dx.doi.org/10.1038/srep33226] [PMID: 27615411]
[36]
Yanagihara T, Suzuki K, Egashira A, et al. Nintedanib and intensive immunosuppressive therapy to treat rapidly progressive interstitial lung disease presenting anti-ARS antibodies. Respir Med Case Rep 2020; 31: 101272.
[http://dx.doi.org/10.1016/j.rmcr.2020.101272] [PMID: 33163354]
[37]
Furuya K, Sakamoto S, Shimizu H, et al. Pirfenidone for acute exacerbation of idiopathic pulmonary fibrosis: A retrospective study. Respir Med 2017; 126: 93-9.
[http://dx.doi.org/10.1016/j.rmed.2017.03.026] [PMID: 28427556]
[38]
Maher TM, Stowasser S, Nishioka Y, et al. Biomarkers of extracellular matrix turnover in patients with idiopathic pulmonary fibrosis given nintedanib (INMARK study): A randomised, placebo- controlled study. Lancet Respir Med 2019; 7(9): 771-9.
[http://dx.doi.org/10.1016/S2213-2600(19)30255-3] [PMID: 31326319]
[39]
Stahnke T, Kowtharapu BS, Stachs O, et al. Suppression of TGF-β pathway by Pirfenidone decreases extracellular matrix deposition in ocular fibroblasts in vitro. PLoS One 2017; 12(2): e0172592.
[http://dx.doi.org/10.1371/journal.pone.0172592] [PMID: 28231275]
[40]
Lin X, Wen J, Liu R, Gao W, Qu B, Yu M. Nintedanib inhibits TGF-β-induced myofibroblast transdifferentiation in human Tenon’s fibroblasts. Mol Vis 2018; 24: 789-800.
[PMID: 30636861]
[41]
Kurimoto R, Ebata T, Iwasawa S, et al. Pirfenidone may revert the epithelial-to-mesenchymal transition in human lung adenocarcinoma. Oncol Lett 2017; 14(1): 944-50.
[http://dx.doi.org/10.3892/ol.2017.6188] [PMID: 28693256]
[42]
Ihara H, Mitsuishi Y, Kato M, et al. Nintedanib inhibits epithelial-mesenchymal transition in A549 alveolar epithelial cells through regulation of the TGF-β/Smad pathway. Respir Investig 2020; 58(4): 275-84.
[http://dx.doi.org/10.1016/j.resinv.2020.01.003] [PMID: 32359980]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version322msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[06:30:59] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[06:30:59] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[06:30:59] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[06:30:59] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (126ms)time
  • Application (197ms)time
  • 1 x Application (61.01%)
    197ms
    1 x Booting (38.98%)
    126ms
    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 duplicated117ms
    • 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 ('51594075','',1,1740551459,1740551459) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740551459
      1msalphaeurekaselec_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 ('51594075','/article/114728',1,1740551459,1740551459)
      130μ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 >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) 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 >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) 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 >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) 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 >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) 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 >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) 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 >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51594075 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51594075) limit 1
      22.5msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51594075
      • 1: 51594075
      • 2: 51594075
      • 3: 51594075
      • 4: 51594075
      • 5: 51594075
      • 6: 51594075
      • 7: 51594075
      • 8: 51594075
      • 9: 51594075
      • 10: 51594075
      • 11: 51594075
      • 12: 51594075
      • 13: 51594075
      • 14: 51594075
      • 15: 51594075
      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=114728
      930μ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` = 47 limit 1
      1.02msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 47
      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=47) and sj.journal_id!=47 group by `j`.`nid`) as `aggregate_table`
      1.08msalphaeurekaselec_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=47) and sj.journal_id!=47 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      940μ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=47) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      5.2msalphaeurekaselec_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=47) 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.85msalphaeurekaselec_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` = '114728'
      1.74msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 114728
      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` = '114728'
      1.88msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 114728
      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` = '114728' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.59msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 114728
      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
      260μ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
      590μ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 = 47 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      36.91msalphaeurekaselec_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 = 47 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.62msalphaeurekaselec_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 = 47 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      4.41msalphaeurekaselec_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` = 114728 limit 1
      210μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 114728
      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 = 114728 and content_type = 'article' order by status desc limit 1
      300μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 622 and cd.sub_disease_id = 623 and content_id!=114728 and cd.content_type = 'article' order by rand() limit 20
      6.39msalphaeurekaselec_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` = 192045 limit 1
      260μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 192045
      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
      250μ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` = 'CRMR' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      320μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CRMR
      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 = '114728' 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) )
      390μ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 = '10646' 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) )
      340μ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 = '2989' 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) )
      330μ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 <= 51594075 and j.to_ip >=51594075 )) and ((j.from_date <= 1740551459 and j.to_date >= 1740551459 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2989) 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 <= 51594075 and j.to_ip >=51594075 )) and ((j.from_date <= 1740551459 and j.to_date >= 1740551459 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2989) 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 <= 51594075 and j.to_ip >=51594075 )) and ((j.from_date <= 1740551459 and j.to_date >= 1740551459 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2989)
      11.37msalphaeurekaselec_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 <= 51594075 and j.to_ip >=51594075 )) and ((j.from_date <= 1740551459 and j.to_date >= 1740551459 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10646) 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 <= 51594075 and j.to_ip >=51594075 )) and ((j.from_date <= 1740551459 and j.to_date >= 1740551459 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10646) 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 <= 51594075 and j.to_ip >=51594075 )) and ((j.from_date <= 1740551459 and j.to_date >= 1740551459 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10646)
      650μ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 <= 51594075 and j.to_ip >=51594075 )) and ((j.from_date <= 1740551459 and j.to_date >= 1740551459 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 114728) 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 <= 51594075 and j.to_ip >=51594075 )) and ((j.from_date <= 1740551459 and j.to_date >= 1740551459 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 114728) 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 <= 51594075 and j.to_ip >=51594075 )) and ((j.from_date <= 1740551459 and j.to_date >= 1740551459 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 114728)
      560μ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` < '8' and is_uploaded = 1 and issue_id = 10646 order by cast(first_page as SIGNED) desc limit 1
      460μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 8
      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` > '12' and is_uploaded = 1 and issue_id = 10646 order by cast(first_page as SIGNED) asc limit 1
      410μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 12
      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'
      170μ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
      170μ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` = 114728 limit 1
      2.38msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 114728
      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` = 47 and `b`.`banner_from_date` <= 1740551459 and `b`.`banner_to_date` >= 1740551459 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: 47
      • 3: 1740551459
      • 4: 1740551459
      • 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` = 47 and `b`.`banner_from_date` <= 1740551459 and `b`.`banner_to_date` >= 1740551459 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.12msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 47
      • 3: 1740551459
      • 4: 1740551459
      • 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='4b5228d9e5f2a0f0ba145e1da145969b'
      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
        QAlHTQ19rgu6fYeccBSiaLs0HXc8hxwPXGaL8Vfe
        uc_cart_id
        4b5228d9e5f2a0f0ba145e1da145969b
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/114728" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/114728
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 26 Feb 2025 06:30:59 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ilh6b3FGUjFXbVdNL01OQU9BYkJzWUE9PSIsInZhbHVlIjoib1lReHlQNXJCYXlWOTgvRm1rMnp6clFWSi9McFhyNzlteGhWR1dHOVlOT2xXaVd0NTl0YkRXdWkzWWxWK2RMV05aMDVrakJkQmhYVjk4b3JKbmtyY2NLdXkrQW9IR3NnYXgrektid0VQTnkzMXBoNVJtK3g5VjVmUC9odkViVWwiLCJtYWMiOiJkMGY4YTFmZTk5ZGI4NDgwNGI0MTIxZTY2OWQzM2ZmNzE5YmVkNzk2NzhmMDU0NWZhMTYwMGQxZmE1NzA1MTkzIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 18:30:59 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ilh6b3FGUjFXbVdNL01OQU9BYkJzWUE9PSIsInZhbHVlIjoib1lReHlQNXJCYXlWOTgvRm1rMnp6clFWSi9McFhyNzlteGhWR1dHOVlOT2xXaVd0NTl0YkRXdWkzWWxWK2RMV05aMDVra" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkFDajV0dm1YZkhDOEpMbDZkM2piZXc9PSIsInZhbHVlIjoieGFoZU9YOXBlL09MdHBlSklxTSt3N2RkbFgzSUlLTU5TMFc1VXFuankxci81WXdkNHRkcDM4dHp6cWM2RFZEbmVGMndtOWZVNzB1NlRPdXBIczNRMmpub3RuekhWSE8zNThobDVxb1YxdWFlQVl4cGFBUFczWnFFdVQ0Ylp6Q3YiLCJtYWMiOiI2MWIxY2M5MGFjYWNjMDkzNDcyOTFiNjBhZjE4Zjk2OTVhMGUxMjQ0YTYyZjMwM2Y2ZWY1ZDViYTc4NjYwODE4IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkFDajV0dm1YZkhDOEpMbDZkM2piZXc9PSIsInZhbHVlIjoieGFoZU9YOXBlL09MdHBlSklxTSt3N2RkbFgzSUlLTU5TMFc1VXFuankxci81WXdkNHRkcDM4dHp" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ilh6b3FGUjFXbVdNL01OQU9BYkJzWUE9PSIsInZhbHVlIjoib1lReHlQNXJCYXlWOTgvRm1rMnp6clFWSi9McFhyNzlteGhWR1dHOVlOT2xXaVd0NTl0YkRXdWkzWWxWK2RMV05aMDVrakJkQmhYVjk4b3JKbmtyY2NLdXkrQW9IR3NnYXgrektid0VQTnkzMXBoNVJtK3g5VjVmUC9odkViVWwiLCJtYWMiOiJkMGY4YTFmZTk5ZGI4NDgwNGI0MTIxZTY2OWQzM2ZmNzE5YmVkNzk2NzhmMDU0NWZhMTYwMGQxZmE1NzA1MTkzIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 18:30:59 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ilh6b3FGUjFXbVdNL01OQU9BYkJzWUE9PSIsInZhbHVlIjoib1lReHlQNXJCYXlWOTgvRm1rMnp6clFWSi9McFhyNzlteGhWR1dHOVlOT2xXaVd0NTl0YkRXdWkzWWxWK2RMV05aMDVra" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkFDajV0dm1YZkhDOEpMbDZkM2piZXc9PSIsInZhbHVlIjoieGFoZU9YOXBlL09MdHBlSklxTSt3N2RkbFgzSUlLTU5TMFc1VXFuankxci81WXdkNHRkcDM4dHp6cWM2RFZEbmVGMndtOWZVNzB1NlRPdXBIczNRMmpub3RuekhWSE8zNThobDVxb1YxdWFlQVl4cGFBUFczWnFFdVQ0Ylp6Q3YiLCJtYWMiOiI2MWIxY2M5MGFjYWNjMDkzNDcyOTFiNjBhZjE4Zjk2OTVhMGUxMjQ0YTYyZjMwM2Y2ZWY1ZDViYTc4NjYwODE4IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkFDajV0dm1YZkhDOEpMbDZkM2piZXc9PSIsInZhbHVlIjoieGFoZU9YOXBlL09MdHBlSklxTSt3N2RkbFgzSUlLTU5TMFc1VXFuankxci81WXdkNHRkcDM4dHp" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "QAlHTQ19rgu6fYeccBSiaLs0HXc8hxwPXGaL8Vfe" "uc_cart_id" => "4b5228d9e5f2a0f0ba145e1da145969b" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/114728" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-26 06:30:59GET/article/114728414371