---------------------------------------------------------------
[ 2018-07-04T16:34:25+08:00 ] 0.0.0.0 HEAD /
[ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_users` [ RunTime:0.018554s ]
[ 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.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.002930s ]
---------------------------------------------------------------
[ 2018-07-04T16:34:26+08:00 ] 162.158.68.216 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.018553s ]
[ 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-07-04T16:34:27+08:00 ] 162.158.68.216 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.021483s ]
[ 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.019530s ]
[ 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.000976s ]
---------------------------------------------------------------
[ 2018-07-04T16:34:27+08:00 ] 162.158.68.216 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.019530s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='5f168944' ) LIMIT 1 [ RunTime:0.001953s ]
[ 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.021483s ]
[ 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-07-04T16:34:28+08:00 ] 162.158.68.216 GET /index.php/index/index/tickets_content/conversationid/1af5a0e0.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.017577s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='1af5a0e0' ) LIMIT 1 [ RunTime:0.001953s ]
[ 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.016601s ]
[ 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.000977s ]
---------------------------------------------------------------
[ 2018-07-04T16:34:28+08:00 ] 162.158.68.216 GET /index.php/index/index/tickets_content/conversationid/ce978e90.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] 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='ce978e90' ) LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='ce978e90' ) ORDER BY `datecreated` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.017577s ]
[ 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.000976s ]
---------------------------------------------------------------
[ 2018-07-04T16:34:29+08:00 ] 162.158.68.216 GET /index.php/index/index/tickets_content/conversationid/9f1686bb.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002929s ] 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='9f1686bb' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='9f1686bb' ) ORDER BY `datecreated` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.018553s ]
[ 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 ]
---------------------------------------------------------------
[ 2018-07-04T16:34:29+08:00 ] 162.158.68.216 GET /index.php/index/index/tickets_content/conversationid/7724913d.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.019530s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='7724913d' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='7724913d' ) ORDER BY `datecreated` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.018553s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '7724913d'  AND `userid` = 'c5b0b0ab'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.003906s ]
---------------------------------------------------------------
[ 2018-07-04T16:34:30+08:00 ] 162.158.68.216 GET /index.php/index/index/tickets_content/conversationid/37435349.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=liveagentdb;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_conversations_search` [ RunTime:0.018553s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='37435349' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='37435349' ) 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` = '37435349'  AND `userid` = '656d8549'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.002929s ]
---------------------------------------------------------------
[ 2018-07-04T16:34:31+08:00 ] 162.158.68.216 GET /index.php/index/index/tickets_content/conversationid/85062861.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.018554s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='85062861' ) LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='85062861' ) ORDER BY `datecreated` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.015624s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = '85062861'  AND `userid` = '558319b8'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2018-07-04T16:34:32+08:00 ] 162.158.68.216 GET /index.php/index/index/tickets_content/conversationid/eff35545.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.016601s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='eff35545' ) LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='eff35545' ) ORDER BY `datecreated` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `qu_la_messages` [ RunTime:0.014648s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_messages` WHERE  `conversationid` = 'eff35545'  AND `userid` = '6994c300'  AND `rtype` IN ('Z','H','M') ORDER BY `messageid` ASC [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2018-07-04T16:34:32+08:00 ] 162.158.68.216 GET /index.php/index/index/tickets_content/conversationid/eb019b09.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.016601s ]
[ sql ] [ SQL ] SELECT COUNT(conversationid) AS tp_count FROM `qu_la_conversations_search` WHERE  (  conversationid='eb019b09' ) LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `qu_la_conversations_search` WHERE  (  conversationid='eb019b09' ) ORDER BY `datecreated` ASC [ RunTime:0.000976s ]