Query Metrics

2 Database Queries
2 Different statements
2.33 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.44 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.resumen AS resumen_3, t0.thumbnail AS thumbnail_4, t0.imagen AS imagen_5, t0.costo AS costo_6, t0.precio AS precio_7, t0.destacado AS destacado_8, t0.orden AS orden_9, t0.visible AS visible_10, t0.updated_at AS updated_at_11, t0.pum AS pum_12, t0.iva AS iva_13, t0.registro_invima AS registro_invima_14, t0.precio_sin_descuento AS precio_sin_descuento_15, t0.es_promo AS es_promo_16, t0.destacado_categoria AS destacado_categoria_17, t0.nombre_comercial AS nombre_comercial_18, t0.referencia AS referencia_19, t0.descuento AS descuento_20, t0.ean AS ean_21, t0.medida AS medida_22, t0.precio_sin_inva AS precio_sin_inva_23, t0.descripcion AS descripcion_24, t0.tela AS tela_25, t0.peso AS peso_26, t0.productos_incluidos AS productos_incluidos_27, t0.alternativa AS alternativa_28, t0.productos_no_incluidos AS productos_no_incluidos_29, t0.recomendaciones AS recomendaciones_30, t0.garantia AS garantia_31, t0.peso_a_soportar AS peso_a_soportar_32, t0.color_texto AS color_texto_33, t0.tecnologia AS tecnologia_34, t0.tipologia AS tipologia_35, t0.adaptabilidad AS adaptabilidad_36, t0.independencia AS independencia_37, t0.gamma AS gamma_38, t0.maestro AS maestro_39, t0.materiales AS materiales_40, t0.ficha_tecnica AS ficha_tecnica_41, t0.imagen_beneficios AS imagen_beneficios_42, t0.calidad AS calidad_43, t0.responsabilidad AS responsabilidad_44, t0.detalles AS detalles_45, t0.imagen_puntos AS imagen_puntos_46, t0.imagen_firmeza AS imagen_firmeza_47, t0.imagen_puntos_extendida AS imagen_puntos_extendida_48, t0.gif_puntos AS gif_puntos_49, t0.video AS video_50, t0.nuevo AS nuevo_51, t0.etiqueta AS etiqueta_52, t0.alt AS alt_53, t0.principal AS principal_54, t0.slug AS slug_55, t0.descripcion_seo AS descripcion_seo_56, t0.tamanio AS tamanio_57, t0.imgcalidad AS imgcalidad_58, t0.imgresponsabilidad AS imgresponsabilidad_59, t0.imgtecnologia AS imgtecnologia_60, t0.incarrito AS incarrito_61, t0.dctoic AS dctoic_62, t0.titulo_seo AS titulo_seo_63, t0.etiquetaprodtext AS etiquetaprodtext_64, t0.etiquetaprodimg AS etiquetaprodimg_65, t0.padre_id AS padre_id_66, t0.material_id AS material_id_67, t0.subcategoria_id AS subcategoria_id_68, t0.medidas_id AS medidas_id_69, t0.rotulo_id AS rotulo_id_70 FROM producto t0 WHERE t0.id = ? AND t0.slug = ? AND t0.principal = ? LIMIT 1
Parameters:
[
  "Colchones"
  "colchon-adaptable-cool-zense-gratis-almohada-cloud-sleep"
  1
]
2 0.89 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.resumen AS resumen_3, t0.thumbnail AS thumbnail_4, t0.imagen AS imagen_5, t0.costo AS costo_6, t0.precio AS precio_7, t0.destacado AS destacado_8, t0.orden AS orden_9, t0.visible AS visible_10, t0.updated_at AS updated_at_11, t0.pum AS pum_12, t0.iva AS iva_13, t0.registro_invima AS registro_invima_14, t0.precio_sin_descuento AS precio_sin_descuento_15, t0.es_promo AS es_promo_16, t0.destacado_categoria AS destacado_categoria_17, t0.nombre_comercial AS nombre_comercial_18, t0.referencia AS referencia_19, t0.descuento AS descuento_20, t0.ean AS ean_21, t0.medida AS medida_22, t0.precio_sin_inva AS precio_sin_inva_23, t0.descripcion AS descripcion_24, t0.tela AS tela_25, t0.peso AS peso_26, t0.productos_incluidos AS productos_incluidos_27, t0.alternativa AS alternativa_28, t0.productos_no_incluidos AS productos_no_incluidos_29, t0.recomendaciones AS recomendaciones_30, t0.garantia AS garantia_31, t0.peso_a_soportar AS peso_a_soportar_32, t0.color_texto AS color_texto_33, t0.tecnologia AS tecnologia_34, t0.tipologia AS tipologia_35, t0.adaptabilidad AS adaptabilidad_36, t0.independencia AS independencia_37, t0.gamma AS gamma_38, t0.maestro AS maestro_39, t0.materiales AS materiales_40, t0.ficha_tecnica AS ficha_tecnica_41, t0.imagen_beneficios AS imagen_beneficios_42, t0.calidad AS calidad_43, t0.responsabilidad AS responsabilidad_44, t0.detalles AS detalles_45, t0.imagen_puntos AS imagen_puntos_46, t0.imagen_firmeza AS imagen_firmeza_47, t0.imagen_puntos_extendida AS imagen_puntos_extendida_48, t0.gif_puntos AS gif_puntos_49, t0.video AS video_50, t0.nuevo AS nuevo_51, t0.etiqueta AS etiqueta_52, t0.alt AS alt_53, t0.principal AS principal_54, t0.slug AS slug_55, t0.descripcion_seo AS descripcion_seo_56, t0.tamanio AS tamanio_57, t0.imgcalidad AS imgcalidad_58, t0.imgresponsabilidad AS imgresponsabilidad_59, t0.imgtecnologia AS imgtecnologia_60, t0.incarrito AS incarrito_61, t0.dctoic AS dctoic_62, t0.titulo_seo AS titulo_seo_63, t0.etiquetaprodtext AS etiquetaprodtext_64, t0.etiquetaprodimg AS etiquetaprodimg_65, t0.padre_id AS padre_id_66, t0.material_id AS material_id_67, t0.subcategoria_id AS subcategoria_id_68, t0.medidas_id AS medidas_id_69, t0.rotulo_id AS rotulo_id_70 FROM producto t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "Colchones"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Producto
  • The field App\Entity\Producto#hijos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Producto#padre does not contain the required 'inversedBy="hijos"' attribute.
App\Entity\Material No errors.
App\Entity\Subcategoria No errors.
App\Entity\Medidas No errors.
App\Entity\Etiqueta No errors.
App\Entity\Categoria No errors.
App\Entity\Inventario No errors.
App\Entity\ListaPrecioItem No errors.
App\Entity\Image No errors.
App\Entity\CodigoDescuento No errors.
App\Entity\Beneficio No errors.
App\Entity\Punto No errors.
App\Entity\Itemcombinaciones No errors.
App\Entity\Descuento No errors.
App\Entity\Favorito
  • The field App\Entity\Favorito#usuario is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Usuario# does not contain the required 'inversedBy' attribute.
  • If association App\Entity\Favorito#usuario is many-to-one, then the inversed side App\Entity\Usuario#favoritos has to be one-to-many.
App\Entity\Clasificacion No errors.
App\Entity\Video No errors.
App\Entity\Combinaciones
  • The mappings App\Entity\Combinaciones#itemcombinaciones and App\Entity\Itemcombinaciones#combinacion are inconsistent with each other.