HELPI IFJÚSÁGI FEJLESZTŐ MŰHELY
2021. jún. 10. - 2022. szept. 23.

Teszt kiemelt esemény 2

Hozzáadás naptárhoz


Nulla eget eros velit. Nullam quis lobortis nisl. Vivamus porttitor felis ut felis efficitur molestie. Integer vitae diam varius, vehicula enim at, ullamcorper ante. Quisque ut condimentum velit. Quisque nec dui iaculis, euismod felis et, rutrum ante. Donec at aliquam ante. Quisque vehicula mollis ligula vel efficitur.

144 query futott le 0.14466214179993 másodperc alatt

Array
(
    [query] => SELECT * FROM core_route   WHERE  ( route_friendly_url = 'teszt-kiemelt-esemeny-2/2021-06-10' )      ORDER BY route_id DESC LIMIT 0, 1
    [begin] => 1638506651.918
    [end] => 1638506651.9194
    [time] => 0.0013601779937744
)
Array
(
    [query] => SELECT 
                    program_basic_id,
                    program_extended_start_time,
                    program_basic_title,
                    program_basic_short_description,
                    program_basic_description,
                    program_basic_full,
                    program_basic_short_title,
                    program_basic_insert_time,
                    program_basic_deleted_time,
                    program_extended_id,
                    program_extended_program_basic_id,
                    program_extended_end_date,
                    program_extended_end_time
                    program_extended_program_basic_id,
                    program_location_relation_program_extended_id,
                    location_name,
                    program_basic_is_ticket,
                    program_basic_ticket_info,
                    program_basic_ticket_link,
                    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 "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_contacts,
                    location_city,
                    location_address,
                    program_basic_hide_date,
                    category_relation_category_id
                 FROM mod_program_basic  LEFT JOIN mod_program_extended ON  ( program_extended_program_basic_id = program_basic_id )   LEFT JOIN mod_program_location_relation ON  ( program_location_relation_program_extended_id	= program_extended_id )   LEFT JOIN mod_location ON  ( location_id = program_location_relation_location_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 )    WHERE  ( program_extended_id = 6 ) AND  ( IFNULL(mod_program_basic.program_basic_delete_user_id, 0) = 0 AND IFNULL(mod_program_extended.program_extended_delete_user_id, 0) = 0 )      LIMIT 0, 1
    [begin] => 1638506651.9601
    [end] => 1638506651.9633
    [time] => 0.0032329559326172
)
Array
(
    [query] => SELECT * FROM core_image  LEFT JOIN mod_media ON  ( media_image_id = image_id )    WHERE  ( media_program_basic_id = 6 ) AND  ( media_deleted_time IS NULL OR media_deleted_time LIKE "0000-00-00 00:00:00" ) AND  ( media_ispublic = 1 )      ORDER BY image_created_date DESC LIMIT 0, 1
    [begin] => 1638506651.9675
    [end] => 1638506651.9699
    [time] => 0.0023579597473145
)
Array
(
    [query] => SELECT * FROM core_image  LEFT JOIN mod_media ON  ( media_image_id = image_id )    WHERE  ( media_program_extended_id = 6 ) AND  ( media_deleted_time IS NULL OR media_deleted_time LIKE "0000-00-00 00:00:00" ) AND  ( media_ispublic = 1 )      ORDER BY image_created_date DESC LIMIT 0, 1
    [begin] => 1638506651.9701
    [end] => 1638506651.9713
    [time] => 0.0012099742889404
)
Array
(
    [query] => SELECT * FROM mod_program_basic  JOIN mod_category_relation ON  ( category_relation_foreign_id = program_basic_id )    WHERE  ( category_relation_type = "mod_program_basic" ) AND  ( category_relation_category_id IN(5,47) ) AND  ( category_relation_foreign_id = 6 )      LIMIT 0, 1
    [begin] => 1638506652.0063
    [end] => 1638506652.0077
    [time] => 0.0014348030090332
)