1 |
SIMPLE |
s2_ |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
Using index; Using temporary; Using filesort |
1 |
SIMPLE |
c3_ |
ref |
PRIMARY, IDX_cus_customer_id, IDX_cus_site_id |
IDX_cus_site_id |
4 |
const |
744 |
Using index |
1 |
SIMPLE |
c1_ |
eq_ref |
PRIMARY, UNIQ_81398E0939C3EED7 |
PRIMARY |
8 |
roofers_staging2.c3_.customer_id |
1 |
Using where |
1 |
SIMPLE |
c0_ |
eq_ref |
PRIMARY, published_at_index, IDX_get_content |
PRIMARY |
8 |
roofers_staging2.c1_.directory_content_id |
1 |
Using where |
1 |
SIMPLE |
c4_ |
ALL |
|
|
|
|
3 |
Using where; Using join buffer (flat, BNL join) |
1 |
SIMPLE |
c6_ |
ref |
PRIMARY, IDX_2A895AEE9395C3F3 |
PRIMARY |
8 |
roofers_staging2.c3_.customer_id |
1 |
Using index; Distinct |