Generic placeholder image

Current Analytical Chemistry

Editor-in-Chief

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

Research Article

A Green Liquid Chromatographic Method For The Simultaneous Determination of Chlorpheniramine Maleate, Pseudoephedrine Hydrochloride and Propyphenazone

Author(s): Nadia M. Mostafa, Ghada M. Elsayed, Nagiba Y. Hassan and Dina A. El Mously*

Volume 15, Issue 6, 2019

Page: [635 - 641] Pages: 7

DOI: 10.2174/1573411014666180806155002

Price: $65

Abstract

Background: The concept of green analytical chemistry prevails due to the growing environmental pollution.

Objective: Our attempts are to develop simple and eco-friendly method which is non-harmful to the environment by producing minimal waste. In this context, a green liquid chromatographic method was applied for the simultaneous determination of chlorpheniramine maleate, pseudoephedrine hydrochloride and propyphenazone in their combined dosage form.

Methods: Separation was carried out using X select HSS RP C18 analytical column (250 × 4.6 mm, 5μm) using methanol - 0.02 M phosphate buffer pH 3 - triethylamine (60:40: 0.1, by volume) as a mobile phase. The separated peaks were detected at 215 nm at a flow rate 1.0 mL/min.

Results: Quantification was done over the concentration ranges of 1-25 µg/mL for chlorpheniramine maleate, 5-35 µg/mL for pseudoephedrine hydrochloride and 10-120 µg/mL for propyphenazone. The suggested method was validated with regard to linearity, accuracy and precision according to the International Conference on Harmonization guidelines with good results.

Conclusion: It could be used as a safer alternative for routine analysis of the mentioned drugs in quality control laboratories.

Keywords: Chlorpheniramine maleate, green chemistry, liquid chromatography, propyphenazone, pseudoephedrine hydrochloride, environmental pollution.

Graphical Abstract

[1]
de la Guardia, M.; Garrigues, S. Handbook of Green Analytical Chemistry; Wiley Online Library: New York, 2012.
[2]
Namieśnik, J. Green analytical chemistry-some remarks. J. Sep. Sci., 2001, 24(2), 151-153.
[3]
Anastas, P.T. Green chemistry and the role of analytical methodology development. Crit. Rev. Anal. Chem., 1999, 29(3), 167-175.
[4]
Keith, L.H.; Gron, L.U. Young, J.L. Green analytical methodologies. Chem. Rev., 2007, 107(6), 2695-2708.
[5]
Gilpin, R.; Gilpin, C. Pharmaceuticals and related drugs. Anal. Chem., 2007, 79(12), 4275-4294.
[6]
Snyder, L.R.; Kirkland, J.J.; Glajch, J.L. Practical HPLC Method development; John Wiley & Sons: New Jersey, 2012.
[7]
Stan, G-S.; Elena Mitoi, B.; Mihaila, A.; Adriana Badea, I.; Y., Aboul-Enein H. Determination of Carprofen in the Presence of some Hydrosoluble Vitamins of Group B by HPLC Method. Curr. Anal. Chem., 2015, 11(4), 273-278.
[8]
British pharmacopoeia. The Stationary office London: England, Vol. 1, 2013.
[9]
Sweetman, S.C. Martindale: The Complete Drug Reference; Pharmaceutical press: London, 2009.
[10]
Louhaichi, M.; Jebali, S.; Loueslati, M.; Adhoum, N.; Monser, L. Simultaneous determination of pseudoephdrine, pheniramine, guaifenisin, pyrilamine, chlorpheniramine and dextromethorphan in cough and cold medicines by high performance liquid chromatography. Talanta, 2009, 78(3), 991-997.
[11]
Al-Rimawi, F. Normal-phase LC method for simultaneous analysis of pseudophedrine hydrochloride, dextromethorphan hydrobromide, chlorpheniramine maleate, and paracetamol in tablet formulations. Saudi Pharm. J., 2010, 18(2), 103-106.
[12]
Kalogria, E.; Koupparis, M.; Panderi, I. A porous graphitized carbon column HPLC method for the quantification of paracetamol, pseudoephedrine, and chlorpheniramine in a pharmaceutical formulation. J. AOAC Int., 2010, 93(4), 1093-1101.
[13]
Soponar, F.; Staniloae, D.; Moise, G.; Szaniszlo, B.; David, V. Simultaneous determination of paracetamol, propyphenazone and caffeine from pharmaceutical preparations in the presence of related substances using a validated HPLC-DAD method. Rev. Roum. Chim., 2013, 58(4-5), 433-440.
[14]
Issa, Y.M.; Hassouna, M.E.; Zayed, A.G. Simultaneous determination of paracetamol, caffeine, domperidone, ergotamine tartrate, propyphenazone, and drotaverine HCl by high performance liquid chromatography. J. Liq. Chromatogr. Relat. Technol., 2012, 35(15), 2148-2161.
[15]
Manassra, A.; Khamis, M.; el-Dakiky, M.; Abdel-Qader, Z.; Al-Rimawi, F. Simultaneous HPLC analysis of pseudophedrine hydrochloride, codeine phosphate, and triprolidine hydrochloride in liquid dosage forms. J. Pharm. Biomed. Anal., 2010, 51(4), 991-993.
[16]
Njaria, P.M.; Abuga, K.O.; Kamau, F.N.; Chepkwony, H.K. A versatile HPLC method for the simultaneous determination of bromhexine, guaifenesin, ambroxol, salbutamol/terbutaline, pseudoephedrine, triprolidine, and chlorpheniramine maleate in cough-cold syrups. Chromatographia, 2016, 79(21-22), 1507-1514.
[17]
Sarılmışer, H.K.; Özçelik, N.O.; Arslan, B.Ö.; Gökalp, M.; Ustaoğlu, A.; Dude, U.K.; Knezevic, Z. Development and validation of a simple HPLC assay method for ibuprofen, pseudoephedrine hydrochloride and chlorpheniramine maleate in syrup form. J. Chem. Metrol., 2017, 11(2), 61.
[18]
Al-Akraa, H.; Sarkis, N.; Alshehaby, M. New rapid RP-HPLC method for simultaneous determination of some decongestants and cough sedatives. Int. J. Pharm. Pharm. Sci., 2013, 5(4), 234-241.
[19]
Riahi, S.; Hadiloo, F.; Milani, S.M.R.; Davarkhah, N.; Ganjali, M.R.; Norouzi, P.; Seyfi, P. A new technique for spectrophotometric determination of pseudoephedrine and guaifenesin in syrup and synthetic mixture. Drug Test. Anal., 2011, 3(5), 319-324.
[20]
Özgür, M.Ü.; Alpdoğan, G.; Aşçi, B. A rapid spectrophotometric method to resolve ternary mixtures of propyphenazone, caffeine, and acetaminophen in tablets. Monatsh. Chem., 2002, 133(2), 219-223.
[21]
Saad, A.S.; Hamdy, A.M.; Salama, F.M.; Abdelkawy, M. Enhancing prediction power of chemometric models through manipulation of the fed spectrophotometric data: A comparative study. Spectrochim. Acta Part A, 2016, 167, 12-18.
[22]
Issa, M.M.; Shanab, A.M.A.; Shaat, N.T. Resolution of five component mixture using mean centering ratio and inverse least squares chemometrics. Chem. Cent. J., 2013, 7(1), 152.
[23]
Buiarelli, F.; Coccioli, F.; Jasionowska, R.; Terracciano, A. Development and validation of an MEKC method for determination of nitrogen‐containing drugs in pharmaceutical preparations. Electrophoresis 2008, 29(17), 3519-3523.
[24]
Subramaniyan, S.P.; Das, S.K. Rapid identification and quantification of chlorpheniramine maleate or pheniramine maleate in pharmaceutical preparations by thin-layer chromatography densitometry. J. AOAC Int., 2004, 87(6), 1319-1322.
[25]
El‐Kommos, M.E.; El‐Gizawy, S.M.; Atia, N.N.; Hosny, N.M. Thin layer chromatography-densitometric determination of some non‐sedating antihistamines in combination with pseudoephedrine or acetaminophen in synthetic mixtures and in pharmaceutical formulations. Biomed. Chromatogr., 2014, 28(3), 391-400.
[26]
Hałka-Grysińska, A.; Ślązak, P.; Zaręba, G.; Markowski, W.; Klimek-Turek, A.; Dzido, T.H. Simultaneous determination of acetaminophen, propyphenazone and caffeine in cefalgin preparation by pressurized planar electrochromatography and high-performance thin-layer chromatography. Anal. Methods, 2012, 4(4), 973-982.
[27]
Vignaduzzo, S.E.; Kaufman, T.S. Development and validation of a HPLC method for the simultaneous determination of bromhexine, chlorpheniramine, paracetamol, and pseudoephedrine in their combined cold medicine formulations. J. Liq. Chromatogr. Relat. Technol., 2013, 36(20), 2829-2843.
[28]
Dinç, E.; Kökdil, G.; Onur, F. Derivative ratio spectra-zero crossing spectrophotometry and LC method applied to the quantitative determination of paracetamol, propyphenazone and caffeine in ternary mixtures. J. Pharm. Biomed. Anal., 2001, 26(5), 769-778.
[29]
Tobiszewski, M.; Mechlińska, A.; Namieśnik, J. Green analytical chemistry-theory and practice. Chem. Soc. Rev., 2010, 39(8), 2869-2878.
[30]
Mostafa, N.M.; Elsayed, G.M.; Hassan, N.Y.; El Mously, D.A. Development and validation of eco-friendly liquid chromatographic and spectrophotometric methods for simultaneous determination of coformulated drugs: Phenylephrine hydrochloride and prednisolone acetate. J. AOAC Int., 2017, 100(6), 1761-1770.
[31]
Henderson, R.K.; Jiménez-González, C.; Constable, D.J.; Alston, S.R.; Inglis, G.G.; Fisher, G.; Sherwood, J.; Binks, S.P.; Curzons, A.D. Expanding GSK’s solvent selection guide-embedding sustainability into solvent selection starting at medicinal chemistry. Green Chem., 2011, 13(4), 854-862.
[32]
Capello, C.; Fischer, U.; Hungerbühler, K. What is a green solvent? A comprehensive framework for the environmental assessment of solvents. Green Chem., 2007, 9(9), 927-934.
[33]
Alfonsi, K.; Colberg, J.; Dunn, P.J.; Fevig, T.; Jennings, S.; Johnson, T.A.; Kleine, H.P.; Knight, C.; Nagy, M.A.; Perry, D.A. Green chemistry tools to influence a medicinal chemistry and research chemistry based organisation. Green Chem., 2008, 10(1), 31-36.
[34]
Indrayanto, G.; Sunarto, A.; Adriani, Y. Simultaneous assay of phenylpropanolamine hydrochloride, caffeine, paracetamol, glycerylguaiacolate and chlorpheniramine maleate in Silabat™ tablet using HPLC with diode array detection. J. Pharm. Biomed. Anal., 1995, 13(12), 1555-1559.
[35]
Ich, I. In Q2 (R1): Validation of Analytical Procedures: Text and Methodology International Conference on Harmonization, Geneva2005.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version268msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:07:18] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:07:18] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:07:18] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (91.04ms)time
  • Application (177ms)time
  • 1 x Application (66.03%)
    177ms
    1 x Booting (33.97%)
    91.04ms
    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 duplicated106ms
    • 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 ('59771045','',1,1740514038,1740514038) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740514038
      1.12msalphaeurekaselec_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 ('59771045','/article/92204',1,1740514038,1740514038)
      180μ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 >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) 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 >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) 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 >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) 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 >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) 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 >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) 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 >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59771045 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59771045) limit 1
      20.42msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59771045
      • 1: 59771045
      • 2: 59771045
      • 3: 59771045
      • 4: 59771045
      • 5: 59771045
      • 6: 59771045
      • 7: 59771045
      • 8: 59771045
      • 9: 59771045
      • 10: 59771045
      • 11: 59771045
      • 12: 59771045
      • 13: 59771045
      • 14: 59771045
      • 15: 59771045
      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=92204
      910μ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` = 4 limit 1
      1.1msalphaeurekaselec_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`
      790μ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
      710μ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`
      3.92msalphaeurekaselec_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
      5.08msalphaeurekaselec_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` = '92204'
      620μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 92204
      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` = '92204'
      3.04msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 92204
      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` = '92204' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.19msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 92204
      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
      280μ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
      600μ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
      35.15msalphaeurekaselec_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
      7.49msalphaeurekaselec_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
      5.61msalphaeurekaselec_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` = 92204 limit 1
      640μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 92204
      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 = 92204 and content_type = 'article' order by status desc limit 1
      260μ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` = 164379 limit 1
      230μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 164379
      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
      240μ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
      310μ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 = '92204' 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) )
      340μ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 = '9360' and content_type = 'i' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      320μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '2543' 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) )
      310μ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 <= 59771045 and j.to_ip >=59771045 )) and ((j.from_date <= 1740514038 and j.to_date >= 1740514038 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2543) 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 <= 59771045 and j.to_ip >=59771045 )) and ((j.from_date <= 1740514038 and j.to_date >= 1740514038 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2543) 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 <= 59771045 and j.to_ip >=59771045 )) and ((j.from_date <= 1740514038 and j.to_date >= 1740514038 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2543)
      6.94msalphaeurekaselec_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 <= 59771045 and j.to_ip >=59771045 )) and ((j.from_date <= 1740514038 and j.to_date >= 1740514038 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9360) 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 <= 59771045 and j.to_ip >=59771045 )) and ((j.from_date <= 1740514038 and j.to_date >= 1740514038 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9360) 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 <= 59771045 and j.to_ip >=59771045 )) and ((j.from_date <= 1740514038 and j.to_date >= 1740514038 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9360)
      600μ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 <= 59771045 and j.to_ip >=59771045 )) and ((j.from_date <= 1740514038 and j.to_date >= 1740514038 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 92204) 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 <= 59771045 and j.to_ip >=59771045 )) and ((j.from_date <= 1740514038 and j.to_date >= 1740514038 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 92204) 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 <= 59771045 and j.to_ip >=59771045 )) and ((j.from_date <= 1740514038 and j.to_date >= 1740514038 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 92204)
      610μ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` < '635' and is_uploaded = 1 and issue_id = 9360 order by cast(first_page as SIGNED) desc limit 1
      560μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 635
      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` > '641' and is_uploaded = 1 and issue_id = 9360 order by cast(first_page as SIGNED) asc limit 1
      500μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 641
      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'
      210μ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
      230μ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` = 92204 limit 1
      2.37msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 92204
      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` <= 1740514038 and `b`.`banner_to_date` >= 1740514038 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.11msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 4
      • 3: 1740514038
      • 4: 1740514038
      • 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` <= 1740514038 and `b`.`banner_to_date` >= 1740514038 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.05msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 4
      • 3: 1740514038
      • 4: 1740514038
      • 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='3141fecd75944f47c6498b2465ceee7d'
      240μ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
        Xjkv1QN2CuxWOxh48I3T8Zywdg6nsWcZP8xcOgLp
        uc_cart_id
        3141fecd75944f47c6498b2465ceee7d
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/92204" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/92204
        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 => "Tue, 25 Feb 2025 20:07:18 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImtqLytTY2wzczQxdkMxdm0wQStxS3c9PSIsInZhbHVlIjoid0dITGZ3YkZjTmw1RGRVY3liU2NLbjd3bTI0aWhwVzR0SzU0K01Iazk1WkFiS1BxRnQ4N0ZWUGpTbDJRUExJcmNUUE5VM2pLcnRQUlRSTXl3L3pialE2V1FqYVVHMFhrRG9LRVN2WWVISVVTWnc4QWJlOTgyUzdYVVBIYkYyR3oiLCJtYWMiOiI2ZTBjM2VmN2M2ODIxZDFmY2IzMjhlM2QzZjQ0NDhjMjJkOTEyMDYyNTAxNjYwNWMxMjRmYjRhZDUzMWUzZjU1IiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 08:07:18 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImtqLytTY2wzczQxdkMxdm0wQStxS3c9PSIsInZhbHVlIjoid0dITGZ3YkZjTmw1RGRVY3liU2NLbjd3bTI0aWhwVzR0SzU0K01Iazk1WkFiS1BxRnQ4N0ZWUGpTbDJRUExJcmNUUE5VM" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ii9Rb1VyMkVMSlloL0JLQ2NXVVJpdHc9PSIsInZhbHVlIjoiYWhXKysrY2lIT0N5S29VZmNmTDJSV1ROUDQzOXRwTEF5VnM5eFYyUXN4Y3R2b0pZWjNpVVNidGo5UkJ6VlQ3ZkJYQTNsYVZCU1RQbjNuMkR5bWMzcGppZlUxR1d4N3pSYThxbERKN3BDN2RVNDRFdnRoY3VaUnpJT3JnWS9WKzUiLCJtYWMiOiJhYzMyYmY1YWEyMmUzYjI4ZDA1ZTlhMDRkMTM1MjE4ZjQ1OGI5YWU1MjZiNjNlMGZiZGZiNTA1ZTMxZmVhNmFmIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ii9Rb1VyMkVMSlloL0JLQ2NXVVJpdHc9PSIsInZhbHVlIjoiYWhXKysrY2lIT0N5S29VZmNmTDJSV1ROUDQzOXRwTEF5VnM5eFYyUXN4Y3R2b0pZWjNpVVNidGo" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImtqLytTY2wzczQxdkMxdm0wQStxS3c9PSIsInZhbHVlIjoid0dITGZ3YkZjTmw1RGRVY3liU2NLbjd3bTI0aWhwVzR0SzU0K01Iazk1WkFiS1BxRnQ4N0ZWUGpTbDJRUExJcmNUUE5VM2pLcnRQUlRSTXl3L3pialE2V1FqYVVHMFhrRG9LRVN2WWVISVVTWnc4QWJlOTgyUzdYVVBIYkYyR3oiLCJtYWMiOiI2ZTBjM2VmN2M2ODIxZDFmY2IzMjhlM2QzZjQ0NDhjMjJkOTEyMDYyNTAxNjYwNWMxMjRmYjRhZDUzMWUzZjU1IiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 08:07:18 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImtqLytTY2wzczQxdkMxdm0wQStxS3c9PSIsInZhbHVlIjoid0dITGZ3YkZjTmw1RGRVY3liU2NLbjd3bTI0aWhwVzR0SzU0K01Iazk1WkFiS1BxRnQ4N0ZWUGpTbDJRUExJcmNUUE5VM" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ii9Rb1VyMkVMSlloL0JLQ2NXVVJpdHc9PSIsInZhbHVlIjoiYWhXKysrY2lIT0N5S29VZmNmTDJSV1ROUDQzOXRwTEF5VnM5eFYyUXN4Y3R2b0pZWjNpVVNidGo5UkJ6VlQ3ZkJYQTNsYVZCU1RQbjNuMkR5bWMzcGppZlUxR1d4N3pSYThxbERKN3BDN2RVNDRFdnRoY3VaUnpJT3JnWS9WKzUiLCJtYWMiOiJhYzMyYmY1YWEyMmUzYjI4ZDA1ZTlhMDRkMTM1MjE4ZjQ1OGI5YWU1MjZiNjNlMGZiZGZiNTA1ZTMxZmVhNmFmIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ii9Rb1VyMkVMSlloL0JLQ2NXVVJpdHc9PSIsInZhbHVlIjoiYWhXKysrY2lIT0N5S29VZmNmTDJSV1ROUDQzOXRwTEF5VnM5eFYyUXN4Y3R2b0pZWjNpVVNidGo" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "Xjkv1QN2CuxWOxh48I3T8Zywdg6nsWcZP8xcOgLp" "uc_cart_id" => "3141fecd75944f47c6498b2465ceee7d" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/92204" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 20:07:18GET/article/92204314361