General Review Article

Neoadjuvant Strategies Before Radical Prostatectomy for High Risk Prostate Cancer in the Era of New Hormonal Agents

Author(s): Alessandro Tafuri, Maria Angela Cerruto and Alessandro Antonelli*

Volume 22, Issue 1, 2021

Published on: 21 June, 2020

Page: [68 - 76] Pages: 9

DOI: 10.2174/1389450121666200621194409

Price: $65

Abstract

Prostate cancer (PCa) is a hormone-dependent disease, including several different patterns from indolent and clinically meaningless to aggressive and lethal disease. Among non -metastatic PCa, high-risk disease represents a therapeutical challenge, given the unfavorable oncological outcomes after exclusive local therapy. Deprivation therapy in the neoadjuvant setting is not recommended prior to radical prostatectomy since it did not provide any survival advantage, although reducing tumor volume, surgical margins rate, local and nodal stage. However, in the few recent years, new hormonal treatments for metastatic PCa emerged and showed a relevant increase of overall survival concerning standard androgen deprivation therapy (ADT). Thus, neo-adjuvant regimens of ADT based on these novel molecules are now under investigation and the results of ongoing clinical trials are expected in order to provide a definitive answer on the real role of neoadjuvant hormonal therapy in the treatment of high-risk localized prostate cancer. In this narrative review, we underline the role of neoadjuvant therapy before radical prostatectomy in high-risk PCa patients considering the impact of the new available hormonal agents.

Keywords: Prostate cancer, neoadjuvant therapy, radical prostatectomy, new hormonal agents, abiraterone, enzalutamide, apalutamide.

« Previous
Graphical Abstract

[1]
Siegel RL, Miller KD, Jemal A. Cancer statistics, 2019. CA Cancer J Clin 2019; 69(1): 7-34.
[http://dx.doi.org/org/10.3322/caac.21551] [PMID: 30620402]
[2]
D’Amico AV, Whittington R, Malkowicz SB, et al. Biochemical outcome after radical prostatectomy, external beam radiation therapy, or interstitial radiation therapy for clinically localized prostate cancer. JAMA 1998; 280(11): 969-74.
[http://dx.doi.org/org/10.1001/jama.280.11.969] [PMID: 9749478]
[3]
Mottet N, Bellmunt J, Bolla M, et al. EAU-ESTRO-SIOG Guidelines on Prostate Cancer. Part 1: Screening, Diagnosis, and Local Treatment with Curative Intent. Eur Urol 2017; 71(4): 618-29.
[http://dx.doi.org/org/10.1016/j.eururo.2016.08.003] [PMID: 27568654]
[4]
Mohler JL, Antonarakis ES, Armstrong AJ, et al. Prostate cancer, version 2.2019, NCCN clinical practice guidelines in oncology. J Natl Compr Canc Netw 2019; 17(5): 479-505.
[http://dx.doi.org/org/10.6004/jnccn.2019.0023] [PMID: 31085757]
[5]
Sanda MG, Cadeddu JA, Kirkby E, et al. Clinically localized prostate cancer: AUA/ASTRO/SUO guideline. Part I: risk stratification, shared decision making, and care options. J Urol 2018; 199(3): 683-90.
[http://dx.doi.org/org/10.1016/j.juro.2017.11.095] [PMID: 29203269]
[6]
Johnston TJ, Shaw GL, Lamb AD, et al. ProtecT study group. Mortality among men with advanced prostate cancer excluded from the ProtecT trial. Eur Urol 2017; 71(3): 381-8.
[http://dx.doi.org/org/10.1016/j.eururo.2016.09.040] [PMID: 27720537]
[7]
Bandini M, Fossati N, Gandaglia G, et al. Neoadjuvant and adjuvant treatment in high-risk prostate cancer. Expert Rev Clin Pharmacol 2018; 11(4): 425-38.
[http://dx.doi.org/org/10.1080/17512433.2018.1429265] [PMID: 29355037]
[8]
Kumar S, Shelley M, Harrison C, Coles B, Wilt TJ, Mason M. Neo‐adjuvant and adjuvant hormone therapy for localised and locally advanced prostate cancer. Cochrane Database of Systematic Reviews 2006; (4):
[http://dx.doi.org//10.1002/14651858.CD006019.pub2]
[9]
Hu J, Xu H, Zhu W, et al. Neo-adjuvant hormone therapy for non-metastatic prostate cancer: a systematic review and meta-analysis of 5,194 patients. World J Surg Oncol 2015; 13(1): 73.
[http://dx.doi.org/org/10.1186/s12957-015-0503-z] [PMID: 25884478]
[10]
Pignot G, Maillet D, Gross E, et al. Systemic treatments for high-risk localized prostate cancer. Nat Rev Urol 2018; 15(8): 498-510.
[http://dx.doi.org/org/10.1038/s41585-018-0017-x] [PMID: 29765147]
[11]
Huggins C, Hodges CV. Studies on prostatic cancer. I. The effect of castration, of estrogen and androgen injection on serum phosphatases in metastatic carcinoma of the prostate. CA Cancer J Clin 1972; 22(4): 232-40.
[http://dx.doi.org/org/10.3322/canjclin.22.4.232] [PMID: 4625049]
[12]
Porcaro AB, Tafuri A, Sebben M, et al. High body mass index predicts multiple prostate cancer lymph node metastases after radical prostatectomy and extended pelvic lymph node dissection. Asian J Androl 2020; 22(3): 323-9.
[http://dx.doi.org/org/10.4103/aja.aja_70_19] [PMID: 31347517]
[13]
Fujita K, Nonomura N. Role of androgen receptor in prostate cancer: a review. World J Mens Health 2019; 37(3): 288-95.
[http://dx.doi.org/org/10.5534/wjmh.180040] [PMID: 30209899]
[14]
Fair WR, Cookson MS, Stroumbakis N, et al. The indications, rationale, and results of neoadjuvant androgen deprivation in the treatment of prostatic cancer: Memorial Sloan-Kettering Cancer Center results. Urology 1997; 49(3A)(Suppl.): 46-55.
[http://dx.doi.org/org/10.1016/S0090-4295(97)00169-6] [PMID: 9123736]
[15]
Isaacs JT, Coffey DS. Adaptation versus selection as the mechanism responsible for the relapse of prostatic cancer to androgen ablation therapy as studied in the Dunning R-3327-H adenocarcinoma. Cancer Res 1981; 41(12 Pt 1): 5070-5.
[PMID: 7307008]
[16]
Antonelli A, Palumbo C, Veccia A, et al. Biological effect of neoadjuvant androgen-deprivation therapy assessed on specimens from radical prostatectomy: a systematic review. Minerva Urol Nefrol 2018; 70(4): 370-9.
[http://dx.doi.org/org/10.23736/S0393-2249.18.03022-9] [PMID: 29392925]
[17]
Porcaro AB, De Luyk N, Corsi P, et al. Clinical factors predicting bilateral lymph node invasion in high-risk prostate cancer. clinical factors predicting bilateral lymph node invasion in high-risk prostate cancer. Urol Int 2017; 99(4): 392-9.
[http://dx.doi.org/org/10.1159/000476039] [PMID: 28486228]
[18]
Antonelli A, Palumbo C, Berruti A. Neoadjuvant androgen deprivation therapy through intense inhibition of the androgen target:“Midsummer Night’s Dream” or “Much Ado About Nothing”? Annals of translational medicine 2019; 7(Suppl. 6)2019. : 76.
[19]
Schulman CC, Sassine AM. Neoadjuvant hormonal deprivation before radical prostatectomy. Eur Urol 1993; 24(4): 450-5.
[http://dx.doi.org/org/10.1159/000474348] [PMID: 7507045]
[20]
Solomon MH, McHugh TA, Dorr RP, Lee F, Siders DB. Hormone ablation therapy as neoadjuvant treatment to radical prostatectomy. Clin Invest Med 1993; 16(6): 532-8.
[PMID: 8013157]
[21]
Soloway MS, Sharifi R, Wajsman Z, McLeod D, Wood DPJ Jr, Puras-Baez A. the lupron depot neoadjuvant prostate cancer study group. Randomized prospective study comparing radical prostatectomy alone versus radical prostatectomy preceded by androgen blockade in clinical stage B2 (T2bNxM0) prostate cancer. J Urol 1995; 154(2 Pt 1): 424-8.
[http://dx.doi.org/org/10.1016/S0022-5347(01)67067-8] [PMID: 7541859]
[22]
Soloway MS, Hachiya T, Civantos F, Murphy WM, Gomez CC, Ruiz HE. Androgen deprivation prior to radical prostatectomy for T2b and T3 prostate cancer. Urology 1994; 43(2)(Suppl.): 52-6.
[http://dx.doi.org/org/10.1016/0090-4295(94)90219-4] [PMID: 7509535]
[23]
Kennedy TJ, Sonneland AM, Marlett MM, Troup RH. Luteinizing hormone-releasing hormone downstaging of clinical stage C prostate cancer. J Urol 1992; 147(3 Pt 2): 891-3.
[http://dx.doi.org/org/10.1016/S0022-5347(17)37414-1] [PMID: 1371563]
[24]
Oesterling JE, Andrews PE, Suman VJ, Zincke H, Myers RP. Preoperative androgen deprivation therapy: artificial lowering of serum prostate specific antigen without downstaging the tumor. J Urol 1993; 149(4): 779-82.
[http://dx.doi.org/org/10.1016/S0022-5347(17)36206-7] [PMID: 7681117]
[25]
Aprikian AG, Fair WR, Reuter VE, et al. Experience with neoadjuvant diethylstilboestrol and radical prostatectomy in patients with locally advanced prostate cancer. Br J Urol 1994; 74(5): 630-6.
[http://dx.doi.org/org/10.1111/j.1464-410X.1994.tb09196.x] [PMID: 7530128]
[26]
Labrie F, Cusan L, Gomez J-L, et al. Neoadjuvant hormonal therapy: the Canadian experience. Urology 1997; 49(3A)(Suppl.): 56-64.
[http://dx.doi.org/org/10.1016/S0090-4295(97)00170-2] [PMID: 9123738]
[27]
Selli C, Montironi R, Bono A, et al. PROSIT Study Group. Effects of complete androgen blockade for 12 and 24 weeks on the pathological stage and resection margin status of prostate cancer. J Clin Pathol 2002; 55(7): 508-13.
[http://dx.doi.org/org/10.1136/jcp.55.7.508] [PMID: 12101195]
[28]
Soloway MS, Pareek K, Sharifi R, et al. Lupron depot neoadjuvant prostate cancer study group. Neoadjuvant androgen ablation before radical prostatectomy in cT2bNxMo prostate cancer: 5-year results. J Urol 2002; 167(1): 112-6.
[http://dx.doi.org/org/10.1016/S0022-5347(05)65393-1] [PMID: 11743286]
[29]
Aus G, Abrahamsson PA, Ahlgren G, et al. Three-month neoadjuvant hormonal therapy before radical prostatectomy: a 7-year follow-up of a randomized controlled trial. BJU Int 2002; 90(6): 561-6.
[http://dx.doi.org/org/10.1046/j.1464-410X.2002.02982.x] [PMID: 12230618]
[30]
Klotz LH, Goldenberg SL, Jewett MA, et al. Canadian Uro-Oncology Group. Long-term followup of a randomized trial of 0 versus 3 months of neoadjuvant androgen ablation before radical prostatectomy. J Urol 2003; 170(3): 791-4.
[http://dx.doi.org/org/10.1097/01.ju.0000081404.98273.fd] [PMID: 12913699]
[31]
Yee DS, Lowrance WT, Eastham JA, Maschino AC, Cronin AM, Rabbani F. Long-term follow-up of 3-month neoadjuvant hormone therapy before radical prostatectomy in a randomized trial. BJU Int 2010; 105(2): 185-90.
[http://dx.doi.org/org/10.1111/j.1464-410X.2009.08698.x] [PMID: 19594741]
[32]
Tosco L, Laenen A, Briganti A, et al. The survival impact of neoadjuvant hormonal therapy before radical prostatectomy for treatment of high-risk prostate cancer. Prostate Cancer Prostatic Dis 2017; 20(4): 407-12.
[http://dx.doi.org/org/10.1038/pcan.2017.29] [PMID: 28485390]
[33]
Mellado B, Font A, Alcaraz A, et al. Phase II trial of short-term neoadjuvant docetaxel and complete androgen blockade in high-risk prostate cancer. Br J Cancer 2009; 101(8): 1248-52.
[http://dx.doi.org/org/10.1038/sj.bjc.6605320] [PMID: 19755998]
[34]
Eastham JAG, Heller S, Halabi JP, Monk H, Beltran M. Gleave. LBA-12 CALGB 90203 (ALLIANCE): radical prostatectomy with or without neoadjuvant chemohormonal therapy in men with clinically localized, high risk prostate cancer. The Journal of Urology 2019; 2014: e997-7.
[35]
Monfette G. Temporary combination therapy with Flutamide and Tryptex as adjuvant to radical prostatectomy for the treatment of early stage prostate cancer Early stage prostate cancer: Diagnosis and choice of therapy 1989.
[36]
Chun J, Pruthi RS. Is neoadjuvant hormonal therapy before radical prostatectomy indicated? Urol Int 2004; 72(4): 275-80.
[http://dx.doi.org/org/10.1159/000077677] [PMID: 15153722]
[37]
Fair WR, Aprikian AG, Cohen D, Sogani P, Reuter V. Use of neoadjuvant androgen deprivation therapy in clinically localized prostate cancer. Clin Invest Med 1993; 16(6): 516-22.
[PMID: 8013156]
[38]
Macfarlane MT, Abi-Aad A, Stein A, Danella J, Belldegrun A, deKernion JB. Neoadjuvant hormonal deprivation in patients with locally advanced prostate cancer. J Urol 1993; 150(1): 132-4.
[http://dx.doi.org/org/10.1016/S0022-5347(17)35414-9] [PMID: 7685421]
[39]
Oberlin DT, Flum AS, Lai JD, Meeks JJ. The effect of minimally invasive prostatectomy on practice patterns of American urologists. Urologic Oncology: Seminars and Original Investigations Elsevier 2016.
[40]
Student S, Hejmo T, Poterała-Hejmo A, Leśniak A, Bułdak R. Anti-androgen hormonal therapy for cancer and other diseases. Eur J Pharmacol 2020.866172783
[http://dx.doi.org/org/10.1016/j.ejphar.2019.172783] [PMID: 31712062]
[41]
Taplin M-E, Montgomery B, Logothetis CJ, et al. Intense androgen-deprivation therapy with abiraterone acetate plus leuprolide acetate in patients with localized high-risk prostate cancer: results of a randomized phase II neoadjuvant study. J Clin Oncol 2014; 32(33): 3705-15.
[http://dx.doi.org/org/10.1200/JCO.2013.53.4578] [PMID: 25311217]
[42]
Efstathiou E, Davis JW, Titus MA, Chapin bf, Zurita AJ, Wen S, et al. Neoadjuvant enzalutamide (ENZA) and abiraterone acetate (AA) plus leuprolide acetate (LHRHa) versus AA+ LHRHa in localized high-risk prostate cancer (LHRPC). J ournal of Clinical Oncology 2016; 3415: 5002-2.
[43]
Montgomery B, Tretiakova MS, Joshua AM, et al. Neoadjuvant Enzalutamide Prior to Prostatectomy. Clin Cancer Res 2017; 23(9): 2169-76.
[http://dx.doi.org/org/10.1158/1078-0432.CCR-16-1357] [PMID: 28151719]
[44]
McKay RR, Ye H, Xie W, et al. Evaluation of Intense Androgen Deprivation Before Prostatectomy: A Randomized Phase II Trial of Enzalutamide and Leuprolide With or Without Abiraterone. J Clin Oncol 2019; 37(11): 923-31.
[http://dx.doi.org/org/10.1200/JCO.18.01777] [PMID: 30811282]
[45]
Joshua AM, Fleshner NE, Chin J, Emmenegger U, Gleave ME, Hotte SJ, et al. Abiraterone+/-cabazitaxel in defining complete response in prostatectomy (ACDC-RP) trial. JAmerican Society of Clinical Oncology 2017.
[http://dx.doi.org/org/10.1200/JCO.2017.35.15_suppl.TPS5095]
[46]
Marchioni M, Sountoulides P, Bada M, et al. Abiraterone in chemotherapy-naive patients with metastatic castration-resistant prostate cancer: a systematic review of ‘real-life’ studies. Ther Adv Urol 2018; 10(10): 305-15.
[http://dx.doi.org/org/10.1177/1756287218786160] [PMID: 30186368]
[47]
Jung ME, Ouk S, Yoo D, et al. Structure-activity relationship for thiohydantoin androgen receptor antagonists for castration-resistant prostate cancer (CRPC). J Med Chem 2010; 53(7): 2779-96.
[http://dx.doi.org/org/10.1021/jm901488g] [PMID: 20218717]
[48]
Tran C, Ouk S, Clegg NJ, et al. Development of a second-generation antiandrogen for treatment of advanced prostate cancer. Science 2009; 324(5928): 787-90.
[http://dx.doi.org/org/10.1126/science.1168175] [PMID: 19359544]
[49]
Alkhudair NA. Apalutamide: Emerging Therapy for Non-Metastatic Castration-Resistant Prostate Cancer. Saudi Pharm J 2019; 27(3): 368-72.
[http://dx.doi.org/org/10.1016/j.jsps.2018.12.005] [PMID: 30976180]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version425msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[13:21:58] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[13:21:58] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[13:21:58] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[13:21:58] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (118ms)time
  • Application (308ms)time
  • 1 x Application (72.34%)
    308ms
    1 x Booting (27.66%)
    118ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated234ms
    • 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 ('60015499','',1,1739971318,1739971318) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739971318
      1.27msalphaeurekaselec_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 ('60015499','/article/107532',1,1739971318,1739971318)
      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 >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) 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 >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) 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 >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) 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 >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) 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 >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) 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 >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 60015499 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 60015499) limit 1
      22.98msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 60015499
      • 1: 60015499
      • 2: 60015499
      • 3: 60015499
      • 4: 60015499
      • 5: 60015499
      • 6: 60015499
      • 7: 60015499
      • 8: 60015499
      • 9: 60015499
      • 10: 60015499
      • 11: 60015499
      • 12: 60015499
      • 13: 60015499
      • 14: 60015499
      • 15: 60015499
      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=107532
      5.46msalphaeurekaselec_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` = 13 limit 1
      1.1msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 13
      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=13) and sj.journal_id!=13 group by `j`.`nid`) as `aggregate_table`
      1.47msalphaeurekaselec_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=13) and sj.journal_id!=13 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.23msalphaeurekaselec_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=13) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      60.1msalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 16. app/Models/Subject.php:220
      • 17. app/Http/Controllers/ArticleController.php:2518
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=13) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      4msalphaeurekaselec_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` = '107532'
      380μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 107532
      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` = '107532'
      2.46msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 107532
      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` = '107532' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.12msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 107532
      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
      280μ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
      660μ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 = 13 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      28.35msalphaeurekaselec_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 = 13 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      19.41msalphaeurekaselec_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 = 13 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      14.52msalphaeurekaselec_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` = 107532 limit 1
      250μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 107532
      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 = 107532 and content_type = 'article' order by status desc limit 1
      290μ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 = 483 and content_id!=107532 and cd.content_type = 'article' order by rand() limit 20
      54.35msalphaeurekaselec_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` = 183014 limit 1
      290μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 183014
      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
      230μ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` = 'CDT' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      320μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CDT
      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 = '107532' 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) )
      360μ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 = '10336' 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) )
      320μ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 = '2949' 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) )
      390μ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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1739971318 and j.to_date >= 1739971318 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2949) 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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1739971318 and j.to_date >= 1739971318 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2949) 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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1739971318 and j.to_date >= 1739971318 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2949)
      4.18msalphaeurekaselec_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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1739971318 and j.to_date >= 1739971318 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10336) 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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1739971318 and j.to_date >= 1739971318 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10336) 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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1739971318 and j.to_date >= 1739971318 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10336)
      610μ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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1739971318 and j.to_date >= 1739971318 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 107532) 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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1739971318 and j.to_date >= 1739971318 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 107532) 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 <= 60015499 and j.to_ip >=60015499 )) and ((j.from_date <= 1739971318 and j.to_date >= 1739971318 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 107532)
      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` < '68' and is_uploaded = 1 and issue_id = 10336 order by cast(first_page as SIGNED) desc limit 1
      570μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 68
      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` > '76' and is_uploaded = 1 and issue_id = 10336 order by cast(first_page as SIGNED) asc limit 1
      450μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 76
      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
      220μ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` = 107532 limit 1
      2.09msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 107532
      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` = 13 and `b`.`banner_from_date` <= 1739971318 and `b`.`banner_to_date` >= 1739971318 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: 13
      • 3: 1739971318
      • 4: 1739971318
      • 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` = 13 and `b`.`banner_from_date` <= 1739971318 and `b`.`banner_to_date` >= 1739971318 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: 13
      • 3: 1739971318
      • 4: 1739971318
      • 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='58d548a24b6e0f7e6ff2ed2d388e27b7'
      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#?
    App\Models\MultiLangArticle
    1MultiLangArticle.php#?
        _token
        yefkfE57plBkhLwR8GtbCnpeQOxe3KK3RkDTBWP4
        uc_cart_id
        58d548a24b6e0f7e6ff2ed2d388e27b7
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/107532" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/107532
        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:9 [ "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6IjBmRVdSN2ZONnc2S2k1bzhjU1lkc0E9PSIsInZhbHVlIjoiRjk5NUhUcFo4VkN1QW11VzJmQVI2VjR6alNWKzdoazlydEdNajZCTFlpND0iLCJtYWMiOiIyMTJjODBhZDAzZTdmYWU1OGQ4MDFmODRhMWM0MWIwODQ5OGYzMGZjOTc1MjU1MmQyNDRkYmE2ZDdiZTk0MGE5IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IjBmRVdSN2ZONnc2S2k1bzhjU1lkc0E9PSIsInZhbHVlIjoiRjk5NUhUcFo4VkN1QW11VzJmQVI2VjR6alNWKzdoazlydEdNajZCTFlpND0iLCJtYWMiOiIyMTJjODBhZDAzZTdm" ] "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
        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 => "Wed, 19 Feb 2025 13:21:58 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImR3WUlsOFRVWkNVb2Zkb3ptQUcwdWc9PSIsInZhbHVlIjoiTTVNUWd0YUNlYUxEUTUvTDhlcXFqMUp1VXFWNmtXdFV0NFFkdStJK2R5b3BsclRjNitQNzdjQ0liM254dTdid0k4R3Z2cHVWYjZhM00raFcrTmVld1o0a1dEYmlpUVJOc3QvK3hadjM4WXIzWEFLeVRGcFhiRXFPMk1EOVplOVkiLCJtYWMiOiJiM2ZkNjQ0OWZjZDEzYzE1MmJhYzA4NzMzY2ExMTI3Yzg4YjgyNGVkNjMyZGY5ZDZiYTAyODE2NzU4N2E1MDMzIiwidGFnIjoiIn0%3D; expires=Sat, 22 Feb 2025 01:21:58 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImR3WUlsOFRVWkNVb2Zkb3ptQUcwdWc9PSIsInZhbHVlIjoiTTVNUWd0YUNlYUxEUTUvTDhlcXFqMUp1VXFWNmtXdFV0NFFkdStJK2R5b3BsclRjNitQNzdjQ0liM254dTdid0k4R3Z2c" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkNUWHVNRjZ0ZWkvU3RvZFlIZENnVGc9PSIsInZhbHVlIjoiMm9vV2pPcklLOU9QRzFYcE14TVhVdjFsYWkzbDZNZU5MYlFPT0xKR2htWlpiMWczbEdiNVNtQVczZnlocjN3WVB0ZExwLzgzYnNPUitRVlN4cWl0NTUvdjBaYnhYQW5LNHdxb2lHVjRJMWJYOWpSdk1xSWFSSmZxeEFrNzVXVVoiLCJtYWMiOiI5YTMwYmQ5NWFiYzU3MTNhMmMwMGFjNjY2NTAzYTY2Njc3OWY2NDkwY2IyNDMwMThmZGZhZTE5ZDI1MjEzMDFmIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkNUWHVNRjZ0ZWkvU3RvZFlIZENnVGc9PSIsInZhbHVlIjoiMm9vV2pPcklLOU9QRzFYcE14TVhVdjFsYWkzbDZNZU5MYlFPT0xKR2htWlpiMWczbEdiNVNtQVc" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImR3WUlsOFRVWkNVb2Zkb3ptQUcwdWc9PSIsInZhbHVlIjoiTTVNUWd0YUNlYUxEUTUvTDhlcXFqMUp1VXFWNmtXdFV0NFFkdStJK2R5b3BsclRjNitQNzdjQ0liM254dTdid0k4R3Z2cHVWYjZhM00raFcrTmVld1o0a1dEYmlpUVJOc3QvK3hadjM4WXIzWEFLeVRGcFhiRXFPMk1EOVplOVkiLCJtYWMiOiJiM2ZkNjQ0OWZjZDEzYzE1MmJhYzA4NzMzY2ExMTI3Yzg4YjgyNGVkNjMyZGY5ZDZiYTAyODE2NzU4N2E1MDMzIiwidGFnIjoiIn0%3D; expires=Sat, 22-Feb-2025 01:21:58 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImR3WUlsOFRVWkNVb2Zkb3ptQUcwdWc9PSIsInZhbHVlIjoiTTVNUWd0YUNlYUxEUTUvTDhlcXFqMUp1VXFWNmtXdFV0NFFkdStJK2R5b3BsclRjNitQNzdjQ0liM254dTdid0k4R3Z2c" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkNUWHVNRjZ0ZWkvU3RvZFlIZENnVGc9PSIsInZhbHVlIjoiMm9vV2pPcklLOU9QRzFYcE14TVhVdjFsYWkzbDZNZU5MYlFPT0xKR2htWlpiMWczbEdiNVNtQVczZnlocjN3WVB0ZExwLzgzYnNPUitRVlN4cWl0NTUvdjBaYnhYQW5LNHdxb2lHVjRJMWJYOWpSdk1xSWFSSmZxeEFrNzVXVVoiLCJtYWMiOiI5YTMwYmQ5NWFiYzU3MTNhMmMwMGFjNjY2NTAzYTY2Njc3OWY2NDkwY2IyNDMwMThmZGZhZTE5ZDI1MjEzMDFmIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkNUWHVNRjZ0ZWkvU3RvZFlIZENnVGc9PSIsInZhbHVlIjoiMm9vV2pPcklLOU9QRzFYcE14TVhVdjFsYWkzbDZNZU5MYlFPT0xKR2htWlpiMWczbEdiNVNtQVc" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "yefkfE57plBkhLwR8GtbCnpeQOxe3KK3RkDTBWP4" "uc_cart_id" => "58d548a24b6e0f7e6ff2ed2d388e27b7" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/107532" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-19 13:21:58GET/article/107532414372