News

 

Profiler (0.663 s)

Requêtes (11)

Erreurs (1)

  • Mémoire utilisée par PHP : 10.71 MB
  • Pic mémoire allouée par PHP : 11.76 MB
  • Temps d'execution du script : 0.663 s
  • Lang : en
  • Path : news
  • Route : newsList
  • $okt->page->module : news
  • $okt->page->action : list
ID Query Time
1
SET NAMES utf8mb4
0.00048
2
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
V3_core_users AS u INNER JOIN V3_core_users_groups AS g ON
g.group_id=u.group_id LEFT JOIN V3_core_users_online AS o ON
o.ident='18.234.255.5' WHERE u.id=1
0.00142
3
UPDATE V3_core_users_online SET logged=1606789292,
prev_url='https://www.faops.net/en/news' WHERE
ident='18.234.255.5'
0.00363
4
UPDATE V3_mod_news SET active = 1
                           WHERE active = 3 AND NOW() >
created_at 
0.00079
5
UPDATE V3_mod_news SET active = 0
                              WHERE active = 1 AND end_at !=
"0000-00-00 00:00:00" 
                              AND NOW() > end_at 
0.00072
6
SELECT COUNT(p.id) AS num_posts FROM V3_mod_news AS p  LEFT
OUTER JOIN V3_core_users AS u ON u.id=p.user_id  INNER JOIN
V3_mod_news_locales AS pl ON p.id=pl.post_id AND
pl.language='en'  LEFT OUTER JOIN V3_mod_news_categories AS
r ON r.id=p.category_id  LEFT OUTER JOIN
V3_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 
0.00351
7
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.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
V3_mod_news AS p  LEFT OUTER JOIN V3_core_users AS u ON
u.id=p.user_id  INNER JOIN V3_mod_news_locales AS pl ON
p.id=pl.post_id AND pl.language='en'  LEFT OUTER JOIN
V3_mod_news_categories AS r ON r.id=p.category_id  LEFT
OUTER JOIN V3_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 0,5 
0.00112
8
SELECT m.*, 
                              ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM V3_mod_map AS m  LEFT JOIN
V3_mod_map_locales AS ml ON m.id=ml.id_map AND
ml.language='en' WHERE 1  AND ml.language='en' AND
m.active=1 ORDER BY m.created_at DESC 
0.00231
9
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 FROM
V3_mod_pages AS p  INNER JOIN V3_mod_pages_locales AS pl ON
p.id=pl.page_id AND pl.language='en'  LEFT OUTER JOIN
V3_mod_pages_categories AS r ON r.id=p.category_id  LEFT
OUTER JOIN V3_mod_pages_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.created_at DESC 
0.00542
10
SELECT m.*, 
                              ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM V3_mod_map AS m  LEFT JOIN
V3_mod_map_locales AS ml ON m.id=ml.id_map AND
ml.language='en' WHERE 1  AND m.id = 2  AND ml.language='en'
AND m.active=1 ORDER BY m.created_at DESC 
0.00095
11
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
V3_mod_contact_fields f LEFT JOIN
V3_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.00379
# type fichier ligne classe fonction message
# 1  Warning /www/2013/07/ca3043/www/oktModules/map/inc/class.map.recordset.php 587 oktDebug errorHandler Undefined index:

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


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


#2 mapRecordset->getScript( called at [/oktThemes/default/templates/map/insert/r-vertical/template.php:31]


#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 [/oktInc/vendor/sfTemplating/sfTemplateRenderer.php:45]


#7 sfTemplateRenderer->__call( called at [/oktThemes/ra137-s/templates/layout.php:199]


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


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


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


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


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


#13 oktTemplating->render( called at [/oktModules/news/inc/class.news.controller.php:94]


#14 newsController->newsList( called at [/oktInc/classes/router/class.oktRouter.php:305]


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