Array
(
[lang] => en
[id_masterGamme_LAVAL] => 17
[id_masterFamille_LAVAL] => 326
[id_masterSSFamille_LAVAL] =>
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] =>
)
[sort] =>
)
Array
(
[arborescence] => TRIEUR
[SQL] => SELECT *
FROM trieurCollection tC
INNER JOIN masterPrix mPrix USING(id_masterPrix)
INNER JOIN prix_EN mPrixLang USING(id_masterPrix)
WHERE ( tC.actif = 1 AND mPrixLang.actif = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL AND tC.reference IN ( SELECT mPrix.reference FROM masterPrix mPrix
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE 1=1 AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL) GROUP BY tC.id_masterPrix
[NUMBER] => 2
[texte] => 2 products
[received] => Array
(
[lang] => en
[id_masterGamme_LAVAL] => 17
[id_masterFamille_LAVAL] => 326
[id_masterSSFamille_LAVAL] =>
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] =>
)
[sort] =>
)
)
ARBORESCENCE => FAMILLE
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS mPrix.* FROM masterPrix mPrix
INNER JOIN prix_EN mPrixLang USING(id_masterPrix)
LEFT OUTER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
LEFT OUTER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND mPrix.CategorieProduit = '' AND mPrix.reference_masterProduit = '' AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mProd.id_masterFamille_LAVAL = :id_masterFamille_LAVAL GROUP BY mPrix.id_masterProduit ORDER BY mPrix.ordre_Famille_LAVAL ASC, mPrix.reference ASC
SQL BOUTIQUE => SELECT SQL_CALC_FOUND_ROWS mPrix.* FROM masterPrix mPrix
INNER JOIN prix_EN mPrixLang USING(id_masterPrix)
LEFT OUTER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
LEFT OUTER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND mPrix.CategorieProduit = '' AND mPrix.reference_masterProduit = '' AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mProd.id_masterFamille_LAVAL = :id_masterFamille_LAVAL GROUP BY mPrix.id_masterProduit ORDER BY mPrix.ordre_Famille_LAVAL ASC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 17
:id_masterFamille_LAVAL 326
:id_masterSSFamille_LAVAL
:eclatement
:id_masterTrieurEnfant
:price_asked
:id_masterBoutikB =>
:search
:sort
NB PRODUIT => 2
NB BOUTIQUE => 2
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => ""AUTORISATION => {"type":"FAMILLE","array_received":{"arborescence":"FAMILLE","id_masterGamme_LAVAL":"17","id_masterFamille_LAVAL":"326","id_masterSSFamille_LAVAL":"","id_masterTrieurEnfant":"","price_asked":"","id_masterBoutikB":"","id_masterNiveau":null,"sort":"","lang":"en"},"id_client_received":null,"client":{"id_client":null,"email_client":null,"num_client":null,"statut_client":null,"id_masterNiveau":null,"label_niveau":null,"adresse":null,"ville":null,"id_pays":null,"pays":null,"id_masterCondition":null,"id_masterDelais":null,"condition_paiement":null,"delais_paiement":null,"tva":1,"ecotaxe":0,"compte_or":0,"langue":"fr","pbx_nom":null,"pbx_prenom":null,"pbx_adresse":null,"pbx_adresse2":null,"pbx_zipcode":null,"pbx_city":null,"pbx_countrycode":null,"pbx_mobilephone":null,"pbx_countrycodemobilephone":null},"autorisation":true}
Add to favorites
Add to favorites
Viewing:
2 out of 2
items