SELECT url_to, r404
FROM pod_redirect
WHERE BINARY REPLACE(url_from,'/ru/','/') = '/kastryuli/pan_16-lamart.html' LIMIT 0,1 [0.0017449855804443 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('pan_16','lamart') order by url [0.0013370513916016 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('pan_16','lamart') order by url [0.00049901008605957 sec]
select id,url from pod_cat_brand where BINARY url IN ('pan_16','lamart') [0.00097298622131348 sec]
SELECT cb.metaindex, cb.metafollow
FROM pod_set_cat_brand cb
INNER JOIN pod_cat_category c ON cb.cat_id = c.id
WHERE c.url = 'kastryuli'
AND cb.brand_id = 1203
AND cb.is_active = 1
LIMIT 1 [0.00058794021606445 sec]
SELECT id, url FROM pod_filter WHERE url IN ('pan_16','lamart') [0.00058794021606445 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('pan_16','lamart') [0.00090408325195312 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods;
CREATE TEMPORARY TABLE tmp_base_goods (
id INT NOT NULL PRIMARY KEY,
brand_id INT,
price DECIMAL(10,2),
old_price DECIMAL(10,2),
ordr INT,
is_present TINYINT(1),
sub_icon_id INT,
fast_delivery TINYINT(1),
is_new TINYINT(1),
is_sale TINYINT(1),
KEY idx_brand (brand_id)
) ENGINE=MEMORY [0.00022578239440918 sec]
INSERT INTO tmp_base_goods
(id, brand_id, price, old_price, ordr, is_present, sub_icon_id, fast_delivery, is_new, is_sale)
SELECT g.id, g.brand_id, g.price, g.old_price, g.ordr, g.is_present,
g.sub_icon_id, g.fast_delivery, g.is_new, g.is_sale
FROM pod_cat_good g
WHERE g.cat_id IN (115) AND g.entry=0 AND g.is_active AND g.is_present_all_mods
UNION
SELECT g.id, g.brand_id, g.price, g.old_price, g.ordr, g.is_present,
g.sub_icon_id, g.fast_delivery, g.is_new, g.is_sale
FROM pod_cat_good g
INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id
WHERE dc.dop_cat_id IN (115) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.33575510978699 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods;
CREATE TEMPORARY TABLE tmp_sub_goods (
id INT NOT NULL PRIMARY KEY,
entry INT NOT NULL,
price DECIMAL(10,2),
old_price DECIMAL(10,2),
sub_icon_id INT,
is_present TINYINT(1),
fast_delivery TINYINT(1),
is_new TINYINT(1),
is_sale TINYINT(1),
KEY idx_entry (entry)
) ENGINE=MEMORY [0.00056695938110352 sec]
INSERT INTO tmp_sub_goods
(id, entry, price, old_price, sub_icon_id, is_present, fast_delivery, is_new, is_sale)
SELECT go.id, go.entry, go.price, go.old_price, go.sub_icon_id, go.is_present,
go.fast_delivery, go.is_new, go.is_sale
FROM pod_cat_good go
INNER JOIN tmp_base_goods t ON go.entry = t.id
WHERE go.is_active AND go.is_present [0.0047290325164795 sec]
SELECT g.id /* cats:115 */
FROM tmp_base_goods g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (89)
WHERE g.brand_id IN (1203) AND
g.is_present AND
1
UNION
SELECT g.id /* cats:115 */
FROM tmp_sub_goods go
INNER JOIN tmp_base_goods g ON go.entry = g.id
INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (89)
WHERE g.brand_id IN (1203) AND
1
[0.0013949871063232 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2bb96ca322e (
id INT,
gid INT,
INDEX idx_id (id),
INDEX idx_gid (gid)
) [0.00020408630371094 sec]
INSERT INTO temp_brand_counts_6a2bb96ca322e (id, gid)
SELECT g.brand_id AS id, g.id AS gid /* cats:115 */
FROM tmp_base_goods g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (89)
WHERE g.is_present AND
1
UNION
SELECT g.brand_id AS id, g.id AS gid /* cats:115 */
FROM tmp_sub_goods go
INNER JOIN tmp_base_goods g ON go.entry = g.id
INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (89)
WHERE 1
UNION
SELECT id, null gid
FROM pod_cat_category
WHERE id in (1203) [0.0030560493469238 sec]
SELECT b.id, b.name AS name, pc.name AS country, b.country_id,
b.image_icon, b.url, b.ordr, pc.code,
COALESCE(tc.count, 0) as count
FROM pod_cat_brand b
INNER JOIN (
SELECT id, COUNT(gid) as count
FROM temp_brand_counts_6a2bb96ca322e
GROUP BY id
HAVING COUNT(gid) > 0
) tc ON b.id = tc.id
LEFT JOIN pod_country pc ON (pc.id = b.country_id AND pc.is_active = 1)
WHERE b.is_active = '1'
ORDER BY b.ordr [0.0012137889862061 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2bb96ca322e [0.00019621849060059 sec]
SELECT MIN(min_price) AS min_price, MAX(max_price) AS max_price
FROM (
SELECT MIN(g.price) AS min_price, MAX(g.price) AS max_price /* cats:115 */
FROM tmp_base_goods g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (89)
WHERE g.brand_id IN (1203) AND
g.is_present AND
1
UNION
SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price /* cats:115 */
FROM tmp_sub_goods go
INNER JOIN tmp_base_goods g ON go.entry = g.id
INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (89)
WHERE g.brand_id IN (1203) AND
1
) A
[0.00073099136352539 sec]
SELECT g.id,if(g.is_present and g.price >= '0' and g.price <= '99999',least(g.price,ifnull(min(pcg.price),g.price)),ifnull(min(pcg.price),g.price)) min_sort_price
, if(g.is_present and g.price >= '0' and g.price <= '99999',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) max_sort_price
FROM (
SELECT g.id /* cats:115 */
FROM tmp_base_goods g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (89)
WHERE g.brand_id IN (1203) AND
g.is_present AND
1
UNION
SELECT g.id /* cats:115 */
FROM tmp_sub_goods go
INNER JOIN tmp_base_goods g ON go.entry = g.id
INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (89)
WHERE g.brand_id IN (1203) AND
1
) a INNER JOIN pod_cat_good g ON a.id = g.id
LEFT JOIN pod_cat_good pcg ON pcg.entry=g.id and pcg.is_present=1 and pcg.is_present=1 and pcg.price >= '0' and pcg.price <= '99999' GROUP BY g.id
ORDER BY g.ordr desc
LIMIT 0, 32 [0.001262903213501 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id in (1203) [0.0003209114074707 sec]
SELECT cb.id,
cb.info AS info,
cb.title AS title,
cb.metadesc AS metadesc,
cb.seo_text AS seo_text,
cb.tagH1 AS tagH1,
cb.canonical,
cb.is_active
FROM pod_set_cat_brand cb
WHERE
cb.cat_id = 115
AND cb.brand_id = 1203
AND cb.is_active = 1
LIMIT 1 [0.00032901763916016 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id='1203' [0.00030899047851562 sec]
SELECT url FROM pod_cat_brand WHERE id = 1203 [0.00022220611572266 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96ca7a01;
CREATE TEMPORARY TABLE tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96ca7a01 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00043582916259766 sec]
INSERT INTO tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96ca7a01 (goods_id, filter_id)
SELECT DISTINCT
t.id AS goods_id,
f.id AS filter_id
FROM pod_cat_filter cf
INNER JOIN pod_filter fm ON cf.filter_id = fm.id AND fm.is_split = 0 AND fm.is_active
INNER JOIN pod_good_filter gf USE INDEX (idx_cat_filter_good)
ON gf.filter_id = cf.filter_id AND gf.cat_id IN (115) AND gf.filter_id_value NOT IN (89)
INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active
INNER JOIN tmp_base_goods t ON gf.id_good = t.id
WHERE cf.category_id = 115 [0.036849975585938 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96ca7a01;
CREATE TEMPORARY TABLE tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96ca7a01 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00035405158996582 sec]
INSERT IGNORE INTO tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96ca7a01 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96ca7a01 p
GROUP BY p.filter_id [0.00069189071655273 sec]
SELECT
c.filter_id,
c.count,
f.entry,
f.name AS name,
f.url,
f.ord,
fm.name AS mname,
fm.url AS murl,
fm.ord AS mord
FROM tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96ca7a01 c
INNER JOIN pod_filter f ON c.filter_id = f.id
INNER JOIN pod_filter fm ON f.entry = fm.id
ORDER BY fm.ord DESC, f.ord DESC, c.filter_id [0.00043010711669922 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96ca7a01 [0.00029706954956055 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96ca7a01 [0.00011420249938965 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb1998;
CREATE TEMPORARY TABLE tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb1998 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00023794174194336 sec]
INSERT INTO tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb1998 (goods_id, filter_id)
SELECT DISTINCT
ts.entry AS goods_id,
f.id AS filter_id
FROM pod_cat_filter cf
INNER JOIN pod_filter fm ON cf.filter_id = fm.id AND fm.is_split = 1 AND fm.is_active
INNER JOIN pod_good_filter gf USE INDEX (idx_cat_filter_good)
ON gf.filter_id = cf.filter_id AND gf.cat_id IN (115) AND gf.filter_id_value NOT IN (89)
INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active
INNER JOIN tmp_sub_goods ts ON gf.id_good = ts.id
WHERE cf.category_id = 115 [0.0027978420257568 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb1998;
CREATE TEMPORARY TABLE tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb1998 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00040602684020996 sec]
INSERT IGNORE INTO tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb1998 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb1998 p
GROUP BY p.filter_id [0.00042414665222168 sec]
SELECT
c.filter_id,
c.count,
f.entry,
f.name AS name,
f.url,
f.ord,
fm.name AS mname,
fm.url AS murl,
fm.ord AS mord
FROM tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb1998 c
INNER JOIN pod_filter f ON c.filter_id = f.id
INNER JOIN pod_filter fm ON f.entry = fm.id
ORDER BY fm.ord DESC, f.ord DESC, c.filter_id [0.00066804885864258 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb1998 [0.00033402442932129 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb1998 [0.00012898445129395 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb318a;
CREATE TEMPORARY TABLE tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb318a (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY [0.00034308433532715 sec]
INSERT INTO tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb318a (goods_id, filter_id)
SELECT DISTINCT
ts.entry AS goods_id,
f.id AS filter_id
FROM pod_cat_filter cf
INNER JOIN pod_filter fm ON cf.filter_id = fm.id AND fm.is_split = 1 AND fm.is_active
INNER JOIN pod_good_filter gf USE INDEX (idx_cat_filter_good)
ON gf.filter_id = cf.filter_id AND gf.cat_id IN (115) AND gf.filter_id = 86
INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active
INNER JOIN tmp_sub_goods ts ON gf.id_good = ts.id
WHERE cf.category_id = 115 [0.0012869834899902 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb318a;
CREATE TEMPORARY TABLE tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb318a (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY [0.0003809928894043 sec]
INSERT INTO tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb318a (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb318a p
GROUP BY p.filter_id [0.0003509521484375 sec]
INSERT INTO tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb318a (filter_id, count)
SELECT pf.id, 0
FROM pod_filter pf
LEFT JOIN tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb318a c ON c.filter_id = pf.id
WHERE pf.id in (89) AND c.filter_id IS NULL [0.00027990341186523 sec]
SELECT
c.filter_id,
c.count,
f.entry,
f.name AS name,
f.url,
f.ord,
fm.name AS mname,
fm.url AS murl,
fm.ord AS mord
FROM tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb318a c
INNER JOIN pod_filter f ON c.filter_id = f.id
INNER JOIN pod_filter fm ON f.entry = fm.id
ORDER BY fm.ord DESC, f.ord DESC, c.filter_id [0.00040507316589355 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb318a [0.00021100044250488 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb318a [9.7036361694336E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb4213;
CREATE TEMPORARY TABLE tmp_A_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb4213 (
entry INT NOT NULL,
sub_icon_id INT NOT NULL,
PRIMARY KEY (entry, sub_icon_id)
) ENGINE=MEMORY; [0.00039410591125488 sec]
INSERT IGNORE INTO tmp_A_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb4213 (entry, sub_icon_id)
SELECT DISTINCT A.entry, A.sub_icon_id FROM (
SELECT g.id as id, g.id as entry, g.sub_icon_id /* cats:115 */
FROM tmp_base_goods g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (89)
WHERE g.brand_id IN (1203) AND
g.is_present AND
1
UNION
SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats:115 */
FROM tmp_sub_goods go
INNER JOIN tmp_base_goods g ON go.entry = g.id
INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (89)
WHERE g.brand_id IN (1203) AND
1
) A [0.0010001659393311 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb4213;
CREATE TEMPORARY TABLE tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb4213 (
sub_icon_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00044417381286621 sec]
INSERT IGNORE INTO tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb4213 (sub_icon_id, count)
SELECT
sub_icon_id,
COUNT(DISTINCT entry) AS count
FROM (
SELECT A.entry, A.sub_icon_id
FROM tmp_A_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb4213 A
INNER JOIN pod_sub_icon si ON A.sub_icon_id = si.id AND si.is_active_filter = 1
) AA
GROUP BY sub_icon_id [0.00047087669372559 sec]
SELECT
c.sub_icon_id AS id,
c.count,
si.entry,
si.name AS name,
si.url
FROM tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb4213 c
INNER JOIN pod_sub_icon si ON c.sub_icon_id = si.id AND si.is_active_filter = 1
ORDER BY si.ordr, si.name [0.00028204917907715 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb4213 [0.00024509429931641 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pemp6lnoe8f3ogbtr9iuaqj8vf_6a2bb96cb4213 [0.00010490417480469 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods;
DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00022983551025391 sec]
Низкие цены на Кастрюли Lamart (Лaмaрт ) – большой выбор, фото. Купить Кастрюли Lamart (Лaмaрт ) в Киеве и Украине
Кастрюли Lamart — французское качество от шеф-повара
Торговая марка «Lamart» основана французским поваром, который работал в семейном ресторане на берегу Атлантического океана. Тогда Пьер Ламар загорелся идеей создать линейку современных кухонных принадлежностей, которые будут облегчать процесс готовки любимых блюд. Так мир увидел легендарные кастрюли Lamart.
Разнообразие моделей на все случаи жизни
Посуда изготавливается из первоклассных материалов с применением инновационных технологий:
коллекция «Shiny» с керамическим антипригарным покрытием
серия «Multicolor» из цветного алюминия с противопригарной поверхностью Greblon
коллекция «Iron» из чугуна с антипригарным эмалированным покрытием
серия «Joli» — кастрюли Lamart из нержавейки с многослойным дном
алюминиевая посуда с мраморной поверхностью.
Хотите приобрести товары Lamart по выгодной стоимости в Киеве? Добро пожаловать в интернет-магазин «Подушка», где можно купить кастрюли по доступным ценам. В каталоге вы сможете выбрать посуду из алюминия, чугуна и нержавеющей стали с фирменными антипригарными покрытиями. Каждая кастрюля Lamart оснащена стеклянной крышкой с паровыходом и эргономичными ручками.
Ваш заказ оформлен! На e-mail отправлено письмо с подтверждением В ближайшее время с Вами свяжется менеджер Спасибо за заказ!
Ваш профиль будет удален навсегда. Его нельзя восстановить. Продолжить?
Оставьте свой номер телефона и наши менеджеры вам перезвонят
Оплату картами Visa и MasterCard обеспечивает сервис онлайн-платежей Portmone.com. Безопасность оплаты подтверждена международным аудитом PCI DSS. Служба поддержки: тел. +380(44)2000902