Gertaera berria sortu
Ez da gertaerarik topatu.
Aztarna Solidarioa
phpFox Developers Debug
Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula
Total Time:
0.4631250
PHP General Time:
0.2911376
GZIP:
disabled
Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.1719874
SQL Queries:
42
SQL Memory Usage:
942.65 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
25.16 Mb
Total Memory Usage (Including Debug):
25.27 Mb
Memory Limit:
512 Mb (1024M)
Load Balancing Enabled:
No
Requests From:
192.168.100.222
Server Time Stamp:
April 8, 2026, 11:47 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.0001009
| Memory Before: 1.41 Mb
| Memory After: 1.41 Mb
| Memory Used: 4.78 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.0005760
| Memory Before: 2.42 Mb
| Memory After: 2.43 Mb
| Memory Used: 3.87 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 = '9b4075d51fd5a53f0177f3e1616c96a3' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
FROM phpfox_log_session AS s
WHERE s.session_hash = '9b4075d51fd5a53f0177f3e1616c96a3' 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.0004339
| Memory Before: 2.43 Mb
| Memory After: 2.43 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_log_session SET last_activity = '1775648846', user_id = '0', location = '/profile-2678/fevent/sort_most-talked/when_this-week/show_10', 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 = '9b4075d51fd5a53f0177f3e1616c96a3'
| 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.0002220
| Memory Before: 3.75 Mb
| Memory After: 3.76 Mb
| Memory Used: 4.97 kb
| Rows: 1
| Slave: No
SELECT s.style_id, s.parent_id AS style_parent_id, s.folder AS style_folder_name, t.folder AS theme_folder_name, t.parent_id AS theme_parent_id, t.total_column, s.l_width, s.c_width, s.r_width
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ref | is_default | is_default | 1 | const | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | sqlgipsol.s.theme_id | 1 |
0.0000961
| Memory Before: 3.75 Mb
| Memory After: 3.76 Mb
| Memory Used: 3.18 kb
| Rows: 1
| Slave: No
SELECT folder AS parent_style_folder
FROM phpfox_theme_style
WHERE style_id = 1
/* OO Query */
FROM phpfox_theme_style
WHERE style_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_style | const | style_id_2,style_id | style_id_2 | 2 | const | 1 |
0.0016630
| Memory Before: 5.16 Mb
| Memory After: 5.2 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 = 'profile-2678'
/* 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-2678'
/* 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.0005748
| Memory Before: 6.56 Mb
| Memory After: 6.56 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 = 2678
LIMIT 1
/* OO Query */
FROM phpfox_fevent
WHERE view_id = 0 AND item_id = 0 AND user_id = 2678
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.0002129
| Memory Before: 8.55 Mb
| Memory After: 8.55 Mb
| Memory Used: 3.39 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.0290701
| Memory Before: 9.31 Mb
| Memory After: 9.34 Mb
| Memory Used: 27.37 kb
| Rows: 698
| Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'core' AND p.module_id = m.module_id AND m.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'core' AND p.module_id = m.module_id AND m.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 | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | ref|filter | language_id,module_id,setting_list | module_id|language_id | 78|14 | const | 2538 (30%) | Using index condition; Using where; Using rowid filter |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
0.0004599
| Memory Before: 10.39 Mb
| Memory After: 10.39 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 = 2678 AND ( m.start_time >= 1775426400 AND m.start_time <= 1776031199 ) AND ( m.start_time >= 1775426400 AND m.start_time <= 1776031199 )
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 = 2678 AND ( m.start_time >= 1775426400 AND m.start_time <= 1776031199 ) AND ( m.start_time >= 1775426400 AND m.start_time <= 1776031199 )
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.0001118
| Memory Before: 10.47 Mb
| Memory After: 10.48 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>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.0027649
| Memory Before: 10.79 Mb
| Memory After: 10.8 Mb
| Memory Used: 6.7 kb
| Rows: 143
| Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'smartslider' AND p.module_id = m.module_id AND m.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'smartslider' AND p.module_id = m.module_id AND m.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 | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | ref | language_id,module_id,setting_list | module_id | 78 | const | 337 | Using index condition; Using where |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
0.0001459
| Memory Before: 11.76 Mb
| Memory After: 11.76 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = '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.0023532
| Memory Before: 12.35 Mb
| Memory After: 12.35 Mb
| Memory Used: 4.77 kb
| Rows: 60
| Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'emoticon' AND p.module_id = m.module_id AND m.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'emoticon' AND p.module_id = m.module_id AND m.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 | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | ref | language_id,module_id,setting_list | module_id | 78 | const | 171 | Using index condition; Using where |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
0.0027618
| Memory Before: 12.36 Mb
| Memory After: 12.37 Mb
| Memory Used: 5.2 kb
| Rows: 79
| Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'attachment' AND p.module_id = m.module_id AND m.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'attachment' AND p.module_id = m.module_id AND m.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 | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | ref | language_id,module_id,setting_list | module_id | 78 | const | 174 | Using index condition; Using where |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
0.0037429
| Memory Before: 12.38 Mb
| Memory After: 12.39 Mb
| Memory Used: 6.56 kb
| Rows: 137
| Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'language' AND p.module_id = m.module_id AND m.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'language' AND p.module_id = m.module_id AND m.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 | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | ref | language_id,module_id,setting_list | module_id | 78 | const | 259 | Using index condition; Using where |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
0.0092349
| Memory Before: 12.42 Mb
| Memory After: 12.43 Mb
| Memory Used: 13.27 kb
| Rows: 423
| Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'higipsol' AND p.module_id = m.module_id AND m.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'higipsol' AND p.module_id = m.module_id AND m.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 | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | ref | language_id,module_id,setting_list | module_id | 78 | const | 1266 | Using index condition; Using where |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
0.0001099
| Memory Before: 12.65 Mb
| Memory After: 12.65 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.0001409
| Memory Before: 12.84 Mb
| Memory After: 12.84 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0004020
| Memory Before: 12.96 Mb
| Memory After: 12.97 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.0000899
| Memory Before: 12.96 Mb
| Memory After: 12.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 = '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.0000739
| Memory Before: 12.98 Mb
| Memory After: 12.98 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0091701
| Memory Before: 13.04 Mb
| Memory After: 13.2 Mb
| Memory Used: 168.83 kb
| Rows: 237
| Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'profile' AND p.module_id = m.module_id AND m.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'profile' AND p.module_id = m.module_id AND m.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 | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | ref | language_id,module_id,setting_list | module_id | 78 | const | 1221 | Using index condition; Using where |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
0.0133979
| Memory Before: 13.13 Mb
| Memory After: 13.28 Mb
| Memory Used: 151.16 kb
| Rows: 849
| Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'user' AND p.module_id = m.module_id AND m.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'user' AND p.module_id = m.module_id AND m.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 | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | ref|filter | language_id,module_id,setting_list | module_id|language_id | 78|14 | const | 2812 (30%) | Using index condition; Using where; Using rowid filter |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
0.0626931
| Memory Before: 13.85 Mb
| Memory After: 14.05 Mb
| Memory Used: 213.6 kb
| Rows: 3513
| Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'page' AND p.module_id = m.module_id AND m.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'page' AND p.module_id = m.module_id AND m.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 | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | ref|filter | language_id,module_id,setting_list | module_id|language_id | 78|14 | const | 2878 (30%) | Using index condition; Using where; Using rowid filter |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
0.0061369
| Memory Before: 14.66 Mb
| Memory After: 14.79 Mb
| Memory Used: 136.23 kb
| Rows: 210
| Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'theme' AND p.module_id = m.module_id AND m.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'theme' AND p.module_id = m.module_id AND m.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 | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | ref | language_id,module_id,setting_list | module_id | 78 | const | 492 | Using index condition; Using where |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
0.0001879
| Memory Before: 24.24 Mb
| Memory After: 24.24 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 = '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.0001750
| Memory Before: 24.26 Mb
| Memory After: 24.26 Mb
| Memory Used: 3.23 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.0017641
| Memory Before: 24.59 Mb
| Memory After: 24.61 Mb
| Memory Used: 17.45 kb
| Rows: 75
| 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 = 2678)
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 = 2678)
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 | cmv | ref | user_id | user_id | 6 | const,sqlgipsol.cf.field_id | 1 | |
| 1 | SIMPLE | cg | eq_ref | PRIMARY | PRIMARY | 2 | sqlgipsol.cf.group_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.0005009
| Memory Before: 24.84 Mb
| Memory After: 24.87 Mb
| Memory Used: 27.3 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 2678
/* OO Query */
FROM phpfox_user_custom
WHERE user_id = 2678
/* 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.0001352
| Memory Before: 24.87 Mb
| Memory After: 24.88 Mb
| Memory Used: 5.91 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.0124099
| Memory Before: 24.95 Mb
| Memory After: 24.97 Mb
| Memory Used: 12.42 kb
| Rows: 387
| Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'custom' AND p.module_id = m.module_id AND m.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'custom' AND p.module_id = m.module_id AND m.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 | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | ref | language_id,module_id,setting_list | module_id | 78 | const | 1665 | Using index condition; Using where |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
0.0001659
| Memory Before: 24.73 Mb
| Memory After: 24.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 = '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.0001760
| Memory Before: 25.2 Mb
| Memory After: 25.21 Mb
| Memory Used: 3.22 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.0003779
| Memory Before: 25.14 Mb
| Memory After: 25.14 Mb
| Memory Used: 3.73 kb
| Rows: 3
| Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 2678
/* OO Query */
FROM phpfox_user_privacy
WHERE user_id = 2678
/* 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.0001490
| Memory Before: 25.01 Mb
| Memory After: 25.01 Mb
| Memory Used: 3.2 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.0001440
| Memory Before: 25.02 Mb
| Memory After: 25.03 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.0001359
| Memory Before: 25.03 Mb
| Memory After: 25.03 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.0000901
| Memory Before: 25.03 Mb
| Memory After: 25.03 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.0001650
| Memory Before: 25.07 Mb
| Memory After: 25.08 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 |
0.0020239
| Memory Before: 25.09 Mb
| Memory After: 25.09 Mb
| Memory Used: 4.41 kb
| Rows: 45
| Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'contact' AND p.module_id = m.module_id AND m.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'contact' AND p.module_id = m.module_id AND m.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 | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | ref | language_id,module_id,setting_list | module_id | 78 | const | 195 | Using index condition; Using where |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
0.0066471
| Memory Before: 25.1 Mb
| Memory After: 25.11 Mb
| Memory Used: 8.84 kb
| Rows: 234
| Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'mail' AND p.module_id = m.module_id AND m.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
FROM phpfox_language_phrase AS p
JOIN phpfox_product AS product
ON(product.product_id = p.product_id AND product.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = 'mail' AND p.module_id = m.module_id AND m.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 | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | p | ref | language_id,module_id,setting_list | module_id | 78 | const | 481 | Using index condition; Using where |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
Array
(
[session] => 9b4075d51fd5a53f0177f3e1616c96a3
[redirect] => /profile-2678/fevent/sort_most-talked/when_this-week/show_10
[socialintegration_pageId] => 27
)
Array
(
[coreb6aavisit] => 1775648826
)
