+------+-------------+-------------------------------------------------------------+--------------------+-------------+------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +------+-------------+-------------------------------------------------------------+--------------------+-------------+------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 | | 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 | | 92 | web_magento | localhost | oscar_prod_magento | Sleep | 0 | | NULL | 0.000 | | 93 | web_magento | localhost | oscar_prod_magento | Sleep | 0 | | NULL | 0.000 | | 94 | web_magento | localhost | oscar_prod_magento | Sleep | 0 | | NULL | 0.000 | | 95 | web_magento | localhost | oscar_prod_magento | Sleep | 0 | | NULL | 0.000 | | 96 | web_magento | localhost | oscar_prod_magento | Sleep | 504 | | NULL | 0.000 | | 304 | dr_magento | ec2-3-112-54-248.ap-northeast-1.compute.amazonaws.com:51294 | NULL | Binlog Dump | 460 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0.000 | | 425 | root | localhost | NULL | Query | 0 | Init | show full processlist | 0.000 | | 507 | web_magento | localhost | oscar_prod_magento | Sleep | 445 | | NULL | 0.000 | | 519 | web_magento | localhost | oscar_prod_magento | Query | 173 | Waiting for table metadata lock | RENAME TABLE catalog_category_product_index_store1 TO catalog_category_product_index_store1_outdated,catalog_category_product_index_store1_replica TO catalog_category_product_index_store1,catalog_category_product_index_store1_outdated TO catalog_category_product_index_store1_replica,catalog_category_product_index_store2 TO catalog_category_product_index_store2_outdated,catalog_category_product_index_store2_replica TO catalog_category_product_index_store2,catalog_category_product_index_store2_outdated TO catalog_category_product_index_store2_replica,catalog_category_product_index_store3 TO catalog_category_product_index_store3_outdated,catalog_category_product_index_store3_replica TO catalog_category_product_index_store3,catalog_category_product_index_store3_outdated TO catalog_category_product_index_store3_replica,catalog_category_product_index_store4 TO catalog_category_product_index_store4_outdated,catalog_category_product_index_store4_replica TO catalog_category_product_index_store4,catalog_category_product_index_store4_outdated TO catalog_category_product_index_store4_replica,catalog_category_product_index_store5 TO catalog_category_product_index_store5_outdated,catalog_category_product_index_store5_replica TO catalog_category_product_index_store5,catalog_category_product_index_store5_outdated TO catalog_category_product_index_store5_replica,catalog_category_product_index_store6 TO catalog_category_product_index_store6_outdated,catalog_category_product_index_store6_replica TO catalog_category_product_index_store6,catalog_category_product_index_store6_outdated TO catalog_category_product_index_store6_replica,catalog_category_product_index_store7 TO catalog_category_product_index_store7_outdated,catalog_category_product_index_store7_replica TO catalog_category_product_index_store7,catalog_category_product_index_store7_outdated TO catalog_category_product_index_store7_replica,catalog_category_product_index_store8 TO catalog_category_product_index_store8_outdated,catalog_category_product_index_store8_replica TO catalog_category_product_index_store8,catalog_category_product_index_store8_outdated TO catalog_category_product_index_store8_replica,catalog_category_product_index_store9 TO catalog_category_product_index_store9_outdated,catalog_category_product_index_store9_replica TO catalog_category_product_index_store9,catalog_category_product_index_store9_outdated TO catalog_category_product_index_store9_replica,catalog_category_product_index_store10 TO catalog_category_product_index_store10_outdated,catalog_category_product_index_store10_replica TO catalog_category_product_index_store10,catalog_category_product_index_store10_outdated TO catalog_category_product_index_store10_replica,catalog_category_product_index_store11 TO catalog_category_product_index_store11_outdated,catalog_category_product_index_store11_replica TO catalog_category_product_index_store11,catalog_category_product_index_store11_outdated TO catalog_category_product_index_store11_replica,catalog_category_product_index_store12 TO catalog_category_product_index_store12_outdated,catalog_category_product_index_store12_replica TO catalog_category_product_index_store12,catalog_category_product_index_store12_outdated TO catalog_category_product_index_store12_replica,catalog_category_product_index_store13 TO catalog_category_product_index_store13_outdated,catalog_category_product_index_store13_replica TO catalog_category_product_index_store13,catalog_category_product_index_store13_outdated TO catalog_category_product_index_store13_replica,catalog_category_product_index_store14 TO catalog_category_product_index_store14_outdated,catalog_category_product_index_store14_replica TO catalog_category_product_index_store14,catalog_category_product_index_store14_outdated TO catalog_category_product_index_store14_replica,catalog_category_product_index_store15 TO catalog_category_product_index_store15_outdated,catalog_category_product_index_store15_replica TO catalog_category_product_index_store15,catalog_category_product_index_store15_outdated TO catalog_category_product_index_store15_replica,catalog_category_product_index_store16 TO catalog_category_product_index_store16_outdated,catalog_category_product_index_store16_replica TO catalog_category_product_index_store16,catalog_category_product_index_store16_outdated TO catalog_category_product_index_store16_replica,catalog_category_product_index_store17 TO catalog_category_product_index_store17_outdated,catalog_category_product_index_store17_replica TO catalog_category_product_index_store17,catalog_category_product_index_store17_outdated TO catalog_category_product_index_store17_replica,catalog_category_product_index_store18 TO catalog_category_product_index_store18_outdated,catalog_category_product_index_store18_replica TO catalog_category_product_index_store18,catalog_category_product_index_store18_outdated TO catalog_category_product_index_store18_replica,catalog_category_product_index_store19 TO catalog_category_product_index_store19_outdated,catalog_category_product_index_store19_replica TO catalog_category_product_index_store19,catalog_category_product_index_store19_outdated TO catalog_category_product_index_store19_replica,catalog_category_product_index_store20 TO catalog_category_product_index_store20_outdated,catalog_category_product_index_store20_replica TO catalog_category_product_index_store20,catalog_category_product_index_store20_outdated TO catalog_category_product_index_store20_replica,catalog_category_product_index_store21 TO catalog_category_product_index_store21_outdated,catalog_category_product_index_store21_replica TO catalog_category_product_index_store21,catalog_category_product_index_store21_outdated TO catalog_category_product_index_store21_replica,catalog_category_product_index_store22 TO catalog_category_product_index_store22_outdated,catalog_category_product_index_store22_replica TO catalog_category_product_index_store22,catalog_category_product_index_store22_outdated TO catalog_category_product_index_store22_replica,catalog_category_product_index_store23 TO catalog_category_product_index_store23_outdated,catalog_category_product_index_store23_replica TO catalog_category_product_index_store23,catalog_category_product_index_store23_outdated TO catalog_category_product_index_store23_replica,catalog_category_product_index_store24 TO catalog_category_product_index_store24_outdated,catalog_category_product_index_store24_replica TO catalog_category_product_index_store24,catalog_category_product_index_store24_outdated TO catalog_category_product_index_store24_replica,catalog_category_product_index_store25 TO catalog_category_product_index_store25_outdated,catalog_category_product_index_store25_replica TO catalog_category_product_index_store25,catalog_category_product_index_store25_outdated TO catalog_category_product_index_store25_replica,catalog_category_product_index_store26 TO catalog_category_product_index_store26_outdated,catalog_category_product_index_store26_replica TO catalog_category_product_index_store26,catalog_category_product_index_store26_outdated TO catalog_category_product_index_store26_replica,catalog_category_product_index_store27 TO catalog_category_product_index_store27_outdated,catalog_category_product_index_store27_replica TO catalog_category_product_index_store27,catalog_category_product_index_store27_outdated TO catalog_category_product_index_store27_replica,catalog_category_product_index_store28 TO catalog_category_product_index_store28_outdated,catalog_category_product_index_store28_replica TO catalog_category_product_index_store28,catalog_category_product_index_store28_outdated TO catalog_category_product_index_store28_replica,catalog_category_product_index_store29 TO catalog_category_product_index_store29_outdated,catalog_category_product_index_store29_replica TO catalog_category_product_index_store29,catalog_category_product_index_store29_outdated TO catalog_category_product_index_store29_replica,catalog_category_product_index_store30 TO catalog_category_product_index_store30_outdated,catalog_category_product_index_store30_replica TO catalog_category_product_index_store30,catalog_category_product_index_store30_outdated TO catalog_category_product_index_store30_replica,catalog_category_product_index_store31 TO catalog_category_product_index_store31_outdated,catalog_category_product_index_store31_replica TO catalog_category_product_index_store31,catalog_category_product_index_store31_outdated TO catalog_category_product_index_store31_replica,catalog_category_product_index_store32 TO catalog_category_product_index_store32_outdated,catalog_category_product_index_store32_replica TO catalog_category_product_index_store32,catalog_category_product_index_store32_outdated TO catalog_category_product_index_store32_replica,catalog_category_product_index_store33 TO catalog_category_product_index_store33_outdated,catalog_category_product_index_store33_replica TO catalog_category_product_index_store33,catalog_category_product_index_store33_outdated TO catalog_category_product_index_store33_replica,catalog_category_product_index_store34 TO catalog_category_product_index_store34_outdated,catalog_category_product_index_store34_replica TO catalog_category_product_index_store34,catalog_category_product_index_store34_outdated TO catalog_category_product_index_store34_replica,catalog_category_product_index_store35 TO catalog_category_product_index_store35_outdated,catalog_category_product_index_store35_replica TO catalog_category_product_index_store35,catalog_category_product_index_store35_outdated TO catalog_category_product_index_store35_replica,catalog_category_product_index_store36 TO catalog_category_product_index_store36_outdated,catalog_category_product_index_store36_replica TO catalog_category_product_index_store36,catalog_category_product_index_store36_outdated TO catalog_category_product_index_store36_replica,catalog_category_product_index_store37 TO catalog_category_product_index_store37_outdated,catalog_category_product_index_store37_replica TO catalog_category_product_index_store37,catalog_category_product_index_store37_outdated TO catalog_category_product_index_store37_replica,catalog_category_product_index_store38 TO catalog_category_product_index_store38_outdated,catalog_category_product_index_store38_replica TO catalog_category_product_index_store38,catalog_category_product_index_store38_outdated TO catalog_category_product_index_store38_replica,catalog_category_product_index_store39 TO catalog_category_product_index_store39_outdated,catalog_category_product_index_store39_replica TO catalog_category_product_index_store39,catalog_category_product_index_store39_outdated TO catalog_category_product_index_store39_replica,catalog_category_product_index_store40 TO catalog_category_product_index_store40_outdated,catalog_category_product_index_store40_replica TO catalog_category_product_index_store40,catalog_category_product_index_store40_outdated TO catalog_category_product_index_store40_replica,catalog_category_product_index_store41 TO catalog_category_product_index_store41_outdated,catalog_category_product_index_store41_replica TO catalog_category_product_index_store41,catalog_category_product_index_store41_outdated TO catalog_category_product_index_store41_replica,catalog_category_product_index_store42 TO catalog_category_product_index_store42_outdated,catalog_category_product_index_store42_replica TO catalog_category_product_index_store42,catalog_category_product_index_store42_outdated TO catalog_category_product_index_store42_replica,catalog_category_product_index_store43 TO catalog_category_product_index_store43_outdated,catalog_category_product_index_store43_replica TO catalog_category_product_index_store43,catalog_category_product_index_store43_outdated TO catalog_category_product_index_store43_replica,catalog_category_product_index_store44 TO catalog_category_product_index_store44_outdated,catalog_category_product_index_store44_replica TO catalog_category_product_index_store44,catalog_category_product_index_store44_outdated TO catalog_category_product_index_store44_replica,catalog_category_product_index_store45 TO catalog_category_product_index_store45_outdated,catalog_category_product_index_store45_replica TO catalog_category_product_index_store45,catalog_category_product_index_store45_outdated TO catalog_category_product_index_store45_replica,catalog_category_product_index_store46 TO catalog_category_product_index_store46_outdated,catalog_category_product_index_store46_replica TO catalog_category_product_index_store46,catalog_category_product_index_store46_outdated TO catalog_category_product_index_store46_replica,catalog_category_product_index_store47 TO catalog_category_product_index_store47_outdated,catalog_category_product_index_store47_replica TO catalog_category_product_index_store47,catalog_category_product_index_store47_outdated TO catalog_category_product_index_store47_replica,catalog_category_product_index_store48 TO catalog_category_product_index_store48_outdated,catalog_category_product_index_store48_replica TO catalog_category_product_index_store48,catalog_category_product_index_store48_outdated TO catalog_category_product_index_store48_replica,catalog_category_product_index_store49 TO catalog_category_product_index_store49_outdated,catalog_category_product_index_store49_replica TO catalog_category_product_index_store49,catalog_category_product_index_store49_outdated TO catalog_category_product_index_store49_replica,catalog_category_product_index_store50 TO catalog_category_product_index_store50_outdated,catalog_category_product_index_store50_replica TO catalog_category_product_index_store50,catalog_category_product_index_store50_outdated TO catalog_category_product_index_store50_replica,catalog_category_product_index_store51 TO catalog_category_product_index_store51_outdated,catalog_category_product_index_store51_replica TO catalog_category_product_index_store51,catalog_category_product_index_store51_outdated TO catalog_category_product_index_store51_replica,catalog_category_product_index_store52 TO catalog_category_product_index_store52_outdated,catalog_category_product_index_store52_replica TO catalog_category_product_index_store52,catalog_category_product_index_store52_outdated TO catalog_category_product_index_store52_replica,catalog_category_product_index_store53 TO catalog_category_product_index_store53_outdated,catalog_category_product_index_store53_replica TO catalog_category_product_index_store53,catalog_category_product_index_store53_outdated TO catalog_category_product_index_store53_replica,catalog_category_product_index_store54 TO catalog_category_product_index_store54_outdated,catalog_category_product_index_store54_replica TO catalog_category_product_index_store54,catalog_category_product_index_store54_outdated TO catalog_category_product_index_store54_replica,catalog_category_product_index_store55 TO catalog_category_product_index_store55_outdated,catalog_category_product_index_store55_replica TO catalog_category_product_index_store55,catalog_category_product_index_store55_outdated TO catalog_category_product_index_store55_replica,catalog_category_product_index_store56 TO catalog_category_product_index_store56_outdated,catalog_category_product_index_store56_replica TO catalog_category_product_index_store56,catalog_category_product_index_store56_outdated TO catalog_category_product_index_store56_replica,catalog_category_product_index_store57 TO catalog_category_product_index_store57_outdated,catalog_category_product_index_store57_replica TO catalog_category_product_index_store57,catalog_category_product_index_store57_outdated TO catalog_category_product_index_store57_replica,catalog_category_product_index_store58 TO catalog_category_product_index_store58_outdated,catalog_category_product_index_store58_replica TO catalog_category_product_index_store58,catalog_category_product_index_store58_outdated TO catalog_category_product_index_store58_replica,catalog_category_product_index_store59 TO catalog_category_product_index_store59_outdated,catalog_category_product_index_store59_replica TO catalog_category_product_index_store59,catalog_category_product_index_store59_outdated TO catalog_category_product_index_store59_replica,catalog_category_product_index_store60 TO catalog_category_product_index_store60_outdated,catalog_category_product_index_store60_replica TO catalog_category_product_index_store60,catalog_category_product_index_store60_outdated TO catalog_category_product_index_store60_replica,catalog_category_product_index_store61 TO catalog_category_product_index_store61_outdated,catalog_category_product_index_store61_replica TO catalog_category_product_index_store61,catalog_category_product_index_store61_outdated TO catalog_category_product_index_store61_replica,catalog_category_product_index_store62 TO catalog_category_product_index_store62_outdated,catalog_category_product_index_store62_replica TO catalog_category_product_index_store62,catalog_category_product_index_store62_outdated TO catalog_category_product_index_store62_replica,catalog_category_product_index_store63 TO catalog_category_product_index_store63_outdated,catalog_category_product_index_store63_replica TO catalog_category_product_index_store63,catalog_category_product_index_store63_outdated TO catalog_category_product_index_store63_replica,catalog_category_product_index_store64 TO catalog_category_product_index_store64_outdated,catalog_category_product_index_store64_replica TO catalog_category_product_index_store64,catalog_category_product_index_store64_outdated TO catalog_category_product_index_store64_replica,catalog_category_product_index_store65 TO catalog_category_product_index_store65_outdated,catalog_category_product_index_store65_replica TO catalog_category_product_index_store65,catalog_category_product_index_store65_outdated TO catalog_category_product_index_store65_replica,catalog_category_product_index_store66 TO catalog_category_product_index_store66_outdated,catalog_category_product_index_store66_replica TO catalog_category_product_index_store66,catalog_category_product_index_store66_outdated TO catalog_category_product_index_store66_replica,catalog_category_product_index_store67 TO catalog_category_product_index_store67_outdated,catalog_category_product_index_store67_replica TO catalog_category_product_index_store67,catalog_category_product_index_store67_outdated TO catalog_category_product_index_store67_replica,catalog_category_product_index_store68 TO catalog_category_product_index_store68_outdated,catalog_category_product_index_store68_replica TO catalog_category_product_index_store68,catalog_category_product_index_store68_outdated TO catalog_category_product_index_store68_replica,catalog_category_product_index_store69 TO catalog_category_product_index_store69_outdated,catalog_category_product_index_store69_replica TO catalog_category_product_index_store69,catalog_category_product_index_store69_outdated TO catalog_category_product_index_store69_replica,catalog_category_product_index_store70 TO catalog_category_product_index_store70_outdated,catalog_category_product_index_store70_replica TO catalog_category_product_index_store70,catalog_category_product_index_store70_outdated TO catalog_category_product_index_store70_replica | 0.000 | | 2683 | web_magento | localhost | oscar_prod_magento | Query | 230 | Sending data | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=3 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 LEFT JOIN `catalog_product_relation` AS `child_link_color_group` ON e.entity_id = child_link_color_group.parent_id LEFT JOIN `cataloginventory_stock_status` AS `child_link_color_group_stock_status` ON child_link_color_group.child_id = child_link_color_group_stock_status.product_id AND child_link_color_group_stock_status.website_id = 0 AND child_link_color_group_stock_status.stock_id = 1 INNER JOIN `catalog_product_entity_varchar` AS `at_color_group` ON (at_color_group.entity_id = e.entity_id OR (at_color_group.entity_id = child_link_color_group.child_id AND child_link_color_group_stock_status.stock_status = 1)) AND (at_color_group.attribute_id = 162) AND (at_color_group.store_id = 0) AND (at_color_group.value IN (30,32,35,36,37,39)) LEFT JOIN `catalog_product_relation` AS `child_link_pattern_group` ON e.entity_id = child_link_pattern_group.parent_id LEFT JOIN `cataloginventory_stock_status` AS `child_link_pattern_group_stock_status` ON child_link_pattern_group.child_id = child_link_pattern_group_stock_status.product_id AND child_link_pattern_group_stock_status.website_id = 0 AND child_link_pattern_group_stock_status.stock_id = 1 INNER JOIN `catalog_product_entity_varchar` AS `at_pattern_group` ON (at_pattern_group.entity_id = e.entity_id OR (at_pattern_group.entity_id = child_link_pattern_group.child_id AND child_link_pattern_group_stock_status.stock_status = 1)) AND (at_pattern_group.attribute_id = 163) AND (at_pattern_group.store_id = 0) AND (at_pattern_group.value IN (120)) LEFT JOIN `catalog_product_relation` AS `child_link_face_shape` ON e.entity_id = child_link_face_shape.parent_id LEFT JOIN `cataloginventory_stock_status` AS `child_link_face_shape_stock_status` ON child_link_face_shape.child_id = child_link_face_shape_stock_status.product_id AND child_link_face_shape_stock_status.website_id = 0 AND child_link_face_shape_stock_status.stock_id = 1 INNER JOIN `catalog_product_entity_varchar` AS `at_face_shape` ON (at_face_shape.entity_id = e.entity_id OR (at_face_shape.entity_id = child_link_face_shape.child_id AND child_link_face_shape_stock_status.stock_status = 1)) AND (at_face_shape.attribute_id = 144) AND (at_face_shape.store_id = 0) AND (at_face_shape.value IN (12)) LEFT JOIN `catalog_product_relation` AS `child_link_width` ON e.entity_id = child_link_width.parent_id LEFT JOIN `cataloginventory_stock_status` AS `child_link_width_stock_status` ON child_link_width.child_id = child_link_width_stock_status.product_id AND child_link_width_stock_status.website_id = 0 AND child_link_width_stock_status.stock_id = 1 INNER JOIN `catalog_product_entity_int` AS `at_width` ON (at_width.entity_id = e.entity_id OR (at_width.entity_id = child_link_width.child_id AND child_link_width_stock_status.stock_status = 1)) AND (at_width.attribute_id = 143) AND (at_width.store_id = 0) AND (at_width.value IN (10)) LEFT JOIN `catalog_product_relation` AS `child_link_material` ON e.entity_id = child_link_material.parent_id LEFT JOIN `cataloginventory_stock_status` AS `child_link_material_stock_status` ON child_link_material.child_id = child_link_material_stock_status.product_id AND child_link_material_stock_status.website_id = 0 AND child_link_material_stock_status.stock_id = 1 INNER JOIN `catalog_product_entity_int` AS `at_material` ON (at_material.entity_id = e.entity_id OR (at_material.entity_id = child_link_material.child_id AND child_link_material_stock_status.stock_status = 1)) AND (at_material.attribute_id = 145) AND (at_material.store_id = 0) AND (at_material.value IN (29)) INNER JOIN `search_tmp_5de9094e3a1b65_56673328` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (at_color_group.entity_id=at_pattern_group.entity_id) AND (at_pattern_group.entity_id=at_face_shape.entity_id) AND (at_face_shape.entity_id=at_width.entity_id) AND (at_width.entity_id=at_material.entity_id) | 0.000 | | 3101 | web_magento | localhost | oscar_prod_magento | Query | 170 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de9098a0b6047_53219349` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3108 | web_magento | localhost | oscar_prod_magento | Query | 166 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de9098da24863_94899899` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3109 | web_magento | localhost | oscar_prod_magento | Query | 166 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de9098de37e30_59207897` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3112 | web_magento | localhost | oscar_prod_magento | Query | 164 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de9098f74eea9_07449079` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 7)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3113 | web_magento | localhost | oscar_prod_magento | Query | 164 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de9098fe3dd10_96123269` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3115 | web_magento | localhost | oscar_prod_magento | Query | 163 | Waiting for table metadata lock | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_store1` WHERE (product_id = 15326) AND (category_id = 3) | 0.000 | | 3136 | web_magento | localhost | oscar_prod_magento | Query | 150 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de9099dc02561_67471037` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3153 | web_magento | localhost | oscar_prod_magento | Query | 144 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909a42e7dc1_14038716` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3159 | web_magento | localhost | oscar_prod_magento | Query | 140 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909a7e0b5d9_21796830` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3170 | web_magento | localhost | oscar_prod_magento | Query | 138 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909aa5ec689_31096069` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3178 | web_magento | localhost | oscar_prod_magento | Query | 137 | Waiting for table metadata lock | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_store1` WHERE (product_id = 4357) AND (category_id = 4) | 0.000 | | 3182 | web_magento | localhost | oscar_prod_magento | Query | 136 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285636') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3189 | web_magento | localhost | oscar_prod_magento | Query | 136 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909ac37f904_69175659` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3190 | web_magento | localhost | oscar_prod_magento | Query | 134 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909ad9a9c81_20563243` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3191 | web_magento | localhost | oscar_prod_magento | Query | 134 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909ae4da6f8_78630616` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3210 | web_magento | localhost | oscar_prod_magento | Query | 130 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909b2474170_22315230` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3211 | web_magento | localhost | oscar_prod_magento | Query | 124 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909b806a035_46535565` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3212 | web_magento | localhost | oscar_prod_magento | Query | 129 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909b33014a0_14730001` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3216 | web_magento | localhost | oscar_prod_magento | Query | 129 | Waiting for table metadata lock | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_store1` WHERE (product_id = 4328) AND (category_id = 0) | 0.000 | | 3222 | web_magento | localhost | oscar_prod_magento | Query | 124 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909b79a17f2_99509787` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3228 | web_magento | localhost | oscar_prod_magento | Query | 122 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909ba0b73c8_42332985` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3233 | web_magento | localhost | oscar_prod_magento | Query | 119 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909bd422ca2_08806062` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3236 | web_magento | localhost | oscar_prod_magento | Query | 116 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909bf7d5e73_36144645` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3238 | web_magento | localhost | oscar_prod_magento | Query | 116 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909c042de27_68839278` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3243 | web_magento | localhost | oscar_prod_magento | Query | 112 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909c3ab7587_07723470` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3245 | web_magento | localhost | oscar_prod_magento | Query | 110 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909c5f15a66_72292308` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3254 | web_magento | localhost | oscar_prod_magento | Query | 103 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909cd1bf5d2_53934963` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3255 | web_magento | localhost | oscar_prod_magento | Query | 102 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909cd918165_61395700` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3261 | web_magento | localhost | oscar_prod_magento | Query | 102 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909cdee7902_48895903` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3278 | web_magento | localhost | oscar_prod_magento | Query | 101 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909cf466de3_38512289` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3338 | web_magento | localhost | oscar_prod_magento | Query | 95 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909d54ba516_18843791` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3348 | web_magento | localhost | oscar_prod_magento | Query | 88 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909db7f3dd0_89045693` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3350 | web_magento | localhost | oscar_prod_magento | Query | 87 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285637') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3353 | web_magento | localhost | oscar_prod_magento | Query | 85 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909de9bd642_97310392` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3367 | web_magento | localhost | oscar_prod_magento | Query | 77 | Waiting for table metadata lock | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_store1` WHERE (product_id = 4357) AND (category_id = 4) | 0.000 | | 3377 | web_magento | localhost | oscar_prod_magento | Query | 77 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909e732e5d3_22751286` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3403 | web_magento | localhost | oscar_prod_magento | Query | 74 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285638') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3408 | web_magento | localhost | oscar_prod_magento | Query | 71 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909ed17af52_74623770` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3416 | web_magento | localhost | oscar_prod_magento | Query | 65 | Waiting for table metadata lock | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_store1` WHERE (product_id = 4349) AND (category_id = 4) | 0.000 | | 3427 | web_magento | localhost | oscar_prod_magento | Query | 68 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909f02d52f8_44423257` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3428 | web_magento | localhost | oscar_prod_magento | Query | 67 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909f08798f1_99254584` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3439 | web_magento | localhost | oscar_prod_magento | Query | 61 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909f6b51603_36684812` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3456 | web_magento | localhost | oscar_prod_magento | Query | 60 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285638') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3470 | web_magento | localhost | oscar_prod_magento | Query | 58 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de909f9796182_07320878` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3491 | web_magento | localhost | oscar_prod_magento | Query | 58 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285639') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3498 | web_magento | localhost | oscar_prod_magento | Query | 52 | Waiting for table metadata lock | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_store1` WHERE (product_id = 4349) AND (category_id = 4) | 0.000 | | 3550 | web_magento | localhost | oscar_prod_magento | Query | 54 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285640') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3569 | web_magento | localhost | oscar_prod_magento | Query | 52 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a0044adf6_45404482` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3571 | web_magento | localhost | oscar_prod_magento | Query | 51 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a00b98f02_65899830` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3577 | web_magento | localhost | oscar_prod_magento | Query | 50 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a022dba56_00214255` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3593 | web_magento | localhost | oscar_prod_magento | Query | 49 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a02ee2165_73836421` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3595 | web_magento | localhost | oscar_prod_magento | Query | 48 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a03d6c7d8_88931727` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3601 | web_magento | localhost | oscar_prod_magento | Query | 45 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a06827520_82244814` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3611 | web_magento | localhost | oscar_prod_magento | Query | 42 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a09ccff14_85415297` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3612 | web_magento | localhost | oscar_prod_magento | Query | 42 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285640') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3614 | web_magento | localhost | oscar_prod_magento | Query | 41 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a0b280708_05432533` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3615 | web_magento | localhost | oscar_prod_magento | Query | 41 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a0b272353_99908095` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3617 | web_magento | localhost | oscar_prod_magento | Query | 41 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a0b4b00a3_69227489` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3662 | web_magento | localhost | oscar_prod_magento | Query | 33 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a12b734f9_14219842` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3664 | web_magento | localhost | oscar_prod_magento | Query | 33 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a135d0ba6_55968574` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 3)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3685 | web_magento | localhost | oscar_prod_magento | Query | 30 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a16049044_35890707` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3689 | web_magento | localhost | oscar_prod_magento | Query | 30 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285640') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3693 | web_magento | localhost | oscar_prod_magento | Query | 29 | Waiting for table metadata lock | SELECT `catalog_category_product_index_store1`.`product_id` FROM `catalog_category_product_index_store1` WHERE (product_id = 12176) AND (category_id = 3) | 0.000 | | 3699 | web_magento | localhost | oscar_prod_magento | Query | 26 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.customer_id IS NULL) AND (t_compare.visitor_id = '0') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3732 | web_magento | localhost | oscar_prod_magento | Query | 22 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285637') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3733 | web_magento | localhost | oscar_prod_magento | Query | 21 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a1e7b9ca1_66151530` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3753 | web_magento | localhost | oscar_prod_magento | Query | 18 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285639') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3758 | web_magento | localhost | oscar_prod_magento | Query | 16 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a23eb2678_26208937` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3759 | web_magento | localhost | oscar_prod_magento | Sleep | 6 | | NULL | 0.000 | | 3761 | web_magento | localhost | oscar_prod_magento | Query | 15 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a24621e92_36449287` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3783 | web_magento | localhost | oscar_prod_magento | Sleep | 14 | | NULL | 0.000 | | 3798 | web_magento | localhost | oscar_prod_magento | Query | 13 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285641') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3802 | web_magento | localhost | oscar_prod_magento | Query | 12 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a27dd3ab5_63824477` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3855 | web_magento | localhost | oscar_prod_magento | Query | 6 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285638') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3903 | web_magento | localhost | oscar_prod_magento | Query | 4 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285643') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3941 | web_magento | localhost | oscar_prod_magento | Query | 2 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a3198c5d5_21586557` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3949 | web_magento | localhost | oscar_prod_magento | Query | 2 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a320b3d56_12274744` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | | 3958 | web_magento | localhost | oscar_prod_magento | Sleep | 1 | | NULL | 0.000 | | 3964 | web_magento | localhost | oscar_prod_magento | Sleep | 0 | | NULL | 0.000 | | 3973 | web_magento | localhost | oscar_prod_magento | Query | 0 | Waiting for table metadata lock | SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '285638') INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id=2 WHERE (cat_index.visibility IN(3, 2, 4)) | 0.000 | | 3974 | web_magento | localhost | oscar_prod_magento | Sleep | 0 | | NULL | 0.000 | | 3975 | web_magento | localhost | oscar_prod_magento | Query | 0 | Waiting for table metadata lock | INSERT INTO `search_tmp_5de90a34517f94_45679297` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0)) * 1) AS score FROM `catalog_product_index_eav` AS `search_index` INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (`search_index`.`attribute_id` = 96 AND `search_index`.`value` in ('2', '4') AND `search_index`.`store_id` = '1') AND (category_ids_index.category_id = 6)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC LIMIT 10000 | 0.000 | +------+-------------+-------------------------------------------------------------+--------------------+-------------+------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ 97 rows in set (0.000 sec)