Liste de produits par fabricant PROCOMEDIC

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 `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.`id_product_attribute`,0) id_product_attribute
, 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,
DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2025-01-24 00:00:00",
INTERVAL 90 DAY
)
) > 0 AS new 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 (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_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 (m.`id_manufacturer` = p.`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  )JOIN `ps_category_product` cp ON (p.id_product = cp.id_product)JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category` AND cg.`id_group` = 1)JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE p.`id_manufacturer` = 6
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY p.id_product
ORDER BY pl.`name` asc
LIMIT 0,12

SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)

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_manufacturer = 6 AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND EXISTS (
SELECT 1
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) INNER JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE p.`id_product` = cp.`id_product` AND cg.`id_group` = 1
)

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='52a017a5d1c3aeb2561790ab927e3c9e' AND cache_id="blockcategories|1|1|1|21|1" AND compile_id="" LIMIT 1

INSERT INTO `ps_blockips_pages`(ip, id_shop, page, user_agent) VALUES('18.97.9.174', '1', 'https://www.latabledexamen.com/6_procomedic', 'CCBot/2.0 (https://commoncrawl.org/faq/)')

SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =1 AND m.page = "manufacturer" LIMIT 1

SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1

SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`
FROM `ps_manufacturer_lang` ml
LEFT JOIN `ps_manufacturer` m ON (ml.`id_manufacturer` = m.`id_manufacturer`)
WHERE ml.id_lang = 1
AND ml.id_manufacturer = 6 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 6) LIMIT 1

SELECT SQL_NO_CACHE id_shop
FROM `ps_manufacturer_shop`
WHERE `id_manufacturer` = 6
AND id_shop = 1 LIMIT 1

INSERT INTO `ps_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', '', '0')

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('6255e1a65eec35b85b477c3adec3a25b',"blocktopmenu|1|1|1|21|manufacturer|6","", FROM_UNIXTIME(1737741603))

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='6255e1a65eec35b85b477c3adec3a25b' AND cache_id="blocktopmenu|1|1|1|21|manufacturer|6" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 9 AND `id_object` = 6 LIMIT 1

SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 20373
AND `date_add` > '2025-01-24 18:30:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1

SELECT SQL_NO_CACHE * FROM `ps_blockips` WHERE ip = '18.97.9.174' AND id_shop = '1' LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='blocktopmenu/1/1/1/21/manufacturer/6/59/ca/9b/59ca9b071831744ee6cdc2463b005e188e07f580.blocktopmenu.tpl.php'
WHERE `template_hash`='6255e1a65eec35b85b477c3adec3a25b' AND cache_id="blocktopmenu|1|1|1|21|manufacturer|6" AND compile_id=""

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='655c99e0b6adbbe521a70b0c20475a1b' AND cache_id="blocksearch-top|1|1|1|21" AND compile_id="" LIMIT 1

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

UPDATE `ps_blockips` SET last_date = '2025-01-24 19:00:03', nbr_pages = nbr_pages+1, id_customer = '', id_guest = '' WHERE ip = '18.97.9.174' AND id_shop = '1'

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='68098216fdb7248b7f27f630a67611eb' AND cache_id="blockbanner|1|1|1|21" AND compile_id="" LIMIT 1

INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('20373', '544', '308349358', '', '1', '1', '2025-01-24 19:00:04')

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='6598b4b77b80ac12ec33455508725188' AND cache_id="blockmyaccountfooter|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ae4ad706089da68e971763e786de0de3' AND cache_id="blockcms|2|1|1|1|21" AND compile_id="" LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('6255e1a65eec35b85b477c3adec3a25b',"blocktopmenu|1|1|1|21|manufacturer|6","", FROM_UNIXTIME(1737741603))

SELECT SQL_NO_CACHE id_address_delivery
FROM `ps_cart`
WHERE (id_cart="0") LIMIT 1

SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'manufacturer' LIMIT 1