Paiement sécurisé et ( bientôt )
L4P - Copyright 2020 | rue Haute Wez 79, 4030 Grivegnée - Tél : +32 (0) 0484 81 58 14 - Email :
Joomla! Version | 4.4.2 |
PHP Version | 8.3.10 |
Identity | guest |
Response | 200 |
Template | yootheme |
Database |
|
1 x afterRenderComponent com_virtuemart (4.66MB) (31.73%) | 89.19ms |
1 x afterRenderRawModule mod_cf_filtering (CF Filtering Module) (1.25MB) (18.04%) | 50.72ms |
1 x Before Access::preloadComponents (all components) (980.74KB) (7.67%) | 21.56ms |
1 x afterRoute (1.58MB) (6.74%) | 18.95ms |
1 x beforeRenderRawModule mod_yootheme_builder (Footer) (830.66KB) (6.12%) | 17.21ms |
1 x afterRenderRawModule mod_virtuemart_cart (Panier) (491.73KB) (3.47%) | 9.77ms |
1 x afterRender (297.91KB) (3.47%) | 9.75ms |
1 x afterInitialise (367.3KB) (3.3%) | 9.28ms |
1 x afterRenderRawModule mod_menu (Main Menu (FR)) (179.7KB) (2.21%) | 6.21ms |
1 x afterRenderRawModule mod_yootheme_builder (Footer) (5.45KB) (2.02%) | 5.67ms |
1 x afterRenderRawModule mod_menu (Main Menu (Mobile)) (16.25KB) (1.91%) | 5.38ms |
1 x afterDispatch (68.21KB) (1.67%) | 4.69ms |
1 x afterRenderRawModule mod_acym (Newsletter) (131.94KB) (0.96%) | 2.70ms |
1 x afterLoad (456.55KB) (0.92%) | 2.58ms |
1 x afterRenderRawModule mod_menu (Menu Produits) (322.98KB) (0.89%) | 2.51ms |
1 x beforeRenderModule mod_cf_filtering (CF Filtering Module) (129.43KB) (0.87%) | 2.45ms |
1 x afterRenderRawModule mod_custom () (23.34KB) (0.78%) | 2.19ms |
1 x afterRenderRawModule mod_menu (Menu corporate) (62.56KB) (0.72%) | 2.03ms |
1 x beforeRenderRawModule mod_menu (Menu corporate) (110.74KB) (0.69%) | 1.95ms |
1 x afterRenderRawModule mod_languages (Changement de langue) (10.36KB) (0.67%) | 1.87ms |
1 x beforeRenderComponent com_virtuemart (14.56KB) (0.52%) | 1.46ms |
1 x beforeRenderRawModule mod_custom (User (connexion)) (9.15KB) (0.47%) | 1.32ms |
1 x beforeRenderRawModule mod_custom () (1.74KB) (0.4%) | 1.11ms |
1 x afterRenderRawModule mod_languages (Changement de langue (mobile)) (2.16KB) (0.36%) | 1.01ms |
1 x afterRenderRawModule mod_menu (Menu GDPR) (58.87KB) (0.35%) | 992μs |
1 x afterRenderRawModule mod_cf_search (CF Product search) (5.91KB) (0.27%) | 768μs |
1 x After Access::preloadComponents (all components) (130.88KB) (0.23%) | 658μs |
1 x afterRenderRawModule mod_yootheme_builder (Affiner ma recherche - top CF) (91.63KB) (0.18%) | 501μs |
1 x beforeRenderRawModule mod_custom (User (connexion) (mobile)) (10.81KB) (0.16%) | 443μs |
1 x beforeRenderRawModule mod_yootheme_builder (Affiner ma recherche - top CF) (15.13KB) (0.13%) | 376μs |
1 x beforeRenderRawModule mod_cf_search (CF Product search) (1.12KB) (0.13%) | 359μs |
1 x afterRenderRawModule mod_virtuemart_cart (Panier (mobile)) (1.42KB) (0.12%) | 326μs |
1 x beforeRenderRawModule mod_custom () (4.55KB) (0.09%) | 256μs |
1 x beforeRenderRawModule mod_languages (Changement de langue (mobile)) (1.99KB) (0.09%) | 246μs |
1 x beforeRenderRawModule mod_custom () (2.52KB) (0.09%) | 243μs |
1 x beforeRenderRawModule mod_cf_filtering (CF Filtering Module) (44.62KB) (0.08%) | 225μs |
1 x afterRenderRawModule mod_custom () (864B) (0.08%) | 219μs |
1 x afterRenderRawModule mod_custom () (1008B) (0.08%) | 211μs |
1 x beforeRenderRawModule mod_menu (Main Menu (FR)) (20.4KB) (0.07%) | 204μs |
1 x afterRenderModule mod_menu (Main Menu (Mobile)) (1.25KB) (0.07%) | 189μs |
1 x afterRenderRawModule mod_cf_search (CF Product search (Mobile)) (1.66KB) (0.06%) | 180μs |
1 x afterRenderModule mod_menu (Menu corporate) (3.16KB) (0.06%) | 176μs |
1 x afterRenderModule mod_virtuemart_cart (Panier) (1.25KB) (0.05%) | 150μs |
1 x afterRenderModule mod_cf_search (CF Product search) (3.77KB) (0.05%) | 138μs |
1 x afterRenderModule mod_cf_filtering (CF Filtering Module) (1.27KB) (0.05%) | 127μs |
1 x beforeRenderRawModule mod_menu (Menu GDPR) (8.83KB) (0.04%) | 123μs |
1 x afterRenderModule mod_custom () (1.23KB) (0.04%) | 122μs |
1 x afterRenderModule mod_yootheme_builder (Footer) (1.25KB) (0.04%) | 117μs |
1 x beforeRenderRawModule mod_acym (Newsletter) (16.88KB) (0.04%) | 112μs |
1 x beforeRenderRawModule mod_menu (Menu Produits) (14.34KB) (0.04%) | 112μs |
1 x afterRenderModule mod_custom (User (connexion)) (1.25KB) (0.04%) | 110μs |
1 x afterRenderRawModule mod_custom (User (connexion)) (1.09KB) (0.04%) | 109μs |
1 x afterRenderRawModule mod_custom (User (connexion) (mobile)) (1.02KB) (0.04%) | 106μs |
1 x afterRenderModule mod_yootheme_builder (Affiner ma recherche - top CF) (1.27KB) (0.04%) | 100μs |
1 x afterRenderModule mod_cf_search (CF Product search (Mobile)) (1.28KB) (0.03%) | 96μs |
1 x afterRenderModule mod_menu (Main Menu (FR)) (10.3KB) (0.03%) | 83μs |
1 x afterRenderModule mod_languages (Changement de langue) (1.27KB) (0.03%) | 83μs |
1 x afterRenderModule mod_languages (Changement de langue (mobile)) (1.28KB) (0.03%) | 82μs |
1 x afterRenderModule mod_cf_filtering (CF Filtering Module) (17.93KB) (0.03%) | 80μs |
1 x After Access::getAssetRules (id:1 name:root.1) (6.7KB) (0.03%) | 78μs |
1 x afterRenderModule mod_custom () (2.43KB) (0.03%) | 75μs |
1 x afterRenderModule mod_virtuemart_cart (Panier (mobile)) (2.8KB) (0.02%) | 59μs |
1 x afterRenderModule mod_acym (Newsletter) (5.3KB) (0.02%) | 59μs |
1 x afterRenderModule mod_menu (Menu Produits) (3.3KB) (0.02%) | 58μs |
1 x afterRenderModule mod_custom (User (connexion) (mobile)) (2.63KB) (0.02%) | 52μs |
1 x afterRenderModule mod_menu (Menu GDPR) (2.91KB) (0.02%) | 49μs |
1 x afterRenderModule mod_custom () (2.49KB) (0.02%) | 46μs |
1 x beforeRenderRawModule mod_languages (Changement de langue) (1.89KB) (0.01%) | 29μs |
1 x beforeRenderRawModule mod_cf_search (CF Product search (Mobile)) (96B) (0.01%) | 22μs |
3 x beforeRenderModule mod_custom () (704B) (0.01%) | 20μs |
1 x beforeRenderRawModule mod_menu (Main Menu (Mobile)) (2.25KB) (0.01%) | 19μs |
1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0.01%) | 18μs |
1 x beforeRenderRawModule mod_virtuemart_cart (Panier (mobile)) (864B) (0.01%) | 16μs |
1 x Before Access::getAssetRules (id:61 name:com_virtuemart) (776B) (0.01%) | 15μs |
1 x beforeRenderRawModule mod_virtuemart_cart (Panier) (272B) (0.01%) | 15μs |
1 x beforeRenderModule mod_menu (Main Menu (Mobile)) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_virtuemart_cart (Panier) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_menu (Main Menu (FR)) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_cf_filtering (CF Filtering Module) (736B) (0%) | 8μs |
1 x beforeRenderModule mod_cf_search (CF Product search) (720B) (0%) | 8μs |
1 x beforeRenderModule mod_menu (Menu corporate) (720B) (0%) | 8μs |
1 x beforeRenderModule mod_yootheme_builder (Footer) (720B) (0%) | 7μs |
1 x After Access::getAssetRules (id:61 name:com_virtuemart) (1.44KB) (0%) | 6μs |
1 x beforeRenderModule mod_acym (Newsletter) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_languages (Changement de langue) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_yootheme_builder (Affiner ma recherche - top CF) (736B) (0%) | 5μs |
1 x beforeRenderModule mod_custom (User (connexion)) (720B) (0%) | 5μs |
1 x beforeRenderModule mod_languages (Changement de langue (mobile)) (736B) (0%) | 5μs |
1 x beforeRenderModule mod_custom (User (connexion) (mobile)) (736B) (0%) | 5μs |
1 x beforeRenderModule mod_menu (Menu Produits) (720B) (0%) | 4μs |
1 x beforeRenderModule mod_menu (Menu GDPR) (704B) (0%) | 4μs |
1 x beforeRenderModule mod_cf_search (CF Product search (Mobile)) (736B) (0%) | 4μs |
1 x beforeRenderModule mod_virtuemart_cart (Panier (mobile)) (736B) (0%) | 4μs |
SELECT @@SESSION.sql_mode;
87μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `bn9fo_session`
WHERE `session_id` = ?
173μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `bn9fo_session`
WHERE `session_id` = :session_id LIMIT 1
57μ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)
3.59ms944BParams/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
252μs1.73KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `bn9fo_viewlevels`
86μ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
134μ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`
549μs4.48KBParams/libraries/src/Plugin/PluginHelper.php:294CopySHOW TABLES LIKE "bn9fo_virtuemart_configs"
450μs1.15KB/administrator/components/com_virtuemart/helpers/vmtable.php:820CopySELECT `config` FROM `bn9fo_virtuemart_configs` WHERE `virtuemart_config_id` = "1";
84μ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)
343μs7.81KBParams/libraries/src/Access/Access.php:357CopySELECT *
FROM `bn9fo_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
138μ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
157μs784B/libraries/src/Language/LanguageHelper.php:213CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` = 'level'
95μs536B/plugins/system/acymtriggers/acymtriggers.php:505CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` = 'active_cron'
81μs536B/plugins/system/acymtriggers/acymtriggers.php:505CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` = 'cron_next'
77μs536B/plugins/system/acymtriggers/acymtriggers.php:505CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` = 'queue_type'
72μs1.77KB/plugins/system/acymtriggers/acymtriggers.php:505CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` = 'cron_frequency'
64μs536B/plugins/system/acymtriggers/acymtriggers.php:505CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` = 'queue_batch_auto'
63μ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`
945μ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
233μs864B/administrator/components/com_templates/src/Model/StyleModel.php:773CopySHOW TABLES
698μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT * FROM bn9fo_acym_configuration
224μs4.56KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM bn9fo_acym_plugin
100μs1.5KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'acychecker' LIMIT 1
104μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'acymailer' LIMIT 1
93μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'amazon' LIMIT 1
102μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'article' LIMIT 1
101μs1.47KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'birthday' LIMIT 1
112μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'brevo' LIMIT 1
108μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'createuser' LIMIT 1
112μ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`
96μs1.02KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'elasticemail' LIMIT 1
104μs3.95KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'forward' LIMIT 1
109μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'mailgun' LIMIT 1
108μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'module' LIMIT 1
87μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'online' LIMIT 1
93μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'override' LIMIT 1
76μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'phpmail' LIMIT 1
79μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'postmark' LIMIT 1
76μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'qmail' LIMIT 1
76μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'segment' LIMIT 1
106μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'sendgrid' LIMIT 1
82μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'sendinblue' LIMIT 1
107μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'luecredentials' LIMIT 1
77μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'lueintegration' LIMIT 1
79μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'luetransactional' LIMIT 1
74μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'luelist' LIMIT 1
72μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'lueusers' LIMIT 1
79μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'luesender' LIMIT 1
75μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'luecampaign' LIMIT 1
80μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'luewebhooks' LIMIT 1
75μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'sendmail' LIMIT 1
106μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'smtp' LIMIT 1
91μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'statistics' LIMIT 1
92μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'subscriber' LIMIT 1
108μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'subscription' LIMIT 1
97μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'time' LIMIT 1
88μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'user' LIMIT 1
90μs1.45KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'virtuemart' LIMIT 1
89μs1.47KB/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT * FROM bn9fo_acym_plugin WHERE folder_name = 'managetext' LIMIT 1
156μ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 = "fr-FR" ) AND client_id=0 AND published=1 AND ( access="1" OR access="5" ) ORDER BY `language` DESC
648μs67.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` = "12"
190μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_category_medias` WHERE `virtuemart_category_id` = "12" 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"
135μ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"
98μs2.38KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySHOW FULL COLUMNS FROM `bn9fo_virtuemart_userfields`
331μ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
243μ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
236μ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
2.59ms520B/administrator/components/com_virtuemart/models/product.php:999CopySELECT `product_stockhandle` FROM `bn9fo_virtuemart_products` WHERE `product_stockhandle` = "disableit" AND `published` = "1" LIMIT 1
2.44ms520B/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` = 12) AND c.`published` = 1 ORDER BY c.ordering,category_name ASC
505μs2.83KB/administrator/components/com_virtuemart/models/category.php:409CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_category_medias` WHERE `virtuemart_category_id` = "13" ORDER BY `ordering`
61μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_category_medias` WHERE `virtuemart_category_id` = "21" ORDER BY `ordering`
72μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_category_medias` WHERE `virtuemart_category_id` = "22" ORDER BY `ordering`
44μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_category_medias` WHERE `virtuemart_category_id` = "23" ORDER BY `ordering`
46μs520B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT 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 (13,21,22,23,12) 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
777μs960B/administrator/components/com_virtuemart/helpers/vmmodel.php:876CopySELECT FOUND_ROWS()
36μ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` = "12" ORDER BY `mf_name`
461μs704B/administrator/components/com_virtuemart/models/manufacturer.php:222CopySELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM bn9fo_virtuemart_categories
WHERE `virtuemart_category_id`= 12
78μ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`= 1
73μ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` = "1"
159μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_category_medias` WHERE `virtuemart_category_id` = "1" ORDER BY `ordering`
41μ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`= 1
52μ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 = 1
65μs656B/administrator/components/com_virtuemart/models/category.php:1040CopySELECT l.slug FROM `bn9fo_virtuemart_manufacturers_fr_fr` as l WHERE l.virtuemart_manufacturer_id = "19"
48μs536B/components/com_virtuemart/router.php:1587CopySELECT l.slug FROM `bn9fo_virtuemart_manufacturers_fr_fr` as l WHERE l.virtuemart_manufacturer_id = "118"
46μs536B/components/com_virtuemart/router.php:1587CopySELECT l.slug FROM `bn9fo_virtuemart_manufacturers_fr_fr` as l WHERE l.virtuemart_manufacturer_id = "10"
46μs536B/components/com_virtuemart/router.php:1587CopySELECT l.slug FROM `bn9fo_virtuemart_manufacturers_fr_fr` as l WHERE l.virtuemart_manufacturer_id = "12"
47μs536B/components/com_virtuemart/router.php:1587CopySELECT l.slug FROM `bn9fo_virtuemart_manufacturers_fr_fr` as l WHERE l.virtuemart_manufacturer_id = "4"
45μs536B/components/com_virtuemart/router.php:1587CopySELECT l.slug FROM `bn9fo_virtuemart_manufacturers_fr_fr` as l WHERE l.virtuemart_manufacturer_id = "1"
104μs536B/components/com_virtuemart/router.php:1587CopySELECT l.slug FROM `bn9fo_virtuemart_manufacturers_fr_fr` as l WHERE l.virtuemart_manufacturer_id = "2"
60μs536B/components/com_virtuemart/router.php:1587CopySELECT l.slug FROM `bn9fo_virtuemart_manufacturers_fr_fr` as l WHERE l.virtuemart_manufacturer_id = "11"
83μ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` = "1071"
210μs5.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1071" ORDER BY `ordering`
112μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1071" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
190μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1071"
66μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1071
73μ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` = "19"
100μ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 (1071) AND c.`published` = "1" ORDER BY field.`ordering` ASC
155μs4.66KB/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"
157μ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"
106μ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-04 19:09:12" )
AND ( ( ISNULL(`publish_down`) or `publish_down`="0000-00-00 00:00:00") OR publish_down >= "2025-01-04 19:09:12" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
228μ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` = "922"
167μs5.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "922" ORDER BY `ordering`
75μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "922" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
164μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "922"
72μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 922
67μs736B/administrator/components/com_virtuemart/models/product.php:2133CopySELECT `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` = "13"
118μs3.13KB/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 (922) AND c.`published` = "1" ORDER BY field.`ordering` ASC
153μ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` = "885"
139μs5.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "885" ORDER BY `ordering`
64μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "885" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
158μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "885"
60μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 885
63μs720B/administrator/components/com_virtuemart/models/product.php:2133CopySELECT `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` = "21"
147μs3.13KB/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 (885) AND c.`published` = "1" ORDER BY field.`ordering` ASC
145μ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` = "870"
138μs5.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "870" ORDER BY `ordering`
64μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "870" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
140μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "870"
57μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 870
79μ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 (870) AND c.`published` = "1" ORDER BY field.`ordering` ASC
137μ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` = "802"
139μs5.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "802" ORDER BY `ordering`
67μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "802" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
138μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "802"
58μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 802
118μs736B/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` = "118"
126μs10.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 (802) AND c.`published` = "1" ORDER BY field.`ordering` ASC
141μ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` = "33"
145μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "33" ORDER BY `ordering`
64μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "33" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
141μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "33"
60μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 33
69μs736B/administrator/components/com_virtuemart/models/product.php:2133CopySELECT `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` = "22"
108μs3.13KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `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` = "10"
86μ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 (33) AND c.`published` = "1" ORDER BY field.`ordering` ASC
157μs4.69KB/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` = "36"
160μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "36" ORDER BY `ordering`
62μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "36" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
142μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "36"
58μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 36
61μs736B/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` = "12"
89μ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 (36) AND c.`published` = "1" ORDER BY field.`ordering` ASC
204μs4.72KB/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` = "990"
151μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "990" ORDER BY `ordering`
67μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "990" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
142μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "990"
58μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 990
61μs736B/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` = "4"
101μ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 (990) 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` = "991"
189μs5.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "991" ORDER BY `ordering`
108μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "991" 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-04 21:09:12" )
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-04 21:09:12" ) ) 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` = "991"
82μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 991
86μs736B/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 (991) AND c.`published` = "1" ORDER BY field.`ordering` ASC
161μ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` = "38"
158μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "38" ORDER BY `ordering`
82μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "38" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
159μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "38"
72μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 38
98μs736B/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` = "1"
105μ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 (38) AND c.`published` = "1" ORDER BY field.`ordering` ASC
186μs4.73KB/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` = "1"
195μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1" ORDER BY `ordering`
77μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-04 21:09:12" )
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-04 21:09:12" ) ) 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` = "1"
81μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1
77μs736B/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 (1) AND c.`published` = "1" ORDER BY field.`ordering` ASC
189μs4.77KB/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` = "5"
152μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "5" ORDER BY `ordering`
76μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "5" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
165μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "5"
83μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 5
78μs736B/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 (5) AND c.`published` = "1" ORDER BY field.`ordering` ASC
220μs4.8KB/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` = "29"
155μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "29" ORDER BY `ordering`
77μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "29" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
153μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "29"
71μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 29
77μs736B/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 (29) AND c.`published` = "1" ORDER BY field.`ordering` ASC
208μs4.83KB/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` = "37"
174μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "37" ORDER BY `ordering`
77μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "37" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
194μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "37"
71μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 37
77μs736B/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 (37) AND c.`published` = "1" ORDER BY field.`ordering` ASC
166μs4.69KB/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` = "30"
157μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "30" ORDER BY `ordering`
82μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "30" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
164μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "30"
65μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 30
101μs736B/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 (30) AND c.`published` = "1" ORDER BY field.`ordering` ASC
191μs4.77KB/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` = "19"
166μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "19" ORDER BY `ordering`
68μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "19" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
157μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "19"
82μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 19
64μs736B/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 (19) AND c.`published` = "1" ORDER BY field.`ordering` ASC
231μs4.77KB/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` = "31"
164μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "31" ORDER BY `ordering`
69μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "31" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
156μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "31"
63μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 31
75μs736B/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 (31) AND c.`published` = "1" ORDER BY field.`ordering` ASC
179μs4.77KB/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` = "34"
146μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "34" ORDER BY `ordering`
69μs552B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "34" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
149μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "34"
58μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 34
62μs736B/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 (34) AND c.`published` = "1" ORDER BY field.`ordering` ASC
152μs4.69KB/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` = "28"
165μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "28" ORDER BY `ordering`
75μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "28" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
221μs2.52KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "28"
95μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 28
106μs736B/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` = "2"
140μ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 (28) AND c.`published` = "1" ORDER BY field.`ordering` ASC
234μs4.77KB/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` = "3"
223μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "3" ORDER BY `ordering`
118μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "3" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
177μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "3"
87μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 3
65μs736B/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 (3) AND c.`published` = "1" ORDER BY field.`ordering` ASC
212μs4.8KB/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` = "32"
154μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "32" ORDER BY `ordering`
94μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "32" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
204μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "32"
59μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 32
87μs736B/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 (32) AND c.`published` = "1" ORDER BY field.`ordering` ASC
199μs4.77KB/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` = "35"
187μs21.53KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `virtuemart_media_id` FROM `bn9fo_virtuemart_product_medias` WHERE `virtuemart_product_id` = "35" ORDER BY `ordering`
70μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_prices` WHERE `virtuemart_product_id` = "35" 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-04 21:09:12" )
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-04 21:09:12" ) ) ORDER BY `product_price` DESC
157μs2.5KB/administrator/components/com_virtuemart/models/product.php:1535CopySELECT `virtuemart_manufacturer_id` FROM `bn9fo_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "35"
60μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT * FROM `bn9fo_virtuemart_product_categories` WHERE `virtuemart_product_id` = 35
86μs736B/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` = "11"
113μ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 (35) AND c.`published` = "1" ORDER BY field.`ordering` ASC
205μs4.72KB/administrator/components/com_virtuemart/models/customfields.php:163CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "1003"
98μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "838"
87μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "796"
92μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "751"
113μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "37"
82μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "135"
91μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "906"
83μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "907"
87μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "136"
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` = "2"
80μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "3"
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` = "29"
79μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "32"
82μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "31"
80μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "33"
79μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "38"
103μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "28"
87μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "36"
123μs18.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "35"
139μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT `bn9fo_virtuemart_medias`.* FROM `bn9fo_virtuemart_medias` WHERE `bn9fo_virtuemart_medias`.`virtuemart_media_id` = "39"
89μs2.75KB/administrator/components/com_virtuemart/helpers/vmtable.php:1128CopySELECT p.`virtuemart_product_id` FROM `bn9fo_virtuemart_products` as p
LEFT JOIN `bn9fo_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = pc.`virtuemart_product_id` WHERE (p.`product_parent_id` = "3" OR p.`virtuemart_product_id` = "3") AND p.`published`="1" GROUP BY p.`virtuemart_product_id` ORDER BY p.pordering ASC
296μs536B/administrator/components/com_virtuemart/models/product.php:3530CopySELECT `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"
158μ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`
83μs536B/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78CopySELECT `language`,`id`
FROM `bn9fo_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
283μ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
216μ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`
798μs163.34KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT * FROM bn9fo_acym_list WHERE `type` = 'standard'
182μs1.66KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM bn9fo_acym_field WHERE `id` IN(2) ORDER BY `ordering` ASC
100μs2.38KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT article.id, article.alias, article.catid, cat.alias AS catalias, article.language
FROM bn9fo_content AS article
LEFT JOIN bn9fo_categories AS cat ON cat.id = article.catid
WHERE article.id = 3 LIMIT 1
100μs768B/administrator/components/com_acym/libraries/joomla/database.php:45CopySELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug`
FROM `bn9fo_categories` AS `s`
INNER JOIN `bn9fo_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
300μs3.97KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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
380μs1.86KB/components/com_customfilters/include/tools.php:606CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=3
128μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=4
114μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=5
69μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=6
113μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=7
90μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=8
69μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=9
85μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=11
70μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=12
83μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=13
98μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=21
89μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=18
80μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=20
64μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=22
58μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=23
68μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=24
54μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=25
56μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=26
56μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=27
50μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=28
52μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=29
52μs536B/plugins/system/customfieldsforallbase/Model/Customfield.php:1083CopySELECT custom_params
FROM bn9fo_virtuemart_customs
WHERE virtuemart_custom_id=30
51μ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
520μs1.73KB/components/com_customfilters/include/tools.php:606CopySELECT virtuemart_shoppergroup_id
FROM bn9fo_virtuemart_vmuser_shoppergroups
WHERE virtuemart_user_id=0
72μ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
230μ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 (12)
GROUP BY `vm`.`virtuemart_manufacturer_id`
ORDER BY name ASC
627μs768B/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
586μ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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=3
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
1.92ms736B/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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=13
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
1.01ms640B/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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=21
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
1.36ms640B/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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=18
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
1.49ms640B/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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=20
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
1.34ms640B/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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=22
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
1.32ms640B/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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=23
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
1.37ms640B/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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=24
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
1.03ms640B/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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=25
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
919μ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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=26
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
916μ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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=27
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
960μ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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=28
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
926μ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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=29
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
914μ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 bn9fo_virtuemart_custom_plg_customsforall_values 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 (12) AND cf.virtuemart_custom_id=30
GROUP BY cfp.customsforall_value_id
ORDER BY cf.ordering
526μ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
109μ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
84μ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 (12)
81μ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 (19)
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 (118)
60μ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 (10)
56μ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 (12)
56μ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 (4)
56μ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 (1)
55μ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 (2)
55μ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 (11)
62μ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
234μ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
561μs4.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT 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
557μ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-04 20:09:12" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-01-04 20:09:12" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
285μ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-04 20:09:12" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-01-04 20:09:12" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
264μ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-04 20:09:12" )
AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-01-04 20:09:12" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
261μs3.11KB/administrator/components/com_virtuemart/helpers/calculationh.php:1521CopySELECT * FROM bn9fo_acym_list WHERE type = 'standard'
181μs1.66KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM bn9fo_acym_field
154μs2.41KB/administrator/components/com_acym/libraries/joomla/database.php:30CopySELECT * FROM bn9fo_acym_form WHERE active = 1 AND type != 'shortcode'
105μ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
115μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `value` FROM bn9fo_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
228μs552B/plugins/system/acymtriggers/acymtriggers.php:214CopySHOW TABLES
806μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT `session_id`
FROM `bn9fo_session`
WHERE `session_id` = ?
139μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `bn9fo_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
3.19ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy