https://staging.rooferscoffeeshop.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CMaster%255CContentController%253A%253ApinnedSidebarAd

Method
GET
HTTP Status
200
IP
40.77.167.78
Profiled on
Token
39bef0
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY <derived2> ALL 9 Using temporary; Using filesort
2 DERIVED t ref PRIMARY, IDX_FEC530A96CB1415A IDX_FEC530A96CB1415A 9 const 1 Using index
2 DERIVED r ref IDX_FEC530A96CB1415A, published_at_index, IDX_get_content IDX_FEC530A96CB1415A 9 roofers_staging2.t.id 8 Using where
3 UNION t ref IDX_FEC530A96CB1415A, published_at_index, IDX_get_content IDX_FEC530A96CB1415A 9 const 1 Using where
UNION RESULT <union2, 3> ALL