---------------------------------------------------------------
[ 2018-05-16T21:30:37+08:00 ] 0.0.0.0 HEAD /
[ sql ] [ DB ] CONNECT:[ UseTime:0.002929s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_users` [ RunTime:0.010743s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations` [ RunTime:0.009766s ]
[ 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-16T21:30:37+08:00 ] 162.158.64.77 GET /
[ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] 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-16T21:30:40+08:00 ] 162.158.64.77 GET /index.php/index/index/tickets_content/conversationid/38b4459d.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.010743s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.024415s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='38b4459d' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='38b4459d' ) ORDER BY `datecreated` ASC [ RunTime:0.009766s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.007813s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '38b4459d'  AND `userid` = '83379773'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2018-05-16T21:30:41+08:00 ] 162.158.64.77 GET /index.php/index/index/tickets_content/conversationid/d684366b.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.012696s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.007813s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='d684366b' ) LIMIT 1 [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='d684366b' ) ORDER BY `datecreated` ASC [ RunTime:0.000000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = 'd684366b'  AND `userid` = '6ca71c49'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2018-05-16T21:30:41+08:00 ] 162.158.64.77 GET /index.php/index/index/tickets_content/conversationid/5c58f9d7.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='5c58f9d7' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='5c58f9d7' ) ORDER BY `datecreated` ASC [ RunTime:0.000000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '5c58f9d7'  AND `userid` = 'aa23c212'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2018-05-16T21:30:42+08:00 ] 162.158.64.77 GET /index.php/index/index/tickets_content/conversationid/08af7e0f.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001953s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.007813s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='08af7e0f' ) LIMIT 1 [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='08af7e0f' ) ORDER BY `datecreated` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '08af7e0f'  AND `userid` = '43f6ce70'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2018-05-16T21:30:42+08:00 ] 162.158.64.77 GET /index.php/index/index/tickets_content/conversationid/39a37e3e.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001953s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='39a37e3e' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='39a37e3e' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '39a37e3e'  AND `userid` = '2d575a45'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2018-05-16T21:30:42+08:00 ] 162.158.64.77 GET /index.php/index/index/tickets_content/conversationid/a469cf16.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.012696s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='a469cf16' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='a469cf16' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = 'a469cf16'  AND `userid` = '94945779'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2018-05-16T21:30:43+08:00 ] 162.158.64.77 GET /index.php/index/index/tickets_content/conversationid/bebd3062.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='bebd3062' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='bebd3062' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = 'bebd3062'  AND `userid` = '16296818'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = 'bebd3062'  AND `userid` = '94945779'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2018-05-16T21:30:43+08:00 ] 162.158.64.77 GET /index.php/index/index/tickets_content/conversationid/a53073ca.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.000977s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.007813s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='a53073ca' ) LIMIT 1 [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='a53073ca' ) ORDER BY `datecreated` ASC [ RunTime:0.000000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.006837s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = 'a53073ca'  AND `userid` = '7ec5e564'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = 'a53073ca'  AND `userid` = '94945779'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2018-05-16T21:30:44+08:00 ] 162.158.64.77 GET /index.php/index/index/tickets_content/conversationid/c33421bf.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.009766s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='c33421bf' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='c33421bf' ) ORDER BY `datecreated` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.008789s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = 'c33421bf'  AND `userid` = 'ef5904e5'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2018-05-16T21:30:45+08:00 ] 162.158.64.77 GET /index.php/index/index/tickets_content/conversationid/d937a9a4.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.010743s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.007813s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='d937a9a4' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='d937a9a4' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = 'd937a9a4'  AND `userid` = 'eb65366f'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.001954s ]