Generic placeholder image

Letters in Functional Foods

Editor-in-Chief

ISSN (Print): 2666-9390
ISSN (Online): 2666-9404

Mini-Review Article

Fruits of Emblica officinalis Linn. and its Phytochemicals in the Prevention of Ethanol-induced Hepatotoxicity: A Mini-Review

Author(s): Manjeshwar Shrinath Baliga*, Vijaya Marakala, Raymond Anthony and Thomas George

Volume 1, 2024

Published on: 22 January, 2024

Article ID: e220124225928 Pages: 6

DOI: 10.2174/0126669390257953231101111549

Price: $65

Abstract

Excessive alcohol consumption over time is one of the primary causes of liver disease and death globally. Because there is no effective treatment, the situation has become more complicated, and the emphasis has shifted to the use of alternative and complementary medicine to treat liver problems. Herbs with dietary use have played an important part in the treatment of liver diseases since antiquity. Amla or Indian gooseberry, scientifically known as Phyllanthus emblica or Emblica officinalis, is a fruiting plant of the Phyllanthaceae family that is used in a variety of traditional and folk medical systems. The fruits have both dietary and medicinal value and are used to prevent chemical-induced hepatocarcinogenesis and reduce experimentally induced hyperlipidemia and metabolic syndrome in laboratory animals. They also have hepatoprotective effects against a variety of hepatotoxins such as heavy metals, iron overload, ochratoxins, hexachlorocyclohexane, carbon tetrachloride, therapeutic drugs such as paracetamol, and antitubercular. Amla fruits and phytochemicals such as quercetin, gallic acid, ellagic acid, and kaempferol are known to reduce ethanol-induced liver damage, and mechanistic studies have shown that the beneficial effects of these phytochemicals are mediated in part by free radical scavenging, antioxidant, and anti-inflammatory effects. This review examines the positive effects of amla fruit and its phytochemicals for the first time, as well as the mechanisms underlying the protective effects.

[1]
Ghany MG, Hoofnagle JH. Approach to the Patient with Liver Disease.Harrison’s Principles of Internal Medicine, 20e. New York, NY: McGraw-Hill Education 2018.
[2]
Shivashankara AR, Azmidah A, Haniadka R, Rai MP, Arora R, Baliga MS. Dietary agents in the prevention of alcohol-induced hepatotoxicty: Preclinical observations. Food Funct 2012; 3(2): 101-9.
[http://dx.doi.org/10.1039/C1FO10170F] [PMID: 22119904]
[3]
Saberi B, Dadabhai AS, Jang YY, Gurakar A, Mezey E. Current Management of Alcoholic Hepatitis and Future Therapies. J Clin Transl Hepatol 2016; 4(2): 113-22.
[PMID: 27350941]
[4]
Albillos A, de Gottardi A, Rescigno M. The gut-liver axis in liver disease: Pathophysiological basis for therapy. J Hepatol 2020; 72(3): 558-77.
[http://dx.doi.org/10.1016/j.jhep.2019.10.003] [PMID: 31622696]
[5]
Szabo G, Petrasek J. Gut–liver axis and sterile signals in the development of alcoholic liver disease. Alcohol Alcohol 2017; 52(4): 414-24.
[http://dx.doi.org/10.1093/alcalc/agx025] [PMID: 28482064]
[6]
Subramaniyan V, Chakravarthi S, Jegasothy R, et al. Alcohol-associated liver disease: A review on its pathophysiology, diagnosis and drug therapy. Toxicol Rep 2021; 8: 376-85.
[http://dx.doi.org/10.1016/j.toxrep.2021.02.010] [PMID: 33680863]
[7]
Guo FF, Xiao M, Wang SY, Zeng T, Cheng L, Xie Q. Downregulation of mitogen-activated protein kinases (MAPKs) in chronic ethanol-induced fatty liver. Toxicol Mech Methods 2020; 30(6): 407-16.
[http://dx.doi.org/10.1080/15376516.2020.1747126] [PMID: 32237978]
[8]
Wen B, Zhang C, Zhou J, et al. Targeted treatment of alcoholic liver disease based on inflammatory signalling pathways. Pharmacol Ther 2021; 222: 107752.
[http://dx.doi.org/10.1016/j.pharmthera.2020.107752] [PMID: 33253739]
[9]
You M, Jogasuria A, Lee K, et al. Signal Transduction Mechanisms of Alcoholic Fatty Liver Disease: Emer ging Role of Lipin-1. Curr Mol Pharmacol 2017; 10(3): 226-36.
[http://dx.doi.org/10.2174/1874467208666150817112109] [PMID: 26278388]
[10]
Thilakchand KR, Mathai RT, Simon P, Ravi RT, Baliga-Rao MP, Baliga MS. Hepatoprotective properties of the Indian gooseberry (Emblica officinalis Gaertn): A review. Food Funct 2013; 4(10): 1431-41.
[http://dx.doi.org/10.1039/c3fo60237k] [PMID: 23978895]
[11]
Baliga MS, Dsouza JJ. Amla (Emblica officinalis Gaertn), a wonder berry in the treatment and prevention of cancer. Eur J Cancer Prev 2011; 20(3): 225-39.
[http://dx.doi.org/10.1097/CEJ.0b013e32834473f4] [PMID: 21317655]
[12]
Gulati RK, Agarwal S, Agrawal SS. Hepatoprotective studies on Phyllanthus emblica Linn. and quercetin. Indian J Exp Biol 1995; 33(4): 261-8.
[PMID: 7558182]
[13]
Reddy VD, Padmavathi P, Varadacharyulu NC. Emblica officinalis protects against alcohol-induced liver mitochondrial dysfunction in rats. J Med Food 2009; 12(2): 327-33.
[http://dx.doi.org/10.1089/jmf.2007.0694] [PMID: 19459733]
[14]
Pramyothin P, Samosorn P, Poungshompoo S, Chaichantipyuth C. The protective effects of Phyllanthus emblica Linn. extract on ethanol induced rat hepatic injury. J Ethnopharmacol 2006; 107(3): 361-4.
[http://dx.doi.org/10.1016/j.jep.2006.03.035] [PMID: 16750340]
[15]
Yao P, Nussler A, Liu L, et al. Quercetin protects human hepatocytes from ethanol-derived oxidative stress by inducing heme oxygenase-1 via the MAPK/Nrf2 pathways. J Hepatol 2007; 47(2): 253-61.
[http://dx.doi.org/10.1016/j.jhep.2007.02.008] [PMID: 17433488]
[16]
Liu S, Hou W, Yao P, et al. Quercetin protects against ethanol-induced oxidative damage in rat primary hepatocytes. Toxicol In Vitro 2010; 24(2): 516-22.
[http://dx.doi.org/10.1016/j.tiv.2009.03.006] [PMID: 19327393]
[17]
Chen X. Protective effects of quercetin on liver injury induced by ethanol. Pharmacogn Mag 2010; 6(22): 135-41.
[http://dx.doi.org/10.4103/0973-1296.62900] [PMID: 20668581]
[18]
Molina MF, Sanchez-Reus I, Iglesias I, Benedi J. Quercetin, a flavonoid antioxidant, prevents and protects against ethanol-induced oxidative stress in mouse liver. Biol Pharm Bull 2003; 26(10): 1398-402.
[http://dx.doi.org/10.1248/bpb.26.1398] [PMID: 14519943]
[19]
Tang Y, Gao C, Xing M, et al. Quercetin prevents ethanol-induced dyslipidemia and mitochondrial oxidative damage. Food Chem Toxicol 2012; 50(5): 1194-200.
[http://dx.doi.org/10.1016/j.fct.2012.02.008] [PMID: 22365892]
[20]
Tang Y, Li Y, Yu H, et al. Quercetin attenuates chronic ethanol hepatotoxicity: Implication of “free” iron uptake and release. Food Chem Toxicol 2014; 67: 131-8.
[http://dx.doi.org/10.1016/j.fct.2014.02.022] [PMID: 24569067]
[21]
Li Y, Chen M, Xu Y, et al. Iron-Mediated Lysosomal Membrane Permeabilization in Ethanol-Induced Hepatic Oxidative Damage and Apoptosis: Protective Effects of Quercetin. Oxid Med Cell Longev 2016; 2016: 1-15.
[http://dx.doi.org/10.1155/2016/4147610] [PMID: 27057276]
[22]
Zhu M, Zhou X, Zhao J. Quercetin prevents alcohol induced liver injury through targeting of PI3K/Akt/nuclear factor κB and STAT3 signaling pathway. Exp Ther Med 2017; 14(6): 6169-75.
[http://dx.doi.org/10.3892/etm.2017.5329] [PMID: 29285175]
[23]
Kartkaya K, Oğlakçı A, Şentürk H, Bayramoğlu G, Canbek M, Kanbak G. Investigation of the possible protective role of gallic acid on paraoxanase and arylesterase activities in livers of rats with acute alcohol intoxication. Cell Biochem Funct 2013; 31(3): 208-13.
[http://dx.doi.org/10.1002/cbf.2874] [PMID: 22945768]
[24]
Zhou Y, Jin H, Wu Y, Chen L, Bao X, Lu C. Gallic acid protects against ethanol-induced hepatocyte necroptosis via an NRF2-dependent mechanism. Toxicol In Vitro 2019; 57: 226-32.
[http://dx.doi.org/10.1016/j.tiv.2019.03.008] [PMID: 30853489]
[25]
Devipriya N, Sudheer AR, Vishwanathan P, Menon VP. Modulatory potential of ellagic acid, a natural plant polyphenol on altered lipid profile and lipid peroxidation status during alcohol-induced toxicity: A pathohistological study. J Biochem Mol Toxicol 2008; 22(2): 101-12.
[http://dx.doi.org/10.1002/jbt.20226] [PMID: 18418896]
[26]
Devipriya N, Sudheer AR, Menon VP. Dose-response effect of ellagic acid on circulatory antioxidants and lipids during alcohol-induced toxicity in experimental rats. Fundam Clin Pharmacol 2007; 21(6): 621-30.
[http://dx.doi.org/10.1111/j.1472-8206.2007.00551.x] [PMID: 18034663]
[27]
Devipriya N, Sudheer AR, Srinivasan M, Menon VP. Effect of Ellagic Acid, a Plant Polyphenol, on Fibrotic Markers (MMPs and TIMPs) during Alcohol-Induced Hepatotoxicity. Toxicol Mech Methods 2007; 17(6): 349-56.
[http://dx.doi.org/10.1080/15376510601077003] [PMID: 20020958]
[28]
Girish C, Pradhan SC. Drug development for liver diseases: Focus on picroliv, ellagic acid and curcumin. Fundam Clin Pharmacol 2008; 22(6): 623-32.
[http://dx.doi.org/10.1111/j.1472-8206.2008.00618.x] [PMID: 19049667]
[29]
Sohn EH, Koo HJ, Hang DTT, et al. Protective effects of ellagic acid on ethanol-induced toxicity in hepatic HepG2 cells. Mol Cell Toxicol 2013; 9(3): 249-56.
[http://dx.doi.org/10.1007/s13273-013-0032-1]
[30]
Calderón-Montaño JM, Burgos-Morón E, Pérez-Guerrero C, López-Lázaro M. A review on the dietary flavonoid kaempferol. Mini Rev Med Chem 2011; 11(4): 298-344.
[http://dx.doi.org/10.2174/138955711795305335] [PMID: 21428901]
[31]
Shakya G, Manjini S, Hoda M, Rajagopalan R. Hepatoprotective role of kaempferol during alcohol- and ΔPUFA-induced oxidative stress. J Basic Clin Physiol Pharmacol 2014; 25(1): 73-9.
[http://dx.doi.org/10.1515/jbcpp-2013-0051] [PMID: 23893680]
[32]
Zhou B, Jiang Z, Li X, Zhang X. Kaempferol’s Protective Effect on Ethanol-Induced Mouse Primary Hepatocytes Injury Involved in the Synchronous Inhibition of SP1, Hsp70 and CYP2E1. Am J Chin Med 2018; 46(5): 1093-110.
[http://dx.doi.org/10.1142/S0192415X1850057X] [PMID: 29976085]
[33]
Chen J, Xuan Y, Luo M, et al. Kaempferol alleviates acute alcoholic liver injury in mice by regulating intestinal tight junction proteins and butyrate receptors and transporters. Toxicology 2020; 429: 152338.
[http://dx.doi.org/10.1016/j.tox.2019.152338] [PMID: 31785310]
[34]
Sairam K, Rao ChV, Babu MD, Kumar KV, Agrawal VK, K Goel RK. Antiulcerogenic effect of methanolic extract of Emblica officinalis: An experimental study. J Ethnopharmacol 2002; 82(1): 1-9.
[http://dx.doi.org/10.1016/S0378-8741(02)00041-7] [PMID: 12169398]
[35]
Al-Rehaily AJ, Al-Howiriny TS, Al-Sohaibani MO, Rafatullah S. Gastroprotective effects of ‘Amla’ Emblica officinalis on in vivo test models in rats. Phytomedicine 2002; 9(6): 515-22.
[http://dx.doi.org/10.1078/09447110260573146] [PMID: 12403160]
[36]
Aruna R, Geetha A, Suguna P, Suganya V. Rutin rich Emblica officinalis Geart. fruit extract ameliorates inflammation in the pancreas of rats subjected to alcohol and cerulein administration. J Complement Integr Med 2014; 11(1): 9-18.
[http://dx.doi.org/10.1515/jcim-2013-0023] [PMID: 24516008]
[37]
Anto EJ, Syahputra RA, Silitonga HA, Situmorang PC, Nugaraha SE. Oral acute toxicity study extract ethanol of balakka fruit (Phyllanthus emblica). Pharmacia 2022; 69(1): 187-94.
[http://dx.doi.org/10.3897/pharmacia.69.e81280]
[38]
Antony B, Benny M, Kaimal TNB. A Pilot clinical study to evaluate the effect of Emblica officinalis extract (Amlamax™) on markers of systemic inflammation and dyslipidemia. Indian J Clin Biochem 2008; 23(4): 378-81.
[http://dx.doi.org/10.1007/s12291-008-0083-6] [PMID: 23105791]
[39]
Chen TS, Liou SY, Chang YL. Supplementation of Emblica officinalis (Amla) extract reduces oxidative stress in uremic patients. Am J Chin Med 2009; 37(1): 19-25.
[http://dx.doi.org/10.1142/S0192415X09006680] [PMID: 19222108]
[40]
Karkon Varnosfaderani S, Hashem-Dabaghian F, Amin G, et al. Efficacy and safety of Amla (Phyllanthus emblica L.) in non-erosive reflux disease: A double-blind, randomized, placebo-controlled clinical trial. J Integr Med 2018; 16(2): 126-31.
[http://dx.doi.org/10.1016/j.joim.2018.02.008] [PMID: 29526236]
[41]
Khanna S, Das A, Spieldenner J, Rink C, Roy S. Supplementation of a standardized extract from Phyllanthus emblica improves cardiovascular risk factors and platelet aggregation in overweight/class-1 obese adults. J Med Food 2015; 18(4): 415-20.
[http://dx.doi.org/10.1089/jmf.2014.0178] [PMID: 25756303]
[42]
Pingali U, Fatima N, Pilli R. Evaluation of Phyllanthus emblica extract on cold pressor induced cardiovascular changes in healthy human subjects. Pharmacognosy Res 2014; 6(1): 29-35.
[http://dx.doi.org/10.4103/0974-8490.122914] [PMID: 24497739]
[43]
Akhtar MS, Ramzan A, Ali A, Ahmad M. Effect of Amla fruit (Emblica officinalis Gaertn.) on blood glucose and lipid profile of normal subjects and type 2 diabetic patients. Int J Food Sci Nutr 2011; 62(6): 609-16.
[http://dx.doi.org/10.3109/09637486.2011.560565] [PMID: 21495900]
[44]
Kapoor MP, Suzuki K, Derek T, Ozeki M, Okubo T. Clinical evaluation of Emblica officinalis Gatertn (Amla) in healthy human subjects: Health benefits and safety results from a randomized, double-blind, crossover placebo-controlled study. Contemp Clin Trials Commun 2020; 17: 100499.
[http://dx.doi.org/10.1016/j.conctc.2019.100499] [PMID: 31890983]
[45]
Usharani P, Merugu PL, Nutalapati C. Evaluation of the effects of a standardized aqueous extract of Phyllanthus emblica fruits on endothelial dysfunction, oxidative stress, systemic inflammation and lipid profile in subjects with metabolic syndrome: A randomised, double blind, placebo controlled clinical study. BMC Complement Med Ther 2019; 19: 97.
[http://dx.doi.org/10.1186/s12906-019-2509-5]
[46]
Upadya H, Prabhu S, Prasad A, Subramanian D, Gupta S, Goel A. A randomized, double blind, placebo controlled, multicenter clinical trial to assess the efficacy and safety of Emblica officinalis extract in patients with dyslipidemia. BMC Complement Altern Med 2019; 19(1): 27.
[http://dx.doi.org/10.1186/s12906-019-2430-y] [PMID: 30670010]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version215msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[23:27:22] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[23:27:22] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[23:27:22] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[23:27:22] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[23:27:22] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (95.57ms)time
  • Application (119ms)time
  • 1 x Application (55.47%)
    119ms
    1 x Booting (44.52%)
    95.57ms
    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 duplicated47.41ms
    • 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 ('51368230','',1,1739834842,1739834842) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739834842
      920μ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 ('51368230','/article/137629',1,1739834842,1739834842)
      190μ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 >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) 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 >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) 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 >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) 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 >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) 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 >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) 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 >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51368230 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51368230) limit 1
      13.21msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51368230
      • 1: 51368230
      • 2: 51368230
      • 3: 51368230
      • 4: 51368230
      • 5: 51368230
      • 6: 51368230
      • 7: 51368230
      • 8: 51368230
      • 9: 51368230
      • 10: 51368230
      • 11: 51368230
      • 12: 51368230
      • 13: 51368230
      • 14: 51368230
      • 15: 51368230
      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=137629
      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` = 212 limit 1
      390μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 212
      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=212) and sj.journal_id!=212 group by `j`.`nid`) as `aggregate_table`
      580μ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=212) and sj.journal_id!=212 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      510μ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=212) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      800μsalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 16. app/Models/Subject.php:220
      • 17. app/Http/Controllers/ArticleController.php:2518
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=212) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      760μ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` = '137629'
      220μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 137629
      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` = '137629'
      450μsalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 137629
      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` = '137629' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      740μsalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 137629
      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
      470μ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 = 212 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      13.64msalphaeurekaselec_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 = 212 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      690μsalphaeurekaselec_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 = 212 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      590μsalphaeurekaselec_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` = 137629 limit 1
      190μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 137629
      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 = 137629 and content_type = 'article' order by status desc limit 1
      290μ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` = 225928 limit 1
      230μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 225928
      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
      250μ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` = 'LFF' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      290μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: LFF
      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 = '137629' 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) )
      500μ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 = '12541' 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 = '3278' 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) )
      360μ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 <= 51368230 and j.to_ip >=51368230 )) and ((j.from_date <= 1739834842 and j.to_date >= 1739834842 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3278) 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 <= 51368230 and j.to_ip >=51368230 )) and ((j.from_date <= 1739834842 and j.to_date >= 1739834842 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3278) 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 <= 51368230 and j.to_ip >=51368230 )) and ((j.from_date <= 1739834842 and j.to_date >= 1739834842 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3278)
      2.5msalphaeurekaselec_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 <= 51368230 and j.to_ip >=51368230 )) and ((j.from_date <= 1739834842 and j.to_date >= 1739834842 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12541) 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 <= 51368230 and j.to_ip >=51368230 )) and ((j.from_date <= 1739834842 and j.to_date >= 1739834842 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12541) 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 <= 51368230 and j.to_ip >=51368230 )) and ((j.from_date <= 1739834842 and j.to_date >= 1739834842 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12541)
      730μ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 <= 51368230 and j.to_ip >=51368230 )) and ((j.from_date <= 1739834842 and j.to_date >= 1739834842 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 137629) 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 <= 51368230 and j.to_ip >=51368230 )) and ((j.from_date <= 1739834842 and j.to_date >= 1739834842 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 137629) 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 <= 51368230 and j.to_ip >=51368230 )) and ((j.from_date <= 1739834842 and j.to_date >= 1739834842 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 137629)
      620μ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` < '52' and is_uploaded = 1 and issue_id = 12541 order by cast(first_page as SIGNED) desc limit 1
      460μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 52
      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` > '57' and is_uploaded = 1 and issue_id = 12541 order by cast(first_page as SIGNED) asc limit 1
      420μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 57
      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'
      160μ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` = 137629 limit 1
      2.39msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 137629
      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` = 212 and `b`.`banner_from_date` <= 1739834842 and `b`.`banner_to_date` >= 1739834842 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.11msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 212
      • 3: 1739834842
      • 4: 1739834842
      • 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` = 212 and `b`.`banner_from_date` <= 1739834842 and `b`.`banner_to_date` >= 1739834842 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: 212
      • 3: 1739834842
      • 4: 1739834842
      • 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='dd8e9c76f339fe81aa5ff56d79804e67'
      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
        rQOumzoYaQB7Pqt8pHUipA97Sbb1JeHwRH4MUvOX
        uc_cart_id
        dd8e9c76f339fe81aa5ff56d79804e67
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/article/137629" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/137629
        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:17 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6Iis3NW9scVVUUC9RVmdsaUh5SmU0d0E9PSIsInZhbHVlIjoid2RJQnRGNThsRmJDeHFBY3BuSlZ4SHVrTUJUTzN6K0lmVklkOEtMSE0zYz0iLCJtYWMiOiI4ODRjMWU0ODY0N2Y1NDQyMjE2ZjA0MWQwNTNmNzMwYmE0YWQ2NmNiZDdiMDRkMTQ5Yjk3YmZjODg4MzBmNTI2IiwidGFnIjoiIn0%3D; XSRF-TOKEN=eyJpdiI6IitWbm5uc2k0Y09pa0U0bVpZSTdoTnc9PSIsInZhbHVlIjoiNWdDNU1UN3VuMUU4NFl0UWxQL0dwRWdUTUpqYTNSc2Z6dE5kVHIvWnFrdTNVbTNBY2NEQUdCVlF3SHlYSVFwQ2xnQ2tERm5xK3RrcERjenE3Ym9Od1packpIdkR5MjJsVTV2WUJEUDhmZzc4NVFqWnBORnMvTWFnV2NFUHR2ZW4iLCJtYWMiOiIyMTM4ZWFhZjk0OGU5ZjRjZjM4ZDBjNTBiYzAxZDc3MDExNDcxZDg3ZGYyMTI4NzhiODc0NzZhZDhlNTg5MWUxIiwidGFnIjoiIn0%3D; alphaeurekaselectnet_session=eyJpdiI6IkUxNUNoOUQ4L2RRZGhmQXpGNXB2T1E9PSIsInZhbHVlIjoiRWsxSVA4dzFiM3FleEZTZ2hRSkpaQ2s2NkxVWmdMRDVQV1YrK3d2SFJHUm81WTh4bnEzU21ubnlrYUF2OW4vQk9oUDlSVEI2TThNRndOVGVUdVpUYUNkYXV5TnVaYm9EdVFRSUl1Q1pOc04vSmxNKzdZZU9LUjZUTEpSeVZTT1EiLCJtYWMiOiIxZjExMzk1MzI1MzgzNTc2ZjQzZDVlYTJlZmVlOGViY2Y2MTMzYTdjMDI0ZTljZDRmMTc3ZTZlMjQ3NjBiNzMyIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6Iis3NW9scVVUUC9RVmdsaUh5SmU0d0E9PSIsInZhbHVlIjoid2RJQnRGNThsRmJDeHFBY3BuSlZ4SHVrTUJUTzN6K0lmVklkOEtMSE0zYz0iLCJtYWMiOiI4ODRjMWU0ODY0N2Y1" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "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" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_cookies
        0 of 0
        array:3 [ "wayfindertarget" => null "XSRF-TOKEN" => "rQOumzoYaQB7Pqt8pHUipA97Sbb1JeHwRH4MUvOX" "alphaeurekaselectnet_session" => "1B8gG5yFYXFYNejhl0tYi4u1fVYep0jgf1uo7pd2" ]
        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:27:22 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjI1MU1UK2lxWHVCekJIeUlML0xTaHc9PSIsInZhbHVlIjoiVW5Uc0Fmb0FHQXV1MmFrQUFHK0RFVDYxWnpVZmhna21KREpiK1ZVOHFqak9YLzd4UGw5T1p1Tnl2MlM0dUhBVHFqdkQ3NnQxbWJYakxNa0dpc1NWQVlMbEFqVnJEYzNaSkh4WWlwOG0xcmFyUHlCc3JITDFiQjNURVNlL3oyKzgiLCJtYWMiOiI3NGVmYWEwZjQyYjVjZWY4MmY2NmY5ZjQ5ZDY1OGI1Y2RmYWRlYzQ3MGFlMGZiMDY3NGVjYzM0NTgxM2EyNWU0IiwidGFnIjoiIn0%3D; expires=Thu, 20 Feb 2025 11:27:22 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjI1MU1UK2lxWHVCekJIeUlML0xTaHc9PSIsInZhbHVlIjoiVW5Uc0Fmb0FHQXV1MmFrQUFHK0RFVDYxWnpVZmhna21KREpiK1ZVOHFqak9YLzd4UGw5T1p1Tnl2MlM0dUhBVHFqdkQ3N" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkVPbmo3L21YMmZ2b1dKRDdUWG42WVE9PSIsInZhbHVlIjoiM1hzZlViNHVNS0crdWM1aFZVZkxxVlZ2OVplL01LRWxEM25DenJLcDJ2MDZ6b0xYZTY0OUZyaXBqaUNjZFBpNUQ1N3JtWlR5N2IvdlhOSmdXYmlwc3hleVRmRGNva1dENlJGN0ZoTzJTckpoVG1RWGFhNWwwKzc4UG5PT0t2R3AiLCJtYWMiOiI2ODQ1NmRkOWY2ZmFiYmQ3OTQzNGVkNGQwNjRjNDQwYmI2ZTM3YmRlZThkMTBhOGFjNTAyYTdlNWNjYjEzMWI3IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkVPbmo3L21YMmZ2b1dKRDdUWG42WVE9PSIsInZhbHVlIjoiM1hzZlViNHVNS0crdWM1aFZVZkxxVlZ2OVplL01LRWxEM25DenJLcDJ2MDZ6b0xYZTY0OUZyaXB" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjI1MU1UK2lxWHVCekJIeUlML0xTaHc9PSIsInZhbHVlIjoiVW5Uc0Fmb0FHQXV1MmFrQUFHK0RFVDYxWnpVZmhna21KREpiK1ZVOHFqak9YLzd4UGw5T1p1Tnl2MlM0dUhBVHFqdkQ3NnQxbWJYakxNa0dpc1NWQVlMbEFqVnJEYzNaSkh4WWlwOG0xcmFyUHlCc3JITDFiQjNURVNlL3oyKzgiLCJtYWMiOiI3NGVmYWEwZjQyYjVjZWY4MmY2NmY5ZjQ5ZDY1OGI1Y2RmYWRlYzQ3MGFlMGZiMDY3NGVjYzM0NTgxM2EyNWU0IiwidGFnIjoiIn0%3D; expires=Thu, 20-Feb-2025 11:27:22 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjI1MU1UK2lxWHVCekJIeUlML0xTaHc9PSIsInZhbHVlIjoiVW5Uc0Fmb0FHQXV1MmFrQUFHK0RFVDYxWnpVZmhna21KREpiK1ZVOHFqak9YLzd4UGw5T1p1Tnl2MlM0dUhBVHFqdkQ3N" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkVPbmo3L21YMmZ2b1dKRDdUWG42WVE9PSIsInZhbHVlIjoiM1hzZlViNHVNS0crdWM1aFZVZkxxVlZ2OVplL01LRWxEM25DenJLcDJ2MDZ6b0xYZTY0OUZyaXBqaUNjZFBpNUQ1N3JtWlR5N2IvdlhOSmdXYmlwc3hleVRmRGNva1dENlJGN0ZoTzJTckpoVG1RWGFhNWwwKzc4UG5PT0t2R3AiLCJtYWMiOiI2ODQ1NmRkOWY2ZmFiYmQ3OTQzNGVkNGQwNjRjNDQwYmI2ZTM3YmRlZThkMTBhOGFjNTAyYTdlNWNjYjEzMWI3IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkVPbmo3L21YMmZ2b1dKRDdUWG42WVE9PSIsInZhbHVlIjoiM1hzZlViNHVNS0crdWM1aFZVZkxxVlZ2OVplL01LRWxEM25DenJLcDJ2MDZ6b0xYZTY0OUZyaXB" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "rQOumzoYaQB7Pqt8pHUipA97Sbb1JeHwRH4MUvOX" "uc_cart_id" => "dd8e9c76f339fe81aa5ff56d79804e67" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/article/137629" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-17 23:27:22GET/article/137629514361