---------------------------------------------------------------
[ 2018-06-15T09:04:28+08:00 ] 0.0.0.0 HEAD /
[ sql ] [ DB ] CONNECT:[ UseTime:0.003906s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_users` [ RunTime:0.009765s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations` [ RunTime:0.009765s ]
[ 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-06-15T09:04:29+08:00 ] 162.158.68.213 GET /
[ sql ] [ DB ] CONNECT:[ UseTime:0.011718s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_users` [ RunTime:0.010742s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations` [ RunTime:0.008788s ]
[ 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-06-15T09:04:30+08:00 ] 162.158.68.213 GET /index.php/index/index/tickets_content/conversationid/d684366b.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.022459s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='d684366b' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='d684366b' ) ORDER BY `datecreated` ASC [ RunTime:0.011718s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.008788s ]
[ 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.001953s ]
---------------------------------------------------------------
[ 2018-06-15T09:04:30+08:00 ] 162.158.68.213 GET /index.php/index/index/tickets_content/conversationid/5c58f9d7.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.009765s ]
[ 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.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.008788s ]
[ 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.000976s ]
---------------------------------------------------------------
[ 2018-06-15T09:04:31+08:00 ] 162.158.68.213 GET /index.php/index/index/tickets_content/conversationid/08af7e0f.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002930s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.009765s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='08af7e0f' ) LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='08af7e0f' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.010742s ]
[ 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.001953s ]
---------------------------------------------------------------
[ 2018-06-15T09:04:32+08:00 ] 162.158.68.213 GET /index.php/index/index/tickets_content/conversationid/39a37e3e.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.011718s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.009765s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='39a37e3e' ) LIMIT 1 [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='39a37e3e' ) ORDER BY `datecreated` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.009765s ]
[ 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.000976s ]
---------------------------------------------------------------
[ 2018-06-15T09:04:32+08:00 ] 162.158.68.213 GET /index.php/index/index/tickets_content/conversationid/a469cf16.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.011718s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.008789s ]
[ 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.010742s ]
[ 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.001953s ]
---------------------------------------------------------------
[ 2018-06-15T09:04:33+08:00 ] 162.158.68.213 GET /index.php/index/index/tickets_content/conversationid/bebd3062.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.012694s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.009765s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='bebd3062' ) LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='bebd3062' ) ORDER BY `datecreated` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.009765s ]
[ 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.000976s ]
[ 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.000976s ]
---------------------------------------------------------------
[ 2018-06-15T09:04:33+08:00 ] 162.158.68.213 GET /index.php/index/index/tickets_content/conversationid/a53073ca.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.009765s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='a53073ca' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='a53073ca' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.008789s ]
[ 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.000977s ]
---------------------------------------------------------------
[ 2018-06-15T09:04:33+08:00 ] 162.158.68.213 GET /index.php/index/index/tickets_content/conversationid/c33421bf.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.009765s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='c33421bf' ) LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='c33421bf' ) ORDER BY `datecreated` ASC [ RunTime:0.000000s ]
[ 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.001953s ]
---------------------------------------------------------------
[ 2018-06-15T09:04:34+08:00 ] 162.158.68.213 GET /index.php/index/index/tickets_content/conversationid/d937a9a4.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.012694s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.009765s ]
[ 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.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.007812s ]
[ 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.001953s ]
---------------------------------------------------------------
[ 2018-06-15T09:04:38+08:00 ] 162.158.68.213 GET /index.php/index/index/tickets_content/conversationid/43b851ac.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.012694s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.010742s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='43b851ac' ) LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='43b851ac' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.010742s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '43b851ac'  AND `userid` = 'cdcc350a'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000976s ]