• Damien Pinon

  • Mémoire utilisée par PHP : 2.41 MB
  • Pic mémoire allouée par PHP : 3.70 MB
  • Temps d'execution du script : 0.340 s
  • Lang : en
  • Path : actualites
  • Route : newsList
  • $okt->page->module : news
  • $okt->page->action : list
  • Title tag : Events/Exhibitions - EARL DAMIEN PINON
  • Title: Events/Exhibitions
  • H1:
  • Meta description:
  • Meta keyword:
ID Query Time
1
SET NAMES utf8mb4
0.00015
2
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV2_core_users AS u INNER JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV2_core_users_online AS o ON
o.ident='954e31f38972c6b0ad26976d8fc4fc73171afeb7d5c5b69333b5c5fbc3770eda'
WHERE u.id=1
0.00062
3
REPLACE INTO oktopusV2_core_users_online (user_id, ident,
logged, csrf_token, prev_url) VALUES
(1,'954e31f38972c6b0ad26976d8fc4fc73171afeb7d5c5b69333b5c5fbc3770eda',
1734784090, '2c34fd1359784e1a3aec78985df821e5ec37ce65',
'https://www.damienpinon.com/en/actualites')
0.00017
4
UPDATE oktopusV2_mod_news SET active = 1

                           WHERE active = 3 AND NOW() >
created_at 
0.00047
5
UPDATE oktopusV2_mod_news SET active = 1

                           WHERE active = 3 AND NOW() >
created_at 
0.00019
6
SELECT id, title, code, img, active, ord FROM
oktopusV2_core_languages WHERE 1  AND code='en' ORDER BY ord
ASC 
0.00044
7
SELECT COUNT(p.id) AS num_posts FROM oktopusV2_mod_news AS p
 LEFT OUTER JOIN oktopusV2_core_users AS u ON u.id=p.user_id
 INNER JOIN oktopusV2_mod_news_locales AS pl ON
p.id=pl.post_id AND pl.language='en'  LEFT OUTER JOIN
oktopusV2_mod_news_categories AS r ON r.id=p.category_id 
LEFT OUTER JOIN oktopusV2_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.00054
8
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 oktopusV2_mod_news AS p  LEFT OUTER
JOIN oktopusV2_core_users AS u ON u.id=p.user_id  INNER JOIN
oktopusV2_mod_news_locales AS pl ON p.id=pl.post_id AND
pl.language='en'  LEFT OUTER JOIN
oktopusV2_mod_news_categories AS r ON r.id=p.category_id 
LEFT OUTER JOIN oktopusV2_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.00120
9
SELECT m.*, 
                              ml.language, ml.title,
ml.title_tag, ml.title_seo, ml.slug, ml.meta_description,
ml.meta_keywords, ml.content FROM oktopusV2_mod_map AS m 
LEFT JOIN oktopusV2_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.00083
10
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
oktopusV2_mod_social_network_reseau snr
                      JOIN
oktopusV2_mod_social_network_reseau_locales snrl ON
snrl.id_reseau = snr.id_reseau AND snrl.language = 'en'
WHERE 1  AND active = '1' ORDER BY snrl.libelle
0.00080
11
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 FROM
oktopusV2_mod_pages AS p  INNER JOIN
oktopusV2_mod_pages_locales AS pl ON p.id=pl.page_id AND
pl.language='en'  LEFT OUTER JOIN
oktopusV2_mod_pages_categories AS r ON r.id=p.category_id 
LEFT OUTER JOIN oktopusV2_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.00071
12
 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 oktopusV2_mod_slideshow_type t
                       WHERE 1 AND CASE 
                                       WHEN t.choix_rubrique
= 1 THEN
                                           t.rubrique LIKE
'%\'/en/actualites\'%'
                                       WHEN t.choix_rubrique
= 2 THEN
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV2_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE '%\'/en/actualites\'%' AND t.actif = 1
                   ) = 0
                
                                           AND
                                           t.rubrique NOT
LIKE '%\'/en/actualites\'%'
                                       ELSE     
                                          
                   (  SELECT COUNT(t.id_type) FROM
oktopusV2_mod_slideshow_type t
                      WHERE t.choix_rubrique = 1 AND
t.rubrique LIKE '%\'/en/actualites\'%' AND t.actif = 1
                   ) = 0
                 
                                   END AND actif = '1' ORDER
BY nom 
0.00051
13
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 oktopusV2_mod_slideshow_type t
                     WHERE t.id_type = '2'
0.00013
14
 SELECT p.*, pl.valeur AS legende, pl.lien,
pl.contenu_titre,  pl.contenu_ss_titre,
pl.contenu_description, pl.primaire_texte,
pl.primaire_texte_mobile, pl.secondaire_texte,
pl.secondaire_texte_mobile, pl.primaire_slug,
pl.secondaire_slug, pl.lien2,  
                          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 oktopusV2_mod_slideshow p
                       LEFT JOIN
oktopusV2_mod_slideshow_locales pl ON pl.id_slideshow =
p.id_slideshow AND pl.language = 'en'
                       WHERE 1 AND p.actif = '1' AND id_type
= '2' ORDER BY position
0.00041
15
SELECT DISTINCT sn.*, snl.*
                      FROM oktopusV2_mod_social_network sn
                      JOIN
oktopusV2_mod_social_network_locales snl ON
snl.id_social_network = sn.id_social_network AND
snl.language = 'en' WHERE 1  AND sn.url != '' AND sn.type !=
''  AND type LIKE '%F%' ORDER BY sn.position
0.00076
16
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 oktopusV2_mod_home_popup p
                      LEFT JOIN
oktopusV2_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'en'
                      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
'%\'/en/actualites\'%') ORDER BY p.rubrique DESC
0.00049
17
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 oktopusV2_mod_home_popup p
                      LEFT JOIN
oktopusV2_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'en'
                      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
'%\'/en/actualites\'%') ORDER BY p.rubrique DESC
0.00037
18
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 oktopusV2_mod_home_popup p
                      LEFT JOIN
oktopusV2_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'en'
                      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
'%\'/en/actualites\'%') ORDER BY p.rubrique DESC
0.00036
19
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 oktopusV2_mod_home_popup p
                      LEFT JOIN
oktopusV2_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'en'
                      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
'%\'/en/actualites\'%') ORDER BY p.rubrique DESC
0.00035
# type fichier ligne classe fonction message
# 1  Error /www/ya18049/www/oktThemes/ra162-s/oktTheme.php 88 oktDebug errorHandler Creation of dynamic property oktTheme::$curLanguage is deprecated

#0 oktTheme->setCurLanguage( called at [/oktThemes/ra162-s/oktTheme.php:79]


#1 oktTheme->prepend( called at [/oktInc/classes/themes/class.oktThemeBase.php:125]


#2 oktThemeBase->init( called at [/oktInc/classes/themes/class.oktThemeBase.php:60]


#3 oktThemeBase->__construct( called at [/oktInc/public/prepend.php:46]


#4 require_once( called at [/oktPrepend.php:17]


#5 require_once( called at [/oktopus.php:17]

# 2  Warning /www/ya18049/www/oktInc/classes/libs/lib.picture.php 64 oktDebug errorHandler getimagesize(/www/ya18049/_new/www/upload/modules/news/img/1/min-list-xl-1.webp): Failed to open stream: No such file or directory

#0 getimagesize( called at [/oktInc/classes/libs/lib.picture.php:64]


#1 picture::getHtml( called at [/oktThemes/ra162-s/templates/news/list/actualites-modele-1-a-em-pour-de-long-titre-darticle-v-5-4-1-em/template.php:91]


#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 [/oktModules/news/inc/class.news.controller.php:152]


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


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

# 3  Warning /www/ya18049/www/oktInc/classes/libs/lib.picture.php 70 oktDebug errorHandler Trying to access array offset on value of type bool

#0 picture::getHtml( called at [/oktThemes/ra162-s/templates/news/list/actualites-modele-1-a-em-pour-de-long-titre-darticle-v-5-4-1-em/template.php:91]


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


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


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


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


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


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

# 4  Warning /www/ya18049/www/oktThemes/ra162-s/templates/layout.php 421 oktDebug errorHandler Undefined variable $id

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


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


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


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


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


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


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


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

# 5  Warning /www/ya18049/www/oktThemes/ra162-s/templates/layout.php 437 oktDebug errorHandler Undefined variable $colonne

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


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


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


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


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


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


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


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