SELECT `main_table`.`entity_id`, `main_table`.`name`,
`url_rewrite`.`request_path` FROM `catalog_category_flat_store_1` AS
`main_table`
LEFT JOIN `core_url_rewrite` AS `url_rewrite` ON
url_rewrite.category_id=main_table.entity_id AND url_rewrite.is_system=1
AND url_rewrite.store_id = 1 AND url_rewrite.id_path LIKE 'category/%'
WHERE (main_table.entity_id IN ('268', '272')) AND (main_table.is_active =
'1') ORDER BY `main_table`.`path` ASC
Elapsed seconds: 0.00011897087097168