Generic placeholder image

Current Drug Metabolism

Editor-in-Chief

ISSN (Print): 1389-2002
ISSN (Online): 1875-5453

Research Article

Chemistry and Antioxidant Potential of Phytoconstituents from Aegle Marmelos Fruit-Shell

Author(s): Ankita Chaubey and Ashok K. Dubey*

Volume 21, Issue 7, 2020

Page: [525 - 533] Pages: 9

DOI: 10.2174/1389200221666200711161056

Price: $65

Abstract

Background: Oxidative stress is among the main causes of metabolic disorders. Hence, there is a need to discover potent antioxidants for therapeutic applications.

Objective: The objective of this study has been to investigate the phytoconstituents of the methanolic extract of the hard shell of Aegle marmelos fruit and their antioxidant potential.

Methods: Methanolic extract was fractionated using different solvents by liquid-liquid extraction. Characterization of the phytoconstituents was done by using phytochemical tests and GC-MS analysis. The free radical scavenging activity, total reducing power, lipid peroxidation inhibition and cell protection assays against oxidative stress were performed with methanolic extract and its fractions.

Results: Therapeutically significant class of compounds, for example, polyphenols, glycosides and sterols were revealed in the hard-shell extract. Differential separation of compounds was achieved by liquid-liquid extraction using different solvents. Six compounds: 4-Hydroxybenzeneacetic acid; 5-Oxo-pyrrolidine-2-carboxylic acid methyl ester; 1-[3-Methyl-3-Butenyl] Pyrrolidine; Trans-sinapyl alcohol; 5-[Hydroxymethyl]-2-furaldehyde and 2,4- Dihydroxy-2,5-dimethyl-3[2H]-furan-3-one, identified in the fruit-shell extract, are being reported for the first time from this plant. Strong antioxidant potential of the extract was evident from efficient scavenging of free radicals. The extract also conferred protection to yeast cells against oxidative damage.

Conclusion: Results showed that the hard shell of the Aegle marmelos fruit was a potent source for antioxidant compounds, which can be developed for therapeutic applications in the control and management of metabolic diseases.

Keywords: Oxidative stress, metabolic disorder, antioxidant, free radicals, Aegle marmelos, phytoconstituents.

Graphical Abstract

[1]
Halliwell, B.; Gutterridge, J.M.C. Reactive species and Disease: fact, fiction or filibuster. Free radicals in Biology and Medicine, 4th ed; Oxford University Press: Oxford, 2007.
[2]
Rani, V.; Deep, G.; Singh, R.K.; Palle, K.; Yadav, U.C. Oxidative stress and metabolic disorders: Pathogenesis and therapeutic strategies. Life Sci., 2016, 148, 183-193.
[http://dx.doi.org/10.1016/j.lfs.2016.02.002 ] [PMID: 26851532]
[3]
Indo, H.P.; Yen, H.C.; Nakanishi, I.; Matsumoto, K.; Tamura, M.; Nagano, Y.; Matsui, H.; Gusev, O.; Cornette, R.; Okuda, T.; Minamiyama, Y.; Ichikawa, H.; Suenaga, S.; Oki, M.; Sato, T.; Ozawa, T.; Clair, D.K.St.; Majima, H.J. A mitochondrial superoxide theory for oxidative stress diseases and aging. J. Clin. Biochem. Nutr., 2015, 56(1), 1-7.
[http://dx.doi.org/10.3164/jcbn.14-42 ] [PMID: 25834301]
[4]
Poljsak, B.; Suput, D.; Milisav, I. Achieving the balance between ROS and antioxidants: when to use the synthetic antioxidants. Oxidative. Med. Cell. Longev., 2013, 2013, 1-11.
[5]
Smith, M.A.; Perry, G.; Richey, P.L.; Sayre, L.M.; Anderson, V.E.; Beal, M.F.; Kowall, N. Oxidative damage in Alzheimer’s. Nature, 1996, 382(6587), 120-121.
[http://dx.doi.org/10.1038/382120b0 ] [PMID: 8700201]
[6]
Sen, S.; Chakraborty, R.; Sridhar, C.; Reddy, Y.S.R.; De, B. Free radicals, antioxidants, diseases and phytomedicines: current status and future prospect. Int. J. Pharm. Sci. Rev. Res., 2010, 3(1), 91-100.
[7]
Valko, M.; Leibfritz, D.; Moncol, J.; Cronin, M.T.D.; Mazur, M.; Telser, J. Free radicals and antioxidants in normal physiological functions and human disease. Int. J. Biochem. Cell Biol., 2007, 39(1), 44-84.
[http://dx.doi.org/10.1016/j.biocel.2006.07.001 ] [PMID: 16978905]
[8]
Sanchez, C.M. Methods used to evaluate the free radical scavenging activity in foods and biological system. J Food Sci Tech Int., 2002, 8(3), 121-137.
[http://dx.doi.org/10.1177/1082013202008003770]
[9]
Dhalwal, K.; Shinde, V.M.; Namdeo, A.G.; Mahadik, K.R. Antioxidant profile and HPTLC-densitometric analysis of umbelliferone and psoralen in Aegle marmelos. Pharm. Biol., 2008, 46(4), 266-272.
[http://dx.doi.org/10.1080/13880200701741088]
[10]
Cragg, G.M.; Newman, D.J.; Snader, K.M. Natural products in drug discovery and development. J. Nat. Prod., 1997, 60(1), 52-60.
[http://dx.doi.org/10.1021/np9604893 ] [PMID: 9014353]
[11]
Higgs, R.E.; Zahn, J.A.; Gygi, J.D.; Hilton, M.D. Rapid method to estimate the presence of secondary metabolites in microbial extracts. Appl. Environ. Microbiol., 2001, 67(1), 371-376.
[http://dx.doi.org/10.1128/AEM.67.1.371-376.2001 ] [PMID: 11133468]
[12]
Kaur, C.; Kapoor, H.C. Antioxidants in fruits and vegetables the millenium’s health. Int. J. Food Sci. Technol., 2000, 36(7), 703-725.
[13]
Miliauskas, G.; Venskutonics, P.R.; Beck, V. Screening of radical scavenging activity of some medicinal and aromatic plant extracts. Food Chem., 2004, 85(2), 231-237.
[http://dx.doi.org/10.1016/j.foodchem.2003.05.007]
[14]
Ramchoun, M.; Harnafi, H.; Alem, C.; Benlys, M.; Elrhaffari, L.; Amrani, S. Study on antioxidant and hypolipidemic effects of polyphenol rich extract from Thymus vulgaris and Lavendula multifida. Pharmacogn. Rev., 2009, 1(3), 106-112.
[15]
Pineda-Ramírez, N.; Calzada, F.; Alquisiras-Burgos, I.; Medina-Campos, O.N.; Pedraza-Chaverri, J.; Ortiz-Plata, A.; Pinzón Estrada, E.; Torres, I.; Aguilera, P. Antioxidant properties and protective effects of some species of the annonaceae, lamiaceae, and geraniaceae families against neuronal damage induced by excitotoxicity and cerebral ischemia. Antioxidants, 2020, 9(3), 253, 1-19.,
[16]
Dash, D.K.; Yeligar, V.C.; Nayak, S.S.; Ghosh, T.; Rajalingam, D.; Sengupta, P.; Maiti, B.C.; Maity, T.K. Evaluation of hepatoprotective and antioxidant activity of Ichnocarpus frutescens (Linn.) R.Br. on paracetamol-induced hepatotoxicity in rats. Trop. J. Pharm. Res., 2007, 6, 755-765.
[http://dx.doi.org/10.4314/tjpr.v6i3.14656]
[17]
Yildirim, A.; Oktay, M.; Bulaloulu, V. The antioxidant activity of the leaves of Cydonia vulgaris. Turk. J. Med. Sci., 2001, 31, 23-27.
[18]
Nagulendran, K.; Velavan, S.; Mahesh, R.; Begum, V.H. In vitro antioxidant activity and total polyphenolic content of Cyperus rotundus rhizomes. E-J. Chem., 2007, 4, 440-449.
[http://dx.doi.org/10.1155/2007/903496]
[19]
Patel, P.K.; Sahu, S.; Sahu, L.; Prajapati, N.K.; Dubey, B.K. Aegle marmelos: A review on its medicinal properties. Int. J. Pharm. Phytopharmacol Res., 2012, 1(5), 332-341.
[20]
Behera, P.; Raj, V.J.; Prasad, A.B.; Basavaraju, R. A review on phytochemical and pharmacological values of fruit pulp of Aegle marmelos. Global J Res. Med. Plants & Indigen. Med., 2014, 3(9), 339-348.
[21]
Maity, P.; Hansda, D.; Bandyopadhyay, U.; Mishra, D.K. Biological activities of crude extracts and chemical constituents of Bael, Aegle marmelos (L.). Corr. Indian J. Exp. Biol., 2009, 47(11), 849-861.
[PMID: 20099458]
[22]
Rajadurai, M.; Prince, P.S. Comparative effects of Aegle marmelos extract and alpha-tocopherol on serum lipids, lipid peroxides and cardiac enzyme levels in rats with isoproterenol-induced myocardial infarction. Singapore Med. J., 2005, 46(2), 78-81.
[PMID: 15678289]
[23]
Trease, G.E.; Evans, M.C. Text book of Pharmacognosy, 12th ed; Baillière Tindall: London, 1983.
[24]
Savithramma, N.; Rao, M.L.; Suhrulatha, D. Screening of medicinal plants for secondary metabolites. Middle-East J Sci., 2011, 8(3), 579-584.
[25]
Meda, A.; Lamien, E.C.; Romito, M.; Millogo, J.; Nacoulma, O.G. Determination of the total phenolic, flavonoid and proline contents in Burkina Fasan honey, as well as their radical scavenging activity. Food Chem., 2005, 91(3), 571-577.
[http://dx.doi.org/10.1016/j.foodchem.2004.10.006]
[26]
Srivastava, V.; Singla, R.K.; Dubey, A.K. Inhibition of biofilm and virulence factors of Candida albicans by partially purified secondary metabolites of Streptomyces chrestomyceticus strain ADP4. Curr. Top. Med. Chem., 2018, 18(11), 925-945.
[http://dx.doi.org/10.2174/1568026618666180711154110 ] [PMID: 29992882]
[27]
Mathew, S.; Abraham, T.E. In vitro antioxidant activity and scavenging effects of Cinnamomum verum leaf extract assayed by different methodologies. Food Chem. Toxicol., 2006, 44(2), 198-206.
[http://dx.doi.org/10.1016/j.fct.2005.06.013 ] [PMID: 16087283]
[28]
Singh, N.; Rajini, P.S. Free radical scavenging activity of an aqueous extract of potato peel. Food Chem., 2004, 85(4), 611-616.
[http://dx.doi.org/10.1016/j.foodchem.2003.07.003]
[29]
Kumar, R.S.; Rajkapoor, B.; Perumal, P. Antioxidant activities of Indigofera cassioides Rottl. Ex. DC. using various in vitro assay models. Asian Pac. J. Trop. Biomed., 2012, 2(4), 256-261.
[http://dx.doi.org/10.1016/S2221-1691(12)60019-7 ] [PMID: 23569910]
[30]
Sudha, G.; Janardhanan, A.; Moorthy, A.; Chinnasamy, M.; Gunasekaran, S.; Thimmaraju, A.; Gopalan, J. Comparative study on the antioxidant activity of methanolic and aqueous extracts from the fruiting bodies of an edible mushroom Pleurotus djamor. Food Sci. Biotechnol., 2016, 25(2), 371-377.
[http://dx.doi.org/10.1007/s10068-016-0052-4 ] [PMID: 30263280]
[31]
Kwolek-Mirek, M.; Zadrag-Tecza, R. Comparison of methods used for assessing the viability and vitality of yeast cells. FEMS Yeast Res., 2014, 14(7), 1068-1079.
[http://dx.doi.org/10.1111/1567-1364.12202 ] [PMID: 25154541]
[32]
Mukherjee, P.K. Extraction and Other Downstream Procedures for Evaluation of Herbal Drugs. In: Mukherjee, P.K., Ed. Quality Control and Evaluation of Herbal Drugs: Evaluating Natural Products and Traditional Medicine; Elsevier: New Delhi, 2019, pp. 195-227.
[http://dx.doi.org/10.1016/B978-0-12-813374-3.00006-5]
[33]
Higuchi, R.; Kitamura, Y.; Komori, T. Thermal degradation of glycosides, I. Degradation of typical triterpenoid and steroid glycosides. Liebigs Ann. Chem., 1986, 4, 638-646.
[http://dx.doi.org/10.1002/jlac.198619860405]
[34]
Lou, S.N.; Lin, Y.S.; Hsu, Y.S.; Chiu, E.M.; Ho, C.T. Soluble and insoluble phenolic compounds and antioxidant activity of immature calamondin affected by solvents and heat treatment. Food Chem., 2014, 161, 246-253.
[http://dx.doi.org/10.1016/j.foodchem.2014.04.009 ] [PMID: 24837947]
[35]
Murcia, M.A.; Martínez-Tomé, M. Antioxidant activity of resveratrol compared with common food additives. J. Food Prot., 2001, 64(3), 379-384.
[http://dx.doi.org/10.4315/0362-028X-64.3.379 ] [PMID: 11252483]
[36]
Tokitomo, Y.; Shimono, Y.; Kobayashi, A.; Yamanishi, T. Aroma Components of Baelfruit. Agric. Biol. Chem., 1982, 46(7), 1873-1877.
[37]
Mujeeb, F.; Bajpai, P.; Pathak, N. Phytochemical evaluation, antimicrobial activity, and determination of bioactive components from leaves of Aegle marmelos. BioMed Res. Int., 2014. 2014497606
[http://dx.doi.org/10.1155/2014/497606 ] [PMID: 24900969]
[38]
Yun, B.R.; Yang, H.J.; Weon, J.B.; Lee, J.; Eom, M.R.; Ma, C.J. Neuroprotective properties of compounds extracted from Dianthus superbus L. against glutamate-induced cell death in HT22 Cells. Pharmacogn. Mag., 2016, 12(46), 109-113.
[http://dx.doi.org/10.4103/0973-1296.177905 ] [PMID: 27076746]
[39]
Meshram, A.; Bhagyawant, S.S.; Srivastava, N. Characterization of pyrrolidine alkaloids of Epipremnum aureum for their antitermite activity against subterranean termites with SEM Studies. Proc. Natl. Acad. Sci., India, Sect. B Biol. Sci., 2017, 89(1), 53-62.
[http://dx.doi.org/10.1007/s40011-017-0893-5]
[40]
Ghosh, G.; Panda, P.; Rath, M.; Pal, A.; Sharma, T.; Das, D. GC-MS analysis of bioactive compounds in the methanol extract of Clerodendrum viscosum leaves. Pharmacognosy Res., 2015, 7(1), 110-113.
[http://dx.doi.org/10.4103/0974-8490.147223 ] [PMID: 25598644]
[41]
Burdurlu, H.S.; Koca, N.; Karadeniz, F. Degradation of vitamin C in citrus juice concentrates during storage. J. Food Eng., 2006, 74(2), 211-216.
[http://dx.doi.org/10.1016/j.jfoodeng.2005.03.026]
[42]
Nemkul, C.M.; Bajracharya, G.; Shrestha, I. Phytochemical, antibacterial and DPPH free radical scavenging evaluations of the barks of Aegle marmelos [L.] Correa. J Pharmacogn Phytochem., 2018, 7(4), 1637-1641.
[43]
Shah, M.D.; Yong, Y.S.; Iqbal, M. Phytochemical investigation and free radical scavenging activities of Essential oil, methanol extract and methanol fractions of Nephrolepis biserrata. Int. J. Pharm. Pharm. Sci., 2014, 6(9), 269-277.
[44]
Chen, P.X.; Tang, Y.; Zhang, B.; Liu, R.; Marcone, M.F.; Li, X.; Tsao, R. 5-hydroxymethyl-2-furfural and derivatives formed during acid hydrolysis of conjugated and bound phenolics in plant foods and the effects on phenolic content and antioxidant capacity. J. Agric. Food Chem., 2014, 62(20), 4754-4761.
[http://dx.doi.org/10.1021/jf500518r ] [PMID: 24796380]
[45]
Yu, X.; Zhao, M.; Liu, F.; Zeng, S.; Hu, J. Identification of 2,3-dihydro-3,5-dihydroxy-6-methyl-4H-pyran-4-one as a strong antioxidant in glucose-histidine Maillard reaction products. Food Res. Int., 2013, 51(1), 397-403.
[http://dx.doi.org/10.1016/j.foodres.2012.12.044]
[46]
Ban, J.O.; Hwang, I.G.; Kim, T.M.; Hwang, B.Y.; Lee, U.S.; Jeong, H.S.; Yoon, Y.W.; Kimz, D.J.; Hong, J.T. Anti-proliferate and pro-apoptotic effects of 2,3-dihydro-3,5-dihydroxy-6-methyl-4H-pyranone through inactivation of NF-kappaB in human colon cancer cells. Arch. Pharm. Res., 2007, 30(11), 1455-1463.
[http://dx.doi.org/10.1007/BF02977371 ] [PMID: 18087815]
[47]
Chukwu, C.J.; Omaka, O.N.; Aja, P.M. Characterization of 2, 5-dimethyl-2,4-dihydroxy-3[2H] furanone, a flavourant principle from Sysepalum dulcificum. Nat. Prod. Chem. Res., 2017, 5(8), 296-304.
[48]
Yao, Z.Y.; Qi, J.H. Comparison of antioxidant activities of melanin fractions from chestnut shell. Molecules, 2016, 21(4)(487), 1-11.,
[http://dx.doi.org/10.3390/molecules21040487]
[49]
Pin-Der-Duh, X. Antioxidant activity of burdock [Arctium lappa Linne]: its scavenging effect on free-radical and active oxygen. J. Am. Oil Chem. Soc., 1998, 75(4), 455-461.
[http://dx.doi.org/10.1007/s11746-998-0248-8]
[50]
Lobo, V.; Patil, A.; Phatak, A.; Chandra, N. Free radicals, antioxidants and functional foods: impact on human health. Pharmacogn. Rev., 2010, 4(8), 118-126.
[http://dx.doi.org/10.4103/0973-7847.70902 ] [PMID: 22228951]
[51]
Mujeeb, F.; Khan, A.F.; Bajpai, P.; Pathak, N. Phytochemical study of Aegle marmelos: chromatographic elucidation of polyphenolics and assessment of antioxidant and cytotoxic potential. Pharmacogn. Mag., 2018, 13(4)(Suppl. 4), S791-S800.
[PMID: 29491635]
[52]
Lee, J.; Koo, N.; Min, D.B. Reactive oxygen species, aging, and antioxidative nutraceuticals. Compr. Rev. Food Sci. Food Saf., 2004, 3(1), 21-33.
[http://dx.doi.org/10.1111/j.1541-4337.2004.tb00058.x]
[53]
Reddy, C.S.; Rao, C.V.; Ramanaa, G. In vitro and in vivo anti-oxidant activity of Ficus racemosa Linn. fruit extract and Aegle marmelos root and leaf extracts. J. Pharm. Res., 2011, 4(7), 2078-2081.
[54]
Baliga, M.S.; Bhat, H.P.; Joseph, N.; Fazal, F. Phytochemistry and medicinal uses of the bael fruit [Aegle marmelos Correa]: a concise review. Food Res. Int., 2011, 44(7), 1768-1775.
[http://dx.doi.org/10.1016/j.foodres.2011.02.008]
[55]
Ayala, A.; Muñoz, M.F.; Argüelles, S. Lipid peroxidation: production, metabolism, and signaling mechanisms of malondialdehyde and 4-hydroxy-2-nonenal. Oxid. Med. Cell. Longev., 2014. 2014360438
[http://dx.doi.org/10.1155/2014/360438 ] [PMID: 24999379]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version358msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[03:13:42] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[03:13:42] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[03:13:42] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (114ms)time
  • Application (244ms)time
  • 1 x Application (68.18%)
    244ms
    1 x Booting (31.82%)
    114ms
    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 duplicated142ms
    • 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 ('316674267','',1,1739848422,1739848422) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739848422
      1.42msalphaeurekaselec_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 ('316674267','/article/108071',1,1739848422,1739848422)
      230μ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 >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) 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 >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) 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 >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) 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 >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) 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 >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) 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 >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316674267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316674267) limit 1
      18.94msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316674267
      • 1: 316674267
      • 2: 316674267
      • 3: 316674267
      • 4: 316674267
      • 5: 316674267
      • 6: 316674267
      • 7: 316674267
      • 8: 316674267
      • 9: 316674267
      • 10: 316674267
      • 11: 316674267
      • 12: 316674267
      • 13: 316674267
      • 14: 316674267
      • 15: 316674267
      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=108071
      740μ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` = 15 limit 1
      790μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 15
      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=15) and sj.journal_id!=15 group by `j`.`nid`) as `aggregate_table`
      1.08msalphaeurekaselec_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=15) and sj.journal_id!=15 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      910μ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=15) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.72msalphaeurekaselec_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=15) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      1.55msalphaeurekaselec_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` = '108071'
      900μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 108071
      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` = '108071'
      2.36msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 108071
      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` = '108071' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.67msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 108071
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ArticleController.php:2533
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      230μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      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 = 15 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      42.5msalphaeurekaselec_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 = 15 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      11.48msalphaeurekaselec_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 = 15 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      11.9msalphaeurekaselec_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` = 108071 limit 1
      970μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 108071
      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 = 108071 and content_type = 'article' order by status desc limit 1
      330μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 183651 limit 1
      270μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 183651
      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
      310μ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` = 'CDM' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      400μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CDM
      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 = '108071' 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) )
      510μ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 = '10116' 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) )
      440μ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 = '2702' 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) )
      390μ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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739848422 and j.to_date >= 1739848422 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2702) 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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739848422 and j.to_date >= 1739848422 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2702) 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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739848422 and j.to_date >= 1739848422 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2702)
      29.23msalphaeurekaselec_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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739848422 and j.to_date >= 1739848422 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10116) 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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739848422 and j.to_date >= 1739848422 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10116) 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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739848422 and j.to_date >= 1739848422 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10116)
      770μ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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739848422 and j.to_date >= 1739848422 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 108071) 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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739848422 and j.to_date >= 1739848422 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 108071) 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 <= 316674267 and j.to_ip >=316674267 )) and ((j.from_date <= 1739848422 and j.to_date >= 1739848422 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 108071)
      650μ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` < '525' and is_uploaded = 1 and issue_id = 10116 order by cast(first_page as SIGNED) desc limit 1
      580μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 525
      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` > '533' and is_uploaded = 1 and issue_id = 10116 order by cast(first_page as SIGNED) asc limit 1
      610μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 533
      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'
      210μ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
      250μ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` = 108071 limit 1
      4.07msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 108071
      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` = 15 and `b`.`banner_from_date` <= 1739848422 and `b`.`banner_to_date` >= 1739848422 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.58msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 15
      • 3: 1739848422
      • 4: 1739848422
      • 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` = 15 and `b`.`banner_from_date` <= 1739848422 and `b`.`banner_to_date` >= 1739848422 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.14msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 15
      • 3: 1739848422
      • 4: 1739848422
      • 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='4fbceb051c34594be067ea3606aa7a26'
      230μ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
        o4bS7xxW9OrOvOjSJy2KRMig0wAGxRKID3lxLoFZ
        uc_cart_id
        4fbceb051c34594be067ea3606aa7a26
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/108071" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/108071
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:9 [ "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6InpXbHNPbkdnQldndElDSnp0RW40OHc9PSIsInZhbHVlIjoiNDZNZ2Y1enErQzRUQzhFQmtVRERMYmdrMm1tQm9iTmYxaE9mcjNmT2tsaz0iLCJtYWMiOiI2NTE1ZDdkZWE4ZTQ3Nzc2YmQ3MTNjOTY0ODlmMzNhOGZjYjgzMTRiMjUwYWI2MDlhZDhkNjNkZDdjZjhkZGYxIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6InpXbHNPbkdnQldndElDSnp0RW40OHc9PSIsInZhbHVlIjoiNDZNZ2Y1enErQzRUQzhFQmtVRERMYmdrMm1tQm9iTmYxaE9mcjNmT2tsaz0iLCJtYWMiOiI2NTE1ZDdkZWE4ZTQ3" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 18 Feb 2025 03:13:42 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJoU3lGSFppL0RRL21xdEVZWE51TUE9PSIsInZhbHVlIjoidkFKUXNrdUJyZ2ZURUlRUVFjc1FHMHlOWHJ4QVY0bFpTN2Z0TlpoODZnazNHSDFGVExOMTluM011Qy9qaWlZUCtNVCs5NnhoaWd6WklHcU12d2dPb0pwaWZQb1ZMZEdKVWx0clB3Tm9rUXFqTXJzL0RKYjlxK2xqZ3pMeWRucXciLCJtYWMiOiI3N2ZhMzkxM2QwNDU0OWYyOTZhYzk5NTZhYTk1NjJmNzUyNzIwNGY4OGM5ZjVlZjhjYzA4MDhkMDBkNWY2NjJhIiwidGFnIjoiIn0%3D; expires=Thu, 20 Feb 2025 15:13:42 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlJoU3lGSFppL0RRL21xdEVZWE51TUE9PSIsInZhbHVlIjoidkFKUXNrdUJyZ2ZURUlRUVFjc1FHMHlOWHJ4QVY0bFpTN2Z0TlpoODZnazNHSDFGVExOMTluM011Qy9qaWlZUCtNVCs5N" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImFjSDR6S3J0T29zWjUvc01IUjdMc1E9PSIsInZhbHVlIjoiUzM0amdTT0lqZWhXVisyQUovQlFyU0lWSGdyRWJkL2JteFNuTGpPOElyaEpTYTRMS1BqNFBrWmJ0aVBFSFp1NmNGcEJvaExDdklLaVNLOEg4aWl0YkYrWGVLRFJteG8zYnFWWnk4dS9Ba3lpb0syWmNYc3pXeXdQVGdpZnEwSG4iLCJtYWMiOiIzMTZkZDYwYmRkMjkzNDA4YTRkYzRlMmNkYmI4ODg1MjllOGUwMjgxYmVmYWNhZTgyNTk5YTg2OWQ4YTMzNDZiIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6ImFjSDR6S3J0T29zWjUvc01IUjdMc1E9PSIsInZhbHVlIjoiUzM0amdTT0lqZWhXVisyQUovQlFyU0lWSGdyRWJkL2JteFNuTGpPOElyaEpTYTRMS1BqNFBrWmJ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJoU3lGSFppL0RRL21xdEVZWE51TUE9PSIsInZhbHVlIjoidkFKUXNrdUJyZ2ZURUlRUVFjc1FHMHlOWHJ4QVY0bFpTN2Z0TlpoODZnazNHSDFGVExOMTluM011Qy9qaWlZUCtNVCs5NnhoaWd6WklHcU12d2dPb0pwaWZQb1ZMZEdKVWx0clB3Tm9rUXFqTXJzL0RKYjlxK2xqZ3pMeWRucXciLCJtYWMiOiI3N2ZhMzkxM2QwNDU0OWYyOTZhYzk5NTZhYTk1NjJmNzUyNzIwNGY4OGM5ZjVlZjhjYzA4MDhkMDBkNWY2NjJhIiwidGFnIjoiIn0%3D; expires=Thu, 20-Feb-2025 15:13:42 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlJoU3lGSFppL0RRL21xdEVZWE51TUE9PSIsInZhbHVlIjoidkFKUXNrdUJyZ2ZURUlRUVFjc1FHMHlOWHJ4QVY0bFpTN2Z0TlpoODZnazNHSDFGVExOMTluM011Qy9qaWlZUCtNVCs5N" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImFjSDR6S3J0T29zWjUvc01IUjdMc1E9PSIsInZhbHVlIjoiUzM0amdTT0lqZWhXVisyQUovQlFyU0lWSGdyRWJkL2JteFNuTGpPOElyaEpTYTRMS1BqNFBrWmJ0aVBFSFp1NmNGcEJvaExDdklLaVNLOEg4aWl0YkYrWGVLRFJteG8zYnFWWnk4dS9Ba3lpb0syWmNYc3pXeXdQVGdpZnEwSG4iLCJtYWMiOiIzMTZkZDYwYmRkMjkzNDA4YTRkYzRlMmNkYmI4ODg1MjllOGUwMjgxYmVmYWNhZTgyNTk5YTg2OWQ4YTMzNDZiIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6ImFjSDR6S3J0T29zWjUvc01IUjdMc1E9PSIsInZhbHVlIjoiUzM0amdTT0lqZWhXVisyQUovQlFyU0lWSGdyRWJkL2JteFNuTGpPOElyaEpTYTRMS1BqNFBrWmJ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "o4bS7xxW9OrOvOjSJy2KRMig0wAGxRKID3lxLoFZ" "uc_cart_id" => "4fbceb051c34594be067ea3606aa7a26" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/108071" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-18 03:13:42GET/article/108071314361