0.0005081
| Memory Before: 2.29 Mb
| Memory After: 2.29 Mb
| Memory Used: 3.86 kb
| 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 = 'bc204101f12e87d389609ca23972dc9b' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | s | ref | session_hash,log_session | session_hash | 32 | const | 1 | Using index condition; Using where |
0.0004549
| Memory Before: 2.3 Mb
| Memory After: 2.3 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_log_session
SET last_activity = '1765888147', user_id = '0', location = '/document/category/15/inklusioa', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.151', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.'
WHERE session_hash = 'bc204101f12e87d389609ca23972dc9b'
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_log_session | ref | session_hash,log_session | session_hash | 32 | const | 1 | Using index condition |
0.0002511
| Memory Before: 3.62 Mb
| Memory After: 3.62 Mb
| Memory Used: 4.97 kb
| 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, t.total_column, s.l_width, s.c_width, s.r_width
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 | sqlgipsol.s.theme_id | 1 | |
0.0001130
| Memory Before: 3.62 Mb
| Memory After: 3.62 Mb
| Memory Used: 3.2 kb
| Rows: 1
| Slave: No
SELECT folder
AS parent_style_folder
FROM phpfox_theme_style
WHERE style_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_style | const | style_id_2,style_id | style_id_2 | 2 | const | 1 | |
0.0025411
| Memory Before: 6.17 Mb
| Memory After: 6.18 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_document
AS m
INNER JOIN phpfox_document_category_data
AS mcd
ON(mcd.document_id = m.document_id)
WHERE m.is_approved = 1 AND m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND mcd.category_id = 15
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | mcd | ref | category_id,document_id | category_id | 4 | const | 59 | |
| 1 | SIMPLE | m | eq_ref | PRIMARY,in_process,document_id_2,in_process_2,in_process_3,in_process_4,in_process_5,document_id,document_id_3 | PRIMARY | 4 | sqlgipsol.mcd.document_id | 1 | Using where |
0.0224090
| Memory Before: 6.18 Mb
| Memory After: 6.2 Mb
| Memory Used: 19.82 kb
| Rows: 9
| Slave: Yes
SELECT dt.*, m.*, u.user_id, u.profile_page_id, u.server_id
AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_document
AS m
INNER JOIN phpfox_document_category_data
AS mcd
ON(mcd.document_id = m.document_id)
JOIN phpfox_document_text
AS dt
ON(dt.document_id = m.document_id)
JOIN phpfox_user
AS u
ON(u.user_id = m.user_id)
WHERE m.is_approved = 1 AND m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND mcd.category_id = 15
GROUP BY m.document_id
ORDER BY m.time_stamp
DESC
LIMIT 9
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | dt | ALL | | MISSING KEY | | | 729 | Using temporary; Using filesort |
| 1 | SIMPLE | mcd | ref|filter | category_id,document_id | document_id|category_id | 4|4 | sqlgipsol.dt.document_id | 1 (8%) | Using index condition; Using where; Using rowid filter |
| 1 | SIMPLE | m | eq_ref | PRIMARY,user_id,in_process,document_id_2,in_process_2,in_process_3,in_process_4,in_process_5,document_id,document_id_3,view_id_4 | PRIMARY | 4 | sqlgipsol.dt.document_id | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.m.user_id | 1 | |
0.0004549
| Memory Before: 6.71 Mb
| Memory After: 6.72 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data
AS pcd
JOIN phpfox_document_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 940
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,document_id | document_id | 4 | const | 3 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0003989
| Memory Before: 6.93 Mb
| Memory After: 6.93 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data
AS pcd
JOIN phpfox_document_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 935
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,document_id | document_id | 4 | const | 3 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002880
| Memory Before: 6.94 Mb
| Memory After: 6.94 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data
AS pcd
JOIN phpfox_document_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 933
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,document_id | document_id | 4 | const | 3 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002940
| Memory Before: 6.95 Mb
| Memory After: 6.95 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data
AS pcd
JOIN phpfox_document_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 931
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,document_id | document_id | 4 | const | 3 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002861
| Memory Before: 6.96 Mb
| Memory After: 6.97 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data
AS pcd
JOIN phpfox_document_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 932
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,document_id | document_id | 4 | const | 3 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002661
| Memory Before: 6.97 Mb
| Memory After: 6.98 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data
AS pcd
JOIN phpfox_document_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 928
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,document_id | document_id | 4 | const | 3 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002630
| Memory Before: 6.98 Mb
| Memory After: 6.99 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data
AS pcd
JOIN phpfox_document_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 927
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,document_id | document_id | 4 | const | 3 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002601
| Memory Before: 6.99 Mb
| Memory After: 7 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data
AS pcd
JOIN phpfox_document_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 926
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,document_id | document_id | 4 | const | 3 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002890
| Memory Before: 7.01 Mb
| Memory After: 7.01 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data
AS pcd
JOIN phpfox_document_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 890
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,document_id | document_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0001860
| Memory Before: 7.02 Mb
| Memory After: 7.02 Mb
| Memory Used: 3.19 kb
| Rows: 1
| Slave: No
SELECT category_id
FROM phpfox_document_category
WHERE category_id = '15'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_document_category | const | PRIMARY | PRIMARY | 3 | const | 1 | Using index |
0.0001609
| Memory Before: 7.02 Mb
| Memory After: 7.03 Mb
| Memory Used: 3.4 kb
| Rows: 1
| Slave: No
SELECT pc.category_id, pc.parent_id
FROM phpfox_document_category
AS pc
WHERE pc.category_id = 15
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pc | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0001268
| Memory Before: 7.02 Mb
| Memory After: 7.03 Mb
| Memory Used: 3.37 kb
| Rows: 0
| Slave: No
SELECT pc.category_id, pc.parent_id
FROM phpfox_document_category
AS pc
WHERE pc.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.0002210
| Memory Before: 7.03 Mb
| Memory After: 7.03 Mb
| Memory Used: 5.02 kb
| Rows: 1
| Slave: No
SELECT *
FROM phpfox_document_category
WHERE category_id IN(15)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_document_category | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0002210
| Memory Before: 8.27 Mb
| Memory After: 8.28 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'template.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002160
| Memory Before: 9.66 Mb
| Memory After: 9.67 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-body.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002499
| Memory Before: 9.86 Mb
| Memory After: 9.86 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'cabecera.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002151
| Memory Before: 10 Mb
| Memory After: 10.01 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001171
| Memory Before: 10.03 Mb
| Memory After: 10.03 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002429
| Memory Before: 21.19 Mb
| Memory After: 21.19 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002129
| Memory Before: 21.2 Mb
| Memory After: 21.21 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-holdername.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002339
| Memory Before: 21.21 Mb
| Memory After: 21.21 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'breadcrumb.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0001431
| Memory Before: 21.24 Mb
| Memory After: 21.24 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-breadcrumblist.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002131
| Memory Before: 21.25 Mb
| Memory After: 21.26 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-breadcrumbmenu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002100
| Memory Before: 21.42 Mb
| Memory After: 21.42 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-menusub.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0005760
| Memory Before: 21.44 Mb
| Memory After: 21.44 Mb
| Memory Used: 3.59 kb
| Rows: 0
| Slave: No
SELECT mc.category_id, mc.name, mc.name_url
FROM phpfox_document_category
AS mc
WHERE mc.parent_id = 15 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | mc | ref | parent_id,is_active | parent_id | 4 | const,const | 1 | Using where; Using filesort |
0.0001531
| Memory Before: 21.44 Mb
| Memory After: 21.45 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'search.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002139
| Memory Before: 21.47 Mb
| Memory After: 21.48 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-contentclass.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002201
| Memory Before: 21.48 Mb
| Memory After: 21.48 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'error.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002160
| Memory Before: 21.48 Mb
| Memory After: 21.49 Mb
| Memory Used: 3.17 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'controller' AND module_id = 'document' AND name = 'index.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0004480
| Memory Before: 21.5 Mb
| Memory After: 21.5 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002232
| Memory Before: 21.5 Mb
| Memory After: 21.51 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002170
| Memory Before: 21.51 Mb
| Memory After: 21.51 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002179
| Memory Before: 21.51 Mb
| Memory After: 21.51 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002151
| Memory Before: 21.51 Mb
| Memory After: 21.51 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002151
| Memory Before: 21.51 Mb
| Memory After: 21.51 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002191
| Memory Before: 21.53 Mb
| Memory After: 21.53 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002401
| Memory Before: 21.53 Mb
| Memory After: 21.53 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002341
| Memory Before: 21.53 Mb
| Memory After: 21.53 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002172
| Memory Before: 21.54 Mb
| Memory After: 21.54 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'pager.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0050209
| Memory Before: 21.59 Mb
| Memory After: 21.6 Mb
| Memory Used: 15.13 kb
| Rows: 4
| Slave: Yes
SELECT d.*, u.user_id, u.profile_page_id, u.server_id
AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_document
AS d
JOIN phpfox_user
AS u
ON(u.user_id = d.user_id)
WHERE d.is_approved = 1 AND d.view_id = 0 AND d.module_id = 'document' AND d.item_id = 0 AND d.privacy = 0 AND d.is_featured = 1
LIMIT 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | d | ref | view_id,user_id,in_process,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,view_id_4 | in_process | 1 | const | 681 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.d.user_id | 1 | |
0.0002110
| Memory Before: 21.63 Mb
| Memory After: 21.63 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0004501
| Memory Before: 21.64 Mb
| Memory After: 21.64 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'featured.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001190
| Memory Before: 21.64 Mb
| Memory After: 21.65 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'featured.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0014529
| Memory Before: 21.69 Mb
| Memory After: 21.69 Mb
| Memory Used: 3.51 kb
| Rows: 1
| Slave: No
SELECT count(*) as total_documents, sum(m.total_view) as total_views, sum(m.total_like) as total_likes
FROM phpfox_document
AS m
JOIN phpfox_document_category_data
AS dcd
ON(m.document_id = dcd.document_id)
WHERE m.in_process = 0 AND m.view_id = 0 AND m.module_id = 'document' AND m.item_id = 0 AND m.privacy IN(0) AND dcd.category_id = 15
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | dcd | ref | category_id,document_id | category_id | 4 | const | 59 | |
| 1 | SIMPLE | m | eq_ref | PRIMARY,view_id,document_id_2,view_id_2,document_id,document_id_3 | PRIMARY | 4 | sqlgipsol.dcd.document_id | 1 | Using where |
0.0001030
| Memory Before: 21.69 Mb
| Memory After: 21.69 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0003300
| Memory Before: 21.7 Mb
| Memory After: 21.7 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'statistic.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0000958
| Memory Before: 21.7 Mb
| Memory After: 21.71 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'statistic.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0115180
| Memory Before: 21.75 Mb
| Memory After: 21.8 Mb
| Memory Used: 53.27 kb
| Rows: 4
| Slave: No
SELECT *
FROM phpfox_document
AS m
JOIN phpfox_user
AS u
ON(m.user_id = u.user_id)
JOIN phpfox_document_category_data
AS dcd
ON(m.document_id = dcd.document_id)
WHERE m.in_process = 0 AND m.is_approved=1 AND m.view_id = 0 AND m.module_id = 'document' AND m.item_id = 0 AND m.privacy IN(0) AND dcd.category_id = 15
ORDER BY m.total_view
DESC
LIMIT 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | dcd | ref | category_id,document_id | category_id | 4 | const | 59 | Using temporary; Using filesort |
| 1 | SIMPLE | m | eq_ref | PRIMARY,view_id,user_id,in_process,document_id_2,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,document_id,document_id_3,view_id_4 | PRIMARY | 4 | sqlgipsol.dcd.document_id | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.m.user_id | 1 | |
0.0001738
| Memory Before: 21.75 Mb
| Memory After: 21.76 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0005600
| Memory Before: 21.76 Mb
| Memory After: 21.77 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'topview.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0000939
| Memory Before: 21.77 Mb
| Memory After: 21.77 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'topview.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0040250
| Memory Before: 21.85 Mb
| Memory After: 21.86 Mb
| Memory Used: 15.13 kb
| Rows: 4
| Slave: Yes
SELECT d.*, u.user_id, u.profile_page_id, u.server_id
AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_document
AS d
JOIN phpfox_user
AS u
ON(u.user_id = d.user_id)
WHERE d.is_approved = 1 AND d.view_id = 0 AND d.module_id = 'document' AND d.item_id = 0 AND d.privacy = 0
ORDER BY d.total_comment
DESC
LIMIT 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | d | range | view_id,user_id,in_process,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,view_id_4 | in_process | 1 | | 681 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.d.user_id | 1 | |
0.0001659
| Memory Before: 21.88 Mb
| Memory After: 21.88 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0003841
| Memory Before: 21.89 Mb
| Memory After: 21.89 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'mostdiscussed.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001202
| Memory Before: 21.89 Mb
| Memory After: 21.9 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'mostdiscussed.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002129
| Memory Before: 21.86 Mb
| Memory After: 21.86 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menufooter.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |