Предоставляю:
# 1.5s user time, 110ms system time, 32.04M rss, 106.06M vsz # Current date: Wed Mar 25 13:34:23 2015 # Hostname: kondr.beget.ru # Files: STDIN # Overall: 2 total, 1 unique, 0.00 QPS, 0.00x concurrency ________________ # Time range: 2015-03-23 08:40:31 to 2015-03-24 11:22:13 # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 6s 3s 3s 3s 3s 157ms 3s # Lock time 386us 192us 194us 193us 194us 1us 193us # Rows sent 2 1 1 1 1 0 1 # Rows examine 148 52 96 74 96 31.11 74 # Rows affecte 0 0 0 0 0 0 0 # Bytes sent 122 61 61 61 61 0 61 # Query size 783 389 394 391.50 394 3.54 391.50 # Profile # Rank Query ID Response time Calls R/Call V/M Item # ==== ================== ============= ===== ====== ===== =============== # 1 0x9C07692F7EE01A5B 6.1143 100.0% 2 3.0571 0.01 SELECT product product_description product_to_store product_to_category # Query 1: 0.00 QPS, 0.00x concurrency, ID 0x9C07692F7EE01A5B at byte 1457090 # This item is included in the report because it matches --limit. # Scores: V/M = 0.01 # Time range: 2015-03-23 08:40:31 to 2015-03-24 11:22:13 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 100 2 # Exec time 100 6s 3s 3s 3s 3s 157ms 3s # Lock time 100 386us 192us 194us 193us 194us 1us 193us # Rows sent 100 2 1 1 1 1 0 1 # Rows examine 100 148 52 96 74 96 31.11 74 # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 100 122 61 61 61 61 0 61 # Query size 100 783 389 394 391.50 394 3.54 391.50 # String: # Databases onarea_fab # Hosts localhost # Last errno 0 # Users onarea_fab # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `onarea_fab` LIKE 'product'\G # SHOW CREATE TABLE `onarea_fab`.`product`\G # SHOW TABLE STATUS FROM `onarea_fab` LIKE 'product_description'\G # SHOW CREATE TABLE `onarea_fab`.`product_description`\G # SHOW TABLE STATUS FROM `onarea_fab` LIKE 'product_to_store'\G # SHOW CREATE TABLE `onarea_fab`.`product_to_store`\G # SHOW TABLE STATUS FROM `onarea_fab` LIKE 'product_to_category'\G # SHOW CREATE TABLE `onarea_fab`.`product_to_category`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (568)\G