Array
(
[lang] => es
[id_masterGamme_LAVAL] => 25
[id_masterFamille_LAVAL] =>
[id_masterSSFamille_LAVAL] =>
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] => 4693
)
[sort] =>
)
Array
(
[arborescence] => TRIEUR
[SQL] => SELECT *
FROM trieurCollection tC
INNER JOIN masterPrix mPrix USING(id_masterPrix)
INNER JOIN prix_ES mPrixLang USING(id_masterPrix)
WHERE ( tC.actif = 1 AND mPrixLang.actif = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_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_masterTrieurParent = 17 AND tC.id_masterTrieurEnfant IN (4693) )) GROUP BY tC.id_masterPrix
[NUMBER] => 250
[texte] => 250 productos
[received] => Array
(
[lang] => es
[id_masterGamme_LAVAL] => 25
[id_masterFamille_LAVAL] =>
[id_masterSSFamille_LAVAL] =>
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] => 4693
)
[sort] =>
)
)
ARBORESCENCE => TRIEUR
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS DISTINCT mPrix.*
FROM masterPrix mPrix
INNER JOIN prix_FR mPrixLang USING(id_masterPrix)
LEFT OUTER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mPrix.id_masterPrix IN ( SELECT DISTINCT(mPrix.id_masterPrix) FROM masterPrix mPrix
INNER JOIN prix_ES mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterTrieurEnfant IN (4693) ) ORDER BY mPrix.ordre_Gamme_LAVAL ASC, mPrix.reference ASC
SQL BOUTIQUE => SELECT SQL_CALC_FOUND_ROWS DISTINCT mPrix.*
FROM masterPrix mPrix
INNER JOIN prix_FR mPrixLang USING(id_masterPrix)
LEFT OUTER JOIN masterProduit mProd ON mPrix.id_masterProduit = mProd.id_masterProduit
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND mProd.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mPrix.id_masterPrix IN ( SELECT DISTINCT(mPrix.id_masterPrix) FROM masterPrix mPrix
INNER JOIN prix_ES mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterTrieurEnfant IN (4693) ) ORDER BY mPrix.ordre_Gamme_LAVAL ASC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 25
:id_masterFamille_LAVAL
:id_masterSSFamille_LAVAL
:eclatement
:id_masterTrieurEnfant Array
:price_asked
:id_masterBoutikB =>
:search
:sort
NB PRODUIT => 250
NB BOUTIQUE => 20
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => ""AUTORISATION => {"type":"TRIEUR","array_received":{"arborescence":"TRIEUR","id_masterGamme_LAVAL":"25","id_masterFamille_LAVAL":"","id_masterSSFamille_LAVAL":"","id_masterTrieurEnfant":["4693"],"price_asked":"","id_masterBoutikB":"","id_masterNiveau":null,"sort":"","lang":"es"},"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}
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Registrar como favorito
Visualización :
20 de 250
modelos