Generic placeholder image

Current Drug Safety

Editor-in-Chief

ISSN (Print): 1574-8863
ISSN (Online): 2212-3911

Research Article

Adalimumab versus Infliximab Treatment Outcome in Ulcerative Colitis: Application of EQ-5D, Visual Analogue Scale, and IBDQ-9 Measures: A Prospective Observational Study

Author(s): Hassan Karami, Farbod Ebadi Fard Azar*, Kamran Bagheri Lankarani, Aziz Rezapour, Sulmaz Ghahramani and Abdolvahab Baghbanian

Volume 18, Issue 4, 2023

Published on: 27 August, 2022

Page: [484 - 495] Pages: 12

DOI: 10.2174/1574886317666220526153518

Price: $65

Abstract

Background: Ulcerative colitis (UC) is a chronic global disease, and its incidence and prevalence are increasing worldwide.

Objective: Our objective was to compare the secondary outcome of treatment with Infliximab (IFX) and Adalimumab (ADA) in the UC patients.

Methods: This was a one-year prospective observational study of moderate- to -severe UC patients treated with ADA or IFX. Patients' secondary health outcomes were measured using the EQ-5D 3L, EQ-VAS, and IBDQ-9 tools. T-test, Mann-Whitney, chi-square, and Fisher's exact tests were used to compare health-related quality of life (HRQoL) among UC patients. HRQoL predictor variables were identified by multivariate linear regression and multivariate logistic regression.

Results: A total of 238 UC patients (patients taking IFX: 78, patients taking ADA: 160) with a mean age of 37.66 and a mean disease duration of 9.29 years were enrolled. The EQ-5D index, EQ-VAS, and IBDQ-9 scores of patients taking IFX were 0.65, 55.93 and, 37.42, respectively. Similarly, patients taking ADA were 0.68, 59.27 and, 36.61, respectively. The highest problem reports were in P/D: 86.1% and A/D: 73.5%. The main independent predictors of HRQoL were: education over 12 years (β = 0.054 [EQ-5D index], β = 13.63 [EQ-VAS], OR: 0.28 [MO], OR: 0.07 [SC]), education between 6-12 years (β = 11.23 [EQ-VAS]), and having "other chronic diseases" (β = -0.074 [EQ-5D index], β = -5.29 [IBDQ-9], OR: 2.84 [UA], OR: 3.80 [A/D]).

Conclusion: There was no significant difference between the effect of ADA and IFX on secondary health outcomes in patients with moderate-to-severe UC.

Keywords: Infliximab, Adalimumab, Ulcerative colitis, EQ-5D, Iran, Health-related quality of life

[1]
Gibson PR, Vaizey C, Black CM, et al. Relationship between disease severity and quality of life and assessment of health care utilization and cost for ulcerative colitis in Australia: A cross-sectional, observational study. J Crohn’s Colitis 2014; 8(7): 598-606.
[http://dx.doi.org/10.1016/j.crohns.2013.11.017] [PMID: 24345767]
[2]
Molodecky N A, Soon S, Rabi D M, et al. Increasing incidence and prevalence of the inflammatory bowel diseases with time, based on systematic review. Gastroenterology 2012; 142(1): 46-54.
[http://dx.doi.org/10.1053/j.gastro.2011.10.001]
[3]
Gholamrezaei A, Haghdani S, Shemshaki H, Tavakoli H, Emami MH. Linguistic validation of the inflammatory bowel disease questionnaire-short form (IBDQ-9) in Iranian population. majallah-i danishkadah-i pizishki-i isfahan 2011; 28(123): 1-10.
[4]
Iglesias M, Vázquez I, Barreiro-de Acosta M, et al. Health related quality of life in patients with Cohn´s disease in remission. Rev Esp Enferm Dig 2010; 102(11): 624-30.
[http://dx.doi.org/10.4321/S1130-01082010001100002] [PMID: 21142382]
[5]
Casellas F, Robles V, Borruel N, et al. Restoration of quality of life of patients with inflammatory bowel disease after one year with antiTNFα treatment. J Crohn’s Colitis 2012; 6(9): 881-6.
[http://dx.doi.org/10.1016/j.crohns.2012.01.019] [PMID: 22398074]
[6]
Poole CD, Connolly MP, Nielsen SK, Currie CJ, Marteau P. A comparison of physician-rated disease severity and patient reported outcomes in mild to moderately active ulcerative colitis. J Crohn’s Colitis 2010; 4(3): 275-82.
[http://dx.doi.org/10.1016/j.crohns.2009.11.010] [PMID: 21122516]
[7]
Drummond MF, McGuire A. Economic evaluation in health care: Merging theory with practice. New York: Oxford University Press 2001.
[8]
National institute for health and care excellence. NICE process and methods guides guide to the methods of technology Appraisal 2013. London 2013.
[9]
Hlavaty T, Persoons P, Vermeire S, et al. Evaluation of short-term responsiveness and cutoff values of inflammatory bowel disease questionnaire in Crohn’s disease. Inflamm Bowel Dis 2006; 12(3): 199-204.
[http://dx.doi.org/10.1097/01.MIB.0000217768.75519.32] [PMID: 16534421]
[10]
Meijs S, Gardenbroek TJ, Sprangers MA, et al. Health-related quality of life and disability in patients with ulcerative colitis and proctocolectomy with ileoanal pouch versus treatment with anti-TNF agents. J Crohn’s Colitis 2014; 8(7): 686-92.
[http://dx.doi.org/10.1016/j.crohns.2013.12.011] [PMID: 24418659]
[11]
Yu H, MacIsaac D, Wong JJ, et al. Market share and costs of biologic therapies for inflammatory bowel disease in the USA. Aliment Pharmacol Ther 2018; 47(3): 364-70.
[http://dx.doi.org/10.1111/apt.14430] [PMID: 29164650]
[12]
Rutgeerts P, Sandborn WJ, Feagan BG, et al. Infliximab for induction and maintenance therapy for ulcerative colitis. N Engl J Med 2005; 353(23): 2462-76.
[http://dx.doi.org/10.1056/NEJMoa050516] [PMID: 16339095]
[13]
Reinisch W, Sandborn WJ, Hommes DW, et al. Adalimumab for induction of clinical remission in moderately to severely active ulcerative colitis: Results of a randomised controlled trial. Gut 2011; 60(6): 780-7.
[http://dx.doi.org/10.1136/gut.2010.221127] [PMID: 21209123]
[14]
Zhang Y, Coello PA, Brożek J, et al. Using patient values and preferences to inform the importance of health outcomes in practice guideline development following the GRADE approach. Health Qual Life Outcomes 2017; 15(1): 52.
[http://dx.doi.org/10.1186/s12955-017-0621-0] [PMID: 28460638]
[15]
Postmus D, Mavris M, Hillege HL, et al. Incorporating patient preferences into drug development and regulatory decision making: Results from a quantitative pilot study with cancer patients, carers, and regulators. Clin Pharmacol Ther 2016; 99(5): 548-54.
[http://dx.doi.org/10.1002/cpt.332] [PMID: 26715217]
[16]
Bastemeijer CM, Voogt L, van Ewijk JP, Hazelzet JA. What do patient values and preferences mean? A taxonomy based on a systematic review of qualitative papers. Patient Educ Couns 2017; 100(5): 871-81.
[http://dx.doi.org/10.1016/j.pec.2016.12.019] [PMID: 28043713]
[17]
Dassopoulos T, Cohen RD, Scherl EJ, Schwartz RM, Kosinski L, Regueiro MD. Ulcerative colitis care pathway. Gastroenterology 2015; 149(1): 238-45.
[http://dx.doi.org/10.1053/j.gastro.2015.05.036] [PMID: 26025078]
[18]
Hagelund LM, Elkjær Stallknecht S, Jensen HH. Quality of life and patient preferences among Danish patients with ulcerative colitis - results from a survey study. Curr Med Res Opin 2020; 36(5): 771-9.
[http://dx.doi.org/10.1080/03007995.2020.1716704] [PMID: 31944145]
[19]
Rubin DT, Siegel CA, Kane SV, et al. Impact of ulcerative colitis from patients’ and physicians’ perspectives: Results from the UC: NORMAL survey. Inflamm Bowel Dis 2009; 15(4): 581-8.
[http://dx.doi.org/10.1002/ibd.20793] [PMID: 19067414]
[20]
Schreiber S, Panés J, Louis E, Holley D, Buch M, Paridaens K. Perception gaps between patients with ulcerative colitis and healthcare professionals: An online survey. BMC Gastroenterol 2012; 12(1): 108.
[http://dx.doi.org/10.1186/1471-230X-12-108] [PMID: 22894661]
[21]
Petrak F, Hardt J, Clement T, Börner N, Egle UT, Hoffmann SO. Impaired health-related quality of life in inflammatory bowel diseases: Psychosocial impact and coping styles in a national German sample. Scand J Gastroenterol 2001; 36(4): 375-82.
[http://dx.doi.org/10.1080/003655201300051171] [PMID: 11336162]
[22]
Levenstein S, Li Z, Almer S, et al. Cross-cultural variation in disease-related concerns among patients with inflammatory bowel disease. Am J Gastroenterol 2001; 96(6): 1822-30.
[http://dx.doi.org/10.1111/j.1572-0241.2001.03878.x] [PMID: 11419836]
[23]
Group TE. EuroQol--a new facility for the measurement of health-related quality of life. Health Policy 1990; 16(3): 199-208.
[http://dx.doi.org/10.1016/0168-8510(90)90421-9] [PMID: 10109801]
[24]
Goudarzi R, Sari AA, Zeraati H, Rashidian A, Mohammad K, Amini S. Valuation of quality weights for EuroQol 5-dimensional health states with the time trade-off method in the capital of Iran. Value Health Reg Issues 2019; 18: 170-5.
[http://dx.doi.org/10.1016/j.vhri.2019.01.007] [PMID: 31096140]
[25]
Zare F, Ameri H, Madadizadeh F, Aghaei MR. Validity and reliability of the EQ-5D-3L (a generic preference-based instrument used for calculating quality-adjusted life -years) for patients with type 2 diabetes in Iran. Diabetes Metab Syndr 2021; 15(1): 319-24.
[http://dx.doi.org/10.1016/j.dsx.2021.01.009] [PMID: 33486224]
[26]
Stark RG, Reitmeir P, Leidl R, König H-H. Validity, reliability, and responsiveness of the EQ-5D in inflammatory bowel disease in Germany. Inflamm Bowel Dis 2010; 16(1): 42-51.
[http://dx.doi.org/10.1002/ibd.20989] [PMID: 19475674]
[27]
Coteur G, Feagan B, Keininger DL, Kosinski M. Evaluation of the meaningfulness of health-related quality of life improvements as assessed by the SF-36 and the EQ-5D VAS in patients with active Crohn’s disease. Aliment Pharmacol Ther 2009; 29(9): 1032-41.
[http://dx.doi.org/10.1111/j.1365-2036.2009.03966.x] [PMID: 19222413]
[28]
Casellas F, Alcalá M-J, Prieto L, Miró J-RA, Malagelada J-R. Assessment of the influence of disease activity on the quality of life of patients with inflammatory bowel disease using a short questionnaire. Am J Gastroenterol 2004; 99(3): 457-61.
[http://dx.doi.org/10.1111/j.1572-0241.2004.04071.x] [PMID: 15056085]
[29]
Huamán JW, Casellas F, Borruel N, et al. Cutoff values of the Inflammatory Bowel Disease Questionnaire to predict a normal health related quality of life. J Crohn’s Colitis 2010; 4(6): 637-41.
[http://dx.doi.org/10.1016/j.crohns.2010.07.006] [PMID: 21122573]
[30]
Sherman M, Tsynman DN, Kim A, et al. Sustained improvement in health-related quality of life measures in patients with inflammatory bowel disease receiving prolonged anti-tumor necrosis factor therapy. J Dig Dis 2014; 15(4): 174-9.
[http://dx.doi.org/10.1111/1751-2980.12125] [PMID: 24373601]
[31]
Karami H, Shirvani Shiri M, Rezapour A, Sarvari Mehrabadi R, Afshari S. The association between diabetic complications and health-related quality of life in patients with type 2 diabetes: A cross-sectional study from Iran. Qual Life Res 2021; 30(7): 1963-74.
[http://dx.doi.org/10.1007/s11136-021-02792-7] [PMID: 33900519]
[32]
Javanbakht M, Keshtkaran A, Shabaninejad H, Karami H, Zakerinia M, Delavari S. Comparison of blood transfusion plus chelation therapy and bone marrow transplantation in patients with β-thalassemia: Application of SF-36, EQ-5D, and visual analogue scale measures. Int J Health Policy Manag 2015; 4(11): 733-40.
[http://dx.doi.org/10.15171/ijhpm.2015.113] [PMID: 26673333]
[33]
Moradi M, Rencz F, Brodszky V, Moradi A, Balogh O, Gulácsi L. Health status and quality of life in patients with psoriasis: An Iranian cross-sectional survey. Arch Iran Med 2015; 18(3)
[34]
Parra RS, Chebli JMF, Amarante HMBS, et al. Quality of life, work productivity impairment and healthcare resources in inflammatory bowel diseases in Brazil. World J Gastroenterol 2019; 25(38): 5862-82.
[http://dx.doi.org/10.3748/wjg.v25.i38.5862] [PMID: 31636478]
[35]
Nordin K, Påhlman L, Larsson K, Sundberg-Hjelm M, Lööf L. Health-related quality of life and psychological distress in a population-based sample of Swedish patients with inflammatory bowel disease. Scand J Gastroenterol 2002; 37(4): 450-7.
[http://dx.doi.org/10.1080/003655202317316097] [PMID: 11989837]
[36]
Bernklev T, Jahnsen J, Lygren I, Henriksen M, Vatn M, Moum B. Health-related quality of life in patients with inflammatory bowel disease measured with the short form-36: Psychometric assessments and a comparison with general population norms. Inflamm Bowel Dis 2005; 11(10): 909-18.
[http://dx.doi.org/10.1097/01.mib.0000179467.01748.99] [PMID: 16189421]
[37]
Schirbel A, Reichert A, Roll S, et al. Impact of pain on health-related quality of life in patients with inflammatory bowel disease. World J Gastroenterol 2010; 16(25): 3168-77.
[http://dx.doi.org/10.3748/wjg.v16.i25.3168] [PMID: 20593502]
[38]
Del Hoyo J, Nos P, Faubel R, et al. A web-based telemanagement system for improving disease activity and quality of life in patients with complex inflammatory bowel disease: Pilot randomized controlled trial. J Med Internet Res 2018; 20(11): e11602.
[http://dx.doi.org/10.2196/11602] [PMID: 30482739]
[39]
Sandborn WJ, Sakuraba A, Wang A, et al. Comparison of real-world outcomes of adalimumab and infliximab for patients with ulcerative colitis in the United States. Curr Med Res Opin 2016; 32(7): 1233-41.
[http://dx.doi.org/10.1185/03007995.2016.1168290] [PMID: 26986449]
[40]
Gies N, Kroeker KI, Wong K, Fedorak RN. Treatment of ulcerative colitis with adalimumab or infliximab: Long-term follow-up of a single-centre cohort. Aliment Pharmacol Ther 2010; 32(4): 522-8.
[http://dx.doi.org/10.1111/j.1365-2036.2010.04380.x] [PMID: 20500733]
[41]
Han M, Jung YS, Cheon JH, Park S. Comparison of real-world outcomes of infliximab versus adalimumab in biologic-naïve Korean patients with ulcerative colitis: A population-based study. Yonsei Med J 2020; 61(1): 48-55.
[http://dx.doi.org/10.3349/ymj.2020.61.1.48] [PMID: 31887799]
[42]
Lee YI, Park Y, Park SJ, Kim TI, Kim WH, Cheon JH. Comparison of long-term outcomes of infliximab versus adalimumab treatment in biologic-naïve patients with ulcerative colitis. Gut Liver 2021; 15(2): 232-42.
[http://dx.doi.org/10.5009/gnl19433] [PMID: 32616683]
[43]
Burisch J, Weimers P, Pedersen N, et al. Health-related quality of life improves during one year of medical and surgical treatment in a European population-based inception cohort of patients with inflammatory bowel disease--an ECCO-EpiCom study. J Crohn’s Colitis 2014; 8(9): 1030-42.
[http://dx.doi.org/10.1016/j.crohns.2014.01.028] [PMID: 24560877]
[44]
Severs M, Mangen MJJ, Fidder HH, et al. Clinical predictors of future nonadherence in inflammatory bowel disease. Inflamm Bowel Dis 2017; 23(9): 1568-76.
[http://dx.doi.org/10.1097/MIB.0000000000001201] [PMID: 28700534]
[45]
AlRuthia Y, Almadi M, Aljebreen A, et al. The cost-effectiveness of biologic versus non-biologic treatments and the health-related quality of life among a sample of patients with inflammatory bowel disease in a tertiary care center in Saudi Arabia. J Med Econ 2020; 23(10): 1102-10.
[http://dx.doi.org/10.1080/13696998.2020.1791889] [PMID: 32619388]
[46]
Casellas F, López-Vivancos J, Casado A, Malagelada J-R. Factors affecting health related quality of life of patients with inflammatory bowel disease. Qual Life Res 2002; 11(8): 775-81.
[http://dx.doi.org/10.1023/A:1020841601110] [PMID: 12482161]
[47]
Guthrie E, Jackson J, Shaffer J, Thompson D, Tomenson B, Creed F. Psychological disorder and severity of inflammatory bowel disease predict health-related quality of life in ulcerative colitis and Crohn’s disease. Am J Gastroenterol 2002; 97(8): 1994-9.
[http://dx.doi.org/10.1111/j.1572-0241.2002.05842.x] [PMID: 12190166]
[48]
Min Ho PY, Hu W, Lee YY, et al. Health-related quality of life of patients with inflammatory bowel disease in Singapore. Intest Res 2019; 17(1): 107-18.
[http://dx.doi.org/10.5217/ir.2018.00099] [PMID: 30419638]
[49]
Hjortswang H, Järnerot G, Curman B, et al. The influence of demographic and disease-related factors on health-related quality of life in patients with ulcerative colitis. Eur J Gastroenterol Hepatol 2003; 15(9): 1011-20.
[http://dx.doi.org/10.1097/00042737-200309000-00012] [PMID: 12923375]
[50]
Hjortswang H, Ström M, Almer S. Health-related quality of life in Swedish patients with ulcerative colitis. Am J Gastroenterol 1998; 93(11): 2203-11.
[http://dx.doi.org/10.1111/j.1572-0241.1998.00537.x] [PMID: 9820397]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version406msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[15:26:06] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[15:26:06] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[15:26:06] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[15:26:06] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[15:26:06] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (126ms)time
  • Application (280ms)time
  • 1 x Application (68.89%)
    280ms
    1 x Booting (31.11%)
    126ms
    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 duplicated167ms
    • 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 ('221938058','',1,1740497166,1740497166) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740497166
      2.46msalphaeurekaselec_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 ('221938058','/article/123993',1,1740497166,1740497166)
      8.57msalphaeurekaselec_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 >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) 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 >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) 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 >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) 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 >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) 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 >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) 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 >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 221938058 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221938058) limit 1
      25.19msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 221938058
      • 1: 221938058
      • 2: 221938058
      • 3: 221938058
      • 4: 221938058
      • 5: 221938058
      • 6: 221938058
      • 7: 221938058
      • 8: 221938058
      • 9: 221938058
      • 10: 221938058
      • 11: 221938058
      • 12: 221938058
      • 13: 221938058
      • 14: 221938058
      • 15: 221938058
      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=123993
      1.11msalphaeurekaselec_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` = 11 limit 1
      1.24msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 11
      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=11) and sj.journal_id!=11 group by `j`.`nid`) as `aggregate_table`
      1.64msalphaeurekaselec_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=11) and sj.journal_id!=11 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.34msalphaeurekaselec_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=11) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      3.1msalphaeurekaselec_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=11) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      2.68msalphaeurekaselec_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` = '123993'
      430μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 123993
      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` = '123993'
      3.61msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 123993
      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` = '123993' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.69msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 123993
      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
      370μ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
      730μ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 = 11 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      49.18msalphaeurekaselec_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 = 11 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      20.75msalphaeurekaselec_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 = 11 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      7.35msalphaeurekaselec_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` = 123993 limit 1
      3msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 123993
      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 = 123993 and content_type = 'article' order by status desc limit 1
      380μ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` = 205305 limit 1
      780μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 205305
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      320μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CDS' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      360μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CDS
      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 = '123993' 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) )
      510μ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 = '12402' 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) )
      430μ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 = '3372' 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) )
      580μ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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740497166 and j.to_date >= 1740497166 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3372) 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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740497166 and j.to_date >= 1740497166 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3372) 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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740497166 and j.to_date >= 1740497166 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3372)
      17.12msalphaeurekaselec_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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740497166 and j.to_date >= 1740497166 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12402) 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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740497166 and j.to_date >= 1740497166 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12402) 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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740497166 and j.to_date >= 1740497166 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12402)
      870μ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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740497166 and j.to_date >= 1740497166 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 123993) 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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740497166 and j.to_date >= 1740497166 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 123993) 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 <= 221938058 and j.to_ip >=221938058 )) and ((j.from_date <= 1740497166 and j.to_date >= 1740497166 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 123993)
      890μ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` < '484' and is_uploaded = 1 and issue_id = 12402 order by cast(first_page as SIGNED) desc limit 1
      1.23msalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 484
      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` > '495' and is_uploaded = 1 and issue_id = 12402 order by cast(first_page as SIGNED) asc limit 1
      850μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 495
      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'
      220μ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
      310μ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` = 123993 limit 1
      3.66msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 123993
      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` = 11 and `b`.`banner_from_date` <= 1740497166 and `b`.`banner_to_date` >= 1740497166 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.46msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 11
      • 3: 1740497166
      • 4: 1740497166
      • 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` = 11 and `b`.`banner_from_date` <= 1740497166 and `b`.`banner_to_date` >= 1740497166 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.6msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 11
      • 3: 1740497166
      • 4: 1740497166
      • 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='a6a5d3229900aafc7f168bfabf15dde2'
      250μ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
        XgWUoz6XEj5G8MLOfzCn26dNcPWrgIDggWjRO46M
        uc_cart_id
        a6a5d3229900aafc7f168bfabf15dde2
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/article/123993" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/123993
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:17 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6IjVGeXlqUFdLK3dPLzJDYkNtU3F0MkE9PSIsInZhbHVlIjoiV05pUGtSbGVOMm9peWdPM0RJcVNoOE5iZDlhVjNqK3llVG1JY21iMytZWT0iLCJtYWMiOiJkZWI0MWMyMmRkMTQ4YzBlNmY2MGM4ZmU3ODljMDI5YmVkNTU2Y2MwODBhYTdlNGMyMzg1MDdiOGY5YWJkZjgxIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IjVGeXlqUFdLK3dPLzJDYkNtU3F0MkE9PSIsInZhbHVlIjoiV05pUGtSbGVOMm9peWdPM0RJcVNoOE5iZDlhVjNqK3llVG1JY21iMytZWT0iLCJtYWMiOiJkZWI0MWMyMmRkMTQ4" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 25 Feb 2025 15:26:06 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IktMaW11WGg0WFV1SFl3VUpuUVNzQ0E9PSIsInZhbHVlIjoibTd5bXFtLzZsaFFQVTd6T29kb2ZkbTZDZVpjc2FVQXhKWU1LUklKM21Zc25EbE9FT1orQ1l2cjVMZTFuSkM1NnpVeUlieEhDQ2c0SGl4TFptK2xtRS9GM0tHd2tscHMyV3hoQy93VVNEUlRTK2pQa3AxNlJUNjVLc3hQMXduRjkiLCJtYWMiOiJlNDlhM2RmY2U4MDU2NGFjZjgzNjc3OTA0NmVmNmUwZGMzMWJkMzA1YWM4NTNkNjhiYTY2YTYxNWQ3YjdhY2QyIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 03:26:06 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IktMaW11WGg0WFV1SFl3VUpuUVNzQ0E9PSIsInZhbHVlIjoibTd5bXFtLzZsaFFQVTd6T29kb2ZkbTZDZVpjc2FVQXhKWU1LUklKM21Zc25EbE9FT1orQ1l2cjVMZTFuSkM1NnpVeUlie" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkphbVlWMlhMSDQ4M050c3E5SHp2YVE9PSIsInZhbHVlIjoib29sSGFQdzBueFM4OFg5WlZzMDdVSllRRTRSbGQ0c1RUNWFQV1dzTm1mN0NEc3JJYkRKQ0dOT1dRNUdTQm9CZXk1bHJ2Z2tmR3ViQU15VHpHQ1VjWjJPNCsrOE1rcUV4Ym5vSUUxbmtKVm95MkZ6Ym9KY29NQmdacCt2b2loL0wiLCJtYWMiOiJlZGVkNTM5YTBkNzRkMTllMWIxM2I4MmIwNGMwM2Q1YTJkMWI1ZjFkYzYyODg0NzVjYWJjMGNlMjU0YjExMDgyIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkphbVlWMlhMSDQ4M050c3E5SHp2YVE9PSIsInZhbHVlIjoib29sSGFQdzBueFM4OFg5WlZzMDdVSllRRTRSbGQ0c1RUNWFQV1dzTm1mN0NEc3JJYkRKQ0dOT1d" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IktMaW11WGg0WFV1SFl3VUpuUVNzQ0E9PSIsInZhbHVlIjoibTd5bXFtLzZsaFFQVTd6T29kb2ZkbTZDZVpjc2FVQXhKWU1LUklKM21Zc25EbE9FT1orQ1l2cjVMZTFuSkM1NnpVeUlieEhDQ2c0SGl4TFptK2xtRS9GM0tHd2tscHMyV3hoQy93VVNEUlRTK2pQa3AxNlJUNjVLc3hQMXduRjkiLCJtYWMiOiJlNDlhM2RmY2U4MDU2NGFjZjgzNjc3OTA0NmVmNmUwZGMzMWJkMzA1YWM4NTNkNjhiYTY2YTYxNWQ3YjdhY2QyIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 03:26:06 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IktMaW11WGg0WFV1SFl3VUpuUVNzQ0E9PSIsInZhbHVlIjoibTd5bXFtLzZsaFFQVTd6T29kb2ZkbTZDZVpjc2FVQXhKWU1LUklKM21Zc25EbE9FT1orQ1l2cjVMZTFuSkM1NnpVeUlie" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkphbVlWMlhMSDQ4M050c3E5SHp2YVE9PSIsInZhbHVlIjoib29sSGFQdzBueFM4OFg5WlZzMDdVSllRRTRSbGQ0c1RUNWFQV1dzTm1mN0NEc3JJYkRKQ0dOT1dRNUdTQm9CZXk1bHJ2Z2tmR3ViQU15VHpHQ1VjWjJPNCsrOE1rcUV4Ym5vSUUxbmtKVm95MkZ6Ym9KY29NQmdacCt2b2loL0wiLCJtYWMiOiJlZGVkNTM5YTBkNzRkMTllMWIxM2I4MmIwNGMwM2Q1YTJkMWI1ZjFkYzYyODg0NzVjYWJjMGNlMjU0YjExMDgyIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkphbVlWMlhMSDQ4M050c3E5SHp2YVE9PSIsInZhbHVlIjoib29sSGFQdzBueFM4OFg5WlZzMDdVSllRRTRSbGQ0c1RUNWFQV1dzTm1mN0NEc3JJYkRKQ0dOT1d" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "XgWUoz6XEj5G8MLOfzCn26dNcPWrgIDggWjRO46M" "uc_cart_id" => "a6a5d3229900aafc7f168bfabf15dde2" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/article/123993" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 15:26:06GET/article/123993514361