---------------------------------------------------------------
[ 2018-06-24T21:28:12+08:00 ] 0.0.0.0 HEAD /
[ sql ] [ DB ] CONNECT:[ UseTime:0.003907s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_users` [ RunTime:0.019532s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations` [ RunTime:0.021485s ]
[ 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.000977s ]
---------------------------------------------------------------
[ 2018-06-24T21:28:13+08:00 ] 162.158.68.215 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.018555s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations` [ RunTime:0.019532s ]
[ 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.001954s ]
---------------------------------------------------------------
[ 2018-06-24T21:28:13+08:00 ] 162.158.68.215 GET /index.php/index/index/tickets_content/conversationid/43b851ac.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.018556s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='43b851ac' ) LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='43b851ac' ) ORDER BY `datecreated` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.017579s ]
[ 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 ]
---------------------------------------------------------------
[ 2018-06-24T21:28:14+08:00 ] 162.158.68.215 GET /index.php/index/index/tickets_content/conversationid/283fb3d7.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.022461s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='283fb3d7' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='283fb3d7' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.018556s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '283fb3d7'  AND `userid` = 'e803e3c3'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2018-06-24T21:28:14+08:00 ] 162.158.68.215 GET /index.php/index/index/tickets_content/conversationid/8b3a00b5.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.019532s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='8b3a00b5' ) LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='8b3a00b5' ) ORDER BY `datecreated` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.018555s ]
[ 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.000977s ]
[ 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.000977s ]
[ 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.001953s ]
---------------------------------------------------------------
[ 2018-06-24T21:28:15+08:00 ] 162.158.68.215 GET /index.php/index/index/tickets_content/conversationid/e33e4e03.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.018555s ]
[ 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.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.016603s ]
[ 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.001953s ]
---------------------------------------------------------------
[ 2018-06-24T21:28:15+08:00 ] 162.158.68.215 GET /index.php/index/index/tickets_content/conversationid/b3222de0.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.022462s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='b3222de0' ) LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='b3222de0' ) ORDER BY `datecreated` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.016602s ]
[ 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.000977s ]
---------------------------------------------------------------
[ 2018-06-24T21:28:15+08:00 ] 162.158.68.215 GET /index.php/index/index/tickets_content/conversationid/c6fa2eb0.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.018556s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='c6fa2eb0' ) LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='c6fa2eb0' ) ORDER BY `datecreated` ASC [ RunTime:0.000000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.027345s ]
[ 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.000977s ]
---------------------------------------------------------------
[ 2018-06-24T21:28:16+08:00 ] 162.158.68.215 GET /index.php/index/index/tickets_content/conversationid/2e4a50ab.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.021485s ]
[ 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.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.020509s ]
[ 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.001953s ]
---------------------------------------------------------------
[ 2018-06-24T21:28:16+08:00 ] 162.158.68.215 GET /index.php/index/index/tickets_content/conversationid/3e5c68e4.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.023438s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='3e5c68e4' ) LIMIT 1 [ RunTime:0.000977s ]
[ 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.018556s ]
[ 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.000977s ]
---------------------------------------------------------------
[ 2018-06-24T21:28:17+08:00 ] 162.158.68.215 GET /index.php/index/index/tickets_content/conversationid/5f168944.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.019532s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='5f168944' ) LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='5f168944' ) ORDER BY `datecreated` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.019532s ]
[ 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.000977s ]
---------------------------------------------------------------
[ 2018-06-24T21:28:17+08:00 ] 162.158.68.215 GET /index.php/index/index/tickets_content/conversationid/1af5a0e0.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.020508s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='1af5a0e0' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='1af5a0e0' ) ORDER BY `datecreated` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.020508s ]
[ 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.005860s ]