
This product is derived from a pattern for other products. It is a parent product and has multiple child products.
You can set several settings (content, customfields) for parent product. Childs of this parent will basically have the same settings as the parent automatically inherit except you overwrite the settings.
In this case product price is set in pattern.
Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua.
At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
Joomla! Version | 5.1.1 |
PHP Version | 8.2.17 |
Identity | guest |
Response | 200 |
Template | cassiopeia |
Database |
|
1 x afterRenderComponent com_virtuemart (2.14MB) (46.35%) | 34.33ms |
1 x afterRender (1.01MB) (21.28%) | 15.76ms |
1 x afterInitialise (1.3MB) (17.98%) | 13.32ms |
1 x Before Access::preloadComponents (all components) (195.62KB) (5.57%) | 4.12ms |
1 x afterRoute (93.01KB) (5.09%) | 3.77ms |
1 x afterLoad (90.47KB) (1.28%) | 945μs |
1 x afterDispatch (11.77KB) (0.82%) | 610μs |
1 x After Access::preloadComponents (all components) (118.43KB) (0.67%) | 497μs |
1 x beforeRenderComponent com_virtuemart (17.03KB) (0.59%) | 438μs |
1 x After Access::getAssetRules (id:1 name:root.1) (7.16KB) (0.06%) | 43μs |
1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0.01%) | 9μs |
1 x Before Access::getAssetRules (id:139 name:com_virtuemart) (776B) (0.01%) | 7μs |
1 x After Access::getAssetRules (id:139 name:com_virtuemart) (1.45KB) (0%) | 3μs |
SELECT @@SESSION.sql_mode;
131μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `ulqx5_session`
WHERE `session_id` = ?
194μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `ulqx5_session`
WHERE `session_id` = :session_id LIMIT 1
115μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `ulqx5_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
239μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ulqx5_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
393μs17.73KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `ulqx5_viewlevels`
118μs656B/libraries/src/Access/Access.php:955CopySELECT `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` = :guest
177μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `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`
433μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `params`
FROM `ulqx5_extensions`
WHERE `element` = 'gtm' AND `type` = 'plugin' AND `folder` = 'system' AND `enabled` = 1
185μs1.15KB/plugins/system/gtm/helpers/plugin.php:130CopySELECT *
FROM `ulqx5_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
187μs1.61KB/libraries/src/Language/LanguageHelper.php:177CopySELECT `element`,`name`,`client_id`,`extension_id`
FROM `ulqx5_extensions`
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1
160μs784B/libraries/src/Language/LanguageHelper.php:250CopySELECT `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`
299μs3.39KBParams/libraries/src/Menu/SiteMenu.php:166CopySHOW TABLES LIKE "ulqx5_virtuemart_configs"
523μs536B/administrator/components/com_virtuemart/helpers/vmtable.php:826CopySELECT `config` FROM `ulqx5_virtuemart_configs` WHERE `virtuemart_config_id` = "1";
170μs536B/administrator/components/com_virtuemart/helpers/config.php:457CopySELECT `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)
264μs7.81KBParams/libraries/src/Access/Access.php:357CopySELECT `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` = 1
185μs848B/administrator/components/com_templates/src/Model/StyleModel.php:775CopySELECT * FROM `ulqx5_menu` WHERE `link` like "index.php?option=com_virtuemart%" and (language="*" or language = "cs-CZ" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC
214μs4.09KB/components/com_virtuemart/router.php:1727CopySELECT l.virtuemart_product_id FROM `ulqx5_virtuemart_products_cs_cz` as l WHERE l.slug = "ghd-8-24"
127μs536B/components/com_virtuemart/router.php:1652CopySELECT l.virtuemart_category_id FROM `ulqx5_virtuemart_categories_cs_cz` as l WHERE l.slug = "pagination"
108μs536B/components/com_virtuemart/router.php:1652CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM ulqx5_virtuemart_categories
WHERE `virtuemart_category_id`= 3
118μs592B/administrator/components/com_virtuemart/models/category.php:1095CopySELECT `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"
166μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_category_medias` WHERE `virtuemart_category_id` = "3" ORDER BY `ordering`
135μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT 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 = 3
114μs656B/administrator/components/com_virtuemart/models/category.php:1041CopySELECT * FROM `ulqx5_virtuemart_shoppergroups` WHERE `default` = "2" AND (`virtuemart_vendor_id` = "1" OR `shared` = "1") AND `published`="1"
178μs2.38KB/administrator/components/com_virtuemart/models/shoppergroup.php:101CopySELECT `ulqx5_virtuemart_shoppergroups`.* FROM `ulqx5_virtuemart_shoppergroups` WHERE `ulqx5_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"
136μs2.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySHOW FULL COLUMNS FROM `ulqx5_virtuemart_userfields`
613μs1.89KB/administrator/components/com_virtuemart/helpers/vmtable.php:787CopySELECT * FROM `ulqx5_virtuemart_userfields` WHERE 1 = 1 AND `account`="1" AND published = 1 AND FIND_IN_SET(name, 'address_type') = 0 ORDER BY ordering
274μs4.92KB/administrator/components/com_virtuemart/helpers/vmmodel.php:515CopySELECT * 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 ordering
200μs4.8KB/administrator/components/com_virtuemart/helpers/vmmodel.php:515CopySELECT `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` = "1108"
209μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1108" ORDER BY `ordering`
129μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1108"
114μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ulqx5_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1108" 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-15 23:02:52" )
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-15 23:02:52" ) ) ORDER BY `product_price` DESC
172μs2.36KB/administrator/components/com_virtuemart/models/product.php:1589CopySELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1108"
117μs3.01KB/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1108
121μs704B/administrator/components/com_virtuemart/models/product.php:2191CopySELECT `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` = "1100"
182μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1100" ORDER BY `ordering`
111μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1100"
109μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ulqx5_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1100" 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-15 23:02:52" )
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-15 23:02:52" ) ) ORDER BY `product_price` DESC
159μs2.38KB/administrator/components/com_virtuemart/models/product.php:1589CopySELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1100"
118μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1100
119μs704B/administrator/components/com_virtuemart/models/product.php:2191CopySELECT `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` = "2"
151μs2.56KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySELECT `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"
182μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_product_medias` WHERE `virtuemart_product_id` = "9" ORDER BY `ordering`
119μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_shoppergroup_id` FROM `ulqx5_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "9"
108μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * 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-15 23:02:52" )
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-15 23:02:52" ) ) ORDER BY `product_price` DESC
198μs2.38KB/administrator/components/com_virtuemart/models/product.php:1589CopySELECT `virtuemart_manufacturer_id` FROM `ulqx5_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "9"
117μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `ulqx5_virtuemart_product_categories` WHERE `virtuemart_product_id` = 9
111μs688B/administrator/components/com_virtuemart/models/product.php:2191CopySELECT `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"
137μs2.56KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySELECT 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 (1108,1100,9) AND c.`published` = "1" ORDER BY field.`ordering` ASC
199μs4.64KB/administrator/components/com_virtuemart/models/customfields.php:163CopySELECT * 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"
196μs4.63KB/administrator/components/com_virtuemart/models/vendor.php:316CopySELECT `ulqx5_virtuemart_currencies`.* FROM `ulqx5_virtuemart_currencies` WHERE `ulqx5_virtuemart_currencies`.`virtuemart_currency_id` = "47"
158μs2.72KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySELECT 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-15 19:02:52" )
AND ( ( ISNULL(`publish_down`) or `publish_down`="0000-00-00 00:00:00") OR publish_down >= "2025-05-15 19:02:52" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL) ORDER BY c.ordering
250μs3.11KB/administrator/components/com_virtuemart/helpers/calculationh.php:174CopySELECT `virtuemart_category_id` FROM ulqx5_virtuemart_calc_categories WHERE `virtuemart_calc_id`="1"
121μs616B/administrator/components/com_virtuemart/helpers/calculationh.php:1307CopySELECT `virtuemart_category_id` FROM ulqx5_virtuemart_calc_categories WHERE `virtuemart_calc_id`="3"
105μs536B/administrator/components/com_virtuemart/helpers/calculationh.php:1307CopySELECT `virtuemart_category_id` FROM ulqx5_virtuemart_calc_categories WHERE `virtuemart_calc_id`="4"
107μs536B/administrator/components/com_virtuemart/helpers/calculationh.php:1307CopySELECT `virtuemart_category_id` FROM ulqx5_virtuemart_calc_categories WHERE `virtuemart_calc_id`="2"
106μs536B/administrator/components/com_virtuemart/helpers/calculationh.php:1307CopySELECT `ulqx5_virtuemart_ratings`.* FROM `ulqx5_virtuemart_ratings` WHERE `ulqx5_virtuemart_ratings`.`virtuemart_product_id` = "1108"
123μs1.34KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySELECT `ulqx5_virtuemart_medias`.* FROM `ulqx5_virtuemart_medias` WHERE `ulqx5_virtuemart_medias`.`virtuemart_media_id` = "20"
141μs2.78KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySELECT p.`virtuemart_product_id`, `pc`.ordering, `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`
WHERE ( `pc`.`virtuemart_category_id` IN (3) AND
`c`.`published` = 1 AND
( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND
p.`published`="1" ) AND p.`virtuemart_product_id`!="1108"
AND `pc`.ordering >= "24"
ORDER BY `pc`.ordering ASC, `l`.product_name ASC, `p`.virtuemart_product_id ASC LIMIT 1
282μs656B/administrator/components/com_virtuemart/models/product.php:2549CopySELECT p.`virtuemart_product_id`, `pc`.ordering, `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`
WHERE ( `pc`.`virtuemart_category_id` IN (3) AND
`c`.`published` = 1 AND
( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND
p.`published`="1" ) AND p.`virtuemart_product_id`!="1108"
AND p.`virtuemart_product_id`!="1107" AND `pc`.ordering <= "24"
ORDER BY `pc`.ordering DESC, `l`.product_name DESC, `p`.virtuemart_product_id DESC LIMIT 1
264μs656B/administrator/components/com_virtuemart/models/product.php:2549CopySELECT `virtuemart_media_id` FROM `ulqx5_virtuemart_manufacturer_medias` WHERE `virtuemart_manufacturer_id` = "2" ORDER BY `ordering`
134μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `ulqx5_virtuemart_medias`.* FROM `ulqx5_virtuemart_medias` WHERE `ulqx5_virtuemart_medias`.`virtuemart_media_id` = "5"
163μs2.78KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySELECT `ulqx5_virtuemart_medias`.* FROM `ulqx5_virtuemart_medias` WHERE `ulqx5_virtuemart_medias`.`virtuemart_media_id` = "10"
129μs2.78KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySELECT COLLATION_NAME from information_schema.columns where TABLE_SCHEMA = "joomla5_rubstudio_cz"
and TABLE_NAME = "ulqx5_users"
and COLUMN_NAME = "name";
322μs536B/administrator/components/com_virtuemart/models/ratings.php:95CopySELECT COLLATION_NAME from information_schema.columns where TABLE_SCHEMA = "joomla5_rubstudio_cz"
and TABLE_NAME = "ulqx5_virtuemart_rating_reviews"
and COLUMN_NAME = "customer";
288μs11.52KB/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 utf8mb4_unicode_ci) AS customer FROM `ulqx5_virtuemart_rating_reviews` AS `pr`
INNER JOIN `ulqx5_virtuemart_products_cs_cz` AS `l` ON `l`.`virtuemart_product_id` = `pr`.`virtuemart_product_id` LEFT JOIN `ulqx5_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 `ulqx5_users` AS `u` ON `pr`.`created_by` = `u`.`id`
WHERE `pr`.`virtuemart_product_id` = "1108"
ORDER BY created_on DESC LIMIT 3
354μs4.86KB/administrator/components/com_virtuemart/helpers/vmmodel.php:892CopySELECT 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 ASC
310μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT 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 ulqx5_virtuemart_shipmentmethods as i
LEFT JOIN `ulqx5_virtuemart_shipmentmethods_cs_cz` as l ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`
LEFT JOIN `ulqx5_extensions` as j ON j.`extension_id` = i.`shipment_jplugin_id`
LEFT OUTER JOIN `ulqx5_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` ASC
472μs4.56KB/administrator/components/com_virtuemart/plugins/vmpsplugin.php:513CopySELECT `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` = "1007"
277μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySELECT `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` = "1107"
201μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1135CopySELECT l.slug FROM `ulqx5_virtuemart_manufacturers_cs_cz` as l WHERE l.virtuemart_manufacturer_id = "2"
137μs536B/components/com_virtuemart/router.php:1652CopySELECT * FROM `ulqx5_virtuemart_ratings` WHERE `virtuemart_product_id` = "1108" AND `published`="1"
222μs1.34KB/administrator/components/com_virtuemart/models/ratings.php:293CopySELECT `language`,`id`
FROM `ulqx5_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
200μs624B/libraries/src/Language/Multilanguage.php:123CopySELECT *
FROM ulqx5_jmap_metainfo
WHERE `linkurl` = 'https://joomla5.rubstudio.cz/cs/vm/pagination/ghd-8-24-detail.html?print=1&tmpl=component'
AND `published` = 1
199μs912B/plugins/system/jmap/jmap.php:769CopySELECT *
FROM ulqx5_jmap_canonicals
WHERE `linkurl` = 'https://joomla5.rubstudio.cz/cs/vm/pagination/ghd-8-24-detail.html?print=1&tmpl=component'
118μs640B/plugins/system/jmap/jmap.php:871CopySELECT 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` = 1
191μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `value` FROM ulqx5_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
206μs536B/plugins/system/acymtriggers/acymtriggers.php:434CopySELECT * FROM ulqx5_acym_configuration
206μs2.31KB/administrator/components/com_acym/Core/joomla/database.php:36CopySHOW TABLES
991μs4.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:635CopySELECT * FROM ulqx5_acym_plugin
200μs2.08KB/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT * FROM ulqx5_acym_plugin
162μs2.08KB/administrator/components/com_acym/Core/joomla/database.php:36CopySHOW TABLES
756μs4.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:635CopySELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM ulqx5_usergroups AS `groups`
145μs1.02KB/administrator/components/com_acym/Core/joomla/database.php:36CopySELECT *
FROM ulqx5_jmap_headings
WHERE `linkurl` = 'https://joomla5.rubstudio.cz/cs/vm/pagination/ghd-8-24-detail.html?print=1&tmpl=component'
121μs752B/plugins/system/jmap/jmap.php:1086CopySELECT
`original_text`,
`target_text`,
`original_text_regex`,
`target_text_regex`
FROM
`ulqx5_jmap_text_replacements`
WHERE
`published` = 1
125μs688B/plugins/system/jmap/jmap.php:465CopySELECT `session_id`
FROM `ulqx5_session`
WHERE `session_id` = ?
130μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `ulqx5_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
327μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy