Generic placeholder image

Adolescent Psychiatry

Editor-in-Chief

ISSN (Print): 2210-6766
ISSN (Online): 2210-6774

Research Article

The Impact of COVID-19 on Psychotropic Medication Prescriptions in Adolescents: Analysis of a Federated Research Network

Author(s): Joshua White*, Taylor Kohn, Marco-Jose Rivero, Akhil Muthigi, Jamie Thomas, Armin Ghomeshi, Francis Petrella, David Miller, Maria Adelaida Rueda-Lara and Ranjith Ramasamy

Volume 13, Issue 2, 2023

Published on: 05 October, 2023

Page: [80 - 88] Pages: 9

DOI: 10.2174/2210676613666230619142223

Price: $65

Abstract

Background: COVID-19 pandemic restrictions resulted in psychosocial stress and increased potential for psychiatric disorders in the adolescent population. Adolescent psychiatric disorders are increasingly managed with psychotropic medications. We aimed to evaluate the first-time prescription rates of psychotropic medications—antidepressants, antipsychotics, hypnotics, sedatives, mood stabilizers, and psychostimulants—in adolescent patients during the COVID-19 pandemic compared to the years immediately prior.

Methods: We utilized electronic health records, claims data, and pharmaceutical data generated from 68 healthcare organizations stored within the TriNetX Research Network to conduct a retrospective matched cohort study. Adolescent patients aged 10-19 years presenting for outpatient evaluation were placed into two cohorts: 1) outpatient evaluation before (2017-2019) and 2) during (2020-2022) the COVID-19 pandemic. Patients with prior history of psychiatric disorders and/or prior use of psychotropic medications were excluded. The main outcome was first-time psychotropic medication prescription within 90 days of outpatient evaluation. We used propensity score matching with logistic regression to build cohorts of equal size based on covariates of interest.

Results: A total of 1,612,283 adolescents presenting before the COVID-19 pandemic and 1,008,161 adolescents presenting during the COVID-19 pandemic were identified. After matching on age, race/ethnicity, smoking status, and obesity status, a total of 1,005,408 adolescents were included in each cohort, each with an average age of 14.7 ± 2.84 years and 52% female and 48% male. The standardized differences between propensity scores were less than 0.1, suggesting a minimal difference between the two groups. Prescription rates for antipsychotics and benzodiazepines were increased for adolescents presenting during the pandemic (Risk Ratio (RR): 1.58, 95% confidence intervals (CI) 1.48-1.69). However, this group had decreased prescription rates for antidepressants (RR: 0.6, 95% CI 0.57-0.63), anxiolytics (RR: 0.78, 95% CI 0.75-0.81), psychostimulants (RR: 0.26, 95% CI 0.25-0.27), and mood stabilizers (RR: 0.44, 95% CI 0.39-0.49).

Conclusion: Adolescents presenting for outpatient evaluation during the COVID-19 pandemic were prescribed antipsychotics and benzodiazepines at an increased rate relative to the years immediately prior, suggesting an increased need for sedation in this patient population. Given reduced access to care during the COVID-19 pandemic, the decreased prescription rate observed for other psychotropic medication classes does not necessarily reflect a decreased incidence of the associated psychiatric disorders.

« Previous
Austerman, J. (2015). ADHD and behavioral disorders: Assessment, management, and an update from DSM-5. Cleve. Clin. J. Med., 82(S1), S2-S7.

[http://dx.doi.org/10.3949/ccjm.82.s1.01] [PMID: 26555810]
American Diabetes Association, American Psychiatric Association, American Association of Clinical Endocrinologists, North American Association for the Study of Obesity (2004) . Consensus development conference on antipsychotic drugs and obesity and diabetes. Obes. Res., 12(2), 362-368.

[http://dx.doi.org/10.1038/oby.2004.46] [PMID: 14981231]
Brooks, S.K., Smith, L.E., Basson, R., Gilks, T. (2018). Women’s sexual dysfunction associated with psychiatric disorders and their treatment. Womens Health , 14.

[http://dx.doi.org/10.1177/1745506518762664] [PMID: 29649948]
Buzzi, C., Tucci, M., Ciprandi, R., Brambilla, I., Caimmi, S., Ciprandi, G., Marseglia, G.L. (2020). The psycho-social effects of COVID-19 on Italian adolescents’ attitudes and behaviors. Ital. J. Pediatr., 46(1), 69.

[http://dx.doi.org/10.1186/s13052-020-00833-4] [PMID: 32448323]
Correll, C.U., Carlson, H. (2006). Endocrine and metabolic adverse effects of psychotropic medications in children and adolescents. J. Am. Acad. Child Adolesc. Psychiatry, 45(7), 771-791.

[http://dx.doi.org/10.1097/01.chi.0000220851.94392.30] [PMID: 16832314]
Chen, F., Zheng, D., Liu, J., Gong, Y., Guan, Z., Lou, D. (2020). Depression and anxiety among adolescents during COVID-19: A cross-sectional study. Brain Behav. Immun., 88, 36-38.

[http://dx.doi.org/10.1016/j.bbi.2020.05.061] [PMID: 32464156]
CDC. Helping Children Cope with Emergencies | CDC. Centers for Disease Control and Prevention.. (2019) . Available from: https://www.cdc.gov/children indisasters/helping-children-cope.html
Coustals, N., Ménard, M.L., Cohen, D. (2021). Aripiprazole in children and adolescents. J. Child Adolesc. Psychopharmacol., 31(1), 4-32.

[http://dx.doi.org/10.1089/cap.2020.0014] [PMID: 32931315]
Dalton, L., Rapa, E., Stein, A. (2020). Protecting the psychological health of children through effective communication about COVID-19. Lancet Child Adolesc. Health, 4(5), 346-347.

[http://dx.doi.org/10.1016/S2352-4642 (20) 30097-3] [PMID: 32243784]
Duan, L., Shao, X., Wang, Y., Huang, Y., Miao, J., Yang, X., Zhu, G. (2020). An investigation of mental health status of children and adolescents in china during the outbreak of COVID-19. J. Affect. Disord., 275, 112-118.

[http://dx.doi.org/10.1016/j.jad.2020.06.029] [PMID: 32658812]
Agostino, D A., D’Angelo .S, Giordano, B., Cigognini, A.C., Chirico, M.L., Redaelli, C., Gambini, (2021) . O.Brief psychotic disorder during the national lockdown in Italy: An emerging clinical phenomenon of the COVID-19 pandemic. Schizophr. Bull., 47(1), 15-22.

[http://dx.doi.org/10.1093/schbul/sbaa112] [PMID: 32761196]
Ellis, W.E., Dumas, T.M., Forbes, L.M. (2020). Physically isolated but socially connected: Psychological adjustment and stress among adolescents during the initial COVID-19 crisis. Can. J. Behav. Sci., 52(3), 177-187.

[http://dx.doi.org/10.1037/cbs0000215]
Esposito, C.M., D’Agostino, A., Dell Osso, B., Fiorentini, A., Prunas, C., Callari, A., Oldani, L., Fontana, E., Gargano, G., Viscardi, B., Giordano, B., D’Angelo, S., Wiedenmann, F., Macellaro, M., Giorgetti, F., Turtulici, N., Gambini, O., Brambilla, P. (2021). Impact of the first Covid-19 pandemic wave on first episode psychosis in Milan, italy. Psychiatry Res., 298, 113802.

[http://dx.doi.org/10.1016/j.psychres.2021.113802] [PMID: 33592401]
Faraone, S.V., Biederman, J., Monuteaux, M., Spencer, T. (2005). Long-term effects of extended-release mixed amphetamine salts treatment of attention- deficit/hyperactivity disorder on growth. J. Child Adolesc. Psychopharmacol., 15(2), 191-202.

[http://dx.doi.org/10.1089/cap.2005.15.191] [PMID: 15910204]
Friedrich, J.M., Sun, C., Geng, X., Calello, D.P., Gillam, M., Medeiros, K.L., Smith, M., Ruck, B., Mazer-Amirshahi, M. (2020). Child and adolescent benzodiazepine exposure and overdose in the United States: 16 years of poison center data. Clin. Toxicol. , 58(7), 725-731.

[http://dx.doi.org/10.1080/15563650.2019.1674321] [PMID: 31612741]
Guessoum, S.B., Lachal, J., Radjack, R., Carretier, E., Minassian, S., Benoit, L., Moro, M.R. (2020). Adolescent psychiatric disorders during the COVID-19 pandemic and lockdown. Psychiatry Res., 291, 113264.

[http://dx.doi.org/10.1016/j.psychres.2020.113264] [PMID: 32622172]
Just, M.J. (2015). The influence of atypical antipsychotic drugs on sexual function. Neuropsychiatr. Dis. Treat., 11, 1655-1661.

[http://dx.doi.org/10.2147/NDT.S84528] [PMID: 26185449]
Koelch, M., Prestel, A., Singer, H., Keller, F., Fegert, J.M., Schlack, R., Hoelling, H., Knopf, H. (2009). Psychotropic medication in children and adolescents in Germany: Prevalence, indications, and psychopathological patterns. J. Child Adolesc. Psychopharmacol., 19(6), 765-770.

[http://dx.doi.org/10.1089/cap.2009.0018] [PMID: 20035595]
Kinon, B., Ahl, J., Liuseifert, H., Maguire, G. (2006). Improvement in hyperprolactinemia and reproductive comorbidities in patients with schizophrenia switched from conventional antipsychotics or risperidone to olanzapine. Psychoneuroendocrinology, 31(5), 577-588.

[http://dx.doi.org/10.1016/j.psyneuen.2005.12.006] [PMID: 16488084]
Kennedy, S.H., Rizvi, S. (2009). Sexual dysfunction, depression, and the impact of antidepressants. J. Clin. Psychopharmacol., 29(2), 157-164.

[http://dx.doi.org/10.1097/JCP.0b013e31819c76e9] [PMID: 19512977]
Loehde, L.W., Novakovic, M. (2021). Acute and transient psychotic disorder induced by fear of coronavirus infection. Eur. J. Psychotraumatol., 12(1), 1954777.

[http://dx.doi.org/10.1080/20008198.2021.1954777] [PMID: 34408820]
Lakhan, S.E., Hagger-Johnson, G.E. (2007). The impact of prescribed psychotropics on youth. Clin. Pract. Epidemiol. Ment. Health, 3(1), 21.

[http://dx.doi.org/10.1186/1745-0179-3-21] [PMID: 17949504]
Muench, J., Hamer, A.M. (2010). Adverse effects of antipsychotic medications. Am. Fam. Physician, 81(5), 617-622.
[PMID: 20187598]
Meherali, S., Punjani, N., Louie-Poon, S., Abdul Rahim, K., Das, J.K., Salam, R.A., Lassi, Z.S. (2021). Mental health of children and adolescents amidst COVID-19 and past pandemics: A rapid systematic review. Int. J. Environ. Res. Public Health, 18(7), 3432.

[http://dx.doi.org/10.3390/ijerph18073432] [PMID: 33810225]
MTA Cooperative Group (2004) National institute of mental health multimodal treatment study of ADHD follow-up: Changes in effectiveness and growth after the end of treatment. Pediatrics, 113(4), 762-769.

[http://dx.doi.org/10.1542/peds.113.4.762] [PMID: 15060225]
Montejo, A.L., Llorca, G., Izquierdo, J.A., Rico-Villademoros, F. (2001). Incidence of sexual dysfunction associated with antidepressant agents: A prospective multicenter study of 1022 outpatients. J. Clin. Psychiatry, 62(S3), 10-21.
[PMID: 11229449]
Montejo, A.L., Montejo, L., Baldwin, D.S. (2018). The impact of severe mental disorders and psychotropic medications on sexual health and its implications for clinical management. World Psychiatry, 17(1), 3-11.

[http://dx.doi.org/10.1002/wps.20509] [PMID: 29352532]
Nearchou, F., Flinn, C., Niland, R., Subramaniam, S.S., Hennessy, E. (2020). Exploring the impact of COVID-19 on mental health outcomes in children and adolescents: A systematic review. Int. J. Environ. Res. Public Health, 17(22), 8479.

[http://dx.doi.org/10.3390/ijerph17228479] [PMID: 33207689]
Olfson, M., He, J., Merikangas, K.R. (2013). Psychotropic medication treatment of adolescents: Results from the national comorbidity survey-adolescent supplement. J. Am. Acad. Child Adolesc. Psychiatry, 52(4), 378-388.

[http://dx.doi.org/10.1016/j.jaac.2012.12.006] [PMID: 23582869]
Steinhausen, H.C. (2015). Recent international trends in psychotropic medication prescriptions for children and adolescents. Eur. Child Adolesc. Psychiatry, 24(6), 635-640.

[http://dx.doi.org/10.1007/s00787-014-0631-y] [PMID: 25378107]
Valdés-Florido, M.J., López-Díaz, Á., Palermo-Zeballos, F.J., Garrido-Torres, N., Álvarez-Gil, P., Martínez-Molina, I., Martín-Gil, V.E., Ruiz-Ruiz, E., Mota-Molina, M., Algarín-Moriana, M.P., Guzmán-del, C.A.H., Ruiz-Arcos, Á., Gómez-Coronado, R., Galiano-Rus, S., Rosa-Ruiz, A., Prados-Ojeda, J.L., Gutierrez-Rojas, L., Crespo-Facorro, B., Ruiz-Veguilla, M. (2022). Clinical characterization of brief psychotic disorders triggered by the COVID-19 pandemic: A multicenter observational study. Eur. Arch. Psychiatry Clin. Neurosci., 272(1), 5-15.

[http://dx.doi.org/10.1007/s00406-021-01256-w] [PMID: 33811552]
Webster, R.K., Weston, D., Woodland, L., Hall, I., Rubin, G.J. (2020). The impact of unplanned school closure on children’s social contact: rapid evidence review. Euro Surveill., 25(13), 2000188.

[http://dx.doi.org/10.2807/1560-7917.ES.2020.25.13.2000188] [PMID: 32265006]
Witek, M.W., Rojas, V., Alonso, C., Minami, H., Silva, R.R. (2005). Review of benzodiazepine use in children and adolescents. Psychiatr. Q., 76(3), 283-296.

[http://dx.doi.org/10.1007/s11126-005-2982-5] [PMID: 16080423]
Zajecka, J. (2001). Strategies for the treatment of antidepressant-related sexual dysfunction. J. Clin. Psychiatry, 62(S3), 35-43.
[PMID: 11229451]
Zviedrite, N., Hodis, J.D., Jahan, F., Gao, H., Uzicanin, A. (2021). COVID-19-associated school closures and related efforts to sustain education and subsidized meal programs, United States, February 18–June 30, 2020. PLoS One, 16(9), e0248925.

[http://dx.doi.org/10.1371/journal.pone.0248925] [PMID: 34520475]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version1.12sRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:28:09] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:28:09] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:28:09] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:28:09] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:28:09] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (290ms)time
  • Application (826ms)time
  • 1 x Application (74%)
    826ms
    1 x Booting (26%)
    290ms
    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 duplicated635ms
    • 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 ('316642695','',1,1740774489,1740774489) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740774489
      9.51msalphaeurekaselec_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 ('316642695','/article/132574',1,1740774489,1740774489)
      250μ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 >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) 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 >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) 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 >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) 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 >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) 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 >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) 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 >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) limit 1
      47.82msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316642695
      • 1: 316642695
      • 2: 316642695
      • 3: 316642695
      • 4: 316642695
      • 5: 316642695
      • 6: 316642695
      • 7: 316642695
      • 8: 316642695
      • 9: 316642695
      • 10: 316642695
      • 11: 316642695
      • 12: 316642695
      • 13: 316642695
      • 14: 316642695
      • 15: 316642695
      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=132574
      1.13msalphaeurekaselec_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` = 109 limit 1
      2.21msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 109
      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=109) and sj.journal_id!=109 group by `j`.`nid`) as `aggregate_table`
      1.13msalphaeurekaselec_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=109) and sj.journal_id!=109 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      960μ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=109) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      7.19msalphaeurekaselec_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=109) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      63.19msalphaeurekaselec_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` = '132574'
      360μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 132574
      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` = '132574'
      29.44msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 132574
      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` = '132574' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      24.77msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 132574
      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
      2.98msalphaeurekaselec_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
      870μ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 = 109 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      111msalphaeurekaselec_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 = 109 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      23.51msalphaeurekaselec_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 = 109 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      4.21msalphaeurekaselec_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` = 132574 limit 1
      270μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 132574
      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 = 132574 and content_type = 'article' order by status desc limit 1
      360μ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` = 218090 limit 1
      280μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 218090
      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` = 'APS' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      360μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: APS
      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 = '132574' 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) )
      19.68msalphaeurekaselec_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 = '12939' 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) )
      530μ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 = '3317' 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) )
      450μ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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740774489 and j.to_date >= 1740774489 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3317) 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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740774489 and j.to_date >= 1740774489 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3317) 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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740774489 and j.to_date >= 1740774489 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3317)
      270msalphaeurekaselec_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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740774489 and j.to_date >= 1740774489 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12939) 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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740774489 and j.to_date >= 1740774489 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12939) 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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740774489 and j.to_date >= 1740774489 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12939)
      1.03msalphaeurekaselec_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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740774489 and j.to_date >= 1740774489 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 132574) 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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740774489 and j.to_date >= 1740774489 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 132574) 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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740774489 and j.to_date >= 1740774489 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 132574)
      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` < '80' and is_uploaded = 1 and issue_id = 12939 order by cast(first_page as SIGNED) desc limit 1
      980μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 80
      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` > '88' and is_uploaded = 1 and issue_id = 12939 order by cast(first_page as SIGNED) asc limit 1
      590μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 88
      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'
      230μ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
      650μ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` = 132574 limit 1
      4.54msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 132574
      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` = 109 and `b`.`banner_from_date` <= 1740774489 and `b`.`banner_to_date` >= 1740774489 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.58msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 109
      • 3: 1740774489
      • 4: 1740774489
      • 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` = 109 and `b`.`banner_from_date` <= 1740774489 and `b`.`banner_to_date` >= 1740774489 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.53msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 109
      • 3: 1740774489
      • 4: 1740774489
      • 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='c199e1ec8787b48d5f13970b6c75b8d6'
      310μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:291
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        8O6vfAtkiTy4NHoBm8GAkjZnAXpgJtbW9AOIb80b
        uc_cart_id
        c199e1ec8787b48d5f13970b6c75b8d6
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/132574" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/132574
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 28 Feb 2025 20:28:09 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InFUdWp0MGRKMEhYZXdSVStVdVpxeHc9PSIsInZhbHVlIjoiNVJUOENkM09LR0t2SkRDWTdhbXBpYkRDSW94bUdsdGtuSUxKc1lqUFpudi83bkcvaktIdzA1YTBnM0ZrenZPcnJkRm1LaEM0UHdZcWE0Rk9yb1FDOVJuWDlNYVpLa1RHcjFueTV6b3E3Ti9scldrSFZZRit1amJzZCtrVlNYaXMiLCJtYWMiOiJhNTEzZjlhYjI5ZGEwZTNhODgwNTZkODM1ZThiOTk3MTJmMzJmMDQ1NWM5NDYyZGJmYjY1N2JhMDgxZmI0MmZkIiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 08:28:09 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InFUdWp0MGRKMEhYZXdSVStVdVpxeHc9PSIsInZhbHVlIjoiNVJUOENkM09LR0t2SkRDWTdhbXBpYkRDSW94bUdsdGtuSUxKc1lqUFpudi83bkcvaktIdzA1YTBnM0ZrenZPcnJkRm1La" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlRlMTlTamFZZm5DRHA2eVFTSHVyWnc9PSIsInZhbHVlIjoickhkWXJRYmkzYnNHaWthVndIT04zcXN1S2IwcDRmUGVPOVJvNzdqQnl6bzkxdlhjNGJOWThqWmVpdkdqeWtYdnFXWjhMMno3UGNVMEJVYU1SaXJhVXRhdFpZNXNYOWxyc2pWVXpiUDFvb0l1bDhLam1ERy9zTzN3NlJVMGdld2oiLCJtYWMiOiIwMzc3ZTlhYTViMDBlMjJhMmVmZGE5NjU2ZjgyMDRlYzI1ZDNjMGY1MGEyOTNhYjNiYThkMGEyOTJlMDYzYjRlIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlRlMTlTamFZZm5DRHA2eVFTSHVyWnc9PSIsInZhbHVlIjoickhkWXJRYmkzYnNHaWthVndIT04zcXN1S2IwcDRmUGVPOVJvNzdqQnl6bzkxdlhjNGJOWThqWmV" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InFUdWp0MGRKMEhYZXdSVStVdVpxeHc9PSIsInZhbHVlIjoiNVJUOENkM09LR0t2SkRDWTdhbXBpYkRDSW94bUdsdGtuSUxKc1lqUFpudi83bkcvaktIdzA1YTBnM0ZrenZPcnJkRm1LaEM0UHdZcWE0Rk9yb1FDOVJuWDlNYVpLa1RHcjFueTV6b3E3Ti9scldrSFZZRit1amJzZCtrVlNYaXMiLCJtYWMiOiJhNTEzZjlhYjI5ZGEwZTNhODgwNTZkODM1ZThiOTk3MTJmMzJmMDQ1NWM5NDYyZGJmYjY1N2JhMDgxZmI0MmZkIiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 08:28:09 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InFUdWp0MGRKMEhYZXdSVStVdVpxeHc9PSIsInZhbHVlIjoiNVJUOENkM09LR0t2SkRDWTdhbXBpYkRDSW94bUdsdGtuSUxKc1lqUFpudi83bkcvaktIdzA1YTBnM0ZrenZPcnJkRm1La" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlRlMTlTamFZZm5DRHA2eVFTSHVyWnc9PSIsInZhbHVlIjoickhkWXJRYmkzYnNHaWthVndIT04zcXN1S2IwcDRmUGVPOVJvNzdqQnl6bzkxdlhjNGJOWThqWmVpdkdqeWtYdnFXWjhMMno3UGNVMEJVYU1SaXJhVXRhdFpZNXNYOWxyc2pWVXpiUDFvb0l1bDhLam1ERy9zTzN3NlJVMGdld2oiLCJtYWMiOiIwMzc3ZTlhYTViMDBlMjJhMmVmZGE5NjU2ZjgyMDRlYzI1ZDNjMGY1MGEyOTNhYjNiYThkMGEyOTJlMDYzYjRlIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlRlMTlTamFZZm5DRHA2eVFTSHVyWnc9PSIsInZhbHVlIjoickhkWXJRYmkzYnNHaWthVndIT04zcXN1S2IwcDRmUGVPOVJvNzdqQnl6bzkxdlhjNGJOWThqWmV" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "8O6vfAtkiTy4NHoBm8GAkjZnAXpgJtbW9AOIb80b" "uc_cart_id" => "c199e1ec8787b48d5f13970b6c75b8d6" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/132574" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 20:28:09GET/article/132574514361