Generic placeholder image

Current Topics in Medicinal Chemistry

Editor-in-Chief

ISSN (Print): 1568-0266
ISSN (Online): 1873-4294

Research Article

Spiro-Lactams as Novel Antimicrobial Agents

Author(s): Américo J.S. Alves, Nuno G. Alves, Cátia C. Caratão, Margarida I.M. Esteves, Diana Fontinha, Inês Bártolo, Maria I.L. Soares, Susana M.M. Lopes, Miguel Prudêncio, Nuno Taveira and Teresa M.V.D. Pinho e Melo*

Volume 20, Issue 2, 2020

Page: [140 - 152] Pages: 13

DOI: 10.2174/1568026619666191105110049

Price: $65

Abstract

Introduction: Structural modulation of previously identified lead spiro-β-lactams with antimicrobial activity was carried out.

Objective: The main objective of this work was to synthesize and evaluate the biological activity of novel spiro-lactams based on previously identified lead compounds with antimicrobial activity.

Methods: The target chiral spiro-γ-lactams were synthesized through 1,3-dipolar cycloaddition reaction of a diazo-γ-lactam with electron-deficient dipolarophiles. In vitro activity against HIV and Plasmodium of a wide range of spiro-β-lactams and spiro-γ-lactams was evaluated. Among these compounds, one derivative with good anti-HIV activity and two with promising antiplasmodial activity (IC50 < 3.5 µM) were identified.

Results: A novel synthetic route to chiral spiro-γ-lactams has been established. The studied β- and γ- lactams were not cytotoxic, and three compounds with promising antimicrobial activity were identified, whose structural modulation may lead to new and more potent drugs.

Conclusion: The designed structural modulation of biologically active spiro-β-lactams involved the replacement of the four-membered β-lactam ring by a five-membered γ-lactam ring. Although conformational and superimposition computational studies revealed no significant differences between β- and γ- lactam pharmacophoric features, the studied structural modulation did not lead to compounds with a similar biological profile. The observed results suggest that the β-lactamic core is a requirement for the activity against both HIV and Plasmodium.

Keywords: Anti-HIV Agents, Antiplasmodial Agents, Spiro-γ-lactams, Spiro-penicillanate, 5-Oxohexahydropyrrolo[2, 1- b]thiazoles, Dipolar Cycloaddition, Diazo Compounds.

Graphical Abstract

[1]
Arya, N.; Jagdale, A.Y.; Patil, T.A.; Yeramwar, S.S.; Holikatti, S.S.; Dwivedi, J.; Shishoo, C.J.; Jain, K.S. The chemistry and biological potential of azetidin-2-ones. Eur. J. Med. Chem., 2014, 74, 619-656.
[http://dx.doi.org/10.1016/j.ejmech.2014.01.002] [PMID: 24531200]
[2]
Mehta, P.D.; Sengar, N.P.S.; Pathak, A.K. 2-Azetidinone-a new profile of various pharmacological activities. Eur. J. Med. Chem., 2010, 45(12), 5541-5560.
[http://dx.doi.org/10.1016/j.ejmech.2010.09.035] [PMID: 20970895]
[3]
Galletti, P.; Giacomini, D. Monocyclic β-lactams: new structures for new biological activities. Curr. Med. Chem., 2011, 18(28), 4265-4283.
[http://dx.doi.org/10.2174/092986711797200480] [PMID: 21861821]
[4]
Hosseyni, S.; Jarrahpour, A. Recent advances in β-lactam synthesis. Org. Biomol. Chem., 2018, 16(38), 6840-6852.
[http://dx.doi.org/10.1039/C8OB01833B] [PMID: 30209477]
[5]
Decuyper, L.; Jukič, M.; Sosič, I.; Žula, A.; D’hooghe, M.; Gobec, S. Antibacterial and β-lactamase inhibitory activity of monocyclic β-lactams. Med. Res. Rev., 2018, 38(2), 426-503.
[http://dx.doi.org/10.1002/med.21443] [PMID: 28815732]
[6]
Singh, G.S.; D’hooghe, M.; De Kimpe, N. Synthesis and reactivity of spiro-fused β-lactams. Tetrahedron, 2011, 67(11), 1989-2012.
[http://dx.doi.org/10.1016/j.tet.2011.01.013]
[7]
Vandekerckhove, S.; D’hooghe, M. Exploration of aziridine- and β-lactam-based hybrids as both bioactive substances and synthetic intermediates in medicinal chemistry. Bioorg. Med. Chem., 2013, 21(13), 3643-3647.
[http://dx.doi.org/10.1016/j.bmc.2013.04.033] [PMID: 23684232]
[8]
Majewski, M.W.; Miller, P.A.; Oliver, A.G.; Miller, M.J. Alternate “drug” delivery utilizing b-lactam cores: Syntheses and biological evaluation of b-lactams bearing isocyanate precursors. J. Org. Chem., 2017, 82(1), 737-744.
[http://dx.doi.org/10.1021/acs.joc.6b02272] [PMID: 27935702]
[9]
Alborz, M.; Jarrahpour, A.; Pournejati, R.; Karbalaei-Heidari, H.R.; Sinou, V.; Latour, C.; Brunel, J.M.; Sharghi, H.; Aberi, M.; Turos, E.; Wojtas, L. Synthesis and biological evaluation of some novel diastereoselective benzothiazole β-lactam conjugates. Eur. J. Med. Chem., 2018, 143, 283-291.
[http://dx.doi.org/10.1016/j.ejmech.2017.11.053] [PMID: 29197733]
[10]
Giacomini, D.; Martelli, G.; Piccichè, M.; Calaresu, E.; Cocuzza, C.E.; Musumeci, R. Design and synthesis of 4-alkylidene-β-lactams: Benzyl- and phenethyl-carbamates as key fragments to switch on antibacterial activity. ChemMedChem, 2017, 12(18), 1525-1533.
[http://dx.doi.org/10.1002/cmdc.201700307] [PMID: 28737008]
[11]
Jarrahpour, A.; Ebrahimi, E.; De Clercq, E.; Sinou, V.; Latour, C.; Bouktab, L.D.; Brunel, J.M. Synthesis of mono-, bis-spiro- and dispiro-β-lactams and evaluation of their antimalarial activities. Tetrahedron, 2011, 67(45), 8699-8704.
[http://dx.doi.org/10.1016/j.tet.2011.09.041]
[12]
Raj, R.; Biot, C.; Carrère-Kremer, S.; Kremer, L.; Guérardel, Y.; Gut, J.; Rosenthal, P.J.; Kumar, V. 4-Aminoquinoline-β-lactam conjugates: synthesis, antimalarial, and antitubercular evaluation. Chem. Biol. Drug Des., 2014, 83(2), 191-197.
[http://dx.doi.org/10.1111/cbdd.12225] [PMID: 24034147]
[13]
Dražić, T.; Sachdev, V.; Leopold, C.; Patankar, J.V.; Malnar, M.; Hećimović, S.; Levak-Frank, S.; Habuš, I.; Kratky, D. Synthesis and evaluation of novel amide amino-β-lactam derivatives as cholesterol absorption inhibitors. Bioorg. Med. Chem., 2015, 23(10), 2353-2359.
[http://dx.doi.org/10.1016/j.bmc.2015.03.067] [PMID: 25882530]
[14]
Baiula, M.; Galletti, P.; Martelli, G.; Soldati, R.; Belvisi, L.; Civera, M.; Dattoli, S.D.; Spampinato, S.M.; Giacomini, D. New β-lactam derivatives modulate cell adhesion and signaling mediated by RGD-binding and leukocyte integrins. J. Med. Chem., 2016, 59(21), 9721-9742.
[http://dx.doi.org/10.1021/acs.jmedchem.6b00576] [PMID: 27726366]
[15]
Zhou, P.; Liu, Y.; Zhou, L.; Zhu, K.; Feng, K.; Zhang, H.; Liang, Y.; Jiang, H.; Luo, C.; Liu, M.; Wang, Y. Potent antitumor activities and structure basis of the chiral β-lactam bridged analogue of combretastatin A-4 binding to tubulin. J. Med. Chem., 2016, 59(22), 10329-10334.
[http://dx.doi.org/10.1021/acs.jmedchem.6b01268] [PMID: 27805821]
[16]
Barrett, A.G.M.; Head, J.; Smith, M.L.; Stock, N.S.; White, A.J.P.; Williams, D.J. Fleming-Tamao oxidation and masked hydroxyl functionality: Total synthesis of (+)-pramanicin and structural elucidation of the antifungal natural product (-)-pramanicin. J. Org. Chem., 1999, 64(16), 6005-6018.
[http://dx.doi.org/10.1021/jo9905672]
[17]
Baures, P.W.; Eggleston, D.S.; Erhard, K.F.; Cieslinski, L.B.; Torphy, T.J.; Christensen, S.B. The crystal structure, absolute configuration, and phosphodiesterase inhibitory activity of (+)-1-(4-bromobenzyl)-4-(3-(cyclopentyloxy)- 4-methoxyphenyl)-pyrrolidin-2-one. J. Med. Chem., 1993, 36(22), 3274-3277.
[http://dx.doi.org/10.1021/jm00074a007] [PMID: 8230117]
[18]
Davies, M.N.; Bayry, J.; Tchilian, E.Z.; Vani, J.; Shaila, M.S.; Forbes, E.K.; Draper, S.J.; Beverley, P.C.L.; Tough, D.F.; Flower, D.R. Toward the discovery of vaccine adjuvants: coupling in silico screening and in vitro analysis of antagonist binding to human and mouse CCR4 receptors. PLoS One, 2009, 4(11) e8084
[http://dx.doi.org/10.1371/journal.pone.0008084] [PMID: 20011659]
[19]
Feling, R.H.; Buchanan, G.O.; Mincer, T.J.; Kauffman, C.A.; Jensen, P.R.; Fenical, W.; Salinosporamide, A. Salinosporamide A: a highly cytotoxic proteasome inhibitor from a novel microbial source, a marine bacterium of the new genus salinospora. Angew. Chem. Int. Ed. Engl., 2003, 42(3), 355-357.
[http://dx.doi.org/10.1002/anie.200390115] [PMID: 12548698]
[20]
Newhouse, B.; Allen, S.; Fauber, B.; Anderson, A.S.; Eary, C.T.; Hansen, J.D.; Schiro, J.; Gaudino, J.J.; Laird, E.; Chantry, D.; Eberhardt, C.; Burgess, L.E. Racemic and chiral lactams as potent, selective and functionally active CCR4 antagonists. Bioorg. Med. Chem. Lett., 2004, 14(22), 5537-5542.
[http://dx.doi.org/10.1016/j.bmcl.2004.09.001] [PMID: 15482919]
[21]
Pyun, D.K.; Kim, B.J.; Jung, H.J.; Kim, J.H.; Lee, J.S.; Lee, W.K.; Lee, C.H. Syntheses of 1β-methylcarbapenems bearing 5-methyl-4-hydroxypyrrolidinone. Chem. Pharm. Bull. (Tokyo), 2002, 50(3), 415-418.
[http://dx.doi.org/10.1248/cpb.50.415] [PMID: 11911211]
[22]
Santos, B.S.; Nunes, S.C.C.; Pais, A.A.C.C.; Pinho e Melo, T.M.V.D. Chiral spiro-β-lactams from 6-diazopenicillanates. Tetrahedron, 2012, 68(19), 3729-3737.
[http://dx.doi.org/10.1016/j.tet.2012.03.022]
[23]
Santos, B.S.; Gomes, C.S.B.; Pinho e Melo, T.M.V.D. Synthesis of chiral spiropyrazoline-beta-lactams and spirocyclopropyl-β-lactams from 6-alkylidenepenicillanates. Tetrahedron, 2014, 70(24), 3812-3821.
[http://dx.doi.org/10.1016/j.tet.2014.03.109]
[24]
Santos, B.S.; Pinho e Melo, T.M.V.D. Synthesis of chiral spirocyclopentenyl-β-lactams through phosphane-catalyzed [3+2] annulation of allenoates with 6-alkylidenepenicillanates. Eur. J. Org. Chem., 2013, (18), 3901-3909.
[http://dx.doi.org/10.1002/ejoc.201300153]
[25]
Pinho e Melo, T. M. V. D.; Taveira, N.; Prudêncio, M.; Santos, B. S.; Bártolo, I. Novel spiro-lactams, process and uses thereof. WO/2018/207165 2017.
[26]
Blanca-Lopez, N.; Jimenez-Rodriguez, T.W.; Somoza, M.L.; Gomez, E.; Al-Ahmad, M.; Perez-Sala, D.; Blanca, M. Allergic reactions to penicillins and cephalosporins: diagnosis, assessment of cross-reactivity and management. Expert Rev. Clin. Immunol., 2019, 15(7), 707-721.
[http://dx.doi.org/10.1080/1744666X.2019.1619548] [PMID: 31161822]
[27]
FDA. Non-Penicillin Beta-Lactam Drugs: A CGMP framework for preventing cross-contamination.. https://www.fda.gov/regulatory-information/search-fda-guidance-documents/non-penicillin-beta-lactam-drugs-cgmp-framework-preventing-cross-contamination (accessed August 27, 2019).
[28]
Brasile, G.; Mauri, L.; Sonnino, S.; Compostella, F.; Ronchetti, F. A practical route to long-chain non-natural α,ω-diamino acids. Amino Acids, 2013, 44(2), 435-441.
[http://dx.doi.org/10.1007/s00726-012-1349-0] [PMID: 22777284]
[29]
Martín-Martínez, M.; De La Figuera, N.; Latorre, M.; Herranz, R.; García-López, M.T.; Cenarruzabeitia, E.; Del Río, J.; González-Muñiz, R. β-Turned dipeptoids as potent and selective CCK(1) receptor antagonists. J. Med. Chem., 2000, 43(20), 3770-3777.
[http://dx.doi.org/10.1021/jm000959x] [PMID: 11020292]
[30]
Borrego, P.; Calado, R.; Marcelino, J.M.; Bártolo, I.; Rocha, C.; Cavaco-Silva, P.; Doroana, M.; Antunes, F.; Maltez, F.; Caixas, U.; Barroso, H.; Taveira, N. Baseline susceptibility of primary HIV-2 to entry inhibitors. Antivir. Ther. (Lond.), 2012, 17(3), 565-570.
[http://dx.doi.org/10.3851/IMP1996] [PMID: 22293827]
[31]
Davis, K.L.; Bibollet-Ruche, F.; Li, H.; Decker, J.M.; Kutsch, O.; Morris, L.; Salomon, A.; Pinter, A.; Hoxie, J.A.; Hahn, B.H.; Kwong, P.D.; Shaw, G.M. Human immunodeficiency virus type 2 (HIV-2)/HIV-1 envelope chimeras detect high titers of broadly reactive HIV-1 V3-specific antibodies in human plasma. J. Virol., 2009, 83(3), 1240-1259.
[http://dx.doi.org/10.1128/JVI.01743-08] [PMID: 19019969]
[32]
Borrego, P.; Calado, R.; Marcelino, J.M.; Pereira, P.; Quintas, A.; Barroso, H.; Taveira, N. An ancestral HIV-2/simian immunodeficiency virus peptide with potent HIV-1 and HIV-2 fusion inhibitor activity. AIDS, 2013, 27(7), 1081-1090.
[http://dx.doi.org/10.1097/QAD.0b013e32835edc1d] [PMID: 23324659]
[33]
Ploemen, I.H.J.; Prudêncio, M.; Douradinha, B.G.; Ramesar, J.; Fonager, J.; van Gemert, G-J.; Luty, A.J.F.; Hermsen, C.C.; Sauerwein, R.W.; Baptista, F.G.; Mota, M.M.; Waters, A.P.; Que, I.; Lowik, C.W.G.M.; Khan, S.M.; Janse, C.J.; Franke-Fayard, B.M.D. Visualisation and quantitative analysis of the rodent malaria liver stage by real time imaging. PLoS One, 2009, 4(11) e7881
[http://dx.doi.org/10.1371/journal.pone.0007881] [PMID: 19924309]
[34]
Prudêncio, M.; Rodrigues, C.D.; Ataíde, R.; Mota, M.M. Dissecting in vitro host cell infection by Plasmodium sporozoites using flow cytometry. Cell. Microbiol., 2008, 10(1), 218-224.
[PMID: 17697130]
[35]
Becke, A.D. Density-functional exchange-energy approximation with correct asymptotic behavior. Phys. Rev. A Gen. Phys., 1988, 38(6), 3098-3100.
[http://dx.doi.org/10.1103/PhysRevA.38.3098] [PMID: 9900728]
[36]
Becke, A.D. Density-functional thermochemistry. The role of exact exchange. J. Chem. Phys., 1993, 98(7), 5648-5652.
[http://dx.doi.org/10.1063/1.464913]
[37]
Lee, C.; Yang, W.; Parr, R.G. Development of the Colle-Salvetti correlation-energy formula into a functional of the electron density. Phys. Rev. B Condens. Matter, 1988, 37(2), 785-789.
[http://dx.doi.org/10.1103/PhysRevB.37.785] [PMID: 9944570]
[38]
Schmidt, M.W.; Baldridge, K.K.; Boatz, J.A.; Elbert, S.T.; Gordon, M.S.; Jensen, J.H.; Koseki, S.; Matsunaga, N.; Nguyen, K.A.; Su, S.J.; Windus, T.L.; Dupuis, M.; Montgomery, J.A. General atomic and molecular electronic structure system. J. Comput. Chem., 1993, 14(11), 1347-1363.
[http://dx.doi.org/10.1002/jcc.540141112]
[39]
Wolber, G.; Langer, T. LigandScout: 3-D pharmacophores derived from protein-bound ligands and their use as virtual screening filters. J. Chem. Inf. Model., 2005, 45(1), 160-169.
[http://dx.doi.org/10.1021/ci049885e] [PMID: 15667141]
[40]
Baldwin, J.E.; Freeman, R.T.; Lowe, C.; Schofield, C.J.; Lee, E. A γ-lactam analog of the penems possessing antibacterial activity. Tetrahedron, 1989, 45(14), 4537-4550.
[http://dx.doi.org/10.1016/S0040-4020(01)89088-8]
[41]
Baldwin, J.E.; Lowe, C.; Schofield, C.J.; Lee, E. A γ-lactam analog of the penems possessing antibacterial activity. Tetrahedron Lett., 1986, 27(30), 3461-3464.
[http://dx.doi.org/10.1016/S0040-4039(00)84822-4]
[42]
Chauvette, R.R.; Pennington, P.A.; Ryan, C.W.; Cooper, R.D.G.; José, F.L.; Wright, I.G.; Van Heyningen, E.M.; Huffman, G.W. Chemistry of cephalosporin antibiotics. XXI. Conversion of penicillins to cephalexin. J. Org. Chem., 1971, 36(9), 1259-1267.
[http://dx.doi.org/10.1021/jo00808a021] [PMID: 4995070]
[43]
Sheehan, J.C.; Commons, T.J. Reaction of 6(7)-diazopenicillanates and diazocephalosporanates with sulfenyl chlorides. Preparation of 6(7)α-methoxy-substituted thiol penicillanates and thiol cephalosporanates. J. Org. Chem., 1978, 43(11), 2203-2208.
[http://dx.doi.org/10.1021/jo00405a026]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version419msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[21:16:23] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[21:16:23] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[21:16:23] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (102ms)time
  • Application (317ms)time
  • 1 x Application (75.65%)
    317ms
    1 x Booting (24.35%)
    102ms
    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 duplicated248ms
    • 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 ('873336012','',1,1740345383,1740345383) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740345383
      880μ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 ('873336012','/article/102088',1,1740345383,1740345383)
      130μ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 >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) 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 >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) 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 >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) 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 >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) 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 >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) 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 >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 873336012 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873336012) limit 1
      11.21msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 873336012
      • 1: 873336012
      • 2: 873336012
      • 3: 873336012
      • 4: 873336012
      • 5: 873336012
      • 6: 873336012
      • 7: 873336012
      • 8: 873336012
      • 9: 873336012
      • 10: 873336012
      • 11: 873336012
      • 12: 873336012
      • 13: 873336012
      • 14: 873336012
      • 15: 873336012
      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=102088
      640μ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` = 38 limit 1
      700μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 38
      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=38) and sj.journal_id!=38 group by `j`.`nid`) as `aggregate_table`
      1.08msalphaeurekaselec_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=38) and sj.journal_id!=38 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      890μ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=38) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.5msalphaeurekaselec_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=38) 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.37msalphaeurekaselec_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` = '102088'
      1.56msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 102088
      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` = '102088'
      2.26msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 102088
      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` = '102088' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.39msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 102088
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ArticleController.php:2533
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      210μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      430μ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 = 38 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      30.83msalphaeurekaselec_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 = 38 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      27.35msalphaeurekaselec_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 = 38 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      17.96msalphaeurekaselec_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` = 102088 limit 1
      210μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 102088
      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 = 102088 and content_type = 'article' order by status desc limit 1
      370μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 295 and cd.sub_disease_id = 300 and content_id!=102088 and cd.content_type = 'article' order by rand() limit 20
      126msalphaeurekaselec_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` = 176397 limit 1
      290μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 176397
      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` = 'CTMC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      350μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CTMC
      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 = '102088' and content_type = 'a' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      360μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2186
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '9668' 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) )
      270μ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 = '2703' 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) )
      260μ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 <= 873336012 and j.to_ip >=873336012 )) and ((j.from_date <= 1740345383 and j.to_date >= 1740345383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2703) 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 <= 873336012 and j.to_ip >=873336012 )) and ((j.from_date <= 1740345383 and j.to_date >= 1740345383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2703) 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 <= 873336012 and j.to_ip >=873336012 )) and ((j.from_date <= 1740345383 and j.to_date >= 1740345383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2703)
      11.15msalphaeurekaselec_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 <= 873336012 and j.to_ip >=873336012 )) and ((j.from_date <= 1740345383 and j.to_date >= 1740345383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9668) 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 <= 873336012 and j.to_ip >=873336012 )) and ((j.from_date <= 1740345383 and j.to_date >= 1740345383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9668) 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 <= 873336012 and j.to_ip >=873336012 )) and ((j.from_date <= 1740345383 and j.to_date >= 1740345383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9668)
      570μ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 <= 873336012 and j.to_ip >=873336012 )) and ((j.from_date <= 1740345383 and j.to_date >= 1740345383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 102088) 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 <= 873336012 and j.to_ip >=873336012 )) and ((j.from_date <= 1740345383 and j.to_date >= 1740345383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 102088) 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 <= 873336012 and j.to_ip >=873336012 )) and ((j.from_date <= 1740345383 and j.to_date >= 1740345383 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 102088)
      540μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2329
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `article` where `first_page` < '140' and is_uploaded = 1 and issue_id = 9668 order by cast(first_page as SIGNED) desc limit 1
      430μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 140
      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` > '152' and is_uploaded = 1 and issue_id = 9668 order by cast(first_page as SIGNED) asc limit 1
      370μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 152
      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'
      150μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      170μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 102088 limit 1
      2.47msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 102088
      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` = 38 and `b`.`banner_from_date` <= 1740345383 and `b`.`banner_to_date` >= 1740345383 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.11msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 38
      • 3: 1740345383
      • 4: 1740345383
      • 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` = 38 and `b`.`banner_from_date` <= 1740345383 and `b`.`banner_to_date` >= 1740345383 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.18msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 38
      • 3: 1740345383
      • 4: 1740345383
      • 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='bb0ceb571e2efdca441f799ad22a9c71'
      260μ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
        3YlH3iTqy84aEAj90jUMfXfsnYTLOzGacBvjw1Hk
        uc_cart_id
        bb0ceb571e2efdca441f799ad22a9c71
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/102088" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/102088
        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=eyJpdiI6Ii84U1JYNGtYY09RNFhwd1JvS1NSNUE9PSIsInZhbHVlIjoicy9pS2xxRmRpM0xsdFRqUzlwYUVRVUdRQ054THlCSmZJSnhHdGt1TDZjaz0iLCJtYWMiOiIwNTk2ZjhkZWM3NTZmMjUxNjcyYTBmZmQ1NDY3MjljYTBlOWYyZTBlMjBkMDJmOGM4MTM5MTA4M2EyNjg0MmI0IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6Ii84U1JYNGtYY09RNFhwd1JvS1NSNUE9PSIsInZhbHVlIjoicy9pS2xxRmRpM0xsdFRqUzlwYUVRVUdRQ054THlCSmZJSnhHdGt1TDZjaz0iLCJtYWMiOiIwNTk2ZjhkZWM3NTZm" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 23 Feb 2025 21:16:23 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjdoRTkwaFFCY0loaitueEFPbkdSOGc9PSIsInZhbHVlIjoiVGZNOVJ1bXc5YmtFODJqcTRXT1ZmSzF6azJ4Yk9KVjJFSUcxQkFaOUV3ZDB2UkVaeURqbHRlUmNxSkFGeW5EL2lOa09KVUtROGdld0Nwb0Z4MHFHY3NoWkdIY0FIYnVNby9NQ3pZMDNQRlF5eHZrQnRFMW16Z3NWb1A1TWNRRjUiLCJtYWMiOiI2NGFlZTlkN2FjZTJiZTMxNDI0ZjcxNzg3YzAyN2FlNmQ1Mzk2ZTMwYmQ4ZGRmNDY1YTY5M2U3OTkzNDc2NTE3IiwidGFnIjoiIn0%3D; expires=Wed, 26 Feb 2025 09:16:23 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjdoRTkwaFFCY0loaitueEFPbkdSOGc9PSIsInZhbHVlIjoiVGZNOVJ1bXc5YmtFODJqcTRXT1ZmSzF6azJ4Yk9KVjJFSUcxQkFaOUV3ZDB2UkVaeURqbHRlUmNxSkFGeW5EL2lOa09KV" 1 => "alphaeurekaselectnet_session=eyJpdiI6Im9idmVsaEprb2V6OE1wUVduSmNFa2c9PSIsInZhbHVlIjoieVVIWERZNFk1anVZMHFTS25ic3poTzlLUWJacVJCaU5GQmRwd2o0SHFhUUhzaGp1TGxlaUgvaFovdG5qVFZMK0pXdHozSDIrZW5sN3U4dkd1SFlCTWlSSGlISkV5ZmVTcFp2cGhYVmRWVGhtRXpnc1Nid01DZWo5UGpGM2pBYkoiLCJtYWMiOiIyMzBmMzFmMmFhMDlhOGMwY2Y2YmRjNmQxMGMzMDQxODRkNDUyYmMwYTZjYzUwYmI5ZmEyM2E1MmY2MDQzNmQxIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Im9idmVsaEprb2V6OE1wUVduSmNFa2c9PSIsInZhbHVlIjoieVVIWERZNFk1anVZMHFTS25ic3poTzlLUWJacVJCaU5GQmRwd2o0SHFhUUhzaGp1TGxlaUgvaFo" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjdoRTkwaFFCY0loaitueEFPbkdSOGc9PSIsInZhbHVlIjoiVGZNOVJ1bXc5YmtFODJqcTRXT1ZmSzF6azJ4Yk9KVjJFSUcxQkFaOUV3ZDB2UkVaeURqbHRlUmNxSkFGeW5EL2lOa09KVUtROGdld0Nwb0Z4MHFHY3NoWkdIY0FIYnVNby9NQ3pZMDNQRlF5eHZrQnRFMW16Z3NWb1A1TWNRRjUiLCJtYWMiOiI2NGFlZTlkN2FjZTJiZTMxNDI0ZjcxNzg3YzAyN2FlNmQ1Mzk2ZTMwYmQ4ZGRmNDY1YTY5M2U3OTkzNDc2NTE3IiwidGFnIjoiIn0%3D; expires=Wed, 26-Feb-2025 09:16:23 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjdoRTkwaFFCY0loaitueEFPbkdSOGc9PSIsInZhbHVlIjoiVGZNOVJ1bXc5YmtFODJqcTRXT1ZmSzF6azJ4Yk9KVjJFSUcxQkFaOUV3ZDB2UkVaeURqbHRlUmNxSkFGeW5EL2lOa09KV" 1 => "alphaeurekaselectnet_session=eyJpdiI6Im9idmVsaEprb2V6OE1wUVduSmNFa2c9PSIsInZhbHVlIjoieVVIWERZNFk1anVZMHFTS25ic3poTzlLUWJacVJCaU5GQmRwd2o0SHFhUUhzaGp1TGxlaUgvaFovdG5qVFZMK0pXdHozSDIrZW5sN3U4dkd1SFlCTWlSSGlISkV5ZmVTcFp2cGhYVmRWVGhtRXpnc1Nid01DZWo5UGpGM2pBYkoiLCJtYWMiOiIyMzBmMzFmMmFhMDlhOGMwY2Y2YmRjNmQxMGMzMDQxODRkNDUyYmMwYTZjYzUwYmI5ZmEyM2E1MmY2MDQzNmQxIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Im9idmVsaEprb2V6OE1wUVduSmNFa2c9PSIsInZhbHVlIjoieVVIWERZNFk1anVZMHFTS25ic3poTzlLUWJacVJCaU5GQmRwd2o0SHFhUUhzaGp1TGxlaUgvaFo" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "3YlH3iTqy84aEAj90jUMfXfsnYTLOzGacBvjw1Hk" "uc_cart_id" => "bb0ceb571e2efdca441f799ad22a9c71" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/102088" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-23 21:16:23GET/article/102088314371