Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2
FROM
  check_ip_request t0
WHERE
  t0.ip = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ip AS ip_2 FROM check_ip_request t0 WHERE t0.ip = '216.73.216.185' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2
FROM
  aws_ip t0

SELECT t0.id AS id_1, t0.ip AS ip_2 FROM aws_ip t0;

SELECT
  c0_.id AS id_0,
  c0_.fi_original_content AS fi_original_content_1,
  c0_.special_type AS special_type_2,
  c0_.homepage_type AS homepage_type_3,
  c0_.main_category AS main_category_4,
  c0_.main_region AS main_region_5,
  c0_.homepage_image AS homepage_image_6,
  c0_.homepage_image_mime AS homepage_image_mime_7,
  c0_.listing_image AS listing_image_8,
  c0_.listing_image_mime AS listing_image_mime_9,
  c0_.top_story AS top_story_10,
  c0_.headline AS headline_11,
  c0_.publication_start_date AS publication_start_date_12,
  c0_.publication_stop_date AS publication_stop_date_13,
  c0_.advertising_stop_date AS advertising_stop_date_14,
  c0_.payed_start_date AS payed_start_date_15,
  c0_.payed_stop_date AS payed_stop_date_16,
  c0_.validation_status AS validation_status_17,
  c0_.payed_status AS payed_status_18,
  c0_.adserver_stock AS adserver_stock_19,
  c0_.adserver_stock_date AS adserver_stock_date_20,
  c0_.adserver_stock_advertiser AS adserver_stock_advertiser_21,
  c0_.adserver_stock_location AS adserver_stock_location_22,
  c0_.modified_date AS modified_date_23,
  c0_.create_date AS create_date_24,
  c0_.homepage_start_date AS homepage_start_date_25,
  c0_.special_stop_date AS special_stop_date_26,
  c0_.fi_advertiser AS fi_advertiser_27,
  c0_.fi_company AS fi_company_28,
  c0_.clicks AS clicks_29,
  c0_.clicks_total AS clicks_total_30,
  c0_.fi_reference AS fi_reference_31,
  c0_.fi_language AS fi_language_32,
  c0_.fi_object AS fi_object_33,
  c0_.author AS author_34,
  c0_.file AS file_35,
  c0_.file_url AS file_url_36,
  c0_.file_name AS file_name_37,
  c0_.contact_name AS contact_name_38,
  c0_.contact_company AS contact_company_39,
  c0_.contact_street AS contact_street_40,
  c0_.contact_street2 AS contact_street2_41,
  c0_.contact_zip_city AS contact_zip_city_42,
  c0_.contact_fi_country AS contact_fi_country_43,
  c0_.contact_phone AS contact_phone_44,
  c0_.contact_fax AS contact_fax_45,
  c0_.contact_email AS contact_email_46,
  c0_.contact_website AS contact_website_47,
  c0_.contact_twitter AS contact_twitter_48,
  c0_.contact_linkedin AS contact_linkedin_49,
  c0_.contact_xing AS contact_xing_50,
  c0_.contact_facebook AS contact_facebook_51,
  c0_.contact_youtube AS contact_youtube_52,
  c0_.contact_instagram AS contact_instagram_53,
  c0_.content_fi_category AS content_fi_category_54,
  c0_.events_venue AS events_venue_55,
  c0_.events_venue_map AS events_venue_map_56,
  c0_.events_street AS events_street_57,
  c0_.events_zip_city AS events_zip_city_58,
  c0_.events_fi_country AS events_fi_country_59,
  c0_.events_from_date AS events_from_date_60,
  c0_.events_to_date AS events_to_date_61,
  c0_.events_website AS events_website_62,
  c0_.suppliers_content_fi_category AS suppliers_content_fi_category_63,
  c0_.external_link AS external_link_64,
  c0_.image_handling AS image_handling_65,
  c0_.homepage AS homepage_66,
  c0_.homepage_position AS homepage_position_67,
  c0_.article_type AS article_type_68,
  c0_.events_type AS events_type_69,
  c0_.short_description AS short_description_70,
  c0_.slug AS slug_71,
  c0_.fi_reference AS fi_reference_72,
  c0_.fi_language AS fi_language_73
FROM
  content c0_
  INNER JOIN language l1_ ON c0_.fi_language = l1_.id
WHERE
  c0_.fi_object IN (?)
  AND c0_.validation_status = ?
  AND c0_.publication_start_date < ?
  AND (
    c0_.publication_stop_date = 0
    OR c0_.publication_stop_date > ?
  )
  AND l1_.lg_iso2 = ?
ORDER BY
  c0_.events_from_date ASC,
  c0_.modified_date DESC
LIMIT
  40

SELECT c0_.id AS id_0, c0_.fi_original_content AS fi_original_content_1, c0_.special_type AS special_type_2, c0_.homepage_type AS homepage_type_3, c0_.main_category AS main_category_4, c0_.main_region AS main_region_5, c0_.homepage_image AS homepage_image_6, c0_.homepage_image_mime AS homepage_image_mime_7, c0_.listing_image AS listing_image_8, c0_.listing_image_mime AS listing_image_mime_9, c0_.top_story AS top_story_10, c0_.headline AS headline_11, c0_.publication_start_date AS publication_start_date_12, c0_.publication_stop_date AS publication_stop_date_13, c0_.advertising_stop_date AS advertising_stop_date_14, c0_.payed_start_date AS payed_start_date_15, c0_.payed_stop_date AS payed_stop_date_16, c0_.validation_status AS validation_status_17, c0_.payed_status AS payed_status_18, c0_.adserver_stock AS adserver_stock_19, c0_.adserver_stock_date AS adserver_stock_date_20, c0_.adserver_stock_advertiser AS adserver_stock_advertiser_21, c0_.adserver_stock_location AS adserver_stock_location_22, c0_.modified_date AS modified_date_23, c0_.create_date AS create_date_24, c0_.homepage_start_date AS homepage_start_date_25, c0_.special_stop_date AS special_stop_date_26, c0_.fi_advertiser AS fi_advertiser_27, c0_.fi_company AS fi_company_28, c0_.clicks AS clicks_29, c0_.clicks_total AS clicks_total_30, c0_.fi_reference AS fi_reference_31, c0_.fi_language AS fi_language_32, c0_.fi_object AS fi_object_33, c0_.author AS author_34, c0_.file AS file_35, c0_.file_url AS file_url_36, c0_.file_name AS file_name_37, c0_.contact_name AS contact_name_38, c0_.contact_company AS contact_company_39, c0_.contact_street AS contact_street_40, c0_.contact_street2 AS contact_street2_41, c0_.contact_zip_city AS contact_zip_city_42, c0_.contact_fi_country AS contact_fi_country_43, c0_.contact_phone AS contact_phone_44, c0_.contact_fax AS contact_fax_45, c0_.contact_email AS contact_email_46, c0_.contact_website AS contact_website_47, c0_.contact_twitter AS contact_twitter_48, c0_.contact_linkedin AS contact_linkedin_49, c0_.contact_xing AS contact_xing_50, c0_.contact_facebook AS contact_facebook_51, c0_.contact_youtube AS contact_youtube_52, c0_.contact_instagram AS contact_instagram_53, c0_.content_fi_category AS content_fi_category_54, c0_.events_venue AS events_venue_55, c0_.events_venue_map AS events_venue_map_56, c0_.events_street AS events_street_57, c0_.events_zip_city AS events_zip_city_58, c0_.events_fi_country AS events_fi_country_59, c0_.events_from_date AS events_from_date_60, c0_.events_to_date AS events_to_date_61, c0_.events_website AS events_website_62, c0_.suppliers_content_fi_category AS suppliers_content_fi_category_63, c0_.external_link AS external_link_64, c0_.image_handling AS image_handling_65, c0_.homepage AS homepage_66, c0_.homepage_position AS homepage_position_67, c0_.article_type AS article_type_68, c0_.events_type AS events_type_69, c0_.short_description AS short_description_70, c0_.slug AS slug_71, c0_.fi_reference AS fi_reference_72, c0_.fi_language AS fi_language_73 FROM content c0_ INNER JOIN language l1_ ON c0_.fi_language = l1_.id WHERE c0_.fi_object IN (9) AND c0_.validation_status = 1 AND c0_.publication_start_date < 1773229417 AND (c0_.publication_stop_date = 0 OR c0_.publication_stop_date > 1773229417) AND l1_.lg_iso2 = 'en' ORDER BY c0_.events_from_date ASC, c0_.modified_date DESC LIMIT 40;

SELECT
  c0_.id AS id_0,
  c0_.cn_short_en AS cn_short_en_1
FROM
  country c0_
  INNER JOIN content c1_ ON (c1_.events_fi_country = c0_.id)
WHERE
  c1_.fi_object IN (?)
  AND c1_.validation_status = ?
  AND c1_.fi_reference IS NULL
  AND c1_.publication_start_date < ?
  AND (
    c1_.publication_stop_date = 0
    OR c1_.publication_stop_date > ?
  )
  AND c0_.id <> ?
  AND (
    c1_.events_to_date BETWEEN ?
    AND ?
  )
ORDER BY
  c0_.cn_short_en ASC

SELECT c0_.id AS id_0, c0_.cn_short_en AS cn_short_en_1 FROM country c0_ INNER JOIN content c1_ ON (c1_.events_fi_country = c0_.id) WHERE c1_.fi_object IN (9) AND c1_.validation_status = 1 AND c1_.fi_reference IS NULL AND c1_.publication_start_date < 1773229417 AND (c1_.publication_stop_date = 0 OR c1_.publication_stop_date > 1773229417) AND c0_.id <> 999 AND (c1_.events_to_date BETWEEN 1773229417 AND 2147472000) ORDER BY c0_.cn_short_en ASC;

SELECT
  t0.id AS id_1,
  t0.cn_iso2 AS cn_iso2_2,
  t0.cn_iso3 AS cn_iso3_3,
  t0.code AS code_4,
  t0.cn_phone AS cn_phone_5,
  t0.cn_short_en AS cn_short_en_6,
  t0.cn_short_de AS cn_short_de_7,
  t0.cn_short_fr AS cn_short_fr_8,
  t0.cn_short_es AS cn_short_es_9
FROM
  country t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = 54 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cn_iso2 AS cn_iso2_2,
  t0.cn_iso3 AS cn_iso3_3,
  t0.code AS code_4,
  t0.cn_phone AS cn_phone_5,
  t0.cn_short_en AS cn_short_en_6,
  t0.cn_short_de AS cn_short_de_7,
  t0.cn_short_fr AS cn_short_fr_8,
  t0.cn_short_es AS cn_short_es_9
FROM
  country t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = 148 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cn_iso2 AS cn_iso2_2,
  t0.cn_iso3 AS cn_iso3_3,
  t0.code AS code_4,
  t0.cn_phone AS cn_phone_5,
  t0.cn_short_en AS cn_short_en_6,
  t0.cn_short_de AS cn_short_de_7,
  t0.cn_short_fr AS cn_short_fr_8,
  t0.cn_short_es AS cn_short_es_9
FROM
  country t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = 11 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cn_iso2 AS cn_iso2_2,
  t0.cn_iso3 AS cn_iso3_3,
  t0.code AS code_4,
  t0.cn_phone AS cn_phone_5,
  t0.cn_short_en AS cn_short_en_6,
  t0.cn_short_de AS cn_short_de_7,
  t0.cn_short_fr AS cn_short_fr_8,
  t0.cn_short_es AS cn_short_es_9
FROM
  country t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = 11 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cn_iso2 AS cn_iso2_2,
  t0.cn_iso3 AS cn_iso3_3,
  t0.code AS code_4,
  t0.cn_phone AS cn_phone_5,
  t0.cn_short_en AS cn_short_en_6,
  t0.cn_short_de AS cn_short_de_7,
  t0.cn_short_fr AS cn_short_fr_8,
  t0.cn_short_es AS cn_short_es_9
FROM
  country t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = 220 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cn_iso2 AS cn_iso2_2,
  t0.cn_iso3 AS cn_iso3_3,
  t0.code AS code_4,
  t0.cn_phone AS cn_phone_5,
  t0.cn_short_en AS cn_short_en_6,
  t0.cn_short_de AS cn_short_de_7,
  t0.cn_short_fr AS cn_short_fr_8,
  t0.cn_short_es AS cn_short_es_9
FROM
  country t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = 20 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cn_iso2 AS cn_iso2_2,
  t0.cn_iso3 AS cn_iso3_3,
  t0.code AS code_4,
  t0.cn_phone AS cn_phone_5,
  t0.cn_short_en AS cn_short_en_6,
  t0.cn_short_de AS cn_short_de_7,
  t0.cn_short_fr AS cn_short_fr_8,
  t0.cn_short_es AS cn_short_es_9
FROM
  country t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = 62 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cn_iso2 AS cn_iso2_2,
  t0.cn_iso3 AS cn_iso3_3,
  t0.code AS code_4,
  t0.cn_phone AS cn_phone_5,
  t0.cn_short_en AS cn_short_en_6,
  t0.cn_short_de AS cn_short_de_7,
  t0.cn_short_fr AS cn_short_fr_8,
  t0.cn_short_es AS cn_short_es_9
FROM
  country t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = 999 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cn_iso2 AS cn_iso2_2,
  t0.cn_iso3 AS cn_iso3_3,
  t0.code AS code_4,
  t0.cn_phone AS cn_phone_5,
  t0.cn_short_en AS cn_short_en_6,
  t0.cn_short_de AS cn_short_de_7,
  t0.cn_short_fr AS cn_short_fr_8,
  t0.cn_short_es AS cn_short_es_9
FROM
  country t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = 220 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cn_iso2 AS cn_iso2_2,
  t0.cn_iso3 AS cn_iso3_3,
  t0.code AS code_4,
  t0.cn_phone AS cn_phone_5,
  t0.cn_short_en AS cn_short_en_6,
  t0.cn_short_de AS cn_short_de_7,
  t0.cn_short_fr AS cn_short_fr_8,
  t0.cn_short_es AS cn_short_es_9
FROM
  country t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = 54 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cn_iso2 AS cn_iso2_2,
  t0.cn_iso3 AS cn_iso3_3,
  t0.code AS code_4,
  t0.cn_phone AS cn_phone_5,
  t0.cn_short_en AS cn_short_en_6,
  t0.cn_short_de AS cn_short_de_7,
  t0.cn_short_fr AS cn_short_fr_8,
  t0.cn_short_es AS cn_short_es_9
FROM
  country t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = 220 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cn_iso2 AS cn_iso2_2,
  t0.cn_iso3 AS cn_iso3_3,
  t0.code AS code_4,
  t0.cn_phone AS cn_phone_5,
  t0.cn_short_en AS cn_short_en_6,
  t0.cn_short_de AS cn_short_de_7,
  t0.cn_short_fr AS cn_short_fr_8,
  t0.cn_short_es AS cn_short_es_9
FROM
  country t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = 93 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cn_iso2 AS cn_iso2_2,
  t0.cn_iso3 AS cn_iso3_3,
  t0.code AS code_4,
  t0.cn_phone AS cn_phone_5,
  t0.cn_short_en AS cn_short_en_6,
  t0.cn_short_de AS cn_short_de_7,
  t0.cn_short_fr AS cn_short_fr_8,
  t0.cn_short_es AS cn_short_es_9
FROM
  country t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = 220 LIMIT 1;