[2024-05-21 14:33:57]
QUERY: SELECT c.* FROM categories AS c WHERE c.id IN (SELECT category_id FROM live) AND parent_id IS NULL ORDER BY ads_count DESC
RUNTIME: 0.633955 ms
RETURNED ROWS: 2
[2024-05-21 14:33:57]
QUERY: SELECT c.* FROM categories AS c WHERE c.id IN (SELECT category_id FROM live) AND parent_id IS NULL ORDER BY ads_count DESC
RUNTIME: 0.437975 ms
RETURNED ROWS: 2
[2024-05-21 14:33:57]
QUERY: SELECT c.* FROM categories AS c WHERE c.id IN (SELECT category_id FROM live) AND parent_id = 1 ORDER BY ads_count DESC
RUNTIME: 1.044989 ms
RETURNED ROWS: 45
[2024-05-21 14:33:57]
QUERY: SELECT c.* FROM categories AS c WHERE c.id IN (SELECT category_id FROM live) AND parent_id = 4 ORDER BY ads_count DESC
RUNTIME: 0.714064 ms
RETURNED ROWS: 21
All categories