GET https://cluster.pytlab.com/catalogo/empresa/30

Query Metrics

22 Database Queries
19 Different statements
57.69 ms Query time
0 Invalid entities
23 Managed entities

Queries

Group similar statements

# Time Info
1 1.21 ms
SELECT t0.id AS id_1, t0.nombre_fiscal AS nombre_fiscal_2, t0.nombre_comercial AS nombre_comercial_3, t0.nif AS nif_4, t0.actividad_empresarial AS actividad_empresarial_5, t0.nombre_representante_legal AS nombre_representante_legal_6, t0.cargo_representante_legal AS cargo_representante_legal_7, t0.telefono_representante_legal AS telefono_representante_legal_8, t0.fecha_creacion AS fecha_creacion_9, t0.fecha_incorporacion_cluster AS fecha_incorporacion_cluster_10, t0.email AS email_11, t0.email_comercial AS email_comercial_12, t0.pagina_web AS pagina_web_13, t0.video_promocional AS video_promocional_14, t0.logo AS logo_15, t0.personal_laboral AS personal_laboral_16, t0.personal_laboral_mujeres AS personal_laboral_mujeres_17, t0.personal_laboral_hombres AS personal_laboral_hombres_18, t0.volumen_facturacion_anual AS volumen_facturacion_anual_19, t0.sello_pyme_innovadora AS sello_pyme_innovadora_20, t0.caducidad_sello_pyme_innovadora AS caducidad_sello_pyme_innovadora_21, t0.deducciones_fiscales AS deducciones_fiscales_22, t0.proveedor_homologado AS proveedor_homologado_23, t0.dispone_certificacion AS dispone_certificacion_24, t0.visible AS visible_25, t0.facebook AS facebook_26, t0.linkedin AS linkedin_27, t0.instagram AS instagram_28, t0.twitter AS twitter_29, t0.deshabilitar AS deshabilitar_30, t0.tipo_empresa_id AS tipo_empresa_id_31 FROM empresa t0 WHERE t0.id = ?
Parameters:
[
  "30"
]
2 1.18 ms
SELECT e0_.id AS id_0, e0_.nombre_fiscal AS nombre_fiscal_1, e0_.nombre_comercial AS nombre_comercial_2, e0_.nif AS nif_3, e0_.actividad_empresarial AS actividad_empresarial_4, e0_.nombre_representante_legal AS nombre_representante_legal_5, e0_.cargo_representante_legal AS cargo_representante_legal_6, e0_.telefono_representante_legal AS telefono_representante_legal_7, e0_.fecha_creacion AS fecha_creacion_8, e0_.fecha_incorporacion_cluster AS fecha_incorporacion_cluster_9, e0_.email AS email_10, e0_.email_comercial AS email_comercial_11, e0_.pagina_web AS pagina_web_12, e0_.video_promocional AS video_promocional_13, e0_.logo AS logo_14, e0_.personal_laboral AS personal_laboral_15, e0_.personal_laboral_mujeres AS personal_laboral_mujeres_16, e0_.personal_laboral_hombres AS personal_laboral_hombres_17, e0_.volumen_facturacion_anual AS volumen_facturacion_anual_18, e0_.sello_pyme_innovadora AS sello_pyme_innovadora_19, e0_.caducidad_sello_pyme_innovadora AS caducidad_sello_pyme_innovadora_20, e0_.deducciones_fiscales AS deducciones_fiscales_21, e0_.proveedor_homologado AS proveedor_homologado_22, e0_.dispone_certificacion AS dispone_certificacion_23, e0_.visible AS visible_24, e0_.facebook AS facebook_25, e0_.linkedin AS linkedin_26, e0_.instagram AS instagram_27, e0_.twitter AS twitter_28, e0_.deshabilitar AS deshabilitar_29, e0_.tipo_empresa_id AS tipo_empresa_id_30 FROM empresa e0_ WHERE e0_.visible = 1 AND (e0_.deshabilitar = 0 OR e0_.deshabilitar IS NULL) ORDER BY e0_.id DESC LIMIT 4
Parameters:
[]
3 0.82 ms
SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.empresa_id AS empresa_id_5 FROM imagen_empresa t0 WHERE t0.empresa_id = ?
Parameters:
[
  30
]
4 0.56 ms
SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.empresa_id AS empresa_id_5 FROM documento_empresa t0 WHERE t0.empresa_id = ?
Parameters:
[
  30
]
5 0.64 ms
SELECT t0.id AS id_1, t0.direccion AS direccion_2, t0.codigo_postal AS codigo_postal_3, t0.telefono AS telefono_4, t0.principal AS principal_5, t0.empresa_id AS empresa_id_6, t0.pais_id AS pais_id_7, t0.comunidad_autonoma_id AS comunidad_autonoma_id_8, t0.provincia_id AS provincia_id_9, t0.municipio_id AS municipio_id_10, t0.isla_id AS isla_id_11 FROM direccion t0 WHERE t0.empresa_id = ?
Parameters:
[
  30
]
6 0.72 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.crpo AS crpo_3 FROM municipio t0 WHERE t0.id = ?
Parameters:
[
  5252
]
7 0.44 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.crpo AS crpo_3, t0.comunidad_autonoma_id AS comunidad_autonoma_id_4 FROM provincia t0 WHERE t0.id = ?
Parameters:
[
  14
]
8 0.68 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.cargo AS cargo_3, t0.telefono AS telefono_4, t0.email AS email_5, t0.telefono_telegram AS telefono_telegram_6, t0.publico AS publico_7, t0.empresa_id AS empresa_id_8 FROM persona_contacto t0 WHERE t0.empresa_id = ?
Parameters:
[
  30
]
9 0.67 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.subvencionado AS subvencionado_4, t0.url AS url_5, t0.observaciones AS observaciones_6, t0.visible AS visible_7, t0.colaboracion AS colaboracion_8, t0.empresa_id AS empresa_id_9, t0.convocatoria_id AS convocatoria_id_10 FROM servicio t0 WHERE t0.empresa_id = ?
Parameters:
[
  30
]
10 0.77 ms
SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.servicio_id AS servicio_id_5 FROM imagen_servicio t0 WHERE t0.servicio_id = ?
Parameters:
[
  13
]
11 0.61 ms
SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.servicio_id AS servicio_id_5 FROM documento_servicio t0 WHERE t0.servicio_id = ?
Parameters:
[
  13
]
12 6.27 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.url AS url_4, t0.observaciones AS observaciones_5, t0.subvencionado AS subvencionado_6, t0.colaboracion AS colaboracion_7, t0.visible AS visible_8, t0.empresa_id AS empresa_id_9, t0.convocatoria_id AS convocatoria_id_10 FROM producto t0 WHERE t0.empresa_id = ?
Parameters:
[
  30
]
13 13.51 ms
SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.producto_id AS producto_id_5 FROM imagen_producto t0 WHERE t0.producto_id = ?
Parameters:
[
  2
]
14 14.21 ms
SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.producto_id AS producto_id_5 FROM documento_producto t0 WHERE t0.producto_id = ?
Parameters:
[
  2
]
15 0.62 ms
SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.producto_id AS producto_id_5 FROM imagen_producto t0 WHERE t0.producto_id = ?
Parameters:
[
  3
]
16 0.41 ms
SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.producto_id AS producto_id_5 FROM documento_producto t0 WHERE t0.producto_id = ?
Parameters:
[
  3
]
17 0.54 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.subvencionado AS subvencionado_5, t0.url AS url_6, t0.observaciones AS observaciones_7, t0.colaboracion AS colaboracion_8, t0.fecha_publica AS fecha_publica_9, t0.visible AS visible_10, t0.empresa_id AS empresa_id_11, t0.trl_id AS trl_id_12, t0.convocatoria_id AS convocatoria_id_13 FROM proyecto t0 WHERE t0.empresa_id = ?
Parameters:
[
  30
]
18 11.69 ms
SELECT t0.id AS id_1, t0.empresa_id AS empresa_id_2, t0.programa_digital_id AS programa_digital_id_3 FROM empresa_proveedor_programa t0 WHERE t0.empresa_id = ?
Parameters:
[
  30
]
19 0.66 ms
SELECT t0.id AS id_1, t0.empresa_id AS empresa_id_2, t0.certificacion_id AS certificacion_id_3 FROM certificacion_empresa t0 WHERE t0.empresa_id = ?
Parameters:
[
  30
]
20 0.45 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3 FROM certificacion t0 WHERE t0.id = ?
Parameters:
[
  1
]
21 0.63 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.imagen AS imagen_4 FROM programa_digital t0 WHERE t0.id = ?
Parameters:
[
  1
]
22 0.39 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.imagen AS imagen_4 FROM programa_digital t0 WHERE t0.id = ?
Parameters:
[
  2
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Empresa 5
App\Entity\TipoEmpresa 2
App\Entity\Producto 2
App\Entity\EmpresaProveedorPrograma 2
App\Entity\ProgramaDigital 2
App\Entity\Direccion 1
App\Entity\Pais 1
App\Entity\Provincia 1
App\Entity\Municipio 1
App\Entity\Isla 1
App\Entity\ComunidadAutonoma 1
App\Entity\PersonaContacto 1
App\Entity\Servicio 1
App\Entity\CertificacionEmpresa 1
App\Entity\Certificacion 1

Entities Mapping

Class Mapping errors
App\Entity\Empresa No errors.
App\Entity\TipoEmpresa No errors.
App\Entity\Direccion No errors.
App\Entity\EmpresaProveedorPrograma No errors.
App\Entity\PersonaContacto No errors.
App\Entity\Servicio No errors.
App\Entity\Producto No errors.
App\Entity\Proyecto No errors.
App\Entity\Imagen No errors.
App\Entity\ImagenEmpresa No errors.
App\Entity\Documento No errors.
App\Entity\DocumentoEmpresa No errors.
App\Entity\PresenciaEmpresa No errors.
App\Entity\User No errors.
App\Entity\CertificacionEmpresa No errors.
App\Entity\ContactoEmpresa No errors.
App\Entity\EtiquetaEmpresa No errors.
App\Entity\CnaeEmpresa No errors.
App\Entity\Pais No errors.
App\Entity\ComunidadAutonoma No errors.
App\Entity\Provincia No errors.
App\Entity\Municipio No errors.
App\Entity\Isla No errors.
App\Entity\PersonaViaComunicacion No errors.
App\Entity\Convocatoria No errors.
App\Entity\EntidadPublicaServicio No errors.
App\Entity\SectorEmpresarialServicio No errors.
App\Entity\SolucionTecnologicaServicio No errors.
App\Entity\EntidadServicio No errors.
App\Entity\DocumentoServicio No errors.
App\Entity\ImagenServicio No errors.
App\Entity\EtiquetaServicio No errors.
App\Entity\SectorEmpresarialProducto No errors.
App\Entity\SolucionTecnologicaProducto No errors.
App\Entity\EntidadProducto No errors.
App\Entity\EntidadPublicaProducto No errors.
App\Entity\DocumentoProducto No errors.
App\Entity\ImagenProducto No errors.
App\Entity\EtiquetaProducto No errors.
App\Entity\Trl No errors.
App\Entity\ProgramaDigital No errors.
App\Entity\Certificacion No errors.