Recambio boligrafo q-connect tipo cross negro

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.`out_of_stock` out_of_stock, pl.`description`, pl.`description_short`,
pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
p.`ean13`, p.`upc`, MAX(image_shop.`id_image`) id_image, il.`legend`,
DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
INTERVAL 30
DAY)) > 0 AS new
FROM `ps_product` p
INNER JOIN `ps_product_tag` PT ON PT.`id_product` = p.`id_product`
INNER JOIN `ps_tag` T ON T.`id_tag` = PT.`id_tag`
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  ) WHERE (T.`name` = '')
AND PT.`id_product` != 21748 AND p.`active` = 1
AND T.`id_lang` = 1
GROUP BY PT.`id_product`, product_shop.`id_product`
LIMIT 10

SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_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 `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") 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`

UPDATE `ps_smarty_lazy_cache`
SET filepath='jscomposer/1/1/1/1/6/vcccproductdisplayBanner21748/e7/11/72/e71172b41044d50cf94f07816a33b3b710036146.jscomposer.tpl.php'
WHERE `template_hash`='3fac6ebc7e913869e87461594de51402' AND cache_id="jscomposer|1|1|1|1|6" AND compile_id="vcccproductdisplayBanner21748"

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea85959610329cefe74e0f17c5758d6d',"jscomposer|1|1|1|1|6","vcprdtb_21748", FROM_UNIXTIME(1777567286))

UPDATE `ps_smarty_lazy_cache`
SET filepath='jscomposer/1/1/1/1/6/vcprdtb_21748/0e/f2/1a/0ef21ae6e6c6704834396a15f4b0b654f41731d8.vc_prd_tab_title.tpl.php'
WHERE `template_hash`='ea85959610329cefe74e0f17c5758d6d' AND cache_id="jscomposer|1|1|1|1|6" AND compile_id="vcprdtb_21748"

UPDATE `ps_smarty_lazy_cache`
SET filepath='jscomposer/1/1/1/1/6/vcccproductdisplayFooterTop21748/e7/11/72/e71172b41044d50cf94f07816a33b3b710036146.jscomposer.tpl.php'
WHERE `template_hash`='3fac6ebc7e913869e87461594de51402' AND cache_id="jscomposer|1|1|1|1|6" AND compile_id="vcccproductdisplayFooterTop21748"

SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 21748
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2026-04-30 00:00:00",
INTERVAL 30 DAY
)
) > 0

UPDATE `ps_smarty_lazy_cache`
SET filepath='socialsharing/21748/1/1/1/1/6/79/bc/1c/79bc1cbf773d8b816b5b961997b5e57494693b4d.socialsharing.tpl.php'
WHERE `template_hash`='a5aa96589d70b69e9f91505aa16b5cd1' AND cache_id="socialsharing|21748|1|1|1|1|6" AND compile_id=""

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('442c43b495928957093dd90056967d5e',"jscomposer|1|1|1|1|6","prdtabcontent_21748", FROM_UNIXTIME(1777567286))

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 22266) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 22206 AND il.`id_lang` = 1
ORDER BY i.`position` ASC

SELECT SQL_NO_CACHE COUNT(`id_module`) FROM ps_module_shop
WHERE enable_device & 1 AND id_module=72 AND id_shop IN (1) LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='productscategory/21748/74/1/1/1/1/6/9e/81/98/9e819830fad02719e92c4645761393914265084a.productscategory.tpl.php'
WHERE `template_hash`='b16634a50ddb6030f6924c6a20c8ed9f' AND cache_id="productscategory|21748|74|1|1|1|1|6" AND compile_id=""

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 20751
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21670) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE pe.*, pel.* FROM `ps_messagesanywhere_configuration` pe 
LEFT JOIN `ps_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 1)
WHERE pe.`id_shop` = 1 
AND pe.`active` = 1 AND (pe.`date_from` <= "2026-04-30 18:41:25" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2026-04-30 18:41:25" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC

SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 21748) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a5aa96589d70b69e9f91505aa16b5cd1',"socialsharing|21748|1|1|1|1|6","", FROM_UNIXTIME(1777567287))

SELECT SQL_NO_CACHE pe.*, pel.* FROM `ps_messagesanywhere_configuration` pe 
LEFT JOIN `ps_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 1)
WHERE pe.`id_shop` = 1 
AND pe.`active` = 1 AND (pe.`date_from` <= "2026-04-30 18:41:27" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2026-04-30 18:41:27" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC

SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 21748
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2026-04-30 00:00:00",
INTERVAL 30 DAY
)
) > 0

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 570) AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-04-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-04-30 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE `file_name`, `subdir` FROM ps_vc_media WHERE id_vc_media=734

SELECT SQL_NO_CACHE * from`ps_auction_details`
WHERE id_product=22677 AND `deleted` = 0 AND auction_status = 1 AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE pe.*, pel.* FROM `ps_messagesanywhere_configuration` pe 
LEFT JOIN `ps_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 1)
WHERE pe.`id_shop` = 1 
AND pe.`active` = 1 AND (pe.`date_from` <= "2026-04-30 18:41:25" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2026-04-30 18:41:25" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC

SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 21748
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2026-04-30 00:00:00",
INTERVAL 30 DAY
)
) > 0

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
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_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` = 574)

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 973) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 21748

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3fac6ebc7e913869e87461594de51402',"jscomposer|1|1|1|1|6","vcccproductdisplayFooterTop21748", FROM_UNIXTIME(1777567288))

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 20443 AND `id_group` = 1 LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3834d8f849b027f9d4c256ad365eb295',"https://www.lacapell.com/ca/recanvis/recambio-boligrafo-q-connect-tipo-cross-negro-5706002217426-21748.html|1|1|1|1|6","", FROM_UNIXTIME(1777567284))

SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position

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 `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e45a0cd89590c63a0a6c8353360cc68c' AND cache_id="" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2026-04-30 00:00:00",
INTERVAL 30 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_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 `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 21748 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 971 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=21748

SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 21748
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2026-04-30 00:00:00",
INTERVAL 30 DAY
)
) > 0