Generic placeholder image

Current Nutrition & Food Science

Editor-in-Chief

ISSN (Print): 1573-4013
ISSN (Online): 2212-3881

Research Article

Chemical Composition and Biological Activities of Essential Oils of Echinops spinosus and Carlina vulgaris Rich in Polyacetylene Compounds

Author(s): Rania Belabbes, Imane R. Mami, Mohammed E.A. Dib*, Kenza Mejdoub, Boufeldja Tabti, Jean Costa and Alain Muselli

Volume 16, Issue 4, 2020

Page: [563 - 570] Pages: 8

DOI: 10.2174/1573401315666190206142929

Price: $65

Abstract

Background: The essential oils of aromatic plants are increasingly used as new biocontrol alternative agents against microbial strains and insect pests of fruits and vegetables, because of their specificity of biodegradable nature.

Objectives: This work, treats for the first time the chemical composition, antioxidant, antifungal and insecticidal activities of the essential oils obtained from Echinops spinosus and Carlina vulgaris from Algeria.

Methods: The chemical compositions of oils were investigated using GC-FID and GC/MS. Antioxidant activity was assessed using three methods (2,2-diphenyl-1-picrylhydrazyl, Ferric-Reducing Antioxidant Power (FRAP) and β-carotene assay). Fumigation toxicity of E. spinosus and C. vulgaris essential oils was tested against Bactrocera oleae pests of olives.

Results: Eighteen and thirteen components representing 95.4 and 97.9% were identified in root essential oils from Echinops spinosus and Carlina vulgaris, respectively. Polyacetylenes were the majority compounds of essential oils. 5(But-1-yn-3-enyl)2,2′bithiophene and α-terthienyle were highly dominants in the E. spinosus essential oil from the roots (54.4 and 26.3%, respectively). Roots of C. vulgaris produce an essential oil dominated by carlina oxide (33.7%) and 13-methoxy carlina oxide (11.5%). Comparison of the antioxidant activity of E. spinosus essential oil showed more important antioxidant effect than C. vulgaris essential oil and the synthetic antioxidant (BHT). Evaluation of the antifungal activity showed an interesting efficiency of both essential oils against P. expansum and A. niger with EC50s varied from 5 to 14.5 mg/L. C. arvensis essential oil exhibited good larvicidal properties. At the concentration of 325 μL/L air, the oil caused mortality of 100% for Bactrocera Oleae adults after 24 h of exposure.

Conclusion: Both essential oils rich to polyacetylenes and polythiophenes.components have shown interesting biological activities, which suggests that plants have the potential to be used as biopesticides and provide an alternative to chemical pesticides.

Keywords: Biological activities, C. vulgaris, chemical pesticides, E. spinosus, essential oils, insecticidal effect.

Graphical Abstract

[1]
Russo A, Perri M, Cione E, Di Gioia ML, Nardi M, Cristina Caroleo M. Biochemical and chemical characterization of Cynara cardunculus L. extract and its potential use as co-adjuvant therapy of chronic myeloid leukemia. J Ethnopharmacol 2017; 202: 184-91.
[http://dx.doi.org/10.1016/j.jep.2017.03.026] [PMID: 28323047]
[2]
Sindona G, Caruso A, Cozza A, et al. Anti-inflammatory effect of 3,4-DHPEA-EDA [2-(3,4 -hydroxyphenyl) ethyl (3S, 4E)-4-formyl-3-(2-oxoethyl)hex-4-enoate] on primary human vascular endothelial cells. Curr Med Chem 2012; 19(23): 4006-13.
[http://dx.doi.org/10.2174/092986712802002536] [PMID: 22680639]
[3]
Nardi M, Bonacci S, De Luca G, et al. Biomimetic synthesis and antioxidant evaluation of 3,4-DHPEA-EDA [2-(3,4- hydroxyphenyl) ethyl (3S,4E)-4-formyl-3-(2-oxoethyl)hex-4- enoate]. Food Chem 2014; 162: 89-93. [2-(3,4 -hydroxyphenyl) ethyl (3S, 4E)-4-formyl-3-(2-oxoethyl)hex-4-enoate)]. 2014.
[http://dx.doi.org/10.1016/j.foodchem.2014.04.015] [PMID: 24874361]
[4]
Nardi M, Bonacci S, Cariati L, et al. Synthesis and antioxidant evaluation of lipophilic oleuropein aglycone derivatives. Food Funct 2017; 8(12): 4684-92.
[http://dx.doi.org/10.1039/C7FO01105A] [PMID: 29160876]
[5]
Ain Sebaa N, Tabet Zatla A, Dib MA, Tabti B, Costa J, Alain M. Antifungal activity of essential oil and hydrosol extract of Ballota nigra L. and their protective effects against the black rot of tomatoes. Curr Nutr Food Sci 2018. [Epub ahead of print].
[6]
Bitsindou M, Lejoly L. Les plantes employées contre les affections hépatiques en médecine traditionnelle africaine. Actes du 2ème Colloque Européen d’Ethnopharmacologie et de la Conférence internationale d’Ethnomédecine. 163-6.
[7]
Quezel P, Santa S. Nouvelle flore de l’Algérie et des régions désertiques méridionale. Paris: National Center for Scientific Research 1963.
[8]
Kit T. Seven new species of Echinops (Asteraceae). Ann Bot Fenn 1995; 32(2): 117-26.
[9]
Ni ZY, Nagashima Y, Zhang ML, et al. 11-Hydroxyisocom-2-en-5-one, a new sesquiterpenoid from Echinops spinosissimus. Chem Nat Compd 2013; 4(49): 632-4.
[http://dx.doi.org/10.1007/s10600-013-0696-8]
[10]
Bouattour E, Fakhfakh J, Affes M, Chawech R, Damak M, Jarraya R. Chemical constituents of Echinops spinosus From Tunisia. J Nat Comp 2017; 53(5): 1-4.
[http://dx.doi.org/10.1007/s10600-017-2179-9]
[11]
Dong M, Cong B, Yu SH, et al. Echinopines A and B: sesquiterpenoids possessing an unprecedented skeleton from Echinops spinosus. Org Lett 2008; 10(5): 701-4.
[http://dx.doi.org/10.1021/ol702629z] [PMID: 18251544]
[12]
Strzemski M, Wójciak-Kosior M, Sowa I, et al. Carlina species as a new source of bioactive pentacyclic triterpenes. Ind Crops Prod 2016; 94: 498-504.
[http://dx.doi.org/10.1016/j.indcrop.2016.09.025]
[13]
Chalchat J, Djordjevic S, Gorunovic M. Composition of the essential oil from the root of Carlina acaulis L. Asteraceae. J Essent Oil Res 1996; 8(5): 577-8.
[http://dx.doi.org/10.1080/10412905.1996.9700696]
[14]
Strzemski M, Wójciak-Kosior M, Sowa I, et al. Carlina vulgaris L. as a source of phytochemicals with antioxidant activity. Oxid Med Cell Longev 2017; 20171891849
[http://dx.doi.org/10.1155/2017/1891849] [PMID: 29181123]
[15]
Jennings W, Shibamoto T. Analytical considerations Qualitative analysis of flavour and fragrance volatiles by glass-capillary gas chromatography. 1st ed. New York: Academic Press 1980; pp. 1-27.
[http://dx.doi.org/10.1016/B978-0-12-384250-3.50004-0]
[16]
König WA, Hochmuth DH, Joulain D. Terpenoids and related constituents of essential oils Library of Mass Finder. Hamburg: Institute of Organic Chemistry 2001.
[17]
National Institute of Standards and Technology. 2008.Available from: www.webbook.nist.gov/chemistry
[18]
Mc Lafferty FW, Stauffer DB. The Wiley/NBS Registry of Mass Spectra Data New-York. Wiley-Interscience 1988.
[19]
Mc Lafferty FW, Stauffer DB. Wiley Registry of Mass Spectral Data. In: Mass Spectrometry Library Search System Bench-Top/PBM version 310d Palisade. Newfield 1994.
[20]
National Institute of Standards and Technology. PC Version 17 of the NIST/EPA/NIH Mass Spectral Library. Norwalk, CT, USA: Perkin-Elmer Corp. 1999.
[21]
Djabou N, Lorenzi V, Guinoiseau E, et al. Phytochemical composition of Corsican teucrium essential oils and antibacterial activity against foodborne or toxi-infectious pathogens. Food Control 2013; 30(1): 354-63.
[http://dx.doi.org/10.1016/j.foodcont.2012.06.025]
[22]
Belabbes R, Dib MEA, Djabou N, et al. Chemical variability, antioxidant and antifungal activities of essential oils and hydrosol extract of Calendula arvensis L. from Western Algeria. Chem Biodivers 2017; 14(5)e1600482
[http://dx.doi.org/10.1002/cbdv.201600482] [PMID: 28109063]
[23]
Tian J, Ban X, Zeng H, Huang B, He J, Wang Y. In vitro and in vivo activity of essential oil from dill (Anethum graveolens L.) against fungal spoilage of cherry tomatoes. Food Control 2011; 22(12): 1992-9.
[http://dx.doi.org/10.1016/j.foodcont.2011.05.018]
[24]
Pandey DK, Tripathi NN, Tripathi RD. Fungitoxic and phytotoxic properties of essential oil of Hyptissu aveolens. J Plant Dis Prot 1982; 89: 344-9.
[25]
Bouayad Alam S, Dib MEA, Djabou N, et al. Essential oils as biocides for the control of fungal infections and devastating pest (Tuta absoluta) of tomato (Lycopersicon esculentum Mill.). Chem Biodivers 2017; 14(7)e1700065
[http://dx.doi.org/10.1002/cbdv.201700065] [PMID: 28422413]
[26]
Abbott WS. A method for computing the effectiveness of an insecticide. J Econ Entomol 1925; 18: 265-7.
[http://dx.doi.org/10.1093/jee/18.2.265a]
[27]
Radulović N, Denić M. Essential oils from the roots of Echinops bannaticus Rochel ex Schrad, and Echinops sphaerocephalus L. (Asteraceae): Chemotaxonomic and Biosynthetic Aspects. Chem biodiverse 2013; 10(4): 658-76.
[28]
Menut C, Lamaty G, Weyerstahl P, Marschall H, Seelmann I, Zollo PH. Aromatic plants of Tropical Central Africa. Part I. Tricyclic sesquiterpenes from the root essential oil of Echinops giganteus var. lelyi C. D. Adams. Flavour Fragrance J 1997; 6(12): 415-21.
[http://dx.doi.org/10.1002/(SICI)1099-1026(199711/12)12:6<415:AID-FFJ666>3.0.CO;2-T]
[29]
Tariku Y, Hymete A, Hailu A, Rohloff J. In vitro evaluation of antileishmanial activity and toxicity of essential oils of Artemisia absinthium and Echinops kebericho. Chem Biodivers 2011; 8(4): 614-23.
[http://dx.doi.org/10.1002/cbdv.201000331] [PMID: 21480507]
[30]
Djordjevic S, Petrovic S, Ristic M, Djokovic D. Composition of Carlina acanthifolia root essential oil. Chem Nat Compd 2015; 4(44): 410-2.
[31]
Tepe B, Sokmen M, Akpulat H, Sokmen A. Screening of the antioxidant potentials of six Salvia species from Turkey. Food Chem 2006; (95): 200-4.
[http://dx.doi.org/10.1016/j.foodchem.2004.12.031]
[32]
Zhao MP, Liu QZ, Liu Q, Liu ZL. Identification of larvicidal constituents of the essential oil of Echinops grijsii roots against the three species of mosquitoes. Molecules 2017; 22(2): 1-11.
[http://dx.doi.org/10.3390/molecules22020205] [PMID: 28134799]
[33]
Tang X, Chen S, Wang L. Isolation and Insecticidal activity of farnesol from Stellera chamaejasme. Asian J Chem 2001; 3(23): 1233-5.
[34]
Jin W, Shi Q, Hong C, Cheng Y, Ma Z, Qu H. Cytotoxic properties of thiophenes from Echinops grijissi Hance. Phytomedicine 2008; 15(9): 768-74.
[http://dx.doi.org/10.1016/j.phymed.2007.10.007] [PMID: 18068965]
[35]
Nakano H, Cantrell CL, Mamonov LK, Osbrink WL, Ross SA. Echinopsacetylenes A and B, new thiophenes from Echinops transiliensis. Org Lett 2011; 13(23): 6228-31.
[http://dx.doi.org/10.1021/ol202680a] [PMID: 22066834]
[36]
Hudson JB, Graham EA, Micki N, Hudson L, Towers GH. Antiviral activity of the photoactive thiophene alpha-terthienyl. Photochem Photobiol 1986; 44(4): 477-82.
[http://dx.doi.org/10.1111/j.1751-1097.1986.tb04695.x] [PMID: 3024189]
[37]
Herrmann F, Hamoud R, Sporer F, Tahrani A, Wink M. Carlina oxide--a natural polyacetylene from Carlina acaulis (Asteraceae) with potent antitrypanosomal and antimicrobial properties. Planta Med 2011; 77(17): 1905-11.
[http://dx.doi.org/10.1055/s-0031-1279984] [PMID: 21678234]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version321msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[13:39:06] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[13:39:06] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[13:39:06] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (104ms)time
  • Application (217ms)time
  • 1 x Application (67.72%)
    217ms
    1 x Booting (32.27%)
    104ms
    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 duplicated123ms
    • 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 ('316686355','',1,1739972346,1739972346) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739972346
      1.18msalphaeurekaselec_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 ('316686355','/article/96402',1,1739972346,1739972346)
      210μ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 >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) 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 >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) 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 >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) 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 >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) 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 >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) 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 >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316686355 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316686355) limit 1
      24.33msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316686355
      • 1: 316686355
      • 2: 316686355
      • 3: 316686355
      • 4: 316686355
      • 5: 316686355
      • 6: 316686355
      • 7: 316686355
      • 8: 316686355
      • 9: 316686355
      • 10: 316686355
      • 11: 316686355
      • 12: 316686355
      • 13: 316686355
      • 14: 316686355
      • 15: 316686355
      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=96402
      680μ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` = 35 limit 1
      790μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 35
      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=35) and sj.journal_id!=35 group by `j`.`nid`) as `aggregate_table`
      520μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=35) and sj.journal_id!=35 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      500μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=35) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      840μsalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 16. app/Models/Subject.php:220
      • 17. app/Http/Controllers/ArticleController.php:2518
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=35) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      790μsalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 14. app/Models/Subject.php:220
      • 15. app/Http/Controllers/ArticleController.php:2518
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `keywords` where `article_id` = '96402'
      690μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 96402
      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` = '96402'
      2.26msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 96402
      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` = '96402' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.7msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 96402
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ArticleController.php:2533
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      230μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      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 = 35 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      26.05msalphaeurekaselec_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 = 35 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      15.49msalphaeurekaselec_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 = 35 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      7.22msalphaeurekaselec_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` = 96402 limit 1
      250μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 96402
      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 = 96402 and content_type = 'article' order by status desc limit 1
      240μ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` = 169671 limit 1
      190μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 169671
      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
      210μ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` = 'CNF' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      300μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CNF
      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 = '96402' 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) )
      350μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2186
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '9870' 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) )
      280μ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 = '2736' 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) )
      260μ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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1739972346 and j.to_date >= 1739972346 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2736) 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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1739972346 and j.to_date >= 1739972346 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2736) 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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1739972346 and j.to_date >= 1739972346 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2736)
      29.27msalphaeurekaselec_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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1739972346 and j.to_date >= 1739972346 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9870) 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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1739972346 and j.to_date >= 1739972346 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9870) 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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1739972346 and j.to_date >= 1739972346 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9870)
      590μ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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1739972346 and j.to_date >= 1739972346 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96402) 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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1739972346 and j.to_date >= 1739972346 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96402) 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 <= 316686355 and j.to_ip >=316686355 )) and ((j.from_date <= 1739972346 and j.to_date >= 1739972346 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96402)
      550μ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` < '563' and is_uploaded = 1 and issue_id = 9870 order by cast(first_page as SIGNED) desc limit 1
      620μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 563
      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` > '570' and is_uploaded = 1 and issue_id = 9870 order by cast(first_page as SIGNED) asc limit 1
      520μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 570
      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'
      190μ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
      210μ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` = 96402 limit 1
      2.43msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 96402
      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` = 35 and `b`.`banner_from_date` <= 1739972346 and `b`.`banner_to_date` >= 1739972346 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.14msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 35
      • 3: 1739972346
      • 4: 1739972346
      • 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` = 35 and `b`.`banner_from_date` <= 1739972346 and `b`.`banner_to_date` >= 1739972346 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.13msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 35
      • 3: 1739972346
      • 4: 1739972346
      • 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='359d02f3ee79c05528d19367af9f2f46'
      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
        hqxiyiBQTRImQ8PJxq4aABKRGJjVhPBGZiRfsPlq
        uc_cart_id
        359d02f3ee79c05528d19367af9f2f46
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/96402" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/96402
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 19 Feb 2025 13:39:06 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjUzTGY3YkZRN1doM0xaWUxvUHhwYmc9PSIsInZhbHVlIjoiSEFJTFBhZFl1TVcxNmJicEMrV3pLWVRqem14aTAwN2dTY3RBYmlldWQ4WXhJaGY2M2xsY1FlWFFMU0pWVmw3RndmODFYVGs5L1BYazk2Sjc3eFNQZWVFMU1QT0trTlY0djk4dWhuQlNvYkhQemV4TE9zcjVwbWw5NHFOVXY3a3AiLCJtYWMiOiJkOTFlZmYzNzE3YTFkMDVmMWM3NmE4MTBiMmI1MTc2MDc1MzJkZTY2NmVlZjE5ZDliMDVhZWVmZDFlZjRmMWU5IiwidGFnIjoiIn0%3D; expires=Sat, 22 Feb 2025 01:39:06 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjUzTGY3YkZRN1doM0xaWUxvUHhwYmc9PSIsInZhbHVlIjoiSEFJTFBhZFl1TVcxNmJicEMrV3pLWVRqem14aTAwN2dTY3RBYmlldWQ4WXhJaGY2M2xsY1FlWFFMU0pWVmw3RndmODFYV" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkZ2S0piNVg3TTF3YmFzY1pHSW53L1E9PSIsInZhbHVlIjoibWRLQ1l6a1dhUnRMaWs4bEZvaXJGNVp4R05iODJFZzUwMVMrVTN1QmNPRXdBRktHVHQ3c21uYUtaL2lDWUUzckNVMzlDcHJxU2dBMjVjdnZrcUxhaTJOalhPZTFSbjhGN05MOGczQ1dBMVg1UGR6dEpXTkVIc1ZjSEp6bDQ4V20iLCJtYWMiOiIyNDljODYzNzY5ZGU4ZmFlMTgzZmFmYmFkYjhhY2NjYzY1NWUzNDE4NTI2YjFkZDkxMmE2NTQ3NmE4NzY1OGY2IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkZ2S0piNVg3TTF3YmFzY1pHSW53L1E9PSIsInZhbHVlIjoibWRLQ1l6a1dhUnRMaWs4bEZvaXJGNVp4R05iODJFZzUwMVMrVTN1QmNPRXdBRktHVHQ3c21uYUt" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjUzTGY3YkZRN1doM0xaWUxvUHhwYmc9PSIsInZhbHVlIjoiSEFJTFBhZFl1TVcxNmJicEMrV3pLWVRqem14aTAwN2dTY3RBYmlldWQ4WXhJaGY2M2xsY1FlWFFMU0pWVmw3RndmODFYVGs5L1BYazk2Sjc3eFNQZWVFMU1QT0trTlY0djk4dWhuQlNvYkhQemV4TE9zcjVwbWw5NHFOVXY3a3AiLCJtYWMiOiJkOTFlZmYzNzE3YTFkMDVmMWM3NmE4MTBiMmI1MTc2MDc1MzJkZTY2NmVlZjE5ZDliMDVhZWVmZDFlZjRmMWU5IiwidGFnIjoiIn0%3D; expires=Sat, 22-Feb-2025 01:39:06 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjUzTGY3YkZRN1doM0xaWUxvUHhwYmc9PSIsInZhbHVlIjoiSEFJTFBhZFl1TVcxNmJicEMrV3pLWVRqem14aTAwN2dTY3RBYmlldWQ4WXhJaGY2M2xsY1FlWFFMU0pWVmw3RndmODFYV" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkZ2S0piNVg3TTF3YmFzY1pHSW53L1E9PSIsInZhbHVlIjoibWRLQ1l6a1dhUnRMaWs4bEZvaXJGNVp4R05iODJFZzUwMVMrVTN1QmNPRXdBRktHVHQ3c21uYUtaL2lDWUUzckNVMzlDcHJxU2dBMjVjdnZrcUxhaTJOalhPZTFSbjhGN05MOGczQ1dBMVg1UGR6dEpXTkVIc1ZjSEp6bDQ4V20iLCJtYWMiOiIyNDljODYzNzY5ZGU4ZmFlMTgzZmFmYmFkYjhhY2NjYzY1NWUzNDE4NTI2YjFkZDkxMmE2NTQ3NmE4NzY1OGY2IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkZ2S0piNVg3TTF3YmFzY1pHSW53L1E9PSIsInZhbHVlIjoibWRLQ1l6a1dhUnRMaWs4bEZvaXJGNVp4R05iODJFZzUwMVMrVTN1QmNPRXdBRktHVHQ3c21uYUt" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "hqxiyiBQTRImQ8PJxq4aABKRGJjVhPBGZiRfsPlq" "uc_cart_id" => "359d02f3ee79c05528d19367af9f2f46" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/96402" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-19 13:39:06GET/article/96402314361