Generic placeholder image

Current Bioinformatics

Editor-in-Chief

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

Review Article

A Review of Protein Inter-residue Distance Prediction

Author(s): He Huang and Xinqi Gong*

Volume 15, Issue 8, 2020

Page: [821 - 830] Pages: 10

DOI: 10.2174/1574893615999200425230056

Price: $65

Abstract

Proteins are large molecules consisting of a linear sequence of amino acids. Protein performs biological functions with specific 3D structures. The main factors that drive proteins to form these structures are constraint between residues. These constraints usually lead to important inter-residue relationships, including short-range inter-residue contacts and long-range interresidue distances. Thus, a highly accurate prediction of inter-residue contact and distance information is of great significance for protein tertiary structure computations. Some methods have been proposed for inter-residue contact prediction, most of which focus on contact map prediction and some reviews have summarized the progresses. However, inter-residue distance prediction is found to provide better guidance for protein structure prediction than contact map prediction in recent years. The methods for inter-residue distance prediction can be roughly divided into two types according to the consideration of distance value: one is based on multi-classification with discrete value and the other is based on regression with continuous value. Here, we summarize these algorithms and show that they have obtained good results. Compared to contact map prediction, distance map prediction is in its infancy. There is a lot to do in the future including improving distance map prediction precision and incorporating them into residue-residue distanceguided ab initio protein folding.

Keywords: Machine learning, deep learning, protein structure prediction, contact map, inter-residue distance, distance map.

Graphical Abstract

[1]
Saitoh S, Nakai T, Nishikawa K. A geometrical constraint approach for reproducing the native backbone conformation of a protein. Proteins-structure Funct. Bioinforma 2010; 15: 191-204.
[2]
Bohr J, Bohr H, Brunak S, et al. Protein structures from distance inequalities. J Mol Biol 1993; 231(3): 861-9.
[http://dx.doi.org/10.1006/jmbi.1993.1332] [PMID: 7685827]
[3]
Ma J, Wang S, Wang Z, Xu J. Protein contact prediction by integrating joint evolutionary coupling analysis and supervised learning. Bioinformatics 2015; 31(21): 3506-13.
[http://dx.doi.org/10.1093/bioinformatics/btv472] [PMID: 26275894]
[4]
Jones DT, Singh T, Kosciolek T, Tetchner S. MetaPSICOV: combining coevolution methods for accurate prediction of contacts and long range hydrogen bonding in proteins. Bioinformatics 2015; 31(7): 999-1006.
[http://dx.doi.org/10.1093/bioinformatics/btu791] [PMID: 25431331]
[5]
Adhikari B, Hou J, Cheng J. DNCON2: improved protein contact prediction using two-level deep convolutional neural networks. Bioinformatics 2018; 34(9): 1466-72.
[http://dx.doi.org/10.1093/bioinformatics/btx781] [PMID: 29228185]
[6]
Hanson J, Paliwal K, Litfin T, Yang Y, Zhou Y. Accurate prediction of protein contact maps by coupling residual two-dimensional bidirectional long short-term memory with convolutional neural networks. Bioinformatics 2018; 34(23): 4039-45.
[http://dx.doi.org/10.1093/bioinformatics/bty481] [PMID: 29931279]
[7]
Heck GS, Pintro VO, Pereira RR, de Ávila MB, Levin NMB, de Azevedo WF. Supervised machine learning methods applied to predict ligand- binding affinity. Curr Med Chem 2017; 24(23): 2459-70.
[http://dx.doi.org/10.2174/0929867324666170623092503] [PMID: 28641555]
[8]
Xavier MM, Heck GS, Avila MB, et al. SAnDReS a computational tool for statistical analysis of docking results and development of scoring functions. Comb Chem High Throughput Screen 2016; 19(10): 801-12.
[http://dx.doi.org/10.2174/1386207319666160927111347] [PMID: 27686428]
[9]
da Silva AD, Bitencourt-Ferreira G, de Azevedo WF Jr. Taba: a tool to analyze the binding affinity. J Comput Chem 2020; 41(1): 69-73.
[http://dx.doi.org/10.1002/jcc.26048] [PMID: 31410856]
[10]
Li H, Peng J, Sidorov P, et al. Classical scoring functions for docking are unable to exploit large volumes of structural and interaction data. Bioinformatics 2019; 35(20): 3989-95.
[http://dx.doi.org/10.1093/bioinformatics/btz183] [PMID: 30873528]
[11]
Moré JJ, Wu Z. Distance geometry optimization for protein structures. J Glob Optim 1999; 15: 219-34.
[http://dx.doi.org/10.1023/A:1008380219900]
[12]
Adams PD, Berkeley L, Clore GM, Jiang J, Nilges M. Crystallography & NMR System : A New Software Suite for Macromolecular Crystallography & NMR System : A New Software Suite for Macromolecular Structure Determination 1998.
[13]
Fadel V, Bettendorff P, Herrmann T, et al. Automated NMR structure determination and disulfide bond identification of the myotoxin crotamine from Crotalus durissus terrificus. Toxicon 2005; 46(7): 759-67.
[http://dx.doi.org/10.1016/j.toxicon.2005.07.018] [PMID: 16185738]
[14]
Liberti L, Lavor C, Maculan N, Mucherino A. Euclidean distance geometry and applications. SIAM Rev 2014; 56: 3-69.
[http://dx.doi.org/10.1137/120875909]
[15]
Wu, Di, Wu, and Zhijun (2007). An updated geometric build-up algorithm for solving the molecular distance geometry problems with sparse distance data. J Glob Optim 2007; 37: 661-73.
[16]
Souza M, Lavor C, Muritiba A, Maculan N. Solving the molecular distance geometry problem with inaccurate distance data. BMC Bioinformatics 2013; 14(Suppl. 9): S7.
[http://dx.doi.org/10.1186/1471-2105-14-S9-S7] [PMID: 23901894]
[17]
Sit A, Wu Z, Yuan Y. A geometric buildup algorithm for the solution of the distance geometry problem using least-squares approximation. Bull Math Biol 2009; 71(8): 1914-33.
[http://dx.doi.org/10.1007/s11538-009-9431-9] [PMID: 19533250]
[18]
Havel TF. Distance Geometry: Theory, Algorithms, and Chemical Applications. Encycl Comput Chem 2003.
[19]
Mohammed Z, Chris B, Bartoli L, et al. The pros and cons of predicting protein contact maps Protein Structure Prediction 2007; 199-217.
[20]
Kuhlman B, Bradley P. Advances in protein structure prediction and design. Nat Rev Mol Cell Biol 2019; 20: 681-97.
[http://dx.doi.org/10.1038/s41580-019-0163-x]
[21]
Jing X, Dong Q, Lu R, Dong Q. Protein inter-residue contacts prediction: Methods, Performances and applications. Curr Bioinform 2018; 14: 178-89.
[http://dx.doi.org/10.2174/1574893613666181109130430]
[22]
Morcos F, Pagnani A, Lunt B, Bertolino A, Marks DS, Sander C. Morcos F, Pagnani A, Lunt B, Bertolino A, Marks DS, Sander C. Direct-coupling analysis of residue coevolution captures native contacts across many protein families. PNAS 2011; 108(49): E1293-E1301..
[http://dx.doi.org/10.1073/pnas.1111471108]
[23]
Ekeberg M, Hartonen T, Aurell E. Fast pseudolikelihood maximization for direct-coupling analysis of protein structure from many homologous amino-acid sequences. J Comput Phys 2014; 276: 341-56.
[http://dx.doi.org/10.1016/j.jcp.2014.07.024]
[24]
Baldassi C, Zamparo M, Feinauer C, et al. Fast and accurate multivariate Gaussian modeling of protein families: predicting residue contacts and protein-interaction partners. PLoS One 2014; 9(3)e92721
[http://dx.doi.org/10.1371/journal.pone.0092721] [PMID: 24663061]
[25]
Jones DT, Kandathil SM. High precision in protein contact prediction using fully convolutional neural networks and minimal sequence features. Bioinformatics 2018; 34(19): 3308-15.
[http://dx.doi.org/10.1093/bioinformatics/bty341] [PMID: 29718112]
[26]
Adhikari B. DEEPCON: Protein Contact Prediction using Dilated Convolutional Neural Networks with Dropout. bioRxiv. 2019.https://www.biorxiv.org/content/10.1101/590455v1?rss=1
[27]
Liu Y, Palmedo P, Ye Q, Berger B, Peng J. Enhancing Evolutionary Couplings with Deep Convolutional Neural Networks. Cell Syst 2018; 6(1): 65-74.e3.
[http://dx.doi.org/10.1016/j.cels.2017.11.014] [PMID: 29275173]
[28]
Michel M, Hurtado DM, Elofsson A. PconsC4: fast, accurate, and hassle-free contact predictions. Bioinformatics 2018; 4: 1-2.
[http://dx.doi.org/10.1093/bioinformatics/bty1036] [PMID: 30590407]
[29]
Zhang H, Gao Y, Deng M, et al. Improving residue-residue contact prediction via low-rank and sparse decomposition of residue correlation matrix. Biochem Biophys Res Commun 2016; 472(1): 217-22.
[http://dx.doi.org/10.1016/j.bbrc.2016.01.188] [PMID: 26920058]
[30]
Martin LC, Gloor GB, Dunn SD, Wahl LM. Using information theory to search for co-evolving residues in proteins. Bioinformatics 2005; 21(22): 4116-24.
[http://dx.doi.org/10.1093/bioinformatics/bti671] [PMID: 16159918]
[31]
Zhang H, Zhang Q, Ju F, et al. Predicting protein inter-residue contacts using composite likelihood maximization and deep learning 2018.
[http://dx.doi.org/10.1186/s12859-019-3051-7]
[32]
Seemayer S, Gruber M, Söding J. CCMpred--fast and precise prediction of protein residue-residue contacts from correlated mutations. Bioinformatics 2014; 30(21): 3128-30.
[http://dx.doi.org/10.1093/bioinformatics/btu500] [PMID: 25064567]
[33]
Marks DS, Colwell LJ, Sheridan R, et al. Protein 3D structure computed from evolutionary sequence variation. PLoS One 2011; 6(12)e28766
[http://dx.doi.org/10.1371/journal.pone.0028766] [PMID: 22163331]
[34]
Wang Z, Xu J. Predicting protein contact map using evolutionary and physical constraints by integer programming. Bioinformatics 2013; 29(13): i266-73.
[http://dx.doi.org/10.1093/bioinformatics/btt211] [PMID: 23812992]
[35]
Jones DT, Buchan DWA, Cozzetto D, Pontil M. PSICOV: precise structural contact prediction using sparse inverse covariance estimation on large multiple sequence alignments. Bioinformatics 2012; 28(2): 184-90.
[http://dx.doi.org/10.1093/bioinformatics/btr638] [PMID: 22101153]
[36]
Kaján L, Hopf TA, Kalaš M, Marks DS, Rost B. FreeContact: fast and free software for protein contact prediction from residue co-evolution. BMC Bioinformatics 2014; 15: 85.
[http://dx.doi.org/10.1186/1471-2105-15-85] [PMID: 24669753]
[37]
Ding W, Mao W, Shao D, Zhang W, Gong H. DeepConPred2: An improved method for the prediction of protein residue contacts. Comput Struct Biotechnol J 2018; 16: 503-10.
[http://dx.doi.org/10.1016/j.csbj.2018.10.009] [PMID: 30505403]
[38]
Kamisetty H, Ovchinnikov S, Baker D. Assessing the utility of coevolution-based residue-residue contact predictions in a sequence- and structure-rich era. Proc Natl Acad Sci USA 2013; 110(39): 15674-9.
[http://dx.doi.org/10.1073/pnas.1314045110] [PMID: 24009338]
[39]
Kukic P, Mirabello C, Tradigo G, Walsh I, Veltri P, Pollastri G. Toward an accurate prediction of inter-residue distances in proteins using 2D recursive neural networks. BMC Bioinformatics 2014; 15: 6.
[http://dx.doi.org/10.1186/1471-2105-15-6] [PMID: 24410833]
[40]
Ronneberger O, Fischer P, Brox T. U-Net: Convolutional Networks for Biomedical Image Segmentation 2015.
[41]
Michel M, Menéndez Hurtado D, Elofsson A. PconsC4: fast, accurate and hassle-free contact predictions. Bioinformatics 2019; 35(15): 2677-9.
[http://dx.doi.org/10.1093/bioinformatics/bty1036] [PMID: 30590407]
[42]
Zhou Z, Siddiquee MR. UNet++: A Nested U-Net Architecture for Medical Image Segmentation
[43]
Shenoy A, Institutet K. Feature optimization of contact map predictions based on inter-residue distances and U-Net ++ architecture Author : Aditi Adesh Shenoy. 2019.
[44]
Reese MG, Lund O, Bohr H. Distance distributions in proteins : A six-parameter representation 1996.
[45]
Lund O, Frimand K, Gorodkin J, Bohr H, Bohr J. Protein distance constraints predicted by neural networks and probability density functions Protein distance constraints predicted by neural networks and probability density functions 1997.
[46]
Gorodkin J, Lund O, Andersen CA, Brunak S. Using Sequence Motifs for Enhanced Neural Network Prediction of Protein Distance Constraints 1999.
[47]
Walsh I, Baù D, Martin AJ, Mooney C, Vullo A, Pollastri G. Ab initio and template-based prediction of multi-class distance maps by two-dimensional recursive neural networks. BMC Struct Biol 2009; 9: 5.
[http://dx.doi.org/10.1186/1472-6807-9-5] [PMID: 19183478]
[48]
Ji S, Oruç T, Mead L, et al. DeepCDpred: Inter-residue distance and contact prediction for improved prediction of protein structure. PLoS One 2019; 14(1)e0205214
[http://dx.doi.org/10.1371/journal.pone.0205214] [PMID: 30620738]
[49]
Nair V, Hinton GEBT-IC, On ML. Rectified Linear Units Improve Restricted Boltzmann Machines 2010.
[50]
Wang S, Sun S, Li Z, Zhang R, Xu J. Accurate De Novo Prediction of Protein Contact Map by Ultra-Deep Learning Model. PLOS Comput Biol 2017; 13(1)e1005324
[http://dx.doi.org/10.1371/journal.pcbi.1005324] [PMID: 28056090]
[51]
Xu J, Wang S. Analysis of distance-based protein structure prediction by deep learning in CASP13. Proteins 2019; 87(12): 1069-81.
[http://dx.doi.org/10.1002/prot.25810] [PMID: 31471916]
[52]
Zhu J, Wang S, Bu D, Xu J. Protein threading using residue co-variation and deep learning. Bioinformatics 2018; 34(13): i263-73.
[http://dx.doi.org/10.1093/bioinformatics/bty278] [PMID: 29949980]
[53]
He K, Zhang X, Ren S, Sun J. Deep residual learning for image recognition 2016.
[http://dx.doi.org/10.1109/CVPR.2016.90]
[54]
Skwark MJ, Raimondi D, Michel M, Elofsson A. Improved contact predictions using the recognition of protein like contact patterns. PLOS Comput Biol 2014; 10(11)e1003889
[http://dx.doi.org/10.1371/journal.pcbi.1003889] [PMID: 25375897]
[55]
Xu J. Distance-based protein folding powered by deep learning 2019.
[http://dx.doi.org/10.1073/pnas.1821309116]
[56]
Vassura M, Margara L, Di Lena P, Medri F, Fariselli P, Casadio R. Reconstruction of 3D structures from protein contact maps. IEEE/ACM Trans Comput Biol Bioinformatics 2008; 5(3): 357-67.
[http://dx.doi.org/10.1109/TCBB.2008.27] [PMID: 18670040]
[57]
Lund O, Hansen J, Brunak S, Bohr J. Relationship between protein structure and geometrical constraints. Protein Sci 1996; 5(11): 2217-25.
[http://dx.doi.org/10.1002/pro.5560051108] [PMID: 8931140]
[58]
Vendruscolo M, Kussell E, Domany E. Recovery of protein structure from contact maps. Fold Des 1997; 2(5): 295-306.
[http://dx.doi.org/10.1016/S1359-0278(97)00041-2] [PMID: 9377713]
[59]
Galaktionov SG, Marshall GRBT-THIC. Properties of intraglobular contacts in proteins: an approach to prediction of tertiary structure 1994.
[60]
Vendruscolo M, Kussell E, Domany E. Recovery of Protein Structure from Contact Maps. 1-27..
[61]
Gianluca P, Alessandro V, Paolo F, Pierre B. Modular DAG-RNN architectures for assembling coarse protein structures. J Comput Biol A J. Comput Mol Cell Biol 2006; 13: 631-50.
[62]
Michel M, Hayat S, Skwark MJ, Sander C, Marks DS, Elofsson A. PconsFold: improved contact predictions improve protein models. Bioinformatics 2014; 30(17): i482-8.
[http://dx.doi.org/10.1093/bioinformatics/btu458] [PMID: 25161237]
[63]
Adhikari B, Bhattacharya D, Cao R, Cheng J. CONFOLD: Residue-residue contact-guided ab initio protein folding. Proteins 2015; 83(8): 1436-49.
[http://dx.doi.org/10.1002/prot.24829] [PMID: 25974172]
[64]
Adhikari B, Cheng J. CONFOLD2: improved contact-driven ab initio protein structure modeling. BMC Bioinformatics 2018; 19(1): 22.
[http://dx.doi.org/10.1186/s12859-018-2032-6] [PMID: 29370750]
[65]
Adhikari B, Cheng J. Improved protein structure reconstruction using secondary structures, contacts at higher distance thresholds, and non-contacts. BMC Bioinformatics 2017; 18(1): 380.
[http://dx.doi.org/10.1186/s12859-017-1807-5] [PMID: 28851269]
[66]
Alquraishi M. Structural bioinformatics AlphaFold at CASP13 2019.
[67]
Hou J, Cao R, Cheng J. Protein tertiary structure modeling driven by deep learning and contact distance prediction in CASP13 Short running title : Protein structure prediction by deep learning in CASP13. 2019.
[68]
Schaarschmidt J, Monastyrskyy B, Kryshtafovych A, Bonvin AMJJ. Assessment of contact predictions in CASP12: Co-evolution and deep learning coming of age. Proteins 2018; 86(Suppl. 1): 51-66.
[http://dx.doi.org/10.1002/prot.25407] [PMID: 29071738]
[69]
Crippen GM. Linearized embedding: a new metric matrix algorithm for calculating molecular conformations subject to geometric constraints. J Comput Chem 1989; 10: 896-902.
[http://dx.doi.org/10.1002/jcc.540100706]
[70]
Den Kelder D, Gabriëlle M. Distance geometry and molecular conformation. Trends Pharmacol Sci 1988; 10: 164.
[http://dx.doi.org/10.1016/0165-6147(89)90173-9]
[71]
Luo XL, Wu ZJ. Least-Squares Approximations in Geometric Buildup for Solving Distance Geometry Problems. J Optim Theory Appl 2011; 149: 580-98.
[http://dx.doi.org/10.1007/s10957-011-9806-6]
[72]
Liberti L, Lavor C, Mucherino A, Maculan N. Molecular distance geometry methods: from continuous to discrete. Int Trans Oper Res 2011; 18: 33-51.
[http://dx.doi.org/10.1111/j.1475-3995.2009.00757.x]
[73]
Fang HR, O’Leary DP. Euclidean distance matrix completion problems. Optim Methods Softw 2012; 27: 695-717.
[http://dx.doi.org/10.1080/10556788.2011.643888]
[74]
Gao Y, Wang S, Deng M, Xu J. RaptorX-Angle: real-value prediction of protein backbone dihedral angles through a hybrid method of clustering and deep learning. BMC Bioinformatics 2018; 19(Suppl. 4): 100.
[http://dx.doi.org/10.1186/s12859-018-2065-x] [PMID: 29745828]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version432msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[16:58:20] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[16:58:20] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[16:58:20] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (147ms)time
  • Application (285ms)time
  • 1 x Application (66.05%)
    285ms
    1 x Booting (33.94%)
    147ms
    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 duplicated183ms
    • 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 ('58766425','',1,1740675500,1740675500) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740675500
      2.99msalphaeurekaselec_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 ('58766425','/article/106126',1,1740675500,1740675500)
      980μ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 >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) 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 >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) 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 >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) 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 >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) 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 >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) 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 >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) limit 1
      17.31msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 58766425
      • 1: 58766425
      • 2: 58766425
      • 3: 58766425
      • 4: 58766425
      • 5: 58766425
      • 6: 58766425
      • 7: 58766425
      • 8: 58766425
      • 9: 58766425
      • 10: 58766425
      • 11: 58766425
      • 12: 58766425
      • 13: 58766425
      • 14: 58766425
      • 15: 58766425
      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=106126
      960μsalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 65 limit 1
      1.09msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 65
      Backtrace
      • 14. app/Models/Journal.php:64
      • 15. app/Http/Controllers/ArticleController.php:2516
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=65) and sj.journal_id!=65 group by `j`.`nid`) as `aggregate_table`
      1.02msalphaeurekaselec_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
      970μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=65) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      4.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=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.87msalphaeurekaselec_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` = '106126'
      1.64msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 106126
      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` = '106126'
      7.52msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 106126
      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` = '106126' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.65msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 106126
      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
      370μ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
      730μ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
      47.9msalphaeurekaselec_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
      42.16msalphaeurekaselec_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
      8.79msalphaeurekaselec_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` = 106126 limit 1
      320μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 106126
      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 = 106126 and content_type = 'article' order by status desc limit 1
      370μ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` = 181338 limit 1
      270μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 181338
      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
      330μ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
      390μ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 = '106126' 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) )
      450μ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 = '10298' 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) )
      400μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '2747' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      400μ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 <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1740675500 and j.to_date >= 1740675500 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2747) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1740675500 and j.to_date >= 1740675500 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2747) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1740675500 and j.to_date >= 1740675500 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2747)
      15.88msalphaeurekaselec_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 <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1740675500 and j.to_date >= 1740675500 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10298) 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 <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1740675500 and j.to_date >= 1740675500 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10298) 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 <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1740675500 and j.to_date >= 1740675500 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10298)
      920μ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 <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1740675500 and j.to_date >= 1740675500 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 106126) 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 <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1740675500 and j.to_date >= 1740675500 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 106126) 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 <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1740675500 and j.to_date >= 1740675500 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 106126)
      690μ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` < '821' and is_uploaded = 1 and issue_id = 10298 order by cast(first_page as SIGNED) desc limit 1
      540μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 821
      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` > '830' and is_uploaded = 1 and issue_id = 10298 order by cast(first_page as SIGNED) asc limit 1
      480μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 830
      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'
      190μ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
      230μ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` = 106126 limit 1
      10.89msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 106126
      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` <= 1740675500 and `b`.`banner_to_date` >= 1740675500 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: 1740675500
      • 4: 1740675500
      • 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` <= 1740675500 and `b`.`banner_to_date` >= 1740675500 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.71msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 65
      • 3: 1740675500
      • 4: 1740675500
      • 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='9bb306a3b52e84bed29b7f4fe8f0c4d3'
      330μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        pcchCTHdXWTD2Q01ZhCji8AgWfse3l1mzj1P148c
        uc_cart_id
        9bb306a3b52e84bed29b7f4fe8f0c4d3
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/106126" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/106126
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Thu, 27 Feb 2025 16:58:20 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImtteXVqcmI5QWE2eU84cUxMbEVORFE9PSIsInZhbHVlIjoiblUra3hyalE0N1VCK1QrQ2wwMkhPenB6UmpuZjhEaTRvT29Od1JzenFkemk4b2htNnlXTi9NbVpUZFNDRGx1WVNPTjdWVzZzMmNwbXdMVlhQWFBqR2NrZXlxZ09KUXM0blpVQ25MbnZWUXVOWEtueDNrbG1kRWMwY0ZkN0JHY08iLCJtYWMiOiI3YjI4OTcwMTUwYTU3YTkxMGYzZDc0Yzc4YTc5MTcxNWU5YzVlODc5Mjk4YmZjMmYwZGUzZTI3ZTc5M2ViYWYxIiwidGFnIjoiIn0%3D; expires=Sun, 02 Mar 2025 04:58:20 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImtteXVqcmI5QWE2eU84cUxMbEVORFE9PSIsInZhbHVlIjoiblUra3hyalE0N1VCK1QrQ2wwMkhPenB6UmpuZjhEaTRvT29Od1JzenFkemk4b2htNnlXTi9NbVpUZFNDRGx1WVNPTjdWV" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ii9SVDBibkhtanh4WWo5K2J5d0daYlE9PSIsInZhbHVlIjoiR1p2Y0tTSyt0cWNxcmhCUTd4MDdSM1RQVGN5S0k2cm9LTVVQbFM5UW5DeHBLNFhaNnBqVUNHd0JNK1daS3ZRUklZcjNia2o2MG5SQjY0RG5ITVRXZ015OUpTNFhqZnBoZ3pmdWl1VTVidFdwNnJpOXRDZEQxTmpDRjZyYy9WYXQiLCJtYWMiOiI0YWVmZGZlMDI4MmMwODhhN2MxN2E1ZjU0NThkZjNjOThmNGUxYjI0MGY5YjNhNDgzOTZjZWM3ZTk2MjQwNTVjIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ii9SVDBibkhtanh4WWo5K2J5d0daYlE9PSIsInZhbHVlIjoiR1p2Y0tTSyt0cWNxcmhCUTd4MDdSM1RQVGN5S0k2cm9LTVVQbFM5UW5DeHBLNFhaNnBqVUNHd0J" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImtteXVqcmI5QWE2eU84cUxMbEVORFE9PSIsInZhbHVlIjoiblUra3hyalE0N1VCK1QrQ2wwMkhPenB6UmpuZjhEaTRvT29Od1JzenFkemk4b2htNnlXTi9NbVpUZFNDRGx1WVNPTjdWVzZzMmNwbXdMVlhQWFBqR2NrZXlxZ09KUXM0blpVQ25MbnZWUXVOWEtueDNrbG1kRWMwY0ZkN0JHY08iLCJtYWMiOiI3YjI4OTcwMTUwYTU3YTkxMGYzZDc0Yzc4YTc5MTcxNWU5YzVlODc5Mjk4YmZjMmYwZGUzZTI3ZTc5M2ViYWYxIiwidGFnIjoiIn0%3D; expires=Sun, 02-Mar-2025 04:58:20 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImtteXVqcmI5QWE2eU84cUxMbEVORFE9PSIsInZhbHVlIjoiblUra3hyalE0N1VCK1QrQ2wwMkhPenB6UmpuZjhEaTRvT29Od1JzenFkemk4b2htNnlXTi9NbVpUZFNDRGx1WVNPTjdWV" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ii9SVDBibkhtanh4WWo5K2J5d0daYlE9PSIsInZhbHVlIjoiR1p2Y0tTSyt0cWNxcmhCUTd4MDdSM1RQVGN5S0k2cm9LTVVQbFM5UW5DeHBLNFhaNnBqVUNHd0JNK1daS3ZRUklZcjNia2o2MG5SQjY0RG5ITVRXZ015OUpTNFhqZnBoZ3pmdWl1VTVidFdwNnJpOXRDZEQxTmpDRjZyYy9WYXQiLCJtYWMiOiI0YWVmZGZlMDI4MmMwODhhN2MxN2E1ZjU0NThkZjNjOThmNGUxYjI0MGY5YjNhNDgzOTZjZWM3ZTk2MjQwNTVjIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ii9SVDBibkhtanh4WWo5K2J5d0daYlE9PSIsInZhbHVlIjoiR1p2Y0tTSyt0cWNxcmhCUTd4MDdSM1RQVGN5S0k2cm9LTVVQbFM5UW5DeHBLNFhaNnBqVUNHd0J" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "pcchCTHdXWTD2Q01ZhCji8AgWfse3l1mzj1P148c" "uc_cart_id" => "9bb306a3b52e84bed29b7f4fe8f0c4d3" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/106126" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-27 16:58:20GET/article/106126314361