02 КОБАЛЬТ

select citygeoip.city_id, city.cityregion_id, city.city, city.state, city.region , (select concat_ws('|',trim(citycoord.x),trim(citycoord.y)) from citycoord where citycoord.type=0 and citycoord.city_id=city.row_id limit 1) from citygeoip, city where citygeoip.ipstart<=INET_ATON('54.162.133.222') and INET_ATON('54.162.133.222')<=citygeoip.ipend and city.row_id=citygeoip.city_id: 0.000101 секунд
Время:0.0043220520019531

select cityregion_id from domain where domain.domain='xn----gtbngkdhccofna1r.xn--p1ai' or domain.punycode='xn----gtbngkdhccofna1r.xn--p1ai': 0.000062 секунд
Время:0.0044281482696533

select row_id, min(cityregion_id), techdomain, techdomain_gtm from domain where del=0 and techdomain<>'' and techdomain_gtm<>'' group by techdomain: 0.000060 секунд
Время:0.0045089721679688

select domain.cityregion_id from domain, city,cityokrug where domain.row_id=cityokrug.domain_id and cityokrug.row_id=city.cityokrug_id and city.row_id=0: 0.000058 секунд
Время:0.0045990943908691

select name, punycode, flroznica, row_id, minzakaz,domain,name2,yandexcounter,yandexkey,gtm,pref from domain where cityregion_id=0: 0.000067 секунд
Время:0.0046839714050293

select row_id, name, CURDATE(), NOW(), DATE_FORMAT(NOW(), '%H') from store where city_id=2: 0.000257 секунд
Время:0.0050079822540283

select row_id, urlr from razdel where del=0 and urlr<>'' order by lev: 0.000139 секунд
Время:0.0053009986877441

select row_id, url from razdel where del=0 and url<>'': 0.000063 секунд
Время:0.0057649612426758

select row_id, urlr from partner where del=0 and urlr<>'': 0.000071 секунд
Время:0.0059950351715088

select row_id, urlr from article where del=0 and urlr<>'': 0.000060 секунд
Время:0.0061049461364746

select row_id, urlr from menu where del=0 and urlr<>'': 0.000062 секунд
Время:0.0061919689178467

select row_id, url from menu where del=0 and url<>'': 0.000060 секунд
Время:0.0062899589538574

select r0_id,r1_id,r2_id,r3_id,r4_id,r5_id from razdel where row_id=3352: 0.000065 секунд
Время:0.0071530342102051

select razdel.razdel_id, razdel.name, razdel.text, razdel.keywords, razdel.lev, 0+razdel.flsublevel, row_id, razdel.del from razdel where razdel.row_id=3352 : 0.000066 секунд
Время:0.0073199272155762

select row_id, name,name2 from postoperation: 0.000070 секунд
Время:0.0074529647827148

select Title, Description, Keywords, Tel, Fraza, Niz, name, pref from cfg where domain_id=8: 0.000062 секунд
Время:0.0075531005859375

select razdel.razdel_id, razdel.name, razdel.text, razdel.keywords, razdel.lev, 0+razdel.flsublevel, row_id, razdel.del , (select base.row_id from base where base.del=0 and base.razdel_id=3352 limit 1) , razdel.countbase ,r0_id,r1_id,r2_id,r3_id,r4_id,r5_id , razdel.grouptitle , razdel.groupdescription , razdel.tovartitle , razdel.tovardescription , razdel.tovarcol , razdel.filterdiametrname , razdel.filterdlinaname , razdel.filtergpname , razdel.filter4 , razdel.filter5 , razdel.filter6 from razdel where razdel.del<>1 and razdel.row_id=3352 : 0.000408 секунд
Время:0.0080029964447021

select row_id, flcard from zak where zak.del=0 and exists (select * from zakData where zakData.Del=0 and zakData.zak_id=zak.row_id) and zak.user_id=0 order by zak.row_id desc: 0.000068 секунд
Время:0.0081250667572021

select count(zak.row_id), zak.row_id from zak, zakStatus, zakData where zakData.del=0 and zakData.zak_ID=zak.Row_ID and zakStatus.row_id=1 and zak.del=0 and zak.zakStatus_id=zakStatus.row_id and zak.user_id=0 group by zak.row_id: 0.000058 секунд
Время:0.0082199573516846

select r0_id, r1_id, r2_id, r3_id, r4_id, r5_id, row_id, name, text from razdel where razdel.del<>1 and razdel_id=0 order by razdel.rating desc, razdel.name: 0.000123 секунд
Время:0.0084190368652344

select count(zak.row_id), zak.row_id from zak, zakStatus, zakData where zakData.del=0 and zakData.zak_ID=zak.Row_ID and zakStatus.row_id=1 and zak.del=0 and zak.zakStatus_id=zakStatus.row_id and zak.user_id=0 group by zak.row_id: 0.000059 секунд
Время:0.0087699890136719

SELECT Row_ID, Name FROM menu WHERE del=0 and hidden=0 order by prior: 0.000059 секунд
Время:0.0088751316070557

select count(zak.row_id), zak.row_id from zak, zakStatus, zakData where zakData.del=0 and zakData.zak_ID=zak.Row_ID and zakStatus.row_id=1 and zak.del=0 and zak.zakStatus_id=zakStatus.row_id and zak.user_id=0 group by zak.row_id: 0.000070 секунд
Время:0.01269793510437

select r0_id, r1_id, r2_id, r3_id, r4_id, r5_id, row_id, name, text from razdel where razdel.del<>1 and razdel_id=0 order by razdel.rating desc, razdel.name: 0.000070 секунд
Время:0.012814044952393

select razdel.razdel_id, razdel.name, razdel.text, (select group_concat(concat(a.row_id,'-',a.Pos) order by Pos separator '|') from article a where a.Pos<>-1 and a.del=0 and a.razdel_id=razdel.row_id) from razdel where razdel.del<>1 and razdel.row_id=3352: 0.000065 секунд
Время:0.013221025466919

select razdel.razdel_id, razdel.name, razdel.text, (select group_concat(concat(a.row_id,'-',a.Pos) order by Pos separator '|') from article a where a.Pos<>-1 and a.del=0 and a.razdel_id=razdel.row_id) from razdel where razdel.del<>1 and razdel.row_id=1814: 0.000059 секунд
Время:0.013306140899658

select razdel.razdel_id, razdel.name, razdel.text, (select group_concat(concat(a.row_id,'-',a.Pos) order by Pos separator '|') from article a where a.Pos<>-1 and a.del=0 and a.razdel_id=razdel.row_id) from razdel where razdel.del<>1 and razdel.row_id=1799: 0.000060 секунд
Время:0.013389110565186

select razdel.razdel_id, razdel.name, razdel.text, (select group_concat(concat(a.row_id,'-',a.Pos) order by Pos separator '|') from article a where a.Pos<>-1 and a.del=0 and a.razdel_id=razdel.row_id) from razdel where razdel.del<>1 and razdel.row_id=1789: 0.000060 секунд
Время:0.013471126556396

select razdel.razdel_id, razdel.name, razdel.text, (select group_concat(concat(a.row_id,'-',a.Pos) order by Pos separator '|') from article a where a.Pos<>-1 and a.del=0 and a.razdel_id=razdel.row_id) from razdel where razdel.del<>1 and razdel.row_id=3285: 0.000060 секунд
Время:0.013556003570557

select r0_id, r1_id, r2_id, r3_id, r4_id, r5_id, row_id, 0+flsublevel, lev, razdel_id from razdel where razdel.del<>1 and row_id=3352 : 0.000062 секунд
Время:0.013775110244751

select razdel.row_id, razdel.name, razdel.text, razdel.razdel_id, razdel.countbase from razdel where razdel.del<>1 and razdel.r0_id=3285 and razdel.row_id<>3285 order by razdel.lev,razdel.rating desc, razdel.name: 0.000207 секунд
Время:0.014017105102539

select min(case when exists (select * from razdelpricetype where razdelpricetype.razdel_id=base.razdel_id and razdelpricetype.domain_id=8) then (select f.price from baseprice f, razdelpricetype where razdelpricetype.razdel_id=base.razdel_id and razdelpricetype.domain_id=8 and f.del=0 and f.base_id=base.row_id and f.pricetype_id=razdelpricetype.pricetype_id limit 1) else (select f.price from baseprice f where f.del=0 and f.base_id=base.row_id and f.pricetype_id=4 limit 1) end), max(case when exists (select * from razdelpricetype where razdelpricetype.razdel_id=base.razdel_id and razdelpricetype.domain_id=8) then (select f.price from baseprice f, razdelpricetype where razdelpricetype.razdel_id=base.razdel_id and razdelpricetype.domain_id=8 and f.del=0 and f.base_id=base.row_id and f.pricetype_id=razdelpricetype.pricetype_id limit 1) else (select f.price from baseprice f where f.del=0 and f.base_id=base.row_id and f.pricetype_id=4 limit 1) end) from prop, baseprop, base, propvalue, razdelprop where baseprop.del=0 and baseprop.base_id=base.row_id and base.del=0 and baseprop.propvalue_id=propvalue.row_id and propvalue.prop_id=prop.row_id and base.fr4_id=3352 and razdelprop.razdel_id=3352 and razdelprop.prop_id=baseprop.prop_id and prop.flleft=1: 0.003453 секунд
Время:0.019813060760498

select prop.row_id, prop.title, prop.null, propvalue.row_id as id2, propvalue.name ,(select CONCAT_WS('/',photocol.path, photo.fileName) from photo, photocol where photocol.row_id=photo.photocol_id and photo.row_id=propvalue.photo_id limit 1) as photo , propvalue.name2 ,prop.type ,max(9) as act ,prop.name ,0 , case when prop.type=5 then razdelprop.count/2 when prop.type=9 then razdelprop.count/3 else razdelprop.count end as kol ,razdel.countbase ,razdelprop.countzn ,prop.ed ,prop.col ,razdelprop.count from prop, baseprop, base, propvalue, razdelprop,razdel where baseprop.del=0 and baseprop.base_id=base.row_id and base.del=0 and baseprop.propvalue_id=propvalue.row_id and propvalue.prop_id=prop.row_id and base.fr4_id=3352 and razdelprop.razdel_id=3352 and razdelprop.prop_id=baseprop.prop_id and razdel.row_id=razdelprop.razdel_id and prop.flleft=1 group by prop.row_id, propvalue.row_id order by kol desc, propvalue.zn0, propvalue.name : 0.002090 секунд
Время:0.021976947784424

select banner.row_id ,(select CONCAT_WS('/',photocol.path, photo.fileName) from photo, photocol where photocol.row_id=photo.photocol_id and photo.row_id=banner.photo_id limit 1) ,banner.title ,case when razdel.r4_id=3352 then 0 else 1 end as prior ,razdel.r0_id,razdel.r1_id,razdel.r2_id,razdel.r3_id,razdel.r4_id,razdel.r5_id from banner,razdel where banner.razdel_id=razdel.row_id and banner.bannertype_id=3 and banner.del=0 order by prior, rand() limit 1: 0.000414 секунд
Время:0.0228271484375

select razdel.row_id, razdel.name, razdel.text from razdel where razdel.del<>1 and razdel.row_id=3352 : 0.000145 секунд
Время:0.023088932037354

select razdel.row_id, razdel.name from razdel where razdel.del<>1 and razdel.razdel_id=3352 : 0.000313 секунд
Время:0.02342700958252

select row_id from article where del=0 and pos=-1 and razdel_id=3352: 0.000060 секунд
Время:0.023622035980225

select prop.row_id, prop.title, prop.null, propvalue.row_id, propvalue.name, prop.name ,case when baseprop.prior<10 then prop.row_id else prop.row_id*100 end as sort from prop, baseprop, base, propvalue where prop.type<>9 and baseprop.del=0 and baseprop.base_id=base.row_id and baseprop.propvalue_id=propvalue.row_id and propvalue.prop_id=prop.row_id and base.del=0 and flroznica=0 and base.fr4_id=3352 and prop.flleft=1 group by prop.row_id, propvalue.row_id order by sort, prop.row_id, propvalue.name: 0.001506 секунд
Время:0.025166034698486

select razdel.svod, razdel.name, razdel.text , razdel.filterdiametrname , razdel.filterdlinaname , razdel.filtergpname , razdel.filter4 , razdel.filter5 , razdel.filter6 , razdel.lev from razdel where razdel.row_id=3352: 0.000071 секунд
Время:0.025298118591309

select base.row_id , base.namefull , case when exists (select * from razdelpricetype where razdelpricetype.razdel_id=base.razdel_id and razdelpricetype.domain_id=8) then (select f.price from baseprice f, razdelpricetype where razdelpricetype.razdel_id=base.razdel_id and razdelpricetype.domain_id=8 and f.del=0 and f.base_id=base.row_id and f.pricetype_id=razdelpricetype.pricetype_id limit 1) else (select f.price from baseprice f where f.del=0 and f.base_id=base.row_id and f.pricetype_id=4 limit 1) end , base.photo , base.ed , (select sum(o.count) from basecount o, pricestype where o.pricestype_id=pricestype.row_id and pricestype.city_id=2 and o.base_id=base.row_id and o.del=0) , base.diameter , base.length , base.lifting , base.kpereshetaed , base.kpereshet , (select r.filterdiametrname from razdel r where r.row_id=base.razdel_id limit 1) as diamn , base.text , (select r.filterdlinaname from razdel r where r.row_id=base.razdel_id limit 1) as dlina , (select r.filtergpname from razdel r where r.row_id=base.razdel_id limit 1) as gp , base.root_id , base.flfas , (select sum(o.count) from basecount o, pricestype where o.pricestype_id=pricestype.row_id and pricestype.city_id=2 and o.del=0 and o.base_id=base.root_id) , base.filter4 , base.filter5 , (select r.filter4 from razdel r where r.row_id=base.razdel_id limit 1) , (select r.filter5 from razdel r where r.row_id=base.razdel_id limit 1) , base.weight , base.fr0_id , (select r.filter6 from razdel r where r.row_id=base.razdel_id limit 1) , base.filter6 , (select sum(o.count) from basecount o, pricestype where o.pricestype_id=pricestype.row_id and pricestype.city_id<>2 and o.base_id=base.row_id and o.del=0) , (select sum(o.count) from basecount o, pricestype where o.pricestype_id=pricestype.row_id and pricestype.city_id<>2 and o.base_id=base.root_id and o.del=0) , (select sum(o.count) from basecount o, pricestype where o.pricestype_id=pricestype.row_id and o.base_id=base.row_id and o.del=0) , (select sum(o.count) from basecount o, pricestype where o.pricestype_id=pricestype.row_id and o.base_id=base.root_id and o.del=0) , (select sum(zakData.kol) from zak, zakStatus, zakData, base b where b.row_id=base.row_id and b.row_id=zakData.base_id and zakData.del=0 and zakData.zak_ID=zak.Row_ID and zakStatus.row_id=1 and zak.del=0 and zak.zakStatus_id=zakStatus.row_id and zak.user_id=0 group by b.row_id) , base.fr1_id , base.fr2_id , case when exists (select * from razdelpricetype where razdelpricetype.razdel_id=base.razdel_id and razdelpricetype.domain_id=8) then (select f.priceold from baseprice f, razdelpricetype where razdelpricetype.razdel_id=base.razdel_id and razdelpricetype.domain_id=8 and f.del=0 and f.base_id=base.row_id and f.pricetype_id=razdelpricetype.pricetype_id limit 1) else (select f.priceold from baseprice f where f.del=0 and f.base_id=base.row_id and f.pricetype_id=4 limit 1) end , base.rating , base.flnew , base.fr3_id , base.fr4_id , base.fr5_id , (select group_concat(concat(city.city,':',o.count)) from basecount o, pricestype, city where pricestype.city_id=city.row_id and o.count>0 and o.pricestype_id=pricestype.row_id and o.base_id=base.row_id and o.del=0) , (select group_concat(concat(city.city,':',o.count)) from basecount o, pricestype, city where pricestype.city_id=city.row_id and o.count>0 and o.pricestype_id=pricestype.row_id and o.base_id=base.root_id and o.del=0) , base.edosn , base.edosnkf , base.bwidth , base.bheight , base.blength , base.flneproizvod , case when exists (select * from razdelpricetype where razdelpricetype.razdel_id=base.razdel_id and razdelpricetype.domain_id=8) then (select f.pricenac from baseprice f, razdelpricetype where razdelpricetype.razdel_id=base.razdel_id and razdelpricetype.domain_id=8 and f.del=0 and f.base_id=base.row_id and f.pricetype_id=razdelpricetype.pricetype_id limit 1) else (select f.pricenac from baseprice f where f.del=0 and f.base_id=base.row_id and f.pricetype_id=4 limit 1) end , (select CONCAT_WS('/',photocol.path, photo.fileName) from basephoto, photo, photocol where basephoto.base_id=base.row_id and photocol.row_id=photo.photocol_id and basephoto.del=0 and photo.photocol_id=74 and basephoto.photo_id=photo.row_id limit 1) , (select CONCAT_WS('/',photocol.path, photo.fileName) from basephoto, photo, photocol where basephoto.base_id=base.row_id and photocol.row_id=photo.photocol_id and basephoto.del=0 and photo.photocol_id=75 and basephoto.photo_id=photo.row_id limit 1) , '' , (select baseprice.price from baseprice where baseprice.del=0 and baseprice.base_id=base.row_id and baseprice.pricetype_id=33 and baseprice.price>0 limit 1) as raspr , (select baseprice.pricenac from baseprice where baseprice.del=0 and baseprice.base_id=base.row_id and baseprice.pricetype_id=33 and baseprice.price>0 limit 1) from base where base.del=0 and flroznica=0 and base.fr4_id=3352 order by CAST(base.diameter AS DECIMAL(10,2)),CAST(base.lifting AS DECIMAL(10,2)), CAST(base.length AS DECIMAL(10,2)), base.namefull limit 0,141: 0.010557 секунд
Время:0.035916090011597

select domainlink.link, domainlinktype.name ,(select CONCAT_WS('/',photocol.path, photo.fileName) from photo, photocol where photocol.row_id=photo.photocol_id and photo.row_id=domainlinktype.photo_id limit 1) from domainlink, domainlinktype where domainlink.del=0 and domainlink.domainlinktype_id=domainlinktype.row_id and domainlinktype.del=0 and domainlink.domain_id=8 order by domainlinktype.pos: 0.000103 секунд
Время:0.042236089706421

select whois_netname_id from whois where whois.ipstart<=INET_ATON('54.162.133.222') and INET_ATON('54.162.133.222')<=whois.ipend: 0.000067 секунд
Время:0.042693138122559