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_
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 c0_.homepage IS NOT NULL
  AND c0_.homepage_position IS NOT NULL
ORDER BY
  c0_.homepage_position ASC
LIMIT
  17

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_ WHERE c0_.fi_object IN (1, 4) AND c0_.validation_status = 1 AND c0_.publication_start_date < 1773225167 AND (c0_.publication_stop_date = 0 OR c0_.publication_stop_date > 1773225167) AND c0_.homepage IS NOT NULL AND c0_.homepage_position IS NOT NULL ORDER BY c0_.homepage_position ASC LIMIT 17;

SELECT
  t0.id AS id_1,
  t0.fi_original_content AS fi_original_content_2,
  t0.special_type AS special_type_3,
  t0.homepage_type AS homepage_type_4,
  t0.main_category AS main_category_5,
  t0.main_region AS main_region_6,
  t0.homepage_image AS homepage_image_7,
  t0.homepage_image_mime AS homepage_image_mime_8,
  t0.listing_image AS listing_image_9,
  t0.listing_image_mime AS listing_image_mime_10,
  t0.top_story AS top_story_11,
  t0.headline AS headline_12,
  t0.publication_start_date AS publication_start_date_13,
  t0.publication_stop_date AS publication_stop_date_14,
  t0.advertising_stop_date AS advertising_stop_date_15,
  t0.payed_start_date AS payed_start_date_16,
  t0.payed_stop_date AS payed_stop_date_17,
  t0.validation_status AS validation_status_18,
  t0.payed_status AS payed_status_19,
  t0.adserver_stock AS adserver_stock_20,
  t0.adserver_stock_date AS adserver_stock_date_21,
  t0.adserver_stock_advertiser AS adserver_stock_advertiser_22,
  t0.adserver_stock_location AS adserver_stock_location_23,
  t0.modified_date AS modified_date_24,
  t0.create_date AS create_date_25,
  t0.homepage_start_date AS homepage_start_date_26,
  t0.special_stop_date AS special_stop_date_27,
  t0.fi_advertiser AS fi_advertiser_28,
  t0.fi_company AS fi_company_29,
  t0.clicks AS clicks_30,
  t0.clicks_total AS clicks_total_31,
  t0.fi_reference AS fi_reference_32,
  t0.fi_language AS fi_language_33,
  t0.fi_object AS fi_object_34,
  t0.author AS author_35,
  t0.file AS file_36,
  t0.file_url AS file_url_37,
  t0.file_name AS file_name_38,
  t0.contact_name AS contact_name_39,
  t0.contact_company AS contact_company_40,
  t0.contact_street AS contact_street_41,
  t0.contact_street2 AS contact_street2_42,
  t0.contact_zip_city AS contact_zip_city_43,
  t0.contact_fi_country AS contact_fi_country_44,
  t0.contact_phone AS contact_phone_45,
  t0.contact_fax AS contact_fax_46,
  t0.contact_email AS contact_email_47,
  t0.contact_website AS contact_website_48,
  t0.contact_twitter AS contact_twitter_49,
  t0.contact_linkedin AS contact_linkedin_50,
  t0.contact_xing AS contact_xing_51,
  t0.contact_facebook AS contact_facebook_52,
  t0.contact_youtube AS contact_youtube_53,
  t0.contact_instagram AS contact_instagram_54,
  t0.content_fi_category AS content_fi_category_55,
  t0.events_venue AS events_venue_56,
  t0.events_venue_map AS events_venue_map_57,
  t0.events_street AS events_street_58,
  t0.events_zip_city AS events_zip_city_59,
  t0.events_fi_country AS events_fi_country_60,
  t0.events_from_date AS events_from_date_61,
  t0.events_to_date AS events_to_date_62,
  t0.events_website AS events_website_63,
  t0.suppliers_content_fi_category AS suppliers_content_fi_category_64,
  t0.external_link AS external_link_65,
  t0.image_handling AS image_handling_66,
  t0.homepage AS homepage_67,
  t0.homepage_position AS homepage_position_68,
  t0.article_type AS article_type_69,
  t0.events_type AS events_type_70,
  t0.short_description AS short_description_71,
  t0.slug AS slug_72,
  t0.fi_reference AS fi_reference_73,
  t0.fi_language AS fi_language_74
FROM
  content t0
  INNER JOIN content_ref ON t0.id = content_ref.fi_content
WHERE
  content_ref.fi_reference = ?

SELECT t0.id AS id_1, t0.fi_original_content AS fi_original_content_2, t0.special_type AS special_type_3, t0.homepage_type AS homepage_type_4, t0.main_category AS main_category_5, t0.main_region AS main_region_6, t0.homepage_image AS homepage_image_7, t0.homepage_image_mime AS homepage_image_mime_8, t0.listing_image AS listing_image_9, t0.listing_image_mime AS listing_image_mime_10, t0.top_story AS top_story_11, t0.headline AS headline_12, t0.publication_start_date AS publication_start_date_13, t0.publication_stop_date AS publication_stop_date_14, t0.advertising_stop_date AS advertising_stop_date_15, t0.payed_start_date AS payed_start_date_16, t0.payed_stop_date AS payed_stop_date_17, t0.validation_status AS validation_status_18, t0.payed_status AS payed_status_19, t0.adserver_stock AS adserver_stock_20, t0.adserver_stock_date AS adserver_stock_date_21, t0.adserver_stock_advertiser AS adserver_stock_advertiser_22, t0.adserver_stock_location AS adserver_stock_location_23, t0.modified_date AS modified_date_24, t0.create_date AS create_date_25, t0.homepage_start_date AS homepage_start_date_26, t0.special_stop_date AS special_stop_date_27, t0.fi_advertiser AS fi_advertiser_28, t0.fi_company AS fi_company_29, t0.clicks AS clicks_30, t0.clicks_total AS clicks_total_31, t0.fi_reference AS fi_reference_32, t0.fi_language AS fi_language_33, t0.fi_object AS fi_object_34, t0.author AS author_35, t0.file AS file_36, t0.file_url AS file_url_37, t0.file_name AS file_name_38, t0.contact_name AS contact_name_39, t0.contact_company AS contact_company_40, t0.contact_street AS contact_street_41, t0.contact_street2 AS contact_street2_42, t0.contact_zip_city AS contact_zip_city_43, t0.contact_fi_country AS contact_fi_country_44, t0.contact_phone AS contact_phone_45, t0.contact_fax AS contact_fax_46, t0.contact_email AS contact_email_47, t0.contact_website AS contact_website_48, t0.contact_twitter AS contact_twitter_49, t0.contact_linkedin AS contact_linkedin_50, t0.contact_xing AS contact_xing_51, t0.contact_facebook AS contact_facebook_52, t0.contact_youtube AS contact_youtube_53, t0.contact_instagram AS contact_instagram_54, t0.content_fi_category AS content_fi_category_55, t0.events_venue AS events_venue_56, t0.events_venue_map AS events_venue_map_57, t0.events_street AS events_street_58, t0.events_zip_city AS events_zip_city_59, t0.events_fi_country AS events_fi_country_60, t0.events_from_date AS events_from_date_61, t0.events_to_date AS events_to_date_62, t0.events_website AS events_website_63, t0.suppliers_content_fi_category AS suppliers_content_fi_category_64, t0.external_link AS external_link_65, t0.image_handling AS image_handling_66, t0.homepage AS homepage_67, t0.homepage_position AS homepage_position_68, t0.article_type AS article_type_69, t0.events_type AS events_type_70, t0.short_description AS short_description_71, t0.slug AS slug_72, t0.fi_reference AS fi_reference_73, t0.fi_language AS fi_language_74 FROM content t0 INNER JOIN content_ref ON t0.id = content_ref.fi_content WHERE content_ref.fi_reference = 42773;

SELECT
  t0.id AS id_1,
  t0.lg_iso2 AS lg_iso2_2,
  t0.lg_name_local AS lg_name_local_3,
  t0.lg_name_en AS lg_name_en_4,
  t0.lg_typo3 AS lg_typo3_5,
  t0.lg_country_iso2 AS lg_country_iso2_6,
  t0.lg_collate_locale AS lg_collate_locale_7,
  t0.lg_sacred AS lg_sacred_8,
  t0.lg_constructed AS lg_constructed_9,
  t0.lg_name_de AS lg_name_de_10
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lg_iso2 AS lg_iso2_2, t0.lg_name_local AS lg_name_local_3, t0.lg_name_en AS lg_name_en_4, t0.lg_typo3 AS lg_typo3_5, t0.lg_country_iso2 AS lg_country_iso2_6, t0.lg_collate_locale AS lg_collate_locale_7, t0.lg_sacred AS lg_sacred_8, t0.lg_constructed AS lg_constructed_9, t0.lg_name_de AS lg_name_de_10 FROM language t0 WHERE t0.id = 112;

SELECT
  t0.id AS id_1,
  t0.fi_original_content AS fi_original_content_2,
  t0.special_type AS special_type_3,
  t0.homepage_type AS homepage_type_4,
  t0.main_category AS main_category_5,
  t0.main_region AS main_region_6,
  t0.homepage_image AS homepage_image_7,
  t0.homepage_image_mime AS homepage_image_mime_8,
  t0.listing_image AS listing_image_9,
  t0.listing_image_mime AS listing_image_mime_10,
  t0.top_story AS top_story_11,
  t0.headline AS headline_12,
  t0.publication_start_date AS publication_start_date_13,
  t0.publication_stop_date AS publication_stop_date_14,
  t0.advertising_stop_date AS advertising_stop_date_15,
  t0.payed_start_date AS payed_start_date_16,
  t0.payed_stop_date AS payed_stop_date_17,
  t0.validation_status AS validation_status_18,
  t0.payed_status AS payed_status_19,
  t0.adserver_stock AS adserver_stock_20,
  t0.adserver_stock_date AS adserver_stock_date_21,
  t0.adserver_stock_advertiser AS adserver_stock_advertiser_22,
  t0.adserver_stock_location AS adserver_stock_location_23,
  t0.modified_date AS modified_date_24,
  t0.create_date AS create_date_25,
  t0.homepage_start_date AS homepage_start_date_26,
  t0.special_stop_date AS special_stop_date_27,
  t0.fi_advertiser AS fi_advertiser_28,
  t0.fi_company AS fi_company_29,
  t0.clicks AS clicks_30,
  t0.clicks_total AS clicks_total_31,
  t0.fi_reference AS fi_reference_32,
  t0.fi_language AS fi_language_33,
  t0.fi_object AS fi_object_34,
  t0.author AS author_35,
  t0.file AS file_36,
  t0.file_url AS file_url_37,
  t0.file_name AS file_name_38,
  t0.contact_name AS contact_name_39,
  t0.contact_company AS contact_company_40,
  t0.contact_street AS contact_street_41,
  t0.contact_street2 AS contact_street2_42,
  t0.contact_zip_city AS contact_zip_city_43,
  t0.contact_fi_country AS contact_fi_country_44,
  t0.contact_phone AS contact_phone_45,
  t0.contact_fax AS contact_fax_46,
  t0.contact_email AS contact_email_47,
  t0.contact_website AS contact_website_48,
  t0.contact_twitter AS contact_twitter_49,
  t0.contact_linkedin AS contact_linkedin_50,
  t0.contact_xing AS contact_xing_51,
  t0.contact_facebook AS contact_facebook_52,
  t0.contact_youtube AS contact_youtube_53,
  t0.contact_instagram AS contact_instagram_54,
  t0.content_fi_category AS content_fi_category_55,
  t0.events_venue AS events_venue_56,
  t0.events_venue_map AS events_venue_map_57,
  t0.events_street AS events_street_58,
  t0.events_zip_city AS events_zip_city_59,
  t0.events_fi_country AS events_fi_country_60,
  t0.events_from_date AS events_from_date_61,
  t0.events_to_date AS events_to_date_62,
  t0.events_website AS events_website_63,
  t0.suppliers_content_fi_category AS suppliers_content_fi_category_64,
  t0.external_link AS external_link_65,
  t0.image_handling AS image_handling_66,
  t0.homepage AS homepage_67,
  t0.homepage_position AS homepage_position_68,
  t0.article_type AS article_type_69,
  t0.events_type AS events_type_70,
  t0.short_description AS short_description_71,
  t0.slug AS slug_72,
  t0.fi_reference AS fi_reference_73,
  t0.fi_language AS fi_language_74
FROM
  content t0
  INNER JOIN content_ref ON t0.id = content_ref.fi_content
WHERE
  content_ref.fi_reference = ?

SELECT t0.id AS id_1, t0.fi_original_content AS fi_original_content_2, t0.special_type AS special_type_3, t0.homepage_type AS homepage_type_4, t0.main_category AS main_category_5, t0.main_region AS main_region_6, t0.homepage_image AS homepage_image_7, t0.homepage_image_mime AS homepage_image_mime_8, t0.listing_image AS listing_image_9, t0.listing_image_mime AS listing_image_mime_10, t0.top_story AS top_story_11, t0.headline AS headline_12, t0.publication_start_date AS publication_start_date_13, t0.publication_stop_date AS publication_stop_date_14, t0.advertising_stop_date AS advertising_stop_date_15, t0.payed_start_date AS payed_start_date_16, t0.payed_stop_date AS payed_stop_date_17, t0.validation_status AS validation_status_18, t0.payed_status AS payed_status_19, t0.adserver_stock AS adserver_stock_20, t0.adserver_stock_date AS adserver_stock_date_21, t0.adserver_stock_advertiser AS adserver_stock_advertiser_22, t0.adserver_stock_location AS adserver_stock_location_23, t0.modified_date AS modified_date_24, t0.create_date AS create_date_25, t0.homepage_start_date AS homepage_start_date_26, t0.special_stop_date AS special_stop_date_27, t0.fi_advertiser AS fi_advertiser_28, t0.fi_company AS fi_company_29, t0.clicks AS clicks_30, t0.clicks_total AS clicks_total_31, t0.fi_reference AS fi_reference_32, t0.fi_language AS fi_language_33, t0.fi_object AS fi_object_34, t0.author AS author_35, t0.file AS file_36, t0.file_url AS file_url_37, t0.file_name AS file_name_38, t0.contact_name AS contact_name_39, t0.contact_company AS contact_company_40, t0.contact_street AS contact_street_41, t0.contact_street2 AS contact_street2_42, t0.contact_zip_city AS contact_zip_city_43, t0.contact_fi_country AS contact_fi_country_44, t0.contact_phone AS contact_phone_45, t0.contact_fax AS contact_fax_46, t0.contact_email AS contact_email_47, t0.contact_website AS contact_website_48, t0.contact_twitter AS contact_twitter_49, t0.contact_linkedin AS contact_linkedin_50, t0.contact_xing AS contact_xing_51, t0.contact_facebook AS contact_facebook_52, t0.contact_youtube AS contact_youtube_53, t0.contact_instagram AS contact_instagram_54, t0.content_fi_category AS content_fi_category_55, t0.events_venue AS events_venue_56, t0.events_venue_map AS events_venue_map_57, t0.events_street AS events_street_58, t0.events_zip_city AS events_zip_city_59, t0.events_fi_country AS events_fi_country_60, t0.events_from_date AS events_from_date_61, t0.events_to_date AS events_to_date_62, t0.events_website AS events_website_63, t0.suppliers_content_fi_category AS suppliers_content_fi_category_64, t0.external_link AS external_link_65, t0.image_handling AS image_handling_66, t0.homepage AS homepage_67, t0.homepage_position AS homepage_position_68, t0.article_type AS article_type_69, t0.events_type AS events_type_70, t0.short_description AS short_description_71, t0.slug AS slug_72, t0.fi_reference AS fi_reference_73, t0.fi_language AS fi_language_74 FROM content t0 INNER JOIN content_ref ON t0.id = content_ref.fi_content WHERE content_ref.fi_reference = 42134;

SELECT
  t0.id AS id_1,
  t0.fi_original_content AS fi_original_content_2,
  t0.special_type AS special_type_3,
  t0.homepage_type AS homepage_type_4,
  t0.main_category AS main_category_5,
  t0.main_region AS main_region_6,
  t0.homepage_image AS homepage_image_7,
  t0.homepage_image_mime AS homepage_image_mime_8,
  t0.listing_image AS listing_image_9,
  t0.listing_image_mime AS listing_image_mime_10,
  t0.top_story AS top_story_11,
  t0.headline AS headline_12,
  t0.publication_start_date AS publication_start_date_13,
  t0.publication_stop_date AS publication_stop_date_14,
  t0.advertising_stop_date AS advertising_stop_date_15,
  t0.payed_start_date AS payed_start_date_16,
  t0.payed_stop_date AS payed_stop_date_17,
  t0.validation_status AS validation_status_18,
  t0.payed_status AS payed_status_19,
  t0.adserver_stock AS adserver_stock_20,
  t0.adserver_stock_date AS adserver_stock_date_21,
  t0.adserver_stock_advertiser AS adserver_stock_advertiser_22,
  t0.adserver_stock_location AS adserver_stock_location_23,
  t0.modified_date AS modified_date_24,
  t0.create_date AS create_date_25,
  t0.homepage_start_date AS homepage_start_date_26,
  t0.special_stop_date AS special_stop_date_27,
  t0.fi_advertiser AS fi_advertiser_28,
  t0.fi_company AS fi_company_29,
  t0.clicks AS clicks_30,
  t0.clicks_total AS clicks_total_31,
  t0.fi_reference AS fi_reference_32,
  t0.fi_language AS fi_language_33,
  t0.fi_object AS fi_object_34,
  t0.author AS author_35,
  t0.file AS file_36,
  t0.file_url AS file_url_37,
  t0.file_name AS file_name_38,
  t0.contact_name AS contact_name_39,
  t0.contact_company AS contact_company_40,
  t0.contact_street AS contact_street_41,
  t0.contact_street2 AS contact_street2_42,
  t0.contact_zip_city AS contact_zip_city_43,
  t0.contact_fi_country AS contact_fi_country_44,
  t0.contact_phone AS contact_phone_45,
  t0.contact_fax AS contact_fax_46,
  t0.contact_email AS contact_email_47,
  t0.contact_website AS contact_website_48,
  t0.contact_twitter AS contact_twitter_49,
  t0.contact_linkedin AS contact_linkedin_50,
  t0.contact_xing AS contact_xing_51,
  t0.contact_facebook AS contact_facebook_52,
  t0.contact_youtube AS contact_youtube_53,
  t0.contact_instagram AS contact_instagram_54,
  t0.content_fi_category AS content_fi_category_55,
  t0.events_venue AS events_venue_56,
  t0.events_venue_map AS events_venue_map_57,
  t0.events_street AS events_street_58,
  t0.events_zip_city AS events_zip_city_59,
  t0.events_fi_country AS events_fi_country_60,
  t0.events_from_date AS events_from_date_61,
  t0.events_to_date AS events_to_date_62,
  t0.events_website AS events_website_63,
  t0.suppliers_content_fi_category AS suppliers_content_fi_category_64,
  t0.external_link AS external_link_65,
  t0.image_handling AS image_handling_66,
  t0.homepage AS homepage_67,
  t0.homepage_position AS homepage_position_68,
  t0.article_type AS article_type_69,
  t0.events_type AS events_type_70,
  t0.short_description AS short_description_71,
  t0.slug AS slug_72,
  t0.fi_reference AS fi_reference_73,
  t0.fi_language AS fi_language_74
FROM
  content t0
  INNER JOIN content_ref ON t0.id = content_ref.fi_content
WHERE
  content_ref.fi_reference = ?

SELECT t0.id AS id_1, t0.fi_original_content AS fi_original_content_2, t0.special_type AS special_type_3, t0.homepage_type AS homepage_type_4, t0.main_category AS main_category_5, t0.main_region AS main_region_6, t0.homepage_image AS homepage_image_7, t0.homepage_image_mime AS homepage_image_mime_8, t0.listing_image AS listing_image_9, t0.listing_image_mime AS listing_image_mime_10, t0.top_story AS top_story_11, t0.headline AS headline_12, t0.publication_start_date AS publication_start_date_13, t0.publication_stop_date AS publication_stop_date_14, t0.advertising_stop_date AS advertising_stop_date_15, t0.payed_start_date AS payed_start_date_16, t0.payed_stop_date AS payed_stop_date_17, t0.validation_status AS validation_status_18, t0.payed_status AS payed_status_19, t0.adserver_stock AS adserver_stock_20, t0.adserver_stock_date AS adserver_stock_date_21, t0.adserver_stock_advertiser AS adserver_stock_advertiser_22, t0.adserver_stock_location AS adserver_stock_location_23, t0.modified_date AS modified_date_24, t0.create_date AS create_date_25, t0.homepage_start_date AS homepage_start_date_26, t0.special_stop_date AS special_stop_date_27, t0.fi_advertiser AS fi_advertiser_28, t0.fi_company AS fi_company_29, t0.clicks AS clicks_30, t0.clicks_total AS clicks_total_31, t0.fi_reference AS fi_reference_32, t0.fi_language AS fi_language_33, t0.fi_object AS fi_object_34, t0.author AS author_35, t0.file AS file_36, t0.file_url AS file_url_37, t0.file_name AS file_name_38, t0.contact_name AS contact_name_39, t0.contact_company AS contact_company_40, t0.contact_street AS contact_street_41, t0.contact_street2 AS contact_street2_42, t0.contact_zip_city AS contact_zip_city_43, t0.contact_fi_country AS contact_fi_country_44, t0.contact_phone AS contact_phone_45, t0.contact_fax AS contact_fax_46, t0.contact_email AS contact_email_47, t0.contact_website AS contact_website_48, t0.contact_twitter AS contact_twitter_49, t0.contact_linkedin AS contact_linkedin_50, t0.contact_xing AS contact_xing_51, t0.contact_facebook AS contact_facebook_52, t0.contact_youtube AS contact_youtube_53, t0.contact_instagram AS contact_instagram_54, t0.content_fi_category AS content_fi_category_55, t0.events_venue AS events_venue_56, t0.events_venue_map AS events_venue_map_57, t0.events_street AS events_street_58, t0.events_zip_city AS events_zip_city_59, t0.events_fi_country AS events_fi_country_60, t0.events_from_date AS events_from_date_61, t0.events_to_date AS events_to_date_62, t0.events_website AS events_website_63, t0.suppliers_content_fi_category AS suppliers_content_fi_category_64, t0.external_link AS external_link_65, t0.image_handling AS image_handling_66, t0.homepage AS homepage_67, t0.homepage_position AS homepage_position_68, t0.article_type AS article_type_69, t0.events_type AS events_type_70, t0.short_description AS short_description_71, t0.slug AS slug_72, t0.fi_reference AS fi_reference_73, t0.fi_language AS fi_language_74 FROM content t0 INNER JOIN content_ref ON t0.id = content_ref.fi_content WHERE content_ref.fi_reference = 42740;

SELECT
  t0.id AS id_1,
  t0.fi_original_content AS fi_original_content_2,
  t0.special_type AS special_type_3,
  t0.homepage_type AS homepage_type_4,
  t0.main_category AS main_category_5,
  t0.main_region AS main_region_6,
  t0.homepage_image AS homepage_image_7,
  t0.homepage_image_mime AS homepage_image_mime_8,
  t0.listing_image AS listing_image_9,
  t0.listing_image_mime AS listing_image_mime_10,
  t0.top_story AS top_story_11,
  t0.headline AS headline_12,
  t0.publication_start_date AS publication_start_date_13,
  t0.publication_stop_date AS publication_stop_date_14,
  t0.advertising_stop_date AS advertising_stop_date_15,
  t0.payed_start_date AS payed_start_date_16,
  t0.payed_stop_date AS payed_stop_date_17,
  t0.validation_status AS validation_status_18,
  t0.payed_status AS payed_status_19,
  t0.adserver_stock AS adserver_stock_20,
  t0.adserver_stock_date AS adserver_stock_date_21,
  t0.adserver_stock_advertiser AS adserver_stock_advertiser_22,
  t0.adserver_stock_location AS adserver_stock_location_23,
  t0.modified_date AS modified_date_24,
  t0.create_date AS create_date_25,
  t0.homepage_start_date AS homepage_start_date_26,
  t0.special_stop_date AS special_stop_date_27,
  t0.fi_advertiser AS fi_advertiser_28,
  t0.fi_company AS fi_company_29,
  t0.clicks AS clicks_30,
  t0.clicks_total AS clicks_total_31,
  t0.fi_reference AS fi_reference_32,
  t0.fi_language AS fi_language_33,
  t0.fi_object AS fi_object_34,
  t0.author AS author_35,
  t0.file AS file_36,
  t0.file_url AS file_url_37,
  t0.file_name AS file_name_38,
  t0.contact_name AS contact_name_39,
  t0.contact_company AS contact_company_40,
  t0.contact_street AS contact_street_41,
  t0.contact_street2 AS contact_street2_42,
  t0.contact_zip_city AS contact_zip_city_43,
  t0.contact_fi_country AS contact_fi_country_44,
  t0.contact_phone AS contact_phone_45,
  t0.contact_fax AS contact_fax_46,
  t0.contact_email AS contact_email_47,
  t0.contact_website AS contact_website_48,
  t0.contact_twitter AS contact_twitter_49,
  t0.contact_linkedin AS contact_linkedin_50,
  t0.contact_xing AS contact_xing_51,
  t0.contact_facebook AS contact_facebook_52,
  t0.contact_youtube AS contact_youtube_53,
  t0.contact_instagram AS contact_instagram_54,
  t0.content_fi_category AS content_fi_category_55,
  t0.events_venue AS events_venue_56,
  t0.events_venue_map AS events_venue_map_57,
  t0.events_street AS events_street_58,
  t0.events_zip_city AS events_zip_city_59,
  t0.events_fi_country AS events_fi_country_60,
  t0.events_from_date AS events_from_date_61,
  t0.events_to_date AS events_to_date_62,
  t0.events_website AS events_website_63,
  t0.suppliers_content_fi_category AS suppliers_content_fi_category_64,
  t0.external_link AS external_link_65,
  t0.image_handling AS image_handling_66,
  t0.homepage AS homepage_67,
  t0.homepage_position AS homepage_position_68,
  t0.article_type AS article_type_69,
  t0.events_type AS events_type_70,
  t0.short_description AS short_description_71,
  t0.slug AS slug_72,
  t0.fi_reference AS fi_reference_73,
  t0.fi_language AS fi_language_74
FROM
  content t0
  INNER JOIN content_ref ON t0.id = content_ref.fi_content
WHERE
  content_ref.fi_reference = ?