SELECT url_to, r404
FROM pod_redirect
WHERE BINARY REPLACE(url_from,'/ru/','/') = '/postelnoe_bele/vyrez.html' LIMIT 0,1 [0.00024104118347168 sec]
SELECT cf.metaindex, cf.metafollow FROM pod_set_cat_filter cf
INNER JOIN pod_filter f ON cf.filter_value_id = f.id
INNER JOIN pod_cat_category c ON cf.cat_id = c.id
WHERE f.url = 'vyrez'
AND c.url = 'postelnoe_bele'
AND cf.is_active = 1
LIMIT 1 [0.00052499771118164 sec]
SELECT cf.metaindex, cf.metafollow FROM pod_set_cat_subicon cf
INNER JOIN pod_sub_icon si ON cf.subicon_id = si.id
INNER JOIN pod_cat_category c ON cf.cat_id = c.id
WHERE si.url = 'vyrez'
AND c.url = 'postelnoe_bele'
AND cf.is_active = 1
LIMIT 1 [0.0003819465637207 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.0002291202545166 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.70361495018005 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.00037002563476562 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.3899450302124 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
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (2659)
WHERE 1
[0.012542009353638 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2fc6eec243f (
id INT,
gid INT,
INDEX idx_id (id),
INDEX idx_gid (gid)
) [0.0004119873046875 sec]
INSERT INTO temp_brand_counts_6a2fc6eec243f (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
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (2659)
WHERE 1
[0.024157047271729 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_6a2fc6eec243f
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.0016257762908936 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2fc6eec243f [0.0001990795135498 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
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (2659)
WHERE 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
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (2659)
WHERE 1
) A
[0.088747978210449 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 <= '14311',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 <= '14311',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 <= '14311'
WHERE g.id IN (7545,34696,128012,129334,153693,154258,155066,155686,163721,163724,175645,180337,182931,186756,187284,188230,200571,201608,212869,227352,237974,238127,253095,253097,253104,253105,253113,253115,253207,253216,262588,262589,262591,262592,266520,266521,266524,266626,266630,266633,266641,266642,266715,266716,266717,266718,266719,266721,266722,266723,266724,266725,266726,266727,266728,269752,269755,269758,269761,269764,269767,269770,269774,269778,269782,269786,269790,270101,270104,270107,270111,270115,270118,270461,270464,271642,271643,271648,271650,271651,271653,271654,271655,271656,271657,271658,271659,271660,271661,271662,271663,271664,271665,271666,271667,271668,271669,271670,271671,271672,271673,271674,271675,271676,271678,271679,271681,271682,271684,271685,271686,271687,271688,271689,271690,271691,271692,271693,271694,271695,271696,271697,271699,271700,271701,271702,271703,271704,271705,271706,271707,271708,271860,271866,271867,271873,272160,272164,272167,272168,272170,272171,272172,272179,272180,272181,272182,272309,272311,272313,272314,272315,272316,272861,272868,272874,272875,272882,272885,274067,274074,274077,274079,275083,277850,277854,277863,277868,277901,282819,284206,284209,284213,284216,284218,284222,284224,284227,284230,284236,284240,284243,284246,284249,284252,284253,284254,288645,288648,288649,288654,288657,293699,293702,293705,293706,293709,298859,299259,299261,299605,299616,299617,299749,299752,299756,299759,299763,299773,299847,299875,299876,299877,300264,302795,308630,308635,313629,313638,313644,313646,313648,317761,317768,317771,319305,319315,322666,322681,322700,324267,324285,324713,328095,329489,332335,332614,332616,332617,332622,332632,332635,332638,332641,332646,332651,332654,332657,332660,332663,332668,332671,332674,332677,332680,332714,332717,332720,332724,332734,332738,332742,332745,332748,332751,332754,332757,332760,332763,332766,332769,332773,332776,332779,332783,332789,332792,332796,332799,332811,332815,332819,332827,332831,332835,332839,332843,332847,332851,332872,332880,332888,332892,332896,332910,332911,332917,332925,332929,332933,332936,332958,332962,332967,333015,333100,333136,333144,333152,333156,333160,333164,333176,333185,333186,333189,333190,333195,333207,333231,333243,333335,333339,333351,333359,333367,333371,333404,333432,334574,334577,334585,334592,334598,334602,335480,335491,335496,335502,335505,335506,335508,335549,335551,335555,335557,335564,335566,335568,335576,335586,335590,335591,335596,335619,335620,335622,335623,335625,335627,335629,335639,335678,335682,335693,335697,335701,335705,335707,335721,335776,335778,335781,335783,335787,335792,335793,335794,335795,335807,335810,335881,335882,335887,335888,335894,335896,335898,335900,335905,335912,335914,335917,336743,336771,336776,336793,336888,336890,336896,336907,336909,336923,336927,337547,337549,337671,337672,338012,338014,338031,338960,338961,338962,338966,338969,338972,338982,339409,340744,341419,341422,341426,341431,341435,341439,341447,341451,341454,341459,341462,341856,343266,343274,343283,343287,343291,343295,343299,344848,344868,344884,344896,344914,344918,345842,345848,345851,345886,345892,345899,345911,345944,345951,345961,345973,346371,346388,346394,348221,348225,348229,348233,348237,348241,348245,348249,348253,348257,348261,348265,348269,348273,348277,348281,348285,348290,348294,348298,348365,348369,348373,348377,348381,348385,348389,348393,348397,348401,348405,348409,348413,348417,348421,348425,348429,348434,348438,348442,348453,348457,348461,348466,348580,348584,348588,348592,348596,348600,348604,348608,348612,348616,348620,348624,348628,348632,348636,348704,348722,349078,349082,349086,349090,349094,349098,349102,349108,349113,349117,349121,349125,349129,349133,349149,349153,349157,349161,349165,349350,349355,349359,349363,349367,349371,349375,349379,349383,349388,349424,349429,349437,349442,349447,349455,349459,349462,349490,349491,349499,349511,349519,349523,349547,349551,349555,349559,349562,349565,349709,349713,349721,349725,349729,349733,349737,349741,349749,349757,349761,349765,349769,349836,349844,349845,349846,349850,349852,349901,349944,351624,360597,360599,363706,363710,363714,363718,363722,363726,363730,363734,363738,363742,363746,363754,363758,363762,364759,364772,364782,364801,364806,364808,364812,364816,366851,367066,367532,367544,367550,367553,367557,367560,367564,367567,367581,367588,367591,367592,367595,367598,367603,367606,367611,367614,367618,367784,367788,367794,367797,367800,367803,367806,367811,367814,367817,367820,367823,367826,367829,367844,367853,367856,367859,367862,367865,367869,367872,372438,374181,374236,375010,375158,375383,375479,376173,376501,376510,377098,377719,380739,380829,380830,381237,381238,384110,385341,385345,385349,385353,385357,385361,385365,385369,385373,385377,385384,385388,385392,385396,385400,385404,385408,385412,385416,385420,385424,385428,385432,385436,385440,385444,385448,385452,385456,388201,388206,391921,391925,391929,391933,391937,391941,391945,391949,391953,391958,391962,392019,392021,392024,392040,392041,400197,400215,400250,402619,402705,402843,402847,404553,404557,404689,404693,404697,404701,404705,406393,406394,406395,406396,406397,406433,406436,406437,407119,407259,407263,407267,407271,407275,407279,407283,407287,407291,407295,407299,407303,407307,408065,408119,408120,408121,408128,408129,408130,408131,408132,408145,408146,408151,408152,408153,408196,408197,408201,409053,409054,409055,409224,409225,409226,409227,409228,409229,409231,409232,409233,409234,409235,409236,409237,409238,409241,409370,409371,409446,409506,409510,409514,409518,409522,409526,409530,410720,410724,410728,410732,411326,411332,411351,411358,411362,411366,411372,411376,411380,411384,411396,411399,411402,411405,411778,411781,411782,411783,411799,413423,413427,413431,413435,413439,413443,413447,415031,418409,418445,418503,418505,418509,418517,418525,418535,418539,418553,418696,419804,419805,420100,420101,422465,422987,422988,422989,422990,423089,423095,423096,423097,423100,423101,423103,423136,423137,423139,423141,423142,423144,423145,423527,423540,425299,425311,425376,425429,425433,425437,425823,425909,425910,425911,426445,430302,430321,430342,430344,430349,430353,430357,430361,430393,430398,430399,430403,430405,430411,430622,430623,430624,430626,430627,430629,430632,430633,430636,430640,430644,430646,430648,430651,430655,430657,430659,430660,430734,430738,430742,430746,430750,430754,430758,430762,430766,430770,430774,430778,430782,430786,430790,430794,430798,430799,430801,430802,430803,430804,430805,430809,430812,430813,430814,430816,430940,430941,430942,430943,430947,430951,430955,430959,430960,430964,430968,430972,430976,430980,430984,430988,430992,430996,431000,431004,431008,431012,431016,431020,431024,431028,431032,431235,431239,431240,431244,431246,431250,431254,431258,431262,431266,431270,431274,431278,431282,431286,431290,431294,431298,431302,431306,431310,431314,431318,431322,431326,431367,431371,431375,431379,431383,431387,431391,431395,431399,431403,431407,431411,431415,431419,431420,431424,431428,431430,431434,431438,431442,431446,431450,431454,432097,432101,432105,432109,432113,432118,432138,432142,432146,432246,432247,432248,432249,432250,432254,432258,432262,432388,432391,432392,432394,432396,432400,432404,432408,432412,432416,432420,432424,432519,432523,432527,432531,432535,432539,432543,432547,432550,432554,432660,432664,432668,432672,432676,432680,432684,432688,432692,432696,432700,432704,432708,432712,432716,432720,432724,432728,432732,432736,432740,433020,433022,433024,433029,433088,433092,433101,433109,433125,434057,434061,434065,434069,434073,434077,434093,434097,434101,434105,434109,434113,434117,434121,434125,434129,434130,434134,434140,434144,434148,434152,434156,434160,434172,434176,434180,434184,434188,434192,434196,434200,434204,434208,434212,434216,434220,434221,434225,434229,434441,434445,434449,434453,434457,434461,434465,434469,434473,434477,434481,434485,434489,434493,434497,434501,434505,434581,434599,434603,434607,434611,434615,434619,434623,434627,434631,434635,434639,434643,434647,434651,434655,434659,434663,434667,434671,434756,434760,434774,434775,434779,434784,434787,434792,435572,435576,435580,435584,435588,435592,435596,435600,435604,435608,435612,435616,435620,435624,435628,435632,435636,435640,435689,435694,435695,435697,435700,435702,435703,435707,435708,435709,435713,435795,435799,435803,435807,435811,435827,435831,435835,435874,435878,435882,435886,435891,435895,435897,435901,435902,435904,435909,435913,435914,436029,436033,436037,436041,436045,436046,436048,436052,436056,436060,436062,436067,436070,436076,436083,436102,436240,436242,436243,436244,436245,436246,436248,436249,436251,436252,436253,436257,436259,436270,436271,436272,436275,436277,436279,436281,436283,436888,436889,436890,436891,436892,436895,436896,436897,439085,439089,439093,439097,439145,439149,439153,439177,439181,439185,439189,439193,439197,439954,439958,439962,439966,439970,439974,440207,440211,440215,440219,440223,440227,440280,440284,440288,440292,440501,440505,440509,440513,440517,440686,440690,440694,440698,440702,440706,440710,440714,440718,440724,440935,440939,440943,440947,440951,440955,441329,441333,441337,441341,441345,441365,441826,441873,441877,441881,441885,441894,441896,441897,441898,441899,441900,441901,444002,444006,444010,444014,444018,444022,444026,444208,444215,444222,444229,444243,444250,444257,447010,447014,447016,447020,447022,447026,447028,447032,447033,447037,447038,447594,447598,447602,447606,447610,447614,447618,448220,448395,448399,448403,448407,448408,448412,448413,448417,448421,448425,448716,448720,448724,448728,448732,448733,448737,448738,448742,448746,448750,449196,449200,449204,449208,449212,449216,449616,449630,449637,450307,450314,450317,450319,450320,450357,450361,450363,450367,450369,450373,450375,450379,450381,450385,450759,450760,450761,450762,450763,450765,450766,450767,450768,450769,450775,450781,450787,450793,450799,450805,450811,450823,450829,450835,450841,450847,450853,450865,450871,450875,450879,450883,450887,451423,451427,451431,451435,451439,451443,451447,451452,451459,451657,452676,452680,452684,452688,452692,452696,452700,452704,452708,452712,452718,452722,452726,452732,452736,452738,452742,452748,452752,453169,453173,453174,453178,453182,453186,453190,453194,453198,453202,453206,453210,453216,453220,453225,453599,456396,456400,456401,456405,456406,456410,456414,456418,456419,456423,456424,456428,456429,456433,456434,456438,456439,456443,456447,456973,457929,458591,459059,459063,459067,459071,459075,459079,459084,459341,459419,459423,459427,459431,459435,459443,459448,459470,459474,459479,459485,459499,459532,459536,459547,459593,459595,459597,459598,459600,459606,459608,459610,459996,460000,460005,460009,460013,460017,460021,460025,460961,460965,460969,460973,460977,461085,461089,461093,461097,461101,462317,462321,462325,462329,462333,462337,462341,462345,462349,462353,462515,462519,462523,462527,462531,462535,462539,462543,462547,463499,463830,463967,464055,464058,464074,464079,464084,464092,464094,464098,464101,464119,464122,464126,464129,464132,464135,464139,464186,464190,464194,464198,464202,464676,464680,464684,464688,464692,464696,464701,464706,464710,464714,464719,464723,464728,464732,464736,464741,464746,465700,465704,465708,465712,465717,466241,466245,466249,466253,466257,466458,466462,466466,466470,466474,466478,467248,467252,467253,467257,467261,467265,467269,467273,467277,467454,467474,467478,467482,467486,467490,467494,467561,467565,467569,467573,467577,467581,468063,468068,468491,468495,468499,468503,470469,470473,470477,470481,470605,470608,470615,470619,470622,470634,470636,470638,470642,470646,470650,470657,470661,470669,470671,470675,470677,470684,470730,470736,470739,470742,470745,470746,470753,470754,470755,470756,470757,471437,471442,471572,471576,471578,473415,473419,473423,473427,473431,473435,473439,473443,473447,473451,473455,473459,473515,473519,473523,473527,473531,473535,473546,473600,473606,473610,473673,473677,473681,473685,473783,473792,474298,474302,474306,474310,474314,474318,474321,474326,474336,474348,474352,474356,474366,474378,474382,474521,474525,474526,474530,474534,474538,474542,474546,474550,474554,474558,474562,474566,474570,474571,474572,474576,474580,474584,474588,474592,475282,475286,475288,475290,475293,475311,475315,475319,475323,475327,475335,475337,475340,475344,475348,475356,475360,475364,475366,475374,475378,475382,475388,475393,475394,475395,475396,475451,475484,476227,476231,476235,476239,476243,476247,476251,476255,476680,476684,476688,476692,476696,476700,476745,476749,476750,476754,476755,476759,476760,476764,477004,477009,477161,477162,477163,477164,477166,477167,477168,477170,477171,477525,477606,477607,477656,477660,477664,477668,477672,477676,477680,477888,477892,477896,477900,477904,477908,477912,477916,478359,478610,478614,478618,478622,478626,478630,478634,478638,478642,478646,478650,479009,479010,479011,479012,479014,479015,479016,479017,480063,480067,480069,480073,480074,480078,480082,480086,480090,480220,480223,480224,480225,480226,480309,480310,480311,480695,481805,481809,481811,481815,481817,481821,481822,481826,481827,481831,481914,481917,481923,481927,481933,481940,481944,481947,481951,481955,481959,481963,481967,481968,481971,481975,481979,481983,481987,481991,481995,481999,482005,482008,482042,482046,482050,482054,482058,482091,482092,482093,482102,482190,482342,482347,482533,482866,483043,483048,483053,483057,483059,483068,483073,483077,483082,483085,483090,483092,483096,483098,483100,483103,483122,483124,483129,483131,483135,483137,483138,483140,483145,483147,483155,483159,483165,483168,483171,483174,483176,483179,483182,485224,485232,485236,485244,485256,485267,485271,485274,485278,485281,485285,485289,485292,485383,485390,485550,485554,488465,488466,488467,488470,488471,488474,488475,488478,488480,488483,488486,488489,488491,488493,488496,488499,488504,488507,488510,488513,488516,488517,488518,488519,488520,488521,488522,488523,488524,488525,488527,488542,488543,488935,490400,490418,490436,490454,491261,491265,491269,491273,491274,491278,491340,491460,493417,493421,493425,493429,493433,493437,493441,493445,493449,493452,493456,493460,493465,493467,493468,493475,493481,493482,493483,493694,493705,497027,497030,497034,497056,497058,497063,497065,497069,497070,497082,497091,497096,497098,497141,497147,497159,497163,497272,497276,497280,497604,497609,497614,497623,497631,497639,497646,497652,497661,497666,497671,497676,497696,497708,497774,497778,497782,497786,497790,497794,497798,497802,497942,497948,497954,497960,497973,497979,497984,497989,499279,499280,499281,499282,499283,499284,499285,499287,499288,499289,499290,499291,499440,499443,499449,499452,499455,499458,499462,499466,499469,499474,499492,499510,499511,499512,499513,499518,499639,499643,501380,501384,501388,501392,501396,501399,501402,501405,501408,501411,501414,501424,501430,501487,501488,501489,501511,501512,501513,501514,501515,501516,501517,501518,501639,501640,501667,501668,501714,501716,501866,501874,501911,501912,501920,501921,501938,501939,501940,501941,501944,501947,501982,501983,502035,502036,502037,502044,502046,502049,502064,502069,502071,502124,502211,502212,502220,502245,502248,502251,502264,502265,502266,502269,502272,502275,502278,502312,502313,502314,502344,502345,502369,502423,502427,502431,502439,502441,502442,502443,502446,502468,502496,502497,502503,502506,502507,502515,502521,502524,502525,502528,502539,502602,502624,502740,502741,502989,502990,502994,503019,503035,503036,503037,503038,503039,503458,503512,503522,503524,503535,503536,503537,503728,503729,503731,503733,503734,503735,503739,503740,503741,503742,503743,503747,503750,503751,503752,503758,503762,503764,503766,503767,503770,503772,503839,503937,503938,503939,503951,504475,504479,504483,504487,504491,504495,504499,504521,504927,504933,504941,504947,504953,504959,504982,504988,504995,505147,505150,505153,505156,505159,505162,505254,505258,505263,505265,505271,505275,505280,505301,505939,505947,506680,506683,506686,506690,506693,506696,506909,507110,507115,507120,507132,507139,507146,507153,507164,507171,507658,507659,507660,507666,507668,507676,507682,507687,508839,508844,508849,508854,508856,508860,508862,508866,509138,509142,509146,509150,509154,509383)
GROUP BY g.id
ORDER BY g.ordr desc
LIMIT 0, 32 [0.20574998855591 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 <= '14311',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 <= '14311',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 <= '14311')
WHERE g.id in (497614,497646,502427,502468,502443,497960,505159,473792,497954,497984,502423,509154,419804,481967,430964,493425,509142,503741,505939,497141,497666,502740,502441,502446,502431,497604,485267,497147,480310,332811,420100,501982)
GROUP BY g.id
ORDER BY g.ordr desc [0.012351989746094 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 (497614,497646,502427,502468,502443,497960,505159,473792,497954,497984,502423,509154,419804,481967,430964,493425,503741,505939,509142,497141,497666,502740,502441,502446,502431,332811,420100,480310,485267,497604,497147,501982) AND g.is_present = '1' AND g.is_active = '1'
ORDER BY g.entry, g.is_present DESC [0.0019528865814209 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 (497614,497646,502427,502468,502443,497960,505159,473792,497954,497984,502423,509154,419804,481967,430964,493425,503741,505939,509142,497141,497666,502740,502441,502446,502431,332811,420100,480310,485267,497604,497147,501982)
ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.0099661350250244 sec]
SELECT cf.id,
cf.info_ua AS info,
cf.title_ua AS title,
cf.metadesc_ua AS metadesc,
cf.seo_text_ua AS seo_text,
cf.tagH1_ua AS tagH1,
cf.is_active
FROM pod_set_cat_filter cf
INNER JOIN pod_filter f ON cf.filter_value_id = f.id
WHERE cf.cat_id = 3
AND f.id = '2659' LIMIT 1 [0.00046205520629883 sec]
SELECT cf.id,
cf.info_ua AS info,
cf.title_ua AS title,
cf.metadesc_ua AS metadesc,
cf.seo_text_ua AS seo_text,
cf.tagH1_ua AS tagH1,
cf.is_active
FROM pod_set_cat_subicon cf
INNER JOIN pod_sub_icon f ON cf.subicon_id = f.id
WHERE cf.cat_id = 3
AND f.url = 'vyrez' LIMIT 1 [0.0005497932434082 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef27ad6;
CREATE TEMPORARY TABLE tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef27ad6 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00048398971557617 sec]
INSERT INTO tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef27ad6 (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 (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 gf.filter_id_value NOT IN (2659)
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 = 3 [0.16857695579529 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef27ad6;
CREATE TEMPORARY TABLE tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef27ad6 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.0003199577331543 sec]
INSERT IGNORE INTO tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef27ad6 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef27ad6 p
GROUP BY p.filter_id [0.0013511180877686 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_sllc12amr9f91du5orhiahka84_6a2fc6ef27ad6 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.00038003921508789 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef27ad6 [0.00029301643371582 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef27ad6 [0.00013017654418945 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef51fda;
CREATE TEMPORARY TABLE tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef51fda (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00017094612121582 sec]
INSERT INTO tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef51fda (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 (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 gf.filter_id_value NOT IN (2659)
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 = 3 [0.047890901565552 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef51fda;
CREATE TEMPORARY TABLE tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef51fda (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.0003049373626709 sec]
INSERT IGNORE INTO tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef51fda (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef51fda p
GROUP BY p.filter_id [0.00049805641174316 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_sllc12amr9f91du5orhiahka84_6a2fc6ef51fda 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.00025606155395508 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef51fda [0.00025486946105957 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef51fda [0.0001070499420166 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef5e724;
CREATE TEMPORARY TABLE tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef5e724 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00018000602722168 sec]
INSERT INTO tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef5e724 (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 (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 gf.filter_id = 1077
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 = 3 [0.014314889907837 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef5e724;
CREATE TEMPORARY TABLE tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef5e724 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00032210350036621 sec]
INSERT INTO tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef5e724 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef5e724 p
GROUP BY p.filter_id [0.00058197975158691 sec]
INSERT IGNORE INTO tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef5e724 (filter_id, count)
SELECT pf.id, 0
FROM pod_filter pf
LEFT JOIN tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef5e724 c ON c.filter_id = pf.id
WHERE pf.id in (2659) AND c.filter_id IS NULL [0.00023198127746582 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_sllc12amr9f91du5orhiahka84_6a2fc6ef5e724 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.00027298927307129 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_sllc12amr9f91du5orhiahka84_6a2fc6ef5e724 [0.00027918815612793 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef5e724 [0.00018811225891113 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_sllc12amr9f91du5orhiahka84_6a2fc6ef62f86;
CREATE TEMPORARY TABLE tmp_A_sllc12amr9f91du5orhiahka84_6a2fc6ef62f86 (
entry INT NOT NULL,
sub_icon_id INT NOT NULL,
PRIMARY KEY (entry, sub_icon_id),
INDEX idx_sub_icon_id (sub_icon_id)
) ENGINE=MEMORY; [0.00022506713867188 sec]
INSERT IGNORE INTO tmp_A_sllc12amr9f91du5orhiahka84_6a2fc6ef62f86 (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
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (2659)
WHERE 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
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (2659)
WHERE 1
) A [0.077967166900635 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef62f86;
CREATE TEMPORARY TABLE tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef62f86 (
sub_icon_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00045514106750488 sec]
INSERT IGNORE INTO tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef62f86 (sub_icon_id, count)
SELECT
sub_icon_id,
COUNT(DISTINCT entry) AS count
FROM (
SELECT A.entry, A.sub_icon_id
FROM tmp_A_sllc12amr9f91du5orhiahka84_6a2fc6ef62f86 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.0020129680633545 sec]
SELECT
c.sub_icon_id AS id,
c.count,
si.entry,
si.name_ua AS name,
si.url
FROM tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef62f86 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.00031280517578125 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_sllc12amr9f91du5orhiahka84_6a2fc6ef62f86 [0.00023818016052246 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sllc12amr9f91du5orhiahka84_6a2fc6ef62f86 [9.8943710327148E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods;
DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00016307830810547 sec]
Постільну білизну виріз купити в Києві з доставкою по Україні ⭐️ Podushka
Ваше замовлення оформлено! На e-mail відправлено лист з підтвердженням Найближчим часом з Вами зв'яжеться менеджер Дякємо за замовлення!
Ваш профіль буде видалений назавжди. Його не можна відновити. Продовжити?
Залиште свій номер телефону і наші менеджери Вам зателефонують
Оплату картами Visa і MasterCard забезпечує сервіс онлайн-платежів Portmone.com. Безпека оплати підтверджена міжнародним аудитом PCI DSS. Служба підтримки: тел. +380 (44) 2000902