Generic placeholder image

Current Proteomics

Editor-in-Chief

ISSN (Print): 1570-1646
ISSN (Online): 1875-6247

Research Article

Cloning, Expression and Biochemical Characterization of the Recombinant α-amylase from Bacillus subtilis YX48

Author(s): Yan Shan , Junjie Shang *, Dongfang Zhang , Yinshan Cui , Yi Wang , Jie Zhu, Yongkai Ma, Pengfei Song , Kunhao Qin, Xiuling Ji, Yunlin Wei* and Lijun Wu

Volume 19, Issue 3, 2022

Published on: 11 January, 2022

Page: [218 - 225] Pages: 8

DOI: 10.2174/1570164618666210726161428

Price: $65

Abstract

Background: Amylase used in the market is mostly medium-temperature enzyme or high-temperature enzyme and has poor enzyme activity under low-temperature environment. Acid α-amylase can be used to develop digestion additives in the pharmaceutical and healthcare industries. The amino acid sequence and structural differences among α-amylases obtained from various organisms are high enough to confer interesting biochemical diversity to the enzymes. However, low- temperature (0-50°C) amylase, with an optimum temperature and heat sensitivity, has a greater potential value than medium (50-80°C) and high (80-110°C) temperature amylases.

Methodology: The gene amy48 from encoding extracellular α-amylase in Bacillus subtilis YX48 was successfully cloned into the pET30a (+) vector and expressed in Escherichia coli BL21 (DE3) for biochemical characterization.

Results and Conclusion: The molecular weight of α-amylase was 75 kDa. The activity of α-amylase was not affected by Ca2+, and Amy48 had the best activity at pH 5.0 and 37°C. AMY48 has high stability over a narrow pH and temperature range (5.0-8.0 and 30-45°C). Amylase activity was strongly inhibited by Zn2+, Mn2+, Cu2+, and Fe2+ ions, but Na+, K+, and Co2+ ions stimulate its activity slightly. The purified enzyme showed gradually reduced activity in the presence of detergents. However, it was remarkably stable against EDTA and urea.

Keywords: α-amylase, Bacillus subtilis, YX48, characterization, organic, solvents.

Graphical Abstract

[1]
Ibrahim, S.R.M.; Mohamed, G.A.; Khayat, M.T.; Ahmed, S.; Abo-Haded, H.; Alshali, K.Z. Mangostanaxanthone VIIII, a new xanthone from Garcinia mangostana pericarps, alpha-amylase inhibitory activity, and molecular docking studies. Braz. J. Pharmacogn., 2019, 29(2), 206-212.
[http://dx.doi.org/10.1016/j.bjp.2019.02.005]
[2]
Marmouzi, I. Pharmacological and chemical properties of some marine echinoderms. Braz. J. Pharmacogn., 2018, 28(5), 575-581.
[http://dx.doi.org/10.1016/j.bjp.2018.05.015]
[3]
de Souza, P.M.; de Oliveira Magalhães, P. Application of microbial α-amylase in industry - a review. Braz. J. Microbiol., 2010, 41(4), 850-861.
[http://dx.doi.org/10.1590/S1517-83822010000400004] [PMID: 24031565]
[4]
Li, Z.; Siepmann, F.B.; Rojas Tovar, L.E.; Chen, X.; Gänzle, M.G. Effect of copy number of the spoVA2mob operon, sourdough and reutericyclin on ropy bread spoilage caused by Bacillus spp. Food Microbiol., 2020, 91(Oct), 103507.
[http://dx.doi.org/10.1016/j.fm.2020.103507] [PMID: 32539950]
[5]
Ozdemir, S.; Fincan, S.A.; Karakaya, A.; Enez, B. A novel raw starch hydrolyzing thermostable alpha-amylase produced by newly isolated Bacillus mojavensis SO-10: Purification, characterization and usage in starch industries. Braz Arch Biol Techn, 2018, 61.
[6]
Valeriano, I.H.; Marques, G.L.L.; Freitas, S.P.; Couri, S.; Penha, E.M.; Gonçalves, M.M.M. Cassava pulp enzymatic hydrolysate as a promising feedstock for ethanol production. Braz. Arch. Biol. Technol., 2018, 61, e18161214.
[http://dx.doi.org/10.1590/1678-4324-2018161214]
[7]
Abd-Elaziz, A.M.; Karam, E.A.; Ghanem, M.M.; Moharam, M.E.; Kansoh, A.L. Production of a novel α-amylase by Bacillus atrophaeus NRC1 isolated from honey: Purification and characterization. Int. J. Biol. Macromol., 2020, 148, 292-301.
[http://dx.doi.org/10.1016/j.ijbiomac.2020.01.120] [PMID: 31945438]
[8]
Mehta, D.; Satyanarayana, T. Bacterial and archaeal α-amylases: diversity and amelioration of the desirable characteristics for industrial applications. Front. Microbiol., 2016, 7(Jul), 1129.
[http://dx.doi.org/10.3389/fmicb.2016.01129] [PMID: 27516755]
[9]
Cunha, J.R.B.; Santos, F.C.P.D.; Assis, F.G.D.V.D.; Leal, P.L. Cultivo de Penicillium spp. em resíduos da colheita de soja para produção de celulase, protease e amilase. Revista Ceres, 2016, 63(5), 597-604.
[http://dx.doi.org/10.1590/0034-737x201663050002]
[10]
Lu, M.S.; Fang, Y.W.; Li, H.Z.; Liu, H.F.; Wang, S.J. Isolation of a novel cold-adapted amylase-producing bacterium and study of its enzyme production conditions. Ann. Microbiol., 2010, 60(3), 557-563.
[http://dx.doi.org/10.1007/s13213-010-0090-8]
[11]
Pathak, A.P.; Rathod, M.G.; Mahabole, M.P.; Khairnar, R.S. Enhanced catalytic activity of Bacillus aryabhattai P1 protease by modulation with nanoactivator. Heliyon, 2020, 6(6), e04053.
[http://dx.doi.org/10.1016/j.heliyon.2020.e04053]
[12]
Sanz-Penella, J.M.; Laparra, J.M.; Haros, M. Impact of α-amylase during breadmaking on in vitro kinetics of starch hydrolysis and glycaemic index of enriched bread with bran. Plant Foods Hum. Nutr., 2014, 69(3), 216-221.
[http://dx.doi.org/10.1007/s11130-014-0436-7] [PMID: 25074672]
[13]
Zeng, J.; Guo, J.; Tu, Y.; Yuan, L. Functional study of C-terminal domain of the thermoacidophilic raw starch-hydrolyzing α-amylase Gt-amy. Food Sci. Biotechnol., 2019, 29(3), 409-418.
[http://dx.doi.org/10.1007/s10068-019-00673-x] [PMID: 32257525]
[14]
Adhikari, A. Gastroprotective and digestive potential of an Ayurvedic asava–arishta preparation. Orient. Pharm. Exp. Med., 2018, 18(4), 391-401.
[http://dx.doi.org/10.1007/s13596-018-0325-y]
[15]
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]
[16]
Zhou, G.; Jin, M.; Cai, Y.; Zeng, R. Characterization of a thermostable and alkali-stable α-amylase from deep-sea bacterium Flammeovirga pacifica. Int. J. Biol. Macromol., 2015, 80, 676-682.
[http://dx.doi.org/10.1016/j.ijbiomac.2015.07.042] [PMID: 26210035]
[17]
Sadiqa, A.; Gilani, S.R.; Anwar, A.; Mehboob, A.; Saleem, A.; Rubab, S. Biogenic fabrication, characterization and drug loaded antimicrobial assay of silver nanoparticles using centratherum anthalminticum (l.) kuntze. J. Pharmaceut. Sci., 2021, 110(5), 1969-1978.
[18]
Lim, S.J.; Hazwani-Oslan, S.N.; Oslan, S.N. Purification and characterisation of thermostable alpha-amylases from microbial sources. Bioresources, 2020, 15(1), 2005-2029.
[19]
Asoodeh, A.; Emtenani, S.; Emtenani, S.; Jalal, R.; Housaindokht, M.R. Molecular cloning and biochemical characterization of a thermoacidophilic, organic-solvent tolerant alpha-amylase from a Bacillus strain in Escherichia coli. J. Mol. Catal., B Enzym., 2014, 99, 114-120.
[http://dx.doi.org/10.1016/j.molcatb.2013.10.025]
[20]
Sharma, A.; Satyanarayana, T. Cloning and expression of acidstable, high maltose-forming, Ca2+-independent α-amylase from an acidophile Bacillus acidicola and its applicability in starch hydrolysis. Extremophiles, 2012, 16(3), 515-522.
[http://dx.doi.org/10.1007/s00792-012-0451-2] [PMID: 22527045]
[21]
Sajedi, R.H. A Ca-independent alpha-amylase that is active and stable at low pH from the Bacillus sp KR-8104. Enzyme Microb. Technol., 2005, 36(5-6), 666-671.
[http://dx.doi.org/10.1016/j.enzmictec.2004.11.003]
[22]
Baltas, N.; Dincer, B.; Ekinci, A.P.; Kolayli, S.; Adiguzel, A. Purification and characterization of extracellular a-amylase from a thermophilic Anoxybacillus thermarum A4 strain. Braz. Arch. Biol. Technol., 2016, 59, e16160346.
[http://dx.doi.org/10.1590/1678-4324-2016160346]
[23]
Hmidet, N.; Ali, N.E.H.; Haddar, A.; Kanoun, S.; Alya, S.K.; Nasri, M. Alkaline proteases and thermostable alpha-amylase co-produced by Bacillus licheniformis NH1: Characterization and potential application as detergent additive. Biochem. Eng. J., 2009, 47(1-3), 71-79.
[http://dx.doi.org/10.1016/j.bej.2009.07.005]
[24]
Emtenani, S.; Asoodeh, A.; Emtenani, S. Gene cloning and characterization of a thermostable organic-tolerant α-amylase from Bacillus subtilis DR8806. Int. J. Biol. Macromol., 2015, 72, 290-298.
[http://dx.doi.org/10.1016/j.ijbiomac.2014.08.023] [PMID: 25168843]
[25]
Chen, J.; Chen, X.; Dai, J.; Xie, G.; Yan, L.; Lu, L.; Chen, J. Cloning, enhanced expression and characterization of an α-amylase gene from a wild strain in B. subtilis WB800. Int. J. Biol. Macromol., 2015, 80, 200-207.
[http://dx.doi.org/10.1016/j.ijbiomac.2015.06.018] [PMID: 26092061]
[26]
Jiang, T.; Cai, M.; Huang, M.; He, H.; Lu, J.; Zhou, X.; Zhang, Y. Characterization of a thermostable raw-starch hydrolyzing α-amylase from deep-sea thermophile Geobacillus sp. Protein Expr. Purif., 2015, 114, 15-22.
[http://dx.doi.org/10.1016/j.pep.2015.06.002] [PMID: 26073094]
[27]
Abdel-Fattah, Y.R.; Soliman, N.A.; El-Touldiy, N.M.; El-Gendi, H.; Ahmed, R.S. Production, purification, and characterization of thermostable alpha-amylase produced by Bacillus licheniformis isolate AI20. J. Chem., 2013, 673173.
[http://dx.doi.org/10.1155/2013/673173]
[28]
Cordeiro, C.A M.; Martins, M.L.L.; Luciano, A.B. Production and properties of alpha-amylase from thermophilic Bacillus sp. Braz. J. Microbiol., 2002, 33(1), 57-61.
[http://dx.doi.org/10.1590/S1517-83822002000100012]
[29]
Violet, M.; Meunier, J. C. Kinetic study of the irreversible thermal denaturation of Bacillus licheniformis alpha-amylase. Biochem. J., 1989, 263(3), 665-670.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version304msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[05:10:11] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[05:10:12] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[05:10:12] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[05:10:12] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (98.21ms)time
  • Application (205ms)time
  • 1 x Application (67.66%)
    205ms
    1 x Booting (32.34%)
    98.21ms
    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 duplicated121ms
    • 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 ('314564252','',1,1740460211,1740460211) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740460211
      1.02msalphaeurekaselec_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 ('314564252','/article/116861',1,1740460211,1740460211)
      680μ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 >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) 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 >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) 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 >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) 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 >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) 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 >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) 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 >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) limit 1
      19.02msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314564252
      • 1: 314564252
      • 2: 314564252
      • 3: 314564252
      • 4: 314564252
      • 5: 314564252
      • 6: 314564252
      • 7: 314564252
      • 8: 314564252
      • 9: 314564252
      • 10: 314564252
      • 11: 314564252
      • 12: 314564252
      • 13: 314564252
      • 14: 314564252
      • 15: 314564252
      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=116861
      790μ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` = 70 limit 1
      770μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 70
      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=70) and sj.journal_id!=70 group by `j`.`nid`) as `aggregate_table`
      750μ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=70) and sj.journal_id!=70 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      650μ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=70) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      780μsalphaeurekaselec_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=70) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      710μsalphaeurekaselec_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` = '116861'
      880μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 116861
      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` = '116861'
      2.32msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 116861
      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` = '116861' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.44msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 116861
      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
      650μ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 = 70 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      44.92msalphaeurekaselec_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 = 70 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      6.4msalphaeurekaselec_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 = 70 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.3msalphaeurekaselec_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` = 116861 limit 1
      940μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 116861
      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 = 116861 and content_type = 'article' order by status desc limit 1
      1.48msalphaeurekaselec_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` = 194973 limit 1
      420μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 194973
      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
      480μ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` = 'CP' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      470μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CP
      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 = '116861' 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) )
      730μ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 = '11559' 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) )
      640μ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 = '3223' 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) )
      510μ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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740460212 and j.to_date >= 1740460212 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3223) 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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740460212 and j.to_date >= 1740460212 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3223) 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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740460212 and j.to_date >= 1740460212 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3223)
      17.02msalphaeurekaselec_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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740460212 and j.to_date >= 1740460212 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11559) 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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740460212 and j.to_date >= 1740460212 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11559) 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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740460212 and j.to_date >= 1740460212 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11559)
      1.09msalphaeurekaselec_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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740460212 and j.to_date >= 1740460212 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 116861) 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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740460212 and j.to_date >= 1740460212 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 116861) 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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740460212 and j.to_date >= 1740460212 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 116861)
      900μ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` < '218' and is_uploaded = 1 and issue_id = 11559 order by cast(first_page as SIGNED) desc limit 1
      710μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 218
      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` > '225' and is_uploaded = 1 and issue_id = 11559 order by cast(first_page as SIGNED) asc limit 1
      620μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 225
      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'
      230μ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
      270μ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` = 116861 limit 1
      2.71msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 116861
      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` = 70 and `b`.`banner_from_date` <= 1740460212 and `b`.`banner_to_date` >= 1740460212 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.26msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 70
      • 3: 1740460212
      • 4: 1740460212
      • 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` = 70 and `b`.`banner_from_date` <= 1740460212 and `b`.`banner_to_date` >= 1740460212 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.24msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 70
      • 3: 1740460212
      • 4: 1740460212
      • 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='2685344aa5390832d5dd0867a2585a71'
      250μ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
        7cSwVjDEjwOn5IW3uZMzX2pF2qUhFr9ck1lsFa3N
        uc_cart_id
        2685344aa5390832d5dd0867a2585a71
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/116861" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/116861
        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 => "Tue, 25 Feb 2025 05:10:12 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im9ZOWZMNVV0RWFkS0w3cGJsNy9vdGc9PSIsInZhbHVlIjoiNEN0bmJac2h0L0hwOExtTW1scm92TitBQzhXRnFwMDViYlNjam9SOUJQVExxd1pTSFFTaVMrVTBqYXBSL1Y1R3dqdXpUTXZMSmZOMGQrb1piemZnZ25MaTZaM214b3U0UkcrWk05dUdDb3JwV1NlQW1RdkNuNXZvajZmTkNEZVAiLCJtYWMiOiJjNDUxOTM0MWM3ZTQ3ZmZjN2IyNGFmODM1Njg2NGVlNGM2M2E0Nzc0ZmM3YmYwODIzYjAzOTQxZmI0MGNiZjEwIiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 17:10:12 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Im9ZOWZMNVV0RWFkS0w3cGJsNy9vdGc9PSIsInZhbHVlIjoiNEN0bmJac2h0L0hwOExtTW1scm92TitBQzhXRnFwMDViYlNjam9SOUJQVExxd1pTSFFTaVMrVTBqYXBSL1Y1R3dqdXpUT" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkVoTHpRd1dlRDM3RHNJVXB1bzJJVVE9PSIsInZhbHVlIjoidXRxYzJEL0twd28wNDVUSnpUaHJOOVhvWDFJRUg4MkliUUFzS1ZITVoyOFlFQnJTbURMOXgyRHZsd1JzTXZwaVNnS2xqNWhpdlBCMXZadVIrOUZ3Kyt5T2VqclZTOVJRdkxXY0FLZUs2bGxTYU9hYit5WllNWHlmWHNxeTA4VjQiLCJtYWMiOiJmNWU5MDUxYjExODhiYTU4N2VkNzZmNGQ1ODNlZjc0MWU3NGRhZThmMDBlMjQzMTQxZDVhMGNlODZmY2E3OTljIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkVoTHpRd1dlRDM3RHNJVXB1bzJJVVE9PSIsInZhbHVlIjoidXRxYzJEL0twd28wNDVUSnpUaHJOOVhvWDFJRUg4MkliUUFzS1ZITVoyOFlFQnJTbURMOXgyRHZ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im9ZOWZMNVV0RWFkS0w3cGJsNy9vdGc9PSIsInZhbHVlIjoiNEN0bmJac2h0L0hwOExtTW1scm92TitBQzhXRnFwMDViYlNjam9SOUJQVExxd1pTSFFTaVMrVTBqYXBSL1Y1R3dqdXpUTXZMSmZOMGQrb1piemZnZ25MaTZaM214b3U0UkcrWk05dUdDb3JwV1NlQW1RdkNuNXZvajZmTkNEZVAiLCJtYWMiOiJjNDUxOTM0MWM3ZTQ3ZmZjN2IyNGFmODM1Njg2NGVlNGM2M2E0Nzc0ZmM3YmYwODIzYjAzOTQxZmI0MGNiZjEwIiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 17:10:12 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Im9ZOWZMNVV0RWFkS0w3cGJsNy9vdGc9PSIsInZhbHVlIjoiNEN0bmJac2h0L0hwOExtTW1scm92TitBQzhXRnFwMDViYlNjam9SOUJQVExxd1pTSFFTaVMrVTBqYXBSL1Y1R3dqdXpUT" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkVoTHpRd1dlRDM3RHNJVXB1bzJJVVE9PSIsInZhbHVlIjoidXRxYzJEL0twd28wNDVUSnpUaHJOOVhvWDFJRUg4MkliUUFzS1ZITVoyOFlFQnJTbURMOXgyRHZsd1JzTXZwaVNnS2xqNWhpdlBCMXZadVIrOUZ3Kyt5T2VqclZTOVJRdkxXY0FLZUs2bGxTYU9hYit5WllNWHlmWHNxeTA4VjQiLCJtYWMiOiJmNWU5MDUxYjExODhiYTU4N2VkNzZmNGQ1ODNlZjc0MWU3NGRhZThmMDBlMjQzMTQxZDVhMGNlODZmY2E3OTljIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkVoTHpRd1dlRDM3RHNJVXB1bzJJVVE9PSIsInZhbHVlIjoidXRxYzJEL0twd28wNDVUSnpUaHJOOVhvWDFJRUg4MkliUUFzS1ZITVoyOFlFQnJTbURMOXgyRHZ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "7cSwVjDEjwOn5IW3uZMzX2pF2qUhFr9ck1lsFa3N" "uc_cart_id" => "2685344aa5390832d5dd0867a2585a71" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/116861" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 05:10:12GET/article/116861414361