0.0005729
| Memory Before: 2.29 Mb
| Memory After: 2.3 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 = '651a9d6b4a9022d2e4efd8ac1ad71db6' 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.0005250
| 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 = '1786987926', user_id = '0', location = '/mobile/document/category/7/aniztasun-kulturala/sort_most-viewed/', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.145', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.'
WHERE session_hash = '651a9d6b4a9022d2e4efd8ac1ad71db6'
| 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.0002379
| Memory Before: 3.62 Mb
| Memory After: 3.63 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.0001040
| Memory Before: 3.63 Mb
| Memory After: 3.63 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.0012221
| Memory Before: 5.91 Mb
| Memory After: 5.91 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 = 7
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 | 27 | |
| 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.0074720
| Memory Before: 5.91 Mb
| Memory After: 5.96 Mb
| Memory Used: 52.5 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 = 7
GROUP BY m.document_id
ORDER BY m.total_view
DESC
LIMIT 9
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | dt | ALL | | MISSING KEY | | | 733 | Using temporary; Using filesort |
| 1 | SIMPLE | mcd | ref|filter | category_id,document_id | document_id|category_id | 4|4 | sqlgipsol.dt.document_id | 1 (4%) | 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.0003982
| Memory Before: 6.48 Mb
| Memory After: 6.48 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 = 4
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.0003719
| Memory Before: 6.64 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 = 270
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.0002851
| Memory Before: 6.65 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 = 317
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.0003128
| Memory Before: 6.66 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 = 765
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.0002751
| Memory Before: 6.67 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 = 43
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.0002520
| 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 = 44
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.0003130
| Memory Before: 6.7 Mb
| Memory After: 6.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 = 150
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.0002971
| Memory Before: 6.71 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 = 231
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.0003121
| Memory Before: 6.72 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 = 232
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.0002480
| Memory Before: 7.58 Mb
| Memory After: 7.58 Mb
| Memory Used: 3.36 kb
| Rows: 0
| Slave: No
SELECT event_id, image_path
FROM phpfox_fevent
WHERE end_time < 1735689600 AND image_path != "" AND image_path != "af9e5ac6fdf7acdeabaaebb4e50a5d84%s.jpg"
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_fevent | ALL | | MISSING KEY | | | 9465 | Using where |
0.0003798
| Memory Before: 7.58 Mb
| Memory After: 7.58 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_cron
SET next_run = '1786987926', last_run = '1786987926'
WHERE cron_id = 5
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_cron | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0002329
| Memory Before: 7.58 Mb
| Memory After: 7.58 Mb
| Memory Used: 1.29 kb
| Rows: -
| Slave: No
INSERT INTO phpfox_cron_log (cron_id, time_stamp) VALUES ('5', '1786987926')
0.0001900
| Memory Before: 8.05 Mb
| Memory After: 8.06 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.0002511
| Memory Before: 9.31 Mb
| Memory After: 9.32 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.0001910
| Memory Before: 9.5 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 = '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.0001168
| Memory Before: 9.64 Mb
| Memory After: 9.64 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 = '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.0000980
| Memory Before: 9.66 Mb
| Memory After: 9.66 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.0002010
| Memory Before: 9.69 Mb
| Memory After: 9.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 = '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.0001328
| Memory Before: 9.71 Mb
| Memory After: 9.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 = '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.0001910
| Memory Before: 9.71 Mb
| Memory After: 9.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 = '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.0001040
| 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 = '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.0001998
| Memory Before: 9.75 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 = '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.0001380
| Memory Before: 9.92 Mb
| Memory After: 9.92 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.0001929
| Memory Before: 9.95 Mb
| Memory After: 9.95 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.0001431
| Memory Before: 9.96 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 = '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.0001099
| Memory Before: 9.96 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 = '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.0002079
| 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 = '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.0001209
| Memory Before: 9.99 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 = '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: 10.01 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 = '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: 10.01 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 = '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.0001581
| Memory Before: 10.01 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 = '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.0001922
| Memory Before: 10.01 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 = '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.0002079
| Memory Before: 10.01 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 = '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.0002100
| 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 = '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.0001500
| Memory Before: 10.03 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 = '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.0001941
| Memory Before: 10.03 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 = '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.0002089
| 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 = '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.0002480
| Memory Before: 10.09 Mb
| Memory After: 10.11 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 | 685 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.d.user_id | 1 | |
0.0001051
| Memory Before: 10.13 Mb
| Memory After: 10.14 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.0000970
| Memory Before: 10.14 Mb
| Memory After: 10.14 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.0001009
| Memory Before: 10.15 Mb
| Memory After: 10.15 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.0011370
| Memory Before: 10.19 Mb
| Memory After: 10.19 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
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 = 7
/* 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 | 27 | |
| 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.0001161
| Memory Before: 10.19 Mb
| Memory After: 10.2 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.0000980
| Memory Before: 10.2 Mb
| Memory After: 10.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 = '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.0000861
| Memory Before: 10.21 Mb
| Memory After: 10.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 = '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.0039539
| Memory Before: 10.25 Mb
| Memory After: 10.27 Mb
| Memory Used: 21.25 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 = 7
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 | 27 | 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.0001690
| Memory Before: 10.22 Mb
| Memory After: 10.23 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.0000989
| Memory Before: 10.23 Mb
| Memory After: 10.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 = '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.0000870
| Memory Before: 10.24 Mb
| Memory After: 10.24 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 = '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.0002279
| Memory Before: 10.32 Mb
| Memory After: 10.33 Mb
| Memory Used: 15.14 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 | | 685 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.d.user_id | 1 | |
0.0001061
| Memory Before: 10.32 Mb
| Memory After: 10.32 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.0000939
| Memory Before: 10.32 Mb
| Memory After: 10.33 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.0000820
| Memory Before: 10.33 Mb
| Memory After: 10.33 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.0001900
| Memory Before: 10.33 Mb
| Memory After: 10.33 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 |