0.0004392
| Memory Before: 1.59 Mb
| Memory After: 1.59 Mb
| Memory Used: 368 b
| Rows: 1
| Slave: No
SELECT s.session_hash, s.id_hash, s.captcha_hash, s.user_id
FROM phpfox_log_session
AS s
WHERE s.session_hash = 'f3d5a875be8fdbc3758a1d3b831bc010' AND s.id_hash = 'af7937af3e4465b9039e98887dc0bc04'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | s | ref | session_hash,log_session | log_session | 192 | const,const | 1 | Using where |
0.0004470
| Memory Before: 1.6 Mb
| Memory After: 1.6 Mb
| Memory Used: 808 b
| Rows: -
| Slave: No
UPDATE phpfox_log_session
SET last_activity = '1337701813', user_id = '0', location = '/group/category/category-1/', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '38.107.179.219', user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
WHERE session_hash = 'f3d5a875be8fdbc3758a1d3b831bc010'
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_log_session | ref | session_hash,log_session | log_session | 96 | const | 1 | Using where |
0.0003421
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 264 b
| Rows: 3
| Slave: No
SELECT loc_id,loc_name,isbanned
FROM sc_locswitch
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | sc_locswitch | ALL | | MISSING KEY | | | 3 | |
0.0002980
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 728 b
| Rows: 1
| Slave: No
SELECT count(*)
FROM phpfox_country
WHERE isbanned =1 and country_iso = ''
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0002840
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 328 b
| Rows: 1
| Slave: No
SELECT count(*)
FROM sc_city_ban
WHERE isbanned =1 and city = 'Unknown'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0002651
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 344 b
| Rows: 1
| Slave: No
SELECT count(*)
FROM sc_zip_ban
WHERE isbanned =1 and zip = 'Unknown'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0004480
| Memory Before: 2.18 Mb
| Memory After: 2.18 Mb
| Memory Used: 912 b
| Rows: 1
| Slave: No
SELECT s.style_id, s.parent_id
AS style_parent_id, s.folder
AS style_folder_name, t.folder
AS theme_folder_name, t.parent_id
AS theme_parent_id
FROM phpfox_theme_style
AS s
JOIN phpfox_theme
AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | s | ref | is_default | is_default | 1 | const | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | phpfoxdev.s.theme_id | 1 | |
0.0010140
| Memory Before: 3.13 Mb
| Memory After: 3.13 Mb
| Memory Used: 440 b
| Rows: 1
| Slave: Yes
SELECT COUNT(DISTINCT m.group_id)
FROM phpfox_group
AS m
INNER JOIN phpfox_group_category_data
AS mcd
ON(mcd.group_id = m.group_id)
WHERE m.view_id IN(0,1) AND mcd.category_id IN(1,2,3)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | mcd | ALL | category_id,group_id | MISSING KEY | | | 97 | Using where |
| 1 | SIMPLE | m | eq_ref | PRIMARY,view_id,view_id_3,group_id | PRIMARY | 4 | phpfoxdev.mcd.group_id | 1 | Using where |
0.0027659
| Memory Before: 3.26 Mb
| Memory After: 3.26 Mb
| Memory Used: 320 b
| Rows: 12
| Slave: Yes
SELECT ei.member_id, m.*, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_group
AS m
INNER JOIN phpfox_group_category_data
AS mcd
ON(mcd.group_id = m.group_id)
LEFT JOIN phpfox_group_invite
AS ei
ON(ei.group_id = m.group_id AND ei.invited_user_id = 0)
JOIN phpfox_user
AS u
ON(u.user_id = m.user_id)
WHERE m.view_id IN(0,1) AND mcd.category_id IN(1,2,3)
GROUP BY m.group_id
ORDER BY m.is_featured
DESC , m.time_stamp
DESC
LIMIT 12
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | mcd | range | category_id,group_id | category_id | 4 | | 93 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | m | eq_ref | PRIMARY,view_id,view_id_3,group_id | PRIMARY | 4 | phpfoxdev.mcd.group_id | 1 | Using where |
| 1 | SIMPLE | ei | ref | group_id,invited_user_id,group_id_2,group_id_3,group_id_4,group_id_5 | invited_user_id | 4 | const | 1 | |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | phpfoxdev.m.user_id | 1 | |
0.0004940
| Memory Before: 3.28 Mb
| Memory After: 3.29 Mb
| Memory Used: 800 b
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_group_category_data
AS pcd
JOIN phpfox_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 60
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,group_id | group_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0004802
| Memory Before: 3.29 Mb
| Memory After: 3.29 Mb
| Memory Used: 464 b
| Rows: 2
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_group_category_data
AS pcd
JOIN phpfox_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 59
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,group_id | group_id | 4 | const | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0005021
| Memory Before: 3.29 Mb
| Memory After: 3.29 Mb
| Memory Used: 384 b
| Rows: 2
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_group_category_data
AS pcd
JOIN phpfox_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 58
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,group_id | group_id | 4 | const | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0003278
| Memory Before: 3.29 Mb
| Memory After: 3.29 Mb
| Memory Used: 536 b
| Rows: 1
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_group_category | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0002840
| Memory Before: 3.29 Mb
| Memory After: 3.29 Mb
| Memory Used: 824 b
| Rows: 0
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0004930
| Memory Before: 3.3 Mb
| Memory After: 3.3 Mb
| Memory Used: 240 b
| Rows: 2
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_group_category_data
AS pcd
JOIN phpfox_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 57
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,group_id | group_id | 4 | const | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0003312
| Memory Before: 3.3 Mb
| Memory After: 3.3 Mb
| Memory Used: 536 b
| Rows: 1
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_group_category | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0002780
| Memory Before: 3.3 Mb
| Memory After: 3.3 Mb
| Memory Used: 824 b
| Rows: 0
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0004811
| Memory Before: 3.3 Mb
| Memory After: 3.3 Mb
| Memory Used: 240 b
| Rows: 2
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_group_category_data
AS pcd
JOIN phpfox_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 56
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,group_id | group_id | 4 | const | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0003250
| Memory Before: 3.3 Mb
| Memory After: 3.3 Mb
| Memory Used: 536 b
| Rows: 1
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_group_category | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0002820
| Memory Before: 3.3 Mb
| Memory After: 3.3 Mb
| Memory Used: 824 b
| Rows: 0
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0004919
| Memory Before: 3.3 Mb
| Memory After: 3.3 Mb
| Memory Used: 240 b
| Rows: 2
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_group_category_data
AS pcd
JOIN phpfox_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 55
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,group_id | group_id | 4 | const | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0003309
| Memory Before: 3.3 Mb
| Memory After: 3.31 Mb
| Memory Used: 736 b
| Rows: 1
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_group_category | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0002818
| Memory Before: 3.31 Mb
| Memory After: 3.31 Mb
| Memory Used: 984 b
| Rows: 0
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0004730
| Memory Before: 3.31 Mb
| Memory After: 3.31 Mb
| Memory Used: 240 b
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_group_category_data
AS pcd
JOIN phpfox_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 54
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,group_id | group_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0004849
| Memory Before: 3.31 Mb
| Memory After: 3.31 Mb
| Memory Used: 512 b
| Rows: 2
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_group_category_data
AS pcd
JOIN phpfox_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 53
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,group_id | group_id | 4 | const | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0003250
| Memory Before: 3.31 Mb
| Memory After: 3.31 Mb
| Memory Used: 896 b
| Rows: 1
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_group_category | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0002809
| Memory Before: 3.31 Mb
| Memory After: 3.31 Mb
| Memory Used: 984 b
| Rows: 0
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0004930
| Memory Before: 3.32 Mb
| Memory After: 3.32 Mb
| Memory Used: 240 b
| Rows: 2
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_group_category_data
AS pcd
JOIN phpfox_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 52
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,group_id | group_id | 4 | const | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0003312
| Memory Before: 3.32 Mb
| Memory After: 3.32 Mb
| Memory Used: 896 b
| Rows: 1
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_group_category | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0002792
| Memory Before: 3.32 Mb
| Memory After: 3.32 Mb
| Memory Used: 984 b
| Rows: 0
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0004790
| Memory Before: 3.32 Mb
| Memory After: 3.32 Mb
| Memory Used: 240 b
| Rows: 2
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_group_category_data
AS pcd
JOIN phpfox_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 51
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,group_id | group_id | 4 | const | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0003281
| Memory Before: 3.32 Mb
| Memory After: 3.32 Mb
| Memory Used: 896 b
| Rows: 1
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_group_category | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0002842
| Memory Before: 3.32 Mb
| Memory After: 3.32 Mb
| Memory Used: 984 b
| Rows: 0
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0004959
| Memory Before: 3.33 Mb
| Memory After: 3.33 Mb
| Memory Used: 240 b
| Rows: 2
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_group_category_data
AS pcd
JOIN phpfox_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 50
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,group_id | group_id | 4 | const | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0003309
| Memory Before: 3.33 Mb
| Memory After: 3.33 Mb
| Memory Used: 896 b
| Rows: 1
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_group_category | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0002770
| Memory Before: 3.33 Mb
| Memory After: 3.33 Mb
| Memory Used: 984 b
| Rows: 0
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0004811
| Memory Before: 3.33 Mb
| Memory After: 3.33 Mb
| Memory Used: 240 b
| Rows: 2
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_group_category_data
AS pcd
JOIN phpfox_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 49
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,group_id | group_id | 4 | const | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0003328
| Memory Before: 3.33 Mb
| Memory After: 3.33 Mb
| Memory Used: 896 b
| Rows: 1
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_group_category | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0002820
| Memory Before: 3.33 Mb
| Memory After: 3.33 Mb
| Memory Used: 984 b
| Rows: 0
| Slave: No
SELECT category_id, name, name_url, parent_id
FROM phpfox_group_category
WHERE category_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0009229
| Memory Before: 5.48 Mb
| Memory After: 5.48 Mb
| Memory Used: 856 b
| Rows: 10
| Slave: No
SELECT *
FROM phpfox_group
WHERE view_id IN(0,1)
ORDER BY total_member
DESC
LIMIT 10
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_group | range | view_id,view_id_3 | view_id_3 | 1 | | 59 | Using where; Using filesort |