https://staging.rooferscoffeeshop.com/forum/roofers-coffee-shop

Method
GET
HTTP Status
200
IP
3.14.134.62
Profiled on
Token
0930a4
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY <derived2> ALL 31410 Using temporary; Using filesort
2 DERIVED r ref IDX_FEC530A96CB1415A, published_at_index, IDX_get_content published_at_index 4 const 31170 Using where
2 DERIVED t eq_ref PRIMARY, IDX_FEC530A96CB1415A PRIMARY 8 roofers_staging2.r.prnt_id 1 Using where
3 UNION t index_merge IDX_FEC530A96CB1415A, published_at_index, IDX_get_content IDX_get_content, IDX_FEC530A96CB1415A 8, 9 320 Using intersect(IDX_get_content, IDX_FEC530A96CB1415A); Using where
UNION RESULT <union2, 3> ALL