Generic placeholder image

Combinatorial Chemistry & High Throughput Screening

Editor-in-Chief

ISSN (Print): 1386-2073
ISSN (Online): 1875-5402

Research Article

Virtual Screening of the Multi-pathway and Multi-gene Regulatory Molecular Mechanism of Dachengqi Decoction in the Treatment of Stroke Based on Network Pharmacology

Author(s): Lishan Pei, Xia Shen, Yonggang Yan*, Conge Tan*, Kai Qu, Junbo Zou, Yanxia Wang and Fan Ping

Volume 23, Issue 8, 2020

Page: [775 - 787] Pages: 13

DOI: 10.2174/1386207323666200311113747

Price: $65

Abstract

Background: Stroke is ranked second among diseases that cause mortality worldwide. Owing to its complicated pathogenesis, no satisfactory treatment strategies for stroke are available. Dachengqi decoction (DCQD), a traditional Chinese herbal medicine, has been widely used in China for a long time, as it has a good effect on stroke. However, the molecular mechanism underlying this effect of DCQD is unclear.

Objective: In the present study, we aimed to reveal and explore the multi-pathway and multi-gene regulatory molecular mechanism of Dachengqi decoction in the treatment of stroke.

Methods: In this study, a network pharmacology method, in combination with oral bioavailability prediction and drug-likeness evaluation, was employed to predict the active ingredients of DCQD. The target genes of the active components and the traced pathways related to these target genes were predicted. Gene Ontology (GO) enrichment and Kyoto Encyclopedia of Genes and Genomes (KEGG) pathway analyses were performed using clusterProfiler software package on the R platform and ClueGo+CluePedia plug-ins. Finally, the key DCQD targets were verified using the Gene Expression Omnibus (GEO) dataset.

Results and Discussion: According to the ADME model, 52 active components were screened from 296 active components of DCQD. After prediction and screening, 215 stroke-related targets were obtained and analyzed via GO and KEGG analyses. GO analysis showed that DCQD targets were mainly involved in the regulation of oxidative stress, lipid metabolism, inflammation, and other biological processes. KEGG pathway analysis further revealed pathways involved in stroke, such as arachidonic acid metabolic, HIF-1 signaling pathway, estrogen signaling pathway, MAPK signaling pathway, PI3K-Akt signaling pathway, platelet activation pathway, VEGF signaling pathway, and cAMP signaling pathway. Network analysis revealed that DCQD might be involved in the regulation of lipid metabolism, blood pressure, inflammation, angiogenesis, neuroprotection, platelet aggregation, apoptosis, and oxidation in stroke treatment. GEO dataset analysis showed that DCQD’s therapeutic effects might be exerted via the bidirectional regulation principle.

Conclusion: Based on the methods of network pharmacology and GEO analysis, it was found that, during stroke treatment, DCQD regulates and controls multiple genes and multiple pathways in a synergistic manner, providing a new strategy for stroke treatment.

Keywords: Dachengqi decoction, ADME, stroke, molecular mechanism, bidirectional regulation, GEO verified.

[1]
Cao, H.Q.; Chen, G.; Dong, E.D. Ten-year review of cerebrovascular disease research funded by the national natural science foundation of China. Chin. J. Neurosurg., 2013, 29, 541-542.
[2]
Hou, S.; Zhang, H.; Li, B.; Luo, Y.; Han, Z.; Shang, S. Validation and evaluation of the core nursing outcomes evaluation system for inpatients with stroke. Int. J. Nurs. Knowl., 2019, 2019, 1-7.
[http://dx.doi.org/10.1111/2047-3095.12259 ] [PMID: 31697041]
[3]
Johnson, C.O.; Nguyen, M.; Roth, G.A. GBD 2016 Stroke Collaborators. Global, regional, and national burden of stroke, 1990-2016: a systematic analysis for the Global Burden of Disease Study 2016. Lancet Neurol., 2019, 18(5), 439-458.
[http://dx.doi.org/10.1016/S1474-4422(19)30034-1 ] [PMID: 30871944]
[4]
Owens, B. Stroke. Nature, 2014, 510(7506), S1.
[http://dx.doi.org/10.1038/510S1a ] [PMID: 24964020]
[5]
Sacco, R.L.; Dong, C. Declining stroke incidence and improving survival in US communities: evidence for success and future challenges. JAMA, 2014, 312(3), 237-238.
[http://dx.doi.org/10.1001/jama.2014.7693 ] [PMID: 25027138]
[6]
Wang, J.Q.; Wang, B.L.; Yang, W.Q. Clinical observation on treatment of 30 cases of large area Cerebral Infarction with Dachengqi decoction. J. Emerg. Tradit. Chin. Med., 2009, 18(3), 348-371.
[7]
Ming, K. W.; Hong, C. X. Study on the mechanism of Dachengqi Decoction in treating acute cerebral hemorrhage. Chinese J. Integr. Med. Cardio-/Cerebrovascuiar Dis., 2006, 4(11), 986-987.
[8]
Hopkins, A.L. Network pharmacology. Nat. Biotechnol., 2007, 25(10), 1110-1111.
[http://dx.doi.org/10.1038/nbt1007-1110 ] [PMID: 17921993]
[9]
Hopkins, A.L. Network pharmacology: the next paradigm in drug discovery. Nat. Chem. Biol., 2008, 4(11), 682-690.
[http://dx.doi.org/10.1038/nchembio.118 ] [PMID: 18936753]
[10]
Shen, X.; Zhao, Z.; Luo, X.; Wang, H.; Hu, B.; Guo, Z. Systems pharmacology based study of the molecular mechanism of SiNiSan formula for application in nervous and mental diseases. Evid. Based Complement. Alternat. Med., 2016, 2016, 9146378.
[http://dx.doi.org/10.1155/2016/9146378 ] [PMID: 28058059]
[11]
Shen, X.; Zhao, Z.; Wang, H.; Guo, Z.; Hu, B.; Zhang, G. Elucidation of the anti-inflammatory mechanisms of bupleuri and scutellariae radix using system pharmacological analyses. Mediators Inflamm., 2017, 2017, 3709874.
[http://dx.doi.org/10.1155/2017/3709874 ] [PMID: 28190938]
[12]
Stamova, B.; Jickling, G.C.; Ander, B.P.; Zhan, X.; Liu, D.; Turner, R.; Ho, C.; Khoury, J.C.; Bushnell, C.; Pancioli, A.; Jauch, E.C.; Broderick, J.P.; Sharp, F.R. Gene expression in peripheral immune cells following cardioembolic stroke is sexually dimorphic. PLoS One, 2014, 9(7), e102550.
[http://dx.doi.org/10.1371/journal.pone.0102550 ] [PMID: 25036109]
[13]
Zou, R.; Zhang, D.; Lv, L.; Shi, W.; Song, Z.; Yi, B.; Lai, B.; Chen, Q.; Yang, S.; Hua, P. Bioinformatic gene analysis for potential biomarkers and therapeutic targets of atrial fibrillation-related stroke. J. Transl. Med., 2019, 17(1), 45.
[http://dx.doi.org/10.1186/s12967-019-1790-x ] [PMID: 30760287]
[14]
Xu, X.; Zhang, W.; Huang, C.; Li, Y.; Yu, H.; Wang, Y.; Duan, J.; Ling, Y. A novel chemometric method for the prediction of human oral bioavailability. Int. J. Mol. Sci., 2012, 13(6), 6964-6982.
[http://dx.doi.org/10.3390/ijms13066964 ] [PMID: 22837674]
[15]
Tao, W.; Xu, X.; Wang, X.; Li, B.; Wang, Y.; Li, Y.; Yang, L. Network pharmacology-based prediction of the active ingredients and potential targets of Chinese herbal Radix Curcumae formula for application to cardiovascular disease. J. Ethnopharmacol., 2013, 145(1), 1-10.
[http://dx.doi.org/10.1016/j.jep.2012.09.051 ] [PMID: 23142198]
[16]
Yang, S.Z. The Divine Farmers Materia Medica:(A Translation of the Shen Nong Ben Cao Jing); Blue Poppy Press: Boulder, Colorado, 1997.
[17]
Veith, L. The Yellow Emperor’s Classic of Internal Medicine, New ed; Berkeley and Los Angeles: University of California Press: Back Cover, 1972.
[18]
Li, Z.G.; Liu, X.R. Yellow Emperor’s Canon of Medicine Plain Conversation, World Book Inc.: Xi’ an, Shaanxi, 2005.
[19]
Cavalieri, S.; Rotoli, M. Huangdi Neijing: a classic book of traditional Chinese medicine. Recenti Prog. Med., 1997, 88(11), 541-546.
[PMID: 9446158]
[20]
Hao, Y.F.; Jiang, J.G. Origin and evolution of China Pharmacopoeia and its implication for traditional medicines. Mini Rev. Med. Chem., 2015, 15(7), 595-603.
[http://dx.doi.org/10.2174/1389557515666150415150803 ] [PMID: 25877600]
[21]
Gao, C.; Zhu, J.P. On ‘apoplexy’ in Chinese ancient medical books. Chin J. Tradit. Chin. Med. Pharm., 2014, 29(5), 1298-1303.
[22]
Tian, Y.Q.; Ding, P. Summary of pharmacological clinical and pharmaceutical research of dachengqi decoction. Zhonghua Zhongyiyao Xuekan, 2006, 24(11), 2134-2135.
[23]
Li, X.; Chu, S.; Liu, Y.; Chen, N. Neuroprotective effects of anthraquinones from rhubarb in central nervous system diseases. Evid. Based Complement. Alternat. Med., 2019, 2019, 3790728.
[http://dx.doi.org/10.1155/2019/3790728 ] [PMID: 31223328]
[24]
Li, M.; Du, Z.M. Research progress on pharmacological effects of aloe-emodin. Zhongguo Lin Chuang Yao Li Xue Za Zhi, 2015, 31(9), 765-768.
[25]
Tan, P.; Zhang, H.Z.; Li, Y.; Zhang, D.K.; Wang, J.B.; Xiao, X.H.; Liu, M. Preliminary study on antiplatelet aggregation of 10 anthraquinones in Rhei Radix et Rhizoma based on bioassay. Chin. Tradit. Herbal Drugs, 2018, 49(04), 859-865.
[26]
Zhang, S.J.; Zhong, L.Y. Research progress on chemical constituents and modern pharmacology of Magnolia officinalis. Zhong Yao Cai, 2013, 36(5), 838-843.
[27]
Liu, Y.P. Main ingredients of Mangnolia officinalis and general situation of its pharmacological action research. Chem. Intermediate., 2017, 5, 141-142.
[28]
Zhang, X.X.; Li, Z.Y.; Ma, Y.L.; Ma, S.C. Progress in research of traditional Chinese medicine Citrus aurantium. Zhongguo Zhongyao Zazhi, 2015, 40(2), 185-190.
[PMID: 26080542]
[29]
Zhang, L.; Zhang, X.; Zhang, C.; Bai, X.; Zhang, J.; Zhao, X.; Chen, L.; Wang, L.; Zhu, C.; Cui, L.; Chen, R.; Zhao, T.; Zhao, Y. Nobiletin promotes antioxidant and anti-inflammatory responses and elicits protection against ischemic stroke in vivo. Brain Res., 2016, 1636, 130-141.
[http://dx.doi.org/10.1016/j.brainres.2016.02.013 ] [PMID: 26874072]
[30]
Gao, H.H.; Gao, L.B.; Wen, J.M. Genetic polymorphisms in the ESR1 gene and cerebral infarction risk: a meta-analysis. DNA Cell Biol., 2014, 33(9), 605-615.
[http://dx.doi.org/10.1089/dna.2013.2270 ] [PMID: 24772998]
[31]
Castellano-Castillo, D.; Moreno-Indias, I.; Sanchez-Alcoholado, L.; Ramos-Molina, B.; Alcaide-Torres, J.; Morcillo, S.; Ocaña-Wilhelmi, L.; Tinahones, F.; Queipo-Ortuño, M.I.; Cardona, F. Altered adipose tissue DNA methylation status in metabolic syndrome: relationships between global dna methylation and specific methylation at adipogenic, lipid metabolism and inflammatory candidate genes and metabolic variables. J. Clin. Med., 2019, 8(1), 1-17.
[http://dx.doi.org/10.3390/jcm8010087 ] [PMID: 30642114]
[32]
Feige, J.N.; Gelman, L.; Michalik, L.; Desvergne, B.; Wahli, W. From molecular action to physiological outputs: peroxisome proliferator-activated receptors are nuclear receptors at the crossroads of key cellular functions. Prog. Lipid Res., 2006, 45(2), 120-159.
[http://dx.doi.org/10.1016/j.plipres.2005.12.002 ] [PMID: 16476485]
[33]
Zhao, J.; Lv, C.; Wu, Q.; Zeng, H.; Guo, X.; Yang, J.; Tian, S.; Zhang, W. Computational systems pharmacology reveals an antiplatelet and neuroprotective mechanism of Deng-Zhan-Xi-Xin injection in the treatment of ischemic stroke. Pharmacol. Res., 2019, 147, 104365.
[http://dx.doi.org/10.1016/j.phrs.2019.104365] [PMID: 31348992]
[34]
Oh, S.H.; Min, K.T.; Jeon, Y.J.; Kim, M.H.; Moon, J.S.; Kim, H.S.; Kim, W.C.; Kim, O.J.; Park, E.K.; Kim, N.K. Association between kinase insert domain-containing receptor gene polymorphism and haplotypes and ischemic stroke. J. Neurol. Sci., 2011, 308(1-2), 62-66.
[http://dx.doi.org/10.1016/j.jns.2011.06.012 ] [PMID: 21705026]
[35]
Geiseler, S.J.; Morland, C. The janus face of VEGF in stroke. Int. J. Mol. Sci., 2018, 19(5), 1-20.
[http://dx.doi.org/10.3390/ijms19051362 ] [PMID: 29734653]
[36]
Xu, X.; Bass, B.; McKillop, W.M.; Mailloux, J.; Liu, T.; Geremia, N.M.; Hryciw, T.; Brown, A. Sox9 knockout mice have improved recovery following stroke. Exp. Neurol., 2018, 303, 59-71.
[http://dx.doi.org/10.1016/j.expneurol.2018.02.001 ] [PMID: 29425963]
[37]
Chaturvedi, M.; Kaczmarek, L. Mmp-9 inhibition: a therapeutic strategy in ischemic stroke. Mol. Neurobiol., 2014, 49(1), 563-573.
[http://dx.doi.org/10.1007/s12035-013-8538-z ] [PMID: 24026771]
[38]
Liu, R.; Cao, S.; Hua, Y.; Keep, R.F.; Huang, Y.; Xi, G. CD163 expression in neurons after experimental intracerebral hemorrhage. Stroke, 2017, 48(5), 1369-1375.
[http://dx.doi.org/10.1161/STROKEAHA.117.016850 ] [PMID: 28360115]
[39]
Förstermann, U.; Sessa, W. C. Nitric oxide synthases: regulation and function. Eur Heart J, 2012, 33(7), 829-837-837a-837d.
[http://dx.doi.org/10.1093/eurheartj/ehr304]
[40]
Shi, W.L.; Yuan, R.; Xin, Q.Q.; Jin, Y.; Cong, W.H.; Chen, K.J. Oxidative stress and hypertension. Med. Recapitulate., 2018, 24(4), 642-650.
[41]
Mao, G.; Ren, P.; Wang, G.; Yan, F.; Zhang, Y. MicroRNA-128-3p protects mouse against cerebral ischemia through reducing p38α mitogen-activated protein kinase activity. J. Mol. Neurosci., 2017, 61(2), 152-158.
[http://dx.doi.org/10.1007/s12031-016-0871-z ] [PMID: 27905005]
[42]
Zhao, S.; Wu, D.X.; Chen, X.; Zhang, Y.L. Study on mechanism for treating ischemic stroke of Siegesbeckiae Herba based on network pharmacology. Zhongguo Zhongyao Zazhi, 2019, 44(13), 2727-2735.
[PMID: 31359683]
[43]
Koyuncuoğlu, T.; Arabacı Tamer, S.; Erzik, C.; Karagöz, A.; Akakın, D.; Yüksel, M.; Yeğen, B.Ç. Oestrogen receptor ERα and ERβ agonists ameliorate oxidative brain injury and improve memory dysfunction in rats with an epileptic seizure. Exp. Physiol., 2019, 104(12), 1911-1928.
[http://dx.doi.org/10.1113/EP087986 ] [PMID: 31608530]
[44]
Li, L.; Fan, X.; Zhang, X.T.; Yue, S.Q.; Sun, Z.Y.; Zhu, J.Q.; Zhang, J.H.; Gao, X.M.; Zhang, H. The effects of Chinese medicines on cAMP/PKA signaling in central nervous system dysfunction. Brain Res. Bull., 2017, 132, 109-117.
[http://dx.doi.org/10.1016/j.brainresbull.2017.04.006 ] [PMID: 28438669]
[45]
Chen, X.; Wang, S.Q.; Li, Y.M. Role of thromboxane A2 in ischemic stroke and its relevant drugs. Chin. J. Cardiovasc. Res., 2015, 13(2), 117-120.
[46]
Yu, Z.H.; Cai, M.; Xiang, J.; Zhang, Z.N.; Zhang, J.S.; Song, X.L.; Zhang, W.; Bao, J.; Li, W.W.; Cai, D.F. PI3K/Akt pathway contributes to neuroprotective effect of Tongxinluo against focal cerebral ischemia and reperfusion injury in rats. J. Ethnopharmacol., 2016, 181, 8-19.
[http://dx.doi.org/10.1016/j.jep.2016.01.028 ] [PMID: 26805466]
[47]
McManus, D.D.; Freedman, J.E. MicroRNAs in platelet function and cardiovascular disease. Nat. Rev. Cardiol., 2015, 12(12), 711-717.
[http://dx.doi.org/10.1038/nrcardio.2015.101 ] [PMID: 26149483]
[48]
King, S.M.; McNamee, R.A.; Houng, A.K.; Patel, R.; Brands, M.; Reed, G.L. Platelet dense-granule secretion plays a critical role in thrombosis and subsequent vascular remodeling in atherosclerotic mice. Circulation, 2009, 120(9), 785-791.
[http://dx.doi.org/10.1161/CIRCULATIONAHA.108.845461 ] [PMID: 19687360]
[49]
Giannarelli, C.; Alique, M.; Rodriguez, D.T.; Yang, D.K.; Jeong, D.; Calcagno, C.; Hutter, R.; Millon, A.; Kovacic, J.C.; Weber, T.; Faries, P.L.; Soff, G.A.; Fayad, Z.A.; Hajjar, R.J.; Fuster, V.; Badimon, J.J. Alternatively spliced tissue factor promotes plaque angiogenesis through the activation of hypoxia-inducible factor-1α and vascular endothelial growth factor signaling. Circulation, 2014, 130(15), 1274-1286.
[http://dx.doi.org/10.1161/CIRCULATIONAHA.114.006614 ] [PMID: 25116956]
[50]
Kofler, N.M.; Simons, M. Angiogenesis versus arteriogenesis: neuropilin 1 modulation of VEGF signaling. F1000Prime Rep., 2015, 7, 26.
[http://dx.doi.org/10.12703/P7-26 ] [PMID: 25926977]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version387msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[15:23:30] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[15:23:31] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[15:23:31] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (97.98ms)time
  • Application (289ms)time
  • 1 x Application (74.65%)
    289ms
    1 x Booting (25.35%)
    97.98ms
    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 duplicated218ms
    • 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 ('314520267','',1,1740497010,1740497010) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740497010
      1.05msalphaeurekaselec_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 ('314520267','/article/105143',1,1740497010,1740497010)
      220μ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 >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) 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 >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) 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 >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) 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 >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) 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 >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) 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 >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314520267 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314520267) limit 1
      14.93msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314520267
      • 1: 314520267
      • 2: 314520267
      • 3: 314520267
      • 4: 314520267
      • 5: 314520267
      • 6: 314520267
      • 7: 314520267
      • 8: 314520267
      • 9: 314520267
      • 10: 314520267
      • 11: 314520267
      • 12: 314520267
      • 13: 314520267
      • 14: 314520267
      • 15: 314520267
      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=105143
      920μ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` = 8 limit 1
      760μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 8
      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=8) and sj.journal_id!=8 group by `j`.`nid`) as `aggregate_table`
      1.05msalphaeurekaselec_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=8) and sj.journal_id!=8 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      900μ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=8) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.33msalphaeurekaselec_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=8) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      1.9msalphaeurekaselec_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` = '105143'
      2.46msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 105143
      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` = '105143'
      2.5msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 105143
      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` = '105143' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.09msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 105143
      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
      270μ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
      470μ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 = 8 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      30.02msalphaeurekaselec_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 = 8 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      14.39msalphaeurekaselec_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 = 8 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      12.05msalphaeurekaselec_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` = 105143 limit 1
      1.38msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 105143
      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 = 105143 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 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 = 258 and cd.sub_disease_id = 299 and content_id!=105143 and cd.content_type = 'article' order by rand() limit 20
      80.96msalphaeurekaselec_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` = 180098 limit 1
      230μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 180098
      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
      240μ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` = 'CCHTS' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      350μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CCHTS
      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 = '105143' 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 = '10124' 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) )
      300μ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 = '2700' 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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740497011 and j.to_date >= 1740497011 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2700) 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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740497011 and j.to_date >= 1740497011 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2700) 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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740497011 and j.to_date >= 1740497011 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2700)
      37.68msalphaeurekaselec_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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740497011 and j.to_date >= 1740497011 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10124) 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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740497011 and j.to_date >= 1740497011 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10124) 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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740497011 and j.to_date >= 1740497011 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10124)
      620μ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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740497011 and j.to_date >= 1740497011 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 105143) 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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740497011 and j.to_date >= 1740497011 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 105143) 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 <= 314520267 and j.to_ip >=314520267 )) and ((j.from_date <= 1740497011 and j.to_date >= 1740497011 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 105143)
      600μ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` < '775' and is_uploaded = 1 and issue_id = 10124 order by cast(first_page as SIGNED) desc limit 1
      500μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 775
      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` > '787' and is_uploaded = 1 and issue_id = 10124 order by cast(first_page as SIGNED) asc limit 1
      460μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 787
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'en'
      190μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      230μ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` = 105143 limit 1
      2.36msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 105143
      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` = 8 and `b`.`banner_from_date` <= 1740497011 and `b`.`banner_to_date` >= 1740497011 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.13msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 8
      • 3: 1740497011
      • 4: 1740497011
      • 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` = 8 and `b`.`banner_from_date` <= 1740497011 and `b`.`banner_to_date` >= 1740497011 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.11msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 8
      • 3: 1740497011
      • 4: 1740497011
      • 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='8bcf05101c7e2e3ab7a391dcfa5a4e73'
      230μ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
        F31KG2lq6azYRIPJmKyhVk0Co7869AehUt73zZF6
        uc_cart_id
        8bcf05101c7e2e3ab7a391dcfa5a4e73
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/105143" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/105143
        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=eyJpdiI6IlJqWDZmbEtCMHpVNHU3VUJOdlpMVXc9PSIsInZhbHVlIjoiZHJWajdqUVdTK21Qa2VlbDViOXdQWGtycllVUHNTYktPRWRWQTlQeGUwdz0iLCJtYWMiOiI5MGQ4YmJlNDY4OWNmNmFhODVmN2IzYTQ1YTUyZmI3MzI2ZjE4Y2M4ZjkwOWQwOWNiMDdlNTk1MGJjNGFkOWE0IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IlJqWDZmbEtCMHpVNHU3VUJOdlpMVXc9PSIsInZhbHVlIjoiZHJWajdqUVdTK21Qa2VlbDViOXdQWGtycllVUHNTYktPRWRWQTlQeGUwdz0iLCJtYWMiOiI5MGQ4YmJlNDY4OWNm" ] "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, 25 Feb 2025 15:23:31 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkNFelF2NWdnWGlVU1lncGk3YncwYkE9PSIsInZhbHVlIjoiZWZPbEhzY3lqZ3hWMTdZTkdUMHcxVXFlZ2FCMWsvS0VkS01FRnowb0JZamxRK3lwZ2t6eWpQODlRTlNZS3RrQnd6M1RoQ3dOeXNQTjZyWmgwYS9Ma3FxYnE0a3ZsRUEzTzV3ajYxdjk1ak4vQjRlNGNxNFI4eDRORjhaT3BCSEMiLCJtYWMiOiJiMWM3ZDc0ZTBjYjMzZjNhMTBkNjg5Zjg5M2E0YzA0ZGRlYzk1Y2M3MjZkODlkYzQwMDU1YjM4MmNjYmYxNmNmIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 03:23:31 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkNFelF2NWdnWGlVU1lncGk3YncwYkE9PSIsInZhbHVlIjoiZWZPbEhzY3lqZ3hWMTdZTkdUMHcxVXFlZ2FCMWsvS0VkS01FRnowb0JZamxRK3lwZ2t6eWpQODlRTlNZS3RrQnd6M1RoQ" 1 => "alphaeurekaselectnet_session=eyJpdiI6Im1CQ1pvaUc2UkZKaGYxdzEyNmgyeXc9PSIsInZhbHVlIjoidXdmdDd3MkF5UGNPOFBRaWVLYWNpL0g5cklnZDNkTzM5eGVNUkMvdE96REJtemZIY213bmtsMmRsMlJDZzI5cjdHWUZPZVpoa3dtVXNuMm53M05lbWl2S0xXNGQ0dHFjd05KTVRrek16blhac2pySUdjQUZrdk1rSVBvYmx4QkwiLCJtYWMiOiI5OTM0YzJhZWMwMTI3NGE1MmQzN2ZkNTVjOTJhNjhhM2E5Y2I4NGFiZjQxMTNiMzJlYjQxOGNkZjc0NWIyOTJkIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Im1CQ1pvaUc2UkZKaGYxdzEyNmgyeXc9PSIsInZhbHVlIjoidXdmdDd3MkF5UGNPOFBRaWVLYWNpL0g5cklnZDNkTzM5eGVNUkMvdE96REJtemZIY213bmtsMmR" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkNFelF2NWdnWGlVU1lncGk3YncwYkE9PSIsInZhbHVlIjoiZWZPbEhzY3lqZ3hWMTdZTkdUMHcxVXFlZ2FCMWsvS0VkS01FRnowb0JZamxRK3lwZ2t6eWpQODlRTlNZS3RrQnd6M1RoQ3dOeXNQTjZyWmgwYS9Ma3FxYnE0a3ZsRUEzTzV3ajYxdjk1ak4vQjRlNGNxNFI4eDRORjhaT3BCSEMiLCJtYWMiOiJiMWM3ZDc0ZTBjYjMzZjNhMTBkNjg5Zjg5M2E0YzA0ZGRlYzk1Y2M3MjZkODlkYzQwMDU1YjM4MmNjYmYxNmNmIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 03:23:31 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkNFelF2NWdnWGlVU1lncGk3YncwYkE9PSIsInZhbHVlIjoiZWZPbEhzY3lqZ3hWMTdZTkdUMHcxVXFlZ2FCMWsvS0VkS01FRnowb0JZamxRK3lwZ2t6eWpQODlRTlNZS3RrQnd6M1RoQ" 1 => "alphaeurekaselectnet_session=eyJpdiI6Im1CQ1pvaUc2UkZKaGYxdzEyNmgyeXc9PSIsInZhbHVlIjoidXdmdDd3MkF5UGNPOFBRaWVLYWNpL0g5cklnZDNkTzM5eGVNUkMvdE96REJtemZIY213bmtsMmRsMlJDZzI5cjdHWUZPZVpoa3dtVXNuMm53M05lbWl2S0xXNGQ0dHFjd05KTVRrek16blhac2pySUdjQUZrdk1rSVBvYmx4QkwiLCJtYWMiOiI5OTM0YzJhZWMwMTI3NGE1MmQzN2ZkNTVjOTJhNjhhM2E5Y2I4NGFiZjQxMTNiMzJlYjQxOGNkZjc0NWIyOTJkIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Im1CQ1pvaUc2UkZKaGYxdzEyNmgyeXc9PSIsInZhbHVlIjoidXdmdDd3MkF5UGNPOFBRaWVLYWNpL0g5cklnZDNkTzM5eGVNUkMvdE96REJtemZIY213bmtsMmR" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "F31KG2lq6azYRIPJmKyhVk0Co7869AehUt73zZF6" "uc_cart_id" => "8bcf05101c7e2e3ab7a391dcfa5a4e73" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/105143" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 15:23:31GET/article/105143314371