Bon cadeau

Mémoire utilisée par PHP : 3,92 Mo
Pic mémoire allouée par PHP : 5,13 Mo
Temps d'execution du script : 0.541 s

Lang :
Path : bon-cadeau-1
Route : mosaicRubrique

$okt->page->module : mosaic
$okt->page->action :
Title tag : Bon cadeau - Oeno Mélo
Title:
H1:
Meta description: Vins locaux à Chablis et Vézelay dans l'Yonne (89)
Meta keyword: Atelier dégustation vin Auxerre, Atelier dégustation vin Joigny, Atelier dégustation vin Tonnerre, Atelier dégustation vin Chablis, Atelier dégustation vin Yonne (89), Atelier dégustation vin Vézelay, Animatrice en dégustation Auxerre, Animatrice en dégustation Joigny, Animatrice en dégustation Tonnerre, Animatrice en dégustation Chablis, Animatrice en dégustation Yonne (89), Animatrice en dégustation Vézelay, Dégustation de vins Auxerre, Dégustation de vins Joigny, Dégustation de vins Tonnerre, Dégustation de vins Chablis, Dégustation de vins Yonne (89), Dégustation de vins Vézelay, Visite domaine viticole Auxerre, Visite domaine viticole Joigny, Visite domaine viticole Tonnerre, Visite domaine viticole Chablis, Visite domaine viticole Yonne (89), Visite domaine viticole Vézelay, Vins locaux Auxerre, Vins locaux Joigny, Vins locaux Tonnerre, Vins locaux Chablis, Vins locaux Yonne (89), Vins locaux Vézelay, Evenement oenologie Auxerre, Evenement oenologie Joigny, Evenement oenologie Tonnerre, Evenement oenologie Chablis, Evenement oenologie Yonne (89), Evenement oenologie Vézelay, Oenologie Auxerre, Oenologie Joigny, Oenologie Tonnerre, Oenologie Chablis, Oenologie Yonne (89), Oenologie Vézelay


SET NAMES utf8mb4
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV1_core_users AS u INNER JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV1_core_users_online AS o ON
o.ident='3.237.32.15' WHERE u.id=1
UPDATE oktopusV1_core_users_online SET logged=1685240698,
prev_url='https://www.oeno-melo.fr/bon-cadeau-1' WHERE
ident='3.237.32.15'
SELECT u.*, g.* FROM oktopusV1_core_users AS u LEFT JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.active != 3 ORDER BY u.username DESC 
 SELECT t.*, tl.*, tsl.nom AS nomStatut, couleur,
                       DATE_FORMAT(tl.date_creation,
'%d/%m/%Y à %Hh%i') AS date_creation_fr,
                       DATE_FORMAT(t.date_transaction,
'%d/%m/%Y à %Hh%i') AS date_transaction_fr
                       FROM
oktopusV1_mod_appointments_transaction t
                       JOIN
oktopusV1_mod_appointments_transaction_statut_ligne tl ON
tl.id_transaction_statut_ligne =
t.id_transaction_statut_ligne
                       JOIN
oktopusV1_mod_appointments_transaction_statut ts ON
ts.id_transaction_statut = tl.id_transaction_statut
                       JOIN
oktopusV1_mod_appointments_transaction_statut_locales tsl ON
tsl.id_transaction_statut = ts.id_transaction_statut AND
tsl.language = 'fr'
                       WHERE 1 AND tl.id_transaction_statut
= '1' ORDER BY t.date_transaction DESC 
SELECT u.*, g.* FROM oktopusV1_core_users AS u LEFT JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.active != 3 ORDER BY u.username DESC 
 SELECT t.*, tl.*, tsl.nom AS nomStatut, couleur,
                       DATE_FORMAT(tl.date_creation,
'%d/%m/%Y à %Hh%i') AS date_creation_fr,
                       DATE_FORMAT(t.date_transaction,
'%d/%m/%Y à %Hh%i') AS date_transaction_fr
                       FROM
oktopusV1_mod_appointments_transaction t
                       JOIN
oktopusV1_mod_appointments_transaction_statut_ligne tl ON
tl.id_transaction_statut_ligne =
t.id_transaction_statut_ligne
                       JOIN
oktopusV1_mod_appointments_transaction_statut ts ON
ts.id_transaction_statut = tl.id_transaction_statut
                       JOIN
oktopusV1_mod_appointments_transaction_statut_locales tsl ON
tsl.id_transaction_statut = ts.id_transaction_statut AND
tsl.language = 'fr'
                       WHERE 1 AND tl.id_transaction_statut
IN (1,11) ORDER BY t.date_transaction DESC 
SELECT u.*, g.* FROM oktopusV1_core_users AS u LEFT JOIN
oktopusV1_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.active != 3 ORDER BY u.username DESC 
 SELECT t.*, tl.*, tsl.nom AS nomStatut, couleur,
                       DATE_FORMAT(tl.date_creation,
'%d/%m/%Y à %Hh%i') AS date_creation_fr,
                       DATE_FORMAT(t.date_transaction,
'%d/%m/%Y à %Hh%i') AS date_transaction_fr
                       FROM
oktopusV1_mod_appointments_transaction t
                       JOIN
oktopusV1_mod_appointments_transaction_statut_ligne tl ON
tl.id_transaction_statut_ligne =
t.id_transaction_statut_ligne
                       JOIN
oktopusV1_mod_appointments_transaction_statut ts ON
ts.id_transaction_statut = tl.id_transaction_statut
                       JOIN
oktopusV1_mod_appointments_transaction_statut_locales tsl ON
tsl.id_transaction_statut = ts.id_transaction_statut AND
tsl.language = 'fr'
                       WHERE 1 AND acompte != 0 AND
mail_2eme_paiement IS NULL AND tl.id_transaction_statut =
'11' ORDER BY t.date_transaction DESC 
UPDATE oktopusV1_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 
UPDATE oktopusV1_mod_news SET active = 0
                              WHERE active = 1 AND end_at !=
"0000-00-00 00:00:00" 
                              AND NOW() > end_at 
SELECT COUNT(id_rubrique) FROM oktopusV1_mod_mosaic_rubrique
WHERE id_rubrique = '1' 

            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'
SELECT f.id, f.user_id, f.active, f.token, f.created_at,
f.updated_at, f.tpl, f.config_general, f.config_style,
f.config_date,
                              fl.language, fl.title,
fl.title_tag, fl.title_seo, fl.slug, fl.meta_description,
fl.meta_keywords, fl.beforedate, fl.afterdate FROM
oktopusV1_mod_facebook AS f  INNER JOIN
oktopusV1_mod_facebook_locales AS fl ON f.id=fl.id_facebook
AND fl.language='fr' WHERE 1  AND fl.language='fr' AND
f.active=1 ORDER BY f.created_at DESC 
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 
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 
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 
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
SELECT p.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,
p.recipients_to, p.recipients_cc, p.recipients_bcc,
p.from_to, p.captcha, p.conversion_google, p.from_copy,
pl.subject 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 
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '1'
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
 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
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 = '1' AND p.actif = '1' AND r.actif = '1' 
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'rubrique'
 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
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 = '1' AND p.actif = '1' AND r.actif = '1' 
SELECT pr.*, rl.slug  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 = '1' AND p.actif = '1' AND r.actif = '1' 
ORDER BY pr.position ASC LIMIT 0,20
SELECT id, language, valeur FROM
oktopusV1_mod_mosaic_locales
					  WHERE `table` = 'produit_photo'
 SELECT p.id_produit_photo AS id, p.* FROM
oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1'
AND id_produit = '1' ORDER BY position 
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER
BY position
 SELECT pd.*, p.id_tva 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 = '1' ORDER BY
pd.id_produit_declinaison 
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '1'

            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'
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '1'
SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE
id_produit = '1'

            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'
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '1'
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 = 1 AND r.actif = 1  GROUP BY r.id_rubrique
ORDER BY nleft asc 
 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 (1) AND
p.actif = '1' ORDER BY pr.position
SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE
id_rubrique = '1'
SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 AND
actif = '1' ORDER BY position
 SELECT dc.* 
                                FROM
oktopusV1_mod_mosaic_declinaison_champ AS dc 
                                WHERE 1 AND dc.actif = '1'
ORDER BY dc.position
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 = 1 AND r.actif = 1  GROUP BY r.id_rubrique
ORDER BY nleft asc 
SELECT *, DATE_FORMAT(livraison_date, '%d/%m/%Y') AS
livraison_date_fr
                   FROM oktopusV1_mod_mosaic_panier WHERE
id_client = 'tmp_6472bb7b33950'
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 =
''
 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
'%\'/bon-cadeau-1\'%'
                                       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 '%\'/bon-cadeau-1\'%' AND t.actif = 1
                   ) = 0
                
                                           AND
                                           t.rubrique NOT
LIKE '%\'/bon-cadeau-1\'%'
                                       ELSE     
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV1_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE '%\'/bon-cadeau-1\'%' AND t.actif = 1
                   ) = 0
                 
                                   END AND actif = '1' ORDER
BY nom 
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'
 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
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
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
'%\'/bon-cadeau-1\'%') ORDER BY p.rubrique DESC
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
'%\'/bon-cadeau-1\'%') ORDER BY p.rubrique DESC

ID	Query	Time
1	`SET NAMES utf8mb4`	0.00034
2	`SELECT u., g., o.logged, o.csrf_token, o.prev_url FROM oktopusV1_core_users AS u INNER JOIN oktopusV1_core_users_groups AS g ON g.group_id=u.group_id LEFT JOIN oktopusV1_core_users_online AS o ON o.ident='3.237.32.15' WHERE u.id=1`	0.00076
3	`UPDATE oktopusV1_core_users_online SET logged=1685240698, prev_url='https://www.oeno-melo.fr/bon-cadeau-1' WHERE ident='3.237.32.15'`	0.00042
4	`SELECT u., g. FROM oktopusV1_core_users AS u LEFT JOIN oktopusV1_core_users_groups AS g ON g.group_id=u.group_id WHERE u.active != 3 ORDER BY u.username DESC`	0.00062
5	SELECT t., tl., tsl.nom AS nomStatut, couleur, DATE_FORMAT(tl.date_creation, '%d/%m/%Y à %Hh%i') AS date_creation_fr, DATE_FORMAT(t.date_transaction, '%d/%m/%Y à %Hh%i') AS date_transaction_fr FROM oktopusV1_mod_appointments_transaction t JOIN oktopusV1_mod_appointments_transaction_statut_ligne tl ON tl.id_transaction_statut_ligne = t.id_transaction_statut_ligne JOIN oktopusV1_mod_appointments_transaction_statut ts ON ts.id_transaction_statut = tl.id_transaction_statut JOIN oktopusV1_mod_appointments_transaction_statut_locales tsl ON tsl.id_transaction_statut = ts.id_transaction_statut AND tsl.language = 'fr' WHERE 1 AND tl.id_transaction_statut = '1' ORDER BY t.date_transaction DESC	0.00037
6	`SELECT u., g. FROM oktopusV1_core_users AS u LEFT JOIN oktopusV1_core_users_groups AS g ON g.group_id=u.group_id WHERE u.active != 3 ORDER BY u.username DESC`	0.00036
7	SELECT t., tl., tsl.nom AS nomStatut, couleur, DATE_FORMAT(tl.date_creation, '%d/%m/%Y à %Hh%i') AS date_creation_fr, DATE_FORMAT(t.date_transaction, '%d/%m/%Y à %Hh%i') AS date_transaction_fr FROM oktopusV1_mod_appointments_transaction t JOIN oktopusV1_mod_appointments_transaction_statut_ligne tl ON tl.id_transaction_statut_ligne = t.id_transaction_statut_ligne JOIN oktopusV1_mod_appointments_transaction_statut ts ON ts.id_transaction_statut = tl.id_transaction_statut JOIN oktopusV1_mod_appointments_transaction_statut_locales tsl ON tsl.id_transaction_statut = ts.id_transaction_statut AND tsl.language = 'fr' WHERE 1 AND tl.id_transaction_statut IN (1,11) ORDER BY t.date_transaction DESC	0.00036
8	`SELECT u., g. FROM oktopusV1_core_users AS u LEFT JOIN oktopusV1_core_users_groups AS g ON g.group_id=u.group_id WHERE u.active != 3 ORDER BY u.username DESC`	0.00039
9	SELECT t., tl., tsl.nom AS nomStatut, couleur, DATE_FORMAT(tl.date_creation, '%d/%m/%Y à %Hh%i') AS date_creation_fr, DATE_FORMAT(t.date_transaction, '%d/%m/%Y à %Hh%i') AS date_transaction_fr FROM oktopusV1_mod_appointments_transaction t JOIN oktopusV1_mod_appointments_transaction_statut_ligne tl ON tl.id_transaction_statut_ligne = t.id_transaction_statut_ligne JOIN oktopusV1_mod_appointments_transaction_statut ts ON ts.id_transaction_statut = tl.id_transaction_statut JOIN oktopusV1_mod_appointments_transaction_statut_locales tsl ON tsl.id_transaction_statut = ts.id_transaction_statut AND tsl.language = 'fr' WHERE 1 AND acompte != 0 AND mail_2eme_paiement IS NULL AND tl.id_transaction_statut = '11' ORDER BY t.date_transaction DESC	0.00035
10	`UPDATE oktopusV1_mod_news SET active = 1 WHERE active = 3 AND NOW() > created_at`	0.00066
11	`UPDATE oktopusV1_mod_news SET active = 0 WHERE active = 1 AND end_at != "0000-00-00 00:00:00" AND NOW() > end_at`	0.00040
12	`SELECT COUNT(id_rubrique) FROM oktopusV1_mod_mosaic_rubrique WHERE id_rubrique = '1'`	0.00060
13	`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.00061
14	`SELECT f.id, f.user_id, f.active, f.token, f.created_at, f.updated_at, f.tpl, f.config_general, f.config_style, f.config_date, fl.language, fl.title, fl.title_tag, fl.title_seo, fl.slug, fl.meta_description, fl.meta_keywords, fl.beforedate, fl.afterdate FROM oktopusV1_mod_facebook AS f INNER JOIN oktopusV1_mod_facebook_locales AS fl ON f.id=fl.id_facebook AND fl.language='fr' WHERE 1 AND fl.language='fr' AND f.active=1 ORDER BY f.created_at DESC`	0.00049
15	`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.00093
16	`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.00042
17	`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.00035
18	`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.00040
19	SELECT p.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, p.recipients_to, p.recipients_cc, p.recipients_bcc, p.from_to, p.captcha, p.conversion_google, p.from_copy, pl.subject 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.00071
20	`SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE id_rubrique = '1'`	0.00057
21	SELECT id, language, valeur FROM oktopusV1_mod_mosaic_locales WHERE `table` = 'rubrique'	0.00054
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.00352
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 = '1' AND p.actif = '1' AND r.actif = '1'`	0.00069
24	SELECT id, language, valeur FROM oktopusV1_mod_mosaic_locales WHERE `table` = 'rubrique'	0.00031
25	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.00190
26	`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 = '1' AND p.actif = '1' AND r.actif = '1'`	0.00033
27	`SELECT pr.*, rl.slug 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 = '1' AND p.actif = '1' AND r.actif = '1' ORDER BY pr.position ASC LIMIT 0,20`	0.00074
28	SELECT id, language, valeur FROM oktopusV1_mod_mosaic_locales WHERE `table` = 'produit_photo'	0.00049
29	`SELECT p.id_produit_photo AS id, p.* FROM oktopusV1_mod_mosaic_produit_photo p WHERE 1 AND actif = '1' AND id_produit = '1' ORDER BY position`	0.00047
30	`SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 ORDER BY position`	0.00047
31	`SELECT pd.*, p.id_tva 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 = '1' ORDER BY pd.id_produit_declinaison`	0.00053
32	`SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE id_produit = '1'`	0.00049
33	`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.00033
34	`SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE id_rubrique = '1'`	0.00030
35	`SELECT * FROM oktopusV1_mod_mosaic_produit_locales WHERE id_produit = '1'`	0.00040
36	`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.00033
37	`SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE id_rubrique = '1'`	0.00030
38	`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 = 1 AND r.actif = 1 GROUP BY r.id_rubrique ORDER BY nleft asc`	0.00097
39	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 (1) AND p.actif = '1' ORDER BY pr.position	0.00156
40	`SELECT * FROM oktopusV1_mod_mosaic_rubrique_locales WHERE id_rubrique = '1'`	0.00032
41	`SELECT * FROM oktopusV1_mod_mosaic_declinaison WHERE 1 AND actif = '1' ORDER BY position`	0.00045
42	`SELECT dc.* FROM oktopusV1_mod_mosaic_declinaison_champ AS dc WHERE 1 AND dc.actif = '1' ORDER BY dc.position`	0.00180
43	`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 = 1 AND r.actif = 1 GROUP BY r.id_rubrique ORDER BY nleft asc`	0.00041
44	`SELECT *, DATE_FORMAT(livraison_date, '%d/%m/%Y') AS livraison_date_fr FROM oktopusV1_mod_mosaic_panier WHERE id_client = 'tmp_6472bb7b33950'`	0.00051
45	`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.00033
46	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 '%\'/bon-cadeau-1\'%' 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 '%\'/bon-cadeau-1\'%' AND t.actif = 1 ) = 0 AND t.rubrique NOT LIKE '%\'/bon-cadeau-1\'%' ELSE ( SELECT COUNT(t.id_type) FROM oktopusV1_mod_slideshow_type t WHERE t.choix_rubrique = 1 AND t.rubrique LIKE '%\'/bon-cadeau-1\'%' AND t.actif = 1 ) = 0 END AND actif = '1' ORDER BY nom	0.00082
47	`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.00034
48	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.00039
49	`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.00036
50	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 '%\'/bon-cadeau-1\'%') ORDER BY p.rubrique DESC	0.00065
51	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 '%\'/bon-cadeau-1\'%') ORDER BY p.rubrique DESC	0.00053

#	type	fichier	ligne	classe	fonction	message

Le produit a été ajouté au panier