Лог Mysql:C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld, Version: 5.1.53-community-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
# Time: 160218 16:12:32
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 3.686000 Lock_time: 0.000000 Rows_sent: 471 Rows_examined: 3091031
use contact;
SET timestamp=1455801152;
sel ect sgn.sdate,sgn.id_obj,sgn.razdel,mes.mes,obj.obj,sgn.zona,sgn.comn,zon.zon,ppl.ppl,sgn.str1,sgn.prim,sgn.phone,sgn.str2,mes.i2 as FontColor,mes.i1 as BkColor,pr.pr,sgn.id_zon,zon.id_key as id_key_zon,sgn.id_mes,sgn.id_pr,sgn.id_ppl,obj.s21,sgn.xuser,sgn.id,mes.id_show,(sel ect text fr om Answer where id=mes.id_show) as xshow,obj.id_pic as PIC_id_obj,mes.id_pic as PIC_id_mes,ppl.id_key as id_key_ppl
,(sel ect razdel.razdel fr om razdel where razdel.id_obj = sgn.id_obj and razdel.n = sgn.razdel limit 1) as xrazdel fr om sgn left join mes as mes on sgn.id_mes = mes.id left join obj as obj on sgn.id_obj = obj.id left join pr as pr on sgn.id_pr = pr.id left join zon as zon on not (sgn.id_mes between 4001 and 4093) and sgn.zona = zon.id_key and sgn.id_obj=zon.id_obj and sgn.razdel = zon.n_razdel left join ppl as ppl on (sgn.id_mes between 4001 and 4093) and ppl.deleted=0 and sgn.zona = ppl.id_key and sgn.id_obj = ppl.id_obj where (obj.id in (sel ect id_obj fr om web_users_on_objs where id_user=5)) and (mes.id <> 0) and (sgn.id_obj >= -1) and (obj.id_obs=1)
order by sgn.id desc;
# Time: 160218 16:12:44
# User@Host: root[root] @ #$#$%
# Query_time: 3.834000 Lock_time: 0.000000 Rows_sent: 490 Rows_examined: 3215541
SET timestamp=1455801164;
sel ect sgn.sdate,sgn.razdel,sgn.id_obj,obj.obj,mes.mes,sgn.zona,zon.zon,sgn.str1,ppl.ppl,sgn.comn,sgn.prim,sgn.phone,sgn.str2,mes.i2 as FontColor,mes.i1 as BkColor,pr.pr,sgn.id_zon,zon.id_key as id_key_zon,sgn.id_mes,sgn.id_pr,sgn.id_ppl,obj.s21,sgn.xuser,sgn.id,mes.id_show,(sel ect text fr om Answer where id=mes.id_show) as xshow,obj.id_pic as PIC_id_obj,mes.id_pic as PIC_id_mes,ppl.id_key as id_key_ppl
,(sel ect razdel.razdel fr om razdel where razdel.id_obj = sgn.id_obj and razdel.n = sgn.razdel limit 1) as xrazdel fr om sgn left join mes as mes on sgn.id_mes = mes.id left join obj as obj on sgn.id_obj = obj.id left join pr as pr on sgn.id_pr = pr.id left join zon as zon on not (sgn.id_mes between 4001 and 4093) and sgn.zona = zon.id_key and sgn.id_obj=zon.id_obj and sgn.razdel = zon.n_razdel left join ppl as ppl on (sgn.id_mes between 4001 and 4093) and ppl.deleted=0 and sgn.zona = ppl.id_key and sgn.id_obj = ppl.id_obj where (obj.id in (sel ect id_obj fr om web_users_on_objs where id_user=6)) and (mes.id <> 0) and (sgn.id_obj >= -1) and (obj.id_obs=1)
order by sgn.id desc;
# Time: 160218 16:13:15
# User@Host: root[root] @ #$#$%
# Query_time: 3.881000 Lock_time: 0.000000 Rows_sent: 490 Rows_examined: 3215542
SET timestamp=1455801195;
sel ect sgn.sdate,sgn.razdel,sgn.id_obj,obj.obj,mes.mes,sgn.zona,zon.zon,sgn.str1,ppl.ppl,sgn.comn,sgn.prim,sgn.phone,sgn.str2,mes.i2 as FontColor,mes.i1 as BkColor,pr.pr,sgn.id_zon,zon.id_key as id_key_zon,sgn.id_mes,sgn.id_pr,sgn.id_ppl,obj.s21,sgn.xuser,sgn.id,mes.id_show,(select text fr om Answer where id=mes.id_show) as xshow,obj.id_pic as PIC_id_obj,mes.id_pic as PIC_id_mes,ppl.id_key as id_key_ppl
,(select razdel.razdel fr om razdel where razdel.id_obj = sgn.id_obj and razdel.n = sgn.razdel lim it 1) as xrazdel fr om sgn left join mes as mes on sgn.id_mes = mes.id left join obj as obj on sgn.id_obj = obj.id left join pr as pr on sgn.id_pr = pr.id left join zon as zon on not (sgn.id_mes between 4001 and 4093) and sgn.zona = zon.id_key and sgn.id_obj=zon.id_obj and sgn.razdel = zon.n_razdel left join ppl as ppl on (sgn.id_mes between 4001 and 4093) and ppl.deleted=0 and sgn.zona = ppl.id_key and sgn.id_obj = ppl.id_obj where (obj.id in (select id_obj fr om web_users_on_objs where id_user=6)) and (mes.id <> 0) and (sgn.id_obj >= -1) and (obj.id_obs=1)
order by sgn.id desc;
# Time: 160218 16:13:16
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 3.716000 Lock_time: 0.000000 Rows_sent: 472 Rows_examined: 3097592
SET timestamp=1455801196;
select sgn.sdate,sgn.id_obj,sgn.razdel,mes.mes,obj.obj,sgn.zona,sgn.comn,zon.zon,ppl.ppl,sgn.str1,sgn.prim,sgn.phone,sgn.str2,mes.i2 as FontColor,mes.i1 as BkColor,pr.pr,sgn.id_zon,zon.id_key as id_key_zon,sgn.id_mes,sgn.id_pr,sgn.id_ppl,obj.s21,sgn.xuser,sgn.id,mes.id_show,(select text fr om Answer where id=mes.id_show) as xshow,obj.id_pic as PIC_id_obj,mes.id_pic as PIC_id_mes,ppl.id_key as id_key_ppl
,(select razdel.razdel fr om razdel wh ere razdel.id_obj = sgn.id_obj and razdel.n = sgn.razdel lim it 1) as xrazdel fr om sgn left join mes as mes on sgn.id_mes = mes.id left join obj as obj on sgn.id_obj = obj.id left join pr as pr on sgn.id_pr = pr.id left join zon as zon on not (sgn.id_mes between 4001 and 4093) and sgn.zona = zon.id_key and sgn.id_obj=zon.id_obj and sgn.razdel = zon.n_razdel left join ppl as ppl on (sgn.id_mes between 4001 and 4093) and ppl.deleted=0 and sgn.zona = ppl.id_key and sgn.id_obj = ppl.id_obj wh ere (obj.id in (select id_obj fr om web_users_on_objs wh ere id_user=5)) and (mes.id <> 0) and (sgn.id_obj >= -1) and (obj.id_obs=1)
order by sgn.id desc;
# Time: 160218 16:13:23
# User@Host: root[root] @ $%%&*()
# Query_time: 7.618000 Lock_time: 0.000000 Rows_sent: 977 Rows_examined: 6410542
SET timestamp=1455801203;
select sgn.xuser,sgn.sdate,sgn.comn,sgn.phone,sgn.id_obj,mes.mes,obj.obj,ppl.ppl,zon.zon,sgn.zona,sgn.razdel,sgn.str1,sgn.str2,sgn.prim,mes.i2 as FontColor,mes.i1 as BkColor,sgn.id_zon,zon.id_key as id_key_zon,sgn.id_mes,sgn.id_pr,sgn.id_ppl,obj.s21,pr.pr,sgn.id,mes.id_show,(select text fr om Answer wh ere id=mes.id_show) as xshow,obj.id_pic as PIC_id_obj,mes.id_pic as PIC_id_mes,ppl.id_key as id_key_ppl
,(select razdel.razdel fr om razdel wh ere razdel.id_obj = sgn.id_obj and razdel.n = sgn.razdel lim it 1) as xrazdel fr om sgn left join mes as mes on sgn.id_mes = mes.id left join obj as obj on sgn.id_obj = obj.id left join pr as pr on sgn.id_pr = pr.id left join zon as zon on not (sgn.id_mes between 4001 and 4093) and sgn.zona = zon.id_key and sgn.id_obj=zon.id_obj and sgn.razdel = zon.n_razdel left join ppl as ppl on (sgn.id_mes between 4001 and 4093) and ppl.deleted=0 and sgn.zona = ppl.id_key and sgn.id_obj = ppl.id_obj wh ere (mes.id <> 0) and (sgn.id_obj >= -1) and (obj.id_obs=1)
order by sgn.id desc;
# Time: 160218 16:14:27
# User@Host: root[root] @ @ $%%&*()
# Query_time: 7.650000 Lock_time: 0.000000 Rows_sent: 977 Rows_examined: 6410542
SET timestamp=1455801267;
select sgn.xuser,sgn.sdate,sgn.comn,sgn.phone,sgn.id_obj,mes.mes,obj.obj,ppl.ppl,zon.zon,sgn.zona,sgn.razdel,sgn.str1,sgn.str2,sgn.prim,mes.i2 as FontColor,mes.i1 as BkColor,sgn.id_zon,zon.id_key as id_key_zon,sgn.id_mes,sgn.id_pr,sgn.id_ppl,obj.s21,pr.pr,sgn.id,mes.id_show,(select text fr om Answer wh ere id=mes.id_show) as xshow,obj.id_pic as PIC_id_obj,mes.id_pic as PIC_id_mes,ppl.id_key as id_key_ppl
,(select razdel.razdel fr om razdel wh ere razdel.id_obj = sgn.id_obj and razdel.n = sgn.razdel lim it 1) as xrazdel fr om sgn left join mes as mes on sgn.id_mes = mes.id left join obj as obj on sgn.id_obj = obj.id left join pr as pr on sgn.id_pr = pr.id left join zon as zon on not (sgn.id_mes between 4001 and 4093) and sgn.zona = zon.id_key and sgn.id_obj=zon.id_obj and sgn.razdel = zon.n_razdel left join ppl as ppl on (sgn.id_mes between 4001 and 4093) and ppl.deleted=0 and sgn.zona = ppl.id_key and sgn.id_obj = ppl.id_obj wh ere (mes.id <> 0) and (sgn.id_obj >= -1) and (obj.id_obs=1)
order by sgn.id desc;