MODE DEBUG

PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
SELECT id_page FROM ga_page WHERE page_url="materiel"

SELECT COUNT(1) count FROM ga_page WHERE page_url="materiel" AND page_link="0"

SELECT id_page FROM ga_page WHERE page_link="53" AND page_url="neuf"

SELECT page_url FROM ga_page WHERE id_page="108"

Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="neuf" AND page_type=""

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="108" 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="108" 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='108' 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="neuf" 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_produit.page_url, ma_produit.id_modele, ma_produit.produit_selection, ma_produit.produit_neuf, ma_produit.produit_prix_visible, ma_produit.produit_annee, ma_produit.produit_prix_vente, ma_produit.produit_visuel1, ma_modele.id_marque, ma_modele.id_modele, ma_modele.modele_visuel1, ma_modele.modele_intitule, ma_modele.modele_marque_autre, ma_marque.marque_name FROM ( ma_produit) LEFT JOIN ma_modele ON ma_produit.id_modele=ma_modele.id_modele LEFT JOIN ma_marque ON ma_modele.id_marque=ma_marque.id_marque WHERE ma_produit.produit_selection="1" and ma_produit.produit_neuf ORDER BY RAND() LIMIT 6

SELECT ma_type.id_type, ma_type.page_url, ma_type.page_name, ma_type.type_nom FROM ma_type ORDER BY ma_type.page_name ASC


Données envoyés au template :
Array
(
[selection_neuf_groupe] => Array
(
[0] => Array
(
[page_url] => 536-60-agripro
[id_modele] => 424
[produit_selection] => 1
[produit_neuf] => 1
[produit_prix_visible] => 0
[produit_annee] => 2018
[produit_prix_vente] => 0
[produit_visuel1] => 478-70bc3400fb6fbaef7e2b1bd6b45d255d.jpg
[id_marque] => 1
[modele_visuel1] =>
[modele_intitule] => 536-60 AGRIPRO
[modele_marque_autre] =>
[marque_name] => JCB
)

[1] => Array
(
[page_url] => nx-4510h-1000472
[id_modele] => 235
[produit_selection] => 1
[produit_neuf] => 1
[produit_prix_visible] => 0
[produit_annee] => 2014
[produit_prix_vente] => 19849
[produit_visuel1] => 287-db93a5a447a3f4f44fb67c5361e042ce.jpg
[id_marque] => 4
[modele_visuel1] =>
[modele_intitule] => NX 4510H
[modele_marque_autre] => KIOTI
[marque_name] => Autres
)

[2] => Array
(
[page_url] => 4220
[id_modele] => 423
[produit_selection] => 1
[produit_neuf] => 1
[produit_prix_visible] => 0
[produit_annee] => 2018
[produit_prix_vente] => 0
[produit_visuel1] => 477-c76e057d17e32dd77f179460af3fa272.jpg
[id_marque] => 1
[modele_visuel1] =>
[modele_intitule] => 4220
[modele_marque_autre] =>
[marque_name] => JCB
)

[3] => Array
(
[page_url] => 536-70-agri-plus-5002064
[id_modele] => 190
[produit_selection] => 1
[produit_neuf] => 1
[produit_prix_visible] => 0
[produit_annee] => 2014
[produit_prix_vente] => 1
[produit_visuel1] => 235-473010a0b877824dd236aa23715ac312.jpg
[id_marque] => 1
[modele_visuel1] =>
[modele_intitule] => 536-70 AGRI PLUS
[modele_marque_autre] =>
[marque_name] => JCB
)

[4] => Array
(
[page_url] => ck-22-m-1000468
[id_modele] => 232
[produit_selection] => 1
[produit_neuf] => 1
[produit_prix_visible] => 0
[produit_annee] => 2014
[produit_prix_vente] => 10910
[produit_visuel1] => 284-e29d3df7e1e8af1553784fb91cdade54.jpg
[id_marque] => 4
[modele_visuel1] =>
[modele_intitule] => CK 22 M
[modele_marque_autre] => KIOTI
[marque_name] => Autres
)

[5] => Array
(
[page_url] => tm-320s-123123
[id_modele] => 405
[produit_selection] => 1
[produit_neuf] => 1
[produit_prix_visible] => 0
[produit_annee] => 2018
[produit_prix_vente] => 0
[produit_visuel1] => 461-aeb3db032afe4c5744de788d77cf7135.jpg
[id_marque] => 1
[modele_visuel1] =>
[modele_intitule] => TM 320S
[modele_marque_autre] =>
[marque_name] => JCB
)

)

[type_liste] => Array
(
[0] => Array
(
[id_type] => 2
[page_url] => chargeurs
[page_name] => Chargeurs
[type_nom] => Chargeurs
)

[1] => Array
(
[id_type] => 13
[page_url] => divers
[page_name] => Divers
[type_nom] => Divers
)

[2] => Array
(
[id_type] => 11
[page_url] => epandage
[page_name] => Epandage
[type_nom] => Epandage
)

[3] => Array
(
[id_type] => 12
[page_url] => materiel-elevage
[page_name] => Matériel d'élevage
[type_nom] => Matériel d'élevage
)

[4] => Array
(
[id_type] => 5
[page_url] => materiel-de-fenaison
[page_name] => Matériel de fenaison
[type_nom] => Matériel de fenaison
)

[5] => Array
(
[id_type] => 4
[page_url] => materiel-de-recolte
[page_name] => Matériel de récolte
[type_nom] => Matériel de récolte
)

[6] => Array
(
[id_type] => 9
[page_url] => outils-du-sol
[page_name] => Outils du sol
[type_nom] => Outils du sol
)

[7] => Array
(
[id_type] => 8
[page_url] => pulverisateurs
[page_name] => Pulvérisateurs
[type_nom] => Pulvérisateurs
)

[8] => Array
(
[id_type] => 10
[page_url] => remorques-agricoles
[page_name] => Remorques agricoles
[type_nom] => Remorques agricoles
)

[9] => Array
(
[id_type] => 7
[page_url] => semoirs
[page_name] => Semoirs
[type_nom] => Semoirs
)

[10] => Array
(
[id_type] => 3
[page_url] => telescopiques
[page_name] => Télescopiques
[type_nom] => Télescopiques
)

[11] => Array
(
[id_type] => 1
[page_url] => tracteurs
[page_name] => Tracteurs
[type_nom] => Tracteurs
)

[12] => Array
(
[id_type] => 6
[page_url] => vehicules-utilitaires
[page_name] => Véhicules utilitaires
[type_nom] => Véhicules utilitaires
)

)

)

PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"