Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.nombre AS nombre_1,
  c0_.direccion AS direccion_2,
  c0_.telefono AS telefono_3,
  c0_.coordenadas AS coordenadas_4,
  c0_.email AS email_5,
  c0_.estado AS estado_6,
  c0_.urlIcono AS urlicono_7,
  c0_.telefonoAdi AS telefonoadi_8,
  c0_.horario AS horario_9,
  c0_.id_tipo AS id_tipo_10,
  c0_.id_provincia AS id_provincia_11,
  c0_.id_ciudad AS id_ciudad_12
FROM
  centro_atencion c0_
ORDER BY
  c0_.nombre ASC

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.direccion AS direccion_2, c0_.telefono AS telefono_3, c0_.coordenadas AS coordenadas_4, c0_.email AS email_5, c0_.estado AS estado_6, c0_.urlIcono AS urlicono_7, c0_.telefonoAdi AS telefonoadi_8, c0_.horario AS horario_9, c0_.id_tipo AS id_tipo_10, c0_.id_provincia AS id_provincia_11, c0_.id_ciudad AS id_ciudad_12 FROM centro_atencion c0_ ORDER BY c0_.nombre ASC;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.estado AS estado_3,
  t0.descripcion AS descripcion_4,
  t0.urlicon AS urlicon_5
FROM
  tipo_centro_atencion t0
WHERE
  t0.nombre = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.estado AS estado_3, t0.descripcion AS descripcion_4, t0.urlicon AS urlicon_5 FROM tipo_centro_atencion t0 WHERE t0.nombre = '01 Servicios de batería';

SELECT
  c0_.id AS id_0,
  c0_.nombre AS nombre_1,
  c0_.coordenadas AS coordenadas_2,
  c0_.coordenadas AS coordenadas_3,
  c0_.direccion || ' - ' || p1_.nombre || ', ' || c2_.nombre AS sclr_4,
  c0_.telefono || ' - ' || c0_.telefonoAdi AS sclr_5,
  c0_.horario AS horario_6,
  t3_.id AS id_7,
  t3_.nombre AS nombre_8
FROM
  centro_atencion c0_,
  tipo_centro_atencion t3_,
  provincia p1_,
  ciudad c2_
WHERE
  c0_.id_tipo = t3_.id
  AND c0_.id_provincia = p1_.id
  AND c0_.id_ciudad = c2_.id
  AND c0_.estado = 'A'
  AND t3_.estado = 'A'
ORDER BY
  c0_.nombre ASC

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.coordenadas AS coordenadas_2, c0_.coordenadas AS coordenadas_3, c0_.direccion || ' - ' || p1_.nombre || ', ' || c2_.nombre AS sclr_4, c0_.telefono || ' - ' || c0_.telefonoAdi AS sclr_5, c0_.horario AS horario_6, t3_.id AS id_7, t3_.nombre AS nombre_8 FROM centro_atencion c0_, tipo_centro_atencion t3_, provincia p1_, ciudad c2_ WHERE c0_.id_tipo = t3_.id AND c0_.id_provincia = p1_.id AND c0_.id_ciudad = c2_.id AND c0_.estado = 'A' AND t3_.estado = 'A' ORDER BY c0_.nombre ASC;

SELECT
  DISTINCT e0_.Nombres AS nombres_0,
  e0_.id AS id_1
FROM
  estructura_ecommerce_es e0_,
  producto_es p1_
WHERE
  e0_.Status = 1
  AND p1_.cat1 = e0_.id
  AND p1_.status_eCommerce = 1
  AND p1_.status_infor = 1
ORDER BY
  e0_.Nombres ASC

SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND p1_.cat1 = e0_.id AND p1_.status_eCommerce = 1 AND p1_.status_infor = 1 ORDER BY e0_.Nombres ASC;

SELECT
  count(f0_.id) AS sclr_0
FROM
  footer_column f0_
WHERE
  f0_.estado = ?
  AND f0_.tipoColumna <> 'C'
  AND f0_.mostrar = ?

SELECT count(f0_.id) AS sclr_0 FROM footer_column f0_ WHERE f0_.estado = 'A' AND f0_.tipoColumna <> 'C' AND f0_.mostrar = 1;

SELECT
  t0.id AS id_1,
  t0.descripcion AS descripcion_2,
  t0.url AS url_3,
  t0.tipoAperturaUrl AS tipoaperturaurl_4,
  t0.footer_column_id AS footer_column_id_5
FROM
  footer_column_texto t0
WHERE
  t0.footer_column_id = ?

SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.url AS url_3, t0.tipoAperturaUrl AS tipoaperturaurl_4, t0.footer_column_id AS footer_column_id_5 FROM footer_column_texto t0 WHERE t0.footer_column_id = 2;

SELECT
  s0_.titulo AS titulo_0
FROM
  seccion_seo s0_
  INNER JOIN tipo_seccion_seo t1_ ON s0_.tipo_seccion_seo_id = t1_.id
WHERE
  s0_.estado = ?
  AND s0_.mostrar = ?
  AND t1_.id_tipo = ?
LIMIT
  1

SELECT s0_.titulo AS titulo_0 FROM seccion_seo s0_ INNER JOIN tipo_seccion_seo t1_ ON s0_.tipo_seccion_seo_id = t1_.id WHERE s0_.estado = 'A' AND s0_.mostrar = 1 AND t1_.id_tipo = 'CA' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.imgNombreServidor AS imgnombreservidor_2,
  t0.imgNombreAlternativo AS imgnombrealternativo_3,
  t0.url AS url_4,
  t0.tipoAperturaUrl AS tipoaperturaurl_5,
  t0.texto_alternativo_imagen AS texto_alternativo_imagen_6,
  t0.footer_column_id AS footer_column_id_7
FROM
  footer_column_imagen t0
WHERE
  t0.footer_column_id = ?

SELECT t0.id AS id_1, t0.imgNombreServidor AS imgnombreservidor_2, t0.imgNombreAlternativo AS imgnombrealternativo_3, t0.url AS url_4, t0.tipoAperturaUrl AS tipoaperturaurl_5, t0.texto_alternativo_imagen AS texto_alternativo_imagen_6, t0.footer_column_id AS footer_column_id_7 FROM footer_column_imagen t0 WHERE t0.footer_column_id = 5;

SELECT
  t0.id AS id_1,
  t0.urlImagen AS urlimagen_2,
  t0.seccion_seo_id AS seccion_seo_id_3
FROM
  img_seccion_seo t0
WHERE
  t0.seccion_seo_id = ?

SELECT t0.id AS id_1, t0.urlImagen AS urlimagen_2, t0.seccion_seo_id AS seccion_seo_id_3 FROM img_seccion_seo t0 WHERE t0.seccion_seo_id = 3;

SELECT
  s0_.id AS id_0,
  s0_.titulo AS titulo_1,
  s0_.descripcion AS descripcion_2,
  s0_.keywords AS keywords_3,
  s0_.estado AS estado_4,
  s0_.mostrar AS mostrar_5,
  s0_.fechaCreacion AS fechacreacion_6,
  s0_.fechaActualizacion AS fechaactualizacion_7,
  s0_.header_principal AS header_principal_8,
  s0_.header_secundario AS header_secundario_9,
  s0_.tipo_seccion_seo_id AS tipo_seccion_seo_id_10
FROM
  seccion_seo s0_
  INNER JOIN tipo_seccion_seo t1_ ON s0_.tipo_seccion_seo_id = t1_.id
WHERE
  s0_.estado = ?
  AND s0_.mostrar = ?
  AND t1_.id_tipo = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.titulo AS titulo_1, s0_.descripcion AS descripcion_2, s0_.keywords AS keywords_3, s0_.estado AS estado_4, s0_.mostrar AS mostrar_5, s0_.fechaCreacion AS fechacreacion_6, s0_.fechaActualizacion AS fechaactualizacion_7, s0_.header_principal AS header_principal_8, s0_.header_secundario AS header_secundario_9, s0_.tipo_seccion_seo_id AS tipo_seccion_seo_id_10 FROM seccion_seo s0_ INNER JOIN tipo_seccion_seo t1_ ON s0_.tipo_seccion_seo_id = t1_.id WHERE s0_.estado = 'A' AND s0_.mostrar = 1 AND t1_.id_tipo = 'CA' LIMIT 1;

SELECT
  DISTINCT e0_.Nombres AS nombres_0,
  e0_.id AS id_1
FROM
  estructura_ecommerce_es e0_,
  producto_es p1_
WHERE
  e0_.Status = 1
  AND e0_.Nivel = 2
  AND p1_.cat1 = 199
  AND p1_.cat2 = e0_.id
ORDER BY
  e0_.Nombres ASC

SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 199 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC;

SELECT
  DISTINCT e0_.Nombres AS nombres_0,
  e0_.id AS id_1
FROM
  estructura_ecommerce_es e0_,
  producto_es p1_
WHERE
  e0_.Status = 1
  AND e0_.Nivel = 2
  AND p1_.cat1 = 198
  AND p1_.cat2 = e0_.id
ORDER BY
  e0_.Nombres ASC

SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 198 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC;

SELECT
  DISTINCT e0_.Nombres AS nombres_0,
  e0_.id AS id_1
FROM
  estructura_ecommerce_es e0_,
  producto_es p1_
WHERE
  e0_.Status = 1
  AND e0_.Nivel = 2
  AND p1_.cat1 = 200
  AND p1_.cat2 = e0_.id
ORDER BY
  e0_.Nombres ASC

SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 200 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC;

SELECT
  DISTINCT e0_.Nombres AS nombres_0,
  e0_.id AS id_1
FROM
  estructura_ecommerce_es e0_,
  producto_es p1_
WHERE
  e0_.Status = 1
  AND e0_.Nivel = 2
  AND p1_.cat1 = 212
  AND p1_.cat2 = e0_.id
ORDER BY
  e0_.Nombres ASC

SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 212 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC;

SELECT
  f0_.id AS id_0,
  f0_.posicion AS posicion_1,
  f0_.mostrar AS mostrar_2,
  f0_.nombreColumna AS nombrecolumna_3,
  f0_.estado AS estado_4,
  f0_.fechaCreacion AS fechacreacion_5,
  f0_.fechaActualizacion AS fechaactualizacion_6,
  f0_.tipoColumna AS tipocolumna_7
FROM
  footer_column f0_
WHERE
  f0_.estado = ?
  AND f0_.tipoColumna <> 'C'
  AND f0_.mostrar = ?
ORDER BY
  f0_.posicion ASC

SELECT f0_.id AS id_0, f0_.posicion AS posicion_1, f0_.mostrar AS mostrar_2, f0_.nombreColumna AS nombrecolumna_3, f0_.estado AS estado_4, f0_.fechaCreacion AS fechacreacion_5, f0_.fechaActualizacion AS fechaactualizacion_6, f0_.tipoColumna AS tipocolumna_7 FROM footer_column f0_ WHERE f0_.estado = 'A' AND f0_.tipoColumna <> 'C' AND f0_.mostrar = 1 ORDER BY f0_.posicion ASC;

SELECT
  DISTINCT e0_.Nombres AS nombres_0,
  e0_.id AS id_1
FROM
  estructura_ecommerce_es e0_,
  producto_es p1_
WHERE
  e0_.Status = 1
  AND e0_.Nivel = 2
  AND p1_.cat1 = 201
  AND p1_.cat2 = e0_.id
ORDER BY
  e0_.Nombres ASC

SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 201 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC;

SELECT
  t0_.id AS id_0,
  t0_.nombre AS nombre_1,
  t0_.estado AS estado_2,
  t0_.descripcion AS descripcion_3,
  t0_.urlicon AS urlicon_4
FROM
  tipo_centro_atencion t0_
WHERE
  t0_.estado = ?
ORDER BY
  t0_.nombre ASC

SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.estado AS estado_2, t0_.descripcion AS descripcion_3, t0_.urlicon AS urlicon_4 FROM tipo_centro_atencion t0_ WHERE t0_.estado = 'A' ORDER BY t0_.nombre ASC;

SELECT
  f0_.id AS id_0,
  f0_.posicion AS posicion_1,
  f0_.mostrar AS mostrar_2,
  f0_.nombreColumna AS nombrecolumna_3,
  f0_.estado AS estado_4,
  f0_.fechaCreacion AS fechacreacion_5,
  f0_.fechaActualizacion AS fechaactualizacion_6,
  f0_.tipoColumna AS tipocolumna_7
FROM
  footer_column f0_
WHERE
  f0_.estado = ?
  AND f0_.tipoColumna = ?
  AND f0_.mostrar = ?

SELECT f0_.id AS id_0, f0_.posicion AS posicion_1, f0_.mostrar AS mostrar_2, f0_.nombreColumna AS nombrecolumna_3, f0_.estado AS estado_4, f0_.fechaCreacion AS fechacreacion_5, f0_.fechaActualizacion AS fechaactualizacion_6, f0_.tipoColumna AS tipocolumna_7 FROM footer_column f0_ WHERE f0_.estado = 'A' AND f0_.tipoColumna = 'C' AND f0_.mostrar = 1;