Gipuzkoa
19 Mayo
gipuzkoasolidarioa.info, Tu Huella Solidaria
Entra y encuentra la asociación que buscas
Más información
¿Cuándo?
Comienzo: miércoles, mayo 19, 2021 14:39
Finaliza: miércoles, mayo 19, 2021 17:39
¿Dónde?
| Dirección: | Gipuzkoa |
phpFox Developers Debug
Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula
Total Time:
0.3193419
PHP General Time:
0.2942827
GZIP:
disabled
Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.0250592
SQL Queries:
76
SQL Memory Usage:
314.91 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
23.53 Mb
Total Memory Usage (Including Debug):
23.81 Mb
Memory Limit:
512 Mb (1024M)
Load Balancing Enabled:
No
Requests From:
192.168.100.222
Server Time Stamp:
December 9, 2025, 6:05 am
PHP Version:
5.6.40
PHP Sapi:
fpm-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux
Cache:
file
SQL Queries
0.0007188
| Memory Before: 2.29 Mb
| Memory After: 2.29 Mb
| Memory Used: 1.35 kb
| Rows: -
| Slave: No
INSERT INTO phpfox_log_session (session_hash, id_hash, user_id, last_activity, location, is_forum, forum_id, im_hide, ip_address, user_agent) VALUES ('40a71f6214a2060e8c10728fc39f2f69', '0d574f7196f9f96e319d05681455513d', '0', '1765260312', '/fevent/6692/la-home-de-la-solidaridad', '0', '0', '0', '216.73.216.221', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.')
0.0002580
| Memory Before: 3.61 Mb
| Memory After: 3.62 Mb
| Memory Used: 5.03 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 */
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.0001190
| 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 */
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.0002232
| Memory Before: 5.21 Mb
| Memory After: 5.21 Mb
| Memory Used: 3.13 kb
| Rows: 1
| Slave: Yes
SELECT MAX(`time_stamp`)
FROM phpfox_fevent_cron AS s
WHERE 1=1 AND `type_cron` = 'for_repeat'
LIMIT 1
/* OO Query */
FROM phpfox_fevent_cron AS s
WHERE 1=1 AND `type_cron` = 'for_repeat'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ALL | MISSING KEY | 98565 | Using where |
0.0001981
| Memory Before: 5.21 Mb
| Memory After: 5.22 Mb
| Memory Used: 3.12 kb
| Rows: 0
| Slave: Yes
SELECT p.page_id
FROM phpfox_pages AS p
JOIN phpfox_like AS l
ON(l.user_id = 0 AND l.`type_id` = 'pages' AND l.`item_id` = p.page_id)
WHERE p.view_id = 0
/* OO Query */
FROM phpfox_pages AS p
JOIN phpfox_like AS l
ON(l.user_id = 0 AND l.`type_id` = 'pages' AND l.`item_id` = p.page_id)
WHERE p.view_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l | ref | type_id,type_id_2,type_id_3,item_id | type_id_3 | 81 | const,const | 1 | Using index condition |
| 1 | SIMPLE | p | eq_ref | PRIMARY,view_id_2,view_id,page_id | PRIMARY | 4 | sqlgipsol.l.item_id | 1 | Using where |
0.0001671
| Memory Before: 5.31 Mb
| Memory After: 5.31 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT MAX(`time_stamp`)
FROM phpfox_fevent_cron AS s
WHERE 1=1 AND `type_cron` = 'for_repeat'
LIMIT 1
/* OO Query */
FROM phpfox_fevent_cron AS s
WHERE 1=1 AND `type_cron` = 'for_repeat'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ALL | MISSING KEY | 98565 | Using where |
0.0022709
| Memory Before: 5.71 Mb
| Memory After: 5.73 Mb
| Memory Used: 17.4 kb
| Rows: 1
| Slave: No
SELECT l.like_id AS is_liked, f.friend_id AS is_friend, e.*, et.description_parsed AS description, 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_fevent AS e
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'fevent' AND l.item_id = e.event_id AND l.user_id = 0)
LEFT JOIN phpfox_friend AS f
ON(f.user_id = e.user_id AND f.friend_user_id = 0)
JOIN phpfox_user AS u
ON(u.user_id = e.user_id)
JOIN phpfox_fevent_text AS et
ON(et.event_id = e.event_id)
WHERE e.event_id = 6692
/* OO Query */
FROM phpfox_fevent AS e
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'fevent' AND l.item_id = e.event_id AND l.user_id = 0)
LEFT JOIN phpfox_friend AS f
ON(f.user_id = e.user_id AND f.friend_user_id = 0)
JOIN phpfox_user AS u
ON(u.user_id = e.user_id)
JOIN phpfox_fevent_text AS et
ON(et.event_id = e.event_id)
WHERE e.event_id = 6692
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | e | const | PRIMARY,user_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | u | const | PRIMARY,user_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | type_id_3|item_id | 81|4 | const,const | 1 (1%) | Using where; Using rowid filter |
| 1 | SIMPLE | f | ref | user_check,user_id,top_friend,friend_user_id | friend_user_id | 4 | const | 1 | Using where |
| 1 | SIMPLE | et | ref | event_id | event_id | 4 | const | 1 |
0.0003672
| Memory Before: 6.06 Mb
| Memory After: 6.06 Mb
| Memory Used: 3.37 kb
| Rows: 0
| Slave: Yes
SELECT cv.value, cf.phrase_var_name
FROM phpfox_fevent_custom_value AS cv
INNER JOIN phpfox_fevent_custom_field AS cf
ON(cf.field_id = cv.field_id)
WHERE cv.event_id = 6692 AND cf.is_active = 1
/* OO Query */
FROM phpfox_fevent_custom_value AS cv
INNER JOIN phpfox_fevent_custom_field AS cf
ON(cf.field_id = cv.field_id)
WHERE cv.event_id = 6692 AND cf.is_active = 1
/* 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.0006490
| Memory Before: 6.16 Mb
| Memory After: 6.16 Mb
| Memory Used: 3.63 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name
FROM phpfox_fevent_category_data AS pcd
JOIN phpfox_fevent_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.event_id = 6692
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_fevent_category_data AS pcd
JOIN phpfox_fevent_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.event_id = 6692
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,event_id | event_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.0004511
| Memory Before: 6.74 Mb
| Memory After: 6.74 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_fevent
SET total_view = total_view + 1
WHERE event_id = 6692
SET total_view = total_view + 1
WHERE event_id = 6692
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent | const | PRIMARY | PRIMARY | 4 | const | 1 |
0.0001540
| Memory Before: 6.89 Mb
| Memory After: 6.89 Mb
| Memory Used: 3.31 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 6692 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 6692 AND user_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.0001590
| Memory Before: 8.07 Mb
| Memory After: 8.08 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 = 'template.html.php'
/* OO Query */
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.0002978
| Memory Before: 9.09 Mb
| Memory After: 9.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 = 'block' AND module_id = 'core' AND name = 'template-body.html.php'
/* OO Query */
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.0002902
| Memory Before: 9.28 Mb
| Memory After: 9.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 = 'block' AND module_id = 'higipsol' AND name = 'cabecera.html.php'
/* OO Query */
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.0000842
| Memory Before: 9.45 Mb
| Memory After: 9.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 = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */
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.0001760
| Memory Before: 9.47 Mb
| Memory After: 9.47 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 */
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.0002530
| Memory Before: 19.78 Mb
| Memory After: 19.78 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 */
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.0002551
| Memory Before: 19.79 Mb
| Memory After: 19.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 = 'block' AND module_id = 'core' AND name = 'template-holdername.html.php'
/* OO Query */
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.0002110
| Memory Before: 19.8 Mb
| Memory After: 19.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 = 'breadcrumb.html.php'
/* OO Query */
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.0001221
| Memory Before: 19.82 Mb
| Memory After: 19.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 = 'core' AND name = 'template-menusub.html.php'
/* OO Query */
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.0002849
| Memory Before: 19.83 Mb
| Memory After: 19.84 Mb
| Memory Used: 3.68 kb
| Rows: 1
| Slave: Yes
SELECT image_id, image_path, server_id
FROM phpfox_fevent_image
WHERE event_id = 6692
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_fevent_image
WHERE event_id = 6692
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent_image | ref | listing_id | listing_id | 4 | const | 1 | Using where; Using filesort |
0.0000849
| Memory Before: 19.84 Mb
| Memory After: 19.84 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 = 'fevent' AND name = 'image.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'fevent' AND name = 'image.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: 20.06 Mb
| Memory After: 20.07 Mb
| Memory Used: 5.52 kb
| Rows: 9
| Slave: Yes
SELECT *
FROM phpfox_fevent_category
WHERE parent_id=0
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_fevent_category
WHERE parent_id=0
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent_category | ALL | parent_id | MISSING KEY | 9 | Using where; Using filesort |
0.0001040
| Memory Before: 20.08 Mb
| Memory After: 20.09 Mb
| Memory Used: 4.89 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_category
WHERE parent_id=7
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_fevent_category
WHERE parent_id=7
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent_category | ref | parent_id | parent_id | 3 | const | 1 | Using where; Using filesort |
0.0000870
| Memory Before: 20.09 Mb
| Memory After: 20.09 Mb
| Memory Used: 4.91 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_category
WHERE parent_id=10
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_fevent_category
WHERE parent_id=10
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent_category | ref | parent_id | parent_id | 3 | const | 1 | Using where; Using filesort |
0.0000858
| Memory Before: 20.09 Mb
| Memory After: 20.09 Mb
| Memory Used: 4.91 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_category
WHERE parent_id=2
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_fevent_category
WHERE parent_id=2
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent_category | ref | parent_id | parent_id | 3 | const | 1 | Using where; Using filesort |
0.0000870
| Memory Before: 20.09 Mb
| Memory After: 20.1 Mb
| Memory Used: 4.89 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_category
WHERE parent_id=1
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_fevent_category
WHERE parent_id=1
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent_category | ref | parent_id | parent_id | 3 | const | 1 | Using where; Using filesort |
0.0000839
| Memory Before: 20.09 Mb
| Memory After: 20.1 Mb
| Memory Used: 4.91 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_category
WHERE parent_id=8
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_fevent_category
WHERE parent_id=8
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent_category | ref | parent_id | parent_id | 3 | const | 1 | Using where; Using filesort |
0.0000889
| Memory Before: 20.1 Mb
| Memory After: 20.1 Mb
| Memory Used: 4.89 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_category
WHERE parent_id=21
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_fevent_category
WHERE parent_id=21
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent_category | ref | parent_id | parent_id | 3 | const | 1 | Using where; Using filesort |
0.0000808
| Memory Before: 20.1 Mb
| Memory After: 20.1 Mb
| Memory Used: 4.91 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_category
WHERE parent_id=5
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_fevent_category
WHERE parent_id=5
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent_category | ref | parent_id | parent_id | 3 | const | 1 | Using where; Using filesort |
0.0000880
| Memory Before: 20.1 Mb
| Memory After: 20.11 Mb
| Memory Used: 4.89 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_category
WHERE parent_id=4
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_fevent_category
WHERE parent_id=4
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent_category | ref | parent_id | parent_id | 3 | const | 1 | Using where; Using filesort |
0.0000939
| Memory Before: 20.1 Mb
| Memory After: 20.11 Mb
| Memory Used: 4.89 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_category
WHERE parent_id=22
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_fevent_category
WHERE parent_id=22
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent_category | ref | parent_id | parent_id | 3 | const | 1 | Using where; Using filesort |
0.0000880
| Memory Before: 20.1 Mb
| Memory After: 20.1 Mb
| Memory Used: 5.52 kb
| Rows: 9
| Slave: Yes
SELECT *
FROM phpfox_fevent_category
/* OO Query */
FROM phpfox_fevent_category
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent_category | ALL | MISSING KEY | 9 |
0.0001080
| Memory Before: 20.28 Mb
| Memory After: 20.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 = 'block.html.php'
/* OO Query */
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: 20.29 Mb
| Memory After: 20.29 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 = 'fevent' AND name = 'category.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'fevent' 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.0000892
| Memory Before: 20.29 Mb
| Memory After: 20.29 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 = 'fevent' AND name = 'category.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'fevent' 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.0002029
| Memory Before: 20.31 Mb
| Memory After: 20.31 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 */
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.0002079
| Memory Before: 20.32 Mb
| Memory After: 20.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-contentclass.html.php'
/* OO Query */
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.0002110
| Memory Before: 20.33 Mb
| Memory After: 20.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 = 'layout' AND name = 'error.html.php'
/* OO Query */
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.0001178
| Memory Before: 20.33 Mb
| Memory After: 20.34 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 = 'fevent' AND name = 'view.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'controller' AND module_id = 'fevent' AND name = 'view.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.0001991
| Memory Before: 20.47 Mb
| Memory After: 20.47 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 = 'fevent' AND name = 'info.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'fevent' AND name = 'info.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.0005400
| Memory Before: 20.68 Mb
| Memory After: 20.68 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT action_id
FROM phpfox_action
WHERE action_type_id = 2 AND item_type_id = "fevent" AND item_id = 6692 AND user_id = 0
LIMIT 1
/* OO Query */
FROM phpfox_action
WHERE action_type_id = 2 AND item_type_id = "fevent" AND item_id = 6692 AND user_id = 0
LIMIT 1
/* 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.0010610
| Memory Before: 21.04 Mb
| Memory After: 21.04 Mb
| Memory Used: 6.71 kb
| Rows: 0
| Slave: Yes
SELECT l.*, 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, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
LEFT JOIN phpfox_action AS a
ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "fevent")
WHERE (l.type_id = 'fevent' OR l.type_id = 'fevent') AND l.item_id = 6692
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
FROM phpfox_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
LEFT JOIN phpfox_action AS a
ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "fevent")
WHERE (l.type_id = 'fevent' OR l.type_id = 'fevent') AND l.item_id = 6692
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | system | type_id,type_id_2,type_id_3,item_id | MISSING KEY | Const row not found; Using temporary; Using filesort | |||
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | item_id|type_id_3 | 4|77 | const | 1 (8%) | Using where; Using rowid filter |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 |
0.0006611
| Memory Before: 21.05 Mb
| Memory After: 21.05 Mb
| Memory Used: 5.36 kb
| Rows: 0
| Slave: Yes
SELECT 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_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "fevent" AND a.item_id = 6692
GROUP BY u.user_id
/* OO Query */
FROM phpfox_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "fevent" AND a.item_id = 6692
GROUP BY u.user_id
/* 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.0001211
| Memory Before: 21.06 Mb
| Memory After: 21.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 = 'block' AND module_id = 'feed' AND name = 'comment.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'comment.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.0001490
| Memory Before: 21.27 Mb
| Memory After: 21.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 = 'feed' AND name = 'link.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'link.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.0001249
| Memory Before: 21.35 Mb
| Memory After: 21.36 Mb
| Memory Used: 3.17 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'share' AND name = 'link.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'share' AND name = 'link.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.0001311
| Memory Before: 21.32 Mb
| Memory After: 21.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 = 'like' AND name = 'display.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'display.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.0006449
| Memory Before: 21.12 Mb
| Memory After: 21.13 Mb
| Memory Used: 8.29 kb
| Rows: 2
| Slave: Yes
SELECT feed.*, 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, u.view_id
FROM phpfox_fevent_feed AS feed
JOIN phpfox_user AS u
ON(u.user_id = feed.user_id)
WHERE feed.parent_user_id = 6692
ORDER BY feed.time_update DESC
LIMIT 4
/* OO Query */
FROM phpfox_fevent_feed AS feed
JOIN phpfox_user AS u
ON(u.user_id = feed.user_id)
WHERE feed.parent_user_id = 6692
ORDER BY feed.time_update DESC
LIMIT 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | feed | ref | parent_user_id | parent_user_id | 4 | const | 2 | Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.feed.user_id | 1 |
0.0008781
| Memory Before: 21.66 Mb
| Memory After: 21.66 Mb
| Memory Used: 5.84 kb
| Rows: 1
| Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.event_id, e.title
FROM phpfox_fevent_feed_comment AS fc
JOIN phpfox_fevent AS e
ON(e.event_id = fc.parent_user_id)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'fevent_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)
WHERE fc.feed_comment_id = 44
/* OO Query */
FROM phpfox_fevent_feed_comment AS fc
JOIN phpfox_fevent AS e
ON(e.event_id = fc.parent_user_id)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'fevent_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)
WHERE fc.feed_comment_id = 44
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fc | const | PRIMARY,parent_user_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | e | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | type_id_3|item_id | 81|4 | const,const | 1 (1%) | Using where; Using rowid filter |
0.0005701
| Memory Before: 21.66 Mb
| Memory After: 21.67 Mb
| Memory Used: 5.86 kb
| Rows: 1
| Slave: Yes
SELECT fc.*, l.like_id AS is_liked, e.event_id, e.title
FROM phpfox_fevent_feed_comment AS fc
JOIN phpfox_fevent AS e
ON(e.event_id = fc.parent_user_id)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'fevent_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)
WHERE fc.feed_comment_id = 43
/* OO Query */
FROM phpfox_fevent_feed_comment AS fc
JOIN phpfox_fevent AS e
ON(e.event_id = fc.parent_user_id)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'fevent_comment' AND l.item_id = fc.feed_comment_id AND l.user_id = 0)
WHERE fc.feed_comment_id = 43
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fc | const | PRIMARY,parent_user_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | e | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | type_id_3|item_id | 81|4 | const,const | 1 (1%) | Using where; Using rowid filter |
0.0005441
| Memory Before: 21.65 Mb
| Memory After: 21.66 Mb
| Memory Used: 6.72 kb
| Rows: 0
| Slave: Yes
SELECT l.*, 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, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
LEFT JOIN phpfox_action AS a
ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "fevent-comment")
WHERE (l.type_id = 'fevent_comment' OR l.type_id = 'fevent-comment') AND l.item_id = 43
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
FROM phpfox_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
LEFT JOIN phpfox_action AS a
ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "fevent-comment")
WHERE (l.type_id = 'fevent_comment' OR l.type_id = 'fevent-comment') AND l.item_id = 43
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | system | type_id,type_id_2,type_id_3,item_id | MISSING KEY | Const row not found; Using temporary; Using filesort | |||
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | item_id|type_id_3 | 4|77 | const | 1 (1%) | Using where; Using rowid filter |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 |
0.0003660
| Memory Before: 21.66 Mb
| Memory After: 21.66 Mb
| Memory Used: 3.13 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'fevent_comment' OR l.type_id = 'fevent-comment') AND l.item_id = 43
LIMIT 1
/* OO Query */
FROM phpfox_like AS l
WHERE (l.type_id = 'fevent_comment' OR l.type_id = 'fevent-comment') AND l.item_id = 43
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | item_id|type_id_3 | 4|77 | const | 1 (1%) | Using where; Using rowid filter |
0.0002191
| Memory Before: 21.66 Mb
| Memory After: 21.67 Mb
| Memory Used: 5.36 kb
| Rows: 0
| Slave: Yes
SELECT 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_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "fevent-comment" AND a.item_id = 43
GROUP BY u.user_id
/* OO Query */
FROM phpfox_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "fevent-comment" AND a.item_id = 43
GROUP BY u.user_id
/* 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.0005369
| Memory Before: 21.66 Mb
| Memory After: 21.67 Mb
| Memory Used: 6.7 kb
| Rows: 0
| Slave: Yes
SELECT l.*, 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, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
LEFT JOIN phpfox_action AS a
ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "fevent-comment")
WHERE (l.type_id = 'fevent_comment' OR l.type_id = 'fevent-comment') AND l.item_id = 44
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
FROM phpfox_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
LEFT JOIN phpfox_action AS a
ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "fevent-comment")
WHERE (l.type_id = 'fevent_comment' OR l.type_id = 'fevent-comment') AND l.item_id = 44
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | system | type_id,type_id_2,type_id_3,item_id | MISSING KEY | Const row not found; Using temporary; Using filesort | |||
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | item_id|type_id_3 | 4|77 | const | 1 (1%) | Using where; Using rowid filter |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 |
0.0003810
| Memory Before: 21.66 Mb
| Memory After: 21.67 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'fevent_comment' OR l.type_id = 'fevent-comment') AND l.item_id = 44
LIMIT 1
/* OO Query */
FROM phpfox_like AS l
WHERE (l.type_id = 'fevent_comment' OR l.type_id = 'fevent-comment') AND l.item_id = 44
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | item_id|type_id_3 | 4|77 | const | 1 (1%) | Using where; Using rowid filter |
0.0057132
| Memory Before: 21.8 Mb
| Memory After: 21.81 Mb
| Memory Used: 9.87 kb
| Rows: 0
| Slave: Yes
SELECT l.like_id AS is_liked, c.*, ct.text_parsed AS text, 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_comment AS c
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
JOIN phpfox_comment_text AS ct
ON(ct.comment_id = c.comment_id)
JOIN phpfox_user AS u
ON(u.user_id = c.user_id)
WHERE c.parent_id = 0 AND c.type_id = 'fevent' AND c.item_id = 44 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 2
/* OO Query */
FROM phpfox_comment AS c
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
JOIN phpfox_comment_text AS ct
ON(ct.comment_id = c.comment_id)
JOIN phpfox_user AS u
ON(u.user_id = c.user_id)
WHERE c.parent_id = 0 AND c.type_id = 'fevent' AND c.item_id = 44 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 2
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | ref | PRIMARY,user_id,type_id,parent_id,parent_id_2,view_id | type_id | 82 | const,const,const | 1 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | l | ref | type_id,type_id_2,type_id_3,item_id | type_id_3 | 81 | const,const | 1 | Using where |
| 1 | SIMPLE | ct | ref | comment_id | comment_id | 4 | sqlgipsol.c.comment_id | 1 | |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.c.user_id | 1 |
0.0002351
| Memory Before: 21.8 Mb
| Memory After: 21.81 Mb
| Memory Used: 5.36 kb
| Rows: 0
| Slave: Yes
SELECT 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_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "fevent-comment" AND a.item_id = 44
GROUP BY u.user_id
/* OO Query */
FROM phpfox_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "fevent-comment" AND a.item_id = 44
GROUP BY u.user_id
/* 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.0003932
| Memory Before: 21.8 Mb
| Memory After: 21.81 Mb
| Memory Used: 5.36 kb
| Rows: 0
| Slave: No
SELECT 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_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
WHERE l.type_id = 'fevent_comment' AND l.item_id = 44
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
FROM phpfox_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
WHERE l.type_id = 'fevent_comment' AND l.item_id = 44
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l | ref | type_id,type_id_2,type_id_3,item_id | type_id_2 | 81 | const,const | 1 | Using where; Using index; Using temporary; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 |
0.0000801
| Memory Before: 21.8 Mb
| Memory After: 21.81 Mb
| Memory Used: 5.36 kb
| Rows: 0
| Slave: Yes
SELECT 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_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "fevent-comment" AND a.item_id = 44
GROUP BY u.user_id
/* OO Query */
FROM phpfox_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "fevent-comment" AND a.item_id = 44
GROUP BY u.user_id
/* 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.0001950
| Memory Before: 21.68 Mb
| Memory After: 21.69 Mb
| Memory Used: 5.36 kb
| Rows: 0
| Slave: Yes
SELECT 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_user AS u
WHERE user_id IN (6692)
/* OO Query */
FROM phpfox_user AS u
WHERE user_id IN (6692)
/* 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.0000842
| Memory Before: 21.69 Mb
| Memory After: 21.7 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT count(*)
FROM phpfox_feed
LIMIT 1
/* OO Query */
FROM phpfox_feed
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Select tables optimized away |
0.0000880
| Memory Before: 23.3 Mb
| Memory After: 23.3 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 */
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.0000849
| Memory Before: 23.31 Mb
| Memory After: 23.31 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 = 'fevent' AND name = 'display.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'fevent' AND name = 'display.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.0000720
| Memory Before: 23.32 Mb
| Memory After: 23.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 = 'fevent' AND name = 'display.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'fevent' AND name = 'display.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.0000930
| Memory Before: 23.46 Mb
| Memory After: 23.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 = 'block' AND module_id = 'feed' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' 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.0000970
| Memory Before: 23.61 Mb
| Memory After: 23.62 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 = 'feed' AND name = 'content.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'content.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: 23.76 Mb
| Memory After: 23.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 = 'feed' AND name = 'comment.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'comment.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.0000839
| Memory Before: 23.86 Mb
| Memory After: 23.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 = 'feed' AND name = 'link.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'link.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.0001180
| Memory Before: 23.86 Mb
| Memory After: 23.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 = 'like' AND name = 'display.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'display.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: 23.57 Mb
| Memory After: 23.58 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 = 'feed' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' 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.0000899
| Memory Before: 23.73 Mb
| Memory After: 23.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 = 'block' AND module_id = 'feed' AND name = 'content.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'content.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: 23.81 Mb
| Memory After: 23.81 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 = 'feed' AND name = 'comment.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'comment.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.0000911
| Memory Before: 23.91 Mb
| Memory After: 23.91 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 = 'feed' AND name = 'link.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'link.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.0000901
| Memory Before: 23.91 Mb
| Memory After: 23.91 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 = 'like' AND name = 'display.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'display.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.0000858
| Memory Before: 23.44 Mb
| Memory After: 23.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 = 'base5' AND module_id = 'core' AND name = 'block/template-menufooter.html.php'
/* OO Query */
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 |
Array
(
[session] => 40a71f6214a2060e8c10728fc39f2f69
[redirect] => /fevent/6692/la-home-de-la-solidaridad
)
Array ( )
