Generic placeholder image

Recent Patents on Biotechnology

Editor-in-Chief

ISSN (Print): 1872-2083
ISSN (Online): 2212-4012

Research Article

Amino Acids Sequence-based Analysis of Arginine Deiminase from Different Prokaryotic Organisms: An In Silico Approach

Author(s): Sara Abdollahi, Mohammad H. Morowvat *, Amir Savardashtaki , Cambyz Irajie , Sohrab Najafipour , Mahboubeh Zarei and Younes Ghasemi

Volume 14, Issue 3, 2020

Page: [235 - 246] Pages: 12

DOI: 10.2174/1872208314666200324114441

Price: $65

Abstract

Background: Arginine deiminase is a bacterial enzyme, which degrades L-arginine. Some human cancers such as hepatocellular carcinoma (HCC) and melanoma are auxotrophic for arginine. Therefore, PEGylated arginine deiminase (ADI-PEG20) is a good anticancer candidate with antitumor effects. It causes local depletion of L-arginine and growth inhibition in arginineauxotrophic tumor cells. The FDA and EMA have granted orphan status to this drug. Some recently published patents have dealt with this enzyme or its PEGylated form.

Objective: Due to increasing attention to it, we aimed to evaluate and compare 30 arginine deiminase proteins from different bacterial species through in silico analysis.

Methods: The exploited analyses included the investigation of physicochemical properties, multiple sequence alignment (MSA), motif, superfamily, phylogenetic and 3D comparative analyses of arginine deiminase proteins thorough various bioinformatics tools.

Results: The most abundant amino acid in the arginine deiminase proteins is leucine (10.13%) while the least amino acid ratio is cysteine (0.98%). Multiple sequence alignment showed 47 conserved patterns between 30 arginine deiminase amino acid sequences. The results of sequence homology among 30 different groups of arginine deiminase enzymes revealed that all the studied sequences located in amidinotransferase superfamily. Based on the phylogenetic analysis, two major clusters were identified. Considering the results of various in silico studies; we selected the five best candidates for further investigations. The 3D structures of the best five arginine deiminase proteins were generated by the I-TASSER server and PyMOL. The RAMPAGE analysis revealed that 81.4%-91.4%, of the selected sequences, were located in the favored region of arginine deiminase proteins.

Conclusion: The results of this study shed light on the basic physicochemical properties of thirty major arginine deiminase sequences. The obtained data could be employed for further in vivo and clinical studies and also for developing the related therapeutic enzymes.

Keywords: Arginine deiminase, in silico, multiple sequence alignment, phylogenetic analysis, physicochemical properties, therapeutic proteins.

Graphical Abstract

[1]
Schimke RT, Berlin CM, Sweeney EW, Carroll WR. The generation of energy by the arginine dihydrolase pathway in Mycoplasma hominis 07. J Biol Chem 1966; 241(10): 2228-36.
[PMID: 5911610]
[2]
Novák L, Zubáčová Z, Karnkowska A, Kolisko M, Hroudová M, Stairs CW, et al. Arginine deiminase pathway enzymes: evolutionary history in metamonads and other eukaryotes. BMC Evol Biol 2016; 16(1): 197.
[http://dx.doi.org/10.1186/s12862-016-0771-4] [PMID: 27716026]
[3]
Noens EE, Lolkema JS. Convergent evolution of the arginine deiminase pathway: the ArcD and ArcE arginine/ornithine exchangers. MicrobiologyOpen 2017; 6(1)e00412
[http://dx.doi.org/10.1002/mbo3.412] [PMID: 27804281]
[4]
Zúñiga M, Pérez G, González-Candelas F. Evolution of arginine deiminase (ADI) pathway genes. Mol Phylogenet Evol 2002; 25(3): 429-44.
[http://dx.doi.org/10.1016/S1055-7903(02)00277-4] [PMID: 12450748]
[5]
Ni Y, Schwaneberg U, Sun Z-H. Arginine deiminase, a potential anti-tumor drug. Cancer Lett 2008; 261(1): 1-11.
[http://dx.doi.org/10.1016/j.canlet.2007.11.038] [PMID: 18179862]
[6]
Takaku H, Takase M, Abe S, Hayashi H, Miyazaki K. In vivo anti-tumor activity of arginine deiminase purified from Mycoplasma arginini. Int J Cancer 1992; 51(2): 244-9.
[http://dx.doi.org/10.1002/ijc.2910510213] [PMID: 1568792]
[7]
Misawa S, Aoshima M, Takaku H, Matsumoto M, Hayashi H. High-level expression of Mycoplasma arginine deiminase in Escherichia coli and its efficient renaturation as an anti-tumor enzyme. J Biotechnol 1994; 36(2): 145-55.
[http://dx.doi.org/10.1016/0168-1656(94)90050-7] [PMID: 7765234]
[8]
Zarei M, Nezafat N, Morowvat MH, Dehshahri A, Ghoshoon MB, Berenjian A, et al. Medium optimization for recombinant soluble arginine deiminase expression in Escherichia coli using response surface methodology. Curr Pharm Biotechnol 2017; 18(11): 935-41.
[http://dx.doi.org/10.2174/1389201019666180115144752] [PMID: 29336257]
[9]
Feun L, Savaraj N. Pegylated arginine deiminase: a novel anticancer enzyme agent. Expert Opin Investig Drugs 2006; 15(7): 815-22.
[http://dx.doi.org/10.1517/13543784.15.7.815] [PMID: 16787144]
[10]
Reddy KR. Controlled-release, pegylation, liposomal formulations: new mechanisms in the delivery of injectable drugs. Ann Pharmacother 2000; 34(7-8): 915-23.
[http://dx.doi.org/10.1345/aph.10054] [PMID: 10928404]
[11]
Mehvar R. Modulation of the pharmacokinetics and pharmacodynamics of proteins by polyethylene glycol conjugation. J Pharm Pharm Sci 2000; 3(1): 125-36.
[PMID: 10954682]
[12]
Park H, Lee JB, Shim YJ, Shin YJ, Jeong S-Y, Oh J, et al. Arginine deiminase enhances MCF-7 cell radiosensitivity by inducing changes in the expression of cell cycle-related proteins. Mol Cells 2008; 25(2): 305-11.
[PMID: 18414006]
[13]
Horn F. The breakdown of arginine to citrulline by Bacillus pyocyaneus. Hoppe Seylers Z Physiol Chem 1933; 216: 244-7.
[http://dx.doi.org/10.1515/bchm2.1933.216.5-6.244]
[14]
Liu Y-M, Sun Z-H, Ni Y, Zheng P, Liu Y-P, Meng F-J. Isolation and identification of an arginine deiminase producing strain Pseudomonas plecoglossicida CGMCC2039. World J Microbiol Biotechnol 2008; 24(10): 2213-9.
[http://dx.doi.org/10.1007/s11274-008-9732-4]
[15]
Galkin A, Kulakova L, Sarikaya E, Lim K, Howard A, Herzberg O. Structural insight into arginine degradation by arginine deiminase, an antibacterial and parasite drug target. J Biol Chem 2004; 279(14): 14001-8.
[http://dx.doi.org/10.1074/jbc.M313410200] [PMID: 14701825]
[16]
Lu X, Li L, Wu R, Feng X, Li Z, Yang H, et al. Kinetic analysis of Pseudomonas aeruginosa arginine deiminase mutants and alternate substrates provides insight into structural determinants of function. Biochemistry 2006; 45(4): 1162-72.
[http://dx.doi.org/10.1021/bi051591e] [PMID: 16430212]
[17]
Miyazaki K, Takaku H, Umeda M, Fujita T, Huang W, Kimura T, et al. Potent growth inhibition of human tumor cells in culture by arginine deiminase purified from a culture medium of a Mycoplasma-infected cell line. Cancer Res 1990; 50(15): 4522-7.
[PMID: 2164440]
[18]
Takaku H, Matsumoto M, Misawa S, Miyazaki K. Anti-tumor activity of arginine deiminase from Mycoplasma argini and its growth-inhibitory mechanism. Jpn J Cancer Res 1995; 86(9): 840-6.
[http://dx.doi.org/10.1111/j.1349-7006.1995.tb03094.x] [PMID: 7591961]
[19]
Kim J-E, Jeong D-W, Lee HJ. Expression, purification, and characterization of arginine deiminase from Lactococcus lactis ssp. lactis ATCC 7962 in Escherichia coli BL21. Protein Expr Purif 2007; 53(1): 9-15.
[http://dx.doi.org/10.1016/j.pep.2006.12.002] [PMID: 17223359]
[20]
Burne RA, Parsons DT, Marquis RE. Cloning and expression in Escherichia coli of the genes of the arginine deiminase system of Streptococcus sanguis NCTC 10904. Infect Immun 1989; 57(11): 3540-8.
[http://dx.doi.org/10.1128/IAI.57.11.3540-3548.1989] [PMID: 2530176]
[21]
Monstadt GM, Holldorf AW. Arginine deiminase from Halobacterium salinarium. Purification and properties. Biochem J 1991; 273(Pt 3): 739-45.
[http://dx.doi.org/10.1042/bj2730739] [PMID: 1847623]
[22]
Gasteiger E, Hoogland C, Gattiker A, Wilkins MR, Appel RD, Bairoch A. Protein identification and analysis tools on the ExPASy server.In: Walker JM, Ed. The proteomics protocols handbook. Berlin: Springer 2005; pp. 571-607.
[http://dx.doi.org/10.1385/1-59259-890-0:571]
[23]
Bailey TL, Elkan C. Unsupervised learning of multiple motifs in biopolymers using expectation maximization. Mach Learn 1995; 21(1): 51-80.
[http://dx.doi.org/10.1007/BF00993379]
[24]
Kumar S, Stecher G, Tamura K. MEGA7: molecular evolutionary genetics analysis version 7.0 for bigger datasets. Mol Biol Evol 2016; 33(7): 1870-4.
[http://dx.doi.org/10.1093/molbev/msw054] [PMID: 27004904]
[25]
Grasso EJ, Sottile AE, Coronel CE. Structural prediction and in silico physicochemcial characterization for mouse caltrin I and bovine caltrin proteins. Bioinform Biol Insights 2016; 10: 225-36.
[http://dx.doi.org/10.4137/BBI.S38191] [PMID: 27812283]
[26]
Vidhya VG, Swarnalatha Y, Bhaskar A. An in silico analysis of physicochemcial characterization and protein-protein interaction network analysis of human anti-apoptotoic proteins. Asian J Pharm 2018; 12(4): S1397-407.
[27]
Zadeh Hosseingholi E, Neghabi N, Molavi G, Gheibi Hayat SM, Shahriarpour H. In silico identification and characterization of antineoplastic asparaginase enzyme from endophytic bacteria. IUBMB Life 2020; 11: 1-10.
[http://dx.doi.org/10.1002/iub.2237] [PMID: 31981306]
[28]
Ikai A. Thermostability and aliphatic index of globular proteins. J Biochem 1980; 88(6): 1895-8.
[PMID: 7462208]
[29]
Guruprasad K, Reddy BV, Pandit MW. Correlation between stability of a protein and its dipeptide composition: a novel approach for predicting in vivo stability of a protein from its primary sequence. Protein Eng 1990; 4(2): 155-61.
[http://dx.doi.org/10.1093/protein/4.2.155] [PMID: 2075190]
[30]
D’Hooghe I, Vander Wauven C, Michiels J, Tricot C, de Wilde P, Vanderleyden J, et al. The arginine deiminase pathway in Rhizobium etli: DNA sequence analysis and functional study of the arcABC genes. J Bacteriol 1997; 179(23): 7403-9.
[http://dx.doi.org/10.1128/JB.179.23.7403-7409.1997] [PMID: 9393705]
[31]
Lovell SC, Davis IW, Arendall WB, De Bakker PI, Word JM, Prisant MG, et al. Structure validation by Cα geometry: ϕ, ψ and Cβ deviation. Proteins: struct. Funct Bioinf 2003; 50(3): 437-50.
[32]
Bomalaski J, Wu B-W. Methods of treatment with arginine deiminase. WO 151568A1 2013.
[33]
Ensor CM, Holtsberg FW, Clark MA. Mutated form of arginine deiminase. EP 1278868B9 2008.
[34]
Xiaoyu F, Jianqun L, Yushuan S, Xiaofang W, Yefei W, Yuzhang W, et al. Arginine deiminase mutant and preparation and application therof. CN 101812438A 2010.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version384msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[13:40:33] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[13:40:33] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[13:40:33] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (106ms)time
  • Application (277ms)time
  • 1 x Application (72.24%)
    277ms
    1 x Booting (27.75%)
    106ms
    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 duplicated194ms
    • 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 ('316307720','',1,1739972433,1739972433) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739972433
      1.01msalphaeurekaselec_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 ('316307720','/article/105441',1,1739972433,1739972433)
      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 >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) 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 >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) 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 >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) 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 >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) 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 >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) 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 >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316307720 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316307720) limit 1
      15.15msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316307720
      • 1: 316307720
      • 2: 316307720
      • 3: 316307720
      • 4: 316307720
      • 5: 316307720
      • 6: 316307720
      • 7: 316307720
      • 8: 316307720
      • 9: 316307720
      • 10: 316307720
      • 11: 316307720
      • 12: 316307720
      • 13: 316307720
      • 14: 316307720
      • 15: 316307720
      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=105441
      810μ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` = 73 limit 1
      850μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 73
      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=73) and sj.journal_id!=73 group by `j`.`nid`) as `aggregate_table`
      880μ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=73) and sj.journal_id!=73 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=73) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.79msalphaeurekaselec_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=73) 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.48msalphaeurekaselec_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` = '105441'
      1.2msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 105441
      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` = '105441'
      3.67msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 105441
      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` = '105441' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.9msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 105441
      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
      260μ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
      510μ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 = 73 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      26.19msalphaeurekaselec_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 = 73 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.16msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2070
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 73 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.93msalphaeurekaselec_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` = 105441 limit 1
      970μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 105441
      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 = 105441 and content_type = 'article' order by status desc limit 1
      3.43msalphaeurekaselec_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 = 469 and content_id!=105441 and cd.content_type = 'article' order by rand() limit 20
      72.13msalphaeurekaselec_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` = 180461 limit 1
      300μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 180461
      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
      270μ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` = 'BIOT' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      310μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: BIOT
      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 = '105441' 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) )
      390μ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 = '10122' 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) )
      340μ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 = '2755' 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) )
      330μ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 <= 316307720 and j.to_ip >=316307720 )) and ((j.from_date <= 1739972433 and j.to_date >= 1739972433 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2755) 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 <= 316307720 and j.to_ip >=316307720 )) and ((j.from_date <= 1739972433 and j.to_date >= 1739972433 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2755) 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 <= 316307720 and j.to_ip >=316307720 )) and ((j.from_date <= 1739972433 and j.to_date >= 1739972433 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2755)
      34.46msalphaeurekaselec_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 <= 316307720 and j.to_ip >=316307720 )) and ((j.from_date <= 1739972433 and j.to_date >= 1739972433 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10122) 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 <= 316307720 and j.to_ip >=316307720 )) and ((j.from_date <= 1739972433 and j.to_date >= 1739972433 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10122) 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 <= 316307720 and j.to_ip >=316307720 )) and ((j.from_date <= 1739972433 and j.to_date >= 1739972433 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10122)
      690μ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 <= 316307720 and j.to_ip >=316307720 )) and ((j.from_date <= 1739972433 and j.to_date >= 1739972433 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 105441) 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 <= 316307720 and j.to_ip >=316307720 )) and ((j.from_date <= 1739972433 and j.to_date >= 1739972433 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 105441) 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 <= 316307720 and j.to_ip >=316307720 )) and ((j.from_date <= 1739972433 and j.to_date >= 1739972433 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 105441)
      650μ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` < '235' and is_uploaded = 1 and issue_id = 10122 order by cast(first_page as SIGNED) desc limit 1
      590μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 235
      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` > '246' and is_uploaded = 1 and issue_id = 10122 order by cast(first_page as SIGNED) asc limit 1
      480μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 246
      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'
      220μ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
      260μ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` = 105441 limit 1
      2.55msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 105441
      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` = 73 and `b`.`banner_from_date` <= 1739972433 and `b`.`banner_to_date` >= 1739972433 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      2.37msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 73
      • 3: 1739972433
      • 4: 1739972433
      • 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` = 73 and `b`.`banner_from_date` <= 1739972433 and `b`.`banner_to_date` >= 1739972433 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.36msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 73
      • 3: 1739972433
      • 4: 1739972433
      • 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='ea314a6f42c5331b69ca3d0fba5485ac'
      390μ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
        iJl1MFtI5hykTdxSC63OkeVAyR3F4zz63wCPj8f6
        uc_cart_id
        ea314a6f42c5331b69ca3d0fba5485ac
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/105441" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/105441
        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 => "Wed, 19 Feb 2025 13:40:33 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im41Y1V6a1p5NmhDd0M0aWNUYjdsNEE9PSIsInZhbHVlIjoiOU1Vck5EdXREQ3JkNTFoMlEzS2tmZW1SVW0ybTE3Mm90elk2YlRGd2dEdW4rUTZzdW9kUlplRFRDb1dYbVp1SzNuaHczaUpYMUo0Z0dVWmdOVHVWTk5JNkFxV3hpZE5PeFdWbkRrVXhLS2JsTVhqdjRuYmtYTnBYMFVZUTZEeXoiLCJtYWMiOiJmOTc1N2I1YmIwZGI5MWRiMThjODk3YjcyZDZmYTc3OWE4Y2YwZDE0NzQ0NjQ0YmI0YmU2ODFjMmRlNTc5MjVjIiwidGFnIjoiIn0%3D; expires=Sat, 22 Feb 2025 01:40:33 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Im41Y1V6a1p5NmhDd0M0aWNUYjdsNEE9PSIsInZhbHVlIjoiOU1Vck5EdXREQ3JkNTFoMlEzS2tmZW1SVW0ybTE3Mm90elk2YlRGd2dEdW4rUTZzdW9kUlplRFRDb1dYbVp1SzNuaHcza" 1 => "alphaeurekaselectnet_session=eyJpdiI6InU4TENWbXoySnJ3bFVQV2Y1UlZNM0E9PSIsInZhbHVlIjoidVAycjRJVko4RmpCRzNoVWNsT0wyNGgvRTlBQXJ2eC9PRFRhWjQ4L0s4b1ozZEJEcUxFL1JQdlpVM1BwZCtsZENyVy9lR20zQnpxMjg0WXRRYWNiQXZHdm1RNFRsY1J1M284WTVCSFl1T1gvSHB6R1A5NCswRGNhdlpBWlllL0ciLCJtYWMiOiJjYTViNjhmN2MwNTFlY2Y1MzkxZTNhYjhjZTU2ZDc4OTMxNzBlMzhlYjA0ZTk0MzI5MDE3YTE0Y2I1ODdjMTAxIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6InU4TENWbXoySnJ3bFVQV2Y1UlZNM0E9PSIsInZhbHVlIjoidVAycjRJVko4RmpCRzNoVWNsT0wyNGgvRTlBQXJ2eC9PRFRhWjQ4L0s4b1ozZEJEcUxFL1JQdlp" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im41Y1V6a1p5NmhDd0M0aWNUYjdsNEE9PSIsInZhbHVlIjoiOU1Vck5EdXREQ3JkNTFoMlEzS2tmZW1SVW0ybTE3Mm90elk2YlRGd2dEdW4rUTZzdW9kUlplRFRDb1dYbVp1SzNuaHczaUpYMUo0Z0dVWmdOVHVWTk5JNkFxV3hpZE5PeFdWbkRrVXhLS2JsTVhqdjRuYmtYTnBYMFVZUTZEeXoiLCJtYWMiOiJmOTc1N2I1YmIwZGI5MWRiMThjODk3YjcyZDZmYTc3OWE4Y2YwZDE0NzQ0NjQ0YmI0YmU2ODFjMmRlNTc5MjVjIiwidGFnIjoiIn0%3D; expires=Sat, 22-Feb-2025 01:40:33 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Im41Y1V6a1p5NmhDd0M0aWNUYjdsNEE9PSIsInZhbHVlIjoiOU1Vck5EdXREQ3JkNTFoMlEzS2tmZW1SVW0ybTE3Mm90elk2YlRGd2dEdW4rUTZzdW9kUlplRFRDb1dYbVp1SzNuaHcza" 1 => "alphaeurekaselectnet_session=eyJpdiI6InU4TENWbXoySnJ3bFVQV2Y1UlZNM0E9PSIsInZhbHVlIjoidVAycjRJVko4RmpCRzNoVWNsT0wyNGgvRTlBQXJ2eC9PRFRhWjQ4L0s4b1ozZEJEcUxFL1JQdlpVM1BwZCtsZENyVy9lR20zQnpxMjg0WXRRYWNiQXZHdm1RNFRsY1J1M284WTVCSFl1T1gvSHB6R1A5NCswRGNhdlpBWlllL0ciLCJtYWMiOiJjYTViNjhmN2MwNTFlY2Y1MzkxZTNhYjhjZTU2ZDc4OTMxNzBlMzhlYjA0ZTk0MzI5MDE3YTE0Y2I1ODdjMTAxIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6InU4TENWbXoySnJ3bFVQV2Y1UlZNM0E9PSIsInZhbHVlIjoidVAycjRJVko4RmpCRzNoVWNsT0wyNGgvRTlBQXJ2eC9PRFRhWjQ4L0s4b1ozZEJEcUxFL1JQdlp" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "iJl1MFtI5hykTdxSC63OkeVAyR3F4zz63wCPj8f6" "uc_cart_id" => "ea314a6f42c5331b69ca3d0fba5485ac" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/105441" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-19 13:40:33GET/article/105441314371