Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.domaine_name AS domaine_name_2,
  c0_.email_project AS email_project_3,
  c0_.mdp_email_project AS mdp_email_project_4,
  c0_.marge_my_flow AS marge_my_flow_5,
  c0_.logo_name AS logo_name_6,
  c0_.favicon_name AS favicon_name_7,
  c0_.enabled AS enabled_8,
  c0_.type_company AS type_company_9,
  c0_.cb_payment AS cb_payment_10,
  c0_.contract AS contract_11,
  c0_.customer_discount AS customer_discount_12,
  c0_.default_credit_cost AS default_credit_cost_13,
  c0_.cost_of_discounted_credit AS cost_of_discounted_credit_14,
  c0_.created_at AS created_at_15,
  c0_.updated_at AS updated_at_16,
  c0_.siren AS siren_17,
  c0_.front_id AS front_id_18,
  c0_.current_credit AS current_credit_19,
  c0_.current_balance AS current_balance_20,
  c0_.deleted AS deleted_21,
  c0_.link_my_flow_confidentiality_commitment AS link_my_flow_confidentiality_commitment_22,
  c0_.extension_domain AS extension_domain_23,
  c0_.parent_id AS parent_id_24,
  c0_.company_data_id AS company_data_id_25,
  c0_.representative_id AS representative_id_26
FROM
  companies c0_
WHERE
  c0_.domaine_name LIKE ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.domaine_name AS domaine_name_2, c0_.email_project AS email_project_3, c0_.mdp_email_project AS mdp_email_project_4, c0_.marge_my_flow AS marge_my_flow_5, c0_.logo_name AS logo_name_6, c0_.favicon_name AS favicon_name_7, c0_.enabled AS enabled_8, c0_.type_company AS type_company_9, c0_.cb_payment AS cb_payment_10, c0_.contract AS contract_11, c0_.customer_discount AS customer_discount_12, c0_.default_credit_cost AS default_credit_cost_13, c0_.cost_of_discounted_credit AS cost_of_discounted_credit_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.siren AS siren_17, c0_.front_id AS front_id_18, c0_.current_credit AS current_credit_19, c0_.current_balance AS current_balance_20, c0_.deleted AS deleted_21, c0_.link_my_flow_confidentiality_commitment AS link_my_flow_confidentiality_commitment_22, c0_.extension_domain AS extension_domain_23, c0_.parent_id AS parent_id_24, c0_.company_data_id AS company_data_id_25, c0_.representative_id AS representative_id_26 FROM companies c0_ WHERE c0_.domaine_name LIKE '%app.dev.my-flow.fr%';

SELECT
  p0_.id AS id_0,
  p0_.file_category AS file_category_1,
  p0_.thumbnail AS thumbnail_2,
  p0_.file_url AS file_url_3
FROM
  portfolio p0_
  LEFT JOIN users u1_ ON p0_.user_id = u1_.id
WHERE
  (
    (
      u1_.accept_presentation = ?
      AND p0_.file_category = 'image'
    )
    OR p0_.file_category = 'video'
    OR p0_.file_category = 'webm'
    OR p0_.file_category = 'embed-link'
  )
  AND p0_.id IN (?)
ORDER BY
  CASE WHEN p0_.file_category = ? THEN 1 WHEN p0_.file_category = ? THEN 2 WHEN p0_.file_category = ? THEN 3 WHEN p0_.file_category = ? THEN 4 WHEN p0_.file_category = ? THEN 5 WHEN p0_.file_category = ? THEN 6 WHEN p0_.file_category = ? THEN 7 WHEN p0_.file_category = ? THEN 8 WHEN p0_.file_category = ? THEN 9 ELSE 8 END ASC
LIMIT
  16

SELECT p0_.id AS id_0, p0_.file_category AS file_category_1, p0_.thumbnail AS thumbnail_2, p0_.file_url AS file_url_3 FROM portfolio p0_ LEFT JOIN users u1_ ON p0_.user_id = u1_.id WHERE ((u1_.accept_presentation = 1 AND p0_.file_category = 'image') OR p0_.file_category = 'video' OR p0_.file_category = 'webm' OR p0_.file_category = 'embed-link') AND p0_.id IN (5, 28, 41, 4, 11, 21, 7, 1, 9, 17, 12, 2) ORDER BY CASE WHEN p0_.file_category = 'video' THEN 1 WHEN p0_.file_category = 'webm' THEN 2 WHEN p0_.file_category = 'embed-link' THEN 3 WHEN p0_.file_category = 'image' THEN 4 WHEN p0_.file_category = 'url' THEN 5 WHEN p0_.file_category = 'audio' THEN 6 WHEN p0_.file_category = 'pdf' THEN 7 WHEN p0_.file_category = 'pptx' THEN 8 WHEN p0_.file_category = 'docx' THEN 9 ELSE 8 END ASC LIMIT 16;

SELECT
  p0_.id AS id_0
FROM
  portfolio p0_
  LEFT JOIN users u1_ ON p0_.user_id = u1_.id
WHERE
  u1_.accept_presentation = ?
  AND p0_.file_category = 'image'

SELECT p0_.id AS id_0 FROM portfolio p0_ LEFT JOIN users u1_ ON p0_.user_id = u1_.id WHERE u1_.accept_presentation = 1 AND p0_.file_category = 'image';