Generic placeholder image

Recent Patents on Biotechnology

Editor-in-Chief

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

Research Article

In silico Analysis of Different Signal Peptides for Secretory Production of Arginine Deiminase in Escherichia coli

Author(s): Mahboubeh Zarei, Navid Nezafat, Mohammad Hossein Morowvat, Mohsen Ektefaie and Younes Ghasemi*

Volume 13, Issue 3, 2019

Page: [217 - 227] Pages: 11

DOI: 10.2174/1872208313666190101114602

Price: $65

Abstract

Background: Secretory production of recombinant protein in bacterial hosts fulfills several advantages. Selecting an appropriate secretory signal peptide is a critical step in secretory production of different protein. Several patents report the usage of signal peptides for secretory production of recombinant proteins in E. coli. In silico identification of suitable signal peptides is a reliable and cost-effective alternative to experimental approaches.

Objective: This study was aimed to predict best signal peptides for the secretory production of recombinant arginine deiminase in E. coli.

Methods: In this study, 30 different signal peptide sequences were retrieved from database. The signal peptide probability, location of cleavage sites, and n, h and c regions were predicted by SignalP 4.1 and Phobius servers. After purging the 30 predicted secretory signal peptides, TorT, bla, NrfA, TolB, PapC, PldA, Lpp were removed. Several physicochemical properties of the remaining potential SPs were determined by ProtParam, PROSO II, and SOLpro servers for theoretically selecting the best candidates.

Results and Conclusion: Based on physicochemical properties, the signal peptides of OmpC, OmpF, and DsbA were identified respectively as the promising candidates for efficient secretory production of arginine deiminase in E. coli. Although the computational approach has established itself as a basis of modern biotechnology, the experimental study is necessary to validate its results. The criteria used in this study could be applied to other targets for recombination processes.

Keywords: Arginine deiminase, secretory production, signal peptide, In silico, E. Coli, protein.

Graphical Abstract

[1]
Huang CJ, Lin H, Yang X. Industrial production of recombinant therapeutics in Escherichia coli and its recent advancements. J Ind Microbiol Biotechnol 2012; 39(3): 383-99.
[2]
Baneyx F, Mujacic M. Recombinant protein folding and misfolding in Escherichia coli. Nat Biotechnol 2004; 22(11): 1399-408.
[3]
Kane JF, Hartley DL. Formation of recombinant protein inclusion bodies in Escherichia coli. Trends Biotechnol 1988; 6(5): 95-101.
[4]
Mukhopadhyay A. Inclusion bodies and purification of proteins in biologically active forms. Adv Biochem Eng Biotechnol 1997; 56: 61-109.
[5]
de Marco A, Deuerling E, Mogk A, Tomoyasu T, Bukau B. Chaperone-based procedure to increase yields of soluble recombinant proteins produced in E. coli. BMC Biotechnol 2007; 7: 32.
[6]
Kumar S, Jain KK, Bhardwaj KN, Chakraborty S, Kuhad RC. Multiple Genes in a single host: Cost-effective production of bacterial laccase (cotA), pectate lyase (pel), and endoxylanase (xyl) by simultaneous expression and cloning in single vector in E. coli. PLoS One 2015; 10(12)e0144379
[7]
Han KY, Song JA, Ahn KY, Park JS, Seo HS, Lee J. Solubilization of aggregation-prone heterologous proteins by covalent fusion of stress-responsive Escherichia coli protein, SlyD. Protein Eng Des Sel 2007; 20(11): 543-9.
[8]
Zhou Y, Lu Z, Wang X, Selvaraj JN, Zhang G. Genetic engineering modification and fermentation optimization for extracellular production of recombinant proteins using Escherichia coli. Appl Microbiol Biotechnol 2018; 102(4): 1545-56.
[9]
Leonhartsberger S, Candussio A, Schmid G. Signal peptide for the production of recombinant proteins. US8148494B2. 2012.
[10]
Robinson RR, Liu AY, Horwitz AH, et al. Modular assembly of antibody genes, antibodies prepared thereby and use. US5618920A, 1997.
[11]
Sockolosky JT, Szoka FC. Periplasmic production via the pET expression system of soluble, bioactive human growth hormone. Protein Expr Purif 2013; 87(2): 129-35.
[12]
Ghoshoon MB, Berenjian A, Hemmati S, et al. Extracellular production of recombinant L-Asparaginase II in Escherichia coli: Medium optimization using response surface methodology. Int J Pept Res Ther 2015; 21(4): 487.
[13]
Winter J, Neubauer P, Glockshuber R, Rudolph R. Increased production of human proinsulin in the periplasmic space of Escherichia coli by fusion to DsbA. Journal of Biotechnology 2000; 84(2): 175-85.
[14]
Manica N, Navid N, Nasim H, Seyyed Soheil R, Mohammad Hossein M, Younes G. In Silico Study of Different Signal Peptides for Secretory Production of Interleukin-11 in Escherichia coli. Curr Proteomics 2017; 14(2): 112-21.
[15]
Forouharmehr A, Nassiri M, Ghovvati S, Javadmanesh A. Evaluation of different signal peptides for secretory production of recombinant bovine pancreatic ribonuclease A in Gram negative bacterial system: an in silico study. Curr Proteomics 2018; 15(1): 24-33.
[16]
Martoglio B, Dobberstein B. Signal sequences: more than just greasy peptides. Trends Cell Biol 1998; 8(10): 410-5.
[17]
Sjöström M, Wold S, Wieslander A, Rilfors L. Signal peptide amino acid sequences in Escherichia coli contain information related to final protein localization. A multivariate data analysis. EMBO J 1987; 6(3): 823-31.
[18]
Tuteja R. Type I signal peptidase: an overview. Arch Biochem Biophys 2005; 441(2): 107-11.
[19]
Zimmermann R, Eyrisch S, Ahmad M, Helms V. Protein translocation across the ER membrane. Biochim Biophys Acta Biomembr 2011; 1808(3): 912-24.
[20]
Owji H, Nezafat N, Negahdaripour M, Hajiebrahimi A, Ghasemi Y. A comprehensive review of signal peptides: Structure, roles, and applications. Eur J Cell Biol 2018; 97(6): 422-41.
[21]
Smith DW, Ganaway RL, Fahrney DE. Arginine deiminase from Mycoplasma arthritidis. Structure-activity relationships among substrates and competitive inhibitors. J Biol Chem 1978; 253(17): 6016-20.
[22]
Szlosarek PW, Steele JP, Nolan L, et al. Arginine deprivation with pegylated arginine deiminase in patients with argininosuccinate synthetase 1–deficient malignant pleural mesothelioma: a randomized clinical trial. JAMA Oncol 2017; 3(1): 58-66.
[23]
Miraki-Moud F, Ghazaly E, Ariza-McNaughton L, et al. Arginine deprivation using pegylated arginine deiminase has activity against primary acute myeloid leukemia cells in vivo. Blood 2015; 125(26): 4060-8.
[24]
Savaraj N, Wu C, Li YY, et al. Targeting argininosuccinate synthetase negative melanomas using combination of arginine degrading enzyme and cisplatin. Oncotarget 2015; 6(8): 6295-309.
[25]
Abou-Alfa GK, Qin S, Ryoo B-Y, et al. Phase III randomized study of second line ADI-PEG 20 plus best supportive care versus placebo plus best supportive care in patients with advanced hepatocellular carcinoma. Ann Oncol 2018; 29(6): 1402-8.
[26]
Beddowes E, Spicer J, Chan PY, et al. Phase 1 dose-escalation study of pegylated arginine deiminase, cisplatin, and pemetrexed in patients with argininosuccinate synthetase 1-deficient thoracic cancers. J Clin Oncol 2017; 35(16): 1778-85.
[27]
Lowery MA, Yu KH, Kelsen DP, et al. A phase 1/1B trial of ADI-PEG 20 plus nab-paclitaxel and gemcitabine in patients with advanced pancreatic adenocarcinoma. Cancer 2017; 123(23): 4556-65.
[28]
Kubo M, Nishitsuji H, Kurihara K, Hayashi T, Masuda T, Kannagi M. Suppression of human immunodeficiency virus type 1 replication by arginine deiminase of Mycoplasma arginini. J Gen Virol 2006; 87(Pt 6): 1589-93.
[29]
Izzo F, Montella M, Orlando AP, et al. Pegylated arginine deiminase lowers hepatitis C viral titers and inhibits nitric oxide synthesis. J Gastroenterol Hepatol 2007; 22(1): 86-91.
[30]
Shirai H, Mokrab Y, Mizuguchi K. The guanidine-group modifying enzymes: structural basis for their diversity and commonality. Proteins 2006; 64(4): 1010-23.
[31]
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.
[32]
Clark MA. Method of treatment with modified arginine deiminase. US7323167B2, 2008.
[33]
Song JA, Lee DS, Park JS, Han KY, Lee J. A novel Escherichia coli solubility enhancer protein for fusion expression of aggregation-prone heterologous proteins. Enzyme Microb Technol 2011; 49(2): 124-30.
[34]
Kang YS, Song JA, Han KY, Lee J. Escherichia coli EDA is a novel fusion expression partner to improve solubility of aggregation-prone heterologous proteins. J Biotechnol 2015; 194: 39-47.
[35]
Ahn KY, Lee B, Han KY, Song JA, Lee DS, Lee J. Synthesis of Mycoplasma arginine deiminase in E. coli using stress-responsive proteins. Enzyme Microb Technol 2014; 63: 46-9.
[36]
Wang Y, Li YZ. Cultivation to improve in vivo solubility of overexpressed arginine deiminases in Escherichia coli and the enzyme characteristics. BMC Biotechnol 2014; 14: 53.
[37]
Zarei M, Nezafat N, Morowvat MH, 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.
[38]
Zarei M, Nezafat N, Rahbar MR, et al. Decreasing the immunogenicity of arginine deiminase enzyme via structure-based computational analysis. J Biomol Struct Dyn 2019; 37(2): 523-36.
[39]
Von HG. Patterns of amino acids near signal-sequence cleavage sites. Eur J Biochem 1983; 133(1): 17-21.
[40]
Consortium U. UniProt: the universal protein knowledgebase. Nucleic Acids Res 2017; 45(D1): D158-69.
[41]
Petersen TN, Brunak S, Von HG, Nielsen H. SignalP 4.0: discriminating signal peptides from transmembrane regions. Nat Methods 2011; 8(10): 785-6.
[42]
Käll L, Krogh A, Sonnhammer EL. Advantages of combined transmembrane topology and signal peptide prediction-the Phobius web server. Nucleic Acids Res 2007; 35(Suppl. 2): W429-32.
[43]
Choo KH, Tan TW, Ranganathan S. A comprehensive assessment of N-terminal signal peptides prediction methods. BMC Bioinformatics 2009; 10(Suppl. 15): S2.
[44]
Gasteiger E, Hoogland C, Gattiker A, et al. Protein identification and analysis tools on the ExPASy server. Humana Press 2005; pp. 571-607.
[45]
Magnan CN, Randall A, Baldi P. SOLpro: accurate sequence-based prediction of protein solubility. Bioinformatics 2009; 25(17): 2200-7.
[46]
Smialowski P, Doose G, Torkler P, Kaufmann S, Frishman D. PROSO II--a new method for protein solubility prediction. FEBS J 2012; 279(12): 2192-200.
[47]
Chang CC, Song J, Tey BT, Ramanan RN. Bioinformatics approaches for improved recombinant protein production in Escherichia coli: protein solubility prediction. Brief Bioinform 2014; 15(6): 953-62.
[48]
Berman HM, Westbrook JD, Gabanyi MJ, et al. The protein structure initiative structural genomics knowledgebase. Nucleic Acids Res 2009; 37(Database issue): D365-8.
[49]
Berman HM, Westbrook J, Feng Z, et al. The protein data bank. Nucleic Acids Res 2000; 28(1): 235-42.
[50]
Kyte J, Doolittle RF. A simple method for displaying the hydropathic character of a protein. J Mol Biol 1982; 157(1): 105-32.
[51]
Ikai A. Thermostability and aliphatic index of globular proteins. J Biochem 1980; 88(6): 1895-8.
[52]
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.
[53]
Low KO, Mahadi NM, Illias RM. Optimisation of signal peptide for recombinant protein secretion in bacterial hosts. Appl Microbiol Biotechnol 2013; 97(9): 3811-26.
[54]
Gouridis G, Karamanou S, Gelis I, Kalodimos CG, Economou A. Signal peptides are allosteric activators of the protein translocase. Nature 2009; 462(7271): 363-7.
[55]
Choi J, Lee S. Secretory and extracellular production of recombinant proteins using Escherichia coli. Appl Microbiol Biotechnol 2004; 64(5): 625-35.
[56]
Qian ZG, Xia XX, Choi JH, Lee SY. Proteome-based identification of fusion partner for high-level extracellular production of recombinant proteins in Escherichia coli. Biotechnol Bioeng 2008; 101(3): 587-601.
[57]
Champion MM, Williams EA, Kennedy GM, Champion PAD. Direct detection of bacterial protein secretion using whole colony proteomics. Mol Cell Proteomics 2012; 11(9): 596-604.
[58]
Zalucki YM, Power PM, Jennings MP. Selection for efficient translation initiation biases codon usage at second amino acid position in secretory proteins. Nucleic Acids Res 2007; 35(17): 5748-54.
[59]
Karamyshev AL, Karamysheva ZN, Kajava AV, Ksenzenko VN, Nesmeyanova MA. Processing of Escherichia coli alkaline phosphatase: role of the primary structure of the signal peptide cleavage region. J Mol Biol 1998; 277(4): 859-70.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version293msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[04:19:54] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[04:19:54] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[04:19:54] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (107ms)time
  • Application (187ms)time
  • 1 x Application (63.66%)
    187ms
    1 x Booting (36.34%)
    107ms
    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 duplicated93.18ms
    • 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 ('873341851','',1,1740457194,1740457194) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740457194
      1.63msalphaeurekaselec_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 ('873341851','/article/95524',1,1740457194,1740457194)
      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 >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) 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 >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) 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 >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) 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 >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) 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 >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) 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 >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 873341851 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873341851) limit 1
      11.68msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 873341851
      • 1: 873341851
      • 2: 873341851
      • 3: 873341851
      • 4: 873341851
      • 5: 873341851
      • 6: 873341851
      • 7: 873341851
      • 8: 873341851
      • 9: 873341851
      • 10: 873341851
      • 11: 873341851
      • 12: 873341851
      • 13: 873341851
      • 14: 873341851
      • 15: 873341851
      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=95524
      720μ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
      790μ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`
      810μ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
      700μ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`
      3.58msalphaeurekaselec_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.9msalphaeurekaselec_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` = '95524'
      2.03msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 95524
      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` = '95524'
      2.21msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 95524
      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` = '95524' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.94msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 95524
      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
      220μ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
      440μ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
      23.36msalphaeurekaselec_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
      3.34msalphaeurekaselec_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
      2.5msalphaeurekaselec_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` = 95524 limit 1
      230μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 95524
      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 = 95524 and content_type = 'article' order by status desc limit 1
      280μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 168683 limit 1
      230μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 168683
      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
      230μ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
      270μ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 = '95524' 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) )
      340μ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 = '9248' 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) )
      320μ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 = '2618' 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) )
      290μ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 <= 873341851 and j.to_ip >=873341851 )) and ((j.from_date <= 1740457194 and j.to_date >= 1740457194 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2618) 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 <= 873341851 and j.to_ip >=873341851 )) and ((j.from_date <= 1740457194 and j.to_date >= 1740457194 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2618) 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 <= 873341851 and j.to_ip >=873341851 )) and ((j.from_date <= 1740457194 and j.to_date >= 1740457194 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2618)
      21.32msalphaeurekaselec_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 <= 873341851 and j.to_ip >=873341851 )) and ((j.from_date <= 1740457194 and j.to_date >= 1740457194 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9248) 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 <= 873341851 and j.to_ip >=873341851 )) and ((j.from_date <= 1740457194 and j.to_date >= 1740457194 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9248) 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 <= 873341851 and j.to_ip >=873341851 )) and ((j.from_date <= 1740457194 and j.to_date >= 1740457194 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9248)
      900μ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 <= 873341851 and j.to_ip >=873341851 )) and ((j.from_date <= 1740457194 and j.to_date >= 1740457194 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 95524) 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 <= 873341851 and j.to_ip >=873341851 )) and ((j.from_date <= 1740457194 and j.to_date >= 1740457194 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 95524) 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 <= 873341851 and j.to_ip >=873341851 )) and ((j.from_date <= 1740457194 and j.to_date >= 1740457194 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 95524)
      820μ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` < '217' and is_uploaded = 1 and issue_id = 9248 order by cast(first_page as SIGNED) desc limit 1
      620μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 217
      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` > '227' and is_uploaded = 1 and issue_id = 9248 order by cast(first_page as SIGNED) asc limit 1
      560μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 227
      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'
      210μ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
      250μ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` = 95524 limit 1
      3.86msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 95524
      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` <= 1740457194 and `b`.`banner_to_date` >= 1740457194 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.58msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 73
      • 3: 1740457194
      • 4: 1740457194
      • 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` <= 1740457194 and `b`.`banner_to_date` >= 1740457194 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.53msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 73
      • 3: 1740457194
      • 4: 1740457194
      • 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='d411ba1c4834052cf2fa5dfe17765015'
      280μ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
        RvHCObjXZWQ4QJUK4oKXifBebZ7CrOtjqHmTChwz
        uc_cart_id
        d411ba1c4834052cf2fa5dfe17765015
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/95524" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/95524
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:9 [ "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6IlFjMDhNbjhnOGJibzJqRnhPWTdHOGc9PSIsInZhbHVlIjoib1NqZ2hVSWs5YkJybkdaV1VVYlBydE9JUzJGdVNRUXc5dm1GTDZoWG5iVERkZmV0SHp4YW0yZk92NlBKRlZkbCIsIm1hYyI6ImNlY2QyNTU4YzJiZTI3YjI5MDFhMWYyMzViNGZmZmNhYTBhNDM2ZTVjYjc0MmFiMWEwNzdiZWEwNDJlZTE2ZjQiLCJ0YWciOiIifQ%3D%3Dwayfindertarget=eyJpdiI6IlFjMDhNbjhnOGJibzJqRnhPWTdHOGc9PSIsInZhbHVlIjoib1NqZ2hVSWs5YkJybkdaV1VVYlBydE9JUzJGdVNRUXc5dm1GTDZoWG5iVERkZmV0SHp4YW0yZk92NlBKRlZkbCIs" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 25 Feb 2025 04:19:54 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjNqU1dsZVppbmpMbUFzM0IzN3VsWVE9PSIsInZhbHVlIjoianRtTW1PZE1YT3NIekthaVQ1Q2VDMklFcGl4V3Y0ZTB4L2lGNHV5Z1VaMGVCb0tySjY1d3ZiaW9rOFd0TEdFNDhkWHpwN1ZZZ3VpaUlpWHhKRURlcGhHN0hsdmNCcnI2b2NGbC9zaVhEK0NyemhoeTYwRTdSOERUbC9oMXJFcE4iLCJtYWMiOiJmZDc0NDMxNzRmMzk4ZmFhNTNlM2RjNDgyMmM5ZThlYjQzNTMyYzRlYjg0MTJhZjc5YmU0ZTYwMjZiZDNmNDJiIiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 16:19:54 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjNqU1dsZVppbmpMbUFzM0IzN3VsWVE9PSIsInZhbHVlIjoianRtTW1PZE1YT3NIekthaVQ1Q2VDMklFcGl4V3Y0ZTB4L2lGNHV5Z1VaMGVCb0tySjY1d3ZiaW9rOFd0TEdFNDhkWHpwN" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkRNQnJFTzlCQ2Rtc0N4c3pkeG8vc1E9PSIsInZhbHVlIjoiN3EwQys2WGN6QUdBejF1Vkh3YWZ3aXU4cFU0OVJhNVNrZGlXZXlVMVR2b0FSSVdjZnV1YU1ZSnQvS1Q5VjFmWTFZQlJ5cndqMjd1d2xna0hPTkR4ODFxajhGdHJ2QmtFb09KMGNMcHlIVFNJVjRyVm9wK1lwQ0dkNGZBaHJkUE4iLCJtYWMiOiI5ZTEyOWNjOGIxNDcyOWEzYzQ0OWU0MmUwMTliMGVmZGJkYzY2ZTkwMDgyNWZlODk3YzgyNzhhMDYxZmYyNDg4IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkRNQnJFTzlCQ2Rtc0N4c3pkeG8vc1E9PSIsInZhbHVlIjoiN3EwQys2WGN6QUdBejF1Vkh3YWZ3aXU4cFU0OVJhNVNrZGlXZXlVMVR2b0FSSVdjZnV1YU1ZSnQ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjNqU1dsZVppbmpMbUFzM0IzN3VsWVE9PSIsInZhbHVlIjoianRtTW1PZE1YT3NIekthaVQ1Q2VDMklFcGl4V3Y0ZTB4L2lGNHV5Z1VaMGVCb0tySjY1d3ZiaW9rOFd0TEdFNDhkWHpwN1ZZZ3VpaUlpWHhKRURlcGhHN0hsdmNCcnI2b2NGbC9zaVhEK0NyemhoeTYwRTdSOERUbC9oMXJFcE4iLCJtYWMiOiJmZDc0NDMxNzRmMzk4ZmFhNTNlM2RjNDgyMmM5ZThlYjQzNTMyYzRlYjg0MTJhZjc5YmU0ZTYwMjZiZDNmNDJiIiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 16:19:54 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjNqU1dsZVppbmpMbUFzM0IzN3VsWVE9PSIsInZhbHVlIjoianRtTW1PZE1YT3NIekthaVQ1Q2VDMklFcGl4V3Y0ZTB4L2lGNHV5Z1VaMGVCb0tySjY1d3ZiaW9rOFd0TEdFNDhkWHpwN" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkRNQnJFTzlCQ2Rtc0N4c3pkeG8vc1E9PSIsInZhbHVlIjoiN3EwQys2WGN6QUdBejF1Vkh3YWZ3aXU4cFU0OVJhNVNrZGlXZXlVMVR2b0FSSVdjZnV1YU1ZSnQvS1Q5VjFmWTFZQlJ5cndqMjd1d2xna0hPTkR4ODFxajhGdHJ2QmtFb09KMGNMcHlIVFNJVjRyVm9wK1lwQ0dkNGZBaHJkUE4iLCJtYWMiOiI5ZTEyOWNjOGIxNDcyOWEzYzQ0OWU0MmUwMTliMGVmZGJkYzY2ZTkwMDgyNWZlODk3YzgyNzhhMDYxZmYyNDg4IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkRNQnJFTzlCQ2Rtc0N4c3pkeG8vc1E9PSIsInZhbHVlIjoiN3EwQys2WGN6QUdBejF1Vkh3YWZ3aXU4cFU0OVJhNVNrZGlXZXlVMVR2b0FSSVdjZnV1YU1ZSnQ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "RvHCObjXZWQ4QJUK4oKXifBebZ7CrOtjqHmTChwz" "uc_cart_id" => "d411ba1c4834052cf2fa5dfe17765015" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/95524" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 04:19:54GET/article/95524314361