|
Longest query:
|
SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS
`default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL,
t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS
`t_d`
LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id =
t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (253, 254, 251, 252,
249, 250, 483, 484, 488)) AND (t_d.attribute_id IN ('93', '94', '104',
'105', '77', '78')) AND (t_d.store_id = 0) UNION ALL SELECT
`t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`,
`t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value,
t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d`
LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id =
t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (253, 254, 251, 252,
249, 250, 483, 484, 488)) AND (t_d.attribute_id IN ('76', '136', '148',
'137', '80', '75', '90', '99', '79', '91', '120')) AND (t_d.store_id = 0)
UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS
`default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL,
t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS
`t_d`
LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id =
t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (253, 254, 251, 252,
249, 250, 483, 484, 488)) AND (t_d.attribute_id IN ('71', '82', '85',
'103', '123', '86', '147', '84', '87', '88', '95', '107', '109', '97',
'98', '117', '118', '119', '112', '113', '114', '143', '130', '131', '206',
'210')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`,
`t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS
`store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value`
FROM `catalog_product_entity_int` AS `t_d`
LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id =
t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (253, 254, 251, 252,
249, 250, 483, 484, 488)) AND (t_d.attribute_id IN ('100', '175', '176',
'178', '179', '89', '181', '96', '184', '102', '139', '122', '140', '127',
'141', '142', '144', '145', '124', '146', '125', '126', '128', '129',
'132', '194', '192', '198', '208', '196', '195', '199', '197', '201',
'182', '207', '188', '200', '193', '183', '190', '191', '81', '189', '209',
'186', '187', '177')) AND (t_d.store_id = 0) UNION ALL SELECT
`t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`,
`t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value,
t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d`
LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id =
t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1
WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (253, 254, 251, 252,
249, 250, 483, 484, 488)) AND (t_d.attribute_id IN ('72', '83', '101',
'73', '106', '205', '202', '203', '204', '185')) AND (t_d.store_id = 0)
|
info
profiler
0.00 s
32.25 MB
98