Secure payment and ( soon )
L4P - Copyright 2020 | rue Haute Wez 79, 4030 Grivegnée - Tél : +32 (0)476 07 14 91 - Email :
Joomla! Version | 4.4.2 |
PHP Version | 8.3.10 |
Identity | guest |
Response | 200 |
Template | yootheme |
Database |
|
1 x afterRenderComponent com_virtuemart (2.72MB) (23.36%) | 50.13ms |
1 x afterRenderRawModule mod_cf_filtering (CF Filtering Module) (1.11MB) (18.85%) | 40.45ms |
1 x afterRoute (1.83MB) (7.63%) | 16.38ms |
1 x afterRenderRawModule mod_menu (Main Menu (EN)) (615.22KB) (7.29%) | 15.64ms |
1 x beforeRenderRawModule mod_yootheme_builder (Footer (EN)) (830.22KB) (6.84%) | 14.67ms |
1 x Before Access::preloadComponents (all components) (980.74KB) (6.71%) | 14.40ms |
1 x afterRenderRawModule mod_virtuemart_cart (Panier) (489.97KB) (4.01%) | 8.60ms |
1 x afterInitialise (367.3KB) (3.54%) | 7.60ms |
1 x afterRender (218.02KB) (3.18%) | 6.81ms |
1 x afterRenderRawModule mod_menu (Main Menu (Mobile) (EN)) (17.07KB) (2.49%) | 5.34ms |
1 x afterRenderRawModule mod_yootheme_builder (Footer (EN)) (56.55KB) (2.41%) | 5.17ms |
1 x afterDispatch (136.47KB) (1.59%) | 3.40ms |
1 x afterRenderRawModule mod_menu (Menu Produits (EN)) (339.05KB) (1.25%) | 2.69ms |
1 x beforeRenderModule mod_cf_filtering (CF Filtering Module) (202.99KB) (1.12%) | 2.40ms |
1 x afterRenderRawModule mod_custom () (26.56KB) (1.08%) | 2.31ms |
1 x afterRenderRawModule mod_languages (Changement de langue) (10.02KB) (0.84%) | 1.81ms |
1 x beforeRenderRawModule mod_menu (Menu corporate (EN)) (107.89KB) (0.84%) | 1.79ms |
1 x afterRenderRawModule mod_menu (Menu corporate (EN)) (62.27KB) (0.79%) | 1.69ms |
1 x beforeRenderRawModule mod_custom (User (connexion)) (9.15KB) (0.61%) | 1.31ms |
1 x afterRenderRawModule mod_languages (Changement de langue (mobile)) (2.16KB) (0.56%) | 1.19ms |
1 x afterRenderRawModule mod_menu (Menu GDPR (EN)) (53.38KB) (0.48%) | 1.04ms |
1 x afterLoad (456.55KB) (0.39%) | 844μs |
1 x beforeRenderRawModule mod_custom () (1.74KB) (0.38%) | 826μs |
1 x beforeRenderRawModule mod_cf_search (CF Product search) (1.12KB) (0.27%) | 580μs |
1 x After Access::preloadComponents (all components) (130.88KB) (0.26%) | 550μs |
1 x beforeRenderComponent com_virtuemart (14.35KB) (0.21%) | 454μs |
1 x afterRenderRawModule mod_cf_search (CF Product search) (5.61KB) (0.21%) | 449μs |
1 x beforeRenderRawModule mod_custom (User (connexion) (mobile)) (10.81KB) (0.17%) | 355μs |
1 x afterRenderRawModule mod_virtuemart_cart (Panier (mobile)) (1.42KB) (0.14%) | 306μs |
1 x afterRenderRawModule mod_yootheme_builder (Affiner ma recherche - top CF) (91.63KB) (0.14%) | 299μs |
1 x beforeRenderRawModule mod_yootheme_builder (Affiner ma recherche - top CF) (23.13KB) (0.14%) | 297μs |
1 x afterRenderModule mod_cf_filtering (CF Filtering Module) (1.27KB) (0.13%) | 288μs |
1 x beforeRenderRawModule mod_languages (Changement de langue (mobile)) (1.99KB) (0.12%) | 257μs |
1 x beforeRenderRawModule mod_custom () (4.55KB) (0.11%) | 236μs |
1 x afterRenderRawModule mod_cf_search (CF Product search (Mobile)) (1.66KB) (0.11%) | 232μs |
1 x beforeRenderRawModule mod_custom () (2.52KB) (0.11%) | 227μs |
1 x afterRenderRawModule mod_custom () (864B) (0.1%) | 211μs |
1 x beforeRenderRawModule mod_cf_filtering (CF Filtering Module) (40.62KB) (0.1%) | 206μs |
1 x beforeRenderRawModule mod_menu (Main Menu (EN)) (12.4KB) (0.09%) | 191μs |
1 x afterRenderModule mod_menu (Menu corporate (EN)) (3.16KB) (0.08%) | 167μs |
1 x afterRenderModule mod_custom () (1.23KB) (0.08%) | 167μs |
1 x afterRenderRawModule mod_custom () (1008B) (0.08%) | 163μs |
1 x afterRenderModule mod_cf_search (CF Product search (Mobile)) (1.28KB) (0.07%) | 160μs |
1 x afterRenderModule mod_virtuemart_cart (Panier) (1.25KB) (0.07%) | 155μs |
1 x afterRenderModule mod_languages (Changement de langue (mobile)) (3.78KB) (0.06%) | 138μs |
1 x afterRenderModule mod_yootheme_builder (Footer (EN)) (1.25KB) (0.06%) | 122μs |
1 x afterRenderModule mod_languages (Changement de langue) (1.27KB) (0.06%) | 120μs |
1 x afterRenderModule mod_yootheme_builder (Affiner ma recherche - top CF) (1.27KB) (0.05%) | 107μs |
1 x afterRenderModule mod_custom (User (connexion)) (1.25KB) (0.05%) | 104μs |
1 x afterRenderModule mod_menu (Main Menu (Mobile) (EN)) (1.25KB) (0.05%) | 102μs |
1 x afterRenderModule mod_cf_search (CF Product search) (1.27KB) (0.04%) | 96μs |
1 x afterRenderRawModule mod_custom (User (connexion)) (1.09KB) (0.04%) | 91μs |
1 x beforeRenderRawModule mod_menu (Menu GDPR (EN)) (8.83KB) (0.04%) | 87μs |
1 x beforeRenderRawModule mod_menu (Menu Produits (EN)) (11.13KB) (0.04%) | 84μs |
1 x afterRenderRawModule mod_custom (User (connexion) (mobile)) (1.02KB) (0.04%) | 83μs |
1 x afterRenderModule mod_menu (Menu GDPR (EN)) (2.92KB) (0.03%) | 73μs |
1 x afterRenderModule mod_cf_filtering (CF Filtering Module) (9.93KB) (0.03%) | 73μs |
1 x afterRenderModule mod_menu (Main Menu (EN)) (10.3KB) (0.03%) | 72μs |
1 x afterRenderModule mod_menu (Menu Produits (EN)) (3.3KB) (0.03%) | 59μs |
1 x afterRenderModule mod_custom () (2.43KB) (0.02%) | 48μs |
1 x afterRenderModule mod_custom (User (connexion) (mobile)) (2.63KB) (0.02%) | 44μs |
1 x afterRenderModule mod_virtuemart_cart (Panier (mobile)) (2.8KB) (0.02%) | 44μs |
1 x afterRenderModule mod_custom () (2.49KB) (0.02%) | 43μs |
1 x beforeRenderRawModule mod_languages (Changement de langue) (1.89KB) (0.02%) | 40μs |
1 x After Access::getAssetRules (id:1 name:root.1) (6.7KB) (0.02%) | 35μs |
1 x beforeRenderRawModule mod_menu (Main Menu (Mobile) (EN)) (2.27KB) (0.02%) | 33μs |
1 x beforeRenderRawModule mod_cf_search (CF Product search (Mobile)) (96B) (0.01%) | 29μs |
1 x beforeRenderRawModule mod_virtuemart_cart (Panier) (272B) (0.01%) | 15μs |
3 x beforeRenderModule mod_custom () (704B) (0.01%) | 15μs |
1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0.01%) | 14μs |
1 x beforeRenderRawModule mod_virtuemart_cart (Panier (mobile)) (864B) (0.01%) | 14μs |
1 x beforeRenderModule mod_yootheme_builder (Affiner ma recherche - top CF) (736B) (0.01%) | 13μs |
1 x Before Access::getAssetRules (id:61 name:com_virtuemart) (776B) (0.01%) | 11μs |
1 x beforeRenderModule mod_menu (Main Menu (EN)) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_languages (Changement de langue (mobile)) (736B) (0%) | 7μs |
1 x beforeRenderModule mod_yootheme_builder (Footer (EN)) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_languages (Changement de langue) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_menu (Menu corporate (EN)) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_cf_filtering (CF Filtering Module) (736B) (0%) | 6μs |
1 x beforeRenderModule mod_virtuemart_cart (Panier) (720B) (0%) | 6μs |
1 x After Access::getAssetRules (id:61 name:com_virtuemart) (1.44KB) (0%) | 5μs |
1 x beforeRenderModule mod_menu (Menu Produits (EN)) (720B) (0%) | 5μs |
1 x beforeRenderModule mod_cf_search (CF Product search (Mobile)) (736B) (0%) | 5μs |
1 x beforeRenderModule mod_menu (Main Menu (Mobile) (EN)) (720B) (0%) | 5μs |
1 x beforeRenderModule mod_cf_search (CF Product search) (720B) (0%) | 5μs |
1 x beforeRenderModule mod_custom (User (connexion)) (720B) (0%) | 4μs |
1 x beforeRenderModule mod_virtuemart_cart (Panier (mobile)) (736B) (0%) | 4μs |
1 x beforeRenderModule mod_menu (Menu GDPR (EN)) (720B) (0%) | 4μs |
1 x beforeRenderModule mod_custom (User (connexion) (mobile)) (736B) (0%) | 3μs |
SELECT @@SESSION.sql_mode;
71μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `bn9fo_session`
WHERE `session_id` = ?
119μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `bn9fo_session`
WHERE `session_id` = :session_id LIMIT 1
58μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `bn9fo_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
2.54ms944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `bn9fo_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
266μs1.73KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `bn9fo_viewlevels`
76μs656B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `bn9fo_usergroups` AS `a`
LEFT JOIN `bn9fo_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
132μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `bn9fo_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
534μs4.48KBParams/libraries/src/Plugin/PluginHelper.php:294CopySHOW TABLES LIKE "bn9fo_virtuemart_configs"
463μs1.15KB/administrator/components/com_virtuemart/helpers/vmtable.php:820CopySELECT `config` FROM `bn9fo_virtuemart_configs` WHERE `virtuemart_config_id` = "1";
80μs536B/administrator/components/com_virtuemart/helpers/config.php:454CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `bn9fo_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,:preparedArray47)
313μs7.81KBParams/libraries/src/Access/Access.php:357CopySELECT *
FROM `bn9fo_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
114μs1.61KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `element`,`name`,`client_id`,`extension_id`
FROM `bn9fo_extensions`
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1
129μs784B/libraries/src/Language/LanguageHelper.php:213CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` = 'level'
77μs536B/plugins/system/acymtriggers/acymtriggers.php:505CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` = 'active_cron'
53μs536B/plugins/system/acymtriggers/acymtriggers.php:505CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` = 'cron_next'
52μs536B/plugins/system/acymtriggers/acymtriggers.php:505CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` = 'queue_type'
56μs1.77KB/plugins/system/acymtriggers/acymtriggers.php:505CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` = 'cron_frequency'
48μs536B/plugins/system/acymtriggers/acymtriggers.php:505CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` = 'queue_batch_auto'
47μs536B/plugins/system/acymtriggers/acymtriggers.php:505CopySELECT `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 `bn9fo_menu` AS `m`
LEFT JOIN `bn9fo_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`
827μs181.8KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `bn9fo_template_styles` AS `s`
LEFT JOIN `bn9fo_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
195μs864B/administrator/components/com_templates/src/Model/StyleModel.php:773CopySHOW TABLES
685μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT * FROM bn9fo_acym_configuration
209μs4.56KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM bn9fo_acym_plugin
113μs1.5KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'acychecker' LIMIT 1
74μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'acymailer' LIMIT 1
79μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'amazon' LIMIT 1
71μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'article' LIMIT 1
67μs1.47KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'birthday' LIMIT 1
71μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'brevo' LIMIT 1
70μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'createuser' LIMIT 1
71μs1.47KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM bn9fo_usergroups AS `groups`
59μs1.02KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'elasticemail' LIMIT 1
68μs3.95KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'forward' LIMIT 1
66μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'mailgun' LIMIT 1
69μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'module' LIMIT 1
69μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'online' LIMIT 1
70μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'override' LIMIT 1
67μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'phpmail' LIMIT 1
66μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'postmark' LIMIT 1
66μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'qmail' LIMIT 1
70μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'segment' LIMIT 1
70μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'sendgrid' LIMIT 1
66μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'sendinblue' LIMIT 1
65μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'luecredentials' LIMIT 1
73μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'lueintegration' LIMIT 1
70μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'luetransactional' LIMIT 1
67μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'luelist' LIMIT 1
66μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'lueusers' LIMIT 1
66μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'luesender' LIMIT 1
65μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'luecampaign' LIMIT 1
77μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'luewebhooks' LIMIT 1
83μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'sendmail' LIMIT 1
75μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'smtp' LIMIT 1
71μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'statistics' LIMIT 1
71μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'subscriber' LIMIT 1
70μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'subscription' LIMIT 1
65μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'time' LIMIT 1
69μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'user' LIMIT 1
66μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'virtuemart' LIMIT 1
67μs1.47KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'managetext' LIMIT 1
66μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM `bn9fo_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` DESC
543μs83.83KB/components/com_virtuemart/router.php:1661CopySELECT `bn9fo_virtuemart_categories`.* ,`bn9fo_virtuemart_categories_fr_fr`.* FROM `bn9fo_virtuemart_categories` INNER JOIN `bn9fo_virtuemart_categories_fr_fr` ON `bn9fo_virtuemart_categories`.`virtuemart_category_id` = `bn9fo_virtuemart_categories_fr_fr`.`virtuemart_category_id` WHERE `bn9fo_virtuemart_categories`.`virtuemart_category_id` = "57"
189μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_category_medias` WHERE `virtuemart_category_id` = "57" ORDER BY `ordering`
70μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_shoppergroups` WHERE `default` = "2" AND (`virtuemart_vendor_id` = "1" OR `shared` = "1") AND `published`="1"
183μs13.38KB/administrator/components/com_virtuemart/models/shoppergroup.php:101CopySELECT `bn9fo_virtuemart_shoppergroups`.* FROM `bn9fo_virtuemart_shoppergroups` WHERE `bn9fo_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"
133μs2.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySHOW FULL COLUMNS FROM `bn9fo_virtuemart_userfields`
477μs1.77KB/administrator/components/com_virtuemart/helpers/vmtable.php:781CopySELECT * FROM `bn9fo_virtuemart_userfields` WHERE 1 = 1 AND `account`="1" AND published = 1 AND FIND_IN_SET(name, 'address_type') = 0 ORDER BY ordering
356μs3.45KB/administrator/components/com_virtuemart/helpers/vmmodel.php:512CopySELECT * FROM `bn9fo_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
330μs3.33KB/administrator/components/com_virtuemart/helpers/vmmodel.php:512CopySELECT `product_stockhandle` FROM `bn9fo_virtuemart_products` WHERE `product_stockhandle` = "disableit_children" AND `published` = "1" LIMIT 1
3.71ms520B/administrator/components/com_virtuemart/models/product.php:999CopySELECT `product_stockhandle` FROM `bn9fo_virtuemart_products` WHERE `product_stockhandle` = "disableit" AND `published` = "1" LIMIT 1
2.61ms520B/administrator/components/com_virtuemart/models/product.php:1002CopySELECT 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 bn9fo_virtuemart_categories as c LEFT JOIN `bn9fo_virtuemart_categories_fr_fr` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE (c.`category_parent_id` = 57) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC
457μs2.77KB/administrator/components/com_virtuemart/models/category.php:409CopySELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`, l.product_name
FROM `bn9fo_virtuemart_products` as p
LEFT JOIN `bn9fo_virtuemart_products_fr_fr` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
LEFT JOIN `bn9fo_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `bn9fo_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
WHERE ( `pc`.`virtuemart_category_id` IN (57) AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `pc`.`ordering` ASC, `product_name` ASC LIMIT 24
349μs704B/administrator/components/com_virtuemart/helpers/vmmodel.php:876CopySELECT FOUND_ROWS()
71μs536B/administrator/components/com_virtuemart/helpers/vmmodel.php:890CopySELECT DISTINCT l.virtuemart_manufacturer_id, l.mf_name FROM `bn9fo_virtuemart_manufacturers_fr_fr` as l INNER JOIN `bn9fo_virtuemart_product_manufacturers` AS pm ON pm.`virtuemart_manufacturer_id` = l.`virtuemart_manufacturer_id` INNER JOIN `bn9fo_virtuemart_products` as p ON p.`virtuemart_product_id` = pm.`virtuemart_product_id` INNER JOIN `bn9fo_virtuemart_product_categories` as pc ON pc.`virtuemart_product_id` = pm.`virtuemart_product_id` WHERE p.`published` = "1" AND pc.`virtuemart_category_id` = "57" ORDER BY `mf_name`
247μs624B/administrator/components/com_virtuemart/models/manufacturer.php:222CopySELECT * FROM `bn9fo_menu` WHERE `link` like "index.php?option=com_virtuemart%" and (language="*" or language = "fr-FR" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC
646μs67.83KB/components/com_virtuemart/router.php:1661CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 57
70μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 9
51μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT `bn9fo_virtuemart_categories`.* ,`bn9fo_virtuemart_categories_fr_fr`.* FROM `bn9fo_virtuemart_categories` INNER JOIN `bn9fo_virtuemart_categories_fr_fr` ON `bn9fo_virtuemart_categories`.`virtuemart_category_id` = `bn9fo_virtuemart_categories_fr_fr`.`virtuemart_category_id` WHERE `bn9fo_virtuemart_categories`.`virtuemart_category_id` = "9"
127μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_category_medias` WHERE `virtuemart_category_id` = "9" ORDER BY `ordering`
39μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 9
77μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT l.virtuemart_category_id, l.category_name, published FROM `bn9fo_virtuemart_categories` as c LEFT JOIN `bn9fo_virtuemart_categories_fr_fr` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE l.virtuemart_category_id = 9
114μs656B/administrator/components/com_virtuemart/models/category.php:1040CopySELECT l.slug FROM `bn9fo_virtuemart_manufacturers_fr_fr` as l WHERE l.virtuemart_manufacturer_id = "53"
47μs536B/components/com_virtuemart/router.php:1587CopySELECT l.slug FROM `bn9fo_virtuemart_manufacturers_fr_fr` as l WHERE l.virtuemart_manufacturer_id = "139"
45μs536B/components/com_virtuemart/router.php:1587CopySELECT l.slug FROM `bn9fo_virtuemart_manufacturers_fr_fr` as l WHERE l.virtuemart_manufacturer_id = "138"
63μs536B/components/com_virtuemart/router.php:1587CopySELECT `bn9fo_virtuemart_products`.* ,`bn9fo_virtuemart_products_fr_fr`.* FROM `bn9fo_virtuemart_products` INNER JOIN `bn9fo_virtuemart_products_fr_fr` ON `bn9fo_virtuemart_products`.`virtuemart_product_id` = `bn9fo_virtuemart_products_fr_fr`.`virtuemart_product_id` WHERE `bn9fo_virtuemart_products`.`virtuemart_product_id` = "544"
262μs5.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "544" ORDER BY `ordering`
84μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "544" 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-05 08:16:15" )
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-05 08:16:15" ) ) ORDER BY `product_price` DESC
171μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 544
74μs720B/administrator/components/com_virtuemart/models/product.php:2133CopySELECT 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 `bn9fo_virtuemart_customs` AS c LEFT JOIN `bn9fo_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (544) AND c.`published` = "1" ORDER BY field.`ordering` ASC
148μs4.64KB/administrator/components/com_virtuemart/models/customfields.php:163CopySELECT * FROM `bn9fo_virtuemart_currencies` AS c
LEFT JOIN `bn9fo_virtuemart_vendors` AS v ON c.virtuemart_currency_id = v.vendor_currency
WHERE v.virtuemart_vendor_id = "1"
128μs4.63KB/administrator/components/com_virtuemart/models/vendor.php:316CopySELECT `bn9fo_virtuemart_currencies`.* FROM `bn9fo_virtuemart_currencies` WHERE `bn9fo_virtuemart_currencies`.`virtuemart_currency_id` = "47"
86μs2.72KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT c.* FROM bn9fo_virtuemart_calcs as c LEFT JOIN bn9fo_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-05 06:16:15" )
AND ( ( ISNULL(`publish_down`) or `publish_down`="0000-00-00 00:00:00") OR publish_down >= "2025-01-05 06:16:15" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
204μs3.11KB/administrator/components/com_virtuemart/helpers/calculationh.php:174CopySELECT `bn9fo_virtuemart_products`.* ,`bn9fo_virtuemart_products_fr_fr`.* FROM `bn9fo_virtuemart_products` INNER JOIN `bn9fo_virtuemart_products_fr_fr` ON `bn9fo_virtuemart_products`.`virtuemart_product_id` = `bn9fo_virtuemart_products_fr_fr`.`virtuemart_product_id` WHERE `bn9fo_virtuemart_products`.`virtuemart_product_id` = "965"
216μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "965" ORDER BY `ordering`
81μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "965" 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-05 08:16:15" )
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-05 08:16:15" ) ) ORDER BY `product_price` DESC
184μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 965
95μs720B/administrator/components/com_virtuemart/models/product.php:2133CopySELECT 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 `bn9fo_virtuemart_customs` AS c LEFT JOIN `bn9fo_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (965) AND c.`published` = "1" ORDER BY field.`ordering` ASC
149μs4.64KB/administrator/components/com_virtuemart/models/customfields.php:163CopySELECT `bn9fo_virtuemart_products`.* ,`bn9fo_virtuemart_products_fr_fr`.* FROM `bn9fo_virtuemart_products` INNER JOIN `bn9fo_virtuemart_products_fr_fr` ON `bn9fo_virtuemart_products`.`virtuemart_product_id` = `bn9fo_virtuemart_products_fr_fr`.`virtuemart_product_id` WHERE `bn9fo_virtuemart_products`.`virtuemart_product_id` = "978"
216μs5.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "978" ORDER BY `ordering`
80μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "978" 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-05 08:16:15" )
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-05 08:16:15" ) ) ORDER BY `product_price` DESC
187μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 978
93μs720B/administrator/components/com_virtuemart/models/product.php:2133CopySELECT 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 `bn9fo_virtuemart_customs` AS c LEFT JOIN `bn9fo_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (978) AND c.`published` = "1" ORDER BY field.`ordering` ASC
134μs4.64KB/administrator/components/com_virtuemart/models/customfields.php:163CopySELECT `bn9fo_virtuemart_products`.* ,`bn9fo_virtuemart_products_fr_fr`.* FROM `bn9fo_virtuemart_products` INNER JOIN `bn9fo_virtuemart_products_fr_fr` ON `bn9fo_virtuemart_products`.`virtuemart_product_id` = `bn9fo_virtuemart_products_fr_fr`.`virtuemart_product_id` WHERE `bn9fo_virtuemart_products`.`virtuemart_product_id` = "976"
171μs5.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "976" ORDER BY `ordering`
106μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "976" 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-05 08:16:15" )
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-05 08:16:15" ) ) ORDER BY `product_price` DESC
181μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "976"
70μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 976
78μs720B/administrator/components/com_virtuemart/models/product.php:2133CopySELECT `bn9fo_virtuemart_manufacturers`.* ,`bn9fo_virtuemart_manufacturers_fr_fr`.* FROM `bn9fo_virtuemart_manufacturers` INNER JOIN `bn9fo_virtuemart_manufacturers_fr_fr` ON `bn9fo_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `bn9fo_virtuemart_manufacturers_fr_fr`.`virtuemart_manufacturer_id` WHERE `bn9fo_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "138"
138μs2.56KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT 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 `bn9fo_virtuemart_customs` AS c LEFT JOIN `bn9fo_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (976) AND c.`published` = "1" ORDER BY field.`ordering` ASC
167μs4.64KB/administrator/components/com_virtuemart/models/customfields.php:163CopySELECT `bn9fo_virtuemart_products`.* ,`bn9fo_virtuemart_products_fr_fr`.* FROM `bn9fo_virtuemart_products` INNER JOIN `bn9fo_virtuemart_products_fr_fr` ON `bn9fo_virtuemart_products`.`virtuemart_product_id` = `bn9fo_virtuemart_products_fr_fr`.`virtuemart_product_id` WHERE `bn9fo_virtuemart_products`.`virtuemart_product_id` = "977"
156μs5.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "977" ORDER BY `ordering`
69μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "977" 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-05 08:16:15" )
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-05 08:16:15" ) ) ORDER BY `product_price` DESC
149μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 977
64μs720B/administrator/components/com_virtuemart/models/product.php:2133CopySELECT 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 `bn9fo_virtuemart_customs` AS c LEFT JOIN `bn9fo_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (977) AND c.`published` = "1" ORDER BY field.`ordering` ASC
132μs4.64KB/administrator/components/com_virtuemart/models/customfields.php:163CopySELECT `bn9fo_virtuemart_products`.* ,`bn9fo_virtuemart_products_fr_fr`.* FROM `bn9fo_virtuemart_products` INNER JOIN `bn9fo_virtuemart_products_fr_fr` ON `bn9fo_virtuemart_products`.`virtuemart_product_id` = `bn9fo_virtuemart_products_fr_fr`.`virtuemart_product_id` WHERE `bn9fo_virtuemart_products`.`virtuemart_product_id` = "395"
174μs5.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "395" ORDER BY `ordering`
67μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "395" 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-05 08:16:15" )
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-05 08:16:15" ) ) ORDER BY `product_price` DESC
144μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "395"
60μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 395
62μs720B/administrator/components/com_virtuemart/models/product.php:2133CopySELECT `bn9fo_virtuemart_manufacturers`.* ,`bn9fo_virtuemart_manufacturers_fr_fr`.* FROM `bn9fo_virtuemart_manufacturers` INNER JOIN `bn9fo_virtuemart_manufacturers_fr_fr` ON `bn9fo_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = `bn9fo_virtuemart_manufacturers_fr_fr`.`virtuemart_manufacturer_id` WHERE `bn9fo_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "53"
103μs2.56KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT 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 `bn9fo_virtuemart_customs` AS c LEFT JOIN `bn9fo_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (395) AND c.`published` = "1" ORDER BY field.`ordering` ASC
147μs4.66KB/administrator/components/com_virtuemart/models/customfields.php:163CopySELECT `bn9fo_virtuemart_products`.* ,`bn9fo_virtuemart_products_fr_fr`.* FROM `bn9fo_virtuemart_products` INNER JOIN `bn9fo_virtuemart_products_fr_fr` ON `bn9fo_virtuemart_products`.`virtuemart_product_id` = `bn9fo_virtuemart_products_fr_fr`.`virtuemart_product_id` WHERE `bn9fo_virtuemart_products`.`virtuemart_product_id` = "396"
149μs5.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "396" ORDER BY `ordering`
72μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "396" 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-05 08:16:15" )
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-05 08:16:15" ) ) ORDER BY `product_price` DESC
150μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "396"
125μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 396
76μs720B/administrator/components/com_virtuemart/models/product.php:2133CopySELECT 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 `bn9fo_virtuemart_customs` AS c LEFT JOIN `bn9fo_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (396) AND c.`published` = "1" ORDER BY field.`ordering` ASC
142μs4.66KB/administrator/components/com_virtuemart/models/customfields.php:163CopySELECT `bn9fo_virtuemart_products`.* ,`bn9fo_virtuemart_products_fr_fr`.* FROM `bn9fo_virtuemart_products` INNER JOIN `bn9fo_virtuemart_products_fr_fr` ON `bn9fo_virtuemart_products`.`virtuemart_product_id` = `bn9fo_virtuemart_products_fr_fr`.`virtuemart_product_id` WHERE `bn9fo_virtuemart_products`.`virtuemart_product_id` = "397"
180μs13.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "397" ORDER BY `ordering`
69μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "397" 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-05 08:16:15" )
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-05 08:16:15" ) ) ORDER BY `product_price` DESC
154μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "397"
63μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 397
62μs720B/administrator/components/com_virtuemart/models/product.php:2133CopySELECT 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 `bn9fo_virtuemart_customs` AS c LEFT JOIN `bn9fo_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE field.`virtuemart_product_id` IN (397) AND c.`published` = "1" ORDER BY field.`ordering` ASC
141μs4.66KB/administrator/components/com_virtuemart/models/customfields.php:163CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "503"
93μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "880"
94μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "893"
78μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "891"
122μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "892"
78μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "296"
97μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "297"
78μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "298"
76μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_vendors`.* ,`bn9fo_virtuemart_vendors_fr_fr`.* FROM `bn9fo_virtuemart_vendors` INNER JOIN `bn9fo_virtuemart_vendors_fr_fr` ON `bn9fo_virtuemart_vendors`.`virtuemart_vendor_id` = `bn9fo_virtuemart_vendors_fr_fr`.`virtuemart_vendor_id` WHERE `bn9fo_virtuemart_vendors`.`virtuemart_vendor_id` = "1"
203μs3.16KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_vendor_medias` WHERE `virtuemart_vendor_id` = "1" ORDER BY `ordering`
50μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `language`,`id`
FROM `bn9fo_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
288μs624B/libraries/src/Language/Multilanguage.php:123CopySELECT `c2`.`language`,`c2`.`id`
FROM `bn9fo_menu` AS `c`
INNER JOIN `bn9fo_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `bn9fo_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `bn9fo_menu` AS `c2` ON `a2`.`id` = `c2`.`id`
WHERE `c`.`id` = :id
238μs1.41KBParams/libraries/src/Language/Associations.php:145CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `bn9fo_modules` AS `m`
LEFT JOIN `bn9fo_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `bn9fo_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`
773μs163.34KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT cf.id AS id,cf.alias AS alias,cf.type_id AS disp_type,cf.params AS params,cf.data_type AS data_type,vmc.virtuemart_custom_id AS custom_id,vmc.custom_title AS custom_title,vmc.custom_element AS custom_element,vmc.field_type AS field_type,vmc.is_list, vmc.custom_value,vmc.custom_tip AS tooltip, vmc.custom_desc AS description
FROM bn9fo_cf_customfields AS cf
INNER JOIN bn9fo_virtuemart_customs AS vmc ON cf.vm_custom_id=vmc.virtuemart_custom_id
WHERE cf.published=1
ORDER BY cf.ordering ASC
341μs1.86KB/components/com_customfilters/include/tools.php:606CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=3
77μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=4
63μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=5
59μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=6
72μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=7
54μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=8
59μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=9
60μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=11
61μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=12
50μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=13
64μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=21
71μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=18
70μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=20
68μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=22
68μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=23
69μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=24
178μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=25
68μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=26
68μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=27
68μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=28
66μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=29
64μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=30
66μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT cf.id AS id,cf.alias AS alias,cf.type_id AS disp_type,cf.params AS params,cf.data_type AS data_type,vmc.virtuemart_custom_id AS custom_id,vmc.custom_title AS custom_title,vmc.custom_element AS custom_element,vmc.field_type AS field_type,vmc.is_list, vmc.custom_value,vmc.custom_tip AS tooltip, vmc.custom_desc AS description
FROM bn9fo_cf_customfields AS cf
INNER JOIN bn9fo_virtuemart_customs AS vmc ON cf.vm_custom_id=vmc.virtuemart_custom_id
WHERE cf.published=1 AND vmc.virtuemart_custom_id IN(3,13,18,20,21,22,23,24,25,26,27,28,29,30)
ORDER BY cf.ordering ASC
698μs1.73KB/components/com_customfilters/include/tools.php:606CopySELECT virtuemart_shoppergroup_id
FROM bn9fo_virtuemart_vmuser_shoppergroups
WHERE virtuemart_user_id=0
77μs520B/components/com_customfilters/include/tools.php:1073CopySELECT cf.id AS id,cf.alias AS alias,cf.type_id AS disp_type,cf.params AS params,cf.data_type AS data_type,vmc.virtuemart_custom_id AS custom_id,vmc.custom_title AS custom_title,vmc.custom_element AS custom_element,vmc.field_type AS field_type,vmc.is_list, vmc.custom_value,vmc.custom_tip AS tooltip, vmc.custom_desc AS description
FROM bn9fo_cf_customfields AS cf
INNER JOIN bn9fo_virtuemart_customs AS vmc ON cf.vm_custom_id=vmc.virtuemart_custom_id
WHERE cf.published=1
ORDER BY cf.ordering ASC
284μs1.86KB/components/com_customfilters/include/tools.php:606CopySELECT SUM(CASE WHEN p.product_parent_id=0 THEN 1 ELSE 0 END) AS counter,langt.mf_name AS name,vm.virtuemart_manufacturer_id AS id
FROM bn9fo_virtuemart_manufacturers AS vm
LEFT JOIN bn9fo_virtuemart_product_manufacturers ON vm.virtuemart_manufacturer_id=bn9fo_virtuemart_product_manufacturers.virtuemart_manufacturer_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON bn9fo_virtuemart_product_manufacturers.virtuemart_product_id = p.`virtuemart_product_id`
LEFT JOIN bn9fo_virtuemart_manufacturers_fr_fr AS langt ON vm.virtuemart_manufacturer_id=langt.virtuemart_manufacturer_id
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND vm.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57)
GROUP BY `vm`.`virtuemart_manufacturer_id`
ORDER BY name ASC
335μs688B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT cf.id AS id,cf.alias AS alias,cf.type_id AS disp_type,cf.params AS params,cf.data_type AS data_type,vmc.virtuemart_custom_id AS custom_id,vmc.custom_title AS custom_title,vmc.custom_element AS custom_element,vmc.field_type AS field_type,vmc.is_list, vmc.custom_value,vmc.custom_tip AS tooltip, vmc.custom_desc AS description
FROM bn9fo_cf_customfields AS cf
INNER JOIN bn9fo_virtuemart_customs AS vmc ON cf.vm_custom_id=vmc.virtuemart_custom_id
WHERE cf.published=1 AND vmc.virtuemart_custom_id IN(3,13,18,20,21,22,23,24,25,26,27,28,29,30)
ORDER BY cf.ordering ASC
477μs1.73KB/components/com_customfilters/include/tools.php:606CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=3
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
988μs640B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=13
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
921μs640B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=21
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
945μs640B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=18
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
923μs640B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=20
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
969μs640B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=22
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
922μs640B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=23
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
963μs640B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=24
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
1.02ms656B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=25
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
1.06ms640B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=26
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
986μs640B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=27
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
1000μs640B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=28
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
879μs640B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=29
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
905μs640B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT DISTINCT `cf`.`customsforall_value_id` AS `id`,`customsforall_value_name` AS `name`,`customsforall_value_label` AS `description`
FROM
(SELECT `tbl1`.`customsforall_value_name`,`tbl1`.`customsforall_value_label`,`tbl1`.`customsforall_value_id`,`tbl2`.`virtuemart_custom_id`,`tbl2`.`ordering`
FROM `bn9fo_virtuemart_custom_plg_customsforall_values_en_gb` AS `tbl1`
LEFT JOIN `bn9fo_virtuemart_custom_plg_customsforall_values` AS `tbl2` ON tbl1.customsforall_value_id= tbl2.customsforall_value_id) AS cf
INNER JOIN bn9fo_virtuemart_product_custom_plg_customsforall AS cfp ON cf.customsforall_value_id=cfp.customsforall_value_id
INNER JOIN `bn9fo_virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id`
INNER JOIN bn9fo_virtuemart_product_categories ON p.virtuemart_product_id = bn9fo_virtuemart_product_categories.virtuemart_product_id
WHERE p.published=1 AND bn9fo_virtuemart_product_categories.virtuemart_category_id IN (57) AND cf.virtuemart_custom_id=30
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
615μs640B/modules/mod_cf_filtering/optionsHelper.php:578CopySELECT CONCAT(`vendor_accepted_currencies`, ",",`vendor_currency`) AS all_currencies, `vendor_currency` FROM `bn9fo_virtuemart_vendors` WHERE `virtuemart_vendor_id`=1
91μs592B/components/com_customfilters/include/tools.php:724CopySELECT currency_symbol, currency_decimal_place, currency_decimal_symbol,currency_positive_style
FROM bn9fo_virtuemart_currencies
WHERE virtuemart_currency_id=47
81μs704B/components/com_customfilters/include/tools.php:748CopySELECT `main`.`virtuemart_category_id` AS `id`,`lang`.`category_name` AS `name`,`lang`.`slug` AS `alias`
FROM `bn9fo_virtuemart_categories` AS `main`
LEFT JOIN `bn9fo_virtuemart_categories_fr_fr` AS lang ON main.virtuemart_category_id=lang.virtuemart_category_id
WHERE `main`.`virtuemart_category_id` IN (57)
70μs656B/components/com_customfilters/include/CategoryHelper.php:55CopySELECT `main`.`virtuemart_manufacturer_id` AS `id`,`lang`.`mf_name` AS `name`,`lang`.`slug` AS `alias`
FROM `bn9fo_virtuemart_manufacturers` AS `main`
LEFT JOIN `bn9fo_virtuemart_manufacturers_fr_fr` AS lang ON main.virtuemart_manufacturer_id=lang.virtuemart_manufacturer_id
WHERE `main`.`virtuemart_manufacturer_id` IN (53)
62μs656B/components/com_customfilters/include/ManufacturerHelper.php:54CopySELECT `main`.`virtuemart_manufacturer_id` AS `id`,`lang`.`mf_name` AS `name`,`lang`.`slug` AS `alias`
FROM `bn9fo_virtuemart_manufacturers` AS `main`
LEFT JOIN `bn9fo_virtuemart_manufacturers_fr_fr` AS lang ON main.virtuemart_manufacturer_id=lang.virtuemart_manufacturer_id
WHERE `main`.`virtuemart_manufacturer_id` IN (139)
57μs656B/components/com_customfilters/include/ManufacturerHelper.php:54CopySELECT `main`.`virtuemart_manufacturer_id` AS `id`,`lang`.`mf_name` AS `name`,`lang`.`slug` AS `alias`
FROM `bn9fo_virtuemart_manufacturers` AS `main`
LEFT JOIN `bn9fo_virtuemart_manufacturers_fr_fr` AS lang ON main.virtuemart_manufacturer_id=lang.virtuemart_manufacturer_id
WHERE `main`.`virtuemart_manufacturer_id` IN (138)
61μs656B/components/com_customfilters/include/ManufacturerHelper.php:54CopySELECT cf.id AS id,cf.alias AS alias,cf.type_id AS disp_type,cf.params AS params,cf.data_type AS data_type,vmc.virtuemart_custom_id AS custom_id,vmc.custom_title AS custom_title,vmc.custom_element AS custom_element,vmc.field_type AS field_type,vmc.is_list, vmc.custom_value,vmc.custom_tip AS tooltip, vmc.custom_desc AS description
FROM bn9fo_cf_customfields AS cf
INNER JOIN bn9fo_virtuemart_customs AS vmc ON cf.vm_custom_id=vmc.virtuemart_custom_id
WHERE cf.published=1
ORDER BY cf.ordering ASC
344μs1.86KB/components/com_customfilters/include/tools.php:606CopySELECT 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 bn9fo_fields AS a
LEFT JOIN `bn9fo_languages` AS l ON l.lang_code = a.language
LEFT JOIN bn9fo_users AS uc ON uc.id=a.checked_out
LEFT JOIN bn9fo_viewlevels AS ag ON ag.id = a.access
LEFT JOIN bn9fo_users AS ua ON ua.id = a.created_user_id
LEFT JOIN bn9fo_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`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)
ORDER BY a.ordering ASC
534μs4.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 16
96μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 7
67μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 16
55μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT `bn9fo_virtuemart_categories`.* ,`bn9fo_virtuemart_categories_fr_fr`.* FROM `bn9fo_virtuemart_categories` INNER JOIN `bn9fo_virtuemart_categories_fr_fr` ON `bn9fo_virtuemart_categories`.`virtuemart_category_id` = `bn9fo_virtuemart_categories_fr_fr`.`virtuemart_category_id` WHERE `bn9fo_virtuemart_categories`.`virtuemart_category_id` = "16"
223μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_category_medias` WHERE `virtuemart_category_id` = "16" ORDER BY `ordering`
52μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 16
62μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 7
56μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT l.virtuemart_category_id, l.category_name, published FROM `bn9fo_virtuemart_categories` as c LEFT JOIN `bn9fo_virtuemart_categories_fr_fr` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE l.virtuemart_category_id = 7
81μs656B/administrator/components/com_virtuemart/models/category.php:1040CopySELECT l.virtuemart_category_id, l.category_name, published FROM `bn9fo_virtuemart_categories` as c LEFT JOIN `bn9fo_virtuemart_categories_fr_fr` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE l.virtuemart_category_id = 16
81μs656B/administrator/components/com_virtuemart/models/category.php:1040CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 17
61μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 17
56μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT `bn9fo_virtuemart_categories`.* ,`bn9fo_virtuemart_categories_fr_fr`.* FROM `bn9fo_virtuemart_categories` INNER JOIN `bn9fo_virtuemart_categories_fr_fr` ON `bn9fo_virtuemart_categories`.`virtuemart_category_id` = `bn9fo_virtuemart_categories_fr_fr`.`virtuemart_category_id` WHERE `bn9fo_virtuemart_categories`.`virtuemart_category_id` = "17"
149μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_category_medias` WHERE `virtuemart_category_id` = "17" ORDER BY `ordering`
45μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 17
56μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT l.virtuemart_category_id, l.category_name, published FROM `bn9fo_virtuemart_categories` as c LEFT JOIN `bn9fo_virtuemart_categories_fr_fr` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE l.virtuemart_category_id = 17
68μs656B/administrator/components/com_virtuemart/models/category.php:1040CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 19
58μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 19
54μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT `bn9fo_virtuemart_categories`.* ,`bn9fo_virtuemart_categories_fr_fr`.* FROM `bn9fo_virtuemart_categories` INNER JOIN `bn9fo_virtuemart_categories_fr_fr` ON `bn9fo_virtuemart_categories`.`virtuemart_category_id` = `bn9fo_virtuemart_categories_fr_fr`.`virtuemart_category_id` WHERE `bn9fo_virtuemart_categories`.`virtuemart_category_id` = "19"
150μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_category_medias` WHERE `virtuemart_category_id` = "19" ORDER BY `ordering`
47μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 19
61μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT l.virtuemart_category_id, l.category_name, published FROM `bn9fo_virtuemart_categories` as c LEFT JOIN `bn9fo_virtuemart_categories_fr_fr` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE l.virtuemart_category_id = 19
73μs656B/administrator/components/com_virtuemart/models/category.php:1040CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 20
62μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 20
79μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT `bn9fo_virtuemart_categories`.* ,`bn9fo_virtuemart_categories_fr_fr`.* FROM `bn9fo_virtuemart_categories` INNER JOIN `bn9fo_virtuemart_categories_fr_fr` ON `bn9fo_virtuemart_categories`.`virtuemart_category_id` = `bn9fo_virtuemart_categories_fr_fr`.`virtuemart_category_id` WHERE `bn9fo_virtuemart_categories`.`virtuemart_category_id` = "20"
138μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_category_medias` WHERE `virtuemart_category_id` = "20" ORDER BY `ordering`
50μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 20
60μs592B/administrator/components/com_virtuemart/models/category.php:1094CopySELECT l.virtuemart_category_id, l.category_name, published FROM `bn9fo_virtuemart_categories` as c LEFT JOIN `bn9fo_virtuemart_categories_fr_fr` as l ON l.`virtuemart_category_id` = c.`virtuemart_category_id` WHERE l.virtuemart_category_id = 20
75μs656B/administrator/components/com_virtuemart/models/category.php:1040CopySELECT 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 bn9fo_fields AS a
LEFT JOIN `bn9fo_languages` AS l ON l.lang_code = a.language
LEFT JOIN bn9fo_users AS uc ON uc.id=a.checked_out
LEFT JOIN bn9fo_viewlevels AS ag ON ag.id = a.access
LEFT JOIN bn9fo_users AS ua ON ua.id = a.created_user_id
LEFT JOIN bn9fo_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
700μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT * FROM bn9fo_virtuemart_calcs LEFT JOIN bn9fo_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-05 07:16:15" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-01-05 07:16:15" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
250μs3.11KB/administrator/components/com_virtuemart/helpers/calculationh.php:1521CopySELECT * FROM bn9fo_virtuemart_calcs LEFT JOIN bn9fo_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-05 07:16:15" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-01-05 07:16:15" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
217μs3.11KB/administrator/components/com_virtuemart/helpers/calculationh.php:1521CopySELECT * FROM bn9fo_virtuemart_calcs LEFT JOIN bn9fo_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-05 07:16:15" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-01-05 07:16:15" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
181μs3.11KB/administrator/components/com_virtuemart/helpers/calculationh.php:1521CopySELECT * FROM bn9fo_acym_list WHERE type = 'standard'
131μs1.66KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM bn9fo_acym_field
107μs2.41KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM bn9fo_acym_form WHERE active = 1 AND type != 'shortcode'
83μs912B/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT 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 `bn9fo_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
155μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
237μs552B/plugins/system/acymtriggers/acymtriggers.php:214CopySHOW TABLES
748μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT `session_id`
FROM `bn9fo_session`
WHERE `session_id` = ?
129μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `bn9fo_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
2.61ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy