Generic placeholder image

International Journal of Sensors, Wireless Communications and Control

Editor-in-Chief

ISSN (Print): 2210-3279
ISSN (Online): 2210-3287

Research Article

Improved Convolutional Neural Network and Heuristic Technique based on Forecasting and Sizing of Hybrid Renewable Energy System

Author(s): Sweta Kumari, Umesh Kumar Sinha, Manish Kumar*, Sunil Kumar Jangir and Ajay Kumar Singh

Volume 12, Issue 2, 2022

Published on: 29 January, 2021

Page: [152 - 164] Pages: 13

DOI: 10.2174/2210327911666210129153927

Price: $65

Abstract

Aims & Objectives: The fast depletion of fossil fuels and the growing awareness of environmental protection have become a concerning topic. Because of this fact, the researchers are working for a long time to generate electrical energy sources due to the intermittent nature of unconventional energy sources such as solar, wind geothermal, tidal, and biomass as a sustainable, cost-effective, and environmentally friendly alternative for conventional energy sources. These systems are interconnected and fulfill demands as well as energy storage, which subsequently formed a complex hybrid renewable energy system. Hence, forecasting of energy generationand sizing of the equipment are essential for the economic feasibility of a complex hybrid system, and also necessary for the design analysis.

Methods: In this research article, the proposed Functional Link Convolutional Neural Network (FLCNN) is applied to forecast the energy generation from the hybrid solar and wind energy system. Also, the Jaya algorithm has been applied to find the optimal sizing of the solar and wind-based hybrid renewable energy system.

Results & Discussion: The proposed method is simple in design and implementation, and it also reduces computational complexity and time. The proposed FLCNN technique has been compared with various other Machine Learning (ML) methodology, such as Convolutional Neural Network (CNN), Random Forest (RF), and Xg-Boost. In sizing, Jaya is compared with other heuristic techniques such as Genetic Algorithm (GA), Particle Swarm Optimization (PSO), and Cat Swarm Optimization (CSO).

Conclusion: The proposed FLCNN and Jaya optimization techniques successfully applied for tasks like energy forecasting and sizing of the renewable energy system.

Keywords: Convolutional neural network, deep learning, forecasting, hybrid renewable energy, sizing, machine learning.

Graphical Abstract

[1]
Geem ZW. Size optimization for a hybrid photovoltaic-wind energy system. Int J Electr Power Energy Syst 2012; 42(1): 448-51.
[http://dx.doi.org/10.1016/j.ijepes.2012.04.051]
[2]
Bowen A. Feldheim: Germany’s renewable village 2015.https://www.dw.com/en/feldheim-germanys-renewable-village/a-18466800
[3]
Nwulu NI, Xia X. Optimal dispatch for a microgrid incorporating renewables and demand response. Renew Energy 2017; 101: 16-28.
[http://dx.doi.org/10.1016/j.renene.2016.08.026]
[4]
Here are INDC objectives and how much it will cost 2017.
[5]
Paul A, Kumar K, Nayyar A, Saeed F, Karthigaikumar P, Tools M. Smart Sensing View project Network, Security and privacy View project Convolutional neural network based early fire detection
[6]
Alawadi S, Kumar A, Nayyar A, Alzubi J. -A comparison of machine learning algorithms for forecasting indoor temperature in smart buildings Machine Learning from Theory to Algorithms: An Overview. J Phys 2018; 1142(1): 12012.
[7]
Maleki A, Khajeh MG, Ameri M. Optimal sizing of a grid independent hybrid renewable energy system incorporating resource uncertainty, and load uncertainty. Int J Electr Power Energy Syst 2016; 83: 514-24.
[http://dx.doi.org/10.1016/j.ijepes.2016.04.008]
[8]
Askarzadeh A, dos Santos Coelho L. A novel framework for optimization of a grid independent hybrid renewable energy system: A case study of Iran. Sol Energy 2015; 112: 383-96.
[http://dx.doi.org/10.1016/j.solener.2014.12.013]
[9]
Khatib T, Mohamed A, Sopian K. A review of photovoltaic systems size optimization techniques. Renew Sustain Energy Rev 2013; 22: 454-65.
[http://dx.doi.org/10.1016/j.rser.2013.02.023]
[10]
Kumar M, Mishra SK, Choubey SK, Tripathy SS, Choubey DK, Das D. Cat Swarm Optimization based Functional Link Multilayer Perceptron for Suppression of Gaussian and Impulse Noise from Computed Tomography Images. Curr Med Imaging 2020; 16(4): 329-39.
[http://dx.doi.org/10.2174/1573405614666180903115336] [PMID: 32410536]
[11]
Venkata Rao R, Waghmare GG. A new optimization algorithm for solving complex constrained design optimization problems. Eng Optim 2016; 1-24.
[http://dx.doi.org/10.1080/0305215X.2016.1164855]
[12]
Rao RV, Rai DP, Balic J. A new optimization algorithm for parameter optimization of nano-finishing processes A new optimization algorithm for parameter optimization of nano- nishing processes. Sci Iran 2017; 24(2): 868-75.
[13]
Kaur A, Sharma S, Mishra A. Sensing period adaptation for multiobjective optimisation in cognitive radio using Jaya algorithm. Electron Lett 2017; 53(19): 1335-6.http://digital-library.theiet.org/content/journals/10.1049/el.2017.2548
[http://dx.doi.org/10.1049/el.2017.2548]
[14]
Kumar M, Mishra SK. Jaya based functional link multilayer perceptron adaptive filter for Poisson noise suppression from X-ray images. Multimedia Tools Appl 2018; 77: 24405-25.
[http://dx.doi.org/10.1007/s11042-017-5592-y]
[15]
Alzubi J, Nayyar A, Kumar A. Machine Learning from Theory to Algorithms: An Overview. Second National Conference on Computational Intelligence. 1-15.
[http://dx.doi.org/10.1088/1742-6596/1142/1/012012]
[16]
Saeed F, Paul A, Karthigaikumar P, Nayyar A. Convolutional neural network based early fire detection. Multimedia Tools Appl 2020; 79(13–14): 9083-99.
[http://dx.doi.org/10.1007/s11042-019-07785-w]
[17]
Rajkumar RK, Ramachandaramurthy VK, Yong BL, Chia DB. Techno-economical optimization of hybrid pv/wind/battery system using Neuro-Fuzzy. Energy 2011; 36(8): 5148-53.
[http://dx.doi.org/10.1016/j.energy.2011.06.017]
[18]
Kumar M, Mishra SK. Teaching learning based optimization-functional link artificial neural network filter for mixed noise reduction from magnetic resonance image. Biomed Mater Eng 2017; 28(6): 643-54.
[http://dx.doi.org/10.3233/BME-171702] [PMID: 29171969]
[19]
Pao Y. Adaptive pattern recognition and neural networks 1989.
[20]
Atia R, Yamada N. Sizing and Analysis of Renewable Energy and Battery Systems in Residential Microgrids. IEEE Trans Smart Grid 2016; 7(3): 1204-13.
[http://dx.doi.org/10.1109/TSG.2016.2519541]
[21]
Vahidinasab V. Optimal distributed energy resources planning in a competitive electricity market: Multiobjective optimization and probabilistic design. Renew Energy 2014; 66: 354-63.
[http://dx.doi.org/10.1016/j.renene.2013.12.042]
[22]
Mellit A, Kalogirou SA, Hontoria L, Shaari S. Artificial intelligence techniques for sizing photovoltaic systems: A review. Renew Sustain Energy Rev 2009; 13(2): 406-19.
[http://dx.doi.org/10.1016/j.rser.2008.01.006]
[23]
Prakash S, Gopinath NP, Suganthi J. Wind and solar energy forecasting system using artificial neural networks. Int J Pure Appl Math 2018; 118(5): 845-54.
[24]
Sanajaoba S, Fernandez E. Maiden application of Cuckoo Search algorithm for optimal sizing of a remote hybrid renewable energy System. Renew Energy 2016; 96: 1-10.
[http://dx.doi.org/10.1016/j.renene.2016.04.069]
[25]
Gao K, Zhang Y, Sadollah A, Lentzakis A, Su R. Jaya, harmony search and water cycle algorithms for solving large-scale real-life urban traffic light scheduling problem. Swarm Evol Comput 2016; 2017(37): 58-72.
[26]
Ismail MS, Moghavvemi M, Mahlia TMI. Genetic algorithm based optimization on modeling and design of hybrid renewable energy systems. Energy Convers Manage 2014; 85: 120-30.
[http://dx.doi.org/10.1016/j.enconman.2014.05.064]
[27]
Asrari A, Wu TX, Ramos B. A Hybrid Algorithm for Short-Term Solar Power Prediction - Sunshine State Case Study. IEEE Transactions on Sustainable Energy 2017; 8(2): 582-91.
[http://dx.doi.org/10.1109/TSTE.2016.2613962]
[28]
Zhang W, Maleki A, Rosen MA. A heuristic-based approach for optimizing a small independent solar and wind hybrid power scheme incorporating load forecasting. J Clean Prod 2019; 241
[http://dx.doi.org/10.1016/j.jclepro.2019.117920]
[29]
Hong YY, Lian RC. Optimal sizing of hybrid wind/PV/diesel generation in a stand-alone power system using markov-based genetic algorithm. IEEE Trans Power Deliv 2012; 27(2): 640-7.
[http://dx.doi.org/10.1109/TPWRD.2011.2177102]
[30]
Kefayat M, Lashkar Ara A, Nabavi Niaki SA. A hybrid of ant colony optimization and artificial bee colony algorithm for probabilistic optimal placement and sizing of distributed energy resources. Energy Convers Manage 2015; 92: 149-61.
[http://dx.doi.org/10.1016/j.enconman.2014.12.037]
[31]
Singh K, Ranade SK, Singh C. Comparative performance analysis of various wavelet and nonlocal means based approaches for image denoising. Optik (Stuttg) 2017; 131: 423-37.http://linkinghub.elsevier.com/retrieve/pii/S0030402616313729
[http://dx.doi.org/10.1016/j.ijleo.2016.11.055]
[32]
Khan A, Javaid N. Learning-Based Optimization for Optimal Sizing of Stand-Alone Photovoltaic, Wind Turbine, and Battery Systems. Engineering 2020; 1-5.
[33]
Alshammari N, Asumadu J. Optimum unit sizing of hybrid renewable energy system utilizing harmony search, Jaya and particle swarm optimization algorithms. Sustainable Cities and Society 2020; 60: 102255.
[34]
Indian Energy Exchange Area Price iexindia.com/marketdata/areaprice.asp

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version277msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:36:42] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:36:42] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:36:42] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:36:42] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (110ms)time
  • Application (167ms)time
  • 1 x Application (60.44%)
    167ms
    1 x Booting (39.55%)
    110ms
    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 duplicated65.38ms
    • 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 ('59228343','',1,1740515802,1740515802) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740515802
      960μsalphaeurekaselec_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 ('59228343','/article/113814',1,1740515802,1740515802)
      150μ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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) limit 1
      11.19msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59228343
      • 1: 59228343
      • 2: 59228343
      • 3: 59228343
      • 4: 59228343
      • 5: 59228343
      • 6: 59228343
      • 7: 59228343
      • 8: 59228343
      • 9: 59228343
      • 10: 59228343
      • 11: 59228343
      • 12: 59228343
      • 13: 59228343
      • 14: 59228343
      • 15: 59228343
      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=113814
      670μ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` = 115 limit 1
      720μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 115
      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=115) and sj.journal_id!=115 group by `j`.`nid`) as `aggregate_table`
      590μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=115) and sj.journal_id!=115 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      520μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=115) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.52msalphaeurekaselec_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=115) 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.27msalphaeurekaselec_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` = '113814'
      270μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 113814
      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` = '113814'
      1.95msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 113814
      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` = '113814' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.2msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 113814
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ArticleController.php:2533
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      230μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      470μ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 = 115 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      23.57msalphaeurekaselec_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 = 115 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      3.27msalphaeurekaselec_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 = 115 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      2.56msalphaeurekaselec_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` = 113814 limit 1
      260μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 113814
      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 = 113814 and content_type = 'article' order by status desc limit 1
      290μ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` = 190914 limit 1
      190μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 190914
      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
      230μ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` = 'SWCC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      310μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: SWCC
      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 = '113814' 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) )
      370μ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 = '11346' 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) )
      300μ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 = '3170' 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) )
      300μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2231
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740515802 and j.to_date >= 1740515802 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3170) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740515802 and j.to_date >= 1740515802 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3170) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740515802 and j.to_date >= 1740515802 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3170)
      4.41msalphaeurekaselec_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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740515802 and j.to_date >= 1740515802 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11346) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740515802 and j.to_date >= 1740515802 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11346) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740515802 and j.to_date >= 1740515802 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11346)
      610μ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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740515802 and j.to_date >= 1740515802 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 113814) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740515802 and j.to_date >= 1740515802 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 113814) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740515802 and j.to_date >= 1740515802 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 113814)
      820μ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` < '152' and is_uploaded = 1 and issue_id = 11346 order by cast(first_page as SIGNED) desc limit 1
      540μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 152
      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` > '164' and is_uploaded = 1 and issue_id = 11346 order by cast(first_page as SIGNED) asc limit 1
      430μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 164
      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'
      180μ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` = 113814 limit 1
      2.29msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 113814
      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` = 115 and `b`.`banner_from_date` <= 1740515802 and `b`.`banner_to_date` >= 1740515802 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: 115
      • 3: 1740515802
      • 4: 1740515802
      • 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` = 115 and `b`.`banner_from_date` <= 1740515802 and `b`.`banner_to_date` >= 1740515802 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.17msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 115
      • 3: 1740515802
      • 4: 1740515802
      • 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='046defb47a8335160b0eaf1840bd48ae'
      230μ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
        rLOvtTuzx1TAdbYsBdud6o2R2SrnM2cpW68XTGym
        uc_cart_id
        046defb47a8335160b0eaf1840bd48ae
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/article/113814" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/113814
        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:17 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6Iis1K3BzUGpsUDNsZE56THdZTGVnWUE9PSIsInZhbHVlIjoiMDlCcE1QY200UDhUVFMxN0piYVltdnhxbHNCd3JDMW54ZnNBb0ZzSlRlUT0iLCJtYWMiOiJlNzBmYWVmOGFjYjJiNDBjODIwZmMxZmYyYTdjNjg1NDViN2ZjYmE5NjViYzllZWI3NzU0YzA1ZjdiOGY4YTA3IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6Iis1K3BzUGpsUDNsZE56THdZTGVnWUE9PSIsInZhbHVlIjoiMDlCcE1QY200UDhUVFMxN0piYVltdnhxbHNCd3JDMW54ZnNBb0ZzSlRlUT0iLCJtYWMiOiJlNzBmYWVmOGFjYjJi" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "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" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 25 Feb 2025 20:36:42 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkVzNVdRYWpOUkNuUkIrNklOL0NwUHc9PSIsInZhbHVlIjoiUzJHckw1Zy9DMHErZ3hBMzdna3RmQmxhWmVmNXh6UTh3VTFlZEJobnVMMWJOYUd0c1EvTDdHWE1jTi8rdTdpR2NMbE5mbFFQUWhMWkJ4MHZzcVkzWUc3Y0VnMkE3OERaRGZrYnNkdzFoVmFobWhhRjJ3K3RZUTcxODZUWnAvVG8iLCJtYWMiOiJiNGUzZTVlZjUwMjllZjc5YTUzZDkwNTExMmJmZjJkMzU5NWIwNGU5YmNlNmJlNmQyNGM3YmYxYWUwMmVkM2MyIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 08:36:42 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkVzNVdRYWpOUkNuUkIrNklOL0NwUHc9PSIsInZhbHVlIjoiUzJHckw1Zy9DMHErZ3hBMzdna3RmQmxhWmVmNXh6UTh3VTFlZEJobnVMMWJOYUd0c1EvTDdHWE1jTi8rdTdpR2NMbE5mb" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlV2aHo3R1NoeUEwWWZMRitnNEM2dlE9PSIsInZhbHVlIjoiTGd5UTRSMnl3cWZicUs1WE9JUWdzRWVFMmc2TDlvTXhUV1p2U1M2RWxGVU5aOXM2ZTdYdjJvdWR0ajMySG1GbUNDcG4xQmYwYmg5WVRpWVUyNFVsc1RVcTc0ZUhYQ3hDV1F1N1lhWHJ1a1hZQlkrd1kyK2VDQUJEZ21iVk1NNVAiLCJtYWMiOiIwZDhkNTFlY2FiYzRiMmRkNmEwNjU2NGM2MjU4MTEzODgyY2Q5YjBiMjI4NzA2YTQzY2IyZDNiNzMyNDRkYzI2IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlV2aHo3R1NoeUEwWWZMRitnNEM2dlE9PSIsInZhbHVlIjoiTGd5UTRSMnl3cWZicUs1WE9JUWdzRWVFMmc2TDlvTXhUV1p2U1M2RWxGVU5aOXM2ZTdYdjJvdWR" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkVzNVdRYWpOUkNuUkIrNklOL0NwUHc9PSIsInZhbHVlIjoiUzJHckw1Zy9DMHErZ3hBMzdna3RmQmxhWmVmNXh6UTh3VTFlZEJobnVMMWJOYUd0c1EvTDdHWE1jTi8rdTdpR2NMbE5mbFFQUWhMWkJ4MHZzcVkzWUc3Y0VnMkE3OERaRGZrYnNkdzFoVmFobWhhRjJ3K3RZUTcxODZUWnAvVG8iLCJtYWMiOiJiNGUzZTVlZjUwMjllZjc5YTUzZDkwNTExMmJmZjJkMzU5NWIwNGU5YmNlNmJlNmQyNGM3YmYxYWUwMmVkM2MyIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 08:36:42 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkVzNVdRYWpOUkNuUkIrNklOL0NwUHc9PSIsInZhbHVlIjoiUzJHckw1Zy9DMHErZ3hBMzdna3RmQmxhWmVmNXh6UTh3VTFlZEJobnVMMWJOYUd0c1EvTDdHWE1jTi8rdTdpR2NMbE5mb" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlV2aHo3R1NoeUEwWWZMRitnNEM2dlE9PSIsInZhbHVlIjoiTGd5UTRSMnl3cWZicUs1WE9JUWdzRWVFMmc2TDlvTXhUV1p2U1M2RWxGVU5aOXM2ZTdYdjJvdWR0ajMySG1GbUNDcG4xQmYwYmg5WVRpWVUyNFVsc1RVcTc0ZUhYQ3hDV1F1N1lhWHJ1a1hZQlkrd1kyK2VDQUJEZ21iVk1NNVAiLCJtYWMiOiIwZDhkNTFlY2FiYzRiMmRkNmEwNjU2NGM2MjU4MTEzODgyY2Q5YjBiMjI4NzA2YTQzY2IyZDNiNzMyNDRkYzI2IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlV2aHo3R1NoeUEwWWZMRitnNEM2dlE9PSIsInZhbHVlIjoiTGd5UTRSMnl3cWZicUs1WE9JUWdzRWVFMmc2TDlvTXhUV1p2U1M2RWxGVU5aOXM2ZTdYdjJvdWR" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "rLOvtTuzx1TAdbYsBdud6o2R2SrnM2cpW68XTGym" "uc_cart_id" => "046defb47a8335160b0eaf1840bd48ae" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/article/113814" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 20:36:42GET/article/113814414361