Generic placeholder image

Current Bioactive Compounds

Editor-in-Chief

ISSN (Print): 1573-4072
ISSN (Online): 1875-6646

Research Article

Phenolic Compounds of Fig (Ficus carica L.) Leaves: Optimization of Extraction by Response Surface Methodology and UPLC-MS Phytochemical Characterization

Author(s): Sonia Yahiaoui, Djamel Edine Kati, Makhlouf Chaalal, Amar Otmani, Nadir Bettache and Mostapha Bachir-bey*

Volume 19, Issue 1, 2023

Published on: 19 August, 2022

Article ID: e150422203672 Pages: 13

DOI: 10.2174/1573407218666220415135916

Abstract

Background: This study is based on ethnobotanical observation and traditional medicinal utilization of fig (Ficus carica L.) by southwest Asian and Mediterranean populations.

Objective: Considering phenolics among the highly bioactive compounds for their numerous therapeutic applications, this investigation's first goal is to optimize their recovery by using Response Surface Methodology (RSM).

Methods: Prior to RSM, the single-factor method was applied to reveal the main factors influencing the extraction (solvent type, solvent concentration, sample˗to˗solvent ratio, temperature, and time of extraction). After using the optimal conditions of extraction, the second objective was the identification of fig leave phytochemicals by UPLC˗MS.

Results: The results of the preliminary optimization step through sequential methodology revealed that solvent concentration, extraction duration, and temperature were the main influencing factors. All these tested extraction parameters significantly influenced total phenolic contents (TPC) and DPPH-free radical scavenging activity (FRSA). RSM analysis using Box˗Behnken design showed that the optimal extraction conditions of total phenolic contents of fig leaves were 23.07% acetone, 51.82 °C, and 118.02 min with values of 29.44 mg GAE/g and 59.48% for TPC and FRSA, respectively. Eight phenolic compounds were detected, including chlorogenic, caffeic, and coumaric acids, rutin, isoquercetin, luteolin, quercetin, and kaempferol, well known for their bioactivities. Two non˗phenolic compounds were also found: The psoralen and an oxylipin, the 9˗oxo˗octadecadienoic acid detected for the first time in fig leaves.

Conclusion: The developed mathematical models have expressed a high level of significance through sequential and RSM optimization processes for phenolic antioxidants of Ficus carica leaves. The UPLC-MS analysis of the optimal extract revealed numerous phenolic compounds known for their bioactivities.

Keywords: Fig leaves, optimization, RSM, phenolic compounds, antioxidant activity, UPLC˗MS

Graphical Abstract

[1]
Konyalιoğlu, S.; Sağlam, H.; Kιvçak, B. α-Tocopherol, flavonoid, and phenol contents and antioxidant activity of Ficus carica leaves. Pharm. Biol., 2005, 43(8), 683-686.
[http://dx.doi.org/10.1080/13880200500383538]
[2]
Boukhalfa, F.; Kadri, N.; Franck, T.; Mouithys-Mickalad, A.; Serteyn, D.; Madani, K. Antioxidant capacity and anti-inflammatory potential of two extracts of Ficus carica leaves dried in the shade and in the oven. Mediterr. Med. J. Nutrition Metab., 2019, 12(4), 365-376.
[http://dx.doi.org/10.3233/MNM-190309]
[3]
Ayoub, L.; Hassan, F.; Hamid, S.; Abdelhamid, Z.; Souad, A. Phytochemical screening, antioxidant activity and inhibitory potential of Ficus carica and Olea europaea leaves. Bioinformation, 2019, 15(3), 226-232.
[http://dx.doi.org/10.6026/97320630015226] [PMID: 31354199]
[4]
Mahmoudi, S.; Khali, M.; Benkhaled, A.; Benamirouche, K.; Baiti, I. Phenolic and flavonoid contents, antioxidant and antimicrobial activities of leaf extracts from ten Algerian Ficus carica L. varieties. Asian Pac. J. Trop. Biomed., 2016, 6(3), 239-245.
[http://dx.doi.org/10.1016/j.apjtb.2015.12.010]
[5]
Mawa, S.; Husain, K.; Jantan, I. Ficus carica L. (Moraceae): phytochemistry, traditional uses and biological activities. Evid. Based Complement. Alternat. Med., 2013, 2013, 974256.
[http://dx.doi.org/10.1155/2013/974256] [PMID: 24159359]
[6]
Lansky, E.P.; Paavilainen, H.M.; Pawlus, A.D.; Newman, R.A. Ficus spp. (fig): Ethnobotany and potential as anticancer and anti-inflammatory agents. J. Ethnopharmacol., 2008, 119(2), 195-213.
[http://dx.doi.org/10.1016/j.jep.2008.06.025] [PMID: 18639620]
[7]
Gilani, A.H.; Mehmood, M.H.; Janbaz, K.H.; Khan, A.U.; Saeed, S.A. Ethnopharmacological studies on antispasmodic and antiplatelet activities of Ficus carica. J. Ethnopharmacol., 2008, 119(1), 1-5.
[http://dx.doi.org/10.1016/j.jep.2008.05.040] [PMID: 18586078]
[8]
Barolo, M.I.; Ruiz Mostacero, N. López, S.N. Ficus carica L. (Moraceae): An ancient source of food and health. Food Chem., 2014, 164, 119-127.
[http://dx.doi.org/10.1016/j.foodchem.2014.04.112] [PMID: 24996314]
[9]
Purnamasari, R.; Winarni, D.; Permanasari, A.A.; Agustina, E.; Hayaza, S.; Darmanto, W. Anticancer activity of methanol extract of Ficus carica leaves and fruits against proliferation, apoptosis, and necrosis in Huh7it cells. Cancer Inform., 2019, 18, 1176935119842576.
[http://dx.doi.org/10.1177/1176935119842576] [PMID: 31037025]
[10]
Raafat, K.; Wurglics, M. Phytochemical analysis of Ficus carica L. active compounds possessing anticonvulsant activity. J. Tradit. Complement. Med., 2018, 9(4), 263-270.
[http://dx.doi.org/10.1016/j.jtcme.2018.01.007] [PMID: 31453121]
[11]
Khoddami, A.; Wilkes, M.A.; Roberts, T.H. Techniques for analysis of plant phenolic compounds. Molecules, 2013, 18(2), 2328-2375.
[http://dx.doi.org/10.3390/molecules18022328] [PMID: 23429347]
[12]
Delmail, D.; Abasq, M-L.; Courtel, P.; Rouaud, I.; Labrousse, P. DNA damage protection, antioxidant and free-radical scavenging activities of Myriophyllum alterniflorum DC (Haloragaceae) vegetative parts. Acta Bot. Gallica, 2013, 160(2), 165-172.
[http://dx.doi.org/10.1080/12538078.2013.799046]
[13]
Liyana-Pathirana, C.; Shahidi, F. Optimization of extraction of phenolic compounds from wheat using response surface methodology. Food Chem., 2005, 93(1), 47-56.
[http://dx.doi.org/10.1016/j.foodchem.2004.08.050]
[14]
Zhang, Z-S.; Li, D.; Wang, L-J.; Ozkan, N.; Chen, X.D.; Mao, Z-H.; Yang, H-Z. Optimization of ethanol-water extraction of lignans from flaxseed. Separ. Purif. Tech., 2007, 57(1), 17-24.
[http://dx.doi.org/10.1016/j.seppur.2007.03.006]
[15]
Saci, F.; Benchikh, Y.; Louaileche, H. Bachir bey, M. Optimization of ultrasound-assisted extraction of phenolic compounds and antioxidant activity from carob pulp (Ceratonia siliqua L.) by using response surface methodology. An. Univ. Dunarea de Jos Galati Fasc. VI Food Technol., 2018, 42, 26-39.
[16]
Benchikh, Y.; Zaoui, A.; Derbal, R. Bachir bey, M.; Louaileche, H. Optimisation of extraction conditions of phenolic compounds and antioxidant activity of c L. using response surface methodology. J. Food Meas. Charact., 2019, 13, 883-891.
[http://dx.doi.org/10.1007/s11694-018-0002-3]
[17]
Saci, F.; Louaileche, H. Bachir bey, M.; Meziant, L. Optimization of phenolic compound recovery and antioxidant activity from carob pulp using response surface methodology. Int. Food Res. J., 2017, 24(3), 1094.
[18]
Naithani, V.; Nair, S.; Kakkar, P. Decline in antioxidant capacity of Indian herbal teas during storage and its relation to phenolic content. Food Res. Int., 2006, 39(2), 176-181.
[http://dx.doi.org/10.1016/j.foodres.2005.07.004]
[19]
Brand-Williams, W.; Cuvelier, M.E.; Berset, C. Use of a free radical method to evaluate antioxidant activity. Lebensm. Wiss. Technol., 1995, 28(1), 25-30.
[http://dx.doi.org/10.1016/S0023-6438(95)80008-5]
[20]
Hismath, I.; Wan, A.W.M.; Ho, C.W. Optimization of extraction conditions for phenolic compounds from neem (Azadirachta indica) leaves. Int. Food Res. J., 2011, 18(3), 931-939.
[21]
Irakli, M.; Chatzopoulou, P.; Ekateriniadou, L. Optimization of ultrasound-assisted extraction of phenolic compounds: Oleuropein, phenolic acids, phenolic alcohols and flavonoids from olive leaves and evaluation of its antioxidant activities. Ind. Crops Prod., 2018, 124, 382-388.
[http://dx.doi.org/10.1016/j.indcrop.2018.07.070]
[22]
Su, L.; Yin, J-J.; Charles, D.; Zhou, K.; Moore, J.; Yu, L. Total phenolic contents, chelating capacities, and radical-scavenging properties of black peppercorn, nutmeg, rosehip, cinnamon and oregano leaf. Food Chem., 2007, 100(3), 990-997.
[http://dx.doi.org/10.1016/j.foodchem.2005.10.058]
[23]
Naczk, M.; Shahidi, F. Phenolics in cereals, fruits and vegetables: Occurrence, extraction and analysis. J. Pharm. Biomed. Anal., 2006, 41(5), 1523-1542.
[http://dx.doi.org/10.1016/j.jpba.2006.04.002] [PMID: 16753277]
[24]
Benchikh, Y.; Louaileche, H. Effects of extraction conditions on the recovery of phenolic compounds and in vitro antioxidant activity of carob (Ceratonia siliqua L.) pulp. Acta Bot. Gallica, 2014, 161(2), 175-181.
[http://dx.doi.org/10.1080/12538078.2014.909325]
[25]
Bey, M.B.; Louaileche, H.; Zemouri, S. Optimization of phenolic compound recovery and antioxidant activity of light and dark dried fig (Ficus carica L.) varieties. Food Sci. Biotechnol., 2013, 22(6), 1613-1619.
[http://dx.doi.org/10.1007/s10068-013-0258-7]
[26]
Spigno, G.; Tramelli, L.; De Faveri, D.M. Effects of extraction time, temperature and solvent on concentration and antioxidant activity of grape marc phenolics. J. Food Eng., 2007, 81(1), 200-208.
[http://dx.doi.org/10.1016/j.jfoodeng.2006.10.021]
[27]
Ameer, K.; Shahbaz, H.M.; Kwon, J-H. Green extraction methods for polyphenols from plant matrices and their byproducts: A review. Compr. Rev. Food Sci. Food Saf., 2017, 16(2), 295-315.
[http://dx.doi.org/10.1111/1541-4337.12253] [PMID: 33371540]
[28]
Chaalal, M.; Touati, N.; Louaileche, H. Extraction of phenolic compounds and in vitro antioxidant capacity of prickly pear seeds. Acta Bot. Gallica, 2012, 159(4), 467-475.
[http://dx.doi.org/10.1080/12538078.2012.758495]
[29]
Pinelo, M.; Rubilar, M.; Jerez, M.; Sineiro, J. Núñez, M.J. Effect of solvent, temperature, and solvent-to-solid ratio on the total phenolic content and antiradical activity of extracts from different components of grape pomace. J. Agric. Food Chem., 2005, 53(6), 2111-2117.
[http://dx.doi.org/10.1021/jf0488110] [PMID: 15769143]
[30]
Sifaoui, I.; Chammem, N.; Abderrabba, M.; Mejri, M. Optimization of phenolic compounds extraction from olive leaves using experimental design methodology. J. Mater. Environ. Sci., 2016, 7(4), 1119-1127.
[31]
Martin-Garcia, B.; Pimentel-Moral, S. Gómez-Caravaca, A.M.; Arráez-Román, D.; Segura-Carretero, A. Box-Behnken experimental design for a green extraction method of phenolic compounds from olive leaves. Ind. Crops Prod., 2020, 154, 112741.
[http://dx.doi.org/10.1016/j.indcrop.2020.112741]
[32]
Brahim, M.; Gambier, F.; Brosse, N. Optimization of polyphenols extraction from grape residues in water medium. Ind. Crops Prod., 2014, 52, 18-22.
[http://dx.doi.org/10.1016/j.indcrop.2013.10.030]
[33]
Silva, E.; Rogez, H.; Larondelle, Y. Optimization of extraction of phenolics from Inga edulis leaves using response surface methodology. Separ. Purif. Tech., 2007, 55(3), 381-387.
[http://dx.doi.org/10.1016/j.seppur.2007.01.008]
[34]
Jumbri, K.; Al-Haniff Rozy, M.F.; Ashari, S.E.; Mohamad, R.; Basri, M.; Fard Masoumi, H.R. Optimisation and characterisation of lipase-catalysed synthesis of a kojic monooleate ester in a solvent-free system by response surface Methodology. PLoS One, 2015, 10(12), e0144664.
[http://dx.doi.org/10.1371/journal.pone.0144664] [PMID: 26657030]
[35]
Juntachote, T.; Berghofer, E.; Bauer, F.; Siebenhandl, S. The application of response surface methodology to the production of phenolic extracts of lemon grass, galangal, holy basil and rosemary. Int. J. Food Sci. Technol., 2006, 41(2), 121-133.
[http://dx.doi.org/10.1111/j.1365-2621.2005.00987.x]
[36]
Ağalar, H.G.; Akalın Çiftçi, G.; Göger, F.; Kırımer, N. Activity guided fractionation of Arum italicum miller tubers and the LC/MS-MS profiles. Rec. Nat. Prod., 2017, 12(1), 64-75.
[http://dx.doi.org/10.25135/rnp.06.17.05.089]
[37]
Takahashi, H.; Kamakari, K.; Goto, T.; Hara, H.; Mohri, S.; Suzuki, H.; Shibata, D.; Nakata, R.; Inoue, H.; Takahashi, N.; Kawada, T. 9-Oxo-10(E),12(Z),15(Z)-Octadecatrienoic acid activates peroxisome proliferator-activated receptor α in hepatocytes. Lipids, 2015, 50(11), 1083-1091.
[http://dx.doi.org/10.1007/s11745-015-4071-3] [PMID: 26387026]
[38]
Chunyan, C.; Bo, S.; Ping, L.; Jingmei, L.; Ito, Y. Isolation and purification of psoralen and bergapten from Ficus carica L. leaves by high-speed countercurrent chromatography. J. Liq. Chromatogr. Relat. Technol., 2009, 32(1), 136-143.
[http://dx.doi.org/10.1080/10826070802548747] [PMID: 20351802]
[39]
Oliveira, A.P. Valentão, P.; Pereira, J.A.; Silva, B.M.; Tavares, F.; Andrade, P.B. Ficus carica L.: Metabolic and biological screening. Food Chem. Toxicol., 2009, 47(11), 2841-2846.
[http://dx.doi.org/10.1016/j.fct.2009.09.004] [PMID: 19747518]
[40]
dos Santos, M.D.; Almeida, M.C.; Lopes, N.P.; de Souza, G.E.P. Evaluation of the anti-inflammatory, analgesic and antipyretic activities of the natural polyphenol chlorogenic acid. Biol. Pharm. Bull., 2006, 29(11), 2236-2240.
[http://dx.doi.org/10.1248/bpb.29.2236] [PMID: 17077520]
[41]
Birková. A. Caffeic acid: A brief overview of its presence, metabolism, and bioactivity. Bioact. Com. Health Dis., 2020, 3(4), 74-81.
[http://dx.doi.org/10.31989/bchd.v3i4.692]
[42]
Vangaveti, V.N.; Jansen, H.; Kennedy, R.L.; Malabu, U.H. Hydroxyoctadecadienoic acids: Oxidised derivatives of linoleic acid and their role in inflammation associated with metabolic syndrome and cancer. Eur. J. Pharmacol., 2016, 785, 70-76.
[http://dx.doi.org/10.1016/j.ejphar.2015.03.096] [PMID: 25987423]
[43]
Nishiguchi, S.; Murata, K.; Ube, N.; Ueno, K.; Tebayashi, S.I.; Teraishi, M.; Okumoto, Y.; Mori, N.; Ishihara, A. Accumulation of 9- and 13-KODEs in response to jasmonic acid treatment and pathogenic infection in rice. J. Pestic. Sci., 2018, 43(3), 191-197.
[http://dx.doi.org/10.1584/jpestics.D18-022] [PMID: 30363135]
[44]
Takahashi, H.; Kim, Y-I.; Hirai, S.; Goto, T.; Ohyane, C.; Tsugane, T.; Konishi, C.; Fujii, T.; Inai, S.; Iijima, Y.; Aoki, K.; Shibata, D.; Takahashi, N.; Kawada, T. Comparative and stability analyses of 9- and 13-Oxo-octadecadienoic acids in various species of tomato. Biosci. Biotechnol. Biochem., 2011, 75(8), 1621-1624.
[http://dx.doi.org/10.1271/bbb.110254] [PMID: 21821922]
[45]
Bachmetov, L.; Gal-Tanamy, M.; Shapira, A.; Vorobeychik, M.; Giterman-Galam, T.; Sathiyamoorthy, P.; Golan-Goldhirsh, A.; Benhar, I.; Tur-Kaspa, R.; Zemel, R. Suppression of hepatitis C virus by the flavonoid quercetin is mediated by inhibition of NS3 protease activity. J. Viral Hepat., 2012, 19(2), e81-e88.
[http://dx.doi.org/10.1111/j.1365-2893.2011.01507.x] [PMID: 22239530]
[46]
Maciel, R.M.; Costa, M.M.; Martins, D.B.; França, R.T.; Schmatz, R.; Graça, D.L.; Duarte, M.M.M.F.; Danesi, C.C.; Mazzanti, C.M.; Schetinger, M.R.C.; Paim, F.C.; Palma, H.E.; Abdala, F.H.; Stefanello, N.; Zimpel, C.K.; Felin, D.V.; Lopes, S.T.A. Antioxidant and anti-inflammatory effects of quercetin in functional and morphological alterations in streptozotocin-induced diabetic rats. Vet. Sci. Res. J., 2013, 95(2), 389-397.
[http://dx.doi.org/10.1016/j.rvsc.2013.04.028] [PMID: 23706762]
[47]
Lin, C-F.; Leu, Y-L.; Al-Suwayeh, S.A.; Ku, M-C.; Hwang, T-L.; Fang, J-Y. Anti-inflammatory activity and percutaneous absorption of quercetin and its polymethoxylated compound and glycosides: The relationships to chemical structures. Eur. J. Pharm. Sci., 2012, 47(5), 857-864.
[http://dx.doi.org/10.1016/j.ejps.2012.04.024] [PMID: 22609526]
[48]
Ahmed Asim, S.; Ahmed, S.; Us-Sehar, N. Psoralen-ultraviolet A treatment with Psoralen-ultraviolet B therapy in the treatment of psoriasis. Pak. J. Med. Sci., 2013, 29(3), 758-761.
[http://dx.doi.org/10.12669/pjms.293.2622] [PMID: 24353623]
[49]
Shenoi, S.D.; Prabhu, S. Indian association of dermatologists, venereologists and leprologists. Photochemotherapy (PUVA) in psoriasis and vitiligo. Indian J. Dermatol. Venereol. Leprol., 2014, 80(6), 497-504.
[http://dx.doi.org/10.4103/0378-6323.144143] [PMID: 25382505]

© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version302msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:01:16] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:01:17] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:01:17] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:01:17] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (110ms)time
  • Application (192ms)time
  • 1 x Application (63.57%)
    192ms
    1 x Booting (36.43%)
    110ms
    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
    31 statements were executed, 4 of which were duplicates, 27 unique. Show only duplicated110ms
    • 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 ('59689235','',1,1740513676,1740513676) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740513676
      1.24msalphaeurekaselec_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 ('59689235','/article/122608',1,1740513676,1740513676)
      170μ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 >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) 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 >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) 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 >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) 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 >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) 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 >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) 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 >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59689235 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59689235) limit 1
      13.4msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59689235
      • 1: 59689235
      • 2: 59689235
      • 3: 59689235
      • 4: 59689235
      • 5: 59689235
      • 6: 59689235
      • 7: 59689235
      • 8: 59689235
      • 9: 59689235
      • 10: 59689235
      • 11: 59689235
      • 12: 59689235
      • 13: 59689235
      • 14: 59689235
      • 15: 59689235
      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=122608
      620μsalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 6 limit 1
      930μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 6
      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=6) and sj.journal_id!=6 group by `j`.`nid`) as `aggregate_table`
      1.89msalphaeurekaselec_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=6) and sj.journal_id!=6 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      2.99msalphaeurekaselec_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=6) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      5.57msalphaeurekaselec_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=6) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      7.18msalphaeurekaselec_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` = '122608'
      910μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 122608
      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` = '122608'
      3.62msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 122608
      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` = '122608' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.5msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 122608
      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
      320μ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
      690μ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 = 6 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      45.84msalphaeurekaselec_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 = 6 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      8.88msalphaeurekaselec_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 = 6 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      4.62msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2071
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select pdf, html, epub, prc from `article_metrics` where `article_id` = 122608 limit 1
      710μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 122608
      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 = 122608 and content_type = 'article' order by status desc limit 1
      300μ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` = 203672 limit 1
      200μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 203672
      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
      220μ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` = 'CBC' 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: CBC
      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 = '122608' 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) )
      410μ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 * from `article` where `first_page` < '39' and is_uploaded = 1 and issue_id = 12071 order by cast(first_page as SIGNED) desc limit 1
      520μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 39
      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` > '51' and is_uploaded = 1 and issue_id = 12071 order by cast(first_page as SIGNED) asc limit 1
      460μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 51
      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
      220μ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` = 122608 limit 1
      2.52msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 122608
      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` = 6 and `b`.`banner_from_date` <= 1740513677 and `b`.`banner_to_date` >= 1740513677 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.15msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 6
      • 3: 1740513677
      • 4: 1740513677
      • 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` = 6 and `b`.`banner_from_date` <= 1740513677 and `b`.`banner_to_date` >= 1740513677 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.15msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 6
      • 3: 1740513677
      • 4: 1740513677
      • 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='6b73f27b50790ebfd33a5f0c2b6ca4cc'
      250μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        ZnXKeQescSmJHMuWbCEe0admG4yOMLnBwVhFuKpR
        uc_cart_id
        6b73f27b50790ebfd33a5f0c2b6ca4cc
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/122608" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/122608
        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=eyJpdiI6Ik5TaFI1NGoxVVB3R20wdzFJa2RFcVE9PSIsInZhbHVlIjoiR1FiSFhXZkxFNURMRXdGTU03S0RuMllPSW8vNndndTh5cEp3NHpPWWdLMD0iLCJtYWMiOiI3NTRjNGI2NWRlNzAzYjgyODI0Y2QyZDA0YzgzOGJlNWVmNDI1YmNkODczNDU4MDdiYjhhZjdkYmU2NzBhMmMzIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6Ik5TaFI1NGoxVVB3R20wdzFJa2RFcVE9PSIsInZhbHVlIjoiR1FiSFhXZkxFNURMRXdGTU03S0RuMllPSW8vNndndTh5cEp3NHpPWWdLMD0iLCJtYWMiOiI3NTRjNGI2NWRlNzAz" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 25 Feb 2025 20:01:17 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ims4UndqamFKa3BLSVVrQ25mdnB4OHc9PSIsInZhbHVlIjoicnNPN1QxUXhCT3dJMjNpd1UvYzh0UFd4eGtsMVFyUXZJeG4xVVlXTVNMVVdzRll3d2NPMmtlUy9mc3R2MXRnalh2emsyZWtNM3I0RVp5Qzk4cWpPaC8yWFk1M29DUG42aGxZRjRlVGdmZHpOckxpVXREWXpGVDB1NDRPVXdhbzciLCJtYWMiOiI0YmEzZDVlMDQzNDljMGQ1ODdmNDVlMTQ3ODU2MzgyMzNlMWVhNzRmZDU4MmVjOTk4YjEzZmUyMjIyM2UwY2NkIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 08:01:17 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ims4UndqamFKa3BLSVVrQ25mdnB4OHc9PSIsInZhbHVlIjoicnNPN1QxUXhCT3dJMjNpd1UvYzh0UFd4eGtsMVFyUXZJeG4xVVlXTVNMVVdzRll3d2NPMmtlUy9mc3R2MXRnalh2emsyZ" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImxqbERLKzFIcEhLaVR6dDRYTWgxYlE9PSIsInZhbHVlIjoiQnowMFZzaDRUNHZ5QVA0dWRzUmw2a1hmbEZ5dm5hZGVkY2xlR0xhSTVzR0oxY1ZpVk02eklpZTJVRXh0UGxHdzVUbjR1ckRRcDY0YlZhclBNMFFCb211aTdudk80eXpUNTY0OEpNR1pHa0puL05WeE8yZHVCQ082QUxqZkFkZFEiLCJtYWMiOiIxNzkzMWQwOWMwY2JiYWM2NDkzOTY3NTdkOGIwMDJmOTQxNDZhZThlNmJlOWU4NzA0MDc5YjBmM2YwMGYwOTdmIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6ImxqbERLKzFIcEhLaVR6dDRYTWgxYlE9PSIsInZhbHVlIjoiQnowMFZzaDRUNHZ5QVA0dWRzUmw2a1hmbEZ5dm5hZGVkY2xlR0xhSTVzR0oxY1ZpVk02eklpZTJ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ims4UndqamFKa3BLSVVrQ25mdnB4OHc9PSIsInZhbHVlIjoicnNPN1QxUXhCT3dJMjNpd1UvYzh0UFd4eGtsMVFyUXZJeG4xVVlXTVNMVVdzRll3d2NPMmtlUy9mc3R2MXRnalh2emsyZWtNM3I0RVp5Qzk4cWpPaC8yWFk1M29DUG42aGxZRjRlVGdmZHpOckxpVXREWXpGVDB1NDRPVXdhbzciLCJtYWMiOiI0YmEzZDVlMDQzNDljMGQ1ODdmNDVlMTQ3ODU2MzgyMzNlMWVhNzRmZDU4MmVjOTk4YjEzZmUyMjIyM2UwY2NkIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 08:01:17 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ims4UndqamFKa3BLSVVrQ25mdnB4OHc9PSIsInZhbHVlIjoicnNPN1QxUXhCT3dJMjNpd1UvYzh0UFd4eGtsMVFyUXZJeG4xVVlXTVNMVVdzRll3d2NPMmtlUy9mc3R2MXRnalh2emsyZ" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImxqbERLKzFIcEhLaVR6dDRYTWgxYlE9PSIsInZhbHVlIjoiQnowMFZzaDRUNHZ5QVA0dWRzUmw2a1hmbEZ5dm5hZGVkY2xlR0xhSTVzR0oxY1ZpVk02eklpZTJVRXh0UGxHdzVUbjR1ckRRcDY0YlZhclBNMFFCb211aTdudk80eXpUNTY0OEpNR1pHa0puL05WeE8yZHVCQ082QUxqZkFkZFEiLCJtYWMiOiIxNzkzMWQwOWMwY2JiYWM2NDkzOTY3NTdkOGIwMDJmOTQxNDZhZThlNmJlOWU4NzA0MDc5YjBmM2YwMGYwOTdmIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6ImxqbERLKzFIcEhLaVR6dDRYTWgxYlE9PSIsInZhbHVlIjoiQnowMFZzaDRUNHZ5QVA0dWRzUmw2a1hmbEZ5dm5hZGVkY2xlR0xhSTVzR0oxY1ZpVk02eklpZTJ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "ZnXKeQescSmJHMuWbCEe0admG4yOMLnBwVhFuKpR" "uc_cart_id" => "6b73f27b50790ebfd33a5f0c2b6ca4cc" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/122608" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 20:01:17GET/article/122608414311