| 1 |
SET NAMES utf8mb4
|
0.00013 |
| 2 |
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
okto_core_users AS u INNER JOIN okto_core_users_groups AS g
ON g.group_id=u.group_id LEFT JOIN okto_core_users_online AS
o ON o.ident='3.235.108.188' WHERE u.id=1
|
0.00266 |
| 3 |
UPDATE okto_core_users_online SET logged=1614808274,
prev_url='https://www.geoclisson.com/ventes-locations' WHERE
ident='3.235.108.188'
|
0.00024 |
| 4 |
SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
okto_mod_estate_i18n_categories AS ec LEFT JOIN
okto_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.00241 |
| 5 |
SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
okto_mod_estate_i18n_categories AS ec LEFT JOIN
okto_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.00024 |
| 6 |
SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
okto_mod_estate_i18n_tranches AS tr WHERE 1 AND
tr.field='price' ORDER BY tr.id ASC
|
0.00239 |
| 7 |
SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
okto_mod_estate_i18n_tranches AS tr WHERE 1 AND
tr.field='surface_habitable' ORDER BY tr.id ASC
|
0.00022 |
| 8 |
SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
okto_mod_estate_i18n_tranches AS tr WHERE 1 AND
tr.field='surface_terrain' ORDER BY tr.id ASC
|
0.00028 |
| 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 okto_mod_estate_i18n_property_types AS pt LEFT JOIN
okto_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.00126 |
| 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 okto_mod_estate_i18n_property_types AS pt LEFT JOIN
okto_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.00011 |
| 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 okto_mod_estate_i18n_house_types AS pt LEFT JOIN
okto_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.00041 |
| 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 okto_mod_estate_i18n_house_types AS pt LEFT JOIN
okto_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.00009 |
| 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 okto_mod_estate_i18n_build_qualities
AS pt LEFT JOIN okto_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.00110 |
| 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
okto_mod_estate_i18n_sectors AS pt LEFT JOIN
okto_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.00151 |
| 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
okto_mod_estate_i18n_sectors AS pt LEFT JOIN
okto_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.00015 |
| 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 okto_mod_estate_i18n_conditions AS pt LEFT JOIN
okto_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.00163 |
| 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 okto_mod_estate_i18n_heating_types AS pt LEFT JOIN
okto_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.00168 |
| 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 okto_mod_estate_i18n_heating_types AS pt LEFT JOIN
okto_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.00012 |
| 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 okto_mod_estate_i18n_heating_natures
AS pt LEFT JOIN okto_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.00119 |
| 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
okto_mod_estate_i18n_kitchens AS pt LEFT JOIN
okto_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.00113 |
| 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
okto_mod_estate_i18n_owners AS o WHERE 1 AND o.active=1
ORDER BY lastname
|
0.00102 |
| 22 |
UPDATE okto_mod_news SET active = 1
WHERE active = 3 AND NOW() >
created_at
|
0.00152 |
| 23 |
UPDATE okto_mod_news SET active = 0
WHERE active = 1 AND end_at !=
"0000-00-00 00:00:00"
AND NOW() > end_at
|
0.00019 |
| 24 |
SELECT COUNT(e.id) AS num_items FROM okto_mod_estate_i18n AS
e LEFT JOIN okto_mod_estate_i18n_locales AS el ON
el.estate_i18n_id=e.id LEFT JOIN
okto_mod_estate_i18n_categories_items AS eci ON
eci.estate_i18n_id=e.id LEFT JOIN
okto_mod_estate_i18n_legislations_items AS eli ON
eli.category_id=e.category_id WHERE 1 AND
el.language_code='fr' AND (e.vendu_loue=0) AND e.active=1
|
0.00481 |
| 25 |
SELECT e.id, e.user_id_created, e.user_id_updated,
e.position, e.created_at, e.updated_at, e.reference,
e.num_mandat, e.date_achat, e.date_mandat, e.property_type,
e.house_type, e.type_transaction, e.created_at,
e.updated_at, e.active, e.prix_en_baisse, e.reduction,
e.nouveaute, e.nouveaute_accueil, e.coup_de_coeur,
e.coup_de_coeur_accueil, e.exclusivite,
e.exclusivite_accueil, e.vendu_loue, e.compromis, e.status,
e.images_url, e.build_quality, e.adress, e.code_postal,
e.ville, e.sector, e.departement, e.code_postal_web,
e.ville_web, e.coordonnees_gps, e.distance_to_shops,
e.distance_to_forest, e.distance_to_sea,
e.distance_to_mountain, e.distance_to_golf, e.price,
e.price_unit, e.fai, e.commission, e.taxe_fonciere,
e.taxe_habitation, e.charges, e.honoraires,
e.pourcentage_honoraire, e.frais_agence,
e.provisions_charges, e.depot_garantie, e.hc_cc,
e.type_affichage_honoraire, e.surface_habitable,
e.surface_terrain, e.surface_carrez, e.surface_sejour,
e.etage, e.nbre_etages, e.plain_pied, e.annee_construction,
e.condition, e.nbre_pieces, e.nbre_chambres,
e.nbre_salles_bain, e.nbre_salles_eau, e.nbre_wc,
e.heating_type, e.heating_nature, e.meuble,
e.handicap_adapt, e.cuisine_equipee, e.with_terrasse,
e.with_garden, e.terrasses_number, e.with_parking,
e.parking_int_number, e.parking_ext_number, e.with_garage,
e.garages_box_number, e.lotissement, e.nbre_murs_mitoyens,
e.suite_parentale, e.kitchen, e.swimming_pool, e.cellar,
e.balcony, e.air_conditioning, e.veranda, e.terrain_tennis,
e.box_chevaux, e.four_pain, e.cellier, e.adsl, e.puit,
e.cheminee, e.buanderie, e.bureau, e.ramassage_scolaire,
e.sia, e.dressing, e.gardien, e.interphone, e.ascenseur,
e.alarme, e.niveaux, e.dependances, e.anciennete, e.dpe,
e.dpe_val, e.ges, e.ges_val, e.cu, e.frais_plan_bornage,
e.provisions_ass_syndic, e.shon, e.eau_terrain,
e.electricite_terrain, e.tout_a_egout_terrain,
e.telecommunication_terrain, e.gaz_terrain, e.viabilise,
e.depot_permis_construire, e.coef_cos, e.emprise_au_sol,
e.lot_number, e.parcel_number, e.owner, e.residence_name,
e.syndic, e.keys, e.map, e.appreciation, e.comments,
e.is_from_gateway, e.is_update_from_gateway, e.images,
e.files, el.estate_i18n_id, el.language_code, el.title,
el.style, el.exposition, el.environment, el.view,
el.short_content, el.long_content, el.assainissement,
el.heating_mode, el.usages, el.bail_type, el.bail_duration,
el.cuisine, el.garden_infos, el.terrasse_infos,
el.services_proximite, el.dependance, el.title_tag,
el.meta_description, el.title_seo, el.meta_keywords,
el.slug, eci.category_id, eci.estate_i18n_id FROM
okto_mod_estate_i18n AS e LEFT JOIN
okto_mod_estate_i18n_locales AS el ON el.estate_i18n_id=e.id
LEFT JOIN okto_mod_estate_i18n_categories_items AS eci ON
eci.estate_i18n_id=e.id LEFT JOIN
okto_mod_estate_i18n_legislations_items AS eli ON
eli.category_id=e.category_id LEFT JOIN okto_core_users AS u
ON u.id=e.user_id_updated WHERE 1 AND el.language_code='fr'
AND (e.vendu_loue=0) AND e.active=1 ORDER BY el.title ASC
LIMIT 0,10
|
0.00218 |
| 26 |
SELECT e.id, e.user_id_created, e.user_id_updated,
e.position, e.created_at, e.updated_at, e.reference,
e.num_mandat, e.date_achat, e.date_mandat, e.property_type,
e.house_type, e.type_transaction, e.created_at,
e.updated_at, e.active, e.prix_en_baisse, e.reduction,
e.nouveaute, e.nouveaute_accueil, e.coup_de_coeur,
e.coup_de_coeur_accueil, e.exclusivite,
e.exclusivite_accueil, e.vendu_loue, e.compromis, e.status,
e.images_url, e.build_quality, e.adress, e.code_postal,
e.ville, e.sector, e.departement, e.code_postal_web,
e.ville_web, e.coordonnees_gps, e.distance_to_shops,
e.distance_to_forest, e.distance_to_sea,
e.distance_to_mountain, e.distance_to_golf, e.price,
e.price_unit, e.fai, e.commission, e.taxe_fonciere,
e.taxe_habitation, e.charges, e.honoraires,
e.pourcentage_honoraire, e.frais_agence,
e.provisions_charges, e.depot_garantie, e.hc_cc,
e.type_affichage_honoraire, e.surface_habitable,
e.surface_terrain, e.surface_carrez, e.surface_sejour,
e.etage, e.nbre_etages, e.plain_pied, e.annee_construction,
e.condition, e.nbre_pieces, e.nbre_chambres,
e.nbre_salles_bain, e.nbre_salles_eau, e.nbre_wc,
e.heating_type, e.heating_nature, e.meuble,
e.handicap_adapt, e.cuisine_equipee, e.with_terrasse,
e.with_garden, e.terrasses_number, e.with_parking,
e.parking_int_number, e.parking_ext_number, e.with_garage,
e.garages_box_number, e.lotissement, e.nbre_murs_mitoyens,
e.suite_parentale, e.kitchen, e.swimming_pool, e.cellar,
e.balcony, e.air_conditioning, e.veranda, e.terrain_tennis,
e.box_chevaux, e.four_pain, e.cellier, e.adsl, e.puit,
e.cheminee, e.buanderie, e.bureau, e.ramassage_scolaire,
e.sia, e.dressing, e.gardien, e.interphone, e.ascenseur,
e.alarme, e.niveaux, e.dependances, e.anciennete, e.dpe,
e.dpe_val, e.ges, e.ges_val, e.cu, e.frais_plan_bornage,
e.provisions_ass_syndic, e.shon, e.eau_terrain,
e.electricite_terrain, e.tout_a_egout_terrain,
e.telecommunication_terrain, e.gaz_terrain, e.viabilise,
e.depot_permis_construire, e.coef_cos, e.emprise_au_sol,
e.lot_number, e.parcel_number, e.owner, e.residence_name,
e.syndic, e.keys, e.map, e.appreciation, e.comments,
e.is_from_gateway, e.is_update_from_gateway, e.images,
e.files, el.estate_i18n_id, el.language_code, el.title,
el.style, el.exposition, el.environment, el.view,
el.short_content, el.long_content, el.assainissement,
el.heating_mode, el.usages, el.bail_type, el.bail_duration,
el.cuisine, el.garden_infos, el.terrasse_infos,
el.services_proximite, el.dependance, el.title_tag,
el.meta_description, el.title_seo, el.meta_keywords,
el.slug, eci.category_id, eci.estate_i18n_id FROM
okto_mod_estate_i18n AS e LEFT JOIN
okto_mod_estate_i18n_locales AS el ON el.estate_i18n_id=e.id
LEFT JOIN okto_mod_estate_i18n_categories_items AS eci ON
eci.estate_i18n_id=e.id LEFT JOIN
okto_mod_estate_i18n_legislations_items AS eli ON
eli.category_id=e.category_id LEFT JOIN okto_core_users AS u
ON u.id=e.user_id_updated WHERE 1 AND e.id NOT IN
(40,41,38,39,37) AND el.language_code='fr' AND
(e.vendu_loue=0) AND e.active=1 ORDER BY el.title ASC LIMIT
0,2
|
0.00073 |
| 27 |
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 okto_mod_estate_i18n_property_types AS pt LEFT JOIN
okto_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.00142 |
| 28 |
SELECT p.id, p.user_id, p.category_id, p.active, p.selected,
p.created_at, p.updated_at, p.end_at, p.images, p.files,
p.tpl, p.visit, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.meta_description, pl.meta_keywords, pl.words, u.username,
u.lastname, u.firstname, rl.title AS category_title, rl.slug
AS category_slug, r.items_tpl AS category_items_tpl FROM
okto_mod_news AS p LEFT OUTER JOIN okto_core_users AS u ON
u.id=p.user_id INNER JOIN okto_mod_news_locales AS pl ON
p.id=pl.post_id AND pl.language='fr' LEFT OUTER JOIN
okto_mod_news_categories AS r ON r.id=p.category_id LEFT
OUTER JOIN okto_mod_news_categories_locales AS rl ON
r.id=rl.category_id AND rl.language='fr' WHERE 1 AND
pl.language='fr' AND p.active=1 ORDER BY p.selected DESC,
p.created_at DESC LIMIT 10
|
0.00276 |
| 29 |
SELECT t.*, tl.rubrique_slug FROM okto_mod_slideshow_type t
LEFT JOIN
okto_mod_slideshow_type_locales tl ON tl.id_type = t.id_type
AND tl.language = 'fr'
WHERE 1 AND
FIND_IN_SET('/ventes-locations', tl.rubrique_slug) > 0 ORDER
BY nom
|
0.00221 |
| 30 |
SELECT t.*, tl.* FROM okto_mod_slideshow_type t
LEFT JOIN
okto_mod_slideshow_type_locales tl ON tl.id_type = t.id_type
AND tl.language = 'fr'
WHERE t.id_type = '1'
|
0.00024 |
| 31 |
SELECT p.*, pl.valeur AS legende, pl.lien,
DATE_FORMAT(p.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
DATE_FORMAT(p.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
FROM okto_mod_slideshow p
LEFT JOIN okto_mod_slideshow_locales
pl ON pl.id_slideshow = p.id_slideshow AND pl.language =
'fr'
WHERE 1 AND p.actif = '1' AND id_type
= '1' ORDER BY position
|
0.00076 |
