phpFox Developers Debug
Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula
Total Time:
0.2067020
PHP General Time:
0.1897719
GZIP:
disabled
Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.0169301
SQL Queries:
37
SQL Memory Usage:
410.44 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
11.74 Mb
Total Memory Usage (Including Debug):
11.97 Mb
Memory Limit:
512 Mb (1024M)
Load Balancing Enabled:
No
Requests From:
192.168.100.222
Server Time Stamp:
January 23, 2026, 3:21 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.0002611
| 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.0008998
| Memory Before: 2.42 Mb
| Memory After: 2.42 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 = '319d2fb663bc8cc6e4c6248d647324d2' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
FROM phpfox_log_session AS s
WHERE s.session_hash = '319d2fb663bc8cc6e4c6248d647324d2' 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.0006840
| Memory Before: 2.42 Mb
| Memory After: 2.43 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_log_session SET last_activity = '1769181669', user_id = '0', location = '/mobile/document/907/bases-carpas-2024', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.178', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = '319d2fb663bc8cc6e4c6248d647324d2'
| 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.0002589
| Memory Before: 3.74 Mb
| Memory After: 3.75 Mb
| Memory Used: 4.97 kb
| Rows: 1
| Slave: No
SELECT s.style_id, s.parent_id AS style_parent_id, s.folder AS style_folder_name, t.folder AS theme_folder_name, t.parent_id AS theme_parent_id, t.total_column, s.l_width, s.c_width, s.r_width
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ref | is_default | is_default | 1 | const | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | sqlgipsol.s.theme_id | 1 |
0.0001290
| Memory Before: 3.75 Mb
| Memory After: 3.75 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.0031011
| Memory Before: 5.69 Mb
| Memory After: 5.72 Mb
| Memory Used: 23.27 kb
| Rows: 3
| Slave: No
SELECT document_track.item_id AS document_is_viewed, f.friend_id AS is_friend, l.like_id AS is_liked, d.*, dt.*, u.*, d.view_id as document_view_id, dr.rate_id AS has_rated, dl.license_id, dl.license_name, dl.reference_url, dl.image_url as license_image_url
FROM phpfox_document AS d
LEFT JOIN phpfox_document_track AS document_track
ON(document_track.item_id = d.document_id)
LEFT JOIN phpfox_friend AS f
ON(f.user_id = d.user_id AND f.friend_user_id = 0)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'document' AND l.item_id = d.document_id AND l.user_id = 0)
JOIN phpfox_user AS u
ON(u.user_id = d.user_id)
JOIN phpfox_document_text AS dt
ON(dt.document_id = d.document_id)
LEFT JOIN phpfox_document_rating AS dr
ON(dr.item_id = d.document_id AND dr.user_id =0)
LEFT JOIN phpfox_document_license AS dl
ON(dl.license_id = d.document_license)
WHERE d.document_id =907
/* OO Query */
FROM phpfox_document AS d
LEFT JOIN phpfox_document_track AS document_track
ON(document_track.item_id = d.document_id)
LEFT JOIN phpfox_friend AS f
ON(f.user_id = d.user_id AND f.friend_user_id = 0)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'document' AND l.item_id = d.document_id AND l.user_id = 0)
JOIN phpfox_user AS u
ON(u.user_id = d.user_id)
JOIN phpfox_document_text AS dt
ON(dt.document_id = d.document_id)
LEFT JOIN phpfox_document_rating AS dr
ON(dr.item_id = d.document_id AND dr.user_id =0)
LEFT JOIN phpfox_document_license AS dl
ON(dl.license_id = d.document_license)
WHERE d.document_id =907
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | dr | system | item_id,item_id_2 | MISSING KEY | Const row not found | |||
| 1 | SIMPLE | d | const | PRIMARY,user_id,document_id_2,document_id,document_id_3,view_id_4 | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | u | const | PRIMARY,user_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | dl | const | PRIMARY | PRIMARY | 4 | const | Unique row not found | |
| 1 | SIMPLE | document_track | ref | item_id | item_id | 4 | const | 4 | Using index |
| 1 | SIMPLE | f | eq_ref | user_check,user_id,top_friend,friend_user_id | user_check | 8 | const,const | 1 | |
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | type_id_3|item_id | 81|4 | const,const | 1 (1%) | Using where; Using rowid filter |
| 1 | SIMPLE | dt | ALL | MISSING KEY | 729 | Using where; Using join buffer (flat, BNL join) |
0.0008230
| Memory Before: 5.81 Mb
| Memory After: 5.81 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 = 907
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 = 907
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.0010660
| Memory Before: 5.88 Mb
| Memory After: 5.88 Mb
| Memory Used: 3.8 kb
| Rows: 0
| Slave: Yes
SELECT tag_id, item_id, tag_text, tag_url
FROM phpfox_tag
WHERE item_id = 907 AND category_id = 'document'
ORDER BY tag_id ASC
/* OO Query */
FROM phpfox_tag
WHERE item_id = 907 AND category_id = 'document'
ORDER BY tag_id ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_tag | ref | item_id,category_id,user_search,user_search_general,item_id_2,item_id_3,category_id_2 | item_id | 81 | const,const | 1 | Using index condition; Using where; Using filesort |
0.0003469
| Memory Before: 5.88 Mb
| Memory After: 5.88 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: No
SELECT item_id
FROM phpfox_document_track
WHERE item_id = 907 AND user_id = 0
LIMIT 1
/* OO Query */
FROM phpfox_document_track
WHERE item_id = 907 AND user_id = 0
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_document_track | ref | item_id | item_id | 8 | const,const | 1 | Using index |
0.0002401
| Memory Before: 7.46 Mb
| Memory After: 7.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 = '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.0002391
| Memory Before: 8.4 Mb
| Memory After: 8.4 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.0002339
| Memory Before: 8.49 Mb
| Memory After: 8.49 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.0002871
| Memory Before: 8.64 Mb
| Memory After: 8.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 = '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.0002451
| Memory Before: 8.66 Mb
| Memory After: 8.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 = '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.0002110
| Memory Before: 8.67 Mb
| Memory After: 8.68 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0002310
| Memory Before: 8.69 Mb
| Memory After: 8.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.0002279
| Memory Before: 8.69 Mb
| Memory After: 8.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.0002770
| Memory Before: 8.72 Mb
| Memory After: 8.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.0002332
| Memory Before: 8.74 Mb
| Memory After: 8.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.0002871
| Memory Before: 8.73 Mb
| Memory After: 8.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 = '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.0002239
| Memory Before: 8.75 Mb
| Memory After: 8.75 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0002780
| Memory Before: 8.75 Mb
| Memory After: 8.75 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0006239
| 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 = 'base5' AND module_id = 'document' AND name = 'controller/view.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'document' AND name = 'controller/view.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002251
| Memory Before: 8.91 Mb
| Memory After: 8.92 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.0004809
| Memory Before: 8.92 Mb
| Memory After: 8.93 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'detail.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'detail.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.0001271
| Memory Before: 8.93 Mb
| Memory After: 8.93 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 = 'document' AND name = 'detail.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'detail.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.0006251
| Memory Before: 11.3 Mb
| Memory After: 11.31 Mb
| Memory Used: 9.29 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "document|detail"
/* OO Query */
FROM phpfox_ad
WHERE location = "document|detail"
/* 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.0004930
| Memory Before: 11.24 Mb
| Memory After: 11.24 Mb
| Memory Used: 3.13 kb
| Rows: 0
| Slave: Yes
SELECT action_id
FROM phpfox_action
WHERE action_type_id = 2 AND item_type_id = "document" AND item_id = 907 AND user_id = 0
LIMIT 1
/* OO Query */
FROM phpfox_action
WHERE action_type_id = 2 AND item_type_id = "document" AND item_id = 907 AND user_id = 0
LIMIT 1
/* 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.0010021
| Memory Before: 11.66 Mb
| Memory After: 11.66 Mb
| Memory Used: 6.7 kb
| Rows: 0
| Slave: Yes
SELECT l.*, 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, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
LEFT JOIN phpfox_action AS a
ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "document")
WHERE (l.type_id = 'document' OR l.type_id = 'document') AND l.item_id = 907
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
FROM phpfox_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
LEFT JOIN phpfox_action AS a
ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "document")
WHERE (l.type_id = 'document' OR l.type_id = 'document') AND l.item_id = 907
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | system | type_id,type_id_2,type_id_3,item_id | MISSING KEY | Const row not found; Using temporary; Using filesort | |||
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | type_id_3|item_id | 77|4 | const | 1 (1%) | Using index condition; Using where; Using rowid filter |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 |
0.0007901
| Memory Before: 11.66 Mb
| Memory After: 11.66 Mb
| Memory Used: 5.36 kb
| Rows: 0
| Slave: No
SELECT 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_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
WHERE l.type_id = 'document' AND l.item_id = 907
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
FROM phpfox_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
WHERE l.type_id = 'document' AND l.item_id = 907
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l | ref | type_id,type_id_2,type_id_3,item_id | type_id_2 | 81 | const,const | 1 | Using where; Using index; Using temporary; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 |
0.0005071
| Memory Before: 11.66 Mb
| Memory After: 11.66 Mb
| Memory Used: 5.36 kb
| Rows: 0
| Slave: Yes
SELECT 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_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "document" AND a.item_id = 907
GROUP BY u.user_id
/* OO Query */
FROM phpfox_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "document" AND a.item_id = 907
GROUP BY u.user_id
/* 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.0001268
| Memory Before: 11.67 Mb
| Memory After: 11.67 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 = 'feed' AND name = 'comment.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'comment.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.0002239
| Memory Before: 11.76 Mb
| Memory After: 11.89 Mb
| Memory Used: 131.06 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'link.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'link.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.0002351
| Memory Before: 11.98 Mb
| Memory After: 11.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 = 'share' AND name = 'link.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'share' AND name = 'link.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.0001850
| Memory Before: 11.8 Mb
| Memory After: 11.93 Mb
| Memory Used: 131.06 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'display.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'display.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.0002239
| Memory Before: 11.95 Mb
| Memory After: 11.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 = 'captcha' AND name = 'form.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'captcha' AND name = 'form.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.0002768
| Memory Before: 11.73 Mb
| Memory After: 11.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-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] => 319d2fb663bc8cc6e4c6248d647324d2
[redirect] => /mobile/document/907/bases-carpas-2024
)
Array
(
[coreb6aavisit] => 1769181669
)
Deskargatu 
