https://staging.rooferscoffeeshop.com/directory/roofing-alliance/posts/1

Method
GET
HTTP Status
200
IP
3.138.122.180
Profiled on
Token
b9b70e
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s2_ const PRIMARY PRIMARY 4 const 1 Using index; Using temporary; Using filesort
1 SIMPLE a4_ ALL 10 Using where
1 SIMPLE a3_ eq_ref PRIMARY, IDX_ad_ad_id, IDX_as_site_id PRIMARY 12 roofers_staging2.a4_.media_group_item_id, const 1 Using index
1 SIMPLE m0_ eq_ref PRIMARY, IDX_3C64B0FAF135F7F5 PRIMARY 8 roofers_staging2.a4_.media_group_item_id 1 Using where
1 SIMPLE m1_ eq_ref PRIMARY PRIMARY 8 roofers_staging2.m0_.media_group_id 1 Using where
1 SIMPLE m5_ ALL 2407 Using where; Using join buffer (flat, BNL join)
1 SIMPLE m6_ ALL 2407 Using where; Using join buffer (incremental, BNL join)
1 SIMPLE m7_ ALL 2407 Using where; Using join buffer (incremental, BNL join)