Generic placeholder image

Current Nutrition & Food Science

Editor-in-Chief

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

Research Article

PDO Rotonda’s Red Eggplant Extract: In vitro Determination of Biological Properties and Minerals Bioaccessibility

Author(s): Ortensia Ilaria Parisi, Mariarosa Ruffo, Fabio Amone, Rocco Malivindi, Domenico Gorgoglione, Filomena De Biasio, Luca Scrivano, Vincenzo Pezzi and Francesco Puoci*

Volume 16, Issue 1, 2020

Page: [65 - 74] Pages: 10

DOI: 10.2174/1573401314666180622110952

Price: $65

Abstract

Background: The Rotonda’s Red Eggplant belongs to the family of Solanum aethiopicum and it is cultivated in a specific area of Potenza (Basilicata, South of Italy) including villages of Rotonda, Viggianello, Castelluccio Superiore and Castelluccio Inferiore. The Red Eggplant cultivated in this area has gained the PDO, “Protected Designation of Origin”.

Objective: The aim of this research was to evaluate the use of PDO Rotonda’s Red Eggplant extract as a possible nutraceutical supplement. The antioxidant, antihypertensive, hypoglycemic, and hypolipidemic properties were in vitro evaluated.

Methods: The antioxidant activity was investigated by evaluating the scavenging properties against 2,2-diphenyl-1-picrylhydrazyl (DPPH) and 2,2-Azinobis-(3-ethylbenzothiazoline-6-sulfonic acid) (ABTS) radicals and by performing the Ammonium Molybdate and Folin-Ciocalteu assay. The hypoglycemic and antihypertensive activity was studied by evaluating the α-Amylase, α-Glucosidase and Angiotensin Converting Enzyme, respectively, inhibiting activity. In order to evaluate the hypolipidemic activity, the pancreatic lipase inhibiting property was determined and Oil Red O staining assay was performed. Finally, to evaluate the possible use of this extract as a minerals supplement, Selenium, Potassium and Chrome bioaccessibility was studied.

Results: The obtained results underline the good antioxidant, hypoglycemic, antihypertensive and hypolipidemic in vitro properties of the PDO Rotonda’s Red Eggplant extract. Moreover, the obtained data show a higher minerals bioaccessibility and this higher value could be ascribable to the natural phytocomplex of PDO Rotonda’s Red Eggplant, which increases the minerals bioaccessibility if compare it with a control sample.

Conclusion: The obtained results show that PDO Rotonda’s Red Eggplant extract, might be used as a possible nutraceutical supplement, along with traditional therapies, both for its biological properties and for its minerals bioaccessibility value.

Keywords: ABTS, ammonium molybdate, DPPH, minerals bioaccessibility, oil Red O, pancreatic lipase, Rotonda’s Red Eggplant extract, Solanum aethiopicum, α-amylase, α-glucosidase.

Graphical Abstract

[1]
Plazas M, Andújar I, Vilanova S, Gramazio P, Herraiz FJ, Prohens J. Conventional and phenomics characterization provides insight into the diversity and relationships of hypervariable scarlet (Solanum aethiopicum L.) and gboma (S. macrocarpon L.) eggplant complexes. Front Plant Sci 2014; 5: 318.
[http://dx.doi.org/10.3389/ fpls.2014.00318] [PMID: 25071801]
[2]
Daunay M, Lester R, Ano G. Cultivated eggplants. In: Charrier A, Jacquot M, Hamon S, Nicolas D, Eds TTropical Plant Breeding. Science Publishers Inc. USA. 2001; pp. 199-222.
[3]
Laghetti G, Hammer K, Brandi M, et al. Ritrovamento in coltura della melanzana africana (Solanum aethipicum L) nel comune di Rotonda (PZ). Informatore agrario LI 1995; 39: 52-8.
[4]
Sunseri F, Polignano G, Alba V, et al. Genetic diversity and characterization of African eggplant germplasm collection. Afr J Plant Sci 2010; 4(7): 231-41.
[5]
Polignano G, Laghetti G, Margiotta B, et al. Agricultural sustainability and underutilized crop species in southern Italy. Plant Genet Resour 2004; 2(1): 29-35.
[http://dx.doi.org/10.1079/PGR200432]
[6]
Plazas M, Prohens J, Cuñat AN, et al. Reducing capacity, chlorogenic acid content and biological activity in a collection of scarlet (Solanum aethiopicum) and Gboma (S. macrocarpon) eggplants. Int J Mol Sci 2014; 15(10): 17221-41.
[http://dx.doi.org/10.3390/ijms151017221] [PMID: 25264739]
[7]
Nwanna EE, Ibukun EO, Oboh G, Ademosun AO, Boligon AA, Athayde M. HPLC-DAD analysis and in-vitro property of polyphenols extracts from (Solanum aethiopium) fruits on α -amylase, α -glucosidase and angiotensin - 1- converting enzyme activities. Int J Biomed Sci 2014; 10(4): 272-81.
[PMID: 25598760]
[8]
Rawat S, Jugran A, Giri L, et al. Assessment of antioxidant properties in fruits of Myrica esculenta: a popular wild edible species in Indian Himalayan region. Evid Based Complementary Altern Med 2011. available at . https://www.hindawi.com/journals/ecam/2011/ 512787/
[9]
Odetola AA, Iranloye YO, Akinloye O. Hypolipidaemic potentials of Solanum melongena and Solanum gilo on hypercholesterolemic rabbits. Pak J Nutr 2004; 3(3): 180-7.
[http://dx.doi.org/10.3923/pjn.2004.180.187]
[10]
Anosike CA, Obidoa O, Ezeanyika LU. The anti-inflammatory activity of garden egg (Solanum aethiopicum) on egg albumin-induced oedema and granuloma tissue formation in rats. Asian Pac J Trop Med 2012; 5(1): 62-6.
[http://dx.doi.org/10.1016/S1995-7645(11)60247-2] [PMID: 22182646]
[11]
Nikolic NC, Stankovic MZ. Solanidine hydrolytic extraction and separation from the potato (Solanum tuberosum L.) vines by using solid-liquid-liquid systems. J Agric Food Chem 2003; 51(7): 1845-9.
[http://dx.doi.org/10.1021/jf020426s] [PMID: 12643640]
[12]
Parisi OI, Aiello D, Casula MF, et al. Mesoporous nanocrystalline TiO2 loaded with ferulic acid for sunscreen and photo-protection: safety and efficacy assessment. RSC Advances 2016; 6(87): 83767-75.
[http://dx.doi.org/10.1039/C6RA07653J]
[13]
Spizzirri U, Altimari I, Puoci F, et al. Innovative antioxidant thermo-responsive hydrogels by radical grafting of catechin on inulin chain. Carbohydr Polym 2011; 84(1): 517-23.
[http://dx.doi.org/10.1016/j.carbpol.2010.12.015]
[14]
Prieto P, Pineda M, Aguilar M. Spectrophotometric quantitation of antioxidant capacity through the formation of a phosphomolybdenum complex: specific application to the determination of vitamin E. Anal Biochem 1999; 269(2): 337-41.
[http://dx.doi.org/10.1006/abio.1999.4019] [PMID: 10222007]
[15]
Parisi OI, Malivindi R, Amone F, et al. Safety and efficacy of dextran-rosma-rinic acid conjugates as innovative polymeric antioxidants in skin whitening: What is the evidence? Cosmetics 2017; 4(3): 28.
[http://dx.doi.org/10.3390/cosmetics4030028]
[16]
Kim M, Kim E, Kwak HS, Jeong Y. The ingredients in Saengshik, a formulated health food, inhibited the activity of α-amylase and α-glucosidase as anti-diabetic function. Nutr Res Pract 2014; 8(5): 602-6.
[http://dx.doi.org/10.4162/nrp.2014.8.5.602] [PMID: 25324943]
[17]
Chaudhary SK, De A, Bhadra S, Mukherjee PK. Angiotensin-converting enzyme (ACE) inhibitory potential of standardized Mucuna pruriens seed extract. Pharm Biol 2015; 53(11): 1614-20.
[http://dx.doi.org/10.3109/13880209.2014.996820] [PMID: 25868619]
[18]
Lim SM, Goh YM, Kuan WB, Loh SP. Effect of germinated brown rice extracts on pancreatic lipase, adipogenesis and lipolysis in 3T3-L1 adipocytes. Lipids Health Dis 2014; 13(1): 169.
[http://dx.doi.org/10.1186/1476-511X-13-169] [PMID: 25367070]
[19]
Zebisch K, Voigt V, Wabitsch M, Brandsch M. Protocol for effective differentiation of 3T3-L1 cells to adipocytes. Anal Biochem 2012; 425(1): 88-90.
[http://dx.doi.org/10.1016/j.ab.2012.03.005] [PMID: 22425542]
[20]
Mosmann T. Rapid colorimetric assay for cellular growth and survival: application to proliferation and cytotoxicity assays. J Immunol Methods 1983; 65(1-2): 55-63.
[http://dx.doi.org/10.1016/0022-1759(83)90303-4] [PMID: 6606682]
[21]
Kim SP, Nam SH, Friedman M. Mechanism of the antiadipogenic-antiobesity effects of a rice hull smoke extract in 3T3-L1 preadipocyte cells and in mice on a high-fat diet. Food Funct 2015; 6(9): 2939-48.
[http://dx.doi.org/10.1039/C5FO00469A] [PMID: 26190448]
[22]
Matute RG, Serra A, Figlas D, Curvetto N. Copper and zinc bioaccumulation and bioavailability of Ganoderma lucidum. J Med Food 2011; 14(10): 1273-9.
[http://dx.doi.org/10.1089/jmf.2010.0206] [PMID: 21554122]
[23]
Soobrattee MA, Neergheen VS, Luximon-Ramma A, Aruoma OI, Bahorun T. Phenolics as potential antioxidant therapeutic agents: mechanism and actions. Mutat Res 2005; 579(1-2): 200-13.
[http://dx.doi.org/10.1016/j.mrfmmm.2005.03.023] [PMID: 16126236]
[24]
Mennella G, Rotino GL, Fibiani M, et al. Characterization of health-related compounds in eggplant (Solanum melongena L.) lines derived from introgression of allied species. J Agric Food Chem 2010; 58(13): 7597-603.
[http://dx.doi.org/10.1021/jf101004z] [PMID: 20527988]
[25]
Sakthiswary R, Zakaria Z, Das S. Diabetes mellitus: treatment challenges and the role of some herbal therapies. Middle East J Sci Res 2014; 20(7): 786-98.
[26]
Béjaoui A, Boulila A, Salem IB, Boussaid M. Chemical composition and bioactivities of the polyphenolic-rich extract of Ormenis africana Jord. and Fourr. Int J Food Prop 2017; 20(8): 1786-95.
[http://dx.doi.org/10.1080/10942912.2016.1219368]
[27]
Martínez-Maqueda D, Miralles B, Recio I, Hernández-Ledesma B. Antihypertensive peptides from food proteins: a review. Food Funct 2012; 3(4): 350-61.
[http://dx.doi.org/10.1039/c2fo10192k] [PMID: 22249830]
[28]
Uraipong C, Zhao J. Rice bran protein hydrolysates exhibit strong in vitro α-amylase, β-glucosidase and ACE-inhibition activities. J Sci Food Agric 2016; 96(4): 1101-10.
[http://dx.doi.org/10.1002/jsfa.7182] [PMID: 25801199]
[29]
de la Garza AL, Milagro FI, Boque N, Campión J, Martínez JA. Natural inhibitors of pancreatic lipase as new players in obesity treatment. Planta Med 2011; 77(8): 773-85.
[http://dx.doi.org/10.1055/s-0030-1270924] [PMID: 21412692]
[30]
Fabroni S, Ballistreri G, Amenta M, Romeo FV, Rapisarda P. Screening of the anthocyanin profile and in vitro pancreatic lipase inhibition by anthocyanin-containing extracts of fruits, vegetables, legumes and cereals. J Sci Food Agric 2016; 96(14): 4713-23.
[http://dx.doi.org/10.1002/jsfa.7708] [PMID: 26970531]
[31]
Sudheesh S, Presannakumar G, Vijayakumar S, Vijayalakshmi NR. Hypolipidemic effect of flavonoids from Solanum melongena. Plant Foods Hum Nutr 1997; 51(4): 321-30.
[http://dx.doi.org/10.1023/A:1007965927434] [PMID: 9650725]
[32]
Omrani H, Golmohamadi S, Pasdar Y, Jasemi K, Almasi A. Effect of selenium supplementation on lipid profile in hemodialysis patients. J Renal Inj Prev 2016; 5(4): 179-82.
[http://dx.doi.org/10.15171/jrip.2016.38] [PMID: 27689119]
[33]
Duntas LH. Selenium and inflammation: underlying anti-inflammatory mechanisms. Horm Metab Res 2009; 41(6): 443-7.
[http://dx.doi.org/10.1055/s-0029-1220724] [PMID: 19418416]
[34]
Panchal SK, Wanyonyi S, Brown L. Selenium, vanadium, and chromium as micronutrients to improve metabolic syndrome. Curr Hypertens Rep 2017; 19(3): 10.
[http://dx.doi.org/10.1007/s11906-017-0701-x] [PMID: 28197835]
[35]
Consensus Study Report. Vitamin C, Vitamin E, Selenium and Carotenoids. National Academy Press: Washington, DC . 2000.
[36]
Fairweather-Tait SJ, Bao Y, Broadley MR, et al. Selenium in human health and disease. Antioxid Redox Signal 2011; 14(7): 1337-83.
[http://dx.doi.org/10.1089/ars.2010.3275]
[37]
Drutel A, Archambeaud F, Caron P. Selenium and the thyroid gland: more good news for clinicians. Clin Endocrinol (Oxf) 2013; 78(2): 155-64.
[http://dx.doi.org/10.1111/cen.12066] [PMID: 23046013]
[38]
Lewicki S, Zdanowski R, Krzyżowska M, et al. The role of Chromium III in the organism and its possible use in diabetes and obesity treatment. Ann Agric Environ Med 2014; 21(2): 331-5.
[http://dx.doi.org/10.5604/1232-1966.1108599] [PMID: 24959784]
[39]
Institute of Medicine (US) Panel on Micronutrients. Dietary reference intakes for vitamin A, vitamin K, arsenic, boron, chromium,copper, iodine, iron, manganese, molybdenum, nickel, silicon, vanadium, and zinc. National Academies Press (US): Washington,DC. 2001.
[40]
Chen Y, Watson HM, Gao J, Sinha SH, Cassady CJ, Vincent JB. Characterization of the organic component of low-molecular-weight chromium-binding substance and its binding of chromium. J Nutr 2011; 141(7): 1225-32.
[http://dx.doi.org/10.3945/jn.111.139147] [PMID: 21593351]
[41]
Iskra R, Ianovych V. Biochemical mechanisms of chromium action in the human and animal organism. Ukr Biokhim Zh 2011; 83(5): 5-12.
[42]
Chen G, Liu P, Pattar GR, et al. Chromium activates glucose transporter 4 trafficking and enhances insulin-stimulated glucose transport in 3T3-L1 adipocytes via a cholesterol-dependent mechanism. Mol Endocrinol 2006; 20(4): 857-70.
[http://dx.doi.org/10.1210/me.2005-0255] [PMID: 16339278]
[43]
Komorowski JR, Tuzcu M, Sahin N, et al. Chromium picolinate modulates serotonergic properties and carbohydrate metabolism in a rat model of diabetes. Biol Trace Elem Res 2012; 149(1): 50-6.
[http://dx.doi.org/10.1007/s12011-012-9393-x] [PMID: 22434381]
[44]
He FJ, MacGregor GA. Beneficial effects of potassium on human health. Physiol Plant 2008; 133(4): 725-35.
[http://dx.doi.org/10.1111/j.1399-3054.2007.01033.x] [PMID: 18724413]
[45]
Zhu K, Devine A, Prince RL. The effects of high potassium consumption on bone mineral density in a prospective cohort study of elderly postmenopausal women. Osteoporos Int 2009; 20(2): 335-40.
[http://dx.doi.org/10.1007/s00198-008-0666-3] [PMID: 18575949]
[46]
Cogswell ME, Zhang Z, Carriquiry AL, et al. Sodium and potassium intakes among US adults: NHANES 2003-2008. Am J Clin Nutr 2012; 96(3): 647-57.
[http://dx.doi.org/10.3945/ajcn.112.034413] [PMID: 22854410]
[47]
Pedrero Z, Madrid Y, Cámara C. Selenium species bioaccessibility in enriched radish (Raphanus sativus): a potential dietary source of selenium. J Agric Food Chem 2006; 54(6): 2412-7.
[http://dx.doi.org/10.1021/jf052500n] [PMID: 16536627]
[48]
Ruzik L, Wojcieszek J. In vitro digestion method for estimation of copper bioaccessibility in Açaí berry. Monatsh Chem 2016; 147: 1429-38.
[http://dx.doi.org/10.1007/s00706-016-1798-3] [PMID: 27546910]
[49]
Frossard E, Bucher M, Mächler M, Mozafar A, et al. Potential for increasing the content and bioavailability of Fe, Zn and Ca in plants for human nutrition. J Sci Food Agric 2000; 80(7): 861-79.
[http://dx.doi.org/10.1002/(SICI)1097-0010(20000515)80:7<861:AID-JSFA601>3.0.CO;2-P]
[50]
Boivin D, Lamy S, Lord Dufour S, et al. Antiproliferative and antioxidant activities of common vegetables: A comparative study. Food Chem 2009; 112(2): 374-80.
[http://dx.doi.org/10.1016/j.foodchem.2008.05.084]
[51]
da Costa JP. A current look at Nutraceuticals–key concepts and future prospects. Trends Food Sci Technol 2017; 62: 68-78.
[http://dx.doi.org/10.1016/j.tifs.2017.02.010]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version379msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[08:12:21] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[08:12:21] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[08:12:21] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (144ms)time
  • Application (234ms)time
  • 1 x Application (61.85%)
    234ms
    1 x Booting (38.14%)
    144ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    36 statements were executed, 4 of which were duplicates, 32 unique. Show only duplicated142ms
    • 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 ('316204442','',1,1740471141,1740471141) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740471141
      1.1msalphaeurekaselec_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 ('316204442','/article/91215',1,1740471141,1740471141)
      180μ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 >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) 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 >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) 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 >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) 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 >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) 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 >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) 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 >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316204442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316204442) limit 1
      13.76msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316204442
      • 1: 316204442
      • 2: 316204442
      • 3: 316204442
      • 4: 316204442
      • 5: 316204442
      • 6: 316204442
      • 7: 316204442
      • 8: 316204442
      • 9: 316204442
      • 10: 316204442
      • 11: 316204442
      • 12: 316204442
      • 13: 316204442
      • 14: 316204442
      • 15: 316204442
      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=91215
      730μ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
      890μ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`
      570μ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
      470μ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`
      800μ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
      770μ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` = '91215'
      1.76msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 91215
      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` = '91215'
      2.19msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 91215
      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` = '91215' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.35msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 91215
      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
      270μ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
      480μ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
      50.22msalphaeurekaselec_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.45msalphaeurekaselec_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
      21.38msalphaeurekaselec_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` = 91215 limit 1
      1.4msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 91215
      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 = 91215 and content_type = 'article' order by status desc limit 1
      380μ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` = 163174 limit 1
      240μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 163174
      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
      280μ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
      390μ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 = '91215' 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) )
      540μ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 = '9533' 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) )
      460μ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 = '2736' 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) )
      430μ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 <= 316204442 and j.to_ip >=316204442 )) and ((j.from_date <= 1740471141 and j.to_date >= 1740471141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2736) 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 <= 316204442 and j.to_ip >=316204442 )) and ((j.from_date <= 1740471141 and j.to_date >= 1740471141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2736) 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 <= 316204442 and j.to_ip >=316204442 )) and ((j.from_date <= 1740471141 and j.to_date >= 1740471141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2736)
      19.31msalphaeurekaselec_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 <= 316204442 and j.to_ip >=316204442 )) and ((j.from_date <= 1740471141 and j.to_date >= 1740471141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9533) 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 <= 316204442 and j.to_ip >=316204442 )) and ((j.from_date <= 1740471141 and j.to_date >= 1740471141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9533) 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 <= 316204442 and j.to_ip >=316204442 )) and ((j.from_date <= 1740471141 and j.to_date >= 1740471141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9533)
      1.08msalphaeurekaselec_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 <= 316204442 and j.to_ip >=316204442 )) and ((j.from_date <= 1740471141 and j.to_date >= 1740471141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 91215) 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 <= 316204442 and j.to_ip >=316204442 )) and ((j.from_date <= 1740471141 and j.to_date >= 1740471141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 91215) 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 <= 316204442 and j.to_ip >=316204442 )) and ((j.from_date <= 1740471141 and j.to_date >= 1740471141 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 91215)
      940μ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` < '65' and is_uploaded = 1 and issue_id = 9533 order by cast(first_page as SIGNED) desc limit 1
      770μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 65
      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` > '74' and is_uploaded = 1 and issue_id = 9533 order by cast(first_page as SIGNED) asc limit 1
      640μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 74
      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'
      340μ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
      310μ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` = 91215 limit 1
      4.29msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 91215
      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` <= 1740471141 and `b`.`banner_to_date` >= 1740471141 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.75msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 35
      • 3: 1740471141
      • 4: 1740471141
      • 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` <= 1740471141 and `b`.`banner_to_date` >= 1740471141 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.62msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 35
      • 3: 1740471141
      • 4: 1740471141
      • 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='c5f294ecaad8c7d4264a9fdc1d3e535f'
      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
        ZekzyYR9U7hyzxc3CdL6PVvfh92Qh1VAVhOYDu4W
        uc_cart_id
        c5f294ecaad8c7d4264a9fdc1d3e535f
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/91215" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/91215
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:9 [ "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6IktjNUsySzRyYWZuZDlJa3dVQ3JLcFE9PSIsInZhbHVlIjoiM2tEamlrZXlhWFAxelJFMm96cmpSUTBIdU1SeC9aY1hJWkRtS1VBb3VTOD0iLCJtYWMiOiIxZDhhZTRjMGRiN2VjYmEzNjUwNWNhZWYwZDk2YmEzN2NkYjdkNGI1MzE0NGU0YTQ5NmU1NGVkMmM3ODgwNjFjIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IktjNUsySzRyYWZuZDlJa3dVQ3JLcFE9PSIsInZhbHVlIjoiM2tEamlrZXlhWFAxelJFMm96cmpSUTBIdU1SeC9aY1hJWkRtS1VBb3VTOD0iLCJtYWMiOiIxZDhhZTRjMGRiN2Vj" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 25 Feb 2025 08:12:21 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImVPaGN5RldaOU1aOUlDZ3REK2F4S3c9PSIsInZhbHVlIjoiaEtTbzEwUGdDQXptdEVwNkFBdE9EK0YvRVIvcFdMd1A5aFAwSXJ6WjdlU3kyVndnZFUxQzYydXFRUDR6b0lxQ0swbUZ2NVZWUm52K0hBRmIzeEZtd3g2ZVlYSVdaNDZ2MHBMdDhDWjFsWEtMUUtBR3p1YitZTHhKdkgxcDRtRXMiLCJtYWMiOiIxNTEwMDBmNjgyY2YwZDcwMzdmOTZmZmEwZmVmZjViYzY3YjJkZDQwMmQ2NjgzMWIxNTA3MzYyYjk5MjlhMTdkIiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 20:12:21 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImVPaGN5RldaOU1aOUlDZ3REK2F4S3c9PSIsInZhbHVlIjoiaEtTbzEwUGdDQXptdEVwNkFBdE9EK0YvRVIvcFdMd1A5aFAwSXJ6WjdlU3kyVndnZFUxQzYydXFRUDR6b0lxQ0swbUZ2N" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkVicTZvKzNrVit2NS9jb2wvaHYyYlE9PSIsInZhbHVlIjoieHJ5VFFqMnEwVTArR1dCMUIvbkFhSkpOZGlFV3RGMlcva1JsN3QzMUtNRHpyT2pjQTJ2VUJXbENmMC9qS0R2bUpHbkFPNHVYM0ZCZDNERWJNRXhWWWsycVZwVXQxUUtxMEhFbzB3eU0rekhaVlR6TFZ3YXZaMVoxUmdHbllFUXMiLCJtYWMiOiI0ZTNkNThmODhlOWFmMzNlODNjNWVhNTg0YmIyNTFkZmFmNjMxZjMzNDY4NzliMzhmNmY4ZDg4Y2RjYjY2NTcxIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkVicTZvKzNrVit2NS9jb2wvaHYyYlE9PSIsInZhbHVlIjoieHJ5VFFqMnEwVTArR1dCMUIvbkFhSkpOZGlFV3RGMlcva1JsN3QzMUtNRHpyT2pjQTJ2VUJXbEN" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImVPaGN5RldaOU1aOUlDZ3REK2F4S3c9PSIsInZhbHVlIjoiaEtTbzEwUGdDQXptdEVwNkFBdE9EK0YvRVIvcFdMd1A5aFAwSXJ6WjdlU3kyVndnZFUxQzYydXFRUDR6b0lxQ0swbUZ2NVZWUm52K0hBRmIzeEZtd3g2ZVlYSVdaNDZ2MHBMdDhDWjFsWEtMUUtBR3p1YitZTHhKdkgxcDRtRXMiLCJtYWMiOiIxNTEwMDBmNjgyY2YwZDcwMzdmOTZmZmEwZmVmZjViYzY3YjJkZDQwMmQ2NjgzMWIxNTA3MzYyYjk5MjlhMTdkIiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 20:12:21 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImVPaGN5RldaOU1aOUlDZ3REK2F4S3c9PSIsInZhbHVlIjoiaEtTbzEwUGdDQXptdEVwNkFBdE9EK0YvRVIvcFdMd1A5aFAwSXJ6WjdlU3kyVndnZFUxQzYydXFRUDR6b0lxQ0swbUZ2N" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkVicTZvKzNrVit2NS9jb2wvaHYyYlE9PSIsInZhbHVlIjoieHJ5VFFqMnEwVTArR1dCMUIvbkFhSkpOZGlFV3RGMlcva1JsN3QzMUtNRHpyT2pjQTJ2VUJXbENmMC9qS0R2bUpHbkFPNHVYM0ZCZDNERWJNRXhWWWsycVZwVXQxUUtxMEhFbzB3eU0rekhaVlR6TFZ3YXZaMVoxUmdHbllFUXMiLCJtYWMiOiI0ZTNkNThmODhlOWFmMzNlODNjNWVhNTg0YmIyNTFkZmFmNjMxZjMzNDY4NzliMzhmNmY4ZDg4Y2RjYjY2NTcxIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkVicTZvKzNrVit2NS9jb2wvaHYyYlE9PSIsInZhbHVlIjoieHJ5VFFqMnEwVTArR1dCMUIvbkFhSkpOZGlFV3RGMlcva1JsN3QzMUtNRHpyT2pjQTJ2VUJXbEN" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "ZekzyYR9U7hyzxc3CdL6PVvfh92Qh1VAVhOYDu4W" "uc_cart_id" => "c5f294ecaad8c7d4264a9fdc1d3e535f" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/91215" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 08:12:21GET/article/91215314361