Vaso de agua Glass Family

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

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m

SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1

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, 13714) 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 `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 111
AND `active` = 1 LIMIT 1

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` = 13714)

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` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 14110) AND (b.`id_shop` = 1) LIMIT 1

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

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

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

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 233) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE v.*,vl.content,vs.id_shop FROM `ps_vccontentanywhere` v 
INNER JOIN `ps_vccontentanywhere_lang` vl ON (v.`id_vccontentanywhere` = vl.`id_vccontentanywhere` AND vl.`id_lang` = 4)
INNER JOIN `ps_vccontentanywhere_shop` vs ON (v.`id_vccontentanywhere` = vs.`id_vccontentanywhere` AND vs.`id_shop` = 1 AND v.`active` = 1)
WHERE v.`hook_name` = "displayBanner" AND v.`active` = 1 AND ( ( v.`exception_type` = 1 AND v.`exception` LIKE "%product%") OR ( v.`exception_type` != 1 AND v.`display_type`= 1 ) OR ( v.`exception_type` != 1 AND v.`display_type` = 0  AND v.`prd_page` = 1 ) ) UNION
SELECT v_1.*,vl_1.content,vs_1.id_shop FROM `ps_vccontentanywhere` v_1
INNER JOIN `ps_vccontentanywhere_lang` vl_1 ON (v_1.`id_vccontentanywhere` = vl_1.`id_vccontentanywhere` AND vl_1.`id_lang` = 4)
INNER JOIN `ps_vccontentanywhere_shop` vs_1 ON (v_1.`id_vccontentanywhere` = vs_1.`id_vccontentanywhere` AND vs_1.`id_shop` = 1 AND v_1.`active` = 1) INNER JOIN `ps_vccontentanywhere_filter` vs_f_1 ON (vs_f_1.`id_vccontentanywhere` = v_1.`id_vccontentanywhere` ) WHERE v_1.`hook_name` = "displayBanner" AND v_1.active = 1 AND v_1.`exception_type` != 1 AND (vs_f_1.page = 1 AND vs_f_1.id_specify_page = 13972) ORDER BY `position` ASC

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

SELECT SQL_NO_CACHE * from `ps_auction_details`
WHERE id_product=14241 AND `deleted` = 0 AND `auction_status` = 2
AND `purchase_status` = 0 AND `winner_timeleft` = 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` = 4)
WHERE pe.`id_shop` = 1 
AND pe.`active` = 1 AND (pe.`date_from` <= "2026-04-30 18:39:54" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2026-04-30 18:39:54" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC

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

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 p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-04-30 00:00:00",
INTERVAL 30 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
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_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 4 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 4 AND pl.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` = 4)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 233 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,100

SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 233 LIMIT 1

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-04-30 00:00:00",
INTERVAL 30 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
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_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 4 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 4 AND pl.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` = 4)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 233 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,100

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` = 4)
WHERE pe.`id_shop` = 1 
AND pe.`active` = 1 AND (pe.`date_from` <= "2026-04-30 18:39:53" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2026-04-30 18:39:53" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC

SELECT SQL_NO_CACHE * from`ps_auction_details`
WHERE id_product=14229 AND `deleted` = 0 AND auction_status = 1 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`=13972

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

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` = 4)
WHERE pe.`id_shop` = 1 
AND pe.`active` = 1 AND (pe.`date_from` <= "2026-04-30 18:39:51" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2026-04-30 18:39:51" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC

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 *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 14219 AND il.`id_lang` = 4
ORDER BY i.`position` ASC

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` = 4)
WHERE pe.`id_shop` = 1 
AND pe.`active` = 1 AND (pe.`date_from` <= "2026-04-30 18:39:54" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2026-04-30 18:39:54" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 40 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pagesnotfound" LIMIT 1

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2026-04-30 00:00:00' AND '2026-04-30 23:59:59' LIMIT 1

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

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

SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 13972 AND ctg.`id_group` = 1 LIMIT 1

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

SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 97 LIMIT 1

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

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "smartshortcode" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockuserinfo" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "emailverificationopc" LIMIT 1

SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` 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)
WHERE pl.id_lang = 4
AND pl.id_product = 13972
AND product_shop.active = 1 LIMIT 1

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

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_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 = 14026 LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "socialsharing" LIMIT 1

SELECT SQL_NO_CACHE `hook_name`, count(`id_vccontentanywhere`) as contentCount   FROM `ps_vccontentanywhere` GROUP BY `hook_name`

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-04-30 00:00:00",
INTERVAL 30 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
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_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 4 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 4 AND pl.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` = 4)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 233 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,100

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcart" LIMIT 1

SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1

SELECT SQL_NO_CACHE * from `ps_auction_details`
WHERE id_product=13982 AND `deleted` = 0 AND `auction_status` = 2
AND `purchase_status` = 0 AND `winner_timeleft` = 1 AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ffe778189cfd9353cc609de504b9ef10' AND cache_id="ybc_newsletter|header|1|1|1|4|6" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 528 LIMIT 1