Generic placeholder image

Current Respiratory Medicine Reviews

Editor-in-Chief

ISSN (Print): 1573-398X
ISSN (Online): 1875-6387

Case Report

Foreign Body Aspiration in Children: Retrospective Case Series and Literature Update

Author(s): Monica Tosto, Andrea Giugno, Laura Sciuto, Giuseppe Fabio Parisi, Maria Papale, Alberto Terminella, Giacomo Cusumano, Sara Manti* and Salvatore Leonardi

Volume 19, Issue 4, 2023

Published on: 25 September, 2023

Page: [323 - 329] Pages: 7

DOI: 10.2174/1573398X19666230915103234

Price: $65

Abstract

Background: Foreign body aspiration is common among older infants and toddlers and is an important cause of morbidity and mortality. It may escape notice by the physicians due to lack of knowledge of the exact history, high variability of clinical presentation, variable latency of the onset of symptoms, and inconclusive radiographical findings.

Case Report: We present a case series about children diagnosed with foreign body aspiration referred to the Pediatric Respiratory Unit of San Marco Hospital in Catania between January 2018 and November 2022. Data regarding demographic characteristics, symptoms, and type of foreign body were collected and analyzed.

Conclusion: Early diagnosis is the key to therapeutic success and effective management of foreign body aspiration. We will review the literature to highlight the diagnostic difficulties related to this condition and the useful tools to recognize and manage it. The most essential part of foreign body aspiration treatment is prevention and the need to educate parents and primary care physicians. It is, therefore, of the utmost importance to consider airway foreign bodies as a cause of cough unresponsive to therapy, recurrent wheezing, and relapsing pneumonia.

[1]
Salih AM, Alfaki M, Alam-Elhuda DM. Airway foreign bodies: A critical review for a common pediatric emergency. World J Emerg Med 2016; 7(1): 5-12.
[http://dx.doi.org/10.5847/wjem.j.1920-8642.2016.01.001] [PMID: 27006731]
[2]
Heyer CM, Bollmeier ME, Rossler L, et al. Evaluation of clinical, radiologic, and laboratory prebronchoscopy findings in children with suspected foreign body aspiration. J Pediatr Surg 2006; 41(11): 1882-8.
[http://dx.doi.org/10.1016/j.jpedsurg.2006.06.016] [PMID: 17101364]
[3]
Karakoc F, Cakir E, Ersu R, et al. Late diagnosis of foreign body aspiration in children with chronic respiratory symptoms. Int J Pediatr Otorhinolaryngol 2007; 71(2): 241-6.
[http://dx.doi.org/10.1016/j.ijporl.2006.10.006] [PMID: 17125849]
[4]
Mu L, He P, Sun D. The causes and complications of late diagnosis of foreign body aspiration in children. Report of 210 cases. Arch Otolaryngol Head Neck Surg 1991; 117(8): 876-9.
[http://dx.doi.org/10.1001/archotol.1991.01870200070010] [PMID: 1892618]
[5]
Manti S, Licari A. How to obtain informed consent for research. Breathe 2018; 14(2): 145-52.
[http://dx.doi.org/10.1183/20734735.001918] [PMID: 29875834]
[6]
Manti S, Licari A, Leonardi S, Marseglia GL. Management of asthma exacerbations in the paediatric population: A systematic review. Eur Respir Rev 2021; 30(161): 200367.
[http://dx.doi.org/10.1183/16000617.0367-2020] [PMID: 34261742]
[7]
Brkic F, Umihanic S, Altumbabic H, et al. Death as a consequence of foreign body aspiration in children. Med Arh 2018; 72(3): 220-3.
[http://dx.doi.org/10.5455/medarh.2018.72.220-223] [PMID: 30061771]
[8]
Ding L, Su S, Chen C, Yao H, Xiao L. Tracheobronchial foreign bodies in children: Experience from 1,328 patients in china. Front Pediatr 2022; 10: 873182.
[http://dx.doi.org/10.3389/fped.2022.873182] [PMID: 35722476]
[9]
Ciftci AO, Bingöl-Koloğlu M, Şenocak ME, Tanyel FC, Büyükpamukçu N. Bronchoscopy for evaluation of foreign body aspiration in children. J Pediatr Surg 2003; 38(8): 1170-6.
[http://dx.doi.org/10.1016/S0022-3468(03)00263-X] [PMID: 12891487]
[10]
Reilly JS, Cook SP, Stool D, Rider G. Prevention and management of aerodigestive foreign body injuries in childhood. Pediatr Clin North Am 1996; 43(6): 1403-11.
[http://dx.doi.org/10.1016/S0031-3955(05)70525-3] [PMID: 8973519]
[11]
Boufersaoui A, Smati L, Benhalla KN, et al. Foreign body aspiration in children: Experience from 2624 patients. Int J Pediatr Otorhinolaryngol 2013; 77(10): 1683-8.
[http://dx.doi.org/10.1016/j.ijporl.2013.07.026] [PMID: 23962764]
[12]
Romero BM, Vilchez-Bravo S, Hernández-Arriaga G, et al. Factors associated with complications of foreign body ingestion and/or aspiration in children from a Peruvian hospital. Heliyon 2023; 9(2): e13450.
[http://dx.doi.org/10.1016/j.heliyon.2023.e13450] [PMID: 36846670]
[13]
Parvar SY, Sarasyabi MS, Moslehi MA, et al. The characteristics of foreign bodies aspirated by children across different continents: A comparative review. Pediatr Pulmonol 2023; 58(2): 408-24.
[http://dx.doi.org/10.1002/ppul.26242] [PMID: 36373422]
[14]
Sai Akhil R, Priya TG, Behera BK, et al. Clinico-radiological profile and outcome of airway foreign body aspiration in children: A single-center experience from a tertiary care center in eastern India. Cureus 2022; 14(2): e22163.
[http://dx.doi.org/10.7759/cureus.22163] [PMID: 35308662]
[15]
Behera G, Tripathy N, Maru YK, Mundra RK, Gupta Y, Lodha M. Role of virtual bronchoscopy in children with a vegetable foreign body in the tracheobronchial tree. J Laryngol Otol 2014; 128(12): 1078-83.
[http://dx.doi.org/10.1017/S0022215114002837] [PMID: 25388230]
[16]
Shivakumar AM, Naik AS, Prashanth KB, Shetty KD, Praveen DS. Tracheobronchial foreign bodies. Indian J Pediatr 2003; 70(10): 793-7.
[http://dx.doi.org/10.1007/BF02723797] [PMID: 14649474]
[17]
Chand R, Shaikh M, Khan Y, Qureshi MA, Maheshwari H, Yasir M. Frequency of various foreign bodies retrieved from the airway during bronchoscopy in children: A pediatric tertiary care center experience. Cureus 2020; 12(7): e9348.
[http://dx.doi.org/10.7759/cureus.9348] [PMID: 32850221]
[18]
Nenna R, Hunt KA, Dassios T, et al. Key paediatric messages from the 2018 European Respiratory Society International Congress. ERJ Open Res 2019; 5(2): 00241-2018.
[http://dx.doi.org/10.1183/23120541.00241-2018] [PMID: 31044141]
[19]
Williams A, George C, Sam S, Shukla S, Atul PS. An audit of morbidity and mortality associated with foreign body aspiration in children from a tertiary level hospital in Northern India. Afr J Paediatr Surg 2014; 11(4): 287-92.
[http://dx.doi.org/10.4103/0189-6725.143129] [PMID: 25323175]
[20]
Sink JR, Kitsko DJ, Georg MW, Winger DG, Simons JP. Predictors of foreign body aspiration in children. Otolaryngol Head Neck Surg 2016; 155(3): 501-7.
[http://dx.doi.org/10.1177/0194599816644410] [PMID: 27071446]
[21]
Marseglia GL, Manti S, Chiappini E, et al. Acute cough in children and adolescents: A systematic review and a practical algorithm by the italian society of pediatric allergy and immunology. Allergol Immunopathol 2021; 49(2): 155-69.
[http://dx.doi.org/10.15586/aei.v49i2.45] [PMID: 33641306]
[22]
Marseglia GL, Manti S, Chiappini E, et al. Chronic cough in childhood: A systematic review for practical guidance by the italian society of pediatric allergy and immunology. Allergol Immunopathol 2021; 49(2): 133-54.
[http://dx.doi.org/10.15586/aei.v49i2.44] [PMID: 33641305]
[23]
Al Masaoudi L, Kolethekkat AA, Jose S, Al Abri R. Can clinical and radiological diagnosis reduce the need for bronchoscopy in pediatric tracheobronchial foreign body aspiration cases? Oman Med J 2022; 37(4): e409.
[http://dx.doi.org/10.5001/omj.2022.80] [PMID: 36052105]
[24]
Tokar B, Ozkan R, Ilhan H. Tracheobronchial foreign bodies in children: Importance of accurate history and plain chest radiography in delayed presentation. Clin Radiol 2004; 59(7): 609-15.
[http://dx.doi.org/10.1016/j.crad.2004.01.006] [PMID: 15208067]
[25]
Foltran F, Ballali S, Passali FM, et al. Foreign bodies in the airways: A meta-analysis of published papers. Int J Pediatr Otorhinolaryngol 2012; 76(Suppl. 1): S12-9.
[http://dx.doi.org/10.1016/j.ijporl.2012.02.004] [PMID: 22333317]
[26]
Bai W, Zhou X, Gao X, Shao C, Califano JA, Ha PK. Value of chest CT in the diagnosis and management of tracheobronchial foreign bodies. Pediatr Int 2011; 53(4): 515-8.
[http://dx.doi.org/10.1111/j.1442-200X.2010.03299.x] [PMID: 21129123]
[27]
Azzi JL, Seo C, McInnis G, et al. A systematic review and meta-analysis of computed tomography in the diagnosis of pediatric foreign body aspiration. Int J Pediatr Otorhinolaryngol 2023; 165: 111429.
[http://dx.doi.org/10.1016/j.ijporl.2022.111429] [PMID: 36621123]
[28]
Qiu W, Wu L, Chen Z. Foreign body aspiration in children with negative multi-detector Computed Tomography results: Own experience during 2011–2018. Int J Pediatr Otorhinolaryngol 2019; 124: 90-3.
[http://dx.doi.org/10.1016/j.ijporl.2019.05.031] [PMID: 31174024]
[29]
Baram A, Sherzad H, Saeed S, Kakamad FH, Hamawandi AMH. Tracheobronchial foreign bodies in children: The role of emergency rigid bronchoscopy. Glob Pediatr Health 2017; 4: 2333794X17743663.
[http://dx.doi.org/10.1177/2333794X17743663]
[30]
Martinot A, Closset M, Marquette CH, et al. Indications for flexible versus rigid bronchoscopy in children with suspected foreign-body aspiration. Am J Respir Crit Care Med 1997; 155(5): 1676-9.
[http://dx.doi.org/10.1164/ajrccm.155.5.9154875] [PMID: 9154875]
[31]
Dorterler M, Kocaman O, Gunendi T, Boleken M. A single-center experience of pediatric foreign-body aspiration: A retrospective 4-year case series. Lung India 2019; 36(3): 202-6.
[http://dx.doi.org/10.4103/lungindia.lungindia_69_18] [PMID: 31031339]
[32]
Fidkowski CW, Zheng H, Firth PG. The anesthetic considerations of tracheobronchial foreign bodies in children: A literature review of 12,979 cases. Anesth Analg 2010; 111(4): 1016-25.
[http://dx.doi.org/10.1213/ANE.0b013e3181ef3e9c] [PMID: 20802055]
[33]
Hui H, Na L, Zhijun CJ, et al. Therapeutic experience from 1428 patients with pediatric tracheobronchial foreign body. J Pediatr Surg 2008; 43(4): 718-21.
[http://dx.doi.org/10.1016/j.jpedsurg.2007.10.010] [PMID: 18405721]
[34]
Saki N, Nikakhlagh S, Rahim F, Abshirini H. Foreign body aspirations in Infancy: A 20-year experience. Int J Med Sci 2009; 6(6): 322-8.
[http://dx.doi.org/10.7150/ijms.6.322] [PMID: 19851473]
[35]
Liu B, Ding F, An Y, et al. Occult foreign body aspirations in pediatric patients: 20-years of experience. BMC Pulm Med 2020; 20(1): 320.
[http://dx.doi.org/10.1186/s12890-020-01356-8] [PMID: 33298020]
[36]
Yadav SP, Singh J, Aggarwal N, Goel A. Airway foreign bodies in children: Experience of 132 cases. Singapore Med J 2007; 48(9): 850-3.
[PMID: 17728968]
[37]
Manti S, Parisi GF, Giacchi V, et al. Pilot study shows right ventricular diastolic function impairment in young children with obstructive respiratory disease. Acta Paediatr 2019; 108(4): 740-4.
[http://dx.doi.org/10.1111/apa.14574] [PMID: 30194783]
[38]
Lin FZ, Cao W, Xu B, Liu J, Bi J, Fu Y. Risk factors for lower respiratory tract infection associated with tracheobronchial foreign body aspiration in children. Ann Otol Rhinol Laryngol 2022; 2022: 34894221143583.
[http://dx.doi.org/10.1177/00034894221143583] [PMID: 36564908]
[39]
Parisi GF, Indolfi C, Decimo F, Leonardi S, Miraglia del Giudice M. COVID-19 pneumonia in children: From etiology to management. Front Pediatr 2020; 8: 616622.
[http://dx.doi.org/10.3389/fped.2020.616622] [PMID: 33381482]
[40]
Oliveira CF, Almeida JFL, Troster EJ, Vaz FAC. Complications of tracheobronchial foreign body aspiration in children: Report of 5 cases and review of the literature. Rev Hosp Clin Fac Med Sao Paulo 2002; 57(3): 108-11.
[http://dx.doi.org/10.1590/S0041-87812002000300005] [PMID: 12118268]
[41]
Hidaka H, Obara T, Kuriyama S, Kurosawa S, Katori Y, Kobayashi T. Logistic regression analysis of risk factors for prolonged pulmonary recovery in children from aspirated foreign body. Int J Pediatr Otorhinolaryngol 2013; 77(10): 1677-82.
[http://dx.doi.org/10.1016/j.ijporl.2013.07.024] [PMID: 23962765]
[42]
Hitter A, Hullo E, Durand C, Righini CA. Diagnostic value of various investigations in children with suspected foreign body aspiration. Eur Ann Otorhinolaryngol Head Neck Dis 2011; 128(5): 248-52.
[http://dx.doi.org/10.1016/j.anorl.2010.12.011] [PMID: 22018977]
[43]
Licari A, Manti S, Castagnoli R, et al. Immunomodulation in pediatric asthma. Front Pediatr 2019; 7: 289.
[http://dx.doi.org/10.3389/fped.2019.00289] [PMID: 31355170]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version584msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:26:23] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:26:23] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:26:23] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:26:23] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:26:23] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (206ms)time
  • Application (378ms)time
  • 1 x Application (64.74%)
    378ms
    1 x Booting (35.25%)
    206ms
    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 duplicated232ms
    • 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 ('51638174','',1,1740774383,1740774383) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740774383
      1.86msalphaeurekaselec_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 ('51638174','/article/134586',1,1740774383,1740774383)
      10.71msalphaeurekaselec_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 >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) 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 >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) 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 >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) 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 >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) 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 >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) 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 >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51638174 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51638174) limit 1
      29.05msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51638174
      • 1: 51638174
      • 2: 51638174
      • 3: 51638174
      • 4: 51638174
      • 5: 51638174
      • 6: 51638174
      • 7: 51638174
      • 8: 51638174
      • 9: 51638174
      • 10: 51638174
      • 11: 51638174
      • 12: 51638174
      • 13: 51638174
      • 14: 51638174
      • 15: 51638174
      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=134586
      1.62msalphaeurekaselec_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` = 47 limit 1
      1.17msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 47
      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=47) and sj.journal_id!=47 group by `j`.`nid`) as `aggregate_table`
      1.24msalphaeurekaselec_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=47) and sj.journal_id!=47 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.04msalphaeurekaselec_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=47) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      5.06msalphaeurekaselec_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=47) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      3.88msalphaeurekaselec_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` = '134586'
      360μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 134586
      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` = '134586'
      3.26msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 134586
      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` = '134586' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      4.81msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 134586
      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
      1.89msalphaeurekaselec_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
      770μ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 = 47 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      44.21msalphaeurekaselec_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 = 47 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      10.32msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2070
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 47 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      8.07msalphaeurekaselec_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` = 134586 limit 1
      440μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 134586
      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 = 134586 and content_type = 'article' order by status desc limit 1
      550μ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` = 221124 limit 1
      660μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 221124
      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
      330μ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` = 'CRMR' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      490μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CRMR
      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 = '134586' 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) )
      550μ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 = '12872' 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) )
      510μ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 = '3360' 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) )
      500μ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 <= 51638174 and j.to_ip >=51638174 )) and ((j.from_date <= 1740774383 and j.to_date >= 1740774383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3360) 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 <= 51638174 and j.to_ip >=51638174 )) and ((j.from_date <= 1740774383 and j.to_date >= 1740774383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3360) 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 <= 51638174 and j.to_ip >=51638174 )) and ((j.from_date <= 1740774383 and j.to_date >= 1740774383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3360)
      32.32msalphaeurekaselec_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 <= 51638174 and j.to_ip >=51638174 )) and ((j.from_date <= 1740774383 and j.to_date >= 1740774383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12872) 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 <= 51638174 and j.to_ip >=51638174 )) and ((j.from_date <= 1740774383 and j.to_date >= 1740774383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12872) 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 <= 51638174 and j.to_ip >=51638174 )) and ((j.from_date <= 1740774383 and j.to_date >= 1740774383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12872)
      930μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2297
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51638174 and j.to_ip >=51638174 )) and ((j.from_date <= 1740774383 and j.to_date >= 1740774383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 134586) 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 <= 51638174 and j.to_ip >=51638174 )) and ((j.from_date <= 1740774383 and j.to_date >= 1740774383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 134586) 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 <= 51638174 and j.to_ip >=51638174 )) and ((j.from_date <= 1740774383 and j.to_date >= 1740774383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 134586)
      930μ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` < '323' and is_uploaded = 1 and issue_id = 12872 order by cast(first_page as SIGNED) desc limit 1
      850μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 323
      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` > '329' and is_uploaded = 1 and issue_id = 12872 order by cast(first_page as SIGNED) asc limit 1
      720μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 329
      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'
      23.62msalphaeurekaselec_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
      380μ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` = 134586 limit 1
      10.74msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 134586
      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` = 47 and `b`.`banner_from_date` <= 1740774383 and `b`.`banner_to_date` >= 1740774383 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.92msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 47
      • 3: 1740774383
      • 4: 1740774383
      • 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` = 47 and `b`.`banner_from_date` <= 1740774383 and `b`.`banner_to_date` >= 1740774383 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.84msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 47
      • 3: 1740774383
      • 4: 1740774383
      • 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='f97bb07096f6f305a8238b0d7f36d906'
      24.65msalphaeurekaselec_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
        fhsTb0g5I7XnPHpJOL7oi1RYORf3ymLYgCznPVQr
        uc_cart_id
        f97bb07096f6f305a8238b0d7f36d906
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/134586" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/134586
        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:26:23 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkcvRkJmRHRUZVZXWVZwakVCbFZhckE9PSIsInZhbHVlIjoiT2F2d0d3NkhUVlFUbzJOS214WW1yN00zcmNXa3JhelRtN00vRVJiN3JJcW1sbVNTdVlxWnpGN0dYeXFnaUNhNVI3Q3cxaEVwcWFRaHlzd3htNjYya2FPV042MHRqQTl3RmpyR3lMR1VZRXFNNkUrbkxUeFNkYjMyMDArYXRXVG8iLCJtYWMiOiJkZTgzNjk1OGQ5NTNjM2QwMjdmYjY2YzMyNmM1MjZhNGMyY2ExYTVlODM3ODk4MTEyYWFlMzU3NDFiOWY2YTFhIiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 08:26:23 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkcvRkJmRHRUZVZXWVZwakVCbFZhckE9PSIsInZhbHVlIjoiT2F2d0d3NkhUVlFUbzJOS214WW1yN00zcmNXa3JhelRtN00vRVJiN3JJcW1sbVNTdVlxWnpGN0dYeXFnaUNhNVI3Q3cxa" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlljOFkyNGJRRzNJb0RGNjhvcThodEE9PSIsInZhbHVlIjoiQkQrZER5MzI5ZTNkWG9seEE5R21ob1NtRGNSa0ROTkhLd2tCZjd5cG5USVFHYzAxc09ZYi9KSHd1NlhjcjFPc2ZCNHROc0pPR1pOY2RiQkFSY3A2RHluaWlqeldZSGx0UzZlZldpbStaK3BJQnpWUkNMYnV1ZG9ybWxNcXZMWlciLCJtYWMiOiI1MDAwZjU0N2VmMjBmNmY3MTM1ZWM1ZDkzNzA5ZTM1MmM4ZjIwOTBiMGRmNjg4MzllZjliMjZjZThmYWM4ZmY3IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlljOFkyNGJRRzNJb0RGNjhvcThodEE9PSIsInZhbHVlIjoiQkQrZER5MzI5ZTNkWG9seEE5R21ob1NtRGNSa0ROTkhLd2tCZjd5cG5USVFHYzAxc09ZYi9KSHd" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkcvRkJmRHRUZVZXWVZwakVCbFZhckE9PSIsInZhbHVlIjoiT2F2d0d3NkhUVlFUbzJOS214WW1yN00zcmNXa3JhelRtN00vRVJiN3JJcW1sbVNTdVlxWnpGN0dYeXFnaUNhNVI3Q3cxaEVwcWFRaHlzd3htNjYya2FPV042MHRqQTl3RmpyR3lMR1VZRXFNNkUrbkxUeFNkYjMyMDArYXRXVG8iLCJtYWMiOiJkZTgzNjk1OGQ5NTNjM2QwMjdmYjY2YzMyNmM1MjZhNGMyY2ExYTVlODM3ODk4MTEyYWFlMzU3NDFiOWY2YTFhIiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 08:26:23 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkcvRkJmRHRUZVZXWVZwakVCbFZhckE9PSIsInZhbHVlIjoiT2F2d0d3NkhUVlFUbzJOS214WW1yN00zcmNXa3JhelRtN00vRVJiN3JJcW1sbVNTdVlxWnpGN0dYeXFnaUNhNVI3Q3cxa" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlljOFkyNGJRRzNJb0RGNjhvcThodEE9PSIsInZhbHVlIjoiQkQrZER5MzI5ZTNkWG9seEE5R21ob1NtRGNSa0ROTkhLd2tCZjd5cG5USVFHYzAxc09ZYi9KSHd1NlhjcjFPc2ZCNHROc0pPR1pOY2RiQkFSY3A2RHluaWlqeldZSGx0UzZlZldpbStaK3BJQnpWUkNMYnV1ZG9ybWxNcXZMWlciLCJtYWMiOiI1MDAwZjU0N2VmMjBmNmY3MTM1ZWM1ZDkzNzA5ZTM1MmM4ZjIwOTBiMGRmNjg4MzllZjliMjZjZThmYWM4ZmY3IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlljOFkyNGJRRzNJb0RGNjhvcThodEE9PSIsInZhbHVlIjoiQkQrZER5MzI5ZTNkWG9seEE5R21ob1NtRGNSa0ROTkhLd2tCZjd5cG5USVFHYzAxc09ZYi9KSHd" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "fhsTb0g5I7XnPHpJOL7oi1RYORf3ymLYgCznPVQr" "uc_cart_id" => "f97bb07096f6f305a8238b0d7f36d906" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/134586" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 20:26:23GET/article/134586514361