Generic placeholder image

Recent Patents on Biotechnology

Editor-in-Chief

ISSN (Print): 1872-2083
ISSN (Online): 2212-4012

Review Article

Prospective Study of Microbial Colorants under the Focus of Patent Documents

Author(s): Brisa R.P. Gonçalves, Bruna A.S. Machado, Samira A. Hanna and Marcelo A. Umsza-Guez*

Volume 14, Issue 3, 2020

Page: [184 - 193] Pages: 10

DOI: 10.2174/1872208313666191002125035

Price: $65

Abstract

Background: Colorant-producing microorganisms are quite common in nature. These biomolecules present many biological activities such as antitumoral, antimicrobial and antioxidant, in addition to the various nuances of color, making them of special technological importance to the industrial sectors.

Objective: This study aims to conduct a technological mapping in the patent, at European patent Office (EPO), in order to evaluate the global panorama of the use of microbial colorants.

Methods: The experimental design was acquired by the keyword-driven approach through the advanced search in the Espacenet database European Patent Office (EPO). The keywords selected were bacteria or fungi* or yeast or algae or microorganism* but not plant* and pigment* or color* or colorant* or dye* and the International Patent Classification code, C09B61, for prospecting of interest.

Results: There has been a linear increase in patents developed in the last 20 years, with Japan as the largest depositor in the area. The companies Dainippon Ink and Chemicals and Ajinomoto, both being Japanese, are the largest depositors with 20% of all patents. Among the microorganisms, the filamentous fungi appeared in the first place with 32% of documents and the fungi of the genus Monascus were the most frequently used.

Conclusion: The use of microbial colorants has been growing among industries, mainly in food sectors, due to the growing demand for products of natural origin. Thus, the increase in research and technological development in the area of microbial colorants can become an economically viable and promising strategy for the various industrial sectors.

Keywords: Pigments, microorganisms, Monascus, database, intellectual property, biotechnology.

Graphical Abstract

[1]
Dufossé L. Current and potential natural pigments from microorganisms (bacteria, yeasts, fungi, microalgae).In: Carle R, Schweiggert RM, Eds. Handbook on natural pigments in food and beverages: industrial applications for improving food color. France: Elsevier Ltd. 2016; pp. 337-54.
[2]
Dufossé L. Red colourants from filamentous fungi: Are they ready for the food industry? J Food Compos Anal 2017; 69: 156-61.
[http://dx.doi.org/10.1016/j.jfca.2017.11.002]
[3]
Malik K, Tokkas J, Goyal S. Microbial Pigments: a review. Int J Microb Resour Technol 2012; 41(4): 361-5.
[4]
Nigam PS, Luke JS. Food additives: production of microbial pigments and their antioxidant properties. Curr Opin Food Sci 2016; 7: 93-100.
[http://dx.doi.org/10.1016/j.cofs.2016.02.004]
[5]
Mapari SAS, Thrane U, Meyer AS. Fungal polyketide azaphilone pigments as future natural food colorants? Trends Biotechnol 2010; 28(6): 300-7.
[http://dx.doi.org/10.1016/j.tibtech.2010.03.004] [PMID: 20452692]
[6]
El-Naggar NEA, El-Ewasy SM. Bioproduction, characterization, anticancer and antioxidant activities of extracellular melanin pigment produced by newly isolated microbial cell factories Streptomyces glaucescens NEAE-H. Sci Rep 2017; 7: 42129.
[http://dx.doi.org/10.1038/srep42129] [PMID: 28195138]
[7]
Li F, Xue F, Yu XGC-MS. FTIR and Raman Analysis of antioxidant components of red pigments from Stemphylium lycopersici. Curr Microbiol 2017; 74(4): 532-9.
[http://dx.doi.org/10.1007/s00284-017-1220-3] [PMID: 28255784]
[8]
Zheng Y, Zhang Y, Chen D, Chen H, Lin L, Zheng C, et al. Monascus pigment rubropunctatin: a potential dual agent for cancer chemotherapy and phototherapy. J Agric Food Chem 2016; 64(12): 2541-8.
[http://dx.doi.org/10.1021/acs.jafc.5b05343] [PMID: 26953890]
[9]
Dufossé L. Microbial pigments from bacteria, yeasts, fungi, and microalgae for the food and feed industries.In: Grumezescu AM, Holban AM, Eds. Natural and artificial flavoring agents and food dyes. France: Elsevier Inc 2018; pp. 113-31.
[10]
Panesar R, Kaur S, Panesar PS. Production of microbial pigments utilizing agro-industrial waste: a review. Curr Opin Food Sci 2015; 1(1): 70-6.
[http://dx.doi.org/10.1016/j.cofs.2014.12.002]
[11]
García AM, López-Moya JR, Ramos P. Key points in biotechnological patents to be exploited. Recent Pat Biotechnol 2013; 7(2): 84-97.
[http://dx.doi.org/10.2174/1872208311307020002] [PMID: 23848273]
[12]
Amparo KK dos S. Ribeiro M do CO, Guarieiro LLN. Estudo de caso utilizando mapeamento de prospecção tecnológica como principal ferramenta de busca científica. Perspect Cienc Inf 2012; 17(4): 195-209.
[http://dx.doi.org/10.1590/S1413-99362012000400012]
[13]
Quintella CM, Meira M, Guimarães AK, Tanajura ADS, Da Silva HRG. Prospecção Tecnológica como uma Ferramenta Aplicada em Ciência e Tecnologia para se Chegar à Inovação. Rev Virtual Quim 2011; 3(5): 406-15.
[14]
WIPO. World Intellectual Property Indicators 2018.. World Intellectual Property Organization Geneva: 2018 [cited: 10 September 2018] Available from http://www.wipo.int/ipstats
[15]
Tuli HS, Chaudhary P, Beniwal V, Sharma AK. Microbial pigments as natural color sources: current trends and future perspectives. J Food Sci Technol 2015; 52(8): 4669-78.
[http://dx.doi.org/10.1007/s13197-014-1601-6] [PMID: 26243889]
[16]
Yamaguchi Y, Yoshida T, Komatsu A, Ito H, Watanabe S. Water soluble Monascus pigment US Patent 3765906A 1973.
[17]
Ishiguro Y, Morita K, Ito Y. Novel bacterial strain capable of producing purple-blue pigment. JPS63245666A 1988.
[18]
Nakai K, Koriyama T. Cosmetic containing concentrated Phaffia pigment oil JPH07101827A 1995.
[19]
Choi KY. Cyp102_scat method of producing bioindigo using cyp102_scat from Streptomyces cattleya KR101783243B1 2017.
[20]
Petrova GV, Burakaeva AD, Egorov NS, Shangaraeva GS. Method for producing organic pigment for coloring polymeric materials RU2646106C1 2018.
[21]
Harasym J, Bogacz-Radomska L. Colorants in foods - from past to present. Eng Sci Technol 2016; 3(22): 21-35.
[22]
Dufossé L. Anthraquinones, the Dr Jekyll and Mr Hyde of the food pigment family. Food Res Int 2014; 65: 132-6.
[http://dx.doi.org/10.1016/j.foodres.2014.09.012]
[23]
Chung KT. Azo dyes and human health: a review. J Environ Sci Health C Environ Carcinog Ecotoxicol Rev 2016; 34(4): 233-61.
[http://dx.doi.org/10.1080/10590501.2016.1236602] [PMID: 27635691]
[24]
Amchova P, Kotolova H, Ruda-Kucerova J. Health safety issues of synthetic food colorants. Regul Toxicol Pharmacol 2015; 73(3): 914-22.
[http://dx.doi.org/10.1016/j.yrtph.2015.09.026] [PMID: 26404013]
[25]
Masone D, Chanforan C. Study on the interaction of artificial and natural food colorants with human serum albumin: a computational point of view. Comput Biol Chem 2015; 56: 152-8.
[http://dx.doi.org/10.1016/j.compbiolchem.2015.04.006] [PMID: 25935119]
[26]
Sivakumar V, Anna JL, Vijayeeswarri J, Swaminathan G. Ultrasound assisted enhancement in natural dye extraction from beetroot for industrial applications and natural dyeing of leather. Ultrason Sonochem 2009; 16(6): 782-9.
[http://dx.doi.org/10.1016/j.ultsonch.2009.03.009] [PMID: 19410496]
[27]
Brocades Gist Method for the production of -carotene and other closely related carotenes. GB854419A 1960.
[28]
Dufossé L. Microbial production of food grade pigments microbial production of food grade pigments. Food Technol Biotechnol 2006; 44(3): 313-21.
[29]
Sharpe PL, Ye RW, Zhu QQ. Carotenoid production in a recombinant oleaginous yeast. US Patent 142082A1 2012.
[30]
Torres FAE, Zaccarim BR. Novaes LC de-L, Jozala AF, Santos C, Teixeira MFS, et al. Natural colorants from filamentous fungi. Appl Microbiol Biotechnol 2016; 100(6): 2511-21.
[http://dx.doi.org/10.1007/s00253-015-7274-x] [PMID: 26780357]
[31]
Velmurugan P, Lee YH, Venil CK, Lakshmanaperumalsamy P, Chae JC, Oh BT. Effect of light on growth, intracellular and extracellular pigment production by five pigment-producing filamentous fungi in synthetic medium. J Biosci Bioeng 2010; 109(4): 346-50.
[http://dx.doi.org/10.1016/j.jbiosc.2009.10.003] [PMID: 20226375]
[32]
Dufossé L, Fouillaud M, Caro Y, Mapari SAS, Sutthiwong N. Filamentous fungi are large-scale producers of pigments and colorants for the food industry. Curr Opin Biotechnol 2014; 26: 56-61.
[http://dx.doi.org/10.1016/j.copbio.2013.09.007] [PMID: 24679259]
[33]
Santos-Ebinuma VC, Roberto IC, Simas Teixeira MF, Pessoa A Jr. Improving of red colorants production by a new Penicillium purpurogenum strain in submerged culture and the effect of different parameters in their stability. Biotechnol Prog 2013; 29(3): 778-85.
[http://dx.doi.org/10.1002/btpr.1720] [PMID: 23554384]
[34]
Venil CK, Aruldass CA, Dufossé L, Zakaria ZA, Ahmad WA. Current perspective on bacterial pigments: emerging sustainable compounds with coloring and biological properties for the industry-an incisive evaluation. RSC Advances 2014; 4(74): 39523-9.
[http://dx.doi.org/10.1039/C4RA06162D]
[35]
Sardaryan E. Strain of the microorganism Penicillium oxalicum var. armeniaca and its application US Patent, 6340586B1 2002.
[36]
Iida H, Tsuyoshi N, Fudo R. Method for producing monascus pigment by fermentation method. JP2003268254A 2003.
[37]
Wrolstad RE, Culver CA. Alternatives to those artificial FD&C food colorants. Annu Rev Food Sci Technol 2012; 3(1): 59-77.
[http://dx.doi.org/10.1146/annurev-food-022811-101118] [PMID: 22385164]
[38]
FDA. Food and drug administration. microorganisms & microbial-derived ingredients used in food.. [cited: 20 September 2018] Available from: https://www.fda.gov/food/generally-recognized-safe-gras/microorganisms-microbial-derived-ingredients-used-food-partial-list
[39]
Martins N, Roriz CL, Morales P, Barros L, Ferreira ICFR. Food colorants: challenges, opportunities and current desires of agro-industries to ensure consumer expectations and regulatory practices. Trends Food Sci Technol 2016; 52: 1-15.
[http://dx.doi.org/10.1016/j.tifs.2016.03.009]
[40]
Gordon RY, Cooperman T, Obermeyer W, Becker DJ. Marked variability of monacolin levels in commercial red yeast rice products: buyer beware! Arch Intern Med 2010; 170(19): 1722-7.
[http://dx.doi.org/10.1001/archinternmed.2010.382] [PMID: 20975018]
[41]
Sen T, Barrow CJ, Deshmukh SK. Microbial pigments in the food industry-challenges and the way forward. Front Nutr 2019; 6: 7.
[http://dx.doi.org/10.3389/fnut.2019.00007] [PMID: 30891448]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version357msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:46:32] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:46:32] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:46:32] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (107ms)time
  • Application (250ms)time
  • 1 x Application (70.15%)
    250ms
    1 x Booting (29.85%)
    107ms
    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 duplicated179ms
    • 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 ('316604151','',1,1740516392,1740516392) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740516392
      1msalphaeurekaselec_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 ('316604151','/article/101136',1,1740516392,1740516392)
      170μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) 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 >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) 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 >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) 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 >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) 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 >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) 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 >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316604151 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316604151) limit 1
      12.08msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316604151
      • 1: 316604151
      • 2: 316604151
      • 3: 316604151
      • 4: 316604151
      • 5: 316604151
      • 6: 316604151
      • 7: 316604151
      • 8: 316604151
      • 9: 316604151
      • 10: 316604151
      • 11: 316604151
      • 12: 316604151
      • 13: 316604151
      • 14: 316604151
      • 15: 316604151
      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=101136
      2.21msalphaeurekaselec_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` = 73 limit 1
      2.87msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 73
      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=73) and sj.journal_id!=73 group by `j`.`nid`) as `aggregate_table`
      880μ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=73) and sj.journal_id!=73 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      730μ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=73) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      97.91msalphaeurekaselec_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=73) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      12.36msalphaeurekaselec_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` = '101136'
      360μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 101136
      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` = '101136'
      2.2msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 101136
      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` = '101136' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      730μsalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 101136
      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
      240μ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
      430μ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 = 73 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      23.3msalphaeurekaselec_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 = 73 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      2.95msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2070
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 73 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      2.71msalphaeurekaselec_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` = 101136 limit 1
      230μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 101136
      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 = 101136 and content_type = 'article' order by status desc limit 1
      210μ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` = 175280 limit 1
      160μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 175280
      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
      180μ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` = 'BIOT' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      250μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: BIOT
      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 = '101136' 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) )
      340μ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 = '10122' 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) )
      290μ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 = '2755' 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) )
      240μ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 <= 316604151 and j.to_ip >=316604151 )) and ((j.from_date <= 1740516392 and j.to_date >= 1740516392 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2755) 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 <= 316604151 and j.to_ip >=316604151 )) and ((j.from_date <= 1740516392 and j.to_date >= 1740516392 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2755) 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 <= 316604151 and j.to_ip >=316604151 )) and ((j.from_date <= 1740516392 and j.to_date >= 1740516392 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2755)
      6.95msalphaeurekaselec_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 <= 316604151 and j.to_ip >=316604151 )) and ((j.from_date <= 1740516392 and j.to_date >= 1740516392 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10122) 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 <= 316604151 and j.to_ip >=316604151 )) and ((j.from_date <= 1740516392 and j.to_date >= 1740516392 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10122) 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 <= 316604151 and j.to_ip >=316604151 )) and ((j.from_date <= 1740516392 and j.to_date >= 1740516392 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10122)
      570μ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 <= 316604151 and j.to_ip >=316604151 )) and ((j.from_date <= 1740516392 and j.to_date >= 1740516392 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 101136) 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 <= 316604151 and j.to_ip >=316604151 )) and ((j.from_date <= 1740516392 and j.to_date >= 1740516392 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 101136) 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 <= 316604151 and j.to_ip >=316604151 )) and ((j.from_date <= 1740516392 and j.to_date >= 1740516392 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 101136)
      540μ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` < '184' and is_uploaded = 1 and issue_id = 10122 order by cast(first_page as SIGNED) desc limit 1
      410μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 184
      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` > '193' and is_uploaded = 1 and issue_id = 10122 order by cast(first_page as SIGNED) asc limit 1
      370μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 193
      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'
      150μ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
      170μ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` = 101136 limit 1
      2.36msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 101136
      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` = 73 and `b`.`banner_from_date` <= 1740516392 and `b`.`banner_to_date` >= 1740516392 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.17msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 73
      • 3: 1740516392
      • 4: 1740516392
      • 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` = 73 and `b`.`banner_from_date` <= 1740516392 and `b`.`banner_to_date` >= 1740516392 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.15msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 73
      • 3: 1740516392
      • 4: 1740516392
      • 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='2601a73deba753033bd0c9e7d98079f5'
      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
        zWEPqEnZvvD9Tso00airp0zYtGJW3Z7FFdOZ8Hn7
        uc_cart_id
        2601a73deba753033bd0c9e7d98079f5
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/101136" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/101136
        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=eyJpdiI6IlN4a1ZVTzY3WE9Ba1kzSXpFaitZU3c9PSIsInZhbHVlIjoieHVMTEZndXVyRVo0ZHNDTkR6cWszMjRpTWR0Wm56RGJUSVFBTzkrcHNEcz0iLCJtYWMiOiIxNDFjMjM5YmJmN2U5MWNlZDgwYTliYTc3MmU0MDNkYzZkOTRmOGFjYmU2MTU1Y2Q0Y2RhOTE0Yjg2ZmY2ZGJhIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IlN4a1ZVTzY3WE9Ba1kzSXpFaitZU3c9PSIsInZhbHVlIjoieHVMTEZndXVyRVo0ZHNDTkR6cWszMjRpTWR0Wm56RGJUSVFBTzkrcHNEcz0iLCJtYWMiOiIxNDFjMjM5YmJmN2U5" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 25 Feb 2025 20:46:32 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkJPWEZ2QThIaEpienEvSWg3SC8rWlE9PSIsInZhbHVlIjoiUms4bC82a3JiRGVRdGJkTU9uWWFMMGt1VEVub2dWZE5GelpmemtYWlY3RmdGZFQxZ1FNVzF1RHZzS0ppSVBZdmVLRG9JWXhLZUhnRGV4bE9MaWk5K2FuQ3dycVU4dHdMTGVhWWRuUzBvVVREOEhFL044ZjdDd2l0d0ZPUHRjNzQiLCJtYWMiOiIzZmViNWE4NzcwMDRkNGY5ZmIxNDZmMTI1ZDRhZjUwMDQzYzQyODEwOTZhYTM1ZDQ4M2QzNmViZmU4NjRkNWE1IiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 08:46:32 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkJPWEZ2QThIaEpienEvSWg3SC8rWlE9PSIsInZhbHVlIjoiUms4bC82a3JiRGVRdGJkTU9uWWFMMGt1VEVub2dWZE5GelpmemtYWlY3RmdGZFQxZ1FNVzF1RHZzS0ppSVBZdmVLRG9JW" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlRXT1lwajZkNzd5R2I3ZFhtMXhkcXc9PSIsInZhbHVlIjoiQmlzamhyYXVrWVVZaFBtbEhVdE1IelpMVzhzRHBMQmFFa2dOMEtFd3JrU3RpV0xwWURhQTBYT2tMVU5xUkJ2Z1hRWjJvNXcyQXJ1ZU5ka0pjSVNVbFc1bjJRcW1TbGgrTWhWakRTVjh0MFM0Y1NqbDdCSUt1eE5rNnJKekdKRDciLCJtYWMiOiIwMTJhNmUxY2UyNzAwNWRmYjY3YjY0Y2JmMDJkZmU0NWExZjMyNTExZDAyNjdiNDhiZWZkMWI5NDNkY2M5ZTgwIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlRXT1lwajZkNzd5R2I3ZFhtMXhkcXc9PSIsInZhbHVlIjoiQmlzamhyYXVrWVVZaFBtbEhVdE1IelpMVzhzRHBMQmFFa2dOMEtFd3JrU3RpV0xwWURhQTBYT2t" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkJPWEZ2QThIaEpienEvSWg3SC8rWlE9PSIsInZhbHVlIjoiUms4bC82a3JiRGVRdGJkTU9uWWFMMGt1VEVub2dWZE5GelpmemtYWlY3RmdGZFQxZ1FNVzF1RHZzS0ppSVBZdmVLRG9JWXhLZUhnRGV4bE9MaWk5K2FuQ3dycVU4dHdMTGVhWWRuUzBvVVREOEhFL044ZjdDd2l0d0ZPUHRjNzQiLCJtYWMiOiIzZmViNWE4NzcwMDRkNGY5ZmIxNDZmMTI1ZDRhZjUwMDQzYzQyODEwOTZhYTM1ZDQ4M2QzNmViZmU4NjRkNWE1IiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 08:46:32 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkJPWEZ2QThIaEpienEvSWg3SC8rWlE9PSIsInZhbHVlIjoiUms4bC82a3JiRGVRdGJkTU9uWWFMMGt1VEVub2dWZE5GelpmemtYWlY3RmdGZFQxZ1FNVzF1RHZzS0ppSVBZdmVLRG9JW" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlRXT1lwajZkNzd5R2I3ZFhtMXhkcXc9PSIsInZhbHVlIjoiQmlzamhyYXVrWVVZaFBtbEhVdE1IelpMVzhzRHBMQmFFa2dOMEtFd3JrU3RpV0xwWURhQTBYT2tMVU5xUkJ2Z1hRWjJvNXcyQXJ1ZU5ka0pjSVNVbFc1bjJRcW1TbGgrTWhWakRTVjh0MFM0Y1NqbDdCSUt1eE5rNnJKekdKRDciLCJtYWMiOiIwMTJhNmUxY2UyNzAwNWRmYjY3YjY0Y2JmMDJkZmU0NWExZjMyNTExZDAyNjdiNDhiZWZkMWI5NDNkY2M5ZTgwIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlRXT1lwajZkNzd5R2I3ZFhtMXhkcXc9PSIsInZhbHVlIjoiQmlzamhyYXVrWVVZaFBtbEhVdE1IelpMVzhzRHBMQmFFa2dOMEtFd3JrU3RpV0xwWURhQTBYT2t" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "zWEPqEnZvvD9Tso00airp0zYtGJW3Z7FFdOZ8Hn7" "uc_cart_id" => "2601a73deba753033bd0c9e7d98079f5" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/101136" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 20:46:32GET/article/101136314361