Plan d'accès - SL2C Auclair

Mémoire utilisée par PHP : 2,53 Mo
Pic mémoire allouée par PHP : 3,36 Mo
Temps d'execution du script : 0.396 s

Lang :
Path : plan-map-footer
Route : mapItem

$okt->page->module : map
$okt->page->action : item
Title tag : Plan d'accès - SL2C Auclair - Renoncet
Title: Plan d'accès
H1:
Meta description:
Meta keyword: charpente, couverture, zinguerie, bardage, isolation intérieure et extérieure, fumisterie, désamiantage


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='1a72e7c539232367e316aeb3f8122368491ff38fa704b5c98b309da3bed15c3f'
WHERE u.id=1
UPDATE oktopusV1_core_users_online SET logged=1726561285,
prev_url='https://www.sl2c-36.fr/plan-map-footer' WHERE
ident='1a72e7c539232367e316aeb3f8122368491ff38fa704b5c98b309da3bed15c3f'
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 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
ml.slug='map-footer' AND m.active=1 ORDER BY m.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 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.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,
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 COUNT(m.id) AS num_elem FROM
oktopusV1_mod_map_element AS m   WHERE 1  AND m.id_map = 2 
AND m.type = "route" AND m.active=1 
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
'%\'/plan-map-footer\'%') 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
'%\'/plan-map-footer\'%') ORDER BY p.rubrique DESC

ID	Query	Time
1	`SET NAMES utf8mb4`	0.00014
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='1a72e7c539232367e316aeb3f8122368491ff38fa704b5c98b309da3bed15c3f' WHERE u.id=1`	0.00061
3	`UPDATE oktopusV1_core_users_online SET logged=1726561285, prev_url='https://www.sl2c-36.fr/plan-map-footer' WHERE ident='1a72e7c539232367e316aeb3f8122368491ff38fa704b5c98b309da3bed15c3f'`	0.00020
4	`UPDATE oktopusV1_mod_news SET active = 1 WHERE active = 3 AND NOW() > created_at`	0.00046
5	`UPDATE oktopusV1_mod_news SET active = 0 WHERE active = 1 AND end_at != "0000-00-00 00:00:00" AND NOW() > end_at`	0.00027
6	`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 ml.slug='map-footer' AND m.active=1 ORDER BY m.created_at DESC`	0.00205
7	`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.00144
8	`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.00050
9	`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.00147
10	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, 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.00237
11	`SELECT COUNT(m.id) AS num_elem FROM oktopusV1_mod_map_element AS m WHERE 1 AND m.id_map = 2 AND m.type = "route" AND m.active=1`	0.00031
12	`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.00092
13	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 '%\'/plan-map-footer\'%') ORDER BY p.rubrique DESC	0.00049
14	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 '%\'/plan-map-footer\'%') ORDER BY p.rubrique DESC	0.00044

#	type	fichier	ligne	classe	fonction	message
# 1	Warning	/www/iza1476/www/oktModules/map/inc/class.map.recordset.php	580	oktDebug	errorHandler	Trying to access array offset on value of type null
#0 mapRecordset->getEmbedAddress( called at [/oktModules/map/inc/class.map.recordset.php:96] #1 mapRecordset->getScriptSimple( called at [/oktModules/map/inc/class.map.recordset.php:79] #2 mapRecordset->getScript( called at [/oktThemes/default/templates/map/item/r-default/template.php:17] #3 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36] #4 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106] #5 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60] #6 oktTemplating->render( called at [/oktModules/map/inc/class.map.controller.php:80] #7 mapController->mapItem( called at [/oktInc/classes/router/class.oktRouter.php:317] #8 oktRouter->callRouteHanlder( called at [/oktopus.php:58]
# 2	Warning	/www/iza1476/www/oktModules/map/inc/class.map.recordset.php	580	oktDebug	errorHandler	Trying to access array offset on value of type null
#0 mapRecordset->getEmbedAddress( called at [/oktModules/map/inc/class.map.recordset.php:96] #1 mapRecordset->getScriptSimple( called at [/oktModules/map/inc/class.map.recordset.php:79] #2 mapRecordset->getScript( called at [/oktThemes/default/templates/map/item/r-default/template.php:17] #3 require( called at [/oktInc/vendor/sfTemplating/sfTemplateRendererPhp.php:36] #4 sfTemplateRendererPhp->evaluate( called at [/oktInc/vendor/sfTemplating/sfTemplateEngine.php:106] #5 sfTemplateEngine->render( called at [/oktInc/classes/core/class.oktTemplating.php:60] #6 oktTemplating->render( called at [/oktModules/map/inc/class.map.controller.php:80] #7 mapController->mapItem( called at [/oktInc/classes/router/class.oktRouter.php:317] #8 oktRouter->callRouteHanlder( called at [/oktopus.php:58]