CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES
CEBADOR PARA PECES GRANDES

CEBADOR PARA PECES GRANDES

41,28 €
Impuestos excluidos

CEBADOR PARA PECES GRANDES

Descripción

Siempre es divertido pescar peces pequeños y medianos, pero lo que realmente nos apasiona es pescar peces grandes.

Qué duda cabe que cebando atraemos gran cantidad de peces, pero la mayoría de veces el cebado no se realiza en el lugar deseado y cebando con pasta, atraemos a todos los peces que hay por la zona, las cuestiones son:

¿Cómo atraer  únicamente a los peces grandes?

¿Cómo cebar exactamente en la zona donde se encuentra nuestro anzuelo?

 Las respuestas son obvias:

 -       Cebando con trozos grandes, atraeremos a peces grandes

-       Depositando el cebo en nuestra zona de pesca tendremos opciones a que muerdan nuestro anzuelo.

 Pensando en estas teorías, se ha pensado en este novedoso invento que una vez probado, nos ha dado resultados satisfactorios, pasando de pescar peces pequeños a peces grandes.

La gran mayoría de cebadores están diseñados para diluir el cebo en un periodo de tiempo relativamente largo, atrayendo a todos los peces, tanto grandes como pequeños, pero al ser estos la gran mayoría que se encuentran en el mar, son los que se acaban pescando, “pequeños”. Este cebador no se carga con pasta para diluir, sino con trozos grandes de carnada, exclusiva para peces grandes, por lo que acabaremos pescando peces “grandes”.

            El cebador para peces grandes  está diseñado para pescar  fondeado y depositar el cebo tanto en el fondo del mar, como para liberarlo a la profundidad deseada, en el caso de pescar a profundidades intermedias, siempre en el mismo lugar donde se encuentra nuestro anzuelo.

Para ello cuenta con un sistema de apertura de doble accionamiento:

                        1º.- Al llegar el cebador, al fondo del mar, actúa automáticamente por contacto el primer accionamiento, que por empuje vertical del embolo inferior, abre el cebador, separando la parte interna del bote, “bandeja” de la parte externa, “cuerpo”, liberando los trozos de cebo en el fondo del mar. Donde se encuentra nuestro anzuelo.

                        2º.- Mediante un pequeño tirón, tanto en el fondo del mar como a la profundidad deseada el cebador se abre, gracias al principio de acción y reacción. Para ello, se ha diseñado un resalte en el cuerpo del cebador, con una superficie de 24 cm² , donde se ejerce la presión capaz de abrir el bote y liberar los trozos de cebo en el lugar deseado.

 La verificación de la apertura nos la da la resistencia del agua a la recuperación del cebador:

  -       Suave, si no se ha abierto

  -       Fuerte si sí se ha abierto.   

El cebador para peces grandes se compone de:

 Cuerpo exterior:

-       Resalte de apoyo para la apertura.

-       Ranuras de alojamiento del muelle de sujeción

-       Agujeros de drenaje

Parte interior:

-       Tapa superior con rosca y agujeros de drenaje

-       Tornillo perforado

-       Tuerca

-       Manguito

-       Eje guía

-       Apoyo del muelle

-       Muelle de sujeción

-       Abrazaderas de presión y regulación

-       Bandeja de expulsión de cebo

-       Eje de apertura inferior

-       Cable de unión del conjunto con lazada para amarre del sedal en parte superior

-       Tapa inferior con agujeros de drenaje

-       Plomo

-       Remaches de presión

Despiece cebador para peces grandes

Este cebador, esta patentado como modelo de utilidad nº : U201931399

Detalles del producto

U-201931399
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 537.622 ms
Querying Time 119 ms
Queries 464
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.007 ms 0.007 ms 13.01 Mb 13.3 Mb
__construct 15.263 ms 15.270 ms 1.94 Mb 15.7 Mb
init 120.298 ms 135.568 ms 8.26 Mb 23.5 Mb
checkAccess 0.002 ms 135.570 ms - Mb 23.5 Mb
setMedia 9.675 ms 145.245 ms 0.69 Mb 24.1 Mb
postProcess 0.008 ms 145.253 ms - Mb 24.1 Mb
initHeader 0.003 ms 145.256 ms - Mb 24.1 Mb
initContent 149.480 ms 294.736 ms 7.81 Mb 32.4 Mb
initFooter 0.002 ms 294.738 ms - Mb 32.4 Mb
display 242.884 ms 537.622 ms 21.99 Mb 54.0 Mb
Hook Time Memory Usage
displayFooterProduct 128.120 ms 9.31 Mb
FilterProductContent 52.036 ms 3.06 Mb
displayHeaderTop 34.689 ms 6.90 Mb
displayProductListReviews 18.091 ms 0.64 Mb
displayMainMenu 12.132 ms 0.57 Mb
DisplayFooterProduct 10.650 ms 0.66 Mb
DisplayBeforeBodyClosingTag 6.771 ms 0.37 Mb
displayFooter 5.697 ms 0.31 Mb
displayNav1 4.355 ms 0.38 Mb
displayAfterBreadcrumb 3.445 ms 0.23 Mb
displayProductAdditionalInfo 3.343 ms 0.24 Mb
displayProductExtraContent 3.306 ms 0.21 Mb
ActionFrontControllerSetMedia 1.924 ms 0.13 Mb
DisplayHeader 1.108 ms 0.04 Mb
displayBeforeBodyClosingTag 1.013 ms 0.04 Mb
renderWidget 0.977 ms 0.05 Mb
displayNav2 0.757 ms 0.07 Mb
displayProductRating 0.435 ms 0.01 Mb
displayProductElementor 0.435 ms 0.03 Mb
DisplayTop 0.065 ms - Mb
ActionDispatcher 0.015 ms - Mb
DisplayProductAdditionalInfo 0.008 ms - Mb
22 hook(s) 289.371 ms 23.25 Mb
Module Time Memory Usage
iqitthemeeditor 4.241 ms 0.61 Mb
ps_emailsubscription 5.594 ms 0.44 Mb
ps_emailalerts 3.808 ms 0.27 Mb
iqitreviews 13.191 ms 0.90 Mb
productcomments 74.775 ms 3.97 Mb
ps_shoppingcart 0.516 ms 0.05 Mb
ps_googleanalytics 3.130 ms 0.25 Mb
iqitcontactpage 1.924 ms 0.12 Mb
iqitcookielaw 1.606 ms 0.16 Mb
iqitelementor 42.041 ms 7.73 Mb
iqitmegamenu 18.790 ms 1.31 Mb
iqitlinksmanager 9.388 ms 0.72 Mb
ps_languageselector 0.750 ms 0.06 Mb
ps_currencyselector 0.592 ms 0.07 Mb
iqitsearch 1.454 ms 0.09 Mb
ps_customersignin 0.211 ms 0.02 Mb
pagesnotfound 0.488 ms 0.05 Mb
iqitproductsnav 3.831 ms 0.27 Mb
ps_sharebuttons 1.487 ms 0.11 Mb
iqitproducttags 1.312 ms 0.10 Mb
ps_viewedproduct 1.740 ms 0.14 Mb
psgdpr 1.907 ms 0.22 Mb
ps_crossselling 1.646 ms 0.13 Mb
ps_categoryproducts 126.210 ms 9.19 Mb
iqitcrossselling 1.445 ms 0.12 Mb
statsdata 6.428 ms 0.30 Mb
26 module(s) 328.505 ms 27.38 Mb

Stopwatch SQL - 464 queries

# Query Time (ms) Rows Filesort Group By Location
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
 3.257 ms 370 /classes/Hook.php:456
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`)
 3.256 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
 3.096 ms 0 /classes/Hook.php:1326
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.542 ms 44 Yes /classes/Category.php:1062
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)
 2.125 ms 1 /modules/iqitmegamenu/models/IqitMenuLinks.php:25
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.773 ms 144 Yes Yes /classes/Hook.php:1267
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` = 81 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 1.129 ms 1 Yes /classes/Product.php:4698
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` = 81
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
 1.028 ms 1 Yes Yes /classes/Product.php:4594
237 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `psm7_product_shop`
WHERE `id_product` = 35 AND id_shop=1 LIMIT 1
 0.968 ms 1 /classes/Product.php:6872
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.962 ms 1 Yes Yes /classes/Category.php:924
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` = 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.843 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` = 81) AND (b.`id_shop` = 1) LIMIT 1
 0.759 ms 1 /src/Adapter/EntityMapper.php:71
12 
SELECT SQL_NO_CACHE lower(name) as name
FROM `psm7_hook` h
WHERE (h.active = 1)
 0.748 ms 950 /classes/Hook.php:1366
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.697 ms 1 Yes /classes/shop/Shop.php:715
16 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `psm7_hook`
 0.657 ms 950 /classes/Hook.php:1326
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.633 ms 16 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
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.632 ms 2 Yes Yes /classes/Category.php:799
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` = 53
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.629 ms 1 /classes/tax/TaxRulesTaxManager.php:109
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.605 ms 8 Yes Yes /classes/Contact.php:100
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.561 ms 3 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.560 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.546 ms 2 Yes Yes /classes/Category.php:799
311 
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.542 ms 0 /classes/Cart.php:1426
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` = 4 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` = 4 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.540 ms 0 /classes/Cart.php:1426
82 
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` = 81
ORDER BY `position`
 0.538 ms 9 Yes /classes/Product.php:3545
264 
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.535 ms 0 /classes/Cart.php:1426
458 
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.534 ms 1 /classes/ObjectModel.php:622
288 
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` = 20 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` = 20 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.525 ms 0 /classes/Cart.php:1426
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` = 81
 0.506 ms 1 /classes/Product.php:7559
299 
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.504 ms 0 /classes/Cart.php:1426
438 
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.487 ms 1 Yes Yes /classes/Product.php:4520
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` = 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_customization` = 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.485 ms 0 /classes/Cart.php:1426
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.482 ms 59 Yes /classes/Dispatcher.php:654
436 
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 (83) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.480 ms 1 Yes Yes /classes/Product.php:4520
322 
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` = 24 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` = 24 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.477 ms 0 /classes/Cart.php:1426
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.476 ms 7 Yes Yes /classes/Category.php:1151
355 
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.473 ms 0 /classes/Cart.php:1426
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.471 ms 93 /classes/module/Module.php:345
434 
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.471 ms 1 Yes Yes /classes/Product.php:4520
333 
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.459 ms 0 /classes/Cart.php:1426
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 = 81
ORDER BY f.position ASC
 0.448 ms 2 Yes /classes/Product.php:6017
344 
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` = 83 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` = 83 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.446 ms 0 /classes/Cart.php:1426
281 
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` = 20) AND (b.`id_shop` = 1) LIMIT 1
 0.442 ms 1 /src/Adapter/EntityMapper.php:71
11 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `psm7_lang` l
JOIN psm7_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
 0.437 ms 1 /classes/Language.php:1216
439 
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 (81) AND cl.`id_lang` = 2
ORDER BY c.`level_depth` DESC
 0.436 ms 2 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
46 
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` = 81)
 0.425 ms 1 /classes/Product.php:3860
24 
SELECT SQL_NO_CACHE *
FROM `psm7_currency` a
LEFT JOIN `psm7_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
LEFT JOIN `psm7_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
 0.421 ms 1 /src/Adapter/EntityMapper.php:71
462 
INSERT INTO `psm7_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('58561', '27', '65790478', '', '1', '1', '2024-09-15 19:24:01')
 0.415 ms 1 /classes/ObjectModel.php:622
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` = 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.411 ms 0 /classes/Cart.php:1426
242 
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` = 35 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` = 35 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.410 ms 0 /classes/Cart.php:1426
459 
SELECT SQL_NO_CACHE `id_guest`
FROM `psm7_connections`
WHERE `id_guest` = 58561
AND `date_add` > '2024-09-15 18:54:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 0.407 ms 1 Yes /classes/Connection.php:168
232 
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.398 ms 0 /classes/Cart.php:1426
253 
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.395 ms 0 /classes/Cart.php:1426
33 
SELECT SQL_NO_CACHE *
FROM `psm7_group` a
LEFT JOIN `psm7_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
 0.392 ms 1 /src/Adapter/EntityMapper.php:71
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 (14)
 0.389 ms 1 /classes/ProductAssembler.php:64
20 
SELECT SQL_NO_CACHE * FROM `psm7_currency` c ORDER BY `iso_code` ASC
 0.387 ms 2 Yes /classes/Currency.php:709
60 
SELECT SQL_NO_CACHE COUNT(*) FROM `psm7_pack` WHERE id_product_pack = 81 LIMIT 1
 0.386 ms 1 /classes/Pack.php:89
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 (20)
 0.384 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` = 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.373 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` = 25 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` = 25 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.371 ms 0 /classes/Cart.php:1426
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` = 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.371 ms 0 /classes/Cart.php:1426
358 
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.371 ms 1 /classes/ProductAssembler.php:64
30 
SELECT SQL_NO_CACHE *
FROM `psm7_currency` a
LEFT JOIN `psm7_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
 0.369 ms 1 /src/Adapter/EntityMapper.php:71
348 
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.369 ms 1 /src/Adapter/EntityMapper.php:71
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 (4)
 0.369 ms 1 /classes/ProductAssembler.php:64
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 (17)
 0.368 ms 1 /classes/ProductAssembler.php:64
463 
INSERT INTO `psm7_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('57302', '', 'www.newspeed.es/home/81-cebador-para-peces-grandes.html', '', '2024-09-15 19:24:01')
 0.368 ms 1 /classes/ObjectModel.php:622
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.367 ms 2 Yes /classes/Currency.php:694
278 
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 = 4
ORDER BY f.position ASC
 0.366 ms 2 Yes /classes/Product.php:6017
376 
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.366 ms 1 /classes/ProductAssembler.php:64
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 (11)
 0.365 ms 1 /classes/ProductAssembler.php:64
289 
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 = 20
ORDER BY f.position ASC
 0.363 ms 2 Yes /classes/Product.php:6017
364 
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.363 ms 1 /classes/ProductAssembler.php:64
292 
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.362 ms 1 /src/Adapter/EntityMapper.php:71
304 
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` = 11) AND (b.`id_shop` = 1) LIMIT 1
 0.358 ms 1 /src/Adapter/EntityMapper.php:71
361 
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 (25)
 0.356 ms 1 /classes/ProductAssembler.php:64
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 (35)
 0.355 ms 1 /classes/ProductAssembler.php:64
326 
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` = 26) AND (b.`id_shop` = 1) LIMIT 1
 0.354 ms 1 /src/Adapter/EntityMapper.php:71
315 
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` = 24) AND (b.`id_shop` = 1) LIMIT 1
 0.352 ms 1 /src/Adapter/EntityMapper.php:71
265 
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.348 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.347 ms 1 /classes/shop/ShopUrl.php:182
357 
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.344 ms 44 /classes/Category.php:991
345 
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 = 83
ORDER BY f.position ASC
 0.343 ms 2 Yes /classes/Product.php:6017
398 
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.341 ms 1 /classes/ProductAssembler.php:64
367 
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.340 ms 1 /classes/ProductAssembler.php:64
323 
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 = 24
ORDER BY f.position ASC
 0.339 ms 2 Yes /classes/Product.php:6017
410 
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 (25) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.339 ms 1 Yes Yes /classes/Product.php:4520
337 
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` = 83) AND (b.`id_shop` = 1) LIMIT 1
 0.339 ms 1 /src/Adapter/EntityMapper.php:71
408 
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.338 ms 1 Yes Yes /classes/Product.php:4520
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 (24)
 0.336 ms 1 /classes/ProductAssembler.php:64
300 
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 = 14
ORDER BY f.position ASC
 0.335 ms 2 Yes /classes/Product.php:6017
401 
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 (83)
 0.333 ms 1 /classes/ProductAssembler.php:64
379 
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.333 ms 1 /classes/ProductAssembler.php:64
404 
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.332 ms 1 /classes/ProductAssembler.php:64
55 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `psm7_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 10 LIMIT 1
 0.331 ms 1 /classes/Category.php:1378
312 
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 = 11
ORDER BY f.position ASC
 0.330 ms 2 Yes /classes/Product.php:6017
334 
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.329 ms 2 Yes /classes/Product.php:6017
225 
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.329 ms 1 /src/Adapter/EntityMapper.php:71
8 
SELECT SQL_NO_CACHE *
FROM `psm7_lang` a
LEFT JOIN `psm7_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 2) LIMIT 1
 0.326 ms 1 /src/Adapter/EntityMapper.php:71
246 
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.313 ms 1 /src/Adapter/EntityMapper.php:71
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.312 ms 1 Yes /classes/shop/Shop.php:1364
420 
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.312 ms 1 Yes Yes /classes/Product.php:4520
412 
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.306 ms 1 Yes Yes /classes/Product.php:4520
6 
SELECT SQL_NO_CACHE *
FROM `psm7_country` a
LEFT JOIN `psm7_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `psm7_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
 0.305 ms 1 /src/Adapter/EntityMapper.php:71
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.304 ms 1 /src/Adapter/EntityMapper.php:71
257 
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.300 ms 1 /src/Adapter/EntityMapper.php:71
201 
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 = 25
ORDER BY f.position ASC
 0.299 ms 2 Yes /classes/Product.php:6017
437 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 18 LIMIT 1
 0.298 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
449 
SELECT SQL_NO_CACHE *
FROM psm7_meta m
LEFT JOIN psm7_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
 0.294 ms 2 /classes/Meta.php:193