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
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 (9MB) (22.42%) | 114.05ms |
| 1 x afterInitialise (8.34MB) (14.67%) | 74.62ms |
| 1 x afterRender (1.46MB) (10.84%) | 55.13ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Navigation (Product categories) on other pages) (2.98MB) (7.94%) | 40.41ms |
| 1 x beforeRenderRawModule mod_login (Login Form) (4.63MB) (7.67%) | 39.04ms |
| 1 x afterRoute (2.79MB) (6.02%) | 30.61ms |
| 1 x afterLoad (3.73MB) (5.65%) | 28.72ms |
| 1 x afterRenderRawModule mod_virtuemart_product (VM - Featured products) (2.53MB) (5.62%) | 28.60ms |
| 1 x afterRenderRawModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (2.45MB) (5.01%) | 25.51ms |
| 1 x Before Access::preloadComponents (all components) (1.79MB) (3.21%) | 16.34ms |
| 1 x afterRenderRawModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (1.25MB) (2.57%) | 13.09ms |
| 1 x afterRenderRawModule mod_login (Login Form) (197.7KB) (0.99%) | 5.03ms |
| 1 x beforeRenderRawModule mod_gantry5_particle (Current Offers) (17.77KB) (0.67%) | 3.39ms |
| 1 x beforeRenderRawModule mod_gantry5_particle (Navigation (Product categories) on other pages) (4KB) (0.62%) | 3.15ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Current Offers) (51.58KB) (0.41%) | 2.10ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Get Support) (32.77KB) (0.28%) | 1.44ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Copyright) (35.27KB) (0.26%) | 1.35ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Payment logos) (5KB) (0.24%) | 1.23ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Information) (6KB) (0.23%) | 1.16ms |
| 1 x afterRenderRawModule mod_gantry5_particle (My Account) (6KB) (0.22%) | 1.12ms |
| 1 x afterRenderRawModule mod_virtuemart_category_search (VirtueMart Category Search Module) (12.81KB) (0.19%) | 962μs |
| 1 x After Access::preloadComponents (all components) (119.09KB) (0.18%) | 907μs |
| 1 x afterRenderModule mod_login (Login Form) (63.5KB) (0.17%) | 871μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Copyright) (7.43KB) (0.13%) | 684μs |
| 1 x beforeRenderRawModule mod_virtuemart_product (VM - Featured products) (6.32KB) (0.13%) | 679μs |
| 1 x beforeRenderRawModule mod_custom (Register to save more) (6.87KB) (0.13%) | 665μs |
| 1 x afterRenderRawModule mod_custom (Register to save more) (4.01KB) (0.12%) | 588μs |
| 1 x beforeRenderRawModule mod_virtuemart_category_search (VirtueMart Category Search Module) (4.04KB) (0.08%) | 419μs |
| 1 x beforeRenderRawModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (2.06KB) (0.08%) | 393μs |
| 1 x After Access::getAssetRules (id:1 name:root.1) (24.98KB) (0.07%) | 359μs |
| 1 x afterRenderModule mod_gantry5_particle (Navigation (Product categories) on other pages) (91.12KB) (0.07%) | 339μs |
| 1 x afterRenderRawModule mod_custom (Offer Banner on Sidebar) (1000B) (0.05%) | 264μs |
| 1 x beforeRenderModule mod_login (Login Form) (64.45KB) (0.05%) | 247μs |
| 1 x afterRenderModule mod_gantry5_particle (Information) (2.88KB) (0.05%) | 233μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (My Account) (120B) (0.05%) | 229μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Payment logos) (712B) (0.04%) | 229μs |
| 1 x afterRenderModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (5.95KB) (0.04%) | 224μs |
| 1 x beforeRenderComponent com_virtuemart (7.51KB) (0.04%) | 217μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Information) (1.01KB) (0.04%) | 216μs |
| 1 x afterRenderModule mod_gantry5_particle (Current Offers) (3KB) (0.04%) | 209μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Get Support) (904B) (0.04%) | 209μs |
| 1 x afterRenderModule mod_gantry5_particle (Copyright) (2.38KB) (0.04%) | 204μs |
| 1 x afterRenderModule mod_gantry5_particle (Get Support) (3.25KB) (0.04%) | 204μs |
| 1 x afterRenderModule mod_gantry5_particle (My Account) (2.88KB) (0.04%) | 203μs |
| 1 x afterRenderModule mod_gantry5_particle (Payment logos) (2.44KB) (0.04%) | 203μs |
| 1 x afterRenderModule mod_virtuemart_product (VM - Featured products) (25.94KB) (0.04%) | 200μs |
| 1 x afterRenderModule mod_custom (Offer Banner on Sidebar) (2.25KB) (0.03%) | 176μs |
| 1 x beforeRenderModule mod_custom (Register to save more) (376B) (0.03%) | 161μs |
| 1 x afterDispatch (2.25KB) (0.02%) | 125μs |
| 1 x afterRenderModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (1.27KB) (0.02%) | 101μs |
| 1 x afterRenderModule mod_virtuemart_category_search (VirtueMart Category Search Module) (1.26KB) (0.02%) | 87μs |
| 1 x afterRenderModule mod_custom (Register to save more) (1.26KB) (0.02%) | 85μs |
| 1 x afterRenderModule mod_login (Login Form) (2.52KB) (0.01%) | 74μs |
| 1 x afterRenderModule mod_custom (Register to save more) (1.27KB) (0.01%) | 71μs |
| 1 x beforeRenderRawModule mod_custom (Offer Banner on Sidebar) (2.59KB) (0.01%) | 65μs |
| 1 x beforeRenderRawModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (1.66KB) (0.01%) | 54μs |
| 1 x beforeRenderModule mod_login (Login Form) (720B) (0%) | 25μs |
| 1 x Before Access::getAssetRules (id:492 name:com_virtuemart) (456B) (0%) | 21μs |
| 1 x Before Access::getAssetRules (id:1 name:root.1) (3.55KB) (0%) | 19μs |
| 1 x After Access::getAssetRules (id:492 name:com_virtuemart) (1.61KB) (0%) | 9μs |
| 1 x beforeRenderModule mod_gantry5_particle (Navigation (Product categories) on other pages) (768B) (0%) | 9μs |
| 1 x beforeRenderModule mod_custom (Register to save more) (720B) (0%) | 8μs |
| 1 x beforeRenderModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (752B) (0%) | 8μs |
| 1 x beforeRenderModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (752B) (0%) | 8μs |
| 1 x beforeRenderModule mod_gantry5_particle (Current Offers) (736B) (0%) | 7μs |
| 1 x beforeRenderModule mod_virtuemart_category_search (VirtueMart Category Search Module) (752B) (0%) | 7μs |
| 1 x beforeRenderModule mod_custom (Offer Banner on Sidebar) (720B) (0%) | 7μs |
| 1 x beforeRenderModule mod_virtuemart_product (VM - Featured products) (736B) (0%) | 7μ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 (Copyright) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Get Support) (720B) (0%) | 5μs |
| 1 x beforeRenderModule mod_gantry5_particle (Payment logos) (720B) (0%) | 5μs |
SELECT @@SESSION.sql_mode;67μ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)432μs944BParams/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` = 1360μs4.73KB/libraries/src/Component/ComponentHelper.php:393CopySELECT `id`,`rules`
FROM `ly39srojgh48_viewlevels`112μ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` = :guest137μ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`980μs16.8KBParams/libraries/src/Plugin/PluginHelper.php:283CopySELECT * FROM ly39srojgh48_hikashop_config306μs44.94KB/administrator/components/com_hikashop/classes/config.php:16CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));49μ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.11ms223.05KBParams/libraries/src/Menu/SiteMenu.php:166CopySHOW TABLES LIKE "ly39srojgh48_virtuemart_configs"369μs872B/administrator/components/com_virtuemart/helpers/vmtable.php:792CopySELECT `config` FROM `ly39srojgh48_virtuemart_configs` WHERE `virtuemart_config_id` = "1";90μ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)513μs10.5KBParams/libraries/src/Access/Access.php:357CopySELECT *
FROM `ly39srojgh48_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC169μ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` = 1259μ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` DESC721μs4.53KB/components/com_virtuemart/router.php:1643CopySELECT l.virtuemart_manufacturer_id FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.slug = "pretium-fringilla"99μs3.35KB/components/com_virtuemart/router.php:1571CopySELECT l.virtuemart_category_id FROM `ly39srojgh48_virtuemart_categories_en_gb` as l WHERE l.slug = "mobiles"86μs872B/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.id235μs1.23KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM ly39srojgh48_virtuemart_categories
WHERE `virtuemart_category_id`= 8105μs944B/administrator/components/com_virtuemart/models/category.php:1078CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM ly39srojgh48_virtuemart_categories
WHERE `virtuemart_category_id`= 172μs944B/administrator/components/com_virtuemart/models/category.php:1078CopySELECT `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"172μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "1" ORDER BY `ordering`97μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT l.virtuemart_category_id, l.category_name, published 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 l.virtuemart_category_id = 194μs1KB/administrator/components/com_virtuemart/models/category.php:1024CopySELECT `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"182μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "8" ORDER BY `ordering`105μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT l.virtuemart_category_id, l.category_name, published 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 l.virtuemart_category_id = 191μs1KB/administrator/components/com_virtuemart/models/category.php:1024CopySELECT l.virtuemart_category_id, l.category_name, published 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 l.virtuemart_category_id = 885μs1KB/administrator/components/com_virtuemart/models/category.php:1024CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "2"86μs872B/components/com_virtuemart/router.php:1571CopySELECT c.* FROM ly39srojgh48_virtuemart_customs as c INNER JOIN ly39srojgh48_virtuemart_product_customfields as pc on (c.virtuemart_custom_id=pc.virtuemart_custom_id)
INNER JOIN ly39srojgh48_virtuemart_product_categories as cat ON (pc.virtuemart_product_id=cat.virtuemart_product_id) WHERE virtuemart_category_id="8" and searchable="1" and (field_type="S" or field_type="P") and c.published = 1 GROUP BY c.virtuemart_custom_id640μ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"204μ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"106μs3.94KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySHOW FULL COLUMNS FROM `ly39srojgh48_virtuemart_userfields`476μs21.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 ordering373μ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 ordering313μ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_categories` as pc ON p.`virtuemart_product_id` = `pc`.`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 ( `pc`.`virtuemart_category_id` IN (8) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 2 AND p.`product_special`="1" AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `mf_name` ASC, p.`virtuemart_product_id` ASC LIMIT 12278μ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_categories` as pc ON p.`virtuemart_product_id` = `pc`.`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 ( `pc`.`virtuemart_category_id` IN (8) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 2 AND p.`product_discontinued`="1" AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `mf_name` ASC, p.`virtuemart_product_id` ASC LIMIT 12251μ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_categories` as pc ON p.`virtuemart_product_id` = `pc`.`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 ( `pc`.`virtuemart_category_id` IN (8) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 2 AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY p.`created_on` DESC, p.`virtuemart_product_id` DESC LIMIT 4338μ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` = "40"239μ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`104μ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-07 10:18:38" )
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-07 10:18:38" ) ) ORDER BY `product_price` DESC217μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "40"86μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 40109μs2.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` = "2"200μ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"173μ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"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` = "5"154μ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"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` = "9"167μ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"149μ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"179μ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"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` = "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"152μ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"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` = "16"146μ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` = "2"129μ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` ASC220μ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"192μ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"130μ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-07 10:18:38" )
AND ( ISNULL(publish_down) OR ( ISNULL("publish_down") or publish_down="0000-00-00 00:00:00") OR publish_down >= "2025-04-07 10:18:38" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)201μs4.3KB/administrator/components/com_virtuemart/helpers/calculationh.php:176CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "40"119μ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"214μ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`122μs8.85KB/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-07 10:18:38" )
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-07 10:18:38" ) ) ORDER BY `product_price` DESC216μ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` = 39107μ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` ASC224μ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_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"231μ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`107μ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-07 10:18:38" )
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-07 10:18:38" ) ) 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"82μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 34133μ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` ASC217μ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"237μ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`92μ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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "33"108μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 33109μ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` ASC203μ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"95μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "26"125μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "19"135μ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_categories` as pc ON p.`virtuemart_product_id` = `pc`.`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 ( `pc`.`virtuemart_category_id` IN (8) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 2 AND pp.`product_price`>"0.001" AND p.`published`="1" AND ( p.`virtuemart_product_id` NOT IN (40,39,34,33) ) )
group by p.`virtuemart_product_id`
ORDER BY p.`product_sales` DESC, p.`virtuemart_product_id` DESC LIMIT 4361μ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` = "28"211μ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`94μ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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "28"87μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 28107μ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` ASC229μ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"115μ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"212μ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`117μ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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "27"87μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 27104μ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` ASC206μ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"95μ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` = "20"207μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "20" ORDER BY `ordering`95μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "20" 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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "20"87μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 20134μ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 (20) AND c.`published` = "1" ORDER BY field.`ordering` ASC221μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "20"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` = "17"236μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "17" ORDER BY `ordering`88μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "17" 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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "17"90μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 17110μ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 (17) AND c.`published` = "1" ORDER BY field.`ordering` ASC202μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "17"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "25"127μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT count(`p`.virtuemart_product_id) AS total
FROM `ly39srojgh48_virtuemart_product_categories` as `pc`
LEFT JOIN `ly39srojgh48_virtuemart_products` as `p` ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id
WHERE `pc`.`virtuemart_category_id` = "8"
AND `p`.`virtuemart_vendor_id` = "1"
AND `p`.`published` = "1"405μs872B/administrator/components/com_virtuemart/models/category.php:663CopySELECT l.virtuemart_category_id, l.category_name, published 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 l.virtuemart_category_id = 1122μs1KB/administrator/components/com_virtuemart/models/category.php:1024CopySELECT l.virtuemart_category_id, l.category_name, published 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 l.virtuemart_category_id = 886μs1KB/administrator/components/com_virtuemart/models/category.php:1024CopySELECT 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_categories` as pc ON p.`virtuemart_product_id` = `pc`.`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 ( `pc`.`virtuemart_category_id` IN (8) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 2 AND p.`published`="1" AND ( p.`virtuemart_product_id` NOT IN (40,39,34,33,28,27,20,17) ) )
group by p.`virtuemart_product_id`
ORDER BY `mf_name` ASC, p.`virtuemart_product_id` ASC LIMIT 24301μs968B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT FOUND_ROWS()37μ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` INNER JOIN `ly39srojgh48_virtuemart_product_categories` as pc ON pc.`virtuemart_product_id` = pm.`virtuemart_product_id` WHERE p.`published` = "1" AND pc.`virtuemart_category_id` = "8" ORDER BY `mf_name`309μ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"67μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "5"64μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "6"67μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "3"89μs872B/components/com_virtuemart/router.php:1571CopySELECT `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` = "3"236μs24.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "3" ORDER BY `ordering`96μs16.85KB/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "3" 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-07 10:18:38" )
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-07 10:18:38" ) ) ORDER BY `product_price` DESC198μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "3"114μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 3109μ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 (3) 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` = "3"101μ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` = "8"226μ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`92μ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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "8"85μ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` ASC203μ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"131μ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` = "9"208μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "9" ORDER BY `ordering`91μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "9" 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-07 10:18:38" )
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-07 10:18:38" ) ) ORDER BY `product_price` DESC199μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "9"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 9105μ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 (9) 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` = "9"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` = "14"206μ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`88μ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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "14"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 14107μ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` ASC204μ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"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "33"135μ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"185μs4.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`64μ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`1.01ms22.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 ASC769μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165CopySELECT * 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-07 10:18:38" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-07 10:18:38" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)230μ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-07 10:18:38" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-07 10:18:38" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)164μ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-07 10:18:38" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-07 10:18:38" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)157μs4.36KB/administrator/components/com_virtuemart/helpers/calculationh.php:1522CopySELECT `a`.`menutype`,`a`.`title`
FROM `ly39srojgh48_menu_types` AS `a`
WHERE `a`.`client_id` = 0135μ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.lft775μ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.lft823μ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 5478μ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` = "48"219μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "48" ORDER BY `ordering`97μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "48" 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-07 10:18:38" )
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-07 10:18:38" ) ) ORDER BY `product_price` DESC205μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "48"88μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 48109μ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"156μ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 (48) AND c.`published` = "1" ORDER BY field.`ordering` ASC232μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "48"95μ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` = "13"201μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "13" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "13" 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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "13"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 13105μ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"173μ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 (13) AND c.`published` = "1" ORDER BY field.`ordering` ASC224μs8.42KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "13"110μ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` = "4"217μ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`93μ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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "4"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 4107μ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` ASC217μ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"108μ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` = "1"210μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1" ORDER BY `ordering`89μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1" 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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "1"93μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1105μ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 (1) AND c.`published` = "1" ORDER BY field.`ordering` ASC231μs8.42KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "1"105μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "36"126μ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` = "21"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` = "10"224μ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`98μ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-07 10:18:38" )
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-07 10:18:38" ) ) ORDER BY `product_price` DESC199μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "10"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 10109μ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 (10) AND c.`published` = "1" ORDER BY field.`ordering` ASC203μ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"104μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "35"122μ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 p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY RAND() LIMIT 8499μ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` = "26"254μ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`95μ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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "26"114μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 26127μ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 (26) AND c.`published` = "1" ORDER BY field.`ordering` ASC235μ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"105μ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` = "12"206μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "12" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "12" 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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "12"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 12104μ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 (12) AND c.`published` = "1" ORDER BY field.`ordering` ASC233μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "12"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` = "29"208μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "29" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "29" 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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "29"87μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 29106μ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 (29) 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` = "29"98μ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` = "24"207μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "24" ORDER BY `ordering`93μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "24" 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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "24"89μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 24111μ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 (24) AND c.`published` = "1" ORDER BY field.`ordering` ASC202μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "24"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` = "6"213μ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`93μ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-07 10:18:38" )
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-07 10:18:38" ) ) 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` = "6"86μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 6106μ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"111μ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` = "23"210μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "23" ORDER BY `ordering`89μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "23" 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-07 10:18:38" )
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-07 10:18:38" ) ) ORDER BY `product_price` DESC209μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "23"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 23106μ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 (23) AND c.`published` = "1" ORDER BY field.`ordering` ASC202μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "23"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` = "29"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` = "38"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` = "23"118μ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` asc242μ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` asc193μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy