Generic placeholder image

Protein & Peptide Letters

Editor-in-Chief

ISSN (Print): 0929-8665
ISSN (Online): 1875-5305

Research Article

Recombinant Expression and Characterization of Lemon (Citrus limon) Peroxidase

Author(s): Veda P. Pandey, Apoorvi Tyagi, Shagoofa Ali, Kusum Yadav, Anurag Yadav, Ajit K. Shasany and Upendra N. Dwivedi*

Volume 28, Issue 4, 2021

Published on: 25 September, 2020

Page: [469 - 479] Pages: 11

DOI: 10.2174/0929866527666200925114054

Price: $65

Abstract

Background: Class III plant peroxidases play important role in a number of physiological processes in plants such as lignin biosynthesis, suberization, cell wall biosynthesis, reactive oxygen species metabolism and plant defense against pathogens. Peroxidases are also of significance in several industrial applications. In view of this, the production and identification of novel peroxidases having resistance towards temperature, pH, salts is desirable.

Objective: The objective of the present work was to clone and characterize a novel plant peroxidase suitable for industrial application.

Methods: A full length cDNA clone of lemon peroxidase was isolated using PCR and RACE approaches, characterized and heterologously expressed in Escherichia coli using standard protocols. The expressed peroxidase was purified using Ni-NTA agarose column and biochemically characterized using standard protocols. The peroxidase was also in-silico characterized at nucleotide as well as protein levels using standard protocols.

Results: A full length cDNA clone of lemon peroxidase was isolated and expressed heterologously in E. coli. The expressed recombinant lemon peroxidase (LPRX) was activated by in-vitro refolding and purified. The purified LPRX exhibited pH and temperature optima of pH 7.0 and 50°C, respectively. The LPRX was found to be activated by metal ions (Na+, Ca2+, Mg2+ and Mn2+) at lower concentration. The expressional analysis of the transcripts suggested involvement of lemon peroxidase in plant defense. The lemon peroxidase was in silico modelled and docked with the substrates guaiacol, and pyrogallol and shown the favourability of pyrogallol over guaiacol, which is in agreement with the in-vitro findings. The protein function annotation analyses suggested the involvement of lemon peroxidase in the phenylpropanoid biosynthesis pathway and plant defense mechanisms.

Conclusion: Based on the biochemical characterization, the purified peroxidase was found to be resistant towards the salts and thus, might be a good candidate for industrial exploitation. The in-silico protein function annotation and transcript analyses highlighted the possible involvement of the lemon peroxidase in plant defense response.

Keywords: Functional annotation, in-vitro folding, in-silico analyses, molecular modeling, phenylpropanoid pathway, recombinant expression.

« Previous
Graphical Abstract

[1]
Welinder, K.G. Superfamily of plant, fungal and bacterial peroxidases. Curr. Opin. Struct. Biol., 1992, 2, 388-393.
[http://dx.doi.org/10.1016/0959-440X(92)90230-5]
[2]
Pandey, V.P.; Awasthi, M.; Singh, S.; Tiwari, S.; Dwivedi, U.N. A comprehensive review on function and application of plant peroxidases. Biochem. Anal. Biochem., 2017, 6, 308-323.
[http://dx.doi.org/10.4172/2161-1009.1000308]
[3]
Husain, Q. Peroxidase mediated decolorization and remediation of wastewater containing industrial dyes: a review. Rev. Environ. Sci. Biotechnol., 2010, 9, 117-140.
[http://dx.doi.org/10.1007/s11157-009-9184-9]
[4]
Regalado Garc’ıa-Almend’arez, C.E.; Duarte-V’azquez, M.A. Biotechnological applications of peroxidases. Phytochem. Rev., 2004, 3, 243-256.
[http://dx.doi.org/10.1023/B:PHYT.0000047797.81958.69]
[5]
Pandey, V.P.; Dwivedi, U.N. A ripening associated peroxidase from papaya having a role in defense and lignification: heterologous expression and in-silico and in-vitro experimental validation. Gene, 2015, 555(2), 438-447.
[http://dx.doi.org/10.1016/j.gene.2014.11.013] [PMID: 25447898]
[6]
Violante-Mota, F.; Tellechea, E.; Moran, J.F.; Sarath, G.; Arredondo-Peter, R. Analysis of peroxidase activity of rice (Oryza sativa) recombinant hemoglobin 1: implications for in vivo function of hexacoordinate non-symbiotic hemoglobins in plants. Phytochemistry, 2010, 71(1), 21-26.
[http://dx.doi.org/10.1016/j.phytochem.2009.09.016] [PMID: 19833360]
[7]
Fattahian, Y.; Riahi-Madvar, A.; Mirzaee, R.; Torkzadeh-Mahani, M.; Asadikaram, G. Heterologous expression, purification and characterization of a peroxidase isolated from Lepidium draba. Protein J., 2017, 36(6), 461-471.
[http://dx.doi.org/10.1007/s10930-017-9741-y] [PMID: 28975545]
[8]
Rodríguez-Cabrera, N.A.; Regalado, C.; García-Almendárez, B.E. Cloning, heterologous expression and properties of a recombinant active turnip peroxidase. J. Agric. Food Chem., 2011, 59(13), 7120-7126.
[http://dx.doi.org/10.1021/jf2006722] [PMID: 21591783]
[9]
Pham, T.M.; Kim, S.J.; Song, B.K.; Kim, Y.H. Optimized refolding and characterization of S-peroxidase (CWPO_C of Populus alba) expressed in E. coli. Protein Expr. Purif., 2011, 80(2), 268-273.
[http://dx.doi.org/10.1016/j.pep.2011.08.003] [PMID: 21856428]
[10]
Bae, E.K.; Lee, H.; Lee, J.S.; Noh, E.W.; Jo, J. Molecular cloning of a peroxidase gene from poplar and its expression in response to stress. Tree Physiol., 2006, 26(11), 1405-1412.
[http://dx.doi.org/10.1093/treephys/26.11.1405] [PMID: 16877325]
[11]
Spadiut, O.; Rossetti, L.; Dietzsch, C.; Herwig, C. Purification of a recombinant plant peroxidase produced in Pichia pastoris by a simple 2-step strategy. Protein Expr. Purif., 2012, 86(2), 89-97.
[http://dx.doi.org/10.1016/j.pep.2012.09.008] [PMID: 23026679]
[12]
Krainer, F.W.; Pletzenauer, R.; Rossetti, L.; Herwig, C.; Glieder, A.; Spadiut, O. Purification and basic biochemical characterization of 19 recombinant plant peroxidase isoenzymes produced in Pichia pastoris. Protein Expr. Purif., 2014, 95, 104-112.
[http://dx.doi.org/10.1016/j.pep.2013.12.003] [PMID: 24342173]
[13]
Green, M.R.; Sambrook, J. Molecular Cloning: A Laboratory Manual, 4th Ed; Cold Spring Harbor Laboratory: America, 2012.
[14]
Bradford, M.M. A rapid and sensitive method for the quantitation of microgram quantities of protein utilizing the principle of protein-dye binding. Anal. Biochem., 1976, 72, 248-254.
[http://dx.doi.org/10.1016/0003-2697(76)90527-3] [PMID: 942051]
[15]
Laemmli, U.K. Cleavage of structural proteins during the assembly of the head of bacteriophage T4. Nature, 1970, 227(5259), 680-685.
[http://dx.doi.org/10.1038/227680a0] [PMID: 5432063]
[16]
Pandey, V.P.; Dwivedi, U.N. Purification and characterization of peroxidase from Leucaena leucocephala, a tree legume. J. Mol. Catal., B Enzym., 2011, 68, 168-173.
[http://dx.doi.org/10.1016/j.molcatb.2010.10.006]
[17]
Davis, B.J. Disc Electrophoresis II. Method and application to human serum proteins. Ann. N. Y. Acad. Sci., 1964, 121, 404-427.
[http://dx.doi.org/10.1111/j.1749-6632.1964.tb14213.x] [PMID: 14240539]
[18]
Pfaffl, M.W. A new mathematical model for relative quantification in real-time RT-PCR. Nucleic Acids Res., 2001, 29(9)e45
[http://dx.doi.org/10.1093/nar/29.9.e45] [PMID: 11328886]
[19]
Asad, S.; Dabirmanesh, B.; Ghaemi, N.; Etezad, S.M.; Khajeh, K. Studies on the refolding process of recombinant horseradish peroxidase. Mol. Biotechnol., 2013, 54(2), 484-492.
[http://dx.doi.org/10.1007/s12033-012-9588-6] [PMID: 22872497]
[20]
Gabaldón, C.; López-Serrano, M.; Pedreño, M.A.; Barceló, A.R. Cloning and molecular characterization of the basic peroxidase isoenzyme from Zinnia elegans, an enzyme involved in lignin biosynthesis. Plant Physiol., 2005, 139(3), 1138-1154.
[http://dx.doi.org/10.1104/pp.105.069674] [PMID: 16258008]
[21]
Liu, C.; Zheng, K.; Xu, Y.; Stephen, L.T.; Wang, J.; Zhao, H.; Yue, T.; Nian, R.; Zhang, H.; Xian, M.; Liu, H. Expression and characterization of soybean seed coat peroxidase in Escherichia coli BL21(DE3). Prep. Biochem. Biotechnol., 2017, 47(8), 768-775.
[http://dx.doi.org/10.1080/10826068.2017.1342258] [PMID: 28644760]
[22]
Pandey, V.P.; Rani, J.; Jaiswal, N.; Singh, S.; Awasthi, M.; Shasany, A.K.; Tiwari, S.; Dwivedi, U.N. Chitosan immobilized novel peroxidase from Azadirachta indica: Characterization and application. Int. J. Biol. Macromol., 2017, 104(Pt B), 1713-1720.
[http://dx.doi.org/10.1016/j.ijbiomac.2017.02.047] [PMID: 28215563]
[23]
Fortea, M.I.; Pellicer, J.A.; Serrano-Martínez, A.; López-Miranda, S.; Lucas-Abellán, C.; Núñez-Delicado, E. Red cabbage (Brassica oleracea) as a new source of high-thermostable peroxidase. J. Agric. Food Chem., 2012, 60(42), 10641-10648.
[http://dx.doi.org/10.1021/jf302483q] [PMID: 23013444]
[24]
Hu, Y.; Wu, J.; Luo, P.; Mo, Y. Purification and partial characterization of peroxidase from lettuce stems. Afr. J. Biotechnol., 2012, 11, 2752-2756.
[25]
Mall, R.; Naik, G.; Mina, U.; Mishra, S.K. Purification and characterization of a thermostable soluble peroxidase from Citrus medica leaf. Prep. Biochem. Biotechnol., 2013, 43(2), 137-151.
[http://dx.doi.org/10.1080/10826068.2012.711793] [PMID: 23302102]
[26]
Mohamed, S.A.; El-Badry, M.O.; Drees, E.A.; Fahmy, A.S. Properties of a cationic peroxidase from Citrus jambhiri cv. Adalia. Appl. Biochem. Biotechnol., 2008, 150(2), 127-137.
[http://dx.doi.org/10.1007/s12010-008-8142-2] [PMID: 18633734]
[27]
Adams, J.B. Regeneration and the kinetics of peroxidase inactivation. Food Chem., 1997, 60, 201-206.
[http://dx.doi.org/10.1016/S0308-8146(96)00320-2]
[28]
Converso, D.A.; Fernández, M.E. Ca2+ activation of wheat peroxidase: a possible physiological mechanism of control. Arch. Biochem. Biophys., 1996, 333(1), 59-65.
[http://dx.doi.org/10.1006/abbi.1996.0364] [PMID: 8806754]
[29]
Sasaki, K.; Yuichi, O.; Hiraga, S.; Gotoh, Y.; Seo, S.; Mitsuhara, I.; Ito, H.; Matsui, H.; Ohashi, Y. Characterization of two rice peroxidase promoters that respond to blast fungus-infection. Mol. Genet. Genomics, 2007, 278(6), 709-722.
[http://dx.doi.org/10.1007/s00438-007-0286-1] [PMID: 17805575]
[30]
Lavania, M.; Chauhan, P.S.; Chauhan, S.V.; Singh, H.B.; Nautiyal, C.S. Induction of plant defense enzymes and phenolics by treatment with plant growth-promoting rhizobacteria Serratia marcescens NBRI1213. Curr. Microbiol., 2006, 52(5), 363-368.
[http://dx.doi.org/10.1007/s00284-005-5578-2] [PMID: 16586018]
[31]
Thordal-Christensen, H.; Brandt, J.; Cho, B.H.; Rasmussen, S.K.; Gregersen, P.L.; Smedegaard-Petersen, V.; Collinge, D.B. cDNA cloning and characterization of two barley transcripts induced differentially by powdery mildew fungus Erysiphie graminis. Physiol. Mol. Plant Pathol., 1992, 40, 395-409.
[http://dx.doi.org/10.1016/0885-5765(92)90031-P]
[32]
Singh, D.P.; Singh, V.; Gupta, V.K.; Shukla, R.; Prabha, R.; Sarma, B.K.; Patel, J.S. Microbial inoculation in rice regulates antioxidative reactions and defense related genes to mitigate drought stress. Sci. Rep., 2020, 10(1), 4818.
[http://dx.doi.org/10.1038/s41598-020-61140-w] [PMID: 32179779]
[33]
Ogawa, S.; Shiro, Y.; Morishima, I. Calcium binding by horseradish peroxidase C and the heme environmental structure. Biochem. Biophys. Res. Commun., 1979, 90(2), 674-678.
[http://dx.doi.org/10.1016/0006-291X(79)91288-9] [PMID: 508331]
[34]
Almargo, L.G.O.; Mezros, L.V.; Bru, S.; Belchi-navarro, R. Ros Barceló. A.; Pedreno, M.A. Class III peroxidases in plant defense reactions. J. Exp. Bot., 2009, 60, 377-390.
[http://dx.doi.org/10.1093/jxb/ern277] [PMID: 19073963]
[35]
Gajhede, M. Plant peroxidases: substrate complexes with mechanistic implications. Biochem. Soc. Trans., 2001, 29(Pt 2), 91-98.
[http://dx.doi.org/10.1042/bst0290091] [PMID: 11356134]
[36]
Itakura, H.; Oda, Y.; Fukuyama, K. Binding mode of benzhydroxamic acid to Arthromyces ramosus peroxidase shown by X-ray crystallographic analysis of the complex at 1.6 A resolution. FEBS Lett., 1997, 412(1), 107-110.
[http://dx.doi.org/10.1016/S0014-5793(97)00751-5] [PMID: 9257700]
[37]
Henriksen, A.; Schuller, D.J.; Meno, K.; Welinder, K.G.; Smith, A.T.; Gajhede, M. Structural interactions between horseradish peroxidase C and the substrate benzhydroxamic acid determined by X-ray crystallography. Biochemistry, 1998, 37(22), 8054-8060.
[http://dx.doi.org/10.1021/bi980234j] [PMID: 9609699]
[38]
Nokthai, P.; Lee, V.S.; Shank, L. Molecular modeling of peroxidase and polyphenol oxidase: substrate specificity and active site comparison. Int. J. Mol. Sci., 2010, 11(9), 3266-3276.
[http://dx.doi.org/10.3390/ijms11093266] [PMID: 20957092]
[39]
Tatoli, S.; Zazza, C.; Sanna, N.; Palma, A.; Aschi, M. The role of arginine 38 in horseradish peroxidase enzyme revisited: a computational investigation. Biophys. Chem., 2009, 141(1), 87-93.
[http://dx.doi.org/10.1016/j.bpc.2008.12.015] [PMID: 19178992]
[40]
Rodriguez-Lopez, J.N.; Smith, A.T.; Thorneley, R.N. Role of arginine 38 in horseradish peroxidase. A critical residue for substrate binding and catalysis. J. Biol. Chem., 1996, 271(8), 4023-4030.
[http://dx.doi.org/10.1074/jbc.271.8.4023] [PMID: 8626735]
[41]
Passardi, F.; Cosio, C.; Penel, C.; Dunand, C. Peroxidases have more functions than a Swiss army knife. Plant Cell Rep., 2005, 24(5), 255-265.
[http://dx.doi.org/10.1007/s00299-005-0972-6] [PMID: 15856234]
[42]
Cosio, C.; Dunand, C. Specific functions of individual class III peroxidase genes. J. Exp. Bot., 2009, 60(2), 391-408.
[http://dx.doi.org/10.1093/jxb/ern318] [PMID: 19088338]
[43]
Christensen, J.H.; Bauw, G.; Welinder, K.G.; Van Montagu, M.; Boerjan, W. Purification and characterization of peroxidases correlated with lignification in poplar xylem. Plant Physiol., 1998, 118(1), 125-135.
[http://dx.doi.org/10.1104/pp.118.1.125] [PMID: 9733532]
[44]
Lin, Y.; Li, W.; Zhang, Y.; Xia, C.; Liu, Y.; Wang, C.; Xu, R.; Zhang, L.; Zhang, L. Identification of genes/proteins related to submergence tolerance by transcriptome and proteome analyses in soybean. Sci. Rep., 2019, 9(1), 14688.
[http://dx.doi.org/10.1038/s41598-019-50757-1] [PMID: 31604973]
[45]
Moural, T.W.; Lewis, K.M.; Barnaba, C.; Zhu, F.; Palmer, N.A.; Sarath, G.; Scully, E.D.; Jones, J.P.; Sattler, S.E.; Kang, C. Characterization of class III peroxidases from switchgrass. Plant Physiol., 2017, 173(1), 417-433.
[http://dx.doi.org/10.1104/pp.16.01426] [PMID: 27879392]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version384msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[17:29:44] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[17:29:44] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[17:29:44] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[17:29:44] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (123ms)time
  • Application (261ms)time
  • 1 x Application (68.03%)
    261ms
    1 x Booting (31.96%)
    123ms
    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 duplicated164ms
    • 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 ('51817477','',1,1740677384,1740677384) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740677384
      920μsalphaeurekaselec_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 ('51817477','/article/110229',1,1740677384,1740677384)
      150μ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 >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) 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 >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) 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 >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) 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 >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) 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 >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) 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 >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51817477 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51817477) limit 1
      24.75msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51817477
      • 1: 51817477
      • 2: 51817477
      • 3: 51817477
      • 4: 51817477
      • 5: 51817477
      • 6: 51817477
      • 7: 51817477
      • 8: 51817477
      • 9: 51817477
      • 10: 51817477
      • 11: 51817477
      • 12: 51817477
      • 13: 51817477
      • 14: 51817477
      • 15: 51817477
      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=110229
      760μ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` = 51 limit 1
      770μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 51
      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=51) and sj.journal_id!=51 group by `j`.`nid`) as `aggregate_table`
      930μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=51) and sj.journal_id!=51 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.01msalphaeurekaselec_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=51) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      3.89msalphaeurekaselec_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=51) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      2.76msalphaeurekaselec_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` = '110229'
      1.51msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 110229
      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` = '110229'
      2.43msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 110229
      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` = '110229' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.14msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 110229
      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
      290μ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
      600μ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 = 51 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      46.6msalphaeurekaselec_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 = 51 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      21.93msalphaeurekaselec_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 = 51 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      30.22msalphaeurekaselec_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` = 110229 limit 1
      200μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 110229
      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 = 110229 and content_type = 'article' order by status desc limit 1
      350μ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` = 186288 limit 1
      200μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 186288
      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
      200μ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` = 'PPL' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      230μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: PPL
      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 = '110229' 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) )
      290μ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 = '10598' 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) )
      290μ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 = '2944' 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) )
      310μ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 <= 51817477 and j.to_ip >=51817477 )) and ((j.from_date <= 1740677384 and j.to_date >= 1740677384 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2944) 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 <= 51817477 and j.to_ip >=51817477 )) and ((j.from_date <= 1740677384 and j.to_date >= 1740677384 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2944) 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 <= 51817477 and j.to_ip >=51817477 )) and ((j.from_date <= 1740677384 and j.to_date >= 1740677384 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2944)
      12.34msalphaeurekaselec_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 <= 51817477 and j.to_ip >=51817477 )) and ((j.from_date <= 1740677384 and j.to_date >= 1740677384 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10598) 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 <= 51817477 and j.to_ip >=51817477 )) and ((j.from_date <= 1740677384 and j.to_date >= 1740677384 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10598) 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 <= 51817477 and j.to_ip >=51817477 )) and ((j.from_date <= 1740677384 and j.to_date >= 1740677384 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10598)
      590μ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 <= 51817477 and j.to_ip >=51817477 )) and ((j.from_date <= 1740677384 and j.to_date >= 1740677384 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 110229) 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 <= 51817477 and j.to_ip >=51817477 )) and ((j.from_date <= 1740677384 and j.to_date >= 1740677384 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 110229) 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 <= 51817477 and j.to_ip >=51817477 )) and ((j.from_date <= 1740677384 and j.to_date >= 1740677384 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 110229)
      810μ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` < '469' and is_uploaded = 1 and issue_id = 10598 order by cast(first_page as SIGNED) desc limit 1
      490μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 469
      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` > '479' and is_uploaded = 1 and issue_id = 10598 order by cast(first_page as SIGNED) asc limit 1
      350μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 479
      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'
      180μ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
      170μ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` = 110229 limit 1
      2.36msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 110229
      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` = 51 and `b`.`banner_from_date` <= 1740677384 and `b`.`banner_to_date` >= 1740677384 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.13msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 51
      • 3: 1740677384
      • 4: 1740677384
      • 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` = 51 and `b`.`banner_from_date` <= 1740677384 and `b`.`banner_to_date` >= 1740677384 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.12msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 51
      • 3: 1740677384
      • 4: 1740677384
      • 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='747fafa8e4955caa3fa90ed3d002770f'
      240μ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
        FIWM7DrHnuJ90UpP8qmt0qbpkZ9ZbcxNZyYFUb2h
        uc_cart_id
        747fafa8e4955caa3fa90ed3d002770f
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/110229" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/110229
        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 17:29:44 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjV3ek9Bc1p3RWVQOXhFaWI1bERZSnc9PSIsInZhbHVlIjoiVkNrREp0eEx0VW8yTEJMZTd2NDdZRVNwT3U1QVFSNG5NY0FwdjNCSFZuVzk1WURoeWR5TUMyTU9BbXl5Z0tobC9sVkE4RE9iN0p4ZXFTY3cxM3dKU0I5VXU1R3lsNlNYaFd1amtIQUtPdjBDQm4rUDNTMHhtcTR1aG5hSHhLYmEiLCJtYWMiOiI2NDNmZWE3M2QxYjNkZjlkOTUzYzkzYzgxODE4NmMyODQ1OTE1MjYyMWJmZTBkZjBjNzIwOTBkZjQ4OTU4MzU4IiwidGFnIjoiIn0%3D; expires=Sun, 02 Mar 2025 05:29:44 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjV3ek9Bc1p3RWVQOXhFaWI1bERZSnc9PSIsInZhbHVlIjoiVkNrREp0eEx0VW8yTEJMZTd2NDdZRVNwT3U1QVFSNG5NY0FwdjNCSFZuVzk1WURoeWR5TUMyTU9BbXl5Z0tobC9sVkE4R" 1 => "alphaeurekaselectnet_session=eyJpdiI6IldncncrdU9nakNXN0dCNmx2ZTU4TXc9PSIsInZhbHVlIjoibGdwNmVNV2txdVpWSEl6LzdYNGErVmtMc3Juc3UxWWhSZnE2eTFNMFphbjZDY1hFWGY3UWlGUW13K201Z0Nsb2I4WXZacnQ3bmJ1QTVMTnNqR1RDM2VRSTEzQWRYYTB6VzRYQis4WUV5UDRDUHc5ZDBuKzJVa2xTdm9UYy9TYnoiLCJtYWMiOiIwNGM4NDIyNzBjNTcxMTA2MmYyYmIzNGUzNzU3ZDA2ZDgyZWQyZmQxMDE5MTNlODZhMTk1M2MzOTM1MTBjNDBmIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IldncncrdU9nakNXN0dCNmx2ZTU4TXc9PSIsInZhbHVlIjoibGdwNmVNV2txdVpWSEl6LzdYNGErVmtMc3Juc3UxWWhSZnE2eTFNMFphbjZDY1hFWGY3UWlGUW1" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjV3ek9Bc1p3RWVQOXhFaWI1bERZSnc9PSIsInZhbHVlIjoiVkNrREp0eEx0VW8yTEJMZTd2NDdZRVNwT3U1QVFSNG5NY0FwdjNCSFZuVzk1WURoeWR5TUMyTU9BbXl5Z0tobC9sVkE4RE9iN0p4ZXFTY3cxM3dKU0I5VXU1R3lsNlNYaFd1amtIQUtPdjBDQm4rUDNTMHhtcTR1aG5hSHhLYmEiLCJtYWMiOiI2NDNmZWE3M2QxYjNkZjlkOTUzYzkzYzgxODE4NmMyODQ1OTE1MjYyMWJmZTBkZjBjNzIwOTBkZjQ4OTU4MzU4IiwidGFnIjoiIn0%3D; expires=Sun, 02-Mar-2025 05:29:44 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjV3ek9Bc1p3RWVQOXhFaWI1bERZSnc9PSIsInZhbHVlIjoiVkNrREp0eEx0VW8yTEJMZTd2NDdZRVNwT3U1QVFSNG5NY0FwdjNCSFZuVzk1WURoeWR5TUMyTU9BbXl5Z0tobC9sVkE4R" 1 => "alphaeurekaselectnet_session=eyJpdiI6IldncncrdU9nakNXN0dCNmx2ZTU4TXc9PSIsInZhbHVlIjoibGdwNmVNV2txdVpWSEl6LzdYNGErVmtMc3Juc3UxWWhSZnE2eTFNMFphbjZDY1hFWGY3UWlGUW13K201Z0Nsb2I4WXZacnQ3bmJ1QTVMTnNqR1RDM2VRSTEzQWRYYTB6VzRYQis4WUV5UDRDUHc5ZDBuKzJVa2xTdm9UYy9TYnoiLCJtYWMiOiIwNGM4NDIyNzBjNTcxMTA2MmYyYmIzNGUzNzU3ZDA2ZDgyZWQyZmQxMDE5MTNlODZhMTk1M2MzOTM1MTBjNDBmIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IldncncrdU9nakNXN0dCNmx2ZTU4TXc9PSIsInZhbHVlIjoibGdwNmVNV2txdVpWSEl6LzdYNGErVmtMc3Juc3UxWWhSZnE2eTFNMFphbjZDY1hFWGY3UWlGUW1" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "FIWM7DrHnuJ90UpP8qmt0qbpkZ9ZbcxNZyYFUb2h" "uc_cart_id" => "747fafa8e4955caa3fa90ed3d002770f" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/110229" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-27 17:29:44GET/article/110229414361