Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

69 Database Queries

44 Different statements

81.49 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


"START TRANSACTION"
INSERT INTO tracking (type, session_id, tracking_value, date_created) VALUES (?, ?, ?, ?)
"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.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.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.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.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.cod = ? 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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.lang = ? AND t0.group_page = ? LIMIT 1
SELECT identificador, valor_es as texto FROM textos
SELECT slug, text FROM api_agency_description WHERE lang = 'es'
SELECT identificador, valor_es as texto FROM textos WHERE identificador in ('hipoteca_en','fitxa_de','text_a','en_tramite')
SELECT CONCAT('https://imagenes.ghestia.cat/images/webs//', url) AS url FROM api_properties_certificates_images WHERE id_property = '20'
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 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 = '20'
                AND fi.cod_lang = 'es_ES'
                GROUP BY f.id
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 = '20'
                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.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.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.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.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 friendly_ES as friendly FROM tipus_operacio WHERE codi = 2 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 * FROM api_properties p LEFT JOIN api_properties_i18n i ON p.id=i.id WHERE p.id=20 LIMIT 1
SELECT * FROM api_properties WHERE precio >= 69000 LIMIT 1
SELECT * FROM preus_compra_cerca WHERE preu <= 89000 ORDER BY id DESC 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 >= 121,bi.superf_util >= 121)  AND   if(bi.superf_constr,bi.superf_constr <= 160,bi.superf_util <= 160)  GROUP BY bi.id  ORDER BY  bi.id DESC  LIMIT 5
SELECT banner, banner_url FROM api_agency
SELECT link_video FROM api_properties_video WHERE id_property = '20' 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 codi FROM tipus_operacio WHERE friendly_ca = 'compra' LIMIT 1
SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales'
SELECT friendly_ca FROM tipus_operacio WHERE codi = '2' 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  = '3' AND cod_lang = 'ca_ES' LIMIT 1
SELECT codi FROM tipus_operacio WHERE friendly_en = 'compra' LIMIT 1
SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales'
SELECT friendly_en FROM tipus_operacio WHERE codi = '2' 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  = '3' AND cod_lang = 'en_US' LIMIT 1
SELECT codi FROM tipus_operacio WHERE friendly_es = 'compra' LIMIT 1
SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales'
SELECT friendly_es FROM tipus_operacio WHERE codi = '2' 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  = '3' AND cod_lang = 'es_ES' LIMIT 1
SELECT codi FROM tipus_operacio WHERE friendly_fr = 'compra' LIMIT 1
SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales'
SELECT friendly_fr FROM tipus_operacio WHERE codi = '2' 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  = '3' AND cod_lang = 'fr_FR' LIMIT 1
SELECT codi FROM tipus_operacio WHERE friendly_es = 'compra' LIMIT 1
SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales'
SELECT friendly_es FROM tipus_operacio WHERE codi = '2' 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  = '3' AND cod_lang = 'es_ES' LIMIT 1

#▲	Time	Info
1	0.41 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
2	0.76 ms	INSERT INTO tracking (type, session_id, tracking_value, date_created) VALUES (?, ?, ?, ?) Parameters: [`0 "1122b1127dd203a4c9a07c01fee8dd2bcf618d3c" "/es/compra/locales/barcelona/badalona/20" "2026-06-19 15:45:06"`] View formatted query View runnable query Explain query 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/locales/barcelona/badalona/20', '2026-06-19 15:45:06');
3	1.90 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
4	2.29 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.date_created AS date_created_3 FROM api_menu t0 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query 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;
5	0.66 ms	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 Parameters: [] View formatted query View runnable query Explain query 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;
6	1.46 ms	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 Parameters: [`"20"`] View formatted query View runnable query Explain query 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 = '20' LIMIT 1;
7	0.54 ms	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 Parameters: [] View formatted query View runnable query Explain query 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;
8	1.81 ms	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 Parameters: [`1`] View formatted query View runnable query Explain query 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;
9	0.47 ms	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 Parameters: [`"es"`] View formatted query View runnable query Explain query 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;
10	0.47 ms	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 Parameters: [`1`] View formatted query View runnable query Explain query 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;
11	0.68 ms	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 = ? Parameters: [`21`] View formatted query View runnable query Explain query 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;
12	0.61 ms	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 Parameters: [`"es" 21`] View formatted query View runnable query Explain query 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;
13	0.43 ms	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 = ? Parameters: [`137`] View formatted query View runnable query Explain query 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;
14	1.16 ms	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 Parameters: [`"es" 137`] View formatted query View runnable query Explain query 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;
15	1.78 ms	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 = ? Parameters: [`141`] View formatted query View runnable query Explain query 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;
16	0.63 ms	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 Parameters: [`"es" 141`] View formatted query View runnable query Explain query 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;
17	0.45 ms	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 = ? Parameters: [`145`] View formatted query View runnable query Explain query 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;
18	1.23 ms	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 Parameters: [`"es" 145`] View formatted query View runnable query Explain query 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;
19	0.61 ms	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 = ? Parameters: [`55`] View formatted query View runnable query Explain query 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;
20	1.91 ms	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 Parameters: [`"es" 99760`] View formatted query View runnable query Explain query 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;
21	0.51 ms	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 = ? Parameters: [`149`] View formatted query View runnable query Explain query 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;
22	1.89 ms	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 Parameters: [`"es" 149`] View formatted query View runnable query Explain query 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;
23	0.44 ms	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 = ? Parameters: [`71`] View formatted query View runnable query Explain query 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;
24	0.49 ms	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 Parameters: [`"es" 99999`] View formatted query View runnable query Explain query 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;
25	1.43 ms	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 = ? Parameters: [`63`] View formatted query View runnable query Explain query 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;
26	0.68 ms	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 Parameters: [`"es" 88190`] View formatted query View runnable query Explain query 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;
27	1.82 ms	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 = ? Parameters: [`59`] View formatted query View runnable query Explain query 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;
28	2.32 ms	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 Parameters: [`"es" 70840`] View formatted query View runnable query Explain query 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;
29	0.59 ms	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 = ? Parameters: [`51`] View formatted query View runnable query Explain query 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;
30	1.37 ms	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 Parameters: [`"es" 60722`] View formatted query View runnable query Explain query 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;
31	4.09 ms	SELECT identificador, valor_es as texto FROM textos Parameters: [] View formatted query View runnable query Explain query SELECT identificador, valor_es as texto FROM textos SELECT identificador, valor_es as texto FROM textos;
32	0.60 ms	SELECT slug, text FROM api_agency_description WHERE lang = 'es' Parameters: [] View formatted query View runnable query Explain query SELECT slug, text FROM api_agency_description WHERE lang = 'es' SELECT slug, text FROM api_agency_description WHERE lang = 'es';
33	0.49 ms	SELECT identificador, valor_es as texto FROM textos WHERE identificador in ('hipoteca_en','fitxa_de','text_a','en_tramite') Parameters: [] View formatted query View runnable query Explain query 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');
34	3.68 ms	SELECT CONCAT('https://imagenes.ghestia.cat/images/webs//', url) AS url FROM api_properties_certificates_images WHERE id_property = '20' Parameters: [] View formatted query View runnable query Explain query SELECT CONCAT( 'https://imagenes.ghestia.cat/images/webs//', url ) AS url FROM api_properties_certificates_images WHERE id_property = '20' SELECT CONCAT('https://imagenes.ghestia.cat/images/webs//', url) AS url FROM api_properties_certificates_images WHERE id_property = '20';
35	4.79 ms	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 Parameters: [`"41.4504333" "2.236313"`] View formatted query View runnable query Explain query 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.4504333' AND t0.glon = '2.236313' LIMIT 1;
36	3.58 ms	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 = '20' AND fi.cod_lang = 'es_ES' GROUP BY f.id Parameters: [] View formatted query View runnable query Explain query 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 = '20' 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 = '20' AND fi.cod_lang = 'es_ES' GROUP BY f.id;
37	0.72 ms	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 = '20' 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) Parameters: [] View formatted query View runnable query Explain query 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 = '20' 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 = '20' 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);
38	0.97 ms	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 Parameters: [`0`] View formatted query View runnable query Explain query 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;
39	0.38 ms	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 Parameters: [`3423`] View formatted query View runnable query Explain query 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;
40	0.35 ms	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 Parameters: [`33`] View formatted query View runnable query Explain query 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;
41	0.35 ms	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 Parameters: [`3 "es_ES"`] View formatted query View runnable query Explain query 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 = 3 AND t0.cod_lang = 'es_ES' LIMIT 1;
42	1.80 ms	SELECT friendly_ES as friendly FROM tipus_operacio WHERE codi = 2 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query 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;
43	1.00 ms	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 Parameters: [`20 "es_ES"`] View formatted query View runnable query Explain query 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 = 20 AND t0.cod_lang = 'es_ES' LIMIT 1;
44	0.57 ms	SELECT * FROM api_properties p LEFT JOIN api_properties_i18n i ON p.id=i.id WHERE p.id=20 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM api_properties p LEFT JOIN api_properties_i18n i ON p.id = i.id WHERE p.id = 20 LIMIT 1 SELECT * FROM api_properties p LEFT JOIN api_properties_i18n i ON p.id=i.id WHERE p.id=20 LIMIT 1;
45	0.51 ms	SELECT * FROM api_properties WHERE precio >= 69000 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM api_properties WHERE precio >= 69000 LIMIT 1 SELECT * FROM api_properties WHERE precio >= 69000 LIMIT 1;
46	2.23 ms	SELECT * FROM preus_compra_cerca WHERE preu <= 89000 ORDER BY id DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM preus_compra_cerca WHERE preu <= 89000 ORDER BY id DESC LIMIT 1 SELECT * FROM preus_compra_cerca WHERE preu <= 89000 ORDER BY id DESC LIMIT 1;
47	2.84 ms	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 >= 121,bi.superf_util >= 121) AND if(bi.superf_constr,bi.superf_constr <= 160,bi.superf_util <= 160) GROUP BY bi.id ORDER BY bi.id DESC LIMIT 5 Parameters: [] View formatted query View runnable query Explain query 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 >= 121, bi.superf_util >= 121 ) AND if( bi.superf_constr, bi.superf_constr <= 160, bi.superf_util <= 160 ) 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 >= 121,bi.superf_util >= 121) AND if(bi.superf_constr,bi.superf_constr <= 160,bi.superf_util <= 160) GROUP BY bi.id ORDER BY bi.id DESC LIMIT 5;
48	0.44 ms	SELECT banner, banner_url FROM api_agency Parameters: [] View formatted query View runnable query Explain query SELECT banner, banner_url FROM api_agency SELECT banner, banner_url FROM api_agency;
49	1.00 ms	SELECT link_video FROM api_properties_video WHERE id_property = '20' 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%' ) Parameters: [] View formatted query View runnable query Explain query SELECT link_video FROM api_properties_video WHERE id_property = '20' 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 = '20' 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%' );
50	0.38 ms	SELECT codi FROM tipus_operacio WHERE friendly_ca = 'compra' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT codi FROM tipus_operacio WHERE friendly_ca = 'compra' LIMIT 1 SELECT codi FROM tipus_operacio WHERE friendly_ca = 'compra' LIMIT 1;
51	2.01 ms	SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales' Parameters: [] View formatted query View runnable query Explain query SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales' SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales';
52	2.50 ms	SELECT friendly_ca FROM tipus_operacio WHERE codi = '2' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT friendly_ca FROM tipus_operacio WHERE codi = '2' LIMIT 1 SELECT friendly_ca FROM tipus_operacio WHERE codi = '2' LIMIT 1;
53	0.49 ms	SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype = '3' AND cod_lang = 'ca_ES' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype = i.id) WHERE id_properties_supertype = '3' 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 = '3' AND cod_lang = 'ca_ES' LIMIT 1;
54	0.36 ms	SELECT codi FROM tipus_operacio WHERE friendly_en = 'compra' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT codi FROM tipus_operacio WHERE friendly_en = 'compra' LIMIT 1 SELECT codi FROM tipus_operacio WHERE friendly_en = 'compra' LIMIT 1;
55	0.40 ms	SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales' Parameters: [] View formatted query View runnable query Explain query SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales' SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales';
56	0.38 ms	SELECT friendly_en FROM tipus_operacio WHERE codi = '2' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT friendly_en FROM tipus_operacio WHERE codi = '2' LIMIT 1 SELECT friendly_en FROM tipus_operacio WHERE codi = '2' LIMIT 1;
57	0.43 ms	SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype = '3' AND cod_lang = 'en_US' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype = i.id) WHERE id_properties_supertype = '3' 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 = '3' AND cod_lang = 'en_US' LIMIT 1;
58	0.56 ms	SELECT codi FROM tipus_operacio WHERE friendly_es = 'compra' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT codi FROM tipus_operacio WHERE friendly_es = 'compra' LIMIT 1 SELECT codi FROM tipus_operacio WHERE friendly_es = 'compra' LIMIT 1;
59	0.54 ms	SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales' Parameters: [] View formatted query View runnable query Explain query SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales' SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales';
60	0.76 ms	SELECT friendly_es FROM tipus_operacio WHERE codi = '2' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT friendly_es FROM tipus_operacio WHERE codi = '2' LIMIT 1 SELECT friendly_es FROM tipus_operacio WHERE codi = '2' LIMIT 1;
61	2.15 ms	SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype = '3' AND cod_lang = 'es_ES' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype = i.id) WHERE id_properties_supertype = '3' 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 = '3' AND cod_lang = 'es_ES' LIMIT 1;
62	3.62 ms	SELECT codi FROM tipus_operacio WHERE friendly_fr = 'compra' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT codi FROM tipus_operacio WHERE friendly_fr = 'compra' LIMIT 1 SELECT codi FROM tipus_operacio WHERE friendly_fr = 'compra' LIMIT 1;
63	1.61 ms	SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales' Parameters: [] View formatted query View runnable query Explain query SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales' SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales';
64	0.52 ms	SELECT friendly_fr FROM tipus_operacio WHERE codi = '2' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT friendly_fr FROM tipus_operacio WHERE codi = '2' LIMIT 1 SELECT friendly_fr FROM tipus_operacio WHERE codi = '2' LIMIT 1;
65	0.46 ms	SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype = '3' AND cod_lang = 'fr_FR' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype = i.id) WHERE id_properties_supertype = '3' 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 = '3' AND cod_lang = 'fr_FR' LIMIT 1;
66	0.48 ms	SELECT codi FROM tipus_operacio WHERE friendly_es = 'compra' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT codi FROM tipus_operacio WHERE friendly_es = 'compra' LIMIT 1 SELECT codi FROM tipus_operacio WHERE friendly_es = 'compra' LIMIT 1;
67	0.72 ms	SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales' Parameters: [] View formatted query View runnable query Explain query SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales' SELECT id FROM api_properties_supertype_i18n WHERE friendly = 'locales';
68	0.42 ms	SELECT friendly_es FROM tipus_operacio WHERE codi = '2' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT friendly_es FROM tipus_operacio WHERE codi = '2' LIMIT 1 SELECT friendly_es FROM tipus_operacio WHERE codi = '2' LIMIT 1;
69	0.54 ms	SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype=i.id) WHERE id_properties_supertype = '3' AND cod_lang = 'es_ES' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM api_properties_supertype s LEFT JOIN api_properties_supertype_i18n i ON (s.id_properties_supertype = i.id) WHERE id_properties_supertype = '3' 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 = '3' AND cod_lang = 'es_ES' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
admin	doctrine.dbal.admin_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
admin	doctrine.orm.admin_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Main\Tracking	No errors.
App\Entity\Main\Textos	No errors.
App\Entity\Main\ApiAgencyLang	No errors.
App\Entity\Main\ApiProperties	No errors.
App\Entity\Main\ApiPropertiesTypesI18n	No errors.
App\Entity\Main\ApiPropertiesCertificatesImages	No errors.
App\Entity\Main\TipusOperacio	No errors.
App\Entity\Main\ApiLocationsGps	No errors.
App\Entity\Main\ApiFeatures	No errors.
App\Entity\Main\ApiZones	No errors.
App\Entity\Main\ApiLocations	No errors.
App\Entity\Main\ApiProvinces	No errors.
App\Entity\Main\ApiAgency	No errors.
App\Entity\Main\ApiPropertiesI18n	No errors.
App\Entity\Main\ApiMenu	No errors.
App\Entity\Main\ApiOrderPages	No errors.
App\Entity\Main\ApiPages	No errors.
App\Entity\Main\ApiAgencyDescription	No errors.
App\Entity\Main\ApiPropertiesSubtypes	No errors.
App\Entity\Main\ApiPropertiesSupertype	No errors.

admin entity manager

No loaded entities.

Symfony Profiler

https://webprof.tridenia.es/es/compra/locales/barcelona/badalona/20

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

admin entity manager