Dokumentu berria igo
Jardun arloko bilaketa
Nabarmendutako dokumentuak
Nork: GipuzkoaSolidarioa
2 Ikustald. | 0 Atsegin dut
Nork: GipuzkoaSolidarioa
1 Ikustald. | 0 Atsegin dut
Nork: GipuzkoaSolidarioa
2 Ikustald. | 0 Atsegin dut
Estatistikak
- Ikustald.
1405 - Atsegin dut
2 - Dokumentuak
723
Gehien ikusitako dokumentuak
Nork: GipuzkoaSolidarioa
26 Ikustald. | 0 Atsegin dut
Nork: GipuzkoaSolidarioa
26 Ikustald. | 0 Atsegin dut
Nork: GipuzkoaSolidarioa
24 Ikustald. | 0 Atsegin dut
Iruzkin gehien duten dokumentuak
Nork: AMIGOSOLIDARIOS
1 Iruzkin
Nork: FUNDACION AYUDA SOLI...
1 Iruzkin
Nork: FUNDACION AYUDA SOLI...
1 Iruzkin
phpFox Developers Debug
Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula
Total Time:
0.3320558
PHP General Time:
0.2844771
GZIP:
disabled
Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.0475787
SQL Queries:
85
SQL Memory Usage:
413.17 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
22.31 Mb
Total Memory Usage (Including Debug):
22.61 Mb
Memory Limit:
512 Mb (1024M)
Load Balancing Enabled:
No
Requests From:
192.168.100.222
Server Time Stamp:
December 22, 2025, 4:50 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.0006111
| Memory Before: 2.29 Mb
| Memory After: 2.29 Mb
| Memory Used: 1.35 kb
| Rows: -
| Slave: No
INSERT INTO phpfox_log_session (session_hash, id_hash, user_id, last_activity, location, is_forum, forum_id, im_hide, ip_address, user_agent) VALUES ('f7b26da50c53a530629fd333b43ec7b8', '0d574f7196f9f96e319d05681455513d', '0', '1766422202', '/document/show_12/when_all-time/sort_most-talked/page_48', '0', '0', '0', '216.73.216.164', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.')
0.0002670
| Memory Before: 3.61 Mb
| Memory After: 3.62 Mb
| Memory Used: 5.03 kb
| Rows: 1
| Slave: No
SELECT s.style_id, s.parent_id AS style_parent_id, s.folder AS style_folder_name, t.folder AS theme_folder_name, t.parent_id AS theme_parent_id, t.total_column, s.l_width, s.c_width, s.r_width
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ref | is_default | is_default | 1 | const | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | sqlgipsol.s.theme_id | 1 |
0.0001101
| Memory Before: 3.62 Mb
| Memory After: 3.62 Mb
| Memory Used: 3.2 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.0002632
| Memory Before: 5.54 Mb
| Memory After: 5.54 Mb
| Memory Used: 4.73 kb
| Rows: 0
| Slave: Yes
SELECT i.*, io.phrase_var as option_phrase_var
FROM phpfox_input_field AS i
LEFT JOIN phpfox_input_option AS io
ON(io.field_id = i.field_id)
WHERE module_id = "document"
/* 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 = "document"
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0002470
| Memory Before: 6.29 Mb
| Memory After: 6.3 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_document AS m
WHERE m.is_approved = 1 AND 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_document AS m
WHERE m.is_approved = 1 AND 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,in_process_2,in_process_3,in_process_4,in_process_5 | in_process | 1 | const | 681 | Using where |
0.0220799
| Memory Before: 6.3 Mb
| Memory After: 6.35 Mb
| Memory Used: 52.91 kb
| Rows: 12
| Slave: Yes
SELECT dt.*, 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_document AS m
JOIN phpfox_document_text AS dt
ON(dt.document_id = m.document_id)
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
WHERE m.is_approved = 1 AND m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0)
ORDER BY m.total_comment DESC
LIMIT 12 OFF SET 564
/* OO Query */
FROM phpfox_document AS m
JOIN phpfox_document_text AS dt
ON(dt.document_id = m.document_id)
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
WHERE m.is_approved = 1 AND m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0)
ORDER BY m.total_comment DESC
LIMIT 12 OFF SET 564
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | dt | ALL | MISSING KEY | 729 | Using temporary; Using filesort | |||
| 1 | SIMPLE | m | eq_ref | PRIMARY,user_id,in_process,document_id_2,in_process_2,in_process_3,in_process_4,in_process_5,document_id,document_id_3,view_id_4 | PRIMARY | 4 | sqlgipsol.dt.document_id | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.m.user_id | 1 |
0.0005219
| Memory Before: 6.88 Mb
| Memory After: 6.89 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 781
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 781
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0003681
| Memory Before: 7.08 Mb
| Memory After: 7.08 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 782
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 782
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002570
| Memory Before: 7.09 Mb
| Memory After: 7.09 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 795
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 795
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0000901
| Memory Before: 7.1 Mb
| Memory After: 7.1 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 796
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 796
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002580
| Memory Before: 7.11 Mb
| Memory After: 7.11 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 797
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 797
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002499
| Memory Before: 7.12 Mb
| Memory After: 7.13 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 785
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 785
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002580
| Memory Before: 7.13 Mb
| Memory After: 7.14 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 787
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 787
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002379
| Memory Before: 7.14 Mb
| Memory After: 7.15 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 798
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 798
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002391
| Memory Before: 7.16 Mb
| Memory After: 7.16 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 799
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 799
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002420
| Memory Before: 7.17 Mb
| Memory After: 7.17 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 790
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 790
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0000870
| Memory Before: 7.18 Mb
| Memory After: 7.18 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 791
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 791
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0002739
| Memory Before: 7.19 Mb
| Memory After: 7.19 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 800
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 800
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0001879
| Memory Before: 7.55 Mb
| Memory After: 7.56 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 = 'document.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 = 'document.index' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000861
| Memory Before: 7.56 Mb
| Memory After: 7.56 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 = 'document' 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 = 'document' 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.56 Mb
| Memory After: 7.57 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.0001869
| Memory Before: 8.49 Mb
| Memory After: 8.49 Mb
| Memory Used: 3.16 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.0002310
| Memory Before: 9.88 Mb
| Memory After: 9.88 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.0002079
| Memory Before: 10.07 Mb
| Memory After: 10.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 = '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.0002079
| Memory Before: 10.22 Mb
| Memory After: 10.22 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0001121
| Memory Before: 10.24 Mb
| Memory After: 10.24 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.0002680
| Memory Before: 21.4 Mb
| Memory After: 21.41 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = '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.0001431
| Memory Before: 21.42 Mb
| Memory After: 21.42 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.0001991
| Memory Before: 21.42 Mb
| Memory After: 21.43 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.0001409
| Memory Before: 21.45 Mb
| Memory After: 21.46 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.0001080
| Memory Before: 21.47 Mb
| Memory After: 21.47 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.0001969
| Memory Before: 21.63 Mb
| Memory After: 21.64 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0001171
| Memory Before: 21.65 Mb
| Memory After: 21.66 Mb
| Memory Used: 3.88 kb
| Rows: 9
| Slave: No
SELECT mc.category_id, mc.name, mc.name_url
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 0 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
FROM phpfox_document_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 | mc | ALL | parent_id,is_active | MISSING KEY | 10 | Using where; Using filesort |
0.0001400
| Memory Before: 21.63 Mb
| Memory After: 21.64 Mb
| Memory Used: 3.39 kb
| Rows: 1
| Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 9 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 9 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 | mc | ref | parent_id,is_active | parent_id | 4 | const,const | 1 | Using where; Using filesort |
0.0001268
| Memory Before: 21.64 Mb
| Memory After: 21.64 Mb
| Memory Used: 3.36 kb
| Rows: 0
| Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 6 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 6 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 | mc | ref | parent_id,is_active | parent_id | 4 | const,const | 1 | Using where; Using filesort |
0.0001020
| Memory Before: 21.64 Mb
| Memory After: 21.64 Mb
| Memory Used: 3.36 kb
| Rows: 0
| Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 3 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 3 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 | mc | ref | parent_id,is_active | parent_id | 4 | const,const | 1 | Using where; Using filesort |
0.0001070
| Memory Before: 21.64 Mb
| Memory After: 21.65 Mb
| Memory Used: 3.36 kb
| Rows: 0
| Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 1 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 1 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 | mc | ref | parent_id,is_active | parent_id | 4 | const,const | 1 | Using where; Using filesort |
0.0000911
| Memory Before: 21.65 Mb
| Memory After: 21.65 Mb
| Memory Used: 3.36 kb
| Rows: 0
| Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 5 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 5 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 | mc | ref | parent_id,is_active | parent_id | 4 | const,const | 1 | Using where; Using filesort |
0.0000870
| Memory Before: 21.65 Mb
| Memory After: 21.65 Mb
| Memory Used: 3.36 kb
| Rows: 0
| Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 28 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 28 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 | mc | ref | parent_id,is_active | parent_id | 4 | const,const | 1 | Using where; Using filesort |
0.0000892
| Memory Before: 21.65 Mb
| Memory After: 21.65 Mb
| Memory Used: 3.36 kb
| Rows: 0
| Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 7 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 7 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 | mc | ref | parent_id,is_active | parent_id | 4 | const,const | 1 | Using where; Using filesort |
0.0000889
| Memory Before: 21.65 Mb
| Memory After: 21.66 Mb
| Memory Used: 3.36 kb
| Rows: 0
| Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 15 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 15 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 | mc | ref | parent_id,is_active | parent_id | 4 | const,const | 1 | Using where; Using filesort |
0.0001001
| Memory Before: 21.66 Mb
| Memory After: 21.66 Mb
| Memory Used: 3.36 kb
| Rows: 0
| Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 8 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 8 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 | mc | ref | parent_id,is_active | parent_id | 4 | const,const | 1 | Using where; Using filesort |
0.0000939
| Memory Before: 21.65 Mb
| Memory After: 21.66 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.0000970
| Memory Before: 21.66 Mb
| Memory After: 21.67 Mb
| Memory Used: 3.2 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'category.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'category.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.0000920
| Memory Before: 21.67 Mb
| Memory After: 21.67 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 = 'document' AND name = 'category.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'category.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.0002170
| Memory Before: 21.72 Mb
| Memory After: 21.72 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'category.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'category.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: 21.93 Mb
| Memory After: 21.93 Mb
| Memory Used: 9.27 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "document|category"
/* OO Query */
FROM phpfox_ad
WHERE location = "document|category"
/* 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.0001070
| Memory Before: 21.88 Mb
| Memory After: 21.88 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.0001969
| 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-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.0001109
| 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 = '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.0002160
| Memory Before: 21.92 Mb
| Memory After: 21.92 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'controller' AND module_id = 'document' AND name = 'index.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'controller' AND module_id = 'document' 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.0001099
| Memory Before: 21.93 Mb
| Memory After: 21.94 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.0001140
| Memory Before: 21.94 Mb
| Memory After: 21.94 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.0002170
| Memory Before: 21.94 Mb
| Memory After: 21.94 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.0002220
| Memory Before: 21.94 Mb
| Memory After: 21.94 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.0002091
| Memory Before: 21.94 Mb
| Memory After: 21.94 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.0002081
| Memory Before: 21.96 Mb
| Memory After: 21.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 = 'document' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.0002072
| Memory Before: 21.96 Mb
| Memory After: 21.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 = 'document' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.0002072
| Memory Before: 21.96 Mb
| Memory After: 21.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 = 'document' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.0002091
| Memory Before: 21.96 Mb
| Memory After: 21.97 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.0002060
| Memory Before: 21.96 Mb
| Memory After: 21.97 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.0002270
| Memory Before: 21.97 Mb
| Memory After: 21.97 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.0002182
| Memory Before: 21.98 Mb
| Memory After: 21.99 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 = 'document' AND name = 'entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.0001380
| Memory Before: 21.99 Mb
| Memory After: 21.99 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.0035930
| Memory Before: 22.04 Mb
| Memory After: 22.05 Mb
| Memory Used: 15.13 kb
| Rows: 4
| Slave: Yes
SELECT d.*, 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_document AS d
JOIN phpfox_user AS u
ON(u.user_id = d.user_id)
WHERE d.is_approved = 1 AND d.view_id = 0 AND d.module_id = 'document' AND d.item_id = 0 AND d.privacy = 0 AND d.is_featured = 1
LIMIT 4
/* OO Query */
FROM phpfox_document AS d
JOIN phpfox_user AS u
ON(u.user_id = d.user_id)
WHERE d.is_approved = 1 AND d.view_id = 0 AND d.module_id = 'document' AND d.item_id = 0 AND d.privacy = 0 AND d.is_featured = 1
LIMIT 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | d | ref | view_id,user_id,in_process,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,view_id_4 | in_process | 1 | const | 681 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.d.user_id | 1 |
0.0001199
| Memory Before: 22.08 Mb
| Memory After: 22.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 = '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.0001078
| Memory Before: 22.08 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 = 'document' AND name = 'featured.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.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 = 'document' AND name = 'featured.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' 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.0002379
| Memory Before: 22.16 Mb
| Memory After: 22.17 Mb
| Memory Used: 9.27 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "document|featured"
/* OO Query */
FROM phpfox_ad
WHERE location = "document|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.0001199
| Memory Before: 22.11 Mb
| Memory After: 22.12 Mb
| Memory Used: 3.5 kb
| Rows: 1
| Slave: No
SELECT count(*) as total_documents, sum(m.total_view) as total_views, sum(m.total_like) as total_likes
FROM phpfox_document AS m
WHERE m.in_process = 0 AND m.view_id = 0 AND m.module_id = 'document' AND m.item_id = 0 AND m.privacy IN(0)
/* OO Query */
FROM phpfox_document AS m
WHERE m.in_process = 0 AND m.view_id = 0 AND m.module_id = 'document' AND m.item_id = 0 AND m.privacy IN(0)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ALL | view_id,view_id_2 | MISSING KEY | 709 | Using where |
0.0000968
| 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 = '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.0001030
| Memory Before: 22.13 Mb
| Memory After: 22.13 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'statistic.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'statistic.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.0000951
| Memory Before: 22.13 Mb
| Memory After: 22.13 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'statistic.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'statistic.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002370
| Memory Before: 22.19 Mb
| Memory After: 22.2 Mb
| Memory Used: 9.27 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "document|statistic"
/* OO Query */
FROM phpfox_ad
WHERE location = "document|statistic"
/* 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.0040870
| Memory Before: 22.17 Mb
| Memory After: 22.19 Mb
| Memory Used: 20.7 kb
| Rows: 4
| Slave: No
SELECT *
FROM phpfox_document AS m
JOIN phpfox_user AS u
ON(m.user_id = u.user_id)
WHERE m.in_process = 0 AND m.is_approved=1 AND m.view_id = 0 AND m.module_id = 'document' AND m.item_id = 0 AND m.privacy IN(0)
ORDER BY m.total_view DESC
LIMIT 4
/* OO Query */
FROM phpfox_document AS m
JOIN phpfox_user AS u
ON(m.user_id = u.user_id)
WHERE m.in_process = 0 AND m.is_approved=1 AND m.view_id = 0 AND m.module_id = 'document' AND m.item_id = 0 AND m.privacy IN(0)
ORDER BY m.total_view DESC
LIMIT 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | range | view_id,user_id,in_process,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,view_id_4 | in_process | 1 | 681 | Using index condition; Using where; Using filesort | |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.m.user_id | 1 |
0.0002129
| Memory Before: 22.12 Mb
| Memory After: 22.13 Mb
| Memory Used: 3.16 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.0001130
| Memory Before: 22.13 Mb
| Memory After: 22.14 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'topview.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'topview.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.0001030
| Memory Before: 22.14 Mb
| Memory After: 22.14 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'topview.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'topview.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.0002189
| Memory Before: 22.21 Mb
| Memory After: 22.22 Mb
| Memory Used: 9.27 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "document|topview"
/* OO Query */
FROM phpfox_ad
WHERE location = "document|topview"
/* 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.0034649
| Memory Before: 22.2 Mb
| Memory After: 22.21 Mb
| Memory Used: 15.13 kb
| Rows: 4
| Slave: Yes
SELECT d.*, 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_document AS d
JOIN phpfox_user AS u
ON(u.user_id = d.user_id)
WHERE d.is_approved = 1 AND d.view_id = 0 AND d.module_id = 'document' AND d.item_id = 0 AND d.privacy = 0
ORDER BY d.total_comment DESC
LIMIT 4
/* OO Query */
FROM phpfox_document AS d
JOIN phpfox_user AS u
ON(u.user_id = d.user_id)
WHERE d.is_approved = 1 AND d.view_id = 0 AND d.module_id = 'document' AND d.item_id = 0 AND d.privacy = 0
ORDER BY d.total_comment DESC
LIMIT 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | d | range | view_id,user_id,in_process,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,view_id_4 | in_process | 1 | 681 | Using index condition; Using where; Using filesort | |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.d.user_id | 1 |
0.0001428
| Memory Before: 22.2 Mb
| Memory After: 22.21 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.0001180
| Memory Before: 22.21 Mb
| Memory After: 22.21 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 = 'document' AND name = 'mostdiscussed.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'mostdiscussed.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.0000951
| Memory Before: 22.22 Mb
| Memory After: 22.22 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'mostdiscussed.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'mostdiscussed.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.0002210
| Memory Before: 22.29 Mb
| Memory After: 22.3 Mb
| Memory Used: 9.28 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "document|mostdiscussed"
/* OO Query */
FROM phpfox_ad
WHERE location = "document|mostdiscussed"
/* 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.0001130
| Memory Before: 22.23 Mb
| Memory After: 22.23 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] => f7b26da50c53a530629fd333b43ec7b8
[redirect] => /document/show_12/when_all-time/sort_most-talked/page_48
)
Array ( )
