Generic placeholder image

Recent Advances in Anti-Infective Drug Discovery

Editor-in-Chief

ISSN (Print): 2772-4344
ISSN (Online): 2772-4352

Research Article

Cholecalciferol Exhibits no Antibacterial Effect on Staphylococcus aureus and Escherichia coli: An in vitro Study

Author(s): Shilia Jacob Kurian, Avirup Biswas, Shrivathsa Kulavalli, Jesil Mathew Aranjani, Amrita Pattanaik, Murali Munisamy, Kavitha Saravu, Gabriel Sunil Rodrigues and Sonal Sekhar Miraj*

Volume 19, Issue 4, 2024

Published on: 24 January, 2024

Page: [315 - 321] Pages: 7

DOI: 10.2174/0127724344277290231211051800

Price: $65

Abstract

Background: The pleiotropic effect of cholecalciferol (vitamin D3) has gained significant momentum and has been explored widely.

Objectives: The study aimed to investigate the antimicrobial effect of cholecalciferol against S. aureus and E. coli.

Methods: An in vitro study was performed for the antimicrobial effect of cholecalciferol against S. aureus and E. coli. The minimum inhibitory concentration (MIC) and minimum bactericidal concentration (MBC) were determined following the broth microdilution method.

Results: The MIC value of cholecalciferol against both S. aureus and E. coli was 0.312 mg/ml, and the MBC for both organisms was 1.25 mg/ml. However, we also observed a significant antimicrobial effect in the dimethyl sulfoxide (DMSO) control at 12.5% (v/v). Therefore, the observed antimicrobial effect may be attributed to DMSO, indicating cholecalciferol does not directly inhibit S. aureus and E. coli.

Conclusion: This study indicates that cholecalciferol does not directly inhibit S. aureus and E. coli. Hence, we suggest exploring the antibacterial properties of other vitamin D analogs, such as calcitriol or its synergetic effect with other antimicrobial agents.

Graphical Abstract

[1]
Brown AF, Leech JM, Rogers TR, McLoughlin RM. Staphylococcus aureus colonization: Modulation of host immune response and impact on human vaccine design. Front Immunol 2014; 4: 507.
[http://dx.doi.org/10.3389/fimmu.2013.00507] [PMID: 24409186]
[2]
Loftus MJ, Young-Sharma TE, Wati S, et al. Epidemiology, antimicrobial resistance and outcomes of Staphylococcus aureus bacteraemia in a tertiary hospital in Fiji: A prospective cohort study. Lancet Reg Health West Pac 2022; 22: 100438.
[http://dx.doi.org/10.1016/j.lanwpc.2022.100438] [PMID: 35373162]
[3]
Bonten M, Johnson JR, van den Biggelaar AHJ, et al. Epidemiology of Escherichia coli bacteremia: A systematic literature review. Clin Infect Dis 2021; 72(7): 1211-9.
[http://dx.doi.org/10.1093/cid/ciaa210] [PMID: 32406495]
[4]
Nair R, Maseeh A, Vitamin D. The “sunshine” vitamin. J Pharmacol Pharmacother 2012; 3(2): 118-26.
[PMID: 22629085]
[5]
Golpour A, Bereswill S, Heimesaat MM. Antimicrobial and immune-modulatory effects of vitamin D provide promising antibiotics-independent approaches to tackle bacterial infections – lessons learnt from a literature survey. Eur J Microbiol Immunol (Bp) 2019; 9(3): 80-7.
[http://dx.doi.org/10.1556/1886.2019.00014] [PMID: 31662886]
[6]
Murray CJL, Ikuta KS, Sharara F, et al. Global burden of bacterial antimicrobial resistance in 2019: A systematic analysis. Lancet 2022; 399(10325): 629-55.
[http://dx.doi.org/10.1016/S0140-6736(21)02724-0] [PMID: 35065702]
[7]
Chung C, Silwal P, Kim I, Modlin RL, Jo EK. Vitamin D-cathelicidin axis: At the crossroads between protective immunity and pathological inflammation during infection. Immune Netw 2020; 20(2): e12.
[http://dx.doi.org/10.4110/in.2020.20.e12] [PMID: 32395364]
[8]
Tintino SR, Morais-Tintino CD, Campina FF, et al. Action of cholecalciferol and alpha-tocopherol on Staphylococcus aureus efflux pumps. EXCLI J 2016; 15: 315-22.
[http://dx.doi.org/10.17179/excli2016-277] [PMID: 27298617]
[9]
Global priority list of antibiotic-resistant bacteria to guide research, discovery, and development of new antibiotics. Who 2017; 2017: 1-7.
[10]
Performance standards for antimicrobial susceptibility testing In: CLSI supplement M100 30th ed. Wayne, PA: Clinical and Laboratory Standards Institute 2020.
[11]
Abd Algaffar SO, Verbon A, van de Sande WWJ, Khalid SA. Development and validation of an in vitro resazurin-based susceptibility assay against madurella mycetomatis. Antimicrob Agents Chemother 2021; 65(3): e01338-20.
[http://dx.doi.org/10.1128/AAC.01338-20] [PMID: 33318015]
[12]
O’Brien J, Wilson I, Orton T, Pognan F. Investigation of the Alamar Blue (resazurin) fluorescent dye for the assessment of mammalian cell cytotoxicity. Eur J Biochem 2000; 267(17): 5421-6.
[http://dx.doi.org/10.1046/j.1432-1327.2000.01606.x] [PMID: 10951200]
[13]
Khelkal IN. Comparison the antibacterial activity of vitamin D2 and D3. Al-Mustansiriyah J Sci 2017; 27(4)
[http://dx.doi.org/10.23851/mjs.v27i4.16]
[14]
Almoudi MMM, Hussein AS, Abu Hassan MI, et al. The antibacterial effects of vitamin D3 against mutans streptococci: An in vitro study. Eur Oral Res 2021; 55(1): 8-15.
[http://dx.doi.org/10.26650/eor.20210119] [PMID: 33937756]
[15]
Poddighe D, Vangelista L. Staphylococcus aureus infection and persistence in chronic rhinosinusitis: Focus on leukocidin ED. Toxins 2020; 12(11): 678.
[http://dx.doi.org/10.3390/toxins12110678] [PMID: 33126405]
[16]
Liao S, Huang Y, Zhang J, et al. Vitamin D promotes epithelial tissue repair and host defense responses against influenza H1N1 virus and Staphylococcus aureus infections. Respir Res 2023; 24(1): 175.
[http://dx.doi.org/10.1186/s12931-023-02477-4] [PMID: 37407993]
[17]
Kalińczak-Górna P, Radajewski K, Burduk P. Relationship between the severity of inflammatory changes in chronic sinusitis and the level of vitamin d before and after the FESS procedure. J Clin Med 2021; 10(13): 2836.
[http://dx.doi.org/10.3390/jcm10132836] [PMID: 34198970]
[18]
Mohanty S, Kamolvit W, Hertting O, Brauner A. Vitamin D strengthens the bladder epithelial barrier by inducing tight junction proteins during E. coli urinary tract infection. Cell Tissue Res 2020; 380(3): 669-73.
[http://dx.doi.org/10.1007/s00441-019-03162-z] [PMID: 31930458]
[19]
Hertting O, Holm Å, Lüthje P, et al. Vitamin D induction of the human antimicrobial peptide cathelicidin in the urinary bladder. PLoS One 2010; 5(12): e15580.
[http://dx.doi.org/10.1371/journal.pone.0015580] [PMID: 21179490]
[20]
Assa A, Vong L, Pinnell LJ, et al. Vitamin D deficiency predisposes to adherent-invasive Escherichia coli-induced barrier dysfunction and experimental colonic injury. Inflamm Bowel Dis 2015; 21(2): 297-306.
[http://dx.doi.org/10.1097/MIB.0000000000000282] [PMID: 25590952]
[21]
Lowry MB, Guo C, Zhang Y, et al. A mouse model for vitamin D-induced human cathelicidin antimicrobial peptide gene expression. J Steroid Biochem Mol Biol 2020; 198: 105552.
[http://dx.doi.org/10.1016/j.jsbmb.2019.105552] [PMID: 31783153]
[22]
Patria FF, Ceccarini MR, Codini M, et al. A role for neutral sphingomyelinase in wound healing induced by keratinocyte proliferation upon 1α 25-Dihydroxyvitamin D3 treatment. Int J Mol Sci 2019; 20(15): 3634.
[http://dx.doi.org/10.3390/ijms20153634] [PMID: 31349547]
[23]
Wang D, Lin L, Lei K, et al. Vitamin D3 analogue facilitates epithelial wound healing through promoting epithelial-mesenchymal transition via the Hippo pathway. J Dermatol Sci 2020; 100(2): 120-8.
[http://dx.doi.org/10.1016/j.jdermsci.2020.08.015] [PMID: 32938565]
[24]
Su Y, Ganguli-Indra G, Bhattacharya N, et al. Codelivery of 1α25-Dihydroxyvitamin D3 and CYP24A1 inhibitor VID400 by nanofiber dressings promotes endogenous antimicrobial peptide LL-37 induction. Mol Pharm 2022; 19(3): 974-84.
[http://dx.doi.org/10.1021/acs.molpharmaceut.1c00944] [PMID: 35179903]
[25]
Schauber J, Dorschner RA, Coda AB, et al. Injury enhances TLR2 function and antimicrobial peptide expression through a vitamin D–dependent mechanism. J Clin Invest 2007; 117(3): 803-11.
[http://dx.doi.org/10.1172/JCI30142] [PMID: 17290304]
[26]
Tian XQ, Chen TC, Holick MF. 1,25‐Dihydroxyvitamin D3: A novel agent for enhancing wound healing. J Cell Biochem 1995; 59(1): 53-6.
[http://dx.doi.org/10.1002/jcb.240590107] [PMID: 8530536]
[27]
Shekhar C. An innovative technique in local antibiotic delivery method in open infected wounds of the musculoskeletal system. Int J Low Extrem Wounds 2019; 18(2): 153-60.
[http://dx.doi.org/10.1177/1534734619841764] [PMID: 31066316]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version291msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[23:31:49] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[23:31:50] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[23:31:50] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[23:31:50] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (107ms)time
  • Application (185ms)time
  • 1 x Application (63.37%)
    185ms
    1 x Booting (36.62%)
    107ms
    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 duplicated97.91ms
    • 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 ('221975217','',1,1739835109,1739835109) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739835109
      1.3msalphaeurekaselec_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 ('221975217','/article/137823',1,1739835109,1739835109)
      230μ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 >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) 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 >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) 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 >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) 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 >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) 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 >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) 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 >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 221975217 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221975217) limit 1
      23.71msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 221975217
      • 1: 221975217
      • 2: 221975217
      • 3: 221975217
      • 4: 221975217
      • 5: 221975217
      • 6: 221975217
      • 7: 221975217
      • 8: 221975217
      • 9: 221975217
      • 10: 221975217
      • 11: 221975217
      • 12: 221975217
      • 13: 221975217
      • 14: 221975217
      • 15: 221975217
      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=137823
      890μ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` = 207 limit 1
      480μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 207
      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=207) and sj.journal_id!=207 group by `j`.`nid`) as `aggregate_table`
      1.91msalphaeurekaselec_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=207) and sj.journal_id!=207 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.59msalphaeurekaselec_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=207) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      9.82msalphaeurekaselec_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=207) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      8.5msalphaeurekaselec_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` = '137823'
      290μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 137823
      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` = '137823'
      730μsalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 137823
      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` = '137823' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.24msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 137823
      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
      290μ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
      640μ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 = 207 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      32.59msalphaeurekaselec_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 = 207 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      1.34msalphaeurekaselec_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 = 207 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      1msalphaeurekaselec_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` = 137823 limit 1
      180μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 137823
      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 = 137823 and content_type = 'article' order by status desc limit 1
      270μ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` = 226127 limit 1
      210μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 226127
      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
      230μ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` = 'RAAIDD' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      270μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: RAAIDD
      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 = '137823' 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) )
      360μ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 = '13141' 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) )
      320μ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 = '3462' 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) )
      270μ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 <= 221975217 and j.to_ip >=221975217 )) and ((j.from_date <= 1739835110 and j.to_date >= 1739835110 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3462) 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 <= 221975217 and j.to_ip >=221975217 )) and ((j.from_date <= 1739835110 and j.to_date >= 1739835110 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3462) 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 <= 221975217 and j.to_ip >=221975217 )) and ((j.from_date <= 1739835110 and j.to_date >= 1739835110 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3462)
      2.29msalphaeurekaselec_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 <= 221975217 and j.to_ip >=221975217 )) and ((j.from_date <= 1739835110 and j.to_date >= 1739835110 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13141) 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 <= 221975217 and j.to_ip >=221975217 )) and ((j.from_date <= 1739835110 and j.to_date >= 1739835110 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13141) 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 <= 221975217 and j.to_ip >=221975217 )) and ((j.from_date <= 1739835110 and j.to_date >= 1739835110 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13141)
      530μ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 <= 221975217 and j.to_ip >=221975217 )) and ((j.from_date <= 1739835110 and j.to_date >= 1739835110 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 137823) 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 <= 221975217 and j.to_ip >=221975217 )) and ((j.from_date <= 1739835110 and j.to_date >= 1739835110 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 137823) 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 <= 221975217 and j.to_ip >=221975217 )) and ((j.from_date <= 1739835110 and j.to_date >= 1739835110 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 137823)
      550μ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` < '315' and is_uploaded = 1 and issue_id = 13141 order by cast(first_page as SIGNED) desc limit 1
      440μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 315
      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` > '321' and is_uploaded = 1 and issue_id = 13141 order by cast(first_page as SIGNED) asc limit 1
      410μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 321
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'en'
      150μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      190μ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` = 137823 limit 1
      2.39msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 137823
      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` = 207 and `b`.`banner_from_date` <= 1739835110 and `b`.`banner_to_date` >= 1739835110 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.07msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 207
      • 3: 1739835110
      • 4: 1739835110
      • 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` = 207 and `b`.`banner_from_date` <= 1739835110 and `b`.`banner_to_date` >= 1739835110 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.03msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 207
      • 3: 1739835110
      • 4: 1739835110
      • 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='bd69562e8fcb00a480b1ca5a9d8d86b9'
      200μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        YQW1Vh59f4UHr0Rjfo3F8oUCan65bIHex207LlhM
        uc_cart_id
        bd69562e8fcb00a480b1ca5a9d8d86b9
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/chapter/16675" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/137823
        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:17 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6IitOT0h0VXdDS2VSY25qT0FPOE9oM0E9PSIsInZhbHVlIjoiUnFHbHUwYWhWSEY5WWN0dnM0L0RFZEhCTnpaWmlNdmdQSG50eUVaVzlSRT0iLCJtYWMiOiI4YjliNzZhNTBkYzdlN2Y2OTA5ZmUyNWIzNzFkOWE4ZWIyMTJiYjhiZDRmYWEwYzg0YjJhZWMxOTdkZmQ0NmEzIiwidGFnIjoiIn0%3D; XSRF-TOKEN=eyJpdiI6IkF1bWtnMG9qYjJJTUxJMDFPK3lQenc9PSIsInZhbHVlIjoiTVFGR000SUlSS1ZSUWxiWCthR0QvN0lRNFdNdFlkbU5NMmp6Tk9OR3dKbW16QlFnVFQwTzBsSkVXbi9Nek1NY0JpTll3OWpJMkFKQUk3cUw1RUZNMlovSC9BQlpMdnB4UW9CQXozelhCdGVHR0pJOGR1TGZNSlpOZzQ3dllVNEMiLCJtYWMiOiIxMzkzOGM4NmMxZGU2ZDU5MDQyMDhlNmU2YjRhYzcxZGU5Y2ZjZjJhNTRhNmEzNjNkMzcyMjgxMzViMDQ2ZDI5IiwidGFnIjoiIn0%3D; alphaeurekaselectnet_session=eyJpdiI6Ilc4cWtOaEJoM1libmtoR21YYnN0aHc9PSIsInZhbHVlIjoiRm9ua01yc1Z1Y3YzMmVnMXJzUDBYNzZ6TXZMWk1rVnAveXJnbTdaYTlTREwwd1VZUm00M201MjMrK08yUis5b2NySndHYzhYeUVWOVFtTER0d28vZ1hQYm4wb1FKUUhKeWZ5L1lobjNKclFLMmR3MzNVSDZYMnpyTjNsaXI5dDYiLCJtYWMiOiIxNDA4YmFmZjA0MzU5OGY5NTFkMDIxMjI4NjZmZDQxYzFjNmRiODc0OTQ4M2Q4NDM3MzllYTA0ODNhMjYyMThhIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IitOT0h0VXdDS2VSY25qT0FPOE9oM0E9PSIsInZhbHVlIjoiUnFHbHUwYWhWSEY5WWN0dnM0L0RFZEhCTnpaWmlNdmdQSG50eUVaVzlSRT0iLCJtYWMiOiI4YjliNzZhNTBkYzdl" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "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" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_cookies
        0 of 0
        array:3 [ "wayfindertarget" => null "XSRF-TOKEN" => "YQW1Vh59f4UHr0Rjfo3F8oUCan65bIHex207LlhM" "alphaeurekaselectnet_session" => "MLprPzXJso9uvKZRvAjjmDdXeNuc5PHTwEJo40s5" ]
        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 => "Mon, 17 Feb 2025 23:31:50 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImFOb3UzTjFPMjdDZGVCbUVMOG5Db0E9PSIsInZhbHVlIjoiWU1DM1k1RzF3UTNhTXhaNmxzYlVlL1RDUTBmdEw5NTU0cExaZlI5YUVCYmtBcHp4QUJuZXZPOGVqclhhL0J6bHUzekd0T2xTcS9PR1RsKzNSVHNxbTJNRXRsbE95YVdGRm41eWVrUjFVV21sUE82c3JHUU9ydGlpRk5UWlNXL0EiLCJtYWMiOiI3MzNiMWM1YmVmYmVhN2JkMmIxYWFiNTEwM2FkMGEyMmY4YWVkYzMxODNkY2M4MzE2MDhmMTI2MzEyNTQzZjRlIiwidGFnIjoiIn0%3D; expires=Thu, 20 Feb 2025 11:31:50 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImFOb3UzTjFPMjdDZGVCbUVMOG5Db0E9PSIsInZhbHVlIjoiWU1DM1k1RzF3UTNhTXhaNmxzYlVlL1RDUTBmdEw5NTU0cExaZlI5YUVCYmtBcHp4QUJuZXZPOGVqclhhL0J6bHUzekd0T" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ilk0VWNCUGQyUVZuZUVBaHozdjRBU2c9PSIsInZhbHVlIjoiT2tEd0lwYUljaXdNSHVwNFdqN1lESzFwcWdXOUxOMzdEWWEzL1lhaTNQSjltWlYvNjBRWVJUY2FONDNucTVhV2pXT3pZYmlOOVRHNVpsMXBoZDNHdEJ4T2dpV3c5UmlRV25zdTNyb3JIeEU5MG9XbjFSTTlIOG5OYWFtYUhZcmYiLCJtYWMiOiI2Yjg1ZTkxNjI3Mjc0YjhmNDMzYTBhMzFkZjM5NTE0YTZmNzgyNzg1ZDg0MjE4NjlmMWYyMmVmMDBmYjJlNTMyIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ilk0VWNCUGQyUVZuZUVBaHozdjRBU2c9PSIsInZhbHVlIjoiT2tEd0lwYUljaXdNSHVwNFdqN1lESzFwcWdXOUxOMzdEWWEzL1lhaTNQSjltWlYvNjBRWVJUY2F" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImFOb3UzTjFPMjdDZGVCbUVMOG5Db0E9PSIsInZhbHVlIjoiWU1DM1k1RzF3UTNhTXhaNmxzYlVlL1RDUTBmdEw5NTU0cExaZlI5YUVCYmtBcHp4QUJuZXZPOGVqclhhL0J6bHUzekd0T2xTcS9PR1RsKzNSVHNxbTJNRXRsbE95YVdGRm41eWVrUjFVV21sUE82c3JHUU9ydGlpRk5UWlNXL0EiLCJtYWMiOiI3MzNiMWM1YmVmYmVhN2JkMmIxYWFiNTEwM2FkMGEyMmY4YWVkYzMxODNkY2M4MzE2MDhmMTI2MzEyNTQzZjRlIiwidGFnIjoiIn0%3D; expires=Thu, 20-Feb-2025 11:31:50 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImFOb3UzTjFPMjdDZGVCbUVMOG5Db0E9PSIsInZhbHVlIjoiWU1DM1k1RzF3UTNhTXhaNmxzYlVlL1RDUTBmdEw5NTU0cExaZlI5YUVCYmtBcHp4QUJuZXZPOGVqclhhL0J6bHUzekd0T" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ilk0VWNCUGQyUVZuZUVBaHozdjRBU2c9PSIsInZhbHVlIjoiT2tEd0lwYUljaXdNSHVwNFdqN1lESzFwcWdXOUxOMzdEWWEzL1lhaTNQSjltWlYvNjBRWVJUY2FONDNucTVhV2pXT3pZYmlOOVRHNVpsMXBoZDNHdEJ4T2dpV3c5UmlRV25zdTNyb3JIeEU5MG9XbjFSTTlIOG5OYWFtYUhZcmYiLCJtYWMiOiI2Yjg1ZTkxNjI3Mjc0YjhmNDMzYTBhMzFkZjM5NTE0YTZmNzgyNzg1ZDg0MjE4NjlmMWYyMmVmMDBmYjJlNTMyIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ilk0VWNCUGQyUVZuZUVBaHozdjRBU2c9PSIsInZhbHVlIjoiT2tEd0lwYUljaXdNSHVwNFdqN1lESzFwcWdXOUxOMzdEWWEzL1lhaTNQSjltWlYvNjBRWVJUY2F" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "YQW1Vh59f4UHr0Rjfo3F8oUCan65bIHex207LlhM" "uc_cart_id" => "bd69562e8fcb00a480b1ca5a9d8d86b9" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/chapter/16675" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-17 23:31:50GET/article/137823414361