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
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 (10.04MB) (24.4%) | 128.36ms |
| 1 x afterInitialise (8.34MB) (14.02%) | 73.77ms |
| 1 x afterRender (1.5MB) (11.05%) | 58.13ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Navigation (Product categories) on other pages) (2.98MB) (7.6%) | 39.97ms |
| 1 x beforeRenderRawModule mod_login (Login Form) (4.63MB) (7.53%) | 39.60ms |
| 1 x afterLoad (3.73MB) (5.62%) | 29.59ms |
| 1 x afterRoute (2.79MB) (5.52%) | 29.06ms |
| 1 x afterRenderRawModule mod_virtuemart_product (VM - Featured products) (2.7MB) (5.41%) | 28.48ms |
| 1 x afterRenderRawModule mod_virtuemart_category_search (VirtueMart Category Search Module) (747.7KB) (3.04%) | 16.00ms |
| 1 x Before Access::preloadComponents (all components) (1.79MB) (2.88%) | 15.18ms |
| 1 x afterRenderRawModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (1.27MB) (2.54%) | 13.36ms |
| 1 x afterRenderRawModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (1.25MB) (2.5%) | 13.16ms |
| 1 x afterRenderRawModule mod_login (Login Form) (197.62KB) (0.93%) | 4.87ms |
| 1 x beforeRenderRawModule mod_gantry5_particle (Current Offers) (13.77KB) (0.62%) | 3.27ms |
| 1 x beforeRenderRawModule mod_gantry5_particle (Navigation (Product categories) on other pages) (4KB) (0.59%) | 3.09ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Current Offers) (51.58KB) (0.39%) | 2.06ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Get Support) (32.77KB) (0.28%) | 1.45ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Copyright) (35.27KB) (0.27%) | 1.41ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Payment logos) (5KB) (0.24%) | 1.25ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Information) (6KB) (0.22%) | 1.14ms |
| 1 x afterRenderRawModule mod_gantry5_particle (My Account) (6KB) (0.21%) | 1.13ms |
| 1 x After Access::preloadComponents (all components) (119.09KB) (0.18%) | 928μs |
| 1 x afterRenderModule mod_login (Login Form) (63.5KB) (0.16%) | 829μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Copyright) (7.43KB) (0.13%) | 683μs |
| 1 x beforeRenderRawModule mod_virtuemart_product (VM - Featured products) (6.32KB) (0.12%) | 656μs |
| 1 x beforeRenderRawModule mod_custom (Register to save more) (6.87KB) (0.12%) | 614μs |
| 1 x afterRenderRawModule mod_custom (Register to save more) (4.01KB) (0.09%) | 464μs |
| 1 x beforeRenderRawModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (2.06KB) (0.09%) | 464μs |
| 1 x After Access::getAssetRules (id:1 name:root.1) (24.98KB) (0.07%) | 376μs |
| 1 x beforeRenderRawModule mod_virtuemart_category_search (VirtueMart Category Search Module) (4.04KB) (0.07%) | 357μs |
| 1 x afterRenderModule mod_gantry5_particle (Navigation (Product categories) on other pages) (91.12KB) (0.06%) | 324μs |
| 1 x afterRenderRawModule mod_custom (Offer Banner on Sidebar) (1000B) (0.05%) | 261μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Information) (1.01KB) (0.04%) | 222μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (My Account) (120B) (0.04%) | 222μs |
| 1 x afterRenderModule mod_virtuemart_product (VM - Featured products) (29.94KB) (0.04%) | 221μs |
| 1 x afterRenderModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (5.95KB) (0.04%) | 218μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Get Support) (904B) (0.04%) | 214μs |
| 1 x afterRenderModule mod_gantry5_particle (Current Offers) (3KB) (0.04%) | 214μs |
| 1 x afterRenderModule mod_gantry5_particle (Payment logos) (2.44KB) (0.04%) | 211μs |
| 1 x afterRenderModule mod_gantry5_particle (Information) (2.88KB) (0.04%) | 210μs |
| 1 x afterRenderModule mod_gantry5_particle (Get Support) (3.25KB) (0.04%) | 210μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Payment logos) (712B) (0.04%) | 210μs |
| 1 x afterRenderModule mod_gantry5_particle (My Account) (2.88KB) (0.04%) | 210μs |
| 1 x afterRenderModule mod_gantry5_particle (Copyright) (2.38KB) (0.04%) | 209μs |
| 1 x beforeRenderModule mod_login (Login Form) (64.45KB) (0.04%) | 201μs |
| 1 x afterRenderModule mod_custom (Offer Banner on Sidebar) (2.25KB) (0.03%) | 178μs |
| 1 x beforeRenderComponent com_virtuemart (7.51KB) (0.03%) | 153μs |
| 1 x afterRenderModule mod_virtuemart_category_search (VirtueMart Category Search Module) (1.26KB) (0.03%) | 146μs |
| 1 x beforeRenderModule mod_custom (Register to save more) (376B) (0.02%) | 129μs |
| 1 x afterDispatch (2.25KB) (0.02%) | 119μs |
| 1 x afterRenderModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (1.27KB) (0.02%) | 110μs |
| 1 x afterRenderModule mod_custom (Register to save more) (1.26KB) (0.02%) | 82μs |
| 1 x afterRenderModule mod_login (Login Form) (2.52KB) (0.01%) | 73μs |
| 1 x afterRenderModule mod_custom (Register to save more) (1.27KB) (0.01%) | 65μs |
| 1 x beforeRenderRawModule mod_custom (Offer Banner on Sidebar) (2.59KB) (0.01%) | 62μs |
| 1 x beforeRenderRawModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (1.66KB) (0.01%) | 53μs |
| 1 x Before Access::getAssetRules (id:492 name:com_virtuemart) (456B) (0%) | 22μs |
| 1 x Before Access::getAssetRules (id:1 name:root.1) (3.55KB) (0%) | 21μs |
| 1 x beforeRenderModule mod_virtuemart_category_search (VirtueMart Category Search Module) (752B) (0%) | 9μs |
| 1 x beforeRenderModule mod_virtuemart_product (VM - Featured products) (736B) (0%) | 9μs |
| 1 x After Access::getAssetRules (id:492 name:com_virtuemart) (1.61KB) (0%) | 9μs |
| 1 x beforeRenderModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (752B) (0%) | 8μs |
| 1 x beforeRenderModule mod_gantry5_particle (Navigation (Product categories) on other pages) (768B) (0%) | 8μs |
| 1 x beforeRenderModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (752B) (0%) | 7μs |
| 1 x beforeRenderModule mod_gantry5_particle (Current Offers) (736B) (0%) | 7μs |
| 1 x beforeRenderModule mod_gantry5_particle (Copyright) (720B) (0%) | 7μs |
| 1 x beforeRenderModule mod_login (Login Form) (720B) (0%) | 7μs |
| 1 x beforeRenderModule mod_gantry5_particle (My Account) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Payment logos) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_custom (Register to save more) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_custom (Offer Banner on Sidebar) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Information) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Get Support) (720B) (0%) | 6μs |
SELECT @@SESSION.sql_mode;64μs1.59KB/libraries/src/Session/MetadataManager.php:184CopySELECT `session_id`
FROM `ly39srojgh48_session`
WHERE `session_id` = :session_id LIMIT 1132μ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)334μ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` = 1290μs4.73KB/libraries/src/Component/ComponentHelper.php:393CopySELECT `id`,`rules`
FROM `ly39srojgh48_viewlevels`87μ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` = :guest138μs1.67KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `ly39srojgh48_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`1.07ms16.8KBParams/libraries/src/Plugin/PluginHelper.php:283CopySELECT * FROM ly39srojgh48_hikashop_config280μ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.03ms223.05KBParams/libraries/src/Menu/SiteMenu.php:166CopySHOW TABLES LIKE "ly39srojgh48_virtuemart_configs"365μs872B/administrator/components/com_virtuemart/helpers/vmtable.php:792CopySELECT `config` FROM `ly39srojgh48_virtuemart_configs` WHERE `virtuemart_config_id` = "1";89μ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)545μs10.5KBParams/libraries/src/Access/Access.php:357CopySELECT *
FROM `ly39srojgh48_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC142μ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` = 1237μs1.69KB/administrator/components/com_templates/src/Model/StyleModel.php:771CopySELECT * FROM `ly39srojgh48_menu` WHERE `link` like "index.php?option=com_virtuemart%" and (language="*" or language = "en-GB" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC646μs4.53KB/components/com_virtuemart/router.php:1643CopySELECT l.virtuemart_manufacturer_id FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.slug = "massa-aliquet"93μs3.35KB/components/com_virtuemart/router.php:1571CopySELECT l.virtuemart_category_id FROM `ly39srojgh48_virtuemart_categories_en_gb` as l WHERE l.slug = "security-cameras"71μ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.id215μ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`= 13107μ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"179μ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`101μ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 `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"154μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "13" ORDER BY `ordering`87μ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 = 189μ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 = 1382μs1KB/administrator/components/com_virtuemart/models/category.php:1024CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "1"65μ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="13" and searchable="1" and (field_type="S" or field_type="P") and c.published = 1 GROUP BY c.virtuemart_custom_id642μ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"168μ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"126μs3.94KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySHOW FULL COLUMNS FROM `ly39srojgh48_virtuemart_userfields`520μ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 ordering412μ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 ordering310μs12.64KB/administrator/components/com_virtuemart/helpers/vmmodel.php:504CopySELECT p.`virtuemart_product_id`, l.product_name
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_products_en_gb` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
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_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( `pc`.`virtuemart_category_id` IN (13) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 1 AND p.`product_special`="1" AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `pc`.`ordering` DESC, `product_name` DESC LIMIT 12262μs896B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT p.`virtuemart_product_id`, l.product_name
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_products_en_gb` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
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_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( `pc`.`virtuemart_category_id` IN (13) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 1 AND p.`product_discontinued`="1" AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `pc`.`ordering` DESC, `product_name` DESC LIMIT 12252μs896B/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT p.`virtuemart_product_id`, l.product_name
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_products_en_gb` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
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_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( `pc`.`virtuemart_category_id` IN (13) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 1 AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY p.`created_on` DESC, p.`virtuemart_product_id` DESC LIMIT 4450μs1.06KB/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` = "46"215μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "46" ORDER BY `ordering`104μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "46" 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-14 17:02: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-14 17:02:38" ) ) ORDER BY `product_price` DESC215μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "46"86μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 46111μ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"175μ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"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` = "4"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` = "5"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` = "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` = "8"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` = "9"146μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "10"157μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "11"147μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "12"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"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` = "15"145μ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"145μ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` = "1"128μs4.19KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (46) AND c.`published` = "1" ORDER BY field.`ordering` ASC214μ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"191μ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"128μ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-14 17:02:38" )
AND ( ISNULL(publish_down) OR ( ISNULL("publish_down") or publish_down="0000-00-00 00:00:00") OR publish_down >= "2025-04-14 17:02:38" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)176μs4.3KB/administrator/components/com_virtuemart/helpers/calculationh.php:176CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "46"102μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "45"218μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "45" ORDER BY `ordering`93μs8.85KB/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "45" 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-14 17:02: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-14 17:02: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` = "45"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 45108μ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 (45) AND c.`published` = "1" ORDER BY field.`ordering` ASC199μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "45"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` = "38"207μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "38" ORDER BY `ordering`88μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "38" 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-14 17:02: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-14 17:02:38" ) ) ORDER BY `product_price` DESC192μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "38"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 38104μ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 (38) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "38"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` = "37"205μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "37" ORDER BY `ordering`88μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "37" 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-14 17:02: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-14 17:02: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` = "37"82μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 37107μ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 (37) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "37"102μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "21"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` = "24"135μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT p.`virtuemart_product_id`, l.product_name
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_products_en_gb` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
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_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( `pc`.`virtuemart_category_id` IN (13) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 1 AND pp.`product_price`>"0.001" AND p.`published`="1" AND ( p.`virtuemart_product_id` NOT IN (46,45,38,37) ) )
group by p.`virtuemart_product_id`
ORDER BY p.`product_sales` DESC, p.`virtuemart_product_id` DESC LIMIT 4432μs1.06KB/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` = "32"209μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "32" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "32" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 17:02: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-14 17:02: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` = "32"86μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 32106μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (32) AND c.`published` = "1" ORDER BY field.`ordering` 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` = "32"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` = "31"222μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "31" ORDER BY `ordering`89μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "31" 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-14 17:02: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-14 17:02: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` = "31"90μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 31106μ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 (31) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "31"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` = "26"220μ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`88μ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-14 17:02: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-14 17:02: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` = "26"92μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 26107μ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` ASC238μ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"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` = "25"209μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "25" ORDER BY `ordering`87μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "25" 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-14 17:02: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-14 17:02:38" ) ) ORDER BY `product_price` DESC192μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "25"90μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 25104μ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 (25) AND c.`published` = "1" ORDER BY field.`ordering` ASC234μs8.42KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "25"105μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "22"123μ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"117μ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` = "13"
AND `p`.`virtuemart_vendor_id` = "1"
AND `p`.`published` = "1"375μ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 = 1100μ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 = 1384μs1KB/administrator/components/com_virtuemart/models/category.php:1024CopySELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`, l.product_name
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_products_en_gb` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
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`
WHERE ( `pc`.`virtuemart_category_id` IN (13) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND `ly39srojgh48_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 1 AND p.`published`="1" AND ( p.`virtuemart_product_id` NOT IN (46,45,38,37,32,31,26,25) ) )
group by p.`virtuemart_product_id`
ORDER BY `pc`.`ordering` DESC, `product_name` DESC LIMIT 24399μs1.25KB/administrator/components/com_virtuemart/helpers/vmmodel.php:867CopySELECT FOUND_ROWS()39μ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` = "13" ORDER BY `mf_name`267μ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 = "5"66μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "2"62μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "6"60μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "3"62μs872B/components/com_virtuemart/router.php:1571CopySELECT `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"213μs24.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`92μ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-14 17:02: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-14 17:02: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"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 13106μ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 (13) AND c.`published` = "1" ORDER BY field.`ordering` ASC232μ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"100μ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` = "1"210μs24.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`88μ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-14 17:02: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-14 17:02: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` = "1"81μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1103μ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"104μ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` = "5"206μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "5" ORDER BY `ordering`88μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "5" 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-14 17:02: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-14 17:02: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` = "5"81μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 5106μ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 (5) AND c.`published` = "1" ORDER BY field.`ordering` ASC213μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "5"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` = "16"208μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "16" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "16" 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-14 17:02: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-14 17:02: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` = "16"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 16113μ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 (16) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "16"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` = "19"217μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "19" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "19" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 17:02: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-14 17:02:38" ) ) ORDER BY `product_price` DESC192μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "19"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 19117μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (19) AND c.`published` = "1" ORDER BY field.`ordering` 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` = "19"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` = "7"216μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "7" ORDER BY `ordering`93μs968B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "7" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 17:02: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-14 17:02: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` = "7"81μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 7106μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (7) AND c.`published` = "1" ORDER BY field.`ordering` 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` = "7"105μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "4"215μ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`89μ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-14 17:02: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-14 17:02: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` = "4"87μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 4105μ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` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "4"107μ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` = "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`90μ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-14 17:02: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-14 17:02: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` = "23"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 23107μ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` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "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` = "13"135μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 13) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC549μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT `ly39srojgh48_virtuemart_vendors`.* ,`ly39srojgh48_virtuemart_vendors_en_gb`.* FROM `ly39srojgh48_virtuemart_vendors` INNER JOIN `ly39srojgh48_virtuemart_vendors_en_gb` ON `ly39srojgh48_virtuemart_vendors`.`virtuemart_vendor_id` = `ly39srojgh48_virtuemart_vendors_en_gb`.`virtuemart_vendor_id` WHERE `ly39srojgh48_virtuemart_vendors`.`virtuemart_vendor_id` = "1"186μ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`62μ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`999μs22.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 ASC784μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 0) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC679μs7.14KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "7" ORDER BY `ordering`102μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "2" ORDER BY `ordering`82μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "3" ORDER BY `ordering`80μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "6" ORDER BY `ordering`76μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "5" ORDER BY `ordering`74μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "4" ORDER BY `ordering`74μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 7) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC500μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 2) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC483μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 3) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC492μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 15) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC487μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 11) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC473μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 12) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC485μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 10) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC520μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 14) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC461μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 8) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC441μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 16) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC457μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 9) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC489μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 6) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC535μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 5) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC465μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT c.category_parent_id, c.`ordering`, c.virtuemart_category_id, c.virtuemart_vendor_id, c.category_template, c.category_layout, c.category_product_layout, c.products_per_row, c.limit_list_step, c.limit_list_initial, c.hits, c.cat_params, c.metarobot, c.metaauthor, c.shared, c.`published`, c.has_children, c.has_medias, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug FROM ly39srojgh48_virtuemart_categories as c LEFT JOIN `ly39srojgh48_virtuemart_categories_en_gb` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 4) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC525μs4.02KB/administrator/components/com_virtuemart/models/category.php:402CopySELECT * FROM ly39srojgh48_virtuemart_calcs LEFT JOIN ly39srojgh48_virtuemart_calc_shoppergroups using(virtuemart_calc_id)WHERE
`calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-04-14 17:02:38" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-14 17:02:38" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)192μ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-14 17:02:38" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-14 17:02:38" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)173μ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-14 17:02:38" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-14 17:02:38" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)159μs4.36KB/administrator/components/com_virtuemart/helpers/calculationh.php:1522CopySELECT `a`.`menutype`,`a`.`title`
FROM `ly39srojgh48_menu_types` AS `a`
WHERE `a`.`client_id` = 0175μ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.lft806μ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.lft794μs15.05KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791CopySELECT p.`virtuemart_product_id`, l.product_name
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_products_en_gb` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_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 5481μs1.11KB/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` = "6"218μ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`94μ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-14 17:02: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-14 17:02:38" ) ) ORDER BY `product_price` DESC230μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "6"104μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 6108μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT `ly39srojgh48_virtuemart_manufacturers`.* ,`ly39srojgh48_virtuemart_manufacturers_en_gb`.* FROM `ly39srojgh48_virtuemart_manufacturers` INNER JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` ON `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id` WHERE `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "3"148μs4.19KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (6) AND c.`published` = "1" ORDER BY field.`ordering` ASC196μ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"103μ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` = "2"223μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "2" ORDER BY `ordering`92μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "2" 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-14 17:02: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-14 17:02: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` = "2"82μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 2121μ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 (2) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "2"104μ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` = "18"211μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "18" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "18" 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-14 17:02: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-14 17:02: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` = "18"100μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 18107μ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 (18) AND c.`published` = "1" ORDER BY field.`ordering` ASC199μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "18"96μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "23"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` = "18"116μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT p.`virtuemart_product_id`, l.product_name
FROM `ly39srojgh48_virtuemart_products` as p
LEFT JOIN `ly39srojgh48_virtuemart_products_en_gb` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
LEFT JOIN `ly39srojgh48_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_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 8479μs1.25KB/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` = "39"217μ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`94μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "39" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-14 17:02: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-14 17:02: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"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 39111μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT `ly39srojgh48_virtuemart_manufacturers`.* ,`ly39srojgh48_virtuemart_manufacturers_en_gb`.* FROM `ly39srojgh48_virtuemart_manufacturers` INNER JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` ON `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id` WHERE `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "2"147μ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 (39) 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` = "39"103μ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` = "36"205μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "36" ORDER BY `ordering`88μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "36" 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-14 17:02: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-14 17:02:38" ) ) ORDER BY `product_price` DESC200μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "36"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 36107μ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 (36) AND c.`published` = "1" ORDER BY field.`ordering` ASC220μs39.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "36"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` = "40"213μ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`93μ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-14 17:02: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-14 17:02: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` = "40"82μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 40107μ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 (40) 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` = "40"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`135μ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-14 17:02: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-14 17:02:38" ) ) ORDER BY `product_price` DESC192μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "29"87μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 29114μ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` 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` = "29"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` = "15"224μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "15" ORDER BY `ordering`94μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "15" 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-14 17:02: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-14 17:02: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` = "15"91μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 15107μ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 (15) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "15"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` = "47"208μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "47" ORDER BY `ordering`90μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "47" 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-14 17:02: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-14 17:02: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` = "47"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 47105μ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 (47) 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` = "47"96μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "26"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` = "29"118μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "37"114μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "30"112μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "31"114μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "32"114μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor`
FROM `ly39srojgh48_scheduler_tasks` AS `a`
LEFT JOIN `ly39srojgh48_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now
ORDER BY `a`.`title` asc282μ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` asc227μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy