SOLDES : C'est parti pour des offres de folie ! JUSQU'À -60% et -15% EXTRA ! J'en profite avec le code : CPARTI15 !

  • Agence de l’Europe
  • Agence de l’Europe
  • Agence de l’Europe
  • Agence de l’Europe

Résultat(s) de la recherche

  • Mémoire utilisée par PHP : 3,69 Mo
  • Pic mémoire allouée par PHP : 4,79 Mo
  • Temps d'execution du script : 0.659 s
  • Lang :
  • Path : catalogue
  • Route : mosaicRubriqueBase
  • $okt->page->module : mosaic
  • $okt->page->action :
  • Title tag : Résultat(s) de la recherche - Agence de l'Europe
  • Title:
  • H1: Résultat(s) de la recherche
  • Meta description:
  • Meta keyword:
ID Query Time
1
SET NAMES utf8mb4
0.00026
2
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV5_core_users AS u INNER JOIN
oktopusV5_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV5_core_users_online AS o ON
o.ident='44.222.104.206' WHERE u.id=1
0.00118
3
UPDATE oktopusV5_core_users_online SET logged=1716514824,
prev_url='https://www.agencedeleurope-vichy.fr/catalogue'
WHERE ident='44.222.104.206'
0.00032
4
SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV5_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV5_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.00048
5
SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV5_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV5_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.00037
6
SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
oktopusV5_mod_estate_i18n_tranches AS tr WHERE 1  AND
tr.field='price' ORDER BY tr.id ASC 
0.00026
7
SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
oktopusV5_mod_estate_i18n_tranches AS tr WHERE 1  AND
tr.field='surface_habitable' ORDER BY tr.id ASC 
0.00018
8
SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
oktopusV5_mod_estate_i18n_tranches AS tr WHERE 1  AND
tr.field='surface_terrain' ORDER BY tr.id ASC 
0.00015
9
SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV5_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV5_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.00029
10
SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "property_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 
0.00023
11
SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "house_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 
0.00020
12
SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "purchase_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 
0.00016
13
SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "rental_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 
0.00020
14
SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "lease_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 
0.00016
15
SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "sector" AND dtl.language_code='fr' AND dt.active=1 ORDER
BY position 
0.00027
16
SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "environment" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 
0.00023
17
SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "kitchen" AND dtl.language_code='fr' AND dt.active=1 ORDER
BY position 
0.00023
18
SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "heating_type" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 
0.00018
19
SELECT dt.*, dtl.* FROM oktopusV5_mod_estate_i18n_data_types
AS dt LEFT JOIN oktopusV5_mod_estate_i18n_data_types_locales
AS dtl ON dtl.data_type_id = dt.id WHERE 1  AND dt.data_type
= "particularity" AND dtl.language_code='fr' AND dt.active=1
ORDER BY position 
0.00039
20
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
oktopusV5_mod_estate_i18n_owners AS o WHERE 1 AND o.active=1
ORDER BY lastname 
0.00028
21
SELECT r.*, rl.*, COUNT(p.id) AS num_items FROM
oktopusV5_mod_galleries AS r LEFT JOIN
oktopusV5_mod_galleries_locales AS rl ON r.id=rl.gallery_id
LEFT JOIN oktopusV5_mod_galleries_items AS p ON
r.id=p.gallery_id WHERE 1 AND rl.language='fr' AND
r.active=1  GROUP BY r.id ORDER BY nleft asc 
0.00045
22
SELECT m.*, 
                              ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM oktopusV5_mod_map AS m 
LEFT JOIN oktopusV5_mod_map_locales AS ml ON m.id=ml.id_map
AND ml.language='fr' WHERE 1  AND ml.language='fr' AND
m.active=1 ORDER BY m.created_at DESC 
0.00037
23
SELECT r.*, rl.*, COUNT(r.id_rubrique) AS num_posts FROM
oktopusV5_mod_mosaic_rubrique AS r LEFT JOIN
oktopusV5_mod_mosaic_rubrique_locales AS rl ON r.id_rubrique
= rl.id_rubrique WHERE 1 AND rl.language='fr' AND r.actif =
1  GROUP BY r.id_rubrique ORDER BY nleft asc 
0.00020
24
SELECT DISTINCT snr.*, snrl.*, 
                            DATE_FORMAT(snr.created_at,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                            DATE_FORMAT(snr.updated_at,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                      FROM
oktopusV5_mod_social_network_reseau snr
                      JOIN
oktopusV5_mod_social_network_reseau_locales snrl ON
snrl.id_reseau = snr.id_reseau AND snrl.language = 'fr'
WHERE 1  AND active = '1' ORDER BY snrl.libelle
0.00032
25
SELECT p.id, p.user_id, p.category_id, p.active,
p.created_at, p.updated_at, p.images, p.files, p.tpl,
p.position, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.meta_description, pl.meta_keywords, pl.words, rl.title AS
category_title, rl.slug AS category_slug, rl.title_tag AS
category_title_tag, r.items_tpl AS category_items_tpl FROM
oktopusV5_mod_pages AS p  INNER JOIN
oktopusV5_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='fr'  LEFT OUTER JOIN
oktopusV5_mod_pages_categories AS r ON r.id=p.category_id 
LEFT OUTER JOIN oktopusV5_mod_pages_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.created_at DESC 
0.00032
26
SELECT id, language, valeur FROM
oktopusV5_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
0.00482
27
 SELECT DISTINCT m.nom AS nomMarque, m.image AS imageMarque,
mo.nom AS nomModele, p.*, pl.*, 
                            IF(1, promo, NOW() BETWEEN
debut_promo AND fin_promo) AS promo,
                            IF(1, nouveaute, NOW() BETWEEN
debut_nouveaute AND fin_nouveaute) AS nouveaute,
                            IF(1, phare, NOW() BETWEEN
debut_phare AND fin_phare) AS phare,
                            IF(1, solde, NOW() BETWEEN
debut_solde AND fin_solde) AS solde,
							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 oktopusV5_mod_mosaic_produit
p
                           JOIN
oktopusV5_mod_mosaic_produit_locales pl ON pl.id_produit =
p.id_produit AND pl.language = 'fr' LEFT JOIN
oktopusV5_mod_mosaic_marque m ON p.id_marque = m.id_marque
                           LEFT JOIN
oktopusV5_mod_mosaic_modele mo ON p.id_modele =
mo.id_modele
                           LEFT JOIN
oktopusV5_mod_mosaic_produit_rubrique pr ON pr.id_produit =
p.id_produit
                           WHERE 1 ORDER BY nom
0.00945
28
SELECT COUNT(p.id_produit) FROM
oktopusV5_mod_mosaic_rubrique r,
oktopusV5_mod_mosaic_rubrique_locales rl,
oktopusV5_mod_mosaic_produit_rubrique pr,
oktopusV5_mod_mosaic_produit p,
oktopusV5_mod_mosaic_produit_locales pl
                        WHERE r.id_rubrique =
pr.id_rubrique
                        AND r.id_rubrique = rl.id_rubrique
                        AND rl.language = 'fr'
						AND p.id_produit = pr.id_produit
                        AND p.id_produit = pl.id_produit
                        AND pl.language = 'fr'  AND
pr.id_rubrique = '0' AND p.actif = '1' AND r.actif = '1' 
0.00080
29
SELECT id, language, valeur FROM
oktopusV5_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
0.00022
30
 SELECT DISTINCT m.nom AS nomMarque, m.image AS imageMarque,
mo.nom AS nomModele, p.*, pl.*, 
                            IF(1, promo, NOW() BETWEEN
debut_promo AND fin_promo) AS promo,
                            IF(1, nouveaute, NOW() BETWEEN
debut_nouveaute AND fin_nouveaute) AS nouveaute,
                            IF(1, phare, NOW() BETWEEN
debut_phare AND fin_phare) AS phare,
                            IF(1, solde, NOW() BETWEEN
debut_solde AND fin_solde) AS solde,
							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 oktopusV5_mod_mosaic_produit
p
                           JOIN
oktopusV5_mod_mosaic_produit_locales pl ON pl.id_produit =
p.id_produit AND pl.language = 'fr' LEFT JOIN
oktopusV5_mod_mosaic_marque m ON p.id_marque = m.id_marque
                           LEFT JOIN
oktopusV5_mod_mosaic_modele mo ON p.id_modele =
mo.id_modele
                           LEFT JOIN
oktopusV5_mod_mosaic_produit_rubrique pr ON pr.id_produit =
p.id_produit
                           WHERE 1 ORDER BY nom
0.00148
31
SELECT COUNT(p.id_produit) FROM
oktopusV5_mod_mosaic_rubrique r,
oktopusV5_mod_mosaic_rubrique_locales rl,
oktopusV5_mod_mosaic_produit_rubrique pr,
oktopusV5_mod_mosaic_produit p,
oktopusV5_mod_mosaic_produit_locales pl
                        WHERE r.id_rubrique =
pr.id_rubrique
                        AND r.id_rubrique = rl.id_rubrique
                        AND rl.language = 'fr'
						AND p.id_produit = pr.id_produit
                        AND p.id_produit = pl.id_produit
                        AND pl.language = 'fr'  AND
pr.id_rubrique = '0' AND p.actif = '1' AND r.actif = '1' 
0.00016
32
SELECT * FROM oktopusV5_mod_mosaic_declinaison WHERE 1 AND
actif = '1' ORDER BY position
0.00376
33
 SELECT dc.* 
                                FROM
oktopusV5_mod_mosaic_declinaison_champ AS dc 
                                WHERE 1 AND dc.actif = '1'
ORDER BY dc.position
0.00191
34
SELECT r.*, rl.*, COUNT(r.id_rubrique) AS num_posts FROM
oktopusV5_mod_mosaic_rubrique AS r LEFT JOIN
oktopusV5_mod_mosaic_rubrique_locales AS rl ON r.id_rubrique
= rl.id_rubrique WHERE 1 AND rl.language='fr' AND r.actif =
1  GROUP BY r.id_rubrique ORDER BY nleft asc 
0.00047
35
 SELECT t.*,
                            DATE_FORMAT(t.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                            DATE_FORMAT(t.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                       FROM oktopusV5_mod_slideshow_type t
                       WHERE 1 AND CASE 
                                       WHEN t.choix_rubrique
= 1 THEN
                                           t.rubrique LIKE
'%\'/catalogue\'%'
                                       WHEN t.choix_rubrique
= 2 THEN
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV5_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE '%\'/catalogue\'%' AND t.actif = 1
                   ) = 0
                
                                           AND
                                           t.rubrique NOT
LIKE '%\'/catalogue\'%'
                                       ELSE     
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV5_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE '%\'/catalogue\'%' AND t.actif = 1
                   ) = 0
                 
                                   END AND actif = '1' ORDER
BY nom 
0.00112
36
SELECT t.*, 
                        DATE_FORMAT(t.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                        DATE_FORMAT(t.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr 
                     FROM oktopusV5_mod_slideshow_type t
                     WHERE t.id_type = '2'
0.00026
37
 SELECT p.*, pl.valeur AS legende, pl.lien,
pl.contenu_titre,  pl.contenu_ss_titre,
pl.contenu_description, pl.primaire_texte,
pl.primaire_texte_mobile, pl.secondaire_texte,
pl.secondaire_texte_mobile, pl.primaire_slug,
pl.secondaire_slug, pl.lien2,  
                          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 oktopusV5_mod_slideshow p
                       LEFT JOIN
oktopusV5_mod_slideshow_locales pl ON pl.id_slideshow =
p.id_slideshow AND pl.language = 'fr'
                       WHERE 1 AND p.actif = '1' AND id_type
= '2' ORDER BY position
0.00033
38
SELECT DISTINCT r.*, rl.*
                      FROM oktopusV5_mod_mosaic_reassurance
r
                      JOIN
oktopusV5_mod_mosaic_reassurance_locales rl ON
rl.id_reassurance = r.id_reassurance AND rl.language = 'fr'
WHERE 1  AND (r.placement LIKE '%H%' ) ORDER BY r.position
0.00042
39
SELECT DISTINCT r.*, rl.*
                      FROM oktopusV5_mod_mosaic_reassurance
r
                      JOIN
oktopusV5_mod_mosaic_reassurance_locales rl ON
rl.id_reassurance = r.id_reassurance AND rl.language = 'fr'
WHERE 1  AND (r.placement LIKE '%B%' ) ORDER BY r.position
0.00026
40
SELECT DISTINCT sn.*, snl.*
                      FROM oktopusV5_mod_social_network sn
                      JOIN
oktopusV5_mod_social_network_locales snl ON
snl.id_social_network = sn.id_social_network AND
snl.language = 'fr' WHERE 1  AND sn.url != '' AND sn.type !=
''  AND type LIKE '%F%' ORDER BY sn.position
0.00044
41
SELECT p.*, pl.*,
                         DATE_FORMAT(p.debut, '%d/%m/%Y') as
debut_fr,
                         DATE_FORMAT(p.fin, '%d/%m/%Y') as
fin_fr,
                         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 oktopusV5_mod_home_popup p
                      LEFT JOIN
oktopusV5_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'fr'
                      WHERE 1 AND (
                                        CURDATE() BETWEEN
p.debut AND p.fin
                                        OR (p.debut =
'0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00')
                                    )AND pl.content <> ''
AND (p.rubrique = '' OR p.rubrique LIKE '%\'/catalogue\'%')
ORDER BY p.rubrique DESC
0.00089
42
SELECT p.*, pl.*,
                         DATE_FORMAT(p.debut, '%d/%m/%Y') as
debut_fr,
                         DATE_FORMAT(p.fin, '%d/%m/%Y') as
fin_fr,
                         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 oktopusV5_mod_home_popup p
                      LEFT JOIN
oktopusV5_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'fr'
                      WHERE 1 AND (
                                        CURDATE() BETWEEN
p.debut AND p.fin
                                        OR (p.debut =
'0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00')
                                    )AND pl.content <> ''
AND (p.rubrique = '' OR p.rubrique LIKE '%\'/catalogue\'%')
ORDER BY p.rubrique DESC
0.00082
# type fichier ligne classe fonction message