New Serotoninergic Ligands Containing Indolic and Methyl Indolic Nuclei: Synthesis and In Vitro Pharmacological Evaluation | Bentham Science
New Serotoninergic Ligands Containing Indolic and Methyl Indolic Nuclei: Synthesis and In Vitro Pharmacological Evaluation

Page: [517 - 530] Pages: 14

  • * (Excluding Mailing and Handling)

Abstract

Background: Serotonin is an important biogenic amine and is implicated in wideranging physiological and physiopathological processes. Pharmacological manipulation of the serotoninergic system is believed to have a great therapeutic potential.

Objectives: In order to identify selective ligands for 5-HT1A, 5-HT2A and 5-HT2C receptors two series of 4-substituted piperazine derivatives, bearing indolic or methyl indolic nuclei, were synthesized.

Methods: All the compounds, synthesized by standard solution methods, were evaluated for 5- HT1A, 5-HT2A and 5-HT2C receptors. The highest affine and selective compounds have been evaluated also on dopaminergic (D1 and D2) and adrenergic (α1A and α2A) receptors.

Results: Several of the newly synthesized molecules showed affinity in the nanomolar range for 5- HT1A, 5-HT2A and 5-HT2C receptors and moderate to no affinity for other relevant receptors (D1, D2, α1A and α2A).

Conclusion: Compounds 7f and 10a showed a nanomolar affinity towards 5-HT1A with an in vitro pharmacologic profile compatible with antipsychotic drugs.

Keywords: Arylpiperazine derivatives, binding assay, indolic and methyl indolic nuclei, synthesis, serotonin, 5-HT1A, 5-HT2A and 5-HT2C receptor ligands.

Graphical Abstract

[1]
Fredriksson, R.; Lagerström, M.C.; Lundin, L.G.; Schiöth, H.B. The G-protein-coupled receptors in the human genome form five main families. Phylogenetic analysis, paralogon groups, and fingerprints. Mol. Pharmacol., 2003, 63(6), 1256-1272.
[http://dx.doi.org/10.1124/mol.63.6.1256] [PMID: 12761335]
[2]
Nichols, D.E.; Nichols, C.D. Serotonin receptors. Chem. Rev., 2008, 108(5), 1614-1641.
[http://dx.doi.org/10.1021/cr078224o] [PMID: 18476671]
[3]
Siddiqui, E.J.; Shabbir, M.; Mikhailidis, D.P.; Thompson, C.S.; Mumtaz, F.H. The role of serotonin (5-hydroxytryptamine1A and 1B) receptors in prostate cancer cell proliferation. J. Urol., 2006, 176(4 Pt 1), 1648-1653.
[http://dx.doi.org/10.1016/j.juro.2006.06.087] [PMID: 16952708]
[4]
Jones, B.J.; Blackburn, T.P. The medical benefit of 5-HT research. Pharmacol. Biochem. Behav., 2002, 71(4), 555-568.
[http://dx.doi.org/10.1016/S0091-3057(01)00745-6] [PMID: 11888547]
[5]
Parker, M.A.; Kurrasch, D.M.; Nichols, D.E. The role of lipophilicity in determining binding affinity and functional activity for 5-HT2A receptor ligands. Bioorg. Med. Chem., 2008, 16(8), 4661-4669.
[http://dx.doi.org/10.1016/j.bmc.2008.02.033] [PMID: 18296055]
[6]
Shimada, I.; Maeno, K.; Kazuta, K.; Kubota, H.; Kimizuka, T.; Kimura, Y.; Hatanaka, K.; Naitou, Y.; Wanibuchi, F.; Sakamoto, S.; Tsukamoto, S. Synthesis and structure-activity relationships of a series of substituted 2-(1H-furo[2,3-g]indazol-1-yl)ethylamine derivatives as 5-HT2C receptor agonists. Bioorg. Med. Chem., 2008, 16(4), 1966-1982.
[http://dx.doi.org/10.1016/j.bmc.2007.10.100] [PMID: 18035544]
[7]
López-Rodríguez, M.L.; Ayala, D.; Benhamú, B.; Morcillo, M.J.; Viso, A. Arylpiperazine derivatives acting at 5-HT(1A) receptors. Curr. Med. Chem., 2002, 9(4), 443-469.
[http://dx.doi.org/10.2174/0929867023371030] [PMID: 11945120]
[8]
Fiorino, F.; Perissutti, E.; Severino, B.; Santagada, V.; Cirillo, D.; Terracciano, S.; Massarelli, P.; Bruni, G.; Collavoli, E.; Renner, C.; Caliendo, G. New 5-hydroxytryptamine(1A) receptor ligands containing a norbornene nucleus: synthesis and in vitro pharmacological evaluation. J. Med. Chem., 2005, 48(17), 5495-5503.
[http://dx.doi.org/10.1021/jm050246k] [PMID: 16107148]
[9]
Fiorino, F.; Severino, B.; De Angelis, F.; Perissutti, E.; Frecentese, F.; Massarelli, P.; Bruni, G.; Collavoli, E.; Santagada, V.; Caliendo, G. Synthesis and in-vitro pharmacological evaluation of new 5-HT1A receptor ligands containing a benzotriazinone nucleus. Arch. Pharm. (Weinheim), 2008, 341(1), 20-27.
[http://dx.doi.org/10.1002/ardp.200700151] [PMID: 18072244]
[10]
Frecentese, F.; Fiorino, F.; Perissutti, E.; Severino, B.; Magli, E.; Esposito, A.; De Angelis, F.; Massarelli, P.; Nencini, C.; Viti, B.; Santagada, V.; Caliendo, G. Efficient microwave combinatorial synthesis of novel indolic arylpiperazine derivatives as serotoninergic ligands. Eur. J. Med. Chem., 2010, 45(2), 752-759.
[http://dx.doi.org/10.1016/j.ejmech.2009.11.023] [PMID: 19954866]
[11]
Fiorino, F.; Severino, B.; De Angelis, F.; Perissutti, E.; Magli, E.; Frecentese, F.; Esposito, A.; Massarelli, P.; Nencini, C.; Viti, B.; Santagada, V.; Caliendo, G. Synthesis and in vitro pharmacological evaluation of a new series of 5-HT1A 5-HT2A and 5-HT2C receptor ligands containing a norbornene nucleus. Pharmazie, 2009, 64(9), 555-564.
[PMID: 19827295]
[12]
Fiorino, F.; Severino, B.; De Angelis, F.; Perissutti, E.; Magli, E.; Frecentese, F.; Esposito, A.; Massarelli, P.; Nencini, C.; Santagada, V.; Caliendo, G. New 5-HT(1A) receptor ligands containing a N′-cyanoisonicotinamidine nucleus: Synthesis and in vitro pharmacological evaluation. Bioorg. Med. Chem. Lett., 2010, 20(9), 2978-2982.
[http://dx.doi.org/10.1016/j.bmcl.2010.02.106] [PMID: 20347301]
[13]
Fiorino, F.; Magli, E.; Severino, B.; Corvino, A.; Ciano, A.; Perissutti, E.; Frecentese, F.; Massarelli, P.; Nencini, C.; Santagada, V.; Caliendo, G. Synthesis and in vitro pharmacological evaluation of novel 2-hydroxypropyl-4-arylpiperazine derivatives as serotoninergic ligands. Arch. Pharm. (Weinheim), 2014, 347(10), 698-706.
[http://dx.doi.org/10.1002/ardp.201400174] [PMID: 25113046]
[14]
Fiorino, F.; Magli, E.; Perissutti, E.; Severino, B.; Frecentese, F.; Esposito, A.; De Angelis, F.; Incisivo, G.M.; Massarelli, P.; Nencini, C.; Di Gennaro, E.; Budillon, A.; Di Cintio, A.; Santagada, V.; Caliendo, G. Synthesis of 1-naphtylpiperazine derivatives as serotoninergic ligands and their evaluation as antiproliferative agents. Eur. J. Med. Chem., 2011, 46(6), 2206-2216.
[http://dx.doi.org/10.1016/j.ejmech.2011.03.001] [PMID: 21440338]
[15]
Fiorino, F.; Severino, B.; Magli, E.; Perissutti, E.; Frecentese, F.; Esposito, A.; Incisivo, G.M.; Ciano, A.; Massarelli, P.; Nencini, C.; Santagada, V.; Caliendo, G. New potent 5-HT(2A) receptor ligands containing an N′-cyanopicolinamidine nucleus: Synthesis and in vitro pharmacological evaluation. Eur. J. Med. Chem., 2012, 47(1), 520-529.
[http://dx.doi.org/10.1016/j.ejmech.2011.11.023] [PMID: 22133459]
[16]
Fiorino, F.; Severino, B.; Magli, E.; Ciano, A.; Caliendo, G.; Santagada, V.; Frecentese, F.; Perissutti, E. 5-HT(1A) receptor: An old target as a new attractive tool in drug discovery from central nervous system to cancer. J. Med. Chem., 2014, 57(11), 4407-4426.
[http://dx.doi.org/10.1021/jm400533t] [PMID: 24295064]
[17]
Fiorino, F.; Ciano, A.; Magli, E.; Severino, B.; Corvino, A.; Perissutti, E.; Frecentese, F.; Di Vaio, P.; Izzo, A.A.; Capasso, R.; Massarelli, P.; Nencini, C.; Rossi, I.; Kędzierska, E.; Orzelska-Gòrka, J.; Bielenica, A.; Santagada, V.; Caliendo, G. Synthesis, in vitro and in vivo pharmacological evaluation of serotoninergic ligands containing an isonicotinic nucleus. Eur. J. Med. Chem., 2016, 110, 133-150.
[http://dx.doi.org/10.1016/j.ejmech.2016.01.021] [PMID: 26820556]
[18]
Fiorino, F.; Magli, E.; Kędzierska, E.; Ciano, A.; Corvino, A.; Severino, B.; Perissutti, E.; Frecentese, F.; Di Vaio, P.; Saccone, I.; Izzo, A.A.; Capasso, R.; Massarelli, P.; Rossi, I.; Orzelska-Gòrka, J.; Kotlińska, J.H.; Santagada, V.; Caliendo, G. New 5-HT1A, 5HT2A and 5HT2C receptor ligands containing a picolinic nucleus: Synthesis, in vitro and in vivo pharmacological evaluation. Bioorg. Med. Chem., 2017, 25(20), 5820-5837.
[http://dx.doi.org/10.1016/j.bmc.2017.09.018] [PMID: 28943244]
[19]
Corvino, A.; Fiorino, F.; Severino, B.; Saccone, I.; Frecentese, F.; Perissutti, E.; Di Vaio, P.; Santagada, V.; Caliendo, G.; Magli, E. The role of 5-HT1A receptor in cancer as a new opportunity in medicinal chemistry. Curr. Med. Chem., 2018, 25(27), 3214-3227.
[http://dx.doi.org/10.2174/0929867325666180209141650] [PMID: 29424302]
[20]
Cheng, Y.; Prusoff, W.H. Relationship between the inhibition constant (K1) and the concentration of inhibitor which causes 50 per cent inhibition (I50) of an enzymatic reaction. Biochem. Pharmacol., 1973, 22(23), 3099-3108.
[http://dx.doi.org/dx.doi.org 10.1016/0006-2952(73)90196-2] [PMID: 4202581]
[21]
Huang, J.; He, F.; Huang, M.; Liu, X.; Xiong, Y.; Huang, Y.; Zhu, L.; Yang, Y.; Xu, X.; Yuan, M. Novel naftopidil-related derivatives and their biological effects as alpha1-adrenoceptors antagonists and antiproliferative agents. Eur. J. Med. Chem., 2015, 96, 83-91.
[http://dx.doi.org/10.1016/j.ejmech.2015.04.005] [PMID: 25874333]
[22]
Zlatović, M.V.; Sukalović, V.V.; Schneider, C.; Roglić, G.M. Interaction of arylpiperazine ligands with the hydrophobic part of the 5-HT1A receptor binding site. Bioorg. Med. Chem., 2006, 14(9), 2994-3001.
[http://dx.doi.org/10.1016/j.bmc.2005.12.023] [PMID: 16403641]
[23]
Ngo, T.; Nicholas, T.J.; Chen, J.; Finch, A.M.; Griffith, R. 5-HT1A receptor pharmacophores to screen for off-target activity of α1 adrenoceptor antagonists. J. Comput. Aided Mol. Des., 2013, 27(4), 305-319.
[http://dx.doi.org/10.1007/s10822-013-9647-5] [PMID: 23625023]
Request history8.2.27PHP Version369msRequest Duration27MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[08:22:03] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[08:22:03] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[08:22:03] LOG.warning: Function strftime() is deprecated in /home/betabenthamscien/public_html/stor...
  • warninglog[08:22:03] LOG.warning: Function strftime() is deprecated in /home/betabenthamscien/public_html/stor...
  • Booting (157ms)time
  • Application (212ms)time
  • 1 x Application (57.37%)
    212ms
    1 x Booting (42.62%)
    157ms
    8 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.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
    35 statements were executed, 2 of which were duplicates, 33 unique. Show only duplicated99.12ms
    • 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 ('309594233','',1,1736929323,1736929323) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1736929323
      1.5msalphaeurekaselec_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 ('309594233','/article/98792',1,1736929323,1736929323)
      1.64msalphaeurekaselec_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 >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) 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 >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) 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 >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) 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 >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) 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 >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) 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 >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 309594233 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309594233) limit 1
      6.13msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 309594233
      • 1: 309594233
      • 2: 309594233
      • 3: 309594233
      • 4: 309594233
      • 5: 309594233
      • 6: 309594233
      • 7: 309594233
      • 8: 309594233
      • 9: 309594233
      • 10: 309594233
      • 11: 309594233
      • 12: 309594233
      • 13: 309594233
      • 14: 309594233
      • 15: 309594233
      Backtrace
      • 14. app/Models/UserAccess/UserAccess.php:784
      • 15. middleware::check_user_access:63
      • 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=98792
      930μ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` = 50 limit 1
      1.09msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 50
      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=50) and sj.journal_id!=50 group by `j`.`nid`) as `aggregate_table`
      1.23msalphaeurekaselec_live_10_06_2022Subject.php#198
      Backtrace
      • 16. app/Models/Subject.php:198
      • 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=50) and sj.journal_id!=50 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      990μsalphaeurekaselec_live_10_06_2022Subject.php#198
      Backtrace
      • 14. app/Models/Subject.php:198
      • 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=50) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2msalphaeurekaselec_live_10_06_2022Subject.php#218
      Backtrace
      • 16. app/Models/Subject.php:218
      • 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=50) 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.82msalphaeurekaselec_live_10_06_2022Subject.php#218
      Backtrace
      • 14. app/Models/Subject.php:218
      • 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` = '98792'
      280μsalphaeurekaselec_live_10_06_2022Keywords.php#85
      Bindings
      • 0: 98792
      Backtrace
      • 13. app/Models/Keywords.php:85
      • 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` = '98792'
      2.07msalphaeurekaselec_live_10_06_2022Article.php#1569
      Bindings
      • 0: 98792
      Backtrace
      • 13. app/Models/Article.php:1569
      • 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 , `au`.*, (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` = '98792' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.18msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 98792
      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
      350μsalphaeurekaselec_live_10_06_2022BundleOffer.php#113
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:113
      • 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
      720μsalphaeurekaselec_live_10_06_2022Article.php#1959
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1959
      • 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 = 50 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      38.75msalphaeurekaselec_live_10_06_2022Issue.php#295
      Backtrace
      • 11. app/Models/Issue.php:295
      • 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 = 50 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`last_modified` desc
      12.9msalphaeurekaselec_live_10_06_2022Article.php#527
      Backtrace
      • 13. app/Models/Article.php:527
      • 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 = 50 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`last_modified` desc
      11.26msalphaeurekaselec_live_10_06_2022Article.php#527
      Backtrace
      • 13. app/Models/Article.php:527
      • 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` = 98792 limit 1
      330μsalphaeurekaselec_live_10_06_2022Article.php#743
      Bindings
      • 0: 98792
      Backtrace
      • 14. app/Models/Article.php:743
      • 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 = 98792 and content_type = 'article' order by status desc limit 1
      360μsalphaeurekaselec_live_10_06_2022Article.php#750
      Backtrace
      • 11. app/Models/Article.php:750
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 172545 limit 1
      240μsalphaeurekaselec_live_10_06_2022Meta.php#59
      Bindings
      • 0: 172545
      Backtrace
      • 14. app/Models/Meta.php:59
      • 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
      300μsalphaeurekaselec_live_10_06_2022BundleOffer.php#113
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:113
      • 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` = 'MC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      360μsalphaeurekaselec_live_10_06_2022Article.php#2024
      Bindings
      • 0: MC
      Backtrace
      • 13. app/Models/Article.php:2024
      • 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 = '98792' 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) )
      440μ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 = '9763' 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) )
      450μ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 = '2692' 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) )
      440μ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 <= 309594233 and j.to_ip >=309594233 )) and ((j.from_date <= 1736929323 and j.to_date >= 1736929323 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2692) 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 <= 309594233 and j.to_ip >=309594233 )) and ((j.from_date <= 1736929323 and j.to_date >= 1736929323 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2692) 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 <= 309594233 and j.to_ip >=309594233 )) and ((j.from_date <= 1736929323 and j.to_date >= 1736929323 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2692)
      990μsalphaeurekaselec_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 <= 309594233 and j.to_ip >=309594233 )) and ((j.from_date <= 1736929323 and j.to_date >= 1736929323 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9763) 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 <= 309594233 and j.to_ip >=309594233 )) and ((j.from_date <= 1736929323 and j.to_date >= 1736929323 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9763) 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 <= 309594233 and j.to_ip >=309594233 )) and ((j.from_date <= 1736929323 and j.to_date >= 1736929323 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9763)
      900μ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 <= 309594233 and j.to_ip >=309594233 )) and ((j.from_date <= 1736929323 and j.to_date >= 1736929323 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 98792) 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 <= 309594233 and j.to_ip >=309594233 )) and ((j.from_date <= 1736929323 and j.to_date >= 1736929323 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 98792) 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 <= 309594233 and j.to_ip >=309594233 )) and ((j.from_date <= 1736929323 and j.to_date >= 1736929323 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 98792)
      910μ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` < '517' and is_uploaded = 1 and issue_id = 9763 order by cast(first_page as SIGNED) desc limit 1
      740μsalphaeurekaselec_live_10_06_2022Article.php#1818
      Bindings
      • 0: 517
      Backtrace
      • 14. app/Models/Article.php:1818
      • 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` > '530' and is_uploaded = 1 and issue_id = 9763 order by cast(first_page as SIGNED) asc limit 1
      630μsalphaeurekaselec_live_10_06_2022Article.php#1830
      Bindings
      • 0: 530
      Backtrace
      • 14. app/Models/Article.php:1830
      • 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'
      250μ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
      320μ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` = 98792 limit 1
      3.98msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 98792
      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` = 50 and `b`.`banner_from_date` <= 1736929323 and `b`.`banner_to_date` >= 1736929323 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.25msalphaeurekaselec_live_10_06_2022Banner.php#189
      Bindings
      • 0: 1
      • 1: J
      • 2: 50
      • 3: 1736929323
      • 4: 1736929323
      • 5: A
      Backtrace
      • 13. app/Models/Banner.php:189
      • 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='45861fa6e182a8048787071ec82f4041'
      390μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._main_menu:13
      • 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
        uNacqMvcDGKGiR5Zs7PkzC6UVNihG6v8Cipz5J5q
        uc_cart_id
        45861fa6e182a8048787071ec82f4041
        _previous
        array:1 [ "url" => "https://beta.benthamscience.com/article/98792" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/98792
        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:16 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "beta.benthamscience.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_cookies
        []
        
        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 => "Wed, 15 Jan 2025 08:22:03 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjAxUTNidjBzUzlyZ0F2dmR5MjRoNXc9PSIsInZhbHVlIjoiUENjMjhGczBYWG1CWG9mSE93REhkSFFnTENsU2JROS9rUzFtRTVuRk9oZUtpVkhPTXh5cWdLZENtVFJVWGduTUtsc0ZUNjdTblYzRnpJS28rZzRhUjJuVE9RMVlDYTJvanZTOWZlQUtPd3NqTGl6YW1GbCtPbGsydGI3dnZTY2UiLCJtYWMiOiI2YTgxYjk5OTlhZmEyNGM3MTcyOTk1MzdjMDVmOTM3NTk4Mzc2ZTgyMTQ1ZWY1MTQ2ODI4NGMxOTk1MDcwMmUyIiwidGFnIjoiIn0%3D; expires=Fri, 17 Jan 2025 20:22:03 GMT; Max-Age=216000; path=/; secure; samesite=strictXSRF-TOKEN=eyJpdiI6IjAxUTNidjBzUzlyZ0F2dmR5MjRoNXc9PSIsInZhbHVlIjoiUENjMjhGczBYWG1CWG9mSE93REhkSFFnTENsU2JROS9rUzFtRTVuRk9oZUtpVkhPTXh5cWdLZENtVFJVWGduTUtsc0ZUN" 1 => "eurekaselectnew_session=eyJpdiI6IkFHYVNKYzBZSDdkTitTL1BzRytnMFE9PSIsInZhbHVlIjoicTdLWWYvSUNLN0hOMHQzaktCN2J6eWx2NVdzcDVlWUlNL2x6Vkg4clRBVEZXa2FGc053Q00xQmExd1FvWVlVMUNHeFFVeG5iL05vVFNyQWZGcVJBVWZ3azFKelBWdjYxZ1k0SC95bGxUQkJvMld3eG5sbG1GRE1mdnhOb0ZZYmYiLCJtYWMiOiJmMTkyOWNkMjkzMWVjNTgwMGZjZWU2Yjk4ZjNmMGM3YzBjNzEzMjdhNTBlODIyYjE3YzIwYTQyZjY2NzRkYzQ4IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=stricteurekaselectnew_session=eyJpdiI6IkFHYVNKYzBZSDdkTitTL1BzRytnMFE9PSIsInZhbHVlIjoicTdLWWYvSUNLN0hOMHQzaktCN2J6eWx2NVdzcDVlWUlNL2x6Vkg4clRBVEZXa2FGc053Q00xQmExd1Fv" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjAxUTNidjBzUzlyZ0F2dmR5MjRoNXc9PSIsInZhbHVlIjoiUENjMjhGczBYWG1CWG9mSE93REhkSFFnTENsU2JROS9rUzFtRTVuRk9oZUtpVkhPTXh5cWdLZENtVFJVWGduTUtsc0ZUNjdTblYzRnpJS28rZzRhUjJuVE9RMVlDYTJvanZTOWZlQUtPd3NqTGl6YW1GbCtPbGsydGI3dnZTY2UiLCJtYWMiOiI2YTgxYjk5OTlhZmEyNGM3MTcyOTk1MzdjMDVmOTM3NTk4Mzc2ZTgyMTQ1ZWY1MTQ2ODI4NGMxOTk1MDcwMmUyIiwidGFnIjoiIn0%3D; expires=Fri, 17-Jan-2025 20:22:03 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjAxUTNidjBzUzlyZ0F2dmR5MjRoNXc9PSIsInZhbHVlIjoiUENjMjhGczBYWG1CWG9mSE93REhkSFFnTENsU2JROS9rUzFtRTVuRk9oZUtpVkhPTXh5cWdLZENtVFJVWGduTUtsc0ZUN" 1 => "eurekaselectnew_session=eyJpdiI6IkFHYVNKYzBZSDdkTitTL1BzRytnMFE9PSIsInZhbHVlIjoicTdLWWYvSUNLN0hOMHQzaktCN2J6eWx2NVdzcDVlWUlNL2x6Vkg4clRBVEZXa2FGc053Q00xQmExd1FvWVlVMUNHeFFVeG5iL05vVFNyQWZGcVJBVWZ3azFKelBWdjYxZ1k0SC95bGxUQkJvMld3eG5sbG1GRE1mdnhOb0ZZYmYiLCJtYWMiOiJmMTkyOWNkMjkzMWVjNTgwMGZjZWU2Yjk4ZjNmMGM3YzBjNzEzMjdhNTBlODIyYjE3YzIwYTQyZjY2NzRkYzQ4IiwidGFnIjoiIn0%3D; path=/; secure; httponlyeurekaselectnew_session=eyJpdiI6IkFHYVNKYzBZSDdkTitTL1BzRytnMFE9PSIsInZhbHVlIjoicTdLWWYvSUNLN0hOMHQzaktCN2J6eWx2NVdzcDVlWUlNL2x6Vkg4clRBVEZXa2FGc053Q00xQmExd1Fv" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "uNacqMvcDGKGiR5Zs7PkzC6UVNihG6v8Cipz5J5q" "uc_cart_id" => "45861fa6e182a8048787071ec82f4041" "_previous" => array:1 [ "url" => "https://beta.benthamscience.com/article/98792" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-01-15 08:22:03GET/article/9879248351