Performance Benchmarks
Total Execution Time
1.5569s
Detailed Benchmarks
Theme Layout Start: 0.0096sTheme Layout End: 0.0030sTheme Footer End: 0.0009sBefore Vue Data: 0.0008sAfter Vue Data: 0.0005sTheme Scripts End: 0.0002s
Database Query Monitor
Total Queries: 193 |
Total Time: 1.515725851059s
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.0002s
SELECT *
FROM `fc_app_settings`
WHERE `autoload` = 1
AND `vartype` != 1
Query #7
0.0001s
SELECT GET_LOCK('ab36f1709c1a9f941e0e3173d7e1d73f', 300) AS ci_session_lock
Query #8
0.0001s
SELECT `data`
FROM `fc_sessions`
WHERE `id` = '41086b3aa212e714c8ccc8333b7991bb068f595c'
AND `ip_address` = '3.41.188.32'
Query #9
0.0019s
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.0000s
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.0000s
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.0000s
SELECT *
FROM `fc_migrations`
LIMIT 1
Query #20
0.0000s
SELECT *
FROM `fc_modules`
Query #21
0.0000s
SELECT *
FROM `fc_siteUsers`
WHERE `userId` IS NULL
Query #22
0.0002s
SELECT *
FROM `fc_app_settings`
WHERE `var` = 'affiliate_url_parameter'
Query #23
0.0002s
SELECT *
FROM `fc_app_settings`
WHERE `var` = 'affiliate_cookie_lifetime_days'
Query #24
0.0002s
SELECT *
FROM `fc_app_settings`
WHERE `var` = 'affiliate_program_enabled'
Query #25
0.0003s
SELECT *
FROM `fc_product_category`
WHERE `category_slug` = 'articole-textile'
AND `fc_product_category`.`is_active` = 1
Query #26
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '127'
AND `is_active` = 1
Query #27
0.0001s
SELECT `id_category`, `category_name`, `category_slug`, `parent_id`
FROM `fc_product_category`
WHERE `is_active` = 1
AND `id_category` = '127'
ORDER BY `id_category` ASC
Query #28
0.0002s
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 #29
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '127'
Query #30
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '128'
Query #31
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '129'
Query #32
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '130'
Query #33
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '131'
Query #34
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '132'
Query #35
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '133'
Query #36
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '134'
Query #37
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '135'
Query #38
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '136'
Query #39
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '137'
Query #40
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '138'
Query #41
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '139'
Query #42
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '140'
Query #43
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '141'
Query #44
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '142'
Query #45
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '143'
Query #46
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '144'
Query #47
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '145'
Query #48
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '146'
Query #49
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '147'
Query #50
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '148'
Query #51
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '149'
Query #52
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '150'
Query #53
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '151'
Query #54
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '152'
Query #55
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '153'
Query #56
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '154'
Query #57
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '155'
Query #58
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '156'
Query #59
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '157'
Query #60
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '158'
Query #61
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '159'
Query #62
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '160'
Query #63
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '161'
Query #64
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '162'
Query #65
0.0001s
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '163'
Query #66
0.0002s
INSERT INTO `fc_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('41086b3aa212e714c8ccc8333b7991bb068f595c', '3.41.188.32', 1788872189, '__ci_last_regenerate|i:1788872189;')
Query #67
0.0001s
SELECT RELEASE_LOCK('ab36f1709c1a9f941e0e3173d7e1d73f') AS ci_session_lock
Query #68
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'shop_settings'
Query #69
0.0273s
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 = "127")
AND (fc_products.main_category_id = "128")
OR (fc_products.main_category_id = "128")
AND (fc_products.main_category_id = "132")
OR (fc_products.main_category_id = "132")
AND (fc_products.main_category_id = "133")
OR (fc_products.main_category_id = "133")
AND (fc_products.main_category_id = "134")
OR (fc_products.main_category_id = "134")
AND (fc_products.main_category_id = "135")
OR (fc_products.main_category_id = "135")
AND (fc_products.main_category_id = "136")
OR (fc_products.main_category_id = "136")
AND (fc_products.main_category_id = "139")
OR (fc_products.main_category_id = "139")
AND (fc_products.main_category_id = "144")
OR (fc_products.main_category_id = "144")
AND (fc_products.main_category_id = "147")
OR (fc_products.main_category_id = "147")
AND (fc_products.main_category_id = "150")
OR (fc_products.main_category_id = "150")
AND (fc_products.main_category_id = "151")
OR (fc_products.main_category_id = "151")
AND (fc_products.main_category_id = "152")
OR (fc_products.main_category_id = "152")
AND (fc_products.main_category_id = "153")
OR (fc_products.main_category_id = "153")
AND (fc_products.main_category_id = "161")
OR (fc_products.main_category_id = "161")
AND (fc_products.main_category_id = "129")
OR (fc_products.main_category_id = "129")
AND (fc_products.main_category_id = "130")
OR (fc_products.main_category_id = "130")
AND (fc_products.main_category_id = "131")
OR (fc_products.main_category_id = "131")
AND (fc_products.main_category_id = "137")
OR (fc_products.main_category_id = "137")
AND (fc_products.main_category_id = "138")
OR (fc_products.main_category_id = "138")
AND (fc_products.main_category_id = "140")
OR (fc_products.main_category_id = "140")
AND (fc_products.main_category_id = "141")
OR (fc_products.main_category_id = "141")
AND (fc_products.main_category_id = "142")
OR (fc_products.main_category_id = "142")
AND (fc_products.main_category_id = "143")
OR (fc_products.main_category_id = "143")
AND (fc_products.main_category_id = "145")
OR (fc_products.main_category_id = "145")
AND (fc_products.main_category_id = "146")
OR (fc_products.main_category_id = "146")
AND (fc_products.main_category_id = "148")
OR (fc_products.main_category_id = "148")
AND (fc_products.main_category_id = "149")
OR (fc_products.main_category_id = "149")
AND (fc_products.main_category_id = "154")
OR (fc_products.main_category_id = "154")
AND (fc_products.main_category_id = "155")
OR (fc_products.main_category_id = "155")
AND (fc_products.main_category_id = "156")
OR (fc_products.main_category_id = "156")
AND (fc_products.main_category_id = "157")
OR (fc_products.main_category_id = "157")
AND (fc_products.main_category_id = "158")
OR (fc_products.main_category_id = "158")
AND (fc_products.main_category_id = "159")
OR (fc_products.main_category_id = "159")
AND (fc_products.main_category_id = "160")
OR (fc_products.main_category_id = "160")
AND (fc_products.main_category_id = "162")
OR (fc_products.main_category_id = "162")
AND (fc_products.main_category_id = "163")
OR (fc_products.main_category_id = "163")
)
OR (fc_products.product_id IN ( select id_product FROM fc_product_to_category WHERE id_category IN (127,128,132,133,134,135,136,139,144,147,150,151,152,153,161,129,130,131,137,138,140,141,142,143,145,146,148,149,154,155,156,157,158,159,160,162,163) ) )
)
GROUP BY `fc_products`.`product_id`
) CI_count_all_results
Query #70
0.0003s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'shop_settings'
Query #71
0.0251s
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 = "127")
AND (fc_products.main_category_id = "128")
OR (fc_products.main_category_id = "128")
AND (fc_products.main_category_id = "132")
OR (fc_products.main_category_id = "132")
AND (fc_products.main_category_id = "133")
OR (fc_products.main_category_id = "133")
AND (fc_products.main_category_id = "134")
OR (fc_products.main_category_id = "134")
AND (fc_products.main_category_id = "135")
OR (fc_products.main_category_id = "135")
AND (fc_products.main_category_id = "136")
OR (fc_products.main_category_id = "136")
AND (fc_products.main_category_id = "139")
OR (fc_products.main_category_id = "139")
AND (fc_products.main_category_id = "144")
OR (fc_products.main_category_id = "144")
AND (fc_products.main_category_id = "147")
OR (fc_products.main_category_id = "147")
AND (fc_products.main_category_id = "150")
OR (fc_products.main_category_id = "150")
AND (fc_products.main_category_id = "151")
OR (fc_products.main_category_id = "151")
AND (fc_products.main_category_id = "152")
OR (fc_products.main_category_id = "152")
AND (fc_products.main_category_id = "153")
OR (fc_products.main_category_id = "153")
AND (fc_products.main_category_id = "161")
OR (fc_products.main_category_id = "161")
AND (fc_products.main_category_id = "129")
OR (fc_products.main_category_id = "129")
AND (fc_products.main_category_id = "130")
OR (fc_products.main_category_id = "130")
AND (fc_products.main_category_id = "131")
OR (fc_products.main_category_id = "131")
AND (fc_products.main_category_id = "137")
OR (fc_products.main_category_id = "137")
AND (fc_products.main_category_id = "138")
OR (fc_products.main_category_id = "138")
AND (fc_products.main_category_id = "140")
OR (fc_products.main_category_id = "140")
AND (fc_products.main_category_id = "141")
OR (fc_products.main_category_id = "141")
AND (fc_products.main_category_id = "142")
OR (fc_products.main_category_id = "142")
AND (fc_products.main_category_id = "143")
OR (fc_products.main_category_id = "143")
AND (fc_products.main_category_id = "145")
OR (fc_products.main_category_id = "145")
AND (fc_products.main_category_id = "146")
OR (fc_products.main_category_id = "146")
AND (fc_products.main_category_id = "148")
OR (fc_products.main_category_id = "148")
AND (fc_products.main_category_id = "149")
OR (fc_products.main_category_id = "149")
AND (fc_products.main_category_id = "154")
OR (fc_products.main_category_id = "154")
AND (fc_products.main_category_id = "155")
OR (fc_products.main_category_id = "155")
AND (fc_products.main_category_id = "156")
OR (fc_products.main_category_id = "156")
AND (fc_products.main_category_id = "157")
OR (fc_products.main_category_id = "157")
AND (fc_products.main_category_id = "158")
OR (fc_products.main_category_id = "158")
AND (fc_products.main_category_id = "159")
OR (fc_products.main_category_id = "159")
AND (fc_products.main_category_id = "160")
OR (fc_products.main_category_id = "160")
AND (fc_products.main_category_id = "162")
OR (fc_products.main_category_id = "162")
AND (fc_products.main_category_id = "163")
OR (fc_products.main_category_id = "163")
)
OR (fc_products.product_id IN ( select id_product FROM fc_product_to_category WHERE id_category IN (127,128,132,133,134,135,136,139,144,147,150,151,152,153,161,129,130,131,137,138,140,141,142,143,145,146,148,149,154,155,156,157,158,159,160,162,163) ) )
)
GROUP BY `fc_products`.`product_id`
ORDER BY `fc_products`.`id_source` ASC, `fc_products`.`cache_max_price` DESC
LIMIT 30
Query #72
0.0002s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '6516'
LIMIT 2
Query #73
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 #74
0.0008s
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` = '6516'
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` = '6840'
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.0006s
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` = '6840'
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` = '58453'
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.0006s
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` = '58453'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #81
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '6590'
LIMIT 2
Query #82
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 #83
0.0005s
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` = '6590'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #84
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '6923'
LIMIT 2
Query #85
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 #86
0.0006s
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` = '6923'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #87
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '9701'
LIMIT 2
Query #88
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 #89
0.0006s
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` = '9701'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #90
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '58482'
LIMIT 2
Query #91
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 #92
0.0005s
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` = '58482'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #93
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '6549'
LIMIT 2
Query #94
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 #95
0.0007s
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` = '6549'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #96
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '6876'
LIMIT 2
Query #97
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 #98
0.0008s
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` = '6876'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #99
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '9623'
LIMIT 2
Query #100
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 #101
0.0006s
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` = '9623'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #102
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '9050'
LIMIT 2
Query #103
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 #104
0.0005s
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` = '9050'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #105
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '9870'
LIMIT 2
Query #106
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 #107
0.0004s
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` = '9870'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #108
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '9471'
LIMIT 2
Query #109
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 #110
0.0008s
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` = '9471'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #111
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '8929'
LIMIT 2
Query #112
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 #113
0.0008s
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` = '8929'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #114
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '9658'
LIMIT 2
Query #115
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 #116
0.0005s
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` = '9658'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #117
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '9568'
LIMIT 2
Query #118
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 #119
0.0006s
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` = '9568'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #120
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '9272'
LIMIT 2
Query #121
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 #122
0.0008s
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` = '9272'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #123
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '9407'
LIMIT 2
Query #124
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 #125
0.0007s
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` = '9407'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #126
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '9085'
LIMIT 2
Query #127
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 #128
0.0010s
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` = '9085'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #129
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '8437'
LIMIT 2
Query #130
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 #131
0.0011s
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` = '8437'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #132
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '58776'
LIMIT 2
Query #133
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 #134
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` = '58776'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #135
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '8728'
LIMIT 2
Query #136
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 #137
0.0010s
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` = '8728'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #138
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '8868'
LIMIT 2
Query #139
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 #140
0.0005s
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` = '8868'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #141
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '8541'
LIMIT 2
Query #142
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 #143
0.0011s
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` = '8541'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #144
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '4924'
LIMIT 2
Query #145
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 #146
0.0004s
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` = '4924'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #147
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '8237'
LIMIT 2
Query #148
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 #149
0.0012s
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` = '8237'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #150
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '8376'
LIMIT 2
Query #151
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 #152
0.0009s
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` = '8376'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #153
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '7038'
LIMIT 2
Query #154
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 #155
0.0007s
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` = '7038'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #156
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '6730'
LIMIT 2
Query #157
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 #158
0.0009s
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` = '6730'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #159
0.0001s
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '8019'
LIMIT 2
Query #160
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 #161
0.0015s
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` = '8019'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
Query #162
0.0001s
SELECT *
FROM `fc_siteUsers`
WHERE `userId` IS NULL
Query #163
0.0001s
SELECT *
FROM `fc_product_attributes`
WHERE `attr_slug` = 'color'
Query #164
0.0001s
SELECT *
FROM `fc_product_attributes`
WHERE `attr_slug` = 'brand'
Query #165
0.0001s
SELECT *
FROM `fc_product_attributes`
WHERE `attr_slug` = 'color-hex'
Query #166
0.0001s
SELECT *
FROM `fc_product_attributes`
WHERE `attr_slug` = 'material'
Query #167
0.0001s
SELECT *
FROM `fc_product_attributes`
WHERE `attr_slug` = 'size'
Query #168
0.6729s
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 #169
0.7480s
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 (127,128,132,133,134,135,136,139,144,147,150,151,152,153,161,129,130,131,137,138,140,141,142,143,145,146,148,149,154,155,156,157,158,159,160,162,163) OR fc_products.product_id IN (SELECT id_product FROM fc_product_to_category WHERE id_category IN (127,128,132,133,134,135,136,139,144,147,150,151,152,153,161,129,130,131,137,138,140,141,142,143,145,146,148,149,154,155,156,157,158,159,160,162,163)))
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 #170
0.0003s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'site_verifications'
Query #171
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'conversion_tracking'
Query #172
0.0001s
SELECT *
FROM `fc_site_menus`
WHERE `id` = 1
Query #173
0.0003s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'topbar_text'
Query #174
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'shop_logo'
Query #175
0.0001s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'wolmart_settings'
Query #176
0.0001s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone'
Query #177
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'shop_logo'
Query #178
0.0001s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'wolmart_settings'
Query #179
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone2'
Query #180
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'contact_email'
Query #181
0.0001s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'shop_logo'
Query #182
0.0001s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'wolmart_settings'
Query #183
0.0001s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'company_name'
Query #184
0.0001s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'vat_number'
Query #185
0.0001s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone'
Query #186
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone_read'
Query #187
0.0002s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone2'
Query #188
0.0001s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone_read2'
Query #189
0.0001s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'contact_email'
Query #190
0.0001s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'contact_email'
Query #191
0.0001s
SELECT *
FROM `fc_siteUsers`
WHERE `userId` IS NULL
Query #192
0.0001s
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 #193
0.0001s
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'conversion_tracking'
Static Page Cache
Current URI: /categorie/articole-textile
Cacheable Route: Yes
Currently Cached: No
Total Cached Files: 52
Total Cache Size: 39.88 MB
