Generic placeholder image

Protein & Peptide Letters

Editor-in-Chief

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

Research Article

Immunological Function of the Antibacterial Peptide Attacin-Like in the Chinese Oak Silkworm, Antheraea pernyi

Author(s): Qingqing Li, Jiawei Zhang, Yu Sun, Lei Wang, Cen Qian, Guoqing Wei, Baojian Zhu* and Chaoliang Liu*

Volume 27, Issue 10, 2020

Page: [953 - 961] Pages: 9

DOI: 10.2174/0929866527666200505210113

Price: $65

Abstract

Background: Antibacterial peptides play important roles in the innate immune system of insects and are divided into four categories according to their structures. Although many antibacterial peptides have been reported in lepidopteran insects, the roles of an attacin-like gene in immune response of Antheraea pernyi remain unclear.

Objective: In this study, the cloning and immunological functions of an attacin-like gene from Antheraea pernyi were investigated.

Methods: The open reading frame of Ap-attacin-like gene was cloned by PCR using the specific primers and then was ligated to the pET-32a vector to construct the recombinant plasmids Ap-attacin- like-pET-32a. The recombinant Ap-attacin-like protein was expressed in E. coli (BL21 DE3) cells and purified by Ni-NTA affinity chromatography. The expression patterns of Ap-attacin-like in different tissues or under microorganism challenges were investigated by real-time PCR and western blotting. Finally, agar well diffusion assay was performed to determine the antimicrobial activity of the recombinant Ap-attacin-like proteins based on the inhibition rate.

Results: The expression level of Ap-attacin-like was highest in the fat body compared with the other examined tissues. The expression of Ap-attacin-like in the fat body was significantly elevated after E. coli, Beauveria bassiana, Micrococcus luteus or Nuclear Polyhedrosis Virus challenges. In addition, the recombinant Ap-attacin-like proteins had obvious antibacterial activity against E. coli.

Conclusion: Ap-attacin-like was highly expressed in immune-related tissues and its expression level was significantly induced by different microorganism challenges, suggesting that Ap-attacin-like participated in the innate immunity of A. pernyi.

Keywords: Antimicrobial peptides, innate immunity, Antheraea pernyi, attacin, E. coli, Nuclear Polyhedrosis Virus.

Graphical Abstract

[1]
Marmaras, V.J.; Lampropoulou, M. Regulators and signalling in insect haemocyte immunity. Cell. Signal., 2009, 21(2), 186-195.
[http://dx.doi.org/10.1016/j.cellsig.2008.08.014] [PMID: 18790716]
[2]
Lavine, M.D.; Strand, M.R. Insect hemocytes and their role in immunity. Insect Biochem. Mol. Biol., 2002, 32(10), 1295-1309.
[http://dx.doi.org/10.1016/S0965-1748(02)00092-9] [PMID: 12225920]
[3]
Lemaitre, B.; Hoffmann, J. The host defense of Drosophila melanogaster. Annu. Rev. Immunol., 2007, 25, 697-743.
[http://dx.doi.org/10.1146/annurev.immunol.25.022106.141615] [PMID: 17201680]
[4]
Fullaondo, A.; Lee, S.Y. Regulation of Drosophila-virus interaction. Dev. Comp. Immunol., 2012, 36(2), 262-266.
[http://dx.doi.org/10.1016/j.dci.2011.08.007] [PMID: 21925207]
[5]
Moy, R.H.; Cherry, S. Antimicrobial autophagy: A conserved innate immune response in Drosophila. J. Innate Immun., 2013, 5(5), 444-455.
[http://dx.doi.org/10.1159/000350326] [PMID: 23689401]
[6]
Yi, H.Y.; Chowdhury, M.; Huang, Y.D.; Yu, X.Q. Insect antimicrobial peptides and their applications. Appl. Microbiol. Biotechnol., 2014, 98(13), 5807-5822.
[http://dx.doi.org/10.1007/s00253-014-5792-6] [PMID: 24811407]
[7]
Cruz, J.; Ortiz, C.; Guzmán, F.; Fernández-Lafuente, R.; Torres, R. Antimicrobial peptides: Promising compounds against pathogenic microorganisms. Curr. Med. Chem., 2014, 21(20), 2299-2321.
[http://dx.doi.org/10.2174/0929867321666140217110155] [PMID: 24533812]
[8]
Wang, G. Human antimicrobial peptides and proteins. Pharmaceuticals (Basel), 2014, 7(5), 545-594.
[http://dx.doi.org/10.3390/ph7050545] [PMID: 24828484]
[9]
Lakshmaiah-Narayana, J.; Chen, J.Y. Antimicrobial peptides: Possible anti-infective agents. Peptides, 2015, 72, 88-94.
[http://dx.doi.org/10.1016/j.peptides.2015.05.012] [PMID: 26048089]
[10]
Hultmark, D.; Engström, A.; Andersson, K.; Steiner, H.; Bennich, H.; Boman, H.G. Insect immunity. Attacins, a family of antibacterial proteins from Hyalophora cecropia. EMBO J., 1983, 2(4), 571-576.
[http://dx.doi.org/10.1002/j.1460-2075.1983.tb01465.x] [PMID: 6628360]
[11]
Liao, Y.Y.; Zuo, Y.H.; Tsai, C.L.; Hsu, C.M.; Chen, M.E. cDNA cloning and transcriptional regulation of the cecropin and attacin from the oriental fruit fly, Bactrocera dorsalis (diptera: tephritidae). Arch. Insect Biochem. Physiol., 2015, 89(2), 126.
[http://dx.doi.org/10.1002/arch.21230] [PMID: 5781309]
[12]
Sun, S.C.; Lindström, I.; Lee, J.Y.; Faye, I. Structure and expression of the attacin genes in Hyalophora cecropia. Eur. J. Biochem., 1991, 196(1), 247-254.
[http://dx.doi.org/10.1111/j.1432-1033.1991.tb15811.x] [PMID: 2001705]
[13]
Kockum, K.; Faye, I.; Hofsten, P.V.; Lee, J.Y.; Xanthopoulos, K.G.; Boman, H.G. Insect immunity. Isolation and sequence of two cDNA clones corresponding to acidic and basic attacins from Hyalophora cecropia. EMBO J., 1984, 3(9), 2071-2075.
[http://dx.doi.org/10.1002/j.1460-2075.1984.tb02093.x] [PMID: 16453548]
[14]
Gunne, H.; Hellers, M.; Steiner, H. Structure of preproattacin and its processing in insect cells infected with a recombinant baculovirus. Eur. J. Biochem., 1990, 187(3), 699-703.
[http://dx.doi.org/10.1111/j.1432-1033.1990.tb15356.x] [PMID: 2406140]
[15]
Engström, P.; Carlsson, A.; Engström, A.; Tao, Z.J.; Bennich, H. The antibacterial effect of attacins from the silk moth Hyalophora cecropia is directed against the outer membrane of Escherichia coli. EMBO J., 1984, 3(13), 3347-3351.
[http://dx.doi.org/10.1002/j.1460-2075.1984.tb02302.x] [PMID: 6396089]
[16]
Carlsson, A.; Engström, P.; Palva, E.T.; Bennich, H. Attacin, an antibacterial protein from Hyalophora cecropia, inhibits synthesis of outer membrane proteins in Escherichia coli by interfering with omp gene transcription. Infect. Immun., 1991, 59(9), 3040-3045.
[http://dx.doi.org/10.1128/IAI.59.9.3040-3045.1991] [PMID: 1715318]
[17]
Carlsson, A.; Nyström, T.; de Cock, H.; Bennich, H. Attacin--an insect immune protein-binds LPS and triggers the specific inhibition of bacterial outer-membrane protein synthesis. Microbiology, 1998, 144(Pt 8), 2179-2188.
[http://dx.doi.org/10.1099/00221287-144-8-2179] [PMID: 9720039]
[18]
Kwon, Y.M.; Kim, H.J.; Kim, Y.I.; Kang, Y.J.; Lee, I.H.; Jin, B.R.; Han, Y.S.; Cheon, H.M.; Ha, N.G.; Seo, S.J. Comparative analysis of two attacin genes from Hyphantria cunea. Comp. Biochem. Physiol. B Biochem. Mol. Biol., 2008, 151(2), 213-220.
[http://dx.doi.org/10.1016/j.cbpb.2008.07.002] [PMID: 18682300]
[19]
Kausar, S.; Abbas, M.N.; Qian, C.; Zhu, B.; Sun, Y.; Sun, Y.; Wang, L.; Wei, G.; Maqsood, I.; Liu, C.L. Serpin-14 negatively regulates prophenoloxidase activation and expression of antimicrobial peptides in Chinese oak silkworm Antheraea pernyi. Dev. Comp. Immunol., 2017, 76, 45-55.
[http://dx.doi.org/10.1016/j.dci.2017.05.017] [PMID: 28545959]
[20]
Park, S.H.; Kim, A.Y.; Ma, S.H.; Kim, H.M.; Kang, H.S.; Maeng, J.S.; Ko, K.; Chung, I.S.; Joung, Y.H. Purification of human carcinoma antigen GA733-2 expressed in Escherichia coli and production of its polyclonal antibody in rabbit. Anim. Cells Syst., 2015, 19(3), 1-6.
[http://dx.doi.org/10.1080/19768354.2015.1030345]
[21]
Gao, J.; Sun, Y.; Sun, Y.; Chen, C.; Kausar, S.; Tian, J.; Zhu, B.; Liu, C. Identification and function of cAMP response element binding protein in Oak silkworm Antheraea pernyi. J. Invertebr. Pathol., 2018, 151, 14-20.
[http://dx.doi.org/10.1016/j.jip.2017.10.006] [PMID: 29079530]
[22]
Livak, K.J.; Schmittgen, T.D. Analysis of relative gene expression data using real-time quantitative PCR and the 2(-Delta Delta C(T)) method. Methods, 2001, 25(4), 402-408.
[http://dx.doi.org/10.1006/meth.2001.1262] [PMID: 11846609]
[23]
Boulanger, N.; Munks, R.J.; Hamilton, J.V.; Vovelle, F.; Brun, R.; Lehane, M.J.; Bulet, P. Epithelial innate immunity. A novel antimicrobial peptide with antiparasitic activity in the blood-sucking insect Stomoxys calcitrans. J. Biol. Chem., 2002, 277(51), 49921-49926.
[http://dx.doi.org/10.1074/jbc.M206296200] [PMID: 12372834]
[24]
Zhou, Z.X.; Huang, Q.H.; Zhu, S.; Zhou, L. Establishment of rapid determining method for antibacterial activity by microplate reader. Adv. Microbiol., 2014, 3, 29-35.
[http://dx.doi.org/10.12677/AMB.2014.32004]
[25]
Tamura, K.; Peterson, D.; Peterson, N.; Stecher, G.; Nei, M.; Kumar, S. MEGA5: Molecular evolutionary genetics analysis using maximum likelihood, evolutionary distance, and maximum parsimony methods. Mol. Biol. Evol., 2011, 28(10), 2731-2739.
[http://dx.doi.org/10.1093/molbev/msr121] [PMID: 21546353]
[26]
Liu, S.Y.; Wang, H.L.; Na, J. Application potential of insect antimicrobial peptides in agricultural production. Tianjin Agri. Sci., 2013, 19, 50-53.
[27]
Tonk, M.; Vilcinskas, A.; Rahnamaeian, M. Insect antimicrobial peptides: Potential tools for the prevention of skin cancer. Appl. Microbiol. Biotechnol., 2016, 100(17), 7397-7405.
[http://dx.doi.org/10.1007/s00253-016-7718-y] [PMID: 27418360]
[28]
Wu, Q.; Patočka, J.; Kuča, K. Insect antimicrobial peptides, a mini review. Toxins (Basel), 2018, 10(11), E461.
[http://dx.doi.org/10.3390/toxins10110461] [PMID: 30413046]
[29]
Ourth, D.D.; Lockey, T.D.; Renis, H.E. Induction of cecropin-like and attacin-like antibacterial but not antiviral activity in Heliothis virescens larvae. Biochem. Biophys. Res. Commun., 1994, 200(1), 35-44.
[http://dx.doi.org/10.1006/bbrc.1994.1410] [PMID: 8166704]
[30]
Sugiyama, M.; Kuniyoshi, H.; Kotani, E.; Taniai, K.; Kadono-Okuda, K.; Kato, Y.; Yamamoto, M.; Shimabukuro, M.; Chowdhury, S.; Xu, J.; Choi, K.; Kataoka, H.; Suzuki, A.; Yamakawa, M. Characterization of a Bombyx mori cDNA encoding a novel member of the attacin family of insect antibacterial proteins. Insect Biochem. Mol. Biol., 1995, 25(3), 385-392.
[http://dx.doi.org/10.1016/0965-1748(94)00080-2] [PMID: 7773256]
[31]
Sudha, R.; Murthy, G.N.; Awasthi, A.K.; Ponnuvel, K.M. Attacin gene sequence variations in different ecoraces of tasar silkworm Antheraea mylitta. Bioinformation, 2015, 11(10), 481-485.
[http://dx.doi.org/10.6026/97320630011481] [PMID: 26664033]
[32]
Bang, K.; Park, S.; Yoo, J.Y.; Cho, S. Characterization and expression of attacin, an antibacterial protein-encoding gene, from the beet armyworm, Spodoptera exigua (Hübner) (Insecta: Lepidoptera: Noctuidae). Mol. Biol. Rep., 2012, 39(5), 5151-5159.
[http://dx.doi.org/10.1007/s11033-011-1311-3] [PMID: 22160467]
[33]
Asling, B.; Dushay, M.S.; Hultmark, D. Identification of early genes in the Drosophila immune response by PCR-based differential display: The Attacin A gene and the evolution of attacin-like proteins. Insect Biochem. Mol. Biol., 1995, 25(4), 511-518.
[http://dx.doi.org/10.1016/0965-1748(94)00091-C] [PMID: 7742836]
[34]
Dushay, M.S.; Roethele, J.B.; Chaverri, J.M.; Dulek, D.E.; Syed, S.K.; Kitami, T.; Eldon, E.D. Two attacin antibacterial genes of Drosophila melanogaster. Gene, 2000, 246(1-2), 49-57.
[http://dx.doi.org/10.1016/S0378-1119(00)00041-X] [PMID: 10767526]
[35]
Wang, L.N.; Yu, B.; Han, G.Q.; Chen, D.W. Molecular cloning, expression in Escherichia coli of Attacin A gene from Drosophila and detection of biological activity. Mol. Biol. Rep., 2010, 37(5), 2463-2469.
[http://dx.doi.org/10.1007/s11033-009-9758-1] [PMID: 19711194]
[36]
Wang, J.; Hu, C.; Wu, Y.; Stuart, A.; Amemiya, C.; Berriman, M.; Toyoda, A.; Hattori, M.; Aksoy, S. Characterization of the antimicrobial peptide attacin loci from Glossina morsitans. Insect Mol. Biol., 2008, 17(3), 293-302.
[http://dx.doi.org/10.1111/j.1365-2583.2008.00805.x] [PMID: 18477243]
[37]
Shin, H.S.; Park, S.I. Novel attacin from Hermetia illucens: cDNA cloning, characterization, and antibacterial properties. Prep. Biochem. Biotechnol., 2019, 49(3), 279-285.
[http://dx.doi.org/10.1080/10826068.2018.1541807] [PMID: 30767702]
[38]
Jo, Y.H.; Park, S.; Park, K.B.; Noh, M.Y.; Cho, J.H.; Ko, H.J.; Kim, C.E.; Patnaik, B.B.; Kim, J.; Won, R.; Bang, I.S.; Lee, Y.S.; Han, Y.S. In silico identification, characterization and expression analysis of attacin gene family in response to bacterial and fungal pathogens in Tenebrio molitor. Entomol. Res., 2018, 48, 45-54.
[http://dx.doi.org/10.1111/1748-5967.12287]
[39]
Li, J.Q.; Lu, X.Y.; Ma, J. Characterization and expression analysis of attacins, antimicro bial peptide-encoding genes, from the desert beetle Microdera punctipennis in response to low temperatures. Cryo Lett., 2017, 38(1), 65-74.
[PMID: 28376142]
[40]
Kishimoto, K.; Fujimoto, S.; Matsumoto, K.; Yamano, Y.; Morishima, I. Protein purification, cDNA cloning and gene expression of attacin, an antibacterial protein, from eri-silkworm, Samia cynthia ricini. Insect Biochem. Mol. Biol., 2002, 32(8), 881-887.
[http://dx.doi.org/10.1016/S0965-1748(01)00177-1] [PMID: 12110295]
[41]
Lekha, G.; Gupta, T.; Trivedy, K.; Ponnuvel, K. Paralogous gene conversion, allelic di vergence attacin genes and its expression profile in response to BmNPV infection in silkworm Bombyx mori. Invert. Surviv. J., 2015, 12, 214-224.
[42]
Hu, Y.; Aksoy, S. An antimicrobial peptide with trypanocidal activity characterized from Glossina morsitans morsitans. Insect Biochem. Mol. Biol., 2005, 35(2), 105-115.
[http://dx.doi.org/10.1016/j.ibmb.2004.10.007] [PMID: 15681221]
[43]
Xie, L.P.; Chen, G.Z.; Zhu, C.B.; Zhu, B.Q.; Hu, Y.J. Structural modification and expression of Attacin A from Glossina morsitans morsitans in E. coli and its antibacterial activities Int. J. Pept. Res. Ther., 2009, 15, 255-261.
[http://dx.doi.org/10.1007/s10989-009-9186-z]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version306msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:28:29] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:28:30] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:28:30] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (90.81ms)time
  • Application (215ms)time
  • 1 x Application (70.34%)
    215ms
    1 x Booting (29.66%)
    90.81ms
    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
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated132ms
    • 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 ('314570456','',1,1740515309,1740515309) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740515309
      1.28msalphaeurekaselec_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 ('314570456','/article/106382',1,1740515309,1740515309)
      210μ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 >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) 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 >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) 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 >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) 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 >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) 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 >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) 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 >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314570456 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314570456) limit 1
      15.4msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314570456
      • 1: 314570456
      • 2: 314570456
      • 3: 314570456
      • 4: 314570456
      • 5: 314570456
      • 6: 314570456
      • 7: 314570456
      • 8: 314570456
      • 9: 314570456
      • 10: 314570456
      • 11: 314570456
      • 12: 314570456
      • 13: 314570456
      • 14: 314570456
      • 15: 314570456
      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=106382
      730μ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
      870μ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`
      860μ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
      770μ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=51) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.92msalphaeurekaselec_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.09msalphaeurekaselec_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` = '106382'
      270μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 106382
      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` = '106382'
      2.38msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 106382
      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` = '106382' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.34msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 106382
      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
      240μ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
      480μ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
      21.82msalphaeurekaselec_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
      12.74msalphaeurekaselec_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
      13.4msalphaeurekaselec_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` = 106382 limit 1
      240μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 106382
      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 = 106382 and content_type = 'article' order by status desc limit 1
      300μ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 a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 16 and cd.sub_disease_id = 488 and content_id!=106382 and cd.content_type = 'article' order by rand() limit 20
      32.36msalphaeurekaselec_live_10_06_2022Article.php#769
      Backtrace
      • 11. app/Models/Article.php:769
      • 12. app/Http/Controllers/ArticleController.php:2098
      • 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` = 181681 limit 1
      210μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 181681
      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
      190μ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
      240μ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 = '106382' 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) )
      310μ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 = '10132' 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) )
      250μ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 = '2694' 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) )
      280μ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 <= 314570456 and j.to_ip >=314570456 )) and ((j.from_date <= 1740515310 and j.to_date >= 1740515310 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2694) 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 <= 314570456 and j.to_ip >=314570456 )) and ((j.from_date <= 1740515310 and j.to_date >= 1740515310 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2694) 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 <= 314570456 and j.to_ip >=314570456 )) and ((j.from_date <= 1740515310 and j.to_date >= 1740515310 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2694)
      12.35msalphaeurekaselec_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 <= 314570456 and j.to_ip >=314570456 )) and ((j.from_date <= 1740515310 and j.to_date >= 1740515310 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10132) 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 <= 314570456 and j.to_ip >=314570456 )) and ((j.from_date <= 1740515310 and j.to_date >= 1740515310 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10132) 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 <= 314570456 and j.to_ip >=314570456 )) and ((j.from_date <= 1740515310 and j.to_date >= 1740515310 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10132)
      580μ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 <= 314570456 and j.to_ip >=314570456 )) and ((j.from_date <= 1740515310 and j.to_date >= 1740515310 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 106382) 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 <= 314570456 and j.to_ip >=314570456 )) and ((j.from_date <= 1740515310 and j.to_date >= 1740515310 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 106382) 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 <= 314570456 and j.to_ip >=314570456 )) and ((j.from_date <= 1740515310 and j.to_date >= 1740515310 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 106382)
      540μ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` < '953' and is_uploaded = 1 and issue_id = 10132 order by cast(first_page as SIGNED) desc limit 1
      520μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 953
      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` > '961' and is_uploaded = 1 and issue_id = 10132 order by cast(first_page as SIGNED) asc limit 1
      400μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 961
      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'
      150μ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` = 106382 limit 1
      2.29msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 106382
      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` <= 1740515310 and `b`.`banner_to_date` >= 1740515310 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.1msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 51
      • 3: 1740515310
      • 4: 1740515310
      • 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` <= 1740515310 and `b`.`banner_to_date` >= 1740515310 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.04msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 51
      • 3: 1740515310
      • 4: 1740515310
      • 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='4159c2020a4092943d0461f41460ba59'
      180μ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
        5g5quxLhr6K3457ndC9xw6jzamS2AhC2MdNr697b
        uc_cart_id
        4159c2020a4092943d0461f41460ba59
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/106382" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/106382
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:9 [ "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6IkZoTFJPc2Q3M0c4TFpBVnpXdnA5QlE9PSIsInZhbHVlIjoiSkVpeEJDOEp6elRpOEw0cjFpWU55MGlmQzREZTdhTDF1djdDWFF4Q0tTVT0iLCJtYWMiOiJiYzMzMzJiMTE3Njg5NzVmY2JhMzM1YmM5MDgzNzliMzFmZjYyNzA1ODIzMDU0ZWZhNDQ4YThjZmU1NDI3NDcyIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IkZoTFJPc2Q3M0c4TFpBVnpXdnA5QlE9PSIsInZhbHVlIjoiSkVpeEJDOEp6elRpOEw0cjFpWU55MGlmQzREZTdhTDF1djdDWFF4Q0tTVT0iLCJtYWMiOiJiYzMzMzJiMTE3Njg5" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 25 Feb 2025 20:28:30 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjZFcTRyZ3daK0JTWmd0NWZEdzFNSHc9PSIsInZhbHVlIjoiUDBWSjE2M2FoMmpDczRqREwxUllDWVY4TjY5eXhmdVFkbHg3aDMweUh4OHh1VDVBc2J3UHdhanVhcDh4akFqdEVyTTN5RVVlME5peURRVktNVFgyZDNZcVo0ei9sWURwZFBRYmVnN1l5NXJBdm5mRkcxNk1BbC94LzhMK0VoV0wiLCJtYWMiOiIxZWMzZjZiODhjMjFmMDc4MDNhYzA3ZDFhOWE1YzNjN2I3YjA5ZjZmODgwN2FkMzFlYjJjYjNlY2JmZDQ3ZTIzIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 08:28:30 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjZFcTRyZ3daK0JTWmd0NWZEdzFNSHc9PSIsInZhbHVlIjoiUDBWSjE2M2FoMmpDczRqREwxUllDWVY4TjY5eXhmdVFkbHg3aDMweUh4OHh1VDVBc2J3UHdhanVhcDh4akFqdEVyTTN5R" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ill6NENCM25wdE92UFRoQUJuZWVZS3c9PSIsInZhbHVlIjoiYkY2Q2RIOGI3MnlkT3BBYXh0S0hnYnFXMHJtNzBjSGhsY0xpK2dIeXZKcmczSXhvRkRrY0hVaFA3NGk2MU5MM0RnaGtNdStzOGZ5cjhHdkJhSkF2VHlQY2pEMXBhQ3BxU3hFdEFIZTl4MXB0STdraWJoUjlhM2c0K3FqTXM3ZjYiLCJtYWMiOiIyYWNmNWQzYTA1NTQzNjBiMDU2MTRiOTFjOGZlYmZjZTRlYmNmZjU0OTc0NTI2YjM5MmRjOTg3ZWM5N2I3ZWQ3IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ill6NENCM25wdE92UFRoQUJuZWVZS3c9PSIsInZhbHVlIjoiYkY2Q2RIOGI3MnlkT3BBYXh0S0hnYnFXMHJtNzBjSGhsY0xpK2dIeXZKcmczSXhvRkRrY0hVaFA" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjZFcTRyZ3daK0JTWmd0NWZEdzFNSHc9PSIsInZhbHVlIjoiUDBWSjE2M2FoMmpDczRqREwxUllDWVY4TjY5eXhmdVFkbHg3aDMweUh4OHh1VDVBc2J3UHdhanVhcDh4akFqdEVyTTN5RVVlME5peURRVktNVFgyZDNZcVo0ei9sWURwZFBRYmVnN1l5NXJBdm5mRkcxNk1BbC94LzhMK0VoV0wiLCJtYWMiOiIxZWMzZjZiODhjMjFmMDc4MDNhYzA3ZDFhOWE1YzNjN2I3YjA5ZjZmODgwN2FkMzFlYjJjYjNlY2JmZDQ3ZTIzIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 08:28:30 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjZFcTRyZ3daK0JTWmd0NWZEdzFNSHc9PSIsInZhbHVlIjoiUDBWSjE2M2FoMmpDczRqREwxUllDWVY4TjY5eXhmdVFkbHg3aDMweUh4OHh1VDVBc2J3UHdhanVhcDh4akFqdEVyTTN5R" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ill6NENCM25wdE92UFRoQUJuZWVZS3c9PSIsInZhbHVlIjoiYkY2Q2RIOGI3MnlkT3BBYXh0S0hnYnFXMHJtNzBjSGhsY0xpK2dIeXZKcmczSXhvRkRrY0hVaFA3NGk2MU5MM0RnaGtNdStzOGZ5cjhHdkJhSkF2VHlQY2pEMXBhQ3BxU3hFdEFIZTl4MXB0STdraWJoUjlhM2c0K3FqTXM3ZjYiLCJtYWMiOiIyYWNmNWQzYTA1NTQzNjBiMDU2MTRiOTFjOGZlYmZjZTRlYmNmZjU0OTc0NTI2YjM5MmRjOTg3ZWM5N2I3ZWQ3IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ill6NENCM25wdE92UFRoQUJuZWVZS3c9PSIsInZhbHVlIjoiYkY2Q2RIOGI3MnlkT3BBYXh0S0hnYnFXMHJtNzBjSGhsY0xpK2dIeXZKcmczSXhvRkRrY0hVaFA" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "5g5quxLhr6K3457ndC9xw6jzamS2AhC2MdNr697b" "uc_cart_id" => "4159c2020a4092943d0461f41460ba59" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/106382" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 20:28:30GET/article/106382314371