Generic placeholder image

Current Bioinformatics

Editor-in-Chief

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

Research Article

Integrated In-silico Analysis to Study the Role of microRNAs in the Detection of Chronic Kidney Diseases

Author(s): Amina Khan, Andleeb Zahra, Sana Mumtaz, M. Qaiser Fatmi* and Muhammad J. Khan*

Volume 15, Issue 2, 2020

Page: [144 - 154] Pages: 11

DOI: 10.2174/1574893614666190923115032

Price: $65

Abstract

Background: MicroRNAs (miRNAs) play an important role in the pathogenesis of various renal diseases, including Chronic Kidney Diseases (CKD). CKD refers to the gradual loss of kidney function with the declining Glomerular Functional Rate (GFR).

Objective: This study focused on the regulatory mechanism of miRNA to control gene expression in CKD.

Methods: In this context, two lists of Differentially Expressed Genes (DEGs) were obtained; one from the three selected experiments by setting a cutoff p-value of <0.05 (List A), and one from a list of target genes of miRNAs (List B). Both lists were then compared to get a common dataset of 33 miRNAs, each had a set of DEGs i.e. both up-regulated and down-regulated genes (List C). These data were subjected to functional enrichment analysis, network illustration, and gene homology studies.

Results: This study confirmed the active participation of various miRNAs i.e. hsa -miR-15a-5p, hsa-miR-195-5p, hsa-miR-365-3p, hsa-miR-30a-5p, hsa-miR-124-3p, hsa-miR-200b-3p, and hsamiR- 429 in the dysregulation of genes involved in kidney development and function. Integrated analyses depicted that miRNAs modulated renal development, homeostasis, various metabolic processes, immune responses, and ion transport activities. Furthermore, homology studies of miRNA-mRNA hybrid highlighted the effect of partial complementary binding pattern on the regulation of genes by miRNA.

Conclusion: The study highlighted the great values of miRNAs as biomarkers in kidney diseases. In addition, the need for further investigations on miRNA-based studies is also commended in the development of diagnostic, prognostic, and therapeutic tools for renal diseases.

Keywords: microRNA, gene expression, Chronic Kidney Diseases (CKD), Glomerular Functional Rate (GFR), dysregulation, biomarkers.

Graphical Abstract

[1]
Levey AS, Eckardt K-U, Tsukamoto Y, et al. Definition and classification of chronic kidney disease: a position statement from Kidney Disease: Improving Global Outcomes (KDIGO). Kidney Int 2005; 67(6): 2089-100.
[http://dx.doi.org/10.1111/j.1523-1755.2005.00365.x] [PMID: 15882252]
[2]
Schiffrin EL, Lipman ML, Mann JFE. Chronic kidney disease: effects on the cardiovascular system. Circulation 2007; 116(1): 85-97.
[http://dx.doi.org/10.1161/CIRCULATIONAHA.106.678342] [PMID: 17606856]
[3]
Khella HWZ, Bakhet M, Lichner Z, Romaschin AD, Jewett MAS, Yousef GM. MicroRNAs in kidney disease: an emerging understanding. Am J Kidney Dis 2013; 61(5): 798-808.
[http://dx.doi.org/10.1053/j.ajkd.2012.09.018] [PMID: 23219107]
[4]
Neuen BL, Chadban SJ, Demaio AR, Johnson DW, Perkovic V. Chronic kidney disease and the global NCDs agenda. BMJ Glob Health 2017; 2(2): e000380
[http://dx.doi.org/10.1136/bmjgh-2017-000380] [PMID: 29225940]
[5]
Thompson S, Wiebe N, Padwal RS, et al. The effect of exercise on blood pressure in chronic kidney disease: A systematic review and meta-analysis of randomized controlled trials. PLoS One 2019; 14(2): e0211032
[http://dx.doi.org/10.1371/journal.pone.0211032] [PMID: 30726242]
[6]
Balkau B, Metzger M, Andreelli F, et al. Impact of sex and glucose-lowering treatments on hypoglycaemic symptoms in people with type 2 diabetes and chronic kidney disease. The French Chronic Kidney Disease - Renal Epidemiology and Information Network (CKD-REIN) Study. Diabetes Metab 2019; 45(2): 175-83.
[http://dx.doi.org/10.1016/j.diabet.2018.03.007] [PMID: 29706470]
[7]
Jessani S, Bux R, Jafar TH. Prevalence, determinants, and management of chronic kidney disease in Karachi, Pakistan - a community based cross-sectional study. BMC Nephrol 2014; 15(1): 90.
[http://dx.doi.org/10.1186/1471-2369-15-90] [PMID: 24927636]
[8]
Sárközy M, Gáspár R, Zvara Á, et al. Chronic kidney disease induces left ventricular overexpression of the pro-hypertrophic microRNA-212. Sci Rep 2019; 9(1): 1302.
[http://dx.doi.org/10.1038/s41598-018-37690-5] [PMID: 30718600]
[9]
Kozomara A, Griffiths-Jones S. miRBase: annotating high confidence microRNAs using deep sequencing data. Nucleic Acids Res 2014; 42(Database issue): D68-73.
[http://dx.doi.org/10.1093/nar/gkt1181] [PMID: 24275495]
[10]
Lee RC, Feinbaum RL, Ambros V. The C. elegans heterochronic gene lin-4 encodes small RNAs with antisense complementarity to lin-14. Cell 1993; 75(5): 843-54.
[http://dx.doi.org/10.1016/0092-8674(93)90529-Y] [PMID: 8252621]
[11]
Rudnicki M, Perco PD, Haene B, et al. Renal microRNA- and RNA-profiles in progressive chronic kidney disease. Eur J Clin Invest 2016; 46(3): 213-26.
[http://dx.doi.org/10.1111/eci.12585] [PMID: 26707063]
[12]
Hüttenhofer A, Mayer G. Circulating miRNAs as biomarkers of kidney disease. Clin Kidney J 2017; 10(1): 27-9.
[http://dx.doi.org/10.1093/ckj/sfw075] [PMID: 28639626]
[13]
Muendlein A, Geiger K, Leiherer A, et al. Correlation Between Circulating Micrornas and Chronic Kidney Disease in Patients With and Without Type 2 Diabetes. J Am Coll Cardiol 2018; 71(11): A1836.
[http://dx.doi.org/10.1016/S0735-1097(18)32377-5]
[14]
Bai M, Chen H, Ding D, et al. MicroRNA-214 promotes chronic kidney disease by disrupting mitochondrial oxidative phosphorylation. Kidney Int 2019; 95(6): 1389-404.
[http://dx.doi.org/10.1016/j.kint.2018.12.028] [PMID: 30955870]
[15]
Paradis P, Huo K-G, Richer C, et al. A2935 microRNA profiling in peripheral blood mononuclear cells from hypertensive patients with or without chronic kidney disease. J Hypertens 2018; 36: e21
[16]
Barrett T, Wilhite SE, Ledoux P, et al. NCBI GEO: archive for functional genomics data sets-update. Nucleic Acids Res 2013; 41(Database issue): D991-5.
[http://dx.doi.org/10.1093/nar/gks1193] [PMID: 23193258]
[17]
Wong N, Wang X. miRDB: an online resource for microRNA target prediction and functional annotations. Nucleic Acids Res 2015; 43(Database issue): D146-52.
[http://dx.doi.org/10.1093/nar/gku1104] [PMID: 25378301]
[18]
Zahra A, Rubab I, Malik S, Khan A, Khan MJ, Fatmi MQ. Meta-analysis of miRNAs and their involvement as biomarkers in oral cancers. BioMed Res Int 2018; 20188439820
[http://dx.doi.org/10.1155/2018/8439820] [PMID: 29516011]
[19]
Wang S, Zhang X, Hao F, et al. Reconstruction and functional annotation of P311 protein-protein interaction network reveals its new functions. Front Genet 2019; 10: 109.
[http://dx.doi.org/10.3389/fgene.2019.00109] [PMID: 30838032]
[20]
Wang Y, Lv K, Zhao M, et al. Expression profiles and functional annotation analysis of mRNAs in suprachiasmatic nucleus of Clock mutant mice. Gene 2018; 647: 107-14.
[http://dx.doi.org/10.1016/j.gene.2017.12.056] [PMID: 29307853]
[21]
Huang W, Sherman BT, Lempicki RA. Systematic and integrative analysis of large gene lists using DAVID bioinformatics resources. Nat Protoc 2009; 4(1): 44-57.
[http://dx.doi.org/10.1038/nprot.2008.211] [PMID: 19131956]
[22]
Zuo Y, Gao Y, Su G, et al. Irregular transcriptome reprogramming probably caused embryo developmental failure of interspecies nuclear transfer between the Przewalski ’ s gazelle and the bovine 2014; 1-14.
[23]
Shannon P, Markiel A, Ozier O, et al. Cytoscape: a software environment for integrated models of biomolecular interaction networks. Genome Res 2003; 13(11): 2498-504.
[http://dx.doi.org/10.1101/gr.1239303] [PMID: 14597658]
[24]
Kozomara A, Griffiths-Jones S. miRBase: integrating microRNA annotation and deep-sequencing data. Nucleic Acids Res 2011; 39: D152-7.
[25]
Kruger J, Rehmsmeier M. RNAhybrid: microRNA target prediction easy, fast and flexible. Nucleic Acids Res 2006; 34(Web Server): W451-4.
[http://dx.doi.org/10.1093/nar/gkl243]
[26]
Xie Y, Jia Y, Cuihua X, Hu F, Xue M, Xue Y. Urinary exosomal microRNA profiling in incipient type 2 diabetic kidney disease. J Diabetes Res 2017; 2017: 6978984
[http://dx.doi.org/10.1155/2017/6978984] [PMID: 29038788]
[27]
Wei Q, Mi QS, Dong Z. The regulation and function of microRNAs in kidney diseases. IUBMB Life 2013; 65(7): 602-14.
[http://dx.doi.org/10.1002/iub.1174] [PMID: 23794512]
[28]
Pavkovic M, Vaidya VS. MicroRNAs and drug-induced kidney injury. Pharmacol Ther 2016; 163: 48-57.
[http://dx.doi.org/10.1016/j.pharmthera.2016.03.016] [PMID: 27126472]
[29]
Xie JX, Fan X, Drummond CA, et al. MicroRNA profiling in kidney disease: Plasma versus plasma-derived exosomes. Gene 2017; 627: 1-8.
[http://dx.doi.org/10.1016/j.gene.2017.06.003] [PMID: 28587849]
[30]
Zununi Vahed S, Poursadegh Zonouzi A, Mahmoodpoor F, Samadi N, Ardalan M, Omidi Y. Circulating miR-150, miR-192, miR-200b, and miR-423-3p as non-invasive biomarkers of chronic allograft dysfunction. Arch Med Res 2017; 48(1): 96-104.
[http://dx.doi.org/10.1016/j.arcmed.2017.03.004] [PMID: 28577875]
[31]
Ichii O, Otsuka S, Ohta H, Yabuki A, Horino T, Kon Y. MicroRNA expression profiling of cat and dog kidneys. Res Vet Sci 2014; 96(2): 299-303.
[http://dx.doi.org/10.1016/j.rvsc.2014.01.003] [PMID: 24530019]
[32]
Szeto CC, Ching-Ha KB, Ka-Bik L, et al. Micro-RNA expression in the urinary sediment of patients with chronic kidney diseases. Dis Markers 2012; 33(3): 137-44.
[http://dx.doi.org/10.1155/2012/842764] [PMID: 22960330]
[33]
Kiriakidou M, Nelson PT, Kouranov A, et al. A combined computational-experimental approach predicts human microRNA targets. Genes Dev 2004; 18(10): 1165-78.
[http://dx.doi.org/10.1101/gad.1184704] [PMID: 15131085]
[34]
Sun Y, Koo S, White N, et al. Development of a micro-array to detect human and mouse microRNAs and characterization of expression in human organs. Nucleic Acids Res 2004; 32(22): e188-8.
[http://dx.doi.org/10.1093/nar/gnh186] [PMID: 15616155]
[35]
Chin LJ, Slack FJ. A truth serum for cancer--microRNAs have major potential as cancer biomarkers. Cell Res 2008; 18(10): 983-4.
[http://dx.doi.org/10.1038/cr.2008.290] [PMID: 18833286]
[36]
Gurtan AM, Sharp PA. The role of miRNAs in regulating gene expression networks. J Mol Biol 2013; 425(19): 3582-600.
[http://dx.doi.org/10.1016/j.jmb.2013.03.007] [PMID: 23500488]
[37]
Zeng Y, Cullen BR. Sequence requirements for micro RNA processing and function in human cells. RNA 2003; 9(1): 112-23.
[http://dx.doi.org/10.1261/rna.2780503] [PMID: 12554881]
[38]
Neal CS, Michael MZ, Pimlott LK, Yong TY, Li JYZ, Gleadle JM. Circulating microRNA expression is reduced in chronic kidney disease. Nephrol Dial Transplant 2011; 26(11): 3794-802.
[http://dx.doi.org/10.1093/ndt/gfr485] [PMID: 21891774]
[39]
Muralidharan J, Ramezani A, Hubal M, et al. Extracellular microRNA signature in chronic kidney disease. Am J Physiol Renal Physiol 2017; 312(6): F982-91.
[http://dx.doi.org/10.1152/ajprenal.00569.2016] [PMID: 28077372]
[40]
Kiriakidou M, Nelson P, Lamprinaki S, Sharma A, Mourelatos Z. Detection of MicroRNAs and assays to monitor MicroRNA activities in vivo and in vitro 2005; 309: 295-310.
[http://dx.doi.org/10.1385/1-59259-935-4:295]
[41]
Wang G, Kwan BC-H, Lai FM-M, et al. Intrarenal expression of miRNAs in patients with hypertensive nephrosclerosis. Am J Hypertens 2010; 23(1): 78-84.
[http://dx.doi.org/10.1038/ajh.2009.208]] [PMID: 19910931]
[42]
Chandrasekaran K, Karolina DS, Sepramaniam S, et al. Role of microRNAs in kidney homeostasis and disease. Kidney Int 2012; 81(7): 617-27.
[http://dx.doi.org/10.1038/ki.2011.448] [PMID: 22237749]
[43]
Hauser AB, Stinghen AEM, Kato S, et al. Characteristics and causes of immune dysfunction related to uremia and dialysis. Perit Dial Int 2008; 28(Suppl. 3): S183-7.
[PMID: 18552253]
[44]
Gobal F, Deshmukh A, Shah S, Mehta JL. Triad of metabolic syndrome, chronic kidney disease, and coronary heart disease with a focus on microalbuminuria death by overeating. J Am Coll Cardiol 2011; 57(23): 2303-8.
[http://dx.doi.org/10.1016/j.jacc.2011.02.027] [PMID: 21636030]
[45]
Valinezhad Orang A, Safaralizadeh R, Kazemzadeh-Bavili M. Mechanisms of miRNA-mediated gene regulation from common downregulation to mRNA-specific upregulation. Int J Genomics 2014; 2014970607
[http://dx.doi.org/10.1155/2014/970607] [PMID: 25180174]
[46]
Al-Chaqmaqchi HAM, Moshfegh A, Dadfar E, et al. Activation of Wnt/β-catenin pathway in monocytes derived from chronic kidney disease patients. PLoS One 2013; 8(7): e68937
[http://dx.doi.org/10.1371/journal.pone.0068937] [PMID: 23935909]
[47]
Scherer A, Günther OP, Balshaw RF, et al. Alteration of human blood cell transcriptome in uremia. BMC Med Genomics 2013; 6(1): 23.
[http://dx.doi.org/10.1186/1755-8794-6-23] [PMID: 23809614]
[48]
Zaza G, Granata S, Rascio F, et al. A specific immune transcriptomic profile discriminates chronic kidney disease patients in predialysis from hemodialyzed patients. BMC Med Genomics 2013; 6(1): 17.
[http://dx.doi.org/10.1186/1755-8794-6-17] [PMID: 23663527]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version253msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[17:55:14] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[17:55:14] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[17:55:14] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (89.83ms)time
  • Application (163ms)time
  • 1 x Application (64.52%)
    163ms
    1 x Booting (35.48%)
    89.83ms
    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 duplicated85.33ms
    • 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 ('59776939','',1,1739987714,1739987714) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739987714
      1.02msalphaeurekaselec_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 ('59776939','/article/100957',1,1739987714,1739987714)
      160μ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 >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) 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 >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) 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 >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) 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 >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) 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 >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) 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 >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59776939 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59776939) limit 1
      13.17msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59776939
      • 1: 59776939
      • 2: 59776939
      • 3: 59776939
      • 4: 59776939
      • 5: 59776939
      • 6: 59776939
      • 7: 59776939
      • 8: 59776939
      • 9: 59776939
      • 10: 59776939
      • 11: 59776939
      • 12: 59776939
      • 13: 59776939
      • 14: 59776939
      • 15: 59776939
      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=100957
      650μ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` = 65 limit 1
      720μsalphaeurekaselec_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`
      690μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=65) and sj.journal_id!=65 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      660μ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`
      2.67msalphaeurekaselec_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
      2.23msalphaeurekaselec_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` = '100957'
      1.06msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 100957
      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` = '100957'
      2.11msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 100957
      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` = '100957' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.46msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 100957
      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
      210μ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
      440μ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
      25.77msalphaeurekaselec_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
      7.99msalphaeurekaselec_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
      6.58msalphaeurekaselec_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` = 100957 limit 1
      250μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 100957
      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 = 100957 and content_type = 'article' order by status desc limit 1
      270μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 175053 limit 1
      220μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 175053
      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
      260μ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
      310μ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 = '100957' 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) )
      380μ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 = '9681' and content_type = 'i' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      340μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '2747' 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) )
      320μ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 <= 59776939 and j.to_ip >=59776939 )) and ((j.from_date <= 1739987714 and j.to_date >= 1739987714 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2747) 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 <= 59776939 and j.to_ip >=59776939 )) and ((j.from_date <= 1739987714 and j.to_date >= 1739987714 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2747) 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 <= 59776939 and j.to_ip >=59776939 )) and ((j.from_date <= 1739987714 and j.to_date >= 1739987714 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2747)
      4.56msalphaeurekaselec_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 <= 59776939 and j.to_ip >=59776939 )) and ((j.from_date <= 1739987714 and j.to_date >= 1739987714 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9681) 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 <= 59776939 and j.to_ip >=59776939 )) and ((j.from_date <= 1739987714 and j.to_date >= 1739987714 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9681) 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 <= 59776939 and j.to_ip >=59776939 )) and ((j.from_date <= 1739987714 and j.to_date >= 1739987714 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9681)
      550μ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 <= 59776939 and j.to_ip >=59776939 )) and ((j.from_date <= 1739987714 and j.to_date >= 1739987714 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100957) 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 <= 59776939 and j.to_ip >=59776939 )) and ((j.from_date <= 1739987714 and j.to_date >= 1739987714 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100957) 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 <= 59776939 and j.to_ip >=59776939 )) and ((j.from_date <= 1739987714 and j.to_date >= 1739987714 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100957)
      830μ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` < '144' and is_uploaded = 1 and issue_id = 9681 order by cast(first_page as SIGNED) desc limit 1
      630μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 144
      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` > '154' and is_uploaded = 1 and issue_id = 9681 order by cast(first_page as SIGNED) asc limit 1
      560μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 154
      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'
      220μ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
      260μ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` = 100957 limit 1
      3.84msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 100957
      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` <= 1739987714 and `b`.`banner_to_date` >= 1739987714 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.12msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 65
      • 3: 1739987714
      • 4: 1739987714
      • 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` <= 1739987714 and `b`.`banner_to_date` >= 1739987714 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.59msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 65
      • 3: 1739987714
      • 4: 1739987714
      • 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='4c67885435471ac33bc035f8b971dfdc'
      230μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        Y1dIJ2Fv6y2atQcHhnhoiHFM8ha3lrhZXvY6yWQE
        uc_cart_id
        4c67885435471ac33bc035f8b971dfdc
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/100957" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/100957
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:9 [ "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6IndLdGJxWmVCN042ZGplY0xTaE9FOFE9PSIsInZhbHVlIjoicWZyNVVINFhQa3g0UklKR3FWbWcybFIycXB4cmZGd3RKazd6WmFHcWEzZz0iLCJtYWMiOiJlMjE4MTg1ZDllYzM2Y2Q0ZTZhOGIwMWQyYzEyMWQ2ZDllMjhjZDY5ZDQ3Yjg1OTU4NzIyYThhYzAwOTcxM2I4IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IndLdGJxWmVCN042ZGplY0xTaE9FOFE9PSIsInZhbHVlIjoicWZyNVVINFhQa3g0UklKR3FWbWcybFIycXB4cmZGd3RKazd6WmFHcWEzZz0iLCJtYWMiOiJlMjE4MTg1ZDllYzM2" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 19 Feb 2025 17:55:14 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjFhYXNNYnRReVJUbS9YaGVVRHJrMmc9PSIsInZhbHVlIjoiUEViN01Zcy9PME5FNmdFNzdXVllsQ0pDbTlwMnVyODF1TFRRaXlNYmo3Tzk5eDlUZS91K3djajE2dFltQ2V0aE5VNTVTZ3dYQzBLWEI5RkRTS3l1M0RSb2lRTGg1ZDZiYUd0a0c5RmYxQk5QOTViTUVtVW1wZk4yNlVGRzM4NFAiLCJtYWMiOiJkMWFmNzY1NzgwOTZlZDU0N2I1MTMzNmUyNTQ0ODE1NGUwYTEwYmEwNWJlZmQ3YjU4NjU2ZjY1NjA0ODIyY2U4IiwidGFnIjoiIn0%3D; expires=Sat, 22 Feb 2025 05:55:14 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjFhYXNNYnRReVJUbS9YaGVVRHJrMmc9PSIsInZhbHVlIjoiUEViN01Zcy9PME5FNmdFNzdXVllsQ0pDbTlwMnVyODF1TFRRaXlNYmo3Tzk5eDlUZS91K3djajE2dFltQ2V0aE5VNTVTZ" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ik03OUtFUS9TRlFxNUZJcm5namQyOXc9PSIsInZhbHVlIjoiNk5lTzdicGtIY2FaemVmTUJWWjFrMThKcDJHOVFSRXlaWG9ZR3o3N2hWK1ZXZytUdWVHcU9rUTI0aENxVzZ2U2lybnZ3MmFGbXMzSDE5enlPT2JKbFFrV2VwQzRVSVBpelVpZk1oM0JBVUlESHlWVnRydWNkczdDVzBERHg5WGQiLCJtYWMiOiI0YzcwYjU2NTliMDZkZGMyMjI2NzdhZTlkMzk0OWYwYjJhYTE3ZDFhYTc0ZDQxYTU1NDJhMjYwMTRkN2RjNTczIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ik03OUtFUS9TRlFxNUZJcm5namQyOXc9PSIsInZhbHVlIjoiNk5lTzdicGtIY2FaemVmTUJWWjFrMThKcDJHOVFSRXlaWG9ZR3o3N2hWK1ZXZytUdWVHcU9rUTI" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjFhYXNNYnRReVJUbS9YaGVVRHJrMmc9PSIsInZhbHVlIjoiUEViN01Zcy9PME5FNmdFNzdXVllsQ0pDbTlwMnVyODF1TFRRaXlNYmo3Tzk5eDlUZS91K3djajE2dFltQ2V0aE5VNTVTZ3dYQzBLWEI5RkRTS3l1M0RSb2lRTGg1ZDZiYUd0a0c5RmYxQk5QOTViTUVtVW1wZk4yNlVGRzM4NFAiLCJtYWMiOiJkMWFmNzY1NzgwOTZlZDU0N2I1MTMzNmUyNTQ0ODE1NGUwYTEwYmEwNWJlZmQ3YjU4NjU2ZjY1NjA0ODIyY2U4IiwidGFnIjoiIn0%3D; expires=Sat, 22-Feb-2025 05:55:14 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjFhYXNNYnRReVJUbS9YaGVVRHJrMmc9PSIsInZhbHVlIjoiUEViN01Zcy9PME5FNmdFNzdXVllsQ0pDbTlwMnVyODF1TFRRaXlNYmo3Tzk5eDlUZS91K3djajE2dFltQ2V0aE5VNTVTZ" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ik03OUtFUS9TRlFxNUZJcm5namQyOXc9PSIsInZhbHVlIjoiNk5lTzdicGtIY2FaemVmTUJWWjFrMThKcDJHOVFSRXlaWG9ZR3o3N2hWK1ZXZytUdWVHcU9rUTI0aENxVzZ2U2lybnZ3MmFGbXMzSDE5enlPT2JKbFFrV2VwQzRVSVBpelVpZk1oM0JBVUlESHlWVnRydWNkczdDVzBERHg5WGQiLCJtYWMiOiI0YzcwYjU2NTliMDZkZGMyMjI2NzdhZTlkMzk0OWYwYjJhYTE3ZDFhYTc0ZDQxYTU1NDJhMjYwMTRkN2RjNTczIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ik03OUtFUS9TRlFxNUZJcm5namQyOXc9PSIsInZhbHVlIjoiNk5lTzdicGtIY2FaemVmTUJWWjFrMThKcDJHOVFSRXlaWG9ZR3o3N2hWK1ZXZytUdWVHcU9rUTI" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "Y1dIJ2Fv6y2atQcHhnhoiHFM8ha3lrhZXvY6yWQE" "uc_cart_id" => "4c67885435471ac33bc035f8b971dfdc" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/100957" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-19 17:55:14GET/article/100957314361