1-6 of 16

Seite:
  1. 1
  2. 2
  3. 3
[profiler]
Memory usage: real: 55312384, emalloc: 54243984
Code ProfilerTimeCntEmallocRealMem
Executed 776 queries in 0.169612884521 seconds
Average query length: 0.000218573304796 seconds
Queries per second: 4575.12412568
Longest query length: 0.00596690177917
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 (14315)) 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 (14315)) 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 (14315)) 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 (14315)) 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 (14315)) AND (t_d.attribute_id IN ('104', '105', '93', '77', '94', '78')) AND (t_d.store_id = 0)