Generic placeholder image

Current Nutrition & Food Science

Editor-in-Chief

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

Research Article

Sensory Characteristic, Nutritional Content, and Glycemic Analysis of Instant Porridge Made of Red Rice, Pumpkin, and Tuna Formulated for the Elderly

Author(s): Toto Sudargo*, Adisti Qamahadlina Larasati, Bianda Aulia, Atika Anif Prameswari, Tira Aristasari and Sheila Rosmala Putri

Volume 19, Issue 3, 2023

Published on: 03 September, 2022

Page: [300 - 306] Pages: 7

DOI: 10.2174/1573401318666220804140804

Price: $65

Abstract

Background: The elderly experience decreased muscle mass and strength, which is often coupled with a reduced dietary intake that may affect physical fitness and quality of life.

Objectives: This study aimed to develop Bensuka, an instant porridge product made from red rice, pumpkin, and tuna, formulated for the elderly.

Methods: To find the right formulation with a low glycemic index (GI) and favorable sensory characteristics, the ingredients were mixed with different ratios, F1 (40% rice, 25% pumpkin, 20% tuna), F2 (35% rice, 25% pumpkin, 25% tuna), and F3 (35% rice, 20% pumpkin, 30% tuna). The sensory characteristics, such as appearance (color), aroma, flavor, texture) were assessed by 64 semi-trained panelists using a 7-point Likert scale, with 1= strongly dislike and 7 = strongly like. One-way ANOVA was performed to analyze the different characteristics between formulations. The nutritional content was assessed using standardized laboratory analysis according to AOAC guidelines.

Results: The formula with a higher ratio of tuna had a higher protein content, while the formula with a higher proportion of red rice had higher calorie and ash content (mineral content). There were no significant differences in sensory characteristics between the three formulations, but F2 had the highest Likert score for flavor and texture. F2 also had the lowest glycemic index and load.

Conclusion: Bensuka instant porridge has favorable sensory and nutrient properties. F2 formulation had the lowest GI and GL. In terms of sensory properties, F2 texture, flavor, and aroma were the most favorable. Therefore, F2 will be used for further elderly functional food studies.

Keywords: Red rice, pumpkin, tuna, elderly, GI, sensory properties

[1]
Rusu A, Randriambelonoro M, Perrin C, Valk C, Álvarez B, Schwarze A-K. Aspects influencing food intake and approaches towards personalising nutrition in the elderly. J Popul Ageing 2020; 13(2): 239-56.
[http://dx.doi.org/10.1007/s12062-019-09259-1]
[2]
Martins IJ. Single gene inactivation with implications to diabetes and multiple organ dysfunction syndrome. J Clin Epigenetics 2017; 03(3): 1-8.
[http://dx.doi.org/10.21767/2472-1158.100058]
[3]
Westphal CH, Dipp MA, Guarente L. A therapeutic role for sirtuins in diseases of aging? Trends Biochem Sci 2007; 32(12): 555-60.
[http://dx.doi.org/10.1016/j.tibs.2007.09.008] [PMID: 17980602]
[4]
Corcoran C, Murphy C, Culligan EP, Walton J, Sleator RD. Malnutrition in the elderly. Sci Prog 2019; 102(2): 171-80.
[http://dx.doi.org/10.1177/0036850419854290] [PMID: 31829839]
[5]
Nasution SZ, Amal MRH, Ariga RA, Siregar CT, Purba WD. Nutritional status of elderly in Urban and Rural North Sumatera, Indonesia. Int J Adv Sci Eng Inf Technol 2020; 10(4): 1639-45.
[http://dx.doi.org/10.18517/ijaseit.10.4.6663]
[6]
Li H, Yao X, Ying Z, et al. Rheological and tribological characteristics of mung bean-rice porridge and its impact on sensory evaluation. Int J Food Prop 2020; 23(1): 1490-505.
[http://dx.doi.org/10.1080/10942912.2020.1810065]
[7]
Rahman ANF, Al-Wahab RR, Suwandi N. Effect of cooking and freezing time on physical properties of instant germinated red rice. IOP Conf Ser Earth Environ Sci 2021; 807(2): 022055.
[http://dx.doi.org/10.1088/1755-1315/807/2/022055]
[8]
Rathna Priya TS, Eliazer Nelson ARL, Ravichandran K, Antony U. Nutritional and functional properties of coloured rice varieties of South India: A review. J Ethn Foods 2019; 6(1): 1-11.
[http://dx.doi.org/10.1186/s42779-019-0017-3]
[9]
Hosoda K, Sasahara H, Matsushita K, Tamura Y. Anthocyanin and proanthocyanidin contents, antioxidant activity, and in situ degradability of black and red rice grains. Asian-Australasian J Animal Sci 2018; 31(8): 1213-20.
[http://dx.doi.org/10.5713/ajas.17.0655]
[10]
Moraru DI, Ploscutanu G, Stoica M. Health benefits of edible round-fruited types of Cucurbita pepo-a short review. J Agroaliment Process Technol 2018; 24(3): 202-6.
[11]
Kaur S, Panghal A, Garg MK, et al. Functional and nutraceutical properties of pumpkin–A review. Nutr Food Sci 2019; 50(2): 384-401.
[http://dx.doi.org/10.1108/NFS-05-2019-0143]
[12]
Men X, Choi SI, Han X, et al. Physicochemical, nutritional and functional properties of Cucurbita moschata. Food Sci Biotechnol 2020; 30(2): 171-83.
[http://dx.doi.org/10.1007/s10068-020-00835-2] [PMID: 33732508]
[13]
Kim YM, Kim EY, Kim IH, Nam TJ. Peptide derived from desalinated boiled tuna extract inhibits adipogenesis through the downregulation of C/EBP-α and PPAR-γ in 3T3-L1 adipocytes. Int J Mol Med 2015; 35(5): 1362-8.
[http://dx.doi.org/10.3892/ijmm.2015.2127] [PMID: 25761066]
[14]
Maqbool A, Strandvik B, Stallings VA. The skinny on tuna fat: Health implications. Public Health Nutr 2011; 14(11): 2049-54.
[http://dx.doi.org/10.1017/S1368980010003757] [PMID: 21324226]
[15]
Ni Lochlainn M, Bowyer RCE, Steves CJ. Dietary protein and muscle in aging people: The potential role of the gut microbiome. Nutrients 2018; 10(7): 1-19.
[http://dx.doi.org/10.3390/nu10070929] [PMID: 30036990]
[16]
Ooi DJ, Iqbal S, Ismail M. Proximate composition, nutritional attributes and mineral composition of Peperomia pellucida L. (Ketumpangan Air) grown in Malaysia. Molecules 2012; 17(9): 11139-45.
[http://dx.doi.org/10.3390/molecules170911139] [PMID: 22986924]
[17]
Chen YJ, Sun FH, Wong SH, Huang YJ. Glycemic index and glycemic load of selected Chinese traditional foods. World J Gastroenterol 2010; 16(12): 1512-7.
[http://dx.doi.org/10.3748/wjg.v16.i12.1512] [PMID: 20333793]
[18]
Lin MHA, Wu MC, Lu S, Lin J. Glycemic index, glycemic load and insulinemic index of Chinese starchy foods. World J Gastroenterol 2010; 16(39): 4973-9.
[http://dx.doi.org/10.3748/wjg.v16.i39.4973] [PMID: 20954285]
[19]
Fleurence J. Seaweed proteins: Biochemical nutritional aspects and potential uses. Trends Food Sci Technol 1999; 10(1): 25-8.
[http://dx.doi.org/10.1016/S0924-2244(99)00015-1]
[20]
Irtanto H, Akbarsyah T. Pengalengan ikan tuna komersial. Squalem 2007; 2: 43-50.
[21]
Indriyani F, Nurhidajah N, Suyanto A. Karakteristik fisik, kimia dan sifat organoleptik tepung beras merah berdasarkan variasi lama pengeringan. J Pangan Dan Gizi 2013; 4: 116231.
[http://dx.doi.org/10.26714/jpg.4.2.2013]
[22]
Praveen S, Kumar RR, Upadhyay S. Biochemistry of food crops from omics studies to nutrient analysis 2018.
[23]
Chaudhari P, Tamrakar N, Singh L, Tandon A, Sharma D. Rice nutritional and medicinal properties: A review article. J Pharmacogn Phytochem 2018; 7: 150-6.
[24]
Son DH, Park WJ, Lee YJ. Recent advances in anti-aging medicine. Korean J Fam Med 2019; 40(5): 289-96.
[http://dx.doi.org/10.4082/kjfm.19.0087] [PMID: 31558007]
[25]
Osman NMH, Mohd-Yusof BN, Ismail A. Estimating glycemic index of rice-based mixed meals by using predicted and adjusted formulae. Rice Sci 2017; 24(5): 274-82.
[http://dx.doi.org/10.1016/j.rsci.2017.06.001]
[26]
Rohitha PBD. Glycemic index of four traditional red pigmented rice. Integr Food Nutr Metab 2018; 5(5): 1-3.
[http://dx.doi.org/10.15761/IFNM.1000230]
[27]
Kumar A, Sahoo U, Baisakha B, et al. Resistant starch could be decisive in determining the glycemic index of rice cultivars. J Cereal Sci 2018; 79: 348-53.
[http://dx.doi.org/10.1016/j.jcs.2017.11.013]
[28]
Fatema K, Rahman F, Sumi N, Kobura K, Ali L. Glycemic and insulinemic responses to commonly consumed potatoes in Bangladeshi type 2 diabetic subjects. Res J Biol Sci 2010; 5(4): 345-9.
[http://dx.doi.org/10.3923/rjbsci.2010.345.349]
[29]
Vega-López S, Venn BJ, Slavin JL. Relevance of the glycemic index and glycemic load for body weight, diabetes, and cardiovascular disease. Nutrients 2018; 10(10): 1-27.
[http://dx.doi.org/10.3390/nu10101361] [PMID: 30249012]
[30]
Meng H, Matthan NR, Ausman LM, Lichtenstein AH. Effect of prior meal macronutrient composition on postprandial glycemic responses and glycemic index and glycemic load value determinations. Am J Clin Nutr 2017; 106(5): 1246-56.
[http://dx.doi.org/10.3945/ajcn.117.162727] [PMID: 28903959]
[31]
Anggraeni VJ, Ramdanawati L, Ayuantika W. Optimization of total anthocyanin extraction from brown rice (Oryza nivara). J Phys Conf Ser 2019; 1338(1): 012006.
[http://dx.doi.org/10.1088/1742-6596/1338/1/012006]
[32]
Muhidin , Syam’Un E, Kaimuddin , et al. The effect of shade on chlorophyll and anthocyanin content of upland red rice. IOP Conf Ser Earth Environ Sci 2018; 122
[http://dx.doi.org/10.1088/1755-1315/122/1/012030]
[33]
Baharuddin F, Hatta W, Said MI. The effects of wheat, tapioca, corn, and red rice flour on TBA value and color sensory quality and the aroma of dangke nuggets. IOP Conf Ser Earth Environ Sci 2021; 788(1): 012114.
[http://dx.doi.org/10.1088/1755-1315/788/1/012114]
[34]
Tangke U, Daeng RA, Katiandagho B. Organoleptic quality of tuna porridge canned with fortified tuna bone meal. IOP Conf Ser Earth Environ Sci 2021; 750(1): 12047.
[http://dx.doi.org/10.1088/1755-1315/750/1/012047]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version565msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[00:30:17] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[00:30:17] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[00:30:17] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[00:30:17] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[00:30:17] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (182ms)time
  • Application (383ms)time
  • 1 x Application (67.77%)
    383ms
    1 x Booting (32.22%)
    182ms
    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 duplicated272ms
    • 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 ('316686355','',1,1740702617,1740702617) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740702617
      6.77msalphaeurekaselec_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 ('316686355','/article/125339',1,1740702617,1740702617)
      1.25msalphaeurekaselec_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 >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) 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 >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) 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 >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) 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 >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) 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 >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) 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 >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) limit 1
      38.25msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316686355
      • 1: 316686355
      • 2: 316686355
      • 3: 316686355
      • 4: 316686355
      • 5: 316686355
      • 6: 316686355
      • 7: 316686355
      • 8: 316686355
      • 9: 316686355
      • 10: 316686355
      • 11: 316686355
      • 12: 316686355
      • 13: 316686355
      • 14: 316686355
      • 15: 316686355
      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=125339
      1.19msalphaeurekaselec_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
      1.17msalphaeurekaselec_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`
      860μ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
      750μ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`
      1.22msalphaeurekaselec_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
      1.11msalphaeurekaselec_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` = '125339'
      990μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 125339
      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` = '125339'
      2.92msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 125339
      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` = '125339' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      4.28msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 125339
      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
      380μ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
      720μ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
      37.4msalphaeurekaselec_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
      20.62msalphaeurekaselec_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
      10.75msalphaeurekaselec_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` = 125339 limit 1
      320μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 125339
      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 = 125339 and content_type = 'article' order by status desc limit 1
      330μ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` = 207282 limit 1
      290μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 207282
      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
      320μ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
      420μ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 = '125339' 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) )
      10.35msalphaeurekaselec_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 = '12238' 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) )
      490μ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 = '3362' 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) )
      5.88msalphaeurekaselec_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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1740702617 and j.to_date >= 1740702617 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3362) 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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1740702617 and j.to_date >= 1740702617 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3362) 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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1740702617 and j.to_date >= 1740702617 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3362)
      99.75msalphaeurekaselec_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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1740702617 and j.to_date >= 1740702617 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12238) 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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1740702617 and j.to_date >= 1740702617 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12238) 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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1740702617 and j.to_date >= 1740702617 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12238)
      12.49msalphaeurekaselec_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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1740702617 and j.to_date >= 1740702617 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 125339) 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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1740702617 and j.to_date >= 1740702617 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 125339) 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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1740702617 and j.to_date >= 1740702617 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 125339)
      980μ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` < '300' and is_uploaded = 1 and issue_id = 12238 order by cast(first_page as SIGNED) desc limit 1
      760μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 300
      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` > '306' and is_uploaded = 1 and issue_id = 12238 order by cast(first_page as SIGNED) asc limit 1
      660μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 306
      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'
      270μ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` = 125339 limit 1
      3.79msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 125339
      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` <= 1740702617 and `b`.`banner_to_date` >= 1740702617 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.76msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 35
      • 3: 1740702617
      • 4: 1740702617
      • 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` <= 1740702617 and `b`.`banner_to_date` >= 1740702617 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.57msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 35
      • 3: 1740702617
      • 4: 1740702617
      • 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='4f0e793674d5ae12b547ec656563e03d'
      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
        YewFWZzEf112GksvzbwN98loN28REqwvzMYAJIHp
        uc_cart_id
        4f0e793674d5ae12b547ec656563e03d
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/125339" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/125339
        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 => "Fri, 28 Feb 2025 00:30:17 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlE1T1ZJSWV5YXRqSHQxb2xsTVgzTEE9PSIsInZhbHVlIjoidW1NN3lGS2E5cFhYVlN4NEs4V0tUb3FTenMzTUVyRWJESTVDcWxIRHQ1d3BqSFo1cVpSRjNmVmxENGVidi9FTXJkRDV5YTZGeDhra09EU2kreitGQm0reVJndGkvR3JRWWJqZENpbytyUHU5cHkrYzlGaXhST1h4dndSOVhEY3giLCJtYWMiOiJjM2FjODQ4OWNhNWI1M2VlYzEwYjI5N2NmNzI5OWIzYjI0MjA1NzlkNzU4Y2Y1MmZlMzMwODMyYTlmMWVkZjJhIiwidGFnIjoiIn0%3D; expires=Sun, 02 Mar 2025 12:30:17 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlE1T1ZJSWV5YXRqSHQxb2xsTVgzTEE9PSIsInZhbHVlIjoidW1NN3lGS2E5cFhYVlN4NEs4V0tUb3FTenMzTUVyRWJESTVDcWxIRHQ1d3BqSFo1cVpSRjNmVmxENGVidi9FTXJkRDV5Y" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlhhYVhndURYY3ZFWXdpNlBNcktGL2c9PSIsInZhbHVlIjoidTFDSzdFRDhDNW1ZclhDcGdmVm1mcHBhSFRsWkVXQVI0YXBUMUtWcGFpOTJraVhjYURPSENoeG5Ndm9waEd0UmJ2WjYvSmhvVFZhMDlqRE1mWTdLditlQjBjcWxUbllWMFowM2dmcGNNYU5uajdtc0dYUmEwTy9hWWFWcjJhR1QiLCJtYWMiOiI2NTlhOWZiNDY5OWFmMmFiYWQwNGYzMTRlYTgyMTJkMmE0OTRiMmQ4MzJlZjc2ODU2MmFlNzFlOGFlNDZkZDhjIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlhhYVhndURYY3ZFWXdpNlBNcktGL2c9PSIsInZhbHVlIjoidTFDSzdFRDhDNW1ZclhDcGdmVm1mcHBhSFRsWkVXQVI0YXBUMUtWcGFpOTJraVhjYURPSENoeG5" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlE1T1ZJSWV5YXRqSHQxb2xsTVgzTEE9PSIsInZhbHVlIjoidW1NN3lGS2E5cFhYVlN4NEs4V0tUb3FTenMzTUVyRWJESTVDcWxIRHQ1d3BqSFo1cVpSRjNmVmxENGVidi9FTXJkRDV5YTZGeDhra09EU2kreitGQm0reVJndGkvR3JRWWJqZENpbytyUHU5cHkrYzlGaXhST1h4dndSOVhEY3giLCJtYWMiOiJjM2FjODQ4OWNhNWI1M2VlYzEwYjI5N2NmNzI5OWIzYjI0MjA1NzlkNzU4Y2Y1MmZlMzMwODMyYTlmMWVkZjJhIiwidGFnIjoiIn0%3D; expires=Sun, 02-Mar-2025 12:30:17 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlE1T1ZJSWV5YXRqSHQxb2xsTVgzTEE9PSIsInZhbHVlIjoidW1NN3lGS2E5cFhYVlN4NEs4V0tUb3FTenMzTUVyRWJESTVDcWxIRHQ1d3BqSFo1cVpSRjNmVmxENGVidi9FTXJkRDV5Y" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlhhYVhndURYY3ZFWXdpNlBNcktGL2c9PSIsInZhbHVlIjoidTFDSzdFRDhDNW1ZclhDcGdmVm1mcHBhSFRsWkVXQVI0YXBUMUtWcGFpOTJraVhjYURPSENoeG5Ndm9waEd0UmJ2WjYvSmhvVFZhMDlqRE1mWTdLditlQjBjcWxUbllWMFowM2dmcGNNYU5uajdtc0dYUmEwTy9hWWFWcjJhR1QiLCJtYWMiOiI2NTlhOWZiNDY5OWFmMmFiYWQwNGYzMTRlYTgyMTJkMmE0OTRiMmQ4MzJlZjc2ODU2MmFlNzFlOGFlNDZkZDhjIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlhhYVhndURYY3ZFWXdpNlBNcktGL2c9PSIsInZhbHVlIjoidTFDSzdFRDhDNW1ZclhDcGdmVm1mcHBhSFRsWkVXQVI0YXBUMUtWcGFpOTJraVhjYURPSENoeG5" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "YewFWZzEf112GksvzbwN98loN28REqwvzMYAJIHp" "uc_cart_id" => "4f0e793674d5ae12b547ec656563e03d" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/125339" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 00:30:17GET/article/125339514361