Generic placeholder image

Current Pharmaceutical Design

Editor-in-Chief

ISSN (Print): 1381-6128
ISSN (Online): 1873-4286

Research Article

Network Pharmacology Combined with Molecular Docking Approach to Investigate the Mechanism of ChuShiWeiLing Decoction against Perianal Eczema

Author(s): Ying Liu, Min Hao, Xinyue Fang, Yifei Qian, Yahui Wang and Shuai Yan*

Volume 30, Issue 18, 2024

Published on: 15 April, 2024

Page: [1442 - 1458] Pages: 17

DOI: 10.2174/0113816128298780240329075340

Price: $65

Abstract

Background: ChuShiWeiLing Decoction (CSWLD) is a famous classical Chinese prescription for the treatment of eczema with desirable effect in clinical practice. It has gradually exerted good curative effects on perianal eczema (PE) in recent years, but its specific mechanism is not elucidated yet.

Objective: This research explores the underlying pharmacological mechanism of CSWLD in addressing PE through network pharmacology combined with molecular docking strategy.

Methods: The key chemical compounds and potential target genes of CSWLD were screened by bioinformatics. The major targets of CSWLD were discovered using network modules. Functional annotation of Gene Ontology (GO) was undertaken, as well as pathway enrichment analysis using the Kyoto Encyclopedia of Genes and Genomes (KEGG). Molecular docking of core protein-ligand interactions was modeled using AutoDock software. Pymol software was used to perform a molecular dynamics simulation for the ideal core protein-ligand that was discovered by molecular docking.

Results: A total of 2,853 active compounds and 922 targets of CSWLD were collected. The target with a higher degree was identified through the PPI network, namely TNF, IL6, ALB, STAT3, EGFR, TLR4, CXCL8 and PTPRC. GO and KEGG analyses suggested that CSWLD treatment of PE mainly involves cellular activation, activation of leukocytes, and adhesion among leukocytes. The molecular docking results showed that wogonin, hederagenin and quercetin of CSWLD could bind to IL-6 and TNF, respectively.

Conclusion: Our results indicated that the bioactives, potential targets, and molecular mechanism of CSWLD against PE.

« Previous
[1]
Weyandt G, Breitkopf C, Werner RN, et al. German S1 guidelines for the diagnosis and treatment of perianal dermatitis (anal eczema). J Dtsch Dermatol Ges 2020; 18(6): 648-57.
[http://dx.doi.org/10.1111/ddg.14125] [PMID: 32469472]
[2]
Dietrich CF, Hoch F. Analekzem. Ther Umsch 2021; 78(9): 509-12.
[http://dx.doi.org/10.1024/0040-5930/a001303] [PMID: 34704478]
[3]
Schauber J, Weisenseel P, Ruzicka T. Topical treatment of perianal eczema with tacrolimus 0·1%. Br J Dermatol 2009; 161(6): 1384-6.
[http://dx.doi.org/10.1111/j.1365-2133.2009.09345.x] [PMID: 19575757]
[4]
Kränke B, Trummer M, Brabek E, Komericki P, Turek TD, Aberer W. Etiologic and causative factors in perianal dermatitis: Results of a prospective study in 126 patients. Wien Klin Wochenschr 2006; 118(3-4): 90-4.
[http://dx.doi.org/10.1007/s00508-006-0529-x] [PMID: 16703252]
[5]
Cheng YL, Wu YL, Li WL. Research progress on epidemiological investigation of anorectal diseases in China. Chin J Coloproctol 2022; 42(6): 74-6.
[http://dx.doi.org/10.3969/j.issn.1000-1174.2022.06.033]
[6]
Silverberg JI, Gelfand JM, Margolis DJ, et al. Symptoms and diagnosis of anxiety and depression in atopic dermatitis in U.S. adults. Br J Dermatol 2019; 181(3): 554-65.
[http://dx.doi.org/10.1111/bjd.17683] [PMID: 30838645]
[7]
Liu H, Xiao J, Wu J. Investigation and analysis of the psychological status and quality of life of patients with chronic eczema. Chin J Dermatol Venereol 2012; 26: 332-3.
[8]
Schauber J. Topical therapy of perianal eczema. Hautarzt 2010; 61(1): 33-8.
[http://dx.doi.org/10.1007/s00105-009-1812-3] [PMID: 19967332]
[9]
Agulló-Pérez AD, Hervella-Garcés M, Oscoz-Jaime S, Azcona-Rodríguez M, Larrea-García M, Yanguas-Bayona JI. Perianal dermatitis. Dermatitis 2017; 28(4): 270-5.
[http://dx.doi.org/10.1097/DER.0000000000000274] [PMID: 28338543]
[10]
Lenhard BH. On the clinical picture of anal eczema – diagnosis and therapy. Wien Med Wochenschr 2004; 154(3-4): 88-91.
[http://dx.doi.org/10.1007/s10354-004-0046-3] [PMID: 15038582]
[11]
Gao W, Qiao X, Zhu J, Jin X, Wei Y. Clinical efficacy of tacrolimus ointment + 3% boric acid lotion joint Chinese Angelica decoction in chronic perianal eczema. Comput Math Methods Med 2021; 2021: 1-5.
[http://dx.doi.org/10.1155/2021/1016108] [PMID: 34721653]
[12]
Weng M, Fang Z. Observation on treating perianal eczema of the Shire type with the Kushen Chushi plaster Clin Res. Zhong Yi Xue 2020; 12(11): 121-3.
[http://dx.doi.org/10.3969/j.issn.1674-7860.2020.11.046]
[13]
Han J. Observation on the efficacy of chushi weiling decoction combined with acupuncture in the treatment of eczema of immunological disorders. Guide Chin Med 2019; 17(28): 161.
[http://dx.doi.org/10.15912/j.cnki.gocm.2019.28.130]
[14]
Du JX, An CC, Xun JF. Study on the treatment of eczema by chushiweiling decoction. Modern J Integr Trad and West Med 2020; 29(30): 3410-2.
[http://dx.doi.org/10.3969/j.issn.1008-8849.2020.30.025]
[15]
Wu J, Zhao YM. Clinical effect of Dehumidification Weiling decoction combined with acupuncture on subacute eczema with dampness of immunological disorders. Inner Mongolia Trad Chin Med 2022; 41(3): 43-4.
[http://dx.doi.org/10.16040/j.cnki.cn15-1101.2022.03.040]
[16]
Liu M. The effect of the Chushi Weiling decoction on seborrheic dermatitis. Clin Res Trad Chin Med 2021; 13(22): 111-3.
[http://dx.doi.org/10.3969/j.issn.1674-7860.2021.22.035]
[17]
Cao T, Tan CC, Peng B. Clinical application of dehumidifying Weiling decoction in dermatology. J Clin Rational Drug Use 2020; 13(13): 110-3.
[http://dx.doi.org/10.15887/j.cnki.13-1389/r.2020.13.061]
[18]
Liu GH, Wang QL, Han XH. Clinical study on Chushi Weiling decoction combined with fire needle in the treatment of chronic eczema with immunological disorders. Int J Trad Chin Med 2022; 44(9): 1001-5.
[http://dx.doi.org/10.3760/cma.j.cn115398-20220402-00018]
[19]
Li JX, Jia XQ, He LY. Treatment of perianal eczema from ‘rheumatism heat stasis’. Int J Trad Chin Med 2022; 44(10): 1182-4.
[http://dx.doi.org/10.3760/cma.j.cn115398-20211013-00118]
[20]
Tan LL. ChuShi weiling decoction in treating 200 cases of chronic eczema. West J Trad Chin Med 2018; 31(12): 66-8.
[21]
Yan S, Ye BR, Lu LJ. Clinical evaluation of modified chushi weiling decoction combined with Zhiyang decoction in the treatment of perianal eczema. Shenzhen J Integr Tradit Chin West Med 2022; 32(8): 61-4.
[http://dx.doi.org/10.16458/j.cnki.1007-0893.2022.08.018]
[22]
Zhang R, Zhu X, Bai H, Ning K. Network pharmacology databases for traditional Chinese medicine: Review and assessment. Front Pharmacol 2019; 10: 123.
[http://dx.doi.org/10.3389/fphar.2019.00123] [PMID: 30846939]
[23]
Li S, Zhang B. Traditional Chinese medicine network pharmacology: Theory, methodology and application. Chin J Nat Med 2013; 11(2): 110-20.
[http://dx.doi.org/10.1016/S1875-5364(13)60037-0] [PMID: 23787177]
[24]
Hao DC, Xiao PG. Network pharmacology: A Rosetta Stone for traditional Chinese medicine. Drug Dev Res 2014; 75(5): 299-312.
[http://dx.doi.org/10.1002/ddr.21214] [PMID: 25160070]
[25]
Pinzi L, Rastelli G. Molecular docking: Shifting paradigms in drug discovery. Int J Mol Sci 2019; 20(18): 4331.
[http://dx.doi.org/10.3390/ijms20184331] [PMID: 31487867]
[26]
Burley SK, Bhikadiya C, Bi C, et al. RCSB Protein Data Bank (RCSB.org): delivery of experimentally-determined PDB structures alongside one million computed structure models of proteins from artificial intelligence/machine learning. Nucleic Acids Res 2023; 51(D1): D488-508.
[http://dx.doi.org/10.1093/nar/gkac1077] [PMID: 36420884]
[27]
Eberhardt J, Santos-Martins D, Tillack AF, Forli S. Auto-Dock Vina 1.2.0: New docking methods, expanded force field, and python bindings. J Chem Inf Model 2021; 61(8): 3891-8.
[http://dx.doi.org/10.1021/acs.jcim.1c00203] [PMID: 34278794]
[28]
Kim S. Getting the most out of PubChem for virtual screening. Expert Opin Drug Discov 2016; 11(9): 843-55.
[http://dx.doi.org/10.1080/17460441.2016.1216967] [PMID: 27454129]
[29]
Li X, Tian Y, Wu H, Wang T. Network pharmacology and molecular docking to unveil the mechanism of Shudihuang against amyotrophic lateral sclerosis. Curr Pharm Des 2023; 29(19): 1535-45.
[http://dx.doi.org/10.2174/1381612829666230621105552] [PMID: 37345246]
[30]
O’Boyle NM, Banck M, James CA, Morley C, Vandermeersch T, Hutchison GR. Open Babel: An open chemical toolbox. J Cheminform 2011; 3(1): 33.
[http://dx.doi.org/10.1186/1758-2946-3-33] [PMID: 21982300]
[31]
Kalliolias GD, Ivashkiv LB. TNF biology, pathogenic mechanisms and emerging therapeutic strategies. Nat Rev Rheumatol 2016; 12(1): 49-62.
[http://dx.doi.org/10.1038/nrrheum.2015.169] [PMID: 26656660]
[32]
Lee A, Qiao Y, Grigoriev G, et al. Tumor necrosis factor α induces sustained signaling and a prolonged and unremitting inflammatory response in rheumatoid arthritis synovial fibroblasts. Arthritis Rheum 2013; 65(4): 928-38.
[http://dx.doi.org/10.1002/art.37853] [PMID: 23335080]
[33]
Feldmann M. Translating molecular insights in autoimmunity into effective therapy. Annu Rev Immunol 2009; 27(1): 1-27.
[http://dx.doi.org/10.1146/annurev-immunol-082708-100732] [PMID: 19007330]
[34]
McEver RP. Selectins: initiators of leucocyte adhesion and signalling at the vascular wall. Cardiovasc Res 2015; 107(3): 331-9.
[http://dx.doi.org/10.1093/cvr/cvv154] [PMID: 25994174]
[35]
Bui TM, Wiesolek HL, Sumagin R. ICAM-1: A master regulator of cellular responses in inflammation, injury resolution, and tumorigenesis. J Leukoc Biol 2020; 108(3): 787-99.
[http://dx.doi.org/10.1002/JLB.2MR0220-549R] [PMID: 32182390]
[36]
Shi H, Wan G, Wang T, et al. Prevalence and influencing risk factors of eczema among preschool children in Urumqi city: a cross-sectional survey. BMC Pediatr 2021; 21(1): 347.
[http://dx.doi.org/10.1186/s12887-021-02819-5] [PMID: 34399722]
[37]
Belloni B, Andres C, Ollert M, Ring J, Mempel M. Novel immunological approaches in the treatment of atopic eczema. Curr Opin Allergy Clin Immunol 2008; 8(5): 423-7.
[http://dx.doi.org/10.1097/ACI.0b013e32830fb8fd] [PMID: 18769195]
[38]
Zhang M, Zhou J, Wang L, et al. Caffeic acid reduces cutaneous tumor necrosis factor alpha (TNF-α), IL-6 and IL-1β levels and ameliorates skin edema in acute and chronic model of cutaneous inflammation in mice. Biol Pharm Bull 2014; 37(3): 347-54.
[http://dx.doi.org/10.1248/bpb.b13-00459] [PMID: 24583856]
[39]
Cohen JN, Bowman S, Laszik ZG, North JP. Clinicopathologic overlap of psoriasis, eczema, and psoriasiform dermatoses: A retrospective study of T helper type 2 and 17 subsets, interleukin 36, and β-defensin 2 in spongiotic psoriasiform dermatitis, sebopsoriasis, and tumor necrosis factor α inhibitor–associated dermatitis. J Am Acad Dermatol 2020; 82(2): 430-9.
[http://dx.doi.org/10.1016/j.jaad.2019.08.023] [PMID: 31859047]
[40]
Li P, Chen J, Zhang W, Fu B, Wang W. Transcriptome inference and systems approaches to polypharmacology and drug discovery in herbal medicine. J Ethnopharmacol 2017; 195: 127-36.
[http://dx.doi.org/10.1016/j.jep.2016.10.020] [PMID: 27894972]
[41]
Lin Y, Chen XJ, He L, et al. Systematic elucidation of the bioactive alkaloids and potential mechanism from Sophora flavescens for the treatment of eczema via network pharmacology. J Ethnopharmacol 2023; 301115799.
[http://dx.doi.org/10.1016/j.jep.2022.115799] [PMID: 36216196]
[42]
Lucas CD, Dorward DA, Sharma S, et al. Wogonin induces eosinophil apoptosis and attenuates allergic airway inflammation. Am J Respir Crit Care Med 2015; 191(6): 626-36.
[http://dx.doi.org/10.1164/rccm.201408-1565OC] [PMID: 25629436]
[43]
Sohail M, Khan FA, Shami HB, Bashir MM. Management of eczema herpeticum in a burn unit. J Pak Med Assoc 2016; 66(11): 1357-61.
[PMID: 27812048]
[44]
Imbernón-Moya A, Ortiz-de Frutos FJ, Delgado-Márquez AM. Initial assessment of patients with contact eczema. Dermosyphiliographic minutes 2016; 107: 791-3.
[http://dx.doi.org/10.1016/j.adengl.2016.08.007]
[45]
Peluso I, Raguzzini A, Serafini M. Effect of flavonoids on circulating levels of TNF-α and IL-6 in humans: A systematic review and meta-analysis. Mol Nutr Food Res 2013; 57(5): 784-801.
[http://dx.doi.org/10.1002/mnfr.201200721] [PMID: 23471810]
[46]
Nguyen LTH, Oh TW, Nguyen UT, Choi MJ, Yang IJ, Shin HM. A natural compound mixture containing arctigenin, hederagenin, and baicalein alleviates atopic dermatitis in mice by regulating hpa axis and immune activity. Evid Based Complement Alternat Med 2020; 2020: 1-13.
[http://dx.doi.org/10.1155/2020/1970349] [PMID: 32714398]
[47]
Lee JH, Lim JY, Jo EH, et al. Chijabyukpi-tang inhibits pro-inflammatory cytokines and chemokines via the Nrf2/HO-1 signaling pathway in TNF-α/IFN-γ-Stimulated HaCaT cells and ameliorates 2,4-dinitrochlorobenzene-induced atopic dermatitis-like skin lesions in mice. Front Pharmacol 2020; 11: 1018.
[http://dx.doi.org/10.3389/fphar.2020.01018] [PMID: 32733250]
[48]
Zimmermann M, Koreck A, Meyer N, et al. TNF-like weak inducer of apoptosis (TWEAK) and TNF-α cooperate in the induction of keratinocyte apoptosis. J Allergy Clin Immunol 2011; 127(1): 200. -207. e10, 207.e1-207.e10.
[http://dx.doi.org/10.1016/j.jaci.2010.11.005] [PMID: 21211655]
[49]
Nakamura M, Lee K, Singh R, et al. Eczema as an adverse effect of anti-TNFα therapy in psoriasis and other Th1-mediated diseases: A review. J Dermatolog Treat 2017; 28(3): 237-41.
[http://dx.doi.org/10.1080/09546634.2016.1230173] [PMID: 27571340]
[50]
Deubelbeiss C, Kolios AGA, Anzengruber F, et al. TNFα and IL‐17A are differentially expressed in psoriasis‐like vs eczema‐like drug reactions to TNFα antagonists. J Cutan Pathol 2018; 45(1): 23-8.
[http://dx.doi.org/10.1111/cup.13055] [PMID: 29023827]
[51]
Zhu Y, Xian X, Wang Z, et al. Research progress on the relationship between atherosclerosis and inflammation. Biomolecules 2018; 8(3): 80.
[http://dx.doi.org/10.3390/biom8030080] [PMID: 30142970]
[52]
Xun Z, Lin J, Yu Q, et al. Taurocholic acid inhibits the response to interferon-α therapy in patients with HBeAg-positive chronic hepatitis B by impairing CD8+ T and NK cell function. Cell Mol Immunol 2021; 18(2): 461-71.
[http://dx.doi.org/10.1038/s41423-020-00601-8] [PMID: 33432062]
[53]
Wang S, Wang Y, Han B, et al. Huanglian ointment alleviates eczema by maintaining the balance of c-Jun and JunB and inhibiting AGE-RAGE-mediated proinflammation signaling pathway. Phytomedicine 2022; 105154372.
[http://dx.doi.org/10.1016/j.phymed.2022.154372] [PMID: 35932609]
[54]
Csiszar A, Ungvari Z. Endothelial dysfunction and vascular inflammation in Type 2 diabetes: Interaction of AGE/RAGE and TNF-α signaling. Am J Physiol Heart Circ Physiol 2008; 295(2): H475-6.
[http://dx.doi.org/10.1152/ajpheart.00644.2008] [PMID: 18599592]
[55]
Li X, Wei S, Niu S, et al. Network pharmacology prediction and molecular docking-based strategy to explore the potential mechanism of Huanglian Jiedu decoction against sepsis. Comput Biol Med 2022; 144105389.
[http://dx.doi.org/10.1016/j.compbiomed.2022.105389] [PMID: 35303581]
[56]
Wang W, Li M, Si H, Jiang Z. Network pharmacology and integrated molecular docking study on the mechanism of the therapeutic effect of fangfeng decoction in osteoarthritis. Curr Pharm Des 2023; 29(5): 379-92.
[http://dx.doi.org/10.2174/1381612829666230216095659] [PMID: 36803762]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version1.77sRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[21:13:32] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[21:13:34] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[21:13:34] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[21:13:34] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[21:13:34] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (91.46ms)time
  • Application (1.68s)time
  • 1 x Application (94.84%)
    1.68s
    1 x Booting (5.16%)
    91.46ms
    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 duplicated134ms
    • 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 ('51799060','',1,1740345214,1740345214) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740345214
      1.04msalphaeurekaselec_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 ('51799060','/article/139748',1,1740345214,1740345214)
      150μ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 >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) 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 >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) 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 >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) 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 >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) 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 >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) 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 >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51799060 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51799060) limit 1
      10.89msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51799060
      • 1: 51799060
      • 2: 51799060
      • 3: 51799060
      • 4: 51799060
      • 5: 51799060
      • 6: 51799060
      • 7: 51799060
      • 8: 51799060
      • 9: 51799060
      • 10: 51799060
      • 11: 51799060
      • 12: 51799060
      • 13: 51799060
      • 14: 51799060
      • 15: 51799060
      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=139748
      760μ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` = 29 limit 1
      1.13msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 29
      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=29) and sj.journal_id!=29 group by `j`.`nid`) as `aggregate_table`
      950μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=29) and sj.journal_id!=29 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      780μ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=29) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.03msalphaeurekaselec_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=29) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      940μsalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 14. app/Models/Subject.php:220
      • 15. app/Http/Controllers/ArticleController.php:2518
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `keywords` where `article_id` = '139748'
      180μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 139748
      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` = '139748'
      3.63msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 139748
      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` = '139748' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.72msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 139748
      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
      210μ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
      440μ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 = 29 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      33.32msalphaeurekaselec_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 = 29 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      32.54msalphaeurekaselec_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 = 29 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      32.07msalphaeurekaselec_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` = 139748 limit 1
      230μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 139748
      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 = 139748 and content_type = 'article' order by status desc limit 1
      260μ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` = 228922 limit 1
      180μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 228922
      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
      190μ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` = 'CPD' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      310μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CPD
      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 = '139748' 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) )
      1.13msalphaeurekaselec_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 = '13327' 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 = '3494' 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) )
      290μ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 <= 51799060 and j.to_ip >=51799060 )) and ((j.from_date <= 1740345214 and j.to_date >= 1740345214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3494) 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 <= 51799060 and j.to_ip >=51799060 )) and ((j.from_date <= 1740345214 and j.to_date >= 1740345214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3494) 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 <= 51799060 and j.to_ip >=51799060 )) and ((j.from_date <= 1740345214 and j.to_date >= 1740345214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3494)
      1.82msalphaeurekaselec_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 <= 51799060 and j.to_ip >=51799060 )) and ((j.from_date <= 1740345214 and j.to_date >= 1740345214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13327) 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 <= 51799060 and j.to_ip >=51799060 )) and ((j.from_date <= 1740345214 and j.to_date >= 1740345214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13327) 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 <= 51799060 and j.to_ip >=51799060 )) and ((j.from_date <= 1740345214 and j.to_date >= 1740345214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13327)
      530μ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 <= 51799060 and j.to_ip >=51799060 )) and ((j.from_date <= 1740345214 and j.to_date >= 1740345214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 139748) 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 <= 51799060 and j.to_ip >=51799060 )) and ((j.from_date <= 1740345214 and j.to_date >= 1740345214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 139748) 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 <= 51799060 and j.to_ip >=51799060 )) and ((j.from_date <= 1740345214 and j.to_date >= 1740345214 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 139748)
      540μ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` < '1442' and is_uploaded = 1 and issue_id = 13327 order by cast(first_page as SIGNED) desc limit 1
      440μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 1442
      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` > '1458' and is_uploaded = 1 and issue_id = 13327 order by cast(first_page as SIGNED) asc limit 1
      340μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 1458
      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'
      160μ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
      170μ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` = 139748 limit 1
      2.31msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 139748
      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` = 29 and `b`.`banner_from_date` <= 1740345214 and `b`.`banner_to_date` >= 1740345214 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.1msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 29
      • 3: 1740345214
      • 4: 1740345214
      • 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` = 29 and `b`.`banner_from_date` <= 1740345214 and `b`.`banner_to_date` >= 1740345214 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.04msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 29
      • 3: 1740345214
      • 4: 1740345214
      • 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='8702ae62b115f479b093e4476407ee3a'
      190μ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
        AjZizfSK5HWLTMpO0uP2O8zbH07zUWbgYL51McOx
        uc_cart_id
        8702ae62b115f479b093e4476407ee3a
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/article/139748" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/139748
        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:17 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6ImRRbFhMTW11czlRK2tINVovRGkrK1E9PSIsInZhbHVlIjoiTWlkY1llMkl3RVYxL3VNdDFubDRZWjlYTXliR1UvMFE4SjJnbTdib2lKUT0iLCJtYWMiOiIwYWZjMTgyMDhhNzJlZTM1YTIyMWJjNDk5ODE0NzY1NzVkZWVlYjZlMjkwNzJlOTBkMmFjNTc5MjZkYTQ1MzZjIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6ImRRbFhMTW11czlRK2tINVovRGkrK1E9PSIsInZhbHVlIjoiTWlkY1llMkl3RVYxL3VNdDFubDRZWjlYTXliR1UvMFE4SjJnbTdib2lKUT0iLCJtYWMiOiIwYWZjMTgyMDhhNzJl" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "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" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        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:13:34 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InZva2g3L1JrS25TZmtndUwxb3Z0OGc9PSIsInZhbHVlIjoiN0QwL0hXMnpHamM4MFh1bUE3d1JMZ2lNOUh1NzN2VTFtazJ3S1ZPYmRsNG5JcmhFZzY5aWxXZmpxdUEyekNmcTZzRThmYnZtVnBtcWMvZno2QlUwdVcyV0R2L3FGOEZEV01zRGh0Skk1S04rc1Q1UVkyNnNzWXZkUUN1Tkw5cGIiLCJtYWMiOiJhYjE5YWRiNDczMzdjNzg1NGY3NjFhZGNhZTE0OWNmYzEzMTJiYWI4MDkyMjRlYmI0ZGVjMTFmZWNiM2Q1YmMwIiwidGFnIjoiIn0%3D; expires=Wed, 26 Feb 2025 09:13:34 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InZva2g3L1JrS25TZmtndUwxb3Z0OGc9PSIsInZhbHVlIjoiN0QwL0hXMnpHamM4MFh1bUE3d1JMZ2lNOUh1NzN2VTFtazJ3S1ZPYmRsNG5JcmhFZzY5aWxXZmpxdUEyekNmcTZzRThmY" 1 => "alphaeurekaselectnet_session=eyJpdiI6IklES2d4L25oWE1udmd1cERBdjFPRkE9PSIsInZhbHVlIjoiOVFKZDRTTEJWWU05MUVVWU5zRS8ybnVTbDIralZOTHRpMGRzcFl4ZUlvY2FZajVQYzBnbVpvMEtzSkUzenQ2UEt4dFU4cW9ZV0YxSElXbjNFZkpIS0tRVFVndHN5NHBWVXlVT01ock1SaGpVRk1ZTlRYUGdLOW9jZ0VEdktTMTciLCJtYWMiOiI1Mzk0OWYxY2IzMjMyNWI5NjAyNmI0NTA4NzRkMDUyZDE4OGUyZjc2YWU4YjAwNGUwMWJhZmExNGYwYjk3OGU4IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IklES2d4L25oWE1udmd1cERBdjFPRkE9PSIsInZhbHVlIjoiOVFKZDRTTEJWWU05MUVVWU5zRS8ybnVTbDIralZOTHRpMGRzcFl4ZUlvY2FZajVQYzBnbVpvMEt" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InZva2g3L1JrS25TZmtndUwxb3Z0OGc9PSIsInZhbHVlIjoiN0QwL0hXMnpHamM4MFh1bUE3d1JMZ2lNOUh1NzN2VTFtazJ3S1ZPYmRsNG5JcmhFZzY5aWxXZmpxdUEyekNmcTZzRThmYnZtVnBtcWMvZno2QlUwdVcyV0R2L3FGOEZEV01zRGh0Skk1S04rc1Q1UVkyNnNzWXZkUUN1Tkw5cGIiLCJtYWMiOiJhYjE5YWRiNDczMzdjNzg1NGY3NjFhZGNhZTE0OWNmYzEzMTJiYWI4MDkyMjRlYmI0ZGVjMTFmZWNiM2Q1YmMwIiwidGFnIjoiIn0%3D; expires=Wed, 26-Feb-2025 09:13:34 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InZva2g3L1JrS25TZmtndUwxb3Z0OGc9PSIsInZhbHVlIjoiN0QwL0hXMnpHamM4MFh1bUE3d1JMZ2lNOUh1NzN2VTFtazJ3S1ZPYmRsNG5JcmhFZzY5aWxXZmpxdUEyekNmcTZzRThmY" 1 => "alphaeurekaselectnet_session=eyJpdiI6IklES2d4L25oWE1udmd1cERBdjFPRkE9PSIsInZhbHVlIjoiOVFKZDRTTEJWWU05MUVVWU5zRS8ybnVTbDIralZOTHRpMGRzcFl4ZUlvY2FZajVQYzBnbVpvMEtzSkUzenQ2UEt4dFU4cW9ZV0YxSElXbjNFZkpIS0tRVFVndHN5NHBWVXlVT01ock1SaGpVRk1ZTlRYUGdLOW9jZ0VEdktTMTciLCJtYWMiOiI1Mzk0OWYxY2IzMjMyNWI5NjAyNmI0NTA4NzRkMDUyZDE4OGUyZjc2YWU4YjAwNGUwMWJhZmExNGYwYjk3OGU4IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IklES2d4L25oWE1udmd1cERBdjFPRkE9PSIsInZhbHVlIjoiOVFKZDRTTEJWWU05MUVVWU5zRS8ybnVTbDIralZOTHRpMGRzcFl4ZUlvY2FZajVQYzBnbVpvMEt" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "AjZizfSK5HWLTMpO0uP2O8zbH07zUWbgYL51McOx" "uc_cart_id" => "8702ae62b115f479b093e4476407ee3a" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/article/139748" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-23 21:13:34GET/article/139748514361