Generic placeholder image

Recent Advances in Computer Science and Communications

Editor-in-Chief

ISSN (Print): 2666-2558
ISSN (Online): 2666-2566

Research Article

Chaotic Butterfly Optimization Algorithm Applied to Multi-objective Economic and Emission Dispatch in Modern Power System

Author(s): Arun Kumar Sahoo, Tapas Kumar Panigrahi, Soumya Ranjan Das* and Aurobinda Behera

Volume 15, Issue 2, 2022

Published on: 18 August, 2020

Page: [170 - 185] Pages: 16

DOI: 10.2174/2666255813999200818140528

Price: $65

Abstract

Aims: To optimize the economic and emission dispatch of the thermal power plant.

Background: Considering both the economic and environmental aspects, a combined approach has been developed to attain a solution for a problem known as the combined economic and emission dispatch problem. The CEED problem is a non-linear bi-objective problem with conflicting behaviour having all the practical constraints.

Objective: A new optimization method is improvised by applying the chaotic mapping to the butterfly optimization algorithm. This method is applied to the Combined Economic and Emission Dispatch (CEED) problem for optimizing consumed fuel cost and produced environment pollutants.

Methods: Improved Chaotic Butterfly algorithm is applied to the optimization problem to optimize combined economic and emission dispatch.

Results: The proposed technique is tested on four different test systems with various practical constraints like valve point loading, ramp rate limit and prohibited operating zones. The obtained results from the chaotic butterfly optimization algorithm (CBOA) are compared with other optimization techniques providing an optimum solution for the CEED problem.

Conclusion Considering the environmental impact, the novel metaheuristic swarm intelligence technique is applied. Different test systems with different practical operational constraints like valve-point loading, prohibited operating zones and ramp rate limits and emission dispatch have been analyzed to validate the implementation of the proposed algorithm in real life CEED problem situations.

Keywords: Economic Dispatch (ED), Chaotic Butterfly Optimization Algorithm (CBOA), Combined Economic and Emission Dispatch (CEED), Penalty Factor, Valve Point Loading Effect, Transmission Loss, Prohibited Operating Zones.

Graphical Abstract

[1]
J.S. Dhillon, and D.P. Kothari, "Power system optimization", In 2012 2nd National Conference on Computational Intelligence and Signal Processing (CISP), 2012pp. 18-21
[2]
J.H. Talaq, F. El-Hawary, and M.E. El-Hawary, "A summary of environmental/economic dispatch algorithms", IEEE Trans. Power Syst., vol. 9, no. 3, pp. 1508-1516, 1994.
[http://dx.doi.org/10.1109/59.336110]
[3]
J.Y. Fan, and L. Zhang, "Real-time economic dispatch with line flow and emission constraints using quadratic programming", IEEE Trans. Power Syst., vol. 13, no. 2, pp. 320-325, 1998.
[http://dx.doi.org/10.1109/59.667345]
[4]
J. Nanda, L. Hari, and M.L. Kothari, "Economic emission load dispatch with line flow constraints using a classical technique", IEE Proc., Gener. Transm. Distrib., vol. 141, no. 1, pp. 1-10, 1994.
[http://dx.doi.org/10.1049/ip-gtd:19949770]
[5]
P. Aravindhababu, and K.R. Nayar, "Economic dispatch based on optimal lambda using radial basis function network", Int. J. Electr. Power Energy Syst., vol. 24, no. 7, pp. 551-556, 2002.
[http://dx.doi.org/10.1016/S0142-0615(01)00063-1]
[6]
A.L. Devi, and O.V. Krishna, "Combined economic and emission dispatch using evolutionary algorithms-a case study", J. Eng. Appl. Sci. (Asian Res. Publ. Netw.), vol. 3, no. 6, pp. 28-35, 2008.
[7]
D. Aydin, S. Özyön, C. Yaşar, and T. Liao, "Artificial bee colony algorithm with dynamic population size to combined economic and emission dispatch problem", Int. J. Electr. Power Energy Syst., vol. 54, pp. 144-153, 2014.
[http://dx.doi.org/10.1016/j.ijepes.2013.06.020]
[8]
S. Özyön, and D. Aydin, "Incremental artificial bee colony with local search to economic dispatch problem with ramp rate limits and prohibited operating zones", Energy Convers. Manage., vol. 65, pp. 397-407, 2013.
[http://dx.doi.org/10.1016/j.enconman.2012.07.005]
[9]
A.Y. Abdelaziz, E.S. Ali, and S.M. Abd Elazim, "Combined economic and emission dispatch solution using flower pollination algorithm", Int. J. Electr. Power Energy Syst., vol. 80, pp. 264-274, 2016.
[http://dx.doi.org/10.1016/j.ijepes.2015.11.093]
[10]
H. Rezaie, M.H. Kazemi-Rahbar, B. Vahidi, and H. Rastegar, "Solution of combined economic and emission dispatch problem using a novel chaotic improved harmony search algorithm", J. Comput. Des. Eng., vol. 6, no. 3, pp. 447-467, 2019.
[http://dx.doi.org/10.1016/j.jcde.2018.08.001]
[11]
A. Bhattacharya, and P.K. Chattopadhyay, "Hybrid differential evolution with biogeography-based optimization algorithm for solution of economic emission load dispatch problemsm", Expert Syst. Appl., vol. 38, no. 11, pp. 14001-14010, 2011.
[12]
B. Jeddi, and V. Vahidinasab, "A modified harmony search method for environmental/economic load dispatch of real-world power systems", Energy Convers. Manage., vol. 78, pp. 661-675, 2014.
[http://dx.doi.org/10.1016/j.enconman.2013.11.027]
[13]
H. Hamedi, "Solving the combined economic load and emission dispatch problems using new heuristic algorithm", Int. J. Electr. Power Energy Syst., vol. 46, pp. 10-16, 2013.
[http://dx.doi.org/10.1016/j.ijepes.2012.09.021]
[14]
L. Benasla, A. Belmadani, and M. Rahli, "Spiral optimization algorithm for solving combined economic and emission dispatch", Int. J. Electr. Power Energy Syst., vol. 62, pp. 163-174, 2014.
[http://dx.doi.org/10.1016/j.ijepes.2014.04.037]
[15]
Y.A. Gherbi, H. Bouzeboudja, and F.Z. Gherbi, "The combined economic environmental dispatch using new hybrid metaheuristic", Energy, vol. 115, pp. 468-477, 2016.
[http://dx.doi.org/10.1016/j.energy.2016.08.079]
[16]
S. Agrawal, B.K. Panigrahi, and M.K. Tiwari, "Multiobjective particle swarm algorithm with fuzzy clustering for electrical power dispatch", IEEE Trans. Evol. Comput., vol. 12, no. 5, pp. 529-541, 2008.
[http://dx.doi.org/10.1109/TEVC.2007.913121]
[17]
P.K. Hota, A.K. Barisal, and R. Chakrabarti, "Economic emission load dispatch through fuzzy based bacterial foraging algorithm", Int. J. Electr. Power Energy Syst., vol. 32, no. 7, pp. 794-803, 2010.
[http://dx.doi.org/10.1016/j.ijepes.2010.01.016]
[18]
M.A. Abido, "A niched Pareto genetic algorithm for multi objective environmental/economic dispatch", Int. J. Electr. Power Energy Syst., vol. 25, no. 2, pp. 97-105, 2003.
[http://dx.doi.org/10.1016/S0142-0615(02)00027-3]
[19]
R. Zhang, J. Zhou, L. Mo, S. Ouyang, and X. Liao, "Economic environmental dispatch using an enhanced multi-objective cultural algorithm", Electr. Power Syst. Res., vol. 99, pp. 18-29, 2013.
[http://dx.doi.org/10.1016/j.epsr.2013.01.010]
[20]
S. Dhanalakshmi, S. Kannan, K. Mahadevan, and S. Baskar, "Application of modified NSGA-II algorithm to combined economic and emission dispatch problem", Int. J. Electr. Power Energy Syst., vol. 33, no. 4, pp. 992-1002, 2011.
[http://dx.doi.org/10.1016/j.ijepes.2011.01.014]
[21]
M. Modiri-Delshad, and N. Abd Rahim, "Multi-objective backtracking search algorithm for economic emission dispatch problem", Appl. Soft Comput., vol. 40, pp. 479-494, 2016.
[http://dx.doi.org/10.1016/j.asoc.2015.11.020]
[22]
S. Arora, and S. Singh, "Butterfly optimization algorithm: A novel approach for global optimization", Soft Comput., vol. 23, no. 3, pp. 715-734, 2019.
[http://dx.doi.org/10.1007/s00500-018-3102-4]
[23]
G. Li, F. Shuang, Z. Pan, and Le. Chengyi, "An improved butterfly optimization algorithm for engineering design problems using the cross-entropy method", Symmetry, vol. 11, no. 8, p. 1049, 2019.
[http://dx.doi.org/10.3390/sym11081049]
[24]
S.K. Baliarsingh, and S. Vipsita, "Chaotic emperor penguin optimised extreme learning machine for microarray cancer classification", IET Syst. Biol., vol. 14, no. 2, pp. 85-95, 2020.
[PMID: 32196467]
[25]
Z.L. Gaing, "Particle swarm optimization to solving the economic dispatch considering the generator constraints", IEEE Trans. Power Syst., vol. 18, no. 3, pp. 1187-1195, 2003.
[http://dx.doi.org/10.1109/TPWRS.2003.814889]
[26]
A.I. Selvakumar, and K. Thanushkodi, "A new particle swarm optimization solution to nonconvex economic dispatch problems", IEEE Trans. Power Syst., vol. 22, no. 1, pp. 42-51, 2007.
[http://dx.doi.org/10.1109/TPWRS.2006.889132]
[27]
J.Q. James, and O.K. Victor, "Li, “A social spider algorithm for solving the non-convex economic load dispatch problem", Neurocomputing, vol. 171, pp. 955-965, 2016.
[http://dx.doi.org/10.1016/j.neucom.2015.07.037]
[28]
T. Ding, R. Bo, F. Li, and H. Sun, "A bi-level branch and bound method for economic dispatch with disjoint prohibited zones considering network losses", IEEE Trans. Power Syst., vol. 30, no. 6, pp. 2841-2855, 2014.
[http://dx.doi.org/10.1109/TPWRS.2014.2375322]
[29]
P.K. Roy, S. Bhui, and C. Paul, "Solution of economic load dispatch using hybrid chemical reaction optimization approach", Appl. Soft Comput., vol. 24, pp. 109-125, 2014.
[http://dx.doi.org/10.1016/j.asoc.2014.07.013]
[30]
W. Sa-Ngiamvibool, S. Pothiya, and I. Ngamroo, "Multiple TABU search algorithm for economic dispatch problem considering valve-point effects", Int. J. Electr. Power Energy Syst., vol. 33, no. 4, pp. 846-854, 2011.
[http://dx.doi.org/10.1016/j.ijepes.2010.11.011]
[31]
T. Niknam, H.D. Mojarrad, and H.Z. Meymand, "Non-smooth economic dispatch computation by fuzzy and self-adaptive particle swarm optimization", Appl. Soft Comput., vol. 11, no. 2, pp. 2805-2817, 2011.
[http://dx.doi.org/10.1016/j.asoc.2010.11.010]
[32]
N. Sinha, R. Chakrabarti, and P.K. Chattopadhyay, "Evolutionary programming techniques for economic load dispatch", IEEE Trans. Evol. Comput., vol. 7, no. 1, pp. 83-94, 2003.
[http://dx.doi.org/10.1109/TEVC.2002.806788]
[33]
K. Bhattacharjee, A. Bhattacharya, and S.H. Nee Dey, "Oppositional real coded chemical reaction optimization for different economic dispatch problems", Int. J. Electr. Power Energy Syst., vol. 55, pp. 378-391, 2014.
[http://dx.doi.org/10.1016/j.ijepes.2013.09.033]
[34]
N. Ghorbani, and E. Babaei, "Exchange market algorithm for economic load dispatch", Int. J. Electr. Power Energy Syst., vol. 75, pp. 19-27, 2016.
[http://dx.doi.org/10.1016/j.ijepes.2015.08.013]
[35]
G. Xiong, and D. Shi, "Orthogonal learning competitive swarm optimizer for economic dispatch problems", Appl. Soft Comput., vol. 66, pp. 134-148, 2018.
[http://dx.doi.org/10.1016/j.asoc.2018.02.019]
[36]
S. Sayah, and A. Hamouda, "A hybrid differential evolution algorithm based on particle swarm optimization for nonconvex economic dispatch problems", Appl. Soft Comput., vol. 13, no. 4, pp. 1608-1619, 2013.
[http://dx.doi.org/10.1016/j.asoc.2012.12.014]
[37]
H. Barati, and M. Sadeghi, "An efficient hybrid MPSO-GA algorithm for solving non-smooth/non-convex economic dispatch problem with practical constraints", Ain Shams Eng. J., vol. 9, no. 4, pp. 1279-1287, 2018.
[38]
V. Hosseinnezhad, and E. Babaei, "Economic load dispatch using θ-PSO", Int. J. Electr. Power Energy Syst., vol. 49, pp. 160-169, 2013.
[http://dx.doi.org/10.1016/j.ijepes.2013.01.002]
[39]
E. Afzalan, and M. Joorabian, "An improved cuckoo search algorithm for power economic load dispatch", Int. Trans. Electr. Energy Syst., vol. 25, no. 6, pp. 958-975, 2015.
[http://dx.doi.org/10.1002/etep.1878]
[40]
G. Binetti, A. Davoudi, F.L. Lewis, D. Naso, and B. Turchiano, "Distributed consensus-based economic dispatch with transmission losses", IEEE Trans. Power Syst., vol. 29, no. 4, pp. 1711-1720, 2014.
[http://dx.doi.org/10.1109/TPWRS.2014.2299436]
[41]
Y. Labbi, D.B. Attous, H.A. Gabbar, B. Mahdad, and A. Zidan, "A new rooted tree optimization algorithm for economic dispatch with valve-point effect", Int. J. Electr. Power Energy Syst., vol. 79, pp. 298-311, 2016.
[http://dx.doi.org/10.1016/j.ijepes.2016.01.028]
[42]
G. Xiong, D. Shi, and X. Duan, "Multi-strategy ensemble biogeography-based optimization for economic dispatch problems", Appl. Energy, vol. 111, pp. 801-811, 2013.
[http://dx.doi.org/10.1016/j.apenergy.2013.04.095]
[43]
D.C. Secui, "A new modified artificial bee colony algorithm for the economic dispatch problem", Energy Convers. Manage., vol. 89, pp. 43-62, 2015.
[http://dx.doi.org/10.1016/j.enconman.2014.09.034]
[44]
A.S. Reddy, and K. Vaisakh, "Shuffled differential evolution for economic dispatch with valve point loading effects", Int. J. Electr. Power Energy Syst., vol. 46, pp. 342-352, 2013.
[http://dx.doi.org/10.1016/j.ijepes.2012.10.012]
[45]
B.R. Adarsh, T. Raghunathan, T. Jayabarathi, and X.S. Yang, "Economic dispatch using chaotic bat algorithm", Energy, vol. 96, pp. 666-675, 2016.
[http://dx.doi.org/10.1016/j.energy.2015.12.096]
[46]
X.S. Yang, S.S. Hosseini, and A.H. Gandomi, "Firefly algorithm for solving non-convex economic dispatch problems with valve loading effect", Appl. Soft Comput., vol. 12, no. 3, pp. 1180-1186, 2012.
[http://dx.doi.org/10.1016/j.asoc.2011.09.017]
[47]
G. Chen, and X. Ding, "Optimal economic dispatch with valve loading effect using self-adaptive firefly algorithm", Appl. Intell., vol. 42, no. 2, pp. 276-288, 2015.
[http://dx.doi.org/10.1007/s10489-014-0593-2]
[48]
T.T. Nguyen, and D.N. Vo, "The application of one rank cuckoo search algorithm for solving economic load dispatch problems", Appl. Soft Comput., vol. 37, pp. 763-773, 2015.
[http://dx.doi.org/10.1016/j.asoc.2015.09.010]
[49]
D. He, F. Wang, and Z. Mao, "A hybrid genetic algorithm approach based on differential evolution for economic dispatch with valve-point effect", Int. J. Electr. Power Energy Syst., vol. 30, no. 1, pp. 31-38, 2008.
[http://dx.doi.org/10.1016/j.ijepes.2007.06.023]
[50]
L. dos Santos Coelho, T.C. Bora, and V.C. Mariani, "Differential evolution based on truncated levy-type flights and population diversity measure to solve economic load dispatch problems", Int. J. Electr. Power Energy Syst., vol. 57, pp. 178-188, 2014.
[http://dx.doi.org/10.1016/j.ijepes.2013.11.024]
[51]
J.X. Neto, G. Reynoso-Meza, T.H. Ruppel, V.C. Mariani, and L. dos Santos Coelho, "Solving non-smooth economic dispatch by a new combination of continuous GRASP algorithm and differential evolution", Int. J. Electr. Power Energy Syst., vol. 84, pp. 13-24, 2017.
[http://dx.doi.org/10.1016/j.ijepes.2016.04.012]
[52]
M.A. Al-Betar, M.A. Awadallah, A.T. Khader, A.L. Bolaji, and A. Almomani, "Economic load dispatch problems with valve-point loading using natural updated harmony search", Neural Comput. Appl., vol. 29, no. 10, pp. 767-781, 2018.
[http://dx.doi.org/10.1007/s00521-016-2611-2]
[53]
D.I. Boussaï, J. Lepagnot, and P. Siarry, "A survey on optimization metaheuristics", Inf. Sci., vol. 237, pp. 82-117, 2013.
[http://dx.doi.org/10.1016/j.ins.2013.02.041]
[54]
T. Dokeroglu, E. Sevinc, T. Kucukyilmaz, and A. Cosar, "A survey on new generation metaheuristic algorithms", Comput. Ind. Eng., vol. 137, p. 106040.
[http://dx.doi.org/10.1016/j.cie.2019.106040]
[55]
M. Modiri-Delshad, S.H. Kaboli, E. Taslimi-Renani, and N. Abd Rahim, "Backtracking search algorithm for solving economic dispatch problems with valve-point effects and multiple fuel options", Energy, vol. 116, pp. 637-649, 2016.
[http://dx.doi.org/10.1016/j.energy.2016.09.140]
[56]
A. Pourdaryaei, H. Mokhlis, H.A. Illias, S.H. Kaboli, S. Ahmad, and S.P. Ang, "Hybrid ANN and artificial cooperative search algorithm to forecast short-term electricity price in de-regulated electricity market", IEEE Access, vol. 7, pp. 125369-125386, 2019.
[http://dx.doi.org/10.1109/ACCESS.2019.2938842]
[57]
M. Modiri-Delshad, S.H. Kaboli, E. Taslimi, J. Selvaraj, and N.A. Rahim, "An iterated-based optimization method for economic dispatch in power system", In: 2013 IEEE Conference on Clean Energy and Technology (CEAT), 2013, pp. 88-92.
[http://dx.doi.org/10.1109/CEAT.2013.6775605]
[58]
A. Pourdaryaei, H. Mokhlis, H.A. Illias, S.H. Kaboli, and S. Ahmad, "Short-term electricity price forecasting via hybrid backtracking search algorithm and ANFIS approach", IEEE Access, vol. 7, pp. 77674-77691, 2019.
[http://dx.doi.org/10.1109/ACCESS.2019.2922420S]
[59]
I.M. Hlal, and V.K. Ramachandaramurthya, S. K, Padmanaban, H. R. Kaboli, A. Pouryekta, T. A. Abdullah and T. Ab Rashid, "NSGA-II and MOPSO based optimization for sizing of hybrid PV/wind/battery energy storage system", Int. J. Power Electron. Drive Syst, vol. 10, no. 1, pp. 463-478, 2019.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version442msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[04:19:49] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[04:19:49] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[04:19:49] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[04:19:49] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (103ms)time
  • Application (339ms)time
  • 1 x Application (76.67%)
    339ms
    1 x Booting (23.33%)
    103ms
    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 duplicated250ms
    • 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 ('316548017','',1,1740457189,1740457189) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740457189
      1.04msalphaeurekaselec_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 ('316548017','/article/109222',1,1740457189,1740457189)
      190μ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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) limit 1
      11.55msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316548017
      • 1: 316548017
      • 2: 316548017
      • 3: 316548017
      • 4: 316548017
      • 5: 316548017
      • 6: 316548017
      • 7: 316548017
      • 8: 316548017
      • 9: 316548017
      • 10: 316548017
      • 11: 316548017
      • 12: 316548017
      • 13: 316548017
      • 14: 316548017
      • 15: 316548017
      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=109222
      890μ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` = 179 limit 1
      540μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 179
      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=179) and sj.journal_id!=179 group by `j`.`nid`) as `aggregate_table`
      940μ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=179) and sj.journal_id!=179 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      780μ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=179) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.5msalphaeurekaselec_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=179) 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.5msalphaeurekaselec_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` = '109222'
      2.53msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 109222
      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` = '109222'
      3.08msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 109222
      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` = '109222' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.22msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 109222
      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
      320μ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
      540μ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 = 179 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      34.85msalphaeurekaselec_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 = 179 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      7.52msalphaeurekaselec_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 = 179 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      6.05msalphaeurekaselec_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` = 109222 limit 1
      390μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 109222
      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 = 109222 and content_type = 'article' order by status desc limit 1
      410μ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` = 184987 limit 1
      280μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 184987
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      320μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'RACSC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      1.02msalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: RACSC
      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 = '109222' 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) )
      520μ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 = '11228' 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) )
      540μ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 = '3174' 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) )
      430μ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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740457189 and j.to_date >= 1740457189 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3174) 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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740457189 and j.to_date >= 1740457189 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3174) 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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740457189 and j.to_date >= 1740457189 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3174)
      127msalphaeurekaselec_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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740457189 and j.to_date >= 1740457189 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11228) 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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740457189 and j.to_date >= 1740457189 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11228) 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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740457189 and j.to_date >= 1740457189 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11228)
      21.15msalphaeurekaselec_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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740457189 and j.to_date >= 1740457189 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 109222) 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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740457189 and j.to_date >= 1740457189 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 109222) 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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740457189 and j.to_date >= 1740457189 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 109222)
      11.81msalphaeurekaselec_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` < '170' and is_uploaded = 1 and issue_id = 11228 order by cast(first_page as SIGNED) desc limit 1
      870μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 170
      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` > '185' and is_uploaded = 1 and issue_id = 11228 order by cast(first_page as SIGNED) asc limit 1
      770μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 185
      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'
      310μ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
      350μ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` = 109222 limit 1
      3.96msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 109222
      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` = 179 and `b`.`banner_from_date` <= 1740457189 and `b`.`banner_to_date` >= 1740457189 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.61msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 179
      • 3: 1740457189
      • 4: 1740457189
      • 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` = 179 and `b`.`banner_from_date` <= 1740457189 and `b`.`banner_to_date` >= 1740457189 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.7msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 179
      • 3: 1740457189
      • 4: 1740457189
      • 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='e225ecae6159ba2a82e9ce41526f5f3d'
      330μ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
        mtyRHKMKCjwJTqWTWrS5hKC1d5bt8QZ1ipkPmCpC
        uc_cart_id
        e225ecae6159ba2a82e9ce41526f5f3d
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/article/109222" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/109222
        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:16 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "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
        []
        
        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 04:19:49 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImlXaUphU0Z2OUlPOXZaZlAwOGlqdVE9PSIsInZhbHVlIjoiejVBaml1OFVvNHBXdjkya0dBZlpEK2VkZCs2aTZwSVJCbXlodkNyaWR6SURpS3NHNy9BV1ZKVXlWL1FCbHRFeDh5Mjc2MWErcHdUWGFZSmZPNHhsdGpoR3h5cGxKbzFGUDlKM1VDU2pYR2FkS0dzVHJWbW0rdDdXTHZmTGhibWYiLCJtYWMiOiIxYWQ4MGNjMzViZTU3YmFmMmZiMjc4NjQxM2UyODA2YWU1MWNiMzcwODhiODVmOWQ0NDEwY2I4Njk2MzRjNTcwIiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 16:19:49 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImlXaUphU0Z2OUlPOXZaZlAwOGlqdVE9PSIsInZhbHVlIjoiejVBaml1OFVvNHBXdjkya0dBZlpEK2VkZCs2aTZwSVJCbXlodkNyaWR6SURpS3NHNy9BV1ZKVXlWL1FCbHRFeDh5Mjc2M" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjBlZGprbWk0UWJZZ3NHNzM1aUphRnc9PSIsInZhbHVlIjoic0RYckFiNXJ4WFduVnlPZ2lidkl3U2kzeGRXWEh3Kzl6UFlaemo0NGZpSm9BVUtIdGdLOEVZKzhmTjBoZFZreUd4Q2RoVW5LREhVcEVxdnZCNi83eVZmbk9vV3hFaDZ3TWJNK2FscEU5SHRIYXRlUlZSUmtMdUVydE53L1pIQ1ciLCJtYWMiOiIwNWIxNjk0MWM0NTYwNjg2MzIzNTFmYTIzNGRmZDRjMDA5ZTQzNjM3MjAxM2JlZmJkYjhmNDU2Y2FhNzlkNzA1IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IjBlZGprbWk0UWJZZ3NHNzM1aUphRnc9PSIsInZhbHVlIjoic0RYckFiNXJ4WFduVnlPZ2lidkl3U2kzeGRXWEh3Kzl6UFlaemo0NGZpSm9BVUtIdGdLOEVZKzh" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImlXaUphU0Z2OUlPOXZaZlAwOGlqdVE9PSIsInZhbHVlIjoiejVBaml1OFVvNHBXdjkya0dBZlpEK2VkZCs2aTZwSVJCbXlodkNyaWR6SURpS3NHNy9BV1ZKVXlWL1FCbHRFeDh5Mjc2MWErcHdUWGFZSmZPNHhsdGpoR3h5cGxKbzFGUDlKM1VDU2pYR2FkS0dzVHJWbW0rdDdXTHZmTGhibWYiLCJtYWMiOiIxYWQ4MGNjMzViZTU3YmFmMmZiMjc4NjQxM2UyODA2YWU1MWNiMzcwODhiODVmOWQ0NDEwY2I4Njk2MzRjNTcwIiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 16:19:49 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImlXaUphU0Z2OUlPOXZaZlAwOGlqdVE9PSIsInZhbHVlIjoiejVBaml1OFVvNHBXdjkya0dBZlpEK2VkZCs2aTZwSVJCbXlodkNyaWR6SURpS3NHNy9BV1ZKVXlWL1FCbHRFeDh5Mjc2M" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjBlZGprbWk0UWJZZ3NHNzM1aUphRnc9PSIsInZhbHVlIjoic0RYckFiNXJ4WFduVnlPZ2lidkl3U2kzeGRXWEh3Kzl6UFlaemo0NGZpSm9BVUtIdGdLOEVZKzhmTjBoZFZreUd4Q2RoVW5LREhVcEVxdnZCNi83eVZmbk9vV3hFaDZ3TWJNK2FscEU5SHRIYXRlUlZSUmtMdUVydE53L1pIQ1ciLCJtYWMiOiIwNWIxNjk0MWM0NTYwNjg2MzIzNTFmYTIzNGRmZDRjMDA5ZTQzNjM3MjAxM2JlZmJkYjhmNDU2Y2FhNzlkNzA1IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IjBlZGprbWk0UWJZZ3NHNzM1aUphRnc9PSIsInZhbHVlIjoic0RYckFiNXJ4WFduVnlPZ2lidkl3U2kzeGRXWEh3Kzl6UFlaemo0NGZpSm9BVUtIdGdLOEVZKzh" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "mtyRHKMKCjwJTqWTWrS5hKC1d5bt8QZ1ipkPmCpC" "uc_cart_id" => "e225ecae6159ba2a82e9ce41526f5f3d" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/article/109222" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 04:19:49GET/article/109222414361