Generic placeholder image

Current Nutrition & Food Science

Editor-in-Chief

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

Review Article

Understanding the Role of Chlorine and Ozone to Control Postharvest Diseases in Fruit and Vegetables: A Review

Author(s): Gabriela M. Baia, Otniel Freitas-Silva* and Murillo F. Junior

Volume 16, Issue 4, 2020

Page: [455 - 461] Pages: 7

DOI: 10.2174/1573401315666190212161209

Price: $65

Abstract

Fruits and vegetables are foods that come into contact with various types of microorganisms from planting to their consumption. A lack or poor sanitation of these products after harvest can cause high losses due to deterioration and/ or pathogenic microorganisms. There are practically no post-harvest fungicides or bactericides with a broad spectrum of action that have no toxic residual effects and are safe. However, to minimize such problems, the use of sanitizers is an efficient device against these microorganisms. Chlorine is the most prevalent sanitizing agent because of its broad spectrum, low cost and well-established practices. However, the inevitable formation of disinfection by-products, such as trihalomethanes (THMs) and haloacetic acids (HAAs), is considered one of the main threats to food safety. Alternative sanitizers, such as chlorine dioxide (ClO2) and ozone, are becoming popular as a substitute for traditional post-harvest treatments. Thus, this review addresses the use of chlorine, chlorine dioxide and ozone emphasizing aspects, such as usage, safe application, spectrum of action and legislation. In order to ensure the quality and safety of final products, the adoption of well-prepared sanitation and sanitation programs for post-harvest fruits and vegetables is essential.

Keywords: Chlorine, disinfection by-products, fresh produce, ozone, phytopathogens, postharvest, sanitation.

Graphical Abstract

[1]
Beuchat LR. Ecological factors influencing survival and growth of human pathogens on raw fruits and vegetables. Microbes Infect 2002; 4(4): 413-23.
[http://dx.doi.org/10.1016/S1286-4579(02)01555-1] [PMID: 11932192]
[2]
Rico D, Martín-Diana AB, Barat JM, Barry-Ryan C. Extending and measuring the quality of fresh-cut fruit and vegetables: a review. Trends Food Sci Technol 2007; 18(7): 373-86.
[http://dx.doi.org/10.1016/j.tifs.2007.03.011]
[3]
Khazandi M, Deo P, Ferro S, et al. Efficacy evaluation of a new water sanitizer for increasing the shelf life of Southern Australian King George Whiting and Tasmanian Atlantic Salmon fillets. Food Microbiol 2017; 68: 51-60.
[http://dx.doi.org/10.1016/j.fm.2017.06.008] [PMID: 28800825]
[4]
FAO. Global food losses and food waste – Extent, causes and prevention. Rome . 2011.
[5]
Ben-Fadhel Y, Nassima Z, Stephane S, Monique L. combined post-harvest treatments for improving quality and extending shelf-life of minimally processed broccoli florets (Brassica oleracea var. italica). Food Bioprocess Technol 2018; 11(1): 84-95.
[http://dx.doi.org/10.1007/s11947-017-1992-2]
[6]
Bermúdez-Aguirre D, Barbosa-Cánovas GV. Disinfection of selected vegetables under nonthermal treatments: chlorine, acid citric, ultraviolet light and ozone. Food Control 2013; 29(1): 82-90.
[http://dx.doi.org/10.1016/j.foodcont.2012.05.073]
[7]
Glowacz M, Rees D. The practicality of using ozone with fruit and vegetables. J Sci Food Agric 2016; 96(14): 4637-43.
[http://dx.doi.org/10.1002/jsfa.7763] [PMID: 27097728]
[8]
Chaidez C, Campo NC, Heredia JB, et al. Chlorine Decontamination of fresh and minimally processed produce. Hoboken, New Jersey, United States: Wiley-Blackwell 2012; pp. 121-33.
[http://dx.doi.org/10.1002/9781118229187.ch7]
[9]
Smilanick JL, Aiyabei J, Gabler FM, Doctor J, Sorenson D, Mackey B. Quantification of the toxicity of aqueous chlorine to spores of Penicillium digitatum and Geotrichum citri-aurantii. Plant Dis 2002; 86(5): 509-14.
[http://dx.doi.org/10.1094/PDIS.2002.86.5.509] [PMID: 30818674]
[10]
Bernat M, Segarra J, Casals C, Teixidó N, Torres R, Usall J. Relevance of the main postharvest handling operations on the development of brown rot disease on stone fruits. J Sci Food Agric 2017; 97(15): 5319-26.
[http://dx.doi.org/10.1002/jsfa.8419] [PMID: 28485472]
[11]
Chen X, Hung YC. Predicting chlorine demand of fresh and fresh-cut produce based on produce wash water properties. Postharvest Biol Technol 2016; 120: 10-5.
[http://dx.doi.org/10.1016/j.postharvbio.2016.05.007]
[12]
Coroneo V, Carraro V, Marras B, et al. Presence of Trihalomethanes in ready-to-eat vegetables disinfected with chlorine. Food Addit Contam Part A Chem Anal Control Expo Risk Assess 2017; 34(12): 2111-7.
[http://dx.doi.org/10.1080/19440049.2017.1382723] [PMID: 28934070]
[13]
Ölmez H, Krestzschmar U. Potential alternative disinfection methods for organic fresh-cut industry for minimizing water consumption and environmental impact. Lebensm Wiss Technol 2009; 42(3): 686-93.
[http://dx.doi.org/10.1016/j.lwt.2008.08.001]
[14]
Klaiber RG, Baur S, Wolf G, Hammes WP, Carle R. Quality of minimally processed carrots as affected by warm water washing and chlorination. Innov Food Sci Emerg Technol 2005; 6(3): 351-62.
[http://dx.doi.org/10.1016/j.ifset.2005.03.002]
[15]
Delaquis PJ, Fukumoto LR, Toivonen PMA, Cliff MA. Implications of wash water chlorination and temperature for the microbiological and sensory properties of fresh-cut iceberg lettuce. Postharvest Biol Technol 2004; 31(1): 81-91.
[http://dx.doi.org/10.1016/S0925-5214(03)00134-0]
[16]
Park SH, Kang DH. Influence of surface properties of produce and food contact surfaces on the efficacy of chlorine dioxide gas for the inactivation of foodborne pathogens. Food Control 2017; 81: 88-95.
[http://dx.doi.org/10.1016/j.foodcont.2017.05.015]
[17]
Sun X, Zhou B, Luo Y, et al. Effect of controlled-release chlorine dioxide on the quality and safety of cherry/grape tomatoes. Food Control 2017; 82: 26-30.
[http://dx.doi.org/10.1016/j.foodcont.2017.06.021]
[18]
Ölmez H. Ozone.In: Gómez-López VM, Ed. . Decontamination of fresh and minimally processed produce. Hoboken, New Jersey, United States: Wiley-Blackwell 2012; pp. 177-95.
[http://dx.doi.org/10.1002/9781118229187.ch10]
[19]
Gómez-López VM, Devlieghere F, Ragaert P, Debevere J. Shelf-life extension of minimally processed carrots by gaseous chlorine dioxide. Int J Food Microbiol 2007; 116(2): 221-7.
[http://dx.doi.org/10.1016/j.ijfoodmicro.2006.12.008] [PMID: 17306398]
[20]
Al-Bloushi M, Saththasivam J, Jeong S, Amy GL, Leiknes T. Effect of organic on chemical oxidation for biofouling control in pilot-scale seawater cooling towers. J Water Process Eng 2017; 2(C): 1-7.
[http://dx.doi.org/10.1016/j.jwpe.2017.09.002]
[21]
Trinetta V, Linton RH, Morgan MT. The application of high-concentration short-time chlorine dioxide treatment for selected specialty crops including Roma tomatoes (Lycopersicon esculentum), cantaloupes (Cucumis melo ssp. melo var. cantaloupensis) and strawberries (Fragaria×ananassa). Food Microbiol 2013; 34(2): 296-302.
[http://dx.doi.org/10.1016/j.fm.2012.12.010] [PMID: 23541196]
[22]
Jin-Hua DU, Mao-run FU, Miao-miao LI, Wei XIA. Effects of chlorine dioxide gas on postharvest physiology and storage quality of Green Bell pepper (Capsicum frutescens L. var. Longrum). Agric Sci China 2007; 6(2): 214-9.
[http://dx.doi.org/10.1016/S1671-2927(07)60037-6]
[23]
Sy KV, McWatters KH, Beuchat LR. Efficacy of gaseous chlorine dioxide as a sanitizer for killing Salmonella, yeasts, and molds on blueberries, strawberries, and raspberries. J Food Prot 2005; 68(6): 1165-75.
[http://dx.doi.org/10.4315/0362-028X-68.6.1165] [PMID: 15954703]
[24]
Sun X, Bai J, Ference C, et al. Antimicrobial activity of controlled-release chlorine dioxide gas on fresh blueberries. J Food Prot 2014; 77(7): 1127-32.
[http://dx.doi.org/10.4315/0362-028X.JFP-13-554] [PMID: 24988018]
[25]
Wen G, Xu X, Huang T, Zhu H, Ma J. Inactivation of three genera of dominant fungal spores in groundwater using chlorine dioxide: Effectiveness, influencing factors, and mechanisms. Water Res 2017; 125(C): 132-40.
[http://dx.doi.org/10.1016/j.watres.2017.08.038] [PMID: 28843153]
[26]
Islam MZ, Mele MA, Park JM, Kim IS, Kang HM. Chlorine dioxide gas retain postharvest quality and shelf life of tomato during modified atmosphere packaging storage. Agrivita 2017; 39(3): 233-8.
[http://dx.doi.org/10.17503/agrivita.v39i3.1454]
[27]
Feliziani E, Lichter A, Smilanick JL, Ippolito A. Disinfecting agents for controlling fruit and vegetable diseases after harvest. Postharvest Biol Technol 2016; 122: 53-69.
[http://dx.doi.org/10.1016/j.postharvbio.2016.04.016]
[28]
An J, Zhang M, Lu Q. Changes in some quality indexes in fresh-cut green asparagus pretreated with aqueous ozone and subsequent modified atmosphere packaging. J Food Eng 2007; 78(1): 340-4.
[http://dx.doi.org/10.1016/j.jfoodeng.2005.10.001]
[29]
García-Martín JF, Olmo M, García JM. Effect of ozone treatment on postharvest disease and quality of different citrus varieties at laboratory and at industrial facility. Postharvest Biol Technol 2018; 137(c): 77-85.
[http://dx.doi.org/10.1016/j.postharvbio.2017.11.015]
[30]
Minas IS, Karaoglanidis GS, Manganaris GA, Vasilakakis M. Effect of ozone application during cold storage of kiwifruit on the development of stem-end rot caused by Botrytis cinerea. Postharvest Biol Technol 2010; 58(3): 203-10.
[http://dx.doi.org/10.1016/j.postharvbio.2010.07.002]
[31]
Palou L, Crisosto CH, Smilanick JL, Adaskaveg JE, Zoffoli JP. Effects of continuous 0.3 ppm ozone exposure on decay development and physiological responses of peaches and table grapes in cold storage. Postharvest Biol Technol 2002; 24(1): 39-48.
[http://dx.doi.org/10.1016/S0925-5214(01)00118-1]
[32]
Gabler FM, Smilanick JL, Mansour MF, Hakan K. Influence of fumigation with high concentrations of ozone gas on postharvest gray mold and fungicide residues on table grapes. Postharvest Biol Technol 2010; 55(2): 85-90.
[http://dx.doi.org/10.1016/j.postharvbio.2009.09.004]
[33]
Feliziani E, Romanazzi G, Smilanick JL. Application of low concentrations of ozone during the cold storage of table grapes. Postharvest Biol Technol 2014; 93: 38-48.
[http://dx.doi.org/10.1016/j.postharvbio.2014.02.006]
[34]
Ong MK, Kazi FK, Forney CF, Ali A. Effect of gaseous ozone on papaya anthracnose. Food Bioprocess Technol 2012; 6(11): 2996-3005.
[http://dx.doi.org/10.1007/s11947-012-1013-4]
[35]
Bai YP, Guo XN, Zhu KX, Zhou HM. Shelf-life extension of semi-dried buckwheat noodles by the combination of aqueous ozone treatment and modified atmosphere packaging. Food Chem 2017; 237: 553-60.
[http://dx.doi.org/10.1016/j.foodchem.2017.05.156] [PMID: 28764034]
[36]
Toti M, Carboni C, Botondi R. Postharvest gaseous ozone treatment enhances quality parameters and delays softening in cantaloupe melon during storage at 6 °C. J Sci Food Agric 2018; 98(2): 487-94.
[http://dx.doi.org/10.1002/jsfa.8485] [PMID: 28612399]
[37]
Tzortzakis N, Singleton I, Barnes J. Impact of low-level atmospheric ozone-enrichment on black spot and anthracnose rot of tomato fruit. Postharvest Biol Technol 2008; 47(1): 1-9.
[http://dx.doi.org/10.1016/j.postharvbio.2007.06.004]
[38]
Glowacz M, Rees D. Exposure to ozone reduces postharvest quality loss in red and green chilli peppers. Food Chem 2016; 210: 305-10.
[http://dx.doi.org/10.1016/j.foodchem.2016.04.119] [PMID: 27211651]
[39]
Souza LPD, Faroni LRA, Heleno FF, et al. Effects of ozone treatment on postharvest carrot quality. LWT 2018; 90: 53-60.
[http://dx.doi.org/10.1016/j.lwt.2017.11.057]
[40]
Smilanick JL, Margosan DM, Gabler FM. Impact of ozonated water on the quality and shelf-life of fresh citrus fruit, stone fruit, and table grapes. Ozone Sci Eng 2002; 24(5): 343-56.
[http://dx.doi.org/10.1080/01919510208901625]
[41]
Alvindia DG, Kobayashi T, Natsuaki KT, Tanda S. Inhibitory influence of inorganic salts on banana postharvest pathogens and preliminary application to control crown rot. J Gen Plant Pathol 2004; 70(1): 61-5.
[http://dx.doi.org/10.1007/s10327-003-0084-5]
[42]
Fischer IH, Júnior HJT, Arruda MC, Júnior NSM. Postharvest of ‘Fuerte’ and ‘Hass’ avocados: physical and chemical characteristics, damages and control of diseases. Semina. Ciênc Agrár 2011; 32(1): 209-20.
[http://dx.doi.org/10.5433/1679-0359.2011v32n1p209]
[43]
Karabulut OA, Ilhan K, Arslan U, Vardar C. Evaluation of the use of chlorine dioxide by fogging for decreasing postharvest decay of fig. Postharvest Biol Technol 2009; 52(3): 313-5.
[http://dx.doi.org/10.1016/j.postharvbio.2009.01.006]
[44]
Sharpe D, Fan L, McRae K, Walker B, MacKay R, Doucette C. Effects of ozone treatment on Botrytis cinerea and Sclerotinia sclerotiorum in relation to horticultural product quality. J Food Sci 2009; 74(6): M250-7.
[http://dx.doi.org/10.1111/j.1750-3841.2009.01234.x] [PMID: 19723209]
[45]
Barth MM, Zhou C, Merciet J, Payne FA. Ozone storage effects on anthocyanin content and fungal growth in blackberries. J Food Sci 1995; 60(6): 1286-8.
[http://dx.doi.org/10.1111/j.1365-2621.1995.tb04575.x]
[46]
Tzortzakis N, Singleton I, Barnes J. Deployment of low-level ozone-enrichment for the preservation of chilled fresh produce. Postharvest Biol Technol 2007; 43(2): 261-70.
[http://dx.doi.org/10.1016/j.postharvbio.2006.09.005]
[47]
Alegria C, Pinheiro J, Gonçalves EM, Fernandes I, Moldão M, Abreu M. Quality atributes of shredded carrot (Daucus carota L. cv. Nantes) as affected by alternative decontamination processes to chlorine. Innov Food Sci Emerg Technol 2009; 10(1): 61-9.
[http://dx.doi.org/10.1016/j.ifset.2008.08.006]
[48]
Zhang L, Lu Z, Yu Z, Gao X. Preservation of fresh-cut celery by treatment of ozonated water. Food Control 2005; 16(3): 279-83.
[http://dx.doi.org/10.1016/j.foodcont.2004.03.007]
[49]
Miller FA, Silva CLM, Brandão TRS. A review on ozone-based treatments for fruit and vegetables preservation. Food Eng Rev 2013; 5(2): 77-106.
[http://dx.doi.org/10.1007/s12393-013-9064-5]
[50]
Silva OF, de Souza AM. Ozone in food processing: impact on food products attributes. In: Jaiswal Amit K, Ed.. Food Processing Technologies: impact on Product Attributes. Boca Raton: CRC Press 2016; pp. 519-52.
[51]
Hung YC, Waters BW, Yemmireddy VK, Huang CH. pH effect on the formation of THM and HAA disinfection byproducts and potential control strategies for food processing. J Integr Agric 2017; 16(12): 2914-23.
[http://dx.doi.org/10.1016/S2095-3119(17)61798-2]
[52]
Gómez-López VM, Rajkovic A, Ragaert P, Smigic N, Devlieghere F. Chlorine dioxide for minimally processed produce preservation: a review. Trends Food Sci Technol 2009; 20(1): 17-26.
[http://dx.doi.org/10.1016/j.tifs.2008.09.005]
[53]
Gómez-López VM. Chlorine dioxide Decontamination of fresh and minimally processed produce. Hoboken, New Jersey, United States: Wiley-Blackwell 2012; pp. 165-75.
[http://dx.doi.org/10.1002/9781118229187.ch9]
[54]
Lee Y, Burgess G, Rubino M, Auras R. Reaction and diffusion of chlorine dioxide gas under dark and light conditions at different temperatures. J Food Eng 2015; 144: 20-8.
[http://dx.doi.org/10.1016/j.jfoodeng.2014.07.008]
[55]
Karaca H, Velioglu YS. Effects of ozone treatments on microbial quality and some chemical properties of lettuce, spinach, and parsley. Postharvest Biol Technol 2014; 88: 46-53.
[http://dx.doi.org/10.1016/j.postharvbio.2013.09.003]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version347msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[15:42:31] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[15:42:31] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[15:42:31] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (130ms)time
  • Application (217ms)time
  • 1 x Application (62.59%)
    217ms
    1 x Booting (37.41%)
    130ms
    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 ('316381173','',1,1740498151,1740498151) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740498151
      2.29msalphaeurekaselec_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 ('316381173','/article/96605',1,1740498151,1740498151)
      220μ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 >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) 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 >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) 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 >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) 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 >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) 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 >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) 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 >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316381173 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316381173) limit 1
      19.53msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316381173
      • 1: 316381173
      • 2: 316381173
      • 3: 316381173
      • 4: 316381173
      • 5: 316381173
      • 6: 316381173
      • 7: 316381173
      • 8: 316381173
      • 9: 316381173
      • 10: 316381173
      • 11: 316381173
      • 12: 316381173
      • 13: 316381173
      • 14: 316381173
      • 15: 316381173
      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=96605
      3.73msalphaeurekaselec_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
      1.16msalphaeurekaselec_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`
      760μ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
      640μ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`
      6.22msalphaeurekaselec_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
      1.59msalphaeurekaselec_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` = '96605'
      2.32msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 96605
      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` = '96605'
      3.04msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 96605
      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` = '96605' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.17msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 96605
      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
      450μ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
      33.13msalphaeurekaselec_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
      10.54msalphaeurekaselec_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
      6.52msalphaeurekaselec_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` = 96605 limit 1
      960μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 96605
      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 = 96605 and content_type = 'article' order by status desc limit 1
      360μ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` = 169931 limit 1
      230μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 169931
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      250μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CNF' 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: 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 = '96605' 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) )
      440μ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) )
      380μ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) )
      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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1740498151 and j.to_date >= 1740498151 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1740498151 and j.to_date >= 1740498151 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1740498151 and j.to_date >= 1740498151 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)
      16.48msalphaeurekaselec_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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1740498151 and j.to_date >= 1740498151 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1740498151 and j.to_date >= 1740498151 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1740498151 and j.to_date >= 1740498151 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)
      710μ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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1740498151 and j.to_date >= 1740498151 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96605) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1740498151 and j.to_date >= 1740498151 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96605) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1740498151 and j.to_date >= 1740498151 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96605)
      630μ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` < '455' and is_uploaded = 1 and issue_id = 9870 order by cast(first_page as SIGNED) desc limit 1
      660μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 455
      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` > '461' and is_uploaded = 1 and issue_id = 9870 order by cast(first_page as SIGNED) asc limit 1
      590μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 461
      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'
      200μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      250μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 96605 limit 1
      2.51msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 96605
      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` <= 1740498151 and `b`.`banner_to_date` >= 1740498151 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: 35
      • 3: 1740498151
      • 4: 1740498151
      • 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` <= 1740498151 and `b`.`banner_to_date` >= 1740498151 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.16msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 35
      • 3: 1740498151
      • 4: 1740498151
      • 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='97555b35277da6100b8b5c6362ff805a'
      240μ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
        oOTz3LSL5go3i8RzFWNCUAYOCni9jtN0dgBS3q36
        uc_cart_id
        97555b35277da6100b8b5c6362ff805a
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/96605" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/96605
        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=eyJpdiI6IitBbmY0SXUyM2ZTSlJzek9DTHZwaVE9PSIsInZhbHVlIjoiaEJzYkZWOHRCbVFtRm5ZUnFEY3JUaGhRenliRytWbTUxUWVEdWFCckZWND0iLCJtYWMiOiIzMGMyNTFjMGU4Yzk0OWQ4Mzc0NTQxZmY4NWEzNTk5NjRkNGIzYWExNWI0N2IwODJmMzVjYTA4NTU5YTEwOWJkIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IitBbmY0SXUyM2ZTSlJzek9DTHZwaVE9PSIsInZhbHVlIjoiaEJzYkZWOHRCbVFtRm5ZUnFEY3JUaGhRenliRytWbTUxUWVEdWFCckZWND0iLCJtYWMiOiIzMGMyNTFjMGU4Yzk0" ] "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:42:31 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlAzQTNoaGdJeCs3MHZqUEdEY2VnVkE9PSIsInZhbHVlIjoidnhxcDlsS3NwZ0NLODUyN3Rqak5pZU84eGY4K0ZRSjZVaHVjNG5ybThNbGdhc25pdlJ2eFR0cTFFL3NUTUxtU1RJYXVONHo2L0prcnlxd1VYTlhTYmZpajZJWW1sb1hMWUMvSFJxWi9ueXlyVmlGc2swY0FkY2hUOWgzQ0JwUVgiLCJtYWMiOiJiZWVlMGQzYzlkYzMyODFkNGJlNmRlZmZlODBmMmY2ODkxZDg1MDhhZTZlZTU3NGIwOWRiNDZhNzEyMTgwYjNmIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 03:42:31 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlAzQTNoaGdJeCs3MHZqUEdEY2VnVkE9PSIsInZhbHVlIjoidnhxcDlsS3NwZ0NLODUyN3Rqak5pZU84eGY4K0ZRSjZVaHVjNG5ybThNbGdhc25pdlJ2eFR0cTFFL3NUTUxtU1RJYXVON" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjJScE0vSkRWcDFHNURQZkdQYlBTSFE9PSIsInZhbHVlIjoiTko1QlRVbktSdkcwZTBEamhlT3NxbUtiYWc4TzFsVzFXV04xZWdvWGMzYVNhNkNtK0huK0tFaEQxckJJWTJNdFZkUUJ0K2JjRUVjS1Q2anc4QzZUQ0lvUC9zWmVNdU8zUkhlTXk1TFQzZmtLcGIzbFVmTmFtUi9CdGdRNnUrOFMiLCJtYWMiOiI1NWU3NmFlYzA4MTZhZjA3NDNjZWNjNjhjZWNmMTM3ZDZkNWI3NTEyMmE4MGJiMjQyNTE4MjlhZGYxZTA2OTA5IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IjJScE0vSkRWcDFHNURQZkdQYlBTSFE9PSIsInZhbHVlIjoiTko1QlRVbktSdkcwZTBEamhlT3NxbUtiYWc4TzFsVzFXV04xZWdvWGMzYVNhNkNtK0huK0tFaEQ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlAzQTNoaGdJeCs3MHZqUEdEY2VnVkE9PSIsInZhbHVlIjoidnhxcDlsS3NwZ0NLODUyN3Rqak5pZU84eGY4K0ZRSjZVaHVjNG5ybThNbGdhc25pdlJ2eFR0cTFFL3NUTUxtU1RJYXVONHo2L0prcnlxd1VYTlhTYmZpajZJWW1sb1hMWUMvSFJxWi9ueXlyVmlGc2swY0FkY2hUOWgzQ0JwUVgiLCJtYWMiOiJiZWVlMGQzYzlkYzMyODFkNGJlNmRlZmZlODBmMmY2ODkxZDg1MDhhZTZlZTU3NGIwOWRiNDZhNzEyMTgwYjNmIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 03:42:31 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlAzQTNoaGdJeCs3MHZqUEdEY2VnVkE9PSIsInZhbHVlIjoidnhxcDlsS3NwZ0NLODUyN3Rqak5pZU84eGY4K0ZRSjZVaHVjNG5ybThNbGdhc25pdlJ2eFR0cTFFL3NUTUxtU1RJYXVON" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjJScE0vSkRWcDFHNURQZkdQYlBTSFE9PSIsInZhbHVlIjoiTko1QlRVbktSdkcwZTBEamhlT3NxbUtiYWc4TzFsVzFXV04xZWdvWGMzYVNhNkNtK0huK0tFaEQxckJJWTJNdFZkUUJ0K2JjRUVjS1Q2anc4QzZUQ0lvUC9zWmVNdU8zUkhlTXk1TFQzZmtLcGIzbFVmTmFtUi9CdGdRNnUrOFMiLCJtYWMiOiI1NWU3NmFlYzA4MTZhZjA3NDNjZWNjNjhjZWNmMTM3ZDZkNWI3NTEyMmE4MGJiMjQyNTE4MjlhZGYxZTA2OTA5IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IjJScE0vSkRWcDFHNURQZkdQYlBTSFE9PSIsInZhbHVlIjoiTko1QlRVbktSdkcwZTBEamhlT3NxbUtiYWc4TzFsVzFXV04xZWdvWGMzYVNhNkNtK0huK0tFaEQ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "oOTz3LSL5go3i8RzFWNCUAYOCni9jtN0dgBS3q36" "uc_cart_id" => "97555b35277da6100b8b5c6362ff805a" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/96605" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 15:42:31GET/article/96605314361