Profiler (0,490 s)

Requêtes (27)

Erreurs (2)

  • Mémoire utilisée par PHP : 3,14 Mo
  • Pic mémoire allouée par PHP : 4,26 Mo
  • Temps d'execution du script : 0.490 s
  • Lang :
  • Path : plan-plan-frontiere-ville
  • Route : mapItem
  • $okt->page->module : map
  • $okt->page->action : item
ID Query Time
1
SET NAMES utf8mb4
0.00022
2
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV4_core_users AS u INNER JOIN
oktopusV4_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV4_core_users_online AS o ON
o.ident='3.238.117.130' WHERE u.id=1
0.00082
3
UPDATE oktopusV4_core_users_online SET logged=1713232885,
prev_url='https://www.saintbriceimmobilier.com/plan-plan-frontiere-ville'
WHERE ident='3.238.117.130'
0.00026
4
SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV4_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV4_mod_estate_i18n_categories_locales AS ecl ON
ecl.category_id=ec.id WHERE 1 AND ecl.language_code='fr' 
AND ec.active=1 
0.00065
5
SELECT ec.id, ec.user_id_created, ec.user_id_updated,
ecl.category_id, ecl.language_code, ecl.name, ecl.slug FROM
oktopusV4_mod_estate_i18n_categories AS ec LEFT JOIN
oktopusV4_mod_estate_i18n_categories_locales AS ecl ON
ecl.category_id=ec.id WHERE 1 AND ecl.language_code='fr' 
AND ec.active=1 
0.00040
6
SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
oktopusV4_mod_estate_i18n_tranches AS tr WHERE 1  AND
tr.field='price' ORDER BY tr.id ASC 
0.00056
7
SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
oktopusV4_mod_estate_i18n_tranches AS tr WHERE 1  AND
tr.field='surface_habitable' ORDER BY tr.id ASC 
0.00025
8
SELECT tr.id, field, tr.depending_data, tr.min, tr.max FROM
oktopusV4_mod_estate_i18n_tranches AS tr WHERE 1  AND
tr.field='surface_terrain' ORDER BY tr.id ASC 
0.00033
9
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.property_type_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_property_types AS pt LEFT
JOIN oktopusV4_mod_estate_i18n_property_types_locales AS ptl
ON ptl.property_type_id=pt.id WHERE 1  AND
ptl.language_code='fr' AND pt.active=1 ORDER BY position 
0.00055
10
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.property_type_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_property_types AS pt LEFT
JOIN oktopusV4_mod_estate_i18n_property_types_locales AS ptl
ON ptl.property_type_id=pt.id WHERE 1  AND
ptl.language_code='fr' AND pt.active=1 ORDER BY position 
0.00025
11
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.house_type_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_house_types AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_house_types_locales AS ptl ON
ptl.house_type_id=pt.id WHERE 1  AND ptl.language_code='fr'
AND pt.active=1 ORDER BY position 
0.00046
12
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.house_type_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_house_types AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_house_types_locales AS ptl ON
ptl.house_type_id=pt.id WHERE 1  AND ptl.language_code='fr'
AND pt.active=1 ORDER BY position 
0.00016
13
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.content, ptl.build_quality_id,
ptl.language_code FROM
oktopusV4_mod_estate_i18n_build_qualities AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_build_qualities_locales AS ptl ON
ptl.build_quality_id=pt.id WHERE 1  AND
ptl.language_code='fr' AND pt.active=1 ORDER BY position 
0.00045
14
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, pt.dep, pt.latitude, pt.longitude,
ptl.sector_id, ptl.language_code FROM
oktopusV4_mod_estate_i18n_sectors AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_sectors_locales AS ptl ON
ptl.sector_id=pt.id WHERE 1  AND ptl.language_code='fr' AND
pt.active=1 ORDER BY position 
0.00054
15
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, pt.dep, pt.latitude, pt.longitude,
ptl.sector_id, ptl.language_code FROM
oktopusV4_mod_estate_i18n_sectors AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_sectors_locales AS ptl ON
ptl.sector_id=pt.id WHERE 1  AND ptl.language_code='fr' AND
pt.active=1 ORDER BY position 
0.00017
16
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.condition_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_conditions AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_conditions_locales AS ptl ON
ptl.condition_id=pt.id WHERE 1  AND ptl.language_code='fr'
AND pt.active=1 ORDER BY position 
0.00042
17
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.heating_type_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_heating_types AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_heating_types_locales AS ptl ON
ptl.heating_type_id=pt.id WHERE 1  AND
ptl.language_code='fr' AND pt.active=1 ORDER BY position 
0.00051
18
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.heating_type_id, ptl.language_code
FROM oktopusV4_mod_estate_i18n_heating_types AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_heating_types_locales AS ptl ON
ptl.heating_type_id=pt.id WHERE 1  AND
ptl.language_code='fr' AND pt.active=1 ORDER BY position 
0.00021
19
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.heating_nature_id,
ptl.language_code FROM
oktopusV4_mod_estate_i18n_heating_natures AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_heating_natures_locales AS ptl ON
ptl.heating_nature_id=pt.id WHERE 1  AND
ptl.language_code='fr' AND pt.active=1 ORDER BY position 
0.00066
20
SELECT pt.id, pt.user_id_created, pt.user_id_updated,
pt.active, pt.position, pt.created_at, pt.updated_at,
ptl.slug, ptl.title, ptl.kitchen_id, ptl.language_code FROM
oktopusV4_mod_estate_i18n_kitchens AS pt LEFT JOIN
oktopusV4_mod_estate_i18n_kitchens_locales AS ptl ON
ptl.kitchen_id=pt.id WHERE 1  AND ptl.language_code='fr' AND
pt.active=1 ORDER BY position 
0.00061
21
SELECT o.id, o.user_id_created, o.user_id_updated,
o.lastname, o.firstname, o.adress, o.zip, o.city, o.tel,
o.gsm_tel_1, o.gsm_tel_2, o.fax, o.mail, o.comments,
o.active, o.position, o.created_at, o.updated_at FROM
oktopusV4_mod_estate_i18n_owners AS o WHERE 1 AND o.active=1
ORDER BY lastname 
0.00054
22
SELECT m.*, 
                              ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM oktopusV4_mod_map AS m 
LEFT JOIN oktopusV4_mod_map_locales AS ml ON m.id=ml.id_map
AND ml.language='fr' WHERE 1  AND ml.language='fr'  AND
ml.slug='plan-frontiere-ville' AND m.active=1 ORDER BY
m.created_at DESC 
0.00342
23
SELECT m.*, 
                              ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM oktopusV4_mod_map AS m 
LEFT JOIN oktopusV4_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.00120
24
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 oktopusV4_mod_pages AS p  INNER JOIN
oktopusV4_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='fr'  LEFT OUTER JOIN
oktopusV4_mod_pages_categories AS r ON r.id=p.category_id 
LEFT OUTER JOIN oktopusV4_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.00312
25
SELECT COUNT(m.id) AS num_elem FROM
oktopusV4_mod_map_element AS m   WHERE 1  AND m.id_map = 3 
AND m.type = "route" AND m.active=1 
0.00060
26
SELECT m.* FROM oktopusV4_mod_map_element AS m WHERE 1  AND
m.id_map = 3 AND m.active=1  AND m.type NOT
IN("marker","markerAddress") ORDER BY m.created_at DESC 
0.00037
27
SELECT m.* FROM oktopusV4_mod_map_element AS m WHERE 1  AND
m.id_map = 3 AND m.active=1  AND m.type
IN("marker","markerAddress") ORDER BY m.created_at DESC 
0.00034
# type fichier ligne classe fonction message
# 1  Warning /www/iza402/www/oktModules/map/inc/class.map.recordset.php 504 oktDebug errorHandler Undefined index: lat

#0 mapRecordset->getPaths( called at [/oktModules/map/inc/class.map.recordset.php:345]


#1 mapRecordset->polygon( called at [/oktModules/map/inc/class.map.recordset.php:327]


#2 mapRecordset->loadElements( called at [/oktModules/map/inc/class.map.recordset.php:123]


#3 mapRecordset->generateElements( called at [/oktModules/map/inc/class.map.recordset.php:117]


#4 mapRecordset->getScriptAdvanced( called at [/oktModules/map/inc/class.map.recordset.php:77]


#5 mapRecordset->getScript( called at [/oktThemes/default/templates/map/item/r-default/template.php:17]


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


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


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


#9 oktTemplating->render( called at [/oktModules/map/inc/class.map.controller.php:80]


#10 mapController->mapItem( called at [/oktInc/classes/router/class.oktRouter.php:305]


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

# 2  Warning /www/iza402/www/oktModules/map/inc/class.map.recordset.php 504 oktDebug errorHandler count(): Parameter must be an array or an object that implements Countable

#0 mapRecordset->getPaths( called at [/oktModules/map/inc/class.map.recordset.php:345]


#1 mapRecordset->polygon( called at [/oktModules/map/inc/class.map.recordset.php:327]


#2 mapRecordset->loadElements( called at [/oktModules/map/inc/class.map.recordset.php:123]


#3 mapRecordset->generateElements( called at [/oktModules/map/inc/class.map.recordset.php:117]


#4 mapRecordset->getScriptAdvanced( called at [/oktModules/map/inc/class.map.recordset.php:77]


#5 mapRecordset->getScript( called at [/oktThemes/default/templates/map/item/r-default/template.php:17]


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


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


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


#9 oktTemplating->render( called at [/oktModules/map/inc/class.map.controller.php:80]


#10 mapController->mapItem( called at [/oktInc/classes/router/class.oktRouter.php:305]


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