• Marais Salant La Nouvelle Brille
  • Mémoire utilisée par PHP : 9,33 Mo
  • Pic mémoire allouée par PHP : 10,20 Mo
  • Temps d'execution du script : 0.138 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.00003
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.00011
3
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00020
4
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00016
5
SELECT setting_name, setting_value FROM
oktopusV1_mod_oktopusagent_settings
0.00006
6
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00016
7
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00015
8
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00015
9
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
0.00015
10
SELECT COUNT(id_rubrique) FROM oktopusV1_mod_mosaic_rubrique
WHERE id_rubrique = '4' 
0.00008
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.00011
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.00042
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.00015
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.00034
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.00039
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.00039
17
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00008
18
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
0.00009
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.00139
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.00020
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.00133
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.00018
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.00020
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.00010
27
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00007
28
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'declinaison'
0.00008
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.00011
30
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '35'
0.00008
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.00009
32
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
33
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '35'
0.00008
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.00009
35
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
36
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00008
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.00009
38
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00006
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.00010
40
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '36'
0.00008
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.00009
42
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
43
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '36'
0.00008
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.00007
46
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00008
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.00009
48
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00006
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.00011
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.00007
53
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '37'
0.00008
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.00010
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.00009
58
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00006
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.00010
60
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '38'
0.00008
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.00007
63
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '38'
0.00008
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.00007
66
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00008
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.00009
68
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00006
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.00009
72
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
73
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '39'
0.00008
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.00007
76
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00008
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.00006
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.00010
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.00009
82
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
83
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '40'
0.00008
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.00007
86
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00008
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.00009
88
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00006
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.00010
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.00009
92
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
93
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '41'
0.00008
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.00007
96
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00008
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.00009
98
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00006
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.00010
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.00007
103
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '42'
0.00008
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.00007
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.00009
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.00009
112
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
113
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '43'
0.00008
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.00007
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.00009
118
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00006
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.00010
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.00009
122
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
123
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '44'
0.00008
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.00009
125
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
126
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00008
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.00009
128
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00006
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.00010
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.00010
132
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
133
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '45'
0.00008
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.00007
136
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00008
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.00009
138
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00006
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.00010
140
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '47'
0.00008
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.00007
143
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '47'
0.00008
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.00007
146
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00008
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.00006
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.00011
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.00011
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.00008
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.00009
155
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
156
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '46'
0.00008
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.00008
158
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
159
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
0.00008
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.00009
161
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
0.00006
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.00010
163
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '57'
0.00008
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.00009
165
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
166
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '57'
0.00008
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.00009
168
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00007
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.00010
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.00030
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.00085
174
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
0.00008
175
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 AND
actif = '1' ORDER BY position
0.00008
176
 SELECT dc.* 
                                FROM
oktopusV1_mod_mosaic_declinaison_champ AS dc 
                                WHERE 1 AND dc.actif = '1'
ORDER BY dc.position
0.00009
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.00033
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.00007
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.00032
181
SELECT *, DATE_FORMAT(livraison_date, '%d/%m/%Y') AS
livraison_date_fr
                   FROM oktopusV1_mod_mosaic_panier WHERE
id_client = 'tmp_69829d30980b6'
0.00009
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.00010
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.00030
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.00019
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.00015
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.00015
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.00014
# type fichier ligne classe fonction message