Agenda
Ecosocial
ESTA SEMANA
Mayores
Eventos del 24 de Abril de 2024
- Finalizado
Comenzó: febrero 7, 2023 19:00
Finalizó: febrero 7, 2023 20:00
Publicado por: ASOCIACIÓN VASCA DE ANTIC
- Finalizado
- Finalizado
+1 DÍA
- Finalizado
Comenzó: diciembre 1, 2021 14:00
Finalizó: diciembre 31, 2021 13:00
Publicado por: GipuzkoaSolidarioa
+1 DÍA
- Finalizado
- Finalizado
- Finalizado
Comenzó: septiembre 21, 2019 16:30
Finalizó: septiembre 21, 2019 17:30
Publicado por: GipuzkoaSolidarioa
+1 DÍA
- Finalizado
- Finalizado
+1 DÍA
- Finalizado
+1 DÍA
- Finalizado
Comenzó: septiembre 30, 2022 00:00
Finalizó: octubre 30, 2022 23:00
Publicado por: GipuzkoaSolidarioa
- Finalizado
- Finalizado
- Finalizado
- Finalizado
- Destacado
- Finalizado
Comenzó: septiembre 19, 2019 10:30
Finalizó: septiembre 19, 2019 18:00
Publicado por: NAGUSILAN, Voluntariado S
- Finalizado
- Finalizado
Comenzó: diciembre 13, 2023 19:00
Finalizó: diciembre 13, 2023 20:00
Publicado por: GipuzkoaSolidarioa
- Finalizado
- Finalizado
Comenzó: septiembre 20, 2022 16:00
Finalizó: septiembre 20, 2022 17:30
Publicado por: GipuzkoaSolidarioa
phpFox Developers Debug
Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula
Total Time:
0.2747562
PHP General Time:
0.2411317
GZIP:
disabled
Driver Version:
MySQL 5.5.5-10.5.23-MariaDB-0+deb11u1-log
SQL Time:
0.0336245
SQL Queries:
39
SQL Memory Usage:
205.14 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
21.49 Mb
Total Memory Usage (Including Debug):
21.71 Mb
Memory Limit:
256 Mb (512M)
Load Balancing Enabled:
No
Requests From:
147.135.173.174
Server Time Stamp:
April 24, 2024, 5:10 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.0002410
| Memory Before: 2.3 Mb
| Memory After: 2.3 Mb
| Memory Used: 1.35 kb
| Rows: -
| Slave: No
INSERT INTO phpfox_log_session (session_hash, id_hash, user_id, last_activity, location, is_forum, forum_id, im_hide, ip_address, user_agent) VALUES ('adfbc5d7a57c923a4085a103e4280a22', '0d574f7196f9f96e319d05681455513d', '0', '1713978633', '/fevent/category/21/adinekoak/show_20/when_all-time/sort_most-talked/', '0', '0', '0', '18.191.46.36', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.')
0.0003440
| Memory Before: 3.62 Mb
| Memory After: 3.63 Mb
| Memory Used: 5.03 kb
| Rows: 1
| Slave: No
SELECT s.style_id, s.parent_id AS style_parent_id, s.folder AS style_folder_name, t.folder AS theme_folder_name, t.parent_id AS theme_parent_id, t.total_column, s.l_width, s.c_width, s.r_width
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ref | is_default | is_default | 1 | const | 1 | |
1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | sqlgipsol2.s.theme_id | 1 |
0.0002179
| Memory Before: 3.62 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.0093579
| Memory Before: 5.21 Mb
| Memory After: 5.22 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 | 86611 | Using where |
0.0003440
| Memory Before: 5.22 Mb
| Memory After: 5.22 Mb
| Memory Used: 3.12 kb
| Rows: 0
| Slave: Yes
SELECT p.page_id
FROM phpfox_pages AS p
JOIN phpfox_like AS l
ON(l.user_id = 0 AND l.`type_id` = 'pages' AND l.`item_id` = p.page_id)
WHERE p.view_id = 0
/* OO Query */
FROM phpfox_pages AS p
JOIN phpfox_like AS l
ON(l.user_id = 0 AND l.`type_id` = 'pages' AND l.`item_id` = p.page_id)
WHERE p.view_id = 0
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | l | ref | type_id,type_id_2,type_id_3,item_id | type_id_3 | 81 | const,const | 1 | Using index condition |
1 | SIMPLE | p | eq_ref | PRIMARY,view_id_2,view_id,page_id | PRIMARY | 4 | sqlgipsol2.l.item_id | 1 | Using where |
0.0002379
| Memory Before: 5.22 Mb
| Memory After: 5.23 Mb
| Memory Used: 3.39 kb
| Rows: 0
| Slave: Yes
SELECT category_id,name
FROM phpfox_event_category
WHERE name_url = '21'
/* OO Query */
FROM phpfox_event_category
WHERE name_url = '21'
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | phpfox_event_category | ALL | MISSING KEY | 8 | Using where |
0.0030050
| Memory Before: 6.96 Mb
| Memory After: 6.96 Mb
| Memory Used: 3.13 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(m.event_id)
FROM phpfox_fevent AS m
INNER JOIN phpfox_fevent_text AS ft
ON(ft.event_id = m.event_id)
INNER JOIN phpfox_fevent_category_data AS mcd
ON(mcd.event_id = m.event_id)
WHERE m.view_id = 0 AND m.privacy IN(0) AND ( ( m.item_id = 0 ) ) AND mcd.category_id = 21
LIMIT 1
/* OO Query */
FROM phpfox_fevent AS m
INNER JOIN phpfox_fevent_text AS ft
ON(ft.event_id = m.event_id)
INNER JOIN phpfox_fevent_category_data AS mcd
ON(mcd.event_id = m.event_id)
WHERE m.view_id = 0 AND m.privacy IN(0) AND ( ( m.item_id = 0 ) ) AND mcd.category_id = 21
LIMIT 1
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | mcd | ref | category_id,event_id | category_id | 4 | const | 198 | |
1 | SIMPLE | m | eq_ref | PRIMARY,view_id,view_id_2,view_id_3,view_id_4,view_id_5 | PRIMARY | 4 | sqlgipsol2.mcd.event_id | 1 | Using where |
1 | SIMPLE | ft | ref | event_id | event_id | 4 | sqlgipsol2.mcd.event_id | 1 | Using index |
0.0051069
| Memory Before: 7.02 Mb
| Memory After: 7.05 Mb
| Memory Used: 33.4 kb
| Rows: 20
| Slave: Yes
SELECT m.server_id as event_server_id, m.*, u.*
FROM phpfox_fevent AS m
INNER JOIN phpfox_fevent_text AS ft
ON(ft.event_id = m.event_id)
INNER JOIN phpfox_fevent_category_data AS mcd
ON(mcd.event_id = m.event_id)
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
WHERE m.view_id = 0 AND m.privacy IN(0) AND ( ( m.item_id = 0 ) ) AND mcd.category_id = 21
GROUP BY m.event_id
ORDER BY m.total_comment DESC
LIMIT 20
/* OO Query */
FROM phpfox_fevent AS m
INNER JOIN phpfox_fevent_text AS ft
ON(ft.event_id = m.event_id)
INNER JOIN phpfox_fevent_category_data AS mcd
ON(mcd.event_id = m.event_id)
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
WHERE m.view_id = 0 AND m.privacy IN(0) AND ( ( m.item_id = 0 ) ) AND mcd.category_id = 21
GROUP BY m.event_id
ORDER BY m.total_comment DESC
LIMIT 20
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | mcd | ref | category_id,event_id | category_id | 4 | const | 198 | Using where; Using temporary; Using filesort |
1 | SIMPLE | m | eq_ref | PRIMARY,user_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5 | PRIMARY | 4 | sqlgipsol2.mcd.event_id | 1 | Using where |
1 | SIMPLE | ft | ref | event_id | event_id | 4 | sqlgipsol2.mcd.event_id | 1 | Using index |
1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol2.m.user_id | 1 |
0.0002718
| Memory Before: 7.31 Mb
| Memory After: 7.32 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 8589 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 8589 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.0002902
| Memory Before: 7.32 Mb
| Memory After: 7.32 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 5731 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 5731 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.0003331
| Memory Before: 7.32 Mb
| Memory After: 7.33 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 7938 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 7938 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.0002930
| Memory Before: 7.33 Mb
| Memory After: 7.33 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 7301 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 7301 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.0003860
| Memory Before: 7.33 Mb
| Memory After: 7.34 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 8918 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 8918 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.0003200
| Memory Before: 7.34 Mb
| Memory After: 7.34 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 7517 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 7517 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.0003109
| Memory Before: 7.34 Mb
| Memory After: 7.35 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 5233 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 5233 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.0002940
| Memory Before: 7.35 Mb
| Memory After: 7.35 Mb
| Memory Used: 3.4 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 7581 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 7581 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.0003331
| Memory Before: 7.35 Mb
| Memory After: 7.36 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 6715 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 6715 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.0002971
| Memory Before: 7.36 Mb
| Memory After: 7.36 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 9511 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 9511 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.0002148
| Memory Before: 7.36 Mb
| Memory After: 7.37 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 8222 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 8222 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.0001531
| Memory Before: 7.37 Mb
| Memory After: 7.37 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 7916 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 7916 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.0001469
| Memory Before: 7.37 Mb
| Memory After: 7.38 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 7198 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 7198 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.0001318
| Memory Before: 7.38 Mb
| Memory After: 7.38 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 8829 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 8829 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.0001280
| Memory Before: 7.38 Mb
| Memory After: 7.39 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 5726 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 5726 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.0000968
| Memory Before: 7.39 Mb
| Memory After: 7.39 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 5196 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 5196 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.0000870
| Memory Before: 7.39 Mb
| Memory After: 7.4 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 6686 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 6686 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.0000880
| Memory Before: 7.4 Mb
| Memory After: 7.4 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 9461 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 9461 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.0000842
| Memory Before: 7.4 Mb
| Memory After: 7.41 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 6464 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 6464 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.0000830
| Memory Before: 7.41 Mb
| Memory After: 7.41 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 8170 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 8170 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.0044930
| Memory Before: 7.41 Mb
| Memory After: 7.43 Mb
| Memory Used: 16.52 kb
| Rows: 3
| Slave: Yes
SELECT v.*, 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 v
JOIN phpfox_user AS u
ON(u.user_id = v.user_id)
WHERE v.view_id = 0 AND v.is_featured = 1 AND ((v.isrepeat>-1 and (v.timerepeat=0 or ( v.isrepeat>-1 and v.timerepeat>1713916800))) or ( v.isrepeat = -1 AND v.end_time >= '1713916800' ) )
ORDER BY v.start_time ASC
/* OO Query */
FROM phpfox_fevent AS v
JOIN phpfox_user AS u
ON(u.user_id = v.user_id)
WHERE v.view_id = 0 AND v.is_featured = 1 AND ((v.isrepeat>-1 and (v.timerepeat=0 or ( v.isrepeat>-1 and v.timerepeat>1713916800))) or ( v.isrepeat = -1 AND v.end_time >= '1713916800' ) )
ORDER BY v.start_time ASC
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | v | ALL | user_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5 | MISSING KEY | 7706 | Using where; Using filesort | ||
1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol2.v.user_id | 1 |
0.0002248
| Memory Before: 7.47 Mb
| Memory After: 7.47 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: No
SELECT rsvp_id
FROM phpfox_fevent_invite
WHERE event_id = 9783 AND invited_user_id = 0
LIMIT 1
/* OO Query */
FROM phpfox_fevent_invite
WHERE event_id = 9783 AND invited_user_id = 0
LIMIT 1
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | phpfox_fevent_invite | ref|filter | event_id,event_id_2,invited_user_id,event_id_3 | invited_user_id|event_id | 4|4 | const | 1 (0%) | Using where; Using rowid filter |
0.0001168
| Memory Before: 7.47 Mb
| Memory After: 7.48 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: No
SELECT rsvp_id
FROM phpfox_fevent_invite
WHERE event_id = 9776 AND invited_user_id = 0
LIMIT 1
/* OO Query */
FROM phpfox_fevent_invite
WHERE event_id = 9776 AND invited_user_id = 0
LIMIT 1
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | phpfox_fevent_invite | ref|filter | event_id,event_id_2,invited_user_id,event_id_3 | invited_user_id|event_id | 4|4 | const | 1 (0%) | Using where; Using rowid filter |
0.0001061
| Memory Before: 7.47 Mb
| Memory After: 7.48 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: No
SELECT rsvp_id
FROM phpfox_fevent_invite
WHERE event_id = 9777 AND invited_user_id = 0
LIMIT 1
/* OO Query */
FROM phpfox_fevent_invite
WHERE event_id = 9777 AND invited_user_id = 0
LIMIT 1
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | phpfox_fevent_invite | ref|filter | event_id,event_id_2,invited_user_id,event_id_3 | invited_user_id|event_id | 4|4 | const | 1 (0%) | Using where; Using rowid filter |
0.0003078
| Memory Before: 7.48 Mb
| Memory After: 7.48 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 | sqlgipsol2.l.item_id | 1 | Using where |
0.0039029
| Memory Before: 7.48 Mb
| Memory After: 7.48 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_fevent AS m
WHERE m.is_featured = 1 and m.view_id = 0 AND ( ( m.item_id = 0 ))
LIMIT 1
/* OO Query */
FROM phpfox_fevent AS m
WHERE m.is_featured = 1 and m.view_id = 0 AND ( ( m.item_id = 0 ))
LIMIT 1
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | view_id,view_id_2,view_id_3,view_id_4,view_id_5 | MISSING KEY | 7706 | Using where |
0.0001769
| Memory Before: 7.61 Mb
| Memory After: 7.61 Mb
| Memory Used: 3.19 kb
| Rows: 1
| Slave: No
SELECT category_id
FROM phpfox_fevent_category
WHERE category_id = '21'
LIMIT 1
/* OO Query */
FROM phpfox_fevent_category
WHERE category_id = '21'
LIMIT 1
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | phpfox_fevent_category | const | PRIMARY | PRIMARY | 3 | const | 1 | Using index |
0.0000858
| Memory Before: 7.61 Mb
| Memory After: 7.61 Mb
| Memory Used: 3.4 kb
| Rows: 1
| Slave: No
SELECT pc.category_id, pc.parent_id
FROM phpfox_fevent_category AS pc
WHERE pc.category_id = 21
/* OO Query */
FROM phpfox_fevent_category AS pc
WHERE pc.category_id = 21
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | pc | const | PRIMARY | PRIMARY | 3 | const | 1 |
0.0002370
| Memory Before: 7.61 Mb
| Memory After: 7.62 Mb
| Memory Used: 3.37 kb
| Rows: 0
| Slave: No
SELECT pc.category_id, pc.parent_id
FROM phpfox_fevent_category AS pc
WHERE pc.category_id = 0
/* OO Query */
FROM phpfox_fevent_category AS pc
WHERE pc.category_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.0001800
| Memory Before: 7.61 Mb
| Memory After: 7.62 Mb
| Memory Used: 4.98 kb
| Rows: 1
| Slave: No
SELECT *
FROM phpfox_fevent_category
WHERE category_id IN(21)
/* OO Query */
FROM phpfox_fevent_category
WHERE category_id IN(21)
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | phpfox_fevent_category | const | PRIMARY | PRIMARY | 3 | const | 1 |
0.0005960
| Memory Before: 11.24 Mb
| Memory After: 11.27 Mb
| Memory Used: 34.61 kb
| Rows: 0
| Slave: Yes
SELECT p.photo_id as cover_photo_exists, u.*, user_space.*, user_field.*, user_activity.*, ls.user_id AS is_online, ts.style_id AS designer_style_id, ts.folder AS designer_style_folder, t.folder AS designer_theme_folder, t.total_column, ts.l_width, ts.c_width, ts.r_width, t.parent_id AS theme_parent_id, ug.prefix, ug.suffix, ug.icon_ext, ug.title, uf.user_id as is_featured
FROM phpfox_user AS u
JOIN phpfox_user_group AS ug
ON(ug.user_group_id = u.user_group_id)
JOIN phpfox_user_space AS user_space
ON(user_space.user_id = u.user_id)
JOIN phpfox_user_field AS user_field
ON(user_field.user_id = u.user_id)
JOIN phpfox_user_activity AS user_activity
ON(user_activity.user_id = u.user_id)
LEFT JOIN phpfox_theme_style AS ts
ON(ts.style_id = user_field.designer_style_id AND ts.is_active = 1)
LEFT JOIN phpfox_theme AS t
ON(t.theme_id = ts.theme_id)
LEFT JOIN phpfox_user_featured AS uf
ON(uf.user_id = u.user_id)
LEFT JOIN phpfox_log_session AS ls
ON(ls.user_id = u.user_id AND ls.im_hide = 0)
LEFT JOIN phpfox_photo AS p
ON(p.photo_id = user_field.cover_photo)
WHERE u.user_id = 0
/* OO Query */
FROM phpfox_user AS u
JOIN phpfox_user_group AS ug
ON(ug.user_group_id = u.user_group_id)
JOIN phpfox_user_space AS user_space
ON(user_space.user_id = u.user_id)
JOIN phpfox_user_field AS user_field
ON(user_field.user_id = u.user_id)
JOIN phpfox_user_activity AS user_activity
ON(user_activity.user_id = u.user_id)
LEFT JOIN phpfox_theme_style AS ts
ON(ts.style_id = user_field.designer_style_id AND ts.is_active = 1)
LEFT JOIN phpfox_theme AS t
ON(t.theme_id = ts.theme_id)
LEFT JOIN phpfox_user_featured AS uf
ON(uf.user_id = u.user_id)
LEFT JOIN phpfox_log_session AS ls
ON(ls.user_id = u.user_id AND ls.im_hide = 0)
LEFT JOIN phpfox_photo AS p
ON(p.photo_id = user_field.cover_photo)
WHERE u.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 |
Array ( [session] => adfbc5d7a57c923a4085a103e4280a22 [redirect] => /fevent/category/21/adinekoak/show_20/when_all-time/sort_most-talked/ )
Array ( )