Generic placeholder image

Current Traditional Medicine

Editor-in-Chief

ISSN (Print): 2215-0838
ISSN (Online): 2215-0846

Systematic Review Article

Phytoestrogens in Menopausal Hot Flashes: A Review Article

Author(s): Rahele Kargozar, Hoda Azizi, Mahdi Yousefi, Seyedeh Azam Pourhoseini, Hamideh Naghedi-Baghdar, Seyed Majid Ghazanfari and Roshanak Salari*

Volume 10, Issue 4, 2024

Published on: 26 June, 2023

Article ID: e290523217412 Pages: 12

DOI: 10.2174/2215083810666230529123939

Price: $65

Abstract

Background: Menopause is a biopsychosocial phenomenon in a woman’s life, and it occurs at about the age of 48-55 years. Factors such as smoking, the number of children, early puberty, and social class can cause early natural menopause. Symptoms that occur during menopause include headache, mood disorders, insomnia, distraction, hot flashes, vaginal dryness, and sweating. The most common symptom is hot flashes, which affect 85% of women with menopause. Recently, people are showing more tendencies toward alternative therapies and herbs phytoestrogens.

Objective: This review aims to introduce the mechanism of herbal phytoestrogens controlling hot flashes during menopause.

Methods: Our searches were performed in the databases of PubMed, Scopus, and Cochrane. English clinical trials, that investigated the effects of phytoestrogen plants individually or in combination on the treatment of hot flashes in menopause were analyzed. After reviewing articles and meeting the inclusion and exclusion criteria, 18 articles were selected.

Results: In this study, 18 clinical trials of 2351 female patients were analyzed. The phytoestrogen plants studied include soy, red clover, cohosh, hops, flax, pomegranate, anise, and Vitex Agnus.

Conclusion: Studies have shown the beneficial effects of phytoestrogens in controlling hot flashes, but in some cases, including soybeans, there are contradictory effects. Therefore, more clinical trials are needed to achieve reliable results to confirm the phytoestrogen effects of herbal medicines.

Graphical Abstract

[1]
Speroff L, Glass K, Kase H. Clinical gynecology, and infertility. (7th ed.), Philadelphia: Williams & Wilkins 2005.
[2]
Anderson DJ, Yates P, McCarthy A, et al. Younger and older women’s concerns about menopause after breast cancer. Eur J Cancer Care 2011; 20(6): 785-94.
[http://dx.doi.org/10.1111/j.1365-2354.2011.01282.x] [PMID: 21883565]
[3]
Kargozar R, Azizi H, Salari R. A review of effective herbal medicines in controlling menopausal symptoms. Electron Physician 2017; 9(11): 5826-33.
[http://dx.doi.org/10.19082/5826] [PMID: 29403626]
[4]
Organization WH. WHO global atlas of traditional, complementary, and alternative medicine. World Health Organization 2005.
[5]
Eden JA. Phytoestrogens for menopausal symptoms: A review. Maturitas 2012; 72(2): 157-9.
[http://dx.doi.org/10.1016/j.maturitas.2012.03.006] [PMID: 22516278]
[6]
Patisaul HB, Jefferson W. The pros and cons of phytoestrogens. Front Neuroendocrinol 2010; 31(4): 400-19.
[http://dx.doi.org/10.1016/j.yfrne.2010.03.003] [PMID: 20347861]
[7]
Murkies AL, Lombard C, Strauss BJG, Wilcox G, Burger HG, Morton MS. Dietary flour supplementation decreases post-menopausal hot flushes: Effect of soy and wheat. Maturitas 1995; 21(3): 189-95.
[http://dx.doi.org/10.1016/0378-5122(95)00899-V] [PMID: 7616867]
[8]
St Germain A, Peterson CTMS, Robinson JGMDMPH, Alekel DLPRD. Isoflavone-rich or isoflavone-poor soy protein does not reduce menopausal symptoms during 24 weeks of treatment. Menopause 2001; 8(1): 17-26.
[http://dx.doi.org/10.1097/00042192-200101000-00005] [PMID: 11201510]
[9]
Faure ED, Chantre P, Mares P. Effects of a standardized soy extract on hot flushes: A multicenter, double-blind, randomized, placebo-controlled study. Menopause 2002; 9(5): 329-34.
[http://dx.doi.org/10.1097/00042192-200209000-00005] [PMID: 12218721]
[10]
Russo R, Corosu R. The clinical use of a preparation based on phyto-oestrogens in the treatment of menopausal disorders. Acta Biomed 2003; 74(3): 137-43.
[PMID: 15055018]
[11]
Nahas EAP, Nahas-Neto J, Orsatti FL, Carvalho EP, Oliveira MLCS, Dias R. Efficacy and safety of a soy isoflavone extract in postmenopausal women: A randomized, double-blind, and placebo-controlled study. Maturitas 2007; 58(3): 249-58.
[http://dx.doi.org/10.1016/j.maturitas.2007.08.012] [PMID: 17913408]
[12]
Ferrari A. Soy extract phytoestrogens with high dose of isoflavones for menopausal symptoms. J Obstet Gynaecol Res 2009; 35(6): 1083-90.
[http://dx.doi.org/10.1111/j.1447-0756.2009.01058.x] [PMID: 20025635]
[13]
van de Weijer PHM, Barentsen R. Isoflavones from red clover (Promensil®) significantly reduce menopausal hot flush symptoms compared with placebo. Maturitas 2002; 42(3): 187-93.
[http://dx.doi.org/10.1016/S0378-5122(02)00080-4] [PMID: 12161042]
[14]
Tice JA, Ettinger B, Ensrud K, Wallace R, Blackwell T, Cummings SR. Phytoestrogen supplements for the treatment of hot flashes: the Isoflavone Clover Extract (ICE) Study: A randomized controlled trial. JAMA 2003; 290(2): 207-14.
[http://dx.doi.org/10.1001/jama.290.2.207] [PMID: 12851275]
[15]
Osmers R, Friede M, Liske E, Schnitker J, Freudenstein J, Henneicke-von ZHH. Efficacy and safety of isopropanol black cohosh extract for climacteric symptoms. Obstet Gynecol 2005; 5(1): 1074-83.
[16]
Heyerick A, Vervarcke S, Depypere H, Bracke M, Keukeleire DD. A first prospective, randomized, double-blind, placebo-controlled study on the use of a standardized hop extract to alleviate menopausal discomforts. Maturitas 2006; 54(2): 164-75.
[http://dx.doi.org/10.1016/j.maturitas.2005.10.005] [PMID: 16321485]
[17]
Bai W, Henneicke-von ZH, Wang S, Zheng S, Liu J, Zhang Z. Efficacy and tolerability of a medicinal product containing an isopropanol black cohosh extract in Chinese women with parallel-controlled study versus tibolone. Maturitas 2007; 58(1): 31-41.
[http://dx.doi.org/10.1016/j.maturitas.2007.04.009] [PMID: 17587516]
[18]
Erkkola R, Vervarcke S, Vansteelandt S, Rompotti P, De Keukeleire D, Heyerick A. A randomized, double-blind, placebo-controlled, cross-over pilot study on the use of a standardized hop extract to alleviate menopausal discomforts. Phytomedicine 2010; 17(6): 389-96.
[http://dx.doi.org/10.1016/j.phymed.2010.01.007] [PMID: 20167461]
[19]
Simbalista R, Sauerbronn A, Aldrighi J, Arêas J. Consumption of a flaxseed-rich food is not more effective than a placebo in alleviating the climacteric symptoms of postmenopausal women. Nutrition 2010; 140(2): 93-7.
[20]
Auerbach L, Rakus J, Bauer C, et al. Pomegranate seed oil in women with menopausal symptoms. Menopause 2012; 19(4): 426-32.
[http://dx.doi.org/10.1097/gme.0b013e3182345b2f] [PMID: 22240636]
[21]
Nahidi F, Kariman N, Simbar M, Mojab F. The study on the effects of Pimpinella anisum on relief and recurrence of menopausal hot flashes. Iran J Pharm Res 2012; 11(4): 1079-85.
[PMID: 24250540]
[22]
De Franciscis P, Grauso F, Luisi A, Schettino M, Torella M, Colacurci N. Adding agnus castus and magnolia to soy isoflavones relieve sleep disturbances besides postmenopausal vasomotor symptoms-long term safety and effectiveness. Nutrients 2017; 9(2): 129.
[http://dx.doi.org/10.3390/nu9020129] [PMID: 28208808]
[23]
Gougeon A. Dynamics of follicular growth in the human: A model from preliminary results. Hum Reprod 1986; 1(2): 81-7.
[http://dx.doi.org/10.1093/oxfordjournals.humrep.a136365] [PMID: 3558758]
[24]
Bachmann GA. Menopausal vasomotor symptoms: A review of causes, effects and evidence-based treatment options. J Reprod Med 2005; 50(3): 155-65.
[PMID: 15841927]
[25]
Agarwal A, Doshi SB. The role of oxidative stress in menopause. J Midlife Health 2013; 4(3): 140-6.
[http://dx.doi.org/10.4103/0976-7800.118990] [PMID: 24672185]
[26]
Kuiper GGJM, Lemmen JG, Carlsson B, et al. Interaction of estrogenic chemicals and phytoestrogens with estrogen receptor β. Endocrinology 1998; 139(10): 4252-63.
[http://dx.doi.org/10.1210/endo.139.10.6216] [PMID: 9751507]
[27]
Mueller SO. Overview of in vitro tools to assess the estrogenic and antiestrogenic activity of phytoestrogens. J Chromatogr B Analyt Technol Biomed Life Sci 2002; 777(1-2): 155-65.
[http://dx.doi.org/10.1016/S1570-0232(02)00282-9] [PMID: 12270209]
[28]
Chlebowski RT, Hendrix SL, Langer RD, et al. Influence of estrogen plus progestin on breast cancer and mammography in healthy postmenopausal women: The Women’s Health Initiative Randomized Trial. JAMA 2003; 289(24): 3243-53.
[http://dx.doi.org/10.1001/jama.289.24.3243] [PMID: 12824205]
[29]
Staff P. Physicians’ desk reference. PDR Network 2011.
[30]
Berek G, Berek DL. Berek & Novak’s gynecology. (15th ed.). Philadelphia: Lippincott Williams and Wilkins 2012; pp. 1109-32.
[31]
Jayagopal V, Albertazzi P, Kilpatrick ES, et al. Beneficial effects of soy phytoestrogen intake in postmenopausal women with type 2 diabetes. Diabetes Care 2002; 25(10): 1709-14.
[http://dx.doi.org/10.2337/diacare.25.10.1709] [PMID: 12351466]
[32]
Emami A, Fasihi SH, Mehregan I. PDR for Herbal Medicines 4th ed. International Kindle Paperwhite. Available from: https://www.amazon.com/PDR-Herbal-Medicines-Thomson-Healthcare/dp/1563636786
[33]
Karimian K. Hot flashes from menopause and herbal medicine in Iran: A systematic review. Eur J Obstet Gynecol Reprod Biol 2014; 17(111): 1-11.
[34]
Nestel PJ, Pomeroy S, Kay S, et al. Isoflavones from red clover improve systemic arterial compliance but not plasma lipids in menopausal women. J Clin Endocrinol Metab 1999; 84(3): 895-8.
[http://dx.doi.org/10.1210/jc.84.3.895] [PMID: 10084567]
[35]
Atkinson C, Compston JE, Day NE, Dowsett M, Bingham SA. The effects of phytoestrogen isoflavones on bone density in women: A double-blind, randomized, placebo-controlled trial. Am J Clin Nutr 2004; 79(2): 326-33.
[http://dx.doi.org/10.1093/ajcn/79.2.326] [PMID: 14749241]
[36]
Salvador R. Herbal Medicine: HOPS. Can Pharm J 1994; 127(4): 203-4.
[37]
Chadwick LR, Pauli GF, Farnsworth NR. The pharmacognosy of Humulus lupulus L. (hops) with an emphasis on estrogenic properties. Phytomedicine 2006; 13(1-2): 119-31.
[http://dx.doi.org/10.1016/j.phymed.2004.07.006] [PMID: 16360942]
[38]
Polu P, Nayanabhirama U, Khan S. Herbal medicinal plants as anticancer agents. Ann Phytomed 2015; 4(1): 37-45.
[39]
Cornish SM, Chilibeck PD, Paus-Jennsen L, et al. A randomized controlled trial of the effects of flaxseed lignan complex on metabolic syndrome composite score and bone mineral in older adults. Appl Physiol Nutr Metab 2009; 34(2): 89-98.
[http://dx.doi.org/10.1139/H08-142] [PMID: 19370038]
[40]
Wittkowsky AK. Drug interactions update: Drugs, herbs, and oral anticoagulation. J Thromb Thrombolysis 2001; 12(1): 67-71.
[http://dx.doi.org/10.1023/A:1012742628628] [PMID: 11711691]
[41]
Nahidi F, Zare E, Mojab F, Majd HA. Effects of licorice root extract on the number of nocturnal hot flashes in menopausal women. ANS Adv Nurs Sci 2010; 19(67): 541-8.
[42]
Prilepskaya VN, Ledina AV, Tagiyeva AV, Revazova FS. Vitex agnus castus: Successful treatment of moderate to severe premenstrual syndrome. Maturitas 2006; 55: S55-63.
[http://dx.doi.org/10.1016/j.maturitas.2006.06.017]
[43]
Webster D, Lu J, Chen S-N, Farnsworth N, Wang ZJ. Activation of the μ-opiate receptor by Vitex agnus-castus methanol extracts: Implication for its use in PMS. J Ethnopharmacol 2006; 106(2): 216-2121.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version2.2sRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[00:14:03] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[00:14:05] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[00:14:05] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[00:14:05] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (117ms)time
  • Application (2.09s)time
  • 1 x Application (94.7%)
    2.09s
    1 x Booting (5.3%)
    117ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    36 statements were executed, 4 of which were duplicates, 32 unique. Show only duplicated77.53ms
    • 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 ('59226591','',1,1740528845,1740528845) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740528845
      1.1msalphaeurekaselec_live_10_06_2022UserAccessCheck.php#24
      Backtrace
      • 11. middleware::check_user_access:24
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('59226591','/article/132131',1,1740528845,1740528845)
      150μ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 >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) 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 >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) 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 >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) 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 >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) 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 >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) 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 >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59226591 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59226591) limit 1
      12.27msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59226591
      • 1: 59226591
      • 2: 59226591
      • 3: 59226591
      • 4: 59226591
      • 5: 59226591
      • 6: 59226591
      • 7: 59226591
      • 8: 59226591
      • 9: 59226591
      • 10: 59226591
      • 11: 59226591
      • 12: 59226591
      • 13: 59226591
      • 14: 59226591
      • 15: 59226591
      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=132131
      620μ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` = 156 limit 1
      710μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 156
      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=156) and sj.journal_id!=156 group by `j`.`nid`) as `aggregate_table`
      640μ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=156) and sj.journal_id!=156 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      600μ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=156) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      4.16msalphaeurekaselec_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=156) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      3.32msalphaeurekaselec_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` = '132131'
      180μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 132131
      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` = '132131'
      2.06msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 132131
      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` = '132131' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      4.61msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 132131
      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
      250μ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 = 156 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      23.58msalphaeurekaselec_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 = 156 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      4.71msalphaeurekaselec_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 = 156 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      2.76msalphaeurekaselec_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` = 132131 limit 1
      170μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 132131
      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 = 132131 and content_type = 'article' order by status desc limit 1
      200μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 217412 limit 1
      190μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 217412
      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
      190μ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` = 'CTM' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      240μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CTM
      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 = '132131' 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) )
      320μ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 = '12728' 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) )
      260μ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 = '3426' 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) )
      240μ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 <= 59226591 and j.to_ip >=59226591 )) and ((j.from_date <= 1740528845 and j.to_date >= 1740528845 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3426) 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 <= 59226591 and j.to_ip >=59226591 )) and ((j.from_date <= 1740528845 and j.to_date >= 1740528845 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3426) 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 <= 59226591 and j.to_ip >=59226591 )) and ((j.from_date <= 1740528845 and j.to_date >= 1740528845 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3426)
      6.68msalphaeurekaselec_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 <= 59226591 and j.to_ip >=59226591 )) and ((j.from_date <= 1740528845 and j.to_date >= 1740528845 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12728) 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 <= 59226591 and j.to_ip >=59226591 )) and ((j.from_date <= 1740528845 and j.to_date >= 1740528845 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12728) 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 <= 59226591 and j.to_ip >=59226591 )) and ((j.from_date <= 1740528845 and j.to_date >= 1740528845 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12728)
      540μ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 <= 59226591 and j.to_ip >=59226591 )) and ((j.from_date <= 1740528845 and j.to_date >= 1740528845 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 132131) 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 <= 59226591 and j.to_ip >=59226591 )) and ((j.from_date <= 1740528845 and j.to_date >= 1740528845 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 132131) 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 <= 59226591 and j.to_ip >=59226591 )) and ((j.from_date <= 1740528845 and j.to_date >= 1740528845 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 132131)
      530μ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` < '9' and is_uploaded = 1 and issue_id = 12728 order by cast(first_page as SIGNED) desc limit 1
      470μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 9
      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` > '20' and is_uploaded = 1 and issue_id = 12728 order by cast(first_page as SIGNED) asc limit 1
      390μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 20
      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'
      180μ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
      170μ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` = 132131 limit 1
      2.31msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 132131
      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` = 156 and `b`.`banner_from_date` <= 1740528845 and `b`.`banner_to_date` >= 1740528845 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.08msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 156
      • 3: 1740528845
      • 4: 1740528845
      • 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` = 156 and `b`.`banner_from_date` <= 1740528845 and `b`.`banner_to_date` >= 1740528845 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.04msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 156
      • 3: 1740528845
      • 4: 1740528845
      • 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='9c0fb39ee6ce5b90167bf99f64f34237'
      190μ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
        bGxEhi5DRYsaCGOAmTmp9smruMA7tc3N71Mnltwj
        uc_cart_id
        9c0fb39ee6ce5b90167bf99f64f34237
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/132131" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/132131
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 26 Feb 2025 00:14:05 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImhrME01NGR2Vyt6SjluQlNrMk8vOXc9PSIsInZhbHVlIjoiajBTYVZXclhXNXZ5czhBaytJRDVXSDg4VElPNVEyck1yU2o0M1BkazN6M1VFME5oVkJEUDR1Qk9MdjZaVmRlM2grc3JUYUtQcWFKZkNhM2hGa1V3c1dXdXU5MVNCdm91RlpoTGgvMEpQZHcxR3VjQklEYVlNenRMTVI1NUhkOWsiLCJtYWMiOiIzNzc4NDhkNDBiYTQyZDdjNjgzNzdkMzhmOTg5NDM5NDhhMzliYmRhNTY0MzkyOWQxNTMwZjg1NzVhMjAxNTczIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 12:14:05 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImhrME01NGR2Vyt6SjluQlNrMk8vOXc9PSIsInZhbHVlIjoiajBTYVZXclhXNXZ5czhBaytJRDVXSDg4VElPNVEyck1yU2o0M1BkazN6M1VFME5oVkJEUDR1Qk9MdjZaVmRlM2grc3JUY" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ii9nQmVKN3N0MHpKb3IwZFpka0NKQkE9PSIsInZhbHVlIjoiOVhJQnhOd2txWkQvVnFuWjVCQjZrZUpNVlVIZzJCdjA4bDVTdjJjUzdUY3hBRGljREw0Wk5HRnlBMCtSSktUZXlDNjl6eG14RXdad0F5dzg3MlBPNXZOa3BVUTZaWHJVWEZoc2N0akNWUjdFaGJjU1orTW5mTGhDMlRlOFpXTDciLCJtYWMiOiJjZmI4MGUyYTFjYWE0YTI4MzliMzJmNTAzM2IwNTFlZTFmZWEwMzNlNzdkMzBjNjJmMGIzNjhhNjg1NGYyYjUyIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ii9nQmVKN3N0MHpKb3IwZFpka0NKQkE9PSIsInZhbHVlIjoiOVhJQnhOd2txWkQvVnFuWjVCQjZrZUpNVlVIZzJCdjA4bDVTdjJjUzdUY3hBRGljREw0Wk5HRnl" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImhrME01NGR2Vyt6SjluQlNrMk8vOXc9PSIsInZhbHVlIjoiajBTYVZXclhXNXZ5czhBaytJRDVXSDg4VElPNVEyck1yU2o0M1BkazN6M1VFME5oVkJEUDR1Qk9MdjZaVmRlM2grc3JUYUtQcWFKZkNhM2hGa1V3c1dXdXU5MVNCdm91RlpoTGgvMEpQZHcxR3VjQklEYVlNenRMTVI1NUhkOWsiLCJtYWMiOiIzNzc4NDhkNDBiYTQyZDdjNjgzNzdkMzhmOTg5NDM5NDhhMzliYmRhNTY0MzkyOWQxNTMwZjg1NzVhMjAxNTczIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 12:14:05 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImhrME01NGR2Vyt6SjluQlNrMk8vOXc9PSIsInZhbHVlIjoiajBTYVZXclhXNXZ5czhBaytJRDVXSDg4VElPNVEyck1yU2o0M1BkazN6M1VFME5oVkJEUDR1Qk9MdjZaVmRlM2grc3JUY" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ii9nQmVKN3N0MHpKb3IwZFpka0NKQkE9PSIsInZhbHVlIjoiOVhJQnhOd2txWkQvVnFuWjVCQjZrZUpNVlVIZzJCdjA4bDVTdjJjUzdUY3hBRGljREw0Wk5HRnlBMCtSSktUZXlDNjl6eG14RXdad0F5dzg3MlBPNXZOa3BVUTZaWHJVWEZoc2N0akNWUjdFaGJjU1orTW5mTGhDMlRlOFpXTDciLCJtYWMiOiJjZmI4MGUyYTFjYWE0YTI4MzliMzJmNTAzM2IwNTFlZTFmZWEwMzNlNzdkMzBjNjJmMGIzNjhhNjg1NGYyYjUyIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ii9nQmVKN3N0MHpKb3IwZFpka0NKQkE9PSIsInZhbHVlIjoiOVhJQnhOd2txWkQvVnFuWjVCQjZrZUpNVlVIZzJCdjA4bDVTdjJjUzdUY3hBRGljREw0Wk5HRnl" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "bGxEhi5DRYsaCGOAmTmp9smruMA7tc3N71Mnltwj" "uc_cart_id" => "9c0fb39ee6ce5b90167bf99f64f34237" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/132131" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-26 00:14:05GET/article/132131414361