Руслан


Новостей нет.
phpFox Developers Debug Toggle JavaScript Console

Total Time:
0.1238890
PHP General Time:
0.1136441

Driver Version:
MySQL 5.7.39-0ubuntu0.18.04.2
SQL Time:
0.0102449
SQL Queries:
22
SQL Memory Usage:
392.19 Kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
878.23 Kb
Total Memory Usage (Including Debug):
957.48 Kb
Memory Limit:
64 Mb (128M)

Load Balancing Enabled:
No
Requests From:
77.222.55.249


Server Time Stamp:
September 27, 2022, 1:44 pm
PHP Version:
8.1.6
PHP Sapi:
fpm-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux

Cache:
file
SQL Queries
0.0003901 | Memory Before: 468.49 Kb | Memory After: 485.35 Kb | Memory Used: 16.86 Kb | Rows: 0 | 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 TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLE   MISSING KEY      no matching row in const table
0.0007670 | Memory Before: 545.59 Kb | Memory After: 578.85 Kb | Memory Used: 33.27 Kb | Rows: 1 | Slave: Yes
SELECT u.*, user_field.*, ls.user_id AS is_online, ug.prefix, ug.suffix, ug.icon_ext, ug.title, uf.user_id as is_featured, p.photo_id as cover_photo_exists
FROM phpfox_user AS u
     JOIN phpfox_user_group AS ug
            ON(ug.user_group_id = u.user_group_id)
     JOIN phpfox_user_field AS user_field
            ON(user_field.user_id = u.user_id)
     LEFT JOIN phpfox_user_featured AS uf
            ON(uf.user_id = u.user_id)
     LEFT JOIN phpfox_session AS ls
            ON(ls.user_id = u.user_id)
     LEFT JOIN phpfox_photo AS p
            ON(p.photo_id = user_field.cover_photo)

WHERE u.user_name = 'profile-768'
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEuf systemPRIMARY    0.00const row not found
1SIMPLEu refPRIMARY,user_name,user_group_id,user_iduser_name303const1100.00 
1SIMPLEug eq_refPRIMARY,user_group_idPRIMARY1danfa.u.user_group_id1100.00Using index condition
1SIMPLEuser_field eq_refuser_iduser_id4danfa.u.user_id1100.00 
1SIMPLEls eq_refuser_id,user_id_2user_id4danfa.u.user_id1100.00Using index
1SIMPLEp eq_refPRIMARY,photo_id,photo_id_2PRIMARY4danfa.user_field.cover_photo1100.00Using index
0.0002120 | Memory Before: 557.39 Kb | Memory After: 574.25 Kb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 768 AND is_expired = 0
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEphpfox_ban_data ALLMISSING KEY    147.14Using where
0.0004759 | Memory Before: 571.83 Kb | Memory After: 592.69 Kb | Memory Used: 20.86 Kb | Rows: 244 | Slave: No
SELECT country_iso, name
FROM phpfox_country
ORDER BY ordering ASC, name ASC
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEphpfox_country ALLMISSING KEY    244100.00Using filesort
0.0002260 | Memory Before: 610.15 Kb | Memory After: 627.05 Kb | Memory Used: 16.91 Kb | Rows: 3 | Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 768
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEphpfox_user_privacy refuser_id,user_id_2user_id4const2100.00 
0.0001550 | Memory Before: 611.92 Kb | Memory After: 628.82 Kb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_user_blocked
WHERE block_user_id = 0
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEphpfox_user_blocked ALLMISSING KEY    425.00Using where
0.0002041 | Memory Before: 659.28 Kb | Memory After: 676.14 Kb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_user_design_order
WHERE user_id = 768
ORDER BY ordering ASC
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEphpfox_user_design_order refuser_iduser_id4const1100.00Using index condition; Using filesort
0.0003791 | Memory Before: 664.64 Kb | Memory After: 681.5 Kb | Memory Used: 16.86 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 = 'profile.index' AND m.is_active = 1
GROUP BY m.menu_id, mo.module_id
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEm refm_connection,parent_idm_connection229const,const188.24Using index condition; Using where; Using temporary; Using filesort
1SIMPLEp refis_active,product_active,product_idis_active1const150.00Using where
1SIMPLEmo refis_active,module_id,module_is_activemodule_is_active303func,const3100.00Using where; Using index
0.0004890 | Memory Before: 665.95 Kb | Memory After: 682.9 Kb | Memory Used: 16.95 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 = 'profile' AND m.is_active = 1
GROUP BY m.menu_id, mo.module_id
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEp refis_active,product_active,product_idis_active1const1100.00Using temporary; Using filesort
1SIMPLEm refm_connection,parent_idm_connection229const,const688.24Using where
1SIMPLEmo refis_active,module_id,module_is_activemodule_is_active303func,const3100.00Using where; Using index
0.0004911 | Memory Before: 677.39 Kb | Memory After: 694.38 Kb | Memory Used: 16.98 Kb | Rows: 7 | 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 TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEm rangeparent_idparent_id3 810.00Using index condition; Using where; Using filesort
1SIMPLEp refis_active,product_active,product_idis_active1const150.00Using where
1SIMPLEmo refis_active,module_id,module_is_activemodule_is_active303func,const3100.00Using where; Using index
0.0005710 | Memory Before: 725.33 Kb | Memory After: 742.19 Kb | Memory Used: 16.86 Kb | Rows: 0 | 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 = 'theme' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'ru'
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEm refis_active,module_id,module_is_activemodule_id302const191.43Using where
1SIMPLEproduct refis_active,product_active,product_idis_active1const1100.00 
1SIMPLEp reflanguage_id,module_id,setting_listmodule_id303const4205.46Using index condition; Using where
0.0003471 | Memory Before: 727.1 Kb | Memory After: 743.96 Kb | Memory Used: 16.86 Kb | Rows: 0 | 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 = 'theme' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'ru'
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEm refis_active,module_id,module_is_activemodule_id302const191.43Using where
1SIMPLEproduct refis_active,product_active,product_idis_active1const1100.00 
1SIMPLEp reflanguage_id,module_id,setting_listmodule_id303const4205.46Using index condition; Using where
0.0002999 | Memory Before: 730.22 Kb | Memory After: 747.08 Kb | Memory Used: 16.86 Kb | Rows: 0 | 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 = 'theme' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'ru'
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEm refis_active,module_id,module_is_activemodule_id302const191.43Using where
1SIMPLEproduct refis_active,product_active,product_idis_active1const1100.00 
1SIMPLEp reflanguage_id,module_id,setting_listmodule_id303const4205.46Using index condition; Using where
0.0002551 | Memory Before: 751.39 Kb | Memory After: 768.25 Kb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT var_name, user_value
FROM phpfox_component_setting
WHERE user_id = 768
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEphpfox_component_setting refuser_id,user_id_2user_id4const1100.00 
0.0007010 | Memory Before: 761.56 Kb | Memory After: 778.42 Kb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT uf.dob_setting, friend.friend_id, friend.friend_user_id, friend.is_top_friend, friend.time_stamp, 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.originality, u.last_activity
FROM phpfox_friend AS friend
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 768) AS sf
            ON(sf.friend_user_id = friend.friend_user_id)
     JOIN phpfox_user AS u
            ON(u.user_id = friend.friend_user_id AND u.status_id = 0 AND u.view_id = 0)
     JOIN phpfox_user_field AS uf
            ON(u.user_id = uf.user_id)

WHERE friend.is_page = 0 AND friend.user_id = 768
ORDER BY friend.is_top_friend DESC , friend.ordering ASC, RAND()
LIMIT 6
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEfriend refuser_check,user_id,top_friend,friend_user_id,is_page,is_page_2is_page5const,const1100.00Using temporary; Using filesort
1SIMPLEphpfox_friend eq_refuser_check,user_id,top_friend,friend_user_id,is_page,is_page_2user_check8const,danfa.friend.friend_user_id147.05Using where
1SIMPLEu eq_refPRIMARY,user_status,status_id,public_feed,user_idPRIMARY4danfa.friend.friend_user_id19.97Using where
1SIMPLEuf eq_refuser_iduser_id4danfa.friend.friend_user_id1100.00 
0.0008328 | Memory Before: 806.98 Kb | Memory After: 823.84 Kb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT feed.*, 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.originality, u.last_activity
FROM (
( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.type_id = 'friend' AND feed.user_id = 768
/* OO Query */) UNI             ON ( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.privacy IN (0) AND type_id = 'feed_comment' AND feed.user_id = 768
/* OO Query */) UNI             ON ( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.privacy IN (0) AND feed.user_id = 768
/* OO Query */) UNI             ON ( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.privacy IN (0) AND feed.parent_user_id = 768
/* OO Query */)) AS feed
     JOIN phpfox_user AS u
            ON(u.user_id = feed.user_id)

WHERE feed.privacy IN (0)
ORDER BY feed.time_stamp DESC
LIMIT 15
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1PRIMARY<derived2> ref<auto_key0><auto_key0>1const2100.00Using where; Using filesort
1PRIMARYu eq_refPRIMARY,user_idPRIMARY4feed.user_id1100.00 
2DERIVEDfeed reftype_id,user_idtype_id302const15.00Using where
3UNIONfeed refprivacy_2,privacy_3,privacy_4,type_id,privacy,privacy_5,user_idprivacy_35const,const15.00Using where
4UNIONfeed refprivacy_2,privacy_3,privacy_4,privacy,privacy_5,user_idprivacy_35const,const1100.00 
5UNIONfeed refprivacy_2,privacy_3,privacy_4,privacy,privacy_5privacy_45const,const1100.00 
 UNION RESULT<union2,3,4,5> ALLMISSING KEY      Using temporary
0.0005858 | Memory Before: 808.54 Kb | Memory After: 825.4 Kb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT feed.*, 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.originality, u.last_activity
FROM (
( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.type_id = 'friend' AND feed.user_id = 768
/* OO Query */) UNI             ON ( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.privacy IN (0) AND type_id = 'feed_comment' AND feed.user_id = 768
/* OO Query */) UNI             ON ( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.privacy IN (0) AND feed.user_id = 768
/* OO Query */) UNI             ON ( SELECT feed.*
FROM phpfox_feed AS feed
WHERE feed.privacy IN (0) AND feed.parent_user_id = 768
/* OO Query */)) AS feed
     JOIN phpfox_user AS u
            ON(u.user_id = feed.user_id)

WHERE feed.privacy IN (0)
ORDER BY feed.time_stamp DESC
LIMIT 15 OFF SET 15
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1PRIMARY<derived2> ref<auto_key0><auto_key0>1const2100.00Using where; Using filesort
1PRIMARYu eq_refPRIMARY,user_idPRIMARY4feed.user_id1100.00 
2DERIVEDfeed reftype_id,user_idtype_id302const15.00Using where
3UNIONfeed refprivacy_2,privacy_3,privacy_4,type_id,privacy,privacy_5,user_idprivacy_35const,const15.00Using where
4UNIONfeed refprivacy_2,privacy_3,privacy_4,privacy,privacy_5,user_idprivacy_35const,const1100.00 
5UNIONfeed refprivacy_2,privacy_3,privacy_4,privacy,privacy_5privacy_45const,const1100.00 
 UNION RESULT<union2,3,4,5> ALLMISSING KEY      Using temporary
0.0003159 | Memory Before: 814.8 Kb | Memory After: 831.66 Kb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT count(f.user_id)
FROM phpfox_friend AS f
     JOIN phpfox_friend AS sf
            ON(sf.friend_user_id = f.friend_user_id AND sf.user_id = 768)
     JOIN phpfox_user AS u
            ON(u.user_id = f.friend_user_id)

WHERE f.is_page = 0 AND f.user_id = 0
GROUP BY f.friend_user_id
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEf refuser_check,user_id,top_friend,friend_user_id,is_page,is_page_2user_check4const147.05Using index condition; Using where
1SIMPLEsf eq_refuser_check,user_id,top_friend,friend_user_iduser_check8const,danfa.f.friend_user_id1100.00Using index
1SIMPLEu eq_refPRIMARY,user_idPRIMARY4danfa.f.friend_user_id1100.00Using index
0.0004179 | Memory Before: 815.98 Kb | Memory After: 832.84 Kb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.originality, u.last_activity
FROM phpfox_friend AS f
     JOIN phpfox_friend AS sf
            ON(sf.friend_user_id = f.friend_user_id AND sf.user_id = 768)
     JOIN phpfox_user AS u
            ON(u.user_id = f.friend_user_id)

WHERE f.is_page = 0 AND f.user_id = 0
GROUP BY f.friend_user_id
ORDER BY f.time_stamp DESC
LIMIT 7
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEf refuser_check,user_id,top_friend,friend_user_id,is_page,is_page_2user_check4const147.05Using index condition; Using where; Using temporary; Using filesort
1SIMPLEsf eq_refuser_check,user_id,top_friend,friend_user_iduser_check8const,danfa.f.friend_user_id1100.00Using index
1SIMPLEu eq_refPRIMARY,user_idPRIMARY4danfa.f.friend_user_id1100.00 
0.0002999 | Memory Before: 819.62 Kb | Memory After: 836.7 Kb | Memory Used: 17.09 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_blog AS b
     JOIN phpfox_user AS u
            ON(u.user_id = b.user_id)

WHERE b.user_id = 768 AND b.post_status = 1
ORDER BY b.time_stamp DESC
LIMIT 3
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEu constPRIMARY,user_idPRIMARY4const1100.00 
1SIMPLEb refuser_id_2,user_iduser_id4const110.00Using where
0.0015922 | Memory Before: 822.62 Kb | Memory After: 839.78 Kb | Memory Used: 17.16 Kb | Rows: 5 | Slave: Yes
SELECT *
FROM phpfox_forum_thread AS ft
     JOIN phpfox_user AS u
            ON(u.user_id = ft.user_id)

WHERE ft.user_id = 768
ORDER BY ft.time_update DESC
LIMIT 5
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEu constPRIMARY,user_idPRIMARY4const1100.00Using filesort
1SIMPLEft ALLMISSING KEY    303410.00Using where
0.0002370 | Memory Before: 860.23 Kb | Memory After: 877.13 Kb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_video
WHERE user_id = 768
ORDER BY time_stamp DESC
LIMIT 2
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEphpfox_video refuser_iduser_id4const1100.00Using index condition; Using filesort
Array
(
    [redirect] => /profile-768/
)