• Marais Salant La Nouvelle Brille

 

Profiler (0,173 s)

Requêtes (190)

Erreurs (0)

  • Mémoire utilisée par PHP : 1,92 Mo
  • Pic mémoire allouée par PHP : 2,93 Mo
  • Temps d'execution du script : 0.173 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.00211
3 
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
 0.00022
4 
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
 0.00017
5 
SELECT setting_name, setting_value FROM
oktopusV1_mod_oktopusagent_settings
 0.00056
6 
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
 0.00032
7 
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
 0.00029
8 
SHOW TABLES LIKE 'oktopusV1_mod_oktopusagent_settings'
 0.00017
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.00070
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.00028
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.00149
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.00078
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.00086
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.00144
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.00044
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.00305
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.00047
21 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
 0.00015
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.00260
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.00038
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.00029
25 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00007
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.00054
27 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00043
28 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'declinaison'
 0.00014
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.00007
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.00011
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.00014
35 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
36 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00013
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.00015
38 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00010
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.00017
40 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '36'
 0.00012
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.00014
42 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
43 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '36'
 0.00012
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.00014
45 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
46 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00013
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.00014
48 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00010
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.00016
50 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '37'
 0.00012
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.00014
52 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
53 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '37'
 0.00011
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.00014
55 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
56 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00013
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.00014
58 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00009
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.00016
60 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '38'
 0.00012
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.00014
62 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
63 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '38'
 0.00011
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.00014
65 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
66 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00013
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.00014
68 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00009
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.00016
70 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '39'
 0.00012
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.00014
72 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
73 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '39'
 0.00011
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.00014
75 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
76 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00015
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.00014
78 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00010
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.00016
80 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '40'
 0.00012
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.00014
82 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
83 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '40'
 0.00011
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.00014
85 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
86 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00013
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.00014
88 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00009
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.00016
90 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '41'
 0.00012
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.00014
92 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
93 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '41'
 0.00011
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.00014
95 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
96 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00013
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.00014
98 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00009
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.00016
100 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '42'
 0.00011
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.00014
102 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
103 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '42'
 0.00011
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.00013
105 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
106 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00013
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.00014
108 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00009
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.00016
110 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '43'
 0.00012
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.00014
112 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
113 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '43'
 0.00011
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.00013
115 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
116 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00013
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.00014
118 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00009
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.00016
120 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '44'
 0.00011
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.00014
122 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
123 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '44'
 0.00011
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.00014
125 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
126 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00014
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.00014
128 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00009
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.00016
130 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '45'
 0.00012
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.00014
132 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
133 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '45'
 0.00013
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.00015
135 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
136 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00013
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.00014
138 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00009
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.00016
140 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '47'
 0.00011
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.00014
142 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
143 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '47'
 0.00011
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.00014
145 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
146 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00013
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.00014
148 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00009
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.00018
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.00090
151 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'declinaison_champ'
 0.00016
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.00016
153 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '46'
 0.00012
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.00015
155 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
156 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '46'
 0.00011
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.00014
158 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
159 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 0.00013
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.00014
161 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 0.00009
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.00016
163 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '57'
 0.00012
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.00014
165 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
166 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '57'
 0.00011
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.00014
168 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00010
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.00030
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.00016
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.00014
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.00059
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.00168
174 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00013
175 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 AND
actif = '1' ORDER BY position
 0.00026
176 
 SELECT dc.* 
                                FROM
oktopusV1_mod_mosaic_declinaison_champ AS dc 
                                WHERE 1 AND dc.actif = '1'
ORDER BY dc.position
 0.00016
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.00067
178 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '4'
 0.00013
179 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '1'
 0.00011
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.00134
181 
SELECT *, DATE_FORMAT(livraison_date, '%d/%m/%Y') AS
livraison_date_fr
                   FROM oktopusV1_mod_mosaic_panier WHERE
id_client = 'tmp_6aa2e4994f782'
 0.00054
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.00069
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.00056
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.00049
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.00006
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.00053
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.00013
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.00013
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