Array
(
[lang] => es
[id_masterGamme_LAVAL] => 15
[id_masterFamille_LAVAL] =>
[id_masterSSFamille_LAVAL] =>
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] => 2128
)
)
Array
(
[arborescence] => TRIEUR
[SQL] => SELECT *
FROM trieurCollection tC
WHERE tC.actif = 1 AND tC.ES = 1 AND tC.id_masterTrieurParent NOT IN (9,15) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.reference IN ( SELECT mPrix.reference FROM masterPrix mPrix
INNER JOIN prix_ES mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND ES = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterTrieurEnfant IN (2128) GROUP BY tC.id_masterPrix ) GROUP BY tC.id_masterPrix
[NUMBER] => 99
[texte] => (99 productos)
[received] => Array
(
[lang] => es
[id_masterGamme_LAVAL] => 15
[id_masterFamille_LAVAL] =>
[id_masterSSFamille_LAVAL] =>
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] => 2128
)
)
)
ARBORESCENCE => TRIEUR
SQL BOUTIQUE TOTALE => SELECT SQL_CALC_FOUND_ROWS DISTINCT mPrix.*
FROM masterPrix mPrix
INNER JOIN prix_FR mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND ES = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mPrix.reference IN ( SELECT mPrix.reference FROM masterPrix mPrix
INNER JOIN prix_ES mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND ES = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterTrieurEnfant IN (2128) GROUP BY tC.id_masterPrix ) ORDER BY mPrix.date_online DESC, 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)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND ES = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND mPrix.reference IN ( SELECT mPrix.reference FROM masterPrix mPrix
INNER JOIN prix_ES mPrixLang USING(id_masterPrix)
INNER JOIN trieurCollection tC ON mPrix.id_masterPrix = tC.id_masterPrix
WHERE ( tC.actif = 1 AND ES = 1 ) AND tC.id_masterGamme_LAVAL = :id_masterGamme_LAVAL AND tC.id_masterTrieurEnfant IN (2128) GROUP BY tC.id_masterPrix ) ORDER BY mPrix.date_online DESC, mPrix.ordre_Gamme_LAVAL ASC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 15
:id_masterFamille_LAVAL
:id_masterSSFamille_LAVAL
:eclatement
:id_masterTrieurEnfant Array
:price_asked
:id_masterBoutikB =>
:search
NB PRODUIT => 99
NB BOUTIQUE => 20
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => nullAUTORISATION => {"type":"TRIEUR","array_received":{"arborescence":"TRIEUR","id_masterGamme_LAVAL":"15","id_masterFamille_LAVAL":null,"id_masterSSFamille_LAVAL":null,"id_masterTrieurEnfant":["2128"],"price_asked":null,"id_masterBoutikB":null,"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},"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 99
modelos