6 Artikel

[profiler]
Memory usage: real: 48758784, emalloc: 48051760
Code ProfilerTimeCntEmallocRealMem
Executed 563 queries in 0.0911912918091 seconds
Average query length: 0.000161973875327 seconds
Queries per second: 6173.8351199
Longest query length: 0.00425505638123
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 (158176)) 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 (158176)) 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 (158176)) 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 (158176)) 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 (158176)) AND (t_d.attribute_id IN ('104', '105', '93', '77', '94', '78')) AND (t_d.store_id = 0)