137 query futott le 0.20351004600525 másodperc alatt

Array
(
    [query] => SELECT * FROM core_route   WHERE  ( route_friendly_url = 'gyerekprogramok' )      ORDER BY route_id DESC LIMIT 0, 1
    [begin] => 1653316653.4456
    [end] => 1653316653.4467
    [time] => 0.001060962677002
)
Array
(
    [query] => SELECT * FROM core_translation   WHERE  ( translation_module = 'agoraprogramcalendar' AND translation_locale = 'hu_hu' )     
    [begin] => 1653316653.4749
    [end] => 1653316653.4772
    [time] => 0.002241849899292
)
Array
(
    [query] => SELECT * FROM core_category   WHERE  ( category_id = '49' )      LIMIT 1
    [begin] => 1653316653.494
    [end] => 1653316653.4951
    [time] => 0.0011131763458252
)
Array
(
    [query] => SELECT COUNT(*) FROM (SELECT COUNT(*) FROM mod_program_basic  LEFT JOIN mod_program_extended ON  ( program_extended_program_basic_id = program_basic_id )   LEFT JOIN mod_category_relation ON  ( category_relation_foreign_id = program_extended_program_basic_id )   LEFT JOIN core_category ON  ( category_relation_category_id = category_id )   LEFT JOIN mod_program_location_relation ON  ( program_location_relation_program_extended_id = program_extended_id )   LEFT JOIN mod_location ON  ( program_location_relation_location_id = location_id )    WHERE  ( 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 ) AND  ( category_relation_type = "mod_program_basic" ) AND  ( category_relation_category_id = 48 )  GROUP BY program_basic_id    ) tt
    [begin] => 1653316653.5101
    [end] => 1653316653.5137
    [time] => 0.003587007522583
)
Array
(
    [query] => SELECT 
                program_extended_program_basic_id,
                program_basic_id,
                category_relation_foreign_id,
                category_relation_type,
                category_relation_category_id,
                category_id,
                program_basic_description,
                program_basic_title,
                program_location_relation_program_extended_id,
                program_extended_id,
                program_location_relation_location_id,
                location_id,
                location_name,
                program_basic_short_description,
                program_extended_start_date,
                program_extended_end_date,
                program_extended_start_time,
                program_extended_end_time,
                STR_TO_DATE(CONCAT(CAST(program_extended_start_date AS CHAR), " ", program_extended_start_time, ":00"), "%Y-%m-%d %H:%i:%s") AS "start_date",
                STR_TO_DATE(CONCAT(CAST(program_extended_end_date AS CHAR), " ", program_extended_end_time, ":00"), "%Y-%m-%d %H:%i:%s") AS "end_date",
                program_basic_ticket_link,
                program_basic_hide_date
             FROM mod_program_basic  LEFT JOIN mod_program_extended ON  ( program_extended_program_basic_id = program_basic_id )   LEFT JOIN mod_category_relation ON  ( category_relation_foreign_id = program_extended_program_basic_id )   LEFT JOIN core_category ON  ( category_relation_category_id = category_id )   LEFT JOIN mod_program_location_relation ON  ( program_location_relation_program_extended_id = program_extended_id )   LEFT JOIN mod_location ON  ( program_location_relation_location_id = location_id )    WHERE  ( 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 ) AND  ( category_relation_type = "mod_program_basic" ) AND  ( category_relation_category_id = 48 )  GROUP BY program_basic_id    ORDER BY start_date ASC
    [begin] => 1653316653.5137
    [end] => 1653316653.5156
    [time] => 0.0018460750579834
)
Array
(
    [query] => SELECT * FROM mod_banner   WHERE  ( banner_id = 1 ) AND  ( banner_status = 1 )      LIMIT 0, 1
    [begin] => 1653316653.6422
    [end] => 1653316653.6435
    [time] => 0.0012261867523193
)