| 0.0008 |
SELECT *
FROM `fc_app_settings`
WHERE `vartype` = '1'
AND `vartype` != '0'
ORDER BY `id`
|
| 0.0003 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'isSetAutologoffOnPeriod'
|
| 0.0003 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'isSetAutologoffOnPeriodInactive'
|
| 0.0006 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'redirIfMustResetPwd'
|
| 0.0003 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'mustResetPwdActive'
|
| 0.0003 |
SELECT *
FROM `fc_app_settings`
WHERE `autoload` = 1
AND `vartype` != 1
|
| 0.0013 |
SELECT *
FROM `fc_app_sectionDefine`
WHERE `class` = 'product'
AND `func` = 'index'
|
| 0.0001 |
SELECT *
FROM `fc_plugins`
|
| 0.0001 |
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'
|
| 0.0001 |
SELECT *
FROM `fc_plugins`
|
| 0.0001 |
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'
|
| 0.0001 |
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'
|
| 0.0001 |
SELECT *
FROM `fc_plugins`
|
| 0.0001 |
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'
|
| 0.0001 |
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'
|
| 0.0001 |
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'
|
| 0.0005 |
SHOW COLUMNS FROM `fc_options`
|
| 0.0001 |
SELECT `name`, `value`
FROM `fc_options`
WHERE `autoload` = 1
|
| 0.0001 |
SELECT *
FROM `fc_redirects`
WHERE `source_url` = 'produs/imola-short-sleeve-men-s-sports-t-shirt-12800'
|
| 0.0001 |
SELECT *
FROM `fc_migrations`
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `fc_modules`
|
| 0.0001 |
SELECT *
FROM `fc_siteUsers`
WHERE `userId` IS NULL
|
| 0.2222 |
SELECT `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`category_image`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
LEFT JOIN `fc_nom_stock_availability` ON `fc_nom_stock_availability`.`id` = `fc_products`.`stock_availability`
WHERE `product_slug` = 'imola-short-sleeve-men-s-sports-t-shirt-12800'
AND `fc_products`.`is_active` = 1
|
| 0.0003 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '12800'
LIMIT 10
|
| 0.2351 |
SELECT "variable_product_12800" as `qname`, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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` = '12800'
|
| 0.0003 |
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` = '12747'
AND `fc_products`.`is_active` = 1
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '12747'
LIMIT 10
|
| 0.0002 |
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` = '12747'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
SELECT *
FROM `fc_product_stats`
WHERE `product_id` = '12800'
|
| 0.0004 |
UPDATE `fc_product_stats` SET views = views+1
WHERE `product_id` = '12800'
|
| 0.0003 |
SELECT `t`.*
FROM `fc_tags` `t`
JOIN `fc_product_tags` `pt` ON `t`.`tag_id` = `pt`.`tag_id`
WHERE `pt`.`product_id` = '12800'
|
| 0.0003 |
SELECT `t`.*
FROM `fc_tags` `t`
JOIN `fc_product_tags` `pt` ON `t`.`tag_id` = `pt`.`tag_id`
WHERE `pt`.`product_id` = '12747'
|
| 0.0002 |
SELECT *
FROM `fc_product_category`
WHERE `parent_id` = '133'
AND `is_active` = 1
|
| 0.0014 |
SELECT `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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`.`is_variable` = 1
)
OR (
`fc_products`.`is_variable` = 0
AND `fc_products`.`id_parent` IS NULL
)
OR (
`fc_products`.`id_parent` IS NULL
AND `fc_products`.`is_variable` IS NULL
)
)
LIMIT 12
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '1'
LIMIT 10
|
| 0.2124 |
SELECT "variable_product_1" as `qname`, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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` = '1'
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '2'
LIMIT 2
|
| 0.0002 |
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` = '2'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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
|
| 0.0003 |
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` = '1'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '3'
LIMIT 10
|
| 0.2134 |
SELECT "variable_product_3" as `qname`, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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` = '3'
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '4'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '5'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '6'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '7'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '8'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '9'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '10'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '11'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '12'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '13'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '14'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '15'
LIMIT 2
|
| 0.0002 |
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` = '4'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0002 |
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` = '5'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '6'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '7'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '8'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '9'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '10'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '11'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '12'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '13'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '14'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '15'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0002 |
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
|
| 0.0003 |
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` = '3'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '16'
LIMIT 10
|
| 0.2119 |
SELECT "variable_product_16" as `qname`, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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` = '16'
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '17'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '18'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '19'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '20'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '21'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '22'
LIMIT 2
|
| 0.0002 |
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` = '17'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0002 |
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` = '18'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '19'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '20'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '21'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '22'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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
|
| 0.0003 |
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` = '16'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '23'
LIMIT 10
|
| 0.2121 |
SELECT "variable_product_23" as `qname`, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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` = '23'
|
| 0.0003 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '24'
LIMIT 2
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '25'
LIMIT 2
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '26'
LIMIT 2
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '27'
LIMIT 2
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '28'
LIMIT 2
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '29'
LIMIT 2
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '30'
LIMIT 2
|
| 0.0004 |
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` = '24'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0003 |
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` = '25'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0003 |
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` = '26'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0003 |
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` = '27'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0003 |
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` = '28'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0003 |
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` = '29'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '30'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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
|
| 0.0001 |
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` = '23'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '31'
LIMIT 10
|
| 0.2121 |
SELECT "variable_product_31" as `qname`, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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` = '31'
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '32'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '33'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '34'
LIMIT 2
|
| 0.0001 |
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` = '32'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '33'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '34'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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
|
| 0.0001 |
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` = '31'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '35'
LIMIT 10
|
| 0.2207 |
SELECT "variable_product_35" as `qname`, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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` = '35'
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '36'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '37'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '38'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '39'
LIMIT 2
|
| 0.0002 |
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` = '36'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '37'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '38'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '39'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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
|
| 0.0001 |
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` = '35'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '40'
LIMIT 10
|
| 0.2148 |
SELECT "variable_product_40" as `qname`, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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` = '40'
|
| 0.0004 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '41'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '42'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '43'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '44'
LIMIT 2
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '45'
LIMIT 2
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '46'
LIMIT 2
|
| 0.0004 |
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` = '41'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0002 |
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` = '42'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '43'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '44'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0003 |
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` = '45'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0003 |
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` = '46'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0002 |
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
|
| 0.0003 |
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` = '40'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '47'
LIMIT 10
|
| 0.2120 |
SELECT "variable_product_47" as `qname`, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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` = '47'
|
| 0.0003 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '48'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '49'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '50'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '51'
LIMIT 2
|
| 0.0002 |
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` = '48'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '49'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '50'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '51'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0002 |
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
|
| 0.0001 |
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` = '47'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '52'
LIMIT 10
|
| 0.2121 |
SELECT "variable_product_52" as `qname`, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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` = '52'
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '53'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '54'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '55'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '56'
LIMIT 2
|
| 0.0002 |
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` = '53'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '54'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '55'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '56'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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
|
| 0.0001 |
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` = '52'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '57'
LIMIT 10
|
| 0.2116 |
SELECT "variable_product_57" as `qname`, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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` = '57'
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '58'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '59'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '60'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '61'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '62'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '63'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '64'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '65'
LIMIT 2
|
| 0.0002 |
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` = '58'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '59'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '60'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '61'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '62'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '63'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '64'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '65'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0002 |
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
|
| 0.0001 |
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` = '57'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '66'
LIMIT 10
|
| 0.2115 |
SELECT "variable_product_66" as `qname`, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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` = '66'
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '67'
LIMIT 2
|
| 0.0002 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '68'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '69'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '70'
LIMIT 2
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '71'
LIMIT 2
|
| 0.0002 |
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` = '67'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '68'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0002 |
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` = '69'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '70'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
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` = '71'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0002 |
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
|
| 0.0001 |
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` = '66'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0001 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '72'
LIMIT 10
|
| 0.2117 |
SELECT "variable_product_72" as `qname`, `fc_products`.*, `fc_nom_stock_availability`.`name` as `Stock_availability`, `fc_nom_stock_availability`.*, `fc_product_category`.`id_category` AS `CategoryId`, `fc_product_category`.`category_name`, `fc_product_category`.`category_slug`, `fc_product_category`.`cat_discount`
FROM `fc_products`
LEFT JOIN `fc_product_category` ON `fc_product_category`.`id_category` = `fc_products`.`main_category_id`
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` = '72'
|
| 0.0003 |
SELECT *
FROM `fc_product_images`
WHERE `id_product` = '73'
LIMIT 2
|
| 0.0002 |
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` = '73'
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0002 |
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
|
| 0.0017 |
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` = '72'
GROUP BY `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0002 |
SELECT `id_category`, `category_name`, `category_slug`, `parent_id`
FROM `fc_product_category`
WHERE `is_active` = 1
AND `id_category` = '133'
ORDER BY `id_category` ASC
|
| 0.0001 |
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
|
| 0.0001 |
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
|
| 0.0002 |
SELECT `id_attribute`, `attr_val`
FROM `fc_product_attribute_values`
JOIN `fc_product_attributes` ON `fc_product_attributes`.`attr_id` = `fc_product_attribute_values`.`id_attribute`
WHERE `fc_product_attribute_values`.`id_product` = '12800'
AND `fc_product_attributes`.`aliasFor` IS NULL
|
| 0.0004 |
SELECT *
FROM `fc_custom_field_values`
JOIN `fc_custom_fields` ON `fc_custom_field_values`.`id_field` = `fc_custom_fields`.`id`
WHERE (`id_item` = 12747 OR `id_item` IS NULL)
AND `relation` = 'product'
|
| 0.2149 |
SELECT `product_id`
FROM `fc_products`
WHERE `id_parent` = '12747'
AND `is_active` = 1
|
| 0.0009 |
SELECT `attr_val_id`, `fc_product_attribute_values`.`id_attribute`, `fc_product_attributes`.`attr_name`, `fc_product_attribute_values`.`attr_val`, `fc_product_attribute_values`.`color`, `fc_product_attributes`.`field_type`, `fc_product_attributes`.`attr_type`, `variation`.`product_id` as `id_product_variation`, `variation`.`product_name` as `variation_name`, `variation`.`sku` as `variation_sku`, `variation`.`product_slug` as `variation_slug`, `variation`.`is_active` as `variation_is_active`, `variation`.`product_stock` as `variation_stock`, `variation`.`stock_availability` as `variation_stock_availability`
FROM `fc_product_attributes`
JOIN `fc_product_attribute_values` ON `fc_product_attribute_values`.`id_attribute` = `fc_product_attributes`.`attr_id`
JOIN `fc_products` as `variation` ON `variation`.`product_id` = `fc_product_attribute_values`.`id_product`
WHERE `fc_product_attribute_values`.`id_product` IN('12748', '12749', '12750', '12751', '12752', '12753', '12754', '12755', '12756', '12757', '12758', '12759', '12760', '12761', '12762', '12763', '12764', '12765', '12766', '12767', '12768', '12769', '12770', '12771', '12772', '12773', '12774', '12775', '12776', '12777', '12778', '12779', '12780', '12781', '12782', '12783', '12784', '12785', '12786', '12787', '12788', '12789', '12790', '12791', '12792', '12793', '12794', '12795', '12796', '12797', '12798', '12799', '12800', '12801', '12802', '12803', '12804', '12805', '12806', '12807', '12808', '12809', '12810', '12811', '12812', '12813', '12814', '12815', '12816', '12817', '12818', '12819', '12820', '12821', '12822', '12823', '12824', '12825', '12826', '12827', '12828', '12829', '12830', '12831', '12832', '12833', '12834', '12835', '12836', '12837', '12838', '12839', '12840', '12841', '12842', '12843', '12844', '12845', '12846', '12847', '12848', '12849')
AND `fc_product_attributes`.`aliasFor` IS NULL
GROUP BY `variation`.`product_id`, `fc_product_attribute_values`.`id_attribute`, `fc_product_attribute_values`.`attr_val`
|
| 0.0518 |
SELECT `sale_price`, `old_price`, `threshold`, `sku`
FROM `fc_product_unit_prices`
JOIN `fc_products` ON `fc_products`.`product_id` = `fc_product_unit_prices`.`id_product`
WHERE `id_product` = '12800'
AND `id_customer` IS NULL
AND `id_group` IS NULL
AND (
`sale_price` > 0
OR `old_price` > 0
)
|
| 0.0004 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'site_verifications'
|
| 0.0002 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'conversion_tracking'
|
| 0.0002 |
SELECT *
FROM `fc_site_menus`
WHERE `id` = 1
|
| 0.0002 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'shop_logo'
|
| 0.0002 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'wolmart_settings'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'shop_logo'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'wolmart_settings'
|
| 0.0002 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone2'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'contact_email'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'shop_logo'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'wolmart_settings'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'company_name'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'vat_number'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone_read'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone2'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'phone_read2'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'contact_email'
|
| 0.0001 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'contact_email'
|
| 0.0001 |
SELECT *
FROM `fc_siteUsers`
WHERE `userId` IS NULL
|
| 0.0002 |
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` = 0
|
| 0.0002 |
SELECT `val`
FROM `fc_app_settings`
WHERE `var` = 'conversion_tracking'
|
