Generic placeholder image

Current Protein & Peptide Science

Editor-in-Chief

ISSN (Print): 1389-2037
ISSN (Online): 1875-5550

General Review Article

Reverse Micellar System in Protein Recovery - A Review of the Latest Developments

Author(s): Revathy Sankaran, Jenn Hau Bong, Yin Hui Chow, Fadzlie Wong Faizal Wong, Tau Chuan Ling* and Pau Loke Show*

Volume 20, Issue 10, 2019

Page: [1012 - 1026] Pages: 15

DOI: 10.2174/1389203720666190628142203

Abstract

Reversed micellar system (RMS) is an innovative technique used for the isolation, extraction and purification of proteins and enzymes. Studies have demonstrated that RMS is an efficient purification technology for extracting proteins and enzymes from natural plant materials or fermentation broth. Lately, reverse micelles have wider biological applications and the ease of scaling up and the possibility for the continuous process have made RMS a vital purification technique in various fields. In this study, an extensive review of RMS with the current application in biotechnology is examined. This review provides insights into the fundamental principles, key variables and parameters of RMS. In addition, a comparative study of RMS with other liquid-liquid extraction techniques is also included. The present review aims to provide a general overview of RMS by summarising the research works, since the introduction of the technology to current development.

Keywords: Reversed micellar system, protein, enzyme, purification, recovery, genetic engineering.

Graphical Abstract

[1]
Raja, S.; Murty, V.R.; Thivaharan, V.; Rajasekar, V.; Ramesh, V. Aqueous two phase systems for the recovery of biomolecules – A review. Sci. Technol., 2012, 1(1), 7-16.
[2]
Schwenke, K.D. Protein purification. From molecular mechanisms to large-scale processes (ACS Symposium Series 427). Developed from a symposium sponsored by the Division on Biochemical Technology at the 198th National Meeting of the American Chemical Society, Miami Beach Food / Nahrung, 1991, 35(3), p. 325.
[3]
Kumar, S.; Hemavathi, A.B.; Hebbar, H.U. Affinity based reverse micellar extraction and purification of bromelain from pineapple (Ananas comosus L. Merryl) waste. Process Biochem., 2011, 46(5), 1216-1220.
[4]
Cui, K-L.; Yuan, X-Z.; Zeng, G-M.; Liang, Y-S.; Han, Z.; Zhang, S.; Peng, S. Application of biosurfactant on the construction of reversed micelle and the optimization of its microenvironment. China Environ. Sci, 2011, 31(9), 1444-1450.
[5]
Luisi, P.L. Enzymes hosted in reverse micelles in hydrocarbon solution. Angew. Chemie. Int. Ed. Engl., 1985, 24(6), 439-450.
[6]
Peng, X.; Xu, H.; Yuan, X.; Leng, L.; Meng, Y. Mixed reverse micellar extraction and effect of surfactant chain length on extraction efficiency. Sep. Purif. Technol., 2016, 160, 117-122.
[7]
Krishna, S.H.; Srinivas, N.D.; Raghavarao, K.S.M.S.; Karanth, N.G. Reverse micellar extraction for downstream processing of proteins/enzymes. In: Advances in Biochemical Engineering/Biotechnology. 2002: 119-183
[8]
He, S.; Shi, J.; Walid, E.; Ma, Y.; Xue, S.J. Extraction and purification of a lectin from small black kidney bean (Phaseolus vulgaris) using a reversed micellar system. Process Biochem., 2013, 48(4), 746-752.
[9]
He, Z.; Tan, J.S.; Abbasiliasi, S.; Lai, O.M.; Tam, Y.J.; Halim, M.; Ariff, A.B. Primary recovery of miraculin from miracle fruit, Synsepalum dulcificum by AOT reverse micellar system. LWT Food Sci Technol., 2015, 64(2), 1243-1250.
[10]
Chen, Y.L.; Su, C.K.; Chiang, B.H. Optimization of reversed micellar extraction of chitosanases produced by Bacillus cereus. Process Biochem., 2006, 41(4), 752-758.
[11]
Nandini, K.E.; Rastogi, N.K. Reverse micellar extraction for downstream processing of lipase: Effect of various parameters on extraction. Process Biochem., 2009, 44(10), 1172-1178.
[12]
Yeung, P.S.W.; Eskici, G.; Axelsen, P.H. Infrared spectroscopy of proteins in reverse micelles. Biochim. Biophys. Acta Biomembr., 2013, 1828(10), 2314-2318.
[13]
Ellis, R.J.; Minton, A.P. Protein aggregation in crowded environments. Biol. Chem., 2006, 387(5), 485-497.
[14]
Fragoso, A.; Pacheco, R.; Karmali, A. Investigation of structural effects and behaviour of Pseudomonas aeruginosa amidase encapsulated in reversed micelles. Process Biochem., 2012, 47(2), 264-272.
[15]
Meersman, F.; Dirix, C.; Shipovskov, S.; Klyachko, N.L.; Heremans, K. Pressure-induced protein unfolding in the ternary system AOT−octane−water is different from that in bulk water. Langmuir, 2005, 21(8), 3599-3604.
[16]
Moilanen, D.E.; Fenn, E.E.; Wong, D.; Fayer, M.D. Water dynamics at the interface in AOT reverse micelles. J. Phys. Chem. B, 2009, 113(25), 8560-8568.
[17]
Mukherjee, S.; Chowdhury, P.; Gai, F. Infrared study of the effect of hydration on the amide I band and aggregation properties of helical peptides. J. Phys. Chem. B, 2007, 111(17), 4596-4602.
[18]
Storm, S.; Aschenbrenner, D.; Smirnova, I. Reverse micellar extraction of amino acids and complex enzyme mixtures. Sep. Purif. Technol., 2014, 123, 23-34.
[19]
Fayer, M.D. Water in a crowd. Physiology, 2011, 26(6), 381-392.
[20]
Regalado, C.; Asenjo, J.A.; Pyle, D.L. Studies on the purification of peroxidase from horseradish roots using reverse micelles. Enzyme Microb. Technol., 1996, 18(5), 332-339.
[21]
Krei, G.A.; Hustedt, H. Extraction of enzymes by reverse micelles. Chem. Eng. Sci., 1992, 47(1), 99-111.
[22]
Gaikaiwari, R.P.; Wagh, S.A.; Kulkarni, B.D. Efficient lipase purification using reverse micellar extraction. Bioresour. Technol., 2012, 108, 224-230.
[23]
Saha, A.; Yadav, R. Reverse micellar extraction: Technological aspects, applications and recent developments. J. Pharm. Res., 2015, 9(2), 145-156.
[24]
Matzke, S.F.; Creagh, A.L.; Haynes, C.A.; Prausnitz, J.M.; Blanch, H.W. Mechanisms of protein solubilization in reverse micelles. Biotechnol. Bioeng., 1992, 40(1), 91-102.
[25]
Lee, K.L.; Chong, C.C. The use of reverse micelles in downstream processing of biotechnological products. Imp. Coll. London 2011 http://arxiv.org/abs/1109.1641
[26]
Nandini, K.E.; Rastogi, N.K. Single step purification of lactoperoxidase from whey involving reverse micelles-assisted extraction and its comparison with reverse micellar extraction. Biotechnol. Prog., 2010, 26(3), 763-771.
[27]
Gangadharappa, B.; Somalapura, B.; Dammalli, M.; Rajashekarappa, S.; Pandurangappa, K.M.T.; Siddaiah, G.B. Reverse micelles as a bioseparation tool for enzymes. J. Proteins Prroteomics, 2017, 8(2), 105-120.
[28]
Wolbert, R.B.G.; Hilhorst, R.; Voskuilen, G.; Nachtegaal, H.; Dekker, M.; Van’t Riet, K.; Bijsterbosch, B.H. Protein transfer from an aqueous phase into reversed micelles: The effect of protein size and charge distribution. Eur. J. Biochem., 1989, 184(3), 627-633.
[29]
Dungan, S.R.; Bausch, T.; Hatton, T.A.; Plucinski, P.; Nitsch, W. Interfacial transport processes in the reversed micellar extraction of proteins. J. Colloid Interface Sci., 1991, 145(1), 33-50.
[30]
Jarudilokkul, S.; Poppenborg, L.H.; Valetti, F.; Gilardi, G.; Stuckey, D.C. Separation and purification of periplasmic cytochrome c 553 using reversed micelles. Biotechnol. Tech., 1999, 13, 159-163.
[31]
Leser, M.E.; Mrkoci, K.; Luisi, P.L. Reverse micelles in protein separation: The use of silica for the back-transfer process. Biotechnol. Bioeng., 1993, 41(4), 489-492.
[32]
Krishna, S.H.; Srinivas, N.D.; Raghavarao, K.S.M.S.; Karanth, N.G. History and Trends in Bioprocessing and Biotransformation. In: Advances in Biochemical Engineering/Biotechnology, 2002, Volume 75, Edition 1, Springer-Verlag Berlin Heidelberg, IX, 258
[33]
Mitra, R.K.; Paul, B.K. Effect of temperature and salt on the phase behavior of nonionic and mixed nonionic-ionic microemulsions with fish-tail diagrams. J. Colloid Interface Sci., 2005, 291(2), 550-559.
[34]
Guo, Z.; Chen, F.; Yang, H.; Liu, K.; Zhang, L. Kinetics of protein extraction in reverse micelle. Int. J. Food Prop., 2015, 18(8), 1707-1718.
[35]
Anjana, P.; Kumar, A.P.; Srinivasan, P.; Suryaprakash, P.; Kumar, R.S. Reverse micelles extraction of lactoferrin using cationic surfactant from whey. Int. J. Chem. Sci., 2010, 8(5), 49-56.
[36]
Li, X.; He, G.; Lin, C.; Liu, H. Study on the extraction and back extraction of bovine serum albumin using reversed micelles. Sep. Sci. Technol., 2007, 42(16), 3741-3757.
[37]
Bratko, D.; Luzar, A.; Chen, S.H. Electrostatic model for protein/reverse micelle complexation. J. Chem. Phys., 1988, 89(1), 545-550.
[38]
Woll, J.M.; Hatton, T.A. A simple phenomenological thermodynamic model for protein partitioning in reversed micellar systems. Bioprocess Eng., 1989, 4(5), 193-199.
[39]
Haghtalab, A.; Osfouri, S. Vacancy solution theory for partitioning of protein in reverse-micellar systems. Sep. Sci. Technol., 2003, 38(3), 553-569.
[40]
Osfouri, S.; Tayebi, T.; Azin, R. A new thermodynamic approach for protein partitioning in reverse micellar solution. Phys. Chem. Res., 2018, 6(1), 105-113.
[41]
Umesh Hebbar, H.; Sumana, B.; Raghavarao, K.S. Use of reverse micellar systems for the extraction and purification of bromelain from pineapple wastes. Bioresour. Technol., 2008, 99(11), 4896-4902.
[42]
Peng, X.; Yuan, X.Z.; Zeng, G.M.; Huang, H.J.; Zhong, H.; Liu, Z.F.; Cui, K.; Liang, Y.; Peng, Z.; Guo, L.; Ma, Y.; Liu, W. Extraction and purification of laccase by employing a novel rhamnolipid reversed micellar system. Process Biochem., 2012, 47(5), 742-748.
[43]
Liang, Y.; Yuan, X.; Zeng, G.; Zhong, H.; Li, H.; Wang, W. Effects of surfactants on enzyme-containing reversed micellar system. Sci. China Chem., 2011, 54(5), 715-723.
[44]
Liu, Y.; Dong, X.; Sun, Y. New development of reverse micelles and applications in protein separation and refolding. Chinese. J. Chem. Eng., 2008, 16(6), 949-955.
[45]
Chuo, S.C.; Mohd-Setapar, S.H.; Mohamad-Aziz, S.N.; Starov, V.M. A new method of extraction of amoxicillin using mixed reverse micelles. Colloids Surfaces. A Physicochem. Eng. Asp., 2014, 460, 137-144.
[46]
Sawada, K.; Ueda, M.; Kajiwara, K. Simultaneous dyeing and enzyme processing of fabrics in a non-ionic surfactant reverse micellar system. Dyes Pigments, 2004, 63(3), 251-258.
[47]
Singh, S.K.; Kishore, N. Thermodynamic insights into the binding of triton X-100 to globular proteins: A calorimetric and spectroscopic investigation. J. Phys. Chem. B, 2006, 110(19), 9728-9737.
[48]
Naoe, K.; Ura, O.; Hattori, M.; Kawagoe, M.; Imai, M. Protein extraction using non-ionic reverse micelles of Span 60. Biochem. Eng. J., 1998, 2(2), 113-119.
[49]
Naoe, K.; Nishino, M.; Ohsa, T.; Kawagoe, M.; Imai, M. Protein extraction using sugar ester reverse micelles. J. Chem. Technol. Biotechnol., 1999, 74(3), 221-226.
[50]
Walde, P.; Giuliani, A.M.; Boicelli, C.A.; Luisi, P.L. Phospholipid based reverse micelles. Chem. Phys. Lipids, 1990, 53(4), 265-288.
[51]
Ichikawa, S.; Sugiura, S.; Nakajima, M.; Sano, Y.; Seki, M.; Furusaki, S. Formation of biocompatible reversed micellar systems using phospholipids. Biochem. Eng. J., 2000, 6(3), 193-199.
[52]
He, S.; Shi, J.; Walid, E.; Zhang, H.; Ma, Y.; Xue, S.J. Reverse micellar extraction of lectin from black turtle bean (Phaseolus vulgaris): Optimisation of extraction conditions by response surface methodology. Food Chem., 2015, 166, 93-100.
[53]
Hsiao, Y-C.; Lin, Y-W.; Su, C-K.; Chiang, B-H. High degree polymerized chitooligosaccharides synthesis by chitosanase in the bulk aqueous system and reversed micellar microreactors. Process Biochem., 2008, 43(1), 76-82.
[54]
Ceraulo, L.; Fanara, S.; Turco Liveri, V.; Ruggirello, A.; Panzeri, W.; Mele, A. Orientation and molecular contacts of melatonin confined into AOT and lecithin reversed micellar systems. Colloids Surfaces. A Physicochem. Eng. Asp., 2008, 316(1-3), 307-312.
[55]
Hebbar, U.H. Reverse Micellar Extraction for Downstream Processing of Enzymes/ Proteins 2007
[56]
Hemavathi, A.B.; Hebbar, H.U.; Raghavarao, K.S. Mixed reverse micellar systems for extraction and purification of β-glucosidase. Sep. Purif. Technol., 2010, 71(2), 263-268.
[57]
Mohd-Setapar, S.H.; Wakeman, R.J.; Tarleton, E.S. Penicillin G solubilisation into AOT reverse micelles. Chem. Eng. Res. Des., 2009, 87(6), 833-842.
[58]
Pires, M.J.; Aires-Barros, M.R.; Cabral, J.M.S. Liquid-liquid extraction of proteins with reversed micelles. Biotechnol. Prog., 1996, 12(3), 290-301.
[59]
Mathew, D.S.; Juang, R.S. Role of alcohols in the formation of inverse microemulsions and back extraction of proteins/enzymes in a reverse micellar system. Sep. Purif. Technol., 2007, 53(3), 199-215.
[60]
Li, S.; Cao, X. Extraction of tea polysaccharides (TPS) using anionic reverse micellar system. Sep. Purif. Technol., 2014, 122, 306-314.
[61]
Michizoe, J.; Ichinose, H.; Kamiya, N.; Maruyama, T.; Goto, M. Biodegradation of phenolic environmental pollutants by a surfactant–laccase complex in organic media. J. Biosci. Bioeng., 2005, 99(6), 642-647.
[62]
Dekker, M.; Hilhorst, R.; Laane, C. Isolating enzymes by reversed micelles. Anal. Biochem., 1989, 178(2), 217-226.
[63]
Liu, J-G.; Xing, J-M.; Shen, R.; Yang, C-L.; Liu, H-Z. Reverse micelles extraction of nattokinase from fermentation broth. Biochem. Eng. J., 2004, 21(3), 273-278.
[64]
Gaikaiwari, R.P.; Wagh, S.A.; Kulkarni, B.D. Extraction and purification of tannase by reverse micelle system. Sep. Purif. Technol., 2012, 89, 288-296.
[65]
Zhou, B.; Wan, J.; Wang, J.; Cao, X. Effect of chaotropes in reverse micellar extraction of kallikrein. Process Biochem., 2012, 47(2), 229-233.
[66]
Gull, N.; Kumar, S.; Ahmad, B.; Khan, R.H. Kabir-ud-Din. Influence of urea additives on micellar morphology/protein conformation. Colloids Surf. B Biointerfaces, 2006, 51(1), 10-15.
[67]
Wan, J.; Li, Q.; Zhou, F.; Liu, J.; Cao, X. Influence of chaotropes on recovery of trypsin and micellar sizes during reverse micelle extraction. Sep. Purif. Technol., 2013, 116, 307-312.
[68]
Aires-Barros, M.R.; Cabral, J.M.S. Selective separation and purification of two lipases fromchromobacterium viscosum using AOT reversed micelles. Biotechnol. Bioeng., 1991, 38(11), 1302-1307.
[69]
Ono, T.; Goto, M. Application of reversed micelles in bioengineering. Curr. Opin. Colloid Interface Sci., 1997, 2(4), 397-401.
[70]
Yi, S.; Dai, F.; Zhao, C.; Si, Y. A reverse micelle strategy for fabricating magnetic lipase-immobilized nanoparticles with robust enzymatic activity. Sci. Rep., 2017, 7(1), 1-9.
[71]
Freitas, O.; Delerue-Matos, C.; Boaventura, R. Optimization of Cu(II) biosorption onto Ascophyllum nodosum by factorial design methodology. J. Hazard. Mater., 2009, 167(1-3), 449-454.
[72]
Jayachandran, D.; Chityala, S.; Prabhu, A.A.; Dasu, V.V. Cationic reverse micellar based purification of recombinant glutaminase free L-asparaginase II of Bacillus subtilis WB800N from fermentation media. Protein Expr. Purif., 2019. 157(December 2018 1-8
[73]
Lee, S.Y.; Khoiroh, I.; Ling, T.C.; Show, P.L. Aqueous two-phase flotation for the recovery of biomolecules. Sep. Purif. Rev., 2016, 45(1), 81-92.
[74]
Imm, J-Y.; Kim, S-C. Convenient partial purification of polyphenol oxidase from apple skin by cationic reversed micellar extraction. Food Chem., 2009, 113(1), 302-306.
[75]
Carvalho, C. Reverse micelles as reaction media for lipases. Biochimie, 2000, 82(11), 1063-1085.
[76]
Lee, K.K.B.; Poppenborg, L.H.; Stuckey, D.C. Terpene ester production in a solvent phase using a reverse micelle-encapsulated lipase. Enzyme Microb. Technol., 1998, 23(3-4), 253-260.
[77]
Naoe, K.; Kataoka, M.; Kawagoe, M. Preparation of water-soluble palladium nanocrystals by reverse micelle method: Digestive ripening behavior of mercaptocarboxylic acids as stabilizing agent. Colloids Surf. A Physicochem. Eng. Asp., 2010, 364(1-3), 116-122.
[78]
Poinern, G.E.J.; Ng, Y-J.; Fawcett, D. Fine-tuning of catalytic tin nanoparticles by the reverse micelle method for direct deposition of silicon nanowires by a plasma-enhanced chemical vapour technique. J. Colloid Interface Sci., 2010, 352(2), 259-264.

© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version423msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[13:16:54] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[13:16:54] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[13:16:54] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (158ms)time
  • Application (266ms)time
  • 1 x Application (62.76%)
    266ms
    1 x Booting (37.24%)
    158ms
    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
    31 statements were executed, 4 of which were duplicates, 27 unique. Show only duplicated161ms
    • 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 ('59228343','',1,1739971014,1739971014) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739971014
      15.99msalphaeurekaselec_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 ('59228343','/article/99292',1,1739971014,1739971014)
      250μ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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) limit 1
      19.74msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59228343
      • 1: 59228343
      • 2: 59228343
      • 3: 59228343
      • 4: 59228343
      • 5: 59228343
      • 6: 59228343
      • 7: 59228343
      • 8: 59228343
      • 9: 59228343
      • 10: 59228343
      • 11: 59228343
      • 12: 59228343
      • 13: 59228343
      • 14: 59228343
      • 15: 59228343
      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=99292
      1.07msalphaeurekaselec_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` = 42 limit 1
      1.11msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 42
      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=42) and sj.journal_id!=42 group by `j`.`nid`) as `aggregate_table`
      1.24msalphaeurekaselec_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=42) and sj.journal_id!=42 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.08msalphaeurekaselec_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=42) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      4.19msalphaeurekaselec_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=42) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      4.3msalphaeurekaselec_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` = '99292'
      4.53msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 99292
      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` = '99292'
      7.06msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 99292
      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` = '99292' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      5.08msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 99292
      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
      4.74msalphaeurekaselec_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
      680μ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 = 42 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      56.53msalphaeurekaselec_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 = 42 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      11.84msalphaeurekaselec_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 = 42 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      8.95msalphaeurekaselec_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` = 99292 limit 1
      1.5msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 99292
      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 = 99292 and content_type = 'article' order by status desc limit 1
      620μ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` = 173099 limit 1
      220μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 173099
      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
      250μ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` = 'CPPS' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      330μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CPPS
      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 = '99292' 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) )
      1.19msalphaeurekaselec_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 * from `article` where `first_page` < '1012' and is_uploaded = 1 and issue_id = 9336 order by cast(first_page as SIGNED) desc limit 1
      570μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 1012
      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` > '1026' and is_uploaded = 1 and issue_id = 9336 order by cast(first_page as SIGNED) asc limit 1
      670μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 1026
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'en'
      230μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      280μ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` = 99292 limit 1
      3.64msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 99292
      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` = 42 and `b`.`banner_from_date` <= 1739971014 and `b`.`banner_to_date` >= 1739971014 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.72msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 42
      • 3: 1739971014
      • 4: 1739971014
      • 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` = 42 and `b`.`banner_from_date` <= 1739971014 and `b`.`banner_to_date` >= 1739971014 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.34msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 42
      • 3: 1739971014
      • 4: 1739971014
      • 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='0d44e77de2c97b353a9193912252cbd1'
      300μ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
        vAZyd6U3NQSRpdVe2yf9FGCYJ6GcUyc0wk63ly9R
        uc_cart_id
        0d44e77de2c97b353a9193912252cbd1
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/99292" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/99292
        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:16:54 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkEwTkVFbHduekpIbUFWc0x1QXpBN1E9PSIsInZhbHVlIjoiaUhaL0ltYVE0VFNubmZMTWFod09zQ3JKK0MvOTJ1VURLbERqL3RwcjZFOFlzZVQvemsxdjl2VE5Vczc3dHlPWTB0c3J1QkpSTDJuMHQvSDk2d2U3eGpieTcrZm9MQVFPYlhRdnJxa2hrcGFBK2NMa0JJY1I0T1lzK013c3hNVnAiLCJtYWMiOiI5NTc3NjUyYWRmMDczYzc2NTM2Y2RmZjA1YWNiZWExNjYxODlmOGU5MGFjMDc3YTVjMjY0ZDEyNTI4YzQyYTZiIiwidGFnIjoiIn0%3D; expires=Sat, 22 Feb 2025 01:16:54 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkEwTkVFbHduekpIbUFWc0x1QXpBN1E9PSIsInZhbHVlIjoiaUhaL0ltYVE0VFNubmZMTWFod09zQ3JKK0MvOTJ1VURLbERqL3RwcjZFOFlzZVQvemsxdjl2VE5Vczc3dHlPWTB0c3J1Q" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlRSdDZwMGVDYVU1T0hwTlkzTnJhc3c9PSIsInZhbHVlIjoib29nMG0zUDZyTDBLeHF5OU9VVHlKS1doSlYzamFHeWpWcFg1MzNNLy9vK3FDVEphRVRLMG92WGtFVWxsL2RVLzRIWFZjOWdKaWo0c2FaQ3FqLzVDcDFVL1pGdVl0NzZrUjBrUUVVRnE4clZsWFJvWUZOby81NlVndUw1ZDRDdXAiLCJtYWMiOiJlZWMyZTM4YzFhMTIxNGY0MWJmODY3M2EyNTkzYzgwNGY5NTMwZTgyZDBlOGI4ZmU1YjZjZjBmMjMyZGYwMzc0IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlRSdDZwMGVDYVU1T0hwTlkzTnJhc3c9PSIsInZhbHVlIjoib29nMG0zUDZyTDBLeHF5OU9VVHlKS1doSlYzamFHeWpWcFg1MzNNLy9vK3FDVEphRVRLMG92WGt" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkEwTkVFbHduekpIbUFWc0x1QXpBN1E9PSIsInZhbHVlIjoiaUhaL0ltYVE0VFNubmZMTWFod09zQ3JKK0MvOTJ1VURLbERqL3RwcjZFOFlzZVQvemsxdjl2VE5Vczc3dHlPWTB0c3J1QkpSTDJuMHQvSDk2d2U3eGpieTcrZm9MQVFPYlhRdnJxa2hrcGFBK2NMa0JJY1I0T1lzK013c3hNVnAiLCJtYWMiOiI5NTc3NjUyYWRmMDczYzc2NTM2Y2RmZjA1YWNiZWExNjYxODlmOGU5MGFjMDc3YTVjMjY0ZDEyNTI4YzQyYTZiIiwidGFnIjoiIn0%3D; expires=Sat, 22-Feb-2025 01:16:54 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkEwTkVFbHduekpIbUFWc0x1QXpBN1E9PSIsInZhbHVlIjoiaUhaL0ltYVE0VFNubmZMTWFod09zQ3JKK0MvOTJ1VURLbERqL3RwcjZFOFlzZVQvemsxdjl2VE5Vczc3dHlPWTB0c3J1Q" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlRSdDZwMGVDYVU1T0hwTlkzTnJhc3c9PSIsInZhbHVlIjoib29nMG0zUDZyTDBLeHF5OU9VVHlKS1doSlYzamFHeWpWcFg1MzNNLy9vK3FDVEphRVRLMG92WGtFVWxsL2RVLzRIWFZjOWdKaWo0c2FaQ3FqLzVDcDFVL1pGdVl0NzZrUjBrUUVVRnE4clZsWFJvWUZOby81NlVndUw1ZDRDdXAiLCJtYWMiOiJlZWMyZTM4YzFhMTIxNGY0MWJmODY3M2EyNTkzYzgwNGY5NTMwZTgyZDBlOGI4ZmU1YjZjZjBmMjMyZGYwMzc0IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlRSdDZwMGVDYVU1T0hwTlkzTnJhc3c9PSIsInZhbHVlIjoib29nMG0zUDZyTDBLeHF5OU9VVHlKS1doSlYzamFHeWpWcFg1MzNNLy9vK3FDVEphRVRLMG92WGt" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "vAZyd6U3NQSRpdVe2yf9FGCYJ6GcUyc0wk63ly9R" "uc_cart_id" => "0d44e77de2c97b353a9193912252cbd1" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/99292" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-19 13:16:54GET/article/99292314311