TERCER GRAN ENCUENTRO DEL PROGRAMA NARANJA THINK GAZTEAK
Evento gratuito donde te invitamos a desayunar para escuchar las necesidades o bloqueos que tienes a la hora de conseguir tus objetivos. Solamente es preguntarte ¿Qué quieres conseguir? ¿Qué necesitas mejorar?. Se trata de una dinámica grupal y para poder desarrollarla, te ayudarán dos dinamizadores.
A partir de ahí un equipo de Coach y Terapeutas emocionales, expertos en motivación...trabajarán dinámicas sobre estas necesidades y te aconsejarán a la hora de poder superarlos.
Y por último y por tu participación en este encuentros de 4 horas...podrás participar si vienes con un par de amig@s en varios sorteos, entre ellos una cena en una pizzeria para tí ( si eres el agraciado) y 9 personas más. Podrás invitar a tu familia, amig@s......
Más información
¿Cuándo?
Comienzo: sábado, enero 14, 2017 11:00
Finaliza: sábado, enero 14, 2017 15:00
¿Dónde?
| Dirección: | Anoeta pasealekua (Craj- al lado del palacio de Hielo) |
ASOCIACIÓN LLENO DE NARANJAS le gusta esto.
Actividad
Enlace para el acceso de reservas de este encuentro. Recordaros que son eventos gratuitos patrocinad@s por Kutxa Solidarioa y sólo por participar en los mismos teneís acceso a estupendos sorteos dentr...
ASOCIACIÓN LLENO DE NARANJAS
Difusión del tercer evento encuentro del Enero del 2017. Se siguió la misma estrategia de difusión en los anteriores encuentros.
- Diciembre 30, 2016
- ·
- Me gusta
Evento gratuito donde te invitamos a desayunar para escuchar las necesidades o bloqueos que tienes a la hora de conseguir tus objetivos. Solamente es preguntarte ¿Qué quieres conseguir? ¿Qué necesitas...
phpFox Developers Debug
Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula
Total Time:
0.3509769
PHP General Time:
0.2875458
GZIP:
disabled
Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.0634311
SQL Queries:
107
SQL Memory Usage:
467.13 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
12.85 Mb
Total Memory Usage (Including Debug):
13.2 Mb
Memory Limit:
512 Mb (1024M)
Load Balancing Enabled:
No
Requests From:
192.168.100.222
Server Time Stamp:
December 9, 2025, 10:04 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.0010750
| Memory Before: 2.29 Mb
| Memory After: 2.29 Mb
| Memory Used: 3.86 kb
| Rows: 1
| Slave: No
SELECT s.session_hash, s.id_hash, s.captcha_hash, s.user_id
FROM phpfox_log_session AS s
WHERE s.session_hash = 'c0cc5b5852ab145b771bf5b1fa9d3789' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
FROM phpfox_log_session AS s
WHERE s.session_hash = 'c0cc5b5852ab145b771bf5b1fa9d3789' 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.0004780
| 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 = '1765317852', user_id = '0', location = '/fevent/1707/naranja-think-gazteak/page_1', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.221', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = 'c0cc5b5852ab145b771bf5b1fa9d3789'
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_log_session | ref | session_hash,log_session | session_hash | 32 | const | 1 | Using index condition |
0.0002511
| Memory Before: 3.62 Mb
| Memory After: 3.62 Mb
| Memory Used: 4.99 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.0001099
| 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.0002420
| Memory Before: 5.15 Mb
| Memory After: 5.16 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 | 98581 | Using where |
0.0001249
| Memory Before: 5.16 Mb
| Memory After: 5.16 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.0002160
| Memory Before: 5.35 Mb
| Memory After: 5.35 Mb
| Memory Used: 3.15 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 | 98581 | Using where |
0.0033820
| Memory Before: 5.76 Mb
| Memory After: 5.78 Mb
| Memory Used: 22 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 = 1707
/* 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 = 1707
/* 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.0077949
| Memory Before: 5.89 Mb
| Memory After: 5.9 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 = 1707 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 = 1707 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.0045092
| Memory Before: 5.99 Mb
| Memory After: 5.99 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 = 1707
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 = 1707
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.0011799
| Memory Before: 6.48 Mb
| Memory After: 6.49 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_fevent
SET total_view = total_view + 1
WHERE event_id = 1707
SET total_view = total_view + 1
WHERE event_id = 1707
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_fevent | const | PRIMARY | PRIMARY | 4 | const | 1 |
0.0001190
| Memory Before: 6.5 Mb
| Memory After: 6.5 Mb
| Memory Used: 3.31 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 1707 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 1707 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.0001910
| Memory Before: 7.65 Mb
| Memory After: 7.66 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0002141
| Memory Before: 8.51 Mb
| Memory After: 8.52 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.0002079
| Memory Before: 8.71 Mb
| Memory After: 8.71 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = '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.0001199
| Memory Before: 8.87 Mb
| Memory After: 8.88 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */
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.0001059
| Memory Before: 8.9 Mb
| Memory After: 8.9 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0001700
| Memory Before: 8.9 Mb
| Memory After: 8.9 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0002131
| Memory Before: 8.91 Mb
| Memory After: 8.92 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-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.0002069
| Memory Before: 8.92 Mb
| Memory After: 8.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 = '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.0002079
| Memory Before: 8.94 Mb
| Memory After: 8.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 = '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.0034621
| Memory Before: 8.95 Mb
| Memory After: 8.96 Mb
| Memory Used: 3.67 kb
| Rows: 1
| Slave: Yes
SELECT image_id, image_path, server_id
FROM phpfox_fevent_image
WHERE event_id = 1707
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_fevent_image
WHERE event_id = 1707
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.0001159
| Memory Before: 8.96 Mb
| Memory After: 8.96 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.0001130
| Memory Before: 9.18 Mb
| Memory After: 9.19 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.0000911
| Memory Before: 9.2 Mb
| Memory After: 9.21 Mb
| Memory Used: 4.9 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.0000861
| Memory Before: 9.21 Mb
| Memory After: 9.21 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.0000830
| Memory Before: 9.21 Mb
| Memory After: 9.21 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.0000861
| Memory Before: 9.21 Mb
| Memory After: 9.22 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.0000799
| Memory Before: 9.21 Mb
| Memory After: 9.22 Mb
| Memory Used: 4.89 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.0000799
| Memory Before: 9.22 Mb
| Memory After: 9.22 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.0000799
| Memory Before: 9.22 Mb
| Memory After: 9.22 Mb
| Memory Used: 4.9 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.0000789
| Memory Before: 9.22 Mb
| Memory After: 9.23 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.0000870
| Memory Before: 9.22 Mb
| Memory After: 9.23 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.0000830
| Memory Before: 9.22 Mb
| Memory After: 9.22 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.0000989
| Memory Before: 9.4 Mb
| Memory After: 9.4 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.0001020
| Memory Before: 9.41 Mb
| Memory After: 9.41 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.0000870
| Memory Before: 9.41 Mb
| Memory After: 9.41 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.0001009
| Memory Before: 9.43 Mb
| Memory After: 9.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 = '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.0001950
| Memory Before: 9.44 Mb
| Memory After: 9.44 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = '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.0001099
| Memory Before: 9.44 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 = '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.0001969
| 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 = '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.0001190
| Memory Before: 9.59 Mb
| Memory After: 9.59 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.0013878
| Memory Before: 9.8 Mb
| Memory After: 9.8 Mb
| Memory Used: 6.91 kb
| Rows: 1
| 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 = 1707
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 = 1707
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.0002759
| Memory Before: 9.8 Mb
| Memory After: 9.8 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 = 1707 AND user_id = 0
LIMIT 1
/* OO Query */
FROM phpfox_action
WHERE action_type_id = 2 AND item_type_id = "fevent" AND item_id = 1707 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.0004551
| Memory Before: 10.16 Mb
| Memory After: 10.17 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 = 1707
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 = 1707
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.0001161
| Memory Before: 10.17 Mb
| Memory After: 10.17 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.0001221
| Memory Before: 10.38 Mb
| Memory After: 10.39 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.0001259
| Memory Before: 10.47 Mb
| Memory After: 10.47 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.0001152
| Memory Before: 10.41 Mb
| Memory After: 10.41 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.0024228
| Memory Before: 10.22 Mb
| Memory After: 10.23 Mb
| Memory Used: 8.63 kb
| Rows: 4
| 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 = 1707
ORDER BY feed.time_update DESC
LIMIT 4 OFF SET 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 = 1707
ORDER BY feed.time_update DESC
LIMIT 4 OFF SET 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 | 8 | Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.feed.user_id | 1 |
0.0061700
| Memory Before: 11.59 Mb
| Memory After: 11.6 Mb
| Memory Used: 10.43 kb
| Rows: 1
| Slave: Yes
SELECT link.*, l.like_id AS is_liked, p.app_id, a.image_path AS app_image_path, u.user_id AS parent_user_id, u.profile_page_id AS parent_profile_page_id, u.server_id AS user_parent_server_id, u.user_name AS parent_user_name, u.full_name AS parent_full_name, u.gender AS parent_gender, u.user_image AS parent_user_image, u.is_invisible AS parent_is_invisible, u.user_group_id AS parent_user_group_id, u.language_id AS parent_language_id, u.last_activity AS parent_last_activity
FROM phpfox_link AS link
LEFT JOIN phpfox_user AS u
ON(u.user_id = link.parent_user_id)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'link' AND l.item_id = link.link_id AND l.user_id = 0)
LEFT JOIN phpfox_pages AS p
ON(p.page_id = u.profile_page_id)
LEFT JOIN phpfox_app AS a
ON(a.app_id = p.app_id)
WHERE link.link_id = 564
/* OO Query */
FROM phpfox_link AS link
LEFT JOIN phpfox_user AS u
ON(u.user_id = link.parent_user_id)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'link' AND l.item_id = link.link_id AND l.user_id = 0)
LEFT JOIN phpfox_pages AS p
ON(p.page_id = u.profile_page_id)
LEFT JOIN phpfox_app AS a
ON(a.app_id = p.app_id)
WHERE link.link_id = 564
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | system | PRIMARY,app_id | MISSING KEY | Const row not found | |||
| 1 | SIMPLE | link | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | u | const | PRIMARY,user_id | PRIMARY | 4 | const | Unique row not found | |
| 1 | SIMPLE | p | const | PRIMARY,page_id | MISSING KEY | 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.0009000
| Memory Before: 11.59 Mb
| Memory After: 11.59 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 = "link")
WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 564
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 = "link")
WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 564
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.0005031
| Memory Before: 11.59 Mb
| Memory After: 11.59 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 564
LIMIT 1
/* OO Query */
FROM phpfox_like AS l
WHERE (l.type_id = 'link' OR l.type_id = 'link') AND l.item_id = 564
LIMIT 1
/* 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 | 81 | const,const | 1 | Using where; Using index |
0.0003400
| Memory Before: 11.59 Mb
| Memory After: 11.6 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 = "link" AND a.item_id = 564
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 = "link" AND a.item_id = 564
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.0006170
| Memory Before: 11.6 Mb
| Memory After: 11.6 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 = 'link' AND l.item_id = 564
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 = 'link' AND l.item_id = 564
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.0001130
| Memory Before: 11.6 Mb
| Memory After: 11.6 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 = "link" AND a.item_id = 564
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 = "link" AND a.item_id = 564
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.0033801
| Memory Before: 11.62 Mb
| Memory After: 11.63 Mb
| Memory Used: 11.44 kb
| Rows: 1
| Slave: Yes
SELECT photo.*, l.like_id AS is_liked, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name
FROM phpfox_photo AS photo
JOIN phpfox_photo_info AS pi
ON(pi.photo_id = photo.photo_id)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
LEFT JOIN phpfox_photo_feed AS pfeed
ON(pfeed.feed_id = 35)
LEFT JOIN phpfox_photo_album AS pa
ON(pa.album_id = photo.album_id)
WHERE photo.photo_id = 3092
/* OO Query */
FROM phpfox_photo AS photo
JOIN phpfox_photo_info AS pi
ON(pi.photo_id = photo.photo_id)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
LEFT JOIN phpfox_photo_feed AS pfeed
ON(pfeed.feed_id = 35)
LEFT JOIN phpfox_photo_album AS pa
ON(pa.album_id = photo.album_id)
WHERE photo.photo_id = 3092
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | photo | const | PRIMARY,photo_id,photo_id_2 | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | pi | const | photo_id | photo_id | 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 | pfeed | ref | feed_id | feed_id | 4 | const | 1 | |
| 1 | SIMPLE | pa | eq_ref | PRIMARY,album_id | PRIMARY | 4 | const | 1 |
0.0006878
| Memory Before: 11.85 Mb
| Memory After: 11.86 Mb
| Memory Used: 11.47 kb
| Rows: 1
| Slave: Yes
SELECT photo.*, l.like_id AS is_liked, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name
FROM phpfox_photo AS photo
JOIN phpfox_photo_info AS pi
ON(pi.photo_id = photo.photo_id)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
LEFT JOIN phpfox_photo_feed AS pfeed
ON(pfeed.feed_id = 34)
LEFT JOIN phpfox_photo_album AS pa
ON(pa.album_id = photo.album_id)
WHERE photo.photo_id = 3089
/* OO Query */
FROM phpfox_photo AS photo
JOIN phpfox_photo_info AS pi
ON(pi.photo_id = photo.photo_id)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
LEFT JOIN phpfox_photo_feed AS pfeed
ON(pfeed.feed_id = 34)
LEFT JOIN phpfox_photo_album AS pa
ON(pa.album_id = photo.album_id)
WHERE photo.photo_id = 3089
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | photo | const | PRIMARY,photo_id,photo_id_2 | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | pi | const | photo_id | photo_id | 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 | pfeed | ref | feed_id | feed_id | 4 | const | 1 | |
| 1 | SIMPLE | pa | eq_ref | PRIMARY,album_id | PRIMARY | 4 | const | 1 |
0.0006819
| Memory Before: 11.85 Mb
| Memory After: 11.86 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 = "photo")
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 3089
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 = "photo")
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 3089
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 (3%) | Using where; Using rowid filter |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 |
0.0005229
| Memory Before: 11.86 Mb
| Memory After: 11.86 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 3089
LIMIT 1
/* OO Query */
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 3089
LIMIT 1
/* 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 | 81 | const,const | 1 | Using where; Using index |
0.0041420
| Memory Before: 11.99 Mb
| Memory After: 12 Mb
| Memory Used: 10.12 kb
| Rows: 1
| 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 = 'photo' AND c.item_id = 3089 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 = 'photo' AND c.item_id = 3089 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.0002570
| Memory Before: 12 Mb
| Memory After: 12.01 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 = "photo" AND a.item_id = 3089
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 = "photo" AND a.item_id = 3089
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.0005310
| Memory Before: 12 Mb
| Memory After: 12.01 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 = "photo")
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 3092
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 = "photo")
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 3092
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 (3%) | Using where; Using rowid filter |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 |
0.0003021
| Memory Before: 12 Mb
| Memory After: 12.01 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 3092
LIMIT 1
/* OO Query */
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 3092
LIMIT 1
/* 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 | 81 | const,const | 1 | Using where; Using index |
0.0009258
| Memory Before: 12.01 Mb
| Memory After: 12.02 Mb
| Memory Used: 10.14 kb
| Rows: 1
| 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 = 'photo' AND c.item_id = 3092 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 = 'photo' AND c.item_id = 3092 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.0002470
| Memory Before: 12.02 Mb
| Memory After: 12.03 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 = "photo" AND a.item_id = 3092
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 = "photo" AND a.item_id = 3092
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.0004060
| Memory Before: 12.02 Mb
| Memory After: 12.02 Mb
| Memory Used: 5.39 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 = 'photo' AND l.item_id = 3092
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 = 'photo' AND l.item_id = 3092
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.0000799
| Memory Before: 12.02 Mb
| Memory After: 12.03 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 = "photo" AND a.item_id = 3092
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 = "photo" AND a.item_id = 3092
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.0018950
| Memory Before: 12.04 Mb
| Memory After: 12.04 Mb
| Memory Used: 5.87 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 = 11
/* 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 = 11
/* 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.0005631
| Memory Before: 12.03 Mb
| Memory After: 12.04 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 = 11
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 = 11
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.0003462
| Memory Before: 12.03 Mb
| Memory After: 12.04 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 = 11
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 = 11
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.0002081
| Memory Before: 12.04 Mb
| Memory After: 12.04 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 = 11
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 = 11
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.0003459
| Memory Before: 12.04 Mb
| Memory After: 12.04 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 = 11
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 = 11
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.0000780
| Memory Before: 12.04 Mb
| Memory After: 12.04 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 = 11
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 = 11
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.0008130
| Memory Before: 11.92 Mb
| Memory After: 11.92 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 (1707,1707,1707)
/* OO Query */
FROM phpfox_user AS u
WHERE user_id IN (1707,1707,1707)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | u | range | PRIMARY,user_id | user_id | 4 | 1 | Using index condition |
0.0000939
| Memory Before: 11.92 Mb
| Memory After: 11.92 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.0000870
| Memory Before: 12.65 Mb
| Memory After: 12.66 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0000768
| Memory Before: 12.66 Mb
| Memory After: 12.66 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0000670
| Memory Before: 12.68 Mb
| Memory After: 12.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 = '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.0003140
| Memory Before: 12.81 Mb
| Memory After: 12.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 = '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.0004420
| 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 = '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.0001101
| Memory Before: 13.11 Mb
| Memory After: 13.11 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.0002010
| Memory Before: 13.21 Mb
| Memory After: 13.21 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = '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.0001590
| Memory Before: 13.27 Mb
| Memory After: 13.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 = '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.0001471
| Memory Before: 13.22 Mb
| Memory After: 13.22 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.0001352
| Memory Before: 12.91 Mb
| Memory After: 12.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 = '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.0002110
| Memory Before: 13.06 Mb
| Memory After: 13.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 = '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.0002179
| Memory Before: 13.14 Mb
| Memory After: 13.15 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = '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.0002100
| Memory Before: 13.24 Mb
| Memory After: 13.24 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = '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.0002100
| Memory Before: 13.3 Mb
| Memory After: 13.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 = '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.0002091
| Memory Before: 13.25 Mb
| Memory After: 13.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 = '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.0006669
| Memory Before: 13.25 Mb
| Memory After: 13.26 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'comment' AND name = 'mini.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'comment' AND name = 'mini.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.0005481
| Memory Before: 13.37 Mb
| Memory After: 13.37 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 = 'link.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' 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.0002131
| Memory Before: 12.98 Mb
| Memory After: 12.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 = '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.0002120
| Memory Before: 13.13 Mb
| Memory After: 13.14 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = '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.0002139
| Memory Before: 13.21 Mb
| Memory After: 13.22 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: 13.31 Mb
| Memory After: 13.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 = '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.0001719
| Memory Before: 13.37 Mb
| Memory After: 13.38 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.0002210
| Memory Before: 13.32 Mb
| Memory After: 13.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.0001690
| Memory Before: 13.32 Mb
| Memory After: 13.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 = 'comment' AND name = 'mini.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'comment' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001209
| Memory Before: 13.39 Mb
| Memory After: 13.39 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 = 'link.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' 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.0001161
| Memory Before: 13 Mb
| Memory After: 13 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.0002091
| Memory Before: 13.15 Mb
| Memory After: 13.16 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.0002170
| Memory Before: 13.25 Mb
| Memory After: 13.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 = '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.0002129
| 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 = '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.0001822
| 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 = '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.0001240
| Memory Before: 12.84 Mb
| Memory After: 12.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 = '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] => c0cc5b5852ab145b771bf5b1fa9d3789
[redirect] => /fevent/1707/naranja-think-gazteak/page_1
)
Array
(
[coreb6aavisit] => 1765317849
)
