56,940
社区成员




+----+-------------+-------+--------+---------------+------------+---------+--------------------------------------+------+--------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+--------+---------------+------------+---------+--------------------------------------+------+--------------------------+
| 1 | SIMPLE | pd | range | PRIMARY | PRIMARY | 8 | NULL | 168 | Using where; Using index |
| 1 | SIMPLE | p | eq_ref | PRIMARY | PRIMARY | 4 | kleehaus_wedding.pd.product_id | 1 | Using where |
| 1 | SIMPLE | p2s | eq_ref | PRIMARY | PRIMARY | 8 | kleehaus_wedding.pd.product_id,const | 1 | Using where; Using index |
| 1 | SIMPLE | ps | ref | product_id | product_id | 4 | kleehaus_wedding.p.product_id | 1 | Using index |
+----+-------------+-------+--------+---------------+------------+---------+--------------------------------------+------+--------------------------+
+----+-------------+-------+--------+---------------------+-------------+---------+---------------------------------------+------+--------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+--------+---------------------+-------------+---------+---------------------------------------+------+--------------------------+
| 1 | SIMPLE | p2c | ref | PRIMARY,category_id | category_id | 4 | const | 436 | Using where |
| 1 | SIMPLE | pd | eq_ref | PRIMARY | PRIMARY | 8 | kleehaus_wedding.p2c.product_id,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | eq_ref | PRIMARY | PRIMARY | 4 | kleehaus_wedding.p2c.product_id | 1 | Using where |
| 1 | SIMPLE | ps | ref | product_id | product_id | 4 | kleehaus_wedding.p.product_id | 1 | Using index |
| 1 | SIMPLE | p2s | eq_ref | PRIMARY | PRIMARY | 8 | kleehaus_wedding.pd.product_id,const | 1 | Using where; Using index |
+----+-------------+-------+--------+---------------------+-------------+---------+---------------------------------------+------+--------------------------+