Symfony Profiler

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

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

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.`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` = 'current_session_id';

SELECT
  s0_.id AS id_0,
  s0_.short_description AS short_description_1,
  s0_.long_description AS long_description_2,
  s0_.paid AS paid_3,
  s0_.payment_identifier AS payment_identifier_4,
  s0_.additional_link AS additional_link_5,
  s0_.gameplay_link AS gameplay_link_6,
  s0_.key_visual AS key_visual_7,
  s0_.key_visual_hd AS key_visual_hd_8,
  s0_.trailer_source AS trailer_source_9,
  s0_.trailer_link AS trailer_link_10,
  s0_.presentation_link AS presentation_link_11,
  s0_.validated AS validated_12,
  s0_.name AS name_13,
  s0_.dev_time AS dev_time_14,
  s0_.dev_number AS dev_number_15,
  s0_.created_at AS created_at_16,
  s0_.updated_at AS updated_at_17,
  s0_.nominated1_firstname AS nominated1_firstname_18,
  s0_.nominated1_lastname AS nominated1_lastname_19,
  s0_.nominated2_firstname AS nominated2_firstname_20,
  s0_.nominated2_lastname AS nominated2_lastname_21,
  s0_.nominated3_firstname AS nominated3_firstname_22,
  s0_.nominated3_lastname AS nominated3_lastname_23,
  s0_.support AS support_24,
  s0_.developer AS developer_25,
  s0_.is_testable AS is_testable_26,
  s0_.test_url AS test_url_27,
  s0_.consent1 AS consent1_28,
  s0_.consent2 AS consent2_29,
  s0_.consent3 AS consent3_30,
  s0_.consent4 AS consent4_31,
  s0_.author_id AS author_id_32,
  s0_.session_id AS session_id_33
FROM
  submission s0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      submission_category s1_
    WHERE
      s1_.submission_id = s0_.id
      AND s1_.category_id IN (?)
  )
  AND s0_.validated = 1
  AND s0_.session_id = ?

SELECT s0_.id AS id_0, s0_.short_description AS short_description_1, s0_.long_description AS long_description_2, s0_.paid AS paid_3, s0_.payment_identifier AS payment_identifier_4, s0_.additional_link AS additional_link_5, s0_.gameplay_link AS gameplay_link_6, s0_.key_visual AS key_visual_7, s0_.key_visual_hd AS key_visual_hd_8, s0_.trailer_source AS trailer_source_9, s0_.trailer_link AS trailer_link_10, s0_.presentation_link AS presentation_link_11, s0_.validated AS validated_12, s0_.name AS name_13, s0_.dev_time AS dev_time_14, s0_.dev_number AS dev_number_15, s0_.created_at AS created_at_16, s0_.updated_at AS updated_at_17, s0_.nominated1_firstname AS nominated1_firstname_18, s0_.nominated1_lastname AS nominated1_lastname_19, s0_.nominated2_firstname AS nominated2_firstname_20, s0_.nominated2_lastname AS nominated2_lastname_21, s0_.nominated3_firstname AS nominated3_firstname_22, s0_.nominated3_lastname AS nominated3_lastname_23, s0_.support AS support_24, s0_.developer AS developer_25, s0_.is_testable AS is_testable_26, s0_.test_url AS test_url_27, s0_.consent1 AS consent1_28, s0_.consent2 AS consent2_29, s0_.consent3 AS consent3_30, s0_.consent4 AS consent4_31, s0_.author_id AS author_id_32, s0_.session_id AS session_id_33 FROM submission s0_ WHERE EXISTS (SELECT 1 FROM submission_category s1_ WHERE s1_.submission_id = s0_.id AND s1_.category_id IN (1)) AND s0_.validated = 1 AND s0_.session_id = 1;

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 (1, 9, 199, 201, 206, 212, 213);

SELECT
  s0_.id AS id_0,
  s0_.short_description AS short_description_1,
  s0_.long_description AS long_description_2,
  s0_.paid AS paid_3,
  s0_.payment_identifier AS payment_identifier_4,
  s0_.additional_link AS additional_link_5,
  s0_.gameplay_link AS gameplay_link_6,
  s0_.key_visual AS key_visual_7,
  s0_.key_visual_hd AS key_visual_hd_8,
  s0_.trailer_source AS trailer_source_9,
  s0_.trailer_link AS trailer_link_10,
  s0_.presentation_link AS presentation_link_11,
  s0_.validated AS validated_12,
  s0_.name AS name_13,
  s0_.dev_time AS dev_time_14,
  s0_.dev_number AS dev_number_15,
  s0_.created_at AS created_at_16,
  s0_.updated_at AS updated_at_17,
  s0_.nominated1_firstname AS nominated1_firstname_18,
  s0_.nominated1_lastname AS nominated1_lastname_19,
  s0_.nominated2_firstname AS nominated2_firstname_20,
  s0_.nominated2_lastname AS nominated2_lastname_21,
  s0_.nominated3_firstname AS nominated3_firstname_22,
  s0_.nominated3_lastname AS nominated3_lastname_23,
  s0_.support AS support_24,
  s0_.developer AS developer_25,
  s0_.is_testable AS is_testable_26,
  s0_.test_url AS test_url_27,
  s0_.consent1 AS consent1_28,
  s0_.consent2 AS consent2_29,
  s0_.consent3 AS consent3_30,
  s0_.consent4 AS consent4_31,
  s0_.author_id AS author_id_32,
  s0_.session_id AS session_id_33
FROM
  submission s0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      submission_category s1_
    WHERE
      s1_.submission_id = s0_.id
      AND s1_.category_id IN (?)
  )
  AND s0_.validated = 1
  AND s0_.session_id = ?

SELECT s0_.id AS id_0, s0_.short_description AS short_description_1, s0_.long_description AS long_description_2, s0_.paid AS paid_3, s0_.payment_identifier AS payment_identifier_4, s0_.additional_link AS additional_link_5, s0_.gameplay_link AS gameplay_link_6, s0_.key_visual AS key_visual_7, s0_.key_visual_hd AS key_visual_hd_8, s0_.trailer_source AS trailer_source_9, s0_.trailer_link AS trailer_link_10, s0_.presentation_link AS presentation_link_11, s0_.validated AS validated_12, s0_.name AS name_13, s0_.dev_time AS dev_time_14, s0_.dev_number AS dev_number_15, s0_.created_at AS created_at_16, s0_.updated_at AS updated_at_17, s0_.nominated1_firstname AS nominated1_firstname_18, s0_.nominated1_lastname AS nominated1_lastname_19, s0_.nominated2_firstname AS nominated2_firstname_20, s0_.nominated2_lastname AS nominated2_lastname_21, s0_.nominated3_firstname AS nominated3_firstname_22, s0_.nominated3_lastname AS nominated3_lastname_23, s0_.support AS support_24, s0_.developer AS developer_25, s0_.is_testable AS is_testable_26, s0_.test_url AS test_url_27, s0_.consent1 AS consent1_28, s0_.consent2 AS consent2_29, s0_.consent3 AS consent3_30, s0_.consent4 AS consent4_31, s0_.author_id AS author_id_32, s0_.session_id AS session_id_33 FROM submission s0_ WHERE EXISTS (SELECT 1 FROM submission_category s1_ WHERE s1_.submission_id = s0_.id AND s1_.category_id IN (2)) AND s0_.validated = 1 AND s0_.session_id = 1;

SELECT
  s0_.id AS id_0,
  s0_.short_description AS short_description_1,
  s0_.long_description AS long_description_2,
  s0_.paid AS paid_3,
  s0_.payment_identifier AS payment_identifier_4,
  s0_.additional_link AS additional_link_5,
  s0_.gameplay_link AS gameplay_link_6,
  s0_.key_visual AS key_visual_7,
  s0_.key_visual_hd AS key_visual_hd_8,
  s0_.trailer_source AS trailer_source_9,
  s0_.trailer_link AS trailer_link_10,
  s0_.presentation_link AS presentation_link_11,
  s0_.validated AS validated_12,
  s0_.name AS name_13,
  s0_.dev_time AS dev_time_14,
  s0_.dev_number AS dev_number_15,
  s0_.created_at AS created_at_16,
  s0_.updated_at AS updated_at_17,
  s0_.nominated1_firstname AS nominated1_firstname_18,
  s0_.nominated1_lastname AS nominated1_lastname_19,
  s0_.nominated2_firstname AS nominated2_firstname_20,
  s0_.nominated2_lastname AS nominated2_lastname_21,
  s0_.nominated3_firstname AS nominated3_firstname_22,
  s0_.nominated3_lastname AS nominated3_lastname_23,
  s0_.support AS support_24,
  s0_.developer AS developer_25,
  s0_.is_testable AS is_testable_26,
  s0_.test_url AS test_url_27,
  s0_.consent1 AS consent1_28,
  s0_.consent2 AS consent2_29,
  s0_.consent3 AS consent3_30,
  s0_.consent4 AS consent4_31,
  s0_.author_id AS author_id_32,
  s0_.session_id AS session_id_33
FROM
  submission s0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      submission_category s1_
    WHERE
      s1_.submission_id = s0_.id
      AND s1_.category_id IN (?)
  )
  AND s0_.validated = 1
  AND s0_.session_id = ?

SELECT s0_.id AS id_0, s0_.short_description AS short_description_1, s0_.long_description AS long_description_2, s0_.paid AS paid_3, s0_.payment_identifier AS payment_identifier_4, s0_.additional_link AS additional_link_5, s0_.gameplay_link AS gameplay_link_6, s0_.key_visual AS key_visual_7, s0_.key_visual_hd AS key_visual_hd_8, s0_.trailer_source AS trailer_source_9, s0_.trailer_link AS trailer_link_10, s0_.presentation_link AS presentation_link_11, s0_.validated AS validated_12, s0_.name AS name_13, s0_.dev_time AS dev_time_14, s0_.dev_number AS dev_number_15, s0_.created_at AS created_at_16, s0_.updated_at AS updated_at_17, s0_.nominated1_firstname AS nominated1_firstname_18, s0_.nominated1_lastname AS nominated1_lastname_19, s0_.nominated2_firstname AS nominated2_firstname_20, s0_.nominated2_lastname AS nominated2_lastname_21, s0_.nominated3_firstname AS nominated3_firstname_22, s0_.nominated3_lastname AS nominated3_lastname_23, s0_.support AS support_24, s0_.developer AS developer_25, s0_.is_testable AS is_testable_26, s0_.test_url AS test_url_27, s0_.consent1 AS consent1_28, s0_.consent2 AS consent2_29, s0_.consent3 AS consent3_30, s0_.consent4 AS consent4_31, s0_.author_id AS author_id_32, s0_.session_id AS session_id_33 FROM submission s0_ WHERE EXISTS (SELECT 1 FROM submission_category s1_ WHERE s1_.submission_id = s0_.id AND s1_.category_id IN (3)) AND s0_.validated = 1 AND s0_.session_id = 1;

SELECT
  s0_.id AS id_0,
  s0_.short_description AS short_description_1,
  s0_.long_description AS long_description_2,
  s0_.paid AS paid_3,
  s0_.payment_identifier AS payment_identifier_4,
  s0_.additional_link AS additional_link_5,
  s0_.gameplay_link AS gameplay_link_6,
  s0_.key_visual AS key_visual_7,
  s0_.key_visual_hd AS key_visual_hd_8,
  s0_.trailer_source AS trailer_source_9,
  s0_.trailer_link AS trailer_link_10,
  s0_.presentation_link AS presentation_link_11,
  s0_.validated AS validated_12,
  s0_.name AS name_13,
  s0_.dev_time AS dev_time_14,
  s0_.dev_number AS dev_number_15,
  s0_.created_at AS created_at_16,
  s0_.updated_at AS updated_at_17,
  s0_.nominated1_firstname AS nominated1_firstname_18,
  s0_.nominated1_lastname AS nominated1_lastname_19,
  s0_.nominated2_firstname AS nominated2_firstname_20,
  s0_.nominated2_lastname AS nominated2_lastname_21,
  s0_.nominated3_firstname AS nominated3_firstname_22,
  s0_.nominated3_lastname AS nominated3_lastname_23,
  s0_.support AS support_24,
  s0_.developer AS developer_25,
  s0_.is_testable AS is_testable_26,
  s0_.test_url AS test_url_27,
  s0_.consent1 AS consent1_28,
  s0_.consent2 AS consent2_29,
  s0_.consent3 AS consent3_30,
  s0_.consent4 AS consent4_31,
  s0_.author_id AS author_id_32,
  s0_.session_id AS session_id_33
FROM
  submission s0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      submission_category s1_
    WHERE
      s1_.submission_id = s0_.id
      AND s1_.category_id IN (?)
  )
  AND s0_.validated = 1
  AND s0_.session_id = ?

SELECT s0_.id AS id_0, s0_.short_description AS short_description_1, s0_.long_description AS long_description_2, s0_.paid AS paid_3, s0_.payment_identifier AS payment_identifier_4, s0_.additional_link AS additional_link_5, s0_.gameplay_link AS gameplay_link_6, s0_.key_visual AS key_visual_7, s0_.key_visual_hd AS key_visual_hd_8, s0_.trailer_source AS trailer_source_9, s0_.trailer_link AS trailer_link_10, s0_.presentation_link AS presentation_link_11, s0_.validated AS validated_12, s0_.name AS name_13, s0_.dev_time AS dev_time_14, s0_.dev_number AS dev_number_15, s0_.created_at AS created_at_16, s0_.updated_at AS updated_at_17, s0_.nominated1_firstname AS nominated1_firstname_18, s0_.nominated1_lastname AS nominated1_lastname_19, s0_.nominated2_firstname AS nominated2_firstname_20, s0_.nominated2_lastname AS nominated2_lastname_21, s0_.nominated3_firstname AS nominated3_firstname_22, s0_.nominated3_lastname AS nominated3_lastname_23, s0_.support AS support_24, s0_.developer AS developer_25, s0_.is_testable AS is_testable_26, s0_.test_url AS test_url_27, s0_.consent1 AS consent1_28, s0_.consent2 AS consent2_29, s0_.consent3 AS consent3_30, s0_.consent4 AS consent4_31, s0_.author_id AS author_id_32, s0_.session_id AS session_id_33 FROM submission s0_ WHERE EXISTS (SELECT 1 FROM submission_category s1_ WHERE s1_.submission_id = s0_.id AND s1_.category_id IN (4)) AND s0_.validated = 1 AND s0_.session_id = 1;

SELECT
  s0_.id AS id_0,
  s0_.short_description AS short_description_1,
  s0_.long_description AS long_description_2,
  s0_.paid AS paid_3,
  s0_.payment_identifier AS payment_identifier_4,
  s0_.additional_link AS additional_link_5,
  s0_.gameplay_link AS gameplay_link_6,
  s0_.key_visual AS key_visual_7,
  s0_.key_visual_hd AS key_visual_hd_8,
  s0_.trailer_source AS trailer_source_9,
  s0_.trailer_link AS trailer_link_10,
  s0_.presentation_link AS presentation_link_11,
  s0_.validated AS validated_12,
  s0_.name AS name_13,
  s0_.dev_time AS dev_time_14,
  s0_.dev_number AS dev_number_15,
  s0_.created_at AS created_at_16,
  s0_.updated_at AS updated_at_17,
  s0_.nominated1_firstname AS nominated1_firstname_18,
  s0_.nominated1_lastname AS nominated1_lastname_19,
  s0_.nominated2_firstname AS nominated2_firstname_20,
  s0_.nominated2_lastname AS nominated2_lastname_21,
  s0_.nominated3_firstname AS nominated3_firstname_22,
  s0_.nominated3_lastname AS nominated3_lastname_23,
  s0_.support AS support_24,
  s0_.developer AS developer_25,
  s0_.is_testable AS is_testable_26,
  s0_.test_url AS test_url_27,
  s0_.consent1 AS consent1_28,
  s0_.consent2 AS consent2_29,
  s0_.consent3 AS consent3_30,
  s0_.consent4 AS consent4_31,
  s0_.author_id AS author_id_32,
  s0_.session_id AS session_id_33
FROM
  submission s0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      submission_category s1_
    WHERE
      s1_.submission_id = s0_.id
      AND s1_.category_id IN (?)
  )
  AND s0_.validated = 1
  AND s0_.session_id = ?

SELECT s0_.id AS id_0, s0_.short_description AS short_description_1, s0_.long_description AS long_description_2, s0_.paid AS paid_3, s0_.payment_identifier AS payment_identifier_4, s0_.additional_link AS additional_link_5, s0_.gameplay_link AS gameplay_link_6, s0_.key_visual AS key_visual_7, s0_.key_visual_hd AS key_visual_hd_8, s0_.trailer_source AS trailer_source_9, s0_.trailer_link AS trailer_link_10, s0_.presentation_link AS presentation_link_11, s0_.validated AS validated_12, s0_.name AS name_13, s0_.dev_time AS dev_time_14, s0_.dev_number AS dev_number_15, s0_.created_at AS created_at_16, s0_.updated_at AS updated_at_17, s0_.nominated1_firstname AS nominated1_firstname_18, s0_.nominated1_lastname AS nominated1_lastname_19, s0_.nominated2_firstname AS nominated2_firstname_20, s0_.nominated2_lastname AS nominated2_lastname_21, s0_.nominated3_firstname AS nominated3_firstname_22, s0_.nominated3_lastname AS nominated3_lastname_23, s0_.support AS support_24, s0_.developer AS developer_25, s0_.is_testable AS is_testable_26, s0_.test_url AS test_url_27, s0_.consent1 AS consent1_28, s0_.consent2 AS consent2_29, s0_.consent3 AS consent3_30, s0_.consent4 AS consent4_31, s0_.author_id AS author_id_32, s0_.session_id AS session_id_33 FROM submission s0_ WHERE EXISTS (SELECT 1 FROM submission_category s1_ WHERE s1_.submission_id = s0_.id AND s1_.category_id IN (5)) AND s0_.validated = 1 AND s0_.session_id = 1;

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 (205, 207);