Symfony Profiler

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_properties_supertype s
  LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype = i.id)
WHERE
  id_properties_supertype = '1'
  AND cod_lang = 'en_US'
LIMIT
  1

SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype  = '1' AND cod_lang = 'en_US' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.glat AS glat_3,
  t0.glon AS glon_4
FROM
  api_locations_gps t0
WHERE
  t0.glat = ?
  AND t0.glon = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.glat AS glat_3, t0.glon AS glon_4 FROM api_locations_gps t0 WHERE t0.glat = '41.4764357' AND t0.glon = '2.2503481' LIMIT 1;

SELECT
  slug,
  text
FROM
  api_agency_description
WHERE
  lang = 'es'

SELECT slug, text FROM api_agency_description WHERE lang = 'es';

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

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

SELECT
  *
FROM
  api_properties
WHERE
  precio >= 1085000
LIMIT
  1

SELECT * FROM api_properties WHERE precio >= 1085000 LIMIT 1;

SELECT
  api_features.id,
  api_features.type,
  api_features_i18n.text as name,
  api_properties_features.value
FROM
  api_features
  LEFT JOIN api_properties_features ON api_properties_features.id_feature = api_features.id
  AND api_properties_features.id_property = '14'
  LEFT JOIN api_features_i18n ON api_features_i18n.id = api_features.id
  AND api_features_i18n.cod_lang = 'es_ES'
WHERE
  api_features.id IN (749, 750)

SELECT api_features.id, api_features.type, api_features_i18n.text as name, api_properties_features.value 
                FROM api_features 
                LEFT JOIN api_properties_features ON api_properties_features.id_feature = api_features.id AND api_properties_features.id_property = '14'
                LEFT JOIN api_features_i18n ON api_features_i18n.id = api_features.id AND api_features_i18n.cod_lang = 'es_ES'
                WHERE api_features.id IN (749, 750);

SELECT
  t0.id AS id_1,
  t0.cod_lang AS cod_lang_2,
  t0.text AS text_3
FROM
  api_properties_types_i18n t0
WHERE
  t0.id = ?
  AND t0.cod_lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cod_lang AS cod_lang_2, t0.text AS text_3 FROM api_properties_types_i18n t0 WHERE t0.id = 2 AND t0.cod_lang = 'es_ES' LIMIT 1;

SELECT
  identificador,
  valor_es as texto
FROM
  textos

SELECT identificador, valor_es as texto FROM textos;

SELECT
  id
FROM
  api_properties_supertype_i18n
WHERE
  friendly = 'viviendas'

SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'viviendas';

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.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.predeterminado = ?
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.predeterminado = 1 LIMIT 1;

"COMMIT"

"COMMIT";

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/14', '2026-06-19 15:45:36');

SELECT
  t0.id AS id_1,
  t0.id_colegiado AS id_colegiado_2,
  t0.id_despacho AS id_despacho_3,
  t0.provincia AS provincia_4,
  t0.localidad AS localidad_5,
  t0.zona AS zona_6,
  t0.cod_postal AS cod_postal_7,
  t0.direccion AS direccion_8,
  t0.obra_nueva AS obra_nueva_9,
  t0.alquiler AS alquiler_10,
  t0.es_subhasta AS es_subhasta_11,
  t0.es_lloguer_temporada AS es_lloguer_temporada_12,
  t0.es_banc AS es_banc_13,
  t0.superf_util AS superf_util_14,
  t0.superf_constr AS superf_constr_15,
  t0.agencia AS agencia_16,
  t0.referencia AS referencia_17,
  t0.glat AS glat_18,
  t0.glon AS glon_19,
  t0.ref_catastral AS ref_catastral_20,
  t0.num_fotos AS num_fotos_21,
  t0.id_tipo_via AS id_tipo_via_22,
  t0.situacion_concreta AS situacion_concreta_23,
  t0.precio_alquiler AS precio_alquiler_24,
  t0.precio_alquiler_anterior AS precio_alquiler_anterior_25,
  t0.precio AS precio_26,
  t0.precio_anterior AS precio_anterior_27,
  t0.rebajado AS rebajado_28,
  t0.precio_subhasta AS precio_subhasta_29,
  t0.precio_subhasta_anterior AS precio_subhasta_anterior_30,
  t0.precio_alquiler_temporada AS precio_alquiler_temporada_31,
  t0.precio_alquiler_temporada_anterior AS precio_alquiler_temporada_anterior_32,
  t0.estado AS estado_33,
  t0.contrato_exclusividad AS contrato_exclusividad_34,
  t0.idportal AS idportal_35,
  t0.fecha_creacion AS fecha_creacion_36,
  t0.fecha_importacion AS fecha_importacion_37,
  t0.fecha_caducidad AS fecha_caducidad_38,
  t0.fecha_update AS fecha_update_39,
  t0.fecha_disponibilidad AS fecha_disponibilidad_40,
  t0.id_properties_subtype AS id_properties_subtype_41,
  t0.id_properties_type AS id_properties_type_42,
  t0.id_properties_supertype AS id_properties_supertype_43,
  t0.num_dorm AS num_dorm_44,
  t0.contactos AS contactos_45,
  t0.visitas AS visitas_46,
  t0.disponible AS disponible_47,
  t0.visibilidad AS visibilidad_48,
  t0.destacado AS destacado_49
FROM
  api_properties t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_colegiado AS id_colegiado_2, t0.id_despacho AS id_despacho_3, t0.provincia AS provincia_4, t0.localidad AS localidad_5, t0.zona AS zona_6, t0.cod_postal AS cod_postal_7, t0.direccion AS direccion_8, t0.obra_nueva AS obra_nueva_9, t0.alquiler AS alquiler_10, t0.es_subhasta AS es_subhasta_11, t0.es_lloguer_temporada AS es_lloguer_temporada_12, t0.es_banc AS es_banc_13, t0.superf_util AS superf_util_14, t0.superf_constr AS superf_constr_15, t0.agencia AS agencia_16, t0.referencia AS referencia_17, t0.glat AS glat_18, t0.glon AS glon_19, t0.ref_catastral AS ref_catastral_20, t0.num_fotos AS num_fotos_21, t0.id_tipo_via AS id_tipo_via_22, t0.situacion_concreta AS situacion_concreta_23, t0.precio_alquiler AS precio_alquiler_24, t0.precio_alquiler_anterior AS precio_alquiler_anterior_25, t0.precio AS precio_26, t0.precio_anterior AS precio_anterior_27, t0.rebajado AS rebajado_28, t0.precio_subhasta AS precio_subhasta_29, t0.precio_subhasta_anterior AS precio_subhasta_anterior_30, t0.precio_alquiler_temporada AS precio_alquiler_temporada_31, t0.precio_alquiler_temporada_anterior AS precio_alquiler_temporada_anterior_32, t0.estado AS estado_33, t0.contrato_exclusividad AS contrato_exclusividad_34, t0.idportal AS idportal_35, t0.fecha_creacion AS fecha_creacion_36, t0.fecha_importacion AS fecha_importacion_37, t0.fecha_caducidad AS fecha_caducidad_38, t0.fecha_update AS fecha_update_39, t0.fecha_disponibilidad AS fecha_disponibilidad_40, t0.id_properties_subtype AS id_properties_subtype_41, t0.id_properties_type AS id_properties_type_42, t0.id_properties_supertype AS id_properties_supertype_43, t0.num_dorm AS num_dorm_44, t0.contactos AS contactos_45, t0.visitas AS visitas_46, t0.disponible AS disponible_47, t0.visibilidad AS visibilidad_48, t0.destacado AS destacado_49 FROM api_properties t0 WHERE t0.id = '14' LIMIT 1;

SELECT
  bi.*,
  des.telef1,
  bi18.anuncio AS descrip,
  IF (
    superf_constr != ''
    AND superf_constr != '00'
    AND superf_constr != '0',
    superf_constr,
    superf_util
  ) AS superficie,
  IF (
    precio_alquiler > 0, precio_alquiler,
    precio
  ) AS preu,
  bi.id_properties_subtype AS id_tipus,
  IF(
    bi.es_lloguer_temporada = 1,
    7,
    IF(
      bi.es_banc = 1,
      4,
      IF(
        bi.obra_nueva = 1,
        3,
        IF(bi.alquiler = 1, 1, 2)
      )
    )
  ) operation,
  apitype.text as tipo_nombre
FROM
  api_properties as bi
  LEFT JOIN api_properties_i18n AS bi18 ON (bi.id = bi18.id)
  AND bi18.cod_lang = ''
  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 = ''
WHERE
  (
    IF (
      bi.contrato_exclusividad = 1,
      IF (
        bi.fecha_caducidad != '0000-00-00'
        AND bi.fecha_caducidad > '2026-06-19',
        TRUE,
        FALSE
      ),
      TRUE
    ) = TRUE
  )
  AND (
    (
      IF(
        bi.obra_nueva = 1
        AND bi.num_fotos >= 1,
        TRUE,
        FALSE
      ) = TRUE
    )
    OR (
      IF(
        bi.obra_nueva = 0
        AND bi.num_fotos >= 1,
        TRUE,
        FALSE
      ) = TRUE
    )
  )
  AND bi.num_fotos > 0
  AND bi.localidad = '3423'
  AND if(
    bi.superf_constr, bi.superf_constr >= 601,
    bi.superf_util >= 601
  )
  AND if(
    bi.superf_constr, bi.superf_constr <= 9000,
    bi.superf_util <= 9000
  )
GROUP BY
  bi.id
ORDER BY
  bi.id DESC
LIMIT
  5

SELECT bi.*, des.telef1  ,bi18.anuncio AS descrip
							,IF (superf_constr != '' AND superf_constr != '00' AND superf_constr !='0' , superf_constr, superf_util) AS superficie,
							 IF (precio_alquiler > 0, precio_alquiler, precio) AS preu  	,bi.id_properties_subtype AS id_tipus,
			 IF(bi.es_lloguer_temporada = 1, 7,
                IF(bi.es_banc = 1, 4,
                    IF(bi.obra_nueva = 1, 3,
                        IF(bi.alquiler = 1, 1, 2)
                    )
                )
            ) operation,
            apitype.text as tipo_nombre FROM api_properties as bi  LEFT JOIN api_properties_i18n AS bi18 ON (bi.id = bi18.id) AND bi18.cod_lang = '' 
		        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 = '' WHERE  (IF (bi.contrato_exclusividad = 1, IF (bi.fecha_caducidad != '0000-00-00' AND bi.fecha_caducidad > '2026-06-19', TRUE, FALSE), TRUE) = TRUE)    AND ((IF(bi.obra_nueva=1 AND bi.num_fotos>=1, TRUE, FALSE) = TRUE) OR (IF(bi.obra_nueva=0 AND bi.num_fotos>=1, TRUE, FALSE) = TRUE))  AND bi.num_fotos > 0  AND   bi.localidad = '3423'  AND   if(bi.superf_constr,bi.superf_constr >= 601,bi.superf_util >= 601)  AND   if(bi.superf_constr,bi.superf_constr <= 9000,bi.superf_util <= 9000)  GROUP BY bi.id  ORDER BY  bi.id DESC  LIMIT 5;

SELECT
  *
FROM
  api_properties_supertype s
  LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype = i.id)
WHERE
  id_properties_supertype = '1'
  AND cod_lang = 'ca_ES'
LIMIT
  1

SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype  = '1' AND cod_lang = 'ca_ES' LIMIT 1;

SELECT
  pf.id_property,
  pf.id_feature,
  pf.id_feature_type,
  COALESCE(dict.value, pf.value) as value,
  f.*,
  f.id as idfeature,
  fi.*,
  fv.name as nombre
FROM
  api_properties_features pf
  INNER JOIN api_features f ON pf.id_feature = f.id
  LEFT JOIN api_features_i18n fi ON f.id = fi.id
  LEFT JOIN api_features_values fv ON f.id = fv.feature
  LEFT JOIN api_features_dictionary_i18n dict ON dict.feature = pf.value
  AND dict.cod_lang = 'es_ES'
WHERE
  pf.id_property = '14'
  AND fi.cod_lang = 'es_ES'
GROUP BY
  f.id

SELECT pf.id_property,pf.id_feature,pf.id_feature_type,COALESCE(dict.value, pf.value) as value,f.*,f.id as idfeature,fi.*,fv.name as nombre 
        		FROM api_properties_features pf INNER JOIN api_features f ON pf.id_feature = f.id
                LEFT JOIN api_features_i18n fi ON f.id = fi.id 
                LEFT JOIN api_features_values fv ON f.id = fv.feature
                LEFT JOIN api_features_dictionary_i18n dict ON dict.feature = pf.value AND dict.cod_lang = 'es_ES'
                WHERE pf.id_property = '14'
                AND fi.cod_lang = 'es_ES'
                GROUP BY f.id;

SELECT
  *
FROM
  api_properties_supertype s
  LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype = i.id)
WHERE
  id_properties_supertype = '1'
  AND cod_lang = 'es_ES'
LIMIT
  1

SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype  = '1' AND cod_lang = 'es_ES' LIMIT 1;

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

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

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_properties p
  LEFT JOIN api_properties_i18n i ON p.id = i.id
WHERE
  p.id = 14
LIMIT
  1

SELECT * FROM api_properties p LEFT JOIN api_properties_i18n i ON p.id=i.id WHERE p.id=14 LIMIT 1;

SELECT
  banner,
  banner_url
FROM
  api_agency

SELECT banner, banner_url FROM api_agency;

SELECT
  identificador,
  valor_es as texto
FROM
  textos
WHERE
  identificador in (
    'hipoteca_en', 'fitxa_de', 'text_a',
    'en_tramite'
  )

SELECT identificador, valor_es as texto FROM textos WHERE identificador in ('hipoteca_en','fitxa_de','text_a','en_tramite');

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
  *
FROM
  preus_compra_cerca
WHERE
  preu <= 1105000
ORDER BY
  id DESC
LIMIT
  1

SELECT * FROM preus_compra_cerca WHERE preu <= 1105000 ORDER BY id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cod_lang AS cod_lang_2,
  t0.anuncio AS anuncio_3
FROM
  api_properties_i18n t0
WHERE
  t0.id = ?
  AND t0.cod_lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cod_lang AS cod_lang_2, t0.anuncio AS anuncio_3 FROM api_properties_i18n t0 WHERE t0.id = 14 AND t0.cod_lang = 'es_ES' LIMIT 1;

SELECT
  friendly_ES as friendly
FROM
  tipus_operacio
WHERE
  codi = 2
LIMIT
  1

SELECT friendly_ES as friendly FROM tipus_operacio WHERE codi = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.location AS location_2,
  t0.name AS name_3,
  t0.friendly AS friendly_4,
  t0.coord AS coord_5
FROM
  api_zones t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.location AS location_2, t0.name AS name_3, t0.friendly AS friendly_4, t0.coord AS coord_5 FROM api_zones t0 WHERE t0.id = 0 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
  link_video
FROM
  api_properties_video
WHERE
  id_property = '14'
  AND (
    link_video LIKE '%tour.feelestate.com%'
    OR link_video LIKE '%inmovriew%'
    OR link_video LIKE '%floorfy%'
    OR link_video LIKE '%viewer.realisti.co%'
    OR link_video LIKE '%storage.net-fs.com%'
    OR link_video LIKE '%matterport.com%'
  )

SELECT link_video FROM api_properties_video WHERE id_property = '14' AND (link_video LIKE '%tour.feelestate.com%' OR link_video LIKE '%inmovriew%' OR link_video LIKE '%floorfy%' OR link_video LIKE '%viewer.realisti.co%' OR link_video LIKE '%storage.net-fs.com%' OR link_video LIKE '%matterport.com%' );

SELECT
  t0.id AS id_1,
  t0.province AS province_2,
  t0.name AS name_3,
  t0.friendly AS friendly_4,
  t0.num_immobles_cerca_rapida AS num_immobles_cerca_rapida_5,
  t0.orden AS orden_6,
  t0.seo_home AS seo_home_7,
  t0.zoom AS zoom_8
FROM
  api_locations t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.province AS province_2, t0.name AS name_3, t0.friendly AS friendly_4, t0.num_immobles_cerca_rapida AS num_immobles_cerca_rapida_5, t0.orden AS orden_6, t0.seo_home AS seo_home_7, t0.zoom AS zoom_8 FROM api_locations t0 WHERE t0.id = 3423 LIMIT 1;

SELECT
  *
FROM
  api_properties_supertype s
  LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype = i.id)
WHERE
  id_properties_supertype = '1'
  AND cod_lang = 'fr_FR'
LIMIT
  1

SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype  = '1' AND cod_lang = 'fr_FR' 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 = ?
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.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
  CONCAT(
    'https://imagenes.ghestia.cat/images/webs//',
    url
  ) AS url
FROM
  api_properties_certificates_images
WHERE
  id_property = '14'

SELECT CONCAT('https://imagenes.ghestia.cat/images/webs//', url) AS url FROM api_properties_certificates_images WHERE id_property = '14';

SELECT
  friendly_ca
FROM
  tipus_operacio
WHERE
  codi = '2'
LIMIT
  1

SELECT friendly_ca FROM tipus_operacio WHERE codi = '2' LIMIT 1;

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

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

SELECT
  friendly_en
FROM
  tipus_operacio
WHERE
  codi = '2'
LIMIT
  1

SELECT friendly_en FROM tipus_operacio WHERE codi = '2' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.country AS country_2,
  t0.autonomousCommunity AS autonomousCommunity_3,
  t0.name AS name_4,
  t0.friendly AS friendly_5
FROM
  api_provinces t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.country AS country_2, t0.autonomousCommunity AS autonomousCommunity_3, t0.name AS name_4, t0.friendly AS friendly_5 FROM api_provinces t0 WHERE t0.id = 33 LIMIT 1;

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

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

SELECT
  friendly_fr
FROM
  tipus_operacio
WHERE
  codi = '2'
LIMIT
  1

SELECT friendly_fr FROM tipus_operacio WHERE codi = '2' LIMIT 1;