Symfony Profiler

"START TRANSACTION"

"START TRANSACTION";

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/viviendas/barcelona/badalona', '2026-06-19 18:01:44');

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_created AS date_created_3
FROM
  api_menu t0
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_created AS date_created_3 FROM api_menu t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.domain AS domain_3,
  t0.address AS address_4,
  t0.phone AS phone_5,
  t0.email AS email_6,
  t0.facebook AS facebook_7,
  t0.twitter AS twitter_8,
  t0.google AS google_9,
  t0.linkedin AS linkedin_10,
  t0.instagram AS instagram_11,
  t0.tiktok AS tiktok_12,
  t0.youtube AS youtube_13,
  t0.logo AS logo_14,
  t0.logo_movile_email AS logo_movile_email_15,
  t0.logo_contact AS logo_contact_16,
  t0.logo_fav AS logo_fav_17,
  t0.logo_aicat AS logo_aicat_18,
  t0.logo_agente AS logo_agente_19,
  t0.logo_miembro AS logo_miembro_20,
  t0.banner AS banner_21,
  t0.banner_url AS banner_url_22,
  t0.default_list_properties AS default_list_properties_23,
  t0.user AS user_24,
  t0.password AS password_25,
  t0.color_primary AS color_primary_26,
  t0.color_secondary AS color_secondary_27,
  t0.primary_foot_1 AS primary_foot_1_28,
  t0.primary_foot_2 AS primary_foot_2_29,
  t0.filter_header AS filter_header_30,
  t0.newsletter AS newsletter_31,
  t0.first_time AS first_time_32,
  t0.activation AS activation_33,
  t0.roles AS roles_34
FROM
  api_agency t0
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.facebook AS facebook_7, t0.twitter AS twitter_8, t0.google AS google_9, t0.linkedin AS linkedin_10, t0.instagram AS instagram_11, t0.tiktok AS tiktok_12, t0.youtube AS youtube_13, t0.logo AS logo_14, t0.logo_movile_email AS logo_movile_email_15, t0.logo_contact AS logo_contact_16, t0.logo_fav AS logo_fav_17, t0.logo_aicat AS logo_aicat_18, t0.logo_agente AS logo_agente_19, t0.logo_miembro AS logo_miembro_20, t0.banner AS banner_21, t0.banner_url AS banner_url_22, t0.default_list_properties AS default_list_properties_23, t0.user AS user_24, t0.password AS password_25, t0.color_primary AS color_primary_26, t0.color_secondary AS color_secondary_27, t0.primary_foot_1 AS primary_foot_1_28, t0.primary_foot_2 AS primary_foot_2_29, t0.filter_header AS filter_header_30, t0.newsletter AS newsletter_31, t0.first_time AS first_time_32, t0.activation AS activation_33, t0.roles AS roles_34 FROM api_agency t0 LIMIT 1;

SELECT
  t0.cod AS cod_1,
  t0.text AS text_2,
  t0.visible AS visible_3,
  t0.predeterminado AS predeterminado_4,
  t0.cod_complete AS cod_complete_5
FROM
  api_agency_lang t0

SELECT t0.cod AS cod_1, t0.text AS text_2, t0.visible AS visible_3, t0.predeterminado AS predeterminado_4, t0.cod_complete AS cod_complete_5 FROM api_agency_lang t0;

SELECT
  t0.cod AS cod_1,
  t0.text AS text_2,
  t0.visible AS visible_3,
  t0.predeterminado AS predeterminado_4,
  t0.cod_complete AS cod_complete_5
FROM
  api_agency_lang t0
WHERE
  t0.cod = ?
LIMIT
  1

SELECT t0.cod AS cod_1, t0.text AS text_2, t0.visible AS visible_3, t0.predeterminado AS predeterminado_4, t0.cod_complete AS cod_complete_5 FROM api_agency_lang t0 WHERE t0.cod = 'es' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.order_page AS order_page_2,
  t0.page_id AS page_id_3,
  t0.menu_id AS menu_id_4,
  t0.parent_id AS parent_id_5
FROM
  api_order_pages t0
WHERE
  t0.menu_id = ?
ORDER BY
  t0.order_page ASC

SELECT t0.id AS id_1, t0.order_page AS order_page_2, t0.page_id AS page_id_3, t0.menu_id AS menu_id_4, t0.parent_id AS parent_id_5 FROM api_order_pages t0 WHERE t0.menu_id = 1 ORDER BY t0.order_page ASC;

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
  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 = 137;

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 = 137 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 = 141;

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 = 141 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 = 145;

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 = 145 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 = 55;

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 = 99760 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 = 149;

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 = 149 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 = 71;

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 = 99999 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 = 63;

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 = 88190 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 = 59;

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 = 70840 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 = 51;

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 = 60722 LIMIT 1;

SELECT
  identificador,
  valor_es as texto
FROM
  textos

SELECT identificador, valor_es as texto FROM textos;

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
  *
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_provinces
WHERE
  friendly = 'barcelona'
LIMIT
  1

SELECT * FROM api_provinces WHERE friendly = 'barcelona' LIMIT 1;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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