3 Artikel

[profiler]
Memory usage: real: 52428800, emalloc: 50983032
Code ProfilerTimeCntEmallocRealMem
Executed 494 queries in 0.0810232162476 seconds
Average query length: 0.000164014607789 seconds
Queries per second: 6097.01790275
Longest query length: 0.00418615341187
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_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 (163700)) AND (t_d.attribute_id IN ('71', '168', '82', '85', '103', '122', '193', '185', '86', '197', '191', '84', '87', '194', '175', '88', '174', '184', '80', '95', '107', '149', '183', '109', '165', '182', '170', '181', '156', '180', '97', '171', '179', '118', '147', '178', '98', '117', '119', '186', '177', '140', '146', '176', '145', '159', '150', '167', '112', '151', '113', '152', '114', '157', '160', '161', '164', '190', '166', '173', '187', '129', '130')) 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 (163700)) AND (t_d.attribute_id IN ('100', '158', '155', '148', '163', '169', '89', '162', '153', '96', '102', '121', '189', '126', '123', '188', '124', '125', '127', '128', '131', '92', '81')) 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 (163700)) AND (t_d.attribute_id IN ('72', '83', '101', '73', '106')) 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 (163700)) AND (t_d.attribute_id IN ('172', '75', '90', '76', '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_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 (163700)) AND (t_d.attribute_id IN ('104', '105', '93', '77', '94', '78')) AND (t_d.store_id = 0)