Performance Benchmarks
Total Execution Time
0.6737s
Detailed Benchmarks
Theme Layout Start: 0.0048sTheme Layout End: 0.0038sTheme Footer End: 0.0011sBefore Vue Data: 0.0010sAfter Vue Data: 0.0006sTheme Scripts End: 0.0002s
Database Query Monitor
Total Queries: 111 |
Total Time: 0.62040114402771s
Query #1
0.0004s
SELECT *
FROM `fc_app_settings`
WHERE `vartype` = '1'
AND `vartype` != '0'
ORDER BY `id`
Query #2
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'isSetAutologoffOnPeriod'
Query #3
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'isSetAutologoffOnPeriodInactive'
Query #4
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'redirIfMustResetPwd'
Query #5
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'mustResetPwdActive'
Query #6
0.0003s
SELECT *
FROM `fc_app_settings`
WHERE `autoload` = 1
AND `vartype` != 1
Query #7
0.0001s
SELECT GET_LOCK('04b8e03ac8e556be1cb462571db86a5c', 300) AS ci_session_lock
Query #8
0.0001s
SELECT `data`
FROM `fc_sessions`
WHERE `id` = '0554da2bd2094500f6a7f100f5c7e6a690cf77e7'
AND `ip_address` = '18.97.14.84'
Query #9
0.0022s
SELECT *
FROM `fc_app_sectionDefine`
WHERE `class` = 'shop_static'
AND `func` = 'product_category'
Query #10
0.0001s
SELECT *
FROM `fc_plugins`
Query #11
0.0001s
UPDATE `fc_plugins` SET `plugin_system_name` = 'finecart_core', `plugin_name` = 'FineCart Core', `plugin_uri` = 'https://tmedia.ro', `plugin_version` = '1.0', `plugin_description` = 'Finecart Base Plugin', `plugin_author` = 'Coman Paul', `plugin_author_uri` = 'https://tmedia.ro'
WHERE `plugin_system_name` = 'finecart_core'
Query #12
0.0001s
SELECT *
FROM `fc_plugins`
Query #13
0.0001s
UPDATE `fc_plugins` SET `plugin_system_name` = 'finecart_core', `plugin_name` = 'FineCart Core', `plugin_uri` = 'https://tmedia.ro', `plugin_version` = '1.0', `plugin_description` = 'Finecart Base Plugin', `plugin_author` = 'Coman Paul', `plugin_author_uri` = 'https://tmedia.ro'
WHERE `plugin_system_name` = 'finecart_core'
Query #14
0.0001s
UPDATE `fc_plugins` SET `plugin_system_name` = 'stickyelements', `plugin_name` = 'Sticky Elements', `plugin_uri` = 'https://tmedia.ro', `plugin_version` = '1.0', `plugin_description` = '', `plugin_author` = 'Coman Paul', `plugin_author_uri` = 'https://tmedia.ro'
WHERE `plugin_system_name` = 'stickyelements'
Query #15
0.0001s
SELECT *
FROM `fc_plugins`
Query #16
0.0001s
UPDATE `fc_plugins` SET `plugin_system_name` = 'finecart_core', `plugin_name` = 'FineCart Core', `plugin_uri` = 'https://tmedia.ro', `plugin_version` = '1.0', `plugin_description` = 'Finecart Base Plugin', `plugin_author` = 'Coman Paul', `plugin_author_uri` = 'https://tmedia.ro'
WHERE `plugin_system_name` = 'finecart_core'
Query #17
0.0001s
UPDATE `fc_plugins` SET `plugin_system_name` = 'stickyelements', `plugin_name` = 'Sticky Elements', `plugin_uri` = 'https://tmedia.ro', `plugin_version` = '1.0', `plugin_description` = '', `plugin_author` = 'Coman Paul', `plugin_author_uri` = 'https://tmedia.ro'
WHERE `plugin_system_name` = 'stickyelements'
Query #18
0.0001s
UPDATE `fc_plugins` SET `plugin_system_name` = 'stickyelements', `plugin_name` = 'Sticky Elements', `plugin_uri` = 'https://tmedia.ro', `plugin_version` = '1.0', `plugin_description` = '', `plugin_author` = 'Coman Paul', `plugin_author_uri` = 'https://tmedia.ro'
WHERE `plugin_system_name` = 'stickyelements'
Query #19
0.0001s
SELECT *
FROM `fc_migrations`
LIMIT 1
Query #20
0.0001s
SELECT *
FROM `fc_modules`
Query #21
0.0337s
SELECT `id`
FROM `fc_usertracking`
WHERE `timestamp` < 1753192081
OR `register_date` < '2025-07-22 16:48:01'
Query #22
0.1049s
DELETE FROM `fc_usertracking`
WHERE `timestamp` < 1753192081
OR `register_date` < '2025-07-22 16:48:01'
Query #23
0.0005s
SELECT *
FROM `fc_app_settings`
WHERE `var` = 'affiliate_url_parameter'
Query #24
0.0002s
SELECT *
FROM `fc_app_settings`
WHERE `var` = 'affiliate_cookie_lifetime_days'
Query #25
0.0001s
SELECT *
FROM `fc_siteUsers`
WHERE `userId` IS NULL
Query #26
0.0004s
SELECT *
FROM `fc_usertracking_ip`
WHERE `ip_address` = '18.97.14.84'
AND `updated_at` > '2026-07-21 16:48:01'
ORDER BY `id` DESC
LIMIT 1
Query #27
0.0000s
INSERT INTO `fc_usertracking` (`session_id`, `request_uri`, `timestamp`, `client_ip`, `client_user_agent`, `referer_page`, `is_browser`, `is_mobile`, `is_robot`, `is_referral`, `browser`, `browser_version`, `mobile`, `robot`, `platform`, `router_class`, `router_method`, `router_directory`, `router_module`, `http_response_code`, `affiliate_id`, `user_id`, `admin_user_id`, `host_name`, `REMOTE_ADDR`, `custom_params`, `request_method`, `ua_type`, `is_suspicious`, `bot_name`, `accept_language`, `content_type`, `current_url`, `url_schema`, `url_port`, `url_path`, `actual_link`, `link_path`, `is_ssl`, `http_request_headers`, `post_data`, `get_qs`, `session_data`, `register_date`, `traffic_source`, `asn_number`, `asn_name`, `datacenter_host`) VALUES ('0554da2bd2094500f6a7f100f5c7e6a690cf77e7', '/categorie/balsam-de-buze', 1784728081, '18.97.14.84', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '', 0, 0, 1, 0, '', '', '', '', 'Unknown Platform', 'shop_static', 'product_category', '../../mod/filter/controllers/', 'filter', 200, NULL, NULL, 0, '18-97-14-84.crawl.commoncrawl.org', '18.97.14.84', '{\"csp_nonce\":\"genlzAFDQBIS3vuY\",\"ua_parsed\":{\"raw\":\"CCBot\\/2.0 (https:\\/\\/commoncrawl.org\\/faq\\/)\",\"ua_type\":\"bot\",\"bot_category\":\"search_engine\",\"is_suspicious\":false,\"os_name\":null,\"os_version\":null,\"browser_name\":\"CCBot\\/CommonCrawl\",\"browser_version\":null,\"device_type\":\"bot\",\"engine\":null}}', 'GET', 'bot', 0, 'CCBot/CommonCrawl', 'en-US,en;q=0.5', 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'https://www.tropeum.ro/categorie/balsam-de-buze', '{\"scheme\":\"https\",\"host\":\"www.tropeum.ro\",\"path\":\"\\/categorie\\/balsam-de-buze\"}', NULL, '/categorie/balsam-de-buze', 'https://www.tropeum.ro/categorie/balsam-de-buze', 'categoriebalsam-de-buze', 0, '{\"X-Https\":\"1\",\"Host\":\"www.tropeum.ro\",\"Accept-Encoding\":\"zstd, br, gzip\",\"If-Modified-Since\":\"Tue, 17 Feb 2026 17:48:03 GMT\",\"Accept-Language\":\"en-US,en;q=0.5\",\"Accept\":\"text\\/html,application\\/xhtml+xml,application\\/xml;q=0.9,*\\/*;q=0.8\",\"User-Agent\":\"CCBot\\/2.0 (https:\\/\\/commoncrawl.org\\/faq\\/)\"}', NULL, NULL, '{\"__ci_last_regenerate\":1784728081}', '2026-07-22 16:48:01', 'direct', '14618', 'AMAZON-AES - Amazon.com, Inc.', '18-97-14-84.crawl.commoncrawl.org')
Query #28
0.0001s
DELETE FROM `fc_whos_online`
WHERE `time_last_click` < '1784727781'
Query #29
0.0001s
SELECT *
FROM `fc_whos_online`
WHERE `session_id` = '0554da2bd2094500f6a7f100f5c7e6a690cf77e7'
Query #30
0.0001s
INSERT INTO `fc_whos_online` (`customer_id`, `admin_id`, `full_name`, `session_id`, `ip_address`, `time_last_click`, `last_page_url`, `host_address`, `user_agent`, `visitor_id`, `time_entry`) VALUES (NULL, NULL, '', '0554da2bd2094500f6a7f100f5c7e6a690cf77e7', '18.97.14.84', '1784728081', '/categorie/balsam-de-buze', '18-97-14-84.crawl.commoncrawl.org', 'CCBot/2.0 (https://commoncrawl.org/faq/)', NULL, '1784728081')
Query #31
0.0001s
SELECT *
FROM `fc_siteUsers`
WHERE `userId` IS NULL
Query #32
0.0002s
SELECT *
FROM `fc_app_settings`
WHERE `var` = 'affiliate_program_enabled'
Query #33
0.0002s
SELECT *
FROM `fc_product_category`
WHERE `category_slug` = 'balsam-de-buze'
AND `fc_product_category`.`is_active` = 1
Query #34
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `id_category` = '59'
AND `fc_product_category`.`is_active` = 1
Query #35
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '60'
AND `is_active` = 1
Query #36
0.0001s
SELECT `id_category`, `category_name`, `category_slug`, `parent_id`
FROM `fc_product_category`
WHERE `is_active` = 1
AND `id_category` = '60'
ORDER BY `id_category` ASC
Query #37
0.0001s
SELECT `id_category`, `category_name`, `category_slug`, `parent_id`
FROM `fc_product_category`
WHERE `is_active` = 1
AND `id_category` = '59'
ORDER BY `id_category` ASC
Query #38
0.0000s
SELECT `id_category`, `category_name`, `category_slug`, `parent_id`
FROM `fc_product_category`
WHERE `is_active` = 1
AND `id_category` = '58'
ORDER BY `id_category` ASC
Query #39
0.0000s
SELECT `id_category`, `category_name`, `category_slug`, `parent_id`
FROM `fc_product_category`
WHERE `is_active` = 1
AND `id_category` = '0'
ORDER BY `id_category` ASC
Query #40
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '60'
Query #41
0.0006s
SELECT `fc_product_attributes`.`attr_id`, `fc_product_attributes`.`attr_name`, `fc_product_attributes`.`attr_type`, `fc_product_attributes`.`attr_slug`, `fc_product_attributes`.`attr_mu`
FROM `fc_products`
JOIN `fc_product_attribute_values` ON `fc_product_attribute_values`.`id_product` = `fc_products`.`product_id`
JOIN `fc_product_attributes` ON `fc_product_attributes`.`attr_id` = `fc_product_attribute_values`.`id_attribute`
WHERE `fc_products`.`main_category_id` IN('60')
AND `fc_product_attributes`.`is_filterable` = 1
GROUP BY `fc_product_attributes`.`attr_id`, `fc_product_attributes`.`attr_name`
ORDER BY `fc_product_attributes`.`sortOrder` ASC
Query #42
0.0002s
INSERT INTO `fc_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('0554da2bd2094500f6a7f100f5c7e6a690cf77e7', '18.97.14.84', 1784728081, '__ci_last_regenerate|i:1784728081;')
Query #43
0.0001s
SELECT RELEASE_LOCK('04b8e03ac8e556be1cb462571db86a5c') AS ci_session_lock
Query #44
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'shop_settings'
Query #45
0.0193s
SELECT COUNT(*) AS `numrows`
FROM (
SELECT `fc_products`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_nom_stock_availability`.`name` as `tx_stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id` AND `fc_product_category`.`is_active` = 1
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
WHERE (
`fc_products`.`is_active` = 1
)
AND `fc_products`.`id_parent` IS NULL
AND (
(
(fc_products.main_category_id = "60")
)
OR (fc_products.product_id IN ( select id_product FROM fc_product_to_category WHERE id_category IN (60) ) )
)
GROUP BY `fc_products`.`product_id`
) CI_count_all_results
Query #46
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'shop_settings'
Query #47
0.0209s
SELECT `fc_products`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_nom_stock_availability`.`name` as `tx_stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id` AND `fc_product_category`.`is_active` = 1
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
WHERE (
`fc_products`.`is_active` = 1
)
AND `fc_products`.`id_parent` IS NULL
AND (
(
(fc_products.main_category_id = "60")
)
OR (fc_products.product_id IN ( select id_product FROM fc_product_to_category WHERE id_category IN (60) ) )
)
GROUP BY `fc_products`.`product_id`
ORDER BY `fc_products`.`id_source` ASC, `fc_products`.`cache_max_price` DESC
LIMIT 30
Query #48
0.0003s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '17099'
LIMIT 2
Query #49
0.0002s
SELECT `fc_products`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`category_image`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
WHERE `is_variable` = 1
AND `fc_products`.`product_id` IS NULL
AND `fc_products`.`is_active` = 1
Query #50
0.0002s
SELECT *
FROM `fc_product_attribute_values`
JOIN `fc_product_attributes` ON `fc_product_attributes`.`attr_id` = `fc_product_attribute_values`.`id_attribute`
WHERE `id_product` = '17099'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #51
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '23225'
LIMIT 2
Query #52
0.0001s
SELECT `fc_products`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`category_image`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
WHERE `is_variable` = 1
AND `fc_products`.`product_id` IS NULL
AND `fc_products`.`is_active` = 1
Query #53
0.0001s
SELECT *
FROM `fc_product_attribute_values`
JOIN `fc_product_attributes` ON `fc_product_attributes`.`attr_id` = `fc_product_attribute_values`.`id_attribute`
WHERE `id_product` = '23225'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #54
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '17093'
LIMIT 2
Query #55
0.0001s
SELECT `fc_products`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`category_image`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
WHERE `is_variable` = 1
AND `fc_products`.`product_id` IS NULL
AND `fc_products`.`is_active` = 1
Query #56
0.0001s
SELECT *
FROM `fc_product_attribute_values`
JOIN `fc_product_attributes` ON `fc_product_attributes`.`attr_id` = `fc_product_attribute_values`.`id_attribute`
WHERE `id_product` = '17093'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #57
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '59167'
LIMIT 2
Query #58
0.0001s
SELECT `fc_products`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`category_image`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
WHERE `is_variable` = 1
AND `fc_products`.`product_id` IS NULL
AND `fc_products`.`is_active` = 1
Query #59
0.0003s
SELECT *
FROM `fc_product_attribute_values`
JOIN `fc_product_attributes` ON `fc_product_attributes`.`attr_id` = `fc_product_attribute_values`.`id_attribute`
WHERE `id_product` = '59167'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #60
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '59165'
LIMIT 2
Query #61
0.0001s
SELECT `fc_products`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`category_image`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
WHERE `is_variable` = 1
AND `fc_products`.`product_id` IS NULL
AND `fc_products`.`is_active` = 1
Query #62
0.0003s
SELECT *
FROM `fc_product_attribute_values`
JOIN `fc_product_attributes` ON `fc_product_attributes`.`attr_id` = `fc_product_attribute_values`.`id_attribute`
WHERE `id_product` = '59165'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #63
0.0002s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '23221'
LIMIT 2
Query #64
0.0002s
SELECT `fc_products`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`category_image`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
WHERE `is_variable` = 1
AND `fc_products`.`product_id` IS NULL
AND `fc_products`.`is_active` = 1
Query #65
0.0002s
SELECT *
FROM `fc_product_attribute_values`
JOIN `fc_product_attributes` ON `fc_product_attributes`.`attr_id` = `fc_product_attribute_values`.`id_attribute`
WHERE `id_product` = '23221'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #66
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '23212'
LIMIT 2
Query #67
0.0001s
SELECT `fc_products`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`category_image`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
WHERE `is_variable` = 1
AND `fc_products`.`product_id` IS NULL
AND `fc_products`.`is_active` = 1
Query #68
0.0002s
SELECT *
FROM `fc_product_attribute_values`
JOIN `fc_product_attributes` ON `fc_product_attributes`.`attr_id` = `fc_product_attribute_values`.`id_attribute`
WHERE `id_product` = '23212'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #69
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '23216'
LIMIT 2
Query #70
0.0001s
SELECT `fc_products`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`category_image`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
WHERE `is_variable` = 1
AND `fc_products`.`product_id` IS NULL
AND `fc_products`.`is_active` = 1
Query #71
0.0002s
SELECT *
FROM `fc_product_attribute_values`
JOIN `fc_product_attributes` ON `fc_product_attributes`.`attr_id` = `fc_product_attribute_values`.`id_attribute`
WHERE `id_product` = '23216'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #72
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '23227'
LIMIT 2
Query #73
0.0001s
SELECT `fc_products`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`category_image`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
WHERE `is_variable` = 1
AND `fc_products`.`product_id` IS NULL
AND `fc_products`.`is_active` = 1
Query #74
0.0001s
SELECT *
FROM `fc_product_attribute_values`
JOIN `fc_product_attributes` ON `fc_product_attributes`.`attr_id` = `fc_product_attribute_values`.`id_attribute`
WHERE `id_product` = '23227'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #75
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '25444'
LIMIT 2
Query #76
0.0001s
SELECT `fc_products`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`category_image`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
WHERE `is_variable` = 1
AND `fc_products`.`product_id` IS NULL
AND `fc_products`.`is_active` = 1
Query #77
0.0001s
SELECT *
FROM `fc_product_attribute_values`
JOIN `fc_product_attributes` ON `fc_product_attributes`.`attr_id` = `fc_product_attribute_values`.`id_attribute`
WHERE `id_product` = '25444'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #78
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '1273'
LIMIT 2
Query #79
0.0001s
SELECT `fc_products`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`category_image`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
WHERE `is_variable` = 1
AND `fc_products`.`product_id` IS NULL
AND `fc_products`.`is_active` = 1
Query #80
0.0002s
SELECT *
FROM `fc_product_attribute_values`
JOIN `fc_product_attributes` ON `fc_product_attributes`.`attr_id` = `fc_product_attribute_values`.`id_attribute`
WHERE `id_product` = '1273'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #81
0.0001s
SELECT *
FROM `fc_siteUsers`
WHERE `userId` IS NULL
Query #82
0.0001s
SELECT *
FROM `fc_product_attributes`
WHERE `attr_slug` = 'color'
Query #83
0.0001s
SELECT *
FROM `fc_product_attributes`
WHERE `attr_slug` = 'brand'
Query #84
0.0001s
SELECT *
FROM `fc_product_attributes`
WHERE `attr_slug` = 'color-hex'
Query #85
0.0001s
SELECT *
FROM `fc_product_attributes`
WHERE `attr_slug` = 'material'
Query #86
0.0001s
SELECT *
FROM `fc_product_attributes`
WHERE `attr_slug` = 'size'
Query #87
0.1680s
SELECT pa.attr_id, pa.attr_name, pa.attr_slug, pa.attr_mu, pag.attr_group_id, pag.attr_group_name, COUNT(DISTINCT pav.id_product) as product_count
FROM `fc_product_attributes` `pa`
LEFT JOIN `fc_product_attribute_values` `pav` ON `pa`.`attr_id` = `pav`.`id_attribute`
INNER JOIN `fc_product_attributes` `pa_check` ON `pa_check`.`attr_id` = `pa`.`attr_id`
LEFT JOIN `fc_attributes_in_groups` `aig` ON `aig`.`id_attribute` = `pa`.`attr_id`
LEFT JOIN `fc_product_attribute_group` `pag` ON `pag`.`attr_group_id` = `aig`.`id_attr_group`
GROUP BY `pa`.`attr_id`
ORDER BY `pag`.`attr_group_name` ASC, `pa`.`attr_name` ASC
Query #88
0.2552s
SELECT
pa.attr_id,
pa.attr_name,
pa.attr_slug,
pa.attr_mu,
pa.field_type,
pa.is_variation,
pa.is_filterable,
pav.attr_val,
pav.val_slug,
pav.color,
COUNT(DISTINCT
CASE WHEN fc_products.id_parent IS NOT NULL AND fc_products.id_parent > 0
THEN fc_products.id_parent
ELSE fc_products.product_id
END
) as product_count
FROM fc_product_attribute_values pav
INNER JOIN fc_product_attributes pa ON pa.attr_id = pav.id_attribute
INNER JOIN fc_products ON fc_products.product_id = pav.id_product
WHERE fc_products.is_active = 1 AND (fc_products.main_category_id IN (60) OR fc_products.product_id IN (SELECT id_product FROM fc_product_to_category WHERE id_category IN (60)))
AND pa.is_filterable = 1
GROUP BY pa.attr_id, pav.attr_val
ORDER BY pa.sortOrder ASC, pa.attr_name ASC, pav.attr_val ASC
Query #89
0.0004s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'site_verifications'
Query #90
0.0003s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'conversion_tracking'
Query #91
0.0002s
SELECT *
FROM `fc_site_menus`
WHERE `id` = 1
Query #92
0.0003s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'shop_logo'
Query #93
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'wolmart_settings'
Query #94
0.0003s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone'
Query #95
0.0003s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'shop_logo'
Query #96
0.0003s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'wolmart_settings'
Query #97
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone2'
Query #98
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'contact_email'
Query #99
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'shop_logo'
Query #100
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'wolmart_settings'
Query #101
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'company_name'
Query #102
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'vat_number'
Query #103
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone'
Query #104
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone_read'
Query #105
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone2'
Query #106
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone_read2'
Query #107
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'contact_email'
Query #108
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'contact_email'
Query #109
0.0001s
SELECT *
FROM `fc_siteUsers`
WHERE `userId` IS NULL
Query #110
0.0002s
SELECT `fc_product_favorites`.*, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*
FROM `fc_product_favorites`
JOIN `fc_products` ON `fc_products`.`product_id` = `fc_product_favorites`.`id_product`
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
WHERE `id_user` IS NULL
Query #111
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'conversion_tracking'
Static Page Cache
Current URI: /categorie/balsam-de-buze
Cacheable Route: Yes
Currently Cached: No
Total Cached Files: 22
Total Cache Size: 17.30 MB
