Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sed augue libero. Maecenas efficitur id ligula et molestie. Aliquam suscipit turpis tellus, et sodales massa aliquet sed. Aenean
Register an account today and get great deals, offers and customised products only for you.
| Joomla! Version | 4.2.6 |
| PHP Version | 7.4.33 |
| Identity | guest |
| Response | 200 |
| Template | r_onsale |
| Database |
|
| 1 x afterRenderComponent com_virtuemart (8.13MB) (19.44%) | 97.62ms |
| 1 x afterInitialise (8.34MB) (15.35%) | 77.11ms |
| 1 x afterRender (1.43MB) (10.49%) | 52.69ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Navigation (Product categories) on other pages) (2.98MB) (7.89%) | 39.61ms |
| 1 x beforeRenderRawModule mod_login (Login Form) (4.63MB) (7.8%) | 39.19ms |
| 1 x afterLoad (3.73MB) (6.09%) | 30.61ms |
| 1 x afterRoute (2.8MB) (5.81%) | 29.17ms |
| 1 x afterRenderRawModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (2.83MB) (5.58%) | 28.01ms |
| 1 x afterRenderRawModule mod_virtuemart_product (VM - Featured products) (1.81MB) (4.16%) | 20.88ms |
| 1 x afterRenderRawModule mod_virtuemart_category_search (VirtueMart Category Search Module) (893.63KB) (3.5%) | 17.57ms |
| 1 x Before Access::preloadComponents (all components) (1.79MB) (3.06%) | 15.39ms |
| 1 x afterRenderRawModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (1.25MB) (2.64%) | 13.26ms |
| 1 x afterRenderRawModule mod_login (Login Form) (198.82KB) (0.97%) | 4.88ms |
| 1 x beforeRenderRawModule mod_gantry5_particle (Navigation (Product categories) on other pages) (4KB) (0.62%) | 3.11ms |
| 1 x beforeRenderRawModule mod_gantry5_particle (Current Offers) (13.77KB) (0.61%) | 3.08ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Current Offers) (51.58KB) (0.41%) | 2.08ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Get Support) (32.77KB) (0.29%) | 1.44ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Copyright) (35.27KB) (0.28%) | 1.40ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Payment logos) (5KB) (0.24%) | 1.20ms |
| 1 x afterRenderRawModule mod_gantry5_particle (My Account) (6KB) (0.22%) | 1.12ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Information) (6KB) (0.22%) | 1.11ms |
| 1 x afterRenderModule mod_login (Login Form) (63.5KB) (0.17%) | 874μs |
| 1 x After Access::preloadComponents (all components) (119.09KB) (0.17%) | 848μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Copyright) (7.43KB) (0.13%) | 678μs |
| 1 x beforeRenderRawModule mod_custom (Register to save more) (6.87KB) (0.13%) | 665μs |
| 1 x beforeRenderRawModule mod_virtuemart_product (VM - Featured products) (6.32KB) (0.13%) | 663μs |
| 1 x afterRenderRawModule mod_custom (Register to save more) (4.01KB) (0.09%) | 458μs |
| 1 x beforeRenderRawModule mod_virtuemart_category_search (VirtueMart Category Search Module) (4.04KB) (0.08%) | 410μs |
| 1 x After Access::getAssetRules (id:1 name:root.1) (24.98KB) (0.08%) | 406μs |
| 1 x beforeRenderRawModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (2.06KB) (0.08%) | 401μs |
| 1 x afterRenderModule mod_gantry5_particle (Navigation (Product categories) on other pages) (91.12KB) (0.05%) | 270μs |
| 1 x afterRenderRawModule mod_custom (Offer Banner on Sidebar) (1000B) (0.05%) | 239μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Information) (1.01KB) (0.04%) | 225μs |
| 1 x afterRenderModule mod_gantry5_particle (Copyright) (2.38KB) (0.04%) | 220μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Get Support) (904B) (0.04%) | 216μs |
| 1 x afterRenderModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (5.95KB) (0.04%) | 213μs |
| 1 x afterRenderModule mod_gantry5_particle (Current Offers) (3KB) (0.04%) | 209μs |
| 1 x afterRenderModule mod_virtuemart_product (VM - Featured products) (25.94KB) (0.04%) | 208μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (My Account) (120B) (0.04%) | 207μs |
| 1 x afterRenderModule mod_gantry5_particle (Get Support) (3.25KB) (0.04%) | 205μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Payment logos) (712B) (0.04%) | 205μs |
| 1 x afterRenderModule mod_gantry5_particle (Information) (2.88KB) (0.04%) | 204μs |
| 1 x afterRenderModule mod_gantry5_particle (My Account) (2.88KB) (0.04%) | 204μs |
| 1 x afterRenderModule mod_gantry5_particle (Payment logos) (2.44KB) (0.04%) | 202μs |
| 1 x beforeRenderModule mod_login (Login Form) (64.45KB) (0.04%) | 195μs |
| 1 x afterRenderModule mod_custom (Offer Banner on Sidebar) (2.25KB) (0.03%) | 171μs |
| 1 x beforeRenderComponent com_virtuemart (7.51KB) (0.03%) | 154μs |
| 1 x beforeRenderModule mod_custom (Register to save more) (376B) (0.03%) | 138μs |
| 1 x afterDispatch (2.25KB) (0.02%) | 113μs |
| 1 x afterRenderModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (1.27KB) (0.02%) | 100μs |
| 1 x afterRenderModule mod_virtuemart_category_search (VirtueMart Category Search Module) (1.26KB) (0.02%) | 91μs |
| 1 x afterRenderModule mod_custom (Register to save more) (1.27KB) (0.02%) | 90μs |
| 1 x afterRenderModule mod_custom (Register to save more) (1.26KB) (0.02%) | 82μs |
| 1 x beforeRenderRawModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (1.66KB) (0.01%) | 75μs |
| 1 x beforeRenderRawModule mod_custom (Offer Banner on Sidebar) (2.59KB) (0.01%) | 74μs |
| 1 x afterRenderModule mod_login (Login Form) (2.52KB) (0.01%) | 72μs |
| 1 x Before Access::getAssetRules (id:492 name:com_virtuemart) (456B) (0%) | 20μs |
| 1 x Before Access::getAssetRules (id:1 name:root.1) (3.55KB) (0%) | 18μs |
| 1 x After Access::getAssetRules (id:492 name:com_virtuemart) (1.61KB) (0%) | 9μs |
| 1 x beforeRenderModule mod_login (Login Form) (720B) (0%) | 8μs |
| 1 x beforeRenderModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (752B) (0%) | 8μs |
| 1 x beforeRenderModule mod_gantry5_particle (Navigation (Product categories) on other pages) (768B) (0%) | 8μs |
| 1 x beforeRenderModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (752B) (0%) | 8μs |
| 1 x beforeRenderModule mod_custom (Offer Banner on Sidebar) (720B) (0%) | 7μs |
| 1 x beforeRenderModule mod_custom (Register to save more) (720B) (0%) | 7μs |
| 1 x beforeRenderModule mod_virtuemart_category_search (VirtueMart Category Search Module) (752B) (0%) | 7μs |
| 1 x beforeRenderModule mod_virtuemart_product (VM - Featured products) (736B) (0%) | 7μs |
| 1 x beforeRenderModule mod_gantry5_particle (Current Offers) (736B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Information) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (My Account) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Get Support) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Copyright) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Payment logos) (720B) (0%) | 5μs |
SELECT @@SESSION.sql_mode;74μs1.59KB/libraries/src/Session/MetadataManager.php:184CopySELECT `session_id`
FROM `ly39srojgh48_session`
WHERE `session_id` = :session_id LIMIT 1130μs1.61KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `ly39srojgh48_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)1.99ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ly39srojgh48_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1330μs4.73KB/libraries/src/Component/ComponentHelper.php:393CopySELECT `id`,`rules`
FROM `ly39srojgh48_viewlevels`121μs1.73KB/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `ly39srojgh48_usergroups` AS `a`
LEFT JOIN `ly39srojgh48_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest164μs1.67KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `ly39srojgh48_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`1.06ms16.8KBParams/libraries/src/Plugin/PluginHelper.php:283CopySELECT * FROM ly39srojgh48_hikashop_config272μs44.94KB/administrator/components/com_hikashop/classes/config.php:16CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));54μs1.25KB/administrator/components/com_hikashop/helpers/helper.php:3194CopySELECT `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 `ly39srojgh48_menu` AS `m`
LEFT JOIN `ly39srojgh48_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`1.08ms223.05KBParams/libraries/src/Menu/SiteMenu.php:166CopySHOW TABLES LIKE "ly39srojgh48_virtuemart_configs"384μs872B/administrator/components/com_virtuemart/helpers/vmtable.php:792CopySELECT `config` FROM `ly39srojgh48_virtuemart_configs` WHERE `virtuemart_config_id` = "1";86μs872B/administrator/components/com_virtuemart/helpers/config.php:452CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `ly39srojgh48_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,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43)495μs10.5KBParams/libraries/src/Access/Access.php:357CopySELECT *
FROM `ly39srojgh48_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC167μs2.44KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `ly39srojgh48_template_styles` AS `s`
LEFT JOIN `ly39srojgh48_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` = 1238μs1.69KB/administrator/components/com_templates/src/Model/StyleModel.php:771CopySELECT * FROM `ly39srojgh48_menu` WHERE `link` like "index.php?option=com_virtuemart%" and (language="*" or language = "en-GB" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC646μs4.53KB/components/com_virtuemart/router.php:1643CopySELECT l.virtuemart_manufacturer_id FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.slug = "nullam-euismod"95μs3.35KB/components/com_virtuemart/router.php:1571CopySELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM ly39srojgh48_template_styles AS s
WHERE s.client_id = 0 AND s.template = 'r_onsale'
ORDER BY s.id219μs1.23KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "5"95μs872B/components/com_virtuemart/router.php:1571CopySELECT c.* FROM ly39srojgh48_virtuemart_customs as c WHERE searchable="1" and (field_type="S" or field_type="P") and c.published = 1 GROUP BY c.virtuemart_custom_id216μs4.3KB/components/com_virtuemart/views/category/view.html.php:610CopySELECT * FROM `ly39srojgh48_virtuemart_shoppergroups` WHERE `default` = "2" AND (`virtuemart_vendor_id` = "1" OR `shared` = "1") AND `published`="1"167μs3.94KB/administrator/components/com_virtuemart/models/shoppergroup.php:101CopySELECT `ly39srojgh48_virtuemart_shoppergroups`.* FROM `ly39srojgh48_virtuemart_shoppergroups` WHERE `ly39srojgh48_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"102μs3.94KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySHOW FULL COLUMNS FROM `ly39srojgh48_virtuemart_userfields`523μs10.39KB/administrator/components/com_virtuemart/helpers/vmtable.php:753CopySELECT * FROM `ly39srojgh48_virtuemart_userfields` WHERE 1 = 1 AND `account`="1" AND published = 1 AND FIND_IN_SET(name, 'address_type') = 0 ORDER BY ordering374μs16.77KB/administrator/components/com_virtuemart/helpers/vmmodel.php:504CopySELECT * FROM `ly39srojgh48_virtuemart_userfields` WHERE 1 = 1 AND `shipment`="1" AND published = 1 AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0 ORDER BY ordering300μs12.64KB/administrator/components/com_virtuemart/helpers/vmmodel.php:504CopySELECT p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` as m ON m.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 5 AND p.`product_special`="1" AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `mf_name` DESC, p.`virtuemart_product_id` DESC LIMIT 12224μs840B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` as m ON m.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 5 AND p.`product_discontinued`="1" AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `mf_name` DESC, p.`virtuemart_product_id` DESC LIMIT 12210μs840B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` as m ON m.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 5 AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY p.`created_on` DESC, p.`virtuemart_product_id` DESC LIMIT 4282μs968B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "44"217μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "44" ORDER BY `ordering`97μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "44" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC202μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "44"93μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 44109μs13.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "1"164μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "2"153μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "3"150μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "4"151μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "5"155μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "6"148μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "7"148μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "8"150μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "9"146μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "10"147μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "11"147μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "12"146μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "13"147μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "14"147μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "15"147μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "16"148μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_manufacturers`.* ,`ly39srojgh48_virtuemart_manufacturers_en_gb`.* FROM `ly39srojgh48_virtuemart_manufacturers` INNER JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` ON `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id` WHERE `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "4"128μs4.19KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (44) AND c.`published` = "1" ORDER BY field.`ordering` ASC215μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT * FROM `ly39srojgh48_virtuemart_currencies` AS c
LEFT JOIN `ly39srojgh48_virtuemart_vendors` AS v ON c.virtuemart_currency_id = v.vendor_currency
WHERE v.virtuemart_vendor_id = "1"189μs7.75KB/administrator/components/com_virtuemart/models/vendor.php:323CopySELECT `ly39srojgh48_virtuemart_currencies`.* FROM `ly39srojgh48_virtuemart_currencies` WHERE `ly39srojgh48_virtuemart_currencies`.`virtuemart_currency_id` = "47"129μs4.34KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.* FROM ly39srojgh48_virtuemart_calcs as c LEFT JOIN ly39srojgh48_virtuemart_calc_shoppergroups as cs ON cs.virtuemart_calc_id=c.virtuemart_calc_id WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ISNULL(publish_up) OR ( ISNULL("publish_up") or publish_up="0000-00-00 00:00:00") OR publish_up <= "2025-04-15 17:44:16" )
AND ( ISNULL(publish_down) OR ( ISNULL("publish_down") or publish_down="0000-00-00 00:00:00") OR publish_down >= "2025-04-15 17:44:16" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)181μs4.3KB/administrator/components/com_virtuemart/helpers/calculationh.php:176CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "44"102μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "43"213μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "43" ORDER BY `ordering`91μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "43" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "43"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 43106μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (43) AND c.`published` = "1" ORDER BY field.`ordering` ASC216μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "43"101μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "40"206μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "40" ORDER BY `ordering`87μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "40" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC204μs12.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "40"87μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 40105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT `ly39srojgh48_virtuemart_manufacturers`.* ,`ly39srojgh48_virtuemart_manufacturers_en_gb`.* FROM `ly39srojgh48_virtuemart_manufacturers` INNER JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` ON `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id` WHERE `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "2"145μs4.19KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (40) AND c.`published` = "1" ORDER BY field.`ordering` ASC199μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "40"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "39"205μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "39" ORDER BY `ordering`111μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "39" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC211μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "39"82μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 39105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (39) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "39"96μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "28"124μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "26"136μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` as m ON m.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 5 AND pp.`product_price`>"0.001" AND p.`published`="1" AND ( p.`virtuemart_product_id` NOT IN (44,43,40,39) ) )
group by p.`virtuemart_product_id`
ORDER BY p.`product_sales` DESC, p.`virtuemart_product_id` DESC LIMIT 4366μs968B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "34"221μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "34" ORDER BY `ordering`94μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "34" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC193μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "34"81μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 34114μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (34) AND c.`published` = "1" ORDER BY field.`ordering` ASC205μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "34"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "33"222μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "33" ORDER BY `ordering`95μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "33" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC195μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "33"80μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 33106μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (33) AND c.`published` = "1" ORDER BY field.`ordering` ASC212μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "33"104μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "28"210μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "28" ORDER BY `ordering`89μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "28" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC202μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "28"87μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 28108μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (28) AND c.`published` = "1" ORDER BY field.`ordering` ASC200μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "28"96μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "27"210μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "27" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "27" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC201μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "27"87μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 27105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (27) AND c.`published` = "1" ORDER BY field.`ordering` ASC210μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "27"99μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "19"124μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "25"118μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` as m ON m.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id`
WHERE ( ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 5 AND p.`published`="1" AND ( p.`virtuemart_product_id` NOT IN (44,43,40,39,34,33,28,27) ) )
group by p.`virtuemart_product_id`
ORDER BY `mf_name` DESC, p.`virtuemart_product_id` DESC LIMIT 24, 24257μs840B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT FOUND_ROWS()36μs872B/administrator/components/com_virtuemart/helpers/vmmodel.php:881CopySELECT DISTINCT l.virtuemart_manufacturer_id, l.mf_name FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l INNER JOIN `ly39srojgh48_virtuemart_product_manufacturers` AS pm ON pm.`virtuemart_manufacturer_id` = l.`virtuemart_manufacturer_id` INNER JOIN `ly39srojgh48_virtuemart_products` as p ON p.`virtuemart_product_id` = pm.`virtuemart_product_id` WHERE p.`published` = "1" ORDER BY `mf_name`220μs1.16KB/administrator/components/com_virtuemart/models/manufacturer.php:218CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "4"82μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "1"66μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "2"62μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "6"60μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "3"62μs872B/components/com_virtuemart/router.php:1571CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 0) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC656μs7.14KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "7" ORDER BY `ordering`97μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "2" ORDER BY `ordering`83μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "3" ORDER BY `ordering`77μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "1" ORDER BY `ordering`75μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "6" ORDER BY `ordering`74μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "5" ORDER BY `ordering`74μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "4" ORDER BY `ordering`74μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "7"124μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "6"117μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "5"116μs20.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "4"115μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "3"113μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "2"113μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "1"113μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_vendors`.* ,`ly39srojgh48_virtuemart_vendors_en_gb`.* FROM `ly39srojgh48_virtuemart_vendors` INNER JOIN `ly39srojgh48_virtuemart_vendors_en_gb` ON `ly39srojgh48_virtuemart_vendors`.`virtuemart_vendor_id` = `ly39srojgh48_virtuemart_vendors_en_gb`.`virtuemart_vendor_id` WHERE `ly39srojgh48_virtuemart_vendors`.`virtuemart_vendor_id` = "1"186μs20.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_vendor_medias` WHERE `virtuemart_vendor_id` = "1" ORDER BY `ordering`57μs840B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `ly39srojgh48_virtuemart_manufacturers`.* ,`ly39srojgh48_virtuemart_manufacturers_en_gb`.* FROM `ly39srojgh48_virtuemart_manufacturers` INNER JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` ON `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id` WHERE `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "5"132μs4.19KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_manufacturer_medias` WHERE `virtuemart_manufacturer_id` = "5" ORDER BY `ordering`56μs840B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `ly39srojgh48_modules` AS `m`
LEFT JOIN `ly39srojgh48_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `ly39srojgh48_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)
ORDER BY `m`.`position`,`m`.`ordering`1ms22.63KBParams/libraries/src/Cache/Controller/CallbackController.php:52CopySELECT 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 ly39srojgh48_fields AS a
LEFT JOIN `ly39srojgh48_languages` AS l ON l.lang_code = a.language
LEFT JOIN ly39srojgh48_users AS uc ON uc.id=a.checked_out
LEFT JOIN ly39srojgh48_viewlevels AS ag ON ag.id = a.access
LEFT JOIN ly39srojgh48_users AS ua ON ua.id = a.created_user_id
LEFT JOIN ly39srojgh48_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC767μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 7) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC528μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 2) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC492μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 3) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC481μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 1) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC602μs8.17KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "15" ORDER BY `ordering`101μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "11" ORDER BY `ordering`82μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "12" ORDER BY `ordering`77μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "10" ORDER BY `ordering`76μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "14" ORDER BY `ordering`75μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "8" ORDER BY `ordering`95μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "16" ORDER BY `ordering`77μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "13" ORDER BY `ordering`74μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "9" ORDER BY `ordering`74μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 15) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC506μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 11) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC496μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 12) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC476μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 10) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC453μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 14) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC484μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 8) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC484μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 16) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC490μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 13) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC463μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 9) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC454μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 6) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC481μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 5) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC502μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 4) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC501μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT * FROM ly39srojgh48_virtuemart_calcs LEFT JOIN ly39srojgh48_virtuemart_calc_shoppergroups using(virtuemart_calc_id)WHERE
`calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-04-15 17:44:16" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-15 17:44:16" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)191μs4.36KB/administrator/components/com_virtuemart/helpers/calculationh.php:1522CopySELECT * FROM ly39srojgh48_virtuemart_calcs LEFT JOIN ly39srojgh48_virtuemart_calc_shoppergroups using(virtuemart_calc_id)WHERE
`calc_kind`="TaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-04-15 17:44:16" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-15 17:44:16" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)165μs4.36KB/administrator/components/com_virtuemart/helpers/calculationh.php:1522CopySELECT * FROM ly39srojgh48_virtuemart_calcs LEFT JOIN ly39srojgh48_virtuemart_calc_shoppergroups using(virtuemart_calc_id)WHERE
`calc_kind`="DATaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-04-15 17:44:16" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-15 17:44:16" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)164μs4.36KB/administrator/components/com_virtuemart/helpers/calculationh.php:1522CopySELECT `a`.`menutype`,`a`.`title`
FROM `ly39srojgh48_menu_types` AS `a`
WHERE `a`.`client_id` = 0121μs1.11KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138CopySELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM ly39srojgh48_menu AS m
WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0
ORDER BY m.lft784μs15.05KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791CopySELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM ly39srojgh48_menu AS m
WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0
ORDER BY m.lft724μs15.05KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791CopySELECT p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` as m ON m.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY RAND() LIMIT 24, 5487μs1000B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "10"227μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "10" ORDER BY `ordering`97μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "10" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC206μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "10"88μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 10111μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT `ly39srojgh48_virtuemart_manufacturers`.* ,`ly39srojgh48_virtuemart_manufacturers_en_gb`.* FROM `ly39srojgh48_virtuemart_manufacturers` INNER JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` ON `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id` WHERE `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "3"148μs4.19KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (10) AND c.`published` = "1" ORDER BY field.`ordering` ASC194μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "10"105μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "26"206μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "26" ORDER BY `ordering`91μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "26" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC196μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "26"88μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 26106μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT `ly39srojgh48_virtuemart_manufacturers`.* ,`ly39srojgh48_virtuemart_manufacturers_en_gb`.* FROM `ly39srojgh48_virtuemart_manufacturers` INNER JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` ON `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id` WHERE `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"145μs4.19KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (26) AND c.`published` = "1" ORDER BY field.`ordering` ASC226μs8.42KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "26"109μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "6"210μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "6" ORDER BY `ordering`95μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "6" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "6"82μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 6105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (6) AND c.`published` = "1" ORDER BY field.`ordering` ASC200μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "6"105μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "4"205μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "4" ORDER BY `ordering`92μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "4" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC192μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "4"82μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 4115μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (4) AND c.`published` = "1" ORDER BY field.`ordering` ASC199μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "4"106μs2.3KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "42"215μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "42" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "42" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC193μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "42"81μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 42108μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (42) AND c.`published` = "1" ORDER BY field.`ordering` ASC200μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "42"100μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "35"128μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "17"116μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "23"114μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "21"111μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "18"113μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "8"221μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "8" ORDER BY `ordering`105μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "8" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC195μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "8"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 8106μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (8) AND c.`published` = "1" ORDER BY field.`ordering` ASC205μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "8"103μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT p.`virtuemart_product_id`
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` as m ON m.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY RAND() LIMIT 24, 8460μs1.07KB/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "19"213μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "19" ORDER BY `ordering`92μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "19" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "19"87μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 19108μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (19) AND c.`published` = "1" ORDER BY field.`ordering` ASC205μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "19"106μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "7"211μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "7" ORDER BY `ordering`94μs968B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "7" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC203μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "7"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 7105μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (7) AND c.`published` = "1" ORDER BY field.`ordering` ASC200μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "7"105μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "32"209μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "32" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "32" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC196μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "32"88μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 32108μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (32) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "32"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "14"209μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "14" ORDER BY `ordering`92μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "14" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-15 17:44:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-15 17:44:16" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "14"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 14116μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (14) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "14"98μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "24"122μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "30"120μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "31"116μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "32"116μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "22"114μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor`
FROM `ly39srojgh48_scheduler_tasks` AS `a`
LEFT JOIN `ly39srojgh48_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now
ORDER BY `a`.`title` asc222μs4.45KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor`
FROM `ly39srojgh48_scheduler_tasks` AS `a`
LEFT JOIN `ly39srojgh48_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL
ORDER BY `a`.`title` asc322μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy