Aukeratutako jarduera
AUTOLAGUNTZA TAILERRAK - TALLERES DE AUTOAYUDA
Nork sortua:: AGADELPRISE
Kategoria:

DONOSTIA
Ekainak 29 (17:00) - Txara I
Desde Agadelprise Donostia continuamos con nuestras actividades en el Mes Mundial del Lipedema
Autolaguntza tailerrak
Psikologoa - Kathleen Phillips
Antsietatea
Depresioa
Estresa
Izen emateak: 601982584 / agadelprise@gmail.com
Más información
Noiz?
Hasiera: asteartea, 2021 ekaina 29, 17:00
Bukaera: asteartea, 2021 ekaina 29, 18:00
Non?
| Kokapena: | TXARA I Pº ZARATEGI 100 |
| Helbide osoa: | Zarategi pasealekua, 100 Txara 1 eraikuntza 20015 Donostia, Gipuzkoa |
| Hiria: | Donostia |
| Posta kodea: | 20015 |
Ekintza
Wall Comment: #48
phpFox Developers Debug
Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula
Total Time:
3.6435380
PHP General Time:
3.6190278
GZIP:
disabled
Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.0245102
SQL Queries:
76
SQL Memory Usage:
303.42 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
12.99 Mb
Total Memory Usage (Including Debug):
13.27 Mb
Memory Limit:
512 Mb (1024M)
Load Balancing Enabled:
No
Requests From:
192.168.100.222
Server Time Stamp:
August 19, 2026, 4:58 pm
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.0004401
| 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 = 'caf6173658baa206dc9f647d029fe428' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
FROM phpfox_log_session AS s
WHERE s.session_hash = 'caf6173658baa206dc9f647d029fe428' 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.0004289
| Memory Before: 2.3 Mb
| Memory After: 2.3 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_log_session SET last_activity = '1787158705', user_id = '0', location = '/mobile/fevent/6797/autolaguntza-tailerrak-talleres-de-autoayuda/comment-id_48/', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.87', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = 'caf6173658baa206dc9f647d029fe428'
| 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.0001860
| Memory Before: 3.62 Mb
| Memory After: 3.63 Mb
| Memory Used: 4.97 kb
| Rows: 1
| Slave: No
SELECT s.style_id, s.parent_id AS style_parent_id, s.folder AS style_folder_name, t.folder AS theme_folder_name, t.parent_id AS theme_parent_id, t.total_column, s.l_width, s.c_width, s.r_width
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
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.0001311
| 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 */
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.0001009
| Memory Before: 5.23 Mb
| Memory After: 5.23 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 | 106628 | Using where |
0.0000801
| Memory Before: 5.23 Mb
| Memory After: 5.24 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.0000970
| Memory Before: 5.43 Mb
| Memory After: 5.43 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 | 106628 | Using where |
0.0009570
| Memory Before: 5.83 Mb
| Memory After: 5.85 Mb
| Memory Used: 17.52 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 = 6797
/* 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 = 6797
/* 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|filter | user_check,user_id,top_friend,friend_user_id | friend_user_id|user_id | 4|4 | const | 1 (0%) | Using where; Using rowid filter |
| 1 | SIMPLE | et | ref | event_id | event_id | 4 | const | 1 |
0.0002089
| Memory Before: 5.96 Mb
| Memory After: 5.96 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 = 6797 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 = 6797 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.0003252
| Memory Before: 6.06 Mb
| Memory After: 6.06 Mb
| Memory Used: 3.64 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 = 6797
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 = 6797
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.0002379
| Memory Before: 6.55 Mb
| Memory After: 6.55 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_fevent
SET total_view = total_view + 1
WHERE event_id = 6797
SET total_view = total_view + 1
WHERE event_id = 6797
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent | const | PRIMARY | PRIMARY | 4 | const | 1 |
0.0001671
| Memory Before: 6.57 Mb
| Memory After: 6.57 Mb
| Memory Used: 3.31 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 6797 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 6797 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.0046101
| Memory Before: 7.36 Mb
| Memory After: 7.36 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 */
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.0001831
| Memory Before: 7.36 Mb
| Memory After: 7.36 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_cron SET next_run = '1787158705', last_run = '1787158705' 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.0001531
| Memory Before: 7.36 Mb
| Memory After: 7.36 Mb
| Memory Used: 1.29 kb
| Rows: -
| Slave: No
INSERT INTO phpfox_cron_log (cron_id, time_stamp) VALUES ('5', '1787158705')
0.0000930
| Memory Before: 7.83 Mb
| Memory After: 7.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 = '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.0001051
| Memory Before: 8.85 Mb
| Memory After: 8.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 = '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.0000899
| Memory Before: 9.05 Mb
| Memory After: 9.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 = '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.0000939
| Memory Before: 9.18 Mb
| Memory After: 9.18 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.0000870
| Memory Before: 9.2 Mb
| Memory After: 9.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 = '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.0000942
| Memory Before: 9.23 Mb
| Memory After: 9.24 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-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.0000970
| Memory Before: 9.25 Mb
| Memory After: 9.25 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.0000920
| Memory Before: 9.25 Mb
| Memory After: 9.26 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0000882
| Memory Before: 9.27 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 = '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.0002642
| Memory Before: 9.29 Mb
| Memory After: 9.29 Mb
| Memory Used: 3.67 kb
| Rows: 1
| Slave: Yes
SELECT image_id, image_path, server_id
FROM phpfox_fevent_image
WHERE event_id = 6797
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_fevent_image
WHERE event_id = 6797
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.0000830
| Memory Before: 9.29 Mb
| Memory After: 9.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 = '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.0001049
| Memory Before: 9.52 Mb
| Memory After: 9.52 Mb
| Memory Used: 5.55 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.0000739
| Memory Before: 9.53 Mb
| Memory After: 9.54 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.0000660
| Memory Before: 9.54 Mb
| Memory After: 9.54 Mb
| Memory Used: 4.89 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.0000682
| Memory Before: 9.54 Mb
| Memory After: 9.55 Mb
| Memory Used: 4.89 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.0000641
| Memory Before: 9.54 Mb
| Memory After: 9.55 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.0000689
| Memory Before: 9.55 Mb
| Memory After: 9.55 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.0002451
| Memory Before: 9.55 Mb
| Memory After: 9.55 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.0001051
| Memory Before: 9.55 Mb
| Memory After: 9.56 Mb
| Memory Used: 4.89 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: 9.55 Mb
| Memory After: 9.56 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.0001061
| Memory Before: 9.56 Mb
| Memory After: 9.56 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.0000908
| Memory Before: 9.55 Mb
| Memory After: 9.55 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.0002170
| 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 */
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.0001059
| 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 = '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.0000908
| Memory Before: 9.74 Mb
| Memory After: 9.75 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.0002131
| 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 */
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.0001171
| Memory Before: 9.77 Mb
| Memory After: 9.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 = '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.0001390
| Memory Before: 9.78 Mb
| Memory After: 9.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 = '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.0001268
| Memory Before: 9.78 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 = '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.0001299
| 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 = '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.0008080
| Memory Before: 10.03 Mb
| Memory After: 10.04 Mb
| Memory Used: 7.32 kb
| Rows: 1
| Slave: No
SELECT attachment.*
FROM phpfox_attachment AS attachment
JOIN phpfox_user AS u
ON(u.user_id = attachment.user_id)
WHERE attachment.item_id = 6797 AND attachment.view_id = 0 AND attachment.category_id = 'fevent' AND attachment.is_inline = 0
ORDER BY attachment.attachment_id DESC
/* OO Query */
FROM phpfox_attachment AS attachment
JOIN phpfox_user AS u
ON(u.user_id = attachment.user_id)
WHERE attachment.item_id = 6797 AND attachment.view_id = 0 AND attachment.category_id = 'fevent' AND attachment.is_inline = 0
ORDER BY attachment.attachment_id DESC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | attachment | ref | category_id,user_id,view_id | view_id | 83 | const,const,const | 6 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.attachment.user_id | 1 | Using index |
0.0001099
| 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 = 'block' AND module_id = 'attachment' AND name = 'list.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'attachment' AND name = 'list.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.0005379
| Memory Before: 10.3 Mb
| Memory After: 10.31 Mb
| Memory Used: 7.27 kb
| Rows: 1
| Slave: Yes
SELECT l.*, u.user_name
FROM phpfox_link AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
WHERE l.link_id = 4119
/* OO Query */
FROM phpfox_link AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
WHERE l.link_id = 4119
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | u | const | PRIMARY,user_id | PRIMARY | 4 | const | 1 |
0.0001101
| Memory Before: 10.31 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 = 'block' AND module_id = 'link' AND name = 'display.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'link' 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.0005109
| Memory Before: 10.31 Mb
| Memory After: 10.31 Mb
| Memory Used: 3.13 kb
| Rows: 0
| Slave: Yes
SELECT action_id
FROM phpfox_action
WHERE action_type_id = 2 AND item_type_id = "fevent" AND item_id = 6797 AND user_id = 0
LIMIT 1
/* OO Query */
FROM phpfox_action
WHERE action_type_id = 2 AND item_type_id = "fevent" AND item_id = 6797 AND user_id = 0
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_action | ref | type_id,type_id_2,type_id_3,item_id | item_id | 4 | const | 1 | Using where |
0.0011191
| Memory Before: 10.66 Mb
| Memory After: 10.67 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 = 6797
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 = 6797
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 | 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 temporary; Using filesort; Using rowid filter |
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | item_id | 4 | const | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 |
0.0004981
| Memory Before: 10.67 Mb
| Memory After: 10.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" AND a.item_id = 6797
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 = 6797
GROUP BY u.user_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | type_id_2 | 81 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.a.user_id | 1 |
0.0001042
| Memory Before: 10.68 Mb
| Memory After: 10.68 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.0002110
| Memory Before: 10.89 Mb
| Memory After: 10.89 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = '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.0002089
| Memory Before: 10.97 Mb
| Memory After: 10.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 = '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.0001290
| Memory Before: 10.92 Mb
| Memory After: 10.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 = '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.0006380
| Memory Before: 10.79 Mb
| Memory After: 10.79 Mb
| Memory Used: 1.35 kb
| Rows: -
| Slave: No
DELETE FROM phpfox_notification WHERE type_id = 'feed_comment_profile' AND item_id = 48 AND user_id = 0
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_notification | ref|filter | user_id,user_id_2,type_id | type_id|user_id_2 | 81|4 | const,const | 1 (1%) | Using index condition; Using where; Using rowid filter |
0.0007000
| Memory Before: 10.8 Mb
| Memory After: 10.81 Mb
| Memory Used: 8.09 kb
| Rows: 1
| 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.type_id = 'fevent_comment' AND feed.item_id = 48 AND feed.parent_user_id = 6797
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.type_id = 'fevent_comment' AND feed.item_id = 48 AND feed.parent_user_id = 6797
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 | 4 | Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.feed.user_id | 1 |
0.0012159
| Memory Before: 11.33 Mb
| Memory After: 11.33 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 = 48
/* 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 = 48
/* 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.0010719
| Memory Before: 11.32 Mb
| Memory After: 11.33 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 = 48
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 = 48
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 | 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 temporary; Using filesort; Using rowid filter |
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | item_id | 4 | const | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 |
0.0007021
| Memory Before: 11.32 Mb
| Memory After: 11.32 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 = 48
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 = 48
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.0004570
| Memory Before: 11.32 Mb
| Memory After: 11.33 Mb
| Memory Used: 5.38 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 = 48
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 = 48
GROUP BY u.user_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | type_id_2 | 81 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.a.user_id | 1 |
0.0006590
| Memory Before: 11.33 Mb
| Memory After: 11.33 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 = 48
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 = 48
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.0001061
| Memory Before: 11.33 Mb
| Memory After: 11.33 Mb
| Memory Used: 5.38 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 = 48
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 = 48
GROUP BY u.user_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | type_id_2 | 81 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.a.user_id | 1 |
0.0002730
| Memory Before: 11.2 Mb
| Memory After: 11.21 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 (6797)
/* OO Query */
FROM phpfox_user AS u
WHERE user_id IN (6797)
/* 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.0001040
| Memory Before: 11.22 Mb
| Memory After: 11.22 Mb
| Memory Used: 3.13 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.0001860
| Memory Before: 12.78 Mb
| Memory After: 12.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 = '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.0000930
| Memory Before: 12.79 Mb
| Memory After: 12.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 = '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.0001161
| Memory Before: 12.8 Mb
| Memory After: 12.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 = '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.0005400
| Memory Before: 12.94 Mb
| Memory After: 12.94 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.0005112
| Memory Before: 13.09 Mb
| Memory After: 13.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 = '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.0005000
| Memory Before: 13.24 Mb
| Memory After: 13.25 Mb
| Memory Used: 3.13 kb
| Rows: 0
| Slave: Yes
SELECT action_id
FROM phpfox_action
WHERE action_type_id = 2 AND item_type_id = "fevent-comment" AND item_id = 48 AND user_id = 0
LIMIT 1
/* OO Query */
FROM phpfox_action
WHERE action_type_id = 2 AND item_type_id = "fevent-comment" AND item_id = 48 AND user_id = 0
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_action | ref | type_id,type_id_2,type_id_3,item_id | item_id | 4 | const | 1 | Using where |
0.0001230
| Memory Before: 13.35 Mb
| Memory After: 13.35 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.0001531
| Memory Before: 13.43 Mb
| Memory After: 13.43 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.0001471
| Memory Before: 13.44 Mb
| Memory After: 13.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 = '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.0001519
| Memory Before: 12.97 Mb
| Memory After: 12.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 = '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] => caf6173658baa206dc9f647d029fe428
[redirect] => /mobile/fevent/6797/autolaguntza-tailerrak-talleres-de-autoayuda/comment-id_48/
[socialintegration_pageId] => 56
)
Array
(
[coreb6aavisit] => 1787158686
)





