Generic placeholder image

Current Bioactive Compounds

Editor-in-Chief

ISSN (Print): 1573-4072
ISSN (Online): 1875-6646

Research Article

Synthesis and Antibacterial / Anticancer Activities of Compounds Containing Pyrazole Ring Linked to Piperazines

Author(s): Kishore K. Valluri, Tejeswara R. Allaka, IV Kasi Viswanath* and Nagaraju PVVS

Volume 16, Issue 4, 2020

Page: [419 - 431] Pages: 13

DOI: 10.2174/1573407215666190111124513

Price: $65

Abstract

Background: Many pyrazole piperazine derivatives are known to exhibit a wide range, thus being attractive for the drug design and synthesis of interesting class of widely studied heterocyclic compounds. It is therefore necessary to devote continuing effort for the identification and development of New Chemical Entities (NCEs) as potential antibacterial and anticancer agents to address serious health problems.

Methods: A series of new compounds containing pyrazole ring linked to a piperazine hydrochloride moiety were synthesized and screened for their antibacterial activity, cytotoxicity of novel scaffolds are described by variation in therapeutic effects of parent molecule. The structure variants were characterized by using a blend of spectroscopic 1H NMR, 13C NMR, IR, Mass and chromatographic techniques.

Results: When tested for in vitro antibacterial and anticancer activities, several of these compounds showed good activities. The target compounds 9b, 9a and 9e exhibited a high degree of anticancer activity against human colon cancer cell line Caco-2 and human breast cancer cell line MDAMB231. Further, 9a, 9b, 9d, and 9h showed better activity towards four medically relevant organisms; Staphylococcus aureus, Bacillus subtilis, Escherichia coli and Klebsiella Species compared to CPF. In the present investigation, cheminfomatics tools Molinspiration, 2003 and MolSoft, 2007 for the prediction of insilico molecular properties and drug likeness for the target compounds 9a-h was evaluated and positive results were observed.

Conclusion: Our study revealed that the molecular framework presented here could be a useful template for the identification of novel small molecules as promising antibacterial/ anticancer agents.

Keywords: Antibacterial activity, anticancer activity, pyrazole, Molinspiration, MolSoft, XRD studies.

Graphical Abstract

[1]
Detchokul, S.; Williams, E.D.; Parker, M.W.; Frauman, A.G. Tetraspanins as regulators of the tumour microenvironment: Implications for metastasis and therapeutic strategies. Br. J. Pharmacol., 2014, 171(24), 5462-5490.
[http://dx.doi.org/10.1111/bph.12260] [PMID: 23731188]
[2]
Hu, W. Hsin-Su Yu.; Yan-Ren chen.; Yi-Min Tsai.; Yin-kai Chen.; Chao-Cheng Liao.; Long-Sen Chang.; Jeh-Jeng Wang. Synthesis and biological evaluation of thio benzanilides as anticancer agents. Bioorg. Med. Chem., 2008, 16, 5295-5302.
[http://dx.doi.org/10.1016/j.bmc.2008.03.003] [PMID: 18359635]
[3]
Kemnitzer, W.; Jiang, S.; Wang, Y.; Kasibhatla, S.; Crogan-Grundy, C.; Bubenik, M.; Labrecque, D.; Denis, R.; Lamothe, S.; Attardo, G.; Gourdeau, H.; Tseng, B.; Drewe, J.; Cai, S.X. Discovery of 4-aryl-4H-chromenes as a new series of apoptosis inducers using a cell- and caspase-based HTS assay. Part 5: Modifications of the 2- and 3-positions. Bioorg. Med. Chem. Lett., 2008, 18(2), 603-607.
[http://dx.doi.org/10.1016/j.bmcl.2007.11.078] [PMID: 18077161]
[4]
Bondock, S.; Khalifa, W.; Fadda, A.A. Synthesis and antimicrobial activity of some new 4-hetarylpyrazole and furo[2,3-c]pyrazole derivatives. Eur. J. Med. Chem., 2011, 46(6), 2555-2561.
[http://dx.doi.org/10.1016/j.ejmech.2011.03.045] [PMID: 21489661]
[5]
Sanjeeva Reddy, C.; Sanjeeva Rao, L.; Rajesh Kumar, G.; Nagaraj, A. Synthesis of new 1,2,4-triazole[3,4-b][1,3,4]thiadiazoles bearing pyrazole as potent antimicrobial agents. Chem. Pharm. Bull. (Tokyo), 2010, 58(10), 1328-1331.
[http://dx.doi.org/10.1248/cpb.58.1328] [PMID: 20930399]
[6]
Patel, M.V.; Bell, R.; Majest, S.; Henry, R.; Kolasa, T. Synthesis of 4,5-diaryl-1H-pyrazole-3-ol derivatives as potential COX-2 inhibitors. J. Org. Chem., 2004, 69(21), 7058-7065.
[http://dx.doi.org/10.1021/jo049264k] [PMID: 15471453]
[7]
Bansode, T.N.; Shelke, J.V.; Dongre, V.G. Synthesis and antimicrobial activity of some new N-acyl substituted phenothiazines. Eur. J. Med. Chem., 2009, 44(12), 5094-5098.
[http://dx.doi.org/10.1016/j.ejmech.2009.07.006] [PMID: 19651462]
[8]
Santos, J.L.; Yamasaki, P.R.; Chin, C.M.; Takashi, C.H.; Pavan, F.R.; Leite, C.Q. Synthesis and in vitro anti Mycobacterium tuberculosis activity of a series of phthalimide derivatives. Bioorg. Med. Chem., 2009, 17(11), 3795-3799.
[http://dx.doi.org/10.1016/j.bmc.2009.04.042] [PMID: 19427791]
[9]
Christodoulou, M.S.; Liekens, S.; Kasiotis, K.M.; Haroutounian, S.A. Novel pyrazole derivatives: Synthesis and evaluation of anti-angiogenic activity. Bioorg. Med. Chem., 2010, 18(12), 4338-4350.
[http://dx.doi.org/10.1016/j.bmc.2010.04.076] [PMID: 20493716]
[10]
Ragavan, R.V.; Vijayakumar, V.; Kumari, N.S. Synthesis and antimicrobial activities of novel 1,5-diaryl pyrazoles. Eur. J. Med. Chem., 2010, 45(3), 1173-1180.
[http://dx.doi.org/10.1016/j.ejmech.2009.12.042] [PMID: 20053480]
[11]
Rangaswamy, J.; Kumar, H.V.; Harini, S.T.; Naik, N. Synthesis of benzofuran based 1,3,5-substituted pyrazole derivatives: as a new class of potent antioxidants and antimicrobials-A novel accost to amend biocompatibility. Bioorg. Med. Chem. Lett., 2012, 22(14), 4773-4777.
[http://dx.doi.org/10.1016/j.bmcl.2012.05.061] [PMID: 22695127]
[12]
Zhang, C.Y.; Liu, X.H.; Wang, B.L.; Wang, S.H.; Li, Z.M. Synthesis and antifungal activities of new pyrazole derivatives via 1,3-dipolar cycloaddition reaction. Chem. Biol. Drug Des., 2010, 75(5), 489-493.
[http://dx.doi.org/10.1111/j.1747-0285.2010.00948.x] [PMID: 20486935]
[13]
El-Sayed Ali, T. Synthesis of some novel pyrazolo[3,4-b]pyridine and pyrazolo[3,4-d]pyrimidine derivatives bearing 5,6-diphenyl-1,2,4-triazine moiety as potential antimicrobial agents. Eur. J. Med. Chem., 2009, 44(11), 4385-4392.
[http://dx.doi.org/10.1016/j.ejmech.2009.05.031] [PMID: 19586688]
[14]
Xie, L.; Cui, J.; Qian, X.; Xu, Y.; Liu, J.; Xu, R. 5-Non-amino aromatic substituted naphthalimides as potential antitumor agents: Synthesis via Suzuki reaction, antiproliferative activity, and DNA-binding behavior. Bioorg. Med. Chem., 2011, 19(2), 961-967.
[http://dx.doi.org/10.1016/j.bmc.2010.11.055] [PMID: 21208805]
[15]
Riyadh, S.M.; Farghaly, T.A.; Abdallah, M.A.; Abdalla, M.M.; Abd El-Aziz, M.R. New pyrazoles incorporating pyrazolylpyrazole moiety: synthesis, anti-HCV and antitumor activity. Eur. J. Med. Chem., 2010, 45(3), 1042-1050.
[http://dx.doi.org/10.1016/j.ejmech.2009.11.050] [PMID: 20022411]
[16]
Hashimoto, H.; Imamura, K.; Haruta, J.; Wakitani, K. 4-(4-cycloalkyl/aryl-oxazol-5-yl)benzenesulfonamides as selective cyclooxygenase-2 inhibitors: enhancement of the selectivity by introduction of a fluorine atom and identification of a potent, highly selective, and orally active COX-2 inhibitor JTE-522(1). J. Med. Chem., 2002, 45(7), 1511-1517.
[http://dx.doi.org/10.1021/jm010484p] [PMID: 11906292]
[17]
Ranatunge, R.R.; Earl, R.A.; Garvey, D.S.; Janero, D.R.; Letts, L.G.; Martino, A.M.; Murty, M.G.; Richardson, S.K.; Schwalb, D.J.; Young, D.V.; Zemtseva, I.S. 3-(2-Methoxytetrahydrofuran-2-yl)pyrazoles: a novel class of potent, selective Cyclooxygenase-2 (COX-2) inhibitors. Bioorg. Med. Chem. Lett., 2004, 14(24), 6049-6052.
[http://dx.doi.org/10.1016/j.bmcl.2004.09.073] [PMID: 15546727]
[18]
Li, Y.L.; Fevig, J.M.; Cacciola, J.; Buriak, J., Jr; Rossi, K.A.; Jona, J.; Knabb, R.M.; Luettgen, J.M.; Wong, P.C.; Bai, S.A.; Wexler, R.R.; Lam, P.Y.S. Preparation of 1-(3-aminobenzo[d]isoxazol-5-yl)-1H-pyrazolo[4,3-d]pyrimidin-7(6H)-ones as potent, selective, and efficacious inhibitors of coagulation factor Xa. Bioorg. Med. Chem. Lett., 2006, 16(19), 5176-5182.
[http://dx.doi.org/10.1016/j.bmcl.2006.07.002] [PMID: 16870435]
[19]
Fevig, J.M.; Cacciola, J.; Buriak, J., Jr; Rossi, K.A.; Knabb, R.M.; Luettgen, J.M.; Wong, P.C.; Bai, S.A.; Wexler, R.R.; Lam, P.Y.S. Preparation of 1-(4-methoxyphenyl)-1H-pyrazolo[4,3-d]pyrimidin-7(6H)-ones as potent, selective and bioavailable inhibitors of coagulation factor Xa. Bioorg. Med. Chem. Lett., 2006, 16(14), 3755-3760.
[http://dx.doi.org/10.1016/j.bmcl.2006.04.044] [PMID: 16682200]
[20]
Pinto, D.J.P.; Orwat, M.J.; Koch, S.; Rossi, K.A.; Alexander, R.S.; Smallwood, A.; Wong, P.C.; Rendina, A.R.; Luettgen, J.M.; Knabb, R.M.; He, K.; Xin, B.; Wexler, R.R.; Lam, P.Y.S. Discovery of 1-(4-methoxyphenyl)-7-oxo-6-(4-(2-oxopiperidin-1-yl)phenyl)-4,5,6,7-tetrahydro-1H-pyrazolo[3,4-c]pyridine-3-carboxamide (apixaban, BMS-562247), a highly potent, selective, efficacious, and orally bioavailable inhibitor of blood coagulation factor Xa. J. Med. Chem., 2007, 50(22), 5339-5356.
[http://dx.doi.org/10.1021/jm070245n] [PMID: 17914785]
[21]
Chou, L.C.; Huang, L.J.; Yang, J.S.; Lee, F.Y.; Teng, C.M.; Kuo, S.C. Synthesis of furopyrazole analogs of 1-benzyl-3-(5-hydroxymethyl-2-furyl)indazole (YC-1) as novel anti-leukemia agents. Bioorg. Med. Chem., 2007, 15(4), 1732-1740.
[http://dx.doi.org/10.1016/j.bmc.2006.12.001] [PMID: 17189698]
[22]
Knorr, L. Chem. Ber., 1883, 17, 546-555.
[http://dx.doi.org/10.1002/cber.188401701152]
[23]
Wei, F.; Zhao, B.X.; Dong, W.L.; Zuo, H.; Shin, D.S.; Wang, D.W.; Xia, Y.; Ge, Y.Q. Microwave‐assisted rapid and straightforward synthesis of novel 6‐(Aroxymethyl)‐2 ‐aryl‐6,7‐dihydropyrazolo[5,1‐c][1,4]oxazin‐4‐one derivatives. Synth. Commun., 2007, 37, 4415-4424.
[http://dx.doi.org/10.1080/00397910701577877]
[24]
Xie, Y.S.; Zhao, B.X.; Lv, H.S.; Li, J.K.; Wang, B.S.; Shin, D.S. Synthesis and single-crystal characterization of novel 2-ferrocenyl-4H-pyrazolo[5,1-c][1,4]oxazin-4-one derivatives. J. Mol. Struct., 2009, 930, 83-87.
[http://dx.doi.org/10.1016/j.molstruc.2009.04.042]
[25]
Xie, Y.S.; Zhao, H.L.; Su, H.; Zhao, B.X.; Liu, J.T.; Li, J.K.; Lv, H.S.; Wang, B.S.; Shin, D.S.; Miao, J.Y. Synthesis, single-crystal characterization and preliminary biological evaluation of novel ferrocenyl pyrazolo[1,5-a]pyrazin-4(5H)-one derivatives. Eur. J. Med. Chem., 2010, 45(1), 210-218.
[http://dx.doi.org/10.1016/j.ejmech.2009.09.046] [PMID: 19879668]
[26]
Zhang, J.H.; Fan, C.D.; Zhao, B.X.; Shin, D.S.; Dong, W.L.; Xie, Y.S.; Miao, J.Y. Synthesis and preliminary biological evaluation of novel pyrazolo[1,5-a]pyrazin-4(5H)-one derivatives as potential agents against A549 lung cancer cells. Bioorg. Med. Chem., 2008, 16(24), 10165-10171.
[http://dx.doi.org/10.1016/j.bmc.2008.10.066] [PMID: 19013820]
[27]
Xie, Y.S.; Pan, X.H.; Zhao, B.X.; Liu, J.T.; Shin, D.S.; Zhang, J.H.; Zheng, L.W.; Zhao, J.; Miao, J.Y. Synthesis, structure characterization and preliminary biological evaluation of novel 5-alkyl-2-ferrocenyl-6,7-dihydropyrazolo[1,5-a]pyrazin-4-(5H)-one derivatives. J. Organomet. Chem., 2008, 693, 1367-1374.
[http://dx.doi.org/10.1016/j.jorganchem.2008.01.043]
[28]
Tewari, A.K.; Srivastava, P.; Singh, V.P.; Singh, A.; Goel, R.K.; Mohan, C.G. Novel anti-inflammatory agents based on pyrazole based dimeric compounds; design, synthesis, docking and in vivo activity. Chem. Pharm. Bull. (Tokyo), 2010, 58(5), 634-638.
[http://dx.doi.org/10.1248/cpb.58.634] [PMID: 20460788]
[29]
[30]
Bakht, M.A.; Yar, M.S.; Abdel-Hamid, S.G.; Al Qasoumi, S.I.; Samad, A. Molecular properties prediction, synthesis and antimicrobial activity of some newer oxadiazole derivatives. Eur. J. Med. Chem., 2010, 45(12), 5862-5869.
[http://dx.doi.org/10.1016/j.ejmech.2010.07.069] [PMID: 20965619]
[31]
Lipinski, C.A.; Lombardo, F.; Dominy, B.W.; Feeney, P.J. Experimental and computational approaches to estimate solubility and permeability in drug discovery and development settings. Adv. Drug Deliv. Rev., 2001, 46(1-3), 3-26.
[http://dx.doi.org/10.1016/S0169-409X(00)00129-0] [PMID: 11259830]
[32]
Rajanarendar, E.; Rama Krishna, S.; Nagaraju, D.; Govardhan Reddy, K.; Kishore, B.; Reddy, Y.N. Environmentally benign synthesis, molecular properties prediction and anti-inflammatory activity of novel isoxazolo[5,4-d]isoxazol-3-yl-aryl-methanones via vinylogous Henry nitroaldol adducts as synthons. Bioorg. Med. Chem. Lett., 2015, 25(7), 1630-1634.
[http://dx.doi.org/10.1016/j.bmcl.2015.01.041] [PMID: 25708616]
[33]
Ertl, P.; Rohde, B.; Selzer, P. Fast calculation of molecular polar surface area as a sum of fragment-based contributions and its application to the prediction of drug transport properties. J. Med. Chem., 2000, 43(20), 3714-3717.
[http://dx.doi.org/10.1021/jm000942e] [PMID: 11020286]
[34]
Alafeefy, A.M.; Alqasoumi, S.I.; Ashour, A.E.; Masand, V.; Al-Jaber, N.A.; Ben Hadda, T.; Mohamed, M.A. Quinazoline-tyrphostin as a new class of antitumor agents, molecular properties prediction, synthesis and biological testing. Eur. J. Med. Chem., 2012, 53, 133-140.
[http://dx.doi.org/10.1016/j.ejmech.2012.03.044] [PMID: 22520152]
[35]
da Silva, M.M.; Comin, M.; Duarte, T.S.; Foglio, M.A.; de Carvalho, J.E.; do Vieira, M.C.; Formagio, A.S. Synthesis, antiproliferative activity and molecular properties predictions of galloyl derivatives. Molecules, 2015, 20(4), 5360-5373.
[http://dx.doi.org/10.3390/molecules20045360] [PMID: 25816079]
[36]
Kavanagh, F. Analytical Microbiology; Academic Press: New York, London, 1972, Vol. II, pp. 11-23.
[37]
Miles, A.A.; Misra, S.S.; Irwin, J.O. The estimation of the bactericidal power of the blood. J. Hyg. (Lond.), 1938, 38(6), 732-749.
[PMID: 20475467]
[38]
Botta, M.; Armaroli, S.; Castagnolo, D.; Fontana, G.; Pera, P.; Bombardelli, E. Synthesis and biological evaluation of new taxoids derived from 2-deacetoxytaxinine J. Bioorg. Med. Chem. Lett., 2007, 17(6), 1579-1583.
[http://dx.doi.org/10.1016/j.bmcl.2006.12.101] [PMID: 17254787]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version374msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[05:01:04] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[05:01:04] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[05:01:04] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (92.8ms)time
  • Application (281ms)time
  • 1 x Application (75.17%)
    281ms
    1 x Booting (24.83%)
    92.80ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated195ms
    • 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 ('316481725','',1,1740459664,1740459664) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740459664
      1.16msalphaeurekaselec_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 ('316481725','/article/95703',1,1740459664,1740459664)
      200μ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 >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) 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 >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) 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 >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) 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 >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) 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 >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) 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 >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316481725 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316481725) limit 1
      15.94msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316481725
      • 1: 316481725
      • 2: 316481725
      • 3: 316481725
      • 4: 316481725
      • 5: 316481725
      • 6: 316481725
      • 7: 316481725
      • 8: 316481725
      • 9: 316481725
      • 10: 316481725
      • 11: 316481725
      • 12: 316481725
      • 13: 316481725
      • 14: 316481725
      • 15: 316481725
      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=95703
      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` = 6 limit 1
      830μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 6
      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=6) and sj.journal_id!=6 group by `j`.`nid`) as `aggregate_table`
      1.34msalphaeurekaselec_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=6) and sj.journal_id!=6 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.97msalphaeurekaselec_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=6) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      3.21msalphaeurekaselec_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=6) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      2.84msalphaeurekaselec_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` = '95703'
      1.89msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 95703
      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` = '95703'
      3.09msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 95703
      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` = '95703' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.33msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 95703
      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
      360μ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
      730μ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 = 6 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      24.47msalphaeurekaselec_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 = 6 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      12.29msalphaeurekaselec_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 = 6 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.25msalphaeurekaselec_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` = 95703 limit 1
      340μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 95703
      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 = 95703 and content_type = 'article' order by status desc limit 1
      1.06msalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 16 and cd.sub_disease_id = 436 and content_id!=95703 and cd.content_type = 'article' order by rand() limit 20
      88.49msalphaeurekaselec_live_10_06_2022Article.php#769
      Backtrace
      • 11. app/Models/Article.php:769
      • 12. app/Http/Controllers/ArticleController.php:2098
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 168900 limit 1
      250μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 168900
      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
      250μ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` = 'CBC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      290μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CBC
      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 = '95703' and content_type = 'a' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      370μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2186
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '9823' 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) )
      320μ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 = '2725' 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) )
      320μ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 <= 316481725 and j.to_ip >=316481725 )) and ((j.from_date <= 1740459664 and j.to_date >= 1740459664 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2725) 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 <= 316481725 and j.to_ip >=316481725 )) and ((j.from_date <= 1740459664 and j.to_date >= 1740459664 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2725) 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 <= 316481725 and j.to_ip >=316481725 )) and ((j.from_date <= 1740459664 and j.to_date >= 1740459664 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2725)
      11.2msalphaeurekaselec_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 <= 316481725 and j.to_ip >=316481725 )) and ((j.from_date <= 1740459664 and j.to_date >= 1740459664 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9823) 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 <= 316481725 and j.to_ip >=316481725 )) and ((j.from_date <= 1740459664 and j.to_date >= 1740459664 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9823) 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 <= 316481725 and j.to_ip >=316481725 )) and ((j.from_date <= 1740459664 and j.to_date >= 1740459664 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9823)
      640μ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 <= 316481725 and j.to_ip >=316481725 )) and ((j.from_date <= 1740459664 and j.to_date >= 1740459664 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 95703) 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 <= 316481725 and j.to_ip >=316481725 )) and ((j.from_date <= 1740459664 and j.to_date >= 1740459664 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 95703) 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 <= 316481725 and j.to_ip >=316481725 )) and ((j.from_date <= 1740459664 and j.to_date >= 1740459664 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 95703)
      830μ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` < '419' and is_uploaded = 1 and issue_id = 9823 order by cast(first_page as SIGNED) desc limit 1
      820μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 419
      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` > '431' and is_uploaded = 1 and issue_id = 9823 order by cast(first_page as SIGNED) asc limit 1
      1.72msalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 431
      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'
      240μ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
      290μ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` = 95703 limit 1
      3.9msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 95703
      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` = 6 and `b`.`banner_from_date` <= 1740459664 and `b`.`banner_to_date` >= 1740459664 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.62msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 6
      • 3: 1740459664
      • 4: 1740459664
      • 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` = 6 and `b`.`banner_from_date` <= 1740459664 and `b`.`banner_to_date` >= 1740459664 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.63msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 6
      • 3: 1740459664
      • 4: 1740459664
      • 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='7e475941a8adff21395330d558157818'
      290μ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
        hzCxKqATLg635hR4KP6PzTe0OLh3bQnQPJIyBrAp
        uc_cart_id
        7e475941a8adff21395330d558157818
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/95703" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/95703
        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=eyJpdiI6IlZIdkxhMStZcWQrYVcwbVJQaGM3NXc9PSIsInZhbHVlIjoiUFhqMVhlcTQ2NUZleVdRelRDdGdObmViNXJaa2JrUWMzK1BFaUJqSEE5cz0iLCJtYWMiOiIwYWQ5YjhhYjkzYWU2NmFlYWQ5OTM2MDQzOTBiZDg4ZGIxNmNjNWM2Njg0NGJlZDkxMjc3YjFmMjM4ZmNjYWRjIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IlZIdkxhMStZcWQrYVcwbVJQaGM3NXc9PSIsInZhbHVlIjoiUFhqMVhlcTQ2NUZleVdRelRDdGdObmViNXJaa2JrUWMzK1BFaUJqSEE5cz0iLCJtYWMiOiIwYWQ5YjhhYjkzYWU2" ] "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 05:01:04 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjR2c0puTXUrSWNxMGhKUFo4NmdyY1E9PSIsInZhbHVlIjoiODVQWVhTY1hoUy9tTlFWR1IvN05CM3EycFpJNThlUEdDWWV4TGRsR3ZtLzg5TGRqMHk3NkRKamRWdEw1eUdKbzJSVFZIbEpWaFJwLzQrRldQbE52VG1VWlF0ZFNrcmtFOVlGdHQwanVSL3Zjb3BGSi83ckNjS05HalRUSjh6aTgiLCJtYWMiOiI3ZmRhMWUwNmU4MzdlN2EwOTA4ZGVlY2NiMTVmYzY2ODhlMzBhZmM0Y2U2N2NiNTQ0Njc2NDlmY2Y2MTc4NGM2IiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 17:01:04 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjR2c0puTXUrSWNxMGhKUFo4NmdyY1E9PSIsInZhbHVlIjoiODVQWVhTY1hoUy9tTlFWR1IvN05CM3EycFpJNThlUEdDWWV4TGRsR3ZtLzg5TGRqMHk3NkRKamRWdEw1eUdKbzJSVFZIb" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlBXRWVYWjhVUGhxY1NhNkpQSm9xQXc9PSIsInZhbHVlIjoic2QyR0ZoVXh5ZkRjeWpuM2ZYYnVBc0RaUGMvRVA3Qms2cTVhZE1aWlA4RGV0Wk9hYm9pVDR1ZTltYjJjSXQza3NMeXRKY1NMSnB0QVBOMktwejViZFF1OWFFd3ZCc0xySEZRQmhrNGFJbHg2RjUxOVNWQVpueGhnYTIvOU5oRlUiLCJtYWMiOiJlZmY0NzAzZjJkNGE0OGRkYWRhNjljY2NjNjMzOGRlMTY2Yzc3NDA1MGE2Mzk3ZWRmYWRmZDdiY2Q4NTJiYjgxIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlBXRWVYWjhVUGhxY1NhNkpQSm9xQXc9PSIsInZhbHVlIjoic2QyR0ZoVXh5ZkRjeWpuM2ZYYnVBc0RaUGMvRVA3Qms2cTVhZE1aWlA4RGV0Wk9hYm9pVDR1ZTl" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjR2c0puTXUrSWNxMGhKUFo4NmdyY1E9PSIsInZhbHVlIjoiODVQWVhTY1hoUy9tTlFWR1IvN05CM3EycFpJNThlUEdDWWV4TGRsR3ZtLzg5TGRqMHk3NkRKamRWdEw1eUdKbzJSVFZIbEpWaFJwLzQrRldQbE52VG1VWlF0ZFNrcmtFOVlGdHQwanVSL3Zjb3BGSi83ckNjS05HalRUSjh6aTgiLCJtYWMiOiI3ZmRhMWUwNmU4MzdlN2EwOTA4ZGVlY2NiMTVmYzY2ODhlMzBhZmM0Y2U2N2NiNTQ0Njc2NDlmY2Y2MTc4NGM2IiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 17:01:04 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjR2c0puTXUrSWNxMGhKUFo4NmdyY1E9PSIsInZhbHVlIjoiODVQWVhTY1hoUy9tTlFWR1IvN05CM3EycFpJNThlUEdDWWV4TGRsR3ZtLzg5TGRqMHk3NkRKamRWdEw1eUdKbzJSVFZIb" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlBXRWVYWjhVUGhxY1NhNkpQSm9xQXc9PSIsInZhbHVlIjoic2QyR0ZoVXh5ZkRjeWpuM2ZYYnVBc0RaUGMvRVA3Qms2cTVhZE1aWlA4RGV0Wk9hYm9pVDR1ZTltYjJjSXQza3NMeXRKY1NMSnB0QVBOMktwejViZFF1OWFFd3ZCc0xySEZRQmhrNGFJbHg2RjUxOVNWQVpueGhnYTIvOU5oRlUiLCJtYWMiOiJlZmY0NzAzZjJkNGE0OGRkYWRhNjljY2NjNjMzOGRlMTY2Yzc3NDA1MGE2Mzk3ZWRmYWRmZDdiY2Q4NTJiYjgxIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlBXRWVYWjhVUGhxY1NhNkpQSm9xQXc9PSIsInZhbHVlIjoic2QyR0ZoVXh5ZkRjeWpuM2ZYYnVBc0RaUGMvRVA3Qms2cTVhZE1aWlA4RGV0Wk9hYm9pVDR1ZTl" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "hzCxKqATLg635hR4KP6PzTe0OLh3bQnQPJIyBrAp" "uc_cart_id" => "7e475941a8adff21395330d558157818" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/95703" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 05:01:04GET/article/95703314371