Joomla! Version | 4.3.4 |
PHP Version | 8.2.26 |
Identity | guest |
Response | 200 |
Template | astroid_template_zero |
Database |
|
1 x afterRenderComponent com_virtuemart (4.22MB) (44.77%) | 69.91ms |
1 x afterInitialise (4.31MB) (14.71%) | 22.98ms |
1 x beforeRenderRawModule mod_menu (Info) (888.09KB) (10.38%) | 16.21ms |
1 x afterRender (631.32KB) (5.79%) | 9.04ms |
1 x afterRoute (613.16KB) (3.91%) | 6.10ms |
1 x Before Access::preloadComponents (all components) (437.18KB) (2.88%) | 4.49ms |
1 x afterRenderRawModule mod_virtuemart_cart (Ostukorv) (202.09KB) (2.42%) | 3.78ms |
1 x afterRenderRawModule mod_menu (Info) (138.9KB) (1.43%) | 2.23ms |
1 x afterLoad (515.38KB) (1.13%) | 1.77ms |
1 x afterRenderRawModule mod_menu (Ostjale) (110.22KB) (0.71%) | 1.11ms |
1 x afterDispatch (46.01KB) (0.7%) | 1.09ms |
1 x After Access::preloadComponents (all components) (129.54KB) (0.66%) | 1.03ms |
1 x afterRenderRawModule mod_menu (E-pood) (120.95KB) (0.59%) | 928μs |
1 x afterRenderRawModule mod_custom (Otsingukomponent) (12.55KB) (0.34%) | 530μs |
1 x beforeRenderComponent com_virtuemart (32.95KB) (0.24%) | 378μs |
1 x afterRenderRawModule mod_custom (Kasutaja) (9.7KB) (0.1%) | 160μs |
1 x beforeRenderRawModule mod_menu (E-pood) (6.17KB) (0.08%) | 127μs |
1 x beforeRenderRawModule mod_menu (Ostjale) (6.19KB) (0.07%) | 115μs |
1 x afterRenderModule mod_menu (Info) (3.02KB) (0.07%) | 106μs |
1 x beforeRenderRawModule mod_custom (Otsingukomponent) (4.42KB) (0.07%) | 105μs |
1 x afterRenderModule mod_virtuemart_cart (Ostukorv) (2.38KB) (0.04%) | 59μs |
1 x After Access::getAssetRules (id:1 name:root.1) (6.7KB) (0.03%) | 54μs |
1 x afterRenderModule mod_menu (E-pood) (2.65KB) (0.03%) | 46μs |
1 x afterRenderModule mod_menu (Ostjale) (2.34KB) (0.03%) | 42μs |
1 x afterRenderModule mod_custom (Otsingukomponent) (2.26KB) (0.03%) | 40μs |
1 x afterRenderModule mod_custom (Kasutaja) (2.24KB) (0.02%) | 34μs |
1 x beforeRenderRawModule mod_custom (Kasutaja) (360B) (0.01%) | 20μs |
1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0.01%) | 16μs |
1 x Before Access::getAssetRules (id:492 name:com_virtuemart) (776B) (0.01%) | 13μs |
1 x beforeRenderRawModule mod_virtuemart_cart (Ostukorv) (104B) (0.01%) | 13μs |
1 x beforeRenderModule mod_menu (Info) (704B) (0.01%) | 8μs |
1 x beforeRenderModule mod_menu (E-pood) (704B) (0%) | 6μs |
1 x beforeRenderModule mod_custom (Otsingukomponent) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_virtuemart_cart (Ostukorv) (720B) (0%) | 6μs |
1 x After Access::getAssetRules (id:492 name:com_virtuemart) (1.45KB) (0%) | 5μs |
1 x beforeRenderModule mod_menu (Ostjale) (704B) (0%) | 5μs |
1 x beforeRenderModule mod_custom (Kasutaja) (720B) (0%) | 4μs |
SELECT @@SESSION.sql_mode;
103μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `paj86_session`
WHERE `session_id` = ?
131μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `paj86_session`
WHERE `session_id` = :session_id LIMIT 1
161μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `paj86_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
275μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `paj86_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
318μs1.73KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `paj86_viewlevels`
183μs656B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `paj86_usergroups` AS `a`
LEFT JOIN `paj86_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
202μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `paj86_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
684μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `template`
FROM `paj86_template_styles`
WHERE `client_id` = 0 AND `home` = 1
251μs1.15KB/components/com_sppagebuilder/parser/addon-parser.php:1273CopySELECT *
FROM `paj86_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
211μs1.59KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `element`,`name`,`client_id`,`extension_id`
FROM `paj86_extensions`
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1
224μs1008B/libraries/src/Language/LanguageHelper.php:213CopySELECT `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 `paj86_menu` AS `m`
LEFT JOIN `paj86_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id`
WHERE
(
(`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2)
ORDER BY `m`.`lft`
1.07ms116.17KBParams/libraries/src/Menu/SiteMenu.php:166CopySHOW TABLES LIKE "paj86_virtuemart_configs"
545μs536B/administrator/components/com_virtuemart/helpers/vmtable.php:797CopySELECT `config` FROM `paj86_virtuemart_configs` WHERE `virtuemart_config_id` = "1";
182μs536B/administrator/components/com_virtuemart/helpers/config.php:454CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `paj86_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,:preparedArray45,:preparedArray46)
502μs7.81KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `paj86_template_styles` AS `s`
LEFT JOIN `paj86_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
252μs864B/administrator/components/com_templates/src/Model/StyleModel.php:771CopySELECT * FROM `paj86_menu` WHERE `link` like "index.php?option=com_virtuemart%" and (language="*" or language = "et-EE" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC
350μs20.23KB/components/com_virtuemart/router.php:1659CopySELECT l.virtuemart_product_id FROM `paj86_virtuemart_products_et_ee` as l WHERE l.slug = "ocean-eyes-enamel-euphoria-silver-ripatsid"
165μs536B/components/com_virtuemart/router.php:1587CopySELECT * FROM `paj86_virtuemart_shoppergroups` WHERE `default` = "2" AND (`virtuemart_vendor_id` = "1" OR `shared` = "1") AND `published`="1"
214μs2.38KB/administrator/components/com_virtuemart/models/shoppergroup.php:101CopySELECT `paj86_virtuemart_shoppergroups`.* FROM `paj86_virtuemart_shoppergroups` WHERE `paj86_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"
139μs2.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1127CopySHOW FULL COLUMNS FROM `paj86_virtuemart_userfields`
647μs1.77KB/administrator/components/com_virtuemart/helpers/vmtable.php:758CopySELECT * FROM `paj86_virtuemart_userfields` WHERE 1 = 1 AND `account`="1" AND published = 1 AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0 ORDER BY ordering
236μs3.22KB/administrator/components/com_virtuemart/helpers/vmmodel.php:505CopySELECT * FROM `paj86_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
213μs3.14KB/administrator/components/com_virtuemart/helpers/vmmodel.php:505CopySELECT `paj86_virtuemart_products`.* ,`paj86_virtuemart_products_et_ee`.* FROM `paj86_virtuemart_products` INNER JOIN `paj86_virtuemart_products_et_ee` ON `paj86_virtuemart_products`.`virtuemart_product_id` = `paj86_virtuemart_products_et_ee`.`virtuemart_product_id` WHERE `paj86_virtuemart_products`.`virtuemart_product_id` = "1693"
310μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1127CopySELECT `virtuemart_media_id` FROM `paj86_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1693" ORDER BY `ordering`
142μs568B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `paj86_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1693" 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-01-01 20:06:06" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-01 20:06:06" ) ) ORDER BY `product_price` DESC
324μs2.5KB/administrator/components/com_virtuemart/models/product.php:1528CopySELECT * FROM `paj86_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1693
169μs752B/administrator/components/com_virtuemart/models/product.php:2124CopySELECT `paj86_virtuemart_categories`.* ,`paj86_virtuemart_categories_et_ee`.* FROM `paj86_virtuemart_categories` INNER JOIN `paj86_virtuemart_categories_et_ee` ON `paj86_virtuemart_categories`.`virtuemart_category_id` = `paj86_virtuemart_categories_et_ee`.`virtuemart_category_id` WHERE `paj86_virtuemart_categories`.`virtuemart_category_id` = "50"
198μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1127CopySELECT `paj86_virtuemart_categories`.* ,`paj86_virtuemart_categories_et_ee`.* FROM `paj86_virtuemart_categories` INNER JOIN `paj86_virtuemart_categories_et_ee` ON `paj86_virtuemart_categories`.`virtuemart_category_id` = `paj86_virtuemart_categories_et_ee`.`virtuemart_category_id` WHERE `paj86_virtuemart_categories`.`virtuemart_category_id` = "54"
186μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1127CopySELECT `paj86_virtuemart_categories`.* ,`paj86_virtuemart_categories_et_ee`.* FROM `paj86_virtuemart_categories` INNER JOIN `paj86_virtuemart_categories_et_ee` ON `paj86_virtuemart_categories`.`virtuemart_category_id` = `paj86_virtuemart_categories_et_ee`.`virtuemart_category_id` WHERE `paj86_virtuemart_categories`.`virtuemart_category_id` = "103"
177μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1127CopySELECT `paj86_virtuemart_categories`.* ,`paj86_virtuemart_categories_et_ee`.* FROM `paj86_virtuemart_categories` INNER JOIN `paj86_virtuemart_categories_et_ee` ON `paj86_virtuemart_categories`.`virtuemart_category_id` = `paj86_virtuemart_categories_et_ee`.`virtuemart_category_id` WHERE `paj86_virtuemart_categories`.`virtuemart_category_id` = "109"
160μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1127CopySELECT 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 `paj86_virtuemart_customs` AS c LEFT JOIN `paj86_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (1693) AND c.`published` = "1" ORDER BY field.`ordering` ASC
229μs4.64KB/administrator/components/com_virtuemart/models/customfields.php:163CopySELECT * FROM `paj86_virtuemart_currencies` AS c
LEFT JOIN `paj86_virtuemart_vendors` AS v ON c.virtuemart_currency_id = v.vendor_currency
WHERE v.virtuemart_vendor_id = "1"
221μs7.13KB/administrator/components/com_virtuemart/models/vendor.php:316CopySELECT `paj86_virtuemart_currencies`.* FROM `paj86_virtuemart_currencies` WHERE `paj86_virtuemart_currencies`.`virtuemart_currency_id` = "47"
132μs2.72KB/administrator/components/com_virtuemart/helpers/vmtable.php:1127CopySELECT c.* FROM paj86_virtuemart_calcs as c LEFT JOIN paj86_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-01-01 16:06:06" )
AND ( ( ISNULL(`publish_down`) or `publish_down`="0000-00-00 00:00:00") OR publish_down >= "2025-01-01 16:06:06" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
337μs3.06KB/administrator/components/com_virtuemart/helpers/calculationh.php:174CopySELECT `virtuemart_category_id` FROM paj86_virtuemart_calc_categories WHERE `virtuemart_calc_id`="10"
169μs552B/administrator/components/com_virtuemart/helpers/calculationh.php:1304CopySELECT `virtuemart_shoppergroup_id` FROM paj86_virtuemart_calc_shoppergroups WHERE `virtuemart_calc_id`="10"
220μs552B/administrator/components/com_virtuemart/helpers/calculationh.php:1326CopySELECT `paj86_virtuemart_ratings`.* FROM `paj86_virtuemart_ratings` WHERE `paj86_virtuemart_ratings`.`virtuemart_product_id` = "1693"
164μs1.33KB/administrator/components/com_virtuemart/helpers/vmtable.php:1127CopySELECT `paj86_virtuemart_medias`.* FROM `paj86_virtuemart_medias` WHERE `paj86_virtuemart_medias`.`virtuemart_media_id` = "3061"
241μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1127CopySELECT `paj86_virtuemart_medias`.* FROM `paj86_virtuemart_medias` WHERE `paj86_virtuemart_medias`.`virtuemart_media_id` = "3062"
236μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1127CopySELECT `paj86_virtuemart_medias`.* FROM `paj86_virtuemart_medias` WHERE `paj86_virtuemart_medias`.`virtuemart_media_id` = "3063"
267μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1127CopySELECT p.`virtuemart_product_id`, `pc`.ordering, `l`.product_name FROM `paj86_virtuemart_products` as p
LEFT JOIN `paj86_virtuemart_products_et_ee` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id` LEFT JOIN `paj86_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `paj86_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `paj86_virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
WHERE ( p.`product_in_stock` - p.`product_ordered` >"0" AND
`pc`.`virtuemart_category_id` IN (103) 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`!="1693"
AND `pc`.ordering >= "0"
ORDER BY `pc`.ordering ASC, `l`.product_name ASC, `p`.virtuemart_product_id ASC LIMIT 1
2.48ms656B/administrator/components/com_virtuemart/models/product.php:2479CopySELECT p.`virtuemart_product_id`, `pc`.ordering, `l`.product_name FROM `paj86_virtuemart_products` as p
LEFT JOIN `paj86_virtuemart_products_et_ee` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id` LEFT JOIN `paj86_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `paj86_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `paj86_virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
WHERE ( p.`product_in_stock` - p.`product_ordered` >"0" AND
`pc`.`virtuemart_category_id` IN (103) 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`!="1693"
AND p.`virtuemart_product_id`!="1864" AND `pc`.ordering <= "0"
ORDER BY `pc`.ordering DESC, `l`.product_name DESC, `p`.virtuemart_product_id DESC LIMIT 1
1.73ms656B/administrator/components/com_virtuemart/models/product.php:2479CopySELECT `virtuemart_media_id` FROM `paj86_virtuemart_category_medias` WHERE `virtuemart_category_id` = "103" ORDER BY `ordering`
175μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT id FROM `paj86_menu` WHERE `link` like "index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=1693%" and (language="*" or language = "et-EE" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC
279μs520B/components/com_virtuemart/router.php:2004CopySELECT id FROM `paj86_menu` WHERE `link` like "index.php?option=com_virtuemart&view=category&virtuemart_category_id=109&virtuemart_manufacturer_id=0%" and (language="*" or language = "et-EE" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC
237μs520B/components/com_virtuemart/router.php:2004CopySELECT id FROM `paj86_menu` WHERE `link` like "index.php?option=com_virtuemart&view=category&virtuemart_category_id=0&virtuemart_manufacturer_id=0%" and (language="*" or language = "et-EE" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC
334μs520B/components/com_virtuemart/router.php:2004CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM paj86_virtuemart_categories
WHERE `virtuemart_category_id`= 109
142μs592B/administrator/components/com_virtuemart/models/category.php:1095CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM paj86_virtuemart_categories
WHERE `virtuemart_category_id`= 54
112μs592B/administrator/components/com_virtuemart/models/category.php:1095CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM paj86_virtuemart_categories
WHERE `virtuemart_category_id`= 109
91μs592B/administrator/components/com_virtuemart/models/category.php:1095CopySELECT `virtuemart_media_id` FROM `paj86_virtuemart_category_medias` WHERE `virtuemart_category_id` = "109" ORDER BY `ordering`
141μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM paj86_virtuemart_categories
WHERE `virtuemart_category_id`= 109
51μs592B/administrator/components/com_virtuemart/models/category.php:1095CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM paj86_virtuemart_categories
WHERE `virtuemart_category_id`= 54
51μs592B/administrator/components/com_virtuemart/models/category.php:1095CopySELECT l.virtuemart_category_id, l.category_name, published FROM `paj86_virtuemart_categories` as c LEFT JOIN `paj86_virtuemart_categories_et_ee` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE l.virtuemart_category_id = 54
131μs656B/administrator/components/com_virtuemart/models/category.php:1041CopySELECT l.virtuemart_category_id, l.category_name, published FROM `paj86_virtuemart_categories` as c LEFT JOIN `paj86_virtuemart_categories_et_ee` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE l.virtuemart_category_id = 109
146μs656B/administrator/components/com_virtuemart/models/category.php:1041CopySELECT 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 paj86_fields AS a
LEFT JOIN `paj86_languages` AS l ON l.lang_code = a.language
LEFT JOIN paj86_users AS uc ON uc.id=a.checked_out
LEFT JOIN paj86_viewlevels AS ag ON ag.id = a.access
LEFT JOIN paj86_users AS ua ON ua.id = a.created_user_id
LEFT JOIN paj86_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
1.11ms4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT 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 paj86_virtuemart_shipmentmethods as i
LEFT JOIN `paj86_virtuemart_shipmentmethods_et_ee` as l ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`
LEFT JOIN `paj86_extensions` as j ON j.`extension_id` = i.`shipment_jplugin_id`
LEFT OUTER JOIN `paj86_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`
1.44ms4.59KB/administrator/components/com_virtuemart/plugins/vmpsplugin.php:498CopySELECT id FROM `paj86_menu` WHERE `link` like "index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=1704%" and (language="*" or language = "et-EE" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC
358μs520B/components/com_virtuemart/router.php:2004CopySELECT id FROM `paj86_menu` WHERE `link` like "index.php?option=com_virtuemart&view=category&virtuemart_category_id=103&virtuemart_manufacturer_id=0%" and (language="*" or language = "et-EE" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC
352μs536B/components/com_virtuemart/router.php:2004CopySELECT `paj86_virtuemart_products`.* ,`paj86_virtuemart_products_et_ee`.* FROM `paj86_virtuemart_products` INNER JOIN `paj86_virtuemart_products_et_ee` ON `paj86_virtuemart_products`.`virtuemart_product_id` = `paj86_virtuemart_products_et_ee`.`virtuemart_product_id` WHERE `paj86_virtuemart_products`.`virtuemart_product_id` = "1704"
277μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1127CopySELECT id FROM `paj86_menu` WHERE `link` like "index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=1864%" and (language="*" or language = "et-EE" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC
318μs520B/components/com_virtuemart/router.php:2004CopySELECT `paj86_virtuemart_products`.* ,`paj86_virtuemart_products_et_ee`.* FROM `paj86_virtuemart_products` INNER JOIN `paj86_virtuemart_products_et_ee` ON `paj86_virtuemart_products`.`virtuemart_product_id` = `paj86_virtuemart_products_et_ee`.`virtuemart_product_id` WHERE `paj86_virtuemart_products`.`virtuemart_product_id` = "1864"
327μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1127CopySELECT id FROM `paj86_menu` WHERE `link` like "index.php?option=com_virtuemart&virtuemart_product_id=0%" and (language="*" or language = "et-EE" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC
317μs520B/components/com_virtuemart/router.php:2004CopySELECT id FROM `paj86_menu` WHERE `link` like "index.php?option=com_virtuemart&view=category&virtuemart_category_id=0&virtuemart_manufacturer_id=0%" and (language="*" or language = "et-EE" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC
66μs520B/components/com_virtuemart/router.php:2004CopySELECT * FROM `paj86_virtuemart_ratings` WHERE `virtuemart_product_id` = "1693" AND `published`="1"
132μs12.33KB/administrator/components/com_virtuemart/models/ratings.php:293CopySELECT `language`,`id`
FROM `paj86_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
209μs704B/libraries/src/Language/Multilanguage.php:123CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `paj86_modules` AS `m`
LEFT JOIN `paj86_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `paj86_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`
531μs2KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT * FROM paj86_virtuemart_calcs LEFT JOIN paj86_virtuemart_calc_shoppergroups using(virtuemart_calc_id)WHERE
`calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-01-01 18:06:06" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-01-01 18:06:06" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
424μs3.11KB/administrator/components/com_virtuemart/helpers/calculationh.php:1520CopySELECT * FROM paj86_virtuemart_calcs LEFT JOIN paj86_virtuemart_calc_shoppergroups using(virtuemart_calc_id)WHERE
`calc_kind`="TaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-01-01 18:06:06" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-01-01 18:06:06" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
391μs3.11KB/administrator/components/com_virtuemart/helpers/calculationh.php:1520CopySELECT * FROM paj86_virtuemart_calcs LEFT JOIN paj86_virtuemart_calc_shoppergroups using(virtuemart_calc_id)WHERE
`calc_kind`="DATaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-01-01 18:06:06" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-01-01 18:06:06" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
286μs3.11KB/administrator/components/com_virtuemart/helpers/calculationh.php:1520CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor`
FROM `paj86_scheduler_tasks` AS `a`
LEFT JOIN `paj86_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now
ORDER BY `a`.`title` asc
577μs3.2KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor`
FROM `paj86_scheduler_tasks` AS `a`
LEFT JOIN `paj86_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL
ORDER BY `a`.`title` asc
379μs3.18KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy