Generic placeholder image

Current Drug Discovery Technologies

Editor-in-Chief

ISSN (Print): 1570-1638
ISSN (Online): 1875-6220

Research Article

Cinnamaldehyde Analogs: Docking Based Optimization, COX-2 Inhibitory In Vivo and In Vitro Studies

Author(s): Vaishali M. Patil*, Preeti Anand, Monika Bhardwaj and Neeraj Masand

Volume 17, Issue 2, 2020

Page: [154 - 165] Pages: 12

DOI: 10.2174/1570163816666190125153951

Price: $65

Abstract

Background: In the past decade CADD has emerged as a rational approach in drug development so with the help molecular docking approach we planned to perform virtual screening of the designed data set of Schiff bases of cinnamaldehyde. The research work will be helpful to put some light on the drug receptor interactions required for anti-inflammatory activity.

Methods: For carrying out virtual screening of the developed cinnamaldehyde Schiff base data set, AutoDock 4.0 was used. The active hits identified through in silico screening were synthesized. Anti-inflammatory evaluation was carried out using Carrageenan-induced paw oedema method.

Results: Compounds V2A44, V2A55, V2A76, V2A82, V2A119, V2A141 and V2A142 has shown highest binding energy (-4.84, -4.76, -4.59, -4.78, -4.74, -4.85 and -4.72 kcal/mol, respectively) and the binding interactions with amino acids namely, Phe478, Glu479, Lys492, Ala493, Asp497 and Ile498. Some of the analogs have shown significant activity and were comparable to Indomethacin (standard drug).

Conclusion: Five new compounds have shown significant activity and the results obtained from in silico studies are parallel to those of in vivo studies.

Keywords: Schiff bases, cinnamaldehyde, virtual screening, anti-inflammatory agent, carragenan-induced paw oedema, molecular docking.

Graphical Abstract

[1]
Schiff H. Mittheilungen aus dem universita¨ tslaboratorium in Pisa: Eine neue reihe organischer basen. Justus Liebigs Ann Chem 1864; 131: 118-9.
[http://dx.doi.org/10.1002/jlac.18641310113]
[2]
Shah S, Vyas R, Mehta RH. Synthesis, characterization and antibacterial activities of some new Schiff base compounds. J Indian Chem Soc 1992; 69: 590-6.
[3]
Pandeya SN, Sriram D, Neath G, Clercq ED. Synthesis and antimicrobial activity of Schiff base and Mannich base of isatin and their derivatives with pyrimidine. Eur J Pharm Sci 1999; 9: 25-32.
[http://dx.doi.org/10.1016/S0928-0987(99)00038-X] [PMID: 10493993]
[4]
More PG, Bhalvankar RB, Patter SC. Schiff bases derived from substituted-2-aminothiazole and substituted salicylaldehyde and 2-hydroxy-1-napthaldehyde exhibits antibacterial and antifungal activity. J Indian Chem Soc 2001; 78: 474-5.
[5]
Kuz’min VE, Artemenko AG, Lozytska RN, et al. Investigation of anticancer activity of macrocyclic Schiff bases by means of 4D-QSAR based on simplex representation of molecular structure. SAR QSAR Environ Res 2005; 16(3): 219-30.
[http://dx.doi.org/10.1080/10659360500037206] [PMID: 15804810]
[6]
Dhar DN, Taploo CL. Schiff bases and their applications. J Sci Ind Res (India) 1982; 41: 501-6.
[7]
Bondock S, Khalifa W, Fadda AA. Synthesis and antimicrobial activity of some new 4-hetarylpyrazole and furo[2,3-c]pyrazole derivatives. Eur J Med Chem 2011; 46(6): 2555-61.
[http://dx.doi.org/10.1016/j.ejmech.2011.03.045] [PMID: 21489661]
[8]
Shi L, Ge HM, Tan SH, et al. Synthesis and antimicrobial activities of Schiff bases derived from 5-chloro-salicylaldehyde. Eur J Med Chem 2007; 42(4): 558-64.
[http://dx.doi.org/10.1016/j.ejmech.2006.11.010] [PMID: 17194508]
[9]
Sridhar SK, Ramesh A. Synthesis and pharmacological activities of hydrazones, Schiff and Mannich bases of isatin derivatives. Biol Pharm Bull 2001; 24(10): 1149-52.
[http://dx.doi.org/10.1248/bpb.24.1149] [PMID: 11642321]
[10]
Kaplan JP, Raizon BM, Desarmenien M, et al. New anticonvulsants: Schiff bases of gamma-aminobutyric acid and gamma-aminobutyramide. J Med Chem 1980; 23(6): 702-4.
[http://dx.doi.org/10.1021/jm00180a029] [PMID: 7392039]
[11]
Bhandari SV, Bothara KG, Raut MK, Patil AA, Sarkate AP, Mokale VJ. Design, synthesis and evaluation of antiinflammatory, analgesic and ulcerogenicity studies of novel S-substituted phenacyl-1,3,4-oxadiazole-2-thiol and Schiff bases of diclofenac acid as nonulcerogenic derivatives. Bioorg Med Chem 2008; 16(4): 1822-31.
[http://dx.doi.org/10.1016/j.bmc.2007.11.014] [PMID: 18248993]
[12]
Patole J, Shingnapurkar D, Padhye S, Ratledge C. Schiff base conjugates of p-aminosalicylic acid as antimycobacterial agents. Bioorg Med Chem Lett 2006; 16(6): 1514-7.
[http://dx.doi.org/10.1016/j.bmcl.2005.12.035] [PMID: 16413184]
[13]
Hearn MJ, Cynamon MH. Design and synthesis of antituberculars: preparation and evaluation against Mycobacterium tuberculosis of an isoniazid Schiff base. J Antimicrob Chemother 2004; 53(2): 185-91.
[http://dx.doi.org/10.1093/jac/dkh041] [PMID: 14688045]
[14]
Ren S, Wang R, Komatsu K, et al. Synthesis, biological evaluation, and quantitative structure-activity relationship analysis of new Schiff bases of hydroxysemicarbazide as potential antitumor agents. J Med Chem 2002; 45(2): 410-9.
[http://dx.doi.org/10.1021/jm010252q] [PMID: 11784145]
[15]
Przybylski P, Huczynski A, Pyta K, Brzezinski B, Bartl F. Biological properties of schiff bases and azo derivatives of phenols. Curr Org Chem 2009; 13: 124-48.
[http://dx.doi.org/10.2174/138527209787193774]
[16]
Nogardy T, Weaver DF. Medicinal Chemistry: A Molecular and Biochemical Approach Oxford University Press. New York 2005.
[17]
DaSilva M, DaSilva L, Fatima MARM. Schiff bases: A short review of their antimicrobial activities. J Adv Res 2011; 2: 1-8.
[http://dx.doi.org/10.1016/j.jare.2010.05.004]
[18]
Liao BC, Hsieh CW, Liu YC, Tzeng TT, Sun YW, Wung BS. Cinnamaldehyde inhibits the tumor necrosis factor-alpha-induced expression of cell adhesion molecules in endothelial cells by suppressing NF-kappaB activation: effects upon IkappaB and Nrf2. Toxicol Appl Pharmacol 2008; 229(2): 161-71.
[http://dx.doi.org/10.1016/j.taap.2008.01.021] [PMID: 18304597]
[19]
Hong CH, Hur SK, Oh OJ, Kim SS, Nam KA, Lee SK. Evaluation of natural products on inhibition of inducible cyclooxygenase (COX-2) and nitric oxide synthase (iNOS) in cultured mouse macrophage cells. J Ethnopharmacol 2002; 83(1-2): 153-9.
[http://dx.doi.org/10.1016/S0378-8741(02)00205-2] [PMID: 12413723]
[20]
Seo UK, Lee YJ, Kim JK, et al. Large-scale and effective screening of Korean medicinal plants for inhibitory activity on matrix metalloproteinase-9. J Ethnopharmacol 2005; 97(1): 101-6.
[http://dx.doi.org/10.1016/j.jep.2004.10.022] [PMID: 15652283]
[21]
Lou ZQ, Qin B. Species systematization and quality evaluation of commonly used Chinese traditional drugs, In: Beijing University Medical Press, Beijing, China. 1985; 1: pp. 1-8. In:
[22]
Lim CS, Kim EY, Lee HS, et al. Protective effects of Cinnamomum cassia Blume in the fibrogenesis of activated HSC-T6 cells and dimethylnitrosamine-induced acute liver injury in SD rats. Biosci Biotechnol Biochem 2010; 74(3): 477-83.
[http://dx.doi.org/10.1271/bbb.90435] [PMID: 20208363]
[23]
Verspohl EJ, Bauer K, Neddermann E. Antidiabetic effect of Cinnamomum cassia and Cinnamomum zeylanicum in vivo and in vitro. Phytother Res 2005; 19(3): 203-6.
[http://dx.doi.org/10.1002/ptr.1643] [PMID: 15934022]
[24]
He ZD, Qiao CF, Han QB, et al. Authentication and quantitative analysis on the chemical profile of cassia bark (cortex cinnamomi) by high-pressure liquid chromatography. J Agric Food Chem 2005; 53(7): 2424-8.
[http://dx.doi.org/10.1021/jf048116s] [PMID: 15796573]
[25]
Chang ST, Chen PF, Chang SC. Antibacterial activity of leaf essential oils and their constituents from Cinnamomum osmophloeum. J Ethnopharmacol 2001; 77(1): 123-7.
[http://dx.doi.org/10.1016/S0378-8741(01)00273-2] [PMID: 11483389]
[26]
Koh WS, Yoon SY, Kwon BM, Jeong TC, Nam KS, Han MY. Cinnamaldehyde inhibits lymphocyte proliferation and modulates T-cell differentiation. Int J Immunopharmacol 1998; 20(11): 643-60.
[http://dx.doi.org/10.1016/S0192-0561(98)00064-2] [PMID: 9848396]
[27]
Kwon BM, Lee SH, Choi SU, et al. Synthesis and in vitro cytotoxicity of cinnamaldehydes to human solid tumor cells. Arch Pharm Res 1998; 21(2): 147-52.
[http://dx.doi.org/10.1007/BF02974019] [PMID: 9875422]
[28]
Shaughnessy DT, Setzer RW, DeMarini DM. The antimutagenic effect of vanillin and cinnamaldehyde on spontaneous mutation at GC but not AT sites. Mutat Res 2001; 48: 55-69.
[http://dx.doi.org/10.1016/S0027-5107(01)00169-5] [PMID: 11506799]
[29]
Fang SH, Rao YK, Tzeng YM. Cytotoxic effect of trans-Cinnamaldehyde from Cinnamomum osmophloeum leaves on human cancer cell lines. Internat J Appl Sci Eng 2004; 2: 136-47.
[30]
Chao LK, Hua KF, Hsu HY, et al. Cinnamaldehyde inhibits pro-inflammatory cytokines secretion from monocytes/macrophages through suppression of intracellular signaling. Food Chem Toxicol 2008; 46(1): 220-31.
[http://dx.doi.org/10.1016/j.fct.2007.07.016] [PMID: 17868967]
[31]
Lee HS, Kim BS, Kim MK. Suppression effect of Cinnamomum cassia bark-derived component on nitric oxide synthase. J Agric Food Chem 2002; 50(26): 7700-3.
[http://dx.doi.org/10.1021/jf020751f] [PMID: 12475291]
[32]
Lin CC, Wu SJ, Chang CH, Ng LT. Antioxidant activity of Cinnamomum cassia. Phytother Res 2003; 17(7): 726-30.
[http://dx.doi.org/10.1002/ptr.1190] [PMID: 12916067]
[33]
Cheng SS, Liu JY, Tsai KH, Chen WJ, Chang ST. Chemical composition and mosquito larvicidal activity of essential oils from leaves of different Cinnamomum osmophloeum provenances. J Agric Food Chem 2004; 52(14): 4395-400.
[http://dx.doi.org/10.1021/jf0497152] [PMID: 15237942]
[34]
Kim HO, Park SW, Park HD. Inactivation of Escherichia coli O157:H7 by cinnamic aldehyde purified from Cinnamomum cassia shoot. Food Microbiol 2004; 21: 105-10.
[http://dx.doi.org/10.1016/S0740-0020(03)00010-8]
[35]
Ng LT, Wu SJ. Antiproliferative Activity of Cinnamomum cassia Constituents and effects of pifithrin-alpha on their apoptotic signaling pathways in Hep G2 Cells. Evid Based Complement Alternat Med 2011; 2011492148
[http://dx.doi.org/10.1093/ecam/nep220] [PMID: 20038571]
[36]
Huss U, Ringbom T, Perera P, Bohlin L, Vasänge M. Screening of ubiquitous plant constituents for COX-2 inhibition with a scintillation proximity based assay. J Nat Prod 2002; 65(11): 1517-21.
[http://dx.doi.org/10.1021/np020023m] [PMID: 12444669]
[37]
Sayed NA, Awadallah FM, Ibrahim NA, Saadi MT. Potential anti-inflammatory activity and ulcerogenicity study of some novel pyrimido[4′,5′:4,5]pyrimido[1,6-a]azepine derivatives. Med Chem Res 2012; 21: 395-405.
[http://dx.doi.org/10.1007/s00044-010-9545-5]
[38]
Hegazy GH, Ali HI. Design, synthesis, biological evaluation, and comparative Cox1 and Cox2 docking of p-substituted benzylidenamino phenyl esters of ibuprofenic and mefenamic acids. Bioorg Med Chem 2012; 20(3): 1259-70.
[http://dx.doi.org/10.1016/j.bmc.2011.12.030] [PMID: 22225915]
[39]
Kulkarni SK. Practical Pharmacology and Clinical Pharmacy. Vallabh Publications 2009; pp. 250-2.
[40]
Morris GM, Goodsell DS, Halliday RS, et al. Automated docking using a Lamarckian genetic algorithm and an empirical binding free energy function. J Comput Chem 1998; 19: 1639-48.
[http://dx.doi.org/10.1002/(SICI)1096-987X(19981115)19:14<1639:AID-JCC10>3.0.CO;2-B]
[41]
Mukherjee A, Sarkar A. New pyrazole-tethered Schiff bases as ligands for the Suzuki reaction. Tetrahedron Lett 2005; 46: 15-8.
[http://dx.doi.org/10.1016/j.tetlet.2004.11.051]
[42]
Shin DS, Kim J, Han DC, et al. Synthesis and biological evaluation of cinnamyl compounds as potent antitumor agents. Bioorg Med Chem Lett 2007; 17(19): 5423-7.
[http://dx.doi.org/10.1016/j.bmcl.2007.07.033] [PMID: 17683933]
[43]
Khan KM, Ambreen N, Mughal UR, Jalil S, Perveen S, Choudhary MI. 3-Formylchromones: Potential anti-inflammatory agent, H E J Research Institute of Chemistry, In: International Center for Chemical and Biological Sciences, University of Karachi, Ka-rachi-75270, Pakistan,. 2010.
[44]
Kaur J, Bhardwaj A, Huang Z, Knaus EE. N-1 and C-3 substituted indole Schiff bases as selective COX-2 inhibitors: synthesis and biological evaluation. Bioorg Med Chem Lett 2012; 22(6): 2154-9.
[http://dx.doi.org/10.1016/j.bmcl.2012.01.130] [PMID: 22361134]
[45]
Armitage P. Statistical Methods in Medical Research, 1st ed , Blackwell: In: Scientific, Oxford, London 1971; pp. 158-62. In:
[46]
Winter CA, Risley EA, Nuss GW. Carrageenin-induced edema in hind paw of the rat as an assay for antiiflammatory drugs. Proc Soc Exp Biol Med 1962; 111: 544-7.
[http://dx.doi.org/10.3181/00379727-111-27849] [PMID: 14001233]
[47]
Dannhardt G, Kiefer W, Krämer G, Maehrlein S, Nowe U, Fiebich B. The pyrrole moiety as a template for COX-1/COX-2 inhibitors. Eur J Med Chem 2000; 35(5): 499-510.
[http://dx.doi.org/10.1016/S0223-5234(00)00150-1] [PMID: 10889329]
[48]
Copeland RA, Williams JM, Giannaras J, et al. Mechanism of selective inhibition of the inducible isoform of prostaglandin G/H synthase. Proc Natl Acad Sci USA 1994; 91(23): 11202-6.
[http://dx.doi.org/10.1073/pnas.91.23.11202] [PMID: 7972034]
[49]
Pagels WR, Sachs RJ, Marnett LJ, Dewitt DL, Day JS, Smith WL. Immunochemical evidence for the involvement of prostaglandin H synthase in hydroperoxide-dependent oxidations by ram seminal vesicle microsomes. J Biol Chem 1983; 258(10): 6517-23.
[PMID: 6406484]
[50]
Egan RW, Paxton J, Kuehl FA Jr. Mechanism for irreversible self-deactivation of prostaglandin synthetase. J Biol Chem 1976; 251(23): 7329-35.
[PMID: 826527]
[51]
Tewari AK, Singh VP, Yadav P, et al. Synthesis, biological evaluation and molecular modeling study of pyrazole derivatives as selective COX-2 inhibitors and anti-inflammatory agents. Bioorg Chem 2014; 56: 8-15.
[http://dx.doi.org/10.1016/j.bioorg.2014.05.004] [PMID: 24893208]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version300msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[15:06:59] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[15:06:59] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[15:06:59] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (115ms)time
  • Application (185ms)time
  • 1 x Application (61.76%)
    185ms
    1 x Booting (38.23%)
    115ms
    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 duplicated110ms
    • 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 ('314567762','',1,1740496019,1740496019) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740496019
      910μsalphaeurekaselec_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 ('314567762','/article/96123',1,1740496019,1740496019)
      140μ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 >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) 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 >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) 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 >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) 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 >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) 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 >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) 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 >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314567762 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314567762) limit 1
      10.79msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314567762
      • 1: 314567762
      • 2: 314567762
      • 3: 314567762
      • 4: 314567762
      • 5: 314567762
      • 6: 314567762
      • 7: 314567762
      • 8: 314567762
      • 9: 314567762
      • 10: 314567762
      • 11: 314567762
      • 12: 314567762
      • 13: 314567762
      • 14: 314567762
      • 15: 314567762
      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=96123
      650μ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` = 68 limit 1
      750μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 68
      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=68) and sj.journal_id!=68 group by `j`.`nid`) as `aggregate_table`
      1.01msalphaeurekaselec_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=68) and sj.journal_id!=68 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      830μ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=68) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.25msalphaeurekaselec_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=68) 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.17msalphaeurekaselec_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` = '96123'
      1.34msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 96123
      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` = '96123'
      3.16msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 96123
      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` = '96123' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.29msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 96123
      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
      260μ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
      550μ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 = 68 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      25.51msalphaeurekaselec_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 = 68 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      7.22msalphaeurekaselec_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 = 68 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.51msalphaeurekaselec_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` = 96123 limit 1
      220μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 96123
      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 = 96123 and content_type = 'article' order by status desc limit 1
      320μ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` = 169371 limit 1
      230μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 169371
      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
      220μ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` = 'CDDT' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      300μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CDDT
      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 = '96123' 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) )
      410μ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 = '9756' 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) )
      370μ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 = '2721' 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) )
      360μ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 <= 314567762 and j.to_ip >=314567762 )) and ((j.from_date <= 1740496019 and j.to_date >= 1740496019 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2721) 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 <= 314567762 and j.to_ip >=314567762 )) and ((j.from_date <= 1740496019 and j.to_date >= 1740496019 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2721) 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 <= 314567762 and j.to_ip >=314567762 )) and ((j.from_date <= 1740496019 and j.to_date >= 1740496019 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2721)
      36.4msalphaeurekaselec_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 <= 314567762 and j.to_ip >=314567762 )) and ((j.from_date <= 1740496019 and j.to_date >= 1740496019 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9756) 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 <= 314567762 and j.to_ip >=314567762 )) and ((j.from_date <= 1740496019 and j.to_date >= 1740496019 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9756) 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 <= 314567762 and j.to_ip >=314567762 )) and ((j.from_date <= 1740496019 and j.to_date >= 1740496019 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9756)
      540μ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 <= 314567762 and j.to_ip >=314567762 )) and ((j.from_date <= 1740496019 and j.to_date >= 1740496019 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96123) 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 <= 314567762 and j.to_ip >=314567762 )) and ((j.from_date <= 1740496019 and j.to_date >= 1740496019 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96123) 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 <= 314567762 and j.to_ip >=314567762 )) and ((j.from_date <= 1740496019 and j.to_date >= 1740496019 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96123)
      530μ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` < '154' and is_uploaded = 1 and issue_id = 9756 order by cast(first_page as SIGNED) desc limit 1
      450μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 154
      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` > '165' and is_uploaded = 1 and issue_id = 9756 order by cast(first_page as SIGNED) asc limit 1
      410μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 165
      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
      190μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 96123 limit 1
      2.31msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 96123
      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` = 68 and `b`.`banner_from_date` <= 1740496019 and `b`.`banner_to_date` >= 1740496019 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: 68
      • 3: 1740496019
      • 4: 1740496019
      • 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` = 68 and `b`.`banner_from_date` <= 1740496019 and `b`.`banner_to_date` >= 1740496019 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.07msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 68
      • 3: 1740496019
      • 4: 1740496019
      • 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='5b3bc0b539e8d2601125a28504098338'
      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
        vcqRkv1ek51d4ffJ09kK3o7RmzmFjoJLAFObDdWs
        uc_cart_id
        5b3bc0b539e8d2601125a28504098338
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/96123" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/96123
        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=eyJpdiI6IjFVV3RnSkJQVUJnQ1dGVEpzZ1A3Y2c9PSIsInZhbHVlIjoiTUsraVlyR2ppUEJBK2JIWlkrUzkwampZcHUvSkNzMjBtcHJhQjVpV3QzTT0iLCJtYWMiOiI1MzU0YzA2OTNkMzM2OThjMDZkNjRjM2E4MDNiNGJkZDE4OWM5OGMyYTc0ZjEwNjAzNzc1YWQwNjRkZTg3MzhhIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IjFVV3RnSkJQVUJnQ1dGVEpzZ1A3Y2c9PSIsInZhbHVlIjoiTUsraVlyR2ppUEJBK2JIWlkrUzkwampZcHUvSkNzMjBtcHJhQjVpV3QzTT0iLCJtYWMiOiI1MzU0YzA2OTNkMzM2" ] "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:06:59 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJFY2R6aGloOHVmRG5EVGxxZnlwdmc9PSIsInZhbHVlIjoiREUrVUlVRlpzYllpK2VXN1h2UUMzVGJOWmlDNWhFQURYRHpENWJyQnhuVTFkbDBkOElPZmowY3RtSTlncjZML1VtOG94Vk5CMFpNbHhiOENjZjh6R01xV0JwVDA5S1VibWV5T1dCekpyWXZJSkx0bFVOYU9LbHhvREtnbHVRWGgiLCJtYWMiOiJkYTYyNDc0MmE2YTBkODA1NGMxZTQ0ZDU4ZWFlMGU5MGZjMmJlYTUzYjYzODAzMzdhZTVhOTNhZGI0Y2JjYmZiIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 03:06:59 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlJFY2R6aGloOHVmRG5EVGxxZnlwdmc9PSIsInZhbHVlIjoiREUrVUlVRlpzYllpK2VXN1h2UUMzVGJOWmlDNWhFQURYRHpENWJyQnhuVTFkbDBkOElPZmowY3RtSTlncjZML1VtOG94V" 1 => "alphaeurekaselectnet_session=eyJpdiI6Im84eUw4MjltdDdCNGRKUjNzOTlHSHc9PSIsInZhbHVlIjoiU3ZRay8ydllNbkkrVmJvRXM4bkRsanZVQzhpZDdWWm80NElBdDVJSXlBQzh6RjN0djM2VkxaWW9uUmw3aDROVWZQS0ZsVW84dGtBWi9KeXBDdHFoaWRBckZpQjZwNW1ZTFB6M1R2UStuSThKSEJTbk1VTlZhMVZTQnZQbVlnR0oiLCJtYWMiOiJkNDI3Mzc4NDczZGJkYTM1YzljMzc2YTUwY2M1ZWExMGVhNWNhYzhhNzVmYzNlMjc5ZWZmYzQ3Njc1MDFjYmRiIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Im84eUw4MjltdDdCNGRKUjNzOTlHSHc9PSIsInZhbHVlIjoiU3ZRay8ydllNbkkrVmJvRXM4bkRsanZVQzhpZDdWWm80NElBdDVJSXlBQzh6RjN0djM2VkxaWW9" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJFY2R6aGloOHVmRG5EVGxxZnlwdmc9PSIsInZhbHVlIjoiREUrVUlVRlpzYllpK2VXN1h2UUMzVGJOWmlDNWhFQURYRHpENWJyQnhuVTFkbDBkOElPZmowY3RtSTlncjZML1VtOG94Vk5CMFpNbHhiOENjZjh6R01xV0JwVDA5S1VibWV5T1dCekpyWXZJSkx0bFVOYU9LbHhvREtnbHVRWGgiLCJtYWMiOiJkYTYyNDc0MmE2YTBkODA1NGMxZTQ0ZDU4ZWFlMGU5MGZjMmJlYTUzYjYzODAzMzdhZTVhOTNhZGI0Y2JjYmZiIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 03:06:59 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlJFY2R6aGloOHVmRG5EVGxxZnlwdmc9PSIsInZhbHVlIjoiREUrVUlVRlpzYllpK2VXN1h2UUMzVGJOWmlDNWhFQURYRHpENWJyQnhuVTFkbDBkOElPZmowY3RtSTlncjZML1VtOG94V" 1 => "alphaeurekaselectnet_session=eyJpdiI6Im84eUw4MjltdDdCNGRKUjNzOTlHSHc9PSIsInZhbHVlIjoiU3ZRay8ydllNbkkrVmJvRXM4bkRsanZVQzhpZDdWWm80NElBdDVJSXlBQzh6RjN0djM2VkxaWW9uUmw3aDROVWZQS0ZsVW84dGtBWi9KeXBDdHFoaWRBckZpQjZwNW1ZTFB6M1R2UStuSThKSEJTbk1VTlZhMVZTQnZQbVlnR0oiLCJtYWMiOiJkNDI3Mzc4NDczZGJkYTM1YzljMzc2YTUwY2M1ZWExMGVhNWNhYzhhNzVmYzNlMjc5ZWZmYzQ3Njc1MDFjYmRiIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Im84eUw4MjltdDdCNGRKUjNzOTlHSHc9PSIsInZhbHVlIjoiU3ZRay8ydllNbkkrVmJvRXM4bkRsanZVQzhpZDdWWm80NElBdDVJSXlBQzh6RjN0djM2VkxaWW9" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "vcqRkv1ek51d4ffJ09kK3o7RmzmFjoJLAFObDdWs" "uc_cart_id" => "5b3bc0b539e8d2601125a28504098338" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/96123" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 15:06:59GET/article/96123314361