Certo è 5.5 ma il problema è in una query del db
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY c range PRIMARY,idx_access idx_access 4 88 Using where; Using temporary; Using filesort
1 PRIMARY a ref idx_access,idx_catid idx_catid 4 carinolanetnew.c.id 50 Using where
1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 carinolanetnew.a.created_by 1
1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 carinolanetnew.a.modified_by 1
1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 carinolanetnew.c.parent_id 1
1 PRIMARY v eq_ref PRIMARY PRIMARY 4 carinolanetnew.a.id 1
1 PRIMARY ALL 21 Using where
1 PRIMARY fp eq_ref PRIMARY PRIMARY 4 carinolanetnew.a.id 1
2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 21 Using where; Using temporary; Using filesort
2 DERIVED cat index idx_left_right idx_left_right 8 95 Using where; Using index; Using join buffer
This query examines 184,338,000 rows, which is unacceptable in shared hosting.