Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.url AS url_3,
  t0.data AS data_4,
  t0.settings AS settings_5,
  t0.original_file_name AS original_file_name_6,
  t0.created AS created_7,
  t0.updated AS updated_8
FROM
  medium t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.url AS url_3, t0.data AS data_4, t0.settings AS settings_5, t0.original_file_name AS original_file_name_6, t0.created AS created_7, t0.updated AS updated_8 FROM medium t0 WHERE t0.id = 1257;

SELECT
  t0.id AS id_1,
  t0.category AS category_2,
  t0.label AS label_3,
  t0.copyright AS copyright_4,
  t0.sort AS sort_5,
  t0.sort_frontend AS sort_frontend_6,
  t0.is_active AS is_active_7,
  t0.project AS project_8,
  t0.medium AS medium_9
FROM
  `project_medium` t0
WHERE
  t0.project = ?
ORDER BY
  t0.sort_frontend ASC

SELECT t0.id AS id_1, t0.category AS category_2, t0.label AS label_3, t0.copyright AS copyright_4, t0.sort AS sort_5, t0.sort_frontend AS sort_frontend_6, t0.is_active AS is_active_7, t0.project AS project_8, t0.medium AS medium_9 FROM `project_medium` t0 WHERE t0.project = 230 ORDER BY t0.sort_frontend ASC;

SELECT
  a0_.id AS id_0,
  a0_.`name` AS name_1,
  a0_.sort_name AS sort_name_2,
  a0_.is_member AS is_member_3,
  a0_.member_group AS member_group_4,
  a0_.is_uea_certificated AS is_uea_certificated_5,
  a0_.is_ce_certificated AS is_ce_certificated_6,
  a0_.is_ued_certificated AS is_ued_certificated_7,
  a0_.wood_from_here_member AS wood_from_here_member_8,
  a0_.enable_notifications AS enable_notifications_9,
  a0_.street AS street_10,
  a0_.city AS city_11,
  a0_.location AS location_12,
  a0_.phone AS phone_13,
  a0_.mobile AS mobile_14,
  a0_.fax AS fax_15,
  a0_.email AS email_16,
  a0_.`password` AS password_17,
  a0_.web AS web_18,
  a0_.facebook AS facebook_19,
  a0_.instagram AS instagram_20,
  a0_.social AS social_21,
  a0_.contact_title AS contact_title_22,
  a0_.contact_first_name AS contact_first_name_23,
  a0_.contact_last_name AS contact_last_name_24,
  a0_.contact_email AS contact_email_25,
  a0_.contact_phone AS contact_phone_26,
  a0_.views AS views_27,
  a0_.slogan AS slogan_28,
  a0_.description AS description_29,
  a0_.youtube AS youtube_30,
  a0_.reset_token AS reset_token_31,
  a0_.reset_token_expiry AS reset_token_expiry_32,
  a0_.created AS created_33,
  a0_.updated AS updated_34,
  a0_.contact_salutation AS contact_salutation_35,
  a0_.deleted AS deleted_36,
  a0_.logo AS logo_37,
  a0_.descendant_id AS descendant_id_38
FROM
  `address` a0_

SELECT a0_.id AS id_0, a0_.`name` AS name_1, a0_.sort_name AS sort_name_2, a0_.is_member AS is_member_3, a0_.member_group AS member_group_4, a0_.is_uea_certificated AS is_uea_certificated_5, a0_.is_ce_certificated AS is_ce_certificated_6, a0_.is_ued_certificated AS is_ued_certificated_7, a0_.wood_from_here_member AS wood_from_here_member_8, a0_.enable_notifications AS enable_notifications_9, a0_.street AS street_10, a0_.city AS city_11, a0_.location AS location_12, a0_.phone AS phone_13, a0_.mobile AS mobile_14, a0_.fax AS fax_15, a0_.email AS email_16, a0_.`password` AS password_17, a0_.web AS web_18, a0_.facebook AS facebook_19, a0_.instagram AS instagram_20, a0_.social AS social_21, a0_.contact_title AS contact_title_22, a0_.contact_first_name AS contact_first_name_23, a0_.contact_last_name AS contact_last_name_24, a0_.contact_email AS contact_email_25, a0_.contact_phone AS contact_phone_26, a0_.views AS views_27, a0_.slogan AS slogan_28, a0_.description AS description_29, a0_.youtube AS youtube_30, a0_.reset_token AS reset_token_31, a0_.reset_token_expiry AS reset_token_expiry_32, a0_.created AS created_33, a0_.updated AS updated_34, a0_.contact_salutation AS contact_salutation_35, a0_.deleted AS deleted_36, a0_.logo AS logo_37, a0_.descendant_id AS descendant_id_38 FROM `address` a0_;

SELECT
  t0.id AS id_1,
  t0.is_payed AS is_payed_2,
  t0.has_win AS has_win_3,
  t0.has_tribute AS has_tribute_4,
  t0.has_keep AS has_keep_5,
  t0.jurytext AS jurytext_6,
  t0.award AS award_7,
  t0.sort AS sort_8,
  t0.is_smart_wood AS is_smart_wood_9,
  t0.is_regional_wood AS is_regional_wood_10,
  t0.jurytext_smart_wood AS jurytext_smart_wood_11,
  t0.jurytext_regional_wood AS jurytext_regional_wood_12,
  t0.is_future AS is_future_13,
  t0.is_relevance AS is_relevance_14,
  t0.jurytext_future AS jurytext_future_15,
  t0.jurytext_relevance AS jurytext_relevance_16,
  t0.project AS project_17,
  t0.campaign AS campaign_18
FROM
  `project_campaign` t0
WHERE
  t0.project = ?

SELECT t0.id AS id_1, t0.is_payed AS is_payed_2, t0.has_win AS has_win_3, t0.has_tribute AS has_tribute_4, t0.has_keep AS has_keep_5, t0.jurytext AS jurytext_6, t0.award AS award_7, t0.sort AS sort_8, t0.is_smart_wood AS is_smart_wood_9, t0.is_regional_wood AS is_regional_wood_10, t0.jurytext_smart_wood AS jurytext_smart_wood_11, t0.jurytext_regional_wood AS jurytext_regional_wood_12, t0.is_future AS is_future_13, t0.is_relevance AS is_relevance_14, t0.jurytext_future AS jurytext_future_15, t0.jurytext_relevance AS jurytext_relevance_16, t0.project AS project_17, t0.campaign AS campaign_18 FROM `project_campaign` t0 WHERE t0.project = 230;

SELECT
  t0.id AS id_1,
  t0.rejected AS rejected_2,
  t0.reject_message AS reject_message_3,
  t0.prepared AS prepared_4,
  t0.created AS created_5,
  t0.submitted AS submitted_6,
  t0.project AS project_7
FROM
  `project_submission` t0
WHERE
  t0.project = ?

SELECT t0.id AS id_1, t0.rejected AS rejected_2, t0.reject_message AS reject_message_3, t0.prepared AS prepared_4, t0.created AS created_5, t0.submitted AS submitted_6, t0.project AS project_7 FROM `project_submission` t0 WHERE t0.project = 230;

SELECT
  t0.id AS id_1,
  t0.`reason` AS reason_2,
  t0.`reason_2` AS reason_2_3,
  t0.project AS project_4,
  t0.certificate AS certificate_5
FROM
  `project_certificate` t0
WHERE
  t0.project = ?

SELECT t0.id AS id_1, t0.`reason` AS reason_2, t0.`reason_2` AS reason_2_3, t0.project AS project_4, t0.certificate AS certificate_5 FROM `project_certificate` t0 WHERE t0.project = 230;

SELECT
  t0.id AS id_1,
  t0.project_id AS project_id_2,
  t0.address_id AS address_id_3
FROM
  project_carpenter t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.address_id AS address_id_3 FROM project_carpenter t0 WHERE t0.project_id = 230;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.is_live AS is_live_2,
  p0_.show_exact_position AS show_exact_position_3,
  p0_.categories AS categories_4,
  p0_.special_categories AS special_categories_5,
  p0_.is_deleted AS is_deleted_6,
  p0_.created AS created_7,
  p0_.updated AS updated_8,
  p0_.category AS category_9,
  p0_.description AS description_10,
  p0_.jurytext AS jurytext_11,
  p0_.client AS client_12,
  p0_.street AS street_13,
  p0_.location AS location_14,
  p0_.latitude AS latitude_15,
  p0_.longitude AS longitude_16,
  p0_.award AS award_17,
  p0_.event AS event_18,
  p0_.visiting_hours AS visiting_hours_19,
  p0_.is_premium AS is_premium_20,
  p0_.client_street AS client_street_21,
  p0_.client_location AS client_location_22,
  p0_.client_phone AS client_phone_23,
  p0_.privacy_policy AS privacy_policy_24,
  p0_.sort AS sort_25,
  p0_.anonymize_client AS anonymize_client_26,
  p0_.short_description AS short_description_27,
  p0_.youtube AS youtube_28,
  p0_.vimeo AS vimeo_29,
  p0_.is_open AS is_open_30,
  p0_.is_cancelled AS is_cancelled_31,
  p0_.is_incomplete AS is_incomplete_32,
  p0_.client_email AS client_email_33,
  p0_.photographer AS photographer_34,
  p0_.execution AS execution_35,
  p0_.use_area AS use_area_36,
  p0_.windows AS windows_37,
  p0_.expansion AS expansion_38,
  p0_.energy AS energy_39,
  p0_.prices AS prices_40,
  p0_.slug AS slug_41,
  p0_.prefabrication AS prefabrication_42,
  p0_.execution_floor AS execution_floor_43,
  p0_.execution_wall AS execution_wall_44,
  p0_.execution_ceiling AS execution_ceiling_45,
  p0_.windows_more AS windows_more_46,
  p0_.windows_checkbox AS windows_checkbox_47,
  p0_.is_full_deleted AS is_full_deleted_48,
  p0_.jurytext_smart_wood AS jurytext_smart_wood_49,
  p0_.jurytext_regional_wood AS jurytext_regional_wood_50,
  p0_.jurytext_future AS jurytext_future_51,
  p0_.jurytext_relevance AS jurytext_relevance_52,
  p0_.submitter AS submitter_53,
  p0_.main_category AS main_category_54,
  p0_.windows_builder_id AS windows_builder_id_55,
  p0_.structural_engineering_id AS structural_engineering_id_56
FROM
  project p0_
  LEFT JOIN `project_campaign` p1_ ON p0_.id = p1_.project
  LEFT JOIN campaign c2_ ON p1_.campaign = c2_.id
WHERE
  p0_.is_live = 1
  AND p0_.is_deleted <> 1
  AND p0_.is_full_deleted <> 1
  AND c2_.identifier = ?
ORDER BY
  ABS(p1_.sort) ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_live AS is_live_2, p0_.show_exact_position AS show_exact_position_3, p0_.categories AS categories_4, p0_.special_categories AS special_categories_5, p0_.is_deleted AS is_deleted_6, p0_.created AS created_7, p0_.updated AS updated_8, p0_.category AS category_9, p0_.description AS description_10, p0_.jurytext AS jurytext_11, p0_.client AS client_12, p0_.street AS street_13, p0_.location AS location_14, p0_.latitude AS latitude_15, p0_.longitude AS longitude_16, p0_.award AS award_17, p0_.event AS event_18, p0_.visiting_hours AS visiting_hours_19, p0_.is_premium AS is_premium_20, p0_.client_street AS client_street_21, p0_.client_location AS client_location_22, p0_.client_phone AS client_phone_23, p0_.privacy_policy AS privacy_policy_24, p0_.sort AS sort_25, p0_.anonymize_client AS anonymize_client_26, p0_.short_description AS short_description_27, p0_.youtube AS youtube_28, p0_.vimeo AS vimeo_29, p0_.is_open AS is_open_30, p0_.is_cancelled AS is_cancelled_31, p0_.is_incomplete AS is_incomplete_32, p0_.client_email AS client_email_33, p0_.photographer AS photographer_34, p0_.execution AS execution_35, p0_.use_area AS use_area_36, p0_.windows AS windows_37, p0_.expansion AS expansion_38, p0_.energy AS energy_39, p0_.prices AS prices_40, p0_.slug AS slug_41, p0_.prefabrication AS prefabrication_42, p0_.execution_floor AS execution_floor_43, p0_.execution_wall AS execution_wall_44, p0_.execution_ceiling AS execution_ceiling_45, p0_.windows_more AS windows_more_46, p0_.windows_checkbox AS windows_checkbox_47, p0_.is_full_deleted AS is_full_deleted_48, p0_.jurytext_smart_wood AS jurytext_smart_wood_49, p0_.jurytext_regional_wood AS jurytext_regional_wood_50, p0_.jurytext_future AS jurytext_future_51, p0_.jurytext_relevance AS jurytext_relevance_52, p0_.submitter AS submitter_53, p0_.main_category AS main_category_54, p0_.windows_builder_id AS windows_builder_id_55, p0_.structural_engineering_id AS structural_engineering_id_56 FROM project p0_ LEFT JOIN `project_campaign` p1_ ON p0_.id = p1_.project LEFT JOIN campaign c2_ ON p1_.campaign = c2_.id WHERE p0_.is_live = 1 AND p0_.is_deleted <> 1 AND p0_.is_full_deleted <> 1 AND c2_.identifier = 'holzbaupreis-2009' ORDER BY ABS(p1_.sort) ASC;

SELECT
  t0.id AS id_1,
  t0.`name` AS name_2,
  t0.sort_name AS sort_name_3,
  t0.is_member AS is_member_4,
  t0.member_group AS member_group_5,
  t0.is_uea_certificated AS is_uea_certificated_6,
  t0.is_ce_certificated AS is_ce_certificated_7,
  t0.is_ued_certificated AS is_ued_certificated_8,
  t0.wood_from_here_member AS wood_from_here_member_9,
  t0.enable_notifications AS enable_notifications_10,
  t0.street AS street_11,
  t0.city AS city_12,
  t0.location AS location_13,
  t0.phone AS phone_14,
  t0.mobile AS mobile_15,
  t0.fax AS fax_16,
  t0.email AS email_17,
  t0.`password` AS password_18,
  t0.web AS web_19,
  t0.facebook AS facebook_20,
  t0.instagram AS instagram_21,
  t0.social AS social_22,
  t0.contact_title AS contact_title_23,
  t0.contact_first_name AS contact_first_name_24,
  t0.contact_last_name AS contact_last_name_25,
  t0.contact_email AS contact_email_26,
  t0.contact_phone AS contact_phone_27,
  t0.views AS views_28,
  t0.slogan AS slogan_29,
  t0.description AS description_30,
  t0.youtube AS youtube_31,
  t0.reset_token AS reset_token_32,
  t0.reset_token_expiry AS reset_token_expiry_33,
  t0.created AS created_34,
  t0.updated AS updated_35,
  t0.contact_salutation AS contact_salutation_36,
  t0.deleted AS deleted_37,
  t0.logo AS logo_38,
  t0.descendant_id AS descendant_id_39
FROM
  `address` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.`name` AS name_2, t0.sort_name AS sort_name_3, t0.is_member AS is_member_4, t0.member_group AS member_group_5, t0.is_uea_certificated AS is_uea_certificated_6, t0.is_ce_certificated AS is_ce_certificated_7, t0.is_ued_certificated AS is_ued_certificated_8, t0.wood_from_here_member AS wood_from_here_member_9, t0.enable_notifications AS enable_notifications_10, t0.street AS street_11, t0.city AS city_12, t0.location AS location_13, t0.phone AS phone_14, t0.mobile AS mobile_15, t0.fax AS fax_16, t0.email AS email_17, t0.`password` AS password_18, t0.web AS web_19, t0.facebook AS facebook_20, t0.instagram AS instagram_21, t0.social AS social_22, t0.contact_title AS contact_title_23, t0.contact_first_name AS contact_first_name_24, t0.contact_last_name AS contact_last_name_25, t0.contact_email AS contact_email_26, t0.contact_phone AS contact_phone_27, t0.views AS views_28, t0.slogan AS slogan_29, t0.description AS description_30, t0.youtube AS youtube_31, t0.reset_token AS reset_token_32, t0.reset_token_expiry AS reset_token_expiry_33, t0.created AS created_34, t0.updated AS updated_35, t0.contact_salutation AS contact_salutation_36, t0.deleted AS deleted_37, t0.logo AS logo_38, t0.descendant_id AS descendant_id_39 FROM `address` t0 WHERE t0.id = 22;

SELECT
  p0_.id AS id_0,
  t1_.name AS name_1,
  t1_.is_important AS is_important_2,
  a2_.`name` AS name_3,
  a2_.location AS location_4
FROM
  project p0_
  LEFT JOIN `project_task` p3_ ON p0_.id = p3_.project
  LEFT JOIN `address` a2_ ON p3_.address = a2_.id
  LEFT JOIN task t1_ ON p3_.task = t1_.id

SELECT p0_.id AS id_0, t1_.name AS name_1, t1_.is_important AS is_important_2, a2_.`name` AS name_3, a2_.location AS location_4 FROM project p0_ LEFT JOIN `project_task` p3_ ON p0_.id = p3_.project LEFT JOIN `address` a2_ ON p3_.address = a2_.id LEFT JOIN task t1_ ON p3_.task = t1_.id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.identifier AS identifier_3,
  t0.type AS type_4,
  t0.is_admin AS is_admin_5,
  t0.is_prospect AS is_prospect_6,
  t0.is_published AS is_published_7,
  t0.available_from AS available_from_8,
  t0.available_till AS available_till_9,
  t0.publish_from AS publish_from_10,
  t0.publish_till AS publish_till_11,
  t0.price AS price_12,
  t0.config AS config_13,
  t0.actions AS actions_14,
  t0.conditions AS conditions_15,
  t0.consent AS consent_16
FROM
  campaign t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3, t0.type AS type_4, t0.is_admin AS is_admin_5, t0.is_prospect AS is_prospect_6, t0.is_published AS is_published_7, t0.available_from AS available_from_8, t0.available_till AS available_till_9, t0.publish_from AS publish_from_10, t0.publish_till AS publish_till_11, t0.price AS price_12, t0.config AS config_13, t0.actions AS actions_14, t0.conditions AS conditions_15, t0.consent AS consent_16 FROM campaign t0 WHERE t0.id = 3;