KAIXO 48 ALDIZKARIA
Nork: AMHER
4 ikustaldia(k) | 0 like(s)
Informe final Letrinas Kiroba
2 ikustaldia(k) | 0 like(s)
phpFox Developers Debug Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula

Total Time:
0.3223209
PHP General Time:
0.2831483
GZIP:
disabled

Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.0391726
SQL Queries:
80
SQL Memory Usage:
393.6 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
22.36 Mb
Total Memory Usage (Including Debug):
22.65 Mb
Memory Limit:
512 Mb (1024M)

Load Balancing Enabled:
No
Requests From:
192.168.100.222


Server Time Stamp:
December 22, 2025, 2: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.0010850 | 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 ('723d93333ecd4773a69a1cd59570cb19', '0d574f7196f9f96e319d05681455513d', '0', '1766415020', '/document/sort_most-talked/show_9/when_all-time/page_45', '0', '0', '0', '216.73.216.164', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.')
0.0002820 | 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefis_defaultis_default1const1 
1SIMPLEteq_refPRIMARY,theme_idPRIMARY2sqlgipsol.s.theme_id1 
0.0001211 | 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_styleconststyle_id_2,style_idstyle_id_22const1 
0.0002558 | 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0002649 | 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefin_process,in_process_2,in_process_3,in_process_4,in_process_5in_process1const681Using where
0.0146799 | Memory Before: 6.3 Mb | Memory After: 6.35 Mb | Memory Used: 50.72 kb | Rows: 9 | 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 9 OFF SET 396
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEdtALL MISSING KEY   729Using temporary; Using filesort
1SIMPLEmeq_refPRIMARY,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_4PRIMARY4sqlgipsol.dt.document_id1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4sqlgipsol.m.user_id1 
0.0001831 | Memory Before: 6.86 Mb | Memory After: 6.86 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 = 576
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpcdrefcategory_id,document_iddocument_id4const1Using temporary; Using filesort
1SIMPLEpceq_refPRIMARYPRIMARY3sqlgipsol.pcd.category_id1Using index condition
0.0001812 | Memory Before: 7.07 Mb | Memory After: 7.07 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 = 577
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpcdrefcategory_id,document_iddocument_id4const1Using temporary; Using filesort
1SIMPLEpceq_refPRIMARYPRIMARY3sqlgipsol.pcd.category_id1Using index condition
0.0001810 | 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 = 578
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpcdrefcategory_id,document_iddocument_id4const1Using temporary; Using filesort
1SIMPLEpceq_refPRIMARYPRIMARY3sqlgipsol.pcd.category_id1Using index condition
0.0001040 | 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 = 579
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpcdrefcategory_id,document_iddocument_id4const1Using temporary; Using filesort
1SIMPLEpceq_refPRIMARYPRIMARY3sqlgipsol.pcd.category_id1Using index condition
0.0001900 | 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 = 583
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpcdrefcategory_id,document_iddocument_id4const1Using temporary; Using filesort
1SIMPLEpceq_refPRIMARYPRIMARY3sqlgipsol.pcd.category_id1Using index condition
0.0001640 | Memory Before: 7.11 Mb | Memory After: 7.12 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 = 584
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpcdrefcategory_id,document_iddocument_id4const1Using temporary; Using filesort
1SIMPLEpceq_refPRIMARYPRIMARY3sqlgipsol.pcd.category_id1Using index condition
0.0000999 | 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 = 586
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpcdrefcategory_id,document_iddocument_id4const1Using temporary; Using filesort
1SIMPLEpceq_refPRIMARYPRIMARY3sqlgipsol.pcd.category_id1Using index condition
0.0000970 | 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 = 580
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpcdrefcategory_id,document_iddocument_id4const1Using temporary; Using filesort
1SIMPLEpceq_refPRIMARYPRIMARY3sqlgipsol.pcd.category_id1Using index condition
0.0000899 | 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 = 581
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpcdrefcategory_id,document_iddocument_id4const1Using temporary; Using filesort
1SIMPLEpceq_refPRIMARYPRIMARY3sqlgipsol.pcd.category_id1Using index condition
0.0001700 | Memory Before: 7.44 Mb | Memory After: 7.44 Mb | Memory Used: 3.7 kb | Rows: 4 | Slave: No
SELECT r.feed_id, r.title_var, r.php_group_code
FROM phpfox_rss AS r
     JOIN phpfox_module AS m
            ON(m.module_id = r.module_id AND m.is_active = 1)
     JOIN phpfox_product AS p
            ON(p.product_id = r.product_id AND p.is_active = 1)

WHERE r.is_active = 1 AND r.is_site_wide = 1
ORDER BY r.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLErALLis_activeMISSING KEY   8Using where; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.r.product_id,const3Using index
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.r.module_id,const8Using index
0.0001929 | Memory Before: 7.59 Mb | Memory After: 7.59 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefproduct_id,m_connection,parent_idm_connection79const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000770 | Memory Before: 7.59 Mb | Memory After: 7.6 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefproduct_id,m_connection,parent_idm_connection79const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000911 | Memory Before: 7.6 Mb | Memory After: 7.61 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmALLproduct_id,parent_idMISSING KEY   209Using where; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0001769 | Memory Before: 8.53 Mb | Memory After: 8.53 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001960 | Memory Before: 9.92 Mb | Memory After: 9.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 = 'block' AND module_id = 'core' AND name = 'template-body.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002110 | Memory Before: 10.11 Mb | Memory After: 10.11 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'cabecera.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002069 | Memory Before: 10.26 Mb | Memory After: 10.26 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001049 | Memory Before: 10.28 Mb | Memory After: 10.28 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002620 | Memory Before: 21.44 Mb | Memory After: 21.45 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002139 | Memory Before: 21.46 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 = 'block' AND module_id = 'core' AND name = 'template-holdername.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002279 | Memory Before: 21.46 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 = 'layout' AND name = 'breadcrumb.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0002110 | Memory Before: 21.49 Mb | Memory After: 21.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 = 'base5' AND module_id = 'core' AND name = 'block/template-breadcrumblist.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002129 | Memory Before: 21.5 Mb | Memory After: 21.51 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-breadcrumbmenu.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002270 | 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 = 'core' AND name = 'template-menusub.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001240 | Memory Before: 21.69 Mb | Memory After: 21.7 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcALLparent_id,is_activeMISSING KEY   10Using where; Using filesort
0.0001342 | Memory Before: 21.67 Mb | Memory After: 21.67 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_id,is_activeparent_id4const,const1Using where; Using filesort
0.0001080 | Memory Before: 21.68 Mb | Memory After: 21.68 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_id,is_activeparent_id4const,const1Using where; Using filesort
0.0001011 | Memory Before: 21.68 Mb | Memory After: 21.68 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_id,is_activeparent_id4const,const1Using where; Using filesort
0.0001059 | Memory Before: 21.68 Mb | Memory After: 21.68 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_id,is_activeparent_id4const,const1Using where; Using filesort
0.0001030 | Memory Before: 21.68 Mb | Memory After: 21.69 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_id,is_activeparent_id4const,const1Using where; Using filesort
0.0000999 | Memory Before: 21.69 Mb | Memory After: 21.69 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_id,is_activeparent_id4const,const1Using where; Using filesort
0.0000958 | Memory Before: 21.69 Mb | Memory After: 21.69 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_id,is_activeparent_id4const,const1Using where; Using filesort
0.0000961 | Memory Before: 21.69 Mb | Memory After: 21.7 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_id,is_activeparent_id4const,const1Using where; Using filesort
0.0001011 | Memory Before: 21.7 Mb | Memory After: 21.7 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_id,is_activeparent_id4const,const1Using where; Using filesort
0.0001059 | Memory Before: 21.69 Mb | Memory After: 21.7 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001049 | Memory Before: 21.7 Mb | Memory After: 21.71 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001030 | Memory Before: 21.71 Mb | Memory After: 21.71 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002151 | Memory Before: 21.76 Mb | Memory After: 21.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 = 'block' AND module_id = 'core' AND name = 'category.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002422 | Memory Before: 21.97 Mb | Memory After: 21.98 Mb | Memory Used: 9.27 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "document|category"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_adALL MISSING KEY   12Using where
0.0001209 | Memory Before: 21.92 Mb | Memory After: 21.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 = 'search.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0002110 | Memory Before: 21.95 Mb | Memory After: 21.95 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002260 | Memory Before: 21.95 Mb | Memory After: 21.95 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0002120 | 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 = 'controller' AND module_id = 'document' AND name = 'index.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001359 | Memory Before: 21.97 Mb | Memory After: 21.98 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002172 | Memory Before: 21.98 Mb | Memory After: 21.98 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002170 | Memory Before: 21.98 Mb | Memory After: 21.98 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'entry.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002141 | Memory Before: 21.98 Mb | Memory After: 21.98 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 = 'entry.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002148 | 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002160 | Memory Before: 22 Mb | Memory After: 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 = 'entry.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002258 | Memory Before: 22 Mb | Memory After: 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 = 'entry.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002151 | Memory Before: 22 Mb | Memory After: 22.01 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002141 | Memory Before: 22 Mb | Memory After: 22.01 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002131 | Memory Before: 22.01 Mb | Memory After: 22.01 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0035310 | Memory Before: 22.06 Mb | Memory After: 22.08 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEdrefview_id,user_id,in_process,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,view_id_4in_process1const681Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4sqlgipsol.d.user_id1 
0.0001321 | Memory Before: 22.1 Mb | Memory After: 22.1 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001218 | Memory Before: 22.11 Mb | Memory After: 22.11 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'featured.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001111 | Memory Before: 22.11 Mb | Memory After: 22.11 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'featured.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002210 | Memory Before: 22.2 Mb | Memory After: 22.21 Mb | Memory Used: 9.27 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "document|featured"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_adALL MISSING KEY   12Using where
0.0001252 | Memory Before: 22.15 Mb | Memory After: 22.15 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmALLview_id,view_id_2MISSING KEY   709Using where
0.0001051 | Memory Before: 22.16 Mb | Memory After: 22.16 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001061 | Memory Before: 22.16 Mb | Memory After: 22.17 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 = 'statistic.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0000980 | Memory Before: 22.17 Mb | Memory After: 22.17 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 = 'statistic.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002270 | Memory Before: 22.22 Mb | Memory After: 22.23 Mb | Memory Used: 9.27 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "document|statistic"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_adALL MISSING KEY   12Using where
0.0042579 | Memory Before: 22.21 Mb | Memory After: 22.23 Mb | Memory Used: 20.72 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrangeview_id,user_id,in_process,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,view_id_4in_process1 681Using index condition; Using where; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4sqlgipsol.m.user_id1 
0.0001321 | Memory Before: 22.19 Mb | Memory After: 22.19 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001099 | Memory Before: 22.19 Mb | Memory After: 22.2 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'topview.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001061 | Memory Before: 22.2 Mb | Memory After: 22.2 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002241 | Memory Before: 22.27 Mb | Memory After: 22.28 Mb | Memory Used: 9.27 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "document|topview"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_adALL MISSING KEY   12Using where
0.0034580 | Memory Before: 22.26 Mb | Memory After: 22.27 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEdrangeview_id,user_id,in_process,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,view_id_4in_process1 681Using index condition; Using where; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4sqlgipsol.d.user_id1 
0.0001259 | Memory Before: 22.26 Mb | Memory After: 22.27 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001070 | Memory Before: 22.27 Mb | Memory After: 22.28 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'mostdiscussed.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0000958 | Memory Before: 22.28 Mb | Memory After: 22.28 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'document' AND name = 'mostdiscussed.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002110 | Memory Before: 22.33 Mb | Memory After: 22.34 Mb | Memory Used: 9.27 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "document|mostdiscussed"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_adALL MISSING KEY   12Using where
0.0001130 | Memory Before: 22.27 Mb | Memory After: 22.28 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menufooter.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
Array
(
    [session] => 723d93333ecd4773a69a1cd59570cb19
    [redirect] => /document/sort_most-talked/show_9/when_all-time/page_45
)
TOP
-->