200 query futott le 0.18006205558777 másodperc alatt

Array
(
    [query] => SELECT 
                category_id,
                category_title,
                category_parent_id,
                category_relation_category_id,
                category_relation_type,
                category_order,
                COUNT(category_relation_id) as category_qty
             FROM core_category  LEFT JOIN mod_category_relation ON  ( category_relation_category_id = category_id )   LEFT JOIN mod_program_basic ON  ( category_relation_foreign_id = program_basic_id )   LEFT JOIN mod_program_extended ON  ( program_extended_program_basic_id = program_basic_id )    WHERE  ( category_parent_id = 3 ) AND  ( (category_relation_type = "mod_program_basic" OR category_relation_type IS NULL) ) AND  ( IFNULL(mod_program_basic.program_basic_delete_user_id,0) = 0 AND IFNULL(mod_program_extended.program_extended_delete_user_id,0) = 0 ) AND  ( CONCAT(CAST(program_extended_end_date AS CHAR), " ", program_extended_end_time, ":00") >= CURRENT_TIMESTAMP )  GROUP BY category_id    ORDER BY category_order
    [begin] => 1793557663.4755
    [end] => 1793557663.5033
    [time] => 0.027784824371338
)
Array
(
    [query] => SELECT 
                category_id,
                category_title,
                category_parent_id,
                category_relation_category_id,
                category_relation_type,
                category_order,
                COUNT(category_relation_id) as category_qty
             FROM core_category  LEFT JOIN mod_category_relation ON  ( category_relation_category_id = category_id )   LEFT JOIN mod_program_basic ON  ( category_relation_foreign_id = program_basic_id )   LEFT JOIN mod_program_extended ON  ( program_extended_program_basic_id = program_basic_id )    WHERE  ( category_parent_id = 4 ) AND  ( (category_relation_type = "mod_program_basic" OR category_relation_type IS NULL) ) AND  ( IFNULL(mod_program_basic.program_basic_delete_user_id,0) = 0 AND IFNULL(mod_program_extended.program_extended_delete_user_id,0) = 0 ) AND  ( CONCAT(CAST(program_extended_end_date AS CHAR), " ", program_extended_end_time, ":00") >= CURRENT_TIMESTAMP )  GROUP BY category_id    ORDER BY category_order
    [begin] => 1793557663.5039
    [end] => 1793557663.5109
    [time] => 0.0070130825042725
)