Generic placeholder image

Current Bioinformatics

Editor-in-Chief

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

Research Article

Prediction of Plant Ubiquitylation Proteins and Sites by Fusing Multiple Features

Author(s): Meng-Yue Guan, Wang-Ren Qiu*, Qian-Kun Wang and Xuan Xiao*

Volume 19, Issue 5, 2024

Published on: 20 November, 2023

Page: [458 - 469] Pages: 12

DOI: 10.2174/1574893618666230908092847

Price: $65

Abstract

Introduction: Protein ubiquitylation is an important post-translational modification (PTM), which is considered to be one of the most important processes regulating cell function and various diseases. Therefore, accurate prediction of ubiquitylation proteins and their PTM sites is of great significance for the study of basic biological processes and the development of related drugs. Researchers have developed some large-scale computational methods to predict ubiquitylation sites, but there is still much room for improvement. Much of the research related to ubiquitylation is cross-species while the life pattern is diversified, and the prediction method always shows its specificity in practical application. This study just aims at the issue of plants and has constructed computational methods for identifying ubiquitylation protein and ubiquitylation sites.

Methods: In this work, we constructed two predictive models to identify plant ubiquitylation proteins and sites. First, in the ubiquitylation proteins prediction model, in order to better reflect protein sequence information and obtain better prediction results, the KNN scoring matrix model based on functional domain Gene Ontology (GO) annotation and word embedding model, i.e. Skip-Gram and Continuous Bag of Words (CBOW), are used to extract the features, and the light gradient boosting machine (LGBM) is selected as the ubiquitylation proteins prediction engine.

Results: As a result, accuracy (ACC), Precision, recall rate (Recall), F1_score and AUC are respectively 85.12%, 80.96%, 72.80%, 76.37% and 0.9193 in the 10-fold cross-validations on independent dataset. In the ubiquitylation sites prediction model, Skip-Gram, CBOW and enhanced amino acid composition (EAAC) feature extraction codes were used to extract protein sequence fragment features, and the predicted results on training and independent test data have also achieved good performance.

Conclusion: In a word, the comparison results demonstrate that our models have a decided advantage in predicting ubiquitylation proteins and sites, and it may provide useful insights for studying the mechanisms and modulation of ubiquitination pathways. The datasets and source codes used in this study are available at: https://github.com/gmywqk/Ub-PS-Fuse.

[1]
He D, Li M, Damaris RN, Bu C, Xue J, Yang P. Quantitative ubiquitylomics approach for characterizing the dynamic change and extensive modulation of ubiquitylation in rice seed germination. Plant J 2020; 101(6): 1430-47.
[http://dx.doi.org/10.1111/tpj.14593] [PMID: 31677306]
[2]
Yadav S, Gupta M, Bist AS. Prediction of ubiquitination sites using UbiNets. Adv Fuzzy Syst 2018; 2018: 1-10.
[http://dx.doi.org/10.1155/2018/5125103]
[3]
Xu G, Jaffrey SR. The new landscape of protein ubiquitination. Nat Biotechnol 2011; 29(12): 1098-100.
[http://dx.doi.org/10.1038/nbt.2061] [PMID: 22158364]
[4]
Starita L, Parvin JD. The multiple nuclear functions of BRCA1: Transcription, ubiquitination and DNA repair. Curr Opin Cell Biol 2003; 15(3): 345-50.
[http://dx.doi.org/10.1016/S0955-0674(03)00042-5] [PMID: 12787778]
[5]
Park HB, Kim JW, Baek KH. Regulation of Wnt signaling through ubiquitination and deubiquitination in cancers. Int J Mol Sci 2020; 21(11): 3904.
[http://dx.doi.org/10.3390/ijms21113904] [PMID: 32486158]
[6]
Porro A, Berti M, Pizzolato J, et al. FAN1 interaction with ubiquitylated PCNA alleviates replication stress and preserves genomic integrity independently of BRCA2. Nat Commun 2017; 8(1): 1073.
[http://dx.doi.org/10.1038/s41467-017-01074-6] [PMID: 29051491]
[7]
Stankovic-Valentin N, Melchior F. Control of SUMO and Ubiquitin by ROS: Signaling and disease implications. Mol Aspects Med 2018; 63: 3-17.
[http://dx.doi.org/10.1016/j.mam.2018.07.002] [PMID: 30059710]
[8]
Corn JE, Vucic D. Ubiquitin in inflammation: The right linkage makes all the difference. Nat Struct Mol Biol 2014; 21(4): 297-300.
[http://dx.doi.org/10.1038/nsmb.2808] [PMID: 24699077]
[9]
Tung CW, Ho SY. Computational identification of ubiquitylation sites from protein sequences. BMC Bioinformatics 2008; 9(1): 310.
[http://dx.doi.org/10.1186/1471-2105-9-310] [PMID: 18625080]
[10]
Tsuchida S, Satoh M, Takiwaki M, Nomura F. Ubiquitination in periodontal disease: A review. Int J Mol Sci 2017; 18(7): 1476.
[http://dx.doi.org/10.3390/ijms18071476] [PMID: 28698506]
[11]
Chan CH, Jo U, Kohrman A, et al. Posttranslational regulation of Akt in human cancer. Cell Biosci 2014; 4(1): 59.
[http://dx.doi.org/10.1186/2045-3701-4-59] [PMID: 25309720]
[12]
Schmidt MF, Gan ZY, Komander D, Dewson G. Ubiquitin signalling in neurodegeneration: Mechanisms and therapeutic opportunities. Cell Death Differ 2021; 28(2): 570-90.
[http://dx.doi.org/10.1038/s41418-020-00706-7] [PMID: 33414510]
[13]
Yamada T, Murata D, Adachi Y, et al. Mitochondrial stasis reveals p62-mediated ubiquitination in Parkin-independent mitophagy and mitigates nonalcoholic fatty liver disease. Cell Metab 2018; 28(4): 588-604.e5.
[http://dx.doi.org/10.1016/j.cmet.2018.06.014] [PMID: 30017357]
[14]
Lu D, Lin W, Gao X, et al. Direct ubiquitination of pattern recognition receptor FLS2 attenuates plant innate immunity. Science 2011; 332(6036): 1439-42.
[http://dx.doi.org/10.1126/science.1204903] [PMID: 21680842]
[15]
Marino D, Peeters N, Rivas S. Ubiquitination during plant immune signaling. Plant Physiol 2012; 160(1): 15-27.
[http://dx.doi.org/10.1104/pp.112.199281] [PMID: 22689893]
[16]
Li F, Zhang Y, Purcell AW, et al. Positive-unlabelled learning of glycosylation sites in the human proteome. BMC Bioinformatics 2019; 20(1): 112.
[http://dx.doi.org/10.1186/s12859-019-2700-1] [PMID: 30841845]
[17]
Luo F, Wang M, Liu Y, Zhao XM, Li A. DeepPhos: Prediction of protein phosphorylation sites with deep learning. Bioinformatics 2019; 35(16): 2766-73.
[http://dx.doi.org/10.1093/bioinformatics/bty1051] [PMID: 30601936]
[18]
Chen X, Qiu JD, Shi SP, Suo SB, Huang SY, Liang RP. Incorporating key position and amino acid residue features to identify general and species-specific Ubiquitin conjugation sites. Bioinformatics 2013; 29(13): 1614-22.
[http://dx.doi.org/10.1093/bioinformatics/btt196] [PMID: 23626001]
[19]
Qiu W, Xu C, Xiao X, Xu D. Computational prediction of ubiquitination proteins using evolutionary profiles and functional domain annotation. Curr Genomics 2019; 20(5): 389-99.
[http://dx.doi.org/10.2174/1389202919666191014091250] [PMID: 32476995]
[20]
Qiu WR, Sun BQ, Xiao X, Xu D, Chou KC. iPhos-PseEvo: Identifying human phosphorylated proteins by incorporating evolutionary information into general PseAAC via grey system theory. Mol Inform 2017; 36(5-6): 1600010.
[http://dx.doi.org/10.1002/minf.201600010] [PMID: 28488814]
[21]
Qiu WR, Xu A, Xu ZC, Zhang CH, Xiao X. Identifying acetylation protein by fusing its PseAAC and functional domain annotation. Front Bioeng Biotechnol 2019; 7: 311.
[http://dx.doi.org/10.3389/fbioe.2019.00311] [PMID: 31867311]
[22]
Qiu W-R, Wang Q-K, Guan M-Y, Jia J-H, Xiao X. Predicting S-nitrosylation proteins and sites by fusing multiple features. Math Biosci Eng 2021; 18(6): 9132-47.
[http://dx.doi.org/10.3934/mbe.2021450] [PMID: 34814339]
[23]
Qiu WR, Guan MY, Wang QK, Lou LL, Xiao X. Identifying pupylation proteins and sites by incorporating multiple methods. Front Endocrinol 2022; 13: 849549.
[http://dx.doi.org/10.3389/fendo.2022.849549] [PMID: 35557849]
[24]
Wang H, Wang Z, Li Z, Lee TY. Incorporating deep learning with word embedding to identify plant ubiquitylation sites. Front Cell Dev Biol 2020; 8: 572195.
[http://dx.doi.org/10.3389/fcell.2020.572195] [PMID: 33102477]
[25]
Siraj A, Lim DY, Tayara H, Chong KT. Ubicomb: A hybrid deep learning model for predicting plant-specific protein ubiquitylation sites. Genes 2021; 12(5): 717.
[http://dx.doi.org/10.3390/genes12050717] [PMID: 34064731]
[26]
Yin S, Zheng J, Jia C, Zou Q, Lin Z, Shi H. UPFPSR: A ubiquitylation predictor for plant through combining sequence information and random forest. Math Biosci Eng 2022; 19(1): 775-91.
[http://dx.doi.org/10.3934/mbe.2022035] [PMID: 34903012]
[27]
Xu H, Zhou J, Lin S, Deng W, Zhang Y, Xue Y. PLMD: An updated data resource of protein lysine modifications. J Genet Genomics 2017; 44(5): 243-50.
[http://dx.doi.org/10.1016/j.jgg.2017.03.007] [PMID: 28529077]
[28]
Boutet E, Lieberherr D, Tognolli M, et al. UniProtKB/Swiss-Prot, the manually annotated section of the UniProt KnowledgeBase: How to use the entry view. In: Plant Bioinformatics. Springer 2016; pp. 23-54.
[http://dx.doi.org/10.1007/978-1-4939-3167-5_2]
[29]
Mikolov T, Chen K, Corrado G, Dean J. Efficient estimation of word representations in vector space. arXiv 2013; 2013: 13013781.
[30]
Yang KK, Wu Z, Bedbrook CN, Arnold FH, Wren J. Learned protein embeddings for machine learning. Bioinformatics 2018; 34(15): 2642-8.
[http://dx.doi.org/10.1093/bioinformatics/bty178] [PMID: 29584811]
[31]
Liu B. Text sentiment analysis based on CBOW model and deep learning in big data environment. J Ambient Intell Humaniz Comput 2020; 11(2): 451-8.
[http://dx.doi.org/10.1007/s12652-018-1095-6]
[32]
The UniProt Consortium. UniProt: The universal protein knowledgebase. Nucleic Acids Res 2017; 45(D1): D158-69.
[http://dx.doi.org/10.1093/nar/gkw1099] [PMID: 27899622]
[33]
Hasan MAM, Ahmad S. mLysPTMpred: Multiple lysine PTM site prediction using combination of SVM with resolving data imbalance issue. Nat Sci 2018; 10(9): 370-84.
[http://dx.doi.org/10.4236/ns.2018.109035]
[34]
Wang M, Cui X, Li S, et al. DeepMal: Accurate prediction of protein malonylation sites by deep neural networks. Chemom Intell Lab Syst 2020; 207: 104175.
[http://dx.doi.org/10.1016/j.chemolab.2020.104175]
[35]
Dou L, Li X, Zhang L, Xiang H, Xu L. iGlu_AdaBoost: Identification of lysine glutarylation using the AdaBoost classifier. J Proteome Res 2021; 20(1): 191-201.
[http://dx.doi.org/10.1021/acs.jproteome.0c00314] [PMID: 33090794]
[36]
Manavalan B, Shin TH, Kim MO, Lee G. PIP-EL: A new ensemble learning method for improved proinflammatory peptide predictions. Front Immunol 2018; 9: 1783.
[http://dx.doi.org/10.3389/fimmu.2018.01783] [PMID: 30108593]
[37]
Li F, Chen J, Ge Z, et al. Computational prediction and interpretation of both general and specific types of promoters in Escherichia coli by exploiting a stacked ensemble-learning framework. Brief Bioinform 2021; 22(2): 2126-40.
[http://dx.doi.org/10.1093/bib/bbaa049] [PMID: 32363397]
[38]
Xie R, Li J, Wang J, et al. DeepVF: A deep learning-based hybrid framework for identifying virulence factors using the stacking strategy. Brief Bioinform 2021; 22(3): bbaa125.
[http://dx.doi.org/10.1093/bib/bbaa125] [PMID: 32599617]
[39]
Tian L, Feng L, Yang L, Guo Y. Stock price prediction based on LSTM and LightGBM hybrid model. J Supercomput 2022; 78(9): 11768-93.
[http://dx.doi.org/10.1007/s11227-022-04326-5]
[40]
Liu Y, Yu Z, Chen C, Han Y, Yu B. Prediction of protein crotonylation sites through LightGBM classifier based on SMOTE and elastic net. Anal Biochem 2020; 609: 113903.
[http://dx.doi.org/10.1016/j.ab.2020.113903] [PMID: 32805274]
[41]
Zhou K, Hu Y, Pan H, et al. Fast prediction of reservoir permeability based on embedded feature selection and LightGBM using direct logging data. Meas Sci Technol 2020; 31(4): 045101.
[http://dx.doi.org/10.1088/1361-6501/ab4a45]
[42]
Chen C, Zhang Q, Ma Q, Yu B, Light GBM-PPI. LightGBM-PPI: Predicting protein-protein interactions through LightGBM with multi-information fusion. Chemom Intell Lab Syst 2019; 191: 54-64.
[http://dx.doi.org/10.1016/j.chemolab.2019.06.003]
[43]
Liang W, Luo S, Zhao G, Wu H. Predicting hard rock pillar stability using GBDT, XGBoost, and LightGBM algorithms. Mathematics 2020; 8(5): 765.
[http://dx.doi.org/10.3390/math8050765]
[44]
Cai CZ, Han LY, Ji ZL, Chen X, Chen YZ. SVM-Prot: Web-based support vector machine software for functional classification of a protein from its primary sequence. Nucleic Acids Res 2003; 31(13): 3692-7.
[http://dx.doi.org/10.1093/nar/gkg600] [PMID: 12824396]
[45]
Zavaljevski N, Stevens FJ, Reifman J. Support vector machines with selective kernel scaling for protein classification and identification of key amino acid positions. Bioinformatics 2002; 18(5): 689-96.
[http://dx.doi.org/10.1093/bioinformatics/18.5.689] [PMID: 12050065]
[46]
Gordon AD, Breiman L, Friedman JH, Olshen RA, Stone CJ. Classification and regression trees. Biometrics 1984; 40(3): 874.
[http://dx.doi.org/10.2307/2530946]
[47]
Boulesteix AL, Janitza S, Kruppa J, König IR. Overview of random forest methodology and practical guidance with emphasis on computational biology and bioinformatics. Wiley Interdiscip Rev Data Min Knowl Discov 2012; 2(6): 493-507.
[http://dx.doi.org/10.1002/widm.1072]
[48]
Ahmad MW, Mourshed M, Rezgui Y. Trees vs Neurons: Comparison between random forest and ANN for high-resolution prediction of building energy consumption. Energy Build 2017; 147: 77-89.
[http://dx.doi.org/10.1016/j.enbuild.2017.04.038]
[49]
Noble WS. What is a support vector machine? Nat Biotechnol 2006; 24(12): 1565-7.
[http://dx.doi.org/10.1038/nbt1206-1565] [PMID: 17160063]
[50]
Cui D, Curry D. Prediction in marketing using the support vector machine. Mark Sci 2005; 24(4): 595-615.
[http://dx.doi.org/10.1287/mksc.1050.0123]
[51]
Tong S, Chang E. Support vector machine active learning for image retrieval. Proceedings of the ninth ACM international conference on Multimedia. Ottawa, Ontario, Canada. 2001; pp. 107-8.
[http://dx.doi.org/10.1145/500141.500159]
[52]
Wang D, Liang Y, Xu D. Capsule network for protein post-translational modification site prediction. Bioinformatics 2019; 35(14): 2386-94.
[http://dx.doi.org/10.1093/bioinformatics/bty977] [PMID: 30520972]
[53]
Xu H, Jia P, Zhao Z. Deep4mC: Systematic assessment and computational prediction for DNA N4-methylcytosine sites by deep learning. Brief Bioinform 2021; 22(3): bbaa099.
[http://dx.doi.org/10.1093/bib/bbaa099] [PMID: 32578842]
[54]
Soliman NF, Abd Alhalem SM, El-Shafai W, et al. Bidirectional long short-term memory network for taxonomic classification. Intell Autom Soft Comput 2022; 33(1): 103-16.
[http://dx.doi.org/10.32604/iasc.2022.017691]
[55]
Graves A. Long short-term memory. In: Supervised Sequence Labelling with Recurrent Neural Networks. Berlin, Heidelberg: Springer 2012; 385: pp. 37-45.
[http://dx.doi.org/10.1007/978-3-642-24797-2_4]
[56]
Qiao Y, Zhu X, Gong H. BERT-Kcr: Prediction of lysine crotonylation sites by a transfer learning method with pre-trained BERT models. Bioinformatics 2022; 38(3): 648-54.
[http://dx.doi.org/10.1093/bioinformatics/btab712] [PMID: 34643684]
[57]
Xiao X, Shao YT, Cheng X, Stamatovic B. iAMP-CA2L: A new CNN-BiLSTM-SVM classifier based on cellular automata image for identifying antimicrobial peptides and their functional types. Brief Bioinform 2021; 22(6): bbab209.
[http://dx.doi.org/10.1093/bib/bbab209] [PMID: 34086856]
[58]
Chen W, Chen G, Zhao L, Chen CYC. Predicting drug–target interactions with deep-embedding learning of graphs and sequences. J Phys Chem A 2021; 125(25): 5633-42.
[http://dx.doi.org/10.1021/acs.jpca.1c02419] [PMID: 34142824]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version522msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:35:33] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:35:33] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:35:33] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:35:33] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:35:33] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (134ms)time
  • Application (389ms)time
  • 1 x Application (74.37%)
    389ms
    1 x Booting (25.63%)
    134ms
    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 duplicated277ms
    • 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 ('59467608','',1,1740774933,1740774933) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740774933
      5.71msalphaeurekaselec_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 ('59467608','/article/134350',1,1740774933,1740774933)
      11.18msalphaeurekaselec_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 >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) 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 >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) 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 >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) 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 >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) 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 >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) 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 >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59467608 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59467608) limit 1
      29.75msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59467608
      • 1: 59467608
      • 2: 59467608
      • 3: 59467608
      • 4: 59467608
      • 5: 59467608
      • 6: 59467608
      • 7: 59467608
      • 8: 59467608
      • 9: 59467608
      • 10: 59467608
      • 11: 59467608
      • 12: 59467608
      • 13: 59467608
      • 14: 59467608
      • 15: 59467608
      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=134350
      1.13msalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 65 limit 1
      1.11msalphaeurekaselec_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`
      14.11msalphaeurekaselec_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
      1.03msalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=65) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      4.1msalphaeurekaselec_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
      3.71msalphaeurekaselec_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` = '134350'
      300μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 134350
      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` = '134350'
      2.85msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 134350
      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` = '134350' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      31.82msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 134350
      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
      410μ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
      750μ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
      84.34msalphaeurekaselec_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
      17.58msalphaeurekaselec_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
      9msalphaeurekaselec_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` = 134350 limit 1
      280μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 134350
      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 = 134350 and content_type = 'article' order by status desc limit 1
      360μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 220814 limit 1
      300μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 220814
      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` = 'CBIO' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      380μ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 = '134350' 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) )
      470μ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 = '13254' 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) )
      420μ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 = '3504' 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 <= 59467608 and j.to_ip >=59467608 )) and ((j.from_date <= 1740774933 and j.to_date >= 1740774933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3504) 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 <= 59467608 and j.to_ip >=59467608 )) and ((j.from_date <= 1740774933 and j.to_date >= 1740774933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3504) 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 <= 59467608 and j.to_ip >=59467608 )) and ((j.from_date <= 1740774933 and j.to_date >= 1740774933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3504)
      44.55msalphaeurekaselec_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 <= 59467608 and j.to_ip >=59467608 )) and ((j.from_date <= 1740774933 and j.to_date >= 1740774933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13254) 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 <= 59467608 and j.to_ip >=59467608 )) and ((j.from_date <= 1740774933 and j.to_date >= 1740774933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13254) 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 <= 59467608 and j.to_ip >=59467608 )) and ((j.from_date <= 1740774933 and j.to_date >= 1740774933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13254)
      930μ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 <= 59467608 and j.to_ip >=59467608 )) and ((j.from_date <= 1740774933 and j.to_date >= 1740774933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 134350) 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 <= 59467608 and j.to_ip >=59467608 )) and ((j.from_date <= 1740774933 and j.to_date >= 1740774933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 134350) 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 <= 59467608 and j.to_ip >=59467608 )) and ((j.from_date <= 1740774933 and j.to_date >= 1740774933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 134350)
      880μ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` < '458' and is_uploaded = 1 and issue_id = 13254 order by cast(first_page as SIGNED) desc limit 1
      740μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 458
      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` > '469' and is_uploaded = 1 and issue_id = 13254 order by cast(first_page as SIGNED) asc limit 1
      520μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 469
      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'
      260μ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
      300μ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` = 134350 limit 1
      3.29msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 134350
      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` <= 1740774933 and `b`.`banner_to_date` >= 1740774933 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      2.03msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 65
      • 3: 1740774933
      • 4: 1740774933
      • 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` <= 1740774933 and `b`.`banner_to_date` >= 1740774933 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.67msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 65
      • 3: 1740774933
      • 4: 1740774933
      • 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='ee9ec00dbf4bda27bc97db10010aad1b'
      300μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:291
      • 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
        xj8LPVhXEJ4JQ8ODH5kMygNCm7n3kUn0D6C6xKU8
        uc_cart_id
        ee9ec00dbf4bda27bc97db10010aad1b
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/134350" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/134350
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 28 Feb 2025 20:35:33 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ikc5bGpPODJsNVlwV1RzU3hvUmYwQUE9PSIsInZhbHVlIjoiRkhZdTA2WDROeHR1RVRZSWQxVFdNU0lqUzhFalFlVXY1SjhHaW95UWZ0K05uNWlzNGNITE1nMTBzWWdEbms1R1hXNWpVTGVLVWs1Ynd4TEpnOXE5T3FJSXowbjRrOUszL1ZZSnNuR0lpQk1jb24xaTVsNlREdHFPU3kvcGM5MDEiLCJtYWMiOiI1ZWRhODgwM2Y4ZjBiZTA1MGM1OTQxOGQ3Mzg4ODI0YzcxNTNhZWU1YjEyMjFmM2Q4ZDVhNzFmZDE3ZDBkOWZjIiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 08:35:33 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ikc5bGpPODJsNVlwV1RzU3hvUmYwQUE9PSIsInZhbHVlIjoiRkhZdTA2WDROeHR1RVRZSWQxVFdNU0lqUzhFalFlVXY1SjhHaW95UWZ0K05uNWlzNGNITE1nMTBzWWdEbms1R1hXNWpVT" 1 => "alphaeurekaselectnet_session=eyJpdiI6InhCVkppZFRsNkNNajZUNXQ1R2FURGc9PSIsInZhbHVlIjoiclJTQTFNTDc4RXBFZXNFTVBzcHhNaVVyV1BJOE1QN1FGTlo3WDBNSkl2aDNOS0FYSDMvV0IycDBreUg5SjRUeDJMK0NudEpKZnZOQ2Njazd4N2RkMzgveVprRzVoaWhTS2hmTVBKZWhGWkNUWjJOZTlJZXU0ck1CVlpEbDJrR1ciLCJtYWMiOiJmMTllMGQxNjEwM2QwMDY2OTkwY2IyNjU3ZmQ2YzlhMzQzNDdjOGY3M2RkNTkxOWMwNTI1ZDcwOTUyODMzNWU4IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6InhCVkppZFRsNkNNajZUNXQ1R2FURGc9PSIsInZhbHVlIjoiclJTQTFNTDc4RXBFZXNFTVBzcHhNaVVyV1BJOE1QN1FGTlo3WDBNSkl2aDNOS0FYSDMvV0IycDB" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ikc5bGpPODJsNVlwV1RzU3hvUmYwQUE9PSIsInZhbHVlIjoiRkhZdTA2WDROeHR1RVRZSWQxVFdNU0lqUzhFalFlVXY1SjhHaW95UWZ0K05uNWlzNGNITE1nMTBzWWdEbms1R1hXNWpVTGVLVWs1Ynd4TEpnOXE5T3FJSXowbjRrOUszL1ZZSnNuR0lpQk1jb24xaTVsNlREdHFPU3kvcGM5MDEiLCJtYWMiOiI1ZWRhODgwM2Y4ZjBiZTA1MGM1OTQxOGQ3Mzg4ODI0YzcxNTNhZWU1YjEyMjFmM2Q4ZDVhNzFmZDE3ZDBkOWZjIiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 08:35:33 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ikc5bGpPODJsNVlwV1RzU3hvUmYwQUE9PSIsInZhbHVlIjoiRkhZdTA2WDROeHR1RVRZSWQxVFdNU0lqUzhFalFlVXY1SjhHaW95UWZ0K05uNWlzNGNITE1nMTBzWWdEbms1R1hXNWpVT" 1 => "alphaeurekaselectnet_session=eyJpdiI6InhCVkppZFRsNkNNajZUNXQ1R2FURGc9PSIsInZhbHVlIjoiclJTQTFNTDc4RXBFZXNFTVBzcHhNaVVyV1BJOE1QN1FGTlo3WDBNSkl2aDNOS0FYSDMvV0IycDBreUg5SjRUeDJMK0NudEpKZnZOQ2Njazd4N2RkMzgveVprRzVoaWhTS2hmTVBKZWhGWkNUWjJOZTlJZXU0ck1CVlpEbDJrR1ciLCJtYWMiOiJmMTllMGQxNjEwM2QwMDY2OTkwY2IyNjU3ZmQ2YzlhMzQzNDdjOGY3M2RkNTkxOWMwNTI1ZDcwOTUyODMzNWU4IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6InhCVkppZFRsNkNNajZUNXQ1R2FURGc9PSIsInZhbHVlIjoiclJTQTFNTDc4RXBFZXNFTVBzcHhNaVVyV1BJOE1QN1FGTlo3WDBNSkl2aDNOS0FYSDMvV0IycDB" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "xj8LPVhXEJ4JQ8ODH5kMygNCm7n3kUn0D6C6xKU8" "uc_cart_id" => "ee9ec00dbf4bda27bc97db10010aad1b" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/134350" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 20:35:33GET/article/134350514361