--------------------------------------------------------------- [ 2018-05-20T19:42:53+08:00 ] 101.199.112.53 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.001953s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_users` [ RunTime:0.007813s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations` [ RunTime:0.006836s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `qu_la_conversations` `a` LEFT JOIN `qu_la_contacts` `b` ON `b`.`contactid`=( SELECT `u`.`contactid` FROM `qu_la_users` `u` WHERE ( u.userid=a.ownerid ) ) LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT * FROM `qu_la_conversations` `a` LEFT JOIN `qu_la_contacts` `b` ON `b`.`contactid`=( SELECT `u`.`contactid` FROM `qu_la_users` `u` WHERE ( u.userid=a.ownerid ) ) ORDER BY `a`.`datecreated` DESC LIMIT 0,10 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2018-05-20T19:44:56+08:00 ] 139.170.67.1 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.010743s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_users` [ RunTime:0.006836s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations` [ RunTime:0.006836s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `qu_la_conversations` `a` LEFT JOIN `qu_la_contacts` `b` ON `b`.`contactid`=( SELECT `u`.`contactid` FROM `qu_la_users` `u` WHERE ( u.userid=a.ownerid ) ) LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT * FROM `qu_la_conversations` `a` LEFT JOIN `qu_la_contacts` `b` ON `b`.`contactid`=( SELECT `u`.`contactid` FROM `qu_la_users` `u` WHERE ( u.userid=a.ownerid ) ) ORDER BY `a`.`datecreated` DESC LIMIT 0,10 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2018-05-20T20:10:37+08:00 ] 123.191.149.148 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.002930s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_users` [ RunTime:0.008789s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations` [ RunTime:0.007813s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `qu_la_conversations` `a` LEFT JOIN `qu_la_contacts` `b` ON `b`.`contactid`=( SELECT `u`.`contactid` FROM `qu_la_users` `u` WHERE ( u.userid=a.ownerid ) ) LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT * FROM `qu_la_conversations` `a` LEFT JOIN `qu_la_contacts` `b` ON `b`.`contactid`=( SELECT `u`.`contactid` FROM `qu_la_users` `u` WHERE ( u.userid=a.ownerid ) ) ORDER BY `a`.`datecreated` DESC LIMIT 0,10 [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2018-05-20T20:11:27+08:00 ] 139.170.66.80 GET /?5315 [ sql ] [ DB ] CONNECT:[ UseTime:0.010743s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_users` [ RunTime:0.007812s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations` [ RunTime:0.007812s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `qu_la_conversations` `a` LEFT JOIN `qu_la_contacts` `b` ON `b`.`contactid`=( SELECT `u`.`contactid` FROM `qu_la_users` `u` WHERE ( u.userid=a.ownerid ) ) LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT * FROM `qu_la_conversations` `a` LEFT JOIN `qu_la_contacts` `b` ON `b`.`contactid`=( SELECT `u`.`contactid` FROM `qu_la_users` `u` WHERE ( u.userid=a.ownerid ) ) ORDER BY `a`.`datecreated` DESC LIMIT 0,10 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2018-05-20T20:12:48+08:00 ] 60.219.236.19 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.011720s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_users` [ RunTime:0.007812s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations` [ RunTime:0.006836s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `qu_la_conversations` `a` LEFT JOIN `qu_la_contacts` `b` ON `b`.`contactid`=( SELECT `u`.`contactid` FROM `qu_la_users` `u` WHERE ( u.userid=a.ownerid ) ) LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `qu_la_conversations` `a` LEFT JOIN `qu_la_contacts` `b` ON `b`.`contactid`=( SELECT `u`.`contactid` FROM `qu_la_users` `u` WHERE ( u.userid=a.ownerid ) ) ORDER BY `a`.`datecreated` DESC LIMIT 0,10 [ RunTime:0.000977s ]