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="outils-du-sol"

Page::getPageDynamic
Page::getModels
SELECT model_name FROM ga_model WHERE model_type="page"

SELECT id_actu, page_name, page_title, page_description, page_keywords FROM ma_actu WHERE page_url="outils-du-sol"

SELECT id_categorie, page_name, page_title, page_description, page_keywords FROM ma_categorie WHERE page_url="outils-du-sol"

SELECT id_type, page_name, page_title, page_description, page_keywords FROM ma_type WHERE page_url="outils-du-sol"

SELECT id_page,page_link FROM ga_page WHERE page_url="type"

SELECT page_url FROM ga_page WHERE id_page="53"

SELECT page_url FROM ga_page WHERE id_page="39"

Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="type" 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="39" 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="39" 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='39' 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="type" 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_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

SELECT ma_marque.id_marque, ma_marque.marque_name, ma_marque.marque_url FROM ma_marque ORDER BY ma_marque.marque_name ASC


Appel d'un fichier de post-traitement : /action/process/dataflow/liste_produits_type.php

SELECT DISTINCT(ma_modele.modele_intitule),id_modele
FROM ma_modele
LEFT JOIN ma_type ON ma_modele.id_type=ma_type.id_type
WHERE ma_type.page_url='outils-du-sol' ORDER BY modele_intitule



SELECT COUNT(id_produit)
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
LEFT JOIN ma_type ON ma_modele.id_type=ma_type.id_type
LEFT JOIN ma_categorie ON ma_modele.id_categorie=ma_categorie.id_categorie
LEFT JOIN ma_agence ON ma_produit.id_agence=ma_agence.id_agence

WHERE ma_produit.produit_neuf='0' AND ma_type.page_url='outils-du-sol' ORDER BY ma_produit.id_produit DESC


SELECT ma_produit.page_url, ma_produit.page_title, ma_produit.id_produit, ma_produit.id_modele, ma_produit.produit_selection, ma_produit.produit_neuf, ma_produit.produit_etat, ma_produit.produit_prix_visible, ma_produit.produit_annee, ma_produit.produit_prix_vente, ma_produit.id_agence, ma_produit.produit_visuel1, ma_modele.id_modele, ma_modele.id_type, ma_modele.modele_intitule, ma_modele.modele_visuel1,ma_modele.modele_marque_autre, ma_type.id_type, ma_agence.agence_cp, ma_agence.agence_ville, ma_agence.id_agence, ma_modele.id_marque, ma_marque.id_marque, ma_marque.marque_name, ma_categorie.categorie_nom
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
LEFT JOIN ma_type ON ma_modele.id_type=ma_type.id_type
LEFT JOIN ma_categorie ON ma_modele.id_categorie=ma_categorie.id_categorie
LEFT JOIN ma_agence ON ma_produit.id_agence=ma_agence.id_agence

WHERE ma_produit.produit_neuf='0' AND ma_type.page_url='outils-du-sol' ORDER BY ma_produit.id_produit DESC LIMIT 6


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


SELECT id_categorie,categorie_nom,id_marque,page_url,id_type FROM ma_categorie WHERE ma_categorie.categorie_catalogue='0' ORDER BY categorie_nom ASC


SELECT id_metacategorie,metacategorie_nom categorie_nom,metacategorie_url,id_type FROM ma_metacategorie ORDER BY metacategorie_nom ASC


Données envoyés au template :
Array
(
[type_liste] => Array
(
[0] => Array
(
[id_type] => 2
[page_url] => chargeurs
[type_nom] => Chargeurs
[categories_liste] => Array
(
[0] => Array
(
[id_categorie] =>
[categorie_url] => chargeurs-frontaux
[categorie_nom] => Chargeurs frontaux
)

[1] => Array
(
[id_categorie] =>
[categorie_url] => chargeuses-sur-pneus
[categorie_nom] => Chargeuses sur pneus
)

[2] => Array
(
[id_categorie] =>
[categorie_url] => divers
[categorie_nom] => Divers
)

)

)

[1] => Array
(
[id_type] => 13
[page_url] => divers
[type_nom] => Divers
[categories_liste] => Array
(
[0] => Array
(
[id_categorie] =>
[categorie_url] => divers
[categorie_nom] => Divers
)

)

)

[2] => Array
(
[id_type] => 11
[page_url] => epandage
[type_nom] => Epandage
[categories_liste] => Array
(
[0] => Array
(
[id_categorie] =>
[categorie_url] => epandage
[categorie_nom] => Epandage
)

)

)

[3] => Array
(
[id_type] => 12
[page_url] => materiel-elevage
[type_nom] => Matériel d'élevage
[categories_liste] => Array
(
[0] => Array
(
[id_categorie] =>
[categorie_url] => desileuses
[categorie_nom] => Désileuses
)

[1] => Array
(
[id_categorie] =>
[categorie_url] => desileuses-pailleuses
[categorie_nom] => Désileuses pailleuses
)

[2] => Array
(
[id_categorie] =>
[categorie_url] => divers
[categorie_nom] => Divers
)

[3] => Array
(
[id_categorie] =>
[categorie_url] => melangeuses
[categorie_nom] => Mélangeuses
)

[4] => Array
(
[id_categorie] =>
[categorie_url] => pailleuses
[categorie_nom] => Pailleuses
)

)

)

[4] => Array
(
[id_type] => 5
[page_url] => materiel-de-fenaison
[type_nom] => Matériel de fenaison
[categories_liste] => Array
(
[0] => Array
(
[id_categorie] =>
[categorie_url] => andaineurs
[categorie_nom] => Andaineurs
)

[1] => Array
(
[id_categorie] =>
[categorie_url] => divers
[categorie_nom] => Divers
)

[2] => Array
(
[id_categorie] =>
[categorie_url] => faneuses
[categorie_nom] => Faneuses
)

[3] => Array
(
[id_categorie] =>
[categorie_url] => faucheuses
[categorie_nom] => Faucheuses
)

[4] => Array
(
[id_categorie] =>
[categorie_url] => presses-balles-rondes
[categorie_nom] => Presses balles rondes
)

[5] => Array
(
[id_categorie] =>
[categorie_url] => presses-haute-densite
[categorie_nom] => Presses haute densité
)

)

)

[5] => Array
(
[id_type] => 4
[page_url] => materiel-de-recolte
[type_nom] => Matériel de récolte
[categories_liste] => Array
(
[0] => Array
(
[id_categorie] =>
[categorie_url] => divers
[categorie_nom] => Divers
)

[1] => Array
(
[id_categorie] =>
[categorie_url] => ensileuses
[categorie_nom] => Ensileuses
)

[2] => Array
(
[id_categorie] =>
[categorie_url] => moissonneuses
[categorie_nom] => Moissonneuses
)

)

)

[6] => Array
(
[id_type] => 9
[page_url] => outils-du-sol
[type_nom] => Outils du sol
[categories_liste] => Array
(
[0] => Array
(
[id_categorie] =>
[categorie_url] => canadiens
[categorie_nom] => Canadiens
)

[1] => Array
(
[id_categorie] =>
[categorie_url] => charrue
[categorie_nom] => Charrue
)

[2] => Array
(
[id_categorie] =>
[categorie_url] => cover-crop
[categorie_nom] => Cover crop
)

[3] => Array
(
[id_categorie] =>
[categorie_url] => divers
[categorie_nom] => Divers
)

[4] => Array
(
[id_categorie] =>
[categorie_url] => herse-rotative
[categorie_nom] => Herse rotative
)

[5] => Array
(
[id_categorie] =>
[categorie_url] => rotalabours
[categorie_nom] => Rotalabours
)

)

)

[7] => Array
(
[id_type] => 8
[page_url] => pulverisateurs
[type_nom] => Pulvérisateurs
[categories_liste] => Array
(
[0] => Array
(
[id_categorie] =>
[categorie_url] => pulverisateurs
[categorie_nom] => Pulvérisateurs
)

)

)

[8] => Array
(
[id_type] => 10
[page_url] => remorques-agricoles
[type_nom] => Remorques agricoles
[categories_liste] => Array
(
[0] => Array
(
[id_categorie] =>
[categorie_url] => bennes-agricoles
[categorie_nom] => Bennes agricoles
)

[1] => Array
(
[id_categorie] =>
[categorie_url] => divers
[categorie_nom] => Divers
)

[2] => Array
(
[id_categorie] =>
[categorie_url] => plateaux
[categorie_nom] => Plateaux
)

)

)

[9] => Array
(
[id_type] => 7
[page_url] => semoirs
[type_nom] => Semoirs
[categories_liste] => Array
(
[0] => Array
(
[id_categorie] =>
[categorie_url] => semoirs
[categorie_nom] => Semoirs
)

)

)

[10] => Array
(
[id_type] => 3
[page_url] => telescopiques
[type_nom] => Télescopiques
[categories_liste] => Array
(
[0] => Array
(
[id_categorie] =>
[categorie_url] => divers
[categorie_nom] => Divers
)

[1] => Array
(
[id_categorie] =>
[categorie_url] => telescopiques
[categorie_nom] => Téléscopiques
)

)

)

[11] => Array
(
[id_type] => 1
[page_url] => tracteurs
[type_nom] => Tracteurs
[categories_liste] => Array
(
[0] => Array
(
[id_categorie] =>
[categorie_url] => divers
[categorie_nom] => Divers
)

[1] => Array
(
[id_categorie] =>
[categorie_url] => tracteurs
[categorie_nom] => Tracteurs
)

)

)

[12] => Array
(
[id_type] => 6
[page_url] => vehicules-utilitaires
[type_nom] => Véhicules utilitaires
[categories_liste] => Array
(
[0] => Array
(
[id_categorie] =>
[categorie_url] => vehicules-utilitaires
[categorie_nom] => Véhicules utilitaires
)

)

)

)

[marques_liste] => Array
(
[0] => Array
(
[id_marque] => 4
[marque_name] => Autres
[marque_url] => autres
)

[1] => Array
(
[id_marque] => 3
[marque_name] => Case IH
[marque_url] => case-ih
)

[2] => Array
(
[id_marque] => 2
[marque_name] => Fendt
[marque_url] => fendt
)

[3] => Array
(
[id_marque] => 1
[marque_name] => JCB
[marque_url] => jcb
)

)

[url] => /materiel/occasion/outils-du-sol?
[materiel_etat] => occasion
[current_type] => outils-du-sol
[modeles_liste] => Array
(
[0] => Array
(
[modele_intitule] => big pro 44 disques
[id_modele] => 260
)

[1] => Array
(
[modele_intitule] => MAXITILLER
[id_modele] => 141
)

[2] => Array
(
[modele_intitule] => SUPER-CROP
[id_modele] => 142
)

[3] => Array
(
[modele_intitule] => sxp 34
[id_modele] => 261
)

[4] => Array
(
[modele_intitule] => 500 S
[id_modele] => 356
)

[5] => Array
(
[modele_intitule] => 5940
[id_modele] => 419
)

[6] => Array
(
[modele_intitule] => 7 corps chariot
[id_modele] => 287
)

[7] => Array
(
[modele_intitule] => askel
[id_modele] => 357
)

[8] => Array
(
[modele_intitule] => BlueBird GHA 6000 K
[id_modele] => 215
)

[9] => Array
(
[modele_intitule] => Carrier X 525
[id_modele] => 122
)

[10] => Array
(
[modele_intitule] => Catros plus 3001
[id_modele] => 166
)

[11] => Array
(
[modele_intitule] => chariot 6 corps
[id_modele] => 286
)

[12] => Array
(
[modele_intitule] => CLC 11 dents disque rouleau
[id_modele] => 394
)

[13] => Array
(
[modele_intitule] => CLC EVO
[id_modele] => 71
)

[14] => Array
(
[modele_intitule] => CONDOR SC
[id_modele] => 213
)

[15] => Array
(
[modele_intitule] => corvus
[id_modele] => 319
)

[16] => Array
(
[modele_intitule] => cultipacker
[id_modele] => 370
)

[17] => Array
(
[modele_intitule] => cultivateur
[id_modele] => 373
)

[18] => Array
(
[modele_intitule] => CULTIVATEUR CLC pro 12 dents
[id_modele] => 240
)

[19] => Array
(
[modele_intitule] => DEVRAN
[id_modele] => 402
)

[20] => Array
(
[modele_intitule] => ED 100
[id_modele] => 267
)

[21] => Array
(
[modele_intitule] => ED 100-200
[id_modele] => 154
)

[22] => Array
(
[modele_intitule] => EL 100
[id_modele] => 135
)

[23] => Array
(
[modele_intitule] => ES 100
[id_modele] => 390
)

[24] => Array
(
[modele_intitule] => ES 100 / 200 5 corps
[id_modele] => 361
)

[25] => Array
(
[modele_intitule] => ES 5
[id_modele] => 371
)

[26] => Array
(
[modele_intitule] => F 160
[id_modele] => 337
)

[27] => Array
(
[modele_intitule] => HR 303
[id_modele] => 382
)

[28] => Array
(
[modele_intitule] => HR 43
[id_modele] => 395
)

[29] => Array
(
[modele_intitule] => HR30
[id_modele] => 157
)

[30] => Array
(
[modele_intitule] => K.H 300
[id_modele] => 56
)

[31] => Array
(
[modele_intitule] => KE 3000 super
[id_modele] => 316
)

[32] => Array
(
[modele_intitule] => KE 303
[id_modele] => 136
)

[33] => Array
(
[modele_intitule] => KE 303
[id_modele] => 256
)

[34] => Array
(
[modele_intitule] => KE 303
[id_modele] => 384
)

[35] => Array
(
[modele_intitule] => KE 303-135
[id_modele] => 214
)

[36] => Array
(
[modele_intitule] => KH 300
[id_modele] => 259
)

[37] => Array
(
[modele_intitule] => lion 4002
[id_modele] => 314
)

[38] => Array
(
[modele_intitule] => maxitiller
[id_modele] => 328
)

[39] => Array
(
[modele_intitule] => Megapack RS 8m25
[id_modele] => 168
)

[40] => Array
(
[modele_intitule] => Modulab
[id_modele] => 355
)

[41] => Array
(
[modele_intitule] => NSH 475 LOSANGE
[id_modele] => 35
)

[42] => Array
(
[modele_intitule] => överum
[id_modele] => 226
)

[43] => Array
(
[modele_intitule] => P SEM
[id_modele] => 169
)

[44] => Array
(
[modele_intitule] => PLANISPIRE
[id_modele] => 58
)

[45] => Array
(
[modele_intitule] => qualidisc 3500 PRO
[id_modele] => 372
)

[46] => Array
(
[modele_intitule] => RCN 359
[id_modele] => 332
)

[47] => Array
(
[modele_intitule] => RWY47
[id_modele] => 418
)

[48] => Array
(
[modele_intitule] => souchu pinet
[id_modele] => 271
)

[49] => Array
(
[modele_intitule] => SPF 8 corps
[id_modele] => 331
)

[50] => Array
(
[modele_intitule] => terradisc 3501
[id_modele] => 344
)

[51] => Array
(
[modele_intitule] => terradisc 4000
[id_modele] => 399
)

[52] => Array
(
[modele_intitule] => Toucan SL 3000
[id_modele] => 383
)

[53] => Array
(
[modele_intitule] => TOUCAN SL 3000
[id_modele] => 137
)

[54] => Array
(
[modele_intitule] => TURBO 2
[id_modele] => 91
)

[55] => Array
(
[modele_intitule] => varimaster 122
[id_modele] => 288
)

[56] => Array
(
[modele_intitule] => varimaster 151
[id_modele] => 301
)

[57] => Array
(
[modele_intitule] => visio 200
[id_modele] => 362
)

[58] => Array
(
[modele_intitule] => VISIO 200
[id_modele] => 80
)

)

[num] => 1
[nb_page] => 1
[produits_type_liste] => Array
(
[0] => Array
(
[page_url] => devran-2003511
[page_title] => DEVRAN 2003511
[id_produit] => 456
[id_modele] => 402
[produit_selection] => 0
[produit_neuf] => 0
[produit_etat] => Bon état général
[produit_prix_visible] => 1
[produit_annee] => 2017
[produit_prix_vente] => 2800
[id_agence] => 10
[produit_visuel1] => 456-2797eac60348a805afbb7642d8337bae.jpg
[id_type] => 9
[modele_intitule] => DEVRAN
[modele_visuel1] =>
[modele_marque_autre] => DEVRAN
[agence_cp] => 56300
[agence_ville] => Pontivy
[id_marque] => 4
[marque_name] => Autres
[categorie_nom] => Divers
)

[1] => Array
(
[page_url] => terradisc-4000-4000993
[page_title] => terradisc 4000 4000993
[id_produit] => 455
[id_modele] => 399
[produit_selection] => 0
[produit_neuf] => 0
[produit_etat] => Bon état général
[produit_prix_visible] => 1
[produit_annee] => 2017
[produit_prix_vente] => 8700
[id_agence] => 10
[produit_visuel1] => 455-45881ce385d0849b5f952ca2574a0962.jpg
[id_type] => 9
[modele_intitule] => terradisc 4000
[modele_visuel1] =>
[modele_marque_autre] =>
[agence_cp] => 56300
[agence_ville] => Pontivy
[id_marque] => 4
[marque_name] => Autres
[categorie_nom] => Divers
)

[2] => Array
(
[page_url] => qualidisc-3500-pro
[page_title] => qualidisc 3500 PRO
[id_produit] => 429
[id_modele] => 372
[produit_selection] => 0
[produit_neuf] => 0
[produit_etat] => Comme neuf
[produit_prix_visible] => 1
[produit_annee] => 2015
[produit_prix_vente] => 1
[id_agence] => 10
[produit_visuel1] => 429-6aeee88abdcb58a664bc973400f5fc06.jpg
[id_type] => 9
[modele_intitule] => qualidisc 3500 PRO
[modele_visuel1] =>
[modele_marque_autre] => KVERNELAND
[agence_cp] => 56300
[agence_ville] => Pontivy
[id_marque] => 4
[marque_name] => Autres
[categorie_nom] => Divers
)

[3] => Array
(
[page_url] => corvus-2003221
[page_title] => corvus 2003221
[id_produit] => 379
[id_modele] => 319
[produit_selection] => 0
[produit_neuf] => 0
[produit_etat] => Très bon état
[produit_prix_visible] => 1
[produit_annee] => 2014
[produit_prix_vente] => 9000
[id_agence] => 10
[produit_visuel1] => 379-6377d5741f31928d256dc03af3be1fb1.jpg
[id_type] => 9
[modele_intitule] => corvus
[modele_visuel1] =>
[modele_marque_autre] => grégoire et besson
[agence_cp] => 56300
[agence_ville] => Pontivy
[id_marque] => 4
[marque_name] => Autres
[categorie_nom] => Herses rotatives
)

)

)

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