Generic placeholder image

Recent Advances in Drug Delivery and Formulation

Editor-in-Chief

ISSN (Print): 2667-3878
ISSN (Online): 2667-3886

Research Article

Exploring the Patent Landscape and Innovation of Hydrogel-based Bioinks Used for 3D Bioprinting

Author(s): Ahmed Fatimi*

Volume 16, Issue 2, 2022

Published on: 21 June, 2022

Page: [145 - 163] Pages: 19

DOI: 10.2174/2667387816666220429095834

Price: $65

Abstract

Background: This paper provides a comprehensive overview of the patent situation for hydrogel- based bioinks used for 3D bioprinting globally. It encapsulates information which could be used as a reference by researchers in the fields of 3D bioprinting, biomaterials, tissue engineering, and biomedical engineering, as well as those interested in biomaterials, especially in the formulation of hydrogels. It can also inform policy discussions, strategic research planning, or technology transfer in this area. The findings presented hereinafter are considered novel research aspects regarding the used hydrogels, their preparation methods, and their formulations, as well as the 3D bioprinting process using hydrogels. Furthermore, the novel part, synthesized patents, is regarded as a breakthrough in hydrogel- based bioinks.

Methods: The following research aspects of this study are based on data collection from selected patent databases. The search results are then analyzed according to publication years, classification, inventors, applicants, and owners, as well as jurisdictions.

Results: Based on the earliest priority date, it is possible to precisely assume that 2004 is considered the starting year of patenting of hydrogel-based bioinks. Furthermore, 2020 was the year with the most patent documents. According to the findings, the United States, China, and the Republic of Korea are the most prolific countries in terms of patenting on hydrogel-based bioinks. The most prolific patenting companies are from the United States, Sweden, and Australia, while universities from the Republic of Korea and the United States are the academic institutions leading the way. Most inventions of hydrogel- based bioinks intended for hydrogels or hydrocolloids used as materials for prostheses or for coating prostheses are characterized by their function or physical properties.

Conclusion: The state has been reviewed by introducing what has been patented concerning hydrogelbased bioinks. Knowledge clusters and expert driving factors indicate that the research based on biomaterials, tissue engineering, and biofabrication is concentrated in the most common patent documents. Finally, this paper, which gives a competitive analysis of the past, present, and future trends in hydrogel-based bioinks, leads to various recommendations that could help one to plan and innovate research strategies.

Keywords: Hydrogels, bioinks, 3D bioprinting, intellectual property, patent, innovation.

Graphical Abstract

[1]
Groll J, Boland T, Blunk T, et al. Biofabrication: Reappraising the definition of an evolving field. Biofabrication 2016; 8(1): 013001.
[http://dx.doi.org/10.1088/1758-5090/8/1/013001] [PMID: 26744832]
[2]
Donderwinkel I, van Hest JCM, Cameron NR. Bio-inks for 3D bioprinting: Recent advances and future prospects. Polym Chem 2017; 8(31): 4451-71.
[http://dx.doi.org/10.1039/C7PY00826K]
[3]
Lin H-H, Hsieh F-Y, Tseng C-S, Hsu SH. Preparation and characterization of a biodegradable polyurethane hydrogel and the hybrid gel with soy protein for 3D cell-laden bioprinting. J Mater Chem B Mater Biol Med 2016; 4(41): 6694-705.
[http://dx.doi.org/10.1039/C6TB01501H] [PMID: 32263524]
[4]
Schwartz R, Malpica M, Thompson GL, Miri AK. Cell encapsulation in gelatin bioink impairs 3D bioprinting resolution. J Mech Behav Biomed Mater 2020; 103: 103524.
[http://dx.doi.org/10.1016/j.jmbbm.2019.103524] [PMID: 31785543]
[5]
Olate-Moya F, Arens L, Wilhelm M, Mateos-Timoneda MA, Engel E, Palza H. Chondroinductive aginate-based hydrogels having graphene oxide for 3D printed scaffold fabrication. ACS Appl Mater Interfaces 2020; 12(4): 4343-57.
[http://dx.doi.org/10.1021/acsami.9b22062] [PMID: 31909967]
[6]
Fatimi A. Chitosan-based embolizing hydrogel for the treatment of endoleaks after endovascular aneurysm repair. Int J Polym Mater 2019; 68(1-3): 107-14.
[http://dx.doi.org/10.1080/00914037.2018.1525729]
[7]
Yuan T, Li Z, Zhang Y, et al. Injectable ultrasonication-induced silk fibroin hydrogel for cartilage repair and regeneration. Tissue Eng Part A 2021; 27(17-18): 1213-24.
[http://dx.doi.org/10.1089/ten.tea.2020.0323] [PMID: 33353462]
[8]
Qiao Y, Liu X, Zhou X, et al. Gelatin templated polypeptide co-cross-linked hydrogel for bone regeneration. Adv Healthc Mater 2020; 9(1): e1901239.
[http://dx.doi.org/10.1002/adhm.201901239] [PMID: 31814318]
[9]
Shie M-Y, Lee J-J, Ho C-C, Yen S-Y, Ng HY, Chen Y-W. Effects of gelatin methacrylate bio-ink concentration on mechano-physical properties and human dermal fibroblast behavior. Polymers (Basel) 2020; 12(9): 1930.
[http://dx.doi.org/10.3390/polym12091930] [PMID: 32859028]
[10]
Zhou X, Nowicki M, Sun H, et al. 3D Bioprinting-tunable small-diameter blood vessels with biomimetic biphasic cell layers. ACS Appl Mater Interfaces 2020; 12(41): 45904-15.
[http://dx.doi.org/10.1021/acsami.0c14871] [PMID: 33006880]
[11]
Wang X-F, Song Y, Liu Y-S, et al. Osteogenic differentiation of three-dimensional bioprinted constructs consisting of human adipose-derived stem cells in vitro and in vivo. PLoS One 2016; 11(6): e0157214.
[http://dx.doi.org/10.1371/journal.pone.0157214] [PMID: 27332814]
[12]
Nie K, Han S, Yang J, et al. Enzyme-crosslinked electrospun fibrous gelatin hydrogel for potential soft tissue engineering. Polymers (Basel) 2020; 12(9): 1977.
[http://dx.doi.org/10.3390/polym12091977] [PMID: 32878113]
[13]
Yu J, Park SA, Kim WD, et al. Current advances in 3D bioprinting technology and its applications for tissue engineering. Polymers (Basel) 2020; 12(12): 2958.
[http://dx.doi.org/10.3390/polym12122958] [PMID: 33322291]
[14]
Yoo S-S. 3D-printed biological organs: Medical potential and patenting opportunity. Expert Opin Ther Pat 2015; 25(5): 507-11.
[http://dx.doi.org/10.1517/13543776.2015.1019466] [PMID: 25711801]
[15]
Cambia Institute. The lens patent data set 2021. Available from: https://www.lens.org (Accessed on: September 2, 2021).
[16]
Bicudo E, Faulkner A, Li P. Patents and the experimental space: Social, legal and geographical dimensions of 3D bioprinting. Int Rev Law Comput Technol 2021; 35(1): 2-23.
[http://dx.doi.org/10.1080/13600869.2020.1785066]
[17]
Lee SM, Trimi S. Innovation for creating a smart future. Journal of Innovation & Knowledge 2018; 3(1): 1-8.
[http://dx.doi.org/10.1016/j.jik.2016.11.001]
[18]
World Intellectual Property Organization. What is intellectual property? In: Geneva, Switzerland 2020; p. 28.
[19]
Gould DM, Gruben WC. The role of intellectual property rights in economic growth. J Dev Econ 1996; 48(2): 323-50.
[http://dx.doi.org/10.1016/0304-3878(95)00039-9]
[20]
Murphy K, Dorfman S, Smith N, et al. Devices, systems, and methods for the fabrication of tissue. Patent US 9227339 B2, 2016.
[21]
O’Mahony AP, Utama RH, Fife CM, et al. Process for printing 3D tissue culture models. Patent EP 3325611 B1, 2020.
[22]
Zhang J, Pei M, Li T, Xu G, Li J, Wang L. The degradable 3D printing bio-ink of temperature-responsive and 3D printing method. Patent CN 107523136 A, 2017.
[23]
Kim SH, Choi JH, Oh SJ, Park KD, Lee JY. Hydrogel composition and bioinks composition comprising the same. Patent KR 20180117417 A, 2018.
[24]
Jung S, Yoon S. Inkjet printable bioink and method of preparing the same. Patent KR 20190054487 A, 2019.
[25]
Liu J, Cheng L, Yu S, Sun J. Preparation method of nanocellulose bio-printing gel ink. Patent CN 110028840 A, 2019.
[26]
Redwan AIN, Thayer P, Martinez H, Gatenholm E. Biogum and botanical gum hydrogel bioinks for the physiological 3D bioprinting of tissue constructs for in vitro culture and transplantation. Patent WO 2020/086941 A1, 2020.
[27]
Gatenholm P. Preparation and applications of RGD conjugated polysaccharide bioinks with or without fibrin for 3d bioprinting of human skin with novel printing head for use as model for testing cosmetics and for transplantation. Patent US 2019/0160203 A1, 2019.
[28]
Varanasi VG, Ilyas A, Kramer PR, Azimaie T, Aswath PB, Cebe T. in vivo live 3D printing of regenerative bone healing scaffolds for rapid fracture healing. Patent US 10442182 B2, 2019.
[29]
Hull CW. Apparatus for production of three-dimensional objects by stereolithography. Patent US 4575330 A, 1986.
[30]
Guvendiren M, Molde J, Soares RMD, Kohn J. Designing biomaterials for 3D printing. ACS Biomater Sci Eng 2016; 2(10): 1679-93.
[http://dx.doi.org/10.1021/acsbiomaterials.6b00121] [PMID: 28025653]
[31]
Murphy SV, Atala A. 3D bioprinting of tissues and organs. Nat Biotechnol 2014; 32(8): 773-85.
[http://dx.doi.org/10.1038/nbt.2958] [PMID: 25093879]
[32]
Klebe RJ. Cytoscribing: A method for micropositioning cells and the construction of two- and three-dimensional synthetic tissues. Exp Cell Res 1988; 179(2): 362-73.
[http://dx.doi.org/10.1016/0014-4827(88)90275-3] [PMID: 3191947]
[33]
Odde DJ, Renn MJ. Laser-guided direct writing for applications in biotechnology. Trends Biotechnol 1999; 17(10): 385-9.
[http://dx.doi.org/10.1016/S0167-7799(99)01355-4] [PMID: 10481169]
[34]
Ozbolat IT, Hospodiuk M. Current advances and future perspectives in extrusion-based bioprinting. Biomaterials 2016; 76: 321-43.
[http://dx.doi.org/10.1016/j.biomaterials.2015.10.076] [PMID: 26561931]
[35]
Landers R, Hübner U, Schmelzeisen R, Mülhaupt R. Rapid prototyping of scaffolds derived from thermoreversible hydrogels and tailored for applications in tissue engineering. Biomaterials 2002; 23(23): 4437-47.
[http://dx.doi.org/10.1016/S0142-9612(02)00139-4] [PMID: 12322962]
[36]
Jiang T, Munguia-Lopez JG, Flores-Torres S, Kort-Mascort J, Kinsella JM. Extrusion bioprinting of soft materials: An emerging technique for biological model fabrication. Appl Phys Rev 2019; 6(1): 011310.
[http://dx.doi.org/10.1063/1.5059393]
[37]
Boland T, Wilson WC, Xu T. Ink-jet printing of viable cells. Patent US 7051654 B2, 2006.
[38]
Forgacs G, Jakab K, Neagu A, Mironov V. Self-assembling cell aggregates and methods of making engineered tissue using the same. Patent US 8241905 B2, 2012.
[39]
Thorpe D, Belcher S, Nicholson J. Handheld 3D bioprinter. Patent US 2020/0130277 A1, 2020.
[40]
World intellectual property organization.. 2021. Patentscope fields definition Available from: https://patentscope.wipo.int/search/en/help/fieldsHelp.jsf (Accessed on: December 2, 2021).
[41]
World intellectual property organization.. The patentscope. 2021. Available from: https://patentscope.wipo.int (Accessed on: December 2, 2021).
[42]
World Health Organization. World Intellectual Property Organization and World Trade Organization, Promoting access to medical technologies and innovation: Intersections between public health, intellectual property and trade. In: Geneva, Switzerland 2020; p. 352.
[43]
Rodríguez-Salvador M, Rio-Belver RM, Garechana-Anacabe G. Scientometric and patentometric analyses to determine the knowledge landscape in innovative technologies: The case of 3D bioprinting. PLoS One 2017; 12(6): e0180375.
[http://dx.doi.org/10.1371/journal.pone.0180375] [PMID: 28662187]
[44]
World intellectual property organization. Handbook on industrial property information and documentation. 2013. Available from: www. wipo.int/standards/en/pdf/08-01-01.pdf (Accessed on: May 25, 2021).
[45]
European patent office. Espacenet glossary. Available from: https://worldwide.espacenet.com/patent (Accessed on: December 2, 2021).
[46]
World intellectual property organization.. IPC Publication Available from: https://www.wipo.int/classifications/ipc/ipcpub (Accessed on: January 14, 2022).
[47]
World intellectual property organization. Guide to the international patent classification (IPC).. 2021. Available from: https://www.wipo.int/edocs/pubdocs/en/wipo_guide_ipc_2020.pdf(Accessed on: December 2, 2021).
[48]
World intellectual property organization.. What is intellectual property?. 2021. Available from: https://www.wipo.int/patents/en/faq_patents.html (Accessed on: September 2, 2021).
[49]
United states patent and trademark office.. Manual of patent examining procedure: Ownership/Assignability of patents and applications. 2021. Available from: https://www.uspto.gov/web/offices/pac/mpep/mpep-0300.html (Accessed on: December 13, 2021).

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version6.16sRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:23:29] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:23:34] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:23:34] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:23:34] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (484ms)time
  • Application (5.67s)time
  • 1 x Application (92.14%)
    5.67s
    1 x Booting (7.86%)
    484ms
    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 duplicated326ms
    • 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 ('314564252','',1,1740774214,1740774214) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740774214
      20.23msalphaeurekaselec_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 ('314564252','/article/123064',1,1740774214,1740774214)
      200μ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 >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) 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 >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) 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 >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) 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 >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) 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 >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) 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 >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314564252 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314564252) limit 1
      12.61msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314564252
      • 1: 314564252
      • 2: 314564252
      • 3: 314564252
      • 4: 314564252
      • 5: 314564252
      • 6: 314564252
      • 7: 314564252
      • 8: 314564252
      • 9: 314564252
      • 10: 314564252
      • 11: 314564252
      • 12: 314564252
      • 13: 314564252
      • 14: 314564252
      • 15: 314564252
      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=123064
      860μsalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 202 limit 1
      570μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 202
      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=202) and sj.journal_id!=202 group by `j`.`nid`) as `aggregate_table`
      1.51msalphaeurekaselec_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=202) and sj.journal_id!=202 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.33msalphaeurekaselec_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=202) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.72msalphaeurekaselec_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=202) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      2.45msalphaeurekaselec_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` = '123064'
      24.63msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 123064
      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` = '123064'
      3.17msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 123064
      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` = '123064' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.38msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 123064
      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
      450μ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
      730μ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 = 202 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      60.44msalphaeurekaselec_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 = 202 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      23.84msalphaeurekaselec_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 = 202 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      1.48msalphaeurekaselec_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` = 123064 limit 1
      21.59msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 123064
      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 = 123064 and content_type = 'article' order by status desc limit 1
      2.13msalphaeurekaselec_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` = 204256 limit 1
      290μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 204256
      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
      320μ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` = 'RADDF' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      440μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: RADDF
      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 = '123064' and content_type = 'a' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      1.74msalphaeurekaselec_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 = '11806' 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) )
      470μ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 = '3173' 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) )
      1.82msalphaeurekaselec_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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740774214 and j.to_date >= 1740774214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3173) 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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740774214 and j.to_date >= 1740774214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3173) 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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740774214 and j.to_date >= 1740774214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3173)
      116msalphaeurekaselec_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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740774214 and j.to_date >= 1740774214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11806) 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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740774214 and j.to_date >= 1740774214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11806) 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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740774214 and j.to_date >= 1740774214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11806)
      990μ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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740774214 and j.to_date >= 1740774214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 123064) 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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740774214 and j.to_date >= 1740774214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 123064) 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 <= 314564252 and j.to_ip >=314564252 )) and ((j.from_date <= 1740774214 and j.to_date >= 1740774214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 123064)
      900μ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` < '145' and is_uploaded = 1 and issue_id = 11806 order by cast(first_page as SIGNED) desc limit 1
      710μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 145
      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` > '163' and is_uploaded = 1 and issue_id = 11806 order by cast(first_page as SIGNED) asc limit 1
      590μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 163
      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'
      220μ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
      7.23msalphaeurekaselec_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` = 123064 limit 1
      4.04msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 123064
      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` = 202 and `b`.`banner_from_date` <= 1740774214 and `b`.`banner_to_date` >= 1740774214 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.9msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 202
      • 3: 1740774214
      • 4: 1740774214
      • 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` = 202 and `b`.`banner_from_date` <= 1740774214 and `b`.`banner_to_date` >= 1740774214 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      3.12msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 202
      • 3: 1740774214
      • 4: 1740774214
      • 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='e2d4f87653a96c98990e85282329b479'
      1.11msalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:291
      • 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
        tg4x6ZmrytG069TZcvYidEcSwOShmJpHfMvNRdtK
        uc_cart_id
        e2d4f87653a96c98990e85282329b479
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/123064" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/123064
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 28 Feb 2025 20:23:34 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImtQcjlZK3hWa2syS0hvZWdrelpveVE9PSIsInZhbHVlIjoiSklYNk1SbEhUNVlTbHU1eWJwTW13aE1OYkdhcnp5NUtUdE5kVzZiMFpTRmpXMGl5YmtPRnRGZUdYaFY1ZWJtandIRlhxbS9pMUtXejlNeUZUdmxTc1pma1BQRlhzRkRoc1p0RnNzeUMyOGRzSjd5TUY4cENYcFAxRTdDb1lkSzQiLCJtYWMiOiIxNzk2NGY0ZmQxNTJhOTdjYjEwOTA1OWI1MDZkN2ZmNjk2NWI4NmYxMzNiMzBjZmE5MDA2YzcyZmRmYjUyYTkzIiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 08:23:34 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImtQcjlZK3hWa2syS0hvZWdrelpveVE9PSIsInZhbHVlIjoiSklYNk1SbEhUNVlTbHU1eWJwTW13aE1OYkdhcnp5NUtUdE5kVzZiMFpTRmpXMGl5YmtPRnRGZUdYaFY1ZWJtandIRlhxb" 1 => "alphaeurekaselectnet_session=eyJpdiI6InpKa2x3ZDFnSmU1ZXZ2NlF2U0lmRGc9PSIsInZhbHVlIjoicy9JeVJFay9YQkJPeTNSaFVEQ3lCVGc0UzdnSXRpNTM1cCs1TWk5ZFNzVll5YkxtSUU2VGE0c2luM0FDNEZ4R2o3bSt5YktOZmw2TVFNVHl1U21RaFVodGZIVXNSZVM5NkEzTnYrZFVyNkkxVm1lWXJGNExEKzF1cUk0Zkc3MFgiLCJtYWMiOiI5YzNmZDllNjUwYzBjMzVkY2U1ZGE3YjJhOThjNTg2ZDA1MWMwMmFmZmU0NTk5Y2ViNzk2YWRlMTE2NDg0N2RiIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6InpKa2x3ZDFnSmU1ZXZ2NlF2U0lmRGc9PSIsInZhbHVlIjoicy9JeVJFay9YQkJPeTNSaFVEQ3lCVGc0UzdnSXRpNTM1cCs1TWk5ZFNzVll5YkxtSUU2VGE0c2l" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImtQcjlZK3hWa2syS0hvZWdrelpveVE9PSIsInZhbHVlIjoiSklYNk1SbEhUNVlTbHU1eWJwTW13aE1OYkdhcnp5NUtUdE5kVzZiMFpTRmpXMGl5YmtPRnRGZUdYaFY1ZWJtandIRlhxbS9pMUtXejlNeUZUdmxTc1pma1BQRlhzRkRoc1p0RnNzeUMyOGRzSjd5TUY4cENYcFAxRTdDb1lkSzQiLCJtYWMiOiIxNzk2NGY0ZmQxNTJhOTdjYjEwOTA1OWI1MDZkN2ZmNjk2NWI4NmYxMzNiMzBjZmE5MDA2YzcyZmRmYjUyYTkzIiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 08:23:34 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImtQcjlZK3hWa2syS0hvZWdrelpveVE9PSIsInZhbHVlIjoiSklYNk1SbEhUNVlTbHU1eWJwTW13aE1OYkdhcnp5NUtUdE5kVzZiMFpTRmpXMGl5YmtPRnRGZUdYaFY1ZWJtandIRlhxb" 1 => "alphaeurekaselectnet_session=eyJpdiI6InpKa2x3ZDFnSmU1ZXZ2NlF2U0lmRGc9PSIsInZhbHVlIjoicy9JeVJFay9YQkJPeTNSaFVEQ3lCVGc0UzdnSXRpNTM1cCs1TWk5ZFNzVll5YkxtSUU2VGE0c2luM0FDNEZ4R2o3bSt5YktOZmw2TVFNVHl1U21RaFVodGZIVXNSZVM5NkEzTnYrZFVyNkkxVm1lWXJGNExEKzF1cUk0Zkc3MFgiLCJtYWMiOiI5YzNmZDllNjUwYzBjMzVkY2U1ZGE3YjJhOThjNTg2ZDA1MWMwMmFmZmU0NTk5Y2ViNzk2YWRlMTE2NDg0N2RiIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6InpKa2x3ZDFnSmU1ZXZ2NlF2U0lmRGc9PSIsInZhbHVlIjoicy9JeVJFay9YQkJPeTNSaFVEQ3lCVGc0UzdnSXRpNTM1cCs1TWk5ZFNzVll5YkxtSUU2VGE0c2l" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "tg4x6ZmrytG069TZcvYidEcSwOShmJpHfMvNRdtK" "uc_cart_id" => "e2d4f87653a96c98990e85282329b479" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/123064" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 20:23:34GET/article/123064414361