Практика

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

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

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

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

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

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

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

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

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

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

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

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

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

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=3248 : 0.000076 секунд
Время:0.0079140663146973

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

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

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=3248 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=3248 : 0.000089 секунд
Время:0.0082910060882568

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

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

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

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

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

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

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

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=3248: 0.000069 секунд
Время:0.014214992523193

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

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

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

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=3248 : 0.000079 секунд
Время:0.014755964279175

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

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

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.fr3_id=3248 and razdelprop.razdel_id=3248 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.000108 секунд
Время:0.02287483215332

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.r3_id=3248 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.000623 секунд
Время:0.023993015289307

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

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

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

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

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=3248: 0.000098 секунд
Время:0.02721905708313

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.fr3_id=3248 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.021874 секунд
Время:0.04916787147522

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

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