Generic placeholder image

Current Nutrition & Food Science

Editor-in-Chief

ISSN (Print): 1573-4013
ISSN (Online): 2212-3881

Review Article

A Renewable Source as a Functional Food: Chia Seed

Author(s): Ahmet H. Dinçoğlu* and Özge Yeşildemir

Volume 15, Issue 4, 2019

Page: [327 - 337] Pages: 11

DOI: 10.2174/1573401314666180410142609

Price: $65

Abstract

Background: Chia seed is not a new food for humanity. The seed has been used in many different areas since the Aztecs, especially the food items. The chia seed is -becoming increasingly important because of its nutritional and functional properties and it is described as “the seed of the 21st century” and “new gold and super nutrient”.

Objective: In this review, general characteristics, nutritional composition, fields of usage, effects on health and importance in human nutrition of the chia seed have been evaluated.

Conclusion: This seed is shown as an important source of dietary fiber (soluble and insoluble), omega- 3 fatty acids, proteins, bioactive and polyphenolic compounds. It also has many physicochemical and functional properties that make it more suitable for the food industry. Chia seed is a good thickener, gel forming and chelating agent, foam enhancer, emulsifier, suspending agent and rehydration factor. Foods such as frozen products, bakery products, beverages, sweets, pasta, and sausages can be enriched with seeds and chia oil can be used as fat replacer for these products. Some studies have shown that consumption of the seed is beneficial for health problems such as dyslipidemia, inflammation, cardiovascular diseases and insulin resistance. However, the results of studies demonstrating the effect of the seeds on diseases have been controversial and many of the studies on this subject are animal studies. There is a need for further studies to reveal the effects of chia seed on human health and its importance in the food industry.

Keywords: Chia seed, dietary fiber, dyslipidemia, functional properties, nutrient, polyphenolic compounds.

Graphical Abstract

[1]
Hasler CM, Brown AC. Position of the American Dietetic Association: Functional foods. J Am Diet Assoc 2009; 109(4): 735-46.
[2]
Berner LA, O’Donnell JA. Functional foods and health claims legislation: Applications to dairy foods. Int Dairy J 1998; 8: 355-62.
[3]
Dick M, Costa TM, Gomaa A, et al. Edible film production from chia seed mucilage: Effect of glycerol concentration on its physicochemical and mechanical properties. Carbohydr Polym 2015; 130: 198-205.
[4]
Valdivia-Lopez MA, Tecante A. Chia (Salvia hispanica): A review of native Mexican seed and its nutritional and functional properties. Adv Food Nutr Res 2015; 75: 53-75.
[5]
Inglett GE, Chen D, Liu S. Physical properties of sugar cookies containing chia-oat composites. J Sci Food Agric 2014; 94: 3226-33.
[6]
Pintado T, Herrero AM, Jiménez-Colmenero F, Ruiz-Capillas C. Strategies for incorporation of chia (Salvia hispanica L.) in frankfurters as a health-promoting ingredient. Meat Sci 2016; 114: 75-84.
[7]
Coelho MS, Salas-Mellado M. Effects of substituting chia (Salvia hispanica L.) flour or seeds for wheat flour on the quality of the bread. LWT - Food Sci Technol 2015; 60: 729-36.
[8]
Vuksan V, Whitham D, Sievenpiper JL, et al. Supplementation of conventional therapy with the novel grain Salba (Salvia hispanica L.) improves major and emerging cardiovascular risk factors in type2 diabetes: results of randomized controlled trial. Diabetes Care 2007; 30: 2804-10.
[9]
Vuksan V, Jenkins AL, Dias AG, et al. Reduction possible explanation of the long-term effects of whole grain Salba (Salvia hispanica L.). Eur J Clin Nutr 2010; 64: 436-8.
[10]
de Souza Ferreira C, de Sousa Fomes Lde F, da Silva GE, Rosa G. Effect of chia seed (Salvia hispanica L.) consumption on cardiovascular risk factors in humans: A systematic review. Nutr Hosp 2015; 32(5): 1909-18.
[11]
Mohd Ali N, Keong Yeap S, Yong Ho W, et al. The promising future of chia, Salvia hispanica L. J Biomed Biotechnol 2012; 1-9.
[12]
Bresson JL, Flynn A, Heinonen M, et al. Opinion on the safety of “Chia seeds (Salvia hispanica L.) and ground whole Chia seeds” as a food ingredient. Eur Food Saf Authority J 2009; 996: 1-26.
[14]
[17]
Daniells S. Chia boom: With 239% growth, chia category set to hit $1 bn by 2020. Super grains! From chia to quinoa Available from:. www.foodnavigator-usa.com/Markets/Chia-boom-With-239-growth-chiacategory-set-to-hit-1-bn-by-2020 (Accessed 2017-08-01)
[18]
Ayerza R, Coates W. Composition of chia (Salvia hispanica) grown in six tropical and sub-tropical ecosystems of South America. Trop Sci 2004; 44: 131-5.
[19]
Capitani MI, Spotorno V, Nolasco SM, Tomás MC. Physicochemical and functional characterization of by-products from chia (Salvia hispanica L.) seeds of Argentina. LWT - Food Sci Technol 2012; 45-9.
[20]
Reyes-Caudillo E, Tecante A, Valdivia-López MA. Dietary fibre content and antioxidant activity of phenolic compounds present in Mexican chia (Salvia hispanica L.) seeds. Food Chem 2008; 107: 656-63.
[21]
da Silva Marineli R, Aguiar-Moraes E, Alves-Lenquiste S, et al. Chemical characterization and antioxidant potential of Chilean chia seeds and oil (Salvia hispanica L.). LWT - Food Sci Technol 2014; 59: 1304-10.
[22]
Özbek T. Çiya tohumu ilaveli, şeker ilavesiz çilek marmeladıPhD dissertation Istanbul Technical University 2016.
[23]
USDA National Nutrient Database for Standard Reference Release 28 (2011). Basic report 12006, seeds, Chia seeds, dried. Report date: January 11, 2016
[24]
Gopalan C, Rama Sastri BV, Balasubramanian SC. Nutritive value of Indian foods. National Institute of Nutrition, Indian Council of Medical Research Hyderabad, India 2007.
[25]
Ixtaina VY, Nolasco SM, Tom’as MC. Physical properties of chia (Salvia hispanica L.) seeds. Ind Crops Prod 2008; 28(3): 286-93.
[26]
Ding Y, Lin HW, Lin YL, et al. Nutritional composition in the chia seed and its processing properties on restructured ham-like products. J Food Drug Anal 2018; 26(1): 124-34.
[27]
Munoz LA, Cobos A, Diaz O, Aguilera JM. Chia seeds: Microstructure, mucilage extraction and hydration. J Food Eng 2012; 108: 216-24.
[28]
Coates W, Ayerza R. Production potential of Chia in northwestern Argentina. Ind Crops Prod 1996; 5: 229-33.
[29]
Monroy-Tores R, Mancilla-Escobar ML, Gallaga-Solórzano JC, Medina-Godoy S, Santiago-García EJ. Protein digestibility of chia seed. Rev Salud Publica Nutr 2008; 9(1): 1.
[30]
Coates W, Ayerza R. Commercial production of Chia in northwestern Argentina. J Am Oil Chem Soc 1998; 75: 1417-20.
[31]
Vázquez-Ovando JA, Rosado-Rubio JG, Chel-Guerrero LA. Betancur- Ancona DA. Dry processing of chia (Salvia hispanica L.) flour: Chemical and characterization of fiber and protein. CYTA J Food 2010; 8: 117-27.
[32]
Segura-Campos MR, Salazar-Vega IM, Chel-Guerrero LA, Betancur-Ancora DA. Biological potential of chia (Salvia hispanica L.) protein hydrolysates and their incorporation into functional foods. LWT-Food Sci Technol 2013; 50: 723-31.
[33]
Olivos-Lugo BL. Valdivia-LópezMÁ, Tecante A. Thermal and physicochemical properties and nutritional value of the protein fraction of Mexican chia seed (Salvia hispanica L.). Food Sci Technol Int 2010; 16: 89-96.
[34]
Sandoval-Oliveros MR, Paredes-Lopez O. Isolation and characterization of proteins from chia seeds (Salvia hispanica L.). J Agric Food Chem 2013; 61(1): 193-201.
[35]
da Silva BP, Morais-Dias D, de Castro Moreira ME, et al. Chia seed shows good protein quality, hypoglycemic effect and improves the lipid profile and liver and intestinal morphology of Wistar rats. Plant Foods Hum Nutr 2016; 71: 225-30.
[36]
Fernandes SS, de las Mercedes Salas-Mellado M. Addition of chia mucilage for reduction of fat content in bread and cakes. Food Chem 2017; 227: 237-44.
[37]
Jin F, Nieman DC, Sha W, Xie G, Qiu Y, Jia W. Supplementation of milled chia seeds increases plasma ALA and EPA in postmenopasual women. Plant Foods Hum Nutr 2012; 67: 105-10.
[38]
Timilsena YP, Adhikari R, Barrow CJ, Adhikari B. Microencapsulation of chia seed oil using chia seed protein isolate-chia seed gum complex coacervates. Int J Biol Macromol 2016; 91: 347-57.
[39]
Segura-Campos MR, Ciau-Solís N, Rosado-Rubio G, Chel-Guerrero L, Betancur-Ancona D. Physicochemical characterization of chia (Salvia hispanica) seed oil from Yucatán, México. Agric Sci 2014; 5(3): 220-6.
[40]
Ayerza R. Oil content and fatty acid composition of chia (Salvia hispanica L.) from five northeastern locations in northwestern Argentina. J Am Oil Chem Soc 1995; 72(9): 1079-81.
[41]
Ixtaina VY, Martínez ML, Spotorno V, et al. Characterization of chia seed oils obtained by pressing and solvent extraction. J Food Compos Anal 2011; 24(2): 166-74.
[42]
Ayerza R, Coates W. Protein content, oil content and fatty acid profiles as potential criteria to determine the origin of commercially grown chia (Salvia hispanica L.). J. Ind Crops Prod 2011; 34: 1366-71.
[43]
Martínez ML, Curti MI, Roccia P, et al. Oxidative stability of walnut (Juglans regia L.) and chia (Salvia hispanica L.) oils microencapsulated by spray drying. Powder Technol 2015; 270: 271-7.
[44]
Timilsena YP, Vongsvivut J, Adhikari R, Adhikari B. Physicochemical and thermal characteristic of Australian chia seed oil. Food Chem 2017; 228: 394-402.
[45]
Chicco AG, D’Alessandro ME, Hein GJ, et al. Dietary chia seed (Salvia hispanica L.) rich in alpha-linolenic acid improves adiposity and normalises hypertriacylglycerolaemia and insulin resistance in dyslipaemic rats. Br J Nutr 2009; 101: 41-50.
[46]
Ovando JV, Rubio GR, Guerrero LC, Ancona DB. Physicochemical properties of fibrous fraction from chia (Salvia hispanica L.). LWT-. J Food Sci Technol 2009; 42: 168-73.
[47]
Álvarez-Chávez LM, Valdivia-López MA, Aburto-Juárez M, Tecante A. Chemical characterization of the lipid fraction of Mexican chia seed (Salvia hispanica L.). Int J Food Prop 2008; 11: 687-97.
[48]
Ixtaina VY, Nolasco SM, Tomás MC. Oxidative stability of chia (Salvia hispanica L.) seed oil: Effect of antioxidants and storage conditions. J Am Oil Chem Soc 2012; 89: 1077-90.
[49]
Nijveldt RJ, van Nood E, van Hoorn EC, et al. Flavonoids: A review of probable mechanisms of action and potential applications. Am J Clin Nutr 2001; 74: 418-25.
[50]
Martínez-Cruz O, Paredes-López O. Phytocemical profile and nutraceutical potential of chia seeds (Salvia hispanica L.) by ultra high performance liquid chromatography. J Chromatogr A 2014; 1346: 43-8.
[51]
Tuberoso C, Kowalczyk A, Sarritzu E, Cabras P. Determination of antioxidant compounds and antioxidant activity in commercial oilseeds for food use. Food Chem 2007; 103: 1494-501.
[52]
Segura-Campos. Ciau-Solís N, Rosado-Rubio G, Chel-Guerrero L, Betancur-Ancona D. Chemical and functional properties of chia seed (Salvia hispanica L.) gum. Int J Food Sci 2014; 2014: 1-5.
[53]
Alfredo VO, Gabriel RR, Luis CG, David BA. Physicochemical properties of a fibrous fraction from chia (Salvia hispanica L.). LWT-Food Sci Technol 2009; 42: 168-73.
[54]
Borneo R, Aguirre A, León AE. Chia (Salvia hispanica L) gel can be used as egg or oil replacer in cake formulations. J Am Diet Assoc 2010; 110: 946-9.
[55]
Felisberto MHF, Wahanik AL, Gomes-Ruffi CR, et al. Use of chia (Salvia hispanica L.) mucilage gel to reduce fat in pound cakes. LWT - Food Sci Technol 2015; 63: 1049-55.
[56]
Herrero AM, Ruiz-Capillas C, Pintado T, Carmona P, Jimenez-Colmenerp F. Infrared spectroscopy used to determine effects of chia and olive oil incorporation strategies on lipid structure of reduced-fat frankfurters. Food Chem 2017; 221: 1333-9.
[57]
Coates W, Ayerza R. Chia (Salvia hispanica L.) seed as an omega-3 fatty acid source for finishing pigs: effects on fatty acid composition and fat stability of the meat and internal fat, growth performance, and meat sensory characteristics. J Anim Sci 2009; 87: 3798-804.
[58]
Pintado T, Herrero AM, Ruiz-Capillas C, et al. Effects of emulsion gels containing bioactive compounds on sensorial, technological, and structural properties of frankfurters. Food Sci Technol Int 2010; 22: 132-45.
[59]
Antruejo A, Azcona JO, Garcia PT, et al. Omega-3 enriched egg production: The effect of a-linolenic x-3 fatty acid sources on laying hen performance and yolk lipid content and fatty acid composition. Br Poult Sci 2011; 52(6): 750-60.
[60]
Ayerza R, Coates W. Omega-3 enriched eggs: The influence of dietary α-linolenic fatty acid source on egg production and composition. Can J Anim Sci 2001; 355-61.
[61]
Ayerza R, Coates W. Dietary levels of Chia: Influence on hen weight, egg production and sensory quality, for two strains of hens. Br Poult Sci 2002; 43: 283-90.
[62]
Masoero G, Sala G, Meineri G, et al. Nir spectroscopy and electronic nose evaluation on live rabbits and on the meat of rabbits fed increasing levels of Chia (Salvia hispanica L.) seeds. J Anim Vet Adv 2008; 7(11): 1394-9.
[63]
Dalle Zotte A, Szendro Z. The role of rabbit meat as functional food. Meat Sci 2011; 88(3): 319-31.
[64]
Peiretti PG, Meineri G. Effects on growth performance, carcass characteristics, and the fat and meat fatty acid profile of rabbits fed diets with chia (Salvia hispanica L.) seed supplements. Meat Sci 2008; 80: 1116-21.
[65]
Ayerza R, Coates W, Lauria M. Chia seed (Salvia hispanica L.) as an omega-3 fatty acid source for broilers: Influence on fatty acid composition, cholesterol and fat content of white and dark meats, growth performance, and sensory characteristics. Poult Sci 2002; 81: 826-37.
[66]
Campos BE, Ruivo TD, Scapim MRS, Madrona GS, Bergamasco RC. Optimization of the mucilage extraction process from chia seeds and application in ice cream as a stabilizer and emulsifier. LWT - Food Sci Technol 2016; 65: 874-83.
[67]
Bustamante M, Oomah BD, Rubilar M, Shene C. Effective Lactobacillus plantarum and Bifidobacterium infantis encapsulation with chia seed (Salvia hispanica L.) and flaxseed (Linum usitatissimum L.) mucilage and soluble protein by spray drying. Food Chem 2017; 216: 97-105.
[68]
Nieman DC, Gillitt N, Jin F, et al. Chia seed supplementation and disease risk factors in overweight women: A metabolomics investigation. J Altern Complement Med 2012; 18(7): 700-8.
[69]
Vuksan V, Jenkins AL, Brissette C, et al. Salba-chia (Salvia hispanica L.) in the treatment of overweight and obese patients with type 2 diabetes: A double-blind randomized controlled trial. Nutr Metab Cardiovasc Dis 2017; 27: 138-46.
[70]
Toscano LT, da Silva CSO, de Almeida AEM, da Cruz Santos A, Silva AS. Chia flour supplementation reduces blood pressure in hypertensive subjects. Plant Foods Hum Nutr 2014; 69: 392-8.
[71]
Jenks AA, Kim SC. Medicinal plant complexes of Salvia subgenus Calosphace: An ethnobotanical study of new world sages. J Ethnopharmacol 2013; 146: 214-24.
[72]
Nieman DC, Cayea EJ, Austin MD, Henson DA, McAnulty SR, Jin F. Chia seed does not promote weight loss or alter disease risk factors in overweight adults. Nutr Res 2009; 29: 414-8.
[73]
da Silva M, Moura CS, Moraes ÉA, et al. Chia (Salvia hispanica L.) enhances HSP, PGC-1α expressions and improves glucose tolerance in diet-induced obese rats. Nutrition 2015; 31: 740-8.
[74]
Poudyal H, Panchal SK, Waanders J, et al. Lipid redistribution by a-linolenic acid-rich chia seed inhibits stearoyl-CoA desaturase-1 and induces cardiac and hepatic protection in diet-induced obese rats. J Nutr Biochem 2012; 23: 153-62.
[75]
Ayerza R Jr, Coates W. Effect of dietary alpha-linolenic fatty acid derived from chia when fed as ground seed, whole seed and oil on lipid content and fatty acid composition of rat plasma. Ann Nutr Metab 2007; 51: 27-34.
[76]
Ho H, Lee AS, Jovanovski E, et al. Effect of whole and ground Salba seeds (Salvia Hispanica L.) on postprandial glycemia in healthy volunteers: a randomized controlled, dose-response trial. Eur J Clin Nutr 2013; 67(7): 786-8.
[77]
Brinkman MT, Karagas MR, Zens MS, et al. Intake of a-linolenic acid and other fatty acids in relation to the risk of bladder cancer: results from the New Hampshire case-control study. Br J Nutr 2011; 106: 1070-7.
[78]
Maillard V, Hoinard C, Arab K, et al. Dietary beta-carotene inhibits mammary carcinogenesis in rats depending on dietary alpha-linolenic acid content. Br J Nutr 2006; 96: 18-21.
[79]
Rossi AS, Oliva ME, Ferreira MR, Chicco A, Lombardo YB. Dietary chia seed induced changes in hepatic transcription factors and their target lipogenic and oxidative enzyme activities in dislipidaemic insulin-resistant rats. Br J Nutr 2013; 109: 1617-27.
[80]
Sierra L, Roco J, Alarcon G, et al. Dietary intevention with Salvia hispanica (Chia) oil improves vascular function in rabbits under hypercholesterolaemic conditions. J Funct Foods 2015; 14: 641-9.
[81]
Vedtofte MS, Jakobsen MU, Lauritzen L, Heitmann BL. Dietary α-linolenic acid, linoleic acid, and n-3 long-chain PUFA and risk of ischemic heart disease. Am J Clin Nutr 2011; 94: 1097-103.
[82]
Commission EU. Authorizing the placing on the market of chia seeds (Salvia hispanica) as novel food ingredient under Regulation (EC) No. 258/97 of European Parliament of the Council. Official Journal of the European Union C 2009; 7645.
[83]
EFSA. Opinion of the scientific panel on dietetic products, nutrition and allergies on a request from the European commission related to the safety of chia (Salvia hispanica L.), seeds and ground whole chia as a novel food ingredient intended for use in bread. EFSA J 2005; 278: 1-12.
[84]
EFSA. Scientific opinion of the panel on dietetic products, nutrition and allergies on a request from the European commission on the safety of ‘Chia seeds (Salvia hispanica L.) and ground whole chia seeds’ as a food ingredient. EFSA J 2009; 996: 1-2.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version469msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[13:23:33] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[13:23:34] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[13:23:34] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (135ms)time
  • Application (334ms)time
  • 1 x Application (71.24%)
    334ms
    1 x Booting (28.76%)
    135ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated241ms
    • 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,1739971413,1739971413) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739971413
      1.2msalphaeurekaselec_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/89632',1,1739971413,1739971413)
      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 >= 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
      13.9msalphaeurekaselec_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=89632
      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` = 35 limit 1
      810μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 35
      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=35) and sj.journal_id!=35 group by `j`.`nid`) as `aggregate_table`
      540μ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=35) and sj.journal_id!=35 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      430μ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=35) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      770μsalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 16. app/Models/Subject.php:220
      • 17. app/Http/Controllers/ArticleController.php:2518
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=35) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      730μsalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 14. app/Models/Subject.php:220
      • 15. app/Http/Controllers/ArticleController.php:2518
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `keywords` where `article_id` = '89632'
      1.15msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 89632
      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` = '89632'
      2.77msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 89632
      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` = '89632' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.87msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 89632
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ArticleController.php:2533
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      290μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      650μsalphaeurekaselec_live_10_06_2022Article.php#1960
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1960
      • 14. app/Http/Controllers/ArticleController.php:2062
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • Select j.subtitle, v.volume_id as volume_id,v.year_id,y.year as year,v.volume_name, v.total_no_of_issues, i.issue_id as issue_id,i.title as issue, i.publication_date as issue_pub_date from journal j join volume v on j.journal_id = v.journal_id join issue i on v.volume_id = i.volume_id join article a on a.issue_id = i.issue_id join year y on v.year_id = y.id where j.journal_id = 35 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      45.81msalphaeurekaselec_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 = 35 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      9.39msalphaeurekaselec_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 = 35 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      7.1msalphaeurekaselec_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` = 89632 limit 1
      270μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 89632
      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 = 89632 and content_type = 'article' order by status desc limit 1
      350μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 283 and cd.sub_disease_id = 301 and content_id!=89632 and cd.content_type = 'article' order by rand() limit 20
      135msalphaeurekaselec_live_10_06_2022Article.php#769
      Backtrace
      • 11. app/Models/Article.php:769
      • 12. app/Http/Controllers/ArticleController.php:2098
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 161165 limit 1
      240μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 161165
      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
      240μ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` = 'CNF' 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: CNF
      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 = '89632' 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) )
      360μ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 = '9053' 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 = '2582' 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) )
      480μ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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1739971414 and j.to_date >= 1739971414 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2582) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1739971414 and j.to_date >= 1739971414 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2582) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1739971414 and j.to_date >= 1739971414 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2582)
      7.47msalphaeurekaselec_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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1739971414 and j.to_date >= 1739971414 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9053) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1739971414 and j.to_date >= 1739971414 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9053) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1739971414 and j.to_date >= 1739971414 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9053)
      820μ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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1739971414 and j.to_date >= 1739971414 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 89632) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1739971414 and j.to_date >= 1739971414 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 89632) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1739971414 and j.to_date >= 1739971414 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 89632)
      860μ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` < '327' and is_uploaded = 1 and issue_id = 9053 order by cast(first_page as SIGNED) desc limit 1
      570μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 327
      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` > '337' and is_uploaded = 1 and issue_id = 9053 order by cast(first_page as SIGNED) asc limit 1
      440μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 337
      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'
      190μ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` = 89632 limit 1
      2.5msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 89632
      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` = 35 and `b`.`banner_from_date` <= 1739971414 and `b`.`banner_to_date` >= 1739971414 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.19msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 35
      • 3: 1739971414
      • 4: 1739971414
      • 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` = 35 and `b`.`banner_from_date` <= 1739971414 and `b`.`banner_to_date` >= 1739971414 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.18msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 35
      • 3: 1739971414
      • 4: 1739971414
      • 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='8ba92c0c6f92e73469ac55b729fb9f2d'
      270μ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
        pjoprzOWLg7n6yTu9tyfHKDpTolW7sPwfEyfIoQo
        uc_cart_id
        8ba92c0c6f92e73469ac55b729fb9f2d
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/89632" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/89632
        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:23:34 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlVtNHlYc29VRnpaY0g3YUdBUUQ1ZFE9PSIsInZhbHVlIjoiMGlKV1NWS1FnaE05c3NXTjNsZitrUURobWxvdjY4bW5IdVVUdmRTMXBMMCt2RG1JRUNsUjZLVjZXY3VUR2RZc2RRcHB4aE4rY05YVVpGRkhjTGNvaEhuNFlPTFNDUk1FZEVGSy8xMlluUysyV3AxaVlpS3ZuWG5Ocit1QmpOY1IiLCJtYWMiOiJjNDU3ZDAwYWM0ODE1NWFhZjU0ZjEzYjQ3MTExNTA5MjFkMTJlMGZlMWM2NDA3ZjVkMGY0NmJmMGM0MzIxNzkzIiwidGFnIjoiIn0%3D; expires=Sat, 22 Feb 2025 01:23:34 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlVtNHlYc29VRnpaY0g3YUdBUUQ1ZFE9PSIsInZhbHVlIjoiMGlKV1NWS1FnaE05c3NXTjNsZitrUURobWxvdjY4bW5IdVVUdmRTMXBMMCt2RG1JRUNsUjZLVjZXY3VUR2RZc2RRcHB4a" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImpWcDI3SWJGNXNtYjZDemp3WWR5bWc9PSIsInZhbHVlIjoiTXZFOW5Tc0dyZ0d4RFA4RFJ6c3BFb05keTJXeUxYNjgvWllNLzRNTTdHaWtUYmwwWFp0dmxuTnpDQm0wcVNNZVR1NlhoT3RnWUw0bDRqOUJIaDIwZnZ6QzQ0MkNZUy8xSWtOYjlHRDN1QzFkcHZsRWhOejN4aGlwVWM4aW1TNjYiLCJtYWMiOiJkYWMyOWMxODRiZmM4ODIyNGM2MDdiZTlkNzQyYzE4ZDQ2MGNjOGVhYzg1MjhiMjRkMzc2YzQyODcwZWQ3Mjg4IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6ImpWcDI3SWJGNXNtYjZDemp3WWR5bWc9PSIsInZhbHVlIjoiTXZFOW5Tc0dyZ0d4RFA4RFJ6c3BFb05keTJXeUxYNjgvWllNLzRNTTdHaWtUYmwwWFp0dmxuTnp" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlVtNHlYc29VRnpaY0g3YUdBUUQ1ZFE9PSIsInZhbHVlIjoiMGlKV1NWS1FnaE05c3NXTjNsZitrUURobWxvdjY4bW5IdVVUdmRTMXBMMCt2RG1JRUNsUjZLVjZXY3VUR2RZc2RRcHB4aE4rY05YVVpGRkhjTGNvaEhuNFlPTFNDUk1FZEVGSy8xMlluUysyV3AxaVlpS3ZuWG5Ocit1QmpOY1IiLCJtYWMiOiJjNDU3ZDAwYWM0ODE1NWFhZjU0ZjEzYjQ3MTExNTA5MjFkMTJlMGZlMWM2NDA3ZjVkMGY0NmJmMGM0MzIxNzkzIiwidGFnIjoiIn0%3D; expires=Sat, 22-Feb-2025 01:23:34 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlVtNHlYc29VRnpaY0g3YUdBUUQ1ZFE9PSIsInZhbHVlIjoiMGlKV1NWS1FnaE05c3NXTjNsZitrUURobWxvdjY4bW5IdVVUdmRTMXBMMCt2RG1JRUNsUjZLVjZXY3VUR2RZc2RRcHB4a" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImpWcDI3SWJGNXNtYjZDemp3WWR5bWc9PSIsInZhbHVlIjoiTXZFOW5Tc0dyZ0d4RFA4RFJ6c3BFb05keTJXeUxYNjgvWllNLzRNTTdHaWtUYmwwWFp0dmxuTnpDQm0wcVNNZVR1NlhoT3RnWUw0bDRqOUJIaDIwZnZ6QzQ0MkNZUy8xSWtOYjlHRDN1QzFkcHZsRWhOejN4aGlwVWM4aW1TNjYiLCJtYWMiOiJkYWMyOWMxODRiZmM4ODIyNGM2MDdiZTlkNzQyYzE4ZDQ2MGNjOGVhYzg1MjhiMjRkMzc2YzQyODcwZWQ3Mjg4IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6ImpWcDI3SWJGNXNtYjZDemp3WWR5bWc9PSIsInZhbHVlIjoiTXZFOW5Tc0dyZ0d4RFA4RFJ6c3BFb05keTJXeUxYNjgvWllNLzRNTTdHaWtUYmwwWFp0dmxuTnp" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "pjoprzOWLg7n6yTu9tyfHKDpTolW7sPwfEyfIoQo" "uc_cart_id" => "8ba92c0c6f92e73469ac55b729fb9f2d" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/89632" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-19 13:23:34GET/article/89632314371