Symfony Profiler

SELECT
  identificador,
  valor_es as texto
FROM
  textos

SELECT identificador, valor_es as texto FROM textos;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.group_page AS group_page_3,
  t0.lang AS lang_4,
  t0.status AS status_5,
  t0.title AS title_6,
  t0.str_html AS str_html_7,
  t0.json_back AS json_back_8,
  t0.date_created AS date_created_9,
  t0.default_page AS default_page_10
FROM
  api_pages t0
WHERE
  t0.lang = ?
  AND t0.group_page = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.lang = 'es' AND t0.group_page = 21 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.group_page AS group_page_3,
  t0.lang AS lang_4,
  t0.status AS status_5,
  t0.title AS title_6,
  t0.str_html AS str_html_7,
  t0.json_back AS json_back_8,
  t0.date_created AS date_created_9,
  t0.default_page AS default_page_10
FROM
  api_pages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.group_page AS group_page_3, t0.lang AS lang_4, t0.status AS status_5, t0.title AS title_6, t0.str_html AS str_html_7, t0.json_back AS json_back_8, t0.date_created AS date_created_9, t0.default_page AS default_page_10 FROM api_pages t0 WHERE t0.id = 21;

SELECT
  *
FROM
  api_provinces
WHERE
  id IN (33, 34, 35, 36)
ORDER BY
  name

SELECT * FROM api_provinces  WHERE id IN (33,34,35,36)  ORDER BY name;

SELECT
  codi
FROM
  tipus_operacio
WHERE
  friendly_es = 'compra'
LIMIT
  1

SELECT codi FROM tipus_operacio WHERE friendly_es = 'compra' LIMIT 1;

SELECT
  *
FROM
  api_provinces
WHERE
  id NOT IN (33, 34, 35, 36)
ORDER BY
  name

SELECT * FROM api_provinces  WHERE id NOT IN (33,34,35,36)  ORDER BY name;

SELECT
  *
FROM
  api_locations
WHERE
  province = 33
  AND name != ''
  AND orden = 0
ORDER BY
  name

SELECT * FROM api_locations WHERE province = 33 AND name != '' AND orden = 0 ORDER BY name;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3915'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3915'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  count(*) as total
FROM
  api_properties
WHERE
  provincia = 53

SELECT count(*) as total FROM api_properties WHERE provincia = 53;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3804'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3804'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3876'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3876'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3665'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3665'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3482'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3482'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3407'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3407'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3434'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3434'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '20072'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '20072'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3780'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3780'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3677'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3677'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3671'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3671'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3516'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3516'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3646'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3646'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3525'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3525'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;

INSERT INTO tracking (
  type, session_id, tracking_value,
  date_created
)
VALUES
  (?, ?, ?, ?)

INSERT INTO tracking (type, session_id, tracking_value, date_created) VALUES (0, '1122b1127dd203a4c9a07c01fee8dd2bcf618d3c', '/es/compra/terrenos/barcelona/rubi', '2026-06-19 16:05:05');

SELECT
  COUNT(id) AS id
FROM
  (
    SELECT
      bi.id AS id
    FROM
      api_properties as bi
      INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
      INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
      INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
      INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type
      AND apitype.cod_lang = 'es_ES'
    WHERE
      IF (
        bi.contrato_exclusividad = 1,
        IF (
          bi.fecha_caducidad != '0000-00-00'
          AND bi.fecha_caducidad > '2026-06-19',
          TRUE,
          FALSE
        ),
        TRUE
      )
      AND bi.num_fotos > 0
      AND (
        bi.alquiler = 0
        OR bi.alquiler = 2
      )
      AND bi.precio > 0
      AND id_properties_supertype = 6
      AND bi.localidad = '3774'
      AND bi.provincia = '33'
    GROUP BY
      bi.id
  ) AS CONTADOR

SELECT COUNT(id) AS id
                FROM (SELECT bi.id AS id  FROM api_properties as bi 
		        INNER JOIN api_despachos AS desps ON bi.id_colegiado = desps.idcens
		        INNER JOIN api_censados AS cen ON bi.id_colegiado = cen.idcens
		        INNER JOIN api_despacho AS des ON desps.idcens = des.idcens
		        INNER JOIN api_properties_types_i18n AS apitype ON apitype.id = bi.id_properties_type AND apitype.cod_lang = 'es_ES' WHERE IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE)
			AND bi.num_fotos > 0 AND   (bi.alquiler=0 OR bi.alquiler=2)  AND   bi.precio > 0 AND   id_properties_supertype = 6  AND   bi.localidad = '3774'  AND   bi.provincia = '33'  GROUP BY bi.id ) AS CONTADOR;