Array
(
[lang] => en
[id_masterGamme_LAVAL] => 14
[id_masterFamille_LAVAL] =>
[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.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 GROUP BY tC.id_masterPrix ) GROUP BY tC.id_masterPrix
[NUMBER] => 1279
[texte] => (1279 products)
[received] => Array
(
[lang] => en
[id_masterGamme_LAVAL] => 14
[id_masterFamille_LAVAL] =>
[id_masterSSFamille_LAVAL] =>
[id_masterBoutikB] =>
[arborescence] => TRIEUR
[search] =>
[id_masterNiveau] =>
[id_masterTrieurEnfant] => Array
(
[0] =>
)
)
)
ARBORESCENCE => GAMME
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 GROUP BY mPrix.id_masterProduit, tC.id_masterTrieurEnfant ORDER BY mPrix.date_online DESC, mPrix.ordre_Gamme_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 GROUP BY mPrix.id_masterProduit, tC.id_masterTrieurEnfant ORDER BY mPrix.date_online DESC, mPrix.ordre_Gamme_LAVAL ASC, mPrix.reference ASC LIMIT 0, 20
:id_masterGamme_LAVAL 14
:id_masterFamille_LAVAL
:id_masterSSFamille_LAVAL
:eclatement
:id_masterTrieurEnfant
:price_asked
:id_masterBoutikB =>
:search
NB PRODUIT => 829
NB BOUTIQUE => 20
LIMIT => LIMIT 0, 20
ID_CLIENT => FAVORITES => ""AUTORISATION => {"type":"GAMME","array_received":{"arborescence":"GAMME","id_masterGamme_LAVAL":"14","id_masterFamille_LAVAL":null,"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 829
items