Maxy shop power - Accessori telefonia, informatica e action cam
Trova il tuo prodotto preferito tra gli oltre 16.000 a catalogo


Marchi



Filtra per Marca
Mostra


Gear4 auricolare originale stereo universale 3.5mm blu

PG505BLU ICE

GEAR4

Loc: 6K05-/2
Quantità: 34

€ 5,76

Gear4 auricolare originale stereo universale 3.5mm purple

PG505PUR KIM

GEAR4

Loc: 5Q05-/2
Quantità: 59

€ 5,76

Gear4 custodia originale hard cover apple iphone 4 yellow bird

ICAB402

GEAR4

Loc: 7A02-/0
Quantità: 1

€ 5,49

Gear4 custodia originale hard cover apple iphone 4 4s pig king

ICAB403

GEAR4

Loc: 7A02-/0
Quantità: 1

€ 5,49

Gear4 custodia originale hard cover apple iphone 4 4s boomerang bird

ICAB407

GEAR4

Loc: 7A02-/0
Quantità: 1

€ 5,49

Gear4 custodia originale hard cover apple iphone 4 4s bomber

ICAB405

GEAR4

Loc: 7A02-/0
Quantità: 5

€ 5,49

Gear4 custodia originale hard cover apple iphone 4 4s blue bird

ICAB406

GEAR4

Loc: 7A02-/0
Quantità: 1

€ 5,49

Gear4 auricolare originale stereo universale 3.5mm pink

PG505PNK FLOSS

GEAR4

Loc: --
Quantità: 0

€ 8,00

Gear4 auricolare originale stereo universale 3.5mm black

PG505BLK SAI

GEAR4

Loc: --
Quantità: 0

€ 8,00

Gear4 custodia thin ice cover apple iphone 4 purple

IC406

GEAR4

Loc: --
Quantità: 1

€ 4,50

Gear4 custodia thin ice cover apple iphone 4 red

IC404

GEAR4

Loc: --
Quantità: 1

€ 4,50


MaxyShopPower

I nostri contatti

Maxy shop power

+39 388 30.20.100

Current Parse Time: 0.042 s with 12 queries
QUERY DEBUG:
Array
(
    [QUERIES] => Array
        (
            [0] => select distinct c.categories_id, c.parent_id, cd.categories_name from categories c inner join categories_description cd on c.categories_id=cd.categories_id inner join products_to_categories p2c on c.categories_id=p2c.categories_id   
    inner join products p ON (p.products_id=p2c.products_id)
        inner join products_description pd ON (p.products_id=pd.products_id)
        left join manufacturers m using(manufacturers_id) where cd.language_id=4 and 1=1  and p.products_status = '1'
            [1] => select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
            [2] => select languages_id, name, code, image, directory from languages order by sort_order
            [3] => select banners_id, date_scheduled from banners where date_scheduled != ''
            [4] => select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id
            [5] => select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
            [6] => select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0
            [7] => select manufacturers_name from manufacturers where manufacturers_id = '4'
            [8] => select * from traduzioni
            [9] => select distinct p.products_model, p.MPN, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, p.products_date_available, cd.categories_name,  m.manufacturers_id, p.trasportogratis, p.colore1,p.colore2,pi.products_image1,p.products_forsale,
  p.products_submodel,p.products_id, pd.products_name, p2c.categories_id,c.categories_tree,p.MPN,
  p.products_price_gross ,p.products_price, p.products_price_listino,p.listino,p.products_tax_class_id,p.products_ubicazione, 
  IF(s.status, s.specials_new_products_price_gross, NULL) as specials_new_products_price_gross,
  IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, 
  IF(s.status, s.specials_new_products_price, p.products_price) as final_price  from products p left join manufacturers m using(manufacturers_id) 
              left join specials s on p.products_id = s.products_id
              inner join products_description pd on p.products_id=pd.products_id 
              inner join products_to_categories p2c on p.products_id=p2c.products_id 
              inner join categories c on c.categories_id=p2c.categories_id 
              inner join categories_description cd on c.categories_id=cd.categories_id
              left join  products_images pi on pi.products_id = p.products_id
               where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id  and (p.products_quantity > '0' or (p.products_quantity<=0 and m.da_escludere=0))  and (m.manufacturers_id = '4' and 1=01) group by p.products_model  order by  p.products_last_modified desc 
            [10] => select distinct p.products_model, p.MPN, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, p.products_date_available, cd.categories_name,  m.manufacturers_id, p.trasportogratis, p.colore1,p.colore2,pi.products_image1,p.products_forsale,
  p.products_submodel,p.products_id, pd.products_name, p2c.categories_id,c.categories_tree,p.MPN,
  p.products_price_gross ,p.products_price, p.products_price_listino,p.listino,p.products_tax_class_id,p.products_ubicazione, 
  IF(s.status, s.specials_new_products_price_gross, NULL) as specials_new_products_price_gross,
  IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, 
  IF(s.status, s.specials_new_products_price, p.products_price) as final_price  from products p left join manufacturers m using(manufacturers_id) 
              left join specials s on p.products_id = s.products_id
              inner join products_description pd on p.products_id=pd.products_id 
              inner join products_to_categories p2c on p.products_id=p2c.products_id 
              inner join categories c on c.categories_id=p2c.categories_id 
              inner join categories_description cd on c.categories_id=cd.categories_id
              left join  products_images pi on pi.products_id = p.products_id
               where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id  and (p.products_quantity > '0' or (p.products_quantity<=0 and m.da_escludere=0))  and (m.manufacturers_id = '4' and 1=01) group by p.products_model  order by  p.products_last_modified desc  limit 0, 16
            [11] => select distinct m.manufacturers_id, m.manufacturers_name from products_to_categories p2c inner join categories c ON (p2c.categories_id = c.categories_id)
    inner join products p ON (p.products_id=p2c.products_id) inner join products_description pd on (p.products_id=pd.products_id)  left join manufacturers m using(manufacturers_id)  where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id  and (p.products_quantity > '0' or (p.products_quantity<=0 and m.da_escludere=0))  and (m.manufacturers_id = '4' and 1=11) order by m.manufacturers_name
        )

    [TIME] => Array
        (
            [0] => 0.002140
            [1] => 0.000197
            [2] => 0.000185
            [3] => 0.000250
            [4] => 0.017538
            [5] => 0.000342
            [6] => 0.000203
            [7] => 0.000134
            [8] => 0.000408
            [9] => 0.001966
            [10] => 0.001599
            [11] => 0.000478
        )

)

SESSION:
Array
(
    [session_product_listing] => 
)

COOKIE:
Array
(
)
POST:
Array
(
)

GET:
Array
(
    [page] => category
    [manufacturers_id] => 4
)