Generic placeholder image

Infectious Disorders - Drug Targets

Editor-in-Chief

ISSN (Print): 1871-5265
ISSN (Online): 2212-3989

Research Article

Frequency of Helicobacter pylori Infection in Patients with Peptic Ulcer Referred to the Endoscopy Departments of Khorramabad City Hospitals, Iran, During 2013-2016

Author(s): Fatemeh Ramezani, Pegah Shakib, Setareh Soroush, Faranak Rezaei, Mosayeb Moradniani* and Somayeh Delfani*

Volume 22, Issue 5, 2022

Published on: 18 April, 2022

Article ID: e020222200771 Pages: 8

DOI: 10.2174/1871526522666220202143058

Price: $65

Abstract

Background: The present study investigated the prevalence of Helicobacter pylori infection in peptic ulcer patients referred to the endoscopy departments in Khorramabad hospitals during 2013- 2016.

Methods: The early pool of the study included all patients who had been referred to the endoscopy department and whose endoscopic and pathology reports were available and complete. After recording endoscopic reports, 1224 peptic ulcer (gastric or duodenal ulcer) cases, in which biopsy assays were performed to examine the type of ulcer and the presence of Helicobacter pylori bacteria, were selected. Pathology reports were collected by referring to the pathology departments. The information in the pathology report, including demographic information, was included in a pre-designed questionnaire to match the endoscopic reports, the location of the pathology sample, and other details, including the presence or absence of Helicobacter pylori bacteria. Finally, the data were analyzed using SPSS, version 21.

Results: For all the 1224 patients studied, the mean age was 15.5 ± 17.5 years old. A total of 664 (54.2%) cases had gastric ulcers, 445 (36.4%) cases had duodenal ulcers, and 115 (9.4%) had both gastric and duodenal ulcers. Among gastric ulcer patients, 512 (65.7%) had a gastric ulcer in the antrum area, and 74.3% (579 patients) of the gastric ulcers were clean base type.

Conclusion: The prevalence of infection was statistically significant in terms of the type, location, and number of peptic ulcers, including both gastric ulcer and duodenal ulcer.

Keywords: Peptic ulcer disease, gastric ulcer, duodenal ulcer, Helicobacter pylori, carcinogen, antrum area.

Graphical Abstract

[1]
Kasper DL, Fauci A, Hauser S, Longo D, Jameson J, Loscalzo J. Harrison’s principles of internal medicine. NY, USA: McGraw Hill Professional 2018.
[2]
Ghorbani D, Kargar M, Doosti A, Abbasi P, Souod N. Optimization of real-time PCR method to assess the direct sensitivity of clarithromycin in Helicobacter pylori. J Microbial World 2009; 2(3): 149-54.
[3]
Logan RP, Walker MM. ABC of the upper gastrointestinal tract: Epidemiology and diagnosis of Helicobacter pylori infection. BMJ 2001; 323(7318): 920-2.
[http://dx.doi.org/10.1136/bmj.323.7318.920] [PMID: 11668141]
[4]
McColl KE. Helicobacter pylori infection. N Engl J Med 2010; 362(17): 1597-604.
[http://dx.doi.org/10.1056/NEJMcp1001110] [PMID: 20427808]
[5]
Walsh JH, Peterson WL. The treatment of Helicobacter pylori infection in the management of peptic ulcer disease. N Engl J Med 1995; 333(15): 984-91.
[http://dx.doi.org/10.1056/NEJM199510123331508] [PMID: 7666920]
[6]
Malfertheiner P, Megraud F, O’Morain CA, et al. European Helicobacter Study Group Management of Helicobacter pylori infection-the Maastricht IV/Florence consensus report. Gut 2012; 61(5): 646-64.
[http://dx.doi.org/10.1136/gutjnl-2012-302084] [PMID: 22491499]
[7]
Graham DY, Fischbach L. Helicobacter pylori treatment in the era of increasing antibiotic resistance. Gut 2010; 59(8): 1143-53.
[http://dx.doi.org/10.1136/gut.2009.192757] [PMID: 20525969]
[8]
Gisbert JP, Calvet X. Review article: the effectiveness of standard triple therapy for Helicobacter pylori has not changed over the last decade, but it is not good enough. Aliment Pharmacol Ther 2011; 34(11-12): 1255-68.
[http://dx.doi.org/10.1111/j.1365-2036.2011.04887.x] [PMID: 22017749]
[9]
rberg M, Nyrén O, Granstrm M. Unexpected decrease with age of Helicobacter pylori seroprevalence among Swedish blood donors. J Clin Microbiol 2003; 41(9): 4038-42.
[http://dx.doi.org/10.1128/JCM.41.9.4038-4042.2003] [PMID: 12958222]
[10]
Hooi JKY, Lai WY, Ng WK, et al. Global prevalence of Helicobacter pylori infection: systematic review and meta-analysis. Gastroenterology 2017; 153(2): 420-9.
[http://dx.doi.org/10.1053/j.gastro.2017.04.022] [PMID: 28456631]
[11]
Graham DY. History of Helicobacter pylori, duodenal ulcer, gastric ulcer and gastric cancer. World J Gastroenterol 2014; 20(18): 5191-204.
[http://dx.doi.org/10.3748/wjg.v20.i18.5191] [PMID: 24833849]
[12]
Wang C, Yuan Y, Hunt RH. The association between Helicobacter pylori infection and early gastric cancer: a meta-analysis. Am J Gastroenterol 2007; 102(8): 1789-98.
[http://dx.doi.org/10.1111/j.1572-0241.2007.01335.x] [PMID: 17521398]
[13]
Everhart JE, Kruszon-Moran D, Perez-Perez GI, Tralka TS, McQuillan G. Seroprevalence and ethnic differences in Helicobacter pylori infection among adults in the United States. J Infect Dis 2000; 181(4): 1359-63.
[http://dx.doi.org/10.1086/315384] [PMID: 10762567]
[14]
Cardenas VM, Mulla ZD, Ortiz M, Graham DY. Iron deficiency and Helicobacter pylori infection in the United States. Am J Epidemiol 2006; 163(2): 127-34.
[http://dx.doi.org/10.1093/aje/kwj018] [PMID: 16306309]
[15]
Eslick GD, Lim LL, Byles JE, Xia HH, Talley NJ. Association of Helicobacter pylori infection with gastric carcinoma: a meta-analysis. Am J Gastroenterol 1999; 94(9): 2373-9.
[http://dx.doi.org/10.1111/j.1572-0241.1999.01360.x] [PMID: 10483994]
[16]
Helicobacter and Cancer Collaborative Group Gastric cancer and Helicobacter pylori: a combined analysis of 12 case control studies nested within prospective cohorts. Gut 2001; 49(3): 347-53.
[http://dx.doi.org/10.1136/gut.49.3.347] [PMID: 11511555]
[17]
Huang JQ, Sridhar S, Chen Y, Hunt RH. Meta-analysis of the relationship between Helicobacter pylori seropositivity and gastric cancer. Gastroenterology 1998; 114(6): 1169-79.
[http://dx.doi.org/10.1016/S0016-5085(98)70422-6] [PMID: 9609753]
[18]
International agency for research on cancer. Helicobacter pylori eradication as a strategy for preventing gastric Cancer. (IARC Working Group Reports, No. 8). 2014. Available from: http://www.iarc.fr/en/publications/pdfs-online/wrk/wrk8/index.php (Accessed November 18, 2016).
[19]
Takenaka R, Okada H, Kato J, et al. Helicobacter pylori eradication reduced the incidence of gastric cancer, especially of the intestinal type. Aliment Pharmacol Ther 2007; 25(7): 805-12.
[http://dx.doi.org/10.1111/j.1365-2036.2007.03268.x] [PMID: 17373919]
[20]
Yeh JM, Kuntz KM, Ezzati M, Goldie SJ. Exploring the cost-effectiveness of Helicobacter pylori screening to prevent gastric cancer in China in anticipation of clinical trial results. Int J Cancer 2009; 124(1): 157-66.
[http://dx.doi.org/10.1002/ijc.23864] [PMID: 18823009]
[21]
Sayehmiri F, Darvishi Z, Sayehmiri K, et al. A systematic review and meta-analysis study to investigate the prevalence of Helicobacter pylori and the sensitivity of its diagnostic methods in Iran. Iran Red Crescent Med J 2014; 16(6)e12581
[http://dx.doi.org/10.5812/ircmj.12581] [PMID: 25068041]
[22]
Fakher.Yasseri H. Determination of Helicobacter-Pylori prevalence in histologic gastritis and intestinal metaplasia and related to age and sex studyon 576 patients with nonulcer dyspepsia at endascopy department of Firozgar hospital. Majallah-i Ulum-i Pizishki-i Razi 2002; 9(30): 379-87.
[23]
Shafaie Tilaki S, Kaboosi H, Peyravii Ghadikolaii F. Prevalence of coinfection Helicobacter pylori with non-Helicobacter pylori helicobacters species in patients suffering from gastric diseases in Iran. J Ilam Uni Med Sci 2019; 27(3): 101-11.
[http://dx.doi.org/10.29252/sjimu.27.3.101]
[24]
Kargar M, Souod N, Ghorbani-Dalini S, Doosti A. Epidemiological evaluation of Helicobacter pylori infection in patients with gastrointestinal disorders in Chahar Mahal and Bakhtiari province. J Fasa Univ Med Sci 2013; 2(4): 266-72.
[25]
Abdolhosseini A, Sarraf KT, Tayebi S, Izanloo A, Jafari N. Prevalence of peptic ulcer disease in asymptomatic subjects referring to the check-up clinic of Razavi hospital from 2006-2011. Razavi Int J Med 2014 2(1).
[http://dx.doi.org/10.5812/rijm.15555]
[26]
Smeltzer SC, Bare BG. Brunner & Suddarth’s textbook of medical-surgical nursing JB Lippincott: Philadelphia 1992.
[27]
Kim JJ, Kim N, Park HK, et al. Clinical characteristics of patients diagnosed as peptic ulcer disease in the third referral center in 2007. Korean J Gastroenterol 2012; 59(5): 338-46.
[http://dx.doi.org/10.4166/kjg.2012.59.5.338] [PMID: 22617527]
[28]
Barati M, Talebi Taher M, Hashemi M, Boghratian A. NaserEslami P. Frequency of H. pilori infection and gastric and duodenal lesions in patients. Majallah-i Ulum-i Pizishki-i Razi 2003; 10(35): 347-53.
[29]
Wijetunge S, Kotakadeniya R, Noordeen F, et al. Prevalence of Helicobacter pylori in benign gastric ulcers in a cohort of Sri Lankan patients. Ceylon Med J 2015; 60(4): 152-4.
[http://dx.doi.org/10.4038/cmj.v60i4.8224] [PMID: 26778396]
[30]
Hajagamohammadi A, Sheikholslami H, Esmaeili R. Prevalence of Helicobacter infection in different endoscopic lesions of patients in Qazvin Bouali Sina hospital (2002). J Qazvin Uni Med Sci 2005; 9(3): 68-70.
[31]
Vahidi ShAM, Shakeri A. Comparison of cytology and histopathology in the diagnosis of Helicobacter pylori infection in contact with the stomach biopsy specimens. J Univ Med SciHealth Services martyr Beheshti 2003 26(4): 241-3.
[32]
Ghahramani R, Abbasian AS, Shafaee S. Prevelence of celiac disease in patients with different types of dyspepsia. J Isfahan Med Scho 2009; 27(93): 65-73.
[33]
Kalantari H, Nourian SM. Prevalance of peptic ulcer versus non ulcer dyspepsia in patients which were admitted for endoscopy. Majallah-i Danishkadah-i Pizishki-i Isfahan 2011; 28(118): 1304-9.
[34]
Goudarzi H, Rezaee H, Rafizadeh M, Mirsamadi E, Mirsamadi A. The frequency of cagA gene of H. pylori isolated from biopsy specimen in Tehran during 2008-2010. J Arak Univ Med Sci 2012; 15(5): 42-8.
[35]
Bani-Hani K, El-Migdadi F. A comparative study of the prevalence of Helicobacter pylori between the inhabitants of areas of different barometric pressure. Int J Gastroentrol 2005; p. 3.
[36]
Kaur G, Naing NN. Prevalence and ethnic distribution of Helicobacter pylori infection among endoscoped patients in North Eastern Peninsular Malaysia. Malays J Med Sci 2003; 10(2): 66-70.
[PMID: 23386799]
[37]
Nahaei M, Pakzad S, Mahmodlou R, Shateri K. Aassociation between Helicobacter pylori infection and perforated peptic ulcer in patients operated in Urmia Imam Khomeini teaching hospital 2019 40(6): 81- 7.
[38]
Yamaguchi N, Kakizoe T. Synergistic interaction between Helicobacter pylori gastritis and diet in gastric cancer. Lancet Oncol 2001; 2(2): 88-94.
[http://dx.doi.org/10.1016/S1470-2045(00)00225-4] [PMID: 11905800]
[39]
Meining A, Riedl B, Stolte M. Features of gastritis predisposing to gastric adenoma and early gastric cancer. J Clin Pathol 2002; 55(10): 770-3.
[http://dx.doi.org/10.1136/jcp.55.10.770] [PMID: 12354805]
[40]
Graham DYI. Helicobacter pylori: its epidemiology and its role in duodenal ulcer disease. J Gastroenterol Hepatol 1991; 6(2): 105-13.
[http://dx.doi.org/10.1111/j.1440-1746.1991.tb01448.x] [PMID: 1912414]
[41]
Graham DY. Campylobacter pylori and peptic ulcer disease. Gastroenterology 1989; 96(2 Pt 2)(Suppl.): 615-25.
[http://dx.doi.org/10.1016/S0016-5085(89)80057-5] [PMID: 2642447]
[42]
Genta RM, Graham DY. Comparison of biopsy sites for the histopathologic diagnosis of Helicobacter pylori: a topographic study of H. pylori density and distribution. Gastrointest Endosc 1994; 40(3): 342-5.
[http://dx.doi.org/10.1016/S0016-5107(94)70067-2] [PMID: 7794303]
[43]
Bayerdörffer E, Lehn N, Hatz R, et al. Difference in expression of Helicobacter pylori gastritis in antrum and body. Gastroenterology 1992; 102(5): 1575-82.
[http://dx.doi.org/10.1016/0016-5085(92)91716-H] [PMID: 1568567]
[44]
Stolte M, Eidt S, Ohnsmann A. Differences in Helicobacter pylori associated gastritis in the antrum and body of the stomach. Z Gastroenterol 1990; 28(5): 229-33.
[PMID: 2402931]
[45]
Fischbach W, Malfertheiner P, Hoffmann JC, et al. German society for hygiene and microbiology; German society for pediatric gastroenterology and nutrition e. V; German society for rheumatology. S3-guideline “Helicobacter pylori and gastroduodenal ulcer disease” of the German society for digestive and metabolic diseases (DGVS) in cooperation with the German society for hygiene and microbiology, society for pediatric gastroenterology and nutrition e. V., German society for rheumatology, AWMF-registration-no. 021/001. Z Gastroenterol 2009; 47(12): 1230-63.
[http://dx.doi.org/10.1055/s-0028-1109855] [PMID: 19960402]
[46]
Palli D, Menegatti M, Masala G, et al. Helicobacter pylori infection, anti-cagA antibodies and peptic ulcer: a case-control study in Italy. Aliment Pharmacol Ther 2002; 16(5): 1015-20.
[http://dx.doi.org/10.1046/j.1365-2036.2002.01253.x] [PMID: 11966512]
[47]
Väänänen H, Vauhkonen M, Helske T, et al. Non-endoscopic diagnosis of atrophic gastritis with a blood test. Correlation between gastric histology and serum levels of gastrin-17 and pepsinogen I: a multicentre study. Eur J Gastroenterol Hepatol 2003; 15(8): 885-91.
[http://dx.doi.org/10.1097/00042737-200308000-00009] [PMID: 12867799]
[48]
Souto FJ, Fontes CJ, Rocha GA, de Oliveira AM, Mendes EN, Queiroz DM. Prevalence of Helicobacter pylori infection in a rural area of the state of Mato Grosso, Brazil. Mem Inst Oswaldo Cruz 1998; 93(2): 171-4.
[http://dx.doi.org/10.1590/S0074-02761998000200006] [PMID: 9698887]
[49]
Jais M, Barua S. Seroprevalence of anti Helicobacter pylori IgG/IgA in asymptomatic population from Delhi. J Commun Dis 2004; 36(2): 132-5.
[PMID: 16295676]
[50]
Murray LJ, McCrum EE, Evans AE, Bamford KB. Epidemiology of Helicobacter pylori infection among 4742 randomly selected subjects from Northern Ireland. Int J Epidemiol 1997; 26(4): 880-7.
[http://dx.doi.org/10.1093/ije/26.4.880] [PMID: 9279623]
[51]
Mégraud F, Brassens-Rabbé MP, Denis F, Belbouri A, Hoa DQ. Seroepidemiology of Campylobacter pylori infection in various populations. J Clin Microbiol 1989; 27(8): 1870-3.
[http://dx.doi.org/10.1128/jcm.27.8.1870-1873.1989] [PMID: 2549098]
[52]
Cullen DJ, Collins BJ, Christiansen KJ, et al. When is Helicobacter pylori infection acquired? Gut 1993; 34(12): 1681-2.
[http://dx.doi.org/10.1136/gut.34.12.1681] [PMID: 8282255]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version359msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[18:02:58] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[18:02:58] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[18:02:58] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[18:02:58] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (91.59ms)time
  • Application (268ms)time
  • 1 x Application (74.51%)
    268ms
    1 x Booting (25.49%)
    91.59ms
    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
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated181ms
    • 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 ('222027364','',1,1739988178,1739988178) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739988178
      900μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#24
      Backtrace
      • 11. middleware::check_user_access:24
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('222027364','/article/120624',1,1739988178,1739988178)
      170μ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 >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) 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 >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) 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 >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) 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 >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) 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 >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) 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 >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 222027364 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 222027364) limit 1
      59.29msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 222027364
      • 1: 222027364
      • 2: 222027364
      • 3: 222027364
      • 4: 222027364
      • 5: 222027364
      • 6: 222027364
      • 7: 222027364
      • 8: 222027364
      • 9: 222027364
      • 10: 222027364
      • 11: 222027364
      • 12: 222027364
      • 13: 222027364
      • 14: 222027364
      • 15: 222027364
      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=120624
      960μsalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 54 limit 1
      1.02msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 54
      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=54) and sj.journal_id!=54 group by `j`.`nid`) as `aggregate_table`
      1.71msalphaeurekaselec_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=54) and sj.journal_id!=54 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.46msalphaeurekaselec_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=54) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      8.22msalphaeurekaselec_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=54) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      7.13msalphaeurekaselec_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` = '120624'
      970μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 120624
      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` = '120624'
      2.26msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 120624
      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` = '120624' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.49msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 120624
      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
      340μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      740μ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 = 54 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      41.75msalphaeurekaselec_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 = 54 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      6.69msalphaeurekaselec_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 = 54 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.11msalphaeurekaselec_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` = 120624 limit 1
      220μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 120624
      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 = 120624 and content_type = 'article' order by status desc limit 1
      310μ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 a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 16 and cd.sub_disease_id = 440 and content_id!=120624 and cd.content_type = 'article' order by rand() limit 20
      17.52msalphaeurekaselec_live_10_06_2022Article.php#769
      Backtrace
      • 11. app/Models/Article.php:769
      • 12. app/Http/Controllers/ArticleController.php:2098
      • 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` = 200771 limit 1
      240μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 200771
      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
      290μ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` = 'IDDT' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      330μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: IDDT
      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 = '120624' 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) )
      1.04msalphaeurekaselec_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 = '11565' 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) )
      360μ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 = '3191' 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) )
      310μ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 <= 222027364 and j.to_ip >=222027364 )) and ((j.from_date <= 1739988178 and j.to_date >= 1739988178 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3191) 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 <= 222027364 and j.to_ip >=222027364 )) and ((j.from_date <= 1739988178 and j.to_date >= 1739988178 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3191) 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 <= 222027364 and j.to_ip >=222027364 )) and ((j.from_date <= 1739988178 and j.to_date >= 1739988178 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3191)
      8.44msalphaeurekaselec_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 <= 222027364 and j.to_ip >=222027364 )) and ((j.from_date <= 1739988178 and j.to_date >= 1739988178 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11565) 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 <= 222027364 and j.to_ip >=222027364 )) and ((j.from_date <= 1739988178 and j.to_date >= 1739988178 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11565) 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 <= 222027364 and j.to_ip >=222027364 )) and ((j.from_date <= 1739988178 and j.to_date >= 1739988178 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11565)
      830μ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 <= 222027364 and j.to_ip >=222027364 )) and ((j.from_date <= 1739988178 and j.to_date >= 1739988178 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 120624) 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 <= 222027364 and j.to_ip >=222027364 )) and ((j.from_date <= 1739988178 and j.to_date >= 1739988178 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 120624) 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 <= 222027364 and j.to_ip >=222027364 )) and ((j.from_date <= 1739988178 and j.to_date >= 1739988178 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 120624)
      790μ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` < '63' and is_uploaded = 1 and issue_id = 11565 order by cast(first_page as SIGNED) desc limit 1
      740μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 63
      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` > '70' and is_uploaded = 1 and issue_id = 11565 order by cast(first_page as SIGNED) asc limit 1
      740μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 70
      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'
      240μ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
      300μ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` = 120624 limit 1
      4msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 120624
      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` = 54 and `b`.`banner_from_date` <= 1739988178 and `b`.`banner_to_date` >= 1739988178 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.17msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 54
      • 3: 1739988178
      • 4: 1739988178
      • 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` = 54 and `b`.`banner_from_date` <= 1739988178 and `b`.`banner_to_date` >= 1739988178 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.11msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 54
      • 3: 1739988178
      • 4: 1739988178
      • 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='dc404645409d0403b6e1db6e8310dea5'
      300μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        pNUnTv7GSAQ344gzxwl5WP5vOqyDaY5C8Xd76GAp
        uc_cart_id
        dc404645409d0403b6e1db6e8310dea5
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/120624" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/120624
        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 => "Wed, 19 Feb 2025 18:02:58 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjBPR0hTKzNtckdJMzR2VllHY2lEQUE9PSIsInZhbHVlIjoiN2NRVkMzMGMwb2hyYmdDVmNzK0tBb3RnclQ0RXZQejVvcFpHc0xJL1dtN24rV1dKY2o4a1hBYmdWOW04eFp1MnVnazZ6MVBzQTZPVUQ2RHYrZm1Cc1BIWWF5cXp6SmRaSHNOekxBdDlQK1dTSE1BNjZwRnBLK0phQzYreFF6WHQiLCJtYWMiOiJlMGM1Mzc1ODMxMjgxZmIyYTZiZTk5ZDUyYWVmMzczYzVmMGJhOTM1OWVlNzAyYTA0OGMwZDAwZTViODA0Y2JhIiwidGFnIjoiIn0%3D; expires=Sat, 22 Feb 2025 06:02:58 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjBPR0hTKzNtckdJMzR2VllHY2lEQUE9PSIsInZhbHVlIjoiN2NRVkMzMGMwb2hyYmdDVmNzK0tBb3RnclQ0RXZQejVvcFpHc0xJL1dtN24rV1dKY2o4a1hBYmdWOW04eFp1MnVnazZ6M" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImZwWXhhcXlpYmYrdnd2aEw3T0ZhY3c9PSIsInZhbHVlIjoiQ1AyYmsrUTJZNzlqbHRNa1dCZUNlNFgwYjNHbDhIYk5QMGdvK1p6RXExeTBydkxpZ2E1UE50NWJEY3V5VGJEQ0dFWWdQR0tJcHY4SVFUd251WDdtc0tqTDN5M1IrL2tTNU9zS3ZGeHlXM1hwWDB0RlR1RGMrdzVhR0RySnBobDEiLCJtYWMiOiI4NTkwYjE4YTg2NGMyNGI1NDQyYTIyZWY4NDA4MmU5Zjk1N2U3MGE2ZThmNWVhNjFlMGFlZGMyNmNkYTRiOTY3IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6ImZwWXhhcXlpYmYrdnd2aEw3T0ZhY3c9PSIsInZhbHVlIjoiQ1AyYmsrUTJZNzlqbHRNa1dCZUNlNFgwYjNHbDhIYk5QMGdvK1p6RXExeTBydkxpZ2E1UE50NWJ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjBPR0hTKzNtckdJMzR2VllHY2lEQUE9PSIsInZhbHVlIjoiN2NRVkMzMGMwb2hyYmdDVmNzK0tBb3RnclQ0RXZQejVvcFpHc0xJL1dtN24rV1dKY2o4a1hBYmdWOW04eFp1MnVnazZ6MVBzQTZPVUQ2RHYrZm1Cc1BIWWF5cXp6SmRaSHNOekxBdDlQK1dTSE1BNjZwRnBLK0phQzYreFF6WHQiLCJtYWMiOiJlMGM1Mzc1ODMxMjgxZmIyYTZiZTk5ZDUyYWVmMzczYzVmMGJhOTM1OWVlNzAyYTA0OGMwZDAwZTViODA0Y2JhIiwidGFnIjoiIn0%3D; expires=Sat, 22-Feb-2025 06:02:58 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjBPR0hTKzNtckdJMzR2VllHY2lEQUE9PSIsInZhbHVlIjoiN2NRVkMzMGMwb2hyYmdDVmNzK0tBb3RnclQ0RXZQejVvcFpHc0xJL1dtN24rV1dKY2o4a1hBYmdWOW04eFp1MnVnazZ6M" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImZwWXhhcXlpYmYrdnd2aEw3T0ZhY3c9PSIsInZhbHVlIjoiQ1AyYmsrUTJZNzlqbHRNa1dCZUNlNFgwYjNHbDhIYk5QMGdvK1p6RXExeTBydkxpZ2E1UE50NWJEY3V5VGJEQ0dFWWdQR0tJcHY4SVFUd251WDdtc0tqTDN5M1IrL2tTNU9zS3ZGeHlXM1hwWDB0RlR1RGMrdzVhR0RySnBobDEiLCJtYWMiOiI4NTkwYjE4YTg2NGMyNGI1NDQyYTIyZWY4NDA4MmU5Zjk1N2U3MGE2ZThmNWVhNjFlMGFlZGMyNmNkYTRiOTY3IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6ImZwWXhhcXlpYmYrdnd2aEw3T0ZhY3c9PSIsInZhbHVlIjoiQ1AyYmsrUTJZNzlqbHRNa1dCZUNlNFgwYjNHbDhIYk5QMGdvK1p6RXExeTBydkxpZ2E1UE50NWJ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "pNUnTv7GSAQ344gzxwl5WP5vOqyDaY5C8Xd76GAp" "uc_cart_id" => "dc404645409d0403b6e1db6e8310dea5" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/120624" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-19 18:02:58GET/article/120624414371