Bideoa igo edo gorde
Bideo Aipagarriak
Bidezko merkataritza aukeratu
by GipuzkoaSolidarioa
3,359 Bistaratzeak
3,359 Bistaratzeak
Elige comercio justo
by GipuzkoaSolidarioa
2,296 Bistaratzeak
2,296 Bistaratzeak
Pausoka elkartea: Therasuit
by Pausoka Elkartea
3,227 Bistaratzeak
3,227 Bistaratzeak
phpFox Developers Debug
Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula
Total Time:
1.0099881
PHP General Time:
0.8419084
GZIP:
disabled
Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.1680797
SQL Queries:
88
SQL Memory Usage:
1.4 Mb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
22.93 Mb
Total Memory Usage (Including Debug):
23.13 Mb
Memory Limit:
512 Mb (1024M)
Load Balancing Enabled:
No
Requests From:
192.168.100.222
Server Time Stamp:
December 24, 2025, 12:14 pm
PHP Version:
5.6.40
PHP Sapi:
fpm-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux
Cache:
file
SQL Queries
0.0001740
| Memory Before: 1.41 Mb
| Memory After: 1.41 Mb
| Memory Used: 4.77 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.0008521
| Memory Before: 2.62 Mb
| Memory After: 2.63 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 = '2bd6690d322ce0420a20ad9685f4fd4f' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
FROM phpfox_log_session AS s
WHERE s.session_hash = '2bd6690d322ce0420a20ad9685f4fd4f' 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.0006120
| Memory Before: 2.63 Mb
| Memory After: 2.63 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_log_session SET last_activity = '1766578457', user_id = '0', location = '/mobile/video/when_all-time/page_63', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.164', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = '2bd6690d322ce0420a20ad9685f4fd4f'
| 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.0003839
| Memory Before: 2.72 Mb
| Memory After: 2.76 Mb
| Memory Used: 38.05 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.0002360
| Memory Before: 4.17 Mb
| Memory After: 4.17 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.0003290
| Memory Before: 4.14 Mb
| Memory After: 4.15 Mb
| Memory Used: 5.04 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.0001740
| Memory Before: 4.15 Mb
| Memory After: 4.15 Mb
| Memory Used: 3.21 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.76 Mb
| Memory After: 4.76 Mb
| Memory Used: 6.12 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.1296649
| Memory Before: 4.76 Mb
| Memory After: 5.31 Mb
| Memory Used: 557.34 kb
| Rows: 15800
| 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 | 42877 | 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.0039630
| Memory Before: 9.33 Mb
| Memory After: 9.69 Mb
| Memory Used: 364.92 kb
| Rows: 11563
| 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 | 42877 | 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.0002949
| Memory Before: 21.82 Mb
| Memory After: 21.83 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.0003481
| Memory Before: 4.83 Mb
| Memory After: 4.85 Mb
| Memory Used: 17.43 kb
| Rows: 143
| Slave: No
SELECT b.block_id, b.type_id, b.ordering, b.m_connection, b.component, b.location, b.disallow_access, b.can_move, m.module_id, bs.source_parsed
FROM phpfox_block AS b
LEFT JOIN phpfox_block_source AS bs
ON(bs.block_id = b.block_id)
JOIN phpfox_module AS m
ON(b.module_id = m.module_id AND m.is_active = 1)
JOIN phpfox_product AS p
ON(b.product_id = p.product_id AND p.is_active = 1)
WHERE b.is_active = 1
ORDER BY b.ordering ASC
/* OO Query */
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.0002098
| Memory Before: 6.25 Mb
| Memory After: 6.25 Mb
| Memory Used: 4.74 kb
| Rows: 0
| Slave: Yes
SELECT i.*, io.phrase_var as option_phrase_var
FROM phpfox_input_field AS i
LEFT JOIN phpfox_input_option AS io
ON(io.field_id = i.field_id)
WHERE module_id = "video"
/* 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 = "video"
/* 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.0001640
| Memory Before: 6.67 Mb
| Memory After: 6.67 Mb
| Memory Used: 4.66 kb
| Rows: 0
| Slave: Yes
SELECT *, COUNT(item_id) AS total
FROM phpfox_tag
WHERE category_id = 'video' AND tag_url = ''
GROUP BY tag_id
/* OO Query */
FROM phpfox_tag
WHERE category_id = 'video' AND tag_url = ''
GROUP BY tag_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_tag | ref | category_id,tag_url,user_search,user_search_general,category_id_2 | tag_url | 257 | const | 1 | Using index condition; Using where; Using temporary; Using filesort |
0.0001290
| Memory Before: 7 Mb
| Memory After: 7.01 Mb
| Memory Used: 3.15 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_video AS m
WHERE m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0)
LIMIT 1
/* OO Query */
FROM phpfox_video AS m
WHERE m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0)
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | in_process,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6 | in_process_2 | 7 | const,const,const,const | 1008 | Using index |
0.0147450
| Memory Before: 7.01 Mb
| Memory After: 7.02 Mb
| Memory Used: 16.45 kb
| Rows: 12
| Slave: Yes
SELECT m.*, 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_video AS m
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
WHERE m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0)
ORDER BY m.time_stamp DESC
LIMIT 12 OFF SET 744
/* OO Query */
FROM phpfox_video AS m
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
WHERE m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0)
ORDER BY m.time_stamp DESC
LIMIT 12 OFF SET 744
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | range | in_process,user_id,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6 | in_process_3 | 6 | 994 | Using index condition; Using where; Using filesort | |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.m.user_id | 1 |
0.0007820
| Memory Before: 7.33 Mb
| Memory After: 7.34 Mb
| Memory Used: 13.38 kb
| Rows: 3
| Slave: Yes
SELECT v.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_video AS v
JOIN phpfox_user AS u
ON(u.user_id = v.user_id)
WHERE v.is_featured = 1
/* OO Query */
FROM phpfox_video AS v
JOIN phpfox_user AS u
ON(u.user_id = v.user_id)
WHERE v.is_featured = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | v | ALL | user_id | MISSING KEY | 1014 | Using where | ||
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.v.user_id | 1 |
0.0001981
| Memory Before: 7.74 Mb
| Memory After: 7.74 Mb
| Memory Used: 3.7 kb
| Rows: 4
| Slave: No
SELECT r.feed_id, r.title_var, r.php_group_code
FROM phpfox_rss AS r
JOIN phpfox_module AS m
ON(m.module_id = r.module_id AND m.is_active = 1)
JOIN phpfox_product AS p
ON(p.product_id = r.product_id AND p.is_active = 1)
WHERE r.is_active = 1 AND r.is_site_wide = 1
ORDER BY r.ordering ASC
/* OO Query */
FROM phpfox_rss AS r
JOIN phpfox_module AS m
ON(m.module_id = r.module_id AND m.is_active = 1)
JOIN phpfox_product AS p
ON(p.product_id = r.product_id AND p.is_active = 1)
WHERE r.is_active = 1 AND r.is_site_wide = 1
ORDER BY r.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | r | ALL | is_active | MISSING KEY | 8 | Using where; Using filesort | ||
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.r.product_id,const | 3 | Using index |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.r.module_id,const | 8 | Using index |
0.0001390
| Memory Before: 7.74 Mb
| Memory After: 7.75 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.0001211
| Memory Before: 7.78 Mb
| Memory After: 7.78 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.0001621
| Memory Before: 7.8 Mb
| Memory After: 7.81 Mb
| Memory Used: 9.73 kb
| Rows: 71
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | 209 | Using where; Using filesort | ||
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0001719
| Memory Before: 7.82 Mb
| Memory After: 7.83 Mb
| Memory Used: 5.08 kb
| Rows: 2
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'main_right' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'main_right' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000970
| Memory Before: 7.81 Mb
| Memory After: 7.82 Mb
| Memory Used: 5.09 kb
| Rows: 2
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'main_right' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'main_right' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0001080
| Memory Before: 7.82 Mb
| Memory After: 7.83 Mb
| Memory Used: 9.68 kb
| Rows: 71
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | 209 | Using where; Using filesort | ||
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000992
| Memory Before: 7.85 Mb
| Memory After: 7.85 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.0000861
| Memory Before: 7.82 Mb
| Memory After: 7.82 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.0001090
| Memory Before: 7.82 Mb
| Memory After: 7.83 Mb
| Memory Used: 9.67 kb
| Rows: 71
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | 209 | Using where; Using filesort | ||
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0001020
| Memory Before: 7.85 Mb
| Memory After: 7.86 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 = 'video.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 = 'video.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 | index_merge | product_id,m_connection,parent_id | parent_id,m_connection | 3,79 | 9 | Using intersect(parent_id,m_connection); 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.0000880
| Memory Before: 7.83 Mb
| Memory After: 7.83 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 = 'video' 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 = 'video' 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.0001051
| Memory Before: 7.83 Mb
| Memory After: 7.84 Mb
| Memory Used: 9.68 kb
| Rows: 71
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | 209 | Using where; Using filesort | ||
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0001090
| Memory Before: 7.86 Mb
| Memory After: 7.87 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.0000980
| Memory Before: 7.85 Mb
| Memory After: 7.85 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.0001171
| Memory Before: 7.86 Mb
| Memory After: 7.87 Mb
| Memory Used: 9.67 kb
| Rows: 71
| Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | 209 | Using where; Using filesort | ||
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0001140
| Memory Before: 8.26 Mb
| Memory After: 8.26 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 = '1'
/* 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 = '1'
/* 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.0001080
| Memory Before: 8.23 Mb
| Memory After: 8.24 Mb
| Memory Used: 9.52 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
LEFT JOIN phpfox_ad_country AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '3'
/* OO Query */
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.0000970
| Memory Before: 8.23 Mb
| Memory After: 8.24 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.0001800
| Memory Before: 8.76 Mb
| Memory After: 8.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.0002260
| Memory Before: 9.11 Mb
| Memory After: 9.12 Mb
| Memory Used: 3.34 kb
| Rows: 0
| Slave: No
SELECT tc.module_id, tc.file_name
FROM phpfox_theme_css AS tc
WHERE style_id = 11
/* OO Query */
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.0001729
| Memory Before: 10.14 Mb
| Memory After: 10.14 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = '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.0002320
| Memory Before: 10.32 Mb
| Memory After: 10.32 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.0001318
| Memory Before: 10.34 Mb
| Memory After: 10.34 Mb
| Memory Used: 3.17 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = '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.0001552
| Memory Before: 10.48 Mb
| Memory After: 10.48 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.0001261
| Memory Before: 10.48 Mb
| Memory After: 10.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 = '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.0002019
| Memory Before: 10.5 Mb
| Memory After: 10.51 Mb
| Memory Used: 3.17 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.0002611
| Memory Before: 21.66 Mb
| Memory After: 21.67 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 = '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.0001261
| Memory Before: 21.67 Mb
| Memory After: 21.68 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 = '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.0001309
| Memory Before: 21.67 Mb
| Memory After: 21.68 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 = '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.0001049
| Memory Before: 21.68 Mb
| Memory After: 21.68 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.0002389
| Memory Before: 21.67 Mb
| Memory After: 21.68 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 = '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.0001290
| Memory Before: 21.69 Mb
| Memory After: 21.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-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.0001419
| Memory Before: 21.69 Mb
| Memory After: 21.7 Mb
| Memory Used: 9.51 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
LEFT JOIN phpfox_ad_country AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '13'
/* OO Query */
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.0001261
| Memory Before: 21.69 Mb
| Memory After: 21.7 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.0001080
| Memory Before: 21.7 Mb
| Memory After: 21.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 = 'breadcrumb.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'breadcrumb.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0001030
| Memory Before: 21.73 Mb
| Memory After: 21.73 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-breadcrumblist.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-breadcrumblist.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.0001042
| Memory Before: 21.74 Mb
| Memory After: 21.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 = 'block' AND module_id = 'core' AND name = 'template-breadcrumbmenu.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-breadcrumbmenu.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.0001268
| Memory Before: 21.89 Mb
| Memory After: 21.9 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.0001211
| Memory Before: 21.91 Mb
| Memory After: 21.91 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-menusub.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-menusub.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002420
| Memory Before: 22.02 Mb
| Memory After: 22.03 Mb
| Memory Used: 3.35 kb
| Rows: 0
| Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_video_category AS mc
WHERE mc.parent_id = 0 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
FROM phpfox_video_category AS mc
WHERE mc.parent_id = 0 AND mc.is_active = 1
ORDER BY mc.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.0001180
| Memory Before: 22.02 Mb
| Memory After: 22.02 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'search.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'search.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002141
| Memory Before: 22.05 Mb
| Memory After: 22.06 Mb
| Memory Used: 3.17 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = '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.0001149
| Memory Before: 22.06 Mb
| Memory After: 22.06 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0002189
| Memory Before: 22.06 Mb
| Memory After: 22.07 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.0001099
| Memory Before: 22.07 Mb
| Memory After: 22.07 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 = 'video' AND name = 'index.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'controller' AND module_id = 'video' AND name = 'index.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001111
| Memory Before: 22.09 Mb
| Memory After: 22.09 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 = 'video' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002129
| Memory Before: 22.1 Mb
| Memory After: 22.1 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 = 'video' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001912
| Memory Before: 22.1 Mb
| Memory After: 22.1 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 = 'video' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002129
| Memory Before: 22.1 Mb
| Memory After: 22.11 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002160
| Memory Before: 22.11 Mb
| Memory After: 22.11 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002122
| Memory Before: 22.11 Mb
| Memory After: 22.11 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001721
| Memory Before: 22.11 Mb
| Memory After: 22.12 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 = 'video' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002139
| Memory Before: 22.12 Mb
| Memory After: 22.12 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 = 'video' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002120
| Memory Before: 22.12 Mb
| Memory After: 22.13 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002129
| Memory Before: 22.12 Mb
| Memory After: 22.13 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001738
| Memory Before: 22.14 Mb
| Memory After: 22.15 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002191
| Memory Before: 22.15 Mb
| Memory After: 22.15 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002110
| Memory Before: 22.15 Mb
| Memory After: 22.16 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'pager.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'pager.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002542
| Memory Before: 22.14 Mb
| Memory After: 22.15 Mb
| Memory Used: 9.52 kb
| Rows: 0
| Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
LEFT JOIN phpfox_ad_country AS ac
ON(ac.ad_id = a.ad_id)
WHERE a.is_active = 1 AND a.location = '4'
/* OO Query */
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.0016670
| Memory Before: 22.16 Mb
| Memory After: 22.18 Mb
| Memory Used: 16.48 kb
| Rows: 0
| Slave: No
SELECT s.*, v.*, ve.embed_code, 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_video AS v
JOIN phpfox_user AS u
ON(u.user_id = v.user_id)
JOIN phpfox_ad_sponsor AS s
ON(s.item_id = v.video_id)
LEFT JOIN phpfox_video_embed AS ve
ON(ve.video_id = v.video_id)
WHERE v.in_process = 0 AND v.view_id = 0 AND v.is_sponsor = 1 AND s.module_id = "video"
/* OO Query */
FROM phpfox_video AS v
JOIN phpfox_user AS u
ON(u.user_id = v.user_id)
JOIN phpfox_ad_sponsor AS s
ON(s.item_id = v.video_id)
LEFT JOIN phpfox_video_embed AS ve
ON(ve.video_id = v.video_id)
WHERE v.in_process = 0 AND v.view_id = 0 AND v.is_sponsor = 1 AND s.module_id = "video"
/* 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 | v | eq_ref | PRIMARY,in_process,user_id,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6 | PRIMARY | 4 | sqlgipsol.s.item_id | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.v.user_id | 1 | |
| 1 | SIMPLE | ve | eq_ref | video_id | video_id | 4 | sqlgipsol.s.item_id | 1 |
0.0001142
| Memory Before: 22.19 Mb
| Memory After: 22.19 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0001011
| Memory Before: 22.19 Mb
| Memory After: 22.2 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 = 'video' AND name = 'featured.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'featured.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.0000970
| Memory Before: 22.2 Mb
| Memory After: 22.2 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 = 'video' AND name = 'featured.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'featured.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: 22.25 Mb
| Memory After: 22.26 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002389
| Memory Before: 22.26 Mb
| Memory After: 22.26 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002408
| Memory Before: 22.26 Mb
| Memory After: 22.26 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002549
| Memory Before: 22.46 Mb
| Memory After: 22.47 Mb
| Memory Used: 9.37 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "video|featured"
/* OO Query */
FROM phpfox_ad
WHERE location = "video|featured"
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_ad | ALL | MISSING KEY | 12 | Using where |
0.0022609
| Memory Before: 22.83 Mb
| Memory After: 22.83 Mb
| Memory Used: 3.77 kb
| Rows: 0
| Slave: Yes
SELECT category_id, tag_text AS tag, tag_url, COUNT(item_id) AS total
FROM phpfox_tag
WHERE category_id = 'video' AND added > 1765973657
GROUP BY tag_text, tag_url
HAVING total > 1
ORDER BY total DESC
LIMIT 10
/* OO Query */
FROM phpfox_tag
WHERE category_id = 'video' AND added > 1765973657
GROUP BY tag_text, tag_url
HAVING total > 1
ORDER BY total DESC
LIMIT 10
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_tag | ref | category_id,user_search,user_search_general,category_id_2 | category_id_2 | 77 | const | 86 | Using index condition; Using where; Using temporary; Using filesort |
0.0001402
| Memory Before: 22.82 Mb
| Memory After: 22.83 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.0001121
| Memory Before: 22.85 Mb
| Memory After: 22.85 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-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] => 2bd6690d322ce0420a20ad9685f4fd4f
[redirect] => /mobile/video/when_all-time/page_63
)
Array
(
[coreb6aavisit] => 1766578456
)
