Вертлюги

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.000089 секунд
Время:0.0041191577911377

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

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

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.000054 секунд
Время:0.004371166229248

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

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

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

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

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

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

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

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

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

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=3071 : 0.000062 секунд
Время:0.0066230297088623

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

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

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=3071 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=3071 : 0.000424 секунд
Время:0.0072979927062988

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.000069 секунд
Время:0.0074551105499268

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.0075511932373047

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.000072 секунд
Время:0.0076961517333984

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.0080461502075195

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

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.000072 секунд
Время:0.011964082717896

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.000071 секунд
Время:0.012083053588867

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=3071: 0.000065 секунд
Время:0.012488126754761

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=2886: 0.000061 секунд
Время:0.012574195861816

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=3287: 0.000061 секунд
Время:0.012659072875977

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=3071 : 0.000061 секунд
Время:0.012825965881348

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

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.fr2_id=3071 and razdelprop.razdel_id=3071 and razdelprop.prop_id=baseprop.prop_id and prop.flleft=1: 0.004870 секунд
Время:0.018448114395142

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.fr2_id=3071 and razdelprop.razdel_id=3071 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.002872 секунд
Время:0.021396160125732

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.r2_id=3071 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.000815 секунд
Время:0.023687124252319

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

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

select razdel.row_id, razdel.name, razdel.text,razdel.photo ,razdel.r0_id ,razdel.r1_id ,razdel.r2_id ,razdel.r3_id ,razdel.r4_id ,razdel.r5_id from razdel where razdel.del<>1 and razdel.row_id IN(2897,2898,2899,0) order by razdel.name: 0.000099 секунд
Время:0.024221181869507

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

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.fr2_id=3071 and prop.flleft=1 group by prop.row_id, propvalue.row_id order by sort, prop.row_id, propvalue.name: 0.002164 секунд
Время:0.027907133102417

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=3071: 0.000100 секунд
Время:0.028172016143799

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.fr2_id=3071 order by base.namefull limit 0,141: 0.009297 секунд
Время:0.037569046020508

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.000207 секунд
Время:0.041658163070679

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.000092 секунд
Время:0.042399168014526