Smart 4 Ruedas
  • ¡En oferta!
Smart 4 Ruedas

Smart 4 Ruedas

830,77 €
Impuestos excluidos

Se desmonta fácil y rápidamente, por lo que podrá transportarlo sin esfuerzo en el maletero del coche para utilizar su scooter allá donde vaya. Con su Libercar Smart usted disfrutará de todas las comodidades a un precio reducido.

  • NOTA: Precio con IVA al 4% con aporte del certificado de minusvalía con grado 7 en movilidad

Descripción

Características Scooter Smart 4 Ruedas

  • Completas prestaciones: Motor 180W - Baterías 2x12Ah - Velocidad 6km/h - Autonomía 16km
  • Sus reducidas dimensiones y su fácil maniobrabilidad le aseguran una total movilidad tanto en espacios exteriores como interiores (radio de giro inferior a 1 metro).
  • Sistema ‘stand up’: el scooter se mantiene en pie por si solo (ocupando 50cm de ancho x 50cm de profundidad) permitiendo acceder a pequeños espacios (ascensores) y guardarla en casa.
  • Fácilmente desmontable para su traslado en el maletero del coche.
  • NOTA: con aporte del certificado de minusvalía del 33% o superior, se aplicará un IVA reducido del 4%.

Video demostrativo Scooter Smart 4 Ruedas

https://www.youtube.com/watch?v=JtU0bY1ESWk

Detalles del producto

smart-4-ruedas
100 Artículos

Reviews (0)

No reviews
Comentarios (0)
No hay reseñas de clientes en este momento.

16 otros productos en la misma categoría:

“La información contenida en este mensaje y/o archivo(s) adjunto(s), enviada desde NEW SPEED SL, es confidencial/privilegiada y está destinada a ser leída sólo por la(s) persona(s) a la(s) que va dirigida. Le recordamos que sus datos han sido incorporados en el sistema de tratamiento de NEW SPEED SL y que siempre y cuando se cumplan los requisitos exigidos por la normativa, usted podrá ejercer sus derechos de acceso, rectificación, limitación de tratamiento, supresión, portabilidad y oposición/revocación, en los términos que establece la normativa vigente en materia de protección de datos, dirigiendo su petición a la dirección postal C/ MONCADA 7 BJ IZQUIERDA 12005, CASTELLON (CASTELLÓN) o bien a través de correo electrónico "info@newspeed.es" Si usted lee este mensaje y no es el destinatario señalado, el empleado o el agente responsable de entregar el mensaje al destinatario, o ha recibido esta comunicación por error, le informamos que está totalmente prohibida, y puede ser ilegal, cualquier divulgación, distribución o reproducción de esta comunicación, y le rogamos que nos lo notifique inmediatamente y nos devuelva el mensaje original a la dirección arriba mencionada. Gracias”.

Load Time 498.641 ms
Querying Time 87 ms
Queries 477
Memory Peak Usage 54.2 Mb
Included Files 978 files - 10.22 Mb
PrestaShop Cache - Mb
Global vars 0.29 Mb
PrestaShop Version 8.1.7
PHP Version 7.2.34
MySQL Version 10.5.26-MariaDB
Memory Limit 256M
Max Execution Time 2000s
Smarty Cache disabled
Smarty Compilation never recompile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 0.004 ms 0.004 ms 13.01 Mb 13.3 Mb
__construct 9.027 ms 9.031 ms 1.94 Mb 15.7 Mb
init 66.740 ms 75.771 ms 8.24 Mb 23.5 Mb
checkAccess 0.002 ms 75.773 ms - Mb 23.5 Mb
setMedia 7.410 ms 83.183 ms 0.69 Mb 24.1 Mb
postProcess 0.004 ms 83.187 ms - Mb 24.1 Mb
initHeader 0.001 ms 83.188 ms - Mb 24.1 Mb
initContent 150.924 ms 234.112 ms 7.77 Mb 32.4 Mb
initFooter 0.002 ms 234.114 ms - Mb 32.4 Mb
display 264.527 ms 498.641 ms 22.31 Mb 54.2 Mb
Hook Time Memory Usage
displayFooterProduct 111.165 ms 9.77 Mb
FilterProductContent 61.609 ms 3.06 Mb
displayHeaderTop 54.374 ms 6.90 Mb
displayProductListReviews 15.326 ms 0.64 Mb
DisplayFooterProduct 14.730 ms 0.59 Mb
displayMainMenu 12.039 ms 0.57 Mb
DisplayBeforeBodyClosingTag 6.953 ms 0.37 Mb
displayFooter 4.400 ms 0.31 Mb
displayProductAdditionalInfo 3.899 ms 0.24 Mb
displayProductExtraContent 3.751 ms 0.21 Mb
displayNav1 3.640 ms 0.38 Mb
displayAfterBreadcrumb 2.990 ms 0.23 Mb
renderWidget 1.521 ms 0.05 Mb
ActionFrontControllerSetMedia 1.474 ms 0.13 Mb
DisplayHeader 1.441 ms 0.04 Mb
displayBeforeBodyClosingTag 0.990 ms 0.04 Mb
displayNav2 0.484 ms 0.07 Mb
displayProductRating 0.302 ms 0.01 Mb
displayProductElementor 0.286 ms 0.03 Mb
DisplayTop 0.063 ms - Mb
ActionDispatcher 0.009 ms - Mb
DisplayProductAdditionalInfo 0.006 ms - Mb
22 hook(s) 301.453 ms 23.65 Mb
Module Time Memory Usage
iqitthemeeditor 3.224 ms 0.61 Mb
ps_emailsubscription 4.882 ms 0.44 Mb
ps_emailalerts 2.903 ms 0.27 Mb
iqitreviews 12.259 ms 0.90 Mb
productcomments 86.345 ms 3.91 Mb
ps_shoppingcart 0.737 ms 0.05 Mb
ps_googleanalytics 4.829 ms 0.25 Mb
iqitcontactpage 2.483 ms 0.12 Mb
iqitcookielaw 1.833 ms 0.16 Mb
iqitelementor 66.793 ms 7.73 Mb
iqitmegamenu 18.942 ms 1.31 Mb
iqitlinksmanager 7.838 ms 0.72 Mb
ps_languageselector 0.645 ms 0.06 Mb
ps_currencyselector 0.724 ms 0.07 Mb
iqitsearch 2.402 ms 0.09 Mb
ps_customersignin 0.390 ms 0.02 Mb
pagesnotfound 0.736 ms 0.05 Mb
iqitproductsnav 3.620 ms 0.27 Mb
ps_sharebuttons 1.699 ms 0.11 Mb
iqitproducttags 1.880 ms 0.10 Mb
ps_viewedproduct 1.446 ms 0.14 Mb
psgdpr 2.795 ms 0.22 Mb
ps_crossselling 1.694 ms 0.13 Mb
ps_categoryproducts 110.130 ms 9.65 Mb
iqitcrossselling 1.171 ms 0.12 Mb
statsdata 6.081 ms 0.30 Mb
26 module(s) 348.483 ms 27.78 Mb

Stopwatch SQL - 477 queries

# Query Time (ms) Rows Filesort Group By Location
176 
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-09-15 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `psm7_category_product` cp
LEFT JOIN `psm7_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN psm7_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `psm7_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN psm7_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `psm7_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1 )
LEFT JOIN `psm7_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 )
LEFT JOIN `psm7_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `psm7_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 2)
LEFT JOIN `psm7_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 10 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 17
 2.456 ms 44 Yes /classes/Category.php:1062
2 
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `psm7_configuration` c
LEFT JOIN `psm7_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 2.409 ms 1081 /classes/Configuration.php:180
39 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `psm7_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `psm7_hook_alias` ha
INNER JOIN `psm7_hook` h ON ha.name = h.name
 1.609 ms 0 /classes/Hook.php:1326
40 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `psm7_hook_module` hm
STRAIGHT_JOIN `psm7_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `psm7_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 1.525 ms 370 /classes/Hook.php:456
13 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `psm7_module` m
INNER JOIN psm7_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `psm7_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `psm7_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `psm7_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 1.350 ms 144 Yes Yes /classes/Hook.php:1267
134 
SELECT SQL_NO_CACHE hs.`id_tab` as id_tab, hssl.`title`, hssl.`label`, hssl.`url`,
hss.`position`,  hss.`active_label`, hss.`url_type`, hss.`id_url`, hss.`icon_type`, hss.`icon_class`, hss.`icon`, hss.`legend_icon`,
hss.`new_window`, hss.`float`, hss.`submenu_type`, hss.`submenu_content`, hss.`submenu_width`, hss.`group_access`
FROM psm7_iqitmegamenu_tabs_shop hs
LEFT JOIN psm7_iqitmegamenu_tabs hss ON (hs.id_tab = hss.id_tab)
LEFT JOIN psm7_iqitmegamenu_tabs_lang hssl ON (hss.id_tab = hssl.id_tab)
WHERE id_shop = 1 AND menu_type = 1 AND active = 1
AND hssl.id_lang = 2
ORDER BY hss.position
 0.766 ms 16 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
141 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `psm7_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `psm7_category` c2 ON c2.`id_category` = 14 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.706 ms 1 Yes Yes /classes/Category.php:799
140 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `psm7_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `psm7_category` c2 ON c2.`id_category` = 13 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.679 ms 2 Yes Yes /classes/Category.php:799
87 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pal.`available_now`, pal.`available_later`
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN psm7_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `psm7_product_attribute_lang` pal
ON (
pa.`id_product_attribute` = pal.`id_product_attribute` AND
pal.`id_lang` = 2)
LEFT JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `psm7_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `psm7_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN psm7_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 5
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 0.672 ms 1 Yes Yes /classes/Product.php:4594
411 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (18)
 0.642 ms 1 /classes/ProductAssembler.php:64
16 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `psm7_hook`
 0.604 ms 950 /classes/Hook.php:1326
408 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (17)
 0.596 ms 1 /classes/ProductAssembler.php:64
12 
SELECT SQL_NO_CACHE lower(name) as name
FROM `psm7_hook` h
WHERE (h.active = 1)
 0.579 ms 950 /classes/Hook.php:1366
130 
SELECT SQL_NO_CACHE *
FROM `psm7_contact` c
LEFT JOIN psm7_contact_shop contact_shop
ON (contact_shop.id_contact = c.id_contact AND contact_shop.id_shop = 1)
LEFT JOIN `psm7_contact_lang` cl ON (c.`id_contact` = cl.`id_contact`)
WHERE cl.`id_lang` = 2
AND contact_shop.`id_shop` IN (1)
GROUP BY c.`id_contact`
ORDER BY `name` ASC
 0.578 ms 8 Yes Yes /classes/Contact.php:100
71 
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-09-15 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
FROM `psm7_accessory`
LEFT JOIN `psm7_product` p ON p.`id_product` = `id_product_2`
INNER JOIN psm7_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `psm7_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `psm7_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 
)
LEFT JOIN `psm7_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1 
)
LEFT JOIN `psm7_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `psm7_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `psm7_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN psm7_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 5 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 0.569 ms 1 Yes /classes/Product.php:4698
138 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `psm7_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `psm7_category` c2 ON c2.`id_category` = 11 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.545 ms 2 Yes Yes /classes/Category.php:799
64 
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
LEFT JOIN `psm7_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 10
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.537 ms 1 Yes Yes /classes/Category.php:924
139 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `psm7_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `psm7_category` c2 ON c2.`id_category` = 12 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.524 ms 3 Yes Yes /classes/Category.php:799
323 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 17 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 17 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.441 ms 0 /classes/Cart.php:1426
370 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (82)
 0.389 ms 1 /classes/ProductAssembler.php:64
471 
INSERT INTO `psm7_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
 0.374 ms 1 /classes/ObjectModel.php:622
345 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 9 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 9 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.369 ms 0 /classes/Cart.php:1426
389 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (8)
 0.365 ms 1 /classes/ProductAssembler.php:64
338 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 9) AND (b.`id_shop` = 1) LIMIT 1
 0.357 ms 1 /src/Adapter/EntityMapper.php:71
290 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 26 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 26 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.356 ms 0 /classes/Cart.php:1426
414 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (9)
 0.356 ms 1 /classes/ProductAssembler.php:64
73 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.352 ms 0 /classes/Cart.php:1426
396 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (81)
 0.349 ms 1 /classes/ProductAssembler.php:64
301 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 13 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.346 ms 0 /classes/Cart.php:1426
399 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (26)
 0.343 ms 1 /classes/ProductAssembler.php:64
189 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 82 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 82 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.341 ms 0 /classes/Cart.php:1426
373 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (2)
 0.341 ms 1 /classes/ProductAssembler.php:64
334 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 18 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 18 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.340 ms 0 /classes/Cart.php:1426
417 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (16)
 0.338 ms 1 /classes/ProductAssembler.php:64
0 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM psm7_shop_url su
LEFT JOIN psm7_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.newspeed.es' OR su.domain_ssl = 'www.newspeed.es')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.338 ms 1 Yes /classes/shop/Shop.php:1364
15 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `psm7_meta` m
LEFT JOIN `psm7_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.336 ms 59 Yes /classes/Dispatcher.php:654
369 
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
FROM `psm7_product` p
INNER JOIN psm7_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `psm7_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 10 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
 0.335 ms 44 /classes/Category.php:991
386 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (36)
 0.332 ms 1 /classes/ProductAssembler.php:64
476 
INSERT INTO `psm7_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('56825', '', 'www.newspeed.es/home/5-smart-4-ruedas-8425402134962.html', '', '2024-09-15 17:30:14')
 0.332 ms 1 /classes/ObjectModel.php:622
356 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.331 ms 0 /classes/Cart.php:1426
80 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.330 ms 0 /classes/Cart.php:1426
312 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 42 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 42 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.329 ms 0 /classes/Cart.php:1426
324 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 17
ORDER BY f.position ASC
 0.328 ms 2 Yes /classes/Product.php:6017
383 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (11)
 0.327 ms 1 /classes/ProductAssembler.php:64
380 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (39)
 0.327 ms 1 /classes/ProductAssembler.php:64
18 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `psm7_module` m
LEFT JOIN `psm7_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.327 ms 93 /classes/module/Module.php:345
377 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (15)
 0.325 ms 1 /classes/ProductAssembler.php:64
393 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (85)
 0.322 ms 1 /classes/ProductAssembler.php:64
405 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (42)
 0.321 ms 1 /classes/ProductAssembler.php:64
367 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 12 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 12 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.321 ms 0 /classes/Cart.php:1426
402 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (13)
 0.320 ms 1 /classes/ProductAssembler.php:64
421 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (82) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.319 ms 1 Yes Yes /classes/Product.php:4520
211 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 15 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 15 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.312 ms 0 /classes/Cart.php:1426
36 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5) AND (b.`id_shop` = 1) LIMIT 1
 0.307 ms 1 /src/Adapter/EntityMapper.php:71
257 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 8 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.307 ms 0 /classes/Cart.php:1426
222 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 39 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 39 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.303 ms 0 /classes/Cart.php:1426
268 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 85 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 85 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.299 ms 0 /classes/Cart.php:1426
279 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 81 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 81 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.299 ms 0 /classes/Cart.php:1426
233 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 11 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 11 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.297 ms 0 /classes/Cart.php:1426
200 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.297 ms 0 /classes/Cart.php:1426
247 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 36 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 36 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.295 ms 0 /classes/Cart.php:1426
409 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `psm7_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 17
ORDER BY `position`
 0.293 ms 1 Yes /classes/Product.php:3545
291 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 26
ORDER BY f.position ASC
 0.290 ms 2 Yes /classes/Product.php:6017
1 
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM psm7_shop_group gs
LEFT JOIN psm7_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN psm7_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
 0.287 ms 1 Yes /classes/shop/Shop.php:715
68 
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `psm7_attribute` a
LEFT JOIN `psm7_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `psm7_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `psm7_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `psm7_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN psm7_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 5
 0.283 ms 1 /classes/Product.php:7559
439 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (26) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.277 ms 1 Yes Yes /classes/Product.php:4520
431 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (36) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.272 ms 1 Yes Yes /classes/Product.php:4520
475 
INSERT INTO `psm7_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('58084', '24', '65790478', '', '1', '1', '2024-09-15 17:30:14')
 0.271 ms 1 /classes/ObjectModel.php:622
429 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (11) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.267 ms 1 Yes Yes /classes/Product.php:4520
447 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (18) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.266 ms 1 Yes Yes /classes/Product.php:4520
153 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1) AND (b.`id_shop` = 1) LIMIT 1
 0.265 ms 1 /src/Adapter/EntityMapper.php:71
425 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (15) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.265 ms 1 Yes Yes /classes/Product.php:4520
65 
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `psm7_category` c
LEFT JOIN `psm7_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.265 ms 7 Yes Yes /classes/Category.php:1151
423 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (2) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.261 ms 1 Yes Yes /classes/Product.php:4520
437 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (81) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.261 ms 1 Yes Yes /classes/Product.php:4520
433 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (8) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.261 ms 1 Yes Yes /classes/Product.php:4520
346 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 9
ORDER BY f.position ASC
 0.259 ms 2 Yes /classes/Product.php:6017
427 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (39) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.258 ms 1 Yes Yes /classes/Product.php:4520
146 
SELECT SQL_NO_CACHE *
FROM `psm7_currency` c
INNER JOIN psm7_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1)
WHERE c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
 0.257 ms 2 Yes /classes/Currency.php:694
449 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (9) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.257 ms 1 Yes Yes /classes/Product.php:4520
339 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `psm7_product` p
INNER JOIN `psm7_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `psm7_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 9)
 0.257 ms 1 /classes/Product.php:3860
435 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (85) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.257 ms 1 Yes Yes /classes/Product.php:4520
445 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (17) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.256 ms 1 Yes Yes /classes/Product.php:4520
349 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16) AND (b.`id_shop` = 1) LIMIT 1
 0.256 ms 1 /src/Adapter/EntityMapper.php:71
374 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.255 ms 1 /src/Adapter/EntityMapper.php:71
443 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (42) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.254 ms 1 Yes Yes /classes/Product.php:4520
452 
SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `psm7_category_product` cp
LEFT JOIN `psm7_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `psm7_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` IN (5) AND cl.`id_lang` = 2
ORDER BY c.`level_depth` DESC
 0.254 ms 2 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
451 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.253 ms 1 Yes Yes /classes/Product.php:4520
327 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 18) AND (b.`id_shop` = 1) LIMIT 1
 0.252 ms 1 /src/Adapter/EntityMapper.php:71
316 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 17) AND (b.`id_shop` = 1) LIMIT 1
 0.252 ms 1 /src/Adapter/EntityMapper.php:71
294 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13) AND (b.`id_shop` = 1) LIMIT 1
 0.252 ms 1 /src/Adapter/EntityMapper.php:71
441 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.252 ms 1 Yes Yes /classes/Product.php:4520
305 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 42) AND (b.`id_shop` = 1) LIMIT 1
 0.251 ms 1 /src/Adapter/EntityMapper.php:71
272 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 81) AND (b.`id_shop` = 1) LIMIT 1
 0.250 ms 1 /src/Adapter/EntityMapper.php:71
41 
SELECT SQL_NO_CACHE tr.*
FROM `psm7_tax_rule` tr
JOIN `psm7_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 55
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.249 ms 1 /classes/tax/TaxRulesTaxManager.php:109
360 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 12) AND (b.`id_shop` = 1) LIMIT 1
 0.242 ms 1 /src/Adapter/EntityMapper.php:71
81 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5
ORDER BY f.position ASC
 0.242 ms 2 Yes /classes/Product.php:6017
313 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 42
ORDER BY f.position ASC
 0.241 ms 2 Yes /classes/Product.php:6017
120 
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "revsliderprestashop" LIMIT 1
 0.241 ms 1 /classes/module/Module.php:2636
387 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `psm7_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 36
ORDER BY `position`
 0.239 ms 1 Yes /classes/Product.php:3545
190 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 82
ORDER BY f.position ASC
 0.237 ms 2 Yes /classes/Product.php:6017
335 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 18
ORDER BY f.position ASC
 0.237 ms 2 Yes /classes/Product.php:6017
261 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 85) AND (b.`id_shop` = 1) LIMIT 1
 0.237 ms 1 /src/Adapter/EntityMapper.php:71
179 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 82) AND (b.`id_shop` = 1) LIMIT 1
 0.236 ms 1 /src/Adapter/EntityMapper.php:71
357 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 16
ORDER BY f.position ASC
 0.236 ms 2 Yes /classes/Product.php:6017