Инструмент алмазный

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

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

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

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

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

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

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

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

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

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

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

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

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

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=3067 : 0.000072 секунд
Время:0.0076749324798584

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

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

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=3067 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=3067 : 0.000409 секунд
Время:0.0083670616149902

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

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

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

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

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

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

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

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=3067: 0.000070 секунд
Время:0.014193058013916

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=2454: 0.000068 секунд
Время:0.014287948608398

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

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=3067 : 0.000223 секунд
Время:0.014749050140381

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

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

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=3067 and razdelprop.razdel_id=3067 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.015821 секунд
Время:0.061025142669678

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=3067 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.000567 секунд
Время:0.062962055206299

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

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

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(3068,3069,3128,3804,0) order by razdel.name: 0.000292 секунд
Время:0.063843965530396

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

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

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=3067: 0.000234 секунд
Время:0.078035116195679

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

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

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