---------------------------------------------------------------
[ 2018-06-28T04:10:09+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.019530s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations` [ RunTime:0.019530s ]
[ 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.001953s ]
[ 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-28T04:10:10+08:00 ] 162.158.64.111 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.020507s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations` [ RunTime:0.020507s ]
[ 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-28T04:10:10+08:00 ] 162.158.64.111 GET /index.php/index/index/tickets_content/conversationid/8b3a00b5.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.021483s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='8b3a00b5' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='8b3a00b5' ) ORDER BY `datecreated` ASC [ RunTime:0.007812s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.019530s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '8b3a00b5'  AND `userid` = '03fa0d4f'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '8b3a00b5'  AND `userid` = '94945779'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '8b3a00b5'  AND `userid` = '94945779'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2018-06-28T04:10:11+08:00 ] 162.158.64.111 GET /index.php/index/index/tickets_content/conversationid/e33e4e03.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.023436s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='e33e4e03' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='e33e4e03' ) ORDER BY `datecreated` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.023436s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = 'e33e4e03'  AND `userid` = 'c6be68af'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2018-06-28T04:10:11+08:00 ] 162.158.64.111 GET /index.php/index/index/tickets_content/conversationid/b3222de0.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.019530s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='b3222de0' ) LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='b3222de0' ) ORDER BY `datecreated` ASC [ RunTime:0.000000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.019530s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = 'b3222de0'  AND `userid` = '23e1993e'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2018-06-28T04:10:12+08:00 ] 162.158.64.111 GET /index.php/index/index/tickets_content/conversationid/c6fa2eb0.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.021483s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='c6fa2eb0' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='c6fa2eb0' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.018553s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = 'c6fa2eb0'  AND `userid` = 'aab6b043'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2018-06-28T04:10:12+08:00 ] 162.158.64.111 GET /index.php/index/index/tickets_content/conversationid/2e4a50ab.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.019530s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='2e4a50ab' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='2e4a50ab' ) ORDER BY `datecreated` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.019530s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '2e4a50ab'  AND `userid` = '2982aefb'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2018-06-28T04:10:13+08:00 ] 162.158.64.111 GET /index.php/index/index/tickets_content/conversationid/3e5c68e4.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.019530s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='3e5c68e4' ) LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='3e5c68e4' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.017577s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '3e5c68e4'  AND `userid` = 'a72124d8'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2018-06-28T04:10:13+08:00 ] 162.158.64.111 GET /index.php/index/index/tickets_content/conversationid/5f168944.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.019530s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='5f168944' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='5f168944' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '5f168944'  AND `userid` = 'f88b8ca5'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2018-06-28T04:10:13+08:00 ] 162.158.64.111 GET /index.php/index/index/tickets_content/conversationid/1af5a0e0.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.026366s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='1af5a0e0' ) LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='1af5a0e0' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.022460s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '1af5a0e0'  AND `userid` = '167ededb'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2018-06-28T04:10:14+08:00 ] 162.158.64.111 GET /index.php/index/index/tickets_content/conversationid/ce978e90.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='ce978e90' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='ce978e90' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.019530s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = 'ce978e90'  AND `userid` = 'e94b18a1'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2018-06-28T04:10:14+08:00 ] 162.158.64.111 GET /index.php/index/index/tickets_content/conversationid/9f1686bb.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.022460s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='9f1686bb' ) LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='9f1686bb' ) ORDER BY `datecreated` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.020506s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '9f1686bb'  AND `userid` = 'b505927e'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.001953s ]