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 auctor ex vel varius tristique. Quisque vitae efficitur dolor. Fusce nec dui efficitur, feugiat diam a, sodales mauris. Nunc elit est, euismod consectetur mollis vitae, egestas at ligula. Praesent ultrices orci vel porta laoreet. Vivamus sit amet risus in purus pulvinar consectetur.
Nulla vitae faucibus neque, non blandit elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla cursus risus et vestibulum mattis. Praesent consectetur rutrum arcu eu vulputate. Vestibulum id facilisis tortor. Etiam urna erat, mollis sit amet vehicula non, accumsan sed nibh. Nunc condimentum nisl eu semper hendrerit.
Register an account today and get great deals, offers and customised products only for you.
| Joomla! Version | 4.2.6 |
| PHP Version | 7.4.33 |
| Identity | guest |
| Response | 200 |
| Template | r_onsale |
| Database |
|
| 1 x afterRenderComponent com_virtuemart (8.22MB) (17.81%) | 82.56ms |
| 1 x afterInitialise (8.34MB) (15.82%) | 73.31ms |
| 1 x afterRender (1.3MB) (10.77%) | 49.91ms |
| 1 x beforeRenderRawModule mod_login (Login Form) (4.57MB) (8.31%) | 38.54ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Navigation (Product categories) on other pages) (2.97MB) (8.19%) | 37.94ms |
| 1 x afterRenderRawModule mod_virtuemart_product (VM - Featured products) (2.95MB) (6.81%) | 31.56ms |
| 1 x afterRenderRawModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (3.24MB) (6.73%) | 31.18ms |
| 1 x afterRoute (2.81MB) (6.46%) | 29.96ms |
| 1 x afterLoad (3.73MB) (6.18%) | 28.65ms |
| 1 x Before Access::preloadComponents (all components) (1.79MB) (3.38%) | 15.69ms |
| 1 x afterRenderRawModule mod_login (Login Form) (264.94KB) (1.04%) | 4.81ms |
| 1 x beforeRenderRawModule mod_gantry5_particle (Current Offers) (17.77KB) (0.73%) | 3.37ms |
| 1 x beforeRenderRawModule mod_gantry5_particle (Navigation (Product categories) on other pages) (4KB) (0.67%) | 3.13ms |
| 1 x afterRenderRawModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (144.65KB) (0.51%) | 2.36ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Current Offers) (51.58KB) (0.48%) | 2.21ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Get Support) (32.77KB) (0.31%) | 1.43ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Copyright) (99.27KB) (0.29%) | 1.36ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Payment logos) (5KB) (0.27%) | 1.24ms |
| 1 x afterRenderRawModule mod_gantry5_particle (Information) (6KB) (0.25%) | 1.15ms |
| 1 x afterRenderRawModule mod_gantry5_particle (My Account) (6KB) (0.23%) | 1.09ms |
| 1 x afterRenderRawModule mod_virtuemart_category_search (VirtueMart Category Search Module) (12.24KB) (0.21%) | 968μs |
| 1 x After Access::preloadComponents (all components) (119.09KB) (0.19%) | 903μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Copyright) (7.43KB) (0.15%) | 696μs |
| 1 x beforeRenderRawModule mod_custom (Register to save more) (6.87KB) (0.14%) | 642μs |
| 1 x beforeRenderRawModule mod_virtuemart_product (VM - Featured products) (6.32KB) (0.14%) | 632μs |
| 1 x afterRenderRawModule mod_custom (Register to save more) (4.01KB) (0.12%) | 558μs |
| 1 x beforeRenderRawModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (2.06KB) (0.09%) | 400μs |
| 1 x After Access::getAssetRules (id:1 name:root.1) (24.98KB) (0.08%) | 360μs |
| 1 x beforeRenderRawModule mod_virtuemart_category_search (VirtueMart Category Search Module) (4.04KB) (0.08%) | 360μs |
| 1 x afterRenderRawModule mod_custom (Offer Banner on Sidebar) (1000B) (0.06%) | 261μs |
| 1 x afterRenderModule mod_gantry5_particle (Navigation (Product categories) on other pages) (90.75KB) (0.06%) | 256μs |
| 1 x afterRenderModule mod_gantry5_particle (Current Offers) (3KB) (0.05%) | 228μs |
| 1 x afterRenderModule mod_gantry5_particle (Payment logos) (2.44KB) (0.05%) | 225μs |
| 1 x beforeRenderModule mod_login (Login Form) (456B) (0.05%) | 224μs |
| 1 x afterRenderModule mod_gantry5_particle (Get Support) (3.25KB) (0.05%) | 224μs |
| 1 x afterRenderModule mod_gantry5_particle (Information) (2.88KB) (0.05%) | 222μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Information) (1.01KB) (0.05%) | 220μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Get Support) (904B) (0.05%) | 213μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (My Account) (120B) (0.05%) | 212μs |
| 1 x beforeRenderRawModule mod_gantry5_particle (Payment logos) (712B) (0.04%) | 205μs |
| 1 x afterRenderModule mod_virtuemart_product (VM - Featured products) (25.94KB) (0.04%) | 204μs |
| 1 x afterRenderModule mod_gantry5_particle (My Account) (2.88KB) (0.04%) | 204μs |
| 1 x afterRenderModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (5.95KB) (0.04%) | 203μs |
| 1 x afterRenderModule mod_gantry5_particle (Copyright) (2.38KB) (0.04%) | 203μs |
| 1 x afterRenderModule mod_custom (Offer Banner on Sidebar) (2.25KB) (0.04%) | 178μs |
| 1 x beforeRenderComponent com_virtuemart (7.51KB) (0.04%) | 169μs |
| 1 x afterDispatch (2.25KB) (0.03%) | 148μs |
| 1 x beforeRenderModule mod_custom (Register to save more) (376B) (0.03%) | 131μs |
| 1 x afterRenderModule mod_login (Login Form) (1.26KB) (0.02%) | 108μs |
| 1 x afterRenderModule mod_virtuemart_category_search (VirtueMart Category Search Module) (1.26KB) (0.02%) | 95μs |
| 1 x afterRenderModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (1.27KB) (0.02%) | 87μs |
| 1 x afterRenderModule mod_custom (Register to save more) (1.26KB) (0.02%) | 83μs |
| 1 x afterRenderModule mod_login (Login Form) (2.52KB) (0.02%) | 76μs |
| 1 x afterRenderModule mod_custom (Register to save more) (1.27KB) (0.01%) | 66μs |
| 1 x beforeRenderRawModule mod_custom (Offer Banner on Sidebar) (2.59KB) (0.01%) | 58μs |
| 1 x beforeRenderRawModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (1.66KB) (0.01%) | 47μs |
| 1 x Before Access::getAssetRules (id:492 name:com_virtuemart) (456B) (0%) | 21μs |
| 1 x Before Access::getAssetRules (id:1 name:root.1) (3.55KB) (0%) | 20μs |
| 1 x After Access::getAssetRules (id:492 name:com_virtuemart) (1.61KB) (0%) | 9μs |
| 1 x beforeRenderModule mod_login (Login Form) (720B) (0%) | 8μs |
| 1 x beforeRenderModule mod_gantry5_particle (Navigation (Product categories) on other pages) (768B) (0%) | 8μs |
| 1 x beforeRenderModule mod_virtuemart_product (VM - Featured products) (736B) (0%) | 8μs |
| 1 x beforeRenderModule mod_custom (Register to save more) (720B) (0%) | 7μs |
| 1 x beforeRenderModule mod_virtuemart_category_search (VirtueMart Category Search Module) (752B) (0%) | 7μs |
| 1 x beforeRenderModule mod_virtuemart_minicart (VM Mini Shopping Cart Module) (752B) (0%) | 7μs |
| 1 x beforeRenderModule mod_rca_virtuemart_products_listingmini (FEATURED PRODUCTS) (752B) (0%) | 7μs |
| 1 x beforeRenderModule mod_gantry5_particle (Information) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Get Support) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_custom (Offer Banner on Sidebar) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Current Offers) (736B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (My Account) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Copyright) (720B) (0%) | 6μs |
| 1 x beforeRenderModule mod_gantry5_particle (Payment logos) (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 1151μ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)345μ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` = 11.94ms4.73KB/libraries/src/Component/ComponentHelper.php:393CopySELECT `id`,`rules`
FROM `ly39srojgh48_viewlevels`98μ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` = :guest152μs1.67KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `ly39srojgh48_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`980μs16.8KBParams/libraries/src/Plugin/PluginHelper.php:283CopySELECT * FROM ly39srojgh48_hikashop_config256μs44.94KB/administrator/components/com_hikashop/classes/config.php:16CopySET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));48μ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`1ms223.05KBParams/libraries/src/Menu/SiteMenu.php:166CopySHOW TABLES LIKE "ly39srojgh48_virtuemart_configs"357μs872B/administrator/components/com_virtuemart/helpers/vmtable.php:792CopySELECT `config` FROM `ly39srojgh48_virtuemart_configs` WHERE `virtuemart_config_id` = "1";84μs872B/administrator/components/com_virtuemart/helpers/config.php:452CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `ly39srojgh48_assets`
WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43)513μs10.5KBParams/libraries/src/Access/Access.php:357CopySELECT *
FROM `ly39srojgh48_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC152μ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` = 1254μ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` DESC729μs4.53KB/components/com_virtuemart/router.php:1643CopySELECT l.virtuemart_product_id FROM `ly39srojgh48_virtuemart_products_en_gb` as l WHERE l.slug = "musical-drum-set-vspro-7-19"102μs3.35KB/components/com_virtuemart/router.php:1571CopySELECT l.virtuemart_category_id FROM `ly39srojgh48_virtuemart_categories_en_gb` as l WHERE l.slug = "tablets"100μ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.id251μs1.23KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69CopySELECT * FROM `ly39srojgh48_virtuemart_shoppergroups` WHERE `default` = "2" AND (`virtuemart_vendor_id` = "1" OR `shared` = "1") AND `published`="1"222μs3.94KB/administrator/components/com_virtuemart/models/shoppergroup.php:101CopySELECT `ly39srojgh48_virtuemart_shoppergroups`.* FROM `ly39srojgh48_virtuemart_shoppergroups` WHERE `ly39srojgh48_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"106μs3.94KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySHOW FULL COLUMNS FROM `ly39srojgh48_virtuemart_userfields`561μs10.39KB/administrator/components/com_virtuemart/helpers/vmtable.php:753CopySELECT * FROM `ly39srojgh48_virtuemart_userfields` WHERE 1 = 1 AND `account`="1" AND published = 1 AND FIND_IN_SET(name, 'address_type') = 0 ORDER BY ordering406μ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 ordering326μs12.64KB/administrator/components/com_virtuemart/helpers/vmmodel.php:504CopySELECT `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"248μ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`101μ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-08 12:09:23" )
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-08 12:09:23" ) ) ORDER BY `product_price` DESC212μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "38"86μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 38110μ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` = "1"167μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "2"154μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "3"153μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "4"149μs15.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"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` = "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"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` = "8"151μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "9"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` = "10"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` = "11"153μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "12"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` = "13"147μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_categories`.* ,`ly39srojgh48_virtuemart_categories_en_gb`.* FROM `ly39srojgh48_virtuemart_categories` INNER JOIN `ly39srojgh48_virtuemart_categories_en_gb` ON `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = `ly39srojgh48_virtuemart_categories_en_gb`.`virtuemart_category_id` WHERE `ly39srojgh48_virtuemart_categories`.`virtuemart_category_id` = "14"158μ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"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` = "16"148μs4.88KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_manufacturers`.* ,`ly39srojgh48_virtuemart_manufacturers_en_gb`.* FROM `ly39srojgh48_virtuemart_manufacturers` INNER JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` ON `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id` WHERE `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"131μ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 (38) AND c.`published` = "1" ORDER BY field.`ordering` ASC211μ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"195μ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"144μ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-08 12:09:23" )
AND ( ISNULL(publish_down) OR ( ISNULL("publish_down") or publish_down="0000-00-00 00:00:00") OR publish_down >= "2025-04-08 12:09:23" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)181μs4.3KB/administrator/components/com_virtuemart/helpers/calculationh.php:176CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "38"101μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "24"145μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT p.`virtuemart_product_id`, `pc`.ordering, `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`
WHERE ( `pc`.`virtuemart_category_id` IN (9) AND
( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND
p.`published`="1" ) AND p.`virtuemart_product_id`!="38"
AND `pc`.ordering <= "0"
ORDER BY `pc`.ordering, `l`.product_name ASC LIMIT 1594μs1KB/administrator/components/com_virtuemart/models/product.php:2494CopySELECT p.`virtuemart_product_id`, `pc`.ordering, `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`
WHERE ( `pc`.`virtuemart_category_id` IN (9) AND
( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND
p.`published`="1" ) AND p.`virtuemart_product_id`!="38"
AND p.`virtuemart_product_id`!="10" AND `pc`.ordering <= "0"
ORDER BY `pc`.ordering, `l`.product_name DESC LIMIT 1598μs1KB/administrator/components/com_virtuemart/models/product.php:2494CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_manufacturer_medias` WHERE `virtuemart_manufacturer_id` = "1" ORDER BY `ordering`68μs840B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `ly39srojgh48_virtuemart_manufacturers`.* ,`ly39srojgh48_virtuemart_manufacturers_en_gb`.* FROM `ly39srojgh48_virtuemart_manufacturers` INNER JOIN `ly39srojgh48_virtuemart_manufacturers_en_gb` ON `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ly39srojgh48_virtuemart_manufacturers_en_gb`.`virtuemart_manufacturer_id` WHERE `ly39srojgh48_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "4"167μs4.19KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_manufacturer_medias` WHERE `virtuemart_manufacturer_id` = "4" ORDER BY `ordering`52μs840B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_category_medias` WHERE `virtuemart_category_id` = "9" ORDER BY `ordering`113μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM ly39srojgh48_virtuemart_categories
WHERE `virtuemart_category_id`= 982μ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`= 168μs944B/administrator/components/com_virtuemart/models/category.php:1078CopySELECT 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 = 190μ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 = 986μs1KB/administrator/components/com_virtuemart/models/category.php:1024CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "9"123μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT COLLATION_NAME from information_schema.columns where TABLE_SCHEMA = "onsa6v7k_zUm5G3cboNXO86fZFv112sTdA76"
and TABLE_NAME = "ly39srojgh48_users"
and COLUMN_NAME = "name";472μs872B/administrator/components/com_virtuemart/models/ratings.php:95CopySELECT COLLATION_NAME from information_schema.columns where TABLE_SCHEMA = "onsa6v7k_zUm5G3cboNXO86fZFv112sTdA76"
and TABLE_NAME = "ly39srojgh48_virtuemart_rating_reviews"
and COLUMN_NAME = "customer";446μs8.85KB/administrator/components/com_virtuemart/models/ratings.php:103CopySELECT `u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, IFNULL(`u`.`name` COLLATE utf8mb4_unicode_ci, `pr`.`customer` COLLATE utf8_unicode_ci) AS customer FROM `ly39srojgh48_virtuemart_rating_reviews` AS `pr`
INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` AS `l` ON `l`.`virtuemart_product_id` = `pr`.`virtuemart_product_id` LEFT JOIN `ly39srojgh48_virtuemart_rating_votes` AS `rv` on
(`pr`.`virtuemart_rating_vote_id` IS NOT NULL AND `rv`.`virtuemart_rating_vote_id`=`pr`.`virtuemart_rating_vote_id` ) XOR
(`pr`.`virtuemart_rating_vote_id` IS NULL AND (`rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id` and `rv`.`created_by`=`pr`.`created_by`) )
LEFT JOIN `ly39srojgh48_users` AS `u` ON `pr`.`created_by` = `u`.`id`
WHERE `pr`.`virtuemart_product_id` = "38"
ORDER BY created_on DESC LIMIT 3236μs7.36KB/administrator/components/com_virtuemart/helpers/vmmodel.php:871CopySELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
j.`params`, j.`custom_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc FROM ly39srojgh48_virtuemart_shipmentmethods as i
LEFT JOIN `ly39srojgh48_virtuemart_shipmentmethods_en_gb` as l ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`
LEFT JOIN `ly39srojgh48_extensions` as j ON j.`extension_id` = i.`shipment_jplugin_id`
LEFT OUTER JOIN `ly39srojgh48_virtuemart_shipmentmethod_shoppergroups` AS s ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id` WHERE i.`published` = "1" AND (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) GROUP BY i.`virtuemart_shipmentmethod_id` ORDER BY i.`ordering`285μs7.69KB/administrator/components/com_virtuemart/plugins/vmpsplugin.php:524CopySELECT `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"234μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "10"202μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "1"86μs872B/components/com_virtuemart/router.php:1571CopySELECT l.slug FROM `ly39srojgh48_virtuemart_manufacturers_en_gb` as l WHERE l.virtuemart_manufacturer_id = "4"65μs872B/components/com_virtuemart/router.php:1571CopySELECT * FROM `ly39srojgh48_virtuemart_ratings` WHERE `virtuemart_product_id` = "38" AND `published`="1"161μs1.95KB/administrator/components/com_virtuemart/models/ratings.php:293CopySELECT `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`996μ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 ASC776μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165CopySELECT * FROM ly39srojgh48_virtuemart_calcs LEFT JOIN ly39srojgh48_virtuemart_calc_shoppergroups using(virtuemart_calc_id)WHERE
`calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-04-08 12:09:23" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-08 12:09:23" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)194μ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-08 12:09:23" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-08 12:09:23" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)163μ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-08 12:09:23" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-08 12:09:23" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)161μs4.36KB/administrator/components/com_virtuemart/helpers/calculationh.php:1522CopySELECT `a`.`menutype`,`a`.`title`
FROM `ly39srojgh48_menu_types` AS `a`
WHERE `a`.`client_id` = 0111μ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.lft777μ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.lft715μ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 5501μ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` = "34"216μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "34" ORDER BY `ordering`98μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "34" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-08 12:09:23" )
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-08 12:09:23" ) ) 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` = "34"83μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 34109μ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"149μ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 (34) AND c.`published` = "1" ORDER BY field.`ordering` ASC195μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "34"97μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "26"213μ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`89μ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-08 12:09:23" )
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-08 12:09:23" ) ) 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` = "26"88μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 26117μ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` 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` = "26"108μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "6"209μ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`92μ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-08 12:09:23" )
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-08 12:09:23" ) ) ORDER BY `product_price` DESC194μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "6"82μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 6106μ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"154μ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` ASC193μ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"101μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "25" ORDER BY `ordering`89μ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-08 12:09:23" )
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-08 12:09:23" ) ) 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` = "25"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 25105μ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` 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` = "25"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` = "4"212μ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`91μ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-08 12:09:23" )
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-08 12:09:23" ) ) 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` = "4"92μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 4106μ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` ASC198μ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_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "19"128μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "17"115μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "23"113μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "21"115μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "10" ORDER BY `ordering`104μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "10" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-08 12:09:23" )
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-08 12:09:23" ) ) ORDER BY `product_price` DESC199μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "10"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 10111μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (10) AND c.`published` = "1" ORDER BY field.`ordering` 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` = "10"103μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "35"132μs4.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "8"228μs24.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "8" ORDER BY `ordering`95μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "8" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-08 12:09:23" )
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-08 12:09:23" ) ) ORDER BY `product_price` DESC196μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "8"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 8107μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (8) AND c.`published` = "1" ORDER BY field.`ordering` ASC200μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "8"102μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "25"129μ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 8496μ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` = "21"228μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "21" ORDER BY `ordering`94μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "21" 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-08 12:09:23" )
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-08 12:09:23" ) ) ORDER BY `product_price` DESC197μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "21"86μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 21109μ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 (21) AND c.`published` = "1" ORDER BY field.`ordering` ASC205μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "21"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` = "2"213μ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`89μ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-08 12:09:23" )
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-08 12:09:23" ) ) 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` = "2"82μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 2106μ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` 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` = "2"110μ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` = "47"210μ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`95μ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-08 12:09:23" )
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-08 12:09:23" ) ) ORDER BY `product_price` DESC205μs4.06KB/administrator/components/com_virtuemart/models/product.php:1522CopySELECT `virtuemart_manufacturer_id` FROM `ly39srojgh48_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "47"85μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 47107μ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"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` = "1"209μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1" ORDER BY `ordering`91μ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-08 12:09:23" )
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-08 12:09:23" ) ) 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` = "1"82μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1106μ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` ASC242μs8.42KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "1"105μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "9"209μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "9" ORDER BY `ordering`92μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "9" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-08 12:09:23" )
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-08 12:09:23" ) ) 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` = "9"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 9106μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (9) AND c.`published` = "1" ORDER BY field.`ordering` ASC207μs7.14KB/administrator/components/com_virtuemart/models/customfields.php:159CopySELECT `ly39srojgh48_virtuemart_ratings`.* FROM `ly39srojgh48_virtuemart_ratings` WHERE `ly39srojgh48_virtuemart_ratings`.`virtuemart_product_id` = "9"105μs2.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_products`.* ,`ly39srojgh48_virtuemart_products_en_gb`.* FROM `ly39srojgh48_virtuemart_products` INNER JOIN `ly39srojgh48_virtuemart_products_en_gb` ON `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = `ly39srojgh48_virtuemart_products_en_gb`.`virtuemart_product_id` WHERE `ly39srojgh48_virtuemart_products`.`virtuemart_product_id` = "42"215μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "42" ORDER BY `ordering`91μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "42" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-08 12:09:23" )
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-08 12:09:23" ) ) 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` = "42"84μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 42117μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (42) AND c.`published` = "1" ORDER BY field.`ordering` 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` = "42"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` = "43"220μs8.91KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `virtuemart_media_id` FROM `ly39srojgh48_virtuemart_product_medias` WHERE `virtuemart_product_id` = "43" ORDER BY `ordering`92μs872B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_prices` WHERE `virtuemart_product_id` = "43" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-08 12:09:23" )
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-08 12:09:23" ) ) 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` = "43"90μs904B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ly39srojgh48_virtuemart_product_categories` WHERE `virtuemart_product_id` = 43106μs2.23KB/administrator/components/com_virtuemart/models/product.php:2142CopySELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`noninheritable`, field.`ordering`,
field.`product_sku`, field.`product_gtin`, field.`product_mpn`
FROM `ly39srojgh48_virtuemart_customs` AS c LEFT JOIN `ly39srojgh48_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (43) AND c.`published` = "1" ORDER BY field.`ordering` 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` = "43"104μs1.95KB/administrator/components/com_virtuemart/helpers/vmtable.php:1122CopySELECT `ly39srojgh48_virtuemart_medias`.* FROM `ly39srojgh48_virtuemart_medias` WHERE `ly39srojgh48_virtuemart_medias`.`virtuemart_media_id` = "18"127μ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"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` = "26"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` = "28"117μ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` asc228μ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` asc225μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy