Array
(
[lang] => en
[id_masterGamme_LAVAL] => 7
[id_masterFamille_LAVAL] => 133
[id_masterSSFamille_LAVAL] =>
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] =>
)
)
Array
(
[arborescence] => TRIEUR
[SQL] => SELECT *
FROM trieurCollection tC
WHERE tC.actif = 1 AND tC.EN = 1 AND tC.id_masterTrieurParent NOT IN (9,15) 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 prix_EN mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND EN = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterFamille_LAVAL = :id_masterFamille_LAVAL GROUP BY tC.id_masterPrix ) GROUP BY tC.id_masterPrix
[NUMBER] => 132
[texte] => (132 products)
[received] => Array
(
[lang] => en
[id_masterGamme_LAVAL] => 7
[id_masterFamille_LAVAL] => 133
[id_masterSSFamille_LAVAL] =>
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] =>
)
)
)
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 USING(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 tC.id_masterTrieurParent IN (13) AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mProd.id_masterFamille_LAVAL = :id_masterFamille_LAVAL GROUP BY mPrix.id_masterProduit, tC.id_masterTrieurEnfant ORDER BY mPrix.date_online DESC, 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 USING(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 tC.id_masterTrieurParent IN (13) AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mProd.id_masterFamille_LAVAL = :id_masterFamille_LAVAL GROUP BY mPrix.id_masterProduit, tC.id_masterTrieurEnfant ORDER BY mPrix.date_online DESC, mPrix.ordre_Famille_LAVAL ASC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 7
:id_masterFamille_LAVAL 133
:id_masterSSFamille_LAVAL
:eclatement
:id_masterTrieurEnfant
:price_asked
:id_masterBoutikB =>
:search
NB PRODUIT => 123
NB BOUTIQUE => 20
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => ""AUTORISATION => {"type":"FAMILLE","array_received":{"arborescence":"FAMILLE","id_masterGamme_LAVAL":"7","id_masterFamille_LAVAL":"133","id_masterSSFamille_LAVAL":null,"id_masterTrieurEnfant":null,"price_asked":null,"id_masterBoutikB":null,"lang":"en"},"id_client_received":"","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},"autorisation":true}
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Add to favorites
Viewing:
20 out of 123
items