Generic placeholder image

Current Pharmaceutical Design

Editor-in-Chief

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

General Research Article

Synthetic Optimization of Ellipticine and Antitumor Activity of Novel Hexacyclic Derivatives of Ellipticine

Author(s): Jingjing Lin, Mei Tang, Ru Zhao, Qianqian Du, Longying Shen, Guohua Du, Yafen Zhang, Yan Li* and Xiandao Pan*

Volume 25, Issue 33, 2019

Page: [3578 - 3589] Pages: 12

DOI: 10.2174/1381612825666190404122650

Price: $65

Abstract

Background: For decades, a great deal of research work has been done to synthesize ellipticine and its derivatives because of their potential antitumor properties and anti-HIV activities. However, the resonance structures in different media, a low level of solubility at physiological pH and systemic toxicity have prevented the use of ellipticine as a therapeutic agent. Besides, the low yield and complex steps of ellipticine synthesis limit its application.

Methods: A high-yield synthetic procedure of ellipticine has been optimized, and the total yield was up to 50% without silica gel column chromatography. Novel hexacyclic ellipticine derivatives were synthesized by coupling ellipticine with o-aminobenzoic acid. Their cytotoxicities against HCT116, MGC803, HT29 and MCF-7 tumor cells were evaluated.

Results: The synthesis process of ellipticine was optimized, and the total yield of the synthetic route was increased to 50% through several operation steps optimization. Fourteen ellipticine hexacyclic derivatives were synthesized. The synthetic compounds were screened for anti-tumor activity in vivo and in vitro, and some of the derivatives had good anti-tumor activity.

Conclusion: Compared with ellipticine, the compound 1l showed higher antitumor activity and better tolerance to tumor models. The compound 1l treatment increased the percentage of late apoptotic cells from 3.1% (DMSO) to 21.6% (20.0 μM) in NCI-H460 cells. It also was observed the effect of 1l on G2 phase arrest was similar as that of ellipticine. The mechanism of action indicated compound 1l could be a topoisomerase IIα poison. These studies provided the basis for the pharmacodynamics and toxicology of ellipticine, and further clarifies the structureactivity relationship of antitumor activity of ellipticine.

Keywords: Ellipticine, hexacyclic derivatives, synthesis, antitumor activity, topoisomerase IIα inhibitor, xenograft model.

[1]
Roviello GN, Iannitti R, Roviello V, Palumbo R, Simonyan H, Vicidomini C. Synthesis and biological evaluation of a novel Amadori compound. Amino Acids 2017; 49(2): 327-35.
[http://dx.doi.org/10.1007/s00726-016-2363-4] [PMID: 27864693]
[2]
Roviello GN, Iannitti R, Palumbo R, Simonyan H, Vicidomini C, Roviello V. Lac-L-TTA, a novel lactose-based amino acid-sugar conjugate for anti-metastatic applications. Amino Acids 2017; 49(8): 1347-53.
[http://dx.doi.org/10.1007/s00726-017-2433-2] [PMID: 28478584]
[3]
Carella A, Roviello V, Iannitti R, et al. Evaluating the biological properties of synthetic 4-nitrophenyl functionalized benzofuran derivatives with telomeric DNA binding and antiproliferative activities. Int J Biol Macromol 2019; 121: 77-88.
[http://dx.doi.org/10.1016/j.ijbiomac.2018.09.153] [PMID: 30261256]
[4]
Musumeci D, Roviello GN, Rigione G, et al. Benzodifuran derivatives as potential antiproliferative agents: possible correlation between their bioactivity and aggregation properties. ChemPlusChem 2017; 82: 251-60.
[http://dx.doi.org/10.1002/cplu.201600547]
[5]
Platellaa C, Guidab S, Bonmassar L, et al. Antitumour activity of resveratrol on human melanoma cells: A possible mechanism related to its interaction with malignant cell telomerase. Biochim Biophys Acta Gen Subj 2017; 1861(11PtA): 2843-51.
[http://dx.doi.org/10.1016/j.bbagen.2017.08.001]
[6]
Dalton LK, Demerac S, Elmes BC, et al. Synthesis of the tumour-inhibitory alkaloids, ellipticine, 9-methoxyellipticine, and related pyrido [4,3-b] carbazoles. Aust J Chem 1967; 20: 2715-7.
[http://dx.doi.org/10.1071/CH9672715]
[7]
Knölker HJ, Reddy KR. Isolation and synthesis of biologically active carbazole alkaloids. Chem Rev 2002; 102(11): 4303-427.
[http://dx.doi.org/10.1021/cr020059j] [PMID: 12428991]
[8]
Schmidt AW, Reddy KR, Knölker HJ. Occurrence, biogenesis, and synthesis of biologically active carbazole alkaloids. Chem Rev 2012; 112(6): 3193-328.
[http://dx.doi.org/10.1021/cr200447s] [PMID: 22480243]
[9]
Gribble GW. Synthesis and antitumor activity of ellipticine alkaloids and related compounds. Alkaloids 1990; 39: 239-352.
[http://dx.doi.org/10.1016/S0099-9598(08)60169-8]
[10]
Sappati S, Hassanali A, Gebauer R, Ghosh P. Nuclear quantum effects in a HIV/cancer inhibitor: The case of ellipticine. J Chem Phys 2016; 145(20): 205102-12.
[http://dx.doi.org/10.1063/1.4968046] [PMID: 27908111]
[11]
Auclair C, Multimodal R. Multimodal action of antitumor agents on DNA: the ellipticine series. Arch Biochem Biophys 1987; 259(1): 1-14.
[http://dx.doi.org/10.1016/0003-9861(87)90463-2] [PMID: 3318697]
[12]
Fung SY, Duhamel J, Chen P. Solvent effect on the photophysical properties of the anticancer agent ellipticine. J Phys Chem A 2006; 110(40): 11446-54.
[http://dx.doi.org/10.1021/jp062778y] [PMID: 17020255]
[13]
Kim JY, Lee SG, Chung JY, et al. Ellipticine induces apoptosis in human endometrial cancer cells: the potential involvement of reactive oxygen species and mitogen-activated protein kinases. Toxicology 2011; 289(2-3): 91-102.
[http://dx.doi.org/10.1016/j.tox.2011.07.014] [PMID: 21843585]
[14]
Vann KR, Ergün Y, Zencir S, Oncuoglu S, Osheroff N, Topcu Z. Inhibition of human DNA topoisomerase IIα by two novel ellipticine derivatives. Bioorg Med Chem Lett 2016; 26(7): 1809-12.
[http://dx.doi.org/10.1016/j.bmcl.2016.02.034] [PMID: 26906637]
[15]
Kotrbová V, Mrázová B, Moserová M, et al. Cytochrome b(5) shifts oxidation of the anticancer drug ellipticine by cytochromes P450 1A1 and 1A2 from its detoxication to activation, thereby modulating its pharmacological efficacy. Biochem Pharmacol 2011; 82(6): 669-80.
[http://dx.doi.org/10.1016/j.bcp.2011.06.003] [PMID: 21683692]
[16]
Banerjee A, Sanyal S, Majumder P, et al. Recognition of chromatin by the plant alkaloid, ellipticine as a dual binder. Biochem Biophys Res Commun 2015; 462(4): 352-7.
[http://dx.doi.org/10.1016/j.bbrc.2015.04.140] [PMID: 25960297]
[17]
Zsila F. The anticancer agent ellipticine binds to glycosaminoglycans at mildly acidic pH characteristic of the extracellular matrix of tumor tissues. RSC Adv 2016; 6: 810-4.
[http://dx.doi.org/10.1039/C5RA23437A]
[18]
Mamgain S, Sharma P, Pathak RK, et al. Computer aided screening of natural comppunds targeting the E6 protein of HPV using molecular docking. Biomed Informatics 2015; 115: 236-42.
[19]
Deane FM, O’Sullivan EC, Maguire AR, et al. Synthesis and evaluation of novel ellipticines as potential anti-cancer agents. Org Biomol Chem 2013; 11(8): 1334-44.
[http://dx.doi.org/10.1039/c2ob27186a] [PMID: 23314103]
[20]
Lin JJ, Yang YJ, Shen LY, et al. Recent progress in synthesis and pharmacological effects of ellipticine and its derivatives. Yao Xue Xue Bao 2017; 52: 1387-96.
[21]
Reddy NB, Burra VR, Ravindranath LK, et al. Synthesis and biological evaluation of benzimidazole fused ellipticine derivatives as anticancer agent. Monatshefte für Chemie-Chemical Monthly 2016; 147: 599-604.
[http://dx.doi.org/10.1007/s00706-016-1684-z]
[22]
Devraj R, Barrett JF, Fernandez JA, Katzenellenbogen JA, Cushman M. Design, synthesis, and biological evaluation of ellipticine-estradiol conjugates. J Med Chem 1996; 39(17): 3367-74.
[http://dx.doi.org/10.1021/jm9602930] [PMID: 8765520]
[23]
Banerjee S, Pabbathi A, Sekhar MC, Samanta A. Dual fluorescence of ellipticine: excited state proton transfer from solvent versus solvent mediated intramolecular proton transfer. J Phys Chem A 2011; 115(33): 9217-25.
[http://dx.doi.org/10.1021/jp206232b] [PMID: 21812494]
[24]
Honda T, Kato M, Inoue M, et al. Synthesis and antitumor activity of quaternary ellipticine glycosides, a series of novel and highly active antitumor agents. J Med Chem 1988; 31(7): 1295-305.
[http://dx.doi.org/10.1021/jm00402a007] [PMID: 3385725]
[25]
Prudent R, Moucadel V, Nguyen CH, et al. Antitumor activity of pyridocarbazole and benzopyridoindole derivatives that inhibit protein kinase CK2. Cancer Res 2010; 70(23): 9865-74.
[http://dx.doi.org/10.1158/0008-5472.CAN-10-0917] [PMID: 21118972]
[26]
Russell EG, O’Sullivan EC, Miller CM, Stanicka J, McCarthy FO, Cotter TG. Ellipticine derivative induces potent cytostatic effect in acute myeloid leukaemia cells. Invest New Drugs 2014; 32(6): 1113-22.
[http://dx.doi.org/10.1007/s10637-014-0140-3] [PMID: 25107543]
[27]
Russell EG, Guo J, O’Sullivan EC, O’Driscoll CM, McCarthy FO, Cotter TG. 7-formyl-10-methylisoellipticine, a novel ellipticine derivative, induces mitochondrial reactive oxygen species (ROS) and shows anti-leukaemic activity in mice. Invest New Drugs 2016; 34(1): 15-23.
[http://dx.doi.org/10.1007/s10637-015-0302-y] [PMID: 26559431]
[28]
Yang Y, Zhu C, Zhang M, et al. Condensation of anthranilic acids with pyridines to furnish pyridoquinazolones via pyridine dearomatization. Chem Commun (Camb) 2016; 52(87): 12869-72.
[http://dx.doi.org/10.1039/C6CC07365D] [PMID: 27735960]
[29]
Li DZ, Zhang QZ, Wang CY, et al. Synthesis and antitumor activity of novel substituted uracil-1′(N)-acetic acid ester derivatives of 20(S)-camptothecins. Eur J Med Chem 2017; 125: 1235-46.
[http://dx.doi.org/10.1016/j.ejmech.2016.11.013] [PMID: 27871039]
[30]
Sordet O, Khan QA, Kohn KW, Pommier Y. Apoptosis induced by topoisomerase inhibitors. Curr Med Chem Anticancer Agents 2003; 3(4): 271-90.
[http://dx.doi.org/10.2174/1568011033482378] [PMID: 12769773]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version363msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[23:29:30] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[23:29:30] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[23:29:30] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (97.06ms)time
  • Application (266ms)time
  • 1 x Application (73.26%)
    266ms
    1 x Booting (26.73%)
    97.06ms
    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 duplicated199ms
    • 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 ('314538714','',1,1739834970,1739834970) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739834970
      1.41msalphaeurekaselec_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 ('314538714','/article/97774',1,1739834970,1739834970)
      150μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) 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 >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) 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 >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) 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 >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) 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 >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) 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 >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314538714 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314538714) limit 1
      11.63msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314538714
      • 1: 314538714
      • 2: 314538714
      • 3: 314538714
      • 4: 314538714
      • 5: 314538714
      • 6: 314538714
      • 7: 314538714
      • 8: 314538714
      • 9: 314538714
      • 10: 314538714
      • 11: 314538714
      • 12: 314538714
      • 13: 314538714
      • 14: 314538714
      • 15: 314538714
      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=97774
      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` = 29 limit 1
      790μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 29
      Backtrace
      • 14. app/Models/Journal.php:64
      • 15. app/Http/Controllers/ArticleController.php:2516
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=29) and sj.journal_id!=29 group by `j`.`nid`) as `aggregate_table`
      990μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=29) and sj.journal_id!=29 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      810μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=29) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.03msalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 16. app/Models/Subject.php:220
      • 17. app/Http/Controllers/ArticleController.php:2518
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=29) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      940μsalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 14. app/Models/Subject.php:220
      • 15. app/Http/Controllers/ArticleController.php:2518
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `keywords` where `article_id` = '97774'
      300μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 97774
      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` = '97774'
      2.76msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 97774
      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` = '97774' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.43msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 97774
      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
      410μsalphaeurekaselec_live_10_06_2022Article.php#1960
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1960
      • 14. app/Http/Controllers/ArticleController.php:2062
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • Select j.subtitle, v.volume_id as volume_id,v.year_id,y.year as year,v.volume_name, v.total_no_of_issues, i.issue_id as issue_id,i.title as issue, i.publication_date as issue_pub_date from journal j join volume v on j.journal_id = v.journal_id join issue i on v.volume_id = i.volume_id join article a on a.issue_id = i.issue_id join year y on v.year_id = y.id where j.journal_id = 29 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      44.92msalphaeurekaselec_live_10_06_2022Issue.php#298
      Backtrace
      • 11. app/Models/Issue.php:298
      • 12. app/Http/Controllers/ArticleController.php:2068
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 1 and a.journal_id = 29 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      49.19msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2070
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 29 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      51.02msalphaeurekaselec_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` = 97774 limit 1
      220μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 97774
      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 = 97774 and content_type = 'article' order by status desc limit 1
      830μ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 = 16 and cd.sub_disease_id = 477 and content_id!=97774 and cd.content_type = 'article' order by rand() limit 20
      13.4msalphaeurekaselec_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` = 171275 limit 1
      200μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 171275
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      190μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CPD' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      290μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CPD
      Backtrace
      • 13. app/Models/Article.php:2025
      • 14. app/Http/Controllers/ArticleController.php:2112
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '97774' 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 = '9473' 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) )
      260μ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 = '2588' 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) )
      250μ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 <= 314538714 and j.to_ip >=314538714 )) and ((j.from_date <= 1739834970 and j.to_date >= 1739834970 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2588) 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 <= 314538714 and j.to_ip >=314538714 )) and ((j.from_date <= 1739834970 and j.to_date >= 1739834970 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2588) 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 <= 314538714 and j.to_ip >=314538714 )) and ((j.from_date <= 1739834970 and j.to_date >= 1739834970 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2588)
      7.79msalphaeurekaselec_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 <= 314538714 and j.to_ip >=314538714 )) and ((j.from_date <= 1739834970 and j.to_date >= 1739834970 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9473) 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 <= 314538714 and j.to_ip >=314538714 )) and ((j.from_date <= 1739834970 and j.to_date >= 1739834970 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9473) 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 <= 314538714 and j.to_ip >=314538714 )) and ((j.from_date <= 1739834970 and j.to_date >= 1739834970 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9473)
      530μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2297
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 314538714 and j.to_ip >=314538714 )) and ((j.from_date <= 1739834970 and j.to_date >= 1739834970 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 97774) 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 <= 314538714 and j.to_ip >=314538714 )) and ((j.from_date <= 1739834970 and j.to_date >= 1739834970 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 97774) 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 <= 314538714 and j.to_ip >=314538714 )) and ((j.from_date <= 1739834970 and j.to_date >= 1739834970 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 97774)
      530μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2329
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `article` where `first_page` < '3578' and is_uploaded = 1 and issue_id = 9473 order by cast(first_page as SIGNED) desc limit 1
      440μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 3578
      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` > '3589' and is_uploaded = 1 and issue_id = 9473 order by cast(first_page as SIGNED) asc limit 1
      370μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 3589
      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` = 97774 limit 1
      2.34msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 97774
      Backtrace
      • 16. app/Http/Controllers/ArticleController.php:2506
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select b.banner_link, b.banner_name, b.banner_script, b.banner_remarks, b.banner_file_name, b.banner_placement, bd.content_type, bd.content_id from `tbl_banner` as `b` inner join `tbl_banner_detail` as `bd` on `bd`.`banner_id` = `b`.`banner_id` inner join `users` as `u` on `u`.`id` = `b`.`updated_by` inner join `journal` as `j` on `j`.`journal_id` = `bd`.`content_id` where `b`.`banner_journal` = 1 and `bd`.`content_type` = 'J' and `bd`.`content_id` = 29 and `b`.`banner_from_date` <= 1739834970 and `b`.`banner_to_date` >= 1739834970 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.09msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 29
      • 3: 1739834970
      • 4: 1739834970
      • 5: A
      Backtrace
      • 13. app/Models/Banner.php:95
      • 14. app/Http/helpers.php:404
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • select b.banner_link, b.banner_name, b.banner_script, b.banner_remarks, b.banner_file_name, b.banner_placement, bd.content_type, bd.content_id from `tbl_banner` as `b` inner join `tbl_banner_detail` as `bd` on `bd`.`banner_id` = `b`.`banner_id` inner join `users` as `u` on `u`.`id` = `b`.`updated_by` inner join `journal` as `j` on `j`.`journal_id` = `bd`.`content_id` where `b`.`banner_journal` = 1 and `bd`.`content_type` = 'J' and `bd`.`content_id` = 29 and `b`.`banner_from_date` <= 1739834970 and `b`.`banner_to_date` >= 1739834970 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.07msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 29
      • 3: 1739834970
      • 4: 1739834970
      • 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='cedce6dad103302196ce3d09c2f75481'
      180μ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
        NuDISuGrunRtvlxKB348lK7rMlwBOiJX4wNBSRLZ
        uc_cart_id
        cedce6dad103302196ce3d09c2f75481
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/97774" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/97774
        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:8 [ "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
        []
        
        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 => "Mon, 17 Feb 2025 23:29:30 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IldlK25nZitneVBMWE9yeWRHak91UUE9PSIsInZhbHVlIjoiTUkzcUZqZXlmTnQ5UnhhaFVpV0RrWHlYYXVZL3ZRY0lSbC95YjM1NFJncndrc3V5aGgxdjhSeUFITkM4YWpmQUQ5TURJU3lmR2Z4aUczZmppaU56UTRaNkNIWDlaaG54elJTWjViaWpBMHVkdU9wUHdaUnhZTDNZdGJxZ20wdjgiLCJtYWMiOiI3NDI0NDA0NzNjNjMxM2YwNzVjYWJjOThjZDM5OTQxZGQ2OTk0ODEyMzA1MmUyMTQ5OGU1YWJkODJjYjQyNjJiIiwidGFnIjoiIn0%3D; expires=Thu, 20 Feb 2025 11:29:30 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IldlK25nZitneVBMWE9yeWRHak91UUE9PSIsInZhbHVlIjoiTUkzcUZqZXlmTnQ5UnhhaFVpV0RrWHlYYXVZL3ZRY0lSbC95YjM1NFJncndrc3V5aGgxdjhSeUFITkM4YWpmQUQ5TURJU" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ijh0dEdmem9YcWk5U3RicFNiWU96UGc9PSIsInZhbHVlIjoiT0piS3RUWWt3SXc0YzhDYjAwUDNTd2JsWUxMbXovWW82MzlXMWJiYUpObG5qbDFqdEo3STUwbUJHNlBZbVpUVlVCNElnbCtmSW1VeVd4T3NrL0JJcS90bUdBT0xIN1hkcklhaHBPZHdHbHJLUzZxdVNnYXQxOTRRbEFhQUQzdWciLCJtYWMiOiI0ZGNhNzVjMTU3MjkxYWRlYmNhMDhiOTAzNjM0MGIyYmM0NDk2NDI2ZDRlNDgwNDQ5NzM1NmZmYTVmYmViMjMxIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ijh0dEdmem9YcWk5U3RicFNiWU96UGc9PSIsInZhbHVlIjoiT0piS3RUWWt3SXc0YzhDYjAwUDNTd2JsWUxMbXovWW82MzlXMWJiYUpObG5qbDFqdEo3STUwbUJ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IldlK25nZitneVBMWE9yeWRHak91UUE9PSIsInZhbHVlIjoiTUkzcUZqZXlmTnQ5UnhhaFVpV0RrWHlYYXVZL3ZRY0lSbC95YjM1NFJncndrc3V5aGgxdjhSeUFITkM4YWpmQUQ5TURJU3lmR2Z4aUczZmppaU56UTRaNkNIWDlaaG54elJTWjViaWpBMHVkdU9wUHdaUnhZTDNZdGJxZ20wdjgiLCJtYWMiOiI3NDI0NDA0NzNjNjMxM2YwNzVjYWJjOThjZDM5OTQxZGQ2OTk0ODEyMzA1MmUyMTQ5OGU1YWJkODJjYjQyNjJiIiwidGFnIjoiIn0%3D; expires=Thu, 20-Feb-2025 11:29:30 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IldlK25nZitneVBMWE9yeWRHak91UUE9PSIsInZhbHVlIjoiTUkzcUZqZXlmTnQ5UnhhaFVpV0RrWHlYYXVZL3ZRY0lSbC95YjM1NFJncndrc3V5aGgxdjhSeUFITkM4YWpmQUQ5TURJU" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ijh0dEdmem9YcWk5U3RicFNiWU96UGc9PSIsInZhbHVlIjoiT0piS3RUWWt3SXc0YzhDYjAwUDNTd2JsWUxMbXovWW82MzlXMWJiYUpObG5qbDFqdEo3STUwbUJHNlBZbVpUVlVCNElnbCtmSW1VeVd4T3NrL0JJcS90bUdBT0xIN1hkcklhaHBPZHdHbHJLUzZxdVNnYXQxOTRRbEFhQUQzdWciLCJtYWMiOiI0ZGNhNzVjMTU3MjkxYWRlYmNhMDhiOTAzNjM0MGIyYmM0NDk2NDI2ZDRlNDgwNDQ5NzM1NmZmYTVmYmViMjMxIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ijh0dEdmem9YcWk5U3RicFNiWU96UGc9PSIsInZhbHVlIjoiT0piS3RUWWt3SXc0YzhDYjAwUDNTd2JsWUxMbXovWW82MzlXMWJiYUpObG5qbDFqdEo3STUwbUJ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "NuDISuGrunRtvlxKB348lK7rMlwBOiJX4wNBSRLZ" "uc_cart_id" => "cedce6dad103302196ce3d09c2f75481" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/97774" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-17 23:29:30GET/article/97774314371