Generic placeholder image

Current Bioinformatics

Editor-in-Chief

ISSN (Print): 1574-8936
ISSN (Online): 2212-392X

Research Article

VirDB: Crowdsourced Database for Evaluation of Dynamical Viral Infection Models

Author(s): Szymon Wasik*, Marcin Jaroszewski, Mateusz Nowaczyk, Natalia Szostak, Tomasz Prejzendanc and Jacek Blazewicz

Volume 14, Issue 8, 2019

Page: [740 - 748] Pages: 9

DOI: 10.2174/1574893614666190308155904

Price: $65

Abstract

Background: Open science is an emerging movement underlining the importance of transparent, high quality research where results can be verified and reused by others. However, one of the biggest problems in replicating experiments is the lack of access to the data used by the authors. This problem also occurs during mathematical modeling of a viral infections. It is a process that can provide valuable insights into viral activity or into a drug’s mechanism of action when conducted correctly.

Objective: We present the VirDB database (virdb.cs.put.poznan.pl), which has two primary objectives. First, it is a tool that enables collecting data on viral infections that could be used to develop new dynamic models of infections using the FAIR data sharing principles. Second, it allows storing references to descriptions of viral infection models, together with their evaluation results.

Methods: To facilitate the fast population of database and the ease of exchange of scientific data, we decided to use crowdsourcing for collecting data. Such approach has already been proved to be very successful in projects such as Wikipedia.

Conclusion: VirDB builds on the concepts and recommendations of Open Science and shares data using the FAIR principles. Thanks to this storing data required for designing and evaluating models of viral infections which can be freely available on the Internet.

Keywords: Viral dynamics, database, open science, evaluation, viral infections modelling, bioinformatics.

Graphical Abstract

[1]
Adams MJ, Lefkowitz EJ, King AMQ, Carstens EB. Ratification vote on taxonomic proposals to the International Committee on Taxonomy of Viruses (2014). Arch Virol 2014; 159(10): 2831-41.
[2]
Dimmock N, Easton AJ, Leppard K. Introduction to Modern Virology. 6th ed. Blackwell Publishing 2007.
[3]
Urbanowicz A, Alejska M, Formanowicz P, Błażewicz J, Figlerowicz M, Bujarski JJ. Homologous crossovers among molecules of brome mosaic bromovirus RNA1 or RNA2 segments in vivo. J Virol 2005; 79(9): 5732-42.
[4]
HIV/AIDS JUNP on. UNAIDS World AIDS Day Report United Nations. 2011.
[5]
Aylward B, Barboza P, Bawo L, et al. WHO Ebola Response Team. Ebola virus disease in West Africa--the first 9 months of the epidemic and forward projections. N Engl J Med 2014; 371(16): 1481-95.
[6]
Lefebvre A, Fiet C, Belpois-Duchamp C, Tiv M, Astruc K, Aho Glélé LS. Case fatality rates of Ebola virus diseases: a meta-analysis of World Health Organization data. Med Mal Infect 2014; 44(9): 412-6.
[7]
Gulland A. Ebola outbreak in west Africa is officially over. BMJ 2016; 352: i243.
[8]
Rasmussen SA, Jamieson DJ, Honein MA, Petersen LR. Zika Virus and Birth Defects--Reviewing the Evidence for Causality. N Engl J Med 2016; 374(20): 1981-7.
[9]
Kaslow RA. Epidemiology and Control: Principles, Practice and Programs.Viral Infections of Humans: Epidemiology and Control Springer US. Boston, MA 2014; 3-8.
[10]
Altman DG. Statistics and ethics in medical research. Collecting and screening data. BMJ 1980; 281(6252): 1399-401.
[11]
Nelson EC, Splaine ME, Batalden PB, Plume SK. Building measurement and data collection into medical practice. Ann Intern Med 1998; 128(6): 460-6.
[12]
Cios KJ, Moore GW. Uniqueness of medical data mining. Artif Intell Med 2002; 26(1-2): 1-24.
[13]
Neylon C, Wu S. Open Science: tools, approaches, and implications. Pac Symp Biocomput 2009; 540-4.
[14]
Kraker P, Leony D, Reinhardt W. Beham nter G. The Case for an Open Science in Technology Enhanced Learning. Int J Technol Enhanc Learn 2011; 3: 643-54.
[15]
Wodak SJ, Mietchen D, Collings AM, Russell RB, Bourne PE. Topic pages: PLoS Computational Biology meets Wikipedia. PLOS Comput Biol 2012; 8(3)e1002446
[16]
Szostak N, Wasik S, Blazewicz J. Hypercycle. PLOS Comput Biol 2016; 12(4)e1004853
[17]
McCullough BD. Got replicability? the journal of money, credit and banking archive. Econ J Watch 2007; 4: 326.
[18]
McCullough BD, McGeary KA, Harrison TD. Lessons from the JMCB Archive. J Money Credit Bank 2006; 38: 1093-107.
[19]
McCullough BD, McGeary KA, Harrison TD. Do Economics Journal Archives Promote Replicable Research?Social Science Research Network: Rochester, NY . 2006. Report No. ID 931231.
[20]
Begley CG, Ellis LM. Drug development: Raise standards for preclinical cancer research. Nature 2012; 483(7391): 531-3.
[21]
Mullard A. Reliability of ‘new drug target’ claims called into question. Nat Rev Drug Discov 2011; 10(9): 643-4.
[22]
Spellman BA. Introduction to the Special Section: Data, Data, Everywhere. Especially in My File Drawer. Perspect Psychol Sci 2012; 7(1): 58-9.
[23]
White HC, Carrier S, Thompson A, Greenberg J, Scherle R. The Dryad Data Repository: A Singapore Framework Metadata Architecture in a DSpace Environment. Int Conf Dublin Core Metadata Appl 2008; pp. 157-62.
[24]
Pampel H, Vierkant P, Scholze F, et al. Making research data repositories visible: the re3data.org Registry. PLoS One 2013; 8(11)e78080
[25]
Wynholds L, Fearon DS Jr, Borgman CL, Traweek S. When Use Cases Are Not Useful: Data Practices, Astronomy, and Digital Libraries. Proceedings of the 11th Annual International ACM/IEEE Joint Conference on Digital Libraries ACM. New York, NY, USA. 2011; pp. 383-6.
[26]
Pontika N, Knoth P, Cancellieri M, Pearce S. Fostering Open Science to Research Using a Taxonomy and an eLearning Portal. Proceedings of the 15th International Conference on Knowledge Technologies and Data-driven Business ACM. New York, NY, USA. 2015; pp. 1-11.
[27]
Borgman CL. The Conundrum of Sharing Research DataSocial Science Research Network: Rochester, NY . 2011. Report No.: ID 1869155.
[28]
Edwards PN, Mayernik MS, Batcheller AL, Bowker GC, Borgman CL. Science friction: data, metadata, and collaboration. Soc Stud Sci 2011; 41(5): 667-90.
[29]
Musen MA, Bean CA, Cheung K-H, et al. CEDAR team. The center for expanded data annotation and retrieval. J Am Med Inform Assoc 2015; 22(6): 1148-52.
[30]
Wilkinson MD, Dumontier M, Aalbersberg IJ, et al. The FAIR Guiding Principles for scientific data management and stewardship. Sci Data 2016.3160018
[31]
Wasik S, Prejzendanc T, Blazewicz J. ModeLang – Experts-friendly language for describing viral infection models. Comput Math Methods Med 2013; 2013: 8.
[32]
Prejzendanc T, Wasik S, Blazewicz J. Computer representations of bioinformatics models. Curr Bioinform 2016; 11: 551-60.
[33]
Virus dynamics: Mathematical principles of immunology and virology. Oxford, New York: Oxford University Press 2001.
[34]
Perelson AS, Ribeiro RM. Modeling the within-host dynamics of HIV infection. BMC Biol 2013; 11: 96.
[35]
Ciupe SM, Ribeiro RM, Nelson PW, Perelson AS. Modeling the mechanisms of acute hepatitis B virus infection. J Theor Biol 2007; 247(1): 23-35.
[36]
Nowak MA, Bonhoeffer S, Hill AM, Boehme R, Thomas HC, McDade H. Viral dynamics in hepatitis B virus infection. Proc Natl Acad Sci USA 1996; 93(9): 4398-402.
[37]
Chatterjee A, Smith PF, Perelson AS. Hepatitis C viral kinetics: the past, present, and future. Clin Liver Dis 2013; 17(1): 13-26.
[38]
Neumann AU, Lam NP, Dahari H, et al. Hepatitis C viral dynamics in vivo and the antiviral efficacy of interferon-alpha therapy. Science 1998; 282(5386): 103-7.
[39]
Madelain V, Oestereich L, Graw F, et al. Ebola virus dynamics in mice treated with favipiravir. Antiviral Res 2015; 123: 70-7.
[40]
Banton S, Roth Z, Pavlovic M. Mathematical modeling of Ebola virus dynamics as a step towards rational vaccine design. 26th Southern Biomedical Engineering Conference SBEC 2010. April 30-May 2, 2010; College Park, Maryland, USA. 196-200.
[41]
Box GE. Robustness in the strategy of scientific model building. Robustness in statistics Elsevier. 1979; 201-36.
[42]
Harrell FE. Regression modeling strategies. BIOS 2017; 330: 2018.
[43]
Efroymson M. Multiple regression analysis. Math Methods Digit Comput 1960; pp. 191-203.
[44]
Stone M. Cross-Validatory Choice and Assessment of Statistical Predictions. J R Stat Soc B 1974; 36: 111-47.
[45]
Geisser S. The Predictive Sample Reuse Method with Applications. J Am Stat Assoc 1975; 70: 320-8.
[46]
Arlot S, Celisse A. A survey of cross-validation procedures for model selection. Stat Surv 2010; 4: 40-79.
[47]
Akaike H. Information Theory and an Extension of the Maximum Likelihood Principle. Selected Papers of Hirotugu Akaike Springer New York 1998; pp. 199-213.
[48]
Toffoli T. Cellular automata as an alternative to (rather than an approximation of) differential equations in modeling physics. Phys Nonlinear Phenom 1984; 10: 117-27.
[49]
Wasik S, Fratczak F, Krzyskow J, Wulnikowski J. Inferring Mathematical Equations Using Crowdsourcing. PLoS One 2015; 10(12)e0145557
[50]
Wasik S, Jackowiak P, Figlerowicz M, Blazewicz J. Multi-agent model of hepatitis C virus infection. Artif Intell Med 2014; 60(2): 123-31.
[51]
Dahari H, Ribeiro RM, Perelson AS. Triphasic decline of hepatitis C virus RNA during antiviral therapy. Hepatology 2007; 46(1): 16-21.
[52]
Bauer B, Reynolds M. Recovering data from scanned graphs: performance of Frantz’s g3data software. Behav Res Methods 2008; 40(3): 858-68.
[53]
Martyushev AP, Petravic J, Grimm AJ, et al. Epitope-specific CD8+ T cell kinetics rather than viral variability determine the timing of immune escape in simian immunodeficiency virus infection. J Immunol 2015; 194(9): 4112-21.
[54]
Martyushev AP, Petravic J, Grimm AJ, et al. Data from: Epitope-specific CD8+ T cell kinetics rather than viral variability determine the timing of immune escape in Simian Immunodeficiency Virus infection. J Immunol 2015; 194(9): 4112-21.
[55]
Doan A, Ramakrishnan R, Halevy AY. Crowdsourcing Systems on the World-Wide Web. Commun ACM 2011; 54: 86-96.
[56]
Altman DG, Andersen PK. Bootstrap investigation of the stability of a Cox regression model. Stat Med 1989; 8(7): 771-83.
[57]
Tibshirani R. Regression Shrinkage and Selection via the Lasso. J R Stat Soc B 1996; 58: 267-88.
[58]
Derksen S, Keselman HJ. Backward, forward and stepwise automated subset selection algorithms: Frequency of obtaining authentic and noise variables. Br J Math Stat Psychol 1992; 45: 265-82.
[59]
Aho K, Derryberry D, Peterson T. Model selection for ecologists: the worldviews of AIC and BIC. Ecology 2014; 95(3): 631-6.
[60]
Macey R, Oster G, Zahnley T. Berkeley Madonna User’s Guide. Berkeley: University of California 2009.
[61]
Guedj J, Dahari H, Pohl RT, Ferenci P, Perelson AS. Understanding silibinin’s modes of action against HCV using viral kinetic modeling. J Hepatol 2012; 56(5): 1019-24.
[62]
Pinheiro J, Bates D. DebRoy S, Sarkar D, Team RC, others nlme: Linear and nonlinear mixed effects models. R Package Version 2012; p. 3.
[63]
Burnham KP, Anderson DR. Multimodel Inference: Understanding AIC and BIC in Model Selection. Sociol Methods Res 2004; 33: 261-304.
[64]
Boban M. Digital single market and EU data protection reform with regard to the processing of personal data as the challenge of the modern world. Econ Soc Dev Book Proc 2016; p. 191.
[65]
Hallinan D, Friedewald M. Open consent, biobanking and data protection law: can open consent be ‘informed’ under the forthcoming data protection regulation? Life Sci Soc Policy 2015; 11: 1.
[66]
Wojciechowski P, Frohmberg W, Kierzynka M, Zurkowski P, Blazewicz J. G-MAPSEQ – a new method for mapping reads to a reference genome. Found Comput Decis Sci 2016; 41: 123-42.
[67]
Wasik S, Jackowiak P, Krawczyk JB, et al. Towards prediction of HCV therapy efficiency. Comput Math Methods Med 2010; 11(2): 185-99.
[68]
Komarova NL, Levy DN, Wodarz D. Synaptic transmission and the susceptibility of HIV infection to anti-viral drugs. Sci Rep 2013; 3: 2103.
[69]
Komarova NL, Anghelina D, Voznesensky I, Trinité B, Levy DN, Wodarz D. Relative contribution of free-virus and synaptic transmission to the spread of HIV-1 through target cell populations. Biol Lett 2013.920121049
[70]
Dale BM, Alvarez RA, Chen BK. Mechanisms of enhanced HIV spread through T-cell virological synapses. Immunol Rev 2013; 251(1): 113-24.
[71]
Sattentau QJ. Cell-to-Cell Spread of Retroviruses. Viruses 2010; 2(6): 1306-21.
[72]
Feldmann J, Schwartz O. HIV-1 Virological Synapse: Live Imaging of Transmission. Viruses 2010; 2(8): 1666-80.
[73]
Dixit NM, Perelson AS. Multiplicity of human immunodeficiency virus infections in lymphoid tissue. J Virol 2004; 78(16): 8942-5.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version929msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[10:02:20] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[10:02:21] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[10:02:21] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (215ms)time
  • Application (714ms)time
  • 1 x Application (76.87%)
    714ms
    1 x Booting (23.13%)
    215ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated584ms
    • 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 ('59576018','',1,1739959340,1739959340) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739959340
      1.2msalphaeurekaselec_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 ('59576018','/article/97198',1,1739959340,1739959340)
      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 >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) 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 >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) 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 >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) 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 >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) 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 >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) 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 >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59576018 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59576018) limit 1
      19.89msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59576018
      • 1: 59576018
      • 2: 59576018
      • 3: 59576018
      • 4: 59576018
      • 5: 59576018
      • 6: 59576018
      • 7: 59576018
      • 8: 59576018
      • 9: 59576018
      • 10: 59576018
      • 11: 59576018
      • 12: 59576018
      • 13: 59576018
      • 14: 59576018
      • 15: 59576018
      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=97198
      1.15msalphaeurekaselec_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` = 65 limit 1
      1.08msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 65
      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=65) and sj.journal_id!=65 group by `j`.`nid`) as `aggregate_table`
      1.06msalphaeurekaselec_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=65) and sj.journal_id!=65 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      960μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=65) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      4.38msalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 16. app/Models/Subject.php:220
      • 17. app/Http/Controllers/ArticleController.php:2518
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=65) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      16.3msalphaeurekaselec_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` = '97198'
      22msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 97198
      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` = '97198'
      16.21msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 97198
      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` = '97198' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      43.67msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 97198
      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
      430μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      780μsalphaeurekaselec_live_10_06_2022Article.php#1960
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1960
      • 14. app/Http/Controllers/ArticleController.php:2062
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • Select j.subtitle, v.volume_id as volume_id,v.year_id,y.year as year,v.volume_name, v.total_no_of_issues, i.issue_id as issue_id,i.title as issue, i.publication_date as issue_pub_date from journal j join volume v on j.journal_id = v.journal_id join issue i on v.volume_id = i.volume_id join article a on a.issue_id = i.issue_id join year y on v.year_id = y.id where j.journal_id = 65 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      90.37msalphaeurekaselec_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 = 65 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      9.71msalphaeurekaselec_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 = 65 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      39.82msalphaeurekaselec_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` = 97198 limit 1
      11msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 97198
      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 = 97198 and content_type = 'article' order by status desc limit 1
      480μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 295 and cd.sub_disease_id = 300 and content_id!=97198 and cd.content_type = 'article' order by rand() limit 20
      237msalphaeurekaselec_live_10_06_2022Article.php#769
      Backtrace
      • 11. app/Models/Article.php:769
      • 12. app/Http/Controllers/ArticleController.php:2098
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 170590 limit 1
      440μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 170590
      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
      370μ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` = 'CBIO' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      440μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CBIO
      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 = '97198' 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) )
      570μ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 = '9524' 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) )
      480μ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 = '2527' 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) )
      450μ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 <= 59576018 and j.to_ip >=59576018 )) and ((j.from_date <= 1739959341 and j.to_date >= 1739959341 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2527) 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 <= 59576018 and j.to_ip >=59576018 )) and ((j.from_date <= 1739959341 and j.to_date >= 1739959341 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2527) 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 <= 59576018 and j.to_ip >=59576018 )) and ((j.from_date <= 1739959341 and j.to_date >= 1739959341 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2527)
      48.79msalphaeurekaselec_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 <= 59576018 and j.to_ip >=59576018 )) and ((j.from_date <= 1739959341 and j.to_date >= 1739959341 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9524) 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 <= 59576018 and j.to_ip >=59576018 )) and ((j.from_date <= 1739959341 and j.to_date >= 1739959341 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9524) 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 <= 59576018 and j.to_ip >=59576018 )) and ((j.from_date <= 1739959341 and j.to_date >= 1739959341 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9524)
      1.06msalphaeurekaselec_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 <= 59576018 and j.to_ip >=59576018 )) and ((j.from_date <= 1739959341 and j.to_date >= 1739959341 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 97198) 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 <= 59576018 and j.to_ip >=59576018 )) and ((j.from_date <= 1739959341 and j.to_date >= 1739959341 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 97198) 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 <= 59576018 and j.to_ip >=59576018 )) and ((j.from_date <= 1739959341 and j.to_date >= 1739959341 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 97198)
      930μ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` < '740' and is_uploaded = 1 and issue_id = 9524 order by cast(first_page as SIGNED) desc limit 1
      760μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 740
      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` > '748' and is_uploaded = 1 and issue_id = 9524 order by cast(first_page as SIGNED) asc limit 1
      660μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 748
      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'
      240μ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
      320μ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` = 97198 limit 1
      3.84msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 97198
      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` = 65 and `b`.`banner_from_date` <= 1739959341 and `b`.`banner_to_date` >= 1739959341 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.85msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 65
      • 3: 1739959341
      • 4: 1739959341
      • 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` = 65 and `b`.`banner_from_date` <= 1739959341 and `b`.`banner_to_date` >= 1739959341 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      4.56msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 65
      • 3: 1739959341
      • 4: 1739959341
      • 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='50467a3ded046b90200218eb218d8b5c'
      610μ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
        hx6tlTaZL7l4HEbVO4lnAuNtF9FHvwe8b6LgmDOb
        uc_cart_id
        50467a3ded046b90200218eb218d8b5c
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/article/97198" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/97198
        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=eyJpdiI6IjU1QkpnZ2cydkxGb3hLc0tHWGlEOFE9PSIsInZhbHVlIjoiN25BbUVCczVYZW1QNTYyQ3JVV2N0TFZNclpKWklieDcrTlBNWVVWRnZIST0iLCJtYWMiOiIzNzRkZjc5YmQyMzkxYTJkYTM1MmQ0ZDEwNzAwNWM0MTY0NGRiNjk5NzkwYjY2YTE2ZWFjOTA3N2MyZTZmMzhmIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IjU1QkpnZ2cydkxGb3hLc0tHWGlEOFE9PSIsInZhbHVlIjoiN25BbUVCczVYZW1QNTYyQ3JVV2N0TFZNclpKWklieDcrTlBNWVVWRnZIST0iLCJtYWMiOiIzNzRkZjc5YmQyMzkx" ] "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:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 19 Feb 2025 10:02:21 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Imh6YXppd0w0bnI0eVRUZ2N2dUliaUE9PSIsInZhbHVlIjoibzRwTHA1SCtGM1h4UEh4NkFNcG1aN1FHMWxEMWNMZE14cllhN1ZTM3VRQ2FjTndIQ2ZpUkNKWklRTjNKbDYyUCtnM2V4R2V2NTJyUDR2MGcreHZIb2N4QXBPMVFLVnh4R1VVbjhBblI1SHRPdUNPMnoxK1UzV0ZiS3p0cmtsaE4iLCJtYWMiOiJlOWI4M2Q0ZjRkOTAwN2Y1NTg5YzVmM2JmNzgyYjdjOTYwMGIzZjc0MzcyOTRhZjJkNjhmODA0ZTVhMTI2NzAyIiwidGFnIjoiIn0%3D; expires=Fri, 21 Feb 2025 22:02:21 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Imh6YXppd0w0bnI0eVRUZ2N2dUliaUE9PSIsInZhbHVlIjoibzRwTHA1SCtGM1h4UEh4NkFNcG1aN1FHMWxEMWNMZE14cllhN1ZTM3VRQ2FjTndIQ2ZpUkNKWklRTjNKbDYyUCtnM2V4R" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkNrOWdZUThFbmx5T0VDT09VVWVFbnc9PSIsInZhbHVlIjoiZ0x4cWtMZzJTalhIZE80UmkwcHYyK01uVDBGUitqTHRmUHNVa0MzdWpFWXFIUFE4MnNYdE5FT3lQUVVlaE1DaFM1Q2lIOXREZHkxQWY1RThOOUZBNVJuQXhUb3JNZjNPdm91TmgvYmtXODBQMFBwMjR6ajBQNDgwNFNuZHpKdU0iLCJtYWMiOiI5M2M4MjNlZjVjMjJiZTFiY2FhZmI2OThlZmM3ZDAzNjI1MWMyNWRmYjI1OGY4ZTM3ZjU3YWI2OTk5YjRkM2U1IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkNrOWdZUThFbmx5T0VDT09VVWVFbnc9PSIsInZhbHVlIjoiZ0x4cWtMZzJTalhIZE80UmkwcHYyK01uVDBGUitqTHRmUHNVa0MzdWpFWXFIUFE4MnNYdE5FT3l" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Imh6YXppd0w0bnI0eVRUZ2N2dUliaUE9PSIsInZhbHVlIjoibzRwTHA1SCtGM1h4UEh4NkFNcG1aN1FHMWxEMWNMZE14cllhN1ZTM3VRQ2FjTndIQ2ZpUkNKWklRTjNKbDYyUCtnM2V4R2V2NTJyUDR2MGcreHZIb2N4QXBPMVFLVnh4R1VVbjhBblI1SHRPdUNPMnoxK1UzV0ZiS3p0cmtsaE4iLCJtYWMiOiJlOWI4M2Q0ZjRkOTAwN2Y1NTg5YzVmM2JmNzgyYjdjOTYwMGIzZjc0MzcyOTRhZjJkNjhmODA0ZTVhMTI2NzAyIiwidGFnIjoiIn0%3D; expires=Fri, 21-Feb-2025 22:02:21 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Imh6YXppd0w0bnI0eVRUZ2N2dUliaUE9PSIsInZhbHVlIjoibzRwTHA1SCtGM1h4UEh4NkFNcG1aN1FHMWxEMWNMZE14cllhN1ZTM3VRQ2FjTndIQ2ZpUkNKWklRTjNKbDYyUCtnM2V4R" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkNrOWdZUThFbmx5T0VDT09VVWVFbnc9PSIsInZhbHVlIjoiZ0x4cWtMZzJTalhIZE80UmkwcHYyK01uVDBGUitqTHRmUHNVa0MzdWpFWXFIUFE4MnNYdE5FT3lQUVVlaE1DaFM1Q2lIOXREZHkxQWY1RThOOUZBNVJuQXhUb3JNZjNPdm91TmgvYmtXODBQMFBwMjR6ajBQNDgwNFNuZHpKdU0iLCJtYWMiOiI5M2M4MjNlZjVjMjJiZTFiY2FhZmI2OThlZmM3ZDAzNjI1MWMyNWRmYjI1OGY4ZTM3ZjU3YWI2OTk5YjRkM2U1IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkNrOWdZUThFbmx5T0VDT09VVWVFbnc9PSIsInZhbHVlIjoiZ0x4cWtMZzJTalhIZE80UmkwcHYyK01uVDBGUitqTHRmUHNVa0MzdWpFWXFIUFE4MnNYdE5FT3l" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "hx6tlTaZL7l4HEbVO4lnAuNtF9FHvwe8b6LgmDOb" "uc_cart_id" => "50467a3ded046b90200218eb218d8b5c" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/article/97198" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-19 10:02:21GET/article/97198314371