SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/postelnoe_bele/first_choice-class-selena-diva.html' LIMIT 0,1 [0.00031304359436035 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('first_choice','class','selena','diva') order by url [0.0016930103302002 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('first_choice','class','selena','diva') order by url [0.0011680126190186 sec]
select id,url from pod_cat_brand where BINARY url = 'first_choice-class-selena-diva' [0.0018820762634277 sec]
select id,url from pod_cat_brand where url = 'first_choice-class-selena-diva' [0.00032901763916016 sec]
select id,url from pod_cat_brand where url in ('first_choice','class','selena','diva') [0.00070500373840332 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.00044393539428711 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.70973110198975 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.00029897689819336 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.35598301887512 sec]
SELECT g.id /* cats: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 */ FROM tmp_base_goods g WHERE g.brand_id IN (826,2134,292,1889) AND 1 [0.00054287910461426 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2af9fcded79 ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.0015108585357666 sec]
INSERT INTO temp_brand_counts_6a2af9fcded79 (id, gid) SELECT g.brand_id AS id, g.id AS gid /* cats: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 */ FROM tmp_base_goods g WHERE 1 UNION SELECT id, null gid FROM pod_cat_category WHERE id in (826,2134,292,1889) [0.015603065490723 sec]
SELECT b.id, b.name_ua AS name, pc.name_ua 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_6a2af9fcded79 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.0015449523925781 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2af9fcded79 [0.00011897087097168 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: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 */ FROM tmp_base_goods g WHERE g.brand_id IN (826,2134,292,1889) AND g.is_present AND 1 UNION SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price /* cats: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 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id WHERE g.brand_id IN (826,2134,292,1889) AND 1 ) A [0.001521110534668 sec]
SELECT g.id /* cats: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 */,if(g.is_present and g.price >= '484' and g.price <= '5733',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 <= '5733',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) max_sort_price FROM tmp_base_goods g LEFT JOIN pod_cat_good pcg ON pcg.entry=g.id AND pcg.is_present=1 AND pcg.price >= '484' AND pcg.price <= '5733' WHERE g.id IN (434714,432578,432577,432574,413698,413697,412181,326471,326470,326469,326468,289788,17790,17731,478825,478824,478823,478822,478821,478273,478272,478268,478267,478265,478264,478263,478259,478256,478255,478254,478252,477376,477373,477372,477276,477275,477274,477273,477269,434706,413615,413589,413588,413586,413577,413576,413575,350540,350539,350334,350333,350332,350331,350297,350288,350287,345702,330686,326524,326521,326520,326519,326467,326466,326459,317169,317167,293599,286149,259116,193604,193480,193477,193473,478216,502569,493093,493092,493089,427624,427623,427622,427620,350704,493090,493088,498246,498245,498242,498221,478889,478888,478406,478405,478404,478403,478402,478401,478400,434712,434711,434710,434709,434708,434707,428370,413709,413708,413707,413706,413705,413696,413695,413694,413693,413574,413573,413570,413568,413567,413566,413565,413493,413492,413491,413490,413489,413488,413487,413482,413481,413478,413476,412176,412175,412174,404652,404641,404639,404634,404633,404632,350534,350533,350415,350414,350413,350412,350411,330685,330682,325983,317174,286139,286111,286110,114214,498210,477698,477697,477694,477253,477250,477249,477248,477247,477246,477245,477241,477240,477239,477238,477237,477235,326530,326529,241780,207919,192362,478806,478802,478208,477701,461512,448649,448648,448647,448646,434696,434695,434693,434692,432576,432567,413691,413690,413632,413629,413623,413621,413620,351992,351991,351990,350800,350797,350546,326253,326252,326251,319491,319473,317377,289929,289796,289795,286234,286232,286161,241281,238613,413622,286163,241278,498259,498258,498257,498256,478820,478815,478211,478210,478207,478206,478205,477703,477702,447000,446999,446998,446997,446996,434722,434721,393883,326269,319488,319474,478817,342554,309376,309323,248830,81463,79045,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,334856) GROUP BY g.id ORDER BY g.ordr desc LIMIT 0, 32 [0.075553894042969 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_ua AS name, g.name2_ua 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_ua AS brand_name,b.url as burl,b.id as bid, b.country AS brand_country,c.url as curl, c.name_ua AS cat_name, si.name_ua 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 <= '5733',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 <= '5733',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 <= '5733') WHERE g.id in (509154,430964,493093,509142,332811,317377,350333,478820,326269,404652,325983,413487,453182,493089,440513,476243,467569,286161,317174,434693,319491,434461,444026,493092,497798,286234,345944,448647,193604,427620,350287,330682) GROUP BY g.id ORDER BY g.ordr desc [0.0068528652191162 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_ua AS name, g.price, g.old_price, g.artikul, g.sub_icon_id, g.is_present, si.name_ua 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,493093,509142,317377,332811,350333,478820,326269,404652,325983,413487,453182,493089,440513,476243,467569,286161,317174,434693,319491,286234,345944,434461,444026,493092,497798,448647,193604,427620,350287,330682) AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.00063681602478027 sec]
SELECT DISTINCT ggd2.good_id AS source_good_id, g.id, g.is_present_all_mods, pc.name_ua 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,493093,509142,317377,332811,350333,478820,326269,404652,325983,413487,453182,493089,440513,476243,467569,286161,317174,434693,319491,286234,345944,434461,444026,493092,497798,448647,193604,427620,350287,330682) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.0086390972137451 sec]
SELECT name_ua AS name, url FROM pod_cat_brand WHERE id in (826,2134,292,1889) [0.00017285346984863 sec]
SELECT name_ua AS name, url FROM pod_cat_brand WHERE id='826.2134.292.1889' [0.00011706352233887 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd; CREATE TEMPORARY TABLE tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.0002288818359375 sec]
INSERT INTO tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd (id) SELECT A.id FROM ( SELECT g.id /* cats: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 */ FROM tmp_base_goods g WHERE g.brand_id IN (826,2134,292,1889) AND 1 ) A [0.00072789192199707 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd; CREATE TEMPORARY TABLE tmp_pairs_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00016498565673828 sec]
INSERT INTO tmp_pairs_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd 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.073625087738 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd; CREATE TEMPORARY TABLE tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00077390670776367 sec]
INSERT IGNORE INTO tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd p GROUP BY p.filter_id [0.0012240409851074 sec]
SELECT c.filter_id, c.count, f.entry, f.name_ua AS name, f.url, f.ord, fm.name_ua AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd 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.00050592422485352 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd [0.00027203559875488 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd [0.0001060962677002 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fd083dd [8.1062316894531E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b; CREATE TEMPORARY TABLE tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00045108795166016 sec]
INSERT INTO tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats: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 */ FROM tmp_base_goods g WHERE g.brand_id IN (826,2134,292,1889) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats: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 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id WHERE g.brand_id IN (826,2134,292,1889) AND 1 ) A [0.0039350986480713 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b; CREATE TEMPORARY TABLE tmp_pairs_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00016903877258301 sec]
INSERT INTO tmp_pairs_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b 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.045156002044678 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b; CREATE TEMPORARY TABLE tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00035905838012695 sec]
INSERT IGNORE INTO tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b p GROUP BY p.filter_id [0.00057101249694824 sec]
SELECT c.filter_id, c.count, f.entry, f.name_ua AS name, f.url, f.ord, fm.name_ua AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b 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.00027894973754883 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b [0.00022602081298828 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b [9.9897384643555E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fe1b71b [8.7976455688477E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fe28559; CREATE TEMPORARY TABLE tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fe28559 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00018095970153809 sec]
INSERT IGNORE INTO tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fe28559 (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: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 */ FROM tmp_base_goods g WHERE g.brand_id IN (826,2134,292,1889) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats: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 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id WHERE g.brand_id IN (826,2134,292,1889) AND 1 ) A [0.0065019130706787 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fe28559; CREATE TEMPORARY TABLE tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fe28559 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00023794174194336 sec]
INSERT IGNORE INTO tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fe28559 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fe28559 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.0024740695953369 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name_ua AS name, si.url FROM tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fe28559 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.00025391578674316 sec]
----------------------------- SELECT DISTINCT gf.id_good AS goods_id, f.id AS filter_id FROM pod_cat_filter cf INNER JOIN pod_good_filter gf USE INDEX (idx_filter_id_good) ON gf.filter_id = cf.filter_id INNER JOIN pod_filter fm ON cf.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 WHERE cf.category_id = 3 AND EXISTS (SELECT 1 FROM tmp_base_goods t WHERE t.id = gf.id_good); [0.76277995109558 sec]
----------------------------- DROP TEMPORARY TABLE IF EXISTS tmp_A_e4amgvh6qd04okuivf3meo46vl_6a2af9fe28559 [0.00016689300537109 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_e4amgvh6qd04okuivf3meo46vl_6a2af9fe28559 [5.8174133300781E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00011086463928223 sec]
Постільна білизна First choice ... Diva (Фьост чойс ... Дівa) - великий вибір, фото, відгуки. Купити Постільна білизна First choice ... Diva в Києві і Україні

DEVELOPMENT🌷ЗНИЖКИ ДО 70%

ПЕРЕЙТИ

Постільна білизна First choice ... Diva

Постільна білизна Задзеркалля pink 101250 бязь-люкс Selena Новинка
Постільна білизна Задзеркалля pink 101250 бязь-люкс Selena
Код: 509154

Виробник: Selena (Украина)

Двоспальний комплект

Двоспальний комплект

Двоспальний євро комплект

Двоспальний євро комплект
Показати більше
Ціна:
864 грн
Постільна білизна Квітковий ранок 300198 сатин Selena - 10 %
Постільна білизна Квітковий ранок 300198 сатин Selena
Код: 430964

Виробник: Selena (Украина)

Двоспальний комплект

Двоспальний комплект
1 312 грн 1 180 грн

Двоспальний євро комплект

Двоспальний євро комплект
1 463 грн 1 317 грн
Показати більше
Ціна:
1 000 грн 1 110 грн
Постільна білизна Soprano Green фланель First choice Хіт продажів
Постільна білизна Soprano Green фланель First choice
Код: 493093
delivary icon

Виробник: First choice (Турция)

Ціна:
3 381 грн
Постільна білизна Лавандовий вечір 100892 бязь-люкс Selena Новинка
Постільна білизна Лавандовий вечір 100892 бязь-люкс Selena
Код: 509142

Виробник: Selena (Украина)

Двоспальний комплект

Двоспальний комплект

Двоспальний євро комплект

Двоспальний євро комплект
Показати більше
Ціна:
864 грн
Постільна білизна First choice VIP Moonlight satin Buhara pudra
Постільна білизна First choice VIP Moonlight satin Buhara pudra
Код: 317377

Виробник: First choice (Турция)

Ціна:
5 292 грн
Комплект постільної білизни Selena Адель 100249
Комплект постільної білизни Selena Адель 100249
Код: 332811
delivary icon

Виробник: Selena (Украина)

Двоспальний комплект

Двоспальний комплект

Двоспальний євро комплект

Двоспальний євро комплект
Показати більше
Ціна:
786 грн
Постільна білизна Rina ранфорс First choice
Постільна білизна Rina ранфорс First choice
Код: 350333

Виробник: First choice (Турция)

Ціна:
2 646 грн
Постільна білизна Leaf сатин 3D First choice
Постільна білизна Leaf сатин 3D First choice
Код: 478820
delivary icon

Виробник: First choice (Турция)

Ціна:
5 733 грн
Постільна білизна VIP сатин 3D Swan pudra First choice Хіт продажів
Постільна білизна VIP сатин 3D Swan pudra First choice
Код: 326269

Виробник: First choice (Турция)

Ціна:
4 082 грн
Однотонна постільна білизна Snazzy Quick Silver сатин-люкс First choice
Однотонна постільна білизна Snazzy Quick Silver сатин-люкс First choice
Код: 404652

Виробник: First choice (Турция)

Полуторний комплект

Полуторний комплект

Сімейний комплект

Сімейний комплект
Ціна:
3 213 грн
Постільна білизна сатин-люкс Advina gri First choice
Постільна білизна сатин-люкс Advina gri First choice
Код: 325983
delivary icon

Виробник: First choice (Турция)

Сімейний комплект

Сімейний комплект
Ціна:
3 906 грн
Постільна білизна Matilde Powder сатин-люкс First choice
Постільна білизна Matilde Powder сатин-люкс First choice
Код: 413487

Виробник: First choice (Турция)

Сімейний комплект

Сімейний комплект
Ціна:
3 906 грн
Постільна білизна Поема кохання 102171 бязь-люкс Selena
Постільна білизна Поема кохання 102171 бязь-люкс Selena
Код: 453182
delivary icon

Виробник: Selena (Украина)

Двоспальний комплект

Двоспальний комплект

Двоспальний євро комплект

Двоспальний євро комплект
Показати більше
Ціна:
864 грн
Постільна білизна Soprano Denim фланель First choice Хіт продажів
Постільна білизна Soprano Denim фланель First choice
Код: 493089
delivary icon

Виробник: First choice (Турция)

Ціна:
3 381 грн
Постільна білизна Милі котики беж 102120 бязь-люкс Selena
Постільна білизна Милі котики беж 102120 бязь-люкс Selena
Код: 440513

Виробник: Selena (Украина)

Двоспальний комплект

Двоспальний комплект

Двоспальний євро комплект

Двоспальний євро комплект
Показати більше
Ціна:
864 грн
Постільна білизна 101217 Ніжні іриси-2 бязь-люкс Selena
Постільна білизна 101217 Ніжні іриси-2 бязь-люкс Selena
Код: 476243

Виробник: Selena (Украина)

Двоспальний комплект

Двоспальний комплект

Двоспальний євро комплект

Двоспальний євро комплект
Показати більше
Ціна:
859 грн
Постільна білизна Новорічні кошенята 102803 бязь-люкс Selena
Постільна білизна Новорічні кошенята 102803 бязь-люкс Selena
Код: 467569
delivary icon

Виробник: Selena (Украина)

Двоспальний комплект

Двоспальний комплект

Двоспальний євро комплект

Двоспальний євро комплект
Показати більше
Ціна:
907 грн
Постільна білизна First choice жаккард Athena kahve
Постільна білизна First choice жаккард Athena kahve
Код: 286161

Виробник: First choice (Турция)

Сімейний комплект

Сімейний комплект
Ціна:
4 284 грн
Постільна білизна First choice сатин-люкс Neva sampanya
Постільна білизна First choice сатин-люкс Neva sampanya
Код: 317174
delivary icon

Виробник: First choice (Турция)

Сімейний комплект

Сімейний комплект
Ціна:
3 906 грн
Постільна білизна Doreta Soil жакард First choice
Постільна білизна Doreta Soil жакард First choice
Код: 434693

Виробник: First choice (Турция)

Ціна:
4 284 грн
Постільна білизна First choice жаккард Lamone krem
Постільна білизна First choice жаккард Lamone krem
Код: 319491

Виробник: First choice (Турция)

Полуторний комплект

Полуторний комплект

Сімейний комплект

Сімейний комплект
Ціна:
3 276 грн
Постільна білизна First choice жаккард Lamone gri
Постільна білизна First choice жаккард Lamone gri
Код: 286234
delivary icon

Виробник: First choice (Турция)

Полуторний комплект

Полуторний комплект

Сімейний комплект

Сімейний комплект
Ціна:
3 276 грн
Комплект постільної білизни бязь люкс Selena Зоряний полосатик 100381
Комплект постільної білизни бязь люкс Selena Зоряний полосатик 100381
Код: 345944
delivary icon

Виробник: Selena (Украина)

Двоспальний комплект

Двоспальний комплект

Двоспальний євро комплект

Двоспальний євро комплект
Показати більше
Ціна:
864 грн
Постільна білизна Орхідея 600171 полікоттон Selena
Постільна білизна Орхідея 600171 полікоттон Selena
Код: 434461
delivary icon

Виробник: Selena (Украина)

Двоспальний комплект

Двоспальний комплект

Двоспальний євро комплект

Двоспальний євро комплект
Показати більше
Ціна:
484 грн
Постільна білизна Пандочки беж 102143 бязь-люкс Selena
Постільна білизна Пандочки беж 102143 бязь-люкс Selena
Код: 444026

Виробник: Selena (Украина)

Двоспальний комплект

Двоспальний комплект

Двоспальний євро комплект

Двоспальний євро комплект
Показати більше
Ціна:
864 грн
Постільна білизна Soprano Grey фланель First choice
Постільна білизна Soprano Grey фланель First choice
Код: 493092
delivary icon

Виробник: First choice (Турция)

Сімейний комплект

Сімейний комплект
Ціна:
3 381 грн
Постільна білизна Веселі каченята 101454 бязь-люкс Selena
Постільна білизна Веселі каченята 101454 бязь-люкс Selena
Код: 497798

Виробник: Selena (Украина)

Двоспальний комплект

Двоспальний комплект

Двоспальний євро комплект

Двоспальний євро комплект
Показати більше
Ціна:
864 грн
Постільна білизна із жаккарду First choice Boris Dried
Постільна білизна із жаккарду First choice Boris Dried
Код: 448647
delivary icon

Виробник: First choice (Турция)

Ціна:
4 284 грн
Постільна білизна First choice ранфорс Snowfall
Постільна білизна First choice ранфорс Snowfall
Код: 193604

Виробник: First choice (Турция)

Ціна:
2 646 грн
Постільна білизна Happiness Green фланель First choice
Постільна білизна Happiness Green фланель First choice
Код: 427620

Виробник: First choice (Турция)

Ціна:
2 835 грн
Постільна білизна Chance turquoise ранфорс First choice
Постільна білизна Chance turquoise ранфорс First choice
Код: 350287

Виробник: First choice (Турция)

Ціна:
2 646 грн
Однотонна постільна білизна сатин-люкс Snazzy fume First choice
Однотонна постільна білизна сатин-люкс Snazzy fume First choice
Код: 330682

Виробник: First choice (Турция)

Сімейний комплект

Сімейний комплект
Ціна:
3 906 грн
1 2 3 4 5 6 7 8 9 10