0.0006511
| Memory Before: 1.25 Mb
| Memory After: 1.28 Mb
| Memory Used: 29.79 kb
| Rows: 565
| Slave: No
SELECT s.type_id, s.var_name, s.value_actual, m.module_id
AS module_name
FROM phpfox_setting
AS s
JOIN phpfox_module
AS m
ON(m.module_id = s.module_id AND m.is_active = 1)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | index | is_active,module_id,module_is_active | module_is_active | 78 | | 85 | Using where; Using index |
| 1 | SIMPLE | s | ref | module_id | module_id | 78 | sqlgipsol.m.module_id | 11 | |
0.0002849
| Memory Before: 2.05 Mb
| Memory After: 2.05 Mb
| Memory Used: 4.36 kb
| Rows: 76
| Slave: No
SELECT m.module_id
FROM phpfox_module
AS m
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.is_active = 1
ORDER BY m.module_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | is_active | MISSING KEY | | | 85 | Using where; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
0.0002830
| Memory Before: 1.71 Mb
| Memory After: 1.72 Mb
| Memory Used: 3.45 kb
| Rows: 5
| Slave: No
SELECT p.call_name, p.php_code
FROM phpfox_plugin
AS p
JOIN phpfox_product
AS product
ON(p.product_id = product.product_id AND product.is_active = 1)
JOIN phpfox_plugin_hook
AS ph
ON(ph.call_name = p.call_name AND ph.is_active = 1)
JOIN phpfox_module
AS m
ON(m.module_id = p.module_id AND m.is_active = 1)
WHERE p.is_active = 1
ORDER BY p.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | p | ALL | is_active | MISSING KEY | | | 5 | Using where; Using filesort |
| 1 | SIMPLE | ph | ref | call_name | call_name | 258 | sqlgipsol.p.call_name,const | 1 | Using where; Using index |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.p.module_id,const | 8 | Using index |
0.0002730
| Memory Before: 1.91 Mb
| Memory After: 1.91 Mb
| Memory Used: 7.48 kb
| Rows: 26
| Slave: No
SELECT product.*
FROM phpfox_product
AS product
ORDER BY product.is_core
DESC , product.product_id ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | product | ALL | | MISSING KEY | | | 26 | Using filesort |
0.0002348
| Memory Before: 2.29 Mb
| Memory After: 2.29 Mb
| Memory Used: 3.4 kb
| Rows: 2
| Slave: No
SELECT r.url, r.replacement
FROM phpfox_rewrite
AS r
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | r | ALL | | MISSING KEY | | | 2 | |
0.0008001
| Memory Before: 2.5 Mb
| Memory After: 2.5 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 ('0cf0f82f6703713d1f6356f921edb92c', '0d574f7196f9f96e319d05681455513d', '0', '1766421991', '/mobile/GipuzkoaSolidarioa/fevent/show_15/when_all-time/page_34', '0', '0', '0', '216.73.216.164', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.')
0.0003300
| Memory Before: 2.59 Mb
| Memory After: 2.63 Mb
| Memory Used: 38.09 kb
| Rows: 472
| Slave: Yes
SELECT m.module_id, user_group_setting.name, user_group_setting.type_id, user_group_setting.default_admin, user_group_setting.default_user, user_group_setting.default_guest, user_group_setting.default_staff, user_setting.value_actual
AS value_actual
FROM phpfox_user_group_setting
AS user_group_setting
JOIN phpfox_module
AS m
ON(m.module_id = user_group_setting.module_id)
LEFT JOIN phpfox_user_setting
AS user_setting
ON(user_setting.user_group_id = '3' AND user_setting.setting_id = user_group_setting.setting_id)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | user_group_setting | ALL | module_id | MISSING KEY | | | 472 | Using where |
| 1 | SIMPLE | user_setting | ref | user_group_id | user_group_id | 4 | const,sqlgipsol.user_group_setting.setting_id | 1 | |
| 1 | SIMPLE | m | ref | module_id,module_is_active | module_id | 77 | sqlgipsol.user_group_setting.module_id | 8 | Using index |
0.0002398
| Memory Before: 4.05 Mb
| Memory After: 4.05 Mb
| Memory Used: 3.27 kb
| Rows: 9
| Slave: No
SELECT ts.style_id
FROM phpfox_theme_style
AS ts
JOIN phpfox_theme
AS t
ON(t.theme_id = ts.theme_id AND t.is_active = 1)
WHERE ts.is_active = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | ts | ALL | is_active | MISSING KEY | | | 9 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,is_active,theme_id | PRIMARY | 2 | sqlgipsol.ts.theme_id | 1 | Using where |
0.0002420
| Memory Before: 4.02 Mb
| Memory After: 4.03 Mb
| Memory Used: 5.16 kb
| Rows: 1
| Slave: No
SELECT s.style_id, s.parent_id
AS style_parent_id, s.folder
AS style_folder_name, t.folder
AS theme_folder_name, t.parent_id
AS theme_parent_id, t.total_column, s.l_width, s.c_width, s.r_width
FROM phpfox_theme_style
AS s
JOIN phpfox_theme
AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | s | ref | is_default | is_default | 1 | const | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | sqlgipsol.s.theme_id | 1 | |
0.0001090
| Memory Before: 4.02 Mb
| Memory After: 4.03 Mb
| Memory Used: 3.34 kb
| Rows: 1
| Slave: No
SELECT folder
AS parent_style_folder
FROM phpfox_theme_style
WHERE style_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_style | const | style_id_2,style_id | style_id_2 | 2 | const | 1 | |
0.0002282
| Memory Before: 4.63 Mb
| Memory After: 4.64 Mb
| Memory Used: 6.34 kb
| Rows: 3
| Slave: No
SELECT *
FROM phpfox_language
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_language | ALL | | MISSING KEY | | | 3 | |
0.0001221
| Memory Before: 4.64 Mb
| Memory After: 4.65 Mb
| Memory Used: 6.18 kb
| Rows: 1
| Slave: No
SELECT *
FROM phpfox_language
WHERE language_id = 'eu'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_language | const | PRIMARY | PRIMARY | 14 | const | 1 | |
0.0943649
| Memory Before: 4.65 Mb
| Memory After: 5.16 Mb
| Memory Used: 525.3 kb
| Rows: 15799
| Slave: No
SELECT p.var_name, p.text, m.module_id
FROM phpfox_language_phrase
AS p
LEFT JOIN phpfox_module
AS m
ON(p.module_id = m.module_id AND m.is_active = 1)
JOIN phpfox_product
AS product
ON(p.product_id = product.product_id AND product.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | p | ALL | language_id,setting_list | MISSING KEY | | | 42874 | Using where |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.p.module_id,const | 8 | Using where; Using index |
0.0037861
| Memory Before: 9.19 Mb
| Memory After: 9.54 Mb
| Memory Used: 364.9 kb
| Rows: 11562
| Slave: No
SELECT p.var_name, p.text, m.module_id
FROM phpfox_language_phrase
AS p
LEFT JOIN phpfox_module
AS m
ON(p.module_id = m.module_id AND m.is_active = 1)
JOIN phpfox_product
AS product
ON(p.product_id = product.product_id AND product.is_active = 1)
WHERE p.language_id = 'en'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | p | ALL | language_id,setting_list | MISSING KEY | | | 42874 | Using where |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.p.module_id,const | 8 | Using where; Using index |
0.0003040
| Memory Before: 21.7 Mb
| Memory After: 21.71 Mb
| Memory Used: 3.9 kb
| Rows: 0
| Slave: No
SELECT var_name, rule, rule_value, ordering
FROM phpfox_language_rule
WHERE language_id = 'eu'
ORDER BY ordering ASC
/* 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.0003190
| Memory Before: 4.67 Mb
| Memory After: 4.69 Mb
| Memory Used: 17.44 kb
| Rows: 143
| Slave: No
SELECT b.block_id, b.type_id, b.ordering, b.m_connection, b.component, b.location, b.disallow_access, b.can_move, m.module_id, bs.source_parsed
FROM phpfox_block
AS b
LEFT JOIN phpfox_block_source
AS bs
ON(bs.block_id = b.block_id)
JOIN phpfox_module
AS m
ON(b.module_id = m.module_id AND m.is_active = 1)
JOIN phpfox_product
AS p
ON(b.product_id = p.product_id AND p.is_active = 1)
WHERE b.is_active = 1
ORDER BY b.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | index | is_active,module_id,module_is_active | module_is_active | 78 | | 85 | Using where; Using index; Using temporary; Using filesort |
| 1 | SIMPLE | b | ref|filter | is_active,product_id,module_id | module_id|is_active | 77|1 | sqlgipsol.m.module_id | 9 (63%) | Using where; Using rowid filter |
| 1 | SIMPLE | bs | ref | block_id | block_id | 4 | sqlgipsol.b.block_id | 5 | |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.b.product_id,const | 3 | Using index |
0.0002122
| Memory Before: 4.94 Mb
| Memory After: 4.94 Mb
| Memory Used: 3.18 kb
| Rows: 0
| Slave: No
SELECT find_value
FROM phpfox_ban
WHERE type_id = 'ip'
/* 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.0005379
| Memory Before: 4.93 Mb
| Memory After: 4.96 Mb
| Memory Used: 26.65 kb
| Rows: 990
| Slave: No
SELECT page_id, title_url
FROM phpfox_page
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_page | ALL | | MISSING KEY | | | 990 | |
0.0002279
| Memory Before: 5.35 Mb
| Memory After: 5.35 Mb
| Memory Used: 4.2 kb
| Rows: 3
| Slave: Yes
SELECT *
FROM phpfox_seo_meta
ORDER BY time_stamp
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_seo_meta | ALL | | MISSING KEY | | | 3 | Using filesort |
0.0019419
| Memory Before: 5.52 Mb
| Memory After: 5.56 Mb
| Memory Used: 35.62 kb
| Rows: 1
| 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_name = 'GipuzkoaSolidarioa'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | u | ref | PRIMARY,user_group_id,user_id,user_name | user_name | 103 | const | 1 | Using index condition |
| 1 | SIMPLE | user_field | eq_ref | user_id | user_id | 4 | sqlgipsol.u.user_id | 1 | |
| 1 | SIMPLE | ts | eq_ref | style_id_2,style_id,is_active | style_id_2 | 2 | sqlgipsol.user_field.designer_style_id | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | sqlgipsol.ts.theme_id | 1 | Using where |
| 1 | SIMPLE | ug | eq_ref | PRIMARY,user_group_id | PRIMARY | 1 | sqlgipsol.u.user_group_id | 1 | Using index condition |
| 1 | SIMPLE | uf | eq_ref | PRIMARY | PRIMARY | 4 | sqlgipsol.u.user_id | 1 | Using index |
| 1 | SIMPLE | user_space | eq_ref | user_id | user_id | 4 | sqlgipsol.u.user_id | 1 | |
| 1 | SIMPLE | user_activity | eq_ref | user_id | user_id | 4 | sqlgipsol.u.user_id | 1 | |
| 1 | SIMPLE | ls | ref | user_id,user_id_2,user_id_3 | user_id | 5 | sqlgipsol.u.user_id,const | 723 | Using index |
| 1 | SIMPLE | p | eq_ref | PRIMARY,photo_id,photo_id_2 | PRIMARY | 4 | sqlgipsol.user_field.cover_photo | 1 | Using index |
0.0002320
| Memory Before: 6.12 Mb
| Memory After: 6.13 Mb
| Memory Used: 5.44 kb
| Rows: 89
| Slave: No
SELECT c.country_iso, c.name
FROM phpfox_country
AS c
ORDER BY c.ordering ASC, c.name ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | c | ALL | | MISSING KEY | | | 89 | Using filesort |
0.0002210
| Memory Before: 12.05 Mb
| Memory After: 12.05 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_fevent
WHERE view_id = 0 AND item_id = 0 AND user_id = 6
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_fevent | ref | user_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5 | view_id_2 | 1 | const | 9005 | Using where; Using index |
0.0002382
| Memory Before: 12.03 Mb
| Memory After: 12.04 Mb
| Memory Used: 4.13 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_user_blocked
WHERE block_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.0002129
| Memory Before: 11.46 Mb
| Memory After: 11.46 Mb
| Memory Used: 3.39 kb
| Rows: 0
| Slave: Yes
SELECT category_id,name
FROM phpfox_event_category
WHERE name_url = 'fevent'
/* 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.0002151
| Memory Before: 12.04 Mb
| Memory After: 12.05 Mb
| Memory Used: 4.74 kb
| Rows: 0
| Slave: Yes
SELECT i.*, io.phrase_var as option_phrase_var
FROM phpfox_input_field
AS i
LEFT JOIN phpfox_input_option
AS io
ON(io.field_id = i.field_id)
WHERE module_id = "fevent"
/* 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.0002141
| Memory Before: 13.11 Mb
| Memory After: 13.12 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)
WHERE m.view_id = 0 AND m.privacy IN(0) AND m.user_id = 6
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,user_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5 | user_id | 4 | const | 3215 | Using where |
| 1 | SIMPLE | ft | ref | event_id | event_id | 4 | sqlgipsol.m.event_id | 1 | Using index |
0.0361578
| Memory Before: 13.29 Mb
| Memory After: 13.32 Mb
| Memory Used: 29.38 kb
| Rows: 15
| 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)
JOIN phpfox_user
AS u
ON(u.user_id = m.user_id)
WHERE m.view_id = 0 AND m.privacy IN(0) AND m.user_id = 6
ORDER BY m.time_stamp
DESC
LIMIT 15
OFF SET 495
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | u | const | PRIMARY,user_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | m | range | PRIMARY,user_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5 | user_id | 4 | | 3215 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | ft | ref | event_id | event_id | 4 | sqlgipsol.m.event_id | 1 | Using index |
0.0002251
| Memory Before: 13.52 Mb
| Memory After: 13.52 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10072 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.0002131
| Memory Before: 13.52 Mb
| Memory After: 13.52 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10071 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.0002050
| Memory Before: 13.53 Mb
| Memory After: 13.53 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10070 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.0002050
| Memory Before: 13.53 Mb
| Memory After: 13.53 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10069 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.0001540
| Memory Before: 13.54 Mb
| Memory After: 13.54 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10067 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.0002530
| Memory Before: 13.54 Mb
| Memory After: 13.54 Mb
| Memory Used: 3.39 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10066 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.0002379
| Memory Before: 13.55 Mb
| Memory After: 13.55 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10065 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: 13.55 Mb
| Memory After: 13.56 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10064 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.0002410
| Memory Before: 13.56 Mb
| Memory After: 13.56 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10063 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.0002282
| Memory Before: 13.56 Mb
| Memory After: 13.57 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10062 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: 13.57 Mb
| Memory After: 13.57 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10061 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.0002711
| Memory Before: 13.57 Mb
| Memory After: 13.58 Mb
| Memory Used: 3.4 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10060 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.0002820
| Memory Before: 13.58 Mb
| Memory After: 13.58 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10059 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.0002720
| Memory Before: 13.58 Mb
| Memory After: 13.59 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10058 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.0002801
| Memory Before: 13.59 Mb
| Memory After: 13.59 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 10057 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.0077178
| Memory Before: 13.61 Mb
| Memory After: 13.63 Mb
| Memory Used: 15.1 kb
| Rows: 0
| 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>1766361600))) or ( v.isrepeat = -1 AND v.end_time >= '1766361600' ) )
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 | | | 9006 | Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.v.user_id | 1 | |
0.0001891
| Memory Before: 13.8 Mb
| Memory After: 13.81 Mb
| Memory Used: 6.19 kb
| Rows: 16
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active, m.mobile_icon
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'main' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | index_merge | product_id,m_connection,parent_id | m_connection,parent_id | 79,3 | | 4 | Using intersect(m_connection,parent_id); Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000970
| Memory Before: 13.83 Mb
| Memory After: 13.83 Mb
| Memory Used: 6.19 kb
| Rows: 16
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active, m.mobile_icon
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'main' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | index_merge | product_id,m_connection,parent_id | m_connection,parent_id | 79,3 | | 4 | Using intersect(m_connection,parent_id); Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0001130
| Memory Before: 13.85 Mb
| Memory After: 13.86 Mb
| Memory Used: 9.7 kb
| Rows: 71
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | | | 209 | Using where; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0001779
| Memory Before: 13.87 Mb
| Memory After: 13.88 Mb
| Memory Used: 5.07 kb
| Rows: 2
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active, m.mobile_icon
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'main_right' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000889
| Memory Before: 13.86 Mb
| Memory After: 13.87 Mb
| Memory Used: 5.07 kb
| Rows: 2
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active, m.mobile_icon
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'main_right' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0001009
| Memory Before: 13.87 Mb
| Memory After: 13.88 Mb
| Memory Used: 9.7 kb
| Rows: 71
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | | | 209 | Using where; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000820
| Memory Before: 13.89 Mb
| Memory After: 13.9 Mb
| Memory Used: 4.91 kb
| Rows: 0
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active, m.mobile_icon
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'explore' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000691
| Memory Before: 13.87 Mb
| Memory After: 13.87 Mb
| Memory Used: 4.91 kb
| Rows: 0
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active, m.mobile_icon
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'explore' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000861
| Memory Before: 13.87 Mb
| Memory After: 13.88 Mb
| Memory Used: 9.67 kb
| Rows: 71
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | | | 209 | Using where; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000789
| Memory Before: 13.9 Mb
| Memory After: 13.91 Mb
| Memory Used: 5.01 kb
| Rows: 1
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active, m.mobile_icon
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'fevent.index' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000699
| Memory Before: 13.88 Mb
| Memory After: 13.88 Mb
| Memory Used: 4.91 kb
| Rows: 0
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active, m.mobile_icon
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'fevent' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000858
| Memory Before: 13.88 Mb
| Memory After: 13.89 Mb
| Memory Used: 9.67 kb
| Rows: 71
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | | | 209 | Using where; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000820
| Memory Before: 13.91 Mb
| Memory After: 13.92 Mb
| Memory Used: 5.38 kb
| Rows: 6
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active, m.mobile_icon
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'footer' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | index_merge | product_id,m_connection,parent_id | m_connection,parent_id | 79,3 | | 1 | Using intersect(m_connection,parent_id); Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000720
| Memory Before: 13.9 Mb
| Memory After: 13.9 Mb
| Memory Used: 5.38 kb
| Rows: 6
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active, m.mobile_icon
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'footer' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | index_merge | product_id,m_connection,parent_id | m_connection,parent_id | 79,3 | | 1 | Using intersect(m_connection,parent_id); Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000858
| Memory Before: 13.91 Mb
| Memory After: 13.92 Mb
| Memory Used: 9.68 kb
| Rows: 71
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id
AS module, m.url_value
AS url, mo.is_active
AS module_is_active
FROM phpfox_menu
AS m
JOIN phpfox_module
AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product
AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | | | 209 | Using where; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0001621
| Memory Before: 14.24 Mb
| Memory After: 14.25 Mb
| Memory Used: 9.52 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad
AS a
LEFT JOIN phpfox_ad_country
AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '3'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | is_active | is_active | 53 | const,const | 1 | Using index condition |
| 1 | SIMPLE | ac | ALL | ad_id | MISSING KEY | | | 1 | Using where; Using join buffer (flat, BNL join) |
0.0000799
| Memory Before: 14.21 Mb
| Memory After: 14.22 Mb
| Memory Used: 3.63 kb
| Rows: 0
| Slave: No
SELECT logo_id, logo, file_ext
FROM phpfox_theme_style_logo
WHERE style_id = 11
/* 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.0001550
| Memory Before: 14.74 Mb
| Memory After: 14.74 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0001998
| Memory Before: 15.09 Mb
| Memory After: 15.09 Mb
| Memory Used: 3.34 kb
| Rows: 0
| Slave: No
SELECT tc.module_id, tc.file_name
FROM phpfox_theme_css
AS tc
WHERE style_id = 11
/* 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.0001929
| Memory Before: 15.58 Mb
| Memory After: 15.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 = '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.0002160
| Memory Before: 15.65 Mb
| Memory After: 15.66 Mb
| Memory Used: 9.52 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad
AS a
LEFT JOIN phpfox_ad_country
AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '14'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | is_active | is_active | 53 | const,const | 1 | Using index condition |
| 1 | SIMPLE | ac | ALL | ad_id | MISSING KEY | | | 1 | Using where; Using join buffer (flat, BNL join) |
0.0001070
| Memory Before: 15.68 Mb
| Memory After: 15.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 = '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.0002041
| Memory Before: 15.81 Mb
| Memory After: 15.82 Mb
| Memory Used: 6.05 kb
| Rows: 2
| Slave: Yes
SELECT l.*
FROM phpfox_language
AS l
WHERE l.user_select = 1
ORDER BY l.is_default
DESC , l.title
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | l | ref | user_select | user_select | 1 | const | 2 | Using where; Using filesort |
0.0001130
| Memory Before: 15.82 Mb
| Memory After: 15.82 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = '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.0001099
| Memory Before: 15.84 Mb
| Memory After: 15.85 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002708
| Memory Before: 26.9 Mb
| Memory After: 26.91 Mb
| Memory Used: 9.51 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad
AS a
LEFT JOIN phpfox_ad_country
AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '9'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | is_active | is_active | 53 | const,const | 1 | Using index condition |
| 1 | SIMPLE | ac | ALL | ad_id | MISSING KEY | | | 1 | Using where; Using join buffer (flat, BNL join) |
0.0001252
| Memory Before: 26.91 Mb
| Memory After: 26.92 Mb
| Memory Used: 9.51 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad
AS a
LEFT JOIN phpfox_ad_country
AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '10'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | is_active | is_active | 53 | const,const | 1 | Using index condition |
| 1 | SIMPLE | ac | ALL | ad_id | MISSING KEY | | | 1 | Using where; Using join buffer (flat, BNL join) |
0.0001130
| Memory Before: 26.91 Mb
| Memory After: 26.92 Mb
| Memory Used: 9.51 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad
AS a
LEFT JOIN phpfox_ad_country
AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '6'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | is_active | is_active | 53 | const,const | 1 | Using index condition |
| 1 | SIMPLE | ac | ALL | ad_id | MISSING KEY | | | 1 | Using where; Using join buffer (flat, BNL join) |
0.0001030
| Memory Before: 26.92 Mb
| Memory After: 26.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 = '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.0002251
| Memory Before: 26.91 Mb
| Memory After: 26.92 Mb
| Memory Used: 9.52 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad
AS a
LEFT JOIN phpfox_ad_country
AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '11'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | is_active | is_active | 53 | const,const | 1 | Using index condition |
| 1 | SIMPLE | ac | ALL | ad_id | MISSING KEY | | | 1 | Using where; Using join buffer (flat, BNL join) |
0.0001190
| Memory Before: 26.93 Mb
| Memory After: 26.93 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-holdername.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001161
| Memory Before: 26.93 Mb
| Memory After: 26.94 Mb
| Memory Used: 9.51 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad
AS a
LEFT JOIN phpfox_ad_country
AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '13'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | is_active | is_active | 53 | const,const | 1 | Using index condition |
| 1 | SIMPLE | ac | ALL | ad_id | MISSING KEY | | | 1 | Using where; Using join buffer (flat, BNL join) |
0.0001090
| Memory Before: 26.93 Mb
| Memory After: 26.94 Mb
| Memory Used: 9.51 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad
AS a
LEFT JOIN phpfox_ad_country
AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '7'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | is_active | is_active | 53 | const,const | 1 | Using index condition |
| 1 | SIMPLE | ac | ALL | ad_id | MISSING KEY | | | 1 | Using where; Using join buffer (flat, BNL join) |
0.0002661
| Memory Before: 27.27 Mb
| Memory After: 27.29 Mb
| Memory Used: 20.23 kb
| Rows: 95
| Slave: Yes
SELECT cf.*, cmv.option_id as customValue, cg.user_group_id as cg_user_group_id
FROM phpfox_custom_field
AS cf
LEFT JOIN phpfox_user_custom_multiple_value
AS cmv
ON(cmv.field_id = cf.field_id AND cmv.user_id = 6)
JOIN phpfox_module
AS m
ON(m.module_id = cf.module_id AND m.is_active = 1)
LEFT JOIN phpfox_custom_group
AS cg
ON(cg.group_id = cf.group_id)
WHERE cf.type_id IN ('user_main','user_panel','profile_panel') AND cf.is_active = 1 AND cf.user_group_id = 0
ORDER BY cf.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | cf | ALL | | MISSING KEY | | | 82 | Using where; Using filesort |
| 1 | SIMPLE | cg | eq_ref | PRIMARY | PRIMARY | 2 | sqlgipsol.cf.group_id | 1 | |
| 1 | SIMPLE | cmv | ref | user_id | user_id | 6 | const,sqlgipsol.cf.field_id | 1 | |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.cf.module_id,const | 8 | Using index |
0.0001829
| Memory Before: 27.58 Mb
| Memory After: 27.61 Mb
| Memory Used: 26.94 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 6
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_user_custom | const | user_id | user_id | 4 | const | 1 | |
0.0001240
| Memory Before: 27.57 Mb
| Memory After: 27.57 Mb
| Memory Used: 5.68 kb
| Rows: 64
| Slave: Yes
SELECT *
FROM phpfox_custom_option
WHERE field_id IN(22,9,79,80,81,48,33,38,51,53,54,55,58,59,61,62,63,64,66,68,69,70,71,72,73,74,75,76,77)
ORDER BY option_id ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_custom_option | ALL | field_id | MISSING KEY | | | 75 | Using where; Using filesort |
0.0002310
| Memory Before: 27.41 Mb
| Memory After: 27.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 = 'base5' AND module_id = 'profile' AND name = 'block/header.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.0002220
| Memory Before: 27.79 Mb
| Memory After: 27.8 Mb
| Memory Used: 10.59 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_photo
WHERE photo_id = 4414
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_photo | const | PRIMARY,photo_id,photo_id_2 | PRIMARY | 4 | const | 1 | |
0.0001249
| Memory Before: 27.84 Mb
| Memory After: 27.85 Mb
| Memory Used: 3.74 kb
| Rows: 3
| Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 6
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_user_privacy | ref | user_id,user_id_2 | user_id_2 | 4 | const | 2 | |
0.0001061
| Memory Before: 27.97 Mb
| Memory After: 27.97 Mb
| Memory Used: 3.19 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/logo.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: 28.16 Mb
| Memory After: 28.16 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/pic.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.0002291
| Memory Before: 28.16 Mb
| Memory After: 28.16 Mb
| Memory Used: 9.51 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad
AS a
LEFT JOIN phpfox_ad_country
AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '12'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | is_active | is_active | 53 | const,const | 1 | Using index condition |
| 1 | SIMPLE | ac | ALL | ad_id | MISSING KEY | | | 1 | Using where; Using join buffer (flat, BNL join) |
0.0001171
| Memory Before: 27.9 Mb
| Memory After: 27.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 = '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.0002129
| Memory Before: 27.93 Mb
| Memory After: 27.93 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-contentclass.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001531
| Memory Before: 27.93 Mb
| Memory After: 27.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 = '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.0002170
| Memory Before: 27.94 Mb
| Memory After: 27.95 Mb
| Memory Used: 9.51 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad
AS a
LEFT JOIN phpfox_ad_country
AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '2'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | is_active | is_active | 53 | const,const | 1 | Using index condition |
| 1 | SIMPLE | ac | ALL | ad_id | MISSING KEY | | | 1 | Using where; Using join buffer (flat, BNL join) |
0.0001130
| Memory Before: 27.94 Mb
| Memory After: 27.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 = 'controller' AND module_id = 'fevent' AND name = 'profile.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: 27.96 Mb
| Memory After: 27.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 = 'listing-edit-item.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.0002339
| Memory Before: 27.96 Mb
| Memory After: 27.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 = 'fevent' AND name = 'listing-edit-item.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.0002141
| Memory Before: 27.97 Mb
| Memory After: 27.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 = 'fevent' AND name = 'listing-edit-item.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: 27.97 Mb
| Memory After: 27.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 = 'fevent' AND name = 'listing-edit-item.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: 27.97 Mb
| Memory After: 27.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 = 'fevent' AND name = 'listing-edit-item.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.0002320
| Memory Before: 27.97 Mb
| Memory After: 27.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 = 'fevent' AND name = 'listing-edit-item.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: 27.97 Mb
| Memory After: 27.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 = 'fevent' AND name = 'listing-edit-item.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: 27.97 Mb
| Memory After: 27.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 = 'fevent' AND name = 'listing-edit-item.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: 27.98 Mb
| Memory After: 27.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 = 'fevent' AND name = 'listing-edit-item.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.0002151
| Memory Before: 27.99 Mb
| Memory After: 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 = 'fevent' AND name = 'listing-edit-item.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.0001831
| Memory Before: 27.99 Mb
| Memory After: 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 = 'fevent' AND name = 'listing-edit-item.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.0001409
| Memory Before: 28 Mb
| Memory After: 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 = 'fevent' AND name = 'listing-edit-item.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: 28 Mb
| Memory After: 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 = 'fevent' AND name = 'listing-edit-item.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.0001550
| Memory Before: 28 Mb
| Memory After: 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 = 'fevent' AND name = 'listing-edit-item.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: 28 Mb
| Memory After: 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 = 'fevent' AND name = 'listing-edit-item.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.0001111
| Memory Before: 28.01 Mb
| Memory After: 28.01 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'pager.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0001049
| Memory Before: 27.99 Mb
| Memory After: 28 Mb
| Memory Used: 9.52 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad
AS a
LEFT JOIN phpfox_ad_country
AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '4'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | is_active | is_active | 53 | const,const | 1 | Using index condition |
| 1 | SIMPLE | ac | ALL | ad_id | MISSING KEY | | | 1 | Using where; Using join buffer (flat, BNL join) |
0.0014338
| Memory Before: 28.01 Mb
| Memory After: 28.03 Mb
| Memory Used: 16.75 kb
| Rows: 0
| Slave: No
SELECT s.*, s.country_iso
AS sponsor_country_iso, e.*
FROM phpfox_fevent
AS e
JOIN phpfox_user
AS u
ON(u.user_id = e.user_id)
JOIN phpfox_ad_sponsor
AS s
ON(s.item_id = e.event_id)
WHERE e.view_id = 0 AND e.privacy = 0 AND e.is_sponsor = 1 AND s.module_id = "fevent" AND e.start_time >= '1766361600'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | | MISSING KEY | | | 21 | Using where |
| 1 | SIMPLE | e | eq_ref | PRIMARY,user_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5 | PRIMARY | 4 | sqlgipsol.s.item_id | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.e.user_id | 1 | Using index |
0.0001421
| Memory Before: 28.02 Mb
| Memory After: 28.03 Mb
| Memory Used: 9.52 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad
AS a
LEFT JOIN phpfox_ad_country
AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '8'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | is_active | is_active | 53 | const,const | 1 | Using index condition |
| 1 | SIMPLE | ac | ALL | ad_id | MISSING KEY | | | 1 | Using where; Using join buffer (flat, BNL join) |
0.0001261
| Memory Before: 28.03 Mb
| Memory After: 28.04 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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 |
Gertaera berria sortu 