Vente de Tables d'examen médicales et Tables de soins professionnelles

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 DISTINCT(nl.`id_prestablog_news`), n.*, nl.*,
LEFT(nl.`title`, 80) as title,
(
SELECT count(cn.`id_prestablog_commentnews`)
FROM `ps_prestablog_commentnews` cn
WHERE cn.`news` = n.`id_prestablog_news`
AND cn.`actif` = 1
) as count_comments,
n.`id_prestablog_news` as `id`
FROM `ps_prestablog_news_lang` nl
LEFT JOIN `ps_prestablog_news` n
ON (n.`id_prestablog_news` = nl.`id_prestablog_news`)
LEFT JOIN `ps_prestablog_correspondancecategorie` cc
ON (n.`id_prestablog_news` = cc.`news`)
WHERE 1=1
AND cc.`categorie` IN (
SELECT id_prestablog_categorie
FROM ps_prestablog_categorie_group
WHERE id_group IN (1)
)
AND n.`id_shop` = 1
AND nl.`id_lang` = 1
AND n.`actif` = 1
AND nl.`actif_langue` = 1
AND n.`slide` = 1
AND TIMESTAMP(n.`date`) <= '2025/01/24 19:02:26'
ORDER BY n.`date` desc
LIMIT 0, 5

SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (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,
product_shop.`date_add` > "2024-10-26" as new,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute
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_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_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  )
WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (product_shop.`date_add` > "2024-10-26") AND (EXISTS(SELECT 1 FROM `ps_category_product` cp
JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1)
WHERE cp.`id_product` = p.`id_product`))
ORDER BY product_shop.`date_add` DESC
LIMIT 8

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 cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 37
AND cl.`id_lang` = 1
AND c.`actif` = 1
AND cc.`categorie` IN (
SELECT id_prestablog_categorie
FROM ps_prestablog_categorie_group
WHERE id_group IN (1)
)
ORDER BY cl.`title`

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='2706a85a10effcb7f6758e7ad1d05310' AND cache_id LIKE "blocknewproducts-home|20250124|1|1|1|21%"

SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 33
AND cl.`id_lang` = 1
AND c.`actif` = 1
AND cc.`categorie` IN (
SELECT id_prestablog_categorie
FROM ps_prestablog_categorie_group
WHERE id_group IN (1)
)
ORDER BY cl.`title`

SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 34
AND cl.`id_lang` = 1
AND c.`actif` = 1
AND cc.`categorie` IN (
SELECT id_prestablog_categorie
FROM ps_prestablog_categorie_group
WHERE id_group IN (1)
)
ORDER BY cl.`title`

SELECT SQL_NO_CACHE cl.`title`, cl.`link_rewrite`, cc.`categorie`
FROM `ps_prestablog_correspondancecategorie` as cc
LEFT JOIN `ps_prestablog_categorie` as c
ON (cc.`categorie` = c.`id_prestablog_categorie`)
LEFT JOIN `ps_prestablog_categorie_lang` as cl
ON (cc.`categorie` = cl.`id_prestablog_categorie`)
WHERE cc.`news` = 35
AND cl.`id_lang` = 1
AND c.`actif` = 1
AND cc.`categorie` IN (
SELECT id_prestablog_categorie
FROM ps_prestablog_categorie_group
WHERE id_group IN (1)
)
ORDER BY cl.`title`

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='2706a85a10effcb7f6758e7ad1d05310' AND cache_id="blocknewproducts-home|20250124|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'home' AND hm.`id_module` = 4 LIMIT 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

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='b65a265567bafd2dab95535e2f2befbf' AND cache_id="homefeatured-tab|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`='a4e4cefb6f319bd72bedb9474b0f1bbb' AND cache_id="blocknewproducts-tab|20250124|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`='626c4e69b0683fd7af4062a458e457ed' AND cache_id="homefeatured|1|1|1|21" AND compile_id="" LIMIT 1

DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='a4e4cefb6f319bd72bedb9474b0f1bbb' AND cache_id LIKE "blocknewproducts-tab|20250124|1|1|1|21%"

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='4cda61ed569ee7ca8e57136af7c10dfa' AND cache_id="blockbestsellers-tab|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'home' AND active = 1
ORDER BY item_order ASC

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='7267bdde9a39084cd18ba1374dcba12b' AND cache_id="blockbestsellers-home|1|1|1|21" AND compile_id="" LIMIT 1

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

UPDATE `ps_smarty_lazy_cache`
SET filepath='displayHome2025_01_24_19/1/1/1/21/33/12/40/3312401938965e03ad68994c6255dc1eb7b6c926.blocks.tpl.php'
WHERE `template_hash`='14e2cab5736b3cb510ab77f2d2151600' AND cache_id="displayHome2025-01-24 19|1|1|1|21" AND compile_id=""

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

SELECT SQL_NO_CACHE * FROM ps_boutonbloghome WHERE `id_lang` = "1" and `id_store`="1" LIMIT 1

SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'home' AND hm.`id_module` = 19 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'top' AND active = 1
ORDER BY item_order ASC

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 = "index" LIMIT 1

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

SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "index"
OR m.page = "index"
)
AND ml.id_lang = 1
AND ml.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`='655c99e0b6adbbe521a70b0c20475a1b' AND cache_id="blocksearch-top|1|1|1|21" AND compile_id="" LIMIT 1

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

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 4 AND `id_shop` = 1 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_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3daa298a719a536344f12c9c9e4a8f21' AND cache_id="homeslider|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`='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`='db9b2f097ed1c5352fe05002ea63a524' AND cache_id="blockcontactinfos|1|1|1|21" AND compile_id="" LIMIT 1

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

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5cd1869be5092cfba1ec98f19870c84a' AND cache_id="blockcmsinfo|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 ('20379', '1', '308349358', '', '1', '1', '2025-01-24 19:02:28')

CREATE TEMPORARY TABLE `ps_pspc_tmp` (
`id_product` INT UNSIGNED NOT NULL DEFAULT 0,
`id_pspc` INT UNSIGNED NOT NULL DEFAULT 0,
`reduction` FLOAT(20, 6),
`to` DATETIME,
UNIQUE(`id_product`)
) ENGINE=MEMORY

SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'home' AND hm.`id_module` = 38 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

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='14e2cab5736b3cb510ab77f2d2151600' AND cache_id="displayHome2025-01-24 19|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 ('14e2cab5736b3cb510ab77f2d2151600',"displayHome2025-01-24 19|1|1|1|21","", FROM_UNIXTIME(1737741747))

SELECT SQL_NO_CACHE *
FROM `ps_pspc_block` a0
LEFT JOIN `ps_pspc_block_lang` `a1` ON (a0.`id_pspc_block` = a1.`id_pspc_block`)
WHERE (a0.`id_pspc_block` IN(1)) AND (1
AND `hook` = "displayHome") AND (a1.`id_lang` = 1)

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

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 `id_module` FROM `ps_module` WHERE `name` = "homefeatured" LIMIT 1

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

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

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockbestsellers" 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')

SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 1 LIMIT 1

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

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

SELECT SQL_NO_CACHE pspc.`id_pspc`, `to`
FROM `ps_pspc` pspc
LEFT JOIN `ps_pspc_shop` pspcs
ON pspc.`id_pspc` = pspcs.`id_pspc`
WHERE pspcs.`active` = 1
AND pspcs.`id_shop` IN (1)
AND `from` <= UTC_TIMESTAMP() AND `to` > UTC_TIMESTAMP()

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('14e2cab5736b3cb510ab77f2d2151600',"displayHome2025-01-24 19|1|1|1|21","", FROM_UNIXTIME(1737741747))

SELECT SQL_NO_CACHE `id_product`
FROM `ps_pspc_tmp`
WHERE 1
ORDER BY `id_product` DESC
LIMIT 0, 12

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|index" AND compile_id="" LIMIT 1

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

SELECT SQL_NO_CACHE `id_pspc`
FROM `ps_pspc_block_source`
WHERE `id_pspc_block` = 1