Gertaera berria sortu
Ez da gertaerarik topatu.
Berdintasuna
Emakumea Surflari se inicia en el año 2014 y es un proyecto de Surf sin ánimo de lucro. Está dirigido al sector que por la influencia de la sociedad tiene mas dificultades en cuanto al género se refiere, es decir, mujeres, trans e int
phpFox Developers Debug
Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula
Total Time:
0.6068799
PHP General Time:
0.4618526
GZIP:
disabled
Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.1450273
SQL Queries:
87
SQL Memory Usage:
1.58 Mb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
27.83 Mb
Total Memory Usage (Including Debug):
28.03 Mb
Memory Limit:
512 Mb (1024M)
Load Balancing Enabled:
No
Requests From:
192.168.100.222
Server Time Stamp:
April 8, 2026, 11:18 am
PHP Version:
5.6.40
PHP Sapi:
fpm-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux
Cache:
file
SQL Queries
0.0007958
| Memory Before: 1.25 Mb
| Memory After: 1.28 Mb
| Memory Used: 29.91 kb
| Rows: 569
| 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 */
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.0002692
| Memory Before: 2.05 Mb
| Memory After: 2.05 Mb
| Memory Used: 4.37 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 */
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.0001981
| Memory Before: 1.72 Mb
| Memory After: 1.72 Mb
| Memory Used: 3.46 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 */
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.0002360
| Memory Before: 1.92 Mb
| Memory After: 1.93 Mb
| Memory Used: 7.46 kb
| Rows: 26
| Slave: No
SELECT product.*
FROM phpfox_product AS product
ORDER BY product.is_core DESC , product.product_id ASC
/* OO Query */
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.0002451
| Memory Before: 2.29 Mb
| Memory After: 2.3 Mb
| Memory Used: 3.39 kb
| Rows: 2
| Slave: No
SELECT r.url, r.replacement
FROM phpfox_rewrite AS r
/* OO Query */
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.0005910
| Memory Before: 2.5 Mb
| Memory After: 2.51 Mb
| Memory Used: 3.86 kb
| Rows: 1
| Slave: No
SELECT s.session_hash, s.id_hash, s.captcha_hash, s.user_id
FROM phpfox_log_session AS s
WHERE s.session_hash = 'e090dd1291195175ce4e1602db4a7227' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
FROM phpfox_log_session AS s
WHERE s.session_hash = 'e090dd1291195175ce4e1602db4a7227' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ref | session_hash,log_session | session_hash | 32 | const | 1 | Using index condition; Using where |
0.0004420
| Memory Before: 2.51 Mb
| Memory After: 2.51 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_log_session SET last_activity = '1775647125', user_id = '0', location = '/mobile/profile-2659/fevent/when_upcoming/show_18/sort_latest', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.132', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = 'e090dd1291195175ce4e1602db4a7227'
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_log_session | ref | session_hash,log_session | session_hash | 32 | const | 1 | Using index condition |
0.0002520
| Memory Before: 2.6 Mb
| Memory After: 2.64 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 */
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.0001872
| Memory Before: 4.06 Mb
| Memory After: 4.06 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 */
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.0002339
| Memory Before: 4.03 Mb
| Memory After: 4.04 Mb
| Memory Used: 5.14 kb
| Rows: 1
| Slave: No
SELECT s.style_id, s.parent_id AS style_parent_id, s.folder AS style_folder_name, t.folder AS theme_folder_name, t.parent_id AS theme_parent_id, t.total_column, s.l_width, s.c_width, s.r_width
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ref | is_default | is_default | 1 | const | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | sqlgipsol.s.theme_id | 1 |
0.0001230
| Memory Before: 4.03 Mb
| Memory After: 4.04 Mb
| Memory Used: 3.28 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.0002282
| Memory Before: 4.64 Mb
| Memory After: 4.65 Mb
| Memory Used: 6.33 kb
| Rows: 3
| Slave: No
SELECT *
FROM phpfox_language
/* OO Query */
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.0001240
| Memory Before: 4.65 Mb
| Memory After: 4.66 Mb
| Memory Used: 6.13 kb
| Rows: 1
| Slave: No
SELECT *
FROM phpfox_language
WHERE language_id = 'eu'
/* OO Query */
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.1073489
| Memory Before: 4.66 Mb
| Memory After: 5.2 Mb
| Memory Used: 559.2 kb
| Rows: 15859
| 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 */
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 | 43059 | 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.0023620
| Memory Before: 9.25 Mb
| Memory After: 9.6 Mb
| Memory Used: 366.92 kb
| Rows: 11627
| 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 */
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 | 43059 | 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.0002859
| Memory Before: 21.76 Mb
| Memory After: 21.76 Mb
| Memory Used: 3.89 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 */
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.0003211
| Memory Before: 4.72 Mb
| Memory After: 4.73 Mb
| Memory Used: 17.52 kb
| Rows: 144
| 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 */
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.0002210
| Memory Before: 4.98 Mb
| Memory After: 4.99 Mb
| Memory Used: 3.17 kb
| Rows: 0
| Slave: No
SELECT find_value
FROM phpfox_ban
WHERE type_id = 'ip'
/* OO Query */
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.0006530
| Memory Before: 4.97 Mb
| Memory After: 5 Mb
| Memory Used: 26.62 kb
| Rows: 990
| Slave: No
SELECT page_id, title_url
FROM phpfox_page
/* OO Query */
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.0002329
| Memory Before: 5.39 Mb
| Memory After: 5.4 Mb
| Memory Used: 4.21 kb
| Rows: 3
| Slave: Yes
SELECT *
FROM phpfox_seo_meta
ORDER BY time_stamp
/* OO Query */
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.0018189
| Memory Before: 5.57 Mb
| Memory After: 5.6 Mb
| Memory Used: 35.6 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 = 'profile-2659'
/* 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_name = 'profile-2659'
/* 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.0002670
| Memory Before: 6.17 Mb
| Memory After: 6.17 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 */
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.0002332
| Memory Before: 12.01 Mb
| Memory After: 12.02 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 = 2659
LIMIT 1
/* OO Query */
FROM phpfox_fevent
WHERE view_id = 0 AND item_id = 0 AND user_id = 2659
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 | user_id | 4 | const | 1 | Using where |
0.0002770
| Memory Before: 12 Mb
| Memory After: 12.01 Mb
| Memory Used: 4.13 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_user_blocked
WHERE block_user_id = 0
/* OO Query */
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.0003021
| Memory Before: 11.39 Mb
| Memory After: 11.39 Mb
| Memory Used: 3.4 kb
| Rows: 0
| Slave: Yes
SELECT category_id,name
FROM phpfox_event_category
WHERE name_url = 'fevent'
/* OO Query */
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.0002840
| Memory Before: 11.97 Mb
| Memory After: 11.98 Mb
| Memory Used: 4.73 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 */
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.0008221
| Memory Before: 13.05 Mb
| Memory After: 13.05 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 = 2659 AND ( m.start_time > 1775647125 )
LIMIT 1
/* OO Query */
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 = 2659 AND ( m.start_time > 1775647125 )
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 | 1 | Using where |
| 1 | SIMPLE | ft | ref | event_id | event_id | 4 | sqlgipsol.m.event_id | 1 | Using index |
0.0115519
| Memory Before: 13.25 Mb
| Memory After: 13.26 Mb
| Memory Used: 15.12 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>1775606400))) or ( v.isrepeat = -1 AND v.end_time >= '1775606400' ) )
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>1775606400))) or ( v.isrepeat = -1 AND v.end_time >= '1775606400' ) )
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 | 9007 | Using where; Using filesort | ||
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.v.user_id | 1 |
0.0003190
| Memory Before: 13.47 Mb
| Memory After: 13.47 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 */
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.0002918
| Memory Before: 13.49 Mb
| Memory After: 13.5 Mb
| Memory Used: 6.16 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 */
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.0002410
| Memory Before: 13.52 Mb
| Memory After: 13.53 Mb
| Memory Used: 9.75 kb
| Rows: 72
| 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 */
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 | 211 | 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.0005999
| Memory Before: 13.65 Mb
| Memory After: 13.66 Mb
| Memory Used: 10.24 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* 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.0003052
| Memory Before: 13.66 Mb
| Memory After: 13.67 Mb
| Memory Used: 10.24 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* 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.0003152
| Memory Before: 13.54 Mb
| Memory After: 13.55 Mb
| Memory Used: 5.15 kb
| Rows: 3
| 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 */
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 | 2 | 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.0002110
| Memory Before: 13.53 Mb
| Memory After: 13.54 Mb
| Memory Used: 5.16 kb
| Rows: 3
| 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 */
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 | 2 | 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.0001531
| Memory Before: 13.54 Mb
| Memory After: 13.55 Mb
| Memory Used: 9.8 kb
| Rows: 72
| 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 */
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 | 211 | 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.0002520
| Memory Before: 13.67 Mb
| Memory After: 13.68 Mb
| Memory Used: 10.27 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* 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.0001390
| Memory Before: 13.67 Mb
| Memory After: 13.68 Mb
| Memory Used: 10.24 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* 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.0002871
| Memory Before: 13.57 Mb
| Memory After: 13.57 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 */
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.0001860
| Memory Before: 13.54 Mb
| Memory After: 13.54 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 */
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.0001652
| Memory Before: 13.54 Mb
| Memory After: 13.55 Mb
| Memory Used: 9.78 kb
| Rows: 72
| 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 */
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 | 211 | 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.0002990
| Memory Before: 13.67 Mb
| Memory After: 13.68 Mb
| Memory Used: 10.25 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* 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.0001888
| Memory Before: 13.67 Mb
| Memory After: 13.68 Mb
| Memory Used: 10.24 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* 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.0002470
| Memory Before: 13.58 Mb
| Memory After: 13.58 Mb
| Memory Used: 4.99 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 */
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.0001321
| Memory Before: 13.55 Mb
| Memory After: 13.56 Mb
| Memory Used: 4.93 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 */
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.0001431
| Memory Before: 13.55 Mb
| Memory After: 13.56 Mb
| Memory Used: 9.79 kb
| Rows: 72
| 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 */
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 | 211 | 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.0002301
| Memory Before: 13.68 Mb
| Memory After: 13.69 Mb
| Memory Used: 10.26 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* 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.0001771
| Memory Before: 13.68 Mb
| Memory After: 13.69 Mb
| Memory Used: 10.24 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* 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.0003099
| Memory Before: 13.59 Mb
| Memory After: 13.6 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 */
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.0002458
| Memory Before: 13.57 Mb
| Memory After: 13.58 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 */
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.0001471
| Memory Before: 13.59 Mb
| Memory After: 13.6 Mb
| Memory Used: 9.79 kb
| Rows: 72
| 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 */
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 | 211 | 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.0002899
| Memory Before: 13.71 Mb
| Memory After: 13.72 Mb
| Memory Used: 10.24 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* 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.0001702
| Memory Before: 13.71 Mb
| Memory After: 13.72 Mb
| Memory Used: 10.27 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* 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.0002959
| Memory Before: 13.92 Mb
| Memory After: 13.93 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 = '3'
/* OO Query */
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.0002470
| Memory Before: 13.9 Mb
| Memory After: 13.9 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 */
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.0002909
| Memory Before: 14.42 Mb
| Memory After: 14.42 Mb
| Memory Used: 3.18 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'template.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'template.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002370
| Memory Before: 14.77 Mb
| Memory After: 14.78 Mb
| Memory Used: 3.37 kb
| Rows: 0
| Slave: No
SELECT tc.module_id, tc.file_name
FROM phpfox_theme_css AS tc
WHERE style_id = 11
/* OO Query */
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.0002320
| Memory Before: 15.28 Mb
| Memory After: 15.28 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-body.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-body.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002329
| Memory Before: 15.45 Mb
| Memory After: 15.46 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 = '14'
/* OO Query */
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.0001569
| Memory Before: 15.47 Mb
| Memory After: 15.48 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'cabecera.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'cabecera.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002420
| Memory Before: 15.61 Mb
| Memory After: 15.62 Mb
| Memory Used: 6.03 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 */
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.0001290
| Memory Before: 15.62 Mb
| Memory After: 15.62 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002182
| Memory Before: 15.64 Mb
| Memory After: 15.64 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002532
| Memory Before: 26.7 Mb
| Memory After: 26.71 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 */
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.0001609
| Memory Before: 26.71 Mb
| Memory After: 26.72 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 */
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.0001278
| Memory Before: 26.71 Mb
| Memory After: 26.72 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 */
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.0001130
| Memory Before: 26.72 Mb
| Memory After: 26.72 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0003068
| Memory Before: 26.71 Mb
| Memory After: 26.72 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 */
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.0002151
| Memory Before: 26.73 Mb
| Memory After: 26.73 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-holdername.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-holdername.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002789
| Memory Before: 26.73 Mb
| Memory After: 26.74 Mb
| Memory Used: 9.53 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 */
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.0002429
| Memory Before: 26.73 Mb
| Memory After: 26.74 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 */
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.0002849
| Memory Before: 27.07 Mb
| Memory After: 27.09 Mb
| Memory Used: 19.27 kb
| Rows: 88
| 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 = 2659)
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 */
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 = 2659)
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 | 83 | 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.0001590
| Memory Before: 27.36 Mb
| Memory After: 27.39 Mb
| Memory Used: 27.21 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 2659
/* OO Query */
FROM phpfox_user_custom
WHERE user_id = 2659
/* 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.0001490
| Memory Before: 27.36 Mb
| Memory After: 27.37 Mb
| Memory Used: 5.95 kb
| Rows: 72
| Slave: Yes
SELECT *
FROM phpfox_custom_option
WHERE field_id IN(93,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 */
FROM phpfox_custom_option
WHERE field_id IN(93,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 | 83 | Using where; Using filesort |
0.0002189
| Memory Before: 27.22 Mb
| Memory After: 27.22 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/header.html.php'
/* OO Query */
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.0002508
| Memory Before: 27.68 Mb
| Memory After: 27.69 Mb
| Memory Used: 3.18 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 */
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.0002220
| Memory Before: 27.79 Mb
| Memory After: 27.79 Mb
| Memory Used: 3.75 kb
| Rows: 3
| Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 2659
/* OO Query */
FROM phpfox_user_privacy
WHERE user_id = 2659
/* 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 | 4 | const | 7 |
0.0002270
| Memory Before: 27.92 Mb
| Memory After: 27.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 = '12'
/* OO Query */
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.0001359
| Memory Before: 27.66 Mb
| Memory After: 27.66 Mb
| Memory Used: 3.17 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'search.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'search.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002151
| Memory Before: 27.69 Mb
| Memory After: 27.69 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-contentclass.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-contentclass.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002720
| Memory Before: 27.69 Mb
| Memory After: 27.7 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'error.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'error.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0001860
| Memory Before: 27.7 Mb
| Memory After: 27.71 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 */
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.0001221
| Memory Before: 27.7 Mb
| Memory After: 27.7 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 */
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.0002370
| Memory Before: 27.7 Mb
| Memory After: 27.71 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 = '4'
/* OO Query */
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.0011270
| Memory Before: 27.72 Mb
| Memory After: 27.74 Mb
| Memory Used: 16.87 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 >= '1775606400'
/* OO Query */
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 >= '1775606400'
/* 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.0001450
| Memory Before: 27.73 Mb
| Memory After: 27.74 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 = '8'
/* OO Query */
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.0001431
| Memory Before: 27.74 Mb
| Memory After: 27.75 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menufooter.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menufooter.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
Array
(
[session] => e090dd1291195175ce4e1602db4a7227
[redirect] => /mobile/profile-2659/fevent/when_upcoming/show_18/sort_latest
[socialintegration_pageId] => 11
)
Array
(
[coreb6aavisit] => 1775647113
)
