Generic placeholder image

Current Medical Imaging

Editor-in-Chief

ISSN (Print): 1573-4056
ISSN (Online): 1875-6603

Research Article

Comparison of Imaging Modalities in the Diagnosis and Tumor Staging of Colorectal Adenocarcinoma

Author(s): Serdar Serinsöz* and Remzi Aktürk

Volume 19, Issue 6, 2023

Published on: 27 December, 2022

Article ID: e091222211823 Pages: 11

DOI: 10.2174/1573405619666221209114218

Price: $65

Abstract

Background: Colorectal cancer is a malignancy that affects the gastrointestinal tract. Clinical diagnosis has routinely been done with colonoscopy in conjunction with digital rectal and histological examinations.

Objective: We show that CT, MRI, and MRI-DWI are all effective in T-staging colorectal adenocarcinoma when compared to pathology examination. However, differences in the detection and diagnostic agreement rates between the imaging modalities for the specific T-stages were observed.

Methods: Fifty-six patients diagnosed with colorectal adenocarcinoma and underwent contrastenhanced abdominal CT, non-contrast MRI, or MRI-DWI between January 2014 and March 2020 were retrospectively examined and compared to a biopsy or postoperative pathological T-stage.

Results: The total diagnostic agreement rate for CT, MRI, and MRI-DWI were 58.93%, 76.79%, and 85.71%, respectively. T-staging was statistically and significantly different across all four stages analyzed for all imaging modalities. The T1-stage for MRI and MRI-DWI compared to pathology rates were statistically significant, whereas MRI-DWI and CT both demonstrated statistical significance for T3 and T2 stage comparison, respectively. Furthermore, a statistical and significant difference between the total stage comparison of MRI, MRI-DWI, and CT compared individually to pathology was also observed. All imaging modalities were able to statistically and significantly identify tumors based on tumor size according to the ROC analysis.

Conclusion: These data suggest that CT, MRI, and MRI-DWI can identify and aid visually in the diagnosis of adenocarcinoma colorectal cancer. MRI-DWI is more specific and sensitive in the diagnosis and staging of colorectal tumors.

Graphical Abstract

[1]
Brown G, Davies S, Williams GT, et al. Effectiveness of preoperative staging in rectal cancer: Digital rectal examination, endoluminal ultrasound or magnetic resonance imaging? Br J Cancer 2004; 91(1): 23-9.
[http://dx.doi.org/10.1038/sj.bjc.6601871] [PMID: 15188013]
[2]
Świderska M, Choromańska B, Dąbrowska E, et al. Review The diagnostics of colorectal cancer. Contemp Oncol (Pozn) 2014; 1(1): 1-6.
[http://dx.doi.org/10.5114/wo.2013.39995] [PMID: 24876814]
[3]
Horvat N, Carlos Tavares Rocha C, Clemente Oliveira B, Petkovska I, Gollub MJ. MRI of rectal cancer: Tumor staging, imaging techniques, and management. Radiographics 2019; 39(2): 367-87.
[http://dx.doi.org/10.1148/rg.2019180114] [PMID: 30768361]
[4]
Heo SH, Kim JW, Shin SS, Jeong YY, Kang H-K. Multimodal imaging evaluation in staging of rectal cancer. World J Gastroenterol 2014; 20(15): 4244-55.
[http://dx.doi.org/10.3748/wjg.v20.i15.4244] [PMID: 24764662]
[5]
Fass L. Imaging and cancer: A review. Mol Oncol 2008; 2(2): 115-52.
[http://dx.doi.org/10.1016/j.molonc.2008.04.001] [PMID: 19383333]
[6]
Joo I, Lee JM, Yoon JH. Imaging Diagnosis of Intrahepatic and Perihilar Cholangiocarcinoma: Recent Advances and Challenges. Radiology 2018; 288(1): 7-13.
[http://dx.doi.org/10.1148/radiol.2018171187] [PMID: 29869969]
[7]
Cleary JOSH, Guimarães AR. Magnetic Resonance Imaging. In: McManus LM, Mitchell RN, Eds. Pathobiology of Human Disease. San Diego: Academic Press 2014; pp. 3987-.
[http://dx.doi.org/10.1016/B978-0-12-386456-7.07609-7]
[8]
Ladd ME, Bachert P, Meyerspeer M, et al. Pros and cons of ultra-high-field MRI/MRS for human application. Prog Nucl Magn Reson Spectrosc 2018; 109: 1-50.
[http://dx.doi.org/10.1016/j.pnmrs.2018.06.001] [PMID: 30527132]
[9]
Berrington de Gonzalez A, Kim KP, Yee J. CT colonography: Perforation rates and potential radiation risks. Gastrointest Endosc Clin N Am 2010; 20(2): 279-91.
[http://dx.doi.org/10.1016/j.giec.2010.02.003] [PMID: 20451817]
[10]
Ridereau-Zins C, Pilleul F, Gandon Y, Laurent V. CT colonography: Why? When? How? Diagn Interv Imaging 2012; 93(1): 2-9.
[http://dx.doi.org/10.1016/j.diii.2011.10.003] [PMID: 22277705]
[11]
Song I, Kim SH, Lee SJ, Choi JY, Kim MJ, Rhim H. Value of diffusion-weighted imaging in the detection of viable tumour after neoadjuvant chemoradiation therapy in patients with locally advanced rectal cancer: Comparison with T2 weighted and PET/CT imaging. Br J Radiol 2012; 85(1013): 577-86.
[http://dx.doi.org/10.1259/bjr/68424021] [PMID: 21343320]
[12]
Urushihata T, Takuwa H, Takahashi M, et al. Exploring cell membrane water exchange in aquaporin-4-deficient ischemic mouse brain using diffusion-weighted MRI. Eur Radiol Exp 2021; 5(1): 44.
[http://dx.doi.org/10.1186/s41747-021-00244-y] [PMID: 34617156]
[13]
Fink KRT, Fink JR. 4 - Principles of Modern Neuroimaging. In Principles of Neurological Surgery (Fourth Edition), Ellenbogen RG; Sekhar LN; Kitchen ND; da Silva HB, Eds. Elsevier: Philadelphia 2018; pp 62-86.e2.
[14]
Messina C, Bignone R, Bruno A, et al. Diffusion-Weighted Imaging in Oncology: An Update. Cancers (Basel) 2020; 12(6): 1493.
[http://dx.doi.org/10.3390/cancers12061493] [PMID: 32521645]
[15]
Pereira NP, Curi C, Osório CABT, et al. Diffusion-weighted magnetic resonance imaging of patients with breast cancer following neoadjuvant chemotherapy provides early prediction of pathological response - a prospective study. Sci Rep 2019; 9(1): 16372.
[http://dx.doi.org/10.1038/s41598-019-52785-3] [PMID: 31705004]
[16]
Jang KM, Kim SH, Hwang J, et al. Differentiation of malignant from benign focal splenic lesions: Added value of diffusion-weighted MRI. AJR Am J Roentgenol 2014; 203(4): 803-12.
[http://dx.doi.org/10.2214/AJR.13.11914] [PMID: 25247945]
[17]
Beltran LS, Samim M, Gyftopoulos S, Bruno MT, Petchprapa CN. Does the addition of DWI to fluid-sensitive conventional MRI of the sacroiliac joints improve the diagnosis of sacroiliitis? AJR Am J Roentgenol 2018; 210(6): 1309-16.
[http://dx.doi.org/10.2214/AJR.17.18636] [PMID: 29629794]
[18]
Raman SP, Chen Y, Fishman EK. Evolution of imaging in rectal cancer: Multimodality imaging with MDCT, MRI, and PET. J Gastrointest Oncol 2015; 6(2): 172-84.
[PMID: 25830037]
[19]
Gunderson LL, Jessup JM, Sargent DJ, Greene FL, Stewart AK. Revised TN categorization for colon cancer based on national survival outcomes data. J Clin Oncol 2010; 28(2): 264-71.
[http://dx.doi.org/10.1200/JCO.2009.24.0952] [PMID: 19949014]
[20]
Monguzzi L, Ippolito D, Bernasconi DP, Trattenero C, Galimberti S, Sironi S. Locally advanced rectal cancer: Value of ADC mapping in prediction of tumor response to radiochemotherapy. Eur J Radiol 2013; 82(2): 234-40.
[http://dx.doi.org/10.1016/j.ejrad.2012.09.027] [PMID: 23122748]
[21]
Benson AB, Venook AP, Al-Hawary MM, et al. Colon Cancer, Version 2.2021, NCCN Clinical Practice Guidelines in Oncology. J Natl Compr Canc Netw 2021; 19(3): 329-59.
[http://dx.doi.org/10.6004/jnccn.2021.0012] [PMID: 33724754]
[22]
Tong GJ, Zhang GY, Liu J, et al. Comparison of the eighth version of the American Joint Committee on Cancer manual to the seventh version for colorectal cancer: A retrospective review of our data. World J Clin Oncol 2018; 9(7): 148-61.
[http://dx.doi.org/10.5306/wjco.v9.i7.148] [PMID: 30425940]
[23]
Sloothaak DAM, Sahami S, van der Zaag-Loonen HJ, et al. The prognostic value of micrometastases and isolated tumour cells in histologically negative lymph nodes of patients with colorectal cancer: A systematic review and meta-analysis. Eur J Surg Oncol 2014; 40(3): 263-9.
[http://dx.doi.org/10.1016/j.ejso.2013.12.002] [PMID: 24368050]
[24]
Yi X, Pei Q, Zhang Y, et al. MRI-Based Radiomics Predicts Tumor Response to Neoadjuvant Chemoradiotherapy in Locally Advanced Rectal Cancer. Front Oncol 2019; 9: 552-2.
[http://dx.doi.org/10.3389/fonc.2019.00552] [PMID: 31293979]
[25]
Wang X, Yuan M, Mi H, et al. The feasibility of differentiating colorectal cancer from normal and inflammatory thickening colon wall using CT texture analysis. Sci Rep 2020; 10(1): 6346.
[http://dx.doi.org/10.1038/s41598-020-62973-1] [PMID: 32286352]
[26]
Kelley SR, Nelson H. 75 - Cancer of the Rectum. In Abeloff's Clinical Oncology (Sixth Edition), Niederhuber JE; Armitage JO; Kastan MB; Doroshow JH; Tepper JE, Eds. Elsevier: Philadelphia 2020; pp 1281-1299.e7.
[27]
Kijima S, Sasaki T, Nagata K, Utano K, Lefor AT, Sugimoto H. Preoperative evaluation of colorectal cancer using CT colonography, MRI, and PET/CT. World J Gastroenterol 2014; 20(45): 16964-75.
[http://dx.doi.org/10.3748/wjg.v20.i45.16964] [PMID: 25493009]
[28]
Kekelidze M, D’Errico L, Pansini M, Tyndall A, Hohmann J. Colorectal cancer: Current imaging methods and future perspectives for the diagnosis, staging and therapeutic response evaluation. World J Gastroenterol 2013; 19(46): 8502-14.
[http://dx.doi.org/10.3748/wjg.v19.i46.8502] [PMID: 24379567]
[29]
Yee J, Weinstein S, Morgan T, Alore P, Aslam R. Advances in CT Colonography for Colorectal Cancer Screening and Diagnosis. J Cancer 2013; 4(3): 200-9.
[http://dx.doi.org/10.7150/jca.5858] [PMID: 23459511]
[30]
Mainenti PP, Cirillo LC, Camera L, et al. Accuracy of single phase contrast enhanced multidetector CT colonography in the preoperative staging of colo-rectal cancer. Eur J Radiol 2006; 60(3): 453-9.
[http://dx.doi.org/10.1016/j.ejrad.2006.08.001] [PMID: 16965883]
[31]
Pickhardt PJ, Choi JR, Hwang I, et al. Computed tomographic virtual colonoscopy to screen for colorectal neoplasia in asymptomatic adults. N Engl J Med 2003; 349(23): 2191-200.
[http://dx.doi.org/10.1056/NEJMoa031618] [PMID: 14657426]
[32]
Flor N, Mezzanzanica M, Rigamonti P, et al. Contrast-enhanced computed tomography colonography in preoperative distinction between T1-T2 and T3-T4 staging of colon cancer. Acad Radiol 2013; 20(5): 590-5.
[http://dx.doi.org/10.1016/j.acra.2013.01.008] [PMID: 23477825]
[33]
Filippone A, Ambrosini R, Fuschi M, Marinelli T, Genovesi D, Bonomo L. Preoperative T and N staging of colorectal cancer: Accuracy of contrast-enhanced multi-detector row CT colonography--initial experience. Radiology 2004; 231(1): 83-90.
[http://dx.doi.org/10.1148/radiol.2311021152] [PMID: 14990815]
[34]
Saklani AP, Bae SU, Clayton A, Kim NK. Magnetic resonance imaging in rectal cancer: A surgeon’s perspective. World J Gastroenterol 2014; 20(8): 2030-41.
[http://dx.doi.org/10.3748/wjg.v20.i8.2030] [PMID: 24616572]
[35]
Santiago I, Figueiredo N, Parés O, Matos C. MRI of rectal cancer—relevant anatomy and staging key points. Insights Imaging 2020; 11(1): 100.
[http://dx.doi.org/10.1186/s13244-020-00890-7] [PMID: 32880782]
[36]
Kim H, Kim JH, Lim JS, et al. MRI findings of rectal submucosal tumors. Korean J Radiol 2011; 12(4): 487-98.
[http://dx.doi.org/10.3348/kjr.2011.12.4.487] [PMID: 21852910]
[37]
Shenoy-Bhangle A, Baliyan V, Kordbacheh H, Guimaraes AR, Kambadakone A. Diffusion weighted magnetic resonance imaging of liver: Principles, clinical applications and recent updates. World J Hepatol 2017; 9(26): 1081-91.
[http://dx.doi.org/10.4254/wjh.v9.i26.1081] [PMID: 28989564]
[38]
Padhani AR, Liu G, Mu-Koh D, et al. Diffusion-weighted magnetic resonance imaging as a cancer biomarker: Consensus and recommendations. Neoplasia 2009; 11(2): 102-25.
[http://dx.doi.org/10.1593/neo.81328] [PMID: 19186405]
[39]
Partridge SC, Nissan N, Rahbar H, Kitsch AE, Sigmund EE. Diffusion-weighted breast MRI: Clinical applications and emerging techniques. J Magn Reson Imaging 2017; 45(2): 337-55.
[http://dx.doi.org/10.1002/jmri.25479] [PMID: 27690173]
[40]
Schurink NW, Lambregts DMJ, Beets-Tan RGH. Diffusion-weighted imaging in rectal cancer: Current applications and future perspectives. Br J Radiol 2019; 92(1096)20180655
[http://dx.doi.org/10.1259/bjr.20180655] [PMID: 30433814]
[41]
Ichikawa T, Erturk SM, Motosugi U, et al. High-B-value diffusion-weighted MRI in colorectal cancer. AJR Am J Roentgenol 2006; 187(1): 181-4.
[http://dx.doi.org/10.2214/AJR.05.1005] [PMID: 16794174]
[42]
Sabry MS, Rady AEE, Niazi GEM, Ali SA. Role of diffusion-weighted MRI in diagnosis and post therapeutic follow-up of colorectal cancer. Egypt J Radiol Nucl Med 2021; 52(1): 180.
[http://dx.doi.org/10.1186/s43055-021-00561-7]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version343msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[08:41:43] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[08:41:44] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[08:41:44] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[08:41:44] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (115ms)time
  • Application (227ms)time
  • 1 x Application (66.32%)
    227ms
    1 x Booting (33.67%)
    115ms
    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 duplicated128ms
    • 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 ('51359025','',1,1740472903,1740472903) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740472903
      1.2msalphaeurekaselec_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 ('51359025','/article/128178',1,1740472903,1740472903)
      250μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) 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 >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) 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 >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) 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 >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) 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 >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) 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 >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51359025 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51359025) limit 1
      17.7msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51359025
      • 1: 51359025
      • 2: 51359025
      • 3: 51359025
      • 4: 51359025
      • 5: 51359025
      • 6: 51359025
      • 7: 51359025
      • 8: 51359025
      • 9: 51359025
      • 10: 51359025
      • 11: 51359025
      • 12: 51359025
      • 13: 51359025
      • 14: 51359025
      • 15: 51359025
      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=128178
      1.01msalphaeurekaselec_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` = 33 limit 1
      1.16msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 33
      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=33) and sj.journal_id!=33 group by `j`.`nid`) as `aggregate_table`
      770μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=33) and sj.journal_id!=33 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      600μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=33) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      930μsalphaeurekaselec_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=33) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      800μsalphaeurekaselec_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` = '128178'
      260μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 128178
      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` = '128178'
      3.07msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 128178
      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` = '128178' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.04msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 128178
      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
      290μ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
      650μ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 = 33 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      45.94msalphaeurekaselec_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 = 33 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      13.8msalphaeurekaselec_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 = 33 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      13msalphaeurekaselec_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` = 128178 limit 1
      1.06msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 128178
      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 = 128178 and content_type = 'article' order by status desc limit 1
      360μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 211823 limit 1
      270μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 211823
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      330μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CMIM' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      450μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CMIM
      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 = '128178' 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) )
      530μ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 = '12307' 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) )
      450μ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 = '3365' 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) )
      470μ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 <= 51359025 and j.to_ip >=51359025 )) and ((j.from_date <= 1740472904 and j.to_date >= 1740472904 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3365) 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 <= 51359025 and j.to_ip >=51359025 )) and ((j.from_date <= 1740472904 and j.to_date >= 1740472904 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3365) 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 <= 51359025 and j.to_ip >=51359025 )) and ((j.from_date <= 1740472904 and j.to_date >= 1740472904 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3365)
      8.59msalphaeurekaselec_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 <= 51359025 and j.to_ip >=51359025 )) and ((j.from_date <= 1740472904 and j.to_date >= 1740472904 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12307) 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 <= 51359025 and j.to_ip >=51359025 )) and ((j.from_date <= 1740472904 and j.to_date >= 1740472904 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12307) 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 <= 51359025 and j.to_ip >=51359025 )) and ((j.from_date <= 1740472904 and j.to_date >= 1740472904 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12307)
      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 <= 51359025 and j.to_ip >=51359025 )) and ((j.from_date <= 1740472904 and j.to_date >= 1740472904 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 128178) 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 <= 51359025 and j.to_ip >=51359025 )) and ((j.from_date <= 1740472904 and j.to_date >= 1740472904 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 128178) 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 <= 51359025 and j.to_ip >=51359025 )) and ((j.from_date <= 1740472904 and j.to_date >= 1740472904 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 128178)
      860μ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` < '612' and is_uploaded = 1 and issue_id = 12307 order by cast(first_page as SIGNED) desc limit 1
      740μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 612
      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` > '622' and is_uploaded = 1 and issue_id = 12307 order by cast(first_page as SIGNED) asc limit 1
      740μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 622
      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'
      250μ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` = 128178 limit 1
      4.37msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 128178
      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` = 33 and `b`.`banner_from_date` <= 1740472904 and `b`.`banner_to_date` >= 1740472904 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.65msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 33
      • 3: 1740472904
      • 4: 1740472904
      • 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` = 33 and `b`.`banner_from_date` <= 1740472904 and `b`.`banner_to_date` >= 1740472904 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.72msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 33
      • 3: 1740472904
      • 4: 1740472904
      • 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='7be89a57c4fd264a6e134972aa233761'
      290μ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
        ujyw7OuXr3vvQeYEp4GNwPraEzwLmeXt9UaRcTn9
        uc_cart_id
        7be89a57c4fd264a6e134972aa233761
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/article/128178" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/128178
        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=eyJpdiI6InVrQVFGOVR5WWJjSGZYTXhVbTkvd0E9PSIsInZhbHVlIjoiNEx0UFpjVWtIV01BZWFOVEpyN1NGN1pXSWE1M0QwbEU4QUd4QnhLNjE5Zz0iLCJtYWMiOiI4NDcwODY0NTQyOTkzYzdjNzVjYTAxYmYzNzdhYjc1NDk2YTVjZWRmMzEzMjVlMzI5ZGYyMzZmMDhmNDdjYmM1IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6InVrQVFGOVR5WWJjSGZYTXhVbTkvd0E9PSIsInZhbHVlIjoiNEx0UFpjVWtIV01BZWFOVEpyN1NGN1pXSWE1M0QwbEU4QUd4QnhLNjE5Zz0iLCJtYWMiOiI4NDcwODY0NTQyOTkz" ] "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 08:41:44 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlBZUHlYTGxmUTFaSTVoMCtTVUl4M1E9PSIsInZhbHVlIjoiNUo5VE9UYkxnTmhNaWVkRzNDL2VLNWtEUE1KVzFMUjdaUi9lUkRQeGZPaFJBRE8zRHdHSkJPQkNxMTY1R0h6QmdQTEc2TWIxRU5iOUM3TFZvbUpVYllvQ3hkVTdKMDlXem9uWEd4ZXRXZWY0TDNBR2thVDdONU1rd0FnMnRjTG4iLCJtYWMiOiJlOGEzZTRjM2I4MzA4ZDJlODhkNWU3YTAzNzMwNTJhOTFiNjEzZWQ1Y2IwZTQ2YmJkMzU0ZjlkZDI0NTU4MGY2IiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 20:41:44 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlBZUHlYTGxmUTFaSTVoMCtTVUl4M1E9PSIsInZhbHVlIjoiNUo5VE9UYkxnTmhNaWVkRzNDL2VLNWtEUE1KVzFMUjdaUi9lUkRQeGZPaFJBRE8zRHdHSkJPQkNxMTY1R0h6QmdQTEc2T" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ik1lbkl6aFBMRWMrR3hwa1NUTmt3UlE9PSIsInZhbHVlIjoicFpSeWtNMW9WWWFkcnpzRVZORFd5NUdZUkVtT0ZRUG4yNUNCdWdtZDhqQ3JnQWc4NlhSTy95ZXJVWHJPOW9YWFNaTjQ0aXJNaGV1VGFsSDNkaXphbkhTclR0ekE3cmtWMHpVOWFna1RmZk9LZVBLTlN2OUdoeFpiOTkxQnJWRU8iLCJtYWMiOiIwNzdlYWY5YzY0NDQ5NDBjMzcyNTBiODBjZjkyNDg4ZDZiOGVjY2VmZWZjNDM4ODc1ODJmYTI0ZDZjOTVlOTJjIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ik1lbkl6aFBMRWMrR3hwa1NUTmt3UlE9PSIsInZhbHVlIjoicFpSeWtNMW9WWWFkcnpzRVZORFd5NUdZUkVtT0ZRUG4yNUNCdWdtZDhqQ3JnQWc4NlhSTy95ZXJ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlBZUHlYTGxmUTFaSTVoMCtTVUl4M1E9PSIsInZhbHVlIjoiNUo5VE9UYkxnTmhNaWVkRzNDL2VLNWtEUE1KVzFMUjdaUi9lUkRQeGZPaFJBRE8zRHdHSkJPQkNxMTY1R0h6QmdQTEc2TWIxRU5iOUM3TFZvbUpVYllvQ3hkVTdKMDlXem9uWEd4ZXRXZWY0TDNBR2thVDdONU1rd0FnMnRjTG4iLCJtYWMiOiJlOGEzZTRjM2I4MzA4ZDJlODhkNWU3YTAzNzMwNTJhOTFiNjEzZWQ1Y2IwZTQ2YmJkMzU0ZjlkZDI0NTU4MGY2IiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 20:41:44 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlBZUHlYTGxmUTFaSTVoMCtTVUl4M1E9PSIsInZhbHVlIjoiNUo5VE9UYkxnTmhNaWVkRzNDL2VLNWtEUE1KVzFMUjdaUi9lUkRQeGZPaFJBRE8zRHdHSkJPQkNxMTY1R0h6QmdQTEc2T" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ik1lbkl6aFBMRWMrR3hwa1NUTmt3UlE9PSIsInZhbHVlIjoicFpSeWtNMW9WWWFkcnpzRVZORFd5NUdZUkVtT0ZRUG4yNUNCdWdtZDhqQ3JnQWc4NlhSTy95ZXJVWHJPOW9YWFNaTjQ0aXJNaGV1VGFsSDNkaXphbkhTclR0ekE3cmtWMHpVOWFna1RmZk9LZVBLTlN2OUdoeFpiOTkxQnJWRU8iLCJtYWMiOiIwNzdlYWY5YzY0NDQ5NDBjMzcyNTBiODBjZjkyNDg4ZDZiOGVjY2VmZWZjNDM4ODc1ODJmYTI0ZDZjOTVlOTJjIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ik1lbkl6aFBMRWMrR3hwa1NUTmt3UlE9PSIsInZhbHVlIjoicFpSeWtNMW9WWWFkcnpzRVZORFd5NUdZUkVtT0ZRUG4yNUNCdWdtZDhqQ3JnQWc4NlhSTy95ZXJ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "ujyw7OuXr3vvQeYEp4GNwPraEzwLmeXt9UaRcTn9" "uc_cart_id" => "7be89a57c4fd264a6e134972aa233761" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/article/128178" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 08:41:44GET/article/128178414361