| 1 |
SET NAMES utf8mb4
|
0.00013 |
| 2 |
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
modules_sitti_core_users AS u INNER JOIN
modules_sitti_core_users_groups AS g ON
g.group_id=u.group_id LEFT JOIN
modules_sitti_core_users_online AS o ON
o.ident='34.207.230.188' WHERE u.id=1
|
0.00200 |
| 3 |
UPDATE modules_sitti_core_users_online SET
logged=1638242042,
prev_url='https://www.location-gites-landes.com/en/news-agenda-culturel'
WHERE ident='34.207.230.188'
|
0.00135 |
| 4 |
SELECT id_selection FROM modules_sitti_mod_resa_selection
WHERE UNIX_TIMESTAMP(date) + 86400 <=
UNIX_TIMESTAMP()
|
0.00036 |
| 5 |
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00025 |
| 6 |
SELECT u.*, g.* FROM modules_sitti_core_users AS u LEFT JOIN
modules_sitti_core_users_groups AS g ON
g.group_id=u.group_id WHERE u.active != 3 ORDER BY
u.username DESC
|
0.00034 |
| 7 |
SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr,
DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
FROM
modules_sitti_mod_resa_reservation c,
modules_sitti_mod_resa_reservation_statut_ligne cl,
modules_sitti_mod_resa_reservation_statut cs
WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut = '1' AND c.moyen_paiement
IN('cheque','virement','telephone') ORDER BY
date_reservation DESC
|
0.00021 |
| 8 |
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00010 |
| 9 |
SELECT u.*, g.* FROM modules_sitti_core_users AS u LEFT JOIN
modules_sitti_core_users_groups AS g ON
g.group_id=u.group_id WHERE u.active != 3 ORDER BY
u.username DESC
|
0.00024 |
| 10 |
SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr,
DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
FROM
modules_sitti_mod_resa_reservation c,
modules_sitti_mod_resa_reservation_statut_ligne cl,
modules_sitti_mod_resa_reservation_statut cs
WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut IN (1,11) ORDER BY date_reservation
DESC
|
0.00021 |
| 11 |
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00015 |
| 12 |
SELECT *
FROM
modules_sitti_mod_resa_reservation_detail
WHERE id_reservation = '108' ORDER BY
index_selection, libelle
|
0.00017 |
| 13 |
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
WHERE `table` = 'reservation_statut'
|
0.00015 |
| 14 |
SELECT u.*, g.* FROM modules_sitti_core_users AS u LEFT JOIN
modules_sitti_core_users_groups AS g ON
g.group_id=u.group_id WHERE u.active != 3 ORDER BY
u.username DESC
|
0.00023 |
| 15 |
SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr,
DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
FROM
modules_sitti_mod_resa_reservation c,
modules_sitti_mod_resa_reservation_statut_ligne cl,
modules_sitti_mod_resa_reservation_statut cs
WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
acompte != 0 AND mail_2eme_paiement IS NULL AND
cl.id_reservation_statut = '11' ORDER BY date_reservation
DESC
|
0.00153 |
| 16 |
UPDATE modules_sitti_mod_news SET active = 1
WHERE active = 3 AND NOW() >
created_at
|
0.00030 |
| 17 |
UPDATE modules_sitti_mod_news SET active = 0
WHERE active = 1 AND end_at !=
"0000-00-00 00:00:00"
AND NOW() > end_at
|
0.00041 |
| 18 |
SELECT id, title, code, img, active, ord FROM
modules_sitti_core_languages WHERE 1 AND code='en' ORDER BY
ord ASC
|
0.00449 |
| 19 |
SELECT r.*, rl.*, COUNT(p.id) AS num_posts FROM
modules_sitti_mod_news_categories AS r LEFT JOIN
modules_sitti_mod_news_categories_locales AS rl ON
r.id=rl.category_id LEFT JOIN modules_sitti_mod_news AS p ON
r.id=p.category_id WHERE 1 AND rl.slug='agenda-culturel' AND
rl.language='en' AND r.active=1 GROUP BY r.id ORDER BY
nleft asc
|
0.00823 |
| 20 |
SELECT r.*, rl.*, COUNT(p.id) AS num_posts FROM
modules_sitti_mod_news_categories AS r LEFT JOIN
modules_sitti_mod_news_categories_locales AS rl ON
r.id=rl.category_id LEFT JOIN modules_sitti_mod_news AS p ON
r.id=p.category_id WHERE 1 AND rl.language='en' GROUP BY
r.id ORDER BY nleft asc
|
0.00268 |
| 21 |
SELECT COUNT(p.id) AS num_posts FROM modules_sitti_mod_news
AS p LEFT OUTER JOIN modules_sitti_core_users AS u ON
u.id=p.user_id INNER JOIN modules_sitti_mod_news_locales AS
pl ON p.id=pl.post_id AND pl.language='en' LEFT OUTER JOIN
modules_sitti_mod_news_categories AS r ON r.id=p.category_id
LEFT OUTER JOIN modules_sitti_mod_news_categories_locales
AS rl ON r.id=rl.category_id AND rl.language='en' WHERE 1
AND p.category_id=2 AND pl.language='en' AND p.active=1
|
0.00050 |
| 22 |
SELECT p.id, p.user_id, p.category_id, p.active, p.selected,
p.created_at, p.updated_at, p.end_at, p.images, p.files,
p.tpl, p.visit, pl.language, pl.title, pl.subtitle,
pl.title_tag, pl.title_seo, pl.slug, pl.content,
pl.content_short, pl.meta_description, pl.meta_keywords,
pl.words, u.username, u.lastname, u.firstname, rl.title AS
category_title, rl.slug AS category_slug, r.items_tpl AS
category_items_tpl FROM modules_sitti_mod_news AS p LEFT
OUTER JOIN modules_sitti_core_users AS u ON u.id=p.user_id
INNER JOIN modules_sitti_mod_news_locales AS pl ON
p.id=pl.post_id AND pl.language='en' LEFT OUTER JOIN
modules_sitti_mod_news_categories AS r ON r.id=p.category_id
LEFT OUTER JOIN modules_sitti_mod_news_categories_locales
AS rl ON r.id=rl.category_id AND rl.language='en' WHERE 1
AND p.category_id=2 AND pl.language='en' AND p.active=1
ORDER BY p.selected DESC, p.created_at DESC LIMIT 0,999
|
0.00063 |
| 23 |
SELECT t.active, t.ord, t.id, t.parent_id, t.nleft,
t.nright, t.level, l.title, l.title_tag, l.title_seo,
l.slug, l.content, l.meta_description, l.meta_keywords FROM
modules_sitti_mod_news_categories AS t JOIN
modules_sitti_mod_news_categories_locales AS l ON t.id =
l.category_id AND l.language = "en" WHERE t.id = 2
|
0.00022 |
| 24 |
SELECT t.active, t.ord, t.id, t.parent_id, t.nleft,
t.nright, t.level, l.title, l.title_tag, l.title_seo,
l.slug, l.content, l.meta_description, l.meta_keywords FROM
modules_sitti_mod_news_categories AS t JOIN
modules_sitti_mod_news_categories_locales AS l ON t.id =
l.category_id AND l.language = "en" WHERE nleft <= 3 AND
nright >= 4 ORDER BY level
|
0.00247 |
| 25 |
SELECT r.*, rl.*, COUNT(p.id) AS num_posts FROM
modules_sitti_mod_news_categories AS r LEFT JOIN
modules_sitti_mod_news_categories_locales AS rl ON
r.id=rl.category_id LEFT JOIN modules_sitti_mod_news AS p ON
r.id=p.category_id WHERE 1 AND rl.language='en' AND
r.active=1 GROUP BY r.id ORDER BY nleft asc
|
0.00319 |
| 26 |
SELECT id, language, message, nom, email, url, note, ip,
visible_home, date_sign, visible, spam_status, spam_filter,
date_reponse, reponse,type,element,id_user,
DATE_FORMAT(date_sign, "%d/%m/%Y %Hh%i") AS date_sign_fr,
DATE_FORMAT(date_reponse, "%d/%m/%Y %Hh%i") AS
date_reponse_fr FROM modules_sitti_mod_guestbook WHERE 1 AND
language='en' ORDER BY date_sign DESC LIMIT 3
|
0.00054 |
| 27 |
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 modules_sitti_mod_slideshow_type t
WHERE t.id_type = '2'
|
0.00028 |
| 28 |
SELECT f.id, f.active, f.type, f.category, f.ord, f.html_id,
f.colonne, f.picto, f.options, f.info_personnelle, fl.title,
fl.legend, fl.description, fl.value FROM
modules_sitti_mod_contact_fields f LEFT JOIN
modules_sitti_mod_contact_fields_locales AS fl ON
fl.field_id=f.id AND fl.category=f.category WHERE 1 AND
f.active>0 AND f.category = "insert" AND fl.language='en'
ORDER BY ord ASC
|
0.00064 |
