kit reparación cebador para peces grandes
kit reparación cebador para peces grandes
kit reparación cebador para peces grandes
kit reparación cebador para peces grandes

kit reparación cebador para peces grandes

4,00 €
Impuestos excluidos

kit de reparación cebador para peces grandes

Descripción

Con el tiempo y el uso, posiblemente se puede deteriorar el muelle de sujeción y apertura, perdiendo su elasticidad,

por ello, NEW SPEED SL, ha pensado en un kit de reparación, para sustituir el muelle deterior

Este kit de reparación se compone de:

- 1 muelle nuevo

- 1 cable nuevo con la cabeza de remache inferior prensada.

- 1 cabeza de remache para la parte superior.

Para la sustitución del muelle, consultar el vídeo:  

Así mismo disponemos del despiece correspondiente de todos y cada uno de sus componentes, por lo que se pueden poner en contacto con NEW SPEED SL via email info@newspeed.es para cualquier consulta o pedidos.

Detalles del producto

6 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 401.580 ms
Querying Time 98 ms
Queries 475
Memory Peak Usage 54.0 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.003 ms 0.003 ms 13.01 Mb 13.3 Mb
__construct 9.335 ms 9.338 ms 1.94 Mb 15.7 Mb
init 68.457 ms 77.795 ms 8.24 Mb 23.5 Mb
checkAccess 0.001 ms 77.796 ms - Mb 23.5 Mb
setMedia 5.500 ms 83.296 ms 0.69 Mb 24.1 Mb
postProcess 0.005 ms 83.301 ms - Mb 24.1 Mb
initHeader 0.002 ms 83.303 ms - Mb 24.1 Mb
initContent 98.071 ms 181.374 ms 7.77 Mb 32.4 Mb
initFooter 0.002 ms 181.376 ms - Mb 32.4 Mb
display 220.204 ms 401.580 ms 22.16 Mb 54.0 Mb
Hook Time Memory Usage
displayFooterProduct 112.454 ms 9.60 Mb
displayHeaderTop 35.540 ms 6.90 Mb
FilterProductContent 32.026 ms 3.06 Mb
displayProductListReviews 14.701 ms 0.64 Mb
displayMainMenu 11.775 ms 0.57 Mb
DisplayFooterProduct 10.960 ms 0.66 Mb
DisplayBeforeBodyClosingTag 4.938 ms 0.37 Mb
displayNav1 4.056 ms 0.38 Mb
displayAfterBreadcrumb 3.632 ms 0.23 Mb
displayFooter 3.607 ms 0.31 Mb
displayProductAdditionalInfo 3.030 ms 0.24 Mb
displayProductExtraContent 2.190 ms 0.21 Mb
DisplayHeader 1.118 ms 0.04 Mb
ActionFrontControllerSetMedia 1.107 ms 0.13 Mb
renderWidget 1.061 ms 0.05 Mb
displayBeforeBodyClosingTag 0.613 ms 0.04 Mb
displayNav2 0.513 ms 0.07 Mb
displayProductElementor 0.365 ms 0.03 Mb
displayProductRating 0.358 ms 0.01 Mb
DisplayTop 0.067 ms - Mb
ActionDispatcher 0.009 ms - Mb
DisplayProductAdditionalInfo 0.007 ms - Mb
22 hook(s) 244.127 ms 23.54 Mb
Module Time Memory Usage
iqitthemeeditor 3.357 ms 0.61 Mb
ps_emailsubscription 3.290 ms 0.44 Mb
ps_emailalerts 2.143 ms 0.27 Mb
iqitreviews 10.264 ms 0.90 Mb
productcomments 52.461 ms 3.97 Mb
ps_shoppingcart 0.483 ms 0.05 Mb
ps_googleanalytics 2.339 ms 0.25 Mb
iqitcontactpage 1.482 ms 0.12 Mb
iqitcookielaw 1.246 ms 0.16 Mb
iqitelementor 42.916 ms 7.73 Mb
iqitmegamenu 17.924 ms 1.31 Mb
iqitlinksmanager 7.592 ms 0.72 Mb
ps_languageselector 0.525 ms 0.06 Mb
ps_currencyselector 0.515 ms 0.07 Mb
iqitsearch 1.569 ms 0.09 Mb
ps_customersignin 0.308 ms 0.02 Mb
pagesnotfound 0.518 ms 0.05 Mb
iqitproductsnav 4.021 ms 0.27 Mb
ps_sharebuttons 1.404 ms 0.11 Mb
iqitproducttags 1.201 ms 0.10 Mb
ps_viewedproduct 1.393 ms 0.14 Mb
psgdpr 2.331 ms 0.22 Mb
ps_crossselling 1.697 ms 0.13 Mb
ps_categoryproducts 110.875 ms 9.48 Mb
iqitcrossselling 0.984 ms 0.12 Mb
statsdata 4.649 ms 0.30 Mb
26 module(s) 277.487 ms 27.67 Mb

Stopwatch SQL - 475 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
3.995 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.581 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.659 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.586 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.461 ms 144 Yes Yes /classes/Hook.php:1267
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
1.170 ms 8 Yes Yes /classes/Contact.php:100
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
1.009 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` = 82
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.873 ms 1 Yes Yes /classes/Product.php:4594
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.853 ms 3 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.784 ms 2 Yes Yes /classes/Category.php:799
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.779 ms 1 Yes Yes /classes/Category.php:799
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.690 ms 16 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
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` = 82 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
0.652 ms 1 Yes /classes/Product.php:4698
16
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `psm7_hook`
0.622 ms 950 /classes/Hook.php:1326
12
SELECT SQL_NO_CACHE lower(name) as name
FROM `psm7_hook` h
WHERE (h.active = 1)
0.586 ms 950 /classes/Hook.php:1366
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.582 ms 1 Yes Yes /classes/Category.php:924
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 (38)
0.549 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` = 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.495 ms 0 /classes/Cart.php:1426
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 (14)
0.490 ms 1 /classes/ProductAssembler.php:64
221
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.476 ms 0 /classes/Cart.php:1426
210
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.472 ms 0 /classes/Cart.php:1426
244
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` = 27 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` = 27 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.460 ms 0 /classes/Cart.php:1426
234
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.460 ms 0 /classes/Cart.php:1426
199
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` = 1 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` = 1 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.440 ms 0 /classes/Cart.php:1426
469
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.439 ms 1 /classes/ObjectModel.php:622
412
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.436 ms 1 /classes/ProductAssembler.php:64
320
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.417 ms 0 /classes/Cart.php:1426
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.398 ms 1 /src/Adapter/EntityMapper.php:71
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` = 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.388 ms 0 /classes/Cart.php:1426
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` = 39) AND (b.`id_shop` = 1) LIMIT 1
0.383 ms 1 /src/Adapter/EntityMapper.php:71
248
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` = 14) AND (b.`id_shop` = 1) LIMIT 1
0.383 ms 1 /src/Adapter/EntityMapper.php:71
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` = 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_customization` = 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.379 ms 0 /classes/Cart.php:1426
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.374 ms 1 Yes /classes/shop/Shop.php:1364
366
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.364 ms 1 /classes/ProductAssembler.php:64
203
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.360 ms 1 /src/Adapter/EntityMapper.php:71
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.360 ms 59 Yes /classes/Dispatcher.php:654
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 (16) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.358 ms 1 Yes Yes /classes/Product.php:4520
365
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.353 ms 44 /classes/Category.php:991
392
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.351 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.351 ms 93 /classes/module/Module.php:345
473
INSERT INTO `psm7_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('58628', '18', '65790478', '', '1', '1', '2024-09-15 19:26:01')
0.350 ms 1 /classes/ObjectModel.php:622
419
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.348 ms 1 Yes Yes /classes/Product.php:4520
375
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.345 ms 1 /classes/ProductAssembler.php:64
255
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` = 14 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` = 14 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.345 ms 0 /classes/Cart.php:1426
245
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 = 27
ORDER BY f.position ASC
0.345 ms 2 Yes /classes/Product.php:6017
156
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` = 35) AND (b.`id_shop` = 1) LIMIT 1
0.343 ms 1 /src/Adapter/EntityMapper.php:71
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.341 ms 1 Yes /classes/shop/Shop.php:715
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 = 39
ORDER BY f.position ASC
0.340 ms 2 Yes /classes/Product.php:6017
415
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.337 ms 1 /classes/ProductAssembler.php:64
382
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 (27)
0.334 ms 1 /classes/ProductAssembler.php:64
222
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.334 ms 2 Yes /classes/Product.php:6017
369
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 (1)
0.333 ms 1 /classes/ProductAssembler.php:64
372
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.331 ms 1 /classes/ProductAssembler.php:64
378
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.330 ms 1 /classes/ProductAssembler.php:64
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.330 ms 1 /classes/ProductAssembler.php:64
214
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.329 ms 1 /src/Adapter/EntityMapper.php:71
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 (12)
0.328 ms 1 /classes/ProductAssembler.php:64
266
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` = 38 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` = 38 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.324 ms 0 /classes/Cart.php:1426
182
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.322 ms 1 /classes/tax/TaxRulesTaxManager.php:109
395
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 (7)
0.320 ms 1 /classes/ProductAssembler.php:64
211
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.320 ms 2 Yes /classes/Product.php:6017
200
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 = 1
ORDER BY f.position ASC
0.319 ms 2 Yes /classes/Product.php:6017
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 (9)
0.317 ms 1 /classes/ProductAssembler.php:64
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 (5)
0.316 ms 1 /classes/ProductAssembler.php:64
277
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.316 ms 0 /classes/Cart.php:1426
177
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 39
AND image_shop.`cover` = 1 LIMIT 1
0.315 ms 5 /classes/Product.php:3570
235
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 = 8
ORDER BY f.position ASC
0.315 ms 2 Yes /classes/Product.php:6017
330
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.314 ms 0 /classes/Cart.php:1426
287
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` = 7 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` = 7 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.313 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` = 82) AND (b.`id_shop` = 1) LIMIT 1
0.312 ms 1 /src/Adapter/EntityMapper.php:71
363
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.308 ms 0 /classes/Cart.php:1426
321
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 = 12
ORDER BY f.position ASC
0.308 ms 2 Yes /classes/Product.php:6017
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` = 82
0.306 ms 1 /classes/Product.php:7559
352
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.306 ms 0 /classes/Cart.php:1426
309
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.305 ms 0 /classes/Cart.php:1426
341
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.304 ms 0 /classes/Cart.php:1426
298
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.302 ms 0 /classes/Cart.php:1426
474
INSERT INTO `psm7_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('57369', '', 'www.newspeed.es/home/82-kit-reparacion-cebador-para-peces-grandes.html', '', '2024-09-15 19:26:01')
0.299 ms 1 /classes/ObjectModel.php:622
227
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` = 54
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.292 ms 1 /classes/tax/TaxRulesTaxManager.php:109
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 (38) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.286 ms 1 Yes Yes /classes/Product.php:4520
120
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "revsliderprestashop" LIMIT 1
0.285 ms 1 /classes/module/Module.php:2636
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 (1) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.281 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.277 ms 2 Yes /classes/Currency.php:694
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 = 82
ORDER BY f.position ASC
0.276 ms 2 Yes /classes/Product.php:6017
10
SELECT SQL_NO_CACHE domain, domain_ssl
FROM psm7_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.273 ms 1 /classes/shop/ShopUrl.php:182
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 (9) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.270 ms 1 Yes Yes /classes/Product.php:4520
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 (18) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.269 ms 1 Yes Yes /classes/Product.php:4520
450
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 (82) AND cl.`id_lang` = 2
ORDER BY c.`level_depth` DESC
0.268 ms 2 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
136
SELECT SQL_NO_CACHE *
FROM `psm7_category` a
LEFT JOIN `psm7_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psm7_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 12) AND (b.`id_shop` = 1) LIMIT 1
0.268 ms 1 /src/Adapter/EntityMapper.php:71
180
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` = 39)
0.268 ms 1 /classes/Product.php:3860
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 (8) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.268 ms 1 Yes Yes /classes/Product.php:4520
97
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
0.267 ms 1 /classes/module/Module.php:2636
170
SELECT SQL_NO_CACHE o.id_order
FROM psm7_orders o
LEFT JOIN psm7_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
AND od.product_id IN (82)
ORDER BY o.id_order DESC
LIMIT 400
0.267 ms 1 Yes /modules/ps_crossselling/ps_crossselling.php:257
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 (15) 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
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 (12) 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
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 (7) 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.264 ms 7 Yes Yes /classes/Category.php:1151
144
SELECT SQL_NO_CACHE l.id_iqitmenulinks, l.new_window, s.name, ll.link, ll.label
FROM psm7_iqitmenulinks l
LEFT JOIN psm7_iqitmenulinks_lang ll ON (l.id_iqitmenulinks = ll.id_iqitmenulinks AND ll.id_lang = 2 AND ll.id_shop=1)
LEFT JOIN psm7_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_iqitmenulinks = "1"
AND l.id_shop IN (0, 1)
0.261 ms 1 /modules/iqitmegamenu/models/IqitMenuLinks.php:25
154
SELECT SQL_NO_CACHE cp.id_product as id_product
FROM `psm7_category_product` as cp
RIGHT JOIN `psm7_product` as p
ON p.id_product=cp.id_product
WHERE cp.id_category = 10
AND p.active = 1
AND cp.position != 0 ORDER BY cp.position DESC LIMIT 1
0.261 ms 45 /modules/iqitproductsnav/iqitproductsnav.php:175
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 (13) 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
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 (27) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.260 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 (14) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.260 ms 1 Yes Yes /classes/Product.php:4520
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` = 14
ORDER BY `position`
0.258 ms 1 Yes /classes/Product.php:3545
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 (42) 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
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 (5) 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