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
  p0_.id AS id_0,
  p0_.destacado AS destacado_1,
  p0_.orden AS orden_2,
  p0_.visible AS visible_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.pum AS pum_6,
  p0_.iva AS iva_7,
  p0_.home AS home_8,
  p0_.is_deleted AS is_deleted_9,
  p0_.width AS width_10,
  p0_.length AS length_11,
  p0_.depth AS depth_12,
  p0_.weight AS weight_13,
  p0_.slug AS slug_14,
  p0_.part_number AS part_number_15,
  p0_.plataforma AS plataforma_16,
  p0_.source AS source_17,
  p0_.per_stack AS per_stack_18,
  p1_.id AS id_19,
  p1_.nombre AS nombre_20,
  p1_.resumen AS resumen_21,
  p1_.presentacion AS presentacion_22,
  p1_.origen AS origen_23,
  p1_.registro_invima AS registro_invima_24,
  p1_.nombre_comercial AS nombre_comercial_25,
  p1_.detalles AS detalles_26,
  p1_.tabla AS tabla_27,
  p1_.fabricacion AS fabricacion_28,
  p1_.inspiracion AS inspiracion_29,
  l2_.id AS id_30,
  l2_.locale AS locale_31,
  l2_.name AS name_32,
  p3_.id AS id_33,
  p3_.precio AS precio_34,
  p3_.precio_sin_descuento AS precio_sin_descuento_35,
  p3_.notas AS notas_36,
  p3_.created_at AS created_at_37,
  p3_.updated_at AS updated_at_38,
  p3_.activo AS activo_39,
  c4_.id AS id_40,
  c4_.iso AS iso_41,
  c4_.conversion_rate_to_usd AS conversion_rate_to_usd_42,
  c5_.id AS id_43,
  c5_.owner_type AS owner_type_44,
  c5_.owner_id AS owner_id_45,
  c5_.orden AS orden_46,
  c5_.visible AS visible_47,
  c5_.principal AS principal_48,
  c5_.llave AS llave_49,
  c5_.link AS link_50,
  c5_.seccion AS seccion_51,
  c5_.created_at AS created_at_52,
  c5_.updated_at AS updated_at_53,
  p0_.color_id AS color_id_54,
  p0_.talla_id AS talla_id_55,
  p0_.padre_id AS padre_id_56,
  p0_.impuesto_id AS impuesto_id_57,
  p0_.unidad_id AS unidad_id_58,
  p1_.locale_id AS locale_id_59,
  p1_.objeto_id AS objeto_id_60,
  p3_.producto_id AS producto_id_61,
  p3_.condicion_id AS condicion_id_62,
  p3_.currency_id AS currency_id_63,
  c5_.image_id AS image_id_64,
  c5_.galeria_id AS galeria_id_65
FROM
  producto p0_
  LEFT JOIN producto_translation p1_ ON p0_.id = p1_.objeto_id
  LEFT JOIN locale l2_ ON p1_.locale_id = l2_.id
  LEFT JOIN producto_precio p3_ ON p0_.id = p3_.producto_id
  LEFT JOIN currency c4_ ON p3_.currency_id = c4_.id
  LEFT JOIN producto_core_image p6_ ON p0_.id = p6_.producto_id
  LEFT JOIN core_image c5_ ON c5_.id = p6_.core_image_id
WHERE
  p0_.id = ?
  OR p0_.slug = ?

SELECT p0_.id AS id_0, p0_.destacado AS destacado_1, p0_.orden AS orden_2, p0_.visible AS visible_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.pum AS pum_6, p0_.iva AS iva_7, p0_.home AS home_8, p0_.is_deleted AS is_deleted_9, p0_.width AS width_10, p0_.length AS length_11, p0_.depth AS depth_12, p0_.weight AS weight_13, p0_.slug AS slug_14, p0_.part_number AS part_number_15, p0_.plataforma AS plataforma_16, p0_.source AS source_17, p0_.per_stack AS per_stack_18, p1_.id AS id_19, p1_.nombre AS nombre_20, p1_.resumen AS resumen_21, p1_.presentacion AS presentacion_22, p1_.origen AS origen_23, p1_.registro_invima AS registro_invima_24, p1_.nombre_comercial AS nombre_comercial_25, p1_.detalles AS detalles_26, p1_.tabla AS tabla_27, p1_.fabricacion AS fabricacion_28, p1_.inspiracion AS inspiracion_29, l2_.id AS id_30, l2_.locale AS locale_31, l2_.name AS name_32, p3_.id AS id_33, p3_.precio AS precio_34, p3_.precio_sin_descuento AS precio_sin_descuento_35, p3_.notas AS notas_36, p3_.created_at AS created_at_37, p3_.updated_at AS updated_at_38, p3_.activo AS activo_39, c4_.id AS id_40, c4_.iso AS iso_41, c4_.conversion_rate_to_usd AS conversion_rate_to_usd_42, c5_.id AS id_43, c5_.owner_type AS owner_type_44, c5_.owner_id AS owner_id_45, c5_.orden AS orden_46, c5_.visible AS visible_47, c5_.principal AS principal_48, c5_.llave AS llave_49, c5_.link AS link_50, c5_.seccion AS seccion_51, c5_.created_at AS created_at_52, c5_.updated_at AS updated_at_53, p0_.color_id AS color_id_54, p0_.talla_id AS talla_id_55, p0_.padre_id AS padre_id_56, p0_.impuesto_id AS impuesto_id_57, p0_.unidad_id AS unidad_id_58, p1_.locale_id AS locale_id_59, p1_.objeto_id AS objeto_id_60, p3_.producto_id AS producto_id_61, p3_.condicion_id AS condicion_id_62, p3_.currency_id AS currency_id_63, c5_.image_id AS image_id_64, c5_.galeria_id AS galeria_id_65 FROM producto p0_ LEFT JOIN producto_translation p1_ ON p0_.id = p1_.objeto_id LEFT JOIN locale l2_ ON p1_.locale_id = l2_.id LEFT JOIN producto_precio p3_ ON p0_.id = p3_.producto_id LEFT JOIN currency c4_ ON p3_.currency_id = c4_.id LEFT JOIN producto_core_image p6_ ON p0_.id = p6_.producto_id LEFT JOIN core_image c5_ ON c5_.id = p6_.core_image_id WHERE p0_.id = 'RG38060L' OR p0_.slug = 'RG38060L';

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2,
  t0.updated_at AS updated_at_3,
  t4.id AS id_5,
  t4.owner_type AS owner_type_6,
  t4.owner_id AS owner_id_7,
  t4.orden AS orden_8,
  t4.visible AS visible_9,
  t4.principal AS principal_10,
  t4.llave AS llave_11,
  t4.link AS link_12,
  t4.seccion AS seccion_13,
  t4.created_at AS created_at_14,
  t4.updated_at AS updated_at_15,
  t4.image_id AS image_id_16,
  t4.galeria_id AS galeria_id_17,
  t0.core_archivo_id AS core_archivo_id_18
FROM
  media_object t0
  LEFT JOIN core_image t4 ON t4.image_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.updated_at AS updated_at_3, t4.id AS id_5, t4.owner_type AS owner_type_6, t4.owner_id AS owner_id_7, t4.orden AS orden_8, t4.visible AS visible_9, t4.principal AS principal_10, t4.llave AS llave_11, t4.link AS link_12, t4.seccion AS seccion_13, t4.created_at AS created_at_14, t4.updated_at AS updated_at_15, t4.image_id AS image_id_16, t4.galeria_id AS galeria_id_17, t0.core_archivo_id AS core_archivo_id_18 FROM media_object t0 LEFT JOIN core_image t4 ON t4.image_id = t0.id WHERE t0.id = 198628;

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2,
  t0.updated_at AS updated_at_3,
  t4.id AS id_5,
  t4.owner_type AS owner_type_6,
  t4.owner_id AS owner_id_7,
  t4.orden AS orden_8,
  t4.visible AS visible_9,
  t4.principal AS principal_10,
  t4.llave AS llave_11,
  t4.link AS link_12,
  t4.seccion AS seccion_13,
  t4.created_at AS created_at_14,
  t4.updated_at AS updated_at_15,
  t4.image_id AS image_id_16,
  t4.galeria_id AS galeria_id_17,
  t0.core_archivo_id AS core_archivo_id_18
FROM
  media_object t0
  LEFT JOIN core_image t4 ON t4.image_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.updated_at AS updated_at_3, t4.id AS id_5, t4.owner_type AS owner_type_6, t4.owner_id AS owner_id_7, t4.orden AS orden_8, t4.visible AS visible_9, t4.principal AS principal_10, t4.llave AS llave_11, t4.link AS link_12, t4.seccion AS seccion_13, t4.created_at AS created_at_14, t4.updated_at AS updated_at_15, t4.image_id AS image_id_16, t4.galeria_id AS galeria_id_17, t0.core_archivo_id AS core_archivo_id_18 FROM media_object t0 LEFT JOIN core_image t4 ON t4.image_id = t0.id WHERE t0.id = 198629;

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2,
  t0.updated_at AS updated_at_3,
  t4.id AS id_5,
  t4.owner_type AS owner_type_6,
  t4.owner_id AS owner_id_7,
  t4.orden AS orden_8,
  t4.visible AS visible_9,
  t4.principal AS principal_10,
  t4.llave AS llave_11,
  t4.link AS link_12,
  t4.seccion AS seccion_13,
  t4.created_at AS created_at_14,
  t4.updated_at AS updated_at_15,
  t4.image_id AS image_id_16,
  t4.galeria_id AS galeria_id_17,
  t0.core_archivo_id AS core_archivo_id_18
FROM
  media_object t0
  LEFT JOIN core_image t4 ON t4.image_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.updated_at AS updated_at_3, t4.id AS id_5, t4.owner_type AS owner_type_6, t4.owner_id AS owner_id_7, t4.orden AS orden_8, t4.visible AS visible_9, t4.principal AS principal_10, t4.llave AS llave_11, t4.link AS link_12, t4.seccion AS seccion_13, t4.created_at AS created_at_14, t4.updated_at AS updated_at_15, t4.image_id AS image_id_16, t4.galeria_id AS galeria_id_17, t0.core_archivo_id AS core_archivo_id_18 FROM media_object t0 LEFT JOIN core_image t4 ON t4.image_id = t0.id WHERE t0.id = 198630;

SELECT
  t0.id AS id_1,
  t0.codigo AS codigo_2,
  t0.orden AS orden_3,
  t0.visible AS visible_4,
  t0.imagen AS imagen_5,
  t0.padre_id AS padre_id_6,
  t0.tipo_id AS tipo_id_7
FROM
  `Option` t0
  INNER JOIN producto_option ON t0.id = producto_option.option_id
WHERE
  producto_option.producto_id = ?

SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.orden AS orden_3, t0.visible AS visible_4, t0.imagen AS imagen_5, t0.padre_id AS padre_id_6, t0.tipo_id AS tipo_id_7 FROM `Option` t0 INNER JOIN producto_option ON t0.id = producto_option.option_id WHERE producto_option.producto_id = 'RG38060L';

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_.destacado = 1
GROUP BY
  p0_.id
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_.destacado = 1 GROUP BY p0_.id 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_.destacado = 1

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_.destacado = 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 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.nombre AS nombre_2
FROM
  lista_precio t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM lista_precio t0 ORDER BY t0.id ASC LIMIT 1;