Generic placeholder image

Mini-Reviews in Medicinal Chemistry

Editor-in-Chief

ISSN (Print): 1389-5575
ISSN (Online): 1875-5607

Review Article

Ziziphus oenoplia Mill.: A Systematic Review on Ethnopharmacology, Phytochemistry and Pharmacology of an Important Traditional Medicinal Plant

Author(s): Afsana Nahrin, Md. Junaid, Syeda Samira Afrose, Antica Barua, Yeasmin Akter, Muhammad Shaiful Alam, Tania Sharmin*, Sakia Ferdousy and S.M. Zahid Hosen

Volume 22, Issue 4, 2022

Published on: 10 August, 2021

Page: [640 - 660] Pages: 21

DOI: 10.2174/1389557521666210810153311

Price: $65

Abstract

Background: Ziziphus oenoplia Mill. (Family- Rhamnaceae) an important shrub, often found throughout the hot regions of tropical Asia and northern Australia, is commonly well known as Jackal jujube in English. It is a folk herbal medicine used as an abdominal pain killer and antidiarrhoeal agent.

Objective: The review aims to provide up-to-date information on the vernacular information, botanical characterization, distribution, ethnopharmacological uses, pharmacological activities, and chemical constituents of Z. oenoplia for possible exploitation of treatment for various diseases and to suggest future investigations.

Methods: This review was performed by studying online resources relating to Z. oenoplia and diverse resources, including scientific journals, books, and worldwide accepted databases from which information was assembled to accumulate significant information and relevant data in one place.

Results: Investigations on Z. oenoplia have been focused on its pharmacological activities, including its antimicrobial, antidiabetic, antihepatotoxic, antiulcer, antiplasmodial, anticancer, wound healing, anthelmintic, antioxidant, analgesic and antinociceptive, hypolipidemic activity, anti-inflammatory, immunomodulatory and antidiarrheal activities. Phytochemical studies resulted in the isolation of fatty acids, flavonoids, phenols, pentacyclic triterpenes, hydroxycarboxylic acids, aliphatic hydroxy ether, and cyclopeptide alkaloids.

Conclusion: Most of the ethnopharmacological relevance of Z. oenoplia is justified, but more studies are needed. Further investigations are necessary to fully understand the mode of action of the active constituents and to exploit its preventive and therapeutic potentials.

Keywords: Ziziphus oenoplia, botanical description, geographical distribution, ethnomedicinal uses, chemical constituents, pharmacological activity.

Graphical Abstract

[1]
Shukla, R.; Pandey, V.; Golhani, D.; Shukla, A.; Rai, K. Herbal shampoo of Zizyphus oenoplia (l) mill from ethanol extract of leaves, Invent; Rap. Cosmeceut, 2015.
[2]
Pullaiah, T. Medicinal plants in andhra pradesh; Daya Books: India, 2002.
[3]
Quattrocchi, U. CRC world dictionary of medicinal and poisonous plants: common names, scientific names, eponyms, synonyms, and etymology; CRC press, 2012, Vol. 5, pp. 1-6.
[4]
Deogade, M.S.; Shambharkar, N.; Kallianpur, S.; Khobragade, P. A field survey for the diverse flora and fauna of chincholi (junapani) beat of vidarbha region (India). J. Indian Sys. Med., 2016, 4(1), 20.
[5]
Eswari, M.L.; Bharathi, R.V.; Jayshree, N. Preliminary phytochemical screening and heavy metal analysis of leaf extracts of Ziziphus oenoplia (L). Mill. Gard. Int. J. Pharm. Sci. Drug Res., 2013, 5(1), 38-40.
[6]
Murthy, H.N.; Joseph, K.S.; Madiwal, A.; Gerald, D.R.; Badiger, M.; Kolkar, L.; Hiremath, R. Physicochemical characteristics of the seed and seed oil of the potentially medicinal plant ziziphus oenoplia. J. Diet. Suppl., 2017, 14(6), 691-696.
[http://dx.doi.org/10.1080/19390211.2017.1304485] [PMID: 28426266]
[7]
Thirugnanasampandan, R.; Ramya, G.; Bhuvaneswari, G.; Aravindh, S.; Vaishnavi, S.; Gogulramnath, M. Preliminary phytochemical analysis and evaluation of antioxidant, cytotoxic and inhibition of lipopolysaccaride - induced NOS (iNOS) expression in BALB/c mice liver by Ziziphus oenoplia Mill. fruit. J. Complement. Integr. Med., 2017, 14(2)
[http://dx.doi.org/10.1515/jcim-2016-0009] [PMID: 28282293]
[8]
Lomchoey, N.; Saenkham, A.; Nakapong, S.; Suksamrarn, S. Potent α–glucosidase inhibitory activity of some Ziziphus plants. KKU Sci. J., 2017, 45(3), 438-446.
[9]
Prabhavathi, S.; Vijayalakshmi, S. New hydroxy carboxylic acid from the root bark of Ziziphus oenoplia. J. Pharmacogn. Phytochem., 2015, 3(6), 150-152.
[10]
Prabhavathi, S.; Vijayalakshmi, S. Identification of new aliphatic hydroxy ether from the root bark of Ziziphus oenoplia. J. Pharmacogn. Phytochem., 2016, 5(1), 85.
[11]
Cassels, B.; Eckhardt, G.; Kaussmann, E-U.; Tschesche, R. Cyclopeptide alkaloids of Zizyphus oenoplia. Tetrahedron, 1974, 30(15), 2461-2466.
[http://dx.doi.org/10.1016/S0040-4020(01)97117-0]
[12]
Tschesche, R. Alkaloide aus rhamnaceen. XXVI. zizyphin-f und-g, neue cyclopeptidalkaloide aus zizyphus oenopolia mill. AGRIS, 1974, 1974(34), 2941-2944.
[13]
Khokhar, I.; Ahmad, A. Spectrometric studies on a new 13-membered cyclopeptide alkaloid from Zizyphus oenoplia. Mill. J. Nat. Sci. Math., 1994, 36, 171.
[14]
Suksamrarn, S.; Suwannapoch, N.; Aunchai, N.; Kuno, M.; Ratananukul, P.; Haritakun, R.; Jansakul, C.; Ruchirawat, S. Ziziphine, N. O, P and Q, new antiplasmodial cyclopeptide alkaloids from Ziziphus oenoplia var. brunoniana. Tetrahedron, 2005, 61(5), 1175-1180.
[http://dx.doi.org/10.1016/j.tet.2004.11.053]
[15]
Maurya, S.; Pandey, D.; Singh, J.; Pandey, V. Constituents of Zizyphus oenoplea. Pharmazie, 1995, 50(5), 372.
[16]
Eswari, M.L.; Bharathi, R.V.; Jayshree, N. Hypolipidemic activity on ethanolic extract of leaves of Ziziphus oenoplia (L). Mill. Gard. Int. J. Pharm. Biol. Arch., 2013, 4(1), 136-141.
[17]
Chuakul, W. Medicinal plants in khao kho district, phetchabun province, Thailand. Pharm. Biol., 2000, 38(1), 61-67.
[http://dx.doi.org/10.1076/1388-0209(200001)3811-BFT061] [PMID: 21214442]
[18]
Ara, H.; Hassan, M.A.; Khanam, M. Taxonomic study of the genus Ziziphus Mill.(Rhamnaceae) of Bangladesh. Bangladesh J. Plant Taxon., 2008, 15(1), 47-61.
[http://dx.doi.org/10.3329/bjpt.v15i1.917]
[19]
Chandraratne, R. Some ethno-archaeological observations on the subsistence strategies of the veddas in sri lanka. Soc. Aff., 2016, 1, 33-44.
[20]
Singh, P.; Tiwari, M.; Yadav, S.; Dubey, S.P. Comparative Study of the roots of the plants Ziziphus oenoplia and Ziziphus jujuba. J. Pharmacogn. Phytochem., 2014, 3(1), 211-217.
[21]
Jadhav, S.A.; Prasanna, S. Evaluation of antiulcer activity of Ziziphus oenoplia (L) Mill. roots in rats. Asian J. Pharm. Clin. Res., 2011, 1(1), 92-95.
[22]
, 1996.
[23]
Kirtikar, K.R. Indian medicinal plants; Lalit Mohan Publication: Allahabad, 1991, Vol. 2, pp. 1347-1348.
[24]
Rajakaruna, N.; Harris, C.S.; Towers, G. Antimicrobial activity of plants collected from serpentine outcrops in Sri Lanka. Pharm. Biol., 2002, 40(3), 235-244.
[http://dx.doi.org/10.1076/phbi.40.3.235.5825]
[25]
Revathi, P.; Parimelazhagan, T. Traditional knowledge on medicinal plants used by the Irula tribe of Hasanur Hills, Erode District, Tamil Nadu, India. Ethnobot. Leaflets, 2010, 2010(2), 4.
[26]
Kamble, S.; Pradhan, S. Ethnobotany of the Korkus in Maharashtra. Nelumbo, 1980, 22(1-4), 201-202.
[27]
Ajesh, T.; Naseef, S.A.; Kumuthakalavalli, R. Ethnobotanical documentation of wild edible fruits used by Muthuvan tribes of Idukki, Kerala-India. Int. J. Pharma Bio Sci., 2012, 3(3), 479-487.
[28]
Ignacimuthu, S.; Ayyanar, M.; Sankarasivaraman, K. Ethnobotanical study of medicinal plants used by Paliyar tribals in Theni district of Tamil Nadu, India. Fitoterapia, 2008, 79(7-8), 562-568.
[http://dx.doi.org/10.1016/j.fitote.2008.06.003] [PMID: 18678232]
[29]
Yadav, S.; Das, S.; Ghosh, S.; Yadav, N. Antidiarrhoeal evaluation of traditionally used Ziziphus oenoplia (L.) Mill root. Int. J. Herb. Med., 2016, 4, 98-102.
[30]
Hossan, M.S.; Hanif, A.; Khan, M.; Bari, S.; Jahan, R.; Rahmatullah, M. Ethnobotanical survey of the Tripura tribe of Bangladesh. Am.-. Eurasian J. Sustain. Agric., 2009, 3(2), 253-261.
[31]
Rahmatullah, M.; Khatun, Z.; Barua, D.; Alam, M-U.; Jahan, S.; Jahan, R. Medicinal plants used by traditional practitioners of the Kole and Rai tribes of Bangladesh. J. Altern. Complement. Med., 2013, 19(6), 483-491.
[http://dx.doi.org/10.1089/acm.2012.0227] [PMID: 23343335]
[32]
Gournelis, D.; Laskaris, G.; Verpoorte, R. Fortschritte der Chemie organischer naturstoffe/progress in the chemistry of organic natural products; Springer, 1998, pp. 1-179.
[http://dx.doi.org/10.1007/978-3-7091-6507-2_1]
[33]
Khan, M.; Khan, G.; Khan, L.; Ahmad, V. Cyclopeptide alkaloids of Zizyphus species. J. Chem. Soc. Pak., 2001, 23(4), 268-277.
[34]
Pramod Mourya, A.S.; Gopal, R.; Santram, L. 2016.
[35]
Aldred, E.M. Pharmacology E-book: a handbook for complementary healthcare professionals; Elsevier Health Sciences, 2008.
[36]
Tambekar, D.; Tiwari, B.; Shirsat, S.; Jaitalkar, D. Antimicrobial potential and Phytochemical analysis of medicinal plants from lonar lake. Int. J. Life Sci. Biotechnol. Pharma Res., 2013, 2(3), 203-2011.
[37]
Ramalingam, R.; Madhavi, B.B.; Nath, A.R.; Duganath, N.; Sri, E.U.; Banji, D. In vitro anti-denaturation and antibacterial activities of Zizyphus oenoplia. Pharm. Lett., 2010, 2(1), 87-93.
[38]
Mourya, P.; Shukla, A.; Rai, G.; Lodhi, S. Hypoglycemic and hypolipidemic effects of ethanolic and aqueous extracts from Ziziphus oenoplia (L) Mill on alloxan-induced diabetic rats. Beni. Suef Univ. J. Basic Appl. Sci., 2017, 6(1), 1-9.
[http://dx.doi.org/10.1016/j.bjbas.2016.12.002]
[39]
Rao, C.V.; Rawat, A.K.; Singh, A.P.; Singh, A.; Verma, N. Hepatoprotective potential of ethanolic extract of Ziziphus oenoplia (L.) Mill roots against antitubercular drugs induced hepatotoxicity in experimental models. Asian Pac. J. Trop. Med., 2012, 5(4), 283-288.
[http://dx.doi.org/10.1016/S1995-7645(12)60040-6] [PMID: 22449519]
[40]
Singh, A.; Kumar, G.R.; Gupta, S.S.; Singh, S.; Rawat, A.; Rao, C.V. Hepatoprotective potential of Ziziphus oenoplia (L.) mill roots against paracetamol-induced hepatotoxicity in rats. AJPCT, 2015, 3(01), 64-78.
[41]
Jadhav, S.A.; Prasanna, S. Evaluation of antiulcer activity of Zizyphus oenoplia (L) Mill. Root in rats. Asian J. Pharm. Clin. Res., 2011, 1(1), 92-95.
[42]
Mahapatra, S.S.; Mohanta, S.; Nayak, A.K. Preliminary investigation of the angiogenic potential of Ziziphus oenoplia root ethanolic extract using the chorioallantoic membrane model. Sci. Asia, 2011, 37, 72-74.
[http://dx.doi.org/10.2306/scienceasia1513-1874.2011.37.072]
[43]
Kuppast, I.; Kumar, K.S. Wound healing activity of aqueous and alcoholic extracts of fruits of Ziziphus oenoplia. Int. J. Chem. Sci., 2012, 10(2), 1021-1027.
[44]
Majumder, P. In vitro anthelmintic activity of Zyziphus oenoplia (L.) Mill root extracts–a promising ethnomedicinal plant. Int. J. Res. Rev. Pharm. Appl. Sci., 2011, 1(4), 334-340.
[45]
Jadhav, S.A.; Chavan, D.S.; Jadhav, P.D. Preliminary phytochemical and anthelmintic activity of zizyphus oenoplia (l) mill. Curr. Pharm. Res., 2012, 2(3), 543.
[http://dx.doi.org/10.33786/JCPR.2012.v02i03.006]
[46]
Shukla, A.; Garg, S.; Garg, A.; Mourya, P.; Jain, C. Investigations on hydroalcoholic extract of for analgesic and anti-Zizyphus oenoplis nociceptive activity. Asian J. Pharm. Pharmacol., 2016, 2(1), 15-18.
[47]
Butle, A.; Talmale, S.; Patil, M. Potential in vivo immunomodulatory effects of the most active lectin isolated from seeds of Zizyphus oenoplia. J. Clin. Cell. Immunol., 2016, 7(1), 1-6.
[48]
Eldin, I.M.T.; Ahmed, E.M.; Abd, E.H. Preliminary study of the clinical hypoglycemic effects of Allium cepa (red onion) in type 1 and type 2 diabetic patients. Environ. Health Insights, 2010, 4, S5540. [EHI]
[49]
Halliwell, B. Antioxidants in human health and disease. Annu. Rev. Nutr., 1996, 16(1), 33-50.
[http://dx.doi.org/10.1146/annurev.nu.16.070196.000341] [PMID: 8839918]
[50]
Hsu, H-C.; Hsu, C-I.; Lin, R-H.; Kao, C-L.; Lin, J-Y. Fip-vvo, a new fungal immunomodulatory protein isolated from Volvariella volvacea. Biochem. J., 1997, 323(Pt 2), 557-565.
[http://dx.doi.org/10.1042/bj3230557] [PMID: 9163352]
[51]
Fontaine, O. Bacterial diarrhoea and treatment. Lancet, 1988, 1(8596), 1234-1235.
[http://dx.doi.org/10.1016/S0140-6736(88)92062-4] [PMID: 2897052]
[52]
Aranda-Michel, J.; Giannella, R.A. Acute diarrhea: A practical review. Am. J. Med., 1999, 106(6), 670-676.
[http://dx.doi.org/10.1016/S0002-9343(99)00128-X] [PMID: 10378626]
[53]
Pires, D.E.; Blundell, T.L.; Ascher, D.B. pkCSM: Predicting small-molecule pharmacokinetic and toxicity properties using graph-based signatures. J. Med. Chem., 2015, 58(9), 4066-4072.
[54]
Matin, M.M.; Chakraborty, P.; Alam, M.S.; Islam, M.M.; Hanee, U. 2020.
[55]
Lin, J.H.; Yamazaki, M. Role of P-glycoprotein in pharmacokinetics. Clin. Pharmacokinet., 2003, 42, 59-98.
[56]
Tzvetkov, M.; Vormfelde, S.; Balen, D.; Meineke, I.; Schmidt, T.; Sehrt, D.; Sabolić, I.; Koepsell, H.; Brockmöller, J. The effects of genetic polymorphisms in the organic cation transporters OCT1, OCT2, and OCT3 on the renal clearance of metformin. Clin. Pharmacol. Ther., 2009, 86(3), 299-306.
[57]
Matin, M.M.; Bhattacharjee, S.C.; Chakraborty, P.; Alam, M.S. Synthesis, PASS predication, in vitro antimicrobial evaluation and pharmacokinetic study of novel n-octyl glucopyranoside esters. Carbohydr. Res., 2019, 485107812
[58]
Curran, M.E.; Splawski, I.; Timothy, K.W.; Vincen, G.M.; Green, E.D.; Keating, M.T. A molecular basis for cardiac arrhythmia: HERG mutations cause long QT syndrome. Cell, 1995, 80(5), 795-803.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version319msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[15:12:17] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[15:12:17] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[15:12:17] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[15:12:17] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (115ms)time
  • Application (204ms)time
  • 1 x Application (64.05%)
    204ms
    1 x Booting (35.95%)
    115ms
    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 duplicated119ms
    • 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 ('309791667','',1,1740496337,1740496337) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740496337
      1.17msalphaeurekaselec_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 ('309791667','/article/117253',1,1740496337,1740496337)
      260μ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 >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) 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 >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) 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 >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) 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 >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) 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 >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) 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 >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) limit 1
      19.36msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 309791667
      • 1: 309791667
      • 2: 309791667
      • 3: 309791667
      • 4: 309791667
      • 5: 309791667
      • 6: 309791667
      • 7: 309791667
      • 8: 309791667
      • 9: 309791667
      • 10: 309791667
      • 11: 309791667
      • 12: 309791667
      • 13: 309791667
      • 14: 309791667
      • 15: 309791667
      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=117253
      910μ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` = 56 limit 1
      1.02msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 56
      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=56) and sj.journal_id!=56 group by `j`.`nid`) as `aggregate_table`
      1.61msalphaeurekaselec_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=56) and sj.journal_id!=56 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.27msalphaeurekaselec_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=56) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.96msalphaeurekaselec_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=56) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      2.6msalphaeurekaselec_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` = '117253'
      960μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 117253
      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` = '117253'
      2.99msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 117253
      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` = '117253' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.67msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 117253
      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
      260μ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
      460μ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 = 56 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      28.31msalphaeurekaselec_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 = 56 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      14.95msalphaeurekaselec_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 = 56 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      11.17msalphaeurekaselec_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` = 117253 limit 1
      750μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 117253
      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 = 117253 and content_type = 'article' order by status desc limit 1
      270μ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` = 195508 limit 1
      190μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 195508
      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
      300μ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` = 'MRMC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      360μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: MRMC
      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 = '117253' 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) )
      1.77msalphaeurekaselec_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 = '11282' and content_type = 'i' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      390μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '3185' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      360μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2231
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740496337 and j.to_date >= 1740496337 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3185) 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740496337 and j.to_date >= 1740496337 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3185) 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740496337 and j.to_date >= 1740496337 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3185)
      11.66msalphaeurekaselec_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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740496337 and j.to_date >= 1740496337 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11282) 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740496337 and j.to_date >= 1740496337 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11282) 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740496337 and j.to_date >= 1740496337 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11282)
      800μ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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740496337 and j.to_date >= 1740496337 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 117253) 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740496337 and j.to_date >= 1740496337 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 117253) 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740496337 and j.to_date >= 1740496337 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 117253)
      820μ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` < '640' and is_uploaded = 1 and issue_id = 11282 order by cast(first_page as SIGNED) desc limit 1
      660μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 640
      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` > '660' and is_uploaded = 1 and issue_id = 11282 order by cast(first_page as SIGNED) asc limit 1
      550μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 660
      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'
      230μ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
      300μ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` = 117253 limit 1
      3.67msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 117253
      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` = 56 and `b`.`banner_from_date` <= 1740496337 and `b`.`banner_to_date` >= 1740496337 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.6msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 56
      • 3: 1740496337
      • 4: 1740496337
      • 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` = 56 and `b`.`banner_from_date` <= 1740496337 and `b`.`banner_to_date` >= 1740496337 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.18msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 56
      • 3: 1740496337
      • 4: 1740496337
      • 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='877a3c24686c1e0ff15e5115db7f1368'
      260μ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
        cXtuayYfXH13DHs5TRCokvj6RxfOcuLUsr9f0CLV
        uc_cart_id
        877a3c24686c1e0ff15e5115db7f1368
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/117253" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/117253
        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=eyJpdiI6IlVQRzBER3dtUDBJVmw0OVpiMUpCZGc9PSIsInZhbHVlIjoiZmxtVzIwWmZPTmdkc3hXd2R6V0lpMWlEYUhHLyt6RlNyM2Y0M05rVGVVM3U3MjJoRXlBZXVQOVg3ak10cjVyUkorRXgvM2l3ZDVhc0o3MUp4bHZPc3c9PSIsIm1hYyI6IjQ1MmQwNmY5OGM0ZGU4YjRhZDNjNTE2ZDM3NjJjOTJlZWI2YmMzZTI5OGMyMzE3ZGIzZGU5NTcxZjQ5NDQzZjgiLCJ0YWciOiIifQ%3D%3Dwayfindertarget=eyJpdiI6IlVQRzBER3dtUDBJVmw0OVpiMUpCZGc9PSIsInZhbHVlIjoiZmxtVzIwWmZPTmdkc3hXd2R6V0lpMWlEYUhHLyt6RlNyM2Y0M05rVGVVM3U3MjJoRXlBZXVQOVg3ak10cjVyUkor" ] "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 15:12:17 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ikh1S2dFeGZTR1RvWDhObUxOeld3ZXc9PSIsInZhbHVlIjoiQ005cUdrSFRqditBMDdNdHJVQ2FneDhxSUc1UE1EYTQ2YmNibmJheWlNUzhQZ1hBM0V0NURnRk10WmRzUEp6NjNPcWNqaE4zV0lxcUc5QmxHRldJWSswenhqUHYxYjROc2pETG1xQzBzRzMrWUtmN3FXbWlkRGRXcm5aQzh4MjQiLCJtYWMiOiIyZWY5ZTJiYTVkMDc0N2QyZDk5ZTJhYjkxNzRjZDU4Y2UzM2ZjNDMyYmY2YjRlYTBmMDgyYmQ1ZjlkMDhmY2NhIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 03:12:17 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ikh1S2dFeGZTR1RvWDhObUxOeld3ZXc9PSIsInZhbHVlIjoiQ005cUdrSFRqditBMDdNdHJVQ2FneDhxSUc1UE1EYTQ2YmNibmJheWlNUzhQZ1hBM0V0NURnRk10WmRzUEp6NjNPcWNqa" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjBjcUYrci9lMUFiYjhreXVrQ0NHZ3c9PSIsInZhbHVlIjoiWCtmK1NIem5PaFNJWit0WlIrNk1nTmNhTHFJVzUzMGZ5VUJidGZDMUNWRHRXcXRFS0VZeFViVERRRE0wMnRNdjBIL1dMMTBiZ0RzaS9iUDBCZnlIS0pTbDFFYUFlUGdTdjBvS0toK1Nxb05pb0Z4T3hja0lmOHFOVTUydmxydk8iLCJtYWMiOiJhNTllY2E4NzA0NGZiZDc2ZTBjYjQzY2M5NDRhMzNkYzA2OWY1Nzc3Yzk4MzhhN2Q0ZTlkNTFiOTVhYWY1ODg5IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IjBjcUYrci9lMUFiYjhreXVrQ0NHZ3c9PSIsInZhbHVlIjoiWCtmK1NIem5PaFNJWit0WlIrNk1nTmNhTHFJVzUzMGZ5VUJidGZDMUNWRHRXcXRFS0VZeFViVER" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ikh1S2dFeGZTR1RvWDhObUxOeld3ZXc9PSIsInZhbHVlIjoiQ005cUdrSFRqditBMDdNdHJVQ2FneDhxSUc1UE1EYTQ2YmNibmJheWlNUzhQZ1hBM0V0NURnRk10WmRzUEp6NjNPcWNqaE4zV0lxcUc5QmxHRldJWSswenhqUHYxYjROc2pETG1xQzBzRzMrWUtmN3FXbWlkRGRXcm5aQzh4MjQiLCJtYWMiOiIyZWY5ZTJiYTVkMDc0N2QyZDk5ZTJhYjkxNzRjZDU4Y2UzM2ZjNDMyYmY2YjRlYTBmMDgyYmQ1ZjlkMDhmY2NhIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 03:12:17 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ikh1S2dFeGZTR1RvWDhObUxOeld3ZXc9PSIsInZhbHVlIjoiQ005cUdrSFRqditBMDdNdHJVQ2FneDhxSUc1UE1EYTQ2YmNibmJheWlNUzhQZ1hBM0V0NURnRk10WmRzUEp6NjNPcWNqa" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjBjcUYrci9lMUFiYjhreXVrQ0NHZ3c9PSIsInZhbHVlIjoiWCtmK1NIem5PaFNJWit0WlIrNk1nTmNhTHFJVzUzMGZ5VUJidGZDMUNWRHRXcXRFS0VZeFViVERRRE0wMnRNdjBIL1dMMTBiZ0RzaS9iUDBCZnlIS0pTbDFFYUFlUGdTdjBvS0toK1Nxb05pb0Z4T3hja0lmOHFOVTUydmxydk8iLCJtYWMiOiJhNTllY2E4NzA0NGZiZDc2ZTBjYjQzY2M5NDRhMzNkYzA2OWY1Nzc3Yzk4MzhhN2Q0ZTlkNTFiOTVhYWY1ODg5IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IjBjcUYrci9lMUFiYjhreXVrQ0NHZ3c9PSIsInZhbHVlIjoiWCtmK1NIem5PaFNJWit0WlIrNk1nTmNhTHFJVzUzMGZ5VUJidGZDMUNWRHRXcXRFS0VZeFViVER" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "cXtuayYfXH13DHs5TRCokvj6RxfOcuLUsr9f0CLV" "uc_cart_id" => "877a3c24686c1e0ff15e5115db7f1368" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/117253" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 15:12:17GET/article/117253414361