• Marais Salant La Nouvelle Brille
  • Mémoire utilisée par PHP : 9,37 Mo
  • Pic mémoire allouée par PHP : 10,24 Mo
  • Temps d'execution du script : 0.187 s
  • Lang :
  • Path : sel-moulu-naturel-4
  • Route : mosaicRubrique
  • $okt->page->module : mosaic
  • $okt->page->action :
  • Title tag : Sel Moulu Naturel et Aromatisé - Catalogue - Marais Salant La Nouvelle Brille
  • Title:
  • H1: Sel Moulu Naturel et Aromatisé
  • Meta description: Sel Moulu Curcuma, Sel Moulu Mélange Barbecue, Sel Moulu Mélange Plancha, Sel Moulu Viande Grillée, Sel Moulu Fines Herbes, Sel Moulu Basilic et Tomate, Sel Moulu Piment, Sel Moulu Spécial Volaill
  • Meta keyword:
ID Query Time
1
SET NAMES utf8mb4
0.00006
2
SELECT u.*, g.* FROM oktopusV1_core_users AS u INNER JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.id=1
0.00168
3
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00023
4
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00018
5
SELECT setting_name, setting_value FROM
oktopusV1_mod_oktopusagent_settings
0.00056
6
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00018
7
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00017
8
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00013
9
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00013
10
SELECT COUNT(id_rubrique) FROM oktopusV1_mod_mosaic_rubrique
WHERE id_rubrique = '4' 
0.00051
11

            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='4'
0.00030
12
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.00148
13
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.00079
14
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.00042
15
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.00092
16
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.00149
17
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
18
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
0.00035
19
 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.00294
20
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 = '4' AND p.actif = '1' AND r.actif = '1' 
0.00028
21
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
0.00008
22
 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.00173
23
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 = '4' AND p.actif = '1' AND r.actif = '1' 
0.00028
24
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 = '4' AND p.actif = '1' AND r.actif = '1' 
ORDER BY pr.position ASC LIMIT 0,20
0.00032
25
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00009
26
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '35' ORDER BY position 
0.00051
27
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00026
28
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'declinaison'
0.00007
29
 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 = '35' ORDER BY
pd.id_produit_declinaison 
0.00040
30
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '35'
0.00006
31

            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='4'
0.00008
32
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
33
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '35'
0.00006
34

            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='4'
0.00007
35
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00005
36
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00007
37
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '36' ORDER BY position 
0.00007
38
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00005
39
 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 = '36' ORDER BY
pd.id_produit_declinaison 
0.00008
40
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '36'
0.00006
41

            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='4'
0.00007
42
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00005
43
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '36'
0.00007
44

            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='4'
0.00008
45
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
46
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00007
47
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '37' ORDER BY position 
0.00008
48
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00005
49
 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 = '37' ORDER BY
pd.id_produit_declinaison 
0.00010
50
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '37'
0.00008
51

            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='4'
0.00009
52
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
53
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '37'
0.00006
54

            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='4'
0.00008
55
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
56
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00007
57
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '38' ORDER BY position 
0.00008
58
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00005
59
 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 = '38' ORDER BY
pd.id_produit_declinaison 
0.00009
60
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '38'
0.00007
61

            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='4'
0.00008
62
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
63
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '38'
0.00006
64

            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='4'
0.00008
65
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
66
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00007
67
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '39' ORDER BY position 
0.00008
68
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00005
69
 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 = '39' ORDER BY
pd.id_produit_declinaison 
0.00010
70
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '39'
0.00007
71

            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='4'
0.00008
72
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
73
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '39'
0.00007
74

            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='4'
0.00008
75
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
76
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00007
77
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '40' ORDER BY position 
0.00009
78
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00005
79
 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 = '40' ORDER BY
pd.id_produit_declinaison 
0.00009
80
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '40'
0.00007
81

            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='4'
0.00008
82
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
83
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '40'
0.00007
84

            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='4'
0.00008
85
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
86
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00007
87
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '41' ORDER BY position 
0.00008
88
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00005
89
 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 = '41' ORDER BY
pd.id_produit_declinaison 
0.00009
90
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '41'
0.00007
91

            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='4'
0.00008
92
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
93
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '41'
0.00006
94

            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='4'
0.00008
95
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
96
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00007
97
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '42' ORDER BY position 
0.00008
98
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00005
99
 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 = '42' ORDER BY
pd.id_produit_declinaison 
0.00009
100
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '42'
0.00007
101

            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='4'
0.00008
102
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
103
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '42'
0.00007
104

            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='4'
0.00008
105
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
106
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00008
107
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '43' ORDER BY position 
0.00008
108
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00006
109
 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 = '43' ORDER BY
pd.id_produit_declinaison 
0.00010
110
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '43'
0.00007
111

            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='4'
0.00008
112
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
113
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '43'
0.00007
114

            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='4'
0.00008
115
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
116
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00008
117
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '44' ORDER BY position 
0.00008
118
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00005
119
 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 = '44' ORDER BY
pd.id_produit_declinaison 
0.00009
120
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '44'
0.00007
121

            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='4'
0.00008
122
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
123
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '44'
0.00007
124

            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='4'
0.00008
125
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
126
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00007
127
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '45' ORDER BY position 
0.00008
128
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00005
129
 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 = '45' ORDER BY
pd.id_produit_declinaison 
0.00009
130
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '45'
0.00007
131

            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='4'
0.00009
132
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
133
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '45'
0.00007
134

            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='4'
0.00008
135
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
136
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00007
137
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '47' ORDER BY position 
0.00008
138
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00005
139
 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 = '47' ORDER BY
pd.id_produit_declinaison 
0.00009
140
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '47'
0.00007
141

            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='4'
0.00008
142
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
143
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '47'
0.00007
144

            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='4'
0.00008
145
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
146
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00007
147
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '46' ORDER BY position 
0.00008
148
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00005
149
 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 = '46' ORDER BY
pd.id_produit_declinaison 
0.00010
150
 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 = '56' ORDER BY
pdc.id_produit_declinaison_champ 
0.00063
151
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'declinaison_champ'
0.00009
152
 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 = '57' ORDER BY
pdc.id_produit_declinaison_champ 
0.00009
153
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '46'
0.00006
154

            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='4'
0.00007
155
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00005
156
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '46'
0.00006
157

            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='4'
0.00007
158
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00005
159
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00006
160
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '57' ORDER BY position 
0.00007
161
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00005
162
 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 = '57' ORDER BY
pd.id_produit_declinaison 
0.00008
163
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '57'
0.00006
164

            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='4'
0.00007
165
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00005
166
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '57'
0.00006
167

            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='4'
0.00008
168
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
169
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 = 4 AND r.actif = 1  
0.00020
170
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 = 4 AND r.actif = 1  
0.00009
171

            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.00009
172
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 = 4 AND r.actif = 1  GROUP BY r.id_rubrique
ORDER BY nleft asc 
0.00034
173
 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 (4) AND
p.actif = '1' ORDER BY pr.position
0.00088
174
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00006
175
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 AND
actif = '1' ORDER BY position
0.00017
176
 SELECT dc.* 
                                FROM
oktopusV1_mod_mosaic_declinaison_champ AS dc 
                                WHERE 1 AND dc.actif = '1'
ORDER BY dc.position
0.00008
177
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.00038
178
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
179
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '1'
0.00006
180
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.00089
181
SELECT *, DATE_FORMAT(livraison_date, '%d/%m/%Y') AS
livraison_date_fr
                   FROM oktopusV1_mod_mosaic_panier WHERE
id_client = 'tmp_6a2c7bc2429f1'
0.00067
182
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.00032
183
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.00028
184
 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
'%\'/sel-moulu-naturel-4\'%'
                                       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 '%\'/sel-moulu-naturel-4\'%' AND t.actif =
1
                   ) = 0
                
                                           AND
                                           t.rubrique NOT
LIKE '%\'/sel-moulu-naturel-4\'%'
                                       ELSE     
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV1_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE '%\'/sel-moulu-naturel-4\'%' AND t.actif =
1
                   ) = 0
                 
                                   END AND actif = '1' ORDER
BY nom 
0.00055
185
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.00008
186
 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.00062
187
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
'%\'/sel-moulu-naturel-4\'%') ORDER BY p.rubrique DESC
0.00055
188
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
'%\'/sel-moulu-naturel-4\'%') ORDER BY p.rubrique DESC
0.00014
189
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
'%\'/sel-moulu-naturel-4\'%') ORDER BY p.rubrique DESC
0.00014
190
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
'%\'/sel-moulu-naturel-4\'%') ORDER BY p.rubrique DESC
0.00013
# type fichier ligne classe fonction message