• Marais Salant La Nouvelle Brille
  • 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.827 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.00019
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='4243f6cc32c5faebd82910f013feb3329eaf49f75b07bd92ca48b3a403bf0620'
WHERE u.id=1
0.00097
3
UPDATE oktopusV1_core_users_online SET logged=1763559443,
prev_url='https://www.marais-salant.fr/gros-sel-naturel-2'
WHERE
ident='4243f6cc32c5faebd82910f013feb3329eaf49f75b07bd92ca48b3a403bf0620'
0.00043
4
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00095
5
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00057
6
SELECT setting_name, setting_value FROM
oktopusV1_mod_oktopusagent_settings
0.00034
7
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00049
8
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00050
9
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00046
10
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00045
11
SELECT COUNT(id_rubrique) FROM oktopusV1_mod_mosaic_rubrique
WHERE id_rubrique = '2' 
0.00040
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.00066
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.00190
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.00140
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.00127
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.00128
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.00127
18
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00030
19
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
0.00036
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.01039
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.00083
22
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
0.00011
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.00412
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.00085
26
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00038
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.00035
28
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00042
29
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'declinaison'
0.00034
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.00050
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.00318
32
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'declinaison_champ'
0.00053
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.00046
34
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '9'
0.00055
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.00024
36
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00014
37
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '9'
0.00034
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.00019
39
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00015
40
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00019
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.00061
42
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00016
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.00055
44
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '10'
0.00051
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.00017
46
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00014
47
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '10'
0.00026
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.00018
49
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00016
50
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00015
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.00052
52
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00014
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.00051
54
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '11'
0.00041
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.00020
56
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00015
57
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '11'
0.00024
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.00017
59
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00015
60
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00014
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.00062
62
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00015
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.00055
64
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '12'
0.00048
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.00016
66
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00019
67
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '12'
0.00034
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.00019
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.00014
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.00062
72
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00020
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.00058
74
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '13'
0.00039
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.00017
76
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00014
77
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '13'
0.00037
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.00017
79
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00014
80
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00014
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.00052
82
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00015
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.00052
84
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '14'
0.00042
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.00017
86
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00014
87
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '14'
0.00024
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.00022
89
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00015
90
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00018
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.00053
92
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00019
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.00052
94
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '15'
0.00045
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.00018
96
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00015
97
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '15'
0.00027
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.00018
99
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00017
100
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00019
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.00047
102
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00015
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.00048
104
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '16'
0.00038
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.00017
106
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00014
107
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '16'
0.00022
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.00013
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.00011
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.00042
112
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00011
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.00040
114
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '17'
0.00030
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.00015
116
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00010
117
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '17'
0.00015
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.00012
119
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00015
120
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00012
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.00039
122
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00012
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.00043
124
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '18'
0.00030
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.00011
127
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '18'
0.00021
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.00009
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.00041
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.00035
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.00084
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.00262
135
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00013
136
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 AND
actif = '1' ORDER BY position
0.00060
137
 SELECT dc.* 
                                FROM
oktopusV1_mod_mosaic_declinaison_champ AS dc 
                                WHERE 1 AND dc.actif = '1'
ORDER BY dc.position
0.00051
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.00029
139
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '2'
0.00017
140
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '1'
0.00037
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.00147
142
SELECT *, DATE_FORMAT(livraison_date, '%d/%m/%Y') AS
livraison_date_fr
                   FROM oktopusV1_mod_mosaic_panier WHERE
id_client = 'tmp_691dc81385ebb'
0.00055
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.00060
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.00017
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.00056
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.00024
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.00044
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.00083
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.00060
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.00058
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.00104
# type fichier ligne classe fonction message