Symfony Profiler

SELECT 
  u0_.username AS username_0, 
  u0_.id AS id_1, 
  u0_.nome AS nome_2, 
  u0_.extra_fields AS extra_fields_3, 
  u0_.logo AS logo_4, 
  u0_.capa AS capa_5, 
  u0_.data_inicio AS data_inicio_6, 
  u0_.nota_avaliacao AS nota_avaliacao_7, 
  c1_.id AS id_8, 
  c1_.nome AS nome_9, 
  c1_.extra_fields AS extra_fields_10, 
  a2_.id AS id_11, 
  a2_.comentario AS comentario_12, 
  a2_.nota AS nota_13, 
  a2_.created_at AS created_at_14, 
  a2_.avaliado_em AS avaliado_em_15, 
  a2_.enabled AS enabled_16 
FROM 
  users u0_ 
  LEFT JOIN categorias c1_ ON u0_.categoria_id = c1_.id 
  LEFT JOIN avaliacao a2_ ON u0_.id = a2_.conveniado_id 
WHERE 
  u0_.enabled = 1 
  AND u0_.roles LIKE '%ROLE_CONVENIADO%' 
  AND (
    u0_.data_fim IS NULL 
    OR u0_.data_fim <= ?
  ) 
ORDER BY 
  u0_.nota_avaliacao DESC

SELECT u0_.username AS username_0, u0_.id AS id_1, u0_.nome AS nome_2, u0_.extra_fields AS extra_fields_3, u0_.logo AS logo_4, u0_.capa AS capa_5, u0_.data_inicio AS data_inicio_6, u0_.nota_avaliacao AS nota_avaliacao_7, c1_.id AS id_8, c1_.nome AS nome_9, c1_.extra_fields AS extra_fields_10, a2_.id AS id_11, a2_.comentario AS comentario_12, a2_.nota AS nota_13, a2_.created_at AS created_at_14, a2_.avaliado_em AS avaliado_em_15, a2_.enabled AS enabled_16 FROM users u0_ LEFT JOIN categorias c1_ ON u0_.categoria_id = c1_.id LEFT JOIN avaliacao a2_ ON u0_.id = a2_.conveniado_id WHERE u0_.enabled = 1 AND u0_.roles LIKE '%ROLE_CONVENIADO%' AND (u0_.data_fim IS NULL OR u0_.data_fim <= '2026-03-16 15:48:07') ORDER BY u0_.nota_avaliacao DESC;

SELECT 
  p0_.id AS id_0, 
  p0_.enabled AS enabled_1, 
  p0_.nome AS nome_2, 
  p0_.descricao AS descricao_3, 
  p0_.extra_fields AS extra_fields_4, 
  p0_.image AS image_5, 
  p0_.valor AS valor_6, 
  p0_.valor_com_desconto AS valor_com_desconto_7, 
  p0_.updated_at AS updated_at_8, 
  u1_.username AS username_9, 
  u1_.id AS id_10, 
  u1_.nome AS nome_11, 
  a2_.id AS id_12, 
  a2_.comentario AS comentario_13, 
  a2_.nota AS nota_14, 
  a2_.created_at AS created_at_15, 
  a2_.avaliado_em AS avaliado_em_16, 
  a2_.enabled AS enabled_17, 
  a3_.id AS id_18, 
  a3_.enabled AS enabled_19, 
  a3_.nome AS nome_20, 
  a3_.cpf AS cpf_21, 
  a3_.telefone AS telefone_22, 
  a3_.matricula AS matricula_23, 
  a3_.updated_at AS updated_at_24, 
  a3_.created_at AS created_at_25 
FROM 
  promocao p0_ 
  LEFT JOIN users u1_ ON p0_.conveniado_id = u1_.id 
  LEFT JOIN avaliacao a2_ ON p0_.id = a2_.promocao_id 
  LEFT JOIN associados a3_ ON a2_.associado_id = a3_.id 
WHERE 
  p0_.enabled = 1

SELECT p0_.id AS id_0, p0_.enabled AS enabled_1, p0_.nome AS nome_2, p0_.descricao AS descricao_3, p0_.extra_fields AS extra_fields_4, p0_.image AS image_5, p0_.valor AS valor_6, p0_.valor_com_desconto AS valor_com_desconto_7, p0_.updated_at AS updated_at_8, u1_.username AS username_9, u1_.id AS id_10, u1_.nome AS nome_11, a2_.id AS id_12, a2_.comentario AS comentario_13, a2_.nota AS nota_14, a2_.created_at AS created_at_15, a2_.avaliado_em AS avaliado_em_16, a2_.enabled AS enabled_17, a3_.id AS id_18, a3_.enabled AS enabled_19, a3_.nome AS nome_20, a3_.cpf AS cpf_21, a3_.telefone AS telefone_22, a3_.matricula AS matricula_23, a3_.updated_at AS updated_at_24, a3_.created_at AS created_at_25 FROM promocao p0_ LEFT JOIN users u1_ ON p0_.conveniado_id = u1_.id LEFT JOIN avaliacao a2_ ON p0_.id = a2_.promocao_id LEFT JOIN associados a3_ ON a2_.associado_id = a3_.id WHERE p0_.enabled = 1;

SELECT 
  b0_.id AS id_0, 
  b0_.enabled AS enabled_1, 
  b0_.nome AS nome_2, 
  b0_.descricao AS descricao_3, 
  b0_.extra_fields AS extra_fields_4, 
  b0_.image AS image_5, 
  b0_.updated_at AS updated_at_6 
FROM 
  banner b0_ 
WHERE 
  b0_.enabled = 1

SELECT b0_.id AS id_0, b0_.enabled AS enabled_1, b0_.nome AS nome_2, b0_.descricao AS descricao_3, b0_.extra_fields AS extra_fields_4, b0_.image AS image_5, b0_.updated_at AS updated_at_6 FROM banner b0_ WHERE b0_.enabled = 1;

SELECT 
  c0_.id AS id_0, 
  c0_.nome AS nome_1, 
  c0_.extra_fields AS extra_fields_2 
FROM 
  categorias c0_ 
ORDER BY 
  c0_.nome ASC

SELECT c0_.id AS id_0, c0_.nome AS nome_1, c0_.extra_fields AS extra_fields_2 FROM categorias c0_ ORDER BY c0_.nome ASC;

SELECT 
  t0_.id AS id_0, 
  t0_.ordem AS ordem_1, 
  t0_.enabled AS enabled_2, 
  t0_.nome AS nome_3, 
  t0_.descricao AS descricao_4, 
  t0_.extra_fields AS extra_fields_5, 
  t0_.updated_at AS updated_at_6, 
  t0_.imagem AS imagem_7 
FROM 
  textos t0_ 
ORDER BY 
  t0_.ordem ASC

SELECT t0_.id AS id_0, t0_.ordem AS ordem_1, t0_.enabled AS enabled_2, t0_.nome AS nome_3, t0_.descricao AS descricao_4, t0_.extra_fields AS extra_fields_5, t0_.updated_at AS updated_at_6, t0_.imagem AS imagem_7 FROM textos t0_ ORDER BY t0_.ordem ASC;