1. SHOW |
total: 1 SHOW COLUMNS FROM `settings` LIKE 'address_limit'
2. SHOW |
total: 1 SHOW COLUMNS FROM `settings` LIKE 'sendmail'
3. SHOW |
total: 1 SHOW COLUMNS FROM `settings` LIKE 'smtp_host'
4. SHOW |
total: 1 SHOW COLUMNS FROM `settings` LIKE 'smtp_user'
5. SHOW |
total: 1 SHOW COLUMNS FROM `settings` LIKE 'smtp_pass'
6. SHOW |
total: 1 SHOW COLUMNS FROM `settings` LIKE 'smtp_port'
7. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" LIMIT 1
8. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "language" LIMIT 1
9. select |
total: 3 SELECT abbr FROM `language` ORDER BY home DESC, id ASC;
10. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "offline_info" LIMIT 1
11. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "offline_info_cn" LIMIT 1
12. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_info" LIMIT 1
13. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_info_cn" LIMIT 1
14. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_note" LIMIT 1
15. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_note_cn" LIMIT 1
16. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "offline_info" LIMIT 1
17. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "offline_info_ru" LIMIT 1
18. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_info" LIMIT 1
19. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_info_ru" LIMIT 1
20. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_note" LIMIT 1
21. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_note_ru" LIMIT 1
22. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
23. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "language" AND COLUMN_NAME = "active" LIMIT 1
24. select |
total: 3 SELECT abbr FROM `language` WHERE active = 1 ;
25. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" LIMIT 1
26. select |
total: 1 SELECT title_en, info_en, keywords_en, description_en FROM `modules` WHERE modalias = "shop" LIMIT 1;
27. select |
total: 23 SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
28. SELECT |
total: 1 SELECT
d.*,
d.title_en AS title,
FORMAT((d.likes/d.ratings),0) as stars,
(SELECT
COUNT(parent_id)
FROM
`mod_comments`
WHERE `mod_comments`.parent_id = d.id
AND section = 'shop'
AND active = 1
AND comment_id = 0) as comments
FROM
`mod_shop` AS d
WHERE slug_en = "organic-9369-chun-mee-tea"
AND d.active = 1
GROUP BY d.id;
29. SELECT |
total: 0 SELECT
SUM(totalprice) as grand,
COUNT(id) AS items
FROM
`mod_shop_cart`
WHERE user_id = "75286d8616d251434ecc093b28b7ef696c3170d3"
GROUP BY user_id;
30. SELECT |
total: 1 SELECT
COUNT(*) AS total
FROM
`mod_comments`
WHERE section = "shop"
AND comment_id = 0
AND parent_id = 12
AND active = 1
LIMIT 1;
31. SELECT |
total: 5 SELECT
c.id,
c.user_id,
c.comment_id,
c.parent_id,
c.section,
c.vote_down,
c.vote_up,
c.body,
c.created,
c.username as uname,
u.username,
CONCAT(u.fname, ' ', u.lname) AS name,
u.avatar
FROM
`mod_comments` AS c
INNER JOIN
(SELECT
id
FROM
`mod_comments`
WHERE section = "shop"
AND parent_id = 12
AND comment_id = 0
AND active = 1
ORDER BY created DESC
LIMIT 65,5) AS ch
ON ch.id IN (c.id, c.comment_id)
LEFT JOIN `users` AS u
ON u.id = c.user_id
WHERE section = "shop"
AND parent_id = 12
AND c.active = 1
ORDER BY created DESC;
32. count |
total: 1 SELECT COUNT(*) as NUMROWS FROM information_schema.tables WHERE (TABLE_SCHEMA = 'eoemtea_online') AND (TABLE_NAME = 'mod_shop') LIMIT 1;
33. count |
total: 1 SELECT COUNT(*) as NUMROWS FROM information_schema.tables WHERE (TABLE_SCHEMA = 'eoemtea_online') AND (TABLE_NAME = 'mod_shop_categories') LIMIT 1;
34. select |
total: 1 SELECT * FROM `mod_shop_categories` WHERE id = 48 AND active = 1 LIMIT 1;
35. count |
total: 1 SELECT COUNT(*) as NUMROWS FROM information_schema.tables WHERE (TABLE_SCHEMA = 'eoemtea_online') AND (TABLE_NAME = 'mod_shop_related_categories') LIMIT 1;
36. SELECT |
total: 4 SELECT d.*
FROM `mod_shop` AS d
LEFT JOIN `mod_shop_related_categories` AS rc ON rc.item_id = d.id
WHERE d.active = 1
AND (d.category_id = 48 OR rc.category_id = 48) AND d.id <> 12
GROUP BY d.id
ORDER BY d.created DESC
LIMIT 4
37. count |
total: 1 SELECT COUNT(*) as NUMROWS FROM information_schema.tables WHERE (TABLE_SCHEMA = 'eoemtea_online') AND (TABLE_NAME = 'pages') LIMIT 1;
38. SELECT |
total: 4 SELECT * FROM `pages` WHERE active = 1 AND page_type = 'normal' ORDER BY id LIMIT 4
39. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_settings" LIMIT 1
40. select |
total: 6 SELECT * FROM `mod_support_settings` ;
41. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
42. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
43. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
44. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" AND COLUMN_NAME = "name_en" LIMIT 1
45. UPDATE |
total: 0 UPDATE `mod_support_departments` SET `name_en` = `name` WHERE `name_en` = '' OR `name_en` IS NULL
46. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
47. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" AND COLUMN_NAME = "name_cn" LIMIT 1
48. UPDATE |
total: 0 UPDATE `mod_support_departments` SET `name_cn` = `name` WHERE `name_cn` = '' OR `name_cn` IS NULL
49. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
50. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" AND COLUMN_NAME = "name_ru" LIMIT 1
51. UPDATE |
total: 0 UPDATE `mod_support_departments` SET `name_ru` = `name` WHERE `name_ru` = '' OR `name_ru` IS NULL
52. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
53. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" AND COLUMN_NAME = "name_en" LIMIT 1
54. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
55. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" AND COLUMN_NAME = "name" LIMIT 1
56. SELECT |
total: 3 SELECT d.*, COALESCE(NULLIF(`d`.`name_en`, ''), NULLIF(`d`.`name`, '')) AS department_name
FROM `mod_support_departments` AS d
WHERE active = 1
ORDER BY d.sorting, department_name
57. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" LIMIT 1
58. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_conversations" LIMIT 1
59. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" LIMIT 1
60. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" AND COLUMN_NAME = "department_ids" LIMIT 1
61. SELECT |
total: 1 SELECT a.*, COUNT(c.id) AS active_count
FROM `mod_support_agents` AS a
LEFT JOIN `mod_support_conversations` AS c ON c.agent_id = a.id AND c.status <> 'closed' AND c.queue_status = 'accepted'
WHERE (a.department_id = 1 OR FIND_IN_SET(1, a.department_ids)) AND a.active = 1 AND a.auto_assign = 1 AND a.status = 'online'
GROUP BY a.id
HAVING active_count < a.max_conversations
ORDER BY active_count ASC, a.updated DESC
LIMIT 1
62. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" LIMIT 1
63. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_conversations" LIMIT 1
64. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" LIMIT 1
65. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" AND COLUMN_NAME = "department_ids" LIMIT 1
66. SELECT |
total: 1 SELECT a.*, COUNT(c.id) AS active_count
FROM `mod_support_agents` AS a
LEFT JOIN `mod_support_conversations` AS c ON c.agent_id = a.id AND c.status <> 'closed' AND c.queue_status = 'accepted'
WHERE (a.department_id = 2 OR FIND_IN_SET(2, a.department_ids)) AND a.active = 1 AND a.auto_assign = 1 AND a.status = 'online'
GROUP BY a.id
HAVING active_count < a.max_conversations
ORDER BY active_count ASC, a.updated DESC
LIMIT 1
67. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" LIMIT 1
68. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_conversations" LIMIT 1
69. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" LIMIT 1
70. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" AND COLUMN_NAME = "department_ids" LIMIT 1
71. SELECT |
total: 1 SELECT a.*, COUNT(c.id) AS active_count
FROM `mod_support_agents` AS a
LEFT JOIN `mod_support_conversations` AS c ON c.agent_id = a.id AND c.status <> 'closed' AND c.queue_status = 'accepted'
WHERE (a.department_id = 3 OR FIND_IN_SET(3, a.department_ids)) AND a.active = 1 AND a.auto_assign = 1 AND a.status = 'online'
GROUP BY a.id
HAVING active_count < a.max_conversations
ORDER BY active_count ASC, a.updated DESC
LIMIT 1
72. SELECT |
total: 1 SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_settings" LIMIT 1
73. select |
total: 6 SELECT * FROM `mod_support_settings` ;
1. SHOW | total: 1 . SHOW COLUMNS FROM `settings` LIKE 'address_limit'
2. SHOW | total: 1 . SHOW COLUMNS FROM `settings` LIKE 'sendmail'
3. SHOW | total: 1 . SHOW COLUMNS FROM `settings` LIKE 'smtp_host'
4. SHOW | total: 1 . SHOW COLUMNS FROM `settings` LIKE 'smtp_user'
5. SHOW | total: 1 . SHOW COLUMNS FROM `settings` LIKE 'smtp_pass'
6. SHOW | total: 1 . SHOW COLUMNS FROM `settings` LIKE 'smtp_port'
7. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" LIMIT 1
8. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "language" LIMIT 1
9. select | total: 3 . SELECT abbr FROM `language` ORDER BY home DESC, id ASC;
10. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "offline_info" LIMIT 1
11. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "offline_info_cn" LIMIT 1
12. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_info" LIMIT 1
13. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_info_cn" LIMIT 1
14. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_note" LIMIT 1
15. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_note_cn" LIMIT 1
16. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "offline_info" LIMIT 1
17. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "offline_info_ru" LIMIT 1
18. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_info" LIMIT 1
19. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_info_ru" LIMIT 1
20. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_note" LIMIT 1
21. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" AND COLUMN_NAME = "inv_note_ru" LIMIT 1
22. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;
23. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "language" AND COLUMN_NAME = "active" LIMIT 1
24. select | total: 3 . SELECT abbr FROM `language` WHERE active = 1 ;
25. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "settings" LIMIT 1
26. select | total: 1 . SELECT title_en, info_en, keywords_en, description_en FROM `modules` WHERE modalias = "shop" LIMIT 1;
27. select | total: 23 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
28. SELECT | total: 1 . SELECT
d.*,
d.title_en AS title,
FORMAT((d.likes/d.ratings),0) as stars,
(SELECT
COUNT(parent_id)
FROM
`mod_comments`
WHERE `mod_comments`.parent_id = d.id
AND section = 'shop'
AND active = 1
AND comment_id = 0) as comments
FROM
`mod_shop` AS d
WHERE slug_en = "organic-9369-chun-mee-tea"
AND d.active = 1
GROUP BY d.id;
29. SELECT | total: 0 . SELECT
SUM(totalprice) as grand,
COUNT(id) AS items
FROM
`mod_shop_cart`
WHERE user_id = "75286d8616d251434ecc093b28b7ef696c3170d3"
GROUP BY user_id;
30. SELECT | total: 1 . SELECT
COUNT(*) AS total
FROM
`mod_comments`
WHERE section = "shop"
AND comment_id = 0
AND parent_id = 12
AND active = 1
LIMIT 1;
31. SELECT | total: 5 . SELECT
c.id,
c.user_id,
c.comment_id,
c.parent_id,
c.section,
c.vote_down,
c.vote_up,
c.body,
c.created,
c.username as uname,
u.username,
CONCAT(u.fname, ' ', u.lname) AS name,
u.avatar
FROM
`mod_comments` AS c
INNER JOIN
(SELECT
id
FROM
`mod_comments`
WHERE section = "shop"
AND parent_id = 12
AND comment_id = 0
AND active = 1
ORDER BY created DESC
LIMIT 65,5) AS ch
ON ch.id IN (c.id, c.comment_id)
LEFT JOIN `users` AS u
ON u.id = c.user_id
WHERE section = "shop"
AND parent_id = 12
AND c.active = 1
ORDER BY created DESC;
32. count | total: 1 . SELECT COUNT(*) as NUMROWS FROM information_schema.tables WHERE (TABLE_SCHEMA = 'eoemtea_online') AND (TABLE_NAME = 'mod_shop') LIMIT 1;
33. count | total: 1 . SELECT COUNT(*) as NUMROWS FROM information_schema.tables WHERE (TABLE_SCHEMA = 'eoemtea_online') AND (TABLE_NAME = 'mod_shop_categories') LIMIT 1;
34. select | total: 1 . SELECT * FROM `mod_shop_categories` WHERE id = 48 AND active = 1 LIMIT 1;
35. count | total: 1 . SELECT COUNT(*) as NUMROWS FROM information_schema.tables WHERE (TABLE_SCHEMA = 'eoemtea_online') AND (TABLE_NAME = 'mod_shop_related_categories') LIMIT 1;
36. SELECT | total: 4 . SELECT d.*
FROM `mod_shop` AS d
LEFT JOIN `mod_shop_related_categories` AS rc ON rc.item_id = d.id
WHERE d.active = 1
AND (d.category_id = 48 OR rc.category_id = 48) AND d.id <> 12
GROUP BY d.id
ORDER BY d.created DESC
LIMIT 437. count | total: 1 . SELECT COUNT(*) as NUMROWS FROM information_schema.tables WHERE (TABLE_SCHEMA = 'eoemtea_online') AND (TABLE_NAME = 'pages') LIMIT 1;
38. SELECT | total: 4 . SELECT * FROM `pages` WHERE active = 1 AND page_type = 'normal' ORDER BY id LIMIT 4
39. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_settings" LIMIT 1
40. select | total: 6 . SELECT * FROM `mod_support_settings` ;
41. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
42. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
43. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
44. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" AND COLUMN_NAME = "name_en" LIMIT 1
45. UPDATE | total: 0 . UPDATE `mod_support_departments` SET `name_en` = `name` WHERE `name_en` = '' OR `name_en` IS NULL
46. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
47. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" AND COLUMN_NAME = "name_cn" LIMIT 1
48. UPDATE | total: 0 . UPDATE `mod_support_departments` SET `name_cn` = `name` WHERE `name_cn` = '' OR `name_cn` IS NULL
49. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
50. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" AND COLUMN_NAME = "name_ru" LIMIT 1
51. UPDATE | total: 0 . UPDATE `mod_support_departments` SET `name_ru` = `name` WHERE `name_ru` = '' OR `name_ru` IS NULL
52. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
53. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" AND COLUMN_NAME = "name_en" LIMIT 1
54. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" LIMIT 1
55. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_departments" AND COLUMN_NAME = "name" LIMIT 1
56. SELECT | total: 3 . SELECT d.*, COALESCE(NULLIF(`d`.`name_en`, ''), NULLIF(`d`.`name`, '')) AS department_name
FROM `mod_support_departments` AS d
WHERE active = 1
ORDER BY d.sorting, department_name57. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" LIMIT 1
58. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_conversations" LIMIT 1
59. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" LIMIT 1
60. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" AND COLUMN_NAME = "department_ids" LIMIT 1
61. SELECT | total: 1 . SELECT a.*, COUNT(c.id) AS active_count
FROM `mod_support_agents` AS a
LEFT JOIN `mod_support_conversations` AS c ON c.agent_id = a.id AND c.status <> 'closed' AND c.queue_status = 'accepted'
WHERE (a.department_id = 1 OR FIND_IN_SET(1, a.department_ids)) AND a.active = 1 AND a.auto_assign = 1 AND a.status = 'online'
GROUP BY a.id
HAVING active_count < a.max_conversations
ORDER BY active_count ASC, a.updated DESC
LIMIT 162. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" LIMIT 1
63. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_conversations" LIMIT 1
64. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" LIMIT 1
65. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" AND COLUMN_NAME = "department_ids" LIMIT 1
66. SELECT | total: 1 . SELECT a.*, COUNT(c.id) AS active_count
FROM `mod_support_agents` AS a
LEFT JOIN `mod_support_conversations` AS c ON c.agent_id = a.id AND c.status <> 'closed' AND c.queue_status = 'accepted'
WHERE (a.department_id = 2 OR FIND_IN_SET(2, a.department_ids)) AND a.active = 1 AND a.auto_assign = 1 AND a.status = 'online'
GROUP BY a.id
HAVING active_count < a.max_conversations
ORDER BY active_count ASC, a.updated DESC
LIMIT 167. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" LIMIT 1
68. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_conversations" LIMIT 1
69. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" LIMIT 1
70. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_agents" AND COLUMN_NAME = "department_ids" LIMIT 1
71. SELECT | total: 1 . SELECT a.*, COUNT(c.id) AS active_count
FROM `mod_support_agents` AS a
LEFT JOIN `mod_support_conversations` AS c ON c.agent_id = a.id AND c.status <> 'closed' AND c.queue_status = 'accepted'
WHERE (a.department_id = 3 OR FIND_IN_SET(3, a.department_ids)) AND a.active = 1 AND a.auto_assign = 1 AND a.status = 'online'
GROUP BY a.id
HAVING active_count < a.max_conversations
ORDER BY active_count ASC, a.updated DESC
LIMIT 172. SELECT | total: 1 . SELECT COUNT(*) AS total FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = "mod_support_settings" LIMIT 1
73. select | total: 6 . SELECT * FROM `mod_support_settings` ;
