Bideoak bilatu
Anterior Siguiente
1,008 emaitzetatik honakoak: 55-72
phpFox Developers Debug Toggle JavaScript Console
Debug Details
Version:
3.8.0
Product Code Name:
Nebula

Total Time:
0.4059181
PHP General Time:
0.3319888
GZIP:
disabled

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

Total Memory Usage:
16.17 Mb
Total Memory Usage (Including Debug):
16.39 Mb
Memory Limit:
512 Mb (1024M)

Load Balancing Enabled:
No
Requests From:
192.168.100.222


Server Time Stamp:
June 15, 2026, 9:29 am
PHP Version:
5.6.40
PHP Sapi:
fpm-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux

Cache:
file
SQL Queries
0.0001249 | Memory Before: 1.55 Mb | Memory After: 1.55 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpALLis_activeMISSING KEY   5Using where; Using filesort
1SIMPLEphrefcall_namecall_name258sqlgipsol.p.call_name,const1Using where; Using index
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.p.module_id,const8Using index
0.0011499 | Memory Before: 1.83 Mb | Memory After: 1.83 Mb | Memory Used: 4.32 kb | Rows: 76 | Slave: No
SELECT m.module_id
FROM phpfox_module AS m
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.is_active = 1
ORDER BY m.module_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmALLis_activeMISSING KEY   85Using where; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
0.0005162 | Memory Before: 2.04 Mb | Memory After: 2.05 Mb | Memory Used: 7.46 kb | Rows: 26 | Slave: No
SELECT product.*
FROM phpfox_product AS product
ORDER BY product.is_core DESC , product.product_id ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEproductALL MISSING KEY   26Using filesort
0.0004759 | Memory Before: 2.41 Mb | Memory After: 2.41 Mb | Memory Used: 3.38 kb | Rows: 2 | Slave: No
SELECT r.url, r.replacement
FROM phpfox_rewrite AS r
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLErALL MISSING KEY   2 
0.0005951 | Memory Before: 2.62 Mb | Memory After: 2.63 Mb | Memory Used: 3.86 kb | Rows: 1 | Slave: No
SELECT s.session_hash, s.id_hash, s.captcha_hash, s.user_id
FROM phpfox_log_session AS s
WHERE s.session_hash = '7c9cc8755b999eafcf005809e08f9016' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefsession_hash,log_sessionsession_hash32const1Using index condition; Using where
0.0004580 | Memory Before: 2.63 Mb | Memory After: 2.63 Mb | Memory Used: 1.41 kb | Rows: - | Slave: No
UPDATE phpfox_log_session SET last_activity = '1781515757', user_id = '0', location = '/video/show_18/sort_most-viewed/when_all-time/page_4/', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.217.64', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = '7c9cc8755b999eafcf005809e08f9016'
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_log_sessionrefsession_hash,log_sessionsession_hash32const1Using index condition
0.0053530 | Memory Before: 2.72 Mb | Memory After: 2.76 Mb | Memory Used: 38.02 kb | Rows: 472 | Slave: Yes
SELECT m.module_id, user_group_setting.name, user_group_setting.type_id, user_group_setting.default_admin, user_group_setting.default_user, user_group_setting.default_guest, user_group_setting.default_staff, user_setting.value_actual AS value_actual
FROM phpfox_user_group_setting AS user_group_setting
     JOIN phpfox_module AS m
            ON(m.module_id = user_group_setting.module_id)
     LEFT JOIN phpfox_user_setting AS user_setting
            ON(user_setting.user_group_id = '3' AND user_setting.setting_id = user_group_setting.setting_id)

/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuser_group_settingALLmodule_idMISSING KEY   472Using where
1SIMPLEuser_settingrefuser_group_iduser_group_id4const,sqlgipsol.user_group_setting.setting_id1 
1SIMPLEmrefmodule_id,module_is_activemodule_id77sqlgipsol.user_group_setting.module_id8Using index
0.0005760 | Memory Before: 4.03 Mb | Memory After: 4.03 Mb | Memory Used: 3.27 kb | Rows: 9 | Slave: No
SELECT ts.style_id
FROM phpfox_theme_style AS ts
     JOIN phpfox_theme AS t
            ON(t.theme_id = ts.theme_id AND t.is_active = 1)

WHERE ts.is_active = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtsALLis_activeMISSING KEY   9Using where
1SIMPLEteq_refPRIMARY,is_active,theme_idPRIMARY2sqlgipsol.ts.theme_id1Using where
0.0001149 | Memory Before: 4.01 Mb | Memory After: 4.01 Mb | Memory Used: 5.08 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.0000851 | Memory Before: 4.01 Mb | Memory After: 4.02 Mb | Memory Used: 3.22 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.0072160 | Memory Before: 4.63 Mb | Memory After: 4.65 Mb | Memory Used: 19.4 kb | Rows: 144 | Slave: No
SELECT b.block_id, b.type_id, b.ordering, b.m_connection, b.component, b.location, b.disallow_access, b.can_move, m.module_id, bs.source_parsed
FROM phpfox_block AS b
     LEFT JOIN phpfox_block_source AS bs
            ON(bs.block_id = b.block_id)
     JOIN phpfox_module AS m
            ON(b.module_id = m.module_id AND m.is_active = 1)
     JOIN phpfox_product AS p
            ON(b.product_id = p.product_id AND p.is_active = 1)

WHERE b.is_active = 1
ORDER BY b.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmindexis_active,module_id,module_is_activemodule_is_active78 85Using where; Using index; Using temporary; Using filesort
1SIMPLEbref|filteris_active,product_id,module_idmodule_id|is_active77|1sqlgipsol.m.module_id9 (63%)Using where; Using rowid filter
1SIMPLEbsrefblock_idblock_id4sqlgipsol.b.block_id5 
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.b.product_id,const3Using index
0.0003798 | Memory Before: 4.9 Mb | Memory After: 4.9 Mb | Memory Used: 3.18 kb | Rows: 0 | Slave: No
SELECT find_value
FROM phpfox_ban
WHERE type_id = 'ip'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0013461 | Memory Before: 4.89 Mb | Memory After: 4.92 Mb | Memory Used: 26.59 kb | Rows: 990 | Slave: No
SELECT page_id, title_url
FROM phpfox_page
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_pageALL MISSING KEY   990 
0.0004580 | Memory Before: 5.34 Mb | Memory After: 5.34 Mb | Memory Used: 4.34 kb | Rows: 3 | Slave: Yes
SELECT *
FROM phpfox_seo_meta
ORDER BY time_stamp
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_seo_metaALL MISSING KEY   3Using filesort
0.0006192 | Memory Before: 5.82 Mb | Memory After: 5.83 Mb | Memory Used: 4.76 kb | Rows: 0 | Slave: Yes
SELECT i.*, io.phrase_var as option_phrase_var
FROM phpfox_input_field AS i
     LEFT JOIN phpfox_input_option AS io
            ON(io.field_id = i.field_id)

WHERE module_id = "video"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0001988 | Memory Before: 6.06 Mb | Memory After: 6.07 Mb | Memory Used: 4.66 kb | Rows: 0 | Slave: Yes
SELECT *, COUNT(item_id) AS total
FROM phpfox_tag
WHERE category_id = 'video' AND tag_url = ''
GROUP BY tag_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_tagrefcategory_id,tag_url,user_search,user_search_general,category_id_2tag_url257const1Using index condition; Using where; Using temporary; Using filesort
0.0219910 | Memory Before: 6.29 Mb | Memory After: 6.32 Mb | Memory Used: 27.37 kb | Rows: 698 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'core' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpref|filterlanguage_id,module_id,setting_listmodule_id|language_id78|14const2540 (30%)Using index condition; Using where; Using rowid filter
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0001881 | Memory Before: 6.56 Mb | Memory After: 6.56 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_video AS m
WHERE m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0)
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefin_process,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6in_process_27const,const,const,const1005Using index
0.0059969 | Memory Before: 6.56 Mb | Memory After: 6.58 Mb | Memory Used: 18.43 kb | Rows: 18 | Slave: Yes
SELECT m.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_video AS m
     JOIN phpfox_user AS u
            ON(u.user_id = m.user_id)

WHERE m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0)
ORDER BY m.total_view DESC
LIMIT 18 OFF SET 54
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrangein_process,user_id,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6in_process_36 997Using index condition; Using where; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4sqlgipsol.m.user_id1 
0.0006299 | Memory Before: 6.98 Mb | Memory After: 6.99 Mb | Memory Used: 13.44 kb | Rows: 3 | Slave: Yes
SELECT v.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_video AS v
     JOIN phpfox_user AS u
            ON(u.user_id = v.user_id)

WHERE v.is_featured = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEvALLuser_idMISSING KEY   1016Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4sqlgipsol.v.user_id1 
0.0002570 | Memory Before: 7.12 Mb | Memory After: 7.12 Mb | Memory Used: 3.63 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_seo_nofollow
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_seo_nofollowsystem MISSING KEY    Const row not found
0.0001569 | Memory Before: 7.11 Mb | Memory After: 7.12 Mb | Memory Used: 4.2 kb | Rows: 3 | Slave: Yes
SELECT *
FROM phpfox_seo_meta
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_seo_metaALL MISSING KEY   3 
0.0004718 | Memory Before: 7.36 Mb | Memory After: 7.37 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.0009930 | Memory Before: 7.51 Mb | Memory After: 7.51 Mb | Memory Used: 6.18 kb | Rows: 16 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'main' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmindex_mergeproduct_id,m_connection,parent_idm_connection,parent_id79,3 4Using intersect(m_connection,parent_id); 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.0000780 | Memory Before: 7.54 Mb | Memory After: 7.55 Mb | Memory Used: 6.16 kb | Rows: 16 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'main' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmindex_mergeproduct_id,m_connection,parent_idm_connection,parent_id79,3 4Using intersect(m_connection,parent_id); 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.0007160 | Memory Before: 7.57 Mb | Memory After: 7.58 Mb | Memory Used: 9.77 kb | Rows: 72 | 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   211Using 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.0002389 | Memory Before: 7.7 Mb | Memory After: 7.71 Mb | Memory Used: 10.24 kb | Rows: 0 | Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0001709 | Memory Before: 7.71 Mb | Memory After: 7.72 Mb | Memory Used: 10.24 kb | Rows: 0 | Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003970 | Memory Before: 7.59 Mb | Memory After: 7.6 Mb | Memory Used: 5.14 kb | Rows: 3 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'main_right' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefproduct_id,m_connection,parent_idm_connection79const,const2Using 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.0000730 | Memory Before: 7.58 Mb | Memory After: 7.59 Mb | Memory Used: 5.16 kb | Rows: 3 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'main_right' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefproduct_id,m_connection,parent_idm_connection79const,const2Using 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.0000899 | Memory Before: 7.59 Mb | Memory After: 7.6 Mb | Memory Used: 9.75 kb | Rows: 72 | 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   211Using 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.0000792 | Memory Before: 7.72 Mb | Memory After: 7.73 Mb | Memory Used: 10.29 kb | Rows: 0 | Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0000660 | Memory Before: 7.72 Mb | Memory After: 7.73 Mb | Memory Used: 10.25 kb | Rows: 0 | Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003140 | Memory Before: 7.62 Mb | Memory After: 7.62 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'explore' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
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.0000899 | Memory Before: 7.59 Mb | Memory After: 7.59 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'explore' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
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.0000930 | Memory Before: 7.59 Mb | Memory After: 7.6 Mb | Memory Used: 9.75 kb | Rows: 72 | 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   211Using 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.0000801 | Memory Before: 7.72 Mb | Memory After: 7.73 Mb | Memory Used: 10.27 kb | Rows: 0 | Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0000660 | Memory Before: 7.72 Mb | Memory After: 7.73 Mb | Memory Used: 10.24 kb | Rows: 0 | Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0004861 | Memory Before: 7.63 Mb | Memory After: 7.63 Mb | Memory Used: 4.99 kb | Rows: 1 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'video.index' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmindex_mergeproduct_id,m_connection,parent_idparent_id,m_connection3,79 9Using intersect(parent_id,m_connection); 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.0003169 | Memory Before: 7.6 Mb | Memory After: 7.61 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'video' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
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.0000930 | Memory Before: 7.6 Mb | Memory After: 7.61 Mb | Memory Used: 9.77 kb | Rows: 72 | 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   211Using 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.0000851 | Memory Before: 7.73 Mb | Memory After: 7.74 Mb | Memory Used: 10.26 kb | Rows: 0 | Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0000639 | Memory Before: 7.73 Mb | Memory After: 7.74 Mb | Memory Used: 10.24 kb | Rows: 0 | Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0005770 | Memory Before: 7.64 Mb | Memory After: 7.65 Mb | Memory Used: 5.38 kb | Rows: 6 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'footer' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmindex_mergeproduct_id,m_connection,parent_idm_connection,parent_id79,3 1Using intersect(m_connection,parent_id); 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.62 Mb | Memory After: 7.63 Mb | Memory Used: 5.38 kb | Rows: 6 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'footer' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmindex_mergeproduct_id,m_connection,parent_idm_connection,parent_id79,3 1Using intersect(m_connection,parent_id); 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.0000870 | Memory Before: 7.64 Mb | Memory After: 7.65 Mb | Memory Used: 9.81 kb | Rows: 72 | 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   211Using 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.0000830 | Memory Before: 7.76 Mb | Memory After: 7.77 Mb | Memory Used: 10.27 kb | Rows: 0 | Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0000782 | Memory Before: 7.76 Mb | Memory After: 7.77 Mb | Memory Used: 10.24 kb | Rows: 0 | Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0002732 | Memory Before: 8.03 Mb | Memory After: 8.04 Mb | Memory Used: 9.51 kb | Rows: 0 | Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '1'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0002539 | Memory Before: 8.01 Mb | Memory After: 8.02 Mb | Memory Used: 9.51 kb | Rows: 0 | Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '3'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0001719 | Memory Before: 8.01 Mb | Memory After: 8.02 Mb | Memory Used: 3.63 kb | Rows: 0 | Slave: No
SELECT logo_id, logo, file_ext
FROM phpfox_theme_style_logo
WHERE style_id = 11
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0004840 | Memory Before: 8.06 Mb | Memory After: 8.06 Mb | Memory Used: 5.14 kb | Rows: 3 | Slave: Yes
SELECT cron.*
FROM phpfox_cron AS cron
     JOIN phpfox_product AS product
            ON(product.product_id = cron.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = cron.module_id AND m.is_active = 1)

WHERE cron.is_active = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcronALLis_activeMISSING KEY   4Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.cron.product_id,const3Using index
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.cron.module_id,const8Using index
0.0000980 | 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.0002842 | Memory Before: 8.88 Mb | Memory After: 8.88 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT find_value, replacement
FROM phpfox_ban
WHERE type_id = 'word'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0004930 | Memory Before: 8.89 Mb | Memory After: 8.89 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT tc.module_id, tc.file_name
FROM phpfox_theme_css AS tc
WHERE style_id = 11
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0005980 | Memory Before: 9.49 Mb | Memory After: 9.5 Mb | Memory Used: 4.4 kb | Rows: 1 | Slave: No
SELECT *
FROM phpfox_currency
WHERE is_active = 1
ORDER BY ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_currencyrefis_activeis_active1const1Using where; Using filesort
0.0002110 | Memory Before: 14.98 Mb | Memory After: 14.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 = '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.0005920 | Memory Before: 15.17 Mb | Memory After: 15.18 Mb | Memory Used: 9.51 kb | Rows: 0 | Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '14'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0001249 | Memory Before: 15.19 Mb | Memory After: 15.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 = '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.0006750 | Memory Before: 15.31 Mb | Memory After: 15.32 Mb | Memory Used: 6.03 kb | Rows: 2 | Slave: Yes
SELECT l.*
FROM phpfox_language AS l
WHERE l.user_select = 1
ORDER BY l.is_default DESC , l.title
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrefuser_selectuser_select1const2Using where; Using filesort
0.0001311 | Memory Before: 15.32 Mb | Memory After: 15.32 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.0001090 | Memory Before: 15.34 Mb | Memory After: 15.35 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.0006189 | Memory Before: 15.35 Mb | Memory After: 15.36 Mb | Memory Used: 9.51 kb | Rows: 0 | Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '9'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0004659 | Memory Before: 15.36 Mb | Memory After: 15.36 Mb | Memory Used: 9.55 kb | Rows: 0 | Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '10'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0004280 | Memory Before: 15.36 Mb | Memory After: 15.37 Mb | Memory Used: 9.51 kb | Rows: 0 | Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '6'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0001149 | Memory Before: 15.37 Mb | Memory After: 15.37 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.0005810 | Memory Before: 15.36 Mb | Memory After: 15.37 Mb | Memory Used: 9.51 kb | Rows: 0 | Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '11'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0001221 | Memory Before: 15.38 Mb | Memory After: 15.38 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-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.0004110 | Memory Before: 15.38 Mb | Memory After: 15.39 Mb | Memory Used: 9.53 kb | Rows: 0 | Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '13'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0003960 | Memory Before: 15.38 Mb | Memory After: 15.39 Mb | Memory Used: 9.51 kb | Rows: 0 | Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '7'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0001142 | Memory Before: 15.38 Mb | Memory After: 15.39 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.0001059 | Memory Before: 15.41 Mb | Memory After: 15.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 = '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.0002041 | Memory Before: 15.43 Mb | Memory After: 15.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 = '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.0005820 | Memory Before: 15.58 Mb | Memory After: 15.59 Mb | Memory Used: 9.51 kb | Rows: 0 | Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '12'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0001390 | Memory Before: 15.59 Mb | Memory After: 15.6 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.0005159 | Memory Before: 15.71 Mb | Memory After: 15.71 Mb | Memory Used: 3.35 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_video_category AS mc
WHERE mc.parent_id = 0 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0001211 | Memory Before: 15.71 Mb | Memory After: 15.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 = '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.0002031 | Memory Before: 15.74 Mb | Memory After: 15.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-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.0001121 | Memory Before: 15.74 Mb | Memory After: 15.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 = '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.0005851 | Memory Before: 15.74 Mb | Memory After: 15.75 Mb | Memory Used: 9.51 kb | Rows: 0 | Slave: No
SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '2'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0001199 | Memory Before: 15.75 Mb | Memory After: 15.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 = 'controller' AND module_id = 'video' 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.0001070 | Memory Before: 15.77 Mb | Memory After: 15.78 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001340 | Memory Before: 15.78 Mb | Memory After: 15.78 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'entry.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002069 | Memory Before: 15.97 Mb | Memory After: 15.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 = 'video' 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.0002060 | Memory Before: 15.97 Mb | Memory After: 15.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 = 'video' 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.0002060 | Memory Before: 15.97 Mb | Memory After: 15.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 = 'video' 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.0002048 | Memory Before: 15.98 Mb | Memory After: 15.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 = 'video' 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.0002060 | Memory Before: 15.98 Mb | Memory After: 15.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 = 'video' 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.0002069 | Memory Before: 15.98 Mb | Memory After: 15.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 = 'video' 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.0002079 | Memory Before: 15.98 Mb | Memory After: 15.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 = 'video' 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.0002191 | Memory Before: 16 Mb | Memory After: 16.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 = 'video' 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.0002060 | Memory Before: 16.01 Mb | Memory After: 16.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 = 'video' 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.0002100 | Memory Before: 16.01 Mb | Memory After: 16.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 = 'video' 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.0002072 | Memory Before: 16.01 Mb | Memory After: 16.02 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' 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.0002060 | Memory Before: 16.02 Mb | Memory After: 16.02 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' 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.0002060 | Memory Before: 16.02 Mb | Memory After: 16.02 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' 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.0002069 | Memory Before: 16.02 Mb | Memory After: 16.03 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' 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.0002129 | Memory Before: 16.03 Mb | Memory After: 16.03 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' 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.0002260 | Memory Before: 16.03 Mb | Memory After: 16.03 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' 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: 16.04 Mb | Memory After: 16.04 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.0012779 | Memory Before: 16.05 Mb | Memory After: 16.06 Mb | Memory Used: 16.46 kb | Rows: 0 | Slave: No
SELECT s.*, v.*, ve.embed_code, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_video AS v
     JOIN phpfox_user AS u
            ON(u.user_id = v.user_id)
     JOIN phpfox_ad_sponsor AS s
            ON(s.item_id = v.video_id)
     LEFT JOIN phpfox_video_embed AS ve
            ON(ve.video_id = v.video_id)

WHERE v.in_process = 0 AND v.view_id = 0 AND v.is_sponsor = 1 AND s.module_id = "video"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsALL MISSING KEY   21Using where
1SIMPLEveq_refPRIMARY,in_process,user_id,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6PRIMARY4sqlgipsol.s.item_id1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4sqlgipsol.v.user_id1 
1SIMPLEveeq_refvideo_idvideo_id4sqlgipsol.s.item_id1 
0.0001230 | Memory Before: 16.07 Mb | Memory After: 16.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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001180 | Memory Before: 16.08 Mb | Memory After: 16.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 = 'block' AND module_id = 'video' 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.0000970 | Memory Before: 16.08 Mb | Memory After: 16.09 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = '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.0001512 | Memory Before: 16.14 Mb | Memory After: 16.14 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001841 | Memory Before: 16.16 Mb | Memory After: 16.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 = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001769 | Memory Before: 16.16 Mb | Memory After: 16.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 = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0004718 | Memory Before: 16.18 Mb | Memory After: 16.19 Mb | Memory Used: 9.27 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "video|featured"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_adALL MISSING KEY   12Using where
0.0021169 | Memory Before: 16.14 Mb | Memory After: 16.14 Mb | Memory Used: 3.77 kb | Rows: 0 | Slave: Yes
SELECT category_id, tag_text AS tag, tag_url, COUNT(item_id) AS total
FROM phpfox_tag
WHERE category_id = 'video' AND added > 1780910957
GROUP BY tag_text, tag_url
HAVING total > 1
ORDER BY total DESC
LIMIT 10
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_tagrefcategory_id,user_search,user_search_general,category_id_2category_id_277const86Using index condition; Using where; Using temporary; Using filesort
0.0001209 | Memory Before: 16.15 Mb | Memory After: 16.15 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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
Session
Array
(
    [session] => 7c9cc8755b999eafcf005809e08f9016
    [redirect] => /video/show_18/sort_most-viewed/when_all-time/page_4/
    [socialintegration_pageId] => 68
)
Cookie
TOP