Generic placeholder image

Current Analytical Chemistry

Editor-in-Chief

ISSN (Print): 1573-4110
ISSN (Online): 1875-6727

Research Article

New Green and High-throughput Microwell Spectrophotometric Method for Quality Control of Pharmaceutical Formulations of Selective Serotonin Reuptake Inhibitors via Microscale Formation of their N-Vinylamino-naphthoquinone Derivatives

Author(s): Reem M. Abuhejail, Nourah Z. Alzoman and Ibrahim A. Darwish*

Volume 20, Issue 1, 2024

Published on: 28 December, 2023

Page: [29 - 40] Pages: 12

DOI: 10.2174/0115734110281768231226115944

Price: $65

Abstract

Background: Selective serotonin reuptake inhibitors (SSRIs) are mostly prescribed for the treatment of depression. This study describes the microscale in-microwell formation of blue-colored N-vinylamino-naphthoquinone derivatives of SSRIs upon their reaction with 2,3-dichloro-1,4- naphthoquinone (DCNQ) and acetaldehyde. The reaction was subsequently utilized as a basis for the development of a new simple and sensitive microwell spectrophotometric method (MW-SPM) for the quality control of pharmaceutical formulations of four SSRIs. These SSRIs are fluoxetine (FLU), sertraline (SER), paroxetine (PAR), and reboxetine (REB).

Methods: The MW-SPM procedure was performed in 96-microwell transparent plates, and the microplate reader was employed to measure the absorbances of the reaction products at their peak absorbance wavelength of 580 nm. The best conditions for the method were determined.

Results: The relations showed good linearity (correlation coefficients were ≥0.9992) in the concentration range of 5 – 600 μg/mL. The limits of detection ranged from 5.20 to 15.58 μg/mL. The precision was deemed acceptable since all cases' relative standard deviation (RSD) values remained below 2.21%. Recovery experiments were conducted to confirm the accuracy of the method, yielding recovery values of at least 97.8%. The MW-SPM method was effectively utilized to analyze SSRIs in both their bulk and pharmaceutical dosage forms, exhibiting acceptable accuracy and precision. The recovery values ranged from 99.4% to 101.0% (with a margin of error of ± 0.5% to 1.6%). The results were comparable with those of the pre-validated reported methods. Four different metric tools evaluated the greenness of the proposed method, and the results proved that the method fulfills the requirements of green analytical approaches. Furthermore, the ability to handle numerous microvolume samples simultaneously in the described method provides it with a high-throughput characteristic.

Conclusion: The proposed MW-SPM represents a valuable tool for an efficient analysis of SSRIs in pharmaceutical quality control units.

Graphical Abstract

[1]
World Health Organization. Available from: https://www.who.int/health-topics/depression#tab=tab_1 (Accessed on 29 March 2023).
[2]
Ford, S.M. Introduction to Clinical Pharmacology, 12th ed; Lippincott Williams & Wilkins: Philadelphia, 2021.
[3]
Eyewitness, D.K. The British Medical Association, Illustrated Medical Dictionary, 3rd ed; Adorling Kindersley Ltd.: London, 2013.
[4]
Quevedo, J.; Zarate, C.A., Jr; Carvalho, A.F. Neurobiology of depression: road to novel therapeutics; Academic Press, Elsevier Inc.: London, UK, 2019.
[5]
Tundo, A.; Filippis, R.; Proietti, L. Pharmacologic approaches to treatment resistant depression: Evidences and personal experience. World J. Psychiatry, 2015, 5(3), 330-341.
[http://dx.doi.org/10.5498/wjp.v5.i3.330] [PMID: 26425446]
[6]
Roiser, J.P.; Elliott, R.; Sahakian, B.J. Cognitive mechanisms of treatment in depression. Neuropsychopharmacology, 2012, 37(1), 117-136.
[http://dx.doi.org/10.1038/npp.2011.183] [PMID: 21976044]
[7]
Leahy, R.L.; Holland, S.J.F.; McGinn, L.K. Treatment plans and interventions for depression and anxiety disorders, 2nd ed; Guilford Publications: New York, USA, 2011.
[8]
Radenković, M.Ć. Novel approaches in treating major depressive disorder (depression); Nova Medicine & Health, 2019.
[9]
Preskorn, S.H. Clinical pharmacology of selective serotonin reuptake inhibitors, 1st ed; Professional Communications, Inc.: New York, USA, 1996.
[10]
Sabri, R. The addictive potential of selective serotonin reuptake inhibitors: addictive potential of selective serotonin reuptake inhibitors relative to benzodiazepines in UK psychiatric patients; LAP Lambert Academic Publishing: London, UK, 2011.
[11]
Şentürk, Z.; Saka, C.; Teğin, İ. Analytical methods for determination of selective serotonin reuptake inhibitor antidepressants. Rev. Anal. Chem., 2011, 30(2), 87-122.
[http://dx.doi.org/10.1515/revac.2011.018]
[12]
Jia, E.; Bartlett, M.G. Recent advances in liquid chromatographic methods for the determination of selective serotonin reuptake inhibitors and serotonin norepinephrine reuptake inhibitors. Biomed. Chromatogr., 2020, 34(3), e4760.
[http://dx.doi.org/10.1002/bmc.4760] [PMID: 31758582]
[13]
Darwish, I.A.; Refaat, I.H. Spectrophotometric analysis of selective serotonin reuptake inhibitors based on formation of charge-transfer complexes with tetracyanoquinodimethane and chloranilic acid. J. AOAC Int., 2006, 89(2), 326-333.
[http://dx.doi.org/10.1093/jaoac/89.2.326] [PMID: 16640280]
[14]
Soliman, S.M.; Mohamed, T.A. Spectrophotometric and spectrofluorimetric determination of some selective serotonin reuptake inhibitors [SSRIs] through ternary complex formation with eosin and copper [II] in pharmaceuticals. J. Drug Res. Egypt, 2011, 32, 111-121.
[15]
Emin, C.; Rodica, S.; Ionescu, A.M.; Safta, A.; Tomescu, C.L. Validation of a spectrophotometric method of some antidepressant drugs. Europ. J. Nat. Sci. Med., 2023, 6(1), 1-9.
[http://dx.doi.org/10.2478/ejnsm-2023-0001]
[16]
Annapurna, V.; Jyothi, G.; Rohini Kumari, T.; Sailaja, B.B.V. Spectrophotometric determination of various drugs using chloranilic acid as chromogenic reagent – II. E-J. Chem., 2010, 7(2), 624-628.
[http://dx.doi.org/10.1155/2010/306858]
[17]
Rao, A.L.; Rajeswari, K.R.; Sankar, G.G. Spectrophotometric methods for the determination of selected drugs in pharmaceutical formulations. J. Chem. Pharm. Res., 2010, 2, 280-282.
[18]
Annapurna, M.M.; Pradhan, D.P. New derivative spectrophotometric methods for the determination of fluoxetine - an antidepressant drug. Chem. Sci. Trans., 2012, 1(3), 697-701.
[http://dx.doi.org/10.7598/cst2012.225]
[19]
Constantinescu, I.C.; Florea, M.; Neagu, A.F. Development of a spectrophotometric method for determination of fluoxetine hydrochloride in bulk and pharmaceutical dosage forms. Farmacia, 2015, 63, 816-820.
[20]
Mukhopadhyay, A.; Pradhan, K.K.; Samanta, R. Development and validation of an UV-spectrophotometric method for the estimation of fluoxetine in pure and tablet dosage forms. Int. J. Pharm. Sci. Res., 2014, 5, 3418-3424.
[21]
Darwish, I.A. Development and validation of spectrophotometric methods for determination of fluoxetine, sertraline, and paroxetine in pharmaceutical dosage forms. J. AOAC Int., 2005, 88(1), 38-45.
[http://dx.doi.org/10.1093/jaoac/88.1.38] [PMID: 15759724]
[22]
Affas, S.; Sakur, A.A. Spectrophotometric method for simultaneous estimation of dapoxetine and some phosphodiesterase-5 inhibitors in new combinations. Res. J. Pharm. Technol., 2019, 12(11), 5193-5198.
[http://dx.doi.org/10.5958/0974-360X.2019.00899.0]
[23]
Görög, S. Ultraviolet-visible spectrophotometry in pharmaceutical analysis; CRC Press: New York, NY, USA, 2018.
[http://dx.doi.org/10.1201/9781351077422]
[24]
Ahmed, S.; Rasul, A.; Masood, Z. Spectrophotometry in pharmaceutical analysis; LAP Lambert Academic Publishing: London, 2011.
[25]
Gore, M.G. Spectrophotometry and spectrofluorimetry: A practical approach, 2nd ed; Oxford University Press: Oxford, 2000.
[http://dx.doi.org/10.1093/oso/9780199638130.001.0001]
[26]
Wang, P.G. High-throughput analysis in the pharmaceutical industry, 1st ed; CRC Press, 2019.
[27]
Mennen, S.M.; Alhambra, C.; Allen, C.L.; Barberis, M.; Berritt, S.; Brandt, T.A.; Campbell, A.D.; Castañón, J.; Cherney, A.H.; Christensen, M.; Damon, D.B.; Eugenio de Diego, J.; García-Cerrada, S.; García-Losada, P.; Haro, R.; Janey, J.; Leitch, D.C.; Li, L.; Liu, F.; Lobben, P.C.; MacMillan, D.W.C.; Magano, J.; McInturff, E.; Monfette, S.; Post, R.J.; Schultz, D.; Sitter, B.J.; Stevens, J.M.; Strambeanu, I.I.; Twilton, J.; Wang, K.; Zajac, M.A. The evolution of high-throughput experimentation in pharmaceutical development and perspectives on the future. Org. Process Res. Dev., 2019, 23(6), 1213-1242.
[http://dx.doi.org/10.1021/acs.oprd.9b00140]
[28]
Darwish, I.A.; Alzoman, N.Z. Development and validation of green and high-throughput microwell spectrophotometric assay for the determination of selective serotonin reuptake inhibitors in their pharmaceutical dosage forms. Molecules, 2023, 28(10), 4221.
[http://dx.doi.org/10.3390/molecules28104221] [PMID: 37241961]
[29]
Wennborg, H.; Bonde, J.P.; Stenbeck, M.; Olsen, J. Adverse reproduction outcomes among employees working in biomedical research laboratories. Scand. J. Work Environ. Health, 2002, 28(1), 5-11.
[http://dx.doi.org/10.5271/sjweh.640] [PMID: 11871853]
[30]
Lindbohm, M.L.; Taskinen, H.; Sallman, M.; Hemminki, K. Spontaneous abortions among women exposed to organic solvents. Am. J. Ind. Med., 1990, 17(4), 449-463.
[http://dx.doi.org/10.1002/ajim.4700170404] [PMID: 2327413]
[31]
Wennborg, H.; Bodin, L.; Vainio, H.; Axelsson, G. Pregnancy outcome of personnel in Swedish biomedical research laboratories. J. Occup. Environ. Med., 2000, 42(4), 438-446.
[http://dx.doi.org/10.1097/00043764-200004000-00022] [PMID: 10774513]
[32]
Kristensen, P.; Hilt, B.; Svendsen, K.; Grimsrud, T.K. Incidence of lymphohaematopoietic cancer at a university laboratory: a cluster investigation. Eur. J. Epidemiol., 2008, 23(1), 11-15.
[http://dx.doi.org/10.1007/s10654-007-9203-5] [PMID: 17985198]
[33]
ICH. International council for harmonisation of technical requirements for pharmaceuticals for human use, ICH Harmonised guideline, validation of analytical procedure: Q2(R2); ICH: Geneva, Switzerland, 2022.
[34]
The United States Pharmacopoeia-National Formulary (USP-NF). US Pharmacopeial Convention Rockville; MD, 2021.
[35]
Keith, L.H.; Gron, L.U.; Young, J.L. Green analytical methodologies. Chem. Rev., 2007, 107(6), 2695-2708.
[http://dx.doi.org/10.1021/cr068359e] [PMID: 17521200]
[36]
Gałuszka, A.; Migaszewski, Z.M.; Konieczka, P.; Namieśnik, J. Analytical Eco-Scale for assessing the greenness of analytical procedures. Trends Analyt. Chem., 2012, 37, 61-72.
[http://dx.doi.org/10.1016/j.trac.2012.03.013]
[37]
Płotka-Wasylka, J. A new tool for the evaluation of the analytical procedure. Green Analytical Procedure Index. Talanta, 2018, 181, 204-209.
[http://dx.doi.org/10.1016/j.talanta.2018.01.013] [PMID: 29426502]
[38]
Pena-Pereira, F.; Wojnowski, W.; Tobiszewski, M. AGREE-analytical greenness metric approach and software. Anal. Chem., 2020, 92(14), 10076-10082.
[http://dx.doi.org/10.1021/acs.analchem.0c01887] [PMID: 32538619]
[39]
Hussein, S.A. Spectrophotometric determination of trimetazidine hydrochloride. Alex. J. Pharm. Sci., 2002, 16, 39-44.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version452msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:48:02] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:48:03] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[20:48:03] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:48:03] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (126ms)time
  • Application (326ms)time
  • 1 x Application (72.04%)
    326ms
    1 x Booting (27.95%)
    126ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    36 statements were executed, 4 of which were duplicates, 32 unique. Show only duplicated221ms
    • 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 ('309824417','',1,1740775682,1740775682) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740775682
      1.31msalphaeurekaselec_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 ('309824417','/article/136831',1,1740775682,1740775682)
      200μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) 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 >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) 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 >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) 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 >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) 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 >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) 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 >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 309824417 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309824417) limit 1
      21.19msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 309824417
      • 1: 309824417
      • 2: 309824417
      • 3: 309824417
      • 4: 309824417
      • 5: 309824417
      • 6: 309824417
      • 7: 309824417
      • 8: 309824417
      • 9: 309824417
      • 10: 309824417
      • 11: 309824417
      • 12: 309824417
      • 13: 309824417
      • 14: 309824417
      • 15: 309824417
      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=136831
      1.1msalphaeurekaselec_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` = 4 limit 1
      1.2msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 4
      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=4) and sj.journal_id!=4 group by `j`.`nid`) as `aggregate_table`
      890μ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=4) and sj.journal_id!=4 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      820μ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=4) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      3msalphaeurekaselec_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=4) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      2.65msalphaeurekaselec_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` = '136831'
      290μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 136831
      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` = '136831'
      3.4msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 136831
      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` = '136831' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 136831
      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
      370μ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
      570μ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 = 4 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      25.99msalphaeurekaselec_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 = 4 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      18.13msalphaeurekaselec_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 = 4 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      8.13msalphaeurekaselec_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` = 136831 limit 1
      200μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 136831
      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 = 136831 and content_type = 'article' order by status desc limit 1
      270μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 224981 limit 1
      240μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 224981
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      250μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CAC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      320μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CAC
      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 = '136831' 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) )
      1.05msalphaeurekaselec_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 = '13080' 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) )
      360μ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 = '3499' 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) )
      340μ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 <= 309824417 and j.to_ip >=309824417 )) and ((j.from_date <= 1740775682 and j.to_date >= 1740775682 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3499) 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 <= 309824417 and j.to_ip >=309824417 )) and ((j.from_date <= 1740775682 and j.to_date >= 1740775682 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3499) 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 <= 309824417 and j.to_ip >=309824417 )) and ((j.from_date <= 1740775682 and j.to_date >= 1740775682 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3499)
      116msalphaeurekaselec_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 <= 309824417 and j.to_ip >=309824417 )) and ((j.from_date <= 1740775682 and j.to_date >= 1740775682 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13080) 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 <= 309824417 and j.to_ip >=309824417 )) and ((j.from_date <= 1740775682 and j.to_date >= 1740775682 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13080) 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 <= 309824417 and j.to_ip >=309824417 )) and ((j.from_date <= 1740775682 and j.to_date >= 1740775682 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13080)
      720μ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 <= 309824417 and j.to_ip >=309824417 )) and ((j.from_date <= 1740775682 and j.to_date >= 1740775682 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 136831) 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 <= 309824417 and j.to_ip >=309824417 )) and ((j.from_date <= 1740775682 and j.to_date >= 1740775682 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 136831) 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 <= 309824417 and j.to_ip >=309824417 )) and ((j.from_date <= 1740775682 and j.to_date >= 1740775682 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 136831)
      950μ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` < '29' and is_uploaded = 1 and issue_id = 13080 order by cast(first_page as SIGNED) desc limit 1
      620μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 29
      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` > '40' and is_uploaded = 1 and issue_id = 13080 order by cast(first_page as SIGNED) asc limit 1
      650μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 40
      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'
      270μ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
      310μ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` = 136831 limit 1
      4.01msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 136831
      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` = 4 and `b`.`banner_from_date` <= 1740775683 and `b`.`banner_to_date` >= 1740775683 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.48msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 4
      • 3: 1740775683
      • 4: 1740775683
      • 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` = 4 and `b`.`banner_from_date` <= 1740775683 and `b`.`banner_to_date` >= 1740775683 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.44msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 4
      • 3: 1740775683
      • 4: 1740775683
      • 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='91c77ec2132447bd285321307af00e96'
      300μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:291
      • 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
        u83AxP6E1seV3PaCwXXsVaFo24L1aOFqZbYW2hU1
        uc_cart_id
        91c77ec2132447bd285321307af00e96
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/136831" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/136831
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:9 [ "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6IlVpay9Ma0RiV1hlak5xN0c3bDlPSUE9PSIsInZhbHVlIjoiRmVOcWhIeUh2dWlqM29lZllxeHNVYkxCZzc4SHhlK0w5cS9CVW03Zi8xMD0iLCJtYWMiOiJkODhiYzM1NDc0ZWQ1NDY2MGViOTMwMGJjNmZmYzZiNTQ3NjZkMDJmZDVjMTRlZjEwYTAxODgwYTU2YzljZjU3IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IlVpay9Ma0RiV1hlak5xN0c3bDlPSUE9PSIsInZhbHVlIjoiRmVOcWhIeUh2dWlqM29lZllxeHNVYkxCZzc4SHhlK0w5cS9CVW03Zi8xMD0iLCJtYWMiOiJkODhiYzM1NDc0ZWQ1" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 28 Feb 2025 20:48:02 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImVNb3ZVUTN1SjVuRjBidUY4MHd0TFE9PSIsInZhbHVlIjoiQXNmenJWTGNjZjVLaHVaTVpkcit6YjlyM2FHdTAyMmN5TXM0UG85aFZEMjUyWHJkRmovM0tZWEZkUkFXeUlROWJtNGl3djlXNENaOHdDSUZVVjVSbC9sTjVHZm1yUDFFa0Q4U3BZdVI2RGh1OG50eG4rWTZyTFFsWklzZ0xwamgiLCJtYWMiOiI5NGRiOTQ3NGY5ZDQ0MDkzYmUxNzY5MDllZTc3ODg3OTA3OGRhZTg4YTYzZmQzYzY2OTkzOTI1OWU3NzhkYzY5IiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 08:48:03 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImVNb3ZVUTN1SjVuRjBidUY4MHd0TFE9PSIsInZhbHVlIjoiQXNmenJWTGNjZjVLaHVaTVpkcit6YjlyM2FHdTAyMmN5TXM0UG85aFZEMjUyWHJkRmovM0tZWEZkUkFXeUlROWJtNGl3d" 1 => "alphaeurekaselectnet_session=eyJpdiI6InkxQ1JLWG13T2FMeHcvc3d1cC9EQnc9PSIsInZhbHVlIjoic1Q1bGhqWWRtM00yZUpXMnN1NmVLaUdvZmdVRlNUWjA5QU1BNjVrOTFLOEZ6QkNPWTZQU0VEOXpzRzlqWXRDOENxdU56ZkNSZzRleGpTSTNsUmQwd3FZVHdmRzVBdVlWZmo5UkQ2ZVdMUnpiQXVkbWlCbWJpandrZXlEYTBzUXkiLCJtYWMiOiI0NzY5OTBhNWYyNDhlNGQxYWYwMTc2NTQ3MmY5Zjg1YWM4YzU4MmUxMjEwZDc3ZDIyMzJiYzgyODJmNGJkZGQ2IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6InkxQ1JLWG13T2FMeHcvc3d1cC9EQnc9PSIsInZhbHVlIjoic1Q1bGhqWWRtM00yZUpXMnN1NmVLaUdvZmdVRlNUWjA5QU1BNjVrOTFLOEZ6QkNPWTZQU0VEOXp" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImVNb3ZVUTN1SjVuRjBidUY4MHd0TFE9PSIsInZhbHVlIjoiQXNmenJWTGNjZjVLaHVaTVpkcit6YjlyM2FHdTAyMmN5TXM0UG85aFZEMjUyWHJkRmovM0tZWEZkUkFXeUlROWJtNGl3djlXNENaOHdDSUZVVjVSbC9sTjVHZm1yUDFFa0Q4U3BZdVI2RGh1OG50eG4rWTZyTFFsWklzZ0xwamgiLCJtYWMiOiI5NGRiOTQ3NGY5ZDQ0MDkzYmUxNzY5MDllZTc3ODg3OTA3OGRhZTg4YTYzZmQzYzY2OTkzOTI1OWU3NzhkYzY5IiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 08:48:03 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImVNb3ZVUTN1SjVuRjBidUY4MHd0TFE9PSIsInZhbHVlIjoiQXNmenJWTGNjZjVLaHVaTVpkcit6YjlyM2FHdTAyMmN5TXM0UG85aFZEMjUyWHJkRmovM0tZWEZkUkFXeUlROWJtNGl3d" 1 => "alphaeurekaselectnet_session=eyJpdiI6InkxQ1JLWG13T2FMeHcvc3d1cC9EQnc9PSIsInZhbHVlIjoic1Q1bGhqWWRtM00yZUpXMnN1NmVLaUdvZmdVRlNUWjA5QU1BNjVrOTFLOEZ6QkNPWTZQU0VEOXpzRzlqWXRDOENxdU56ZkNSZzRleGpTSTNsUmQwd3FZVHdmRzVBdVlWZmo5UkQ2ZVdMUnpiQXVkbWlCbWJpandrZXlEYTBzUXkiLCJtYWMiOiI0NzY5OTBhNWYyNDhlNGQxYWYwMTc2NTQ3MmY5Zjg1YWM4YzU4MmUxMjEwZDc3ZDIyMzJiYzgyODJmNGJkZGQ2IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6InkxQ1JLWG13T2FMeHcvc3d1cC9EQnc9PSIsInZhbHVlIjoic1Q1bGhqWWRtM00yZUpXMnN1NmVLaUdvZmdVRlNUWjA5QU1BNjVrOTFLOEZ6QkNPWTZQU0VEOXp" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "u83AxP6E1seV3PaCwXXsVaFo24L1aOFqZbYW2hU1" "uc_cart_id" => "91c77ec2132447bd285321307af00e96" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/136831" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 20:48:03GET/article/136831414361