Welcome to VirtueMart the ecommerce managment system. The sample data give you a good insight of the possibilities with VirtueMart. The product description is directly the manual to configure the demonstrated features.

You see here the store description used to describe your store. Check it out!

We were established in 1869 in a time when getting good clothes was expensive, but the quality was good. Now that only a select few of those authentic clothes survive, we have dedicated this store to bringing the experience alive for collectors and master carrier everywhere.

Example for usage of product pattern. For showcase reason the PATTERN is NOT unpublished.

Sort by

Sorted Product Name +/-

Product Name

Product SKU

Ordering

Manufacturer:

Producer

All Manufacturers

Default

No records found.

Product pattern

Featured Products

Multi Variant

Depended Multivariants

Base price for variant: 10,00 €

Sales price: 11,00 €

Sales price without tax: 10,00 €

Discount:

Tax amount: 1,00 €

Price / COM_VIRTUEMART_UNIT_SYMBOL_:

Product details

T-Shirt classic blue

Freetime & leisure 360° comrade.

Base price for variant: 24,17 €

Sales price: 27,55 €

Sales price without tax: 22,96 €

Discount: -1,45 €

Tax amount: 4,59 €

Price / COM_VIRTUEMART_UNIT_SYMBOL_:

Product details

Dress Shirt with tie

Fine feathers make fine birds - time to get serious.

Base price for variant: 40,83 €

Sales price: 49,00 €

Sales price without tax: 40,83 €

Discount:

Tax amount: 8,17 €

Price / COM_VIRTUEMART_UNIT_SYMBOL_:

Product details

Latest Products

FAC #0 20

Base price for variant: 80,00 €

Sales price: 96,00 €

Sales price without tax: 80,00 €

Discount:

Tax amount: 16,00 €

Price / COM_VIRTUEMART_UNIT_SYMBOL_:

Product details

Advanced PATTERN

Showcase advanced pattern usage.

Base price for variant: 25,00 €

Sales price: 30,00 €

Sales price without tax: 25,00 €

Discount:

Tax amount: 5,00 €

Price / COM_VIRTUEMART_UNIT_SYMBOL_:

Product details

PATTERN Product variants

Base price for variant: 10,00 €

Sales price: 11,00 €

Sales price without tax: 10,00 €

Discount:

Tax amount: 1,00 €

Price / COM_VIRTUEMART_UNIT_SYMBOL_:

Product details

Login Form

J! Info Request Session Profile Queries191 Log5

7.125MB105ms

Joomla! Version	5.1.1
PHP Version	8.2.28
Identity	guest
Response	200
Template	cassiopeia
Database	Server mysql Version 8.0.36-28 Collation utf8mb4_unicode_ci Conn Collation utf8mb4_0900_ai_ci

$_GET: array:5 [ "limitstart" => 0 "virtuemart_manufacturer_id" => 3 "virtuemart_category_id" => 2 ...
$_POST: []
$_SESSION: array:1 [ "joomla" => "***redacted***" ]
$_COOKIE: []
$_SERVER: array:64 [ "USER" => "www-data" "HOME" => "/var/www" "SCRIPT_NAME" => "/index.php" "REQUEST_...

session: array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1747904054 "last" => 1747904054...
registry: array:3 [ "data" => array:1 [ "com_virtuemart" => array:1 [ "category" => array:1 [ ...
user: array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter: array:1 [ "language" => "en-GB" ]
vm: array:5 [ "vmlastvisitedItemid" => 980 "vmlastvisitedcategoryid" => 2 "vmlastvisitedmanuid" =>...
plg_system_webauthn: array:1 [ "returnUrl" => "https://joomla5.rubstudio.cz/en/vm/manufacturer/producer/product-pattern...

afterLoad (84.87KB) (919μs)
afterInitialise (1.31MB) (12.85ms)
Before Access::preloadComponents (all components) (423.77KB) (4.79ms)
After Access::preloadComponents (all components) (120.62KB) (476μs)
Before Access::getAssetRules (id:1 name:root.1) (104B) (8μs)
After Access::getAssetRules (id:1 name:root.1) (7.16KB) (42μs)
Before Access::getAssetRules (id:139 name:com_virtuemart) (776B) (7μs)
After Access::getAssetRules (id:139 name:com_virtuemart) (1.45KB) (2μs)
afterRoute (87.8KB) (3.42ms)
beforeRenderComponent com_virtuemart (16.7KB) (385μs)
afterRenderComponent com_virtuemart (3.3MB) (59.05ms)
afterDispatch (10.7KB) (605μs)
beforeRenderRawModule mod_login (Login Form) (58.45KB) (1.3ms)
afterRenderRawModule mod_login (Login Form) (35.13KB) (1.05ms)
beforeRenderRawModule mod_languages (Language Switcher) (4.39KB) (12μs)
afterRenderRawModule mod_languages (Language Switcher) (14.27KB) (1.2ms)
beforeRenderRawModule mod_menu (Main menu en-GB) (1.3KB) (11μs)
afterRenderRawModule mod_menu (Main menu en-GB) (44.38KB) (747μs)
beforeRenderModule mod_login (Login Form) (7.84KB) (134μs)
afterRenderModule mod_login (Login Form) (11.03KB) (139μs)
beforeRenderModule mod_languages (Language Switcher) (2.84KB) (7μs)
afterRenderModule mod_languages (Language Switcher) (3.69KB) (15μs)
beforeRenderModule mod_menu (Main menu en-GB) (2.83KB) (5μs)
afterRenderModule mod_menu (Main menu en-GB) (2.75KB) (10μs)
beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.32KB) (26μs)
afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.28KB) (330μs)
beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (3μs)
afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.94KB) (146μs)
afterRender (1.16MB) (16.72ms)

1 x afterRenderComponent com_virtuemart (3.3MB) (56.46%)	59.05ms
1 x afterRender (1.16MB) (15.98%)	16.72ms
1 x afterInitialise (1.31MB) (12.28%)	12.85ms
1 x Before Access::preloadComponents (all components) (423.77KB) (4.58%)	4.79ms
1 x afterRoute (87.8KB) (3.27%)	3.42ms
1 x beforeRenderRawModule mod_login (Login Form) (58.45KB) (1.25%)	1.30ms
1 x afterRenderRawModule mod_languages (Language Switcher) (14.27KB) (1.15%)	1.20ms
1 x afterRenderRawModule mod_login (Login Form) (35.13KB) (1%)	1.05ms
1 x afterLoad (84.87KB) (0.88%)	919μs
1 x afterRenderRawModule mod_menu (Main menu en-GB) (44.38KB) (0.71%)	747μs
1 x afterDispatch (10.7KB) (0.58%)	605μs
1 x After Access::preloadComponents (all components) (120.62KB) (0.46%)	476μs
1 x beforeRenderComponent com_virtuemart (16.7KB) (0.37%)	385μs
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.28KB) (0.32%)	330μs
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.94KB) (0.14%)	146μs
1 x afterRenderModule mod_login (Login Form) (11.03KB) (0.13%)	139μs
1 x beforeRenderModule mod_login (Login Form) (7.84KB) (0.13%)	134μs
1 x After Access::getAssetRules (id:1 name:root.1) (7.16KB) (0.04%)	42μs
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.32KB) (0.02%)	26μs
1 x afterRenderModule mod_languages (Language Switcher) (3.69KB) (0.01%)	15μs
1 x beforeRenderRawModule mod_languages (Language Switcher) (4.39KB) (0.01%)	12μs
1 x beforeRenderRawModule mod_menu (Main menu en-GB) (1.3KB) (0.01%)	11μs
1 x afterRenderModule mod_menu (Main menu en-GB) (2.75KB) (0.01%)	10μs
1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0.01%)	8μs
1 x Before Access::getAssetRules (id:139 name:com_virtuemart) (776B) (0.01%)	7μs
1 x beforeRenderModule mod_languages (Language Switcher) (2.84KB) (0.01%)	7μs
1 x beforeRenderModule mod_menu (Main menu en-GB) (2.83KB) (0%)	5μs
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)	3μs
1 x After Access::getAssetRules (id:139 name:com_virtuemart) (1.45KB) (0%)	2μs

191 statements were executed, 4 of which were duplicates, 187 unique34.49ms890.27KB

SELECT @@SESSION.sql_mode;133μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
SELECT `data` FROM `ulqx5_session` WHERE `session_id` = ?192μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
SELECT `session_id` FROM `ulqx5_session` WHERE `session_id` = :session_id LIMIT 1166μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
INSERT INTO `ulqx5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)276μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `ulqx5_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1438μs17.73KB/libraries/src/Component/ComponentHelper.php:399Copy
SELECT `id`,`rules` FROM `ulqx5_viewlevels`137μs656B/libraries/src/Access/Access.php:955Copy
SELECT `b`.`id` FROM `ulqx5_usergroups` AS `a` LEFT JOIN `ulqx5_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest186μs1.33KBParams/libraries/src/Access/Access.php:868Copy
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `ulqx5_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`421μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
SELECT `params` FROM `ulqx5_extensions` WHERE `element` = 'gtm' AND `type` = 'plugin' AND `folder` = 'system' AND `enabled` = 1151μs1.15KB/plugins/system/gtm/helpers/plugin.php:130Copy
SELECT * FROM `ulqx5_languages` WHERE `published` = 1 ORDER BY `ordering` ASC161μs1.61KB/libraries/src/Language/LanguageHelper.php:177Copy
SELECT `element`,`name`,`client_id`,`extension_id` FROM `ulqx5_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1142μs784B/libraries/src/Language/LanguageHelper.php:250Copy
SELECT `value` FROM ulqx5_acym_configuration WHERE `name` = 'level'121μs536B/plugins/system/acymtriggers/acymtriggers.php:643Copy
SELECT `value` FROM ulqx5_acym_configuration WHERE `name` = 'active_cron'115μs536B/plugins/system/acymtriggers/acymtriggers.php:643Copy
SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `ulqx5_menu` AS `m` LEFT JOIN `ulqx5_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`278μs3.39KBParams/libraries/src/Menu/SiteMenu.php:166Copy
SHOW TABLES LIKE "ulqx5_virtuemart_configs"660μs536B/administrator/components/com_virtuemart/helpers/vmtable.php:826Copy
SELECT `config` FROM `ulqx5_virtuemart_configs` WHERE `virtuemart_config_id` = "1";177μs536B/administrator/components/com_virtuemart/helpers/config.php:457Copy
SELECT `id`,`name`,`rules`,`parent_id` FROM `ulqx5_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,:preparedArray44)241μs9.06KBParams/libraries/src/Access/Access.php:357Copy
SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `ulqx5_template_styles` AS `s` LEFT JOIN `ulqx5_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` = 1178μs848B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
SELECT * FROM `ulqx5_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` DESC218μs2.84KB/components/com_virtuemart/router.php:1727Copy
SELECT l.virtuemart_manufacturer_id FROM `ulqx5_virtuemart_manufacturers_cs_cz` as l WHERE l.slug = "producer"111μs536B/components/com_virtuemart/router.php:1652Copy
SELECT l.virtuemart_category_id FROM `ulqx5_virtuemart_categories_cs_cz` as l WHERE l.slug = "product-pattern"104μs536B/components/com_virtuemart/router.php:1652Copy
SELECT `ulqx5_virtuemart_categories`.* ,`ulqx5_virtuemart_categories_cs_cz`.* FROM `ulqx5_virtuemart_categories` INNER JOIN `ulqx5_virtuemart_categories_cs_cz` ON `ulqx5_virtuemart_categories`.`virtuemart_category_id` = `ulqx5_virtuemart_categories_cs_cz`.`virtuemart_category_id` WHERE `ulqx5_virtuemart_categories`.`virtuemart_category_id` = "2"170μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_category_medias` WHERE `virtuemart_category_id` = "2" ORDER BY `ordering`137μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent` FROM ulqx5_virtuemart_categories WHERE `virtuemart_category_id`= 2111μs592B/administrator/components/com_virtuemart/models/category.php:1095Copy
SELECT l.virtuemart_category_id, l.category_name, published FROM `ulqx5_virtuemart_categories` as c LEFT JOIN `ulqx5_virtuemart_categories_cs_cz` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE l.virtuemart_category_id = 2110μs656B/administrator/components/com_virtuemart/models/category.php:1041Copy
SELECT l.slug FROM `ulqx5_virtuemart_manufacturers_cs_cz` as l WHERE l.virtuemart_manufacturer_id = "3"125μs536B/components/com_virtuemart/router.php:1652Copy
SELECT c.* FROM ulqx5_virtuemart_customs as c INNER JOIN ulqx5_virtuemart_product_customfields as pc on (c.virtuemart_custom_id=pc.virtuemart_custom_id) INNER JOIN ulqx5_virtuemart_product_categories as cat ON (pc.virtuemart_product_id=cat.virtuemart_product_id) WHERE virtuemart_category_id="2" and searchable="1" and (field_type="S" or field_type="P") and c.published = 1 GROUP BY c.virtuemart_custom_id253μs3.06KB/components/com_virtuemart/views/category/view.html.php:614Copy
SELECT pc.* FROM ulqx5_virtuemart_product_customfields as pc INNER JOIN ulqx5_virtuemart_products as p on (pc.virtuemart_product_id=p.virtuemart_product_id)INNER JOIN ulqx5_virtuemart_product_categories as cat on (pc.virtuemart_product_id=cat.virtuemart_product_id) WHERE virtuemart_custom_id="100" and p.published="1" and virtuemart_category_id="2" GROUP BY `customfield_value`307μs1.64KB/components/com_virtuemart/views/category/view.html.php:642Copy
SELECT * FROM `ulqx5_virtuemart_shoppergroups` WHERE `default` = "2" AND (`virtuemart_vendor_id` = "1" OR `shared` = "1") AND `published`="1"180μs2.38KB/administrator/components/com_virtuemart/models/shoppergroup.php:101Copy
SELECT `ulqx5_virtuemart_shoppergroups`.* FROM `ulqx5_virtuemart_shoppergroups` WHERE `ulqx5_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"153μs2.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SHOW FULL COLUMNS FROM `ulqx5_virtuemart_userfields`747μs1.89KB/administrator/components/com_virtuemart/helpers/vmtable.php:787Copy
SELECT * FROM `ulqx5_virtuemart_userfields` WHERE 1 = 1 AND `account`="1" AND published = 1 AND FIND_IN_SET(name, 'address_type') = 0 ORDER BY ordering303μs4.92KB/administrator/components/com_virtuemart/helpers/vmmodel.php:515Copy
SELECT * FROM `ulqx5_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 ordering240μs7.3KB/administrator/components/com_virtuemart/helpers/vmmodel.php:515Copy
SELECT p.`virtuemart_product_id`, l.product_name FROM `ulqx5_virtuemart_products` as p LEFT JOIN `ulqx5_virtuemart_products_cs_cz` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `ulqx5_virtuemart_product_manufacturers` as pmanu ON p.`virtuemart_product_id` = pmanu.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` WHERE ( `c`.`published` = 1 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND pmanu.`virtuemart_manufacturer_id` = 3 AND p.`product_special`="1" AND p.`published`="1" ) group by p.`virtuemart_product_id` ORDER BY RAND() LIMIT 9420μs624B/administrator/components/com_virtuemart/helpers/vmmodel.php:888Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "300"194μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "300" ORDER BY `ordering`129μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "300"105μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_prices` WHERE `virtuemart_product_id` = "300" 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-05-22 10:54:14" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-05-22 10:54:14" ) ) ORDER BY `product_price` DESC190μs2.38KB/administrator/components/com_virtuemart/models/product.php:1589Copy
SELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "300"130μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 300110μs704B/administrator/components/com_virtuemart/models/product.php:2191Copy
SELECT `ulqx5_virtuemart_categories`.* ,`ulqx5_virtuemart_categories_cs_cz`.* FROM `ulqx5_virtuemart_categories` INNER JOIN `ulqx5_virtuemart_categories_cs_cz` ON `ulqx5_virtuemart_categories`.`virtuemart_category_id` = `ulqx5_virtuemart_categories_cs_cz`.`virtuemart_category_id` WHERE `ulqx5_virtuemart_categories`.`virtuemart_category_id` = "11"152μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_manufacturers`.* ,`ulqx5_virtuemart_manufacturers_cs_cz`.* FROM `ulqx5_virtuemart_manufacturers` INNER JOIN `ulqx5_virtuemart_manufacturers_cs_cz` ON `ulqx5_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ulqx5_virtuemart_manufacturers_cs_cz`.`virtuemart_manufacturer_id` WHERE `ulqx5_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "3"130μs2.56KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "170"175μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "170" ORDER BY `ordering`120μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "170"106μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_prices` WHERE `virtuemart_product_id` = "170" 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-05-22 10:54:14" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-05-22 10:54:14" ) ) ORDER BY `product_price` DESC149μs2.36KB/administrator/components/com_virtuemart/models/product.php:1589Copy
SELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "170"109μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 170109μs704B/administrator/components/com_virtuemart/models/product.php:2191Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "9"164μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "9" ORDER BY `ordering`106μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "9"97μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_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-05-22 10:54:14" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-05-22 10:54:14" ) ) ORDER BY `product_price` DESC143μs2.38KB/administrator/components/com_virtuemart/models/product.php:1589Copy
SELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "9"106μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 9114μs688B/administrator/components/com_virtuemart/models/product.php:2191Copy
SELECT `ulqx5_virtuemart_manufacturers`.* ,`ulqx5_virtuemart_manufacturers_cs_cz`.* FROM `ulqx5_virtuemart_manufacturers` INNER JOIN `ulqx5_virtuemart_manufacturers_cs_cz` ON `ulqx5_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `ulqx5_virtuemart_manufacturers_cs_cz`.`virtuemart_manufacturer_id` WHERE `ulqx5_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"138μs2.56KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT 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 `ulqx5_virtuemart_customs` AS c LEFT JOIN `ulqx5_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (300,170,9) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs4.66KB/administrator/components/com_virtuemart/models/customfields.php:163Copy
SELECT * FROM `ulqx5_virtuemart_currencies` AS c LEFT JOIN `ulqx5_virtuemart_vendors` AS v ON c.virtuemart_currency_id = v.vendor_currency WHERE v.virtuemart_vendor_id = "1"179μs4.63KB/administrator/components/com_virtuemart/models/vendor.php:316Copy
SELECT `ulqx5_virtuemart_currencies`.* FROM `ulqx5_virtuemart_currencies` WHERE `ulqx5_virtuemart_currencies`.`virtuemart_currency_id` = "47"132μs2.72KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT c.* FROM ulqx5_virtuemart_calcs as c LEFT JOIN ulqx5_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 `publish_up`="0000-00-00 00:00:00") OR publish_up <= "2025-05-22 06:54:14" ) AND ( ( ISNULL(`publish_down`) or `publish_down`="0000-00-00 00:00:00") OR publish_down >= "2025-05-22 06:54:14" ) AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL) ORDER BY c.ordering280μs3.11KB/administrator/components/com_virtuemart/helpers/calculationh.php:174Copy
SELECT `virtuemart_category_id` FROM ulqx5_virtuemart_calc_categories WHERE `virtuemart_calc_id`="1"147μs616B/administrator/components/com_virtuemart/helpers/calculationh.php:1307Copy
SELECT `virtuemart_category_id` FROM ulqx5_virtuemart_calc_categories WHERE `virtuemart_calc_id`="3"132μs536B/administrator/components/com_virtuemart/helpers/calculationh.php:1307Copy
SELECT `virtuemart_category_id` FROM ulqx5_virtuemart_calc_categories WHERE `virtuemart_calc_id`="4"120μs536B/administrator/components/com_virtuemart/helpers/calculationh.php:1307Copy
SELECT `virtuemart_category_id` FROM ulqx5_virtuemart_calc_categories WHERE `virtuemart_calc_id`="2"99μs536B/administrator/components/com_virtuemart/helpers/calculationh.php:1307Copy
SELECT `ulqx5_virtuemart_ratings`.* FROM `ulqx5_virtuemart_ratings` WHERE `ulqx5_virtuemart_ratings`.`virtuemart_product_id` = "300"129μs1.34KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "155"190μs32.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "155" ORDER BY `ordering`115μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "155"135μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_prices` WHERE `virtuemart_product_id` = "155" 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-05-22 10:54:14" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-05-22 10:54:14" ) ) ORDER BY `product_price` DESC208μs2.38KB/administrator/components/com_virtuemart/models/product.php:1589Copy
SELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "155"148μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 155133μs736B/administrator/components/com_virtuemart/models/product.php:2191Copy
SELECT `ulqx5_virtuemart_categories`.* ,`ulqx5_virtuemart_categories_cs_cz`.* FROM `ulqx5_virtuemart_categories` INNER JOIN `ulqx5_virtuemart_categories_cs_cz` ON `ulqx5_virtuemart_categories`.`virtuemart_category_id` = `ulqx5_virtuemart_categories_cs_cz`.`virtuemart_category_id` WHERE `ulqx5_virtuemart_categories`.`virtuemart_category_id` = "7"223μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_categories`.* ,`ulqx5_virtuemart_categories_cs_cz`.* FROM `ulqx5_virtuemart_categories` INNER JOIN `ulqx5_virtuemart_categories_cs_cz` ON `ulqx5_virtuemart_categories`.`virtuemart_category_id` = `ulqx5_virtuemart_categories_cs_cz`.`virtuemart_category_id` WHERE `ulqx5_virtuemart_categories`.`virtuemart_category_id` = "8"155μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_categories`.* ,`ulqx5_virtuemart_categories_cs_cz`.* FROM `ulqx5_virtuemart_categories` INNER JOIN `ulqx5_virtuemart_categories_cs_cz` ON `ulqx5_virtuemart_categories`.`virtuemart_category_id` = `ulqx5_virtuemart_categories_cs_cz`.`virtuemart_category_id` WHERE `ulqx5_virtuemart_categories`.`virtuemart_category_id` = "9"132μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT 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 `ulqx5_virtuemart_customs` AS c LEFT JOIN `ulqx5_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (155) AND c.`published` = "1" ORDER BY field.`ordering` ASC200μs4.7KB/administrator/components/com_virtuemart/models/customfields.php:163Copy
SELECT `ulqx5_virtuemart_ratings`.* FROM `ulqx5_virtuemart_ratings` WHERE `ulqx5_virtuemart_ratings`.`virtuemart_product_id` = "155"123μs1.34KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "154"163μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "154" ORDER BY `ordering`113μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "154"98μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_prices` WHERE `virtuemart_product_id` = "154" 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-05-22 10:54:14" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-05-22 10:54:14" ) ) ORDER BY `product_price` DESC162μs2.38KB/administrator/components/com_virtuemart/models/product.php:1589Copy
SELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "154"106μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 154107μs720B/administrator/components/com_virtuemart/models/product.php:2191Copy
SELECT 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 `ulqx5_virtuemart_customs` AS c LEFT JOIN `ulqx5_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (154) AND c.`published` = "1" ORDER BY field.`ordering` ASC204μs4.72KB/administrator/components/com_virtuemart/models/customfields.php:163Copy
SELECT `ulqx5_virtuemart_ratings`.* FROM `ulqx5_virtuemart_ratings` WHERE `ulqx5_virtuemart_ratings`.`virtuemart_product_id` = "154"126μs1.34KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_medias`.* FROM `ulqx5_virtuemart_medias` WHERE `ulqx5_virtuemart_medias`.`virtuemart_media_id` = "11"127μs2.78KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_medias`.* FROM `ulqx5_virtuemart_medias` WHERE `ulqx5_virtuemart_medias`.`virtuemart_media_id` = "29"138μs2.78KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_medias`.* FROM `ulqx5_virtuemart_medias` WHERE `ulqx5_virtuemart_medias`.`virtuemart_media_id` = "24"128μs2.78KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT p.`virtuemart_product_id`, l.product_name FROM `ulqx5_virtuemart_products` as p LEFT JOIN `ulqx5_virtuemart_products_cs_cz` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `ulqx5_virtuemart_product_manufacturers` as pmanu ON p.`virtuemart_product_id` = pmanu.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` WHERE ( `c`.`published` = 1 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND pmanu.`virtuemart_manufacturer_id` = 3 AND p.`product_discontinued`="1" AND p.`published`="1" AND ( p.`virtuemart_product_id` NOT IN (300,155,154) ) ) group by p.`virtuemart_product_id` ORDER BY product_name ASC, p.`virtuemart_product_id` ASC LIMIT 9273μs576B/administrator/components/com_virtuemart/helpers/vmmodel.php:888Copy
SELECT p.`virtuemart_product_id`, l.product_name FROM `ulqx5_virtuemart_products` as p LEFT JOIN `ulqx5_virtuemart_products_cs_cz` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `ulqx5_virtuemart_product_manufacturers` as pmanu ON p.`virtuemart_product_id` = pmanu.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` WHERE ( `c`.`published` = 1 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND pmanu.`virtuemart_manufacturer_id` = 3 AND p.`published`="1" AND ( p.`virtuemart_product_id` NOT IN (300,155,154) ) ) group by p.`virtuemart_product_id` ORDER BY p.`created_on` DESC, p.`virtuemart_product_id` DESC LIMIT 3255μs624B/administrator/components/com_virtuemart/helpers/vmmodel.php:888Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "1200"191μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1200" ORDER BY `ordering`115μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1200"107μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1200" 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-05-22 10:54:14" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-05-22 10:54:14" ) ) ORDER BY `product_price` DESC160μs2.38KB/administrator/components/com_virtuemart/models/product.php:1589Copy
SELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1200"107μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1200106μs704B/administrator/components/com_virtuemart/models/product.php:2191Copy
SELECT `ulqx5_virtuemart_categories`.* ,`ulqx5_virtuemart_categories_cs_cz`.* FROM `ulqx5_virtuemart_categories` INNER JOIN `ulqx5_virtuemart_categories_cs_cz` ON `ulqx5_virtuemart_categories`.`virtuemart_category_id` = `ulqx5_virtuemart_categories_cs_cz`.`virtuemart_category_id` WHERE `ulqx5_virtuemart_categories`.`virtuemart_category_id` = "3"157μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT 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 `ulqx5_virtuemart_customs` AS c LEFT JOIN `ulqx5_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (1200) AND c.`published` = "1" ORDER BY field.`ordering` ASC148μs4.64KB/administrator/components/com_virtuemart/models/customfields.php:163Copy
SELECT `ulqx5_virtuemart_ratings`.* FROM `ulqx5_virtuemart_ratings` WHERE `ulqx5_virtuemart_ratings`.`virtuemart_product_id` = "1200"124μs1.34KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "204"205μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "204" ORDER BY `ordering`151μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "204"130μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_prices` WHERE `virtuemart_product_id` = "204" 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-05-22 10:54:14" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-05-22 10:54:14" ) ) ORDER BY `product_price` DESC216μs2.38KB/administrator/components/com_virtuemart/models/product.php:1589Copy
SELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "204"152μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 204119μs704B/administrator/components/com_virtuemart/models/product.php:2191Copy
SELECT 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 `ulqx5_virtuemart_customs` AS c LEFT JOIN `ulqx5_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (204) AND c.`published` = "1" ORDER BY field.`ordering` ASC189μs4.69KB/administrator/components/com_virtuemart/models/customfields.php:163Copy
SELECT `ulqx5_virtuemart_ratings`.* FROM `ulqx5_virtuemart_ratings` WHERE `ulqx5_virtuemart_ratings`.`virtuemart_product_id` = "204"163μs1.34KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_ratings`.* FROM `ulqx5_virtuemart_ratings` WHERE `ulqx5_virtuemart_ratings`.`virtuemart_product_id` = "170"153μs1.34KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_medias`.* FROM `ulqx5_virtuemart_medias` WHERE `ulqx5_virtuemart_medias`.`virtuemart_media_id` = "20"172μs2.78KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT p.`virtuemart_product_id`, l.product_name FROM `ulqx5_virtuemart_products` as p LEFT JOIN `ulqx5_virtuemart_products_cs_cz` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `ulqx5_virtuemart_product_manufacturers` as pmanu ON p.`virtuemart_product_id` = pmanu.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` WHERE ( `c`.`published` = 1 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND pmanu.`virtuemart_manufacturer_id` = 3 AND pp.`product_price`>"0.001" AND p.`published`="1" AND ( p.`virtuemart_product_id` NOT IN (300,155,154,1200,204,170) ) ) group by p.`virtuemart_product_id` ORDER BY p.`product_sales` DESC, p.`virtuemart_product_id` DESC LIMIT 3352μs576B/administrator/components/com_virtuemart/helpers/vmmodel.php:888Copy
SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`, l.product_name FROM `ulqx5_virtuemart_products` as p LEFT JOIN `ulqx5_virtuemart_products_cs_cz` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `ulqx5_virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `ulqx5_virtuemart_product_manufacturers` as pmanu ON p.`virtuemart_product_id` = pmanu.`virtuemart_product_id` WHERE ( `pc`.`virtuemart_category_id` IN (2) AND `c`.`published` = 1 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND pmanu.`virtuemart_manufacturer_id` = 3 AND p.`published`="1" AND ( p.`virtuemart_product_id` NOT IN (300,155,154,1200,204,170) ) ) group by p.`virtuemart_product_id` ORDER BY `pc`.`ordering` ASC, `product_name` ASC LIMIT 24296μs576B/administrator/components/com_virtuemart/helpers/vmmodel.php:888Copy
SELECT FOUND_ROWS()99μs536B/administrator/components/com_virtuemart/helpers/vmmodel.php:902Copy
SELECT DISTINCT l.virtuemart_manufacturer_id, l.mf_name FROM `ulqx5_virtuemart_manufacturers_cs_cz` as l INNER JOIN `ulqx5_virtuemart_product_manufacturers` AS pm ON pm.`virtuemart_manufacturer_id` = l.`virtuemart_manufacturer_id` INNER JOIN `ulqx5_virtuemart_products` as p ON p.`virtuemart_product_id` = pm.`virtuemart_product_id` INNER JOIN `ulqx5_virtuemart_product_categories` as pc ON pc.`virtuemart_product_id` = pm.`virtuemart_product_id` WHERE p.`published` = "1" AND pc.`virtuemart_category_id` = "2" ORDER BY `mf_name`197μs608B/administrator/components/com_virtuemart/models/manufacturer.php:222Copy
SELECT l.slug FROM `ulqx5_virtuemart_manufacturers_cs_cz` as l WHERE l.virtuemart_manufacturer_id = "2"107μs536B/components/com_virtuemart/router.php:1652Copy
SELECT virtuemart_product_id FROM `ulqx5_virtuemart_products` WHERE `product_parent_id` =300 and ( published = "1" ) ORDER BY pordering, created_on ASC138μs776B/administrator/components/com_virtuemart/models/product.php:3674Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "301"175μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "302"159μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "303"159μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "304"153μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "305"143μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "306"146μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "307"157μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "308"150μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "309"157μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "310"159μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "311"151μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "312"144μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "313"171μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "314"167μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "315"177μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT p.`virtuemart_product_id` FROM `ulqx5_virtuemart_products` as p LEFT JOIN `ulqx5_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = pc.`virtuemart_product_id` WHERE p.`product_parent_id` = "155" AND p.`published`="1" GROUP BY p.`virtuemart_product_id` ORDER BY p.pordering ASC178μs8.55KB/administrator/components/com_virtuemart/models/product.php:3601Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "197"189μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "197" ORDER BY `ordering`127μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "197"115μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_prices` WHERE `virtuemart_product_id` = "197" 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-05-22 10:54:14" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-05-22 10:54:14" ) ) ORDER BY `product_price` DESC160μs2.36KB/administrator/components/com_virtuemart/models/product.php:1589Copy
SELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "197"111μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 197105μs688B/administrator/components/com_virtuemart/models/product.php:2191Copy
SELECT 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 `ulqx5_virtuemart_customs` AS c LEFT JOIN `ulqx5_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (197) AND c.`published` = "1" ORDER BY field.`ordering` ASC201μs4.7KB/administrator/components/com_virtuemart/models/customfields.php:163Copy
SELECT `ulqx5_virtuemart_ratings`.* FROM `ulqx5_virtuemart_ratings` WHERE `ulqx5_virtuemart_ratings`.`virtuemart_product_id` = "197"160μs1.33KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "198"207μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "198" ORDER BY `ordering`142μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "198"105μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_prices` WHERE `virtuemart_product_id` = "198" 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-05-22 10:54:14" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-05-22 10:54:14" ) ) ORDER BY `product_price` DESC174μs2.36KB/administrator/components/com_virtuemart/models/product.php:1589Copy
SELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "198"104μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 198106μs688B/administrator/components/com_virtuemart/models/product.php:2191Copy
SELECT 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 `ulqx5_virtuemart_customs` AS c LEFT JOIN `ulqx5_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (198) AND c.`published` = "1" ORDER BY field.`ordering` ASC199μs4.72KB/administrator/components/com_virtuemart/models/customfields.php:163Copy
SELECT `ulqx5_virtuemart_ratings`.* FROM `ulqx5_virtuemart_ratings` WHERE `ulqx5_virtuemart_ratings`.`virtuemart_product_id` = "198"112μs1.33KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "199"167μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "199" ORDER BY `ordering`116μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "199"99μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_prices` WHERE `virtuemart_product_id` = "199" 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-05-22 10:54:14" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-05-22 10:54:14" ) ) ORDER BY `product_price` DESC154μs2.36KB/administrator/components/com_virtuemart/models/product.php:1589Copy
SELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "199"106μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 199110μs688B/administrator/components/com_virtuemart/models/product.php:2191Copy
SELECT 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 `ulqx5_virtuemart_customs` AS c LEFT JOIN `ulqx5_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (199) AND c.`published` = "1" ORDER BY field.`ordering` ASC208μs4.72KB/administrator/components/com_virtuemart/models/customfields.php:163Copy
SELECT `ulqx5_virtuemart_ratings`.* FROM `ulqx5_virtuemart_ratings` WHERE `ulqx5_virtuemart_ratings`.`virtuemart_product_id` = "199"118μs1.33KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT p.`virtuemart_product_id` FROM `ulqx5_virtuemart_products` as p LEFT JOIN `ulqx5_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = pc.`virtuemart_product_id` WHERE p.`product_parent_id` = "154" AND p.`published`="1" GROUP BY p.`virtuemart_product_id` ORDER BY p.pordering ASC147μs552B/administrator/components/com_virtuemart/models/product.php:3601Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "195"174μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT 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 `ulqx5_virtuemart_customs` AS c LEFT JOIN `ulqx5_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (195) AND c.`published` = "1" ORDER BY field.`ordering` ASC191μs4.72KB/administrator/components/com_virtuemart/models/customfields.php:163Copy
SELECT `ulqx5_virtuemart_ratings`.* FROM `ulqx5_virtuemart_ratings` WHERE `ulqx5_virtuemart_ratings`.`virtuemart_product_id` = "195"110μs1.33KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_products`.* ,`ulqx5_virtuemart_products_cs_cz`.* FROM `ulqx5_virtuemart_products` INNER JOIN `ulqx5_virtuemart_products_cs_cz` ON `ulqx5_virtuemart_products`.`virtuemart_product_id` = `ulqx5_virtuemart_products_cs_cz`.`virtuemart_product_id` WHERE `ulqx5_virtuemart_products`.`virtuemart_product_id` = "196"186μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "196" ORDER BY `ordering`108μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "196"96μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_prices` WHERE `virtuemart_product_id` = "196" 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-05-22 10:54:14" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-05-22 10:54:14" ) ) ORDER BY `product_price` DESC144μs2.36KB/administrator/components/com_virtuemart/models/product.php:1589Copy
SELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "196"108μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 196103μs688B/administrator/components/com_virtuemart/models/product.php:2191Copy
SELECT 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 `ulqx5_virtuemart_customs` AS c LEFT JOIN `ulqx5_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (196) AND c.`published` = "1" ORDER BY field.`ordering` ASC181μs4.72KB/administrator/components/com_virtuemart/models/customfields.php:163Copy
SELECT `ulqx5_virtuemart_ratings`.* FROM `ulqx5_virtuemart_ratings` WHERE `ulqx5_virtuemart_ratings`.`virtuemart_product_id` = "196"129μs1.33KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `ulqx5_virtuemart_medias`.* FROM `ulqx5_virtuemart_medias` WHERE `ulqx5_virtuemart_medias`.`virtuemart_media_id` = "10"139μs2.78KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT 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 ulqx5_virtuemart_categories as c LEFT JOIN `ulqx5_virtuemart_categories_cs_cz` 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 ASC200μs2.77KB/administrator/components/com_virtuemart/models/category.php:409Copy
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM ulqx5_fields AS a LEFT JOIN `ulqx5_languages` AS l ON l.lang_code = a.language LEFT JOIN ulqx5_users AS uc ON uc.id=a.checked_out LEFT JOIN ulqx5_viewlevels AS ag ON ag.id = a.access LEFT JOIN ulqx5_users AS ua ON ua.id = a.created_user_id LEFT JOIN ulqx5_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 ASC365μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
SELECT `ulqx5_virtuemart_vendors`.* ,`ulqx5_virtuemart_vendors_cs_cz`.* FROM `ulqx5_virtuemart_vendors` INNER JOIN `ulqx5_virtuemart_vendors_cs_cz` ON `ulqx5_virtuemart_vendors`.`virtuemart_vendor_id` = `ulqx5_virtuemart_vendors_cs_cz`.`virtuemart_vendor_id` WHERE `ulqx5_virtuemart_vendors`.`virtuemart_vendor_id` = "1"187μs3.16KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135Copy
SELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_vendor_medias` WHERE `virtuemart_vendor_id` = "1" ORDER BY `ordering`144μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78Copy
SELECT * FROM ulqx5_menu WHERE id = "980"202μs2.84KB/administrator/components/com_virtuemart/helpers/vmpagination.php:410Copy
SELECT `language`,`id` FROM `ulqx5_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0187μs624B/libraries/src/Language/Multilanguage.php:123Copy
SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `ulqx5_modules` AS `m` LEFT JOIN `ulqx5_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `ulqx5_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`429μs2KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
SELECT `c2`.`language`,`c2`.`id` FROM `ulqx5_menu` AS `c` INNER JOIN `ulqx5_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `ulqx5_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `ulqx5_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id176μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
SELECT * FROM ulqx5_acym_configuration218μs2.31KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
SELECT * FROM ulqx5_acym_list WHERE type = 'standard'171μs1.66KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
SELECT * FROM ulqx5_acym_field169μs1.69KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
SELECT * FROM ulqx5_acym_form WHERE active = 1 AND type != 'shortcode'152μs912B/administrator/components/com_acym/Core/joomla/database.php:36Copy
SELECT * FROM ulqx5_jmap_metainfo WHERE `linkurl` = 'https://joomla5.rubstudio.cz/en/vm/manufacturer/producer/product-pattern.html' AND `published` = 1167μs912B/plugins/system/jmap/jmap.php:769Copy
SELECT * FROM ulqx5_jmap_canonicals WHERE `linkurl` = 'https://joomla5.rubstudio.cz/en/vm/manufacturer/producer/product-pattern.html'123μs640B/plugins/system/jmap/jmap.php:871Copy
SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `ulqx5_scheduler_tasks` AS `a` WHERE `a`.`state` = 1165μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
SELECT `value` FROM ulqx5_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"219μs536B/plugins/system/acymtriggers/acymtriggers.php:434Copy
SHOW TABLES1.11ms4.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:635Copy
SELECT * FROM ulqx5_acym_plugin264μs2.08KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
SELECT * FROM ulqx5_acym_plugin178μs2.08KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
SHOW TABLES1.01ms4.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:635Copy
SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM ulqx5_usergroups AS `groups`382μs1.02KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
SELECT * FROM ulqx5_jmap_headings WHERE `linkurl` = 'https://joomla5.rubstudio.cz/en/vm/manufacturer/producer/product-pattern.html'147μs752B/plugins/system/jmap/jmap.php:1086Copy
SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `ulqx5_jmap_text_replacements` WHERE `published` = 1107μs688B/plugins/system/jmap/jmap.php:465Copy
SELECT `session_id` FROM `ulqx5_session` WHERE `session_id` = ?147μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
UPDATE `ulqx5_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?240μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy

infoplg_system_gtm_debug - GtmQueue::__construct: Array ( [0] => session )
infoplg_system_gtm_debug - GtmQueue::__construct: Array ( [0] => session )
infoplg_system_gtm_debug - GtmQueue::getItems: Array ( )
infoplg_system_gtm_debug - GtmQueue::updateItemsStatus: Array ( [0] => Array ( ) )
infoplg_system_gtm - plgSystemGtm::onAfterRender - https://joomla5.rubstudio.cz/en/vm/manufacturer/produ...

Product pattern

Featured Products

Multi Variant

T-Shirt classic blue

Dress Shirt with tie

Latest Products

FAC #0 20

Advanced PATTERN

PATTERN Product variants

Login Form

Main menu en-GB