Generic placeholder image

Infectious Disorders - Drug Targets

Editor-in-Chief

ISSN (Print): 1871-5265
ISSN (Online): 2212-3989

Research Article

The Persistence Time of SARS-CoV-2 RNA in Hospitalized COVID-19 Patients: A Prospective Study

Author(s): Jila Yavarian, Mohammad Javaherian, Somayeh Shatizadeh Malekshahi, Zahra Ahmadinejad, Fatemeh Ghiasvand, Elaheh Ahmadi, Ladan Abbasian, Malihe Hasannezhad, Narges Dabaghipour, Nazanin-Zahra Shafiei-Jandaghi, Talat Mokhtari-Azad and Mahboubeh Hajiabdolbaghi*

Volume 22, Issue 6, 2022

Published on: 23 May, 2022

Article ID: e230222201383 Pages: 6

DOI: 10.2174/1871526522666220223162445

Price: $65

Abstract

Background: In late December 2019, severe acute respiratory syndrome coronavirus 2 (SARS-CoV2), the causative agent of coronavirus disease 2019 (COVID-19), spread to almost all countries worldwide. The outbreak of this virus has been confirmed on 19th February, 2020, in Iran.

Objective: The aim of this study was to investigate the time of viral RNA clearance in swab and serum samples of COVID-19 patients having received different medications. We also evaluated different factors that may affect viral RNA persistence in patients infected by SARS-CoV-2.

Methods: In March 2020, twenty-one hospitalized COVID-19 patients participated in this prospective study. All patients received antiviral agents in their routine care. Throat swabs and blood samples were obtained from all patients in different intervals, including day 3 or 5, day 7, day 10, and finally, 14 days after the first positive real-time RT-PCR (rRT-PCT) test.

Results: The median time from the symptom onset (SO) to the first negative rRT-PCR results for throat swabs and serum samples of COVID-19 patients was 18 and 14 days, respectively. These times were more significant in patients with lymphopenia, oxygen saturation ≤ 90%, and comorbidity.

Conclusion: This preliminary study highlights that SASR-CoV-2 RNA was not detectable in the upper respiratory tract for longer than three weeks. In addition, SARS-CoV-2 may persist for a long period of time in the respiratory than in the serum samples. This study supports the idea that in limited resource settings, the patients should be tested earlier than three weeks for discharge management.

Keywords: COVID-19, SARS-CoV-2, RNA, clearance, RT-PCR, serum.

Graphical Abstract

[1]
Zhu N, Zhang D, Wang W, et al. A novel coronavirus from patients with pneumonia in China, 2019. N Engl J Med 2020; 382(8): 727-33.
[http://dx.doi.org/10.1056/NEJMoa2001017] [PMID: 31978945]
[2]
WHO. Coronavirus disease 2019 (COVID-19) - Situation report - 72. 2020. Available from: https://www.who.int/docs/default-source/coronaviruse/situation-reports/20200401-sitrep-72-covid-19.pdf?sfvrsn=3dd8971b_2
[3]
Yavarian J, Shafiei-Jandaghi N-Z, Sadeghi K, et al. First cases of SARS-CoV-2 in Iran, 2020: Case series report. Iran J Public Health 2020; 49(8): 1564-8.
[http://dx.doi.org/10.18502/ijph.v49i8.3903] [PMID: 33083334]
[4]
Worldometer. Total Coronaviruses Case in Iran. 2020. Available from: https://www.worldometers.info/coronavirus/country/iran/
[5]
Read JM, Bridgen JR, Cummings DA, Ho A, Jewell CP. Novel coronavirus 2019.medRxiv
[http://dx.doi.org/10.1101/2020.01.23.20018549]
[6]
Huang C, Wang Y, Li X, et al. Clinical features of patients in-fected with 2019 novel coronavirus in Wuhan, China. Lancet 2020; 395(10223): 497-506.
[http://dx.doi.org/10.1016/S0140-6736(20)30183-5] [PMID: 31986264]
[7]
Chu DK, Pan Y, Cheng S, Hui KP, Krishnan P, Liu Y, et al. Molecular diagnosis of a novel coronavirus (2019-nCoV) caus-ing an outbreak of pneumonia. Clin Chem 2020; 66(4): 549-.
[http://dx.doi.org/10.1093/clinchem/hvaa029] [PMID: 32031583]
[8]
Ling Y, Xu S-B, Lin Y-X, et al. Persistence and clearance of viral RNA in 2019 novel coronavirus disease rehabilitation pa-tients. Chin Med J (Engl) 2020; 133(9): 1039-43.
[http://dx.doi.org/10.1097/CM9.0000000000000774] [PMID: 32118639]
[9]
Chen Y, Chen L, Deng Q, et al. The presence of SARS-CoV-2 RNA in the feces of COVID-19 patients. J Med Virol 2020; 92(7): 833-40.
[http://dx.doi.org/10.1002/jmv.25825] [PMID: 32243607]
[10]
Li J, Wei X, Tian W, et al. Clinical features of discharged COVID-19 patients with an extended SARS-CoV-2 RNA posi-tive signal in respiratory samples. Virus Res 2020; 286198047
[http://dx.doi.org/10.1016/j.virusres.2020.198047] [PMID: 32522535]
[11]
Jeong HW, Kim S-M, Kim H-S, et al. Viable SARS-CoV-2 in various specimens from COVID-19 patients. Clin Microbiol Infect 2020; 26(11): 1520-4.
[http://dx.doi.org/10.1016/j.cmi.2020.07.020] [PMID: 32711057]
[12]
Sun J, Xiao J, Sun R, et al. Prolonged persistence of SARS-CoV-2 RNA in body fluids. Emerg Infect Dis 2020; 26(8): 1834-8.
[http://dx.doi.org/10.3201/eid2608.201097] [PMID: 32383638]
[13]
Walsh KA, Jordan K, Clyne B, Rohde D, Drummond L, Byrne P, et al. SARS-CoV-2 detection, viral load and infectivity over the course of an infection: SARS-CoV-2 detection, viral load and infectivity. J Infect 81(3): 357-71.
[http://dx.doi.org/10.1016/j.jinf.2020.06.067]
[14]
Rees EM, Nightingale ES, Jafari Y, Waterlow NR, Clifford S, Pearson CA, et al. COVID-19 length of hospital stay: A system-atic review and data synthesis. medRxiv 2020.
[http://dx.doi.org/10.1101/2020.04.30.20084780]
[15]
Xu D, Zhang Z, Jin L, et al. Persistent shedding of viable SARS-CoV in urine and stool of SARS patients during the convales-cent phase. Eur J Clin Microbiol Infect Dis 2005; 24(3): 165-71.
[http://dx.doi.org/10.1007/s10096-005-1299-5] [PMID: 15789222]
[16]
Corman VM, Albarrak AM, Omrani AS, et al. Viral shedding and antibody response in 37 patients with Middle East respira-tory syndrome coronavirus infection. Clin Infect Dis 2016; 62(4): 477-83.
[http://dx.doi.org/10.1093/cid/civ951] [PMID: 26565003]
[17]
Zou L, Ruan F, Huang M, et al. SARS-CoV-2 viral load in upper respiratory specimens of infected patients. N Engl J Med 2020; 382(12): 1177-9.
[http://dx.doi.org/10.1056/NEJMc2001737] [PMID: 32074444]
[18]
Wang K, Zhang X, Sun J, Ye J, Wang F, Hua J, et al. Differences of SARS-CoV-2 shedding duration in sputum and nasopharyn-geal swab specimens among adult inpatients with COVID-19. Chest 2020; 158(5): 1876-84.
[http://dx.doi.org/10.1016/j.chest.2020.06.015] [PMID: 32569635]
[19]
Zhou F, Yu T, Du R, et al. Clinical course and risk factors for mortality of adult inpatients with COVID-19 in Wuhan, China: A retrospective cohort study. Lancet 2020; 395(10229): 1054-62.
[http://dx.doi.org/10.1016/S0140-6736(20)30566-3] [PMID: 32171076]
[20]
Wang L, Gao Y-H, Lou L-L, Zhang G-J. The clinical dynamics of 18 cases of COVID-19 outside of Wuhan, China. Eur Respir J 2020; 55(4)2000398
[http://dx.doi.org/10.1183/13993003.00398-2020] [PMID: 32139464]
[21]
Carmo A, Pereira-Vaz J, Mota V, et al. Clearance and persis-tence of SARS-CoV-2 RNA in patients with COVID-19. J Med Virol 2020; 92(10): 2227-31.
[http://dx.doi.org/10.1002/jmv.26103] [PMID: 32484958]
[22]
Fu Y, Han P, Zhu R, et al. Risk factors for viral RNA shedding in COVID-19 patients. Eur Respir J 2020; 56(1)2001190
[http://dx.doi.org/10.1183/13993003.01190-2020] [PMID: 32398298]
[23]
Zhou B, She J, Wang Y, Ma X. Duration of viral shedding of discharged patients with severe COVID-19. Clin Infect Dis 2020.ciaa451
[http://dx.doi.org/10.1093/cid/ciaa451] [PMID: 32302000]
[24]
Tu Y-H, Wei Y-Y, Zhang D-W, Chen C-S, Hu X-W, Fei G. Analysis of factors affected the SARS-CoV-2 viral shedding time of COVID-19 patients in Anhui, China: A retrospective study. Res Square 2020
[http://dx.doi.org/10.21203/rs.3.rs-20954/v1]
[25]
Wang W, Xu Y, Gao R, et al. Detection of SARS-CoV-2 in dif-ferent types of clinical specimens. JAMA 2020; 323(18): 1843-4.
[http://dx.doi.org/10.1001/jama.2020.3786] [PMID: 32159775]
[26]
Qian G-Q, Chen X-Q, Lv D-F, et al. Duration of SARS-CoV-2 viral shedding during COVID-19 infection. Infect Dis (Lond) 2020; 52(7): 511-2.
[http://dx.doi.org/10.1080/23744235.2020.1748705] [PMID: 32275181]
[27]
Zhang W, Du R-H, Li B, et al. Molecular and serological inves-tigation of 2019-nCoV infected patients: Implication of multiple shedding routes. Emerg Microbes Infect 2020; 9(1): 386-9.
[http://dx.doi.org/10.1080/22221751.2020.1729071] [PMID: 32065057]
[28]
Wölfel R, Corman VM, Guggemos W, et al. Virological assess-ment of hospitalized patients with COVID-2019. Nature 2020; 581(7809): 465-9.
[http://dx.doi.org/10.1038/s41586-020-2196-x] [PMID: 32235945]
[29]
Kim J-M, Kim HM, Lee EJ, et al. Detection and isolation of SARS-CoV-2 in serum, urine, and stool specimens of COVID-19 patients from the Republic of Korea. Osong Public Health Res Perspect 2020; 11(3): 112-7.
[http://dx.doi.org/10.24171/j.phrp.2020.11.3.02] [PMID: 32528816]
[30]
Fang L, Karakiulakis G, Roth M. Are patients with hypertension and diabetes mellitus at increased risk for COVID-19 infection? Lancet Respir Med 2020; 8(4)e21
[http://dx.doi.org/10.1016/S2213-2600(20)30116-8] [PMID: 32171062]
[31]
Guan WJ, Ni ZY, Hu Y, et al. Clinical characteristics of corona-virus disease 2019 in China. N Engl J Med 2020; 382(18): 1708-20.
[http://dx.doi.org/10.1056/NEJMoa2002032] [PMID: 32109013]
[32]
Chen X, Hu W, Ling J, Mo P, Zhang Y, Jiang Q, et al. Hyperten-sion and diabetes delay the viral clearance in COVID-19 pa-tients. medRxiv 2020.
[http://dx.doi.org/10.1101/2020.03.22.20040774]
[33]
Yan D, Liu X-Y, Zhu YN, et al. Factors associated with pro-longed viral shedding and impact of lopinavir/ritonavir treat-ment in hospitalised non-critically ill patients with SARS-CoV-2 infection. Eur Respir J 2020; 56(1)2000799
[http://dx.doi.org/10.1183/13993003.00799-2020] [PMID: 32430428]
[34]
Shi D, Wu W, Wang Q, Xu K, Xie J, Wu J, et al. Clinical charac-teristics and factors associated with long-term viral excretion in patients with SARS-CoV-2 infection: A single center 28-day study. J Infect Dis 2020; 222(6): 910-8.
[http://dx.doi.org/10.1093/infdis/jiaa388]
[35]
Mueller AL, McNamara MS, Sinclair DA. Why does COVID-19 disproportionately affect older people? Aging (Albany NY) 2020; 12(10): 9959-81.
[http://dx.doi.org/10.18632/aging.103344] [PMID: 32470948]
[36]
Bartoli-Leonard F, Wilkinson FL, Schiro A, Inglott FS, Alexan-der MY, Weston R. Suppression of SIRT1 in diabetic conditions induces osteogenic differentiation of human vascular smooth muscle cells via RUNX2 signalling. Sci Rep 2019; 9(1): 878.
[http://dx.doi.org/10.1038/s41598-018-37027-2] [PMID: 30696833]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version323msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[17:15:50] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[17:15:51] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[17:15:51] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[17:15:51] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (130ms)time
  • Application (193ms)time
  • 1 x Application (59.7%)
    193ms
    1 x Booting (40.29%)
    130ms
    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 duplicated114ms
    • 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 ('59068240','',1,1740676550,1740676550) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740676550
      1.04msalphaeurekaselec_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 ('59068240','/article/121097',1,1740676550,1740676550)
      200μ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 >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) 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 >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) 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 >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) 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 >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) 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 >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) 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 >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59068240 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59068240) limit 1
      19.36msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59068240
      • 1: 59068240
      • 2: 59068240
      • 3: 59068240
      • 4: 59068240
      • 5: 59068240
      • 6: 59068240
      • 7: 59068240
      • 8: 59068240
      • 9: 59068240
      • 10: 59068240
      • 11: 59068240
      • 12: 59068240
      • 13: 59068240
      • 14: 59068240
      • 15: 59068240
      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=121097
      760μ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` = 54 limit 1
      840μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 54
      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=54) and sj.journal_id!=54 group by `j`.`nid`) as `aggregate_table`
      1.27msalphaeurekaselec_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=54) and sj.journal_id!=54 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.07msalphaeurekaselec_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=54) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      5.44msalphaeurekaselec_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=54) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      4.67msalphaeurekaselec_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` = '121097'
      920μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 121097
      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` = '121097'
      2.64msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 121097
      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` = '121097' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      4.36msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 121097
      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
      450μ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
      670μ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 = 54 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      32.67msalphaeurekaselec_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 = 54 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      8.31msalphaeurekaselec_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 = 54 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      7.35msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2071
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select pdf, html, epub, prc from `article_metrics` where `article_id` = 121097 limit 1
      370μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 121097
      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 = 121097 and content_type = 'article' order by status desc limit 1
      360μ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` = 201383 limit 1
      290μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 201383
      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
      300μ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` = 'IDDT' 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: IDDT
      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 = '121097' 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) )
      560μ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 = '11625' 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) )
      440μ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 = '3191' 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) )
      380μ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 <= 59068240 and j.to_ip >=59068240 )) and ((j.from_date <= 1740676551 and j.to_date >= 1740676551 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3191) 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 <= 59068240 and j.to_ip >=59068240 )) and ((j.from_date <= 1740676551 and j.to_date >= 1740676551 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3191) 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 <= 59068240 and j.to_ip >=59068240 )) and ((j.from_date <= 1740676551 and j.to_date >= 1740676551 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3191)
      10.4msalphaeurekaselec_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 <= 59068240 and j.to_ip >=59068240 )) and ((j.from_date <= 1740676551 and j.to_date >= 1740676551 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11625) 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 <= 59068240 and j.to_ip >=59068240 )) and ((j.from_date <= 1740676551 and j.to_date >= 1740676551 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11625) 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 <= 59068240 and j.to_ip >=59068240 )) and ((j.from_date <= 1740676551 and j.to_date >= 1740676551 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11625)
      900μ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 <= 59068240 and j.to_ip >=59068240 )) and ((j.from_date <= 1740676551 and j.to_date >= 1740676551 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 121097) 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 <= 59068240 and j.to_ip >=59068240 )) and ((j.from_date <= 1740676551 and j.to_date >= 1740676551 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 121097) 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 <= 59068240 and j.to_ip >=59068240 )) and ((j.from_date <= 1740676551 and j.to_date >= 1740676551 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 121097)
      890μ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` < '56' and is_uploaded = 1 and issue_id = 11625 order by cast(first_page as SIGNED) desc limit 1
      700μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 56
      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` > '61' and is_uploaded = 1 and issue_id = 11625 order by cast(first_page as SIGNED) asc limit 1
      510μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 61
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'en'
      200μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      250μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 121097 limit 1
      2.37msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 121097
      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` = 54 and `b`.`banner_from_date` <= 1740676551 and `b`.`banner_to_date` >= 1740676551 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.15msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 54
      • 3: 1740676551
      • 4: 1740676551
      • 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` = 54 and `b`.`banner_from_date` <= 1740676551 and `b`.`banner_to_date` >= 1740676551 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: 54
      • 3: 1740676551
      • 4: 1740676551
      • 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='5fe925c9f4c6eb5ffe07b1a7fd62ef76'
      250μ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
        x7Qq4F36cNRThFC8uMMF6hSVNPPPjrbjmwE0joa0
        uc_cart_id
        5fe925c9f4c6eb5ffe07b1a7fd62ef76
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/121097" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/121097
        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 => "Thu, 27 Feb 2025 17:15:51 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlloRmRsdmxRV2JaYVoyOWptRjZKK2c9PSIsInZhbHVlIjoiVHB0N2VtZVMwYVYvSGRJeExINWthaVpybEpmbWRRUll6bXhEd2ZrQkVVM1RiSHI3UVRRVkhOSlVlaGtkQ0ZNOU1yMmFpN0RpZE5Qa0ZhdU45UEgzVWdzYTJqSFh1VXVkMTE1aGNyS2FuZjFtaWlTQUhQMDFlVFVmYmF2V2ppRDciLCJtYWMiOiJhMGMwMjkzNWUxNjZhNDM5ODhhYWFmMjYyZjAyZGFjMWQ5MDczZjZiYjkwYzhkYTdhNWY3ZjIxZmM0MDg1NGM4IiwidGFnIjoiIn0%3D; expires=Sun, 02 Mar 2025 05:15:51 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlloRmRsdmxRV2JaYVoyOWptRjZKK2c9PSIsInZhbHVlIjoiVHB0N2VtZVMwYVYvSGRJeExINWthaVpybEpmbWRRUll6bXhEd2ZrQkVVM1RiSHI3UVRRVkhOSlVlaGtkQ0ZNOU1yMmFpN" 1 => "alphaeurekaselectnet_session=eyJpdiI6Im1YdUFvVmE3cGgvNXVCeEx6TlhqclE9PSIsInZhbHVlIjoiV0NpdmVQbFUzSDltTHBtSGhMUVhvY2FhUzdNTU1xdWs3cFBoUUM0T0xFekNpTFdIU1ZSZ2k3V3R1TGFCb3pKalBSSmtDRlJHV2tiVFFSM3FOUFJQOG1pRGpUUVh1QVVqaDRwaVc5ckxQYjNSeDVtM3luOEpnbFJ0MFh0ZzdjNlIiLCJtYWMiOiI0MGFlYWYzNDJlN2ZlZTk0ZWU5Mzg5MjY1MjAxZjIyNTMyZTk3YjViYTkxNzE5MGU4MWMxNmYzN2ZhN2VhNWJjIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Im1YdUFvVmE3cGgvNXVCeEx6TlhqclE9PSIsInZhbHVlIjoiV0NpdmVQbFUzSDltTHBtSGhMUVhvY2FhUzdNTU1xdWs3cFBoUUM0T0xFekNpTFdIU1ZSZ2k3V3R" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlloRmRsdmxRV2JaYVoyOWptRjZKK2c9PSIsInZhbHVlIjoiVHB0N2VtZVMwYVYvSGRJeExINWthaVpybEpmbWRRUll6bXhEd2ZrQkVVM1RiSHI3UVRRVkhOSlVlaGtkQ0ZNOU1yMmFpN0RpZE5Qa0ZhdU45UEgzVWdzYTJqSFh1VXVkMTE1aGNyS2FuZjFtaWlTQUhQMDFlVFVmYmF2V2ppRDciLCJtYWMiOiJhMGMwMjkzNWUxNjZhNDM5ODhhYWFmMjYyZjAyZGFjMWQ5MDczZjZiYjkwYzhkYTdhNWY3ZjIxZmM0MDg1NGM4IiwidGFnIjoiIn0%3D; expires=Sun, 02-Mar-2025 05:15:51 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlloRmRsdmxRV2JaYVoyOWptRjZKK2c9PSIsInZhbHVlIjoiVHB0N2VtZVMwYVYvSGRJeExINWthaVpybEpmbWRRUll6bXhEd2ZrQkVVM1RiSHI3UVRRVkhOSlVlaGtkQ0ZNOU1yMmFpN" 1 => "alphaeurekaselectnet_session=eyJpdiI6Im1YdUFvVmE3cGgvNXVCeEx6TlhqclE9PSIsInZhbHVlIjoiV0NpdmVQbFUzSDltTHBtSGhMUVhvY2FhUzdNTU1xdWs3cFBoUUM0T0xFekNpTFdIU1ZSZ2k3V3R1TGFCb3pKalBSSmtDRlJHV2tiVFFSM3FOUFJQOG1pRGpUUVh1QVVqaDRwaVc5ckxQYjNSeDVtM3luOEpnbFJ0MFh0ZzdjNlIiLCJtYWMiOiI0MGFlYWYzNDJlN2ZlZTk0ZWU5Mzg5MjY1MjAxZjIyNTMyZTk3YjViYTkxNzE5MGU4MWMxNmYzN2ZhN2VhNWJjIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Im1YdUFvVmE3cGgvNXVCeEx6TlhqclE9PSIsInZhbHVlIjoiV0NpdmVQbFUzSDltTHBtSGhMUVhvY2FhUzdNTU1xdWs3cFBoUUM0T0xFekNpTFdIU1ZSZ2k3V3R" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "x7Qq4F36cNRThFC8uMMF6hSVNPPPjrbjmwE0joa0" "uc_cart_id" => "5fe925c9f4c6eb5ffe07b1a7fd62ef76" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/121097" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-27 17:15:51GET/article/121097414361