• Marais Salant La Nouvelle Brille

 

Profiler (0,369 s)

Requêtes (151)

Erreurs (0)

  • Mémoire utilisée par PHP : 2,92 Mo
  • Pic mémoire allouée par PHP : 4,28 Mo
  • Temps d'execution du script : 0.369 s
  • Lang :
  • Path : gros-sel-naturel-2
  • Route : mosaicRubrique
  • $okt->page->module : mosaic
  • $okt->page->action :
  • Title tag : Gros Sel Naturel et Aromatisé - Catalogue - Marais Salant La Nouvelle Brille
  • Title:
  • H1: Gros Sel Naturel et Aromatisé
  • Meta description: Gros Sel Marin Naturel, Gros Sel Marin Sel Fou, Gros Sel Marin Barbecue, Gros Sel Marin Court Bouillon Poisson, Gros Sel Marin Grillade, Gros Sel Marin Poivre, Gros Sel Marin Spécial Légume, Gros Se
  • Meta keyword:
ID Query Time
1 
SET NAMES utf8mb4
 0.00010
2 
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV1_core_users AS u INNER JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV1_core_users_online AS o ON
o.ident='0231e6688b01229f07d2423110789e5a43517e563ffb5ee23dcc3beb128bc944'
WHERE u.id=1
 0.00060
3 
UPDATE oktopusV1_core_users_online SET logged=1759651837,
prev_url='https://www.marais-salant.fr/gros-sel-naturel-2'
WHERE
ident='0231e6688b01229f07d2423110789e5a43517e563ffb5ee23dcc3beb128bc944'
 0.00017
4 
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
 0.00053
5 
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
 0.00022
6 
SELECT setting_name, setting_value FROM
oktopusV1_mod_oktopusagent_settings
 0.00007
7 
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
 0.00018
8 
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
 0.00018
9 
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
 0.00018
10 
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
 0.00018
11 
SELECT COUNT(id_rubrique) FROM oktopusV1_mod_mosaic_rubrique
WHERE id_rubrique = '2'
0.00054
12 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00049
13 
SELECT r.*, rl.*, COUNT(p.id) AS num_items FROM
oktopusV1_mod_galleries AS r LEFT JOIN
oktopusV1_mod_galleries_locales AS rl ON r.id=rl.gallery_id
LEFT JOIN oktopusV1_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.00031
14 
SELECT m.*, 
                              ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM oktopusV1_mod_map AS m 
LEFT JOIN oktopusV1_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.00032
15 
SELECT r.*, rl.*, COUNT(r.id_rubrique) AS num_posts FROM
oktopusV1_mod_mosaic_rubrique AS r LEFT JOIN
oktopusV1_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.00014
16 
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
oktopusV1_mod_social_network_reseau snr
                      JOIN
oktopusV1_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.00016
17 
SELECT p.id, p.original_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
oktopusV1_mod_pages AS p  INNER JOIN
oktopusV1_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='fr'  LEFT OUTER JOIN
oktopusV1_mod_pages_categories AS r ON r.id=p.category_id 
LEFT OUTER JOIN oktopusV1_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.00024
18 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00032
19 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
 0.00038
20 
 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 oktopusV1_mod_mosaic_produit
p
                           JOIN
oktopusV1_mod_mosaic_produit_locales pl ON pl.id_produit =
p.id_produit AND pl.language = 'fr' LEFT JOIN
oktopusV1_mod_mosaic_marque m ON p.id_marque = m.id_marque
                           LEFT JOIN
oktopusV1_mod_mosaic_modele mo ON p.id_modele =
mo.id_modele
                           LEFT JOIN
oktopusV1_mod_mosaic_produit_rubrique pr ON pr.id_produit =
p.id_produit
                           WHERE 1 ORDER BY nom
 0.00470
21 
SELECT COUNT(p.id_produit) FROM
oktopusV1_mod_mosaic_rubrique r,
oktopusV1_mod_mosaic_rubrique_locales rl,
oktopusV1_mod_mosaic_produit_rubrique pr,
oktopusV1_mod_mosaic_produit p,
oktopusV1_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 = '2' AND p.actif = '1' AND r.actif = '1'
0.00304
22 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
 0.00012
23 
 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 oktopusV1_mod_mosaic_produit
p
                           JOIN
oktopusV1_mod_mosaic_produit_locales pl ON pl.id_produit =
p.id_produit AND pl.language = 'fr' LEFT JOIN
oktopusV1_mod_mosaic_marque m ON p.id_marque = m.id_marque
                           LEFT JOIN
oktopusV1_mod_mosaic_modele mo ON p.id_modele =
mo.id_modele
                           LEFT JOIN
oktopusV1_mod_mosaic_produit_rubrique pr ON pr.id_produit =
p.id_produit
                           WHERE 1 ORDER BY nom
 0.00331
24 
SELECT COUNT(p.id_produit) FROM
oktopusV1_mod_mosaic_rubrique r,
oktopusV1_mod_mosaic_rubrique_locales rl,
oktopusV1_mod_mosaic_produit_rubrique pr,
oktopusV1_mod_mosaic_produit p,
oktopusV1_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 = '2' AND p.actif = '1' AND r.actif = '1'
0.00010
25 
SELECT pr.*, rl.slug, IF(1, p.nouveaute, NOW() BETWEEN
p.debut_nouveaute AND p.fin_nouveaute) AS nouveaute  FROM
oktopusV1_mod_mosaic_rubrique r,
oktopusV1_mod_mosaic_rubrique_locales rl,
oktopusV1_mod_mosaic_produit_rubrique pr,
oktopusV1_mod_mosaic_produit p,
oktopusV1_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 = '2' AND p.actif = '1' AND r.actif = '1' 
ORDER BY pr.position ASC LIMIT 0,20
 0.00152
26 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00014
27 
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '9' ORDER BY position
0.00030
28 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00013
29 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'declinaison'
 0.00010
30 
 SELECT pd.*, p.id_tva,
                        IF(1, promo, NOW() BETWEEN
p.debut_promo AND p.fin_promo) AS promo,
                        IF(1, solde, NOW() BETWEEN
p.debut_solde AND p.fin_solde) AS solde 
                        FROM
oktopusV1_mod_mosaic_produit_declinaison AS pd
                        LEFT JOIN
oktopusV1_mod_mosaic_produit as p ON p.id_produit =
pd.id_produit
						WHERE 1 AND pd.id_produit = '9' ORDER BY
pd.id_produit_declinaison
0.00042
31 
 SELECT pdc.*, dc.id_declinaison
						FROM oktopusV1_mod_mosaic_produit_declinaison_champ AS
pdc 
						LEFT JOIN oktopusV1_mod_mosaic_declinaison_champ AS dc
ON dc.id_declinaison_champ= pdc.id_declinaison_champ
						LEFT JOIN oktopusV1_mod_mosaic_declinaison AS d ON
d.id_declinaison = dc.id_declinaison
						WHERE 1 AND pdc.id_produit_declinaison = '58' ORDER BY
pdc.id_produit_declinaison_champ
0.00217
32 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'declinaison_champ'
 0.00031
33 
 SELECT pdc.*, dc.id_declinaison
						FROM oktopusV1_mod_mosaic_produit_declinaison_champ AS
pdc 
						LEFT JOIN oktopusV1_mod_mosaic_declinaison_champ AS dc
ON dc.id_declinaison_champ= pdc.id_declinaison_champ
						LEFT JOIN oktopusV1_mod_mosaic_declinaison AS d ON
d.id_declinaison = dc.id_declinaison
						WHERE 1 AND pdc.id_produit_declinaison = '59' ORDER BY
pdc.id_produit_declinaison_champ
0.00030
34 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '9'
 0.00033
35 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00009
36 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00007
37 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '9'
 0.00017
38 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00010
39 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00007
40 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00007
41 
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '10' ORDER BY position
0.00029
42 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00009
43 
 SELECT pd.*, p.id_tva,
                        IF(1, promo, NOW() BETWEEN
p.debut_promo AND p.fin_promo) AS promo,
                        IF(1, solde, NOW() BETWEEN
p.debut_solde AND p.fin_solde) AS solde 
                        FROM
oktopusV1_mod_mosaic_produit_declinaison AS pd
                        LEFT JOIN
oktopusV1_mod_mosaic_produit as p ON p.id_produit =
pd.id_produit
						WHERE 1 AND pd.id_produit = '10' ORDER BY
pd.id_produit_declinaison
0.00027
44 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '10'
 0.00023
45 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00009
46 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00006
47 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '10'
 0.00015
48 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00014
49 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00010
50 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00008
51 
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '11' ORDER BY position
0.00026
52 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00007
53 
 SELECT pd.*, p.id_tva,
                        IF(1, promo, NOW() BETWEEN
p.debut_promo AND p.fin_promo) AS promo,
                        IF(1, solde, NOW() BETWEEN
p.debut_solde AND p.fin_solde) AS solde 
                        FROM
oktopusV1_mod_mosaic_produit_declinaison AS pd
                        LEFT JOIN
oktopusV1_mod_mosaic_produit as p ON p.id_produit =
pd.id_produit
						WHERE 1 AND pd.id_produit = '11' ORDER BY
pd.id_produit_declinaison
0.00023
54 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '11'
 0.00017
55 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00008
56 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00006
57 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '11'
 0.00021
58 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00012
59 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00008
60 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00019
61 
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '12' ORDER BY position
0.00028
62 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00009
63 
 SELECT pd.*, p.id_tva,
                        IF(1, promo, NOW() BETWEEN
p.debut_promo AND p.fin_promo) AS promo,
                        IF(1, solde, NOW() BETWEEN
p.debut_solde AND p.fin_solde) AS solde 
                        FROM
oktopusV1_mod_mosaic_produit_declinaison AS pd
                        LEFT JOIN
oktopusV1_mod_mosaic_produit as p ON p.id_produit =
pd.id_produit
						WHERE 1 AND pd.id_produit = '12' ORDER BY
pd.id_produit_declinaison
0.00023
64 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '12'
 0.00018
65 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00017
66 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00008
67 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '12'
 0.00015
68 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00009
69 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00022
70 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00009
71 
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '13' ORDER BY position
0.00023
72 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00009
73 
 SELECT pd.*, p.id_tva,
                        IF(1, promo, NOW() BETWEEN
p.debut_promo AND p.fin_promo) AS promo,
                        IF(1, solde, NOW() BETWEEN
p.debut_solde AND p.fin_solde) AS solde 
                        FROM
oktopusV1_mod_mosaic_produit_declinaison AS pd
                        LEFT JOIN
oktopusV1_mod_mosaic_produit as p ON p.id_produit =
pd.id_produit
						WHERE 1 AND pd.id_produit = '13' ORDER BY
pd.id_produit_declinaison
0.00024
74 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '13'
 0.00022
75 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00009
76 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00007
77 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '13'
 0.00048
78 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00008
79 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00007
80 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00008
81 
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '14' ORDER BY position
0.00022
82 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00008
83 
 SELECT pd.*, p.id_tva,
                        IF(1, promo, NOW() BETWEEN
p.debut_promo AND p.fin_promo) AS promo,
                        IF(1, solde, NOW() BETWEEN
p.debut_solde AND p.fin_solde) AS solde 
                        FROM
oktopusV1_mod_mosaic_produit_declinaison AS pd
                        LEFT JOIN
oktopusV1_mod_mosaic_produit as p ON p.id_produit =
pd.id_produit
						WHERE 1 AND pd.id_produit = '14' ORDER BY
pd.id_produit_declinaison
0.00022
84 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '14'
 0.00020
85 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00009
86 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00006
87 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '14'
 0.00016
88 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00009
89 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00009
90 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00007
91 
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '15' ORDER BY position
0.00025
92 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00007
93 
 SELECT pd.*, p.id_tva,
                        IF(1, promo, NOW() BETWEEN
p.debut_promo AND p.fin_promo) AS promo,
                        IF(1, solde, NOW() BETWEEN
p.debut_solde AND p.fin_solde) AS solde 
                        FROM
oktopusV1_mod_mosaic_produit_declinaison AS pd
                        LEFT JOIN
oktopusV1_mod_mosaic_produit as p ON p.id_produit =
pd.id_produit
						WHERE 1 AND pd.id_produit = '15' ORDER BY
pd.id_produit_declinaison
0.00022
94 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '15'
 0.00018
95 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00043
96 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00009
97 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '15'
 0.00015
98 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00011
99 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00009
100 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00010
101 
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '16' ORDER BY position
0.00028
102 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00010
103 
 SELECT pd.*, p.id_tva,
                        IF(1, promo, NOW() BETWEEN
p.debut_promo AND p.fin_promo) AS promo,
                        IF(1, solde, NOW() BETWEEN
p.debut_solde AND p.fin_solde) AS solde 
                        FROM
oktopusV1_mod_mosaic_produit_declinaison AS pd
                        LEFT JOIN
oktopusV1_mod_mosaic_produit as p ON p.id_produit =
pd.id_produit
						WHERE 1 AND pd.id_produit = '16' ORDER BY
pd.id_produit_declinaison
0.00026
104 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '16'
 0.00022
105 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00011
106 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00008
107 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '16'
 0.00014
108 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00011
109 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00009
110 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00010
111 
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '17' ORDER BY position
0.00026
112 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00010
113 
 SELECT pd.*, p.id_tva,
                        IF(1, promo, NOW() BETWEEN
p.debut_promo AND p.fin_promo) AS promo,
                        IF(1, solde, NOW() BETWEEN
p.debut_solde AND p.fin_solde) AS solde 
                        FROM
oktopusV1_mod_mosaic_produit_declinaison AS pd
                        LEFT JOIN
oktopusV1_mod_mosaic_produit as p ON p.id_produit =
pd.id_produit
						WHERE 1 AND pd.id_produit = '17' ORDER BY
pd.id_produit_declinaison
0.00026
114 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '17'
 0.00022
115 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00011
116 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00009
117 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '17'
 0.00013
118 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00011
119 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00011
120 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00011
121 
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '18' ORDER BY position
0.00024
122 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00010
123 
 SELECT pd.*, p.id_tva,
                        IF(1, promo, NOW() BETWEEN
p.debut_promo AND p.fin_promo) AS promo,
                        IF(1, solde, NOW() BETWEEN
p.debut_solde AND p.fin_solde) AS solde 
                        FROM
oktopusV1_mod_mosaic_produit_declinaison AS pd
                        LEFT JOIN
oktopusV1_mod_mosaic_produit as p ON p.id_produit =
pd.id_produit
						WHERE 1 AND pd.id_produit = '18' ORDER BY
pd.id_produit_declinaison
0.00025
124 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '18'
 0.00022
125 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00010
126 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00008
127 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '18'
 0.00013
128 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='2'
 0.00010
129 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00008
130 
SELECT COUNT(r.id_rubrique) AS num_rubriques FROM
oktopusV1_mod_mosaic_rubrique AS r LEFT JOIN
oktopusV1_mod_mosaic_rubrique_locales AS rl ON r.id_rubrique
= rl.id_rubrique WHERE 1 AND rl.language='fr' AND
r.id_parent = 2 AND r.actif = 1
0.00216
131 
SELECT COUNT(r.id_rubrique) AS num_rubriques FROM
oktopusV1_mod_mosaic_rubrique AS r LEFT JOIN
oktopusV1_mod_mosaic_rubrique_locales AS rl ON r.id_rubrique
= rl.id_rubrique WHERE 1 AND rl.language='fr' AND
r.id_parent = 2 AND r.actif = 1
0.00011
132 

            SELECT r.*, rl.* FROM
oktopusV1_mod_mosaic_rubrique r
            JOIN oktopusV1_mod_mosaic_rubrique_locales rl ON
rl.id_rubrique = r.id_rubrique AND rl.language = 'fr'
            WHERE r.id_rubrique='1'
 0.00030
133 
SELECT r.*, rl.*, COUNT(r.id_rubrique) AS num_posts FROM
oktopusV1_mod_mosaic_rubrique AS r LEFT JOIN
oktopusV1_mod_mosaic_rubrique_locales AS rl ON r.id_rubrique
= rl.id_rubrique WHERE 1 AND rl.language='fr' AND
r.id_parent = 2 AND r.actif = 1  GROUP BY r.id_rubrique
ORDER BY nleft asc
0.00064
134 
 SELECT DISTINCT m.nom AS nomMarque, m.image AS imageMarque,
mo.nom AS nomModele, p.*, pl.*, pr.position,
                            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 oktopusV1_mod_mosaic_produit
p
                           JOIN
oktopusV1_mod_mosaic_produit_locales pl ON pl.id_produit =
p.id_produit AND pl.language = 'fr' LEFT JOIN
oktopusV1_mod_mosaic_marque m ON p.id_marque = m.id_marque
                           LEFT JOIN
oktopusV1_mod_mosaic_modele mo ON p.id_modele =
mo.id_modele
                           LEFT JOIN
oktopusV1_mod_mosaic_produit_rubrique pr ON pr.id_produit =
p.id_produit
                           WHERE pr.id_rubrique IN (2) AND
p.actif = '1' ORDER BY pr.position
 0.00190
135 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00011
136 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 AND
actif = '1' ORDER BY position
 0.00182
137 
 SELECT dc.* 
                                FROM
oktopusV1_mod_mosaic_declinaison_champ AS dc 
                                WHERE 1 AND dc.actif = '1'
ORDER BY dc.position
 0.00030
138 
SELECT r.*, rl.*, COUNT(r.id_rubrique) AS num_posts FROM
oktopusV1_mod_mosaic_rubrique AS r LEFT JOIN
oktopusV1_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.00017
139 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
 0.00015
140 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '1'
 0.00011
141 
SELECT DISTINCT sn.*, snl.*
                      FROM oktopusV1_mod_social_network sn
                      JOIN
oktopusV1_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.00017
142 
SELECT *, DATE_FORMAT(livraison_date, '%d/%m/%Y') AS
livraison_date_fr
                   FROM oktopusV1_mod_mosaic_panier WHERE
id_client = 'tmp_68e227fd743f7'
 0.00014
143 
SELECT p.date, pd.*, po.id_tva FROM
oktopusV1_mod_mosaic_panier AS p
                    LEFT JOIN
oktopusV1_mod_mosaic_panier_detail AS pd ON p.id_panier =
pd.id_panier
                    LEFT JOIN oktopusV1_mod_mosaic_produit
AS po ON pd.id_produit = po.id_produit WHERE p.id_client =
''
 0.00010
144 
SELECT DISTINCT sn.*, snl.*
                      FROM oktopusV1_mod_social_network sn
                      JOIN
oktopusV1_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.00013
145 
 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 oktopusV1_mod_slideshow_type t
                       WHERE 1 AND CASE 
                                       WHEN t.choix_rubrique
= 1 THEN
                                           t.rubrique LIKE
'%\'/gros-sel-naturel-2\'%'
                                       WHEN t.choix_rubrique
= 2 THEN
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV1_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE '%\'/gros-sel-naturel-2\'%' AND t.actif = 1
                   ) = 0
                
                                           AND
                                           t.rubrique NOT
LIKE '%\'/gros-sel-naturel-2\'%'
                                       ELSE     
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV1_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE '%\'/gros-sel-naturel-2\'%' AND t.actif = 1
                   ) = 0
                 
                                   END AND actif = '1' ORDER
BY nom
0.00059
146 
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 oktopusV1_mod_slideshow_type t
                     WHERE t.id_type = '2'
 0.00010
147 
 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 oktopusV1_mod_slideshow p
                       LEFT JOIN
oktopusV1_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.00016
148 
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 oktopusV1_mod_home_popup p
                      LEFT JOIN
oktopusV1_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
'%\'/gros-sel-naturel-2\'%') ORDER BY p.rubrique DESC
 0.00052
149 
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 oktopusV1_mod_home_popup p
                      LEFT JOIN
oktopusV1_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
'%\'/gros-sel-naturel-2\'%') ORDER BY p.rubrique DESC
 0.00031
150 
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 oktopusV1_mod_home_popup p
                      LEFT JOIN
oktopusV1_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
'%\'/gros-sel-naturel-2\'%') ORDER BY p.rubrique DESC
 0.00041
151 
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 oktopusV1_mod_home_popup p
                      LEFT JOIN
oktopusV1_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
'%\'/gros-sel-naturel-2\'%') ORDER BY p.rubrique DESC
 0.00044
# type fichier ligne classe fonction message