Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.orden AS orden_2,
  c0_.visible AS visible_3,
  c0_.home AS home_4,
  c0_.menu AS menu_5,
  c0_.ordenmenu AS ordenmenu_6,
  m1_.file_path AS file_path_7,
  GROUP_CONCAT(
    JSON_OBJECT(
      'locale', l2_.locale, 'nombre', c3_.nombre
    )
  ) AS sclr_8
FROM
  categoria c0_
  LEFT JOIN categoria_translation c3_ ON c0_.id = c3_.objeto_id
  LEFT JOIN locale l2_ ON c3_.locale_id = l2_.id
  LEFT JOIN core_image c4_ ON c0_.imagen_id = c4_.id
  LEFT JOIN media_object m1_ ON c4_.image_id = m1_.id
WHERE
  c0_.visible = 1
GROUP BY
  c0_.id
ORDER BY
  c0_.orden ASC

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.orden AS orden_2, c0_.visible AS visible_3, c0_.home AS home_4, c0_.menu AS menu_5, c0_.ordenmenu AS ordenmenu_6, m1_.file_path AS file_path_7, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'nombre', c3_.nombre)) AS sclr_8 FROM categoria c0_ LEFT JOIN categoria_translation c3_ ON c0_.id = c3_.objeto_id LEFT JOIN locale l2_ ON c3_.locale_id = l2_.id LEFT JOIN core_image c4_ ON c0_.imagen_id = c4_.id LEFT JOIN media_object m1_ ON c4_.image_id = m1_.id WHERE c0_.visible = 1 GROUP BY c0_.id ORDER BY c0_.orden ASC;

SELECT
  t0_.llave AS llave_0,
  t1_.valor AS valor_1
FROM
  texto t0_
  LEFT JOIN texto_translation t1_ ON t0_.id = t1_.objeto_id
  LEFT JOIN locale l2_ ON t1_.locale_id = l2_.id
WHERE
  l2_.locale = ?
ORDER BY
  t0_.id DESC

SELECT t0_.llave AS llave_0, t1_.valor AS valor_1 FROM texto t0_ LEFT JOIN texto_translation t1_ ON t0_.id = t1_.objeto_id LEFT JOIN locale l2_ ON t1_.locale_id = l2_.id WHERE l2_.locale = 'es' ORDER BY t0_.id DESC;

SELECT
  c0_.id AS id_0,
  m1_.file_path AS file_path_1,
  c0_.link AS link_2,
  c0_.orden AS orden_3,
  c0_.principal AS principal_4,
  GROUP_CONCAT(
    JSON_OBJECT(
      'locale', l2_.id, 'localename', l2_.locale,
      'titulo', c3_.titulo, 'descripcion',
      c3_.descripcion, 'button', c3_.button
    )
  ) AS sclr_5
FROM
  core_image c0_
  LEFT JOIN core_image_translation c3_ ON c0_.id = c3_.core_image_id
  LEFT JOIN locale l2_ ON c3_.locale_id = l2_.id
  LEFT JOIN galeria g4_ ON c0_.galeria_id = g4_.id
  LEFT JOIN media_object m1_ ON c0_.image_id = m1_.id
WHERE
  g4_.llave = ?
GROUP BY
  c0_.id
ORDER BY
  c0_.principal DESC,
  c0_.orden ASC

SELECT c0_.id AS id_0, m1_.file_path AS file_path_1, c0_.link AS link_2, c0_.orden AS orden_3, c0_.principal AS principal_4, GROUP_CONCAT(JSON_OBJECT('locale', l2_.id, 'localename', l2_.locale, 'titulo', c3_.titulo, 'descripcion', c3_.descripcion, 'button', c3_.button)) AS sclr_5 FROM core_image c0_ LEFT JOIN core_image_translation c3_ ON c0_.id = c3_.core_image_id LEFT JOIN locale l2_ ON c3_.locale_id = l2_.id LEFT JOIN galeria g4_ ON c0_.galeria_id = g4_.id LEFT JOIN media_object m1_ ON c0_.image_id = m1_.id WHERE g4_.llave = 'banner_home' GROUP BY c0_.id ORDER BY c0_.principal DESC, c0_.orden ASC;

SELECT
  t0.id AS id_1,
  t0.iso AS iso_2,
  t0.conversion_rate_to_usd AS conversion_rate_to_usd_3
FROM
  currency t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.iso AS iso_2, t0.conversion_rate_to_usd AS conversion_rate_to_usd_3 FROM currency t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.visible AS visible_2,
  p0_.destacado AS destacado_3,
  p0_.orden AS orden_4,
  p0_.part_number AS part_number_5,
  p1_.nombre AS nombre_6,
  p1_.resumen AS resumen_7,
  p2_.precio AS precio_8,
  p2_.precio_sin_descuento AS precio_sin_descuento_9,
  p3_.ref AS ref_10,
  p0_.per_stack AS per_stack_11,
  p0_.width AS width_12,
  p0_.length AS length_13,
  p0_.depth AS depth_14,
  p0_.weight AS weight_15,
  GROUP_CONCAT(
    JSON_OBJECT(
      'principal', c4_.principal, 'image',
      m5_.file_path
    )
  ) AS sclr_16
FROM
  producto p0_
  LEFT JOIN producto_translation p1_ ON p0_.id = p1_.objeto_id
  LEFT JOIN producto_precio p2_ ON p0_.id = p2_.producto_id
  LEFT JOIN producto_unidad p3_ ON p0_.unidad_id = p3_.id
  LEFT JOIN producto_core_image p6_ ON p0_.id = p6_.producto_id
  LEFT JOIN core_image c4_ ON c4_.id = p6_.core_image_id
  LEFT JOIN media_object m5_ ON c4_.image_id = m5_.id
WHERE
  p0_.visible = 1
  AND (
    p0_.is_deleted <> 1
    OR p0_.is_deleted IS NULL
  )
  AND p0_.home = 1
GROUP BY
  p0_.id
ORDER BY
  p0_.id ASC
LIMIT
  9

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.visible AS visible_2, p0_.destacado AS destacado_3, p0_.orden AS orden_4, p0_.part_number AS part_number_5, p1_.nombre AS nombre_6, p1_.resumen AS resumen_7, p2_.precio AS precio_8, p2_.precio_sin_descuento AS precio_sin_descuento_9, p3_.ref AS ref_10, p0_.per_stack AS per_stack_11, p0_.width AS width_12, p0_.length AS length_13, p0_.depth AS depth_14, p0_.weight AS weight_15, GROUP_CONCAT(JSON_OBJECT('principal', c4_.principal, 'image', m5_.file_path)) AS sclr_16 FROM producto p0_ LEFT JOIN producto_translation p1_ ON p0_.id = p1_.objeto_id LEFT JOIN producto_precio p2_ ON p0_.id = p2_.producto_id LEFT JOIN producto_unidad p3_ ON p0_.unidad_id = p3_.id LEFT JOIN producto_core_image p6_ ON p0_.id = p6_.producto_id LEFT JOIN core_image c4_ ON c4_.id = p6_.core_image_id LEFT JOIN media_object m5_ ON c4_.image_id = m5_.id WHERE p0_.visible = 1 AND (p0_.is_deleted <> 1 OR p0_.is_deleted IS NULL) AND p0_.home = 1 GROUP BY p0_.id ORDER BY p0_.id ASC LIMIT 9;

SELECT
  count(p0_.id) AS sclr_0
FROM
  producto p0_
  LEFT JOIN producto_translation p1_ ON p0_.id = p1_.objeto_id
  LEFT JOIN producto_precio p2_ ON p0_.id = p2_.producto_id
  LEFT JOIN producto_unidad p3_ ON p0_.unidad_id = p3_.id
  LEFT JOIN producto_core_image p5_ ON p0_.id = p5_.producto_id
  LEFT JOIN core_image c4_ ON c4_.id = p5_.core_image_id
  LEFT JOIN media_object m6_ ON c4_.image_id = m6_.id
WHERE
  p0_.visible = 1
  AND (
    p0_.is_deleted <> 1
    OR p0_.is_deleted IS NULL
  )
  AND p0_.home = 1
ORDER BY
  p0_.id ASC

SELECT count(p0_.id) AS sclr_0 FROM producto p0_ LEFT JOIN producto_translation p1_ ON p0_.id = p1_.objeto_id LEFT JOIN producto_precio p2_ ON p0_.id = p2_.producto_id LEFT JOIN producto_unidad p3_ ON p0_.unidad_id = p3_.id LEFT JOIN producto_core_image p5_ ON p0_.id = p5_.producto_id LEFT JOIN core_image c4_ ON c4_.id = p5_.core_image_id LEFT JOIN media_object m6_ ON c4_.image_id = m6_.id WHERE p0_.visible = 1 AND (p0_.is_deleted <> 1 OR p0_.is_deleted IS NULL) AND p0_.home = 1 ORDER BY p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.iso AS iso_2,
  t0.conversion_rate_to_usd AS conversion_rate_to_usd_3
FROM
  currency t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.iso AS iso_2, t0.conversion_rate_to_usd AS conversion_rate_to_usd_3 FROM currency t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  m0_.file_path AS file_path_0
FROM
  core_image c1_
  LEFT JOIN media_object m0_ ON c1_.image_id = m0_.id
WHERE
  c1_.llave = ?
LIMIT
  1

SELECT m0_.file_path AS file_path_0 FROM core_image c1_ LEFT JOIN media_object m0_ ON c1_.image_id = m0_.id WHERE c1_.llave = 'banner_5_principal' LIMIT 1;

SELECT
  t0_.llave AS llave_0,
  t1_.valor AS valor_1
FROM
  texto_big t0_
  LEFT JOIN texto_big_translation t1_ ON t0_.id = t1_.objeto_id
  LEFT JOIN locale l2_ ON t1_.locale_id = l2_.id
WHERE
  l2_.locale = ?
ORDER BY
  t0_.id DESC

SELECT t0_.llave AS llave_0, t1_.valor AS valor_1 FROM texto_big t0_ LEFT JOIN texto_big_translation t1_ ON t0_.id = t1_.objeto_id LEFT JOIN locale l2_ ON t1_.locale_id = l2_.id WHERE l2_.locale = 'es' ORDER BY t0_.id DESC;

SELECT
  m0_.file_path AS file_path_0
FROM
  core_image c1_
  LEFT JOIN media_object m0_ ON c1_.image_id = m0_.id
WHERE
  c1_.llave = ?
LIMIT
  1

SELECT m0_.file_path AS file_path_0 FROM core_image c1_ LEFT JOIN media_object m0_ ON c1_.image_id = m0_.id WHERE c1_.llave = 'banner_4_imagen_1' LIMIT 1;

SELECT
  m0_.file_path AS file_path_0
FROM
  core_image c1_
  LEFT JOIN media_object m0_ ON c1_.image_id = m0_.id
WHERE
  c1_.llave = ?
LIMIT
  1

SELECT m0_.file_path AS file_path_0 FROM core_image c1_ LEFT JOIN media_object m0_ ON c1_.image_id = m0_.id WHERE c1_.llave = 'banner_4_imagen_2' LIMIT 1;

SELECT
  c0_.id AS id_0,
  m1_.file_path AS file_path_1,
  c0_.link AS link_2,
  c0_.orden AS orden_3,
  c0_.principal AS principal_4,
  GROUP_CONCAT(
    JSON_OBJECT(
      'locale', l2_.id, 'localename', l2_.locale,
      'titulo', c3_.titulo, 'descripcion',
      c3_.descripcion, 'button', c3_.button
    )
  ) AS sclr_5
FROM
  core_image c0_
  LEFT JOIN core_image_translation c3_ ON c0_.id = c3_.core_image_id
  LEFT JOIN locale l2_ ON c3_.locale_id = l2_.id
  LEFT JOIN galeria g4_ ON c0_.galeria_id = g4_.id
  LEFT JOIN media_object m1_ ON c0_.image_id = m1_.id
WHERE
  g4_.llave = ?
GROUP BY
  c0_.id
ORDER BY
  c0_.principal DESC,
  c0_.orden ASC

SELECT c0_.id AS id_0, m1_.file_path AS file_path_1, c0_.link AS link_2, c0_.orden AS orden_3, c0_.principal AS principal_4, GROUP_CONCAT(JSON_OBJECT('locale', l2_.id, 'localename', l2_.locale, 'titulo', c3_.titulo, 'descripcion', c3_.descripcion, 'button', c3_.button)) AS sclr_5 FROM core_image c0_ LEFT JOIN core_image_translation c3_ ON c0_.id = c3_.core_image_id LEFT JOIN locale l2_ ON c3_.locale_id = l2_.id LEFT JOIN galeria g4_ ON c0_.galeria_id = g4_.id LEFT JOIN media_object m1_ ON c0_.image_id = m1_.id WHERE g4_.llave = 'sec-logosAliados' GROUP BY c0_.id ORDER BY c0_.principal DESC, c0_.orden ASC;

SELECT
  c0_.id AS id_0,
  m1_.file_path AS file_path_1,
  c0_.link AS link_2,
  c0_.orden AS orden_3,
  c0_.principal AS principal_4,
  GROUP_CONCAT(
    JSON_OBJECT(
      'locale', l2_.id, 'localename', l2_.locale,
      'titulo', c3_.titulo, 'descripcion',
      c3_.descripcion, 'button', c3_.button
    )
  ) AS sclr_5
FROM
  core_image c0_
  LEFT JOIN core_image_translation c3_ ON c0_.id = c3_.core_image_id
  LEFT JOIN locale l2_ ON c3_.locale_id = l2_.id
  LEFT JOIN galeria g4_ ON c0_.galeria_id = g4_.id
  LEFT JOIN media_object m1_ ON c0_.image_id = m1_.id
WHERE
  g4_.llave = ?
GROUP BY
  c0_.id
ORDER BY
  c0_.principal DESC,
  c0_.orden ASC

SELECT c0_.id AS id_0, m1_.file_path AS file_path_1, c0_.link AS link_2, c0_.orden AS orden_3, c0_.principal AS principal_4, GROUP_CONCAT(JSON_OBJECT('locale', l2_.id, 'localename', l2_.locale, 'titulo', c3_.titulo, 'descripcion', c3_.descripcion, 'button', c3_.button)) AS sclr_5 FROM core_image c0_ LEFT JOIN core_image_translation c3_ ON c0_.id = c3_.core_image_id LEFT JOIN locale l2_ ON c3_.locale_id = l2_.id LEFT JOIN galeria g4_ ON c0_.galeria_id = g4_.id LEFT JOIN media_object m1_ ON c0_.image_id = m1_.id WHERE g4_.llave = 'sec-logosAliados' GROUP BY c0_.id ORDER BY c0_.principal DESC, c0_.orden ASC;

SELECT
  f0_.id AS id_0,
  f0_.orden AS orden_1,
  f0_.visible AS visible_2,
  f0_.section AS section_3,
  f0_.program AS program_4,
  f0_.created_at AS created_at_5,
  f0_.updated_at AS updated_at_6,
  f0_.question_id AS question_id_7,
  f0_.answer_id AS answer_id_8
FROM
  faq f0_
WHERE
  f0_.visible = ?
ORDER BY
  f0_.section ASC,
  f0_.orden ASC

SELECT f0_.id AS id_0, f0_.orden AS orden_1, f0_.visible AS visible_2, f0_.section AS section_3, f0_.program AS program_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6, f0_.question_id AS question_id_7, f0_.answer_id AS answer_id_8 FROM faq f0_ WHERE f0_.visible = 1 ORDER BY f0_.section ASC, f0_.orden ASC;