Generic placeholder image

Current Chromatography

Editor-in-Chief

ISSN (Print): 2213-2406
ISSN (Online): 2213-2414

Research Article

Total Carotenoids Content and Assessment of Carotene Profile by High- Performance Liquid Chromatography in Selected Vegetables of Bangladesh with Special Reference to Some Unconventional Varieties

Author(s): Samia Sams, Mohammad Khairul Alam*, Monira Ahsan and Sheikh Nazrul Islam

Volume 7, Issue 1, 2020

Page: [24 - 31] Pages: 8

DOI: 10.2174/2213240607999200731010929

Price: $65

Abstract

Background: Carotenoids are natural plant pigments and precursors of vitamin A, which provide a health benefit, protect against chronic degenerative diseases, and contribute to immune functions. Utilization and identification of foods with a high content of carotenoids received greater attention nowadays.

Objective: The present study was aimed at evaluating total carotenoids content (TCC) and carotene composition of unconventional leafy vegetables growing in Bangladesh.

Materials and Methods: The samples were collected from different locations of Bangladesh and mixed together to ensure sample representativeness. Acetone–petroleum ether extraction followed by spectrophotometric measurement was utilized for quantification of TCC. High-performance liquid chromatography (HPLC- DAD) was used to separate and quantify carotene components.

Results and Discussion: The TCC values ranged from 129.38 μg/100 g edible portion (EP) in Helencha to 12803.31 μg/100 g EP in Roktodrone. The study findings also revealed that the selected plant samples exhibited high content of β-carotene ranging from 120.99 μg/100 g EP in Parul to 11301.16 μg/100 g EP in Roktodrone. It was also observed that most of the vegetables analyzed did not have α-carotene, lycopene, β-cryptoxanthin or it was in such a small quantity that could not be detected with HPLC.

Conclusion: It can be suggested that regular intake of these vegetables may provide pro-vitamin A. In order to address the vitamin A deficiency and to maintain biodiversity, the analysis of carotenoids composition of these unconventional plant foods is to be initiated and make it available to the mass population. It would also fill up the data gap in the existing food composition table of Bangladesh.

Keywords: Vitamin A, β-carotene, carotenoids, carotene profile, HPLC-DAD, unconventional vegetables.

[1]
Alam, M.K.; Rana, Z.H.; Islam, S.N.; Akhtaruzzaman, M. Comparative assessment of nutritional composition, polyphenol profile, antidiabetic and antioxidative properties of selected edible wild plant species of Bangladesh. Food Chem., 2020, 320126646
[http://dx.doi.org/10.1016/j.foodchem.2020.126646] [PMID: 32229398]
[2]
Rana, Z.H.; Alam, M.K.; Akhtaruzzaman, M. Nutritional Composition, Total Phenolic Content, Antioxidant and α-Amylase Inhibitory Activities of Different Fractions of Selected Wild Edible Plants. Antioxidants, 2019, 8(7), 203.
[http://dx.doi.org/10.3390/antiox8070203] [PMID: 31266183]
[3]
Alam, M.K.; Rana, Z.H.; Islam, S.N.; Akhtaruzzaman, M. Total phenolic content and antioxidant activity of methanolic extract of selected wWild leafy vegetables grown in bangladesh: A cheapest source of antioxidants. Potravin. Slovak J. Food Sci., 2019, 13(1), 287-293.
[http://dx.doi.org/10.5219/1107]
[4]
Alam, M.K.; Rana, Z.H.; Islam, S.N. Comparison of the proximate composition, total carotenoids and total polyphenol content of nine orange-fleshed sweet potato varieties grown in Bangladesh. Foods, 2016, 5(3), 64.
[http://dx.doi.org/10.3390/foods5030064] [PMID: 28231159]
[5]
Alam, M.K.; Rana, Z.H.; Kabir, N.; Begum, P.; Kawsar, M.; Khatun, M.; Ahsan, M.; Islam, S.N. Total Phenolics, Total Carotenoids and Antioxidant Activity of Selected Unconventional Vegetables Growing in Bangladesh. Curr. Nutr. Food Sci., 2019, 15
[http://dx.doi.org/10.2174/1573401315666191209095515]
[6]
Johnson, E.J. The role of carotenoids in human health. Nutr. Clin. Care, 2002, 5(2), 56-65.
[http://dx.doi.org/10.1046/j.1523-5408.2002.00004.x] [PMID: 12134711]
[7]
Hercberg, S.; Kesse-Guyot, E.; Druesne-Pecollo, N.; Touvier, M.; Favier, A.; Latino-Martel, P.; Briançon, S.; Galan, P. Incidence of cancers, ischemic cardiovascular diseases and mortality during 5-year follow-up after stopping antioxidant vitamins and minerals supplements: a postintervention follow-up in the SU.VI.MAX Study. Int. J. Cancer, 2010, 127(8), 1875-1881.
[http://dx.doi.org/10.1002/ijc.25201] [PMID: 20104528]
[8]
Abdel-Aal, S.M.; Akhtar, H.; Zaheer, K.; Ali, R. Dietary sources of lutein and zeaxanthin carotenoids and their role in eye health. Nutrients, 2013, 5(4), 1169-1185.
[http://dx.doi.org/10.3390/nu5041169] [PMID: 23571649]
[9]
Yaacob, J.S.; Abdul Halim, N.A.; Ashokhan, S.; Ali, H.; Othman, R. Distribution of carotenoids and vitamin a activity in aerial organs of selected underutilized malaysian “ulam” or traditional vegetables (averrhoa carambola, manihot esculenta and ipomoea batatas). Pigm. Resin Technol., 2019, 48(2), 148-155.
[http://dx.doi.org/10.1108/PRT-02-2018-0019]
[10]
Islam, S.N.; Nusrat, T.; Begum, P.; Ahsan, M. Carotenoids and β- carotene in orange fleshed sweet potato: A possible solution to vitamin A deficiency. Food Chem., 2016, 199, 628-631.
[http://dx.doi.org/10.1016/j.foodchem.2015.12.057] [PMID: 26776017]
[11]
Ghani, A. Medicinal Plants of Bangladesh: Chemical Constituents and Uses; Dhaka Asiat. Soc.: Bangladesh, 2003.
[12]
Sarker, U.; Hossain, M.M.; Oba, S. Nutritional and antioxidant components and antioxidant capacity in green morph Amaranthus leafy vegetable. Sci. Rep., 2020, 10(1), 1336.
[http://dx.doi.org/10.1038/s41598-020-57687-3] [PMID: 31992722]
[13]
Sarker, U.; Oba, S. Protein, dietary fiber, minerals, antioxidant pigments and phytochemicals, and antioxidant activity in selected red morph Amaranthus leafy vegetable. PLoS One, 2019, 14(12)e0222517
[http://dx.doi.org/10.1371/journal.pone.0222517] [PMID: 31830064]
[14]
Southgate, D.A.T.; Greenfield, H. Guidelines for the production, management and use of food composition data: An in foods project. Food Sci. Nutr., 2017, 42(1), 15-23.
[http://dx.doi.org/10.1080/09543465.1988.11904124]
[15]
Gupta, S.; Jyothi Lakshmi, A.; Manjunath, M.N.; Prakash, J. Analysis of nutrient and antinutrient content of underutilized green leafy vegetables. Lebensm. Wiss. Technol., 2005, 38(4), 339-345.
[http://dx.doi.org/10.1016/j.lwt.2004.06.012]
[16]
Raju, M.; Varakumar, S.; Lakshminarayana, R.; Krishnakantha, T.P.; Baskaran, V. Carotenoid composition and vitamin A activity of medicinally important green leafy vegetables. Food Chem., 2007, 101(4), 1598-1605.
[http://dx.doi.org/10.1016/j.foodchem.2006.04.015]
[17]
Lakshminarayana, R.; Raju, M.; Krishnakantha, T.P.; Baskaran, V. Determination of major carotenoids in a few Indian leafy vegetables by high-performance liquid chromatography. J. Agric. Food Chem., 2005, 53(8), 2838-2842.
[http://dx.doi.org/10.1021/jf0481711] [PMID: 15826027]
[18]
Rajyalakshmi, P.; Venkatalaxmi, K.; Venkatalakshmamma, K.; Jyothsna, Y.; Devi, K.B.; Suneetha, V. Total carotenoid and beta- carotene contents of forest green leafy vegetables consumed by tribals of south India. Plant Foods Hum. Nutr., 2001, 56(3), 225-238.
[http://dx.doi.org/10.1023/A:1011125232097] [PMID: 11442223]
[19]
Steiner-Asiedu, M.; Agbemafle, I.; Setorglo, J.; Danquah, A.O.; Anderson, A.K. Carotenoids content of corchorus olitorius and solanum macrocarpon - commonly used ghanaian vegetables. Int. Food Res. J., 2014, 21(5), 2063-2067.
[20]
Mageney, V.; Baldermann, S.; Albach, D.C. Intraspecific variation in carotenoids of brassica oleracea var. sabellica. J. Agric. Food Chem., 2016, 64(16), 3251-3257.
[http://dx.doi.org/10.1021/acs.jafc.6b00268] [PMID: 27045759]
[21]
Aizawa, K.; Inakuma, T. Quantitation of carotenoids in commonly consumed vegetables in Japan. Food Sci. Technol. Res., 2007, 13(3), 247-252.
[http://dx.doi.org/10.3136/fstr.13.247]
[22]
Neugart, S.; Baldermann, S.; Ngwene, B.; Wesonga, J.; Schreiner, M. Indigenous leafy vegetables of Eastern Africa - A source of extraordinary secondary plant metabolites. Food Res. Int., 2017, 100(Pt 3), 411-422.
[http://dx.doi.org/10.1016/j.foodres.2017.02.014] [PMID: 28964364]
[23]
Burri, B.J.; La Frano, M.R.; Zhu, C. Absorption, metabolism, and functions of β-cryptoxanthin. Nutr. Rev., 2016, 74(2), 69-82.
[http://dx.doi.org/10.1093/nutrit/nuv064] [PMID: 26747887]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version350msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[23:29:54] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[23:29:54] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[23:29:54] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (117ms)time
  • Application (234ms)time
  • 1 x Application (66.66%)
    234ms
    1 x Booting (33.34%)
    117ms
    12 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
    • 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, 2 of which were duplicates, 34 unique. Show only duplicated151ms
    • 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 ('309684047','',1,1739834994,1739834994) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739834994
      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 ('309684047','/article/108777',1,1739834994,1739834994)
      200μ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 >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) 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 >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) 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 >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) 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 >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) 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 >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) 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 >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 309684047 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309684047) limit 1
      16.51msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 309684047
      • 1: 309684047
      • 2: 309684047
      • 3: 309684047
      • 4: 309684047
      • 5: 309684047
      • 6: 309684047
      • 7: 309684047
      • 8: 309684047
      • 9: 309684047
      • 10: 309684047
      • 11: 309684047
      • 12: 309684047
      • 13: 309684047
      • 14: 309684047
      • 15: 309684047
      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=108777
      710μ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` = 140 limit 1
      800μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 140
      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=140) and sj.journal_id!=140 group by `j`.`nid`) as `aggregate_table`
      600μ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=140) and sj.journal_id!=140 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      520μ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=140) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      960μ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=140) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      880μ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` = '108777'
      300μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 108777
      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` = '108777'
      2.02msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 108777
      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` = '108777' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.51msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 108777
      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
      210μ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
      420μ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 = 140 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      28.93msalphaeurekaselec_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 = 140 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      1.26msalphaeurekaselec_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 = 140 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      1.01msalphaeurekaselec_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` = 108777 limit 1
      680μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 108777
      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 = 108777 and content_type = 'article' order by status desc limit 1
      550μ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 = 258 and cd.sub_disease_id = 353 and content_id!=108777 and cd.content_type = 'article' order by rand() limit 20
      51.52msalphaeurekaselec_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` = 184439 limit 1
      290μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 184439
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      280μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CCHG' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      270μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CCHG
      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 = '108777' 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) )
      350μ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 = '10173' 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) )
      390μ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 = '2780' 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) )
      320μ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 <= 309684047 and j.to_ip >=309684047 )) and ((j.from_date <= 1739834994 and j.to_date >= 1739834994 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2780) 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 <= 309684047 and j.to_ip >=309684047 )) and ((j.from_date <= 1739834994 and j.to_date >= 1739834994 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2780) 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 <= 309684047 and j.to_ip >=309684047 )) and ((j.from_date <= 1739834994 and j.to_date >= 1739834994 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2780)
      28.57msalphaeurekaselec_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 <= 309684047 and j.to_ip >=309684047 )) and ((j.from_date <= 1739834994 and j.to_date >= 1739834994 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10173) 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 <= 309684047 and j.to_ip >=309684047 )) and ((j.from_date <= 1739834994 and j.to_date >= 1739834994 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10173) 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 <= 309684047 and j.to_ip >=309684047 )) and ((j.from_date <= 1739834994 and j.to_date >= 1739834994 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10173)
      960μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2297
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 309684047 and j.to_ip >=309684047 )) and ((j.from_date <= 1739834994 and j.to_date >= 1739834994 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 108777) 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 <= 309684047 and j.to_ip >=309684047 )) and ((j.from_date <= 1739834994 and j.to_date >= 1739834994 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 108777) 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 <= 309684047 and j.to_ip >=309684047 )) and ((j.from_date <= 1739834994 and j.to_date >= 1739834994 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 108777)
      830μ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` < '24' and is_uploaded = 1 and issue_id = 10173 order by cast(first_page as SIGNED) desc limit 1
      700μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 24
      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` > '31' and is_uploaded = 1 and issue_id = 10173 order by cast(first_page as SIGNED) asc limit 1
      600μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 31
      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'
      220μ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
      260μ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` = 108777 limit 1
      4msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 108777
      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` = 140 and `b`.`banner_from_date` <= 1739834994 and `b`.`banner_to_date` >= 1739834994 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.19msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 140
      • 3: 1739834994
      • 4: 1739834994
      • 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='28b270db3d38cd5cfed3511c1a6e4111'
      250μ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
        jREQ9sY4gkIE3l8awxwo8t081lmzx0TENXZImU2p
        uc_cart_id
        28b270db3d38cd5cfed3511c1a6e4111
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/108777" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/108777
        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=eyJpdiI6InVVckloRnU1TnA3YUsvUjlpNStJR0E9PSIsInZhbHVlIjoiUEt1TThKbTcrL1N2NkVBTVhhQnRVQ0IzZ1l5V3RsYkN0Z3Vvd2NMS0lhaz0iLCJtYWMiOiIwODdlNTY5YTE2M2M4ZmIzMzc2ZDI3YjhmNzhkOTg1YjUyMzgyNDViYTRiZDI5Yzk1MjFlZmE2M2I0NjI2ODIzIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6InVVckloRnU1TnA3YUsvUjlpNStJR0E9PSIsInZhbHVlIjoiUEt1TThKbTcrL1N2NkVBTVhhQnRVQ0IzZ1l5V3RsYkN0Z3Vvd2NMS0lhaz0iLCJtYWMiOiIwODdlNTY5YTE2M2M4" ] "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 => "Mon, 17 Feb 2025 23:29:54 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkZiVm9tcDlPZmwvOTRtTnkyVCt3K3c9PSIsInZhbHVlIjoieTdJendtdEZSZVFrUGd3aitUbng2WFBOZXRFVVNjdUJjdk94T1hCb3BHZVJOTmxTSG15QWIwZE9mY1JvQ28yREJWL29kQUhid0RobktxSmRZcjcwcE5PSVYxbUVrQTh1N3UyQy9lUXY5K2tTc2hUWXVoaU8zM1YwNUZsamJoRzUiLCJtYWMiOiI0YTUxOGUzMzBiNTM5Y2U5N2FiOTdkMTE1ZmQ2Y2NmNDRmMmQzOTU0OTg0ODA3MTExYWJiYjgxNTQxY2JhNTU5IiwidGFnIjoiIn0%3D; expires=Thu, 20 Feb 2025 11:29:54 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkZiVm9tcDlPZmwvOTRtTnkyVCt3K3c9PSIsInZhbHVlIjoieTdJendtdEZSZVFrUGd3aitUbng2WFBOZXRFVVNjdUJjdk94T1hCb3BHZVJOTmxTSG15QWIwZE9mY1JvQ28yREJWL29kQ" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkZOSmxpRHFLT0tMcTFQM2ZhdVNyS1E9PSIsInZhbHVlIjoiOGVjd0drT1hLcE8vOTI5eFZvejkwWUJqalJjNUQyUlMwRzMrdG83a3FiWmhiSWpJbTF3S0hPaFVUZ0ZybEk4MTY0aWZFMEpFbmFmVXdyS3ovcmg2U05TbndVU21TVEhrVHJFRE4yVDFxK2JvVGd1Y1Q1dkpHbHd5Rjk1RkZLdEIiLCJtYWMiOiI3N2M3N2JjZDE3NDBjZjc4NmQ4ZWYyNmJiZjI0NzgwODgxOGQ0OWFmZDYzYzhmNTE4MzUzMjM3ZjBhZTMxY2VjIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkZOSmxpRHFLT0tMcTFQM2ZhdVNyS1E9PSIsInZhbHVlIjoiOGVjd0drT1hLcE8vOTI5eFZvejkwWUJqalJjNUQyUlMwRzMrdG83a3FiWmhiSWpJbTF3S0hPaFV" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkZiVm9tcDlPZmwvOTRtTnkyVCt3K3c9PSIsInZhbHVlIjoieTdJendtdEZSZVFrUGd3aitUbng2WFBOZXRFVVNjdUJjdk94T1hCb3BHZVJOTmxTSG15QWIwZE9mY1JvQ28yREJWL29kQUhid0RobktxSmRZcjcwcE5PSVYxbUVrQTh1N3UyQy9lUXY5K2tTc2hUWXVoaU8zM1YwNUZsamJoRzUiLCJtYWMiOiI0YTUxOGUzMzBiNTM5Y2U5N2FiOTdkMTE1ZmQ2Y2NmNDRmMmQzOTU0OTg0ODA3MTExYWJiYjgxNTQxY2JhNTU5IiwidGFnIjoiIn0%3D; expires=Thu, 20-Feb-2025 11:29:54 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkZiVm9tcDlPZmwvOTRtTnkyVCt3K3c9PSIsInZhbHVlIjoieTdJendtdEZSZVFrUGd3aitUbng2WFBOZXRFVVNjdUJjdk94T1hCb3BHZVJOTmxTSG15QWIwZE9mY1JvQ28yREJWL29kQ" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkZOSmxpRHFLT0tMcTFQM2ZhdVNyS1E9PSIsInZhbHVlIjoiOGVjd0drT1hLcE8vOTI5eFZvejkwWUJqalJjNUQyUlMwRzMrdG83a3FiWmhiSWpJbTF3S0hPaFVUZ0ZybEk4MTY0aWZFMEpFbmFmVXdyS3ovcmg2U05TbndVU21TVEhrVHJFRE4yVDFxK2JvVGd1Y1Q1dkpHbHd5Rjk1RkZLdEIiLCJtYWMiOiI3N2M3N2JjZDE3NDBjZjc4NmQ4ZWYyNmJiZjI0NzgwODgxOGQ0OWFmZDYzYzhmNTE4MzUzMjM3ZjBhZTMxY2VjIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkZOSmxpRHFLT0tMcTFQM2ZhdVNyS1E9PSIsInZhbHVlIjoiOGVjd0drT1hLcE8vOTI5eFZvejkwWUJqalJjNUQyUlMwRzMrdG83a3FiWmhiSWpJbTF3S0hPaFV" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "jREQ9sY4gkIE3l8awxwo8t081lmzx0TENXZImU2p" "uc_cart_id" => "28b270db3d38cd5cfed3511c1a6e4111" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/108777" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-17 23:29:54GET/article/108777312361