Generic placeholder image

Current Nutrition & Food Science

Editor-in-Chief

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

Research Article

Food Services Menu Engineering: Preference, Acceptability, and Popularity Index of Local Food Package Menus to Control the Glycemic Responses of T2DM Subjects

Author(s): Nurul Hakimah*, Nur Rahman, Sucipto Sucipto, Wignyanto Wignyanto and Aulanni'am Aulanni'am

Volume 16, Issue 7, 2020

Page: [1119 - 1129] Pages: 11

DOI: 10.2174/1573401316666191226114724

Price: $65

Abstract

Background: The purpose of this study was to analyze the menu engineering data: preferences, acceptances, and popularity indexes of local food package menus with low to moderate glycemic index and how these variables affect the glycemic response of subjects with type 2 diabetes mellitus (T2DM).

Methods: This study was a one group pre and post-test experimental study with 21 T2DM participants. A total of 1,764 menu engineering data were obtained during the two-week study period. Fifteen food service survey questions were distributed and anthropometric and glycemic responses were measured.

Results: The popularity indexes of the main and snack package menus were significantly different (p=0,000). There was a significant decrease (p<0.05) in Δ RBG levels by 59.6±115.8 mg/ dL (26.7%) and Δ % albumin glycated by 1.5±1.0 (6.1%) (p = 0.000) on 38% subjects with good glycemic control who consumed less food outside the study (12.5%). Price, type of food, type of foodstuff, nutrient content, portion size, food appearance, food texture, GI values, food menu name, and menu conformity to the environment were important considerations in the menu preference and popularity.

Conclusion: This study showed that the local food package menu can control the glycemic response of T2DM participants while having a high popularity index. This finding provides an opportunity for the foodservice industry to operate sustainably by considering the factors desired by consumers with T2DM in controlling their long-term glycemic response.

Keywords: Food acceptance, food service industry, glycemic control, local food, menu preference, popularity index.

Graphical Abstract

[1]
Gundala S, Sastry VV, Manmohan T, Geeta V. A study on adherence to dietary guidelines, treatment and preventive care among diabetic patients. Int Arch Integr Med 2016; 3(5): 166-73.
[2]
World Health Organization. Adherence to long-term therapy: Evidence for action. Switzerland: Jenewa 2003.
[3]
Coyle ME, Francis K, Chapman Y. Self-management activities in diabetes care: a systematic review. Aust Health Rev 2013; 37(4): 513-22.
[http://dx.doi.org/10.1071/AH13060] [PMID: 24018058]
[4]
Thomas D, Elliott EJ. Low glycaemic index, or low glycaemic load, diets for diabetes mellitus. Cochrane Database Syst Rev 2009; (1): : CD006296.
[http://dx.doi.org/10.1002/14651858.CD006296.pub2] [PMID: 19160276]
[5]
McGeoch SC, Holtrop G, Fyfe C, et al. Food intake and dietary glycaemic index in free-living adults with and without type 2 diabetes mellitus. Nutrients 2011; 3(6): 683-93.
[http://dx.doi.org/10.3390/nu3060683] [PMID: 22254116]
[6]
Raj D, Devi G. Dietary adherence and food acceptability among individuals with type 2 diabetes. Univ Alberia 2012. (thesis).
[7]
Ahlgren SS, Shultz JA, Massey LK, Hicks BC, Wysham C. Development of a preliminary diabetes dietary satisfaction and outcomes measure for patients with type 2 diabetes. Qual Life Res 2004; 13(4): 819-32.
[http://dx.doi.org/10.1023/B:QURE.0000021694.59992.a1] [PMID: 15129892]
[8]
Dunne JB, Chambers KJ, Giombolini KJ, Schlegel SA. What does local mean in the grocery store? Multiplicity in food retailers’ perspectives on sourcing and marketing local foods. Renew Agric Food Syst 2011; 26(1): 46-59.
[http://dx.doi.org/10.1017/S1742170510000402]
[9]
Feenstra G. Creating space for sustainable food systems: Lessons from the field. Agric Human Values 2002; 19(2): 99-106.
[http://dx.doi.org/10.1023/A:1016095421310]
[10]
Brand-Miller J, Hayne S, Petocz P, Colagiuri S. Low-glycemic index diets in the management of diabetes: a meta-analysis of randomized controlled trials. Diabetes Care 2003; 26(8): 2261-7.
[http://dx.doi.org/10.2337/diacare.26.8.2261] [PMID: 12882846]
[11]
de Munter JSL, Hu FB, Spiegelman D, Franz M, van Dam RM. Whole grain, bran, and germ intake and risk of type 2 diabetes: a prospective cohort study and systematic review. PLoS Med 2007; 4(8): e261.
[http://dx.doi.org/10.1371/journal.pmed.0040261] [PMID: 17760498]
[12]
Virtanen HEK, Koskinen TT, Voutilainen S, et al. Intake of different dietary proteins and risk of type 2 diabetes in men: The kuopio ischaemic heart disease risk factor study. Br J Nutr 2017; 117(6): 882-93.
[http://dx.doi.org/10.1017/S0007114517000745] [PMID: 28397639]
[13]
Mikkelsen BE. Declining role of governments in promoting healthy eating: Time to rethink the role of the food industry? Scandinavian J Nutr 2005; 49: 127-30.
[14]
Melia D. Trends in the food and beverage sector of the hospitality industry recommended citation. In: Dubrovnik, Croatia: Euro- CHRIE Conference. 2011.
[15]
Gudzune KA, Doshi RS, Mehta AK, et al. Efficacy of commercial weight-loss programs: An updated systematic review. Ann Intern Med 2015; 162(10): 739.
[16]
Deurenberg P, Weststrate JA, Seidell JC. Body mass index as a measure of body fatness: Age and sex-specific prediction formulas. Br J Nutr 1991; 65(2): 105-14.
[http://dx.doi.org/10.1079/BJN19910073] [PMID: 2043597]
[17]
Loredo A, Jaramillo K, Nickerson B. Validity of BMI-based equations for estimating body fat percentage in collegiate male soccer players: A three-compartment model comparison. IJESAB 2016; 2(10)(proceeding).
[18]
Swaroopa Rani GN, Swaroopa Rani G. Different measuring techniques for body fat analysis. Int Res J Sci Eng 2015; 3(33): 98-106.
[19]
Malhotra NK. Questionnaire Design and scale development. The handbook of marketing research. In: Grover R, Ed The handbook of marketing research. California: SAGE Publications, Inc. 2006.
[http://dx.doi.org/10.4135/9781412973380.n5]
[20]
Brouns F, Bjorck I, Frayn KN, et al. Glycaemic index methodology. Nutr Res Rev 2005; 18(1): 145-71.
[http://dx.doi.org/10.1079/NRR2005100] [PMID: 19079901]
[21]
Avedzi HM, Mathe N, Storey K, Johnson JA, Johnson ST. Examining sex differences in glycemic index knowledge and intake among individuals with type 2 diabetes. Prim Care Diabetes 2018; 12(1): 71-9.
[http://dx.doi.org/10.1016/j.pcd.2017.07.005] [PMID: 28823516]
[22]
Geaney F, Fitzgerald S, Harrington JM, Kelly C, Greiner BA, Perry IJ. Nutrition knowledge, diet quality and hypertension in a working population. Prev Med Rep 2015; 2: 105-13.
[http://dx.doi.org/10.1016/j.pmedr.2014.11.008] [PMID: 26844058]
[23]
Lyons BP. Nutrition education intervention with community-dwelling older adults: research challenges and opportunities. J Community Health 2014; 39(4): 810-8.
[http://dx.doi.org/10.1007/s10900-013-9810-x] [PMID: 24368631]
[24]
Al-Rasheedi AAS. The role of educational level in glycemic control among patients with type II diabetes mellitus. Int J Health Sci (Qassim) 2014; 8(2): 177-87.
[http://dx.doi.org/10.12816/0006084] [PMID: 25246885]
[25]
Brewster PWH, Melrose RJ, Marquine MJ, et al. Life experience and demographic influences on cognitive function in older adults. Neuropsychology 2014; 28(6): 846-58.
[http://dx.doi.org/10.1037/neu0000098] [PMID: 24933483]
[26]
Roberto CA, Khandpur N. Improving the design of nutrition labels to promote healthier food choices and reasonable portion sizes. Int J Obes 2014; 38(Suppl. 1): S25-33.
[http://dx.doi.org/10.1038/ijo.2014.86] [PMID: 25033961]
[27]
Petit O, Merunka D, Anton J-L, et al. Health and pleasure in consumers’ dietary food choices: individual differences in the brain’s value system. PLoS One 2016; 11(7): e0156333.
[http://dx.doi.org/10.1371/journal.pone.0156333] [PMID: 27428267]
[28]
French SA. Pricing effects on food choices. J Nutr 2003; 133(3): 841S-3S.
[http://dx.doi.org/10.1093/jn/133.3.841S] [PMID: 12612165]
[29]
Kumar S, Mohanraj R, Sudha V, et al. Perceptions about varieties of brown rice: a qualitative study from Southern India. J Am Diet Assoc 2011; 111(10): 1517-22.
[http://dx.doi.org/10.1016/j.jada.2011.07.002] [PMID: 21963018]
[30]
Ebrahim Z, De Villiers A, Ahmed T. Factors influencing adherence to dietary guidelines: A qualitative study on the experiences of patients with type 2 diabetes attending a clinic in Cape Town. J Endocrinol Metab Diabetes South Africa 2014; 19(2): 76-84.
[http://dx.doi.org/10.1080/16089677.2014.11073604]
[31]
Alhussain MH, Macdonald IA, Taylor MA. Irregular meal-pattern effects on energy expenditure, metabolism, and appetite regulation: a randomized controlled trial in healthy normal-weight women. Am J Clin Nutr 2016; 104(1): 21-32.
[http://dx.doi.org/10.3945/ajcn.115.125401] [PMID: 27305952]
[32]
Juraschek SP, Steffes MW, Miller ER III, Selvin E. Alternative markers of hyperglycemia and risk of diabetes. Diabetes Care 2012; 35(11): 2265-70.
[http://dx.doi.org/10.2337/dc12-0787] [PMID: 22875225]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version389msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[04:52:31] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[04:52:32] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[04:52:32] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (121ms)time
  • Application (268ms)time
  • 1 x Application (68.9%)
    268ms
    1 x Booting (31.1%)
    121ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated171ms
    • 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 ('221946642','',1,1740459151,1740459151) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740459151
      990μsalphaeurekaselec_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 ('221946642','/article/103229',1,1740459151,1740459151)
      130μ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 >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) 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 >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) 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 >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) 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 >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) 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 >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) 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 >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 221946642 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221946642) limit 1
      11.82msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 221946642
      • 1: 221946642
      • 2: 221946642
      • 3: 221946642
      • 4: 221946642
      • 5: 221946642
      • 6: 221946642
      • 7: 221946642
      • 8: 221946642
      • 9: 221946642
      • 10: 221946642
      • 11: 221946642
      • 12: 221946642
      • 13: 221946642
      • 14: 221946642
      • 15: 221946642
      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=103229
      700μ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
      710μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 35
      Backtrace
      • 14. app/Models/Journal.php:64
      • 15. app/Http/Controllers/ArticleController.php:2516
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=35) and sj.journal_id!=35 group by `j`.`nid`) as `aggregate_table`
      540μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=35) and sj.journal_id!=35 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      400μ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`
      730μ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
      660μ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` = '103229'
      1.52msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 103229
      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` = '103229'
      3.07msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 103229
      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` = '103229' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.83msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 103229
      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
      230μ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
      26.16msalphaeurekaselec_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.04msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2070
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 35 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      7.62msalphaeurekaselec_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` = 103229 limit 1
      300μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 103229
      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 = 103229 and content_type = 'article' order by status desc limit 1
      420μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 283 and cd.sub_disease_id = 591 and content_id!=103229 and cd.content_type = 'article' order by rand() limit 20
      70.06msalphaeurekaselec_live_10_06_2022Article.php#769
      Backtrace
      • 11. app/Models/Article.php:769
      • 12. app/Http/Controllers/ArticleController.php:2098
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 177797 limit 1
      290μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 177797
      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
      350μ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
      380μ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 = '103229' 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) )
      480μ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 = '10027' 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) )
      430μ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) )
      400μ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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459152 and j.to_date >= 1740459152 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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459152 and j.to_date >= 1740459152 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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459152 and j.to_date >= 1740459152 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.03msalphaeurekaselec_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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459152 and j.to_date >= 1740459152 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10027) 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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459152 and j.to_date >= 1740459152 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10027) 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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459152 and j.to_date >= 1740459152 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10027)
      1.05msalphaeurekaselec_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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459152 and j.to_date >= 1740459152 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 103229) 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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459152 and j.to_date >= 1740459152 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 103229) 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 <= 221946642 and j.to_ip >=221946642 )) and ((j.from_date <= 1740459152 and j.to_date >= 1740459152 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 103229)
      900μ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` < '1119' and is_uploaded = 1 and issue_id = 10027 order by cast(first_page as SIGNED) desc limit 1
      820μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 1119
      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` > '1129' and is_uploaded = 1 and issue_id = 10027 order by cast(first_page as SIGNED) asc limit 1
      690μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 1129
      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'
      240μ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
      330μ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` = 103229 limit 1
      3.95msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 103229
      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` <= 1740459152 and `b`.`banner_to_date` >= 1740459152 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.69msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 35
      • 3: 1740459152
      • 4: 1740459152
      • 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` <= 1740459152 and `b`.`banner_to_date` >= 1740459152 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.68msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 35
      • 3: 1740459152
      • 4: 1740459152
      • 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='cf0927a01e80c0d40b586d8b18f91a8e'
      400μ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
        U78oAzwqgSjQeZSdYF5a5cgEcBBGwi9KwLhXjLs9
        uc_cart_id
        cf0927a01e80c0d40b586d8b18f91a8e
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/103229" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/103229
        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=eyJpdiI6Ik1GZGoyTzVGa2xFR2R6cFNMZHl3MkE9PSIsInZhbHVlIjoiT2UwOHBOdVRCdWxEMGV0b1pVQkZGN3EwUWRXWnFDckJyOW15a1k4TEFaMD0iLCJtYWMiOiIxMGIxM2Q5NTU5NWE4MGM2OGJkNzk5MGExNmNiNjVlMzczNTJhNGM3NTk4MzBmNTc1ODE1ZjdhODZmYWNiMDlhIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6Ik1GZGoyTzVGa2xFR2R6cFNMZHl3MkE9PSIsInZhbHVlIjoiT2UwOHBOdVRCdWxEMGV0b1pVQkZGN3EwUWRXWnFDckJyOW15a1k4TEFaMD0iLCJtYWMiOiIxMGIxM2Q5NTU5NWE4" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 25 Feb 2025 04:52:32 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlpxU2l0VXhPVnIyUGVtZWdoTTNaZ1E9PSIsInZhbHVlIjoibFl2YTd3ZXFSK3c5TW93U2RIQUFvTU1uR2o5NjYzWmdhMXFOa0lzOHk5VzNkWE1CVVVuSHJHWnUwYXREYTh3LzdzYWlpVmc1WGZ3TGVXT2VjOHNSaUh0a2lnVC9kRnhmR2lLL0p1TFdXZXkyQ2dSQ05CZklWUGxGNnI2RzlUbE8iLCJtYWMiOiI5NjBkNzVjNTk5NTJmY2UzMzU5NGFjMjA1ZjYyYTNhOTgyNGI0ZjI5MTdjOGE3NTZhYjYxNmIzYjc1YzFhNTY4IiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 16:52:32 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlpxU2l0VXhPVnIyUGVtZWdoTTNaZ1E9PSIsInZhbHVlIjoibFl2YTd3ZXFSK3c5TW93U2RIQUFvTU1uR2o5NjYzWmdhMXFOa0lzOHk5VzNkWE1CVVVuSHJHWnUwYXREYTh3LzdzYWlpV" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlgzMmNwN01KZVdjakQ2TzFvT2srK0E9PSIsInZhbHVlIjoiYUpjZWhkSVZSd2hkTjFnUXI3VFdMNThqRUtZOFU3SkNyWE9RdlpVVFpJM096MDdyVUJQSm9pblAzN2FlS3YxWXZjOEhwSVhzV1pSR1NqZzdTNjNwekwrUmZyRjh6UHZtWElZV1VaQ1d2NllLc1BpeWo3YUhkek5mK0pXalBzQVIiLCJtYWMiOiI1YTkzMmYzMmZhMWQ1ZjM1NjhiYjI0MDQzNGExZTYwNGYzN2YwZDg3NmQ4ZTMxY2JhNzM3ZjQzOWUxYWNhMjQzIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlgzMmNwN01KZVdjakQ2TzFvT2srK0E9PSIsInZhbHVlIjoiYUpjZWhkSVZSd2hkTjFnUXI3VFdMNThqRUtZOFU3SkNyWE9RdlpVVFpJM096MDdyVUJQSm9pblA" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlpxU2l0VXhPVnIyUGVtZWdoTTNaZ1E9PSIsInZhbHVlIjoibFl2YTd3ZXFSK3c5TW93U2RIQUFvTU1uR2o5NjYzWmdhMXFOa0lzOHk5VzNkWE1CVVVuSHJHWnUwYXREYTh3LzdzYWlpVmc1WGZ3TGVXT2VjOHNSaUh0a2lnVC9kRnhmR2lLL0p1TFdXZXkyQ2dSQ05CZklWUGxGNnI2RzlUbE8iLCJtYWMiOiI5NjBkNzVjNTk5NTJmY2UzMzU5NGFjMjA1ZjYyYTNhOTgyNGI0ZjI5MTdjOGE3NTZhYjYxNmIzYjc1YzFhNTY4IiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 16:52:32 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlpxU2l0VXhPVnIyUGVtZWdoTTNaZ1E9PSIsInZhbHVlIjoibFl2YTd3ZXFSK3c5TW93U2RIQUFvTU1uR2o5NjYzWmdhMXFOa0lzOHk5VzNkWE1CVVVuSHJHWnUwYXREYTh3LzdzYWlpV" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlgzMmNwN01KZVdjakQ2TzFvT2srK0E9PSIsInZhbHVlIjoiYUpjZWhkSVZSd2hkTjFnUXI3VFdMNThqRUtZOFU3SkNyWE9RdlpVVFpJM096MDdyVUJQSm9pblAzN2FlS3YxWXZjOEhwSVhzV1pSR1NqZzdTNjNwekwrUmZyRjh6UHZtWElZV1VaQ1d2NllLc1BpeWo3YUhkek5mK0pXalBzQVIiLCJtYWMiOiI1YTkzMmYzMmZhMWQ1ZjM1NjhiYjI0MDQzNGExZTYwNGYzN2YwZDg3NmQ4ZTMxY2JhNzM3ZjQzOWUxYWNhMjQzIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlgzMmNwN01KZVdjakQ2TzFvT2srK0E9PSIsInZhbHVlIjoiYUpjZWhkSVZSd2hkTjFnUXI3VFdMNThqRUtZOFU3SkNyWE9RdlpVVFpJM096MDdyVUJQSm9pblA" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "U78oAzwqgSjQeZSdYF5a5cgEcBBGwi9KwLhXjLs9" "uc_cart_id" => "cf0927a01e80c0d40b586d8b18f91a8e" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/103229" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 04:52:32GET/article/103229314371