Generic placeholder image

Current Women`s Health Reviews

Editor-in-Chief

ISSN (Print): 1573-4048
ISSN (Online): 1875-6581

Review Article

Utilization of Tumor Markers in Adnexal Masses: A Review of Current Literature

Author(s): Emily Penick* and Victoria Olowu

Volume 15, Issue 1, 2019

Page: [3 - 11] Pages: 9

DOI: 10.2174/1573404813666171101163653

Price: $65

Abstract

Background: Adnexal masses are a common presenting concern among women of all age groups. While the majority of adnexal masses are benign, the differentiation of a mass and diagnosis of malignancy can present a dilemma. The use of laboratory studies and tumor markers, which can be obtained through minimally invasive means, can aid in the diagnosis of a mass or the decision to refer a patient to a specialist.

Objective: This review provides information on current available tumor markers, their use in the diagnosis of various adnexal masses and tumors, a review on current biomarker panels, and the role these results play in treating pre- and postmenopausal patients with adnexal masses.

Results: Many tumor markers exist; however, the majority of markers are not specific to one tumor or cancer. Many benign conditions also cause elevations in tumor markers, which can make distinguishing benign and malignant conditions difficult. In recent years, the development of biomarker panels has served to improve diagnostic accuracy when dealing with an adnexal mass and algorithms have been developed to aid with triaging a patient to continued observation versus referral to a specialist.

Conclusion: It is important to merge clinical and laboratory data together when diagnosing and managing any patient with an adnexal mass given the many benign and malignant conditions that can cause elevations in tumor markers.

Keywords: Adnexal masses, tumor markers, adnexal masses diagnosis, malignancy, postmenopausal patients, cancer antigen.

Graphical Abstract

[1]
American College of Obstetricians and Gynecologists’ Committee on Practice Bulletins—Gynecology. Evaluation and management of adnexal masses. Practice Bulletin No. 174. Obstet Gynecol 2016; 128: e210-26.
[2]
Schorge JO, Modesitt SC, Coleman RL, et al. SGO White Paper on ovarian cancer: etiology, screening and surveillance. Gynecol Oncol 2010; 119(1): 7-17.
[3]
"Tumor Markers." National Cancer Institute; 2015. Available at. https://www.cancer.gov/about-cancer/diagnosis-staging/diagnosis/ tumor-markers-fact-sheet (Accessed on: November 14, 2016).
[4]
Soletormos G, Duffy MJ, Othman Abu Hassan S, et al. Clinical use of cancer biomarkers in epithelial ovarian cancer: Updated guidelines from the European group on tumor markers. Int J Gynecol Cancer 2016; 26(1): 43-51.
[5]
Sharma S. Tumor markers in clinical practice: General principles and guidelines. Indian J Med Paediatr Oncol 2009; 30(1): 1-8.
[6]
Johnson CC, Kessel B, Riley TL, et al. The epidemiology of CA-125 in women without evidence of ovarian cancer in the Prostate, Lung, Colorectal and Ovarian Cancer (PLCO) screening trial. Gynecol Oncol 2008; 110(3): 383-9.
[7]
Bast RC Jr, Klug TL, St John E, et al. A radioimmunoassay using a monoclonal antibody to monitor the course of epithelial ovarian cancer. N Engl J Med 1983; 309(15): 883-7.
[8]
Kitawaki J, Ishihara H, Koshiba H, et al. Usefulness and limits of CA-125 in diagnosis of endometriosis without associated ovarian endometriomas. Hum Reprod 2005; 20(7): 1999-2003.
[9]
Graham L. ACOG releases guidelines on management of adnexal masses. Am Fam Physician 2008; 77(9): 1320-3.
[10]
Karlsen MA, Sandhu N, Hogdall C, et al. Evaluation of HE4, CA125, risk of ovarian malignancy algorithm (ROMA) and risk of malignancy index (RMI) as diagnostic tools of epithelial ovarian cancer in patients with a pelvic mass. Gynecol Oncol 2012; 127(2): 379-83.
[11]
van den Akker PA, Aalders AL, Snijders MP, et al. Evaluation of the Risk of Malignancy Index in daily clinical management of adnexal masses. Gynecol Oncol 2010; 116(3): 384-8.
[12]
Hakansson F, Hogdall EV, Nedergaard L, et al. Risk of malignancy index used as a diagnostic tool in a tertiary centre for patients with a pelvic mass. Acta Obstet Gynecol Scand 2012; 91(4): 496-502.
[13]
Perkins GL, Slater E, Sanders G, Prichard J. Serum tumor markers. Am Fam Physician 2003; 68(6): 1075-82.
[14]
Liu Z, Zhang Y, Niu Y, et al. A systematic review and meta-analysis of diagnostic and prognostic serum biomarkers of colorectal cancer. PLoS One 2014; 9(8): e103910.
[15]
Hogdall EV, Christensen L, Kjaer SK, et al. Protein expression levels of carcinoembryonic antigen (CEA) in Danish ovarian cancer patients: from the Danish 'MALOVA’ovarian cancer study. Pathology 2008; 40(5): 487-92.
[16]
Solvsten Sorenson S, Jul Mosgaard B. Combination of cancer antigen 125 and carcinoembryonic antigen can improve ovarian cancer diagnosis. Dan Med Bull 2011; 58(11): A4331.
[17]
Pectasides D, Pectasides E, Kassanos D. Germ cell tumors of the ovary. Cancer Treat Rev 2008; 34(5): 427-41.
[18]
Fowler JE Jr, Platoff GE, Kubrock CA, Stutzman RE. Commercial radioimmunoassay for beta subunit of human chorionic gonadotropin: falsely positive determinations due to elevated serum luteinizing hormone. Cancer 1982; 49(1): 136-9.
[19]
Kelleher CM, Goldstein AM. Adnexal masses in children and adolescents. Clin Obstet Gynecol 2015; 58(1): 76-92.
[20]
Martin LJ, Zieve D. Lactate dehydrogenase test NIH, US National Library of Medicine, Medline Plus A.D.A.M. Editorial team; 2016.
[21]
de Kretser DM, Hedger MP, Loveland KL, Phillips DJ. Inhibins, activins and follistatin in reproduction. Hum Reprod Update 2002; 8(6): 529-41.
[22]
Robertson DM, Pruysers E, Jobling T. Inhibin as a diagnostic marker for ovarian cancer. Cancer Lett 2007; 249(1): 14-7.
[23]
Robertson DM, Pruysers E, Burger HG, Jobling T, McNeilage J, Healy D. Inhibins and ovarian cancer. Mol Cell Endocrinol 2004; 225(1-2): 65-71.
[24]
Mom CH, Engelen MJ, Willemse PH, et al. Granulosa cell tumors of the ovary: the clinical value of serum inhibin A and B levels in a large single center cohort. Gynecol Oncol 2007; 105(2): 365-72.
[25]
Robertson DM, Stephenson T, Pruysers E, et al. Characterization of inhibin forms and their measurement by an inhibin alpha-subunit ELISA in serum from postmenopausal women with ovarian cancer. J Clin Endocrinol Metab 2002; 87(2): 816-24.
[26]
Sehested A, Juul AA, Andersson AM, et al. Serum inhibin A and inhibin B in healthy prepubertal, pubertal, and adolescent girls and adult women: relation to age, stage of puberty, menstrual cycle, follicle-stimulating hormone, luteinizing hormone, and estradiol levels. J Clin Endocrinol Metab 2000; 85(4): 1634-40.
[27]
Lappohn RE, Burger HG, Bouma J, Bangah M, Krans M. Inhibin as a marker for granulosa cell tumor. Acta Obstet Gynecol Scand Suppl 1992; 155: 61-5.
[28]
Schumer ST. Granulosa cell tumor of the ovary. J Clin Oncol 2003; 21(6): 1180-9.
[29]
Sofronescu A, Staros E. "Estradiol" In Drugs and Diseases Available at: https://emedicine.medscape.com/article/2089003-overview (Accessed on: March 1, 2017).
[30]
Scharl A, Crombach G, Vierbuchen M, Gohring U, Gottert T, Holt JA. Antigen CA 19-9: presence in mucosa of nondiseased mullerian duct derivatives and marker for differentiation in their carcinomas. Obstet Gynecol 1991; 77(4): 580-5.
[31]
Santotoribio JD, Garcia-de la Torre A, Canavate-Solano C, Arce-Matute F, Sanchez-del Pino MJ, Perez-Ramos S. Cancer antigens 19.9 and 125 as tumor markers in patients with mucinous ovarian tumors. Eur J Gynaecol Oncol 2016; 37(1): 26-9.
[32]
Cho HY, Kim K, Jeon YT, Kim YB, No JH. CA19-9 elevation in ovarian mature cystic teratoma: discrimination from ovarian cancer - CA19-9 level in teratoma. Med Sci Monit 2013; 19: 230-5.
[33]
Moore RG, Brown AK, Miller MC, et al. Utility of a novel serum tumor biomarker HE4 in patients with endometrioid adenocarcinoma of the uterus. Gynecol Oncol 2008; 110(2): 196-201.
[34]
Simmons AR, Baggerly K, Bast RC Jr. The emerging role of HE4 in the evaluation of epithelial ovarian and endometrial carcinomas. Oncology (Williston Park) 2013; 27(6): 548-56.
[35]
Galgano MT, Hampton GM, Frierson HF Jr. Comprehensive analysis of HE4 expression in normal and malignant human tissues. Mod Pathol 2006; 19(6): 847-53.
[36]
Drapkin R, von Horsten HH, Lin Y, et al. Human epididymis protein 4 (HE4) is a secreted glycoprotein that is overexpressed by serous and endometrioid ovarian carcinomas. Cancer Res 2005; 65(6): 2162-9.
[37]
Lin J, Qin J, Sangvatanakul V. Human epididymis protein 4 for differential diagnosis between benign gynecologic disease and ovarian cancer: a systematic review and meta-analysis. Eur J Obstet Gynecol Reprod Biol 2013; 167(1): 81-5.
[38]
Kondalsamy-Chennakesavan S, Hackethal A, Bowtell D. Australian Ovarian Cancer Study G, Obermair A. Differentiating stage 1 epithelial ovarian cancer from benign ovarian tumours using a combination of tumour markers HE4, CA125, and CEA and patient’s age. Gynecol Oncol 2013; 129(3): 467-71.
[39]
Angioli R, Plotti F, Capriglione S, et al. The role of novel biomarker HE4 in endometrial cancer: a case control prospective study. Tumour Biol 2013; 34(1): 571-6.
[40]
U.S. Food and Drug Administration. OVA1 Next Generation. 510(k) substantial equivalence determination decision summary.Silver Spring (MD): FDA; 2016. Available at:. http://www. accessdata.fda.gov/cdrh_ docs/reviews/K150588.pdf (Accessed on: March 1, 2017)..
[41]
U.S. Food and Drug Administration. ROMATM (HE4 EIA + Architect CA 125 10TM). 510(k) summary. Silver Spring (MD): FDA; 2011. Available at:. http:// www.accessdata.fda.gov/cdrh_ docs/pdf10/K103358.pdf (Accessed on: March 1, 2017).
[42]
Bristow RE, Smith A, Zhang Z, et al. Ovarian malignancy risk stratification of the adnexal mass using a multivariate index assay. Gynecol Oncol 2013; 128(2): 252-9.
[43]
Ueland FR, Desimone CP, Seamon LG, et al. Effectiveness of a multivariate index assay in the preoperative assessment of ovarian tumors. Obstet Gynecol 2011; 117(6): 1289-97.
[44]
Moore RG, McMeekin DS, Brown AK, et al. A novel multiple marker bioassay utilizing HE4 and CA125 for the prediction of ovarian cancer in patients with a pelvic mass. Gynecol Oncol 2009; 112(1): 40-6.
[45]
Moore RG, Miller MC, Disilvestro P, et al. Evaluation of the diagnostic accuracy of the risk of ovarian malignancy algorithm in women with a pelvic mass. Obstet Gynecol 2011; 118(2 Pt 1): 280-8.
[46]
Skates SJ. Ovarian cancer screening: development of the risk of ovarian cancer algorithm (ROCA) and ROCA screening trials. Int J Gynecol Cancer 2012; 22(Suppl. 1): S24-6.
[47]
Menon U, Ryan A, Kalsi J, et al. Risk algorithm using serial biomarker measurements doubles the number of screen-detected cancers compared with a single-threshold rule in the United Kingdom collaborative trial of ovarian cancer screening. J Clin Oncol 2015; 33(18): 2062-71.
[48]
Van Calster B, Van Hoorde K, Valentin L, et al. Evaluating the risk of ovarian cancer before surgery using the ADNEX model to differentiate between benign, borderline, early and advanced stage invasive, and secondary metastatic tumours: prospective multicentre diagnostic study. BMJ 2014; 349: g5920.
[49]
Sayasneh A, Wynants L, Preisler J, et al. Multicentre external validation of IOTA prediction models and RMI by operators with varied training. Br J Cancer 2013; 108(12): 2448-54.
[50]
Timmerman D, Testa AC, Bourne T, et al. Logistic regression model to distinguish between the benign and malignant adnexal mass before surgery: a multicenter study by the International Ovarian Tumor Analysis Group. J Clin Oncol 2005; 23(34): 8794-801.
[51]
Kaijser J, Bourne T, Valentin L, et al. Improving strategies for diagnosing ovarian cancer: a summary of the International Ovarian Tumor Analysis (IOTA) studies. Ultrasound Obstet Gynecol 2013; 41(1): 9-20.
[52]
Van Holsbeke C, Van Calster B, Bourne T, et al. External validation of diagnostic models to estimate the risk of malignancy in adnexal masses. Clin Cancer Res 2012; 18(3): 815-25.
[53]
Barroilhet L, Vitonis A, Shipp T, Muto M, Benacerraf B. Sonographic predictors of ovarian malignancy. J Clin Ultrasound 2013; 41(5): 269-74.
[54]
Goff BA, Mandel L, Muntz HG, Melancon CH. Ovarian carcinoma diagnosis. Cancer 2000; 89(10): 2068-75.
[55]
Committee on Gynecologic Practice, Society of Gynecologic Oncology. The role of the obstetrician–gynecologist in the early detection of epithelial ovarian cancer in women at average risk. Committee Opinion No. 716. Obstet Gynecol 2017; 130: e146-9.
[56]
American College of Obstetricians and Gynecologists. Practice Advisory: FDA Issues Safety Communication on Screening Tests for Ovarian Cancer. 2016.
[57]
American College of Obstetricians and Gynecologists’ Committee on Practice Bulletins. Hereditary Breast and Ovarian Cancer Syndrome. Obstet Gynecol 2009; 113.
[58]
Jayson GC, Kohn EC, Kitchener HC, Ledermann JA. Ovarian cancer. Lancet 2014; 384(9951): 1376-88.
[59]
Rustin GJ, Vergote I, Eisenhauer E, et al. Definitions for response and progression in ovarian cancer clinical trials incorporating RECIST 1.1 and CA 125 agreed by the Gynecological Cancer Intergroup (GCIG). Int J Gynecol Cancer 2011; 21(2): 419-23.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version386msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[04:19:47] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[04:19:47] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[04:19:47] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (142ms)time
  • Application (244ms)time
  • 1 x Application (63.13%)
    244ms
    1 x Booting (36.87%)
    142ms
    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 duplicated151ms
    • 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 ('51271243','',1,1740457187,1740457187) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740457187
      2.17msalphaeurekaselec_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 ('51271243','/article/86646',1,1740457187,1740457187)
      240μ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 >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) 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 >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) 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 >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) 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 >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) 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 >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) 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 >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51271243 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271243) limit 1
      21.79msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51271243
      • 1: 51271243
      • 2: 51271243
      • 3: 51271243
      • 4: 51271243
      • 5: 51271243
      • 6: 51271243
      • 7: 51271243
      • 8: 51271243
      • 9: 51271243
      • 10: 51271243
      • 11: 51271243
      • 12: 51271243
      • 13: 51271243
      • 14: 51271243
      • 15: 51271243
      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=86646
      1.62msalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 58 limit 1
      1.15msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 58
      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=58) and sj.journal_id!=58 group by `j`.`nid`) as `aggregate_table`
      610μ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 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=58) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      890μ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=58) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      850μ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` = '86646'
      980μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 86646
      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` = '86646'
      2.53msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 86646
      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` = '86646' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      4.66msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 86646
      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
      420μ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
      500μ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 = 58 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      32.34msalphaeurekaselec_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 = 58 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      6.91msalphaeurekaselec_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 = 58 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.32msalphaeurekaselec_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` = 86646 limit 1
      300μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 86646
      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 = 86646 and content_type = 'article' order by status desc limit 1
      420μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 16 and cd.sub_disease_id = 478 and content_id!=86646 and cd.content_type = 'article' order by rand() limit 20
      51.02msalphaeurekaselec_live_10_06_2022Article.php#769
      Backtrace
      • 11. app/Models/Article.php:769
      • 12. app/Http/Controllers/ArticleController.php:2098
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 156733 limit 1
      280μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 156733
      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
      210μ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` = 'CWHR' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      330μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CWHR
      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 = '86646' 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) )
      380μ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 = '8731' and content_type = 'i' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      360μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '2526' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      310μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2231
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271243 and j.to_ip >=51271243 )) and ((j.from_date <= 1740457187 and j.to_date >= 1740457187 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2526) 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 <= 51271243 and j.to_ip >=51271243 )) and ((j.from_date <= 1740457187 and j.to_date >= 1740457187 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2526) 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 <= 51271243 and j.to_ip >=51271243 )) and ((j.from_date <= 1740457187 and j.to_date >= 1740457187 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2526)
      6.97msalphaeurekaselec_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 <= 51271243 and j.to_ip >=51271243 )) and ((j.from_date <= 1740457187 and j.to_date >= 1740457187 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 8731) 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 <= 51271243 and j.to_ip >=51271243 )) and ((j.from_date <= 1740457187 and j.to_date >= 1740457187 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 8731) 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 <= 51271243 and j.to_ip >=51271243 )) and ((j.from_date <= 1740457187 and j.to_date >= 1740457187 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 8731)
      630μ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 <= 51271243 and j.to_ip >=51271243 )) and ((j.from_date <= 1740457187 and j.to_date >= 1740457187 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 86646) 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 <= 51271243 and j.to_ip >=51271243 )) and ((j.from_date <= 1740457187 and j.to_date >= 1740457187 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 86646) 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 <= 51271243 and j.to_ip >=51271243 )) and ((j.from_date <= 1740457187 and j.to_date >= 1740457187 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 86646)
      610μ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` < '3' and is_uploaded = 1 and issue_id = 8731 order by cast(first_page as SIGNED) desc limit 1
      530μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 3
      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` > '11' and is_uploaded = 1 and issue_id = 8731 order by cast(first_page as SIGNED) asc limit 1
      500μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 11
      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'
      190μ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
      240μ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` = 86646 limit 1
      2.36msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 86646
      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` = 58 and `b`.`banner_from_date` <= 1740457187 and `b`.`banner_to_date` >= 1740457187 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.15msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 58
      • 3: 1740457187
      • 4: 1740457187
      • 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` = 58 and `b`.`banner_from_date` <= 1740457187 and `b`.`banner_to_date` >= 1740457187 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.13msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 58
      • 3: 1740457187
      • 4: 1740457187
      • 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='b51c6a6355fa029c782bc64d7c67e44e'
      240μ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
        LONdprt8JgWu3KCc0uRsMDXeB5raRUEAbvPkyMyC
        uc_cart_id
        b51c6a6355fa029c782bc64d7c67e44e
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/86646" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/86646
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 25 Feb 2025 04:19:47 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik80Uk9SR2FQT3BLNHEzMVI2RGxmYUE9PSIsInZhbHVlIjoiQWEyZHJxcXJYVjd0WkFPTkpqUTQ3eUtqY0ViU0FKNjUxL05YcVFJSWhyS1dWQU5qQWc0aUN3cW51RWw2ZFMwQ0tia3BzdjRCb0NnVzdPVnBndHU2THhsZ1NwNWNEZXk0YUwwMWhyTGdEVEZkTUpjUURHWWtLQjZmcmp2aDltakQiLCJtYWMiOiI2YjcyYWRkNDNiNmNmNmMwZDUwMjYxYWI3N2M2NWE3MWQwZWRkNGM2OGExMTg1NjIwODUzYTZmMzU3ZGI3OWUxIiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 16:19:47 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ik80Uk9SR2FQT3BLNHEzMVI2RGxmYUE9PSIsInZhbHVlIjoiQWEyZHJxcXJYVjd0WkFPTkpqUTQ3eUtqY0ViU0FKNjUxL05YcVFJSWhyS1dWQU5qQWc0aUN3cW51RWw2ZFMwQ0tia3Bzd" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlRuVGVxOGMwa1hhNTRZQ3dTRWJmSEE9PSIsInZhbHVlIjoiSWhrSmJ3bmd5bU1LbkJzSkh5UkVWYUpKSmFiVFRZSWpNNE84VlFTMFh0NnRPNHYzK2kyZTdLbjRxaGgvTExETWJJWWFycjRJUDZ0dEh6NHNBeGtLU3RIWFVwMUdnU2Z6RjU0T215YldKZTNGUVB4WnZ4NHFnUGVuU2JwZkdDUnoiLCJtYWMiOiIwY2ZkOWYzOWYzYzU4NDBlMGI0MGUxNGM2OTM0OTczNWFjOTM4ZTUyMmEyYjQwZWIzMTdjYTNkOWFhYWQwZTYzIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlRuVGVxOGMwa1hhNTRZQ3dTRWJmSEE9PSIsInZhbHVlIjoiSWhrSmJ3bmd5bU1LbkJzSkh5UkVWYUpKSmFiVFRZSWpNNE84VlFTMFh0NnRPNHYzK2kyZTdLbjR" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik80Uk9SR2FQT3BLNHEzMVI2RGxmYUE9PSIsInZhbHVlIjoiQWEyZHJxcXJYVjd0WkFPTkpqUTQ3eUtqY0ViU0FKNjUxL05YcVFJSWhyS1dWQU5qQWc0aUN3cW51RWw2ZFMwQ0tia3BzdjRCb0NnVzdPVnBndHU2THhsZ1NwNWNEZXk0YUwwMWhyTGdEVEZkTUpjUURHWWtLQjZmcmp2aDltakQiLCJtYWMiOiI2YjcyYWRkNDNiNmNmNmMwZDUwMjYxYWI3N2M2NWE3MWQwZWRkNGM2OGExMTg1NjIwODUzYTZmMzU3ZGI3OWUxIiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 16:19:47 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ik80Uk9SR2FQT3BLNHEzMVI2RGxmYUE9PSIsInZhbHVlIjoiQWEyZHJxcXJYVjd0WkFPTkpqUTQ3eUtqY0ViU0FKNjUxL05YcVFJSWhyS1dWQU5qQWc0aUN3cW51RWw2ZFMwQ0tia3Bzd" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlRuVGVxOGMwa1hhNTRZQ3dTRWJmSEE9PSIsInZhbHVlIjoiSWhrSmJ3bmd5bU1LbkJzSkh5UkVWYUpKSmFiVFRZSWpNNE84VlFTMFh0NnRPNHYzK2kyZTdLbjRxaGgvTExETWJJWWFycjRJUDZ0dEh6NHNBeGtLU3RIWFVwMUdnU2Z6RjU0T215YldKZTNGUVB4WnZ4NHFnUGVuU2JwZkdDUnoiLCJtYWMiOiIwY2ZkOWYzOWYzYzU4NDBlMGI0MGUxNGM2OTM0OTczNWFjOTM4ZTUyMmEyYjQwZWIzMTdjYTNkOWFhYWQwZTYzIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlRuVGVxOGMwa1hhNTRZQ3dTRWJmSEE9PSIsInZhbHVlIjoiSWhrSmJ3bmd5bU1LbkJzSkh5UkVWYUpKSmFiVFRZSWpNNE84VlFTMFh0NnRPNHYzK2kyZTdLbjR" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "LONdprt8JgWu3KCc0uRsMDXeB5raRUEAbvPkyMyC" "uc_cart_id" => "b51c6a6355fa029c782bc64d7c67e44e" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/86646" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 04:19:47GET/article/86646314361