Open Access

Biopharmaceutical Sciences, Biomed Biopharm Res., 2021; 18(2):228-237

doi: 10.19277/bbr.18.2.271;  [+] PDF version here; [+] Portuguese html version here

 

Rapid UV-Vis spectroscopy methods for quantification of ranitidine tablets

Patrícia Rijo 1,2*, Lara Ribeiro 1, Marisa Nicolai 1, Paula Pereira 1,3,4, Célia Faustino2*

1 Center for Research in Biosciences & Health Technologies (CBIOS), Universidade Lusófona de Humanidades e Tecnologias, 1749-024 Lisboa, Portugal;

2 Research Institute forMedicines (iMed.ULisboa), Faculty of Pharmacy, Universidade de Lisboa, Av. Prof. Gama Pinto, 1649–003, Lisbon, Portugal; 

3 Center for Natural Resources and Environment (CERENA), Instituto Superior Técnico (IST), Universidade de Lisboa, Av. Rovisco Pais, 1049-001 Lisboa, Portugal;

4 EPCV-ULHT-Universidade Lusófona de Humanidades e Tecnologias, 1749-024 Lisboa, Portugal

*corresponding authors: patricia.rijo@ulusofona.ptcfaustino@ff.ulisboa.pt

 

Abstract

Ranitidine is a histamine H2-receptor antagonist that inhibits gastric acid secretion, commonly used in the treatment and prophylaxis of peptic ulcer and gastroesophageal reflux disease. Over-the-counter ranitidine hydrochloride tablets are available in several European countries as well as the US for the relief of indigestion and heartburn. Commercial tablets containing the equivalent of 150 mg of ranitidine were analysed following extraction. Ranitidine is water-soluble, thus avoiding the use of organic solvents. Standard aqueous solutions of ranitidine hydrochloride were used to construct a calibration curve. This graduate laboratory experiment describes a simple, inexpensive, safe, and “green” procedure for the quantification of ranitidine tablets by UV spectrophotometry. The entire procedure provides an pedagogical opportunity to approach a realistic analytical scenario, typical of a quality control laboratory, by designing an attractive and engaging hands-on session. An average content of 148 ± 1 mg of ranitidine was determined using both standard addition and external calibration methods and results are in agreement with Pharmacopoeia.

 

Keywords: Analytical chemistry, ranitidine, drugs/pharmaceuticals, quantitative analysis, UV-Vis spectroscopy

Received 01/09/2021; Accepted: 21/12/2021

 

Introduction

UV-Vis spectroscopy is a feasible and straightforward analytical tool routinely used with other assay techniques in the pharmaceutical industry in areas such as quality control and quality assurance (1). Several papers describing the quantification of analytical samples by UV spectrophotometry in the pharmaceutical, biotechnological, and environmental areas, as well as in the field of food and beverage, have been reported in the literature (2-21).

Highly conjugated organic compounds, including many drugs and biological macromolecules (e.g., proteins and nucleic acids) absorb light in the ultraviolet (UV)-visible (vis) region of the electromagnetic spectrum. Quantitative analysis is based on the relationship between the degree of absorption and the concentration of the absorbing species in solution, mathematically described by the Beer–Lambert law, A = elcwhere A is the absorbance at a fixed wavelength, e is the absorption coefficient, l is the path length and c is concentration.

This experiment was conceived to introduce the technique of ultraviolet spectroscopy to undergraduate students in Pharmaceutical Organic Chemistry classes and describes a simple, inexpensive, and environmentally green (organic solvent-free) laboratory procedure for the quantitative assay of ranitidine, a histamine H2-receptor antagonist, in commercial 150 mg ranitidine tablets.

Ranitidine is a histamine H2-receptor antagonist that inhibits gastric acid secretion induced by histamine, pentagastrin, and other secretagogues. Ranitidine hydrochloride (Figure 1) is a white or pale yellow, water-soluble, crystalline powder.

Ranitidine is commonly used in the treatment and prophylaxis of peptic ulcer and gastroesophageal reflux disease, and also in other conditions where reduction of gastric secretion and acid output is desirable. It can also be administered with nonsteroidal anti-inflammatory drugs (NSAIDs) to reduce the risk of ulceration. The usual dose of ranitidine is either 150 mg twice a day or 300 mg once a day, usually at night.

Several preparations of ranitidine hydrochloride are available over the counter (OTC) for the relief of indigestion and heartburn, including 150 mg tablets. Each tablet for oral administration contains 168 mg of ranitidine hydrochloride (equivalent to 150 mg of ranitidine anhydrous free base).

Students are provided with 150 mg ranitidine tablets and a stock solution of ranitidine hydrochloride for the preparation of ranitidine standard solutions to be used in the construction of a calibration curve. The ranitidine tablets must be subjected to pre-analytical treatment for selective extraction and dilution of ranitidine for subsequent quantification.

The mass (mg) of ranitidine in the prescription tablet is determined from the calibration curve obtained, and the value is then compared with the label claim of the manufacturer according to the specifications of the Pharmacopeia. The official monographs of the European Pharmacopoeia (22) (and also the USP (23)) require that ranitidine tablets contain an amount of ranitidine hydrochloride (C13H23ClN4O3S) equivalent to not less than 90.0 % and not more than 110.0 % of the (package) labelled quantity of ranitidine (C13H22N4O3S) (24).

The entire laboratory procedure is completed in a three-hour lab session and is ideally performed by students working in group. It provides students with an opportunity to solve an authentic analytical problem with a commercial pharmaceutical sample in a realistic and engaging lab session. Although originally intended for undergraduate Pharmaceutical Organic Chemistry students, the experiment is simple enough to be performed by undergraduate students within a general chemistry course. It is also suited for advanced high school chemistry students, as long as a suitable UV spectrophotometer is available.

 

Materials and Methods

Reagents

Ranitidine hydrochloride was obtained from Sigma-Aldrich and used as received. OTC ranitidine hydrochloride tablets labelled to contain 150 mg of ranitidine were purchased from a local pharmacy. Absorbance measurements were performed ten times for blanks and in triplicate for standards and sample at 25 °C with an ultraviolet-visible spectrophotometer (Shimadzu UV-1603, Kyoto, Japan) using 1 cm length quartz cells. Distilled water (solvent) was used as the reference blank.

Experimental procedure

Standard addition and external calibration methods were performed to quantify ranitidine in commercial tablets.

Firstly, for the external calibration method, ranitidine hydrochloride was dissolved in water in order to prepare a 500.0 µg mL-1 stock solution, which was provided to the students. From the stock solution, students performed serial dilutions to prepare 25 mL ranitidine hydrochloride standard solutions with concentrations in the range 1.00–20.00 µg mL-1 to be used in the construction of a calibration curve.

The preparation of the pharmaceutical sample was based on the assay described in Pharmacopeia (22, 23) for ranitidine tablets. Five 150 mg ranitidine tablets were accurately weighed and crushed with a mortar and pestle. The resulting powder, equivalent to the average mass of one tablet, was dissolved in distilled water, with gentle stirring, to a final volume of 500 mL. The solution was filtered and a 1:100 dilution of the filtrate was performed, leading to the pharmaceutical sample to be analysed, with theoretical ranitidine concentration of 3.00 µg mL-1

For the standard addition method, 2.50 mL of the previously prepared sample solution (3.00 µg mL-1) was added to a 25 mL volumetric flask and the standard solutions were mixed and diluted to (final) ranitidine hydrochloride concentrations in the range of 1.0–20.0 µg mL-1.

The UV absorption spectra of the ranitidine hydrochloride stock solution and pharmaceutical sample were recorded between 400 and 200 nm, using distilled water as the reference blank, to compare the two profiles and determine the wavelength(s) of maximum absorbance. Absorption measurements of ranitidine hydrochloride solutions were performed in triplicate at the wavelengths of maximum absorption.

For accurate and precise quantification of the ranitidine content, the limit of detection (LOD) and the limit of quantification (LOQ) were determined (25). The LOD was determined using Equation 1, and the LOQ by Equation 2:

where σ is the standard deviation of the absorbance readings of the blank and S is the slope of the calibration curve.

Thus, ten absorbance measurements of the blank were performed at the wavelength of maximum absorbance of ranitidine to ensure a relative standard deviation (RSD) of less than 10%, as recommended by IUPAC (26).

 

Results and Discussion

The UV absorption spectra of the ranitidine hydrochloride stock solution and pharmaceutical sample solution are shown in Figure 2.

Figure 2 - UV absorption spectrum of a 10.0 µg mL−1 ranitidine hydrochloride stock solution (upper curve) and a solution from a commercial sample (lower curve) registered between 400 and 200 nm.

Sample and stock aqueous solutions show two absorption peaks at 314 nm and 227 nm. Absorption measurements are then performed at 314 nm and 227 nm against distilled water as the reference blank. In order to quantify ranitidine in tablets, students must convert the amount of ranitidine chloride to the ranitidine free base. In solution, the absorbing species is ranitidine, with hydrogen chloride present (only) to stabilize the ranitidine molecule against oxidation. Typical average absorption values and corrected ranitidine concentrations are shown in Table 1.

From data shown in Table 1, calibration curves were prepared (Figure 3) by plotting absorption values against ranitidine concentration. A linear relationship between absorbance and concentration was observed in the studied concentration range of 0.9–17.9 µg mL-1, thus following the Lambert-Beer law.

The equations of this straight line could be obtained from regression analysis using either a computer program or a scientific or graphing calculator in order to determine the ranitidine concentration (µg mL-1) in the sample solution and in the original pharmaceutical tablet, taking into account the dilution factor (Table 2).

Table 2 - Quantification range, equation of calibration curve, square of correlation coefficient, limit of detection (LOD), limit of quantification (LOQ), ranitidine mass, relative error at 227 nm and 314 nm for external calibration and standard addition methods. 

The mass of ranitidine (mg) in the prescription tablet was then determined from the concentration of ranitidine (mg/tablet) in the pharmaceutical sample and the value obtained is compared with the label claim of the manufacturer and with the specifications of the European Pharmacopoeia for ranitidine tablets. Students’ average results was 148 ± 1 mg of ranitidine, equivalent to a good agreement with the tolerable and expected percentage range of the labelled claim as set forth by Pharmacopoeia (22, 23).

 

Conclusion

The experimental procedure presented for quantification of the water-soluble drug ranitidine, a histamine H2-receptor antagonist, represents a non-hazardous, simple, and reproducible laboratory experiment that can be conducted at an undergraduate level.

The use of UV spectrophotometry allowed for the quantification of ranitidine in the tablets analysed. An average content of 148 ± 1 mg of ranitidine was calculated, in good agreement with the amount claimed on the product label and in accordance with the specifications of the European Pharmacopoeia. The ratio, between the maximum absorbances at 227 nm and 314 nm, were 1.05 and 1.07 for standard stock and sample solutions, respectively, also in conformity to Pharmacopoeia (22,23). The methods used were found to be simple, rapid, accurate, precise, and easily implemented in a three-hour laboratory class. Moreover, the requirement of readily available reagents that are inexpensive and safe to handle makes the analytical method economical and environmentally friendly. The proposed quantitation of ranitidine from commercial tablets can be made at 227 nm and/or at 314 nm using an external standard method and/or the standard addition method, showing relative error in the same order of magnitude.

 

Authors Contributions Statement

P.R., L.R., M.N., P.P., C.F. - conceptualization and study design; M.N. - experimental implementation; M.N., P.P. - data analysis; M.N., P.P. - drafting, editing and reviewing; M.N- figures and graphics; P.R., L.R., M.N., P.P., C.F - supervision and final writing.

 

Funding

This research was funded by Fundação para a Ciência e a Tecnologia (FCT, Portugal), through projects UIDP/04567/2020 and UIDB/04567/2020. P.P. Gratefully acknowledges the support of the CERENA strategic project FCT-UID/ECI/04028/2019.

 

Acknowledgments

The authors acknowledge all the participants.

 

Conflict of interest

The authors declare that there is no financial or personal relationship that could present a potential conflict of interests.

 

References

  1. Görög, S. (1995). UV-visible spectrophotometry in pharmaceutical analysis. CRC Press, Boca Raton, 1995.
  2. Egts, H., Durben, D. J., Dixson, J. A., & Zehfus, M. H. (2012). A Multicomponent UV Analysis of α- and β-Acids in Hops. Journal of Chemical Education, 89,117–120.
  3. Kimaru, I. W., Zhao, F., & Chichester, K. (2010). Spectrophotometric quantification of ibuprofen release in dissolution testing. A pharmaceutical analysis experiment for instrumental analysis laboratory. The Chemical Educator, 15,484–487.
  4. Mbindyo, J. K. N., & Brown, A. K. (2010). Investigating UV-Blocking Properties of Sunscreens on the Microscale. J. Chem. Educ., 87, 1388.
  5. Andersen, J. E. T. (2009). Exercise in quality assurance: A laboratory exercise. Journal of Chemical Education, 86,733–737.
  6. Reid, K. R., Meyerhoff, M. E., & Mitchell-Koch, J. T. (2008). Salicylate detection by complexation with iron(III) and optical absorbance spectroscopy. An undergraduate quantitative analysis experiment. Journal of Chemical Education, 85, 1658–1659.
  7. Dwyer, T. J., Fillo, & J. D. (2006). Assaying α-dicarbonyl compounds in wine: A complementary GC-MS, HPLC and visible spectrophotometric analysis. Journal of Chemical Education, 83, 273–276.
  8. Mouer, H. P., Zanella, A., & Poon, T. (2006). An introduction to UV-Vis spectroscopy using sunscreens. Journal of Chemical Education, 83, 769.
  9. Beckers, J. L. (2004). The determination of caffeine in coffee: Sense or nonsense? Journal of Chemical Education, 81, 90–93.
  10. Patterson, B. M., Danielson, N. D., Lorigan, G. A., & Sommer, A. S. (2003). Analytical spectroscopy using modulator systems. Journal of Chemical Education, 80, 1460–1463.
  11. Byrd, H., & O’Donell, S. E. (2003). A General Chemistry Laboratory Theme: Spectroscopic Analysis of Aspirin. J. Chem. Educ., 80, 174–176.
  12. Aberásturi, F., Jiménez, A. I., Jiménez, F., & Arias, J. J. (2001). UV-Visible first-derivative spectrophotometry applied to an analysis of a vitamin mixture. Journal of Chemical Education78, 793–795.
  13. Aroti, A., & Leontidis, E. (2001). Simultaneous determination of the ionization constant and the solubility of sparingly soluble drug substances. A physical chemistry experiment. Journal of Chemical Education78, 786–788.
  14. Ribone, M. É., Pagani, A. P., Olivieri, A. C., & Goicoechea, H. C. (2000). Determination of the active principle in a syrup by spectrophotometry and principal component regression analysis. An advanced undergraduate experiment involving Chemometrics. Journal of Chemical Education, 77,1330– 1333.
  15. Aurian-Blajeni, B., Sam, J., & Sisak, M. (1999). Sweet chemistry. Journal of Chemical Education, 76, 91–92.
  16. McDevitt, V. L., Rodriguez, A., & Williams, K. R. (1998). Analysis of soft drinks: UV spectrophotometry, liquid chromatography and capillary electrophoresis.Journal of Chemical Education, 75, 625–628.
  17. Adams, P. E. (1995). Determining iron content in foods by spectrophotometry. Journal of Chemical Education, 72,649–651.
  18. Yarnelle, M. K., & West, K. J. (1989). Modification of an ultraviolet spectrophotometric determination of the active ingredients in APC tablets. Journal of Chemical Education, 66, 601–602.
  19. Stolzberg, R. J. (1986). Evaluation of derivative ultraviolet spectrometry for determining saccharin in cola and other matrices: An instrumental methods experiment. Journal of Chemical Education, 63, 351–353.
  20. Van Atta, R. E. (1979). Ultraviolet spectrophotometric determination of caffeine in cola Drinks: An organic analytical experiment. Journal of Chemical Education, 56, 666.
  21. Fernandez, L. T., Mannett, K., & Frederick H. (1978). Experiment for instrumental analysis. The determination of aspirin by ultraviolet absorption.Journal of Chemical Education, 55, 266.
  22. European Pharmacopoeia. (2010). European directorate for the quality of medicines and health care (7th edition), Council of Europe, Strasbourg.
  23. Pharmacopeia–National Formulary (USP35 – NF30). (2012). United States pharmacopeial convention, Rockville, USA.
  24. Under revision, 95-105%, USP Medicines Compendium (USP-MC). available at https://mc.usp.org (last accessed 06 June 2013).
  25. International conference on harmonisation of technical requirements for registration of pharmaceuticals for human use. (1994). ICH guideline Q2(R1): Validation of analytical procedures: text and methodology, Geneva, Switzerland.
  26. Currie, L. A. (1999). Nomenclature in evaluation of analytical methods including detection and quantification capabilities. Analytica Chimica Acta, 391(2), 105-126.

 

 

18.913MBMemory Usage337msRequest Duration
Joomla! Version4.4.11
PHP Version8.2.27
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
5.7.32
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:50 [ "CONTEXT_DOCUMENT_ROOT" => "/home/biomedi/public_html" "CONTEXT_PREFIX" => "" "DOCU...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744841347 "last" => 1744841347...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (4.01MB) (64.53ms)
  • afterInitialise (6.65MB) (134ms)
  • afterRoute (652.61KB) (12.08ms)
  • beforeRenderComponent com_content (1005.42KB) (13.31ms)
  • Before Access::preloadComponents (all components) (627.28KB) (7.68ms)
  • After Access::preloadComponents (all components) (102.45KB) (1.97ms)
  • Before Access::preloadPermissions (com_content) (424B) (33μs)
  • After Access::preloadPermissions (com_content) (115.2KB) (1.21ms)
  • Before Access::getAssetRules (id:222 name:com_content.article.121) (6.65KB) (28μs)
  • After Access::getAssetRules (id:222 name:com_content.article.121) (26.42KB) (453μs)
  • afterRenderComponent com_content (2.85MB) (40.85ms)
  • Before Access::getAssetRules (id:8 name:com_content) (174.24KB) (3.98ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (22μs)
  • afterDispatch (9.01KB) (1.63ms)
  • beforeRenderRawModule mod_menu (Main Menu EN) (253.71KB) (4.89ms)
  • afterRenderRawModule mod_menu (Main Menu EN) (1.23MB) (33.06ms)
  • beforeRenderRawModule mod_finder (Search) (864B) (59μs)
  • afterRenderRawModule mod_finder (Search) (465.23KB) (9.25ms)
  • beforeRenderModule mod_menu (Main Menu EN) (25.87KB) (566μs)
  • afterRenderModule mod_menu (Main Menu EN) (23.88KB) (223μs)
  • beforeRenderModule mod_finder (Search) (2.57KB) (30μs)
  • afterRenderModule mod_finder (Search) (3.05KB) (105μs)
  • afterRender (351.5KB) (6.02ms)
  • 1 x afterInitialise (6.65MB) (39.71%)
    133.76ms
    1 x afterLoad (4.01MB) (19.16%)
    64.53ms
    1 x afterRenderComponent com_content (2.85MB) (12.13%)
    40.85ms
    1 x afterRenderRawModule mod_menu (Main Menu EN) (1.23MB) (9.81%)
    33.06ms
    1 x beforeRenderComponent com_content (1005.42KB) (3.95%)
    13.31ms
    1 x afterRoute (652.61KB) (3.59%)
    12.08ms
    1 x afterRenderRawModule mod_finder (Search) (465.23KB) (2.75%)
    9.25ms
    1 x Before Access::preloadComponents (all components) (627.28KB) (2.28%)
    7.68ms
    1 x afterRender (351.5KB) (1.79%)
    6.02ms
    1 x beforeRenderRawModule mod_menu (Main Menu EN) (253.71KB) (1.45%)
    4.89ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (174.24KB) (1.18%)
    3.98ms
    1 x After Access::preloadComponents (all components) (102.45KB) (0.59%)
    1.97ms
    1 x afterDispatch (9.01KB) (0.49%)
    1.63ms
    1 x After Access::preloadPermissions (com_content) (115.2KB) (0.36%)
    1.21ms
    1 x beforeRenderModule mod_menu (Main Menu EN) (25.87KB) (0.17%)
    566μs
    1 x After Access::getAssetRules (id:222 name:com_content.article.121) (26.42KB) (0.13%)
    453μs
    1 x afterRenderModule mod_menu (Main Menu EN) (23.88KB) (0.07%)
    223μs
    1 x afterRenderModule mod_finder (Search) (3.05KB) (0.03%)
    105μs
    1 x beforeRenderRawModule mod_finder (Search) (864B) (0.02%)
    59μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.01%)
    33μs
    1 x beforeRenderModule mod_finder (Search) (2.57KB) (0.01%)
    30μs
    1 x Before Access::getAssetRules (id:222 name:com_content.article.121) (6.65KB) (0.01%)
    28μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.01%)
    22μs
30 statements were executed, 2 of which were duplicates, 28 unique21.58ms294.76KB
  • SELECT @@SESSION.sql_mode;242μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `g6vzf_session` WHERE `session_id` = ?314μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `g6vzf_session` WHERE `session_id` = :session_id LIMIT 1232μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `g6vzf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)723μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `g6vzf_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1651μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `g6vzf_viewlevels`268μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `g6vzf_usergroups` AS `a` LEFT JOIN `g6vzf_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest313μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `g6vzf_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`1.63ms3.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `g6vzf_languages` WHERE `published` = 1 ORDER BY `ordering` ASC371μs2.23KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `g6vzf_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1371μs784B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `g6vzf_menu` AS `m` LEFT JOIN `g6vzf_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`3.63ms183.3KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `g6vzf_template_styles` AS `s` LEFT JOIN `g6vzf_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1440μs864B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `g6vzf_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39)1.19ms7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `g6vzf_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0609μs5.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `g6vzf_content`719μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `g6vzf_content` SET `hits` = (`hits` + 1) WHERE `id` = '121'2.51ms48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `g6vzf_content` AS `a` INNER JOIN `g6vzf_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `g6vzf_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `g6vzf_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `g6vzf_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `g6vzf_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)618μs55.44KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `g6vzf_categories` AS `s` INNER JOIN `g6vzf_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`573μs3.97KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `g6vzf_contentitem_tag_map` AS `m` INNER JOIN `g6vzf_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)336μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `g6vzf_categories` AS `s` INNER JOIN `g6vzf_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`597μs3.97KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM g6vzf_fields AS a LEFT JOIN `g6vzf_languages` AS l ON l.lang_code = a.language LEFT JOIN g6vzf_users AS uc ON uc.id=a.checked_out LEFT JOIN g6vzf_viewlevels AS ag ON ag.id = a.access LEFT JOIN g6vzf_users AS ua ON ua.id = a.created_user_id LEFT JOIN g6vzf_fields_groups AS g ON g.id = a.group_id LEFT JOIN `g6vzf_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray7,:preparedArray8) ORDER BY a.ordering ASC830μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `language`,`id` FROM `g6vzf_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0447μs592B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `g6vzf_menu` AS `c` INNER JOIN `g6vzf_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `g6vzf_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `g6vzf_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id256μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `g6vzf_content` AS `c` INNER JOIN `g6vzf_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `g6vzf_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `g6vzf_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `g6vzf_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-04-16 22:09:07') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-04-16 22:09:07') AND c2.state = 1984μs1.47KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `g6vzf_modules` AS `m` LEFT JOIN `g6vzf_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `g6vzf_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`760μs1.88KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `g6vzf_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1540μs656B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `g6vzf_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)361μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `g6vzf_scheduler_tasks` AS `a` WHERE `a`.`state` = 1223μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `g6vzf_session` WHERE `session_id` = ?294μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `g6vzf_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?556μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy