Generic placeholder image

Current Drug Metabolism

Editor-in-Chief

ISSN (Print): 1389-2002
ISSN (Online): 1875-5453

General Research Article

Developing a High-performance Liquid Chromatography Method for Simultaneous Determination of Loratadine and its Metabolite Desloratadine in Human Plasma

Author(s): Mahmoud M. Sebaiy* and Noha I. Ziedan

Volume 20, Issue 13, 2019

Page: [1053 - 1059] Pages: 7

DOI: 10.2174/1389200220666191125095648

Price: $65

Abstract

Background: Allergic diseases are considered as the major burden on public health with increased prevalence globally. Histamine H1-receptor antagonists are the foremost commonly used drugs in the treatment of allergic disorders. The target drug in this study, loratadine, belongs to this class of drugs and its biometabolite desloratadine which is also a non-sedating H1 receptor antagonist with anti-histaminic activity being 2.5 to 4 times greater than loratadine. This study aimed to develop and validate a novel isocratic Reversed-phase High-Performance Liquid Chromatography (RP-HPLC) method for rapid and simultaneous separation and determination of loratadine and its metabolite, desloratadine in human plasma.

Methods: The drug extraction method from plasma was based on protein precipitation technique. The separation was carried out on a Thermo Scientific BDS Hypersil C18 column (5μm, 250 x 4.60 mm) in a mobile phase of MeOH: 0.025M KH2PO4 adjusted to pH 3.50 using orthophosphoric acid (85: 15, v/v) at an ambient temperature. The flow rate was maintained at 1 mL/min and maximum absorption was measured using the PDA detector at 248 nm.

Results: The retention times of loratadine and desloratadine in plasma samples were recorded to be 4.10 and 5.08 minutes, respectively, indicating a short analysis time. Limits of detection were found to be 1.80 and 1.97 ng/mL for loratadine and desloratadine, respectively, showing a high degree of sensitivity of the method. The method was then validated according to FDA guidelines for the determination of the two analytes in human plasma.

Conclusion: The results obtained indicate that the proposed method is rapid, sensitive in the nanogram range, accurate, selective, robust and reproducible compared to other reported methods.

Keywords: RP-HPLC, loratadine, desloratadine, protein precipitation, human plasma, FDA guidelines.

Graphical Abstract

[1]
Du Buske, L.M. Clinical comparison of histamine H1-receptor antagonist drugs. J. Allergy Clin. Immunol., 1996, 98, S307-S318.
[http://dx.doi.org/10.1016/S0091-6749(96)80116-3]
[2]
Fathalla, B.; Sawsan, A.R.; Mohamed, E.A.; Sahar, Z.; Sona, B. Rapid micellar HPLC analysis of loratadine and its major metabolite desloratadine in nano-concentration range using monolithic column and fluorometric detection: application to pharmaceuticals and biological fluids. Chem. Cent. J. , 2016.10, 79..
[http://dx.doi.org/10.1186/s13065-016-0225-5.]
[3]
Haria, M.; Fitton, A.; Peters, D.H. Loratadine. A reappraisal of its pharmacological properties and therapeutic use in allergic disorders. Drugs, 1994, 48, 617-637.
[http://dx.doi.org/10.2165/00003495-199448040-00009]
[4]
Kleine-Tebbe, J.; Josties, C.; Frank, G.; Stalleicken, D.; Buschauer, A.; Schunack, W.; Kunkel, G.; Czarnetzki, B. Inhibition of IgE and non-IgE mediated histamine release from human basophil leukocytes in vitro by a histamine H1-antagonist, desethoxycarbonyl-loratadine. J Allergy. Clin. Immunol., 1994, 93, 494-500.
[5]
The United States Pharmacopeia 32 The National Formulary 27, Electronic Version [CD-ROM]. US Pharmacopeial Convention,Rockville,. 2009.
[6]
Popovic, G.; Cakar, M.; Agbaba, D. Acid-base equilibria and solubility of loratadine and desloratadine in water and micellar media. J. Pharm. Biomed. Anal., 2009, 49, 42-47.
[http://dx.doi.org/10.1016/j.jpba.2008.09.043]
[7]
Rao, D.D.; Satyanarayana, N.V.; Malleswara, R.; Sait, S.S.; Chakole, D.; Mukkanti, K. A validated stability-indicating UPLC method for desloratadine and its impurities in pharmaceutical dosage forms. J. Pharm. Biomed. Anal., 2010, 51, 736-742.
[http://dx.doi.org/10.1016/j.jpba.2009.09.016]
[8]
Yang, L.; Mann, T.D.; Little, D.; Wu, N.; Clement, R.P.; Rudewicz, P.J. Evaluation of a four-channel multiplexed electrospray triple quadrupole mass spectrometer for the simultaneous validation of LC/MS/MS methods in four different preclinical matrixes. Anal. Chem., 2001, 73, 1740-1747.
[http://dx.doi.org/10.1021/ac0012694]
[9]
Sutherland, F.C.W.; de Jager, A.D.; Badenhorst, D.; Scanes, T.; Hundt, H.K.L.; Swart, K.J.; Hundt, A.F. Sensitive liquid chromatography-tandem mass spectrometry method for the determination of loratadine and its major active metabolite descarboethoxyloratadine in human plasma. J. Chromatogr. A, 2001, 914, 37-73.
[http://dx.doi.org/10.1016/S0021-9673(01)00646-X]
[10]
Ruperez, F.J.; Fernandez, H.; Barbas, C. LC determination of loratadine and related impurities. J. Pharm. Biomed. Anal., 2002, 29, 35-41.
[http://dx.doi.org/10.1016/S0731-7085(02)00057-2]
[11]
Yang, L.; Amad, M.; Winnik, W.M.; Schoen, A.E.; Schweingruber, H.; Mylchreest, I.; Rudewicz, P.J. Investigation of an enhanced resolution triple quadrupole mass spectrometer for high-throughput liquid chromatography/tandem mass spectrometry assays. Rapid Commun. Mass Spectrom., 2002, 16, 2060-2066.
[http://dx.doi.org/10.1002/rcm.824]
[12]
Naidong, W.; Addison, T.; Schneider, T.; Jiang, X.; Halls, T.D.J. A sensitive LC/MS/MS method using silica column and aqueous-organic mobile phase for the analysis of loratadine and descarboethoxy-loratadine in human plasma. J. Pharm. Biomed. Anal., 2003, 32, 609-617.
[http://dx.doi.org/10.1016/S0731-7085(03)00168-7]
[13]
Yin, O.Q.P.; Shi, X.; Chow, M.S.S. Reliable and specific high performance liquid chromatographic method for simultaneous determination of loratadine and its metabolite in human plasma. J. Chromatogr. B Analyt. Technol. Biomed. Life Sci., 2003, 796, 165-172.
[http://dx.doi.org/10.1016/j.jchromb.2003.08.023]
[14]
Qi, M.; Wang, P.; Geng, Y. Determination of desloratadine in drug substance and pharmaceutical preparations by liquid chromatography. J. Pharm. Biomed. Anal., 2005, 38, 355-359.
[http://dx.doi.org/10.1016/j.jpba.2005.01.003]
[15]
El-Sherbiny, D.T.; El-Enany, N.; Belal, F.F.; Hansen, S.H. Simultaneous determination of loratadine and desloratadine in pharmaceutical preparations using liquid chromatography with a microemulsion as eluent. J. Pharm. Biomed. Anal., 2007, 43, 1236-1242.
[http://dx.doi.org/10.1016/j.jpba.2006.10.027]
[16]
Vlase, L.; Imre, S.; Muntean, D.; Leucuta, S.E. Determination of loratadine and its active metabolite in human plasma by high-performance liquid chromatography with mass spectrometry detection. J. Pharm. Biomed. Anal., 2007, 44, 652-657.
[http://dx.doi.org/10.1016/j.jpba.2006.08.013]
[17]
Sora, D.I.; Udrescu, S.; David, V.; Medvedovici, A. Validated ion pair liquid chromatography/fluorescence detection method for assessing the variability of the loratadine metabolism occurring in bioequivalence studies. Biomed. Chromatogr., 2007, 21, 1023-1029.
[http://dx.doi.org/10.1002/bmc.845]
[18]
Srinubabu, G.; Patel, R.S.; Shedbalkar, V.P.; Rao, A.A.; Rao, M.N.; Bandaru, V.V.R. Development and validation of high-throughput liquid chromatography-tandem mass spectrometric method for simultaneous quantification of loratadine and desloratadine in human plasma. J. Chromatogr. , 2007, 860, 202-208.
[http://dx.doi.org/10.1016/j.jchromb.2007.10.036]
[19]
Patel, B.N.; Sharma, N.; Sanyal, M.; Shrivastav, P.S. LC-MS-ESI for the determination of loratadine and descarboethoxyloratadine in human plasma. J. Chromatogr. Sci., 2010, 48, 35-44.
[http://dx.doi.org/10.1093/chromsci/48.1.35]
[20]
Lu, J.; Wei, Y.C.; Markovich, R.J.; Rustum, A.M. Development and validation of a novel stability-indicating reversed-phase high-performance liquid chromatography method for assay of loratadine and determination of its related compounds. J. AOAC Int., 2010, 93, 891-903.
[21]
Ramulu, G.; Kumar, Y.R.; Vyas, K.; Suryanarayana, M.V.; Mukkanti, K. A new validated liquid chromatographic method for the determination of loratadine and its impurities. Sci. Pharm., 2011, 79, 277-292.
[http://dx.doi.org/10.3797/scipharm.1012-13]
[22]
Youssef, R.M.; Khamis, E.F.; El-Sayed, M.A.; Abdel Moneim, M.M. Validated HPTLC method for simultaneous determination of loratadine and desloratadine in presence of coformulated drug. J. Planar Chromatogr. Mod. TLC, 2012, 25, 456-462.
[http://dx.doi.org/10.1556/JPC.25.2012.5.12]
[23]
Issa, N. MLynarova, M. Analysis of tablets containing the antihistamine loratadine: a contribution to the identification of impurities. Ceska Slov. Farm., 2004, 53, 192-196.
[24]
Johnson, R.; Christensen, J.; Lin, C.C. Sensitive gas-liquid chromatographic method for the determination of loratadine and its major active metabolite, descarboethoxyloratadine, in human plasma using a nitrogen-phosphorus detector. J. Chromatogr. B Biomed. Sci. Appl., 1994, 657, 125-131.
[http://dx.doi.org/10.1016/0378-4347(94)80078-2]
[25]
Rele, R.V.; Gurav, P.J. A simple extractive spectrophotometric determination of loratadine, desloratadine and rupatadine from pharmaceutical formulations. Int. J. Pharma Bio Sci., 2012, 3, 89.
[26]
El-Awady, M.; Belal, F.; Pyell, U. Robust analysis of the hydrophobic basic analytes loratadine and desloratadine in pharmaceutical preparations and biological fluids by sweeping-cyclodextrin-modified micellar electrokinetic chromatography. J. Chromatogr. A, 2013, 1309, 64-75.
[http://dx.doi.org/10.1016/j.chroma.2013.08.020]
[27]
Center for Drug Evaluation and Research. Food and Drug Administration:Rockville, 1994.Available at:. (https://www.fda.gov/downloads/drugs/guidances/ucm134409.pdf)
[28]
US Food and Drug Administration. Guidance for Industry: Bioanalytical Method Validation. Food and Drug Administration: Rockville,. 2001.http://www.fda.gov/downloads/Drugs/Guidance/ucm070107.pdf
[29]
Zimmer, D. New US FDA draft guidance on bioanalytical method validation versus current FDA and EMA Guidelines: Chromatographic methods and ISR. Bioanal., 2014, 6(1), 13-19.
[http://dx.doi.org/10.4155/bio.13.298.]
[30]
30. Hilbert, J.; Radwanski, E.; Affrime, M.; Perentesis, G.; Symchowicz, S.; Zam-Paglione, N. Excretion of loratadine in human breast milk. J. Clin. Pharmacol., 1988, 28(3), 234-239.
[http://dx.doi.org/10.1002/j.1552-4604.1988.tb03138.x]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version300msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[23:16:24] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[23:16:25] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[23:16:25] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (91.66ms)time
  • Application (209ms)time
  • 1 x Application (69.49%)
    209ms
    1 x Booting (30.51%)
    91.66ms
    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 duplicated139ms
    • 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 ('316600437','',1,1740525384,1740525384) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740525384
      840μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#24
      Backtrace
      • 11. middleware::check_user_access:24
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('316600437','/article/102564',1,1740525384,1740525384)
      130μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#27
      Backtrace
      • 11. middleware::check_user_access:27
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) 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 >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) 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 >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) 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 >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) 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 >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) 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 >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316600437 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316600437) limit 1
      14.77msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316600437
      • 1: 316600437
      • 2: 316600437
      • 3: 316600437
      • 4: 316600437
      • 5: 316600437
      • 6: 316600437
      • 7: 316600437
      • 8: 316600437
      • 9: 316600437
      • 10: 316600437
      • 11: 316600437
      • 12: 316600437
      • 13: 316600437
      • 14: 316600437
      • 15: 316600437
      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=102564
      700μ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` = 15 limit 1
      32.52msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 15
      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=15) and sj.journal_id!=15 group by `j`.`nid`) as `aggregate_table`
      1.23msalphaeurekaselec_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=15) and sj.journal_id!=15 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      860μ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=15) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.66msalphaeurekaselec_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=15) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      1.44msalphaeurekaselec_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` = '102564'
      870μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 102564
      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` = '102564'
      2.39msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 102564
      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` = '102564' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.68msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 102564
      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
      230μ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
      400μ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 = 15 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      32.09msalphaeurekaselec_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 = 15 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      12.26msalphaeurekaselec_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 = 15 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      13.81msalphaeurekaselec_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` = 102564 limit 1
      380μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 102564
      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 = 102564 and content_type = 'article' order by status desc limit 1
      340μ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` = 176942 limit 1
      240μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 176942
      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
      280μ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` = 'CDM' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      380μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CDM
      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 = '102564' 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) )
      470μ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 = '9621' 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) )
      410μ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 = '2559' 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) )
      390μ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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740525385 and j.to_date >= 1740525385 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2559) 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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740525385 and j.to_date >= 1740525385 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2559) 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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740525385 and j.to_date >= 1740525385 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2559)
      11.27msalphaeurekaselec_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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740525385 and j.to_date >= 1740525385 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9621) 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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740525385 and j.to_date >= 1740525385 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9621) 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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740525385 and j.to_date >= 1740525385 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9621)
      620μ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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740525385 and j.to_date >= 1740525385 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 102564) 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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740525385 and j.to_date >= 1740525385 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 102564) 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 <= 316600437 and j.to_ip >=316600437 )) and ((j.from_date <= 1740525385 and j.to_date >= 1740525385 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 102564)
      600μ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` < '1053' and is_uploaded = 1 and issue_id = 9621 order by cast(first_page as SIGNED) desc limit 1
      510μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 1053
      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` > '1059' and is_uploaded = 1 and issue_id = 9621 order by cast(first_page as SIGNED) asc limit 1
      420μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 1059
      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'
      180μ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
      180μ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` = 102564 limit 1
      2.32msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 102564
      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` = 15 and `b`.`banner_from_date` <= 1740525385 and `b`.`banner_to_date` >= 1740525385 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.18msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 15
      • 3: 1740525385
      • 4: 1740525385
      • 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` = 15 and `b`.`banner_from_date` <= 1740525385 and `b`.`banner_to_date` >= 1740525385 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.12msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 15
      • 3: 1740525385
      • 4: 1740525385
      • 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='501e28efcd9f3fb82c840585d4a71ed5'
      210μ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
        KSmVHCDzJerTlMEKOTtLEiDCALsHtS4dChRF0WCe
        uc_cart_id
        501e28efcd9f3fb82c840585d4a71ed5
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/102564" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/102564
        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 23:16:25 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkJPcEJ4a2FYaDdObVgzcVRFN01JeEE9PSIsInZhbHVlIjoiZEtxSzVaTW9iR1BGUm1IRTFuODhMZFhWQVhJdnZyRytnei9mMEtQYUxrSTVGclArVGtJODJJS3lwSWM4cklQWEwxTTNubjREQnczdWNKdjA2R3BTLzFhTXRpbERzSGFnRmJrZks0RWgxVzhjdTk3Tndya0xXbXNuZCtFYXdab0kiLCJtYWMiOiJhNzNkZWJmZjQ1ZjIyNzlkMjg2M2MyZmI2MWY1NGUyZDIxOWI4MDI0MmFjYTQzYzI3MjRkNzFhNzlmMWIwNzZhIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 11:16:25 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkJPcEJ4a2FYaDdObVgzcVRFN01JeEE9PSIsInZhbHVlIjoiZEtxSzVaTW9iR1BGUm1IRTFuODhMZFhWQVhJdnZyRytnei9mMEtQYUxrSTVGclArVGtJODJJS3lwSWM4cklQWEwxTTNub" 1 => "alphaeurekaselectnet_session=eyJpdiI6IktOYzduaXNReGZxZ0RWUG9uelF5WEE9PSIsInZhbHVlIjoiT0tlR2szN0R6V1NTOVcxU3ZVM01uVDFSbjlmcXUxRnlwR1ZDODBrUVMyM2FCVGhSNS92V3hQS1ltWStxMzJBMWh0dDRRWEp3QTFlZFdZZjMvZHpkVTJ5NlRoYXpDcUd6Y2F1RXpvZkM2VGZnSnQycWJoTGNSNGpGb0ZWVnZOWmMiLCJtYWMiOiI1MWRlNTk5MWQ3ZDA1OWZhZjA0NTdhYmYyMTAzMDhiMzViY2QxY2ZiNzQ5M2YzYjBiY2M1NjFkMzZhZTVlNzRjIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IktOYzduaXNReGZxZ0RWUG9uelF5WEE9PSIsInZhbHVlIjoiT0tlR2szN0R6V1NTOVcxU3ZVM01uVDFSbjlmcXUxRnlwR1ZDODBrUVMyM2FCVGhSNS92V3hQS1l" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkJPcEJ4a2FYaDdObVgzcVRFN01JeEE9PSIsInZhbHVlIjoiZEtxSzVaTW9iR1BGUm1IRTFuODhMZFhWQVhJdnZyRytnei9mMEtQYUxrSTVGclArVGtJODJJS3lwSWM4cklQWEwxTTNubjREQnczdWNKdjA2R3BTLzFhTXRpbERzSGFnRmJrZks0RWgxVzhjdTk3Tndya0xXbXNuZCtFYXdab0kiLCJtYWMiOiJhNzNkZWJmZjQ1ZjIyNzlkMjg2M2MyZmI2MWY1NGUyZDIxOWI4MDI0MmFjYTQzYzI3MjRkNzFhNzlmMWIwNzZhIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 11:16:25 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkJPcEJ4a2FYaDdObVgzcVRFN01JeEE9PSIsInZhbHVlIjoiZEtxSzVaTW9iR1BGUm1IRTFuODhMZFhWQVhJdnZyRytnei9mMEtQYUxrSTVGclArVGtJODJJS3lwSWM4cklQWEwxTTNub" 1 => "alphaeurekaselectnet_session=eyJpdiI6IktOYzduaXNReGZxZ0RWUG9uelF5WEE9PSIsInZhbHVlIjoiT0tlR2szN0R6V1NTOVcxU3ZVM01uVDFSbjlmcXUxRnlwR1ZDODBrUVMyM2FCVGhSNS92V3hQS1ltWStxMzJBMWh0dDRRWEp3QTFlZFdZZjMvZHpkVTJ5NlRoYXpDcUd6Y2F1RXpvZkM2VGZnSnQycWJoTGNSNGpGb0ZWVnZOWmMiLCJtYWMiOiI1MWRlNTk5MWQ3ZDA1OWZhZjA0NTdhYmYyMTAzMDhiMzViY2QxY2ZiNzQ5M2YzYjBiY2M1NjFkMzZhZTVlNzRjIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IktOYzduaXNReGZxZ0RWUG9uelF5WEE9PSIsInZhbHVlIjoiT0tlR2szN0R6V1NTOVcxU3ZVM01uVDFSbjlmcXUxRnlwR1ZDODBrUVMyM2FCVGhSNS92V3hQS1l" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "KSmVHCDzJerTlMEKOTtLEiDCALsHtS4dChRF0WCe" "uc_cart_id" => "501e28efcd9f3fb82c840585d4a71ed5" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/102564" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 23:16:25GET/article/102564314361