202 query futott le 0.10918712615967 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] => 1774357227.0111
    [end] => 1774357227.0252
    [time] => 0.014062881469727
)
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] => 1774357227.0267
    [end] => 1774357227.0309
    [time] => 0.004216194152832
)