"Back"

SQL Explain

Executed SQL
SELECT `d`.`entity_id` FROM `catalog_category_entity_int` AS `d` LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = d.entity_id WHERE (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (d.entity_id IN ('3', '15', '29', '30', '34', '37', '38', '39', '57', '58', '59', '60', '61', '62', '66', '67', '69', '70', '71', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '111', '112', '113', '114', '115', '116', '117', '118', '119', '120', '121', '122', '123', '124', '125', '126', '127', '128', '129', '130', '131', '132', '133', '134', '135', '136', '137', '138', '139', '140', '141', '142', '143', '144', '145', '146', '147', '148', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '162', '163', '164', '167', '168', '169', '170', '171', '173', '174', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '189', '190', '191', '192', '193', '194', '195', '196', '197', '198', '199', '200', '201', '202', '204', '205', '206', '211', '212', '213', '214', '215', '216', '217', '218', '219', '220', '221', '222', '223', '224', '225', '226', '227', '228', '229', '230', '231', '232', '233', '234', '235', '236', '237', '238', '239', '240', '244', '245', '246', '247', '248', '249', '250', '251', '252', '253', '254', '255', '257', '258', '260')) AND (IF(c.value_id > 0, c.value, d.value) = :cond)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE d ref IDX_CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID 2 const 176 Using where
1 SIMPLE c index_merge IDX_CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID 2,2 1 Using intersect(IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID); Using where; Using join buffer (Block Nested Loop)