| 1 |
SET NAMES utf8mb4
|
0.00019 |
| 2 |
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV1b_core_users AS u INNER JOIN
oktopusV1b_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV1b_core_users_online AS o ON
o.ident='87ab7c7379019543ffcbc42ab0453d8c325a07a087e0501fb109c979583755c1'
WHERE u.id=1
|
0.00064 |
| 3 |
REPLACE INTO oktopusV1b_core_users_online (user_id, ident,
logged, csrf_token, prev_url) VALUES
(1,'87ab7c7379019543ffcbc42ab0453d8c325a07a087e0501fb109c979583755c1',
1714016807, '6f6279b1ec3b92d3b74cc6f7326302679b05195d',
'https://www.dome-nettoyage.com/f-actualites')
|
0.00094 |
| 4 |
SELECT 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 oktopusV1b_mod_social_network_reseau snr
JOIN
oktopusV1b_mod_social_network_reseau_locales snrl ON
snrl.id_reseau = snr.id_reseau AND snrl.language = 'fr'
WHERE 1 AND snrl.slug ='actualites'
|
0.00072 |
| 5 |
SELECT DISTINCT sn.*, snl.*
FROM oktopusV1b_mod_social_network sn
JOIN
oktopusV1b_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.00155 |
| 6 |
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 oktopusV1b_mod_home_popup p
LEFT JOIN
oktopusV1b_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
'%\'/f-actualites\'%') ORDER BY p.rubrique DESC
|
0.00063 |
| 7 |
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 oktopusV1b_mod_home_popup p
LEFT JOIN
oktopusV1b_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
'%\'/f-actualites\'%') ORDER BY p.rubrique DESC
|
0.00041 |
