1 |
SET NAMES utf8mb4
|
0.00033 |
2 |
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV4_core_users AS u INNER JOIN
oktopusV4_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV4_core_users_online AS o ON
o.ident='3.133.128.227' WHERE u.id=1
|
0.00091 |
3 |
REPLACE INTO oktopusV4_core_users_online (user_id, ident,
logged, csrf_token, prev_url) VALUES (1,'3.133.128.227',
1732170997, '6890e48df9e712fa042906a1b6928eb831f7a342',
'https://www.saintbriceimmobilier.com/agence-immobiliere-saint-brice-en-cogles')
|
0.00036 |
4 |
SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV4_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV4_mod_estate_i18n_categories_locales AS ecl ON
ecl.category_id=ec.id WHERE 1 AND ecl.language_code='fr'
AND ec.active=1
|
0.00070 |
5 |
SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV4_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV4_mod_estate_i18n_categories_locales AS ecl ON
ecl.category_id=ec.id WHERE 1 AND ecl.language_code='fr'
AND ec.active=1
|
0.00038 |
6 |
SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
oktopusV4_mod_estate_i18n_tranches AS tr WHERE 1 AND
tr.field='price' ORDER BY tr.id ASC
|
0.00047 |
7 |
SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
oktopusV4_mod_estate_i18n_tranches AS tr WHERE 1 AND
tr.field='surface_habitable' ORDER BY tr.id ASC
|
0.00038 |
8 |
SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
oktopusV4_mod_estate_i18n_tranches AS tr WHERE 1 AND
tr.field='surface_terrain' ORDER BY tr.id ASC
|
0.00041 |
9 |
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.property_type_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_property_types AS pt LEFT
JOIN oktopusV4_mod_estate_i18n_property_types_locales AS ptl
ON ptl.property_type_id=pt.id WHERE 1 AND
ptl.language_code='fr' AND pt.active=1 ORDER BY position
|
0.00064 |
10 |
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.property_type_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_property_types AS pt LEFT
JOIN oktopusV4_mod_estate_i18n_property_types_locales AS ptl
ON ptl.property_type_id=pt.id WHERE 1 AND
ptl.language_code='fr' AND pt.active=1 ORDER BY position
|
0.00040 |
11 |
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.house_type_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_house_types AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_house_types_locales AS ptl ON
ptl.house_type_id=pt.id WHERE 1 AND ptl.language_code='fr'
AND pt.active=1 ORDER BY position
|
0.00053 |
12 |
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.house_type_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_house_types AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_house_types_locales AS ptl ON
ptl.house_type_id=pt.id WHERE 1 AND ptl.language_code='fr'
AND pt.active=1 ORDER BY position
|
0.00034 |
13 |
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.content, ptl.build_quality_id,
ptl.language_code FROM
oktopusV4_mod_estate_i18n_build_qualities AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_build_qualities_locales AS ptl ON
ptl.build_quality_id=pt.id WHERE 1 AND
ptl.language_code='fr' AND pt.active=1 ORDER BY position
|
0.00048 |
14 |
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, pt.dep, pt.latitude, pt.longitude,
ptl.sector_id, ptl.language_code FROM
oktopusV4_mod_estate_i18n_sectors AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_sectors_locales AS ptl ON
ptl.sector_id=pt.id WHERE 1 AND ptl.language_code='fr' AND
pt.active=1 ORDER BY position
|
0.00060 |
15 |
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, pt.dep, pt.latitude, pt.longitude,
ptl.sector_id, ptl.language_code FROM
oktopusV4_mod_estate_i18n_sectors AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_sectors_locales AS ptl ON
ptl.sector_id=pt.id WHERE 1 AND ptl.language_code='fr' AND
pt.active=1 ORDER BY position
|
0.00038 |
16 |
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.condition_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_conditions AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_conditions_locales AS ptl ON
ptl.condition_id=pt.id WHERE 1 AND ptl.language_code='fr'
AND pt.active=1 ORDER BY position
|
0.00052 |
17 |
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.heating_type_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_heating_types AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_heating_types_locales AS ptl ON
ptl.heating_type_id=pt.id WHERE 1 AND
ptl.language_code='fr' AND pt.active=1 ORDER BY position
|
0.00068 |
18 |
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.heating_type_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_heating_types AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_heating_types_locales AS ptl ON
ptl.heating_type_id=pt.id WHERE 1 AND
ptl.language_code='fr' AND pt.active=1 ORDER BY position
|
0.00039 |
19 |
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.heating_nature_id,
ptl.language_code FROM
oktopusV4_mod_estate_i18n_heating_natures AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_heating_natures_locales AS ptl ON
ptl.heating_nature_id=pt.id WHERE 1 AND
ptl.language_code='fr' AND pt.active=1 ORDER BY position
|
0.00060 |
20 |
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.kitchen_id, ptl.language_code FROM
oktopusV4_mod_estate_i18n_kitchens AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_kitchens_locales AS ptl ON
ptl.kitchen_id=pt.id WHERE 1 AND ptl.language_code='fr' AND
pt.active=1 ORDER BY position
|
0.00047 |
21 |
SELECT o.id, o.user_id_created, o.user_id_updated,
o.lastname, o.firstname, o.adress, o.zip, o.city, o.tel,
o.gsm_tel_1, o.gsm_tel_2, o.fax, o.mail, o.comments,
o.active, o.position, o.created_at, o.updated_at FROM
oktopusV4_mod_estate_i18n_owners AS o WHERE 1 AND o.active=1
ORDER BY lastname
|
0.00063 |
22 |
SELECT f.id, f.active, f.type, f.category, f.ord, f.html_id,
f.colonne, f.picto, f.options, f.info_personnelle, fl.title,
fl.legend, fl.description, fl.value FROM
oktopusV4_mod_contact_fields f LEFT JOIN
oktopusV4_mod_contact_fields_locales AS fl ON
fl.field_id=f.id AND fl.category=f.category WHERE 1 AND
f.active>0 AND f.category = "contact" AND fl.language='fr'
ORDER BY ord ASC
|
0.00292 |
23 |
SELECT COUNT(m.id) AS num_elem FROM
oktopusV4_mod_map_element AS m WHERE 1 AND m.id_map = 1
AND m.type = "route" AND m.active=1
|
0.00170 |
24 |
SELECT m.*,
ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM oktopusV4_mod_map AS m
LEFT JOIN oktopusV4_mod_map_locales AS ml ON m.id=ml.id_map
AND ml.language='fr' WHERE 1 AND m.id = 1 AND
ml.language='fr' AND m.active=1 ORDER BY m.created_at DESC
|
0.00116 |