6 Item(s)

per page

6 Item(s)

per page

[profiler]
Memory usage: real: 30408704, emalloc: 28489216
Code ProfilerTimeCntEmallocRealMem
Executed 675 queries in 0.14052700996399 seconds
Average query length: 0.00020818816290961 seconds
Queries per second: 4803.3470588535
Longest query length: 0.025491952896118
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_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 = 17 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (7320, 5583, 3371, 1919, 26851, 166, 8250, 7051, 4617, 3128, 920, 4615, 7952, 6046, 3375, 1991, 275, 10257, 7138, 4620, 3129, 1233, 26738, 3755)) AND (t_d.attribute_id IN ('458', '390', '73', '150', '452', '92', '338', '113', '69', '70', '84', '453', '74')) 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 = 17 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (7320, 5583, 3371, 1919, 26851, 166, 8250, 7051, 4617, 3128, 920, 4615, 7952, 6046, 3375, 1991, 275, 10257, 7138, 4620, 3129, 1233, 26738, 3755)) AND (t_d.attribute_id IN ('506', '415', '412', '463', '474', '266', '299', '505', '419', '160', '496', '409', '507', '414', '284', '454', '407', '411', '468', '472', '498', '334', '93', '510', '469', '125', '122', '165', '75', '509', '508', '503', '386', '83', '158', '169', '164', '471', '117', '120', '413', '163', '159', '462', '121', '418', '118', '477', '89', '115', '464', '95', '168', '119')) 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 = 17 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (7320, 5583, 3371, 1919, 26851, 166, 8250, 7051, 4617, 3128, 920, 4615, 7952, 6046, 3375, 1991, 275, 10257, 7138, 4620, 3129, 1233, 26738, 3755)) AND (t_d.attribute_id IN ('246', '247', '248', '249', '250', '252', '253', '254', '255', '256', '258', '259', '260', '245', '460', '416', '110', '96', '178', '349', '350', '281', '88', '116', '319', '486', '485', '487', '478', '494', '493', '482', '484', '346', '79', '105', '285', '286', '347', '124', '82', '78', '76', '112', '111', '65', '102', '100', '387', '353', '123', '354', '356', '367', '361', '80', '106', '352', '262', '345', '355', '351', '81', '107', '90', '91', '457', '175', '348')) 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 = 17 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (7320, 5583, 3371, 1919, 26851, 166, 8250, 7051, 4617, 3128, 920, 4615, 7952, 6046, 3375, 1991, 275, 10257, 7138, 4620, 3129, 1233, 26738, 3755)) AND (t_d.attribute_id IN ('396', '99', '66', '406', '330', '404', '491', '488', '490', '495', '317', '504', '408', '166', '167', '77', '265', '325', '170', '171', '417', '405', '94', '397', '67', '467', '392')) 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 = 17 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (7320, 5583, 3371, 1919, 26851, 166, 8250, 7051, 4617, 3128, 920, 4615, 7952, 6046, 3375, 1991, 275, 10257, 7138, 4620, 3129, 1233, 26738, 3755)) AND (t_d.attribute_id IN ('97', '98', '86', '87', '71', '72', '161')) AND (t_d.store_id = 0)