Men's Accessories

Memory usage: real: 15990784, emalloc: 15556208

Executed 233 queries in 0.13729906082153 seconds
Average query length: 0.00058926635545722 seconds
Queries per second: 1697.0254465387
Longest query length: 0.0057861804962158
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_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 (4762, 2533, 4818, 11987, 11985, 5021, 5007, 5005, 11983, 2850)) AND (t_d.attribute_id IN ('169', '168', '144', '214', '188', '156', '215', '199', '146', '167', '185', '100', '198', '131', '128', '81', '89', '200', '123', '126', '173', '127', '145', '124', '190', '191', '155', '121', '157', '197', '125', '96')) 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 (4762, 2533, 4818, 11987, 11985, 5021, 5007, 5005, 11983, 2850)) AND (t_d.attribute_id IN ('133', '187', '142', '117', '148', '149', '103', '189', '95', '122', '138', '85', '112', '212', '140', '130', '192', '88', '84', '82', '119', '118', '71', '109', '107', '184', '134', '186', '129', '178', '179', '86', '113', '180', '87', '114', '137', '97', '98', '141', '175', '211', '216', '217', '139')) 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 (4762, 2533, 4818, 11987, 11985, 5021, 5007, 5005, 11983, 2850)) AND (t_d.attribute_id IN ('79', '170', '171', '90', '99', '120', '75', '76', '152', '153', '151', '91', '80')) 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 (4762, 2533, 4818, 11987, 11985, 5021, 5007, 5005, 11983, 2850)) AND (t_d.attribute_id IN ('150', '106', '72', '208', '83', '101', '73', '154')) 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 (4762, 2533, 4818, 11987, 11985, 5021, 5007, 5005, 11983, 2850)) AND (t_d.attribute_id IN ('104', '105', '93', '94', '77', '78')) AND (t_d.store_id = 0)