Generic placeholder image

Current Pharmaceutical Design

Editor-in-Chief

ISSN (Print): 1381-6128
ISSN (Online): 1873-4286

General Review Article

What is Blockchain Technology and its Significance in the Current Healthcare System? A Brief Insight

Author(s): Syed S. Ahmad*, Shahzad Khan and Mohammad A. Kamal

Volume 25, Issue 12, 2019

Page: [1402 - 1408] Pages: 7

DOI: 10.2174/1381612825666190620150302

Price: $65

Abstract

Background: The promising eventual fate of blockchain in healthcare has a lot more extensive prospect. Blockchain is a novel structure that gives another design to storage and trade of data among different members of a particular network. In case of a hospital, blockchain takes into consideration the creation of a better treatment structure by the expert doctor in order to arrange the meeting based on the symptoms of patients throughout the world by the electronic system. Blockchain technology is crucial for biomedical and human services applications as social insurance has turned out to be a standout among the most essential rising application areas of the blockchain distributed ledger technology.

Result: By and large, blockchain is treated as a conveyed record to store social insurance related information for allocation, trading, dissecting, footage, and affirming purposes among accomplices. The advantage of blockchain databases versus traditional dispersed databases is that they are decentralized, permanent, and perfected with advanced digital payment frameworks and hash chain occasion structure. The blockchain code is an unlocked resource and can be utilized, altered, and customized by its clients.

Conclusion: Nowadays, blockchain is expected to be almost universally adopted across medical organizations around the world. The purpose of this review article is to comprehend the current explored subjects, difficulties, and future headings in regards to blockchain innovation from the specialized perspective in the health care system.

Keywords: Blockchain technology, health care system, network, interoperability, organizations, travel industry.

[1]
Pilkington M. Blockchain Technology: Principles and Applications (September 18, 2015) Research Handbook on Digital Transformations, edited by F Xavier Olleros and Majlinda Zhegu 2016. Edward Elgar 2015.
[2]
Gordon WJ, Catalini C. Blockchain technology for healthcare: facilitating the transition to patient-driven interoperability. Comput Struct Biotechnol J 2018; 16: 224-30. [http://dx.doi.org/10.1016/j.csbj.2018.06.003]. [PMID: 30069284].
[3]
Nakamoto S. Bitcoin: A peer-to-peer electronic cash system 2008.
[4]
Greenberg A G. Branwen, Bitcoin’s creator Satoshi Nakamoto is probably this unknown Australian genius WIRED December 2015.
[5]
Bohannon J. The bitcoin busts. American Association for the Advancement of Science 2016. [http://dx.doi.org/10.1126/science.351.6278.1144]
[6]
Krefting L. Rigor in qualitative research: the assessment of trustworthiness. Am J Occup Ther 1991; 45(3): 214-22. [http://dx.doi.org/10.5014/ajot.45.3.214]. [PMID: 2031523].
[7]
Sharples M, Domingue J. The blockchain and kudos: A distributed system for educational record, reputation and reward. European Conference on Technology Enhanced Learning.
[http://dx.doi.org/10.1007/978-3-319-45153-4_48]
[8]
Kuo TT, Kim HE, Ohno-Machado L. Blockchain distributed ledger technologies for biomedical and health care applications. J Am Med Inform Assoc 2017; 24(6): 1211-20. [http://dx.doi.org/10.1093/jamia/ocx068]. [PMID: 29016974].
[9]
Heston T. Why Blockchain Technology is Important for Healthcare Professionals 2017.
[http://dx.doi.org/10.2139/ssrn.3006389]
[10]
Manski S. Building the blockchain world: Technological commonwealth or just more of the same? Strateg Change 2017; 26: 511-22. [http://dx.doi.org/10.1002/jsc.2151].
[11]
Sadiku MN, Eze KG, Musa S. Blockchain Technology in Healthcare. IJASRE 2018; 4(5): 154-9. [http://dx.doi.org/10.7324/IJASRE.2018.32723].
[12]
Iansiti M, Lakhani KR. The truth about blockchain. Harv Bus Rev 2017; 95: 118-27.
[13]
Tsai W, Blower R, Zhu Y, Yu L. A system view of financial blockchains. 2016. IEEE Symposium on Service-Oriented System Engineering (SOSE) 450-7.
[http://dx.doi.org/10.1109/SOSE.2016.66]
[14]
Buterin V. A next-generation smart contract and decentralized application platform. white paper 2014.
[15]
Cachin C. Architecture of the hyperledger blockchain fabric. Workshop on Distributed Cryptocurrencies and Consensus Ledgers 2016.
[16]
Wahl B, Cossy-Gantner A, Germann S, Schwalbe NR. Artificial intelligence (AI) and global health: how can AI contribute to health in resource-poor settings? BMJ Glob Health 2018; 3(4): e000798. [http://dx.doi.org/10.1136/bmjgh-2018-000798]. [PMID: 30233828].
[17]
Piette JD, Mendoza-Avelares MO, Ganser M, Mohamed M, Marinec N, Krishnan S. A preliminary study of a cloud-computing model for chronic illness self-care support in an underdeveloped country. Am J Prev Med 2011; 40(6): 629-32. [http://dx.doi.org/10.1016/j.amepre.2011.02.014]. [PMID: 21565655].
[18]
Sachan K. Aadhaar & Blockchain: opportunities and challenges for India. Massachusetts Institute of Technology 2018.
[19]
Tapscott D, Tapscott A. How blockchain will change organizations. MIT Sloan Manag Rev 2017; 58: 10.
[20]
Tapscott D, Tapscott A. Blockchain revolution: How the technology behind bitcoin is changing money, business, and the world. Penguin 2016.
[21]
Catalini C, Gans JS. Some Simple Economics of the Blockchain Rotman School of Management Working Paper No 2874598, MIT Sloan Research Paper 2017.
[22]
Mandl KD, Kohane IS. Escaping the EHR trap--the future of health IT. N Engl J Med 2012; 366(24): 2240-2. [http://dx.doi.org/10.1056/NEJMp1203102]. [PMID: 22693995].
[23]
Baxendale G. Can Blockchain Revolutionise EPRs? ITNow 2016; 58: 38-9. [http://dx.doi.org/10.1093/itnow/bww017].
[24]
Yue X, Wang H, Jin D, Li M, Jiang W. Healthcare data gateways: found healthcare intelligence on blockchain with novel privacy risk control. J Med Syst 2016; 40(10): 218. [http://dx.doi.org/10.1007/s10916-016-0574-6]. [PMID: 27565509].
[25]
Jenkins J, Kopf J, Binh Q. Tran, Frenchi C, Szu H. “Bio-mining for biomarkers with a multi-resolution block chain”, Proc. SPIE 9496, Independent Component Analyses, Compressive Sampling, Large Data Analyses (LDA). Neural Networks, Biosystems, and Nanoengineering 2015.XIII94960N.
[26]
Brodersen. Blockchain : Securing a New Health Interoperability Experience 2016.
[27]
Zhou Y, Ancker JS, Upadhye M, et al. The impact of interoperability of electronic health records on ambulatory physician practices: a discrete-event simulation study. Inform Prim Care 2013; 21(1): 21-9. [http://dx.doi.org/10.14236/jhi.v21i1.36]. [PMID: 24629653].
[28]
Stewart BA, Fernandes S, Rodriguez-Huertas E, Landzberg M. A preliminary look at duplicate testing associated with lack of electronic health record interoperability for transferred patients. J Am Med Inform Assoc 2010; 17(3): 341-4. [http://dx.doi.org/10.1136/jamia.2009.001750]. [PMID: 20442154].
[29]
Walker J, Pan E, Johnston D, et al. The value of health care information exchange and interoperability: There is a business case to be made for spending money on a fully standardized nationwide system. Health Aff 2005; 24(Suppl. 1): W5-10-8. [http://dx.doi.org/10.1377/hlthaff.W5.10].
[30]
Center BP. Clinician Perspectives on Electronic Health Information Sharing for Transitions of Care Bipartisan Policy Center
[31]
https://wwwforbescom/Blockchain in health care: The good, the bad and the ugly 2012.
[32]
https://medicalfuturistcomWhat the hell is blockchain and what does it mean for healthcare and pharma?. 2018.
[33]
Attili S. Today’s Healthcare Challenges and How Blockchain Can Help Solve Them - Join IBM for a HIMSS17 Breakfast Briefing IBM Healthcare and Life Sciences Industries Blog February 2, 2017 11 feb 2019]; 2019.Available from https://www.ibm.com/blogs/insights-on-business/healthcare/todays-healthcare-challenges-blockchain-can-help-solve-join-ibm-himss17-breakfast-briefing/.
[34]
Skiba DJ. The potential of blockchain in education and health care. Nurs Educ Perspect 2017; 38(4): 220-1. [http://dx.doi.org/10.1097/01.NEP.0000000000000190]. [PMID: 28622267].
[35]
Orcutt M. Why the CDC Wants in on Blockchain MIT Technology Review (online) 2017.
[36]
Peters A. Can blockchain disrupt health education, licensing, and credentialing?, in The Lancet Global Health Blog 2017.
[37]
Durant E, Trachy A. Digital Diploma debuts at MIT http://news.mit.edu/2017/mit-debuts-secure-digital-diploma-using-bitcoin-blockchain-technology-10172017
[38]
Lin P. Blockchain: The Missing Link Between Genomics and Privacy? Forbes 2017. [Internet].
[39]
Zimmerman J. DNA Block Chain Project Boosts Research, Preserves Patient Anonymity. CoinDesk 2014; p. 27.
[40]
Yli-Huumo J, Ko D, Choi S, Park S, Smolander K. Where is current research on blockchain technology?-a systematic review. PLoS One 2016; 11(10): e0163477. [http://dx.doi.org/10.1371/journal.pone.0163477]. [PMID: 27695049].
[41]
Kamel Boulos MN, Wilson JT, Clauson KA. Geospatial blockchain: promises, challenges, and scenarios in health and healthcare. Int J Health Geogr 2018; 17(1): 25. [http://dx.doi.org/10.1186/s12942-018-0144-x]. [PMID: 29973196].
[42]
Ozercan HI, Ileri AM, Ayday E, Alkan C. Realizing the potential of blockchain technologies in genomics. Genome Res 2018; 28(9): 1255-63. [http://dx.doi.org/10.1101/gr.207464.116]. [PMID: 30076130].
[43]
Zhou L, Wang L, Sun Y. Mistore: a blockchain-based medical insurance storage system. J Med Syst 2018; 42(8): 149. [http://dx.doi.org/10.1007/s10916-018-0996-4]. [PMID: 29968202].
[44]
Benchoufi M, Ravaud P. Blockchain technology for improving clinical research quality. Trials 2017; 18(1): 335. [http://dx.doi.org/10.1186/s13063-017-2035-z]. [PMID: 28724395].
[45]
Siew Hua G, Kamal MA, Lima MM, Khalil MI, Pasupuleti VR, Aliev G. Medicinal plants in management of type 2 diabetes and neurodegenerative disorders. Evid Based Complement Alternat Med 2015; 2015: 686872. [http://dx.doi.org/10.1155/2015/686872]. [PMID: 25873981].
[46]
Ahmad SS, Akhtar S. Danish Rizvi SM, et al. Screening and elucidation of selected natural compounds for anti- alzheimer’s potential targeting BACE-1 enzyme: A case computational study. Curr Comput Aided Drug Des 2017; 13(4): 311-8. [http://dx.doi.org/10.2174/1573409913666170414123825]. [PMID: 28413992].
[47]
Calabresi E, Petrelli F, Bonifacio AF, Puxeddu I, Alunno A. One year in review 2018: pathogenesis of rheumatoid arthritis. Clin Exp Rheumatol 2018; 36(2): 175-84. [PMID: 29716677].
[48]
García De Viedma D, Pérez-Lago L. The evolution of genotyping strategies to detect, analyze, and control transmission of tuberculosis. Microbiol Spectr 2018; 6(5) [http://dx.doi.org/10.1128/microbiolspec.MTBP-0002-2016]. [PMID: 30338753].
[49]
Nørfeldt L, Bøtker J, Edinger M, et al. Cryptopharmaceuticals: increasing the safety of medication by a blockchain of pharmaceutical products. J Pharm Sci 2019; S0022-3549 . (19): 30293-X.
[50]
Cichosz SL, Stausholm MN, Kronborg T, Vestergaard P, Hejlesen O. How to use blockchain for diabetes health care data and access management: An operational concept. J Diabetes Sci Technol 2019; 13(2): 248-53. [http://dx.doi.org/10.1177/1932296818790281]. [PMID: 30047789].

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version442msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[15:20:26] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[15:20:26] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[15:20:26] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (134ms)time
  • Application (308ms)time
  • 1 x Application (69.69%)
    308ms
    1 x Booting (30.31%)
    134ms
    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 duplicated209ms
    • 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 ('314549955','',1,1740496826,1740496826) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740496826
      1.33msalphaeurekaselec_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 ('314549955','/article/99126',1,1740496826,1740496826)
      230μ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 >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) 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 >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) 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 >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) 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 >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) 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 >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) 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 >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314549955 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314549955) limit 1
      17.07msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314549955
      • 1: 314549955
      • 2: 314549955
      • 3: 314549955
      • 4: 314549955
      • 5: 314549955
      • 6: 314549955
      • 7: 314549955
      • 8: 314549955
      • 9: 314549955
      • 10: 314549955
      • 11: 314549955
      • 12: 314549955
      • 13: 314549955
      • 14: 314549955
      • 15: 314549955
      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=99126
      1.03msalphaeurekaselec_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` = 29 limit 1
      1.1msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 29
      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=29) and sj.journal_id!=29 group by `j`.`nid`) as `aggregate_table`
      1.38msalphaeurekaselec_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=29) and sj.journal_id!=29 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.19msalphaeurekaselec_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=29) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.54msalphaeurekaselec_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=29) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      1.59msalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 14. app/Models/Subject.php:220
      • 15. app/Http/Controllers/ArticleController.php:2518
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `keywords` where `article_id` = '99126'
      1.56msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 99126
      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` = '99126'
      3.04msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 99126
      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` = '99126' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.97msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 99126
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ArticleController.php:2533
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      260μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      500μ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 = 29 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      48.15msalphaeurekaselec_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 = 29 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      51.32msalphaeurekaselec_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 = 29 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      50.13msalphaeurekaselec_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` = 99126 limit 1
      330μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 99126
      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 = 99126 and content_type = 'article' order by status desc limit 1
      320μ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` = 172892 limit 1
      230μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 172892
      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
      240μ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` = 'CPD' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      350μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CPD
      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 = '99126' 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) )
      400μ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 = '9254' 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) )
      340μ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 = '2588' 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.09msalphaeurekaselec_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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740496826 and j.to_date >= 1740496826 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2588) 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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740496826 and j.to_date >= 1740496826 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2588) 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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740496826 and j.to_date >= 1740496826 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2588)
      13.59msalphaeurekaselec_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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740496826 and j.to_date >= 1740496826 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9254) 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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740496826 and j.to_date >= 1740496826 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9254) 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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740496826 and j.to_date >= 1740496826 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9254)
      630μ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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740496826 and j.to_date >= 1740496826 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99126) 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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740496826 and j.to_date >= 1740496826 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99126) 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 <= 314549955 and j.to_ip >=314549955 )) and ((j.from_date <= 1740496826 and j.to_date >= 1740496826 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99126)
      680μ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` < '1402' and is_uploaded = 1 and issue_id = 9254 order by cast(first_page as SIGNED) desc limit 1
      530μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 1402
      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` > '1408' and is_uploaded = 1 and issue_id = 9254 order by cast(first_page as SIGNED) asc limit 1
      510μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 1408
      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
      200μ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` = 99126 limit 1
      2.37msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 99126
      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` = 29 and `b`.`banner_from_date` <= 1740496826 and `b`.`banner_to_date` >= 1740496826 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.14msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 29
      • 3: 1740496826
      • 4: 1740496826
      • 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` = 29 and `b`.`banner_from_date` <= 1740496826 and `b`.`banner_to_date` >= 1740496826 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.55msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 29
      • 3: 1740496826
      • 4: 1740496826
      • 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='ec18f7b6a2264e55a800f9b7d809db69'
      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
        5n6N9qL08cE1x9XYJ07uuWCihhJ3qMFjUNoGHqGA
        uc_cart_id
        ec18f7b6a2264e55a800f9b7d809db69
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/99126" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/99126
        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 => "Tue, 25 Feb 2025 15:20:26 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im5sN2tkVmRuUkI0bWNmNlFRajg2Q2c9PSIsInZhbHVlIjoiR3NDZm00cHExRWd3TkJ4cnp2NERJTXBoWG53NWhneGdqTm9lenNOZ29FaG1SbTFmckZKY0FYUVpVd2duSHRIZCtrU2RHcjduUkR1enA5RVlsTWh0YTNvSFhLOFBHWk03V0lKYXB4dkFqK3gveis5RWpMYUNpRHhzY3MxMHpMQm8iLCJtYWMiOiJhZjc2OGY1MWI5YTkwNjU2NjhlMjJjZWFhNjJkZWMyNTc4MGQwYTk0ODgwOWI2NmMzOWZlZjg4MWM3ZTI5ODQ0IiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 03:20:26 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Im5sN2tkVmRuUkI0bWNmNlFRajg2Q2c9PSIsInZhbHVlIjoiR3NDZm00cHExRWd3TkJ4cnp2NERJTXBoWG53NWhneGdqTm9lenNOZ29FaG1SbTFmckZKY0FYUVpVd2duSHRIZCtrU2RHc" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlRyQ1pBWkg0cHAvZkI3aHBNZTVtL2c9PSIsInZhbHVlIjoiM2ovUG5MbmIwUkpNcGVObkZTR0g3SG55OVhZeHBUczV0dXQySWhCcGM2OXUxU3BKVXZXY05uMmdhUHVoNEo5MjFQVWxNMUtYQytVanhJb3p2bU45T0pySmhONlF0eCtORGZXaTJzTzBYRTkxdHlWYWg3UGZFM1lHajUvV0MrSDIiLCJtYWMiOiI0NjBkZDAwM2I5ZjVhMWRmYWQ5ZWYwMDBlMmZjOGRmODJjYWQ2NjNiNmI3NDllNjQ0NDY0NDhhMzFmYTE0MDk2IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlRyQ1pBWkg0cHAvZkI3aHBNZTVtL2c9PSIsInZhbHVlIjoiM2ovUG5MbmIwUkpNcGVObkZTR0g3SG55OVhZeHBUczV0dXQySWhCcGM2OXUxU3BKVXZXY05uMmd" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Im5sN2tkVmRuUkI0bWNmNlFRajg2Q2c9PSIsInZhbHVlIjoiR3NDZm00cHExRWd3TkJ4cnp2NERJTXBoWG53NWhneGdqTm9lenNOZ29FaG1SbTFmckZKY0FYUVpVd2duSHRIZCtrU2RHcjduUkR1enA5RVlsTWh0YTNvSFhLOFBHWk03V0lKYXB4dkFqK3gveis5RWpMYUNpRHhzY3MxMHpMQm8iLCJtYWMiOiJhZjc2OGY1MWI5YTkwNjU2NjhlMjJjZWFhNjJkZWMyNTc4MGQwYTk0ODgwOWI2NmMzOWZlZjg4MWM3ZTI5ODQ0IiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 03:20:26 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Im5sN2tkVmRuUkI0bWNmNlFRajg2Q2c9PSIsInZhbHVlIjoiR3NDZm00cHExRWd3TkJ4cnp2NERJTXBoWG53NWhneGdqTm9lenNOZ29FaG1SbTFmckZKY0FYUVpVd2duSHRIZCtrU2RHc" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlRyQ1pBWkg0cHAvZkI3aHBNZTVtL2c9PSIsInZhbHVlIjoiM2ovUG5MbmIwUkpNcGVObkZTR0g3SG55OVhZeHBUczV0dXQySWhCcGM2OXUxU3BKVXZXY05uMmdhUHVoNEo5MjFQVWxNMUtYQytVanhJb3p2bU45T0pySmhONlF0eCtORGZXaTJzTzBYRTkxdHlWYWg3UGZFM1lHajUvV0MrSDIiLCJtYWMiOiI0NjBkZDAwM2I5ZjVhMWRmYWQ5ZWYwMDBlMmZjOGRmODJjYWQ2NjNiNmI3NDllNjQ0NDY0NDhhMzFmYTE0MDk2IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlRyQ1pBWkg0cHAvZkI3aHBNZTVtL2c9PSIsInZhbHVlIjoiM2ovUG5MbmIwUkpNcGVObkZTR0g3SG55OVhZeHBUczV0dXQySWhCcGM2OXUxU3BKVXZXY05uMmd" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "5n6N9qL08cE1x9XYJ07uuWCihhJ3qMFjUNoGHqGA" "uc_cart_id" => "ec18f7b6a2264e55a800f9b7d809db69" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/99126" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 15:20:26GET/article/99126314361