Богатые тоже плачут

phpFox Developers Debug Toggle JavaScript Console

Total Time:
0.0390980
PHP General Time:
0.0256191

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

Total Memory Usage:
753.23 Kb
Total Memory Usage (Including Debug):
829.92 Kb
Memory Limit:
64 Mb (128M)

Load Balancing Enabled:
No
Requests From:
77.222.55.249


Server Time Stamp:
September 27, 2022, 1:47 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.0003278 | Memory Before: 468.48 Kb | Memory After: 485.34 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.0008461 | Memory Before: 549.62 Kb | Memory After: 566.61 Kb | Memory Used: 16.99 Kb | Rows: 1 | Slave: Yes
SELECT f.friend_id AS is_friend, 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, p.*, pi.*, pa.name AS album_url, pa.name AS album_title, pa.profile_id AS album_profile_id, pt.item_id AS is_viewed, lik.like_id AS is_liked
FROM phpfox_photo AS p
     LEFT JOIN phpfox_friend AS f
            ON(f.user_id = p.user_id AND f.friend_user_id = 0)
     JOIN phpfox_user AS u
            ON(u.user_id = p.user_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p.photo_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p.album_id)
     LEFT JOIN phpfox_photo_track AS pt
            ON(pt.item_id = p.photo_id AND pt.user_id = 0)
     LEFT JOIN phpfox_like AS lik
            ON(lik.type_id = 'photo' AND lik.item_id = p.photo_id AND lik.user_id = 0)

WHERE p.photo_id = 519
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEp constPRIMARY,photo_id,photo_id_2,user_idPRIMARY4const1100.00 
1SIMPLEf constuser_check,user_id,top_friend,friend_user_iduser_check8const,const 0.00unique row not found
1SIMPLEu constPRIMARY,user_idPRIMARY4const1100.00 
1SIMPLEpi constphoto_idphoto_id4const1100.00 
1SIMPLEpa constPRIMARY,album_idPRIMARY4const 0.00unique row not found
1SIMPLEpt refitem_iditem_id8const,const1100.00Using index
1SIMPLElik refuser_id,item_id,type_iduser_id4const1100.00Using where
0.0001788 | Memory Before: 555.56 Kb | Memory After: 572.42 Kb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name
FROM phpfox_photo_category_data AS pcd
     JOIN phpfox_photo_category AS pc
            ON(pc.category_id = pcd.category_id)

WHERE pcd.photo_id = 519
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLE   MISSING KEY      no matching row in const table
0.0005109 | Memory Before: 570.23 Kb | Memory After: 587.1 Kb | Memory Used: 16.88 Kb | Rows: 1 | Slave: Yes
SELECT p.*, pu.vanity_url, pg.name AS category_name, pg.page_type, l.like_id AS is_liked
FROM phpfox_pages AS p
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
            ON(pg.category_id = p.category_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages' AND l.item_id = p.page_id AND l.user_id = 0)

WHERE p.page_id = 29
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEp constPRIMARY,page_idPRIMARY4const1100.00 
1SIMPLEpu refpage_idpage_id4const1100.00 
1SIMPLEpg constPRIMARY,category_idPRIMARY3const1100.00 
1SIMPLEl refuser_id,item_id,type_iduser_id4const1100.00Using where
0.0002668 | Memory Before: 569.52 Kb | Memory After: 586.63 Kb | Memory Used: 17.11 Kb | Rows: 14 | Slave: Yes
SELECT *
FROM phpfox_pages_perm
WHERE page_id = 29
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEphpfox_pages_perm refpage_idpage_id4const13100.00 
0.0004079 | Memory Before: 573.73 Kb | Memory After: 590.6 Kb | Memory Used: 16.88 Kb | Rows: 1 | Slave: Yes
SELECT p.*, pu.vanity_url, pg.name AS category_name, pg.page_type, l.like_id AS is_liked
FROM phpfox_pages AS p
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
            ON(pg.category_id = p.category_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages' AND l.item_id = p.page_id AND l.user_id = 0)

WHERE p.page_id = 29
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEp constPRIMARY,page_idPRIMARY4const1100.00 
1SIMPLEpu refpage_idpage_id4const1100.00 
1SIMPLEpg constPRIMARY,category_idPRIMARY3const1100.00 
1SIMPLEl refuser_id,item_id,type_iduser_id4const1100.00Using where
0.0005639 | Memory Before: 583.77 Kb | Memory After: 600.76 Kb | Memory Used: 16.99 Kb | Rows: 1 | Slave: Yes
SELECT f.friend_id AS is_friend, 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, p.*, pi.*, pa.name AS album_url, pa.name AS album_title, pa.profile_id AS album_profile_id, pt.item_id AS is_viewed, lik.like_id AS is_liked
FROM phpfox_photo AS p
     LEFT JOIN phpfox_friend AS f
            ON(f.user_id = p.user_id AND f.friend_user_id = 0)
     JOIN phpfox_user AS u
            ON(u.user_id = p.user_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p.photo_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p.album_id)
     LEFT JOIN phpfox_photo_track AS pt
            ON(pt.item_id = p.photo_id AND pt.user_id = 0)
     LEFT JOIN phpfox_like AS lik
            ON(lik.type_id = 'photo' AND lik.item_id = p.photo_id AND lik.user_id = 0)

WHERE p.photo_id = 519
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEp constPRIMARY,photo_id,photo_id_2,user_idPRIMARY4const1100.00 
1SIMPLEf constuser_check,user_id,top_friend,friend_user_iduser_check8const,const 0.00unique row not found
1SIMPLEu constPRIMARY,user_idPRIMARY4const1100.00 
1SIMPLEpi constphoto_idphoto_id4const1100.00 
1SIMPLEpa constPRIMARY,album_idPRIMARY4const 0.00unique row not found
1SIMPLEpt refitem_iditem_id8const,const1100.00Using index
1SIMPLElik refuser_id,item_id,type_iduser_id4const1100.00Using where
0.0001509 | Memory Before: 588.42 Kb | Memory After: 605.28 Kb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name
FROM phpfox_photo_category_data AS pcd
     JOIN phpfox_photo_category AS pc
            ON(pc.category_id = pcd.category_id)

WHERE pcd.photo_id = 519
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLE   MISSING KEY      no matching row in const table
0.0028789 | Memory Before: 589.04 Kb | Memory After: 606.08 Kb | Memory Used: 17.04 Kb | Rows: 4 | Slave: Yes
SELECT p.*
FROM phpfox_photo AS p
WHERE p.photo_id NOT IN (519) AND p.module_id = 'pages' AND p.group_id = 29
ORDER BY RAND()
LIMIT 4
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEp ALLPRIMARY,photo_id,photo_id_2   45541.00Using where; Using temporary; Using filesort
0.0010591 | Memory Before: 594.2 Kb | Memory After: 611.07 Kb | Memory Used: 16.88 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS photo
     JOIN phpfox_user AS u
            ON(u.user_id = photo.user_id)

WHERE photo.photo_id > 519 AND photo.module_id = 'pages' AND photo.group_id = 29 AND ((photo.privacy = 0) AND photo.privacy = 0 AND photo.view_id = 0)
LIMIT 1
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEphoto refPRIMARY,photo_id,view_id_2,photo_id_2,view_id,privacy,view_id_3,view_id_5,user_idview_id_35const,const729.78Using where
1SIMPLEu eq_refPRIMARY,user_idPRIMARY4danfa.photo.user_id1100.00Using index
0.0017271 | Memory Before: 595.22 Kb | Memory After: 629.45 Kb | Memory Used: 34.23 Kb | Rows: 74 | Slave: Yes
SELECT photo.*
FROM phpfox_photo AS photo
     JOIN phpfox_user AS u
            ON(u.user_id = photo.user_id)

WHERE photo.photo_id > 519 AND photo.module_id = 'pages' AND photo.group_id = 29 AND ((photo.privacy = 0) AND photo.privacy = 0 AND photo.view_id = 0)
ORDER BY photo.photo_id ASC
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEphoto refPRIMARY,photo_id,view_id_2,photo_id_2,view_id,privacy,view_id_3,view_id_5,user_idview_id_35const,const729.78Using index condition; Using where; Using filesort
1SIMPLEu eq_refPRIMARY,user_idPRIMARY4danfa.photo.user_id1100.00Using index
0.0009260 | Memory Before: 598.12 Kb | Memory After: 614.99 Kb | Memory Used: 16.88 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS photo
     JOIN phpfox_user AS u
            ON(u.user_id = photo.user_id)

WHERE photo.photo_id < 519 AND photo.module_id = 'pages' AND photo.group_id = 29 AND ((photo.privacy = 0) AND photo.privacy = 0 AND photo.view_id = 0)
LIMIT 1
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEphoto refPRIMARY,photo_id,view_id_2,photo_id_2,view_id,privacy,view_id_3,view_id_5,user_idview_id_35const,const720.22Using where
1SIMPLEu eq_refPRIMARY,user_idPRIMARY4danfa.photo.user_id1100.00Using index
0.0011799 | Memory Before: 599.14 Kb | Memory After: 616.43 Kb | Memory Used: 17.29 Kb | Rows: 19 | Slave: Yes
SELECT photo.*
FROM phpfox_photo AS photo
     JOIN phpfox_user AS u
            ON(u.user_id = photo.user_id)

WHERE photo.photo_id < 519 AND photo.module_id = 'pages' AND photo.group_id = 29 AND ((photo.privacy = 0) AND photo.privacy = 0 AND photo.view_id = 0)
ORDER BY photo.photo_id DESC
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEphoto refPRIMARY,photo_id,view_id_2,photo_id_2,view_id,privacy,view_id_3,view_id_5,user_idview_id_35const,const720.22Using index condition; Using where; Using filesort
1SIMPLEu eq_refPRIMARY,user_idPRIMARY4danfa.photo.user_id1100.00Using index
0.0002420 | Memory Before: 603.25 Kb | Memory After: 620.11 Kb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT p.user_id AS photo_owner_id, pt.tag_id, pt.user_id AS post_user_id, pt.content, pt.position_x, pt.position_y, pt.width, pt.height, 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_photo_tag AS pt
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = pt.tag_user_id)
     JOIN phpfox_photo AS p
            ON(p.photo_id = pt.photo_id)

WHERE pt.photo_id = 519
/* OO Query */
IdSelect TypeTablePartitionsTypePossible KeysKeyKey LenRefRowsFilteredExtra
1SIMPLEp constPRIMARY,photo_id,photo_id_2PRIMARY4const1100.00 
1SIMPLEpt refphoto_id,photo_id_2,photo_id_3,photo_id_4photo_id4const1100.00 
1SIMPLEu eq_refPRIMARY,user_idPRIMARY4danfa.pt.tag_user_id1100.00 
0.0004382 | Memory Before: 609.02 Kb | Memory After: 625.88 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 = 'photo.view' 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.0002902 | Memory Before: 610.33 Kb | Memory After: 627.19 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 = 'photo' 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.0004802 | Memory Before: 611.45 Kb | Memory After: 628.43 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.0003979 | Memory Before: 672.7 Kb | Memory After: 689.55 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.0003052 | Memory Before: 674.47 Kb | Memory After: 691.33 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.0003011 | Memory Before: 676.34 Kb | Memory After: 693.2 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
Array
(
    [redirect] => /photo/519/
)