Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.short_description AS short_description_2,
  t0.long_description AS long_description_3,
  t0.paid AS paid_4,
  t0.payment_identifier AS payment_identifier_5,
  t0.additional_link AS additional_link_6,
  t0.gameplay_link AS gameplay_link_7,
  t0.key_visual AS key_visual_8,
  t0.key_visual_hd AS key_visual_hd_9,
  t0.trailer_source AS trailer_source_10,
  t0.trailer_link AS trailer_link_11,
  t0.presentation_link AS presentation_link_12,
  t0.validated AS validated_13,
  t0.name AS name_14,
  t0.dev_time AS dev_time_15,
  t0.dev_number AS dev_number_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.nominated1_firstname AS nominated1_firstname_19,
  t0.nominated1_lastname AS nominated1_lastname_20,
  t0.nominated2_firstname AS nominated2_firstname_21,
  t0.nominated2_lastname AS nominated2_lastname_22,
  t0.nominated3_firstname AS nominated3_firstname_23,
  t0.nominated3_lastname AS nominated3_lastname_24,
  t0.support AS support_25,
  t0.developer AS developer_26,
  t0.is_testable AS is_testable_27,
  t0.test_url AS test_url_28,
  t0.consent1 AS consent1_29,
  t0.consent2 AS consent2_30,
  t0.consent3 AS consent3_31,
  t0.consent4 AS consent4_32,
  t0.author_id AS author_id_33,
  t0.session_id AS session_id_34
FROM
  submission t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.short_description AS short_description_2, t0.long_description AS long_description_3, t0.paid AS paid_4, t0.payment_identifier AS payment_identifier_5, t0.additional_link AS additional_link_6, t0.gameplay_link AS gameplay_link_7, t0.key_visual AS key_visual_8, t0.key_visual_hd AS key_visual_hd_9, t0.trailer_source AS trailer_source_10, t0.trailer_link AS trailer_link_11, t0.presentation_link AS presentation_link_12, t0.validated AS validated_13, t0.name AS name_14, t0.dev_time AS dev_time_15, t0.dev_number AS dev_number_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.nominated1_firstname AS nominated1_firstname_19, t0.nominated1_lastname AS nominated1_lastname_20, t0.nominated2_firstname AS nominated2_firstname_21, t0.nominated2_lastname AS nominated2_lastname_22, t0.nominated3_firstname AS nominated3_firstname_23, t0.nominated3_lastname AS nominated3_lastname_24, t0.support AS support_25, t0.developer AS developer_26, t0.is_testable AS is_testable_27, t0.test_url AS test_url_28, t0.consent1 AS consent1_29, t0.consent2 AS consent2_30, t0.consent3 AS consent3_31, t0.consent4 AS consent4_32, t0.author_id AS author_id_33, t0.session_id AS session_id_34 FROM submission t0 WHERE t0.id = '208';

SELECT
  t0.id AS id_1,
  t0.step AS step_2,
  t0.value AS value_3,
  t0.category_id AS category_id_4,
  t5.id AS id_6,
  t5.name AS name_7,
  t5.visible AS visible_8,
  t0.voter_id AS voter_id_9,
  t10.id AS id_11,
  t10.email AS email_12,
  t10.roles AS roles_13,
  t10.password AS password_14,
  t10.lastname AS lastname_15,
  t10.firstname AS firstname_16,
  t10.`function` AS function_17,
  t10.phone AS phone_18,
  t10.company AS company_19,
  t10.address AS address_20,
  t10.zipcode AS zipcode_21,
  t10.city AS city_22,
  t10.country AS country_23,
  t10.website AS website_24,
  t10.adherent AS adherent_25,
  t10.valid AS valid_26,
  t10.validation_token AS validation_token_27,
  t10.reset_token AS reset_token_28,
  t10.email_referent2 AS email_referent2_29,
  t10.lastname_referent2 AS lastname_referent2_30,
  t10.firstname_referent2 AS firstname_referent2_31,
  t10.function_referent2 AS function_referent2_32,
  t10.phone_referent2 AS phone_referent2_33,
  t10.email_referent3 AS email_referent3_34,
  t10.lastname_referent3 AS lastname_referent3_35,
  t10.firstname_referent3 AS firstname_referent3_36,
  t10.function_referent3 AS function_referent3_37,
  t10.phone_referent3 AS phone_referent3_38,
  t10.address2 AS address2_39,
  t10.expertise AS expertise_40,
  t0.submission_id AS submission_id_41,
  t42.id AS id_43,
  t42.short_description AS short_description_44,
  t42.long_description AS long_description_45,
  t42.paid AS paid_46,
  t42.payment_identifier AS payment_identifier_47,
  t42.additional_link AS additional_link_48,
  t42.gameplay_link AS gameplay_link_49,
  t42.key_visual AS key_visual_50,
  t42.key_visual_hd AS key_visual_hd_51,
  t42.trailer_source AS trailer_source_52,
  t42.trailer_link AS trailer_link_53,
  t42.presentation_link AS presentation_link_54,
  t42.validated AS validated_55,
  t42.name AS name_56,
  t42.dev_time AS dev_time_57,
  t42.dev_number AS dev_number_58,
  t42.created_at AS created_at_59,
  t42.updated_at AS updated_at_60,
  t42.nominated1_firstname AS nominated1_firstname_61,
  t42.nominated1_lastname AS nominated1_lastname_62,
  t42.nominated2_firstname AS nominated2_firstname_63,
  t42.nominated2_lastname AS nominated2_lastname_64,
  t42.nominated3_firstname AS nominated3_firstname_65,
  t42.nominated3_lastname AS nominated3_lastname_66,
  t42.support AS support_67,
  t42.developer AS developer_68,
  t42.is_testable AS is_testable_69,
  t42.test_url AS test_url_70,
  t42.consent1 AS consent1_71,
  t42.consent2 AS consent2_72,
  t42.consent3 AS consent3_73,
  t42.consent4 AS consent4_74,
  t42.author_id AS author_id_75,
  t42.session_id AS session_id_76
FROM
  vote t0
  INNER JOIN category t5 ON t0.category_id = t5.id
  INNER JOIN user t10 ON t0.voter_id = t10.id
  INNER JOIN submission t42 ON t0.submission_id = t42.id
WHERE
  t0.submission_id IN (?)

SELECT t0.id AS id_1, t0.step AS step_2, t0.value AS value_3, t0.category_id AS category_id_4, t5.id AS id_6, t5.name AS name_7, t5.visible AS visible_8, t0.voter_id AS voter_id_9, t10.id AS id_11, t10.email AS email_12, t10.roles AS roles_13, t10.password AS password_14, t10.lastname AS lastname_15, t10.firstname AS firstname_16, t10.`function` AS function_17, t10.phone AS phone_18, t10.company AS company_19, t10.address AS address_20, t10.zipcode AS zipcode_21, t10.city AS city_22, t10.country AS country_23, t10.website AS website_24, t10.adherent AS adherent_25, t10.valid AS valid_26, t10.validation_token AS validation_token_27, t10.reset_token AS reset_token_28, t10.email_referent2 AS email_referent2_29, t10.lastname_referent2 AS lastname_referent2_30, t10.firstname_referent2 AS firstname_referent2_31, t10.function_referent2 AS function_referent2_32, t10.phone_referent2 AS phone_referent2_33, t10.email_referent3 AS email_referent3_34, t10.lastname_referent3 AS lastname_referent3_35, t10.firstname_referent3 AS firstname_referent3_36, t10.function_referent3 AS function_referent3_37, t10.phone_referent3 AS phone_referent3_38, t10.address2 AS address2_39, t10.expertise AS expertise_40, t0.submission_id AS submission_id_41, t42.id AS id_43, t42.short_description AS short_description_44, t42.long_description AS long_description_45, t42.paid AS paid_46, t42.payment_identifier AS payment_identifier_47, t42.additional_link AS additional_link_48, t42.gameplay_link AS gameplay_link_49, t42.key_visual AS key_visual_50, t42.key_visual_hd AS key_visual_hd_51, t42.trailer_source AS trailer_source_52, t42.trailer_link AS trailer_link_53, t42.presentation_link AS presentation_link_54, t42.validated AS validated_55, t42.name AS name_56, t42.dev_time AS dev_time_57, t42.dev_number AS dev_number_58, t42.created_at AS created_at_59, t42.updated_at AS updated_at_60, t42.nominated1_firstname AS nominated1_firstname_61, t42.nominated1_lastname AS nominated1_lastname_62, t42.nominated2_firstname AS nominated2_firstname_63, t42.nominated2_lastname AS nominated2_lastname_64, t42.nominated3_firstname AS nominated3_firstname_65, t42.nominated3_lastname AS nominated3_lastname_66, t42.support AS support_67, t42.developer AS developer_68, t42.is_testable AS is_testable_69, t42.test_url AS test_url_70, t42.consent1 AS consent1_71, t42.consent2 AS consent2_72, t42.consent3 AS consent3_73, t42.consent4 AS consent4_74, t42.author_id AS author_id_75, t42.session_id AS session_id_76 FROM vote t0 INNER JOIN category t5 ON t0.category_id = t5.id INNER JOIN user t10 ON t0.voter_id = t10.id INNER JOIN submission t42 ON t0.submission_id = t42.id WHERE t0.submission_id IN (208);

SELECT
  t0.`setting_key` AS setting_key_1,
  t0.value AS value_2
FROM
  app_settings t0
WHERE
  t0.`setting_key` = ?

SELECT t0.`setting_key` AS setting_key_1, t0.value AS value_2 FROM app_settings t0 WHERE t0.`setting_key` = 'session_enabled';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_submission_end AS date_submission_end_3,
  t0.date_first_step_start AS date_first_step_start_4,
  t0.date_first_step_end AS date_first_step_end_5,
  t0.date_second_step_start AS date_second_step_start_6,
  t0.date_second_step_end AS date_second_step_end_7
FROM
  session t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_submission_end AS date_submission_end_3, t0.date_first_step_start AS date_first_step_start_4, t0.date_first_step_end AS date_first_step_end_5, t0.date_second_step_start AS date_second_step_start_6, t0.date_second_step_end AS date_second_step_end_7 FROM session t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3
FROM
  category t0
  INNER JOIN submission_category ON t0.id = submission_category.category_id
WHERE
  submission_category.submission_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3 FROM category t0 INNER JOIN submission_category ON t0.id = submission_category.category_id WHERE submission_category.submission_id = 208;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.submission_id AS submission_id_3,
  t0.category_id AS category_id_4
FROM
  submission_motivation t0
WHERE
  t0.submission_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.submission_id AS submission_id_3, t0.category_id AS category_id_4 FROM submission_motivation t0 WHERE t0.submission_id = 208;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3 FROM category t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3 FROM category t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3 FROM category t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3 FROM category t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3 FROM category t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.visible AS visible_3
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3 FROM category t0 WHERE t0.id = 12;