Referencia: 18

Marca: Ledcar

W5W CANBUS T10 8 LED SMD

NO DA ERROR EN EL CHECK CONTROL DEL COCHEIdeal para luz de posición.Conector: W5W / T10Leds: 8 LEDs SMD 3528 de alta intensidad y bajo consumoVoltaje: 12V Precio indicado por unidad 2 AÑOS DE GARANTÍA

Precio 3,49 € Precio base 4,99 €
Más
En stock

Referencia: 286

Marca: Ledcar

PLACA 13.5W 36 COB LEDS W5W BA9S C5W

NUEVA TECNOLOGÍA COB LEDPlaca de 27 COB LEDs para iluminar plafones interiores, maletero...Se incluye casquillo T10 (W5W), ba9s y festoon (C5W).La parte de atrás es autoadhesiva. Voltaje: 12/24/30 VPotencia: 13.5 WColor: BLANCO 6000K2 AÑOS DE GARANTÍA

Precio 6,99 € Precio base 9,99 €
Más
En stock

Referencia: 577

Marca: Ledcar

T10 SUPER CANBUS W5W 15 LED 4014 SMD

LED super brillante SMD 4014Bajo consumo de energía y muy alta intensidad, con sistema SUPER CANBUS que evita fallo en check.Conector: T10/W5WVoltaje: DC 12VLa bombilla contiene 15 LED SMD 40142 AÑOS DE GARANTÍAPrecio por unidad

Precio 3,99 € Precio base 4,99 €
Más
En stock
Los productos más vendidos
  • Consulta a través de Whatsapp

Scirocco
luces led Volkswagen Scirocco

Scirocco

Luces LED VOLKSWAGEN SCIROCCO

Filtros activos

Referencia: LL034

Marca: Ledcar

LUZ CORTESIA PARASOLES LED VW / SKODA / SEAT

La solución para una perfecta iluminación la luz de cortesía de los parasoles .... con LED Modelos compatibles:VW: EOS (+2006),GOLF V (2004-2009), GOLF 6 (+2009), GOLF PLUS (+2005), JETTA (+2006), PASSAT (+2006), PASSAT CC (+2009), SCIROCCO (+2009), TIGUAN (+2008), POLO (+2005), TOURAN (+2011), SHARAN (+2011).SKODA: SUPERB (+2008)SEAT: ALHAMBRAEL KIT...

Precio 30,00 €
Más
En stock

Referencia: LL035

Marca: Ledcar

LUZ CORTESIA MALETERO VW / SEAT

La solución para una perfecta iluminación de su MALETERO .... con LED.La pieza tiene 18 LEDs SMD aportando 144 LUMENS.Modelos compatibles:VW:Caddy +2004, Eos +2006, Golf5, Golf6, Golf Plus +2005, Jetta/syncro +2006, Passat +2006, Passat cc +2009, Polo 5D 00-02, Scirocco +2009, Sharan +2011, Tiguan +2008, Touran +2003, Touareg +2003, Transporter...

Precio 16,99 €
Más
En stock

Referencia: 407

Marca: Ledcar

LED BAJO RETROVISORES VW (TIPO 1)

Luces LED para luz bajo retrovisores exterioresModelos compatibles:CC 2012~EOS 2009~2011Passat /4Motion/Santana 2011~Passat CC 2009~2012Scirocco 2009~ Compatible con ordenador abordo (Sin error en check control) Compatible con la conexión original / sin necesidad de adaptaciones  El juego incluye 2 piezas(Ref. LL066)

Precio 29,99 € Precio base 39,99 €
Más
En stock

Referencia: 351

Marca: Ledcar

LOGO VW LED BAJO PUERTA VOLKSWAGEN

Diseñados para instalar en la parte inferior de la puerta para proyectar el logotipo en el suelo cuando se abre la puerta.Válido para los modelos VOLKSWAGEN, con luz bajo puertas de serie:GOLF  2010-2016 (MK5-MK6-MK7)  Golf plus 2005-2007Jetta  2006-2014 (MK5-MK6-MK7)  Passat  +2012 (B6-B7)CC 2009-2016Sharan +2011Touareg 2011-2016EOS     +2006Scirocco...

Precio 19,98 € Precio base 39,97 €
Más
En stock

Referencia: 308

Marca: Ledcar

LUZ CORTESIA INTERIOR LED SEAT / AUDI / VW / SKODA

La solución para una perfecta iluminación de su interior, reposapiés, bajo puertas .... con LED Modelos compatibles:LamborghiniVW: Golf5/Golf6, Passat cc/Passat 5D/Passat R36, Campmob04/ Polo 02-09/ Caddy 04-09/E0S06-08, Jetta 06-08/Scirocco 09/Tiguan 08/ Touareg 03-09,Phaeton,Sharan, Transporter.Audi:A2/A3/S3/A4/...

Precio 9,99 €
Más
En stock

Referencia: 203

Marca: Ledcar

KIT LUZ DIURNA LED

Cambia la luz amarilla de la luz diurna de tu coche y pásate a la tecnología LED.Luz totalmente BLANCA.Sencilla instalación y SIN FALLO en check control.Kit formado por 2 bombillas LED aptas para casquillo P21W.KIT VÁLIDO PARA:AUDI Q7, SEAT LEÓN III, SEAT ALHAMBRA, SEAT TOLEDO, VW SCIROCCO, VW SHARAN, VW PASSAT B7, , LAGUNA 3, GRAND SCENIC, MEGANE 3 VARIA...

Precio 11,98 €
Más
En stock

Referencia: 53

Marca: Ledcar

P21W CANBUS BA15S 1156 18 LEDS

NO DA ERROR EN EL CHECK CONTROL DEL COCHE Conector: P21W BA15S 1156Leds: 18 LEDs SMD 5050 de alta intensidadVoltaje: 12VColor: BLANCOLumens: 540El precio indicado es por unidad IDEAL PARA LA COLOCACIÓN EN LUZ DIURNA, FRENO Y MARCHA ATRÁS.Válidas para luz diurna:AUDI Q7, SEAT LEÓN III, SEAT ALHAMBRA, SEAT TOLEDO, VW SCIROCCO, VW SHARAN, VW PASSAT B7,...

Precio 5,99 € Precio base 9,99 €
Más
En stock

Referencia: 29

Marca: Ledcar

led VW SCIROCCO (+2006) pack bombillas led

Contenido del PACK para VW Scirocco (+2006):- Luces de posición- Plafón interior delantero - Plafón interior trasero- Luces de matrícula- Luz de maletero - Luces de parasol -SIN ERROR EN CHECK CONTROL- Con este pack te ahorras un 10%Puedes ampliarlo si dispones de LUZ DIURNA:Nuestros productos CANBUS son compatibles con el 99% de los vehículos

Precio 16,34 € Precio base 18,15 €
Más
En stock

Síganos en Facebook

Load Time 1248 ms
Querying Time 260 ms
Queries 435
Memory Peak Usage 68.8 Mb
Included Files 1048 files - 19.56 Mb
PrestaShop Cache - Mb
Global vars 0.42 Mb
PrestaShop Version 1.7.8.7
PHP Version 7.4.33
MySQL Version 5.7.38-log
Memory Limit 128M
Max Execution Time 3000000s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 18 ms 18 ms 15.67 Mb 16.4 Mb
__construct 0 ms 18 ms - Mb 16.4 Mb
init 87 ms 105 ms 8.61 Mb 25.3 Mb
checkAccess 0 ms 105 ms - Mb 25.3 Mb
setMedia 8 ms 113 ms 0.74 Mb 25.3 Mb
postProcess 0 ms 113 ms - Mb 25.3 Mb
initHeader 0 ms 113 ms - Mb 25.3 Mb
initContent 900 ms 1013 ms 15.83 Mb 40.9 Mb
initFooter 0 ms 1013 ms - Mb 40.9 Mb
display 235 ms 1248 ms 27.27 Mb 68.8 Mb
Hook Time Memory Usage
displayLeftColumn 32 ms 0.78 Mb
displayNav2 24 ms 0.52 Mb
DisplayBeforeBodyClosingTag 21 ms 0.97 Mb
DisplayFooter 13 ms 0.97 Mb
displayTop 7 ms 0.15 Mb
DisplayHeader 7 ms 0.64 Mb
displayFooter 7 ms 0.19 Mb
displayNavFullWidth 5 ms 0.61 Mb
displayFooterAfter 5 ms 0.18 Mb
DisplayNav1 4 ms 0.15 Mb
Header 4 ms 0.36 Mb
ActionDispatcherBefore 3 ms - Mb
AngarFacebook 2 ms 0.09 Mb
ActionFrontControllerAfterInit 2 ms 0.01 Mb
ProductSearchProvider 2 ms 0.22 Mb
ActionFrontControllerSetMedia 1 ms 0.15 Mb
DisplayFooterAfter 1 ms 0.06 Mb
DisplayLeftColumn 1 ms - Mb
DisplayBanner 1 ms 0.06 Mb
Footer 1 ms 0.03 Mb
LeftColumn 0 ms 0.02 Mb
ActionObjectAddAfter 0 ms - Mb
22 hook(s) 144 ms 6.09 Mb
Module Time Memory Usage
progeo 16 ms 2.15 Mb
blockreassurance 4 ms 0.39 Mb
ps_emailsubscription 4 ms 0.29 Mb
blockwishlist 1 ms 0.06 Mb
ps_socialfollow 4 ms 0.17 Mb
ps_searchbar 2 ms 0.09 Mb
baabandonedcartreminder 5 ms 0.41 Mb
ps_imageslider 2 ms 0.20 Mb
eicaptcha 1 ms 0.09 Mb
bonsearch 1 ms 0.04 Mb
ps_googleanalytics 2 ms 0.22 Mb
medialoader 0 ms 0.03 Mb
angarfastconfig 3 ms 0.09 Mb
angarbanners 8 ms 0.27 Mb
angarcatproduct 1 ms 0.09 Mb
angarcmsdesc 1 ms 0.08 Mb
angarcmsinfo 1 ms 0.07 Mb
angarfacebook 3 ms 0.13 Mb
angarhomecat 1 ms 0.06 Mb
angarmanufacturer 1 ms 0.07 Mb
angarparallax 0 ms 0.06 Mb
angarslider 2 ms 0.27 Mb
angarscrolltop 1 ms 0.03 Mb
angarthemeconfigurator 11 ms 1.26 Mb
mailalerts 2 ms 0.22 Mb
emarketing 1 ms 0.10 Mb
ps_feeder 1 ms 0.03 Mb
correosexpress 9 ms 1.06 Mb
psxmarketingwithgoogle 2 ms 0.24 Mb
ps_shoppingcart 6 ms 0.14 Mb
showgooglemybusinessreviews 1 ms 0.10 Mb
paypal 11 ms 2.40 Mb
obsredsys 3 ms 0.42 Mb
uecookie 1 ms 0.14 Mb
whatsapp 4 ms 0.13 Mb
ps_facetedsearch 5 ms 0.57 Mb
angarcontact 7 ms 0.28 Mb
ps_customersignin 2 ms 0.10 Mb
ps_languageselector 8 ms 0.14 Mb
ps_currencyselector 14 ms 0.36 Mb
ps_mainmenu 9 ms 0.88 Mb
ps_categorytree 22 ms 0.50 Mb
ps_linklist 81 ms 20.29 Mb
angarbestsellers 9 ms 0.31 Mb
ps_customeraccountlinks 4 ms 0.14 Mb
statsdata 21 ms 0.97 Mb
shoppingfluxexport 6 ms 0.62 Mb
47 module(s) 301 ms 36.75 Mb

Stopwatch SQL - 435 queries

Query Time (ms) Rows Filesort Group By Location
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 `ledcar_configuration` c
LEFT JOIN `ledcar_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
10936 ms 21615 /classes/Configuration.php:160
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ledcar_product p LEFT JOIN ledcar_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ledcar_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ledcar_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ledcar_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ledcar_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ledcar_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ledcar_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ledcar_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=495 AND c.nright<=496 GROUP BY p.id_product) p INNER JOIN ledcar_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 12
8714 ms 1962576 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ledcar_category` c
INNER JOIN `ledcar_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `ledcar_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND nleft >= 2 AND nright <= 605
AND c.id_category IN (
SELECT id_category
FROM `ledcar_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
7612 ms 303 Yes /modules/ps_categorytree/ps_categorytree.php:166
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, cp.position FROM ledcar_product p LEFT JOIN ledcar_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ledcar_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ledcar_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ledcar_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ledcar_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ledcar_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ledcar_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ledcar_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=495 AND c.nright<=496 GROUP BY p.id_product) p
7272 ms 654192 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
INSERT INTO `ledcar_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')
5136 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ledcar_specific_price` WHERE `id_product` != 0
3942 ms 284 /classes/SpecificPrice.php:295
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ledcar_module` m
INNER JOIN ledcar_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 `ledcar_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `ledcar_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ledcar_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ledcar_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`
3748 ms 2540 Yes Yes /classes/Hook.php:1183
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ledcar_meta` m
LEFT JOIN `ledcar_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
3463 ms 780 Yes /classes/Dispatcher.php:643
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `ledcar_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1
3143 ms 80656 /classes/SpecificPrice.php:287
(SELECT SQL_NO_CACHE * FROM `ledcar_cart_rule` cr
LEFT JOIN `ledcar_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
2792 ms 1 /classes/CartRule.php:444
INSERT INTO `ledcar_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('1353969', '433', '65851226', '', '1', '1', '2023-04-02 08:31:50')
2546 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ledcar_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ledcar_hook_alias` ha
INNER JOIN `ledcar_hook` h ON ha.name = h.name
2133 ms 0 /classes/Hook.php:1243
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 `ledcar_hook_module` hm
STRAIGHT_JOIN `ledcar_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ledcar_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1918 ms 470 /classes/Hook.php:504
SELECT SQL_NO_CACHE `id_guest`
FROM `ledcar_connections`
WHERE `id_guest` = 1353969
AND `date_add` > '2023-04-02 08:01:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
1861 ms 1 Yes /classes/Connection.php:154
SELECT SQL_NO_CACHE 1 FROM ledcar_cart_product cp INNER JOIN ledcar_product p
ON (p.id_product = cp.id_product) INNER JOIN ledcar_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
1855 ms 1 /classes/Cart.php:4218
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
1681 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-04-02 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ledcar_product p
LEFT JOIN ledcar_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ledcar_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ledcar_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 29
LIMIT 1
1652 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE * FROM `ledcar_hook_module_exceptions`
WHERE `id_shop` IN (1)
1632 ms 1 /classes/module/Module.php:2237
SELECT SQL_NO_CACHE *
FROM `ledcar_currency_lang`
WHERE `id_currency` = 3
1619 ms 15 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE name, alias FROM `ledcar_hook_alias`
1608 ms 90 /classes/Hook.php:353
(SELECT 1 FROM `ledcar_cart_rule` WHERE date_to >= "2023-04-02 00:00:00" AND date_to <= "2023-04-02 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ledcar_cart_rule` WHERE date_from >= "2023-04-02 00:00:00" AND date_from <= "2023-04-02 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ledcar_cart_rule` WHERE date_from < "2023-04-02 00:00:00" AND date_to > "2023-04-02 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
1596 ms 1 /classes/CartRule.php:383
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ledcar_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 164 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-04-02 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-04-02 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1503 ms 8 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ledcar_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 203
ORDER BY `position`
1467 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-04-02 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ledcar_product p
LEFT JOIN ledcar_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ledcar_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ledcar_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 164
LIMIT 1
1455 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE lower(name) as name
FROM `ledcar_hook` h
WHERE (h.active = 1)
1358 ms 805 /classes/Hook.php:1283
(SELECT SQL_NO_CACHE * FROM `ledcar_cart_rule` cr
LEFT JOIN `ledcar_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
1358 ms 1 /classes/CartRule.php:444
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ledcar_module` m
LEFT JOIN `ledcar_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
1344 ms 127 /classes/module/Module.php:340
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a0
LEFT JOIN `ledcar_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 495) AND (a0.`nright` > 496) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
1260 ms 4242 Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
1258 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE *
FROM `ledcar_currency_lang`
WHERE `id_currency` = 4
1243 ms 15 /src/Adapter/EntityMapper.php:84
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 697 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 697 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
1223 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ledcar_category` c
INNER JOIN ledcar_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ledcar_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ledcar_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 136
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1207 ms 1 Yes Yes /classes/Category.php:919
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
1171 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
1162 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE *
FROM `ledcar_currency` c
INNER JOIN ledcar_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
1158 ms 6 Yes /classes/Currency.php:694
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ledcar_feature_product pf
LEFT JOIN ledcar_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ledcar_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ledcar_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ledcar_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 164
ORDER BY f.position ASC
1150 ms 34 Yes /classes/Product.php:5897
(SELECT 1 FROM `ledcar_cart_rule` WHERE date_to >= "2023-04-02 00:00:00" AND date_to <= "2023-04-02 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ledcar_cart_rule` WHERE date_from >= "2023-04-02 00:00:00" AND date_from <= "2023-04-02 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ledcar_cart_rule` WHERE date_from < "2023-04-02 00:00:00" AND date_to > "2023-04-02 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
1141 ms 1 /classes/CartRule.php:383
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ledcar_feature_product pf
LEFT JOIN ledcar_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ledcar_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ledcar_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ledcar_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 427
ORDER BY f.position ASC
1140 ms 16 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE * FROM ledcar_whatsapp WHERE id_whatsapp = 1 LIMIT 1
1127 ms 1 /modules/whatsapp/whatsapp.php:175
SELECT SQL_NO_CACHE p.*, product_shop.*, pl.*, image_shop.`id_image` id_image, il.`legend`, cl.`name` AS category_default, a.quantity AS pack_quantity, product_shop.`id_category_default`, a.id_product_pack, a.id_product_attribute_item
FROM `ledcar_pack` a
LEFT JOIN `ledcar_product` p ON p.id_product = a.id_product_item
LEFT JOIN `ledcar_product_lang` pl
ON p.id_product = pl.id_product
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
LEFT JOIN `ledcar_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 `ledcar_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
INNER JOIN ledcar_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ledcar_category_lang` cl
ON product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
WHERE product_shop.`id_shop` = 1
AND a.`id_product_pack` = 164
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
1102 ms 1 Yes /classes/Pack.php:350
SELECT SQL_NO_CACHE 1 FROM `ledcar_specific_price` WHERE id_product = 164 LIMIT 1
1083 ms 8 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module` WHERE `name` = "ps_categorytree" LIMIT 1
1063 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ledcar_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 29 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-04-02 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-04-02 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1045 ms 8 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ledcar_feature_product pf
LEFT JOIN ledcar_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ledcar_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ledcar_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ledcar_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 407
ORDER BY f.position ASC
977 ms 5 Yes /classes/Product.php:5897
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 53 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 53 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
964 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ledcar_currency` a
LEFT JOIN `ledcar_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 4) LIMIT 1
937 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 427) AND (b.`id_shop` = 1) LIMIT 1
927 ms 1 /src/Adapter/EntityMapper.php:76
(SELECT SQL_NO_CACHE * FROM `ledcar_cart_rule` cr
LEFT JOIN `ledcar_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
910 ms 1 /classes/CartRule.php:444
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ledcar_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 53 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-04-02 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-04-02 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
836 ms 8 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE `id_order`
FROM `ledcar_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
833 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ledcar_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 407 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-04-02 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-04-02 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
828 ms 8 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ledcar_hook`
824 ms 805 /classes/Hook.php:1243
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module` WHERE `name` = "ps_socialfollow" LIMIT 1
820 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
815 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE `name`
FROM `ledcar_hook`
WHERE `id_hook` = 821 LIMIT 1
812 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-04-02 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ledcar_product p
LEFT JOIN ledcar_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ledcar_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ledcar_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 53
LIMIT 1
811 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1
809 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COUNT(*) FROM `ledcar_pack` WHERE id_product_pack = 29 LIMIT 1
798 ms 5 /classes/Pack.php:89
SELECT SQL_NO_CACHE *
FROM `ledcar_group` a
LEFT JOIN `ledcar_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
790 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ledcar_feature_product pf
LEFT JOIN ledcar_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ledcar_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ledcar_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ledcar_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 29
ORDER BY f.position ASC
789 ms 2 Yes /classes/Product.php:5897
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 `ledcar_product_attribute` pa
INNER JOIN ledcar_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 `ledcar_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ledcar_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ledcar_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ledcar_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (465) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
777 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE p.*, product_shop.*, pl.*, image_shop.`id_image` id_image, il.`legend`, cl.`name` AS category_default, a.quantity AS pack_quantity, product_shop.`id_category_default`, a.id_product_pack, a.id_product_attribute_item
FROM `ledcar_pack` a
LEFT JOIN `ledcar_product` p ON p.id_product = a.id_product_item
LEFT JOIN `ledcar_product_lang` pl
ON p.id_product = pl.id_product
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
LEFT JOIN `ledcar_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 `ledcar_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
INNER JOIN ledcar_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ledcar_category_lang` cl
ON product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
WHERE product_shop.`id_shop` = 1
AND a.`id_product_pack` = 203
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
766 ms 1 Yes /classes/Pack.php:350
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module_shop` WHERE `id_module` = 8 AND `id_shop` = 1 LIMIT 1
744 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ledcar_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 697 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-04-02 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-04-02 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
735 ms 8 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-04-02 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ledcar_product p
LEFT JOIN ledcar_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ledcar_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ledcar_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 465
LIMIT 1
731 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ledcar_feature_product pf
LEFT JOIN ledcar_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ledcar_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ledcar_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ledcar_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 465
ORDER BY f.position ASC
729 ms 13 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE 1 FROM `ledcar_specific_price` WHERE `from` BETWEEN '2023-04-02 00:00:00' AND '2023-04-02 23:59:59' LIMIT 1
727 ms 1 /classes/SpecificPrice.php:362
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 `ledcar_product` p
INNER JOIN `ledcar_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ledcar_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` = 427)
722 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_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
714 ms 1 /src/Adapter/EntityMapper.php:76
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 407 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 407 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
710 ms 0 /classes/Cart.php:1429
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 18 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 18 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
706 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-04-02 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ledcar_product p
LEFT JOIN ledcar_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ledcar_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ledcar_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 351
LIMIT 1
705 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
701 ms 11 /modules/progeo/model/georule.php:35
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 427 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 427 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
700 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ledcar_shop_url su
LEFT JOIN ledcar_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.ledcar.es' OR su.domain_ssl = 'www.ledcar.es')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
699 ms 1 Yes /classes/shop/Shop.php:1350
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-04-02 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ledcar_product p
LEFT JOIN ledcar_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ledcar_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ledcar_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 407
LIMIT 1
698 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module` WHERE `name` = "ps_languageselector" LIMIT 1
692 ms 1 /classes/module/Module.php:2840
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 `ledcar_product` p
INNER JOIN `ledcar_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ledcar_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` = 164)
686 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 697) AND (b.`id_shop` = 1) LIMIT 1
683 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ledcar_lang` l
JOIN ledcar_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
682 ms 15 /classes/Language.php:1198
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ledcar_stock_available`
WHERE (id_product = 407) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
679 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
672 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE `id_order`
FROM `ledcar_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
671 ms 1 /classes/order/Order.php:1203
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 ledcar_shop_group gs
LEFT JOIN ledcar_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ledcar_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
660 ms 1 Yes /classes/shop/Shop.php:711
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
658 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-04-02 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ledcar_product p
LEFT JOIN ledcar_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ledcar_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ledcar_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 308
LIMIT 1
638 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE `id_order`
FROM `ledcar_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
634 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-04-02 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ledcar_product p
LEFT JOIN ledcar_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ledcar_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ledcar_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 203
LIMIT 1
620 ms 1 /classes/ProductAssembler.php:95
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 465 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 465 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
616 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ledcar_feature_product pf
LEFT JOIN ledcar_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ledcar_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ledcar_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ledcar_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 53
ORDER BY f.position ASC
615 ms 7 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `ledcar_product_lang`
WHERE `id_product` = 164 AND `id_shop` = 1
614 ms 15 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-04-02 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ledcar_product p
LEFT JOIN ledcar_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ledcar_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN ledcar_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 427
LIMIT 1
613 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ledcar_module` m
LEFT JOIN `ledcar_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
612 ms 127 /classes/module/Module.php:340
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ledcar_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 351 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-04-02 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-04-02 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
609 ms 8 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
606 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 164) LIMIT 1
598 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ledcar_feature_product pf
LEFT JOIN ledcar_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ledcar_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ledcar_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ledcar_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 203
ORDER BY f.position ASC
596 ms 9 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `ledcar_angarbanners`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
589 ms 45 Yes /modules/angarbanners/angarbanners.php:312
SELECT SQL_NO_CACHE tr.*
FROM `ledcar_tax_rule` tr
JOIN `ledcar_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 58
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
588 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
587 ms 11 /modules/progeo/model/georule.php:35
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 580 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 580 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
587 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ledcar_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 53
ORDER BY `position`
582 ms 7 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module_shop` WHERE `id_module` = 13 AND `id_shop` = 1 LIMIT 1
581 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE modified FROM ledcar_smarty_cache WHERE id_smarty_cache = "f43bdb5becdfd09b5b4dc0c194064c0d806d500e" LIMIT 1
576 ms 1 /classes/Smarty/SmartyCacheResourceMysql.php:72
SELECT SQL_NO_CACHE `id_country`
FROM `ledcar_country`
WHERE `iso_code` = 'US' LIMIT 1
571 ms 1 /classes/Country.php:193
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 `ledcar_product` p
INNER JOIN `ledcar_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ledcar_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` = 697)
570 ms 1 /classes/Product.php:3820
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 `ledcar_product_attribute` pa
INNER JOIN ledcar_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 `ledcar_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ledcar_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ledcar_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ledcar_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (308) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
567 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ledcar_layered_category
WHERE controller = 'category'
AND id_category = 136
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
566 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
562 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 369) AND (b.`id_shop` = 1) LIMIT 1
554 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 164
AND image_shop.`cover` = 1 LIMIT 1
551 ms 3 /classes/Product.php:3533
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 `ledcar_product_attribute` pa
INNER JOIN ledcar_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 `ledcar_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ledcar_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ledcar_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ledcar_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (427) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
543 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 308) AND (b.`id_shop` = 1) LIMIT 1
539 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 164) AND (b.`id_shop` = 1) LIMIT 1
538 ms 1 /src/Adapter/EntityMapper.php:76
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 `ledcar_product_attribute` pa
INNER JOIN ledcar_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 `ledcar_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ledcar_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ledcar_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ledcar_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (29) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
536 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 5
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1
533 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_group_lang`
WHERE `id_group` = 1
533 ms 15 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ledcar_stock_available`
WHERE (id_product = 427) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
532 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
529 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE *
FROM `ledcar_currency` a
LEFT JOIN `ledcar_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ledcar_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
529 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 8
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1
525 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ledcar_feature_product pf
LEFT JOIN ledcar_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ledcar_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ledcar_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ledcar_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 308
ORDER BY f.position ASC
522 ms 21 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 29) AND (b.`id_shop` = 1) LIMIT 1
521 ms 1 /src/Adapter/EntityMapper.php:76
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 `ledcar_product_attribute` pa
INNER JOIN ledcar_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 `ledcar_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ledcar_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ledcar_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ledcar_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (203) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
521 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE modified FROM ledcar_smarty_cache WHERE id_smarty_cache = "ddf05ef8edcee1b131e5d14ef3cc5b01955abbf3" LIMIT 1
521 ms 0 /classes/Smarty/SmartyCacheResourceMysql.php:72
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 203) AND (b.`id_shop` = 1) LIMIT 1
520 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ledcar_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 465
ORDER BY `position`
519 ms 3 Yes /classes/Product.php:3508
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 `ledcar_product_attribute` pa
INNER JOIN ledcar_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 `ledcar_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ledcar_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ledcar_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ledcar_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (164) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
519 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE * FROM `ledcar_currency` c ORDER BY `iso_code` ASC
518 ms 6 Yes /classes/Currency.php:709
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 29) LIMIT 1
517 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * FROM `ledcar_image_type` WHERE 1 AND `categories` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
515 ms 8 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 839) AND (b.`id_shop` = 1) LIMIT 1
514 ms 1 /src/Adapter/EntityMapper.php:76
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 697 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 697 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
512 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ledcar_lang` l
LEFT JOIN `ledcar_lang_shop` ls ON (l.id_lang = ls.id_lang)
510 ms 15 /classes/Language.php:1049
SELECT SQL_NO_CACHE *
FROM `ledcar_country` a
LEFT JOIN `ledcar_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
510 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_currency` a
LEFT JOIN `ledcar_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ledcar_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 5) LIMIT 1
506 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
505 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module` WHERE `name` = "ps_searchbar" LIMIT 1
504 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE name FROM ledcar_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 135 LIMIT 1
504 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `name`, `alias` FROM `ledcar_hook_alias`
502 ms 90 /classes/Hook.php:301
SELECT SQL_NO_CACHE `id_page`
FROM `ledcar_page`
WHERE `id_page_type` = 3 AND `id_object` = 136 LIMIT 1
502 ms 2 /classes/Page.php:83
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module_shop` WHERE `id_module` = 25 AND `id_shop` = 1 LIMIT 1
502 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1
500 ms 1 /classes/module/Module.php:2328
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 53 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 53 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
500 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ledcar_currency` a
LEFT JOIN `ledcar_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
499 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 458) AND (b.`id_shop` = 1) LIMIT 1
499 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_currency` a
LEFT JOIN `ledcar_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
498 ms 1 /src/Adapter/EntityMapper.php:76
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 `ledcar_product_attribute` pa
INNER JOIN ledcar_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 `ledcar_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ledcar_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ledcar_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ledcar_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (407) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
498 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ledcar_category_group ctg
WHERE ctg.`id_category` = 136 AND ctg.`id_group` = 1 LIMIT 1
497 ms 1 /classes/Category.php:1730
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 `ledcar_product_attribute` pa
INNER JOIN ledcar_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 `ledcar_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ledcar_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ledcar_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ledcar_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (53) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
496 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ledcar_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 29
ORDER BY `position`
496 ms 6 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
494 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 366) AND (b.`id_shop` = 1) LIMIT 1
494 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ledcar_layered_category
WHERE controller = 'category'
AND id_category = 136
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
492 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
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 `ledcar_product_attribute` pa
INNER JOIN ledcar_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 `ledcar_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ledcar_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ledcar_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ledcar_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (351) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
490 ms 2 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 407) AND (b.`id_shop` = 1) LIMIT 1
489 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ledcar_stock_available`
WHERE (id_product = 203) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
487 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE format
FROM `ledcar_address_format`
WHERE `id_country` = 6 LIMIT 1
486 ms 1 /classes/AddressFormat.php:672
SELECT SQL_NO_CACHE *
FROM `ledcar_country` a
LEFT JOIN `ledcar_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ledcar_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
485 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1
485 ms 1 /src/Adapter/EntityMapper.php:76
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 351 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 351 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
481 ms 0 /classes/Cart.php:1429
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 308 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 308 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
480 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ledcar_currency` a
LEFT JOIN `ledcar_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 5) LIMIT 1
479 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_currency_lang`
WHERE `id_currency` = 5
478 ms 15 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module` WHERE `name` = "ps_currencyselector" LIMIT 1
477 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ledcar_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 164
ORDER BY `position`
475 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ledcar_stock_available`
WHERE (id_product = 839) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
475 ms 1 /classes/stock/StockAvailable.php:453
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 458 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 458 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
467 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 53) AND (b.`id_shop` = 1) LIMIT 1
467 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 465) AND (b.`id_shop` = 1) LIMIT 1
465 ms 1 /src/Adapter/EntityMapper.php:76
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 840 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 840 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
464 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ledcar_product_attribute`
WHERE `id_product` = 203
460 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE value FROM `ledcar_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
460 ms 1 /classes/shop/Shop.php:1171
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 840) AND (b.`id_shop` = 1) LIMIT 1
459 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_currency` a
LEFT JOIN `ledcar_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ledcar_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 3) LIMIT 1
458 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 368) AND (b.`id_shop` = 1) LIMIT 1
458 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ledcar_feature_product pf
LEFT JOIN ledcar_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ledcar_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ledcar_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ledcar_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 351
ORDER BY f.position ASC
453 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 351) AND (b.`id_shop` = 1) LIMIT 1
451 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_angarbanners`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'left' AND active = 1
ORDER BY item_order ASC
449 ms 45 Yes /modules/angarbanners/angarbanners.php:312
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
446 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE *
FROM `ledcar_currency` a
LEFT JOIN `ledcar_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 3) LIMIT 1
446 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE modified, content FROM ledcar_smarty_cache WHERE id_smarty_cache = "5c99a8d783be2f042bcce56de94e46cbe59c7e0a" LIMIT 1
446 ms 1 /classes/Smarty/SmartyCacheResourceMysql.php:48
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ledcar_product_attribute pa
INNER JOIN ledcar_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 53 LIMIT 1
446 ms 1 /classes/Product.php:1037
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 839 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 839 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
444 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ledcar_country_lang`
WHERE `id_country` = 6
443 ms 15 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
443 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE depends_on_stock
FROM `ledcar_stock_available`
WHERE (id_product = 580) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
438 ms 1 /classes/stock/StockAvailable.php:744
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module` WHERE `name` = "ps_mainmenu" LIMIT 1
435 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE id_product_item, id_product_attribute_item, quantity FROM `ledcar_pack` where id_product_pack = 29
434 ms 5 /classes/Pack.php:164
SELECT SQL_NO_CACHE *
FROM `ledcar_manufacturer` a
LEFT JOIN `ledcar_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `ledcar_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 1) LIMIT 1
433 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ledcar_specific_price_priority`
WHERE `id_product` = 164
ORDER BY `id_specific_price_priority` DESC LIMIT 1
432 ms 1 /classes/SpecificPrice.php:250
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ledcar_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 134 LIMIT 1
432 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 6
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1
430 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE modified FROM ledcar_smarty_cache WHERE id_smarty_cache = "23c9d8f76572620303d7f2ae56ac0f66b9a69dd1" LIMIT 1
430 ms 1 /classes/Smarty/SmartyCacheResourceMysql.php:72
SELECT SQL_NO_CACHE *
FROM `ledcar_currency_lang`
WHERE `id_currency` = 2
427 ms 15 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE modified FROM ledcar_smarty_cache WHERE id_smarty_cache = "410b75b6eed89a2d84375b62cded3ab23988547a" LIMIT 1
425 ms 1 /classes/Smarty/SmartyCacheResourceMysql.php:72
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ledcar_product_attribute pa
INNER JOIN ledcar_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 697 LIMIT 1
425 ms 1 /classes/Product.php:1037
SELECT SQL_NO_CACHE `reduction`
FROM `ledcar_product_group_reduction_cache`
WHERE `id_product` = 203 AND `id_group` = 1 LIMIT 1
424 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE name FROM ledcar_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 372 LIMIT 1
423 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 203) LIMIT 1
419 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_country_lang`
WHERE `id_country` = 21
418 ms 15 /src/Adapter/EntityMapper.php:84
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ledcar_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 53 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ledcar_cart_product` cp JOIN `ledcar_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ledcar_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` = 53 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
418 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
416 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_lang` FROM `ledcar_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
414 ms 15 /classes/Language.php:853
SELECT SQL_NO_CACHE *
FROM `ledcar_angarbanners`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'header' AND active = 1
ORDER BY item_order ASC
413 ms 45 Yes /modules/angarbanners/angarbanners.php:312
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ledcar_stock_available`
WHERE (id_product = 465) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
413 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ledcar_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 308
ORDER BY `position`
412 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE modified, content FROM ledcar_smarty_cache WHERE id_smarty_cache = "410b75b6eed89a2d84375b62cded3ab23988547a" LIMIT 1
411 ms 1 /classes/Smarty/SmartyCacheResourceMysql.php:48
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ledcar_specific_price_priority`
WHERE `id_product` = 407
ORDER BY `id_specific_price_priority` DESC LIMIT 1
410 ms 0 /classes/SpecificPrice.php:250
SELECT SQL_NO_CACHE *
FROM `ledcar_currency_lang`
WHERE `id_currency` = 1
406 ms 15 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
401 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE COUNT(*) FROM `ledcar_pack` WHERE id_product_pack = 580 LIMIT 1
398 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 465
AND image_shop.`cover` = 1 LIMIT 1
396 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE `id_lang` FROM `ledcar_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
396 ms 15 /classes/Language.php:853
SELECT SQL_NO_CACHE *
FROM `ledcar_state` a
WHERE (a.`id_state` = 374) LIMIT 1
396 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
395 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ledcar_required_field
392 ms 1 /classes/ObjectModel.php:1510
SELECT SQL_NO_CACHE modified, content FROM ledcar_smarty_cache WHERE id_smarty_cache = "23c9d8f76572620303d7f2ae56ac0f66b9a69dd1" LIMIT 1
392 ms 1 /classes/Smarty/SmartyCacheResourceMysql.php:48
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 407
AND image_shop.`cover` = 1 LIMIT 1
390 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE c.id_currency
FROM `ledcar_currency` c
WHERE (iso_code = 'PLN') LIMIT 1
390 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE * FROM ledcar_whatsapp WHERE id_whatsapp = 1 LIMIT 1
389 ms 1 /modules/whatsapp/whatsapp.php:146
SELECT SQL_NO_CACHE `id_lang` FROM `ledcar_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
389 ms 15 /classes/Language.php:853
SELECT SQL_NO_CACHE `name`
FROM `ledcar_hook`
WHERE `id_hook` = 796 LIMIT 1
389 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE 1 FROM `ledcar_specific_price` WHERE id_product = 0 LIMIT 1
388 ms 1 /classes/SpecificPrice.php:411
SELECT SQL_NO_CACHE id_shop
FROM `ledcar_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
387 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE *
FROM `ledcar_lang` a
LEFT JOIN `ledcar_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
387 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_product_lang`
WHERE `id_product` = 203 AND `id_shop` = 1
384 ms 15 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `ledcar_currency` a
LEFT JOIN `ledcar_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ledcar_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 4) LIMIT 1
384 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_order`
FROM `ledcar_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
382 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
382 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE *
FROM `ledcar_product` a
LEFT JOIN `ledcar_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ledcar_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 580) AND (b.`id_shop` = 1) LIMIT 1
381 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_category_lang`
WHERE `id_category` = 136 AND `id_shop` = 1
381 ms 15 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
379 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_order`
FROM `ledcar_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
379 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_country`
FROM `ledcar_country`
WHERE `iso_code` = 'US' LIMIT 1
379 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
376 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) LIMIT 1
374 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE modified, content FROM ledcar_smarty_cache WHERE id_smarty_cache = "f43bdb5becdfd09b5b4dc0c194064c0d806d500e" LIMIT 1
373 ms 1 /classes/Smarty/SmartyCacheResourceMysql.php:48
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ledcar_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 351
ORDER BY `position`
370 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE COUNT(*) FROM `ledcar_pack` WHERE id_product_pack = 18 LIMIT 1
368 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
366 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ledcar_currency` c
LEFT JOIN ledcar_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
365 ms 6 /classes/Currency.php:1126
SELECT SQL_NO_CACHE 1 FROM `ledcar_specific_price` WHERE id_product = 407 LIMIT 1
364 ms 8 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE *
FROM `ledcar_country` a
LEFT JOIN `ledcar_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
364 ms 1 /src/Adapter/EntityMapper.php:76
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 `ledcar_product` p
INNER JOIN `ledcar_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ledcar_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` = 465)
363 ms 1 /classes/Product.php:3820
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 `ledcar_product` p
INNER JOIN `ledcar_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ledcar_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` = 29)
363 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ledcar_product_attribute`
WHERE `id_product` = 308
356 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module_shop` WHERE `id_module` = 15 AND `id_shop` = 1 LIMIT 1
356 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE modified, content FROM ledcar_smarty_cache WHERE id_smarty_cache = "c33be0aa794d81c15fe43372bbaf051efb40b00c" LIMIT 1
356 ms 1 /classes/Smarty/SmartyCacheResourceMysql.php:48
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ledcar_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 135 LIMIT 1
355 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 9
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1
352 ms 1 /src/Adapter/EntityMapper.php:76
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 `ledcar_product` p
INNER JOIN `ledcar_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ledcar_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` = 308)
351 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE c.id_currency
FROM `ledcar_currency` c
WHERE (iso_code = 'HUF') LIMIT 1
350 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE id_shop
FROM `ledcar_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
343 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE `iso_code`
FROM `ledcar_country`
WHERE `id_country` = 6 LIMIT 1
343 ms 1 /classes/Country.php:274
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 `ledcar_product` p
INNER JOIN `ledcar_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ledcar_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` = 407)
342 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE `id_lang` FROM `ledcar_lang` WHERE `iso_code` = 'es' LIMIT 1
340 ms 15 /classes/Language.php:824
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
340 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 367) AND (b.`id_shop` = 1) LIMIT 1
339 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ledcar_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 427
ORDER BY `position`
337 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_lang` FROM `ledcar_lang`
WHERE `locale` = 'es-es'
OR `language_code` = 'es-es' LIMIT 1
336 ms 15 /classes/Language.php:853
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 `ledcar_product` p
INNER JOIN `ledcar_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ledcar_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` = 203)
335 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ledcar_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 407
ORDER BY `position`
335 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ledcar_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
334 ms 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 15
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1
334 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ledcar_currency` a
LEFT JOIN `ledcar_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ledcar_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
333 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 29
AND image_shop.`cover` = 1 LIMIT 1
333 ms 6 /classes/Product.php:3533
SELECT SQL_NO_CACHE *
FROM `ledcar_product_lang`
WHERE `id_product` = 29 AND `id_shop` = 1
331 ms 15 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ledcar_product_attribute`
WHERE `id_product` = 53
330 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ledcar_image` i
INNER JOIN ledcar_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 351
AND image_shop.`cover` = 1 LIMIT 1
329 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE `id_order`
FROM `ledcar_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
329 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE modified, content FROM ledcar_smarty_cache WHERE id_smarty_cache = "4cf6e7d23d27240ca25054200f7ced5e997296b3" LIMIT 1
325 ms 1 /classes/Smarty/SmartyCacheResourceMysql.php:48
SELECT SQL_NO_CACHE id_page_type
FROM ledcar_page_type
WHERE name = 'category' LIMIT 1
323 ms 1 /classes/Page.php:104
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 `ledcar_product` p
INNER JOIN `ledcar_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ledcar_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` = 351)
316 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ledcar_country`
WHERE `id_country` = 6 LIMIT 1
316 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE modified FROM ledcar_smarty_cache WHERE id_smarty_cache = "9bc7636003a4885fd71193c31bf5cb99629f7bd6" LIMIT 1
316 ms 0 /classes/Smarty/SmartyCacheResourceMysql.php:72
SELECT SQL_NO_CACHE * FROM ledcar_whatsapp WHERE id_whatsapp = 1 LIMIT 1
312 ms 1 /modules/whatsapp/whatsapp.php:182
SELECT SQL_NO_CACHE COUNT(*) FROM `ledcar_pack` WHERE id_product_pack = 427 LIMIT 1
311 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE `id_module` FROM `ledcar_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
307 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 12
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1
306 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE g.* FROM `ledcar_georule` g 
INNER JOIN `ledcar_country` c ON (g.`id_country` = c.`id_country`)
WHERE g.active = 1 AND c.iso_code = "US" AND g.id_shop = 1 LIMIT 1
306 ms 11 /modules/progeo/model/georule.php:35
SELECT SQL_NO_CACHE *
FROM `ledcar_category` a
LEFT JOIN `ledcar_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 10
LEFT JOIN `ledcar_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1
306 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `reduction`
FROM `ledcar_product_group_reduction_cache`
WHERE `id_product` = 427 AND `id_group` = 1 LIMIT 1
306 ms 0 /classes/GroupReduction.php:156
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 `ledcar_product` p
INNER JOIN `ledcar_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ledcar_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` = 53)
303 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE `id_order`
FROM `ledcar_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
302 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE c.id_currency
FROM `ledcar_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
301 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE modified FROM ledcar_smarty_cache WHERE id_smarty_cache = "4cf6e7d23d27240ca25054200f7ced5e997296b3" LIMIT 1
300 ms 1 /classes/Smarty/SmartyCacheResourceMysql.php:72