SELECT url_to, r404
FROM pod_redirect
WHERE BINARY REPLACE(url_from,'/ru/','/') = '/postelnoe_bele/class-marcel-selena-homytex.html' LIMIT 0,1 [0.00034189224243164 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('class','marcel','selena','homytex') order by url [0.0010719299316406 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('class','marcel','selena','homytex') order by url [0.00069808959960938 sec]
select id,url from pod_cat_brand where BINARY url = 'class-marcel-selena-homytex' [0.0010848045349121 sec]
select id,url from pod_cat_brand where url = 'class-marcel-selena-homytex' [0.00034713745117188 sec]
select id,url from pod_cat_brand where url in ('class','marcel','selena','homytex') [0.00052618980407715 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.00032210350036621 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 (3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689) 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 (3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.68612885475159 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.00031113624572754 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.36312413215637 sec]
SELECT g.id -- основні (tmp)
FROM tmp_base_goods g
WHERE g.brand_id IN (826,2408,1744,1889) AND
1
[0.000701904296875 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2accfadd6eb (
id INT,
gid INT,
INDEX idx_id (id),
INDEX idx_gid (gid)
) [0.00023293495178223 sec]
INSERT INTO temp_brand_counts_6a2accfadd6eb (id, gid)
SELECT g.brand_id AS id, g.id AS gid -- основні (tmp)
FROM tmp_base_goods g
WHERE 1
UNION
SELECT id, null gid
FROM pod_cat_category
WHERE id in (826,2408,1744,1889) [0.014564990997314 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_6a2accfadd6eb
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.0014939308166504 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2accfadd6eb [0.00013399124145508 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 -- основні (tmp)
FROM tmp_base_goods g
WHERE g.brand_id IN (826,2408,1744,1889) AND
g.is_present AND
1
UNION
SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price -- підтовари (tmp)
FROM tmp_sub_goods go
INNER JOIN tmp_base_goods g ON go.entry = g.id
WHERE g.brand_id IN (826,2408,1744,1889) AND
1
) A
[0.0015170574188232 sec]
SELECT g.id, if(g.is_present and g.price >= '484' and g.price <= '4829',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 >= '484' and g.price <= '4829',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) max_sort_price
FROM pod_cat_good g
LEFT JOIN pod_cat_good pcg ON pcg.entry=g.id and pcg.is_present=1 and pcg.is_present=1 and pcg.price >= '484' and pcg.price <= '4829' WHERE g.id in (342554,309376,309323,248830,81463,79045,488543,488542,488527,488525,488524,488523,488521,488520,488519,488518,488517,488516,488513,488510,488507,488504,488499,488496,488493,488491,488489,488486,488480,488478,488475,488474,488471,488470,322666,488522,488483,418696,488467,488466,488465,488564,488562,488558,488557,262592,262591,262589,262588,488568,434760,434756,434671,434667,434663,406437,406436,406434,406433,333190,333189,333188,333187,333186,333185,304583,284254,284253,434168,434164,277868,277863,269790,482347,482342,482190,478650,478646,478642,478638,478634,478630,478626,478622,478618,478614,478610,477916,477912,477908,477904,477900,477896,477892,477888,473535,473531,473527,473523,473519,473515,473459,473455,473451,473447,473443,473439,464719,464714,464710,464706,464701,464696,464692,464688,464684,464680,464676,462547,462543,462539,462535,462531,461101,461097,461093,461089,461085,460977,460973,460969,460965,460961,459084,459079,459075,459071,459067,459063,459059,450887,450883,450879,450875,450871,440955,440951,440947,440943,440939,440935,440292,440288,440284,440280,440227,440223,440219,440215,440211,440207,436895,436888,436270,436240,436037,436033,436029,435914,435913,435909,435904,435897,435895,435891,435886,435882,435878,435874,435795,435713,435709,435689,435640,435636,435632,435628,435624,435620,435616,435612,435608,435604,435600,435596,435592,435588,435584,435580,435576,435572,434505,434501,434497,434493,434489,434485,434481,434477,434473,434469,434465,434461,434457,434453,434449,434445,434441,434073,434069,434065,434061,434057,432416,432412,431399,431395,431391,431387,431383,431379,431375,431371,431367,413447,413443,413439,413435,413431,413427,413423,409371,409370,409235,409234,409233,409232,409231,409229,409228,409227,409226,409225,409224,407307,407303,407299,407295,407291,407287,407283,407279,407275,407271,407267,407263,407259,406397,406396,406395,406394,406393,404705,404701,404697,404693,404689,402847,402843,402705,402619,391962,391958,391953,391949,391945,391941,391937,391933,391929,391925,349749,349565,349562,349559,349462,349459,409530,409526,409522,349769,349765,349761,349757,349551,349547,349543,349539,343770,343766,343307,343303,505280,505275,505271,505265,505258,505254,436892,436891,436890,436889,436253,436243,436067,435708,435702,435700,435697,435695,435694,434792,434160,430659,430657,430655,385456,385452,385448,385444,385440,385436,385432,349848,349847,349843,349133,349129,349125,349121,349117,349113,349108,349102,349098,349094,349090,349086,349082,349078,348722,348711,348708,345976,345973,345970,345967,345964,343229,343218,333371,333367,333363,333359,333355,333347,333343,333199,333195,333191,333136,333132,333128,333124,333120,333116,333112,333108,333104,333100,333096,333092,332835,322685,313648,308644,308641,308638,308635,284227,284224,284222,284218,277901,277854,277850,269774,269770,497280,497276,497272,497163,497159,467277,467273,467269,467265,467261,467257,467253,467252,467248,465717,465712,465708,465704,465700,462527,462523,462519,462515,432664,432660,432118,432113,432109,432105,432101,432097,431322,431318,431314,431310,431306,431302,430778,430774,430770,410732,410728,410724,410720,343278,343274,341459,341462,508866,508860,508854,505263,497802,491460,491278,491273,482866,481826,481821,481815,481809,480090,480073,480067,477607,477606,476764,476759,476754,476749,474571,474570,474525,460025,456438,456433,456428,456423,456418,456405,456400,453173,452736,450768,450767,450766,450765,450763,450762,450761,450760,450759,450385,450379,450373,450367,450361,448737,448732,448412,448407,447037,447032,447026,447020,447014,436281,436279,436277,436275,436272,435902,435901,434220,434077,432249,432248,432247,432246,367865,367591,349852,349851,349850,349849,349846,349845,349844,349842,349841,349840,349839,349838,349837,349836,349490,349437,284252,284216,504499,504495,504491,504487,504483,504479,504475,474314,474310,474306,474302,474298,467494,467490,467486,467482,467478,467474,453225,453220,453216,453210,453206,453202,453198,453194,439153,439149,439145,439097,439093,439089,439085,436070,434619,434615,434611,434607,434603,434599,431298,431294,431290,431286,431282,431278,431274,431270,431266,431262,431258,431254,431250,431246,431244,431240,431239,431235,431032,431028,431024,431020,431016,431012,431008,431004,431000,430996,430992,430988,430984,430980,430976,430972,430968,430964,430960,430959,430955,430951,430947,430943,430942,430941,430940,430816,430814,430813,430812,430809,430805,430804,430803,430802,430801,430799,430798,430660,415031,409238,409237,409236,363762,363758,363754,363750,349741,349503,349499,348636,348632,348628,348624,348620,348616,348612,348608,348604,348600,348596,348592,348588,348584,348580,348180,348177,348150,345981,345839,344218,344214,344210,343258,343254,341860,341856,341586,341583,341579,341454,341443,333283,333279,333275,333271,333263,333259,333255,333251,333247,333211,333207,333203,333180,333081,333074,333063,333057,332971,332967,332962,324710,324707,322703,322700,322697,322692,322689,318518,317765,317762,317761,313646,313638,313629,308648,299763,299759,299756,299752,284249,284246,284243,284240,284236,284230,270118,270111,270107,269786,269782,269778,313644,509154,509150,509146,509142,509138,508862,508856,508849,508844,508839,501392,501388,501384,501380,497798,497794,497790,497786,497782,497778,497774,491340,491274,491269,491265,491261,482058,482054,482050,482046,482042,481831,481827,481822,481817,481811,481805,480086,480082,480078,480074,480069,480063,477680,477676,477672,477668,477664,477660,477656,476760,476755,476750,476745,476700,476696,476692,476688,476684,476680,476255,476251,476247,476243,476239,476235,476231,476227,475327,475323,475319,475315,475311,474592,474588,474584,474580,474576,474572,474566,474562,474558,474554,474550,474546,474542,474538,474534,474530,474526,474521,473685,473681,473677,473673,473435,473431,473427,473423,473419,473415,470481,470477,470473,470469,468503,468499,468495,468491,467581,467577,467573,467569,467565,467561,466478,466474,466470,466466,466462,466458,466257,466253,466249,466245,466241,464746,464741,464736,464732,464728,464723,464202,464198,464194,464190,464186,462353,462349,462345,462341,462337,462333,462329,462325,462321,462317,460021,460017,460013,460009,460005,460000,459996,456447,456443,456439,456434,456429,456424,456419,456414,456410,456406,456401,456396,453190,453186,453182,453178,453174,453169,452752,452748,452742,452738,452732,452726,452722,452718,452712,452708,452704,452700,452696,452692,452688,452684,452680,452676,451459,451452,451447,451443,451439,451435,451431,451427,451423,450865,450853,450847,450841,450835,450829,450823,450811,450805,450799,450793,450787,450781,450775,450769,450381,450375,450369,450363,450357,449216,449212,449208,449204,449200,449196,448750,448746,448742,448738,448733,448728,448724,448720,448716,448425,448421,448417,448413,448408,448403,448399,448395,447618,447614,447610,447606,447602,447598,447594,447038,447033,447028,447022,447016,447010,444026,444022,444018,444014,444010,444006,444002,441885,441881,441877,441873,441345,441341,441337,441333,441329,440724,440718,440714,440710,440706,440702,440698,440694,440690,440686,440517,440513,440509,440505,440501,439974,439970,439966,439962,439958,439954,439197,439193,439189,439185,439181,439177,436897,436896,436283,436271,436259,436257,436252,436251,436249,436248,436246,436245,436244,436242,436102,436083,436076,436062,436060,436056,436052,436048,436046,436045,436041,435835,435831,435827,435811,435807,435803,435799,435707,435703,434787,434784,434779,434775,434774,434659,434655,434651,434647,434643,434639,434635,434631,434627,434623,434229,434225,434221,434216,434212,434208,434204,434200,434196,434192,434188,434184,434180,434176,434172,434156,434152,434148,434144,434140,434134,434130,434129,434125,434121,434117,434113,434109,434105,434101,434097,434093,433029,433024,433022,433020,432740,432736,432732,432728,432724,432720,432716,432712,432708,432704,432700,432696,432692,432688,432684,432680,432676,432672,432668,432554,432550,432547,432543,432539,432535,432531,432527,432523,432519,432424,432420,432408,432404,432400,432396,432394,432392,432391,432388,432262,432258,432254,432250,432146,432142,432138,431454,431450,431446,431442,431438,431434,431430,431428,431424,431420,431419,431415,431411,431407,431403,431326,430794,430790,430786,430782,430766,430762,430758,430754,430750,430746,430742,430738,430734,430651,430648,430646,430644,430640,430636,430633,430632,430629,430627,430626,430624,430623,430622,430361,430357,430353,430349,409518,409514,409510,409506,409241,404557,404553,391921,385428,385424,385420,385416,385412,385408,385404,385400,385396,385392,385388,385384,385377,385373,385369,385365,385361,385357,385353,385349,385345,385341,380751,380747,380743,380739,376173,375479,375171,375166,375010,367872,367869,367862,367859,367856,367853,367844,367829,367826,367823,367820,367817,367814,367811,367806,367803,367800,367797,367794,367788,367784,367618,367614,367611,367606,367603,367598,367595,367592,367588,367581,367567,367564,367560,367557,367553,367550,367544,367532,363746,363742,363738,363734,363730,363726,363722,363718,363714,363710,363706,349944,349925,349921,349917,349913,349909,349905,349901,349897,349893,349737,349733,349729,349725,349721,349713,349709,349555,349531,349527,349523,349519,349515,349511,349495,349491,349483,349480,349477,349473,349469,349465,349455,349451,349447,349442,349438,349424,349388,349383,349379,349375,349371,349367,349363,349359,349355,349350,349165,349161,349157,349153,349149,348704,348701,348466,348461,348457,348453,348442,348438,348434,348429,348425,348421,348417,348413,348409,348405,348401,348397,348393,348389,348385,348381,348377,348373,348369,348365,348298,348294,348290,348285,348281,348277,348273,348269,348265,348261,348257,348253,348249,348245,348241,348237,348233,348229,348225,348221,348186,348183,348137,348134,348130,348127,348124,348121,348118,348115,346391,346388,346371,345961,345951,345948,345944,345911,345908,345905,345902,345895,345892,345889,345886,345883,345851,345848,345845,345842,345446,345424,345420,345416,345412,345403,345011,345008,345004,345000,344996,344923,344918,344914,344909,344901,344896,344888,344884,344880,344876,344872,344868,344863,344856,344852,344848,344844,343299,343295,343291,343287,343283,343270,343266,343262,342733,342729,342721,341451,341447,341439,341435,341431,341426,341422,341419,333439,333432,333421,333412,333408,333404,333400,333397,333394,333390,333386,333351,333339,333335,333267,333243,333239,333235,333231,333227,333223,333219,333215,333176,333172,333168,333164,333160,333156,333152,333148,333144,333140,333015,333011,332958,332954,332949,332944,332940,332936,332933,332929,332925,332921,332917,332911,332910,332906,332900,332896,332892,332888,332884,332880,332876,332867,332863,332859,332855,332851,332847,332843,332839,332831,332827,332823,332819,332815,332811,332808,332805,332802,332799,332796,332792,332789,332786,332783,332779,332776,332773,332769,332766,332763,332760,332757,332754,332751,332748,332745,332742,332738,332730,332724,332720,332717,332714,332680,332677,332674,332671,332668,332663,332660,332657,332654,332651,332646,332645,332641,332638,332635,332632,332622,332621,332617,332616,332615,332614,324719,324716,324713,324285,324282,324279,324276,324270,324267,322681,322678,317777,317774,317771,317768,308632,308630,299749,293709,293706,293705,293702,288657,288654,288649,288648,288645,284213,284209,284206,270115,270104,270101,269767,269764,269761,269758,269755,269752,349433,349432,349429,348698,346394,345899,342725,332872,332734,293699,414529)
GROUP BY g.id
ORDER BY g.ordr desc
LIMIT 0, 32 [0.12293887138367 sec]
SELECT g.video, g.threedvideo, g.is_xit, g.is_action, g.is_sale,
g.sub_is_action, g.is_new, g.is_pay_for_video, g.id, g.cat_id,
g.name AS name, g.name2 AS name2, g.descr, g.size_table, g.artikul, g.image_small,
g.image_big, g.price, g.old_price, g.is_present,
g.is_present_all_mods, g.sub_icon_id,g.url,g.ordr, g.last_items, g.fast_delivery, g.free_delivery, g.gift,
g.timer, g.action_validity,
b.name AS brand_name,b.url as burl,b.id as bid, b.country AS brand_country,c.url as curl, c.name AS cat_name,
si.name AS sub_icon_name,si.icon AS sub_icon,
g.star, g.comment_id, if(g.is_present and g.price >= '484' and g.price <= '4829',least(g.price,ifnull(min(pcg.price),g.price)),ifnull(min(pcg.price),g.price)) as min_sort_price,
if(g.is_present and g.price >= '484' and g.price <= '4829',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) as max_sort_price
FROM pod_cat_good g
INNER JOIN pod_cat_category c ON c.id=g.cat_id
LEFT JOIN pod_cat_brand b ON b.id=g.brand_id
LEFT JOIN pod_sub_icon si ON si.id=g.sub_icon_id
LEFT JOIN pod_cat_good pcg ON (pcg.entry=g.id and pcg.is_present=1 and pcg.price >= '484' and pcg.price <= '4829')
WHERE g.id in (509154,430964,509142,332811,453182,440513,476243,467569,497798,444026,345944,434461,348453,440710,440702,476745,439966,434204,464186,473419,367611,473431,452738,473451,434611,464696,434073,482058,448413,480090,452732,474562)
GROUP BY g.id
ORDER BY g.ordr desc [0.0027229785919189 sec]
SELECT g.ordr, g.is_xit, g.is_pay_for_video, g.is_action, g.is_sale, g.is_new, g.last_items, g.fast_delivery, g.free_delivery, g.gift,
g.timer, g.action_validity,
g.id, g.entry, g.name AS name, g.price, g.old_price, g.artikul, g.sub_icon_id, g.is_present, si.name AS sub_icon_name, si.icon AS sub_icon
FROM pod_cat_good g
LEFT JOIN pod_sub_icon si ON si.id = g.sub_icon_id
WHERE g.entry IN (509154,430964,509142,332811,453182,440513,476243,467569,345944,434461,444026,497798,348453,440710,440702,476745,439966,434204,464186,473419,367611,473431,452738,473451,434611,464696,434073,482058,448413,480090,452732,474562) AND g.is_active = '1'
ORDER BY g.entry, g.is_present DESC [0.001410961151123 sec]
SELECT DISTINCT
ggd2.good_id AS source_good_id,
g.id, g.is_present_all_mods,
pc.name AS name,
g.url,
b.url as burl, c.url as curl,
g.is_present,
pc.code AS color_code,
gg.group_type,
gg.param_name,
gg.param_name_ua,
ggd.text_value,
ggd.icon_path
FROM pod_goods_group_goods ggd2
JOIN pod_goods_group_goods ggd ON ggd2.goods_group_id=ggd.goods_group_id
JOIN pod_goods_group gg ON ggd.goods_group_id=gg.id
JOIN pod_cat_good g ON g.id=ggd.good_id
LEFT JOIN pod_cat_brand b ON g.brand_id=b.id
LEFT JOIN pod_cat_category c ON g.cat_id=c.id
LEFT JOIN pod_colors pc ON pc.id=ggd.color_id
WHERE ggd2.good_id IN (509154,430964,509142,332811,453182,440513,476243,467569,345944,434461,444026,497798,348453,440710,440702,476745,439966,434204,464186,473419,367611,473431,452738,473451,434611,464696,434073,482058,448413,480090,452732,474562)
ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.0021309852600098 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id in (826,2408,1744,1889) [0.00021481513977051 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id='826.2408.1744.1889' [0.00017905235290527 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8;
CREATE TEMPORARY TABLE tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8 (
id INT NOT NULL,
PRIMARY KEY (id)
) ENGINE=MEMORY; [0.00031900405883789 sec]
INSERT INTO tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8 (id) SELECT A.id FROM (
SELECT g.id -- основні (tmp)
FROM tmp_base_goods g
WHERE g.brand_id IN (826,2408,1744,1889) AND
1
) A [0.0009760856628418 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8;
CREATE TEMPORARY TABLE tmp_pairs_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.0002748966217041 sec]
INSERT INTO tmp_pairs_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8 (goods_id, filter_id)
SELECT DISTINCT
A.id AS goods_id,
f.id AS filter_id
FROM tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8 A
INNER JOIN pod_good_filter gf ON A.id = gf.id_good
INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 3
INNER JOIN pod_filter fm ON gf.filter_id = fm.id AND fm.is_split = 0 AND fm.is_active
INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active [1.2956619262695 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8;
CREATE TEMPORARY TABLE tmp_counts_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00037503242492676 sec]
INSERT IGNORE INTO tmp_counts_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8 p
GROUP BY p.filter_id [0.0011880397796631 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_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8 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.00050520896911621 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8 [0.00023818016052246 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8 [0.00010204315185547 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfb105d8 [0.00025582313537598 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85;
CREATE TEMPORARY TABLE tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85 (
id INT NOT NULL,
entry INT NOT NULL,
PRIMARY KEY (id),
KEY idx_entry (entry)
) ENGINE=MEMORY; [0.00028896331787109 sec]
INSERT INTO tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85 (id, entry) SELECT A.id, A.entry FROM (
SELECT g.id as id, g.id as entry -- основні (tmp)
FROM tmp_base_goods g
WHERE g.brand_id IN (826,2408,1744,1889) AND
g.is_present AND
1
UNION
SELECT go.id as id, g.id as entry -- підтовари (tmp)
FROM tmp_sub_goods go
INNER JOIN tmp_base_goods g ON go.entry = g.id
WHERE g.brand_id IN (826,2408,1744,1889) AND
1
) A [0.0064489841461182 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85;
CREATE TEMPORARY TABLE tmp_pairs_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00035905838012695 sec]
INSERT INTO tmp_pairs_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85 (goods_id, filter_id)
SELECT DISTINCT
A.entry AS goods_id,
f.id AS filter_id
FROM tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85 A
INNER JOIN pod_good_filter gf ON A.id = gf.id_good
INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 3
INNER JOIN pod_filter fm ON gf.filter_id = fm.id AND fm.is_split = 1 AND fm.is_active
INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active [0.047089099884033 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85;
CREATE TEMPORARY TABLE tmp_counts_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00046682357788086 sec]
INSERT IGNORE INTO tmp_counts_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85 p
GROUP BY p.filter_id [0.00062704086303711 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_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85 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.00037312507629395 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85 [0.00027585029602051 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85 [0.00014114379882812 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc59f85 [0.00011992454528809 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc681cb;
CREATE TEMPORARY TABLE tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc681cb (
entry INT NOT NULL,
sub_icon_id INT NOT NULL,
PRIMARY KEY (entry, sub_icon_id)
) ENGINE=MEMORY; [0.0002751350402832 sec]
INSERT IGNORE INTO tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc681cb (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 -- основні (tmp)
FROM tmp_base_goods g
WHERE g.brand_id IN (826,2408,1744,1889) AND
g.is_present AND
1
UNION
SELECT go.id as id, g.id as entry, go.sub_icon_id -- підтовари (tmp)
FROM tmp_sub_goods go
INNER JOIN tmp_base_goods g ON go.entry = g.id
WHERE g.brand_id IN (826,2408,1744,1889) AND
1
) A [0.008018970489502 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc681cb;
CREATE TEMPORARY TABLE tmp_counts_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc681cb (
sub_icon_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00033307075500488 sec]
INSERT IGNORE INTO tmp_counts_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc681cb (sub_icon_id, count)
SELECT
sub_icon_id,
COUNT(DISTINCT entry) AS count
FROM (
SELECT A.entry, A.sub_icon_id
FROM tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc681cb 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.0031449794769287 sec]
SELECT
c.sub_icon_id AS id,
c.count,
si.entry,
si.name AS name,
si.url
FROM tmp_counts_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc681cb 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.00034999847412109 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc681cb [0.00028204917907715 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_mudv2p2a5obgtgqa5uhcbmi7t7_6a2accfc681cb [0.00011014938354492 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods;
DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00013899803161621 sec]
Постельное белье Class ... Homytex (Клaсс ... Хoмитeкс) – большой выбор, фото, отзывы. Купить Постельное белье Class ... Homytex в Киеве и Украине
Ваш заказ оформлен! На e-mail отправлено письмо с подтверждением В ближайшее время с Вами свяжется менеджер Спасибо за заказ!
Ваш профиль будет удален навсегда. Его нельзя восстановить. Продолжить?
Оставьте свой номер телефона и наши менеджеры вам перезвонят
Оплату картами Visa и MasterCard обеспечивает сервис онлайн-платежей Portmone.com. Безопасность оплаты подтверждена международным аудитом PCI DSS. Служба поддержки: тел. +380(44)2000902