Research Article

整合突变和表达数据识别2型糖尿病相关基因特征

卷 22, 期 1, 2022

发表于: 07 July, 2021

页: [51 - 58] 页: 8

弟呕挨: 10.2174/1566523221666210707140839

价格: $65

摘要

病人。随着测序技术的发展,从表达数据中鉴定出了大量的差异表达基因。然而,机器学习的方法只能识别局部最优解作为签名。 目的:通过遗传获得的突变信息能更好地反映基因与疾病之间的关系。因此,我们需要整合突变信息来更准确地识别签名。 为此,我们整合Genome-Wide Association Study (GWAS)数据和表达数据,并结合表达定量性状位点(expression Quantitative Trait Loci, eQTL)技术,得到T2DM预测特征(t2dmsg -10)。首先,我们利用GWAS数据得到T2DM易感基因座列表。然后,利用eQTL技术获取风险单核苷酸多态性(SNPs),并结合胰腺β-细胞基因表达数据获得10个蛋白编码基因。接下来,我们将这些基因以相同的重量组合在一起。 结果:采用受试者工作特征(Receiver Operating Characteristic, ROC)、单基因去除与增加法、基因本体论功能富集法和蛋白-蛋白相互作用网络验证结果显示,t2dmsg -10对T2DM具有良好的预测效果(AUC=0.99),且具有较高的鲁棒性。 结论:总之,我们获得了T2DM的预测特征,并进一步进行了验证。

关键词: 2型糖尿病,全基因组关联研究,表达定量性状位点,预测特征,AUC=0.99, ROC。

图形摘要

[1]
Faselis C, Katsimardou A, Imprialos K, Deligkaris P, Kallistratos M, Dimitriadis K. Microvascular complications of type 2 diabetes mellitus. Curr Vasc Pharmacol 2020; 18(2): 117-24.
[http://dx.doi.org/10.2174/1570161117666190502103733] [PMID: 31057114]
[2]
Cheng L, Qi C, Zhuang H, Fu T, Zhang X. gutMDisorder: A comprehensive database for dysbiosis of the gut microbiota in disorders and interventions. Nucleic Acids Res 2020; 48(D1): D554-60.
[http://dx.doi.org/10.1093/nar/gkz843] [PMID: 31584099]
[3]
Barron E, Bakhai C, Kar P, et al. Associations of type 1 and type 2 diabetes with COVID-19-related mortality in England: A whole-population study. Lancet Diabetes Endocrinol 2020; 8(10): 813-22.
[http://dx.doi.org/10.1016/S2213-8587(20)30272-2] [PMID: 32798472]
[4]
Cheng L, Zhuang H, Ju H, et al. Exposing the causal effect of body mass index on the risk of type 2 diabetes mellitus: A mendelian randomization study. Front Genet 2019; 10: 94.
[http://dx.doi.org/10.3389/fgene.2019.00094] [PMID: 30891058]
[5]
GWAS to the people. Nat Med 2018; 24(10): 1483.
[http://dx.doi.org/10.1038/s41591-018-0231-3] [PMID: 30297896]
[6]
Zou Q, Qu K, Luo Y, Yin D, Ju Y, Tang H. Predicting diabetes mellitus with machine learning techniques. Front Genet 2018; 9: 515.
[http://dx.doi.org/10.3389/fgene.2018.00515] [PMID: 30459809]
[7]
Auton A, Brooks LD, Durbin RM, et al. A global reference for human genetic variation. Nature 2015; 526(7571): 68-74.
[http://dx.doi.org/10.1038/nature15393] [PMID: 26432245]
[8]
Frazer KA, Ballinger DG, Cox DR, et al. A second generation human haplotype map of over 3.1 million SNPs. Nature 2007; 449(7164): 851-61.
[http://dx.doi.org/10.1038/nature06258] [PMID: 17943122]
[9]
Ding L, Fan L, Xu X, Fu J, Xue Y. Identification of core genes and pathways in type 2 diabetes mellitus by bioinformatics analysis. Mol Med Rep 2019; 20(3): 2597-608.
[http://dx.doi.org/10.3892/mmr.2019.10522] [PMID: 31524257]
[10]
Cheng L, Hu Y. Human disease system biology. Curr Gene Ther 2018; 18(5): 255-6.
[http://dx.doi.org/10.2174/1566523218666181010101114] [PMID: 30306867]
[11]
Zou Q, Li J, Song L, Zeng X, Wang G. Similarity computation strategies in the microRNA-disease network: A survey. Brief Funct Genomics 2016; 15(1): 55-64.
[PMID: 26134276]
[12]
Cheng L, Zhao H, Wang P, et al. Computational methods for identifying similar diseases. Mol Ther Nucleic Acids 2019; 18: 590-604.
[http://dx.doi.org/10.1016/j.omtn.2019.09.019] [PMID: 31678735]
[13]
Cheng L. Computational and biological methods for gene therapy. Curr Gene Ther 2019; 19(4): 210.
[http://dx.doi.org/10.2174/156652321904191022113307] [PMID: 31762421]
[14]
Zhang X, Zou Q, Rodriguez-Paton A, Zeng X. Meta-path methods for prioritizing candidate disease miRNAs. IEEE/ACM Trans Comput Biol Bioinformatics 2019; 16(1): 283-91.
[http://dx.doi.org/10.1109/TCBB.2017.2776280] [PMID: 29990255]
[15]
Yang F, Zou Q. mAML: An automated machine learning pipeline with a microbiome repository for human disease classification. Database (Oxford) 2020. baaa050
[http://dx.doi.org/10.1093/database/baaa050] [PMID: 32588040]
[16]
Morris AP, Voight BF, Teslovich TM, et al. Large-scale association analysis provides insights into the genetic architecture and pathophysiology of type 2 diabetes. Nat Genet 2012; 44(9): 981-90.
[http://dx.doi.org/10.1038/ng.2383] [PMID: 22885922]
[17]
Pal LR, Yu C-H, Mount SM, Moult J. Insights from GWAS: Emerging landscape of mechanisms underlying complex trait disease. BMC Genomics 2015; 16(Suppl. 8): S4.
[http://dx.doi.org/10.1186/1471-2164-16-S8-S4] [PMID: 26110739]
[18]
Sherry ST, Ward MH, Kholodov M, et al. dbSNP: The NCBI database of genetic variation. Nucleic Acids Res 2001; 29(1): 308-11.
[http://dx.doi.org/10.1093/nar/29.1.308] [PMID: 11125122]
[19]
Zhang ZM, Tan JX, Wang F, Dao FY, Zhang ZY, Lin H. Early diagnosis of hepatocellular carcinoma using machine learning method. Front Bioeng Biotechnol 2020; 8: 254.
[http://dx.doi.org/10.3389/fbioe.2020.00254] [PMID: 32292778]
[20]
Dao FY, Lv H, Zulfiqar H, et al. A computational platform to identify origins of replication sites in eukaryotes. Brief Bioinform 2021; 22(2): 1940-50.
[http://dx.doi.org/10.1093/bib/bbaa017] [PMID: 32065211]
[21]
Krentz NAJ, Gloyn AL. Insights into pancreatic islet cell dysfunction from type 2 diabetes mellitus genetics. Nat Rev Endocrinol 2020; 16(4): 202-12.
[http://dx.doi.org/10.1038/s41574-020-0325-0] [PMID: 32099086]
[22]
Ritchie ME, Phipson B, Wu D, et al. limma powers differential expression analyses for RNA-sequencing and microarray studies. Nucleic Acids Res 2015; 43(7)e47
[http://dx.doi.org/10.1093/nar/gkv007] [PMID: 25605792]
[23]
Liang J. Protective effects of an obesity-associated polymorphism (cdkal1 rs9356744) on prediabetes: The cardiometabolic risk in chinese (CRC) Study. Experimental and clinical endocrinology & diabetes : Official journal, german society of endocrinology [and] german diabetes association 2018; 126(9): 540-.
[http://dx.doi.org/10.1055/s-0042-109607] [PMID: 29933462]
[24]
Montesanto A, Bonfigli AR, Crocco P, et al. Genes associated with type 2 diabetes and vascular complications. Aging (Albany NY) 2018; 10(2): 178-96.
[http://dx.doi.org/10.18632/aging.101375] [PMID: 29410390]
[25]
Robin X, Turck N, Hainard A, et al. pROC: An open-source package for R and S+ to analyze and compare ROC curves. BMC Bioinformatics 2011; 12: 77.
[http://dx.doi.org/10.1186/1471-2105-12-77] [PMID: 21414208]
[26]
Masini M, Martino L, Marselli L, et al. Ultrastructural alterations of pancreatic beta cells in human diabetes mellitus. Diabetes Metab Res Rev 2017; 33(6)
[http://dx.doi.org/10.1002/dmrr.2894] [PMID: 28303682]
[27]
Johnson SR, Leo P, Conwell LS, Harris M, Brown MA, Duncan EL. Clinical usefulness of comprehensive genetic screening in maturity onset diabetes of the young (MODY): A novel ABCC8 mutation in a previously screened family. J Diabetes 2018; 10(9): 764-7.
[http://dx.doi.org/10.1111/1753-0407.12778] [PMID: 29726111]
[28]
Huang DW, Sherman BT, Lempicki RA. “Bioinformatics enrichment tools: Paths toward the comprehensive functional analysis of large gene lists,” (in eng). Nucleic Acids Res 2009; 37(1)
[http://dx.doi.org/10.1093/nar/gkn923]
[29]
Szklarczyk D, Gable AL, Lyon D, et al. STRING v11: Protein-protein association networks with increased coverage, supporting functional discovery in genome-wide experimental datasets. Nucleic Acids Res 2019; 47(D1): D607-13.
[http://dx.doi.org/10.1093/nar/gky1131] [PMID: 30476243]
[30]
Amin S, Cook B, Zhou T, et al. Discovery of a drug candidate for GLIS3-associated diabetes. Nat Commun 2018; 9(1): 2681.
[http://dx.doi.org/10.1038/s41467-018-04918-x] [PMID: 29992946]
[31]
Kumar S, Aswal VK, Agrawal RP, et al. SNP in KCNQ1 gene is associated with susceptibility to diabetic nephropathy in subjects with type 2 diabetes in india. J Assoc Physicians India 2018; 66(8): 58-61.
[PMID: 31324086]
[32]
Dwivedi OP, Lehtovirta M, Hastoy B, et al. Loss of ZnT8 function protects against diabetes by enhanced insulin secretion. Nat Genet 2019; 51(11): 1596-606.
[http://dx.doi.org/10.1038/s41588-019-0513-9] [PMID: 31676859]
[33]
Machado-Silva W, Tonet-Furioso AC, Gomes L, Córdova C, Moraes CF, Nóbrega OT. The rs4430796 SNP of the HNF1β gene associates with type 2 diabetes in older adults Revista da associacao medica brasileira (1992) 2018; 64: pp.(7): 586-9.
[http://dx.doi.org/10.1590/1806-9282.64.07.586]
[34]
Lv H, et al. iDNA-MS: An integrated computational tool for detecting dna modification sites in multiple genomes. iScience 2020; 23(4): 100991.
[http://dx.doi.org/10.1016/j.isci.2020.100991]
[35]
Yang H, Lv H, Ding H, Chen W, Lin H. iRNA-2OM: A sequence-based predictor for identifying 2′-o-methylation sites in homo sapiens. J Comput Biol 2018; 25(11): 1266-77.
[http://dx.doi.org/10.1089/cmb.2018.0004] [PMID: 30113871]
[36]
Peng J, Hui W, Li Q, et al. A learning-based framework for miRNA-disease association identification using neural networks. Bioinformatics 2019; 35(21): 4364-71.
[http://dx.doi.org/10.1093/bioinformatics/btz254] [PMID: 30977780]
[37]
Peng J, Xue H, Wei Z, Tuncali I, Hao J, Shang X. Integrating multi-network topology for gene function prediction using deep neural networks. Brief Bioinform 2021; 22(2): 2096-105.
[http://dx.doi.org/10.1093/bib/bbaa036] [PMID: 32249297]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version340msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:07:59] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:07:59] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:07:59] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:07:59] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (105ms)time
  • Application (235ms)time
  • 1 x Application (69.18%)
    235ms
    1 x Booting (30.82%)
    105ms
    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
    40 statements were executed, 4 of which were duplicates, 36 unique. Show only duplicated143ms
    • 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 ('309813860','',1,1740514079,1740514079) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740514079
      1.4msalphaeurekaselec_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 ('309813860','/article/116530/cn',1,1740514079,1740514079)
      250μ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 >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) 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 >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) 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 >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) 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 >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) 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 >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) 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 >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 309813860 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309813860) limit 1
      18.75msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 309813860
      • 1: 309813860
      • 2: 309813860
      • 3: 309813860
      • 4: 309813860
      • 5: 309813860
      • 6: 309813860
      • 7: 309813860
      • 8: 309813860
      • 9: 309813860
      • 10: 309813860
      • 11: 309813860
      • 12: 309813860
      • 13: 309813860
      • 14: 309813860
      • 15: 309813860
      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=116530
      920μ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` = 28 limit 1
      1.21msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 28
      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=28) and sj.journal_id!=28 group by `j`.`nid`) as `aggregate_table`
      1.12msalphaeurekaselec_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=28) and sj.journal_id!=28 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.02msalphaeurekaselec_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=28) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      4.27msalphaeurekaselec_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=28) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      3.63msalphaeurekaselec_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` = '116530'
      460μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 116530
      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` = '116530'
      1.95msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 116530
      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` = '116530' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.2msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 116530
      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
      350μ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
      760μ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 = 28 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      43.45msalphaeurekaselec_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 = 28 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      7.56msalphaeurekaselec_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 = 28 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      6.18msalphaeurekaselec_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` = 116530 limit 1
      360μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 116530
      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 = 116530 and content_type = 'article' order by status desc limit 1
      410μ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` = 194572 limit 1
      280μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 194572
      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
      310μ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` = 'CGT' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      400μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CGT
      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 = '116530' 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) )
      660μ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 = '11200' and content_type = 'i' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      440μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '3245' 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) )
      410μ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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1740514079 and j.to_date >= 1740514079 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3245) 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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1740514079 and j.to_date >= 1740514079 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3245) 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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1740514079 and j.to_date >= 1740514079 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3245)
      13.9msalphaeurekaselec_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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1740514079 and j.to_date >= 1740514079 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11200) 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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1740514079 and j.to_date >= 1740514079 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11200) 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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1740514079 and j.to_date >= 1740514079 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11200)
      910μ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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1740514079 and j.to_date >= 1740514079 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 116530) 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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1740514079 and j.to_date >= 1740514079 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 116530) 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 <= 309813860 and j.to_ip >=309813860 )) and ((j.from_date <= 1740514079 and j.to_date >= 1740514079 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 116530)
      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` < '51' and is_uploaded = 1 and issue_id = 11200 order by cast(first_page as SIGNED) desc limit 1
      610μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 51
      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` > '58' and is_uploaded = 1 and issue_id = 11200 order by cast(first_page as SIGNED) asc limit 1
      550μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 58
      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` = 'cn'
      210μsalphaeurekaselec_live_10_06_2022ArticleController.php#2486
      Bindings
      • 0: cn
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2486
      • 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` = 2
      280μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 2
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2487
      • 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 `multilanguage_article` where (`language_id` = 2 and `article_id` = 116530)
      9.18msalphaeurekaselec_live_10_06_2022ArticleController.php#2488
      Bindings
      • 0: 2
      • 1: 116530
      Backtrace
      • 15. app/Http/Controllers/ArticleController.php:2488
      • 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
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `keyword` from `multilanguage_keywords` where (`language_id` = 2 and `article_id` = 116530)
      4.38msalphaeurekaselec_live_10_06_2022ArticleController.php#2489
      Bindings
      • 0: 2
      • 1: 116530
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2489
      • 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 CONCAT_WS(' ',au.first_name, ' ', ifnull(au.initials,''), ' ', au.last_name) as authors, CONCAT_WS(' ',au.last_name, ', ', ifnull(au.initials,''), ' ', au.first_name) as authorsRIS, CONCAT_WS(' ',au.last_name, ' ', ifnull(au.initials,''), ' ', au.first_name) as authorsCiteAs , `au`.*, (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 `multilanguage_authors` as `au` left join `multilanguage_author_affiliation` as `af` on `au`.`id` = `af`.`author_id` where `au`.`article_id` = 116530 group by `au`.`id` order by `au`.`article_id` asc, `au`.`sequence` asc
      6.43msalphaeurekaselec_live_10_06_2022MultiLangAuthor.php#30
      Bindings
      • 0: 116530
      Backtrace
      • 13. app/Models/MultiLangAuthor.php:30
      • 14. app/Http/Controllers/ArticleController.php:2493
      • 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 `multilanguage_journal`.`title` from `multilanguage_journal` where `multilanguage_journal`.`journal_id` = 28 and `language_id` = 2
      300μsalphaeurekaselec_live_10_06_2022ArticleController.php#2495
      Bindings
      • 0: 28
      • 1: 2
      Backtrace
      • 13. app/Http/Controllers/ArticleController.php:2495
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `id` from `multilanguage_article` where `article_id` = 116530 limit 1
      3.75msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 116530
      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` = 28 and `b`.`banner_from_date` <= 1740514079 and `b`.`banner_to_date` >= 1740514079 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.54msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 28
      • 3: 1740514079
      • 4: 1740514079
      • 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` = 28 and `b`.`banner_from_date` <= 1740514079 and `b`.`banner_to_date` >= 1740514079 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.11msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 28
      • 3: 1740514079
      • 4: 1740514079
      • 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='dc3c764ca7375ba85af3485533b7d50e'
      200μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLangArticle
    2MultiLangArticle.php#?
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        l4ijurEzb8VgniwMUJvrpVbbapcfd5seqpPGJ8Oy
        uc_cart_id
        dc3c764ca7375ba85af3485533b7d50e
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/116530/cn" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/116530/cn
        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=eyJpdiI6InV1WlZPaVpYS3ZRWVJYaDk5TjdqQnc9PSIsInZhbHVlIjoicktoOWNzVGdKd3hqRjJEdURUaXBXSHVzUVNadU1PeVlBQmNFeGJLdkhjND0iLCJtYWMiOiI3NDY0MDJiMDdiODYxNzhlZWZiYWViYTNiODAxMTZhY2Y1NDUzNWI3YTI5ZDZlMmIwNzg3OThlMTFiNDVkNTNlIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6InV1WlZPaVpYS3ZRWVJYaDk5TjdqQnc9PSIsInZhbHVlIjoicktoOWNzVGdKd3hqRjJEdURUaXBXSHVzUVNadU1PeVlBQmNFeGJLdkhjND0iLCJtYWMiOiI3NDY0MDJiMDdiODYx" ] "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 => "Tue, 25 Feb 2025 20:07:59 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlEzT0ZFdGt4Uk5JY2MwWkV4cFY0M3c9PSIsInZhbHVlIjoiRUtjLzBZdzY1V1pYSGk5RHg5akJOZGh1Wm9mR3pFZFo3QjZJd0M0SFR0eVNLSFoxa0M2dWJwMDFLUWxSa2hRVU1GOFcwRlBhWnlSYVFzRzdjdFVYT1cydlpDaW4vU0RwNGFwcVp2Q2J2VDV1TGRFZzN1Qm8vT2lMbm9BeEtpMlIiLCJtYWMiOiJmZDRmZWExZDU4MjAyZWRiYTc2ZmIxMDYzYzMxNTAyNTE4YTdmYzQ5NmVmNjY2ZjNhOTY2NGNjY2RlNGIxMjA3IiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 08:07:59 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlEzT0ZFdGt4Uk5JY2MwWkV4cFY0M3c9PSIsInZhbHVlIjoiRUtjLzBZdzY1V1pYSGk5RHg5akJOZGh1Wm9mR3pFZFo3QjZJd0M0SFR0eVNLSFoxa0M2dWJwMDFLUWxSa2hRVU1GOFcwR" 1 => "alphaeurekaselectnet_session=eyJpdiI6InNySWpFd1IxSXkzdkNaQmpPN3pBbHc9PSIsInZhbHVlIjoiYXBBN2dpZWQ3KzFTaWNEU2hLTEpyQ2JHME1ROE53TnpLRSszaU5JdkRCVWtKVkp4NG5lNjBVSXpiclRRcWNCZDg4emt3TDgwK2ZJc0R3VW1yNEhNSURKYk94RzNJTGdUVi9yR2lSWVh6UHloTW8weVJwUzVxR1NCK1c0YWV2OEwiLCJtYWMiOiI0MjA0YTFmNTAyY2YzNzg5Y2JjZTQyZWNiMzFiOTViNmJhODEyMTJmOWViMDlkMzcwMGEzZDdhM2JjZGUwMmU4IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6InNySWpFd1IxSXkzdkNaQmpPN3pBbHc9PSIsInZhbHVlIjoiYXBBN2dpZWQ3KzFTaWNEU2hLTEpyQ2JHME1ROE53TnpLRSszaU5JdkRCVWtKVkp4NG5lNjBVSXp" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlEzT0ZFdGt4Uk5JY2MwWkV4cFY0M3c9PSIsInZhbHVlIjoiRUtjLzBZdzY1V1pYSGk5RHg5akJOZGh1Wm9mR3pFZFo3QjZJd0M0SFR0eVNLSFoxa0M2dWJwMDFLUWxSa2hRVU1GOFcwRlBhWnlSYVFzRzdjdFVYT1cydlpDaW4vU0RwNGFwcVp2Q2J2VDV1TGRFZzN1Qm8vT2lMbm9BeEtpMlIiLCJtYWMiOiJmZDRmZWExZDU4MjAyZWRiYTc2ZmIxMDYzYzMxNTAyNTE4YTdmYzQ5NmVmNjY2ZjNhOTY2NGNjY2RlNGIxMjA3IiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 08:07:59 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlEzT0ZFdGt4Uk5JY2MwWkV4cFY0M3c9PSIsInZhbHVlIjoiRUtjLzBZdzY1V1pYSGk5RHg5akJOZGh1Wm9mR3pFZFo3QjZJd0M0SFR0eVNLSFoxa0M2dWJwMDFLUWxSa2hRVU1GOFcwR" 1 => "alphaeurekaselectnet_session=eyJpdiI6InNySWpFd1IxSXkzdkNaQmpPN3pBbHc9PSIsInZhbHVlIjoiYXBBN2dpZWQ3KzFTaWNEU2hLTEpyQ2JHME1ROE53TnpLRSszaU5JdkRCVWtKVkp4NG5lNjBVSXpiclRRcWNCZDg4emt3TDgwK2ZJc0R3VW1yNEhNSURKYk94RzNJTGdUVi9yR2lSWVh6UHloTW8weVJwUzVxR1NCK1c0YWV2OEwiLCJtYWMiOiI0MjA0YTFmNTAyY2YzNzg5Y2JjZTQyZWNiMzFiOTViNmJhODEyMTJmOWViMDlkMzcwMGEzZDdhM2JjZGUwMmU4IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6InNySWpFd1IxSXkzdkNaQmpPN3pBbHc9PSIsInZhbHVlIjoiYXBBN2dpZWQ3KzFTaWNEU2hLTEpyQ2JHME1ROE53TnpLRSszaU5JdkRCVWtKVkp4NG5lNjBVSXp" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "l4ijurEzb8VgniwMUJvrpVbbapcfd5seqpPGJ8Oy" "uc_cart_id" => "dc3c764ca7375ba85af3485533b7d50e" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/116530/cn" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 20:07:59GET/article/116530/cn414403