Generic placeholder image

Current Medicinal Chemistry

Editor-in-Chief

ISSN (Print): 0929-8673
ISSN (Online): 1875-533X

Review Article

NR2F1-AS1: A Functional Long Noncoding RNA in Tumorigenesis

Author(s): Jiahui Hu, Fan Peng, Xinyan Qiu, Jingjie Yang, Jing Li, Chuyue Shen and Chengfu Yuan*

Volume 30, Issue 37, 2023

Published on: 02 February, 2023

Page: [4266 - 4276] Pages: 11

DOI: 10.2174/0929867330666230112165503

Price: $65

Abstract

Background: NR2F1-AS1 is a long non-coding RNA (lnc RNA) that is involved in different biological processes. It plays an integral role in the pathophysiology of human diseases, especially tumorigenesis and progression. Therefore, it may be a promising target for numerous tumor biotherapeutics. The current review study aimed to show the pathophysiological activities and processes of RNA NR2F1-AS1 in cancer cells.

Methods: The contents of the present review were based on information obtained from PubMed. In the data search, “NR2F1-AS1” was chosen as the first keyword, whereas “cancer” was chosen as the second keyword. This review selected and summarized studies published between 2019-2021, concerning the biological functions and mechanisms of NR2F1-AS1 in the development of tumorigenesis.

Results: It was found that NR2F1-AS1 regulates a variety of biological activities such as proliferation, invasion, migration, and apoptosis. It acts as an oncogene because it is abnormally expressed and promotes the progression of cancer in a variety of malignancies, including esophageal squamous cell carcinoma, non-small cell lung cancer, breast cancer, neuroblastoma, endometrial cancer, thyroid cancer, and gastric cancer. However, it was evident that NR2F1-AS1 inhibits the progression of cancer in cervical squamous cell carcinoma.

Conclusion: NR2F1-AS1 is a potential new biomarker and therapeutic target for the treatment of different cancers.

« Previous
[1]
Mattick, J.S. Non-coding RNAs: the architects of eukaryotic complexity. EMBO Rep., 2001, 2(11), 986-991.
[http://dx.doi.org/10.1093/embo-reports/kve230] [PMID: 11713189]
[2]
Shi, X.; Sun, M.; Liu, H.; Yao, Y.; Song, Y. Long non-coding RNAs: A new frontier in the study of human diseases. Cancer Lett., 2013, 339(2), 159-166.
[http://dx.doi.org/10.1016/j.canlet.2013.06.013] [PMID: 23791884]
[3]
Bridges, M.C.; Daulagala, A.C.; Kourtidis, A. LNCcation: lncRNA localization and function. J. Cell Biol., 2021, 220(2), e202009045.
[http://dx.doi.org/10.1083/jcb.202009045] [PMID: 33464299]
[4]
Zhang, A.; Xu, M.; Mo, Y.Y. Role of the lncRNA-p53 regulatory network in cancer. J. Mol. Cell Biol., 2014, 6(3), 181-191.
[http://dx.doi.org/10.1093/jmcb/mju013] [PMID: 24721780]
[5]
Krawczyk, M.; Emerson, B.M. p50-associated COX-2 extragenic RNA (PACER) activates COX-2 gene expression by occluding repressive NF-κB complexes. eLife, 2014, 3, e01776.
[http://dx.doi.org/10.7554/eLife.01776] [PMID: 24843008]
[6]
Liu, B.; Sun, L.; Liu, Q.; Gong, C.; Yao, Y.; Lv, X.; Lin, L.; Yao, H.; Su, F.; Li, D.; Zeng, M.; Song, E. A cytoplasmic NF-κB interacting long noncoding RNA blocks IκB phosphorylation and suppresses breast cancer metastasis. Cancer Cell, 2015, 27(3), 370-381.
[http://dx.doi.org/10.1016/j.ccell.2015.02.004] [PMID: 25759022]
[7]
Rapicavoli, N.A.; Qu, K.; Zhang, J.; Mikhail, M.; Laberge, R.M.; Chang, H.Y. A mammalian pseudogene lncRNA at the interface of inflammation and anti-inflammatory therapeutics. eLife, 2013, 2, e00762.
[http://dx.doi.org/10.7554/eLife.00762] [PMID: 23898399]
[8]
Peng, W-X.; Koirala, P.; Mo, Y-Y. LncRNA-mediated regulation of cell signaling in cancer. Oncogene, 2017, 36(41), 5661-5667.
[http://dx.doi.org/10.1038/onc.2017.184] [PMID: 28604750]
[9]
Khalil, B.D.; Sanchez, R.; Rahman, T.; Rodriguez-Tirado, C.; Moritsch, S.; Martinez, A.R.; Miles, B.; Farias, E.; Mezei, M.; Nobre, A.R.; Singh, D.; Kale, N.; Sproll, K.C.; Sosa, M.S.; Aguirre-Ghiso, J.A. An NR2F1-specific agonist suppresses metastasis by inducing cancer cell dormancy. J. Exp. Med., 2022, 219(1), e20210836.
[http://dx.doi.org/10.1084/jem.20210836] [PMID: 34812843]
[10]
Tocco, C.; Bertacchi, M.; Studer, M. Structural and functional aspects of the neurodevelopmental gene NR2F1: From animal models to human pathology. Front. Mol. Neurosci., 2021, 14, 767965.
[http://dx.doi.org/10.3389/fnmol.2021.767965] [PMID: 34975398]
[11]
Bertacchi, M.; Romano, A.L.; Loubat, A.; Tran Mau-Them, F.; Willems, M.; Faivre, L.; Khau van Kien, P.; Perrin, L.; Devillard, F.; Sorlin, A.; Kuentz, P.; Philippe, C.; Garde, A.; Neri, F.; Di Giaimo, R.; Oliviero, S.; Cappello, S.; D’Incerti, L.; Frassoni, C.; Studer, M. NR2F1 regulates regional progenitor dynamics in the mouse neocortex and cortical gyrification in BBSOAS patients. EMBO J., 2020, 39(13), e104163.
[http://dx.doi.org/10.15252/embj.2019104163] [PMID: 32484994]
[12]
Sosa, M.S.; Parikh, F.; Maia, A.G.; Estrada, Y.; Bosch, A.; Bragado, P.; Ekpin, E.; George, A.; Zheng, Y.; Lam, H.M.; Morrissey, C.; Chung, C.Y.; Farias, E.F.; Bernstein, E.; Aguirre-Ghiso, J.A. NR2F1 controls tumour cell dormancy via SOX9- and RARβ-driven quiescence programmes. Nat. Commun., 2015, 6(1), 6170.
[http://dx.doi.org/10.1038/ncomms7170] [PMID: 25636082]
[13]
Rusk, N. Understanding noncoding RNAs. Nat. Methods, 2015, 12(1), 35-35.
[http://dx.doi.org/10.1038/nmeth.3235] [PMID: 25699315]
[14]
Huang, H.; Chen, J.; Ding, C.M.; Jin, X.; Jia, Z.M.; Peng, J. Lnc RNA NR 2F1- AS 1 regulates hepatocellular carcinoma oxaliplatin resistance by targeting ABCC 1 via miR-363. J. Cell. Mol. Med., 2018, 22(6), 3238-3245.
[http://dx.doi.org/10.1111/jcmm.13605] [PMID: 29602203]
[15]
Ren, P.; Zhang, H.; Chang, L.; Hong, X.D.; Xing, L. LncRNA NR2F1-AS1 promotes proliferation and metastasis of ESCC cells via regulating EMT. Eur. Rev. Med. Pharmacol. Sci., 2020, 24(7), 3686-3693.
[http://dx.doi.org/10.26355/eurrev_202004_20831] [PMID: 32329844]
[16]
Zhang, Y.; Zheng, A.; Xu, R.; Zhou, F.; Hao, A.; Yang, H.; Yang, P. NR2F1-induced NR2F1-AS1 promotes esophageal squamous cell carcinoma progression via activating Hedgehog signaling pathway. Biochem. Biophys. Res. Commun., 2019, 519(3), 497-504.
[http://dx.doi.org/10.1016/j.bbrc.2019.09.015] [PMID: 31530388]
[17]
Guo, F.; Fu, Q.; Wang, Y.; Sui, G. Long non-coding RNA NR2F1-AS1 promoted proliferation and migration yet suppressed apoptosis of thyroid cancer cells through regulating miRNA-338-3p/ CCND1 axis. J. Cell. Mol. Med., 2019, 23(9), 5907-5919.
[http://dx.doi.org/10.1111/jcmm.14386] [PMID: 31304680]
[18]
Yang, C.; Liu, Z.; Chang, X.; Xu, W.; Gong, J.; Chai, F.; Cui, D. NR2F1-AS1 regulated miR-423-5p/SOX12 to promote proliferation and invasion of papillary thyroid carcinoma. J. Cell. Biochem., 2020, 121(2), 2009-2018.
[http://dx.doi.org/10.1002/jcb.29435] [PMID: 31692033]
[19]
Zhang, C.; Wu, S.; Song, R.; Liu, C. Long noncoding RNA NR2F1-AS1 promotes the malignancy of non-small cell lung cancer via sponging microRNA-493-5p and thereby increasing ITGB1 expression. Aging, 2021, 13(5), 7660-7675.
[http://dx.doi.org/10.18632/aging.103564] [PMID: 32784268]
[20]
Zhang, Q.; Li, T.; Wang, Z.; Kuang, X.; Shao, N.; Lin, Y. lncRNA NR2F1-AS1 promotes breast cancer angiogenesis through activating IGF-1/IGF-1R/ERK pathway. J. Cell. Mol. Med., 2020, 24(14), 8236-8247.
[http://dx.doi.org/10.1111/jcmm.15499] [PMID: 32548873]
[21]
Liu, L.; Zhao, H.; He, H.H.; Huang, J.; Xu, Y.Y.; Li, X.L.; Wu, Y.; Wang, J.; Zhu, Y.B. Long non-coding RNA NR2F1-AS1 promoted neuroblastoma progression through miR-493-5p/TRIM2 axis. Eur. Rev. Med. Pharmacol. Sci., 2020, 24(24), 12748-12756.
[http://dx.doi.org/10.26355/eurrev_202012_24174] [PMID: 33378023]
[22]
Wang, L.; Zhao, S.; Mingxin, Y.U. LncRNA NR2F1-AS1 is involved in the progression of endometrial cancer by sponging miR-363 to target SOX4. Pharmazie, 2019, 74(5), 295-300.
[http://dx.doi.org/10.1691/ph.2019.8905] [PMID: 31109400]
[23]
Peng, J.; Hou, F.; Zhu, W.; Li, J.; Teng, Z. lncRNA NR2F1-AS1 regulates miR-17/SIK1 axis to suppress the invasion and migration of cervical squamous cell carcinoma cells. Reprod. Sci., 2020, 27(7), 1534-1539.
[http://dx.doi.org/10.1007/s43032-020-00149-y] [PMID: 31994002]
[24]
Zuo, F.; Zhang, Y.; Li, J.; Yang, S.; Chen, X. Long noncoding RNA NR2F1-AS1 plays a carcinogenic role in gastric cancer by recruiting transcriptional factor SPI1 to upregulate ST8SIA1 expression. Bioengineered, 2021, 12(2), 12345-12356.
[http://dx.doi.org/10.1080/21655979.2021.2001168] [PMID: 34738863]
[25]
Liao, X.; Wen, L.; Luo, L. The effect and mechanism of lncRNA NR2F1-As1/miR-493-5p/MAP3K2 axis in the progression of gastric cancer. J. Oncol., 2021, 2021, 3881932.
[http://dx.doi.org/10.1155/2021/3881932] [PMID: 34335755]
[26]
Lv, J.; Zhang, S.; Liu, Y.; Li, C.; Guo, T.; Zhang, S.; Li, Z.; Jiao, Z.; Sun, H.; Zhang, Y.; Xu, L. NR2F1-AS1/miR-190a/PHLDB2 induces the epithelial–mesenchymal transformation process in gastric cancer by promoting phosphorylation of AKT3. Front. Cell Dev. Biol., 2021, 9, 688949.
[http://dx.doi.org/10.3389/fcell.2021.688949] [PMID: 34746118]
[27]
Ferlay, J.; Soerjomataram, I.; Dikshit, R.; Eser, S.; Mathers, C.; Rebelo, M.; Parkin, D.M.; Forman, D.; Bray, F. Cancer incidence and mortality worldwide: Sources, methods and major patterns in GLOBOCAN 2012. Int. J. Cancer, 2015, 136(5), E359-E386.
[http://dx.doi.org/10.1002/ijc.29210] [PMID: 25220842]
[28]
Chmielik, E.; Rusinek, D.; Oczko-Wojciechowska, M.; Jarzab, M.; Krajewska, J.; Czarniecka, A.; Jarzab, B. Heterogeneity of thyroid cancer. Pathobiology, 2018, 85(1-2), 117-129.
[http://dx.doi.org/10.1159/000486422]
[29]
Cheng, L.; Zhou, R.; Chen, M.; Feng, L.; Li, H. MicroRNA-150 targets Rho-associated protein kinase 1 to inhibit cell proliferation, migration and invasion in papillary thyroid carcinoma. Mol. Med. Rep., 2017, 16(2), 2217-2224.
[http://dx.doi.org/10.3892/mmr.2017.6842] [PMID: 28656254]
[30]
Carling, T.; Udelsman, R. Thyroid cancer. Annu. Rev. Med., 2014, 65(1), 125-137.
[http://dx.doi.org/10.1146/annurev-med-061512-105739] [PMID: 24274180]
[31]
Vasileiadis, I.; Boutzios, G.; Karalaki, M.; Misiakos, E.; Karatzas, T. Papillary thyroid carcinoma of the isthmus: Total thyroidectomy or isthmusectomy? Am. J. Surg., 2018, 216(1), 135-139.
[http://dx.doi.org/10.1016/j.amjsurg.2017.09.008] [PMID: 28954712]
[32]
Bray, F.; Ferlay, J.; Soerjomataram, I.; Siegel, R.L.; Torre, L.A.; Jemal, A. Global cancer statistics 2018: GLOBOCAN estimates of incidence and mortality worldwide for 36 cancers in 185 countries. CA Cancer J. Clin., 2018, 68(6), 394-424.
[http://dx.doi.org/10.3322/caac.21492] [PMID: 30207593]
[33]
Weis, S.M.; Cheresh, D.A. Tumor angiogenesis: Molecular pathways and therapeutic targets. Nat. Med., 2011, 17(11), 1359-1370.
[http://dx.doi.org/10.1038/nm.2537] [PMID: 22064426]
[34]
Sato, Y. Molecular diagnosis of tumor angiogenesis and anti-angiogenic cancer therapy. Int. J. Clin. Oncol., 2003, 8(4), 200-206.
[http://dx.doi.org/10.1007/s10147-003-0342-8] [PMID: 12955574]
[35]
Nakagawara, A.; Li, Y.; Izumi, H.; Muramori, K.; Inada, H.; Nishi, M. Neuroblastoma. Jpn. J. Clin. Oncol., 2018, 48(3), 214-241.
[http://dx.doi.org/10.1093/jjco/hyx176] [PMID: 29378002]
[36]
Ke, X.X.; Zhang, D.; Zhao, H.; Hu, R.; Dong, Z.; Yang, R.; Zhu, S.; Xia, Q.; Ding, H.F.; Cui, H. Phox2B correlates with MYCN and is a prognostic marker for neuroblastoma development. Oncol. Lett., 2015, 9(6), 2507-2514.
[http://dx.doi.org/10.3892/ol.2015.3088] [PMID: 26137098]
[37]
Yeramian, A.; Moreno-Bueno, G.; Dolcet, X.; Catasus, L.; Abal, M.; Colas, E.; Reventos, J.; Palacios, J.; Prat, J.; Matias-Guiu, X. Endometrial carcinoma: Molecular alterations involved in tumor development and progression. Oncogene, 2013, 32(4), 403-413.
[http://dx.doi.org/10.1038/onc.2012.76] [PMID: 22430211]
[38]
Cohen, P.A.; Jhingran, A.; Oaknin, A.; Denny, L. Cervical cancer. Lancet, 2019, 393(10167), 169-182.
[http://dx.doi.org/10.1016/S0140-6736(18)32470-X] [PMID: 30638582]
[39]
Imounga, L.M.; Plenet, J.; Belliardo, S.; Chine, E.C.; Louvel, D.; Cenciu, B.; Couppié, P.; Alsibai, K.D.; Nacher, M. Gastric cancer incidence and mortality in french guiana: South American or french? J. Gastrointest. Cancer, 2022, 53(1), 204-210.
[http://dx.doi.org/10.1007/s12029-020-00572-z] [PMID: 33411259]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version332msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[21:37:47] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[21:37:47] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[21:37:47] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[21:37:47] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[21:37:47] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (95.27ms)time
  • Application (237ms)time
  • 1 x Application (71.32%)
    237ms
    1 x Booting (28.68%)
    95.27ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    36 statements were executed, 4 of which were duplicates, 32 unique. Show only duplicated143ms
    • 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 ('873421719','',1,1740346667,1740346667) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740346667
      1.08msalphaeurekaselec_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 ('873421719','/article/128810',1,1740346667,1740346667)
      170μ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 >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) 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 >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) 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 >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) 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 >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) 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 >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) 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 >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 873421719 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873421719) limit 1
      11.32msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 873421719
      • 1: 873421719
      • 2: 873421719
      • 3: 873421719
      • 4: 873421719
      • 5: 873421719
      • 6: 873421719
      • 7: 873421719
      • 8: 873421719
      • 9: 873421719
      • 10: 873421719
      • 11: 873421719
      • 12: 873421719
      • 13: 873421719
      • 14: 873421719
      • 15: 873421719
      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=128810
      710μsalphaeurekaselec_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` = 25 limit 1
      800μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 25
      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=25) and sj.journal_id!=25 group by `j`.`nid`) as `aggregate_table`
      1.37msalphaeurekaselec_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=25) and sj.journal_id!=25 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.13msalphaeurekaselec_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=25) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      3.35msalphaeurekaselec_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=25) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      2.78msalphaeurekaselec_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` = '128810'
      190μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 128810
      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` = '128810'
      3.07msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 128810
      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` = '128810' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.88msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 128810
      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
      250μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      650μsalphaeurekaselec_live_10_06_2022Article.php#1960
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1960
      • 14. app/Http/Controllers/ArticleController.php:2062
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • Select j.subtitle, v.volume_id as volume_id,v.year_id,y.year as year,v.volume_name, v.total_no_of_issues, i.issue_id as issue_id,i.title as issue, i.publication_date as issue_pub_date from journal j join volume v on j.journal_id = v.journal_id join issue i on v.volume_id = i.volume_id join article a on a.issue_id = i.issue_id join year y on v.year_id = y.id where j.journal_id = 25 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      30.46msalphaeurekaselec_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 = 25 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      33.85msalphaeurekaselec_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 = 25 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      26.71msalphaeurekaselec_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` = 128810 limit 1
      220μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 128810
      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 = 128810 and content_type = 'article' order by status desc limit 1
      270μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 212668 limit 1
      200μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 212668
      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` = 'CMC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      360μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CMC
      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 = '128810' 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) )
      370μ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 = '12568' 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) )
      310μ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 = '3321' 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) )
      270μ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 <= 873421719 and j.to_ip >=873421719 )) and ((j.from_date <= 1740346667 and j.to_date >= 1740346667 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3321) 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 <= 873421719 and j.to_ip >=873421719 )) and ((j.from_date <= 1740346667 and j.to_date >= 1740346667 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3321) 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 <= 873421719 and j.to_ip >=873421719 )) and ((j.from_date <= 1740346667 and j.to_date >= 1740346667 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3321)
      9.41msalphaeurekaselec_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 <= 873421719 and j.to_ip >=873421719 )) and ((j.from_date <= 1740346667 and j.to_date >= 1740346667 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12568) 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 <= 873421719 and j.to_ip >=873421719 )) and ((j.from_date <= 1740346667 and j.to_date >= 1740346667 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12568) 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 <= 873421719 and j.to_ip >=873421719 )) and ((j.from_date <= 1740346667 and j.to_date >= 1740346667 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12568)
      950μ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 <= 873421719 and j.to_ip >=873421719 )) and ((j.from_date <= 1740346667 and j.to_date >= 1740346667 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 128810) 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 <= 873421719 and j.to_ip >=873421719 )) and ((j.from_date <= 1740346667 and j.to_date >= 1740346667 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 128810) 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 <= 873421719 and j.to_ip >=873421719 )) and ((j.from_date <= 1740346667 and j.to_date >= 1740346667 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 128810)
      900μ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` < '4266' and is_uploaded = 1 and issue_id = 12568 order by cast(first_page as SIGNED) desc limit 1
      670μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 4266
      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` > '4276' and is_uploaded = 1 and issue_id = 12568 order by cast(first_page as SIGNED) asc limit 1
      570μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 4276
      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'
      260μ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
      330μ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` = 128810 limit 1
      3.89msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 128810
      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` = 25 and `b`.`banner_from_date` <= 1740346667 and `b`.`banner_to_date` >= 1740346667 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.73msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 25
      • 3: 1740346667
      • 4: 1740346667
      • 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` = 25 and `b`.`banner_from_date` <= 1740346667 and `b`.`banner_to_date` >= 1740346667 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.64msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 25
      • 3: 1740346667
      • 4: 1740346667
      • 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='6828ccc485a33df0789acb8fa3577364'
      320μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        AugjmE8l7JCDU0eJSum96QkRdUGXOWoV7kkv8D84
        uc_cart_id
        6828ccc485a33df0789acb8fa3577364
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/128810" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/128810
        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=eyJpdiI6ImxDYlY3TGhlcmFMeENNMkFOa1pwU2c9PSIsInZhbHVlIjoibktaTHFTc21xTXN3TUhWVE0wU0Nqb3Y4NlAzbGQvSlFiNG9XNEZCVEYxST0iLCJtYWMiOiIyNTFhYzZjOTgzZjVlYTNiYjE3ZDQ3Mjc2NDhjNmJmNmVjNWYxNmM3Y2YxNmZjMzY4ZjdkNzBhMjc0NzQyNjlkIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6ImxDYlY3TGhlcmFMeENNMkFOa1pwU2c9PSIsInZhbHVlIjoibktaTHFTc21xTXN3TUhWVE0wU0Nqb3Y4NlAzbGQvSlFiNG9XNEZCVEYxST0iLCJtYWMiOiIyNTFhYzZjOTgzZjVl" ] "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 => "Sun, 23 Feb 2025 21:37:47 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ink0eGIrZHZ1SFVDYWowN3B2QXh1WGc9PSIsInZhbHVlIjoiem1HQnhqaW1hVDBiVlpnK3drbkFDdktSbmpodU9DRVhibW5NemV2enFCNkNxaVRGTTNjTy96d2ZFNHJhYjVFSWFOUGRnWWxwTFQrRmJPQ0hMTEZHWm16M0ZHZUNPYUkzQnlLN0crZnFBaEordnBnWGNGOFZ1WkVjbDdaaENxKzQiLCJtYWMiOiIxZWFlN2QzNWUyOWYyYTk0YjFmNjJlYTYxODNiODVlMGFkNGI5ZTlkOGNiZDkwYTI1M2NmZDcyYWZlNjU2YWJmIiwidGFnIjoiIn0%3D; expires=Wed, 26 Feb 2025 09:37:47 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ink0eGIrZHZ1SFVDYWowN3B2QXh1WGc9PSIsInZhbHVlIjoiem1HQnhqaW1hVDBiVlpnK3drbkFDdktSbmpodU9DRVhibW5NemV2enFCNkNxaVRGTTNjTy96d2ZFNHJhYjVFSWFOUGRnW" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkozQXdMSTF4NDVadWtoaW9hcGljVWc9PSIsInZhbHVlIjoiMGcwcEJ5cUZDMVd0cW00OU9aa05yd1VnMmw1MlcyZnEzSmhHN0dHdTFoc3g4WEcxQmU1cXp6QUdhTlVtUFU5MXJPckxmUFNVVEtic0JRUFZNclpRbjR3L0lreFlzdlk5d0hrNjRPdjZkbXdJclhLNjRFMEI5SUw0a1l0eVJMNk8iLCJtYWMiOiJkOTEwNDBiNzkzOWQzYTU5MDYzMWE1NDkyOTkzYzYxNmRjN2E3ZGNmN2U0YzQ1ZmI1ZmEwYjRhNjVkZmE2ODRmIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkozQXdMSTF4NDVadWtoaW9hcGljVWc9PSIsInZhbHVlIjoiMGcwcEJ5cUZDMVd0cW00OU9aa05yd1VnMmw1MlcyZnEzSmhHN0dHdTFoc3g4WEcxQmU1cXp6QUd" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ink0eGIrZHZ1SFVDYWowN3B2QXh1WGc9PSIsInZhbHVlIjoiem1HQnhqaW1hVDBiVlpnK3drbkFDdktSbmpodU9DRVhibW5NemV2enFCNkNxaVRGTTNjTy96d2ZFNHJhYjVFSWFOUGRnWWxwTFQrRmJPQ0hMTEZHWm16M0ZHZUNPYUkzQnlLN0crZnFBaEordnBnWGNGOFZ1WkVjbDdaaENxKzQiLCJtYWMiOiIxZWFlN2QzNWUyOWYyYTk0YjFmNjJlYTYxODNiODVlMGFkNGI5ZTlkOGNiZDkwYTI1M2NmZDcyYWZlNjU2YWJmIiwidGFnIjoiIn0%3D; expires=Wed, 26-Feb-2025 09:37:47 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ink0eGIrZHZ1SFVDYWowN3B2QXh1WGc9PSIsInZhbHVlIjoiem1HQnhqaW1hVDBiVlpnK3drbkFDdktSbmpodU9DRVhibW5NemV2enFCNkNxaVRGTTNjTy96d2ZFNHJhYjVFSWFOUGRnW" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkozQXdMSTF4NDVadWtoaW9hcGljVWc9PSIsInZhbHVlIjoiMGcwcEJ5cUZDMVd0cW00OU9aa05yd1VnMmw1MlcyZnEzSmhHN0dHdTFoc3g4WEcxQmU1cXp6QUdhTlVtUFU5MXJPckxmUFNVVEtic0JRUFZNclpRbjR3L0lreFlzdlk5d0hrNjRPdjZkbXdJclhLNjRFMEI5SUw0a1l0eVJMNk8iLCJtYWMiOiJkOTEwNDBiNzkzOWQzYTU5MDYzMWE1NDkyOTkzYzYxNmRjN2E3ZGNmN2U0YzQ1ZmI1ZmEwYjRhNjVkZmE2ODRmIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkozQXdMSTF4NDVadWtoaW9hcGljVWc9PSIsInZhbHVlIjoiMGcwcEJ5cUZDMVd0cW00OU9aa05yd1VnMmw1MlcyZnEzSmhHN0dHdTFoc3g4WEcxQmU1cXp6QUd" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "AugjmE8l7JCDU0eJSum96QkRdUGXOWoV7kkv8D84" "uc_cart_id" => "6828ccc485a33df0789acb8fa3577364" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/128810" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-23 21:37:47GET/article/128810514361