Thank you for filling out the form below to sign our guestbook.

Français Espagnol Allemand

Guest book
  • Mémoire utilisée par PHP : 4.04 MB
  • Pic mémoire allouée par PHP : 5.20 MB
  • Temps d'execution du script : 1.075 s
  • Lang : en
  • Path : livre-d-or
  • Route : guestbookPage
  • $okt->page->module : guestbook
  • $okt->page->action : list
ID Query Time
1
SET NAMES utf8mb4
0.00036
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.00434
3
UPDATE modules_sitti_core_users_online SET
logged=1638241383,
prev_url='https://www.location-gites-landes.com/en/livre-d-or?page=3'
WHERE ident='34.207.230.188'
0.00101
4
SELECT id_selection FROM modules_sitti_mod_resa_selection 
                      WHERE UNIX_TIMESTAMP(date) + 86400 <=
UNIX_TIMESTAMP() 
0.00069
5
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00252
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.00115
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.05098
8
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00061
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.00047
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.00184
11
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00415
12
 SELECT * 
                        FROM
modules_sitti_mod_resa_reservation_detail
						WHERE id_reservation = '108'  ORDER BY
index_selection, libelle 
0.00073
13
SELECT id, language, valeur FROM
modules_sitti_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
0.00043
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.00051
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.00177
16
UPDATE modules_sitti_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 
0.00141
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.01061
18
SELECT id, title, code, img, active, ord FROM
modules_sitti_core_languages WHERE 1  AND code='en' ORDER BY
ord ASC 
0.00684
19
SELECT COUNT(id) AS num_sig FROM modules_sitti_mod_guestbook
WHERE 1 AND type='1' AND visible=1 AND (spam_status = "" OR
spam_status IS NULL) AND language='en' ORDER BY date_sign
DESC 
0.00131
20
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
type='1' AND visible=1 AND (spam_status = "" OR spam_status
IS NULL) AND language='en' ORDER BY date_sign DESC LIMIT
10,5 
0.00067
21
SELECT COUNT(id) AS num_sig, AVG(note) AS avg_note FROM
modules_sitti_mod_guestbook WHERE 1 AND visible=1 AND
(spam_status = "" OR spam_status IS NULL) AND language='en' 
0.00435
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 pl.language='en' AND p.active=1 ORDER BY p.selected
DESC, p.created_at DESC LIMIT 10 
0.04938
23
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.01937
24
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.00174
# type fichier ligne classe fonction message
# 1  Warning /www/2011/01/iza129/www/oktModules/slideshow/module_handler.php 268 oktDebug errorHandler in_array() expects parameter 2 to be array, string given

#0 in_array( called at [/oktModules/slideshow/module_handler.php:268]


#1 module_slideshow->isH1Display( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:65]


#2 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]


#3 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]


#4 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]


#5 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]


#6 sfTemplateRenderer->__call( called at [/oktThemes/ra141-s/templates/layout.php:438]


#7 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]


#8 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]


#9 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]


#10 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]


#11 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]


#12 oktTemplating->render( called at [/oktModules/guestbook/inc/class.guestbook.controller.php:114]


#13 guestbookController->guestbookPage( called at [/oktInc/classes/router/class.oktRouter.php:317]


#14 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

# 2  Warning /www/2011/01/iza129/www/oktModules/slideshow/module_handler.php 268 oktDebug errorHandler in_array() expects parameter 2 to be array, string given

#0 in_array( called at [/oktModules/slideshow/module_handler.php:268]


#1 module_slideshow->isH1Display( called at [/oktThemes/default/templates/slideshow/insert/r-splide/template.php:115]


#2 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]


#3 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]


#4 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]


#5 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]


#6 sfTemplateRenderer->__call( called at [/oktThemes/ra141-s/templates/layout.php:438]


#7 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36]


#8 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106]


#9 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]


#10 oktTemplating->render( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:117]


#11 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60]


#12 oktTemplating->render( called at [/oktModules/guestbook/inc/class.guestbook.controller.php:114]


#13 guestbookController->guestbookPage( called at [/oktInc/classes/router/class.oktRouter.php:317]


#14 oktRouter->callRouteHanlder( called at [/oktopus.php:58]