Research Article

Potential Prognostic Predictors and Molecular Targets for Skin Melanoma Screened by Weighted Gene Co-expression Network Analysis

Author(s): Sichao Chen, Zeming Liu, Man Li, Yihui Huang, Min Wang, Wen Zeng, Wei Wei, Chao Zhang, Yan Gong* and Liang Guo*

Volume 20, Issue 1, 2020

Page: [5 - 14] Pages: 10

DOI: 10.2174/1566523220666200516170832

Price: $65

Abstract

Aims and Objectives: Among skin cancers, malignant skin melanoma is the leading cause of death. Identification of gene markers of malignant skin melanoma associated with survival may provide new clues for prognosis prediction and treatment. This research aimed to screen out potential prognostic predictors and molecular targets for malignant skin melanoma.

Introduction: Information regarding gene expression in skin melanoma and patients’ clinical traits was obtained from the Gene Expression Omnibus database. Weighted gene co-expression network analysis (WGCNA) was applied to build co-expression modules and investigate the association between the modules and clinical traits. Moreover, functional enrichment analysis was performed for clinically significant co-expression modules. Hub genes of these modules were validated via Gene Expression Profiling Interactive Analysis (GEPIA) and the Human Protein Atlas (http:// www.proteinatlas.org).

Methods: First, using WGCNA, 9 co-expression modules were constructed by the top 25% differentially expressed genes (4406 genes) from 77 human melanoma samples. Two co-expression modules (magenta and blue modules) were significantly correlated with survival months (r = -0.27, p = 0.02; r = 0.27, p = 0.02, respectively). The results of functional enrichment analysis demonstrated that the magenta module was mainly enriched in the cell cycle process and the blue module was mainly enriched in the immune response process. Additionally, the GEPIA and Human Protein Atlas results suggested that the hub genes CCNB2, ARHGAP30, and SEMA4D were associated with relapse-free survival and overall survival (all p-values < 0.05) and were differentially expressed in melanoma tumors and normal skin.

Results and Conclusion: The results provided the framework of co-expression gene modules of skin melanoma and screened out CCNB2, ARHGAP30, and SEMA4D associated with survival as potential prognostic predictors and molecular targets of treatment.

Keywords: Melanoma, WGCNA, prognosis, CCNB2, ARHGAP30, SEMA4D.

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/10.3322/caac.21551] [PMID: 30620402]
[2]
Howlader N, Noone A, Krapcho M, et al. SEER Cancer Statistics Review, 1975-2013. Bethesda, MD: National Cancer Institute 2016.
[3]
Shao C, Dai W, Li H, et al. The relationship between RASSF1A gene promoter methylation and the susceptibility and prognosis of melanoma: A meta-analysis and bioinformatics. PLoS One 2017; 12(2): e0171676
[http://dx.doi.org/10.1371/journal.pone.0171676] [PMID: 28207831]
[4]
Barut F, Udul P, Kokturk F, Kandemir NO, Keser SH, Ozdamar SO. Clinicopathological features and pituitary homeobox 1 gene expression in the progression and prognosis of cutaneous malignant melanoma. Kaohsiung J Med Sci 2016; 32(10): 494-500.
[http://dx.doi.org/10.1016/j.kjms.2016.08.001] [PMID: 27742032]
[5]
Liu H, Zhou M. Evaluation of p53 gene expression and prognosis characteristics in uveal melanoma cases. OncoTargets Ther 2017; 10: 3429-34.
[http://dx.doi.org/10.2147/OTT.S136785] [PMID: 28744147]
[6]
Yan J, Yu J, Wu X, et al. Increased AURKA gene copy number correlates with poor prognosis and predicts the efficacy of High-dose interferon therapy in acral melanoma. J Cancer 2018; 9(7): 1267-76.
[http://dx.doi.org/10.7150/jca.24013] [PMID: 29675108]
[7]
Gerami P, Cook RW, Wilkinson J, et al. Development of a prognostic genetic signature to predict the metastatic risk associated with cutaneous melanoma. Clin Cancer Res 2015; 21(1): 175-83.
[http://dx.doi.org/10.1158/1078-0432.CCR-13-3316]
[8]
Uhara H. Recent advances in therapeutic strategies for unresectable or metastatic melanoma and real-world data in Japan. Int J Clin Oncol 2019; 24(12): 1508-14.
[PMID: 29470725]
[9]
Robert C, Grob JJ, Stroyakovskiy D, et al. Five-Year outcomes with dabrafenib plus trametinib in metastatic melanoma. N Engl J Med 2019; 381(7): 626-36.
[http://dx.doi.org/10.1056/NEJMoa1904059] [PMID: 31166680]
[10]
Guo Y, Ma J, Xiao L, et al. Identification of key pathways and genes in different types of chronic kidney disease based on WGCNA. Mol Med Rep 2019; 20(3): 2245-57.
[http://dx.doi.org/10.3892/mmr.2019.10443] [PMID: 31257514]
[11]
Xia WX, Yu Q, Li GH, et al. Identification of four hub genes associated with adrenocortical carcinoma progression by WGCNA. PeerJ 2019; 7: e6555
[http://dx.doi.org/10.7717/peerj.6555] [PMID: 30886771]
[12]
Di Y, Chen D, Yu W, Yan L. Bladder cancer stage-associated hub genes revealed by WGCNA co-expression network analysis. Hereditas 2019; 156: 7.
[http://dx.doi.org/10.1186/s41065-019-0083-y] [PMID: 30723390]
[13]
Mann GJ, Pupo GM, Campain AE, et al. BRAF mutation, NRAS mutation, and the absence of an immune-related expressed gene profile predict poor outcome in patients with stage III melanoma. J Invest Dermatol 2013; 133(2): 509-17.
[http://dx.doi.org/10.1038/jid.2012.283] [PMID: 22931913]
[14]
Mason MJ, Fan G, Plath K, Zhou Q, Horvath S. Signed weighted gene co-expression network analysis of transcriptional regulation in murine embryonic stem cells. BMC Genomics 2009; 10(1): 327.
[http://dx.doi.org/10.1186/1471-2164-10-327] [PMID: 19619308]
[15]
Yip AM, Horvath S. Gene network interconnectedness and the generalized topological overlap measure. BMC Bioinformatics 2007; 8: 22.
[http://dx.doi.org/10.1186/1471-2105-8-22] [PMID: 17250769]
[16]
Langfelder P, Horvath S. Eigengene networks for studying the relationships between co-expression modules. BMC Syst Biol 2007; 1: 54.
[http://dx.doi.org/10.1186/1752-0509-1-54] [PMID: 18031580]
[17]
Tang Z, Li C, Kang B, Gao G, Li C, Zhang Z. GEPIA: a web server for cancer and normal gene expression profiling and interactive analyses. Nucleic Acids Res 2017; 45(W1): W98-W102.
[http://dx.doi.org/10.1093/nar/gkx247] [PMID: 28407145]
[18]
Takashima S, Saito H, Takahashi N, et al. Strong expression of cyclin B2 mRNA correlates with a poor prognosis in patients with non-small cell lung cancer. Tumour Biol 2014; 35(5): 4257-65.
[http://dx.doi.org/10.1007/s13277-013-1556-7] [PMID: 24375198]
[19]
Li R, Jiang X, Zhang Y, et al. Cyclin B2 overexpression in human hepatocellular carcinoma is associated with poor prognosis. Arch Med Res 2019; 50(1): 10-7.
[http://dx.doi.org/10.1016/j.arcmed.2019.03.003] [PMID: 31101236]
[20]
Shubbar E, Kovács A, Hajizadeh S, et al. Elevated cyclin B2 expression in invasive breast carcinoma is associated with unfavorable clinical outcome. BMC Cancer 2013; 13: 1.
[http://dx.doi.org/10.1186/1471-2407-13-1] [PMID: 23282137]
[21]
Shi Q, Wang W, Jia Z, Chen P, Ma K, Zhou C. ISL1, a novel regulator of CCNB1, CCNB2 and c-MYC genes, promotes gastric cancer cell proliferation and tumor growth. Oncotarget 2016; 7(24): 36489-500.
[http://dx.doi.org/10.18632/oncotarget.9269] [PMID: 27183908]
[22]
Naji L, Pacholsky D, Aspenström P. ARHGAP30 is a Wrch-1-interacting protein involved in actin dynamics and cell adhesion. Biochem Biophys Res Commun 2011; 409(1): 96-102.
[http://dx.doi.org/10.1016/j.bbrc.2011.04.116] [PMID: 21565175]
[23]
Wang J, Qian J, Hu Y, et al. ArhGAP30 promotes p53 acetylation and function in colorectal cancer. Nat Commun 2014; 5: 4735.
[http://dx.doi.org/10.1038/ncomms5735] [PMID: 25156493]
[24]
Mao X, Tong J. ARHGAP30 suppressed lung cancer cell proliferation, migration, and invasion through inhibition of the Wnt/β-catenin signaling pathway. OncoTargets Ther 2018; 11: 7447-57.
[http://dx.doi.org/10.2147/OTT.S175255] [PMID: 30425532]
[25]
Li H, Wang JS, Mu LJ, Shan KS, Li LP, Zhou YB. Promotion of Sema4D expression by tumor-associated macrophages: Significance in gastric carcinoma. World J Gastroenterol 2018; 24(5): 593-601.
[http://dx.doi.org/10.3748/wjg.v24.i5.593] [PMID: 29434448]
[26]
Xia Y, Cai XY, Fan JQ, et al. The role of sema4D in vasculogenic mimicry formation in non-small cell lung cancer and the underlying mechanisms. Int J Cancer 2019; 144(9): 2227-38.
[http://dx.doi.org/10.1002/ijc.31958] [PMID: 30374974]
[27]
Chen Y, Zhang L, Liu WX, Wang K. VEGF and SEMA4D have synergistic effects on the promotion of angiogenesis in epithelial ovarian cancer. Cell Mol Biol Lett 2018; 23: 2.
[http://dx.doi.org/10.1186/s11658-017-0058-9] [PMID: 29308068]
[28]
Soong J, Scott G. Plexin B1 inhibits MET through direct association and regulates Shp2 expression in melanocytes. J Cell Sci 2013; 126(Pt 2): 688-95.
[http://dx.doi.org/10.1242/jcs.119487] [PMID: 23203808]
[29]
Soong J, Chen Y, Shustef EM, Scott GA. Sema4D, the ligand for Plexin B1, suppresses c-Met activation and migration and promotes melanocyte survival and growth. J Invest Dermatol 2012; 132(4): 1230-8.
[http://dx.doi.org/10.1038/jid.2011.414] [PMID: 22189792]
[30]
Heo JR, Kim NH, Cho J, Choi KC. Current treatments for advanced melanoma and introduction of a promising novel gene therapy for melanoma (Review). Oncol Rep 2016; 36(4): 1779-86.
[http://dx.doi.org/10.3892/or.2016.5032] [PMID: 27573048]
[31]
Menezes ME, Talukdar S, Wechman SL, et al. Prospects of gene therapy to treat melanoma. Adv Cancer Res 2018; 138: 213-37.
[http://dx.doi.org/10.1016/bs.acr.2018.02.007] [PMID: 29551128]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version367msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[02:56:02] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[02:56:02] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[02:56:02] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (107ms)time
  • Application (259ms)time
  • 1 x Application (70.71%)
    259ms
    1 x Booting (29.28%)
    107ms
    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 duplicated156ms
    • 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 ('316574772','',1,1739847362,1739847362) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739847362
      1.88msalphaeurekaselec_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 ('316574772','/article/106684',1,1739847362,1739847362)
      250μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) 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 >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) 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 >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) 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 >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) 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 >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) 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 >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316574772 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316574772) limit 1
      22.15msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316574772
      • 1: 316574772
      • 2: 316574772
      • 3: 316574772
      • 4: 316574772
      • 5: 316574772
      • 6: 316574772
      • 7: 316574772
      • 8: 316574772
      • 9: 316574772
      • 10: 316574772
      • 11: 316574772
      • 12: 316574772
      • 13: 316574772
      • 14: 316574772
      • 15: 316574772
      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=106684
      1msalphaeurekaselec_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` = 28 limit 1
      1.14msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 28
      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=28) and sj.journal_id!=28 group by `j`.`nid`) as `aggregate_table`
      980μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=28) and sj.journal_id!=28 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      890μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=28) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      4.5msalphaeurekaselec_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=28) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      3.91msalphaeurekaselec_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` = '106684'
      340μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 106684
      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` = '106684'
      2.95msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 106684
      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` = '106684' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.47msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 106684
      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
      230μ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
      570μ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 = 28 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      32.48msalphaeurekaselec_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 = 28 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      6.06msalphaeurekaselec_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 = 28 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      6.26msalphaeurekaselec_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` = 106684 limit 1
      230μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 106684
      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 = 106684 and content_type = 'article' order by status desc limit 1
      1.41msalphaeurekaselec_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 = 433 and content_id!=106684 and cd.content_type = 'article' order by rand() limit 20
      36.81msalphaeurekaselec_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` = 182016 limit 1
      230μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 182016
      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
      260μ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` = 'CGT' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      340μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CGT
      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 = '106684' 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 = '9893' 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) )
      340μ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 = '2707' 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 <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1739847362 and j.to_date >= 1739847362 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2707) 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 <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1739847362 and j.to_date >= 1739847362 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2707) 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 <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1739847362 and j.to_date >= 1739847362 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2707)
      21.56msalphaeurekaselec_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 <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1739847362 and j.to_date >= 1739847362 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9893) 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 <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1739847362 and j.to_date >= 1739847362 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9893) 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 <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1739847362 and j.to_date >= 1739847362 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9893)
      650μ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 <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1739847362 and j.to_date >= 1739847362 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 106684) 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 <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1739847362 and j.to_date >= 1739847362 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 106684) 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 <= 316574772 and j.to_ip >=316574772 )) and ((j.from_date <= 1739847362 and j.to_date >= 1739847362 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 106684)
      590μ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` < '5' and is_uploaded = 1 and issue_id = 9893 order by cast(first_page as SIGNED) desc limit 1
      480μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 5
      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` > '14' and is_uploaded = 1 and issue_id = 9893 order by cast(first_page as SIGNED) asc limit 1
      460μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 14
      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'
      180μ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
      190μ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` = 106684 limit 1
      1.79msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 106684
      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` = 28 and `b`.`banner_from_date` <= 1739847362 and `b`.`banner_to_date` >= 1739847362 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.19msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 28
      • 3: 1739847362
      • 4: 1739847362
      • 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` = 28 and `b`.`banner_from_date` <= 1739847362 and `b`.`banner_to_date` >= 1739847362 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.14msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 28
      • 3: 1739847362
      • 4: 1739847362
      • 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='74aa5bf174ec2f31b9535e477907dd0c'
      210μ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
        ht9kCqnyh4kvPFsO5GH1aXpXAJ3xFxZithyiLIFu
        uc_cart_id
        74aa5bf174ec2f31b9535e477907dd0c
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/106684" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/106684
        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=eyJpdiI6ImFzV0U3MTlhU3BoekFKaGNIU09GZ2c9PSIsInZhbHVlIjoib0xRNnNMMWlDR3FMNjMzblcxQWtaVG1yWFVqQ3E1SVZBQ1VIZFZXN2l3aExTMWpGYW5LS2ZHWk5aaWRKb0E2YyIsIm1hYyI6ImQwODU1MjIyZWEwZGM1Y2UyMjc0NmQ1MzljMGJhNDBiMzI1OGZiNmJjZWJmYjc4NDllZTczOWU3Y2MzOGRkNjEiLCJ0YWciOiIifQ%3D%3Dwayfindertarget=eyJpdiI6ImFzV0U3MTlhU3BoekFKaGNIU09GZ2c9PSIsInZhbHVlIjoib0xRNnNMMWlDR3FMNjMzblcxQWtaVG1yWFVqQ3E1SVZBQ1VIZFZXN2l3aExTMWpGYW5LS2ZHWk5aaWRKb0E2YyIs" ] "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 => "Tue, 18 Feb 2025 02:56:02 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlRjVnN1YjdOaEw2MXMyVG0rSWtoYkE9PSIsInZhbHVlIjoiS0ticFlseDlYR09lalNudEpDKzZJQTJ5WmZtbmNTY3BnT3pFOWhJVTVKUmhuMlpEVVRYRDc5bDRlMThLTWhyWFBucmZHbVFyQ3FWZWlJaWcwY2ZNZXUyWEt6RFVSRlpTdFZjaEtOdzRtNS9IZFZWVzFiTElXRnlNNUFDRjhvbXEiLCJtYWMiOiIwNzhiYzBlNjVmZmFmYjY0YzQxNmIxOGE5YTAyYzk2Y2U0MmY4ZTc1MjM4NDk1YzhiYWU2MjFiYjM5MDljNzQ1IiwidGFnIjoiIn0%3D; expires=Thu, 20 Feb 2025 14:56:02 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlRjVnN1YjdOaEw2MXMyVG0rSWtoYkE9PSIsInZhbHVlIjoiS0ticFlseDlYR09lalNudEpDKzZJQTJ5WmZtbmNTY3BnT3pFOWhJVTVKUmhuMlpEVVRYRDc5bDRlMThLTWhyWFBucmZHb" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ijlmbm8rVUJMRE4weWYwWjFTeVREVWc9PSIsInZhbHVlIjoiVzM5NklRZnZ2OU5Ra3BQME9rSVhqSGZ3TEpVditvZ3hwY09ZVE1aYXJDSXJNNUl1MzE5MTdMSjFRKzBIRUppOTNzLy9Xak1obTgyeTVhRVFpYTFGQ3g2SU1WWW9IQUtQNWs5c1U3ZW5FM2pueHUxb0FMOGZhMHkrSEYzNGRWZkkiLCJtYWMiOiI5ZDZmZjI3ZmEwM2NhNjVhYzAwYjNlZjFkZmE4YTA2YjY4ZGYwNTBiZmQzMjg2MGFkZTQxN2QwNjYwMzMxMjc5IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ijlmbm8rVUJMRE4weWYwWjFTeVREVWc9PSIsInZhbHVlIjoiVzM5NklRZnZ2OU5Ra3BQME9rSVhqSGZ3TEpVditvZ3hwY09ZVE1aYXJDSXJNNUl1MzE5MTdMSjF" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlRjVnN1YjdOaEw2MXMyVG0rSWtoYkE9PSIsInZhbHVlIjoiS0ticFlseDlYR09lalNudEpDKzZJQTJ5WmZtbmNTY3BnT3pFOWhJVTVKUmhuMlpEVVRYRDc5bDRlMThLTWhyWFBucmZHbVFyQ3FWZWlJaWcwY2ZNZXUyWEt6RFVSRlpTdFZjaEtOdzRtNS9IZFZWVzFiTElXRnlNNUFDRjhvbXEiLCJtYWMiOiIwNzhiYzBlNjVmZmFmYjY0YzQxNmIxOGE5YTAyYzk2Y2U0MmY4ZTc1MjM4NDk1YzhiYWU2MjFiYjM5MDljNzQ1IiwidGFnIjoiIn0%3D; expires=Thu, 20-Feb-2025 14:56:02 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlRjVnN1YjdOaEw2MXMyVG0rSWtoYkE9PSIsInZhbHVlIjoiS0ticFlseDlYR09lalNudEpDKzZJQTJ5WmZtbmNTY3BnT3pFOWhJVTVKUmhuMlpEVVRYRDc5bDRlMThLTWhyWFBucmZHb" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ijlmbm8rVUJMRE4weWYwWjFTeVREVWc9PSIsInZhbHVlIjoiVzM5NklRZnZ2OU5Ra3BQME9rSVhqSGZ3TEpVditvZ3hwY09ZVE1aYXJDSXJNNUl1MzE5MTdMSjFRKzBIRUppOTNzLy9Xak1obTgyeTVhRVFpYTFGQ3g2SU1WWW9IQUtQNWs5c1U3ZW5FM2pueHUxb0FMOGZhMHkrSEYzNGRWZkkiLCJtYWMiOiI5ZDZmZjI3ZmEwM2NhNjVhYzAwYjNlZjFkZmE4YTA2YjY4ZGYwNTBiZmQzMjg2MGFkZTQxN2QwNjYwMzMxMjc5IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ijlmbm8rVUJMRE4weWYwWjFTeVREVWc9PSIsInZhbHVlIjoiVzM5NklRZnZ2OU5Ra3BQME9rSVhqSGZ3TEpVditvZ3hwY09ZVE1aYXJDSXJNNUl1MzE5MTdMSjF" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "ht9kCqnyh4kvPFsO5GH1aXpXAJ3xFxZithyiLIFu" "uc_cart_id" => "74aa5bf174ec2f31b9535e477907dd0c" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/106684" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-18 02:56:02GET/article/106684314372