MODE DEBUG
PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
SELECT id_page FROM ga_page WHERE page_url="emissions"
SELECT COUNT(1) count FROM ga_page WHERE page_url="emissions" AND page_link="0"
SELECT id_page FROM ga_page WHERE page_link="70" AND page_url="super-blender-20102012"
Page::getPageDynamic
Page::getModels
SELECT model_name FROM ga_model WHERE model_type="page"
SELECT id_utilisateur, page_name, page_title, page_description, page_keywords FROM ma_utilisateur WHERE page_url="super-blender-20102012"
SELECT id_stage, page_name, page_title, page_description, page_keywords FROM ma_stage WHERE page_url="super-blender-20102012"
SELECT id_programme, page_name, page_title, page_description, page_keywords FROM ma_programme WHERE page_url="super-blender-20102012"
SELECT id_emission, page_name, page_title, page_description, page_keywords FROM ma_emission WHERE page_url="super-blender-20102012"
SELECT id_page,page_link FROM ga_page WHERE page_url="emission"
SELECT page_url FROM ga_page WHERE id_page="70"
SELECT page_url FROM ga_page WHERE id_page="8"
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="emission" AND page_type="1"
Page::getCssPage
SELECT ga_file.file_name FROM ga_file, ga_file_page WHERE ga_file.id_file=ga_file_page.id_file AND ga_file_page.id_page="8" AND file_extension="css" ORDER BY ga_file_page.id_file_page
Page::getJsPage
SELECT ga_file.file_name FROM ga_file, ga_file_page WHERE ga_file.id_file=ga_file_page.id_file AND ga_file_page.id_page="8" AND file_extension="js" ORDER BY ga_file_page.id_file_page
Page::getRSSPage
SELECT rss_url,rss_description FROM ga_rss,ga_page_rss WHERE ga_page_rss.id_page='8' AND ga_page_rss.id_rss=ga_rss.id_rss ORDER BY ga_rss.id_rss
Site::getConfig
SELECT * FROM ga_config
PageBuilderPublic::buildPage
dataflow::__construct
dataflow::getDataflowQueries
Récupération des requêtes supplémentaires.
SELECT ga_query.id_query, ga_query_asso.query_asso_order, ga_query.query_column, ga_query.query_table, ga_query.query_where, ga_query.query_group, ga_query.query_order, ga_query.query_left, ga_query.query_on, ga_query.query_list, ga_query.query_limit, ga_query.query_type, ga_query.query_log, ga_query.query_output_name, ga_fileprocess.fileprocess_name FROM ( ga_dataflow, ga_query, ga_query_asso) LEFT JOIN ga_fileprocess ON ga_dataflow.id_fileprocess=ga_fileprocess.id_fileprocess WHERE ga_dataflow.dataflow_name="emission" AND ga_dataflow.id_dataflow=ga_query_asso.id_dataflow AND ga_query.id_query=ga_query_asso.id_query ORDER BY ga_query_asso.query_asso_order, ga_query.query_list
SELECT ma_emission.id_emission, ma_emission.page_name, ma_emission.page_url, ma_emission.page_title, ma_emission.page_description, ma_emission.page_keywords, ma_emission.emission_datetime, ma_emission.emission_datetime_fin, ma_emission.emission_duree, ma_emission.emission_sujet, ma_emission.emission_entete, ma_emission.emission_description, ma_emission.emission_audio, ma_emission.id_playlist_emission, ma_programme.programme_nom, ma_programme.programme_description, ma_media.media_name, ma_media.media_description, ma_programme.page_url media_repertoire, ma_programme.id_programme FROM ( ma_emission) LEFT JOIN ma_programme ON ma_programme.id_programme=ma_emission.id_programme LEFT JOIN ma_media ON ma_media.id_programme=ma_emission.id_programme WHERE ma_emission.page_url="super-blender-20102012"
SELECT ma_media.media_name emission_media_name, ma_media.media_description emission_media_description FROM ( ma_emission) LEFT JOIN ma_media ON ma_media.id_emission=ma_emission.id_emission WHERE page_url="super-blender-20102012" AND media_type='une'
SELECT ma_evenement.page_url, ma_evenement.evenement_nom, ma_evenement.evenement_type, ma_evenement.evenement_debut, ma_evenement.evenement_entete, ma_evenement.evenement_etat, ma_media.media_name FROM ( ma_evenement) LEFT JOIN ma_media ON ma_media.id_evenement=ma_evenement.id_evenement WHERE ma_evenement.evenement_debut>=NOW() AND ma_evenement.evenement_etat='2' ORDER BY ma_evenement.evenement_debut ASC LIMIT 5
SELECT ma_tag.tag_name FROM ( ma_emission) LEFT JOIN ma_tag ON ma_tag.id_programme=ma_emission.id_programme WHERE ma_emission.page_url="super-blender-20102012"
SELECT ma_emission.page_url, ma_emission.emission_datetime, ma_emission.emission_entete, ma_programme.programme_nom, programme_entete, ma_media.media_name FROM ( ma_emission) LEFT JOIN ma_programme ON ma_programme.id_programme=ma_emission.id_programme LEFT JOIN ma_media ON ma_media.id_programme=ma_emission.id_programme WHERE ma_emission.emission_datetime>=CURDATE() AND ma_emission.emission_datetime<=CURDATE()+1 ORDER BY ma_emission.emission_datetime ASC
SELECT ma_media.media_name, ma_media.media_description FROM ( ma_emission) LEFT JOIN ma_media ON ma_media.id_emission=ma_emission.id_emission WHERE page_url="super-blender-20102012" AND ma_media.media_type='son'
SELECT ma_commentaire.id_commentaire, ma_commentaire.commentaire_name, ma_commentaire.commentaire_contenu, ma_commentaire.commentaire_date, ma_commentaire.commentaire_auteur, ma_commentaire.id_article, ma_commentaire.id_emission, ma_commentaire.commentaire_email FROM ( ma_commentaire) LEFT JOIN ma_emission ON ma_commentaire.id_emission=ma_emission.id_emission WHERE ma_emission.page_url="super-blender-20102012" AND ma_commentaire.commentaire_status=1 ORDER BY ma_commentaire.commentaire_date ASC
Appel d'un fichier de post-traitement : /action/process/dataflow/emissions_programme.php
SELECT ma_emission.emission_datetime,ma_emission.page_url,ma_emission.emission_sujet
FROM ma_emission
WHERE id_programme='26' AND
emission_datetime<=CURRENT_DATE()
ORDER BY emission_datetime DESC
SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='26' AND
emission_datetime>=NOW()
ORDER BY emission_datetime ASC
LIMIT 1
SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='26' AND
emission_datetime<'2012-10-20 13:00:00'
ORDER BY emission_datetime DESC
LIMIT 1
SELECT ma_emission.emission_datetime,ma_emission.emission_sujet,page_url
FROM ma_emission
WHERE id_programme='26' AND
emission_datetime>'2012-10-20 13:00:00'
ORDER BY emission_datetime ASC
LIMIT 1
SELECT id_em_titre, em_titre_name, em_titre_artiste,
id_emission, em_titre_label, em_titre_annee,
em_titre_album, em_titre_site, em_titre_facebook,
em_titre_twitter, em_titre_bandcamp, em_titre_myspace,
em_titre_soundcloud, em_titre_mixcloud, em_titre_ra,
em_titre_youtube, em_titre_vimeo, em_titre_discogs,
em_titre_cover
FROM ma_em_titre
WHERE id_emission='2902'
Données envoyés au template :
Array
(
[id_emission] => 2902
[page_name] => Super Blender - 20/10/2012
[page_url] => super-blender-20102012
[page_title] => Super Blender - 20/10/2012
[page_description] =>
[page_keywords] =>
[emission_datetime] => 2012-10-20 13:00:00
[emission_datetime_fin] => 2012-10-20 13:59:00
[emission_duree] => 59
[emission_sujet] => Mange ton gazon
[emission_entete] => Saison 1 - Emission 1
[emission_description] =>
[emission_audio] =>
[id_playlist_emission] => 0
[programme_nom] => Super Blender
[programme_description] =>
Super Blender : malaxeur d'idées, brasseur de goûts !
Nous autres Francais accordons une place particulière dans nos vies à... la nourriture.
Super Blender c'est l'émission qui cuisine les sujets de société qui touchent à la sphère alimentaire.
Super Blender teste également pour vous des curiosités culinaires sans oublier de vous faire part d'astuces étonnantes et de bons plans !
[media_name] => 2012-09-28-7dd7a9697791767c406ab890930dc405.jpg
[media_description] =>
[media_repertoire] => super-blender
[id_programme] => 26
[evenements_liste] => Array
(
[0] => Array
(
[page_url] => la-cale-du-r7-soul-18-05-2013
[evenement_nom] => La Cale du R7 - Soul
[evenement_type] => partenaire
[evenement_debut] => 2013-05-18 18:00:00
[evenement_entete] => Concert - Soul
[evenement_etat] => 2
[media_name] => 2013-05-02-017b4bb3281b62bed032e38adfabacd2.jpg
)
[1] => Array
(
[page_url] => festa-nordestina-18-05-2013
[evenement_nom] => Festa Nordestina
[evenement_type] => partenaire
[evenement_debut] => 2013-05-18 18:00:00
[evenement_entete] => Concert - Brésil festif !
[evenement_etat] => 2
[media_name] => 2013-05-06-8e6452eb33dd639a3ac605498ab511e6.jpg
)
[2] => Array
(
[page_url] => winston-mac-anuff-18-05-2013
[evenement_nom] => Winston Mac Anuff
[evenement_type] => partenaire
[evenement_debut] => 2013-05-18 20:30:00
[evenement_entete] => Concert - Reggae / Soul
[evenement_etat] => 2
[media_name] => 2013-04-30-a3d9356779f565b1afec1fdc89643a5c.jpg
)
[3] => Array
(
[page_url] => the-feeling-of-love-18-05-2013
[evenement_nom] => The Feeling of love
[evenement_type] => partenaire
[evenement_debut] => 2013-05-18 21:00:00
[evenement_entete] => Concert - Garage / Punk / Krautrock
[evenement_etat] => 2
[media_name] => 2013-05-06-4808d7f636b1eaa8a6fb791ee648c23d.jpg
)
[4] => Array
(
[page_url] => tribe-it-18-05-2013
[evenement_nom] => Tribe it
[evenement_type] => partenaire
[evenement_debut] => 2013-05-18 21:00:00
[evenement_entete] => Concert - Didgeridoo trip
[evenement_etat] => 2
[media_name] => 2013-05-07-d79d19bb044bf3e1e3d596f053a9d605.jpg
)
)
[tags_liste] => Array
(
[0] => Array
(
[tag_name] => nourriture
)
[1] => Array
(
[tag_name] => débats
)
[2] => Array
(
[tag_name] => curiosités
)
)
[prochaine_emission_liste] => Array
(
[0] => Array
(
[page_url] => rip-eat-up-18052013
[emission_datetime] => 2013-05-18 00:00:00
[emission_entete] =>
[programme_nom] => Rip Eat Up
[programme_entete] => Défrichage des musiques électroniques par une passionnée
[media_name] => 2012-10-09-fef95652f1eb7401e007ad35885261bf.jpg
)
[1] => Array
(
[page_url] => smooth-morning-18052013
[emission_datetime] => 2013-05-18 08:00:00
[emission_entete] =>
[programme_nom] => Smooth Morning
[programme_entete] => Réveillez-vous en douceur avec une émulsion musicale relaxante
[media_name] => 2012-11-29-0700601b5507e51abce9e8e4ca5176ef.jpg
)
[2] => Array
(
[page_url] => tracks-breakfast-18-05-2013
[emission_datetime] => 2013-05-18 10:00:00
[emission_entete] =>
[programme_nom] => Tracks & Breakfast
[programme_entete] => Emission d'actualité musicale mais pas que !
[media_name] => 2012-09-25-9a0aab536bc0e69d35a3e94684e0d41e.jpg
)
[3] => Array
(
[page_url] => toc-toc-toc-18-05-2013
[emission_datetime] => 2013-05-18 11:00:00
[emission_entete] =>
[programme_nom] => Toc Toc Toc
[programme_entete] => Création, psychanalyse, éducation, bénévolat, aventures humaines...
[media_name] => 2012-09-27-86268811461e182c28c2a6b4c4ae1165.jpg
)
[4] => Array
(
[page_url] => incredibilibi-18052013
[emission_datetime] => 2013-05-18 12:00:00
[emission_entete] =>
[programme_nom] => Incredibilibi
[programme_entete] => 120 minutes d'actualités incrédibiliesques....
[media_name] => 2012-10-09-b2094eb7f2dfc1e7f4e1c1ed3f1ddff5.jpg
)
[5] => Array
(
[page_url] => hoop-kultur-18-05-2013
[emission_datetime] => 2013-05-18 14:00:00
[emission_entete] =>
[programme_nom] => Hoop Kultur
[programme_entete] => Voyage de curiosité en quête des cultures alternatives et indisciplinées
[media_name] => 2012-10-09-2253a2845d895175ea05237f3eb1fa6d.jpg
)
[6] => Array
(
[page_url] => disques-et-sons-de-comptoir-18-05-2013
[emission_datetime] => 2013-05-18 15:00:00
[emission_entete] =>
[programme_nom] => Disques et sons de comptoir
[programme_entete] => Emission de découverte de la nouvelle scène francophone
[media_name] => 2012-10-01-79b5f64cb92ae124712f30b9142eee9f.jpg
)
[7] => Array
(
[page_url] => kobaia-18-05-2013
[emission_datetime] => 2013-05-18 16:00:00
[emission_entete] =>
[programme_nom] => Kobaïa
[programme_entete] => Emission de musiques éléctriques et expérimentales
[media_name] => 2012-09-24-38bb288856da07f502f197c52947455f.jpg
)
[8] => Array
(
[page_url] => inna-di-roots-18-05-2013
[emission_datetime] => 2013-05-18 17:00:00
[emission_entete] =>
[programme_nom] => Inna Di Roots
[programme_entete] => Sonorités jamaïcaines depuis leurs origines jusqu'à nos jours
[media_name] => 2012-10-01-33f8537d680d43f05d0f0cfe9f1bfb07.jpg
)
[9] => Array
(
[page_url] => take-jazz-18-05-2013
[emission_datetime] => 2013-05-18 18:00:00
[emission_entete] =>
[programme_nom] => Take Jazz
[programme_entete] => Emission de tous les jazz en compagnie de Tom Select et François
[media_name] => 2012-10-02-da14dd5ede6273ae6621eefdd0e7ec40.jpg
)
[10] => Array
(
[page_url] => groove-au-logis-18-05-2013
[emission_datetime] => 2013-05-18 19:00:00
[emission_entete] =>
[programme_nom] => Groove au Logis
[programme_entete] => Black Music d'hier à aujourd'hui dans votre Logis !
[media_name] => 2012-09-27-79b1bfc2ca0c5fe748622baef75fca12.jpg
)
[11] => Array
(
[page_url] => les-oreilles-de-jankev-18-05-2013
[emission_datetime] => 2013-05-18 20:00:00
[emission_entete] =>
[programme_nom] => Les oreilles de Jankev
[programme_entete] => Toute l'actu musique, c'est dans Les oreilles de Jankev
[media_name] => 2012-09-27-68cf8f7fdb5278e310c41aadbb1ac382.jpg
)
[12] => Array
(
[page_url] => cosmic-show-18-05-2013
[emission_datetime] => 2013-05-18 21:00:00
[emission_entete] =>
[programme_nom] => Cosmic Show
[programme_entete] => Musique, découverte, mix live, interview et bonne humeur !
[media_name] => 2012-10-02-3199c5531a924c95f7b4cfb007736ade.jpg
)
[13] => Array
(
[page_url] => emission-speciale-18052013
[emission_datetime] => 2013-05-18 22:00:00
[emission_entete] => En direct de chez oim !
[programme_nom] => Emission Spéciale
[programme_entete] => Prun' en direct pour une émission spéciale.
[media_name] => 2012-10-16-31755eeba6d5da8bb0c795d18e2a91a2.jpg
)
)
[podcast_liste] => Array
(
[0] => Array
(
[media_name] => super-blender-20121020-1.mp3
[media_description] => Super Blender 20/10/2012 Partie 1
)
)
[emissions_passees_liste] => Array
(
[0] => Array
(
[emission_datetime] => 2013-04-27 12:00:00
[page_url] => super-blender-27042013
[emission_sujet] => Saison 1 - Emission 7
)
[1] => Array
(
[emission_datetime] => 2013-03-30 12:00:00
[page_url] => super-blender-30032013
[emission_sujet] => La chevauchée des vaches qui rient
)
[2] => Array
(
[emission_datetime] => 2013-02-23 12:00:00
[page_url] => super-blender-23022013
[emission_sujet] => La multiplication des pains
)
[3] => Array
(
[emission_datetime] => 2013-01-26 12:00:00
[page_url] => super-blender-26012013
[emission_sujet] => Produire plus pour manger plus
)
[4] => Array
(
[emission_datetime] => 2012-12-22 12:00:00
[page_url] => super-blender-22122012
[emission_sujet] => Cake à la mode cherche cup
)
[5] => Array
(
[emission_datetime] => 2012-11-24 12:00:00
[page_url] => super-blender-24112012
[emission_sujet] => Saveurs azotiques
)
[6] => Array
(
[emission_datetime] => 2012-10-20 13:00:00
[page_url] => super-blender-20102012
[emission_sujet] => Mange ton gazon
)
)
[prochaine_emission_programme] => Array
(
[emission_datetime] => 2013-05-25 12:00:00
[emission_sujet] => Saison 1 - Emission 8
[page_url] => super-blender-25052013
)
[precedente_emission_programme] => 0
[suivante_emission_programme] => Array
(
[emission_datetime] => 2012-11-24 12:00:00
[emission_sujet] => Saveurs azotiques
[page_url] => super-blender-24112012
)
[playlist] => Array
(
)
)
PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"