0.0004919
| 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 = 'ff328f3b82942ed396be6270939689f8' 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.0005341
| Memory Before: 2.3 Mb
| Memory After: 2.3 Mb
| Memory Used: 1.43 kb
| Rows: -
| Slave: No
UPDATE phpfox_log_session
SET last_activity = '1765389137', user_id = '0', location = '/document/show_15/when_all-time/sort_latest/page_3', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.221', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.'
WHERE session_hash = 'ff328f3b82942ed396be6270939689f8'
| 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.0001552
| Memory Before: 3.62 Mb
| Memory After: 3.62 Mb
| Memory Used: 4.95 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.0001230
| Memory Before: 3.62 Mb
| Memory After: 3.62 Mb
| Memory Used: 3.18 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.0001481
| Memory Before: 5.95 Mb
| Memory After: 5.95 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_document
AS m
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)
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | in_process,in_process_2,in_process_3,in_process_4,in_process_5 | in_process | 1 | const | 668 | Using where |
0.0137310
| Memory Before: 5.95 Mb
| Memory After: 5.99 Mb
| Memory Used: 46.48 kb
| Rows: 15
| 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
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)
ORDER BY m.time_stamp
DESC
LIMIT 15
OFF SET 30
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | dt | ALL | | MISSING KEY | | | 714 | Using temporary; Using filesort |
| 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.0001709
| Memory Before: 6.56 Mb
| Memory After: 6.56 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.0001540
| Memory Before: 6.61 Mb
| Memory After: 6.62 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 = 889
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.0000961
| Memory Before: 6.62 Mb
| Memory After: 6.63 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 = 888
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.0000832
| Memory Before: 6.63 Mb
| Memory After: 6.64 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 = 887
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.0000768
| Memory Before: 6.65 Mb
| Memory After: 6.65 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 = 886
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.0000770
| Memory Before: 6.66 Mb
| Memory After: 6.66 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 = 884
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.0000770
| Memory Before: 6.67 Mb
| Memory After: 6.67 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 = 883
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.0000770
| Memory Before: 6.68 Mb
| Memory After: 6.68 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 = 879
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 | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0000761
| Memory Before: 6.69 Mb
| Memory After: 6.69 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 = 881
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.0000792
| Memory Before: 6.7 Mb
| Memory After: 6.71 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 = 880
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.0000792
| 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 = 874
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.0000780
| Memory Before: 6.72 Mb
| Memory After: 6.73 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 = 873
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.0000849
| Memory Before: 6.73 Mb
| Memory After: 6.74 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 = 872
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.0000842
| Memory Before: 6.75 Mb
| Memory After: 6.75 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 = 871
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.0000911
| Memory Before: 6.76 Mb
| Memory After: 6.76 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 = 870
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.0001421
| Memory Before: 7.98 Mb
| Memory After: 7.98 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.0001700
| Memory Before: 9.07 Mb
| Memory After: 9.08 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.0001221
| Memory Before: 9.27 Mb
| Memory After: 9.27 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.0001070
| Memory Before: 9.44 Mb
| Memory After: 9.44 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.0001109
| Memory Before: 9.46 Mb
| Memory After: 9.46 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.0001059
| Memory Before: 9.46 Mb
| Memory After: 9.46 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.0001080
| Memory Before: 9.48 Mb
| Memory After: 9.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 = '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.0001040
| Memory Before: 9.48 Mb
| Memory After: 9.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 = '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.0001020
| Memory Before: 9.51 Mb
| Memory After: 9.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 = '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.0001020
| Memory Before: 9.52 Mb
| Memory After: 9.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 = '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.0001070
| Memory Before: 9.69 Mb
| Memory After: 9.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 = '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.0001111
| Memory Before: 9.73 Mb
| Memory After: 9.73 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.0001011
| Memory Before: 9.74 Mb
| Memory After: 9.74 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 = 'category.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.0000942
| Memory Before: 9.74 Mb
| Memory After: 9.74 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 = 'category.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.0001070
| Memory Before: 9.79 Mb
| Memory After: 9.79 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 = 'category.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.0001061
| Memory Before: 9.76 Mb
| Memory After: 9.76 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.0001080
| Memory Before: 9.79 Mb
| Memory After: 9.79 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-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.0001040
| Memory Before: 9.79 Mb
| Memory After: 9.8 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.0001051
| Memory Before: 9.8 Mb
| Memory After: 9.8 Mb
| Memory Used: 3.15 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.0001030
| Memory Before: 9.82 Mb
| Memory After: 9.82 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.0001128
| Memory Before: 9.82 Mb
| Memory After: 9.82 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.0001061
| Memory Before: 9.82 Mb
| Memory After: 9.83 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.0001051
| Memory Before: 9.82 Mb
| Memory After: 9.83 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.0001130
| Memory Before: 9.83 Mb
| Memory After: 9.83 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.0001101
| Memory Before: 9.84 Mb
| Memory After: 9.85 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.0001190
| Memory Before: 9.84 Mb
| Memory After: 9.85 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.0001142
| Memory Before: 9.85 Mb
| Memory After: 9.85 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.0001049
| Memory Before: 9.85 Mb
| Memory After: 9.85 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.0001051
| Memory Before: 9.85 Mb
| Memory After: 9.85 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.0001650
| Memory Before: 9.85 Mb
| Memory After: 9.85 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.0001140
| Memory Before: 9.87 Mb
| Memory After: 9.87 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.0001900
| Memory Before: 9.87 Mb
| Memory After: 9.87 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.0002329
| Memory Before: 9.87 Mb
| Memory After: 9.87 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.0002081
| Memory Before: 9.87 Mb
| Memory After: 9.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 = '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.0001299
| Memory Before: 9.88 Mb
| Memory After: 9.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 = '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.0001369
| Memory Before: 9.93 Mb
| Memory After: 9.94 Mb
| Memory Used: 15.15 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 | 668 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.d.user_id | 1 | |
0.0001040
| Memory Before: 9.97 Mb
| Memory After: 9.97 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.0001070
| Memory Before: 9.98 Mb
| Memory After: 9.98 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.0000942
| Memory Before: 9.98 Mb
| Memory After: 9.99 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.0001080
| Memory Before: 10.03 Mb
| Memory After: 10.03 Mb
| Memory Used: 3.5 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
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)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | view_id,view_id_2 | MISSING KEY | | | 718 | Using where |
0.0001070
| 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 = '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.0001140
| Memory Before: 10.04 Mb
| Memory After: 10.04 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 = 'document' AND name = 'block/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.0000939
| Memory Before: 10.04 Mb
| Memory After: 10.05 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 = 'document' AND name = 'block/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.0001349
| Memory Before: 10.09 Mb
| Memory After: 10.11 Mb
| Memory Used: 20.76 kb
| Rows: 4
| Slave: No
SELECT *
FROM phpfox_document
AS m
JOIN phpfox_user
AS u
ON(m.user_id = u.user_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)
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 | m | 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 | | 668 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.m.user_id | 1 | |
0.0001109
| Memory Before: 10.01 Mb
| Memory After: 10.01 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.0001061
| Memory Before: 10.02 Mb
| Memory After: 10.02 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.0000970
| Memory Before: 10.02 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 = '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.0002139
| Memory Before: 10.09 Mb
| Memory After: 10.1 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 | | 668 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.d.user_id | 1 | |
0.0001199
| Memory Before: 10.09 Mb
| Memory After: 10.09 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.0001080
| Memory Before: 10.1 Mb
| Memory After: 10.1 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.0000980
| Memory Before: 10.1 Mb
| Memory After: 10.1 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.0001230
| Memory Before: 10.1 Mb
| Memory After: 10.1 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 |
Crear nuevo documento
