# 121.8s user time, 6.9s system time, 45.75M rss, 116.70M vsz # Current date: Wed Mar 10 15:03:33 2021 # Hostname: logstorage.******.ru # Files: /dev/fd/63 # Overall: 14.82k total, 793 unique, 0.27 QPS, 1.41x concurrency _________ # Time range: 2021-03-09T21:00:05 to 2021-03-10T11:58:45 # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 75954s 2s 79s 5s 9s 2s 5s # Lock time 7s 0 2s 443us 194us 19ms 138us # Rows sent 11.81M 0 4.27M 835.63 2.90 45.11k 0.99 # Rows examine 543.13M 0 4.27M 37.52k 36.57k 81.62k 36.57k # Rows affecte 31.45k 0 16.01k 2.17 0 162.07 0 # Bytes sent 1.06G 11 174.89M 73.90k 15.20k 1.78M 65.89 # Query size 20.34M 0 40.61k 920.86 2.06k 778.63 1012.63 # Profile # Rank Query ID Response time Calls R/Call V/M Item # ==== ================== ================ ===== ====== ===== ============ # 1 0x1F4EE42DDDE93EFE 19338.4165 25.5% 3576 5.4078 0.67 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 2 0x39B83B51F529D118 18616.2064 24.5% 3450 5.3960 0.67 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 3 0xE9800998ECF8427E 15542.2356 20.5% 2998 5.1842 0.97 # 4 0x3EF8072A1A8092AE 3483.8039 4.6% 653 5.3351 0.65 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 5 0x5872FE3AEF48D810 3173.1605 4.2% 603 5.2623 0.95 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 6 0x64C02B1AC2A388CA 1890.7559 2.5% 614 3.0794 0.02 SELECT modzzz_articles_main Profiles # 7 0x500E07F99D733A76 1621.4427 2.1% 530 3.0593 0.02 SELECT modzzz_articles_main Profiles # 8 0xF39B73C76FF04FBF 1071.2406 1.4% 197 5.4378 0.62 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 9 0x8D752C1D147240A2 863.3056 1.1% 165 5.2322 0.78 # 10 0xCDB648903A3F252A 848.0497 1.1% 160 5.3003 0.72 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 11 0xF822AC4AD3192113 587.1561 0.8% 106 5.5392 0.76 SELECT bx_photos_main sys_albums_objects sys_albums Profiles bx_photos_main sys_albums_objects sys_albums Profiles # 12 0x6DD3696BDCADF86A 547.1450 0.7% 99 5.5267 0.58 SELECT bx_photos_main sys_albums_objects sys_albums Profiles bx_photos_main sys_albums_objects sys_albums Profiles # 13 0x0DA38BE1A8193154 500.4249 0.7% 88 5.6866 0.72 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 14 0xBC22ECB0AAFD2D54 464.9376 0.6% 78 5.9607 0.60 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 15 0x29D9EFFEC1AABFA5 447.4401 0.6% 88 5.0845 0.57 SELECT bx_photos_main sys_albums_objects sys_albums Profiles bx_photos_main sys_albums_objects sys_albums Profiles # 16 0xE089E155EAD04722 378.0568 0.5% 122 3.0988 0.02 SELECT modzzz_articles_main Profiles # 17 0xDE5CD663B39D138E 317.0414 0.4% 64 4.9538 0.57 SELECT bx_photos_main sys_albums_objects sys_albums Profiles bx_photos_main sys_albums_objects sys_albums Profiles # 18 0xF57AEF67D1E35025 271.7452 0.4% 44 6.1760 0.84 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 19 0x3646CB46F7452DF6 264.6494 0.3% 93 2.8457 0.23 SELECT modzzz_articles_main Profiles # 20 0x1392CE8929BE2998 262.6440 0.3% 41 6.4060 2.09 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 21 0xB4AFB5698472C265 228.5954 0.3% 75 3.0479 0.01 SELECT modzzz_articles_main Profiles # 22 0xFFB4C303CFFF024A 187.6233 0.2% 31 6.0524 0.77 SELECT bx_photos_main sys_albums_objects sys_albums Profiles bx_photos_main sys_albums_objects sys_albums Profiles # 23 0x5D501F66106CFDA5 144.1031 0.2% 23 6.2654 0.58 SELECT bx_photos_main sys_albums_objects sys_albums Profiles bx_photos_main sys_albums_objects sys_albums Profiles # 24 0xC0AF1B4495949D2F 140.8841 0.2% 23 6.1254 0.71 SELECT bx_photos_main sys_albums_objects sys_albums Profiles bx_photos_main sys_albums_objects sys_albums Profiles # 25 0x1776D44B552F1F62 122.2919 0.2% 27 4.5293 0.49 # 26 0xC5DAA19943AFF9F0 115.1356 0.2% 38 3.0299 0.01 SELECT modzzz_articles_main Profiles # 27 0x787B5535BE5DB982 103.9513 0.1% 22 4.7251 0.39 SELECT bx_photos_main sys_albums_objects sys_albums Profiles bx_photos_main sys_albums_objects sys_albums Profiles # 28 0x14A8A2CC4EECBA20 103.7015 0.1% 15 6.9134 0.73 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 31 0xAC310108DCD1FC76 75.3823 0.1% 10 7.5382 0.49 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 32 0xBD0DF39BEA21EAFE 74.0534 0.1% 24 3.0856 0.01 SELECT modzzz_articles_main Profiles # 33 0x7DC2CB06A7E26562 73.2071 0.1% 24 3.0503 0.01 SELECT modzzz_articles_main Profiles modzzz_articles_main Profiles # 34 0xAA67A47289C5F84F 71.8824 0.1% 23 3.1253 0.01 SELECT modzzz_articles_main Profiles # 35 0xE7B64533273650AD 67.7947 0.1% 19 3.5681 0.22 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 36 0x810CEB43EF44F8FA 66.6212 0.1% 16 4.1638 0.48 SELECT bx_photos_main Profiles sys_albums_objects sys_albums # 37 0x0EE42781FED5A080 66.1638 0.1% 12 5.5136 0.37 SELECT bx_photos_main sys_albums_objects sys_albums Profiles bx_photos_main sys_albums_objects sys_albums Profiles # 39 0x79FF64D3398C63A2 65.6243 0.1% 12 5.4687 0.60 SELECT bx_photos_main sys_albums_objects sys_albums Profiles bx_photos_main sys_albums_objects sys_albums Profiles # 40 0x2C62833C608283CE 64.0982 0.1% 17 3.7705 0.28 SELECT bx_photos_main sys_albums_objects sys_albums Profiles # 43 0x755652FD2C5DE85E 55.0623 0.1% 16 3.4414 0.73 SELECT modzzz_articles_main Profiles # 54 0x19059DB1CCF0F4F8 38.2042 0.1% 12 3.1837 0.58 SELECT modzzz_articles_main Profiles # 55 0x79AE68F192BA9B65 35.7535 0.0% 11 3.2503 0.03 SELECT modzzz_articles_main Profiles # MISC 0xMISC 3358.4709 4.4% 559 6.0080 0.0 <395 ITEMS> # Query 1: 0.07 QPS, 0.36x concurrency, ID 0x1F4EE42DDDE93EFE at byte 54084455 # This item is included in the report because it matches --limit. # Scores: V/M = 0.67 # Time range: 2021-03-09T21:00:29 to 2021-03-10T11:46:18 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 24 3576 # Exec time 25 19338s 2s 19s 5s 9s 2s 5s # Lock time 9 617ms 39us 31ms 172us 194us 616us 138us # Rows sent 0 3.54k 0 12 1.01 0.99 0.27 0.99 # Rows examine 24 134.38M 0 666.68k 38.48k 36.57k 10.50k 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 260.70k 63 1.69k 75.73 62.76 137.90 62.76 # Query size 22 4.57M 982 1.00k 1016.98 1012.63 1.72 1012.63 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Time 2021-03-09... (1/0%), 2021-03-09... (1/0%)... 159 more # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%')\G # Query 2: 0.07 QPS, 0.36x concurrency, ID 0x39B83B51F529D118 at byte 26484374 # This item is included in the report because it matches --limit. # Scores: V/M = 0.67 # Time range: 2021-03-09T21:12:10 to 2021-03-10T11:34:26 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 23 3450 # Exec time 24 18616s 2s 14s 5s 9s 2s 5s # Lock time 10 677ms 55us 23ms 196us 194us 751us 144us # Rows sent 0 10.09k 1 4 2.99 2.90 0.16 2.90 # Rows examine 23 128.81M 19.19k 38.30k 38.23k 36.57k 815.06 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 6.03M 63 233.23k 1.76k 1.69k 3.83k 1.69k # Query size 31 6.34M 1.40k 1.44k 1.44k 1.39k 0 1.39k # String: # Databases ********_ru # Hosts localhost # Last errno 0 (3637/105%), 1160 (1/0%) # Time 2021-03-09... (1/0%), 2021-03-09... (1/0%)... 157 more # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4\G # Query 3: 0.06 QPS, 0.29x concurrency, ID 0xE9800998ECF8427E at byte 37842143 # This item is included in the report because it matches --limit. # Scores: V/M = 0.97 # Time range: 2021-03-09T21:00:18 to 2021-03-10T11:46:21 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 20 2998 # Exec time 20 15542s 2s 48s 5s 9s 2s 5s # Lock time 39 3s 24us 2s 872us 194us 34ms 144us # Rows sent 34 4.12M 0 1.67M 1.41k 2.90 43.71k 0.99 # Rows examine 21 119.29M 0 4.20M 40.74k 36.57k 124.44k 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 36 399.07M 11 174.89M 136.81k 5.20k 3.53M 62.76 # Query size 0 0 0 0 0 0 0 0 # String: # Databases ********_ru # Hosts localhost # Last errno 0 (3280/109%), 1160 (1/0%) # Time 2021-03-09... (1/0%), 2021-03-09... (1/0%)... 106 more # Users libmonster... (3809/127%), root (2/0%) # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # /* No query */\G # Query 4: 0.01 QPS, 0.07x concurrency, ID 0x3EF8072A1A8092AE at byte 26438487 # This item is included in the report because it matches --limit. # Scores: V/M = 0.65 # Time range: 2021-03-09T21:12:07 to 2021-03-10T10:30:52 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 4 653 # Exec time 4 3484s 2s 13s 5s 8s 2s 5s # Lock time 1 102ms 111us 4ms 155us 185us 145us 144us # Rows sent 0 655 1 3 1.00 0.99 0.07 0.99 # Rows examine 4 24.42M 38.30k 38.30k 38.30k 38.30k 0 38.30k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 44.28k 11 1.69k 71.85 62.76 114.84 62.76 # Query size 4 971.53k 1.02k 1.42k 1.07k 1.26k 91.03 1012.63 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%'); SET timestamp=1615364639\G # Query 5: 0.01 QPS, 0.07x concurrency, ID 0x5872FE3AEF48D810 at byte 15857086 # This item is included in the report because it matches --limit. # Scores: V/M = 0.95 # Time range: 2021-03-09T21:12:45 to 2021-03-10T10:30:34 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 4 603 # Exec time 4 3173s 2s 38s 5s 8s 2s 5s # Lock time 1 106ms 59us 13ms 176us 194us 519us 144us # Rows sent 0 1.75k 0 4 2.98 2.90 0.23 2.90 # Rows examine 4 23.54M 19.19k 1.07M 39.97k 36.57k 41.65k 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 1.00M 64 1.87k 1.68k 1.69k 150.70 1.69k # Query size 6 1.30M 1.46k 1.83k 1.53k 1.69k 77.38 1.46k # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Time 2021-03-09... (1/0%), 2021-03-10... (1/0%)... 16 more # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4; SET timestamp=1615362043\G # Query 6: 0.01 QPS, 0.04x concurrency, ID 0x64C02B1AC2A388CA at byte 45893211 # This item is included in the report because it matches --limit. # Scores: V/M = 0.02 # Time range: 2021-03-09T21:00:16 to 2021-03-10T10:13:06 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 4 614 # Exec time 2 1891s 2s 4s 3s 3s 218ms 3s # Lock time 1 75ms 41us 4ms 122us 185us 172us 108us # Rows sent 0 631 0 14 1.03 0.99 0.57 0.99 # Rows examine 1 5.77M 0 11.95k 9.62k 9.80k 584.53 9.33k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 5.70M 11 1.35M 9.47k 62.76 102.06k 62.76 # Query size 1 306.03k 337 646 390.74 487.09 51.86 363.48 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Time 2021-03-09... (1/0%), 2021-03-09... (1/0%)... 15 more # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'modzzz_articles_main'\G # SHOW CREATE TABLE `********_ru`.`modzzz_articles_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE 1 AND `modzzz_articles_main`.`status` ='approved' AND CONCAT(`modzzz_articles_main`.`title`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`categories`) LIKE ('%ИЗ%ИСТОРИИ%ПОЛИТИЧЕСКОЙ%МЫСЛИ%ИТАЛИИ%XVI%в.%')\G # Query 7: 0.01 QPS, 0.03x concurrency, ID 0x500E07F99D733A76 at byte 8200020 # This item is included in the report because it matches --limit. # Scores: V/M = 0.02 # Time range: 2021-03-09T21:00:21 to 2021-03-10T10:42:25 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 530 # Exec time 2 1621s 2s 4s 3s 3s 225ms 3s # Lock time 1 68ms 47us 10ms 128us 144us 413us 103us # Rows sent 0 3.21k 1 14 6.21 13.83 5.67 2.90 # Rows examine 0 4.98M 9.60k 11.08k 9.63k 9.33k 112.46 9.33k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 28 313.44M 11 1.83M 616.05k 1.61M 628.94k 245.21k # Query size 3 827.88k 1.23k 1.53k 1.28k 1.33k 56.86 1.20k # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Time 2021-03-09... (1/0%), 2021-03-09... (1/0%)... 32 more # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'modzzz_articles_main'\G # SHOW CREATE TABLE `********_ru`.`modzzz_articles_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `modzzz_articles_main`.`id` as `id`, `modzzz_articles_main`.`title` as `title`, `modzzz_articles_main`.`uri` as `uri`, `modzzz_articles_main`.`created` as `created`, `modzzz_articles_main`.`when` as `when`, `modzzz_articles_main`.`author_id` as `author_id`, `modzzz_articles_main`.`thumb` as `thumb`, `modzzz_articles_main`.`rate`, `modzzz_articles_main`.`country`, `modzzz_articles_main`.`city`, `modzzz_articles_main`.`anonymous`, `modzzz_articles_main`.`snippet`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`categories`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`video_embed`, `modzzz_articles_main`.`comments_count`, `modzzz_articles_main`.`organization`, `modzzz_articles_main`.`real_author`, `modzzz_articles_main`.`source`, `modzzz_articles_main`.`author_website`, `modzzz_articles_main`.`author_id`, `Profiles`.`NickName` as `NickName` FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE 1 AND `modzzz_articles_main`.`status` ='approved' AND CONCAT(`modzzz_articles_main`.`title`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`categories`) LIKE ('%Решения%Пленума%ЦК%КПСС%-%в%жизнь!%СУХАЯ%ЗЕМЛЯ%У%ВОДЫ%') ORDER BY `modzzz_articles_main`.`when` DESC LIMIT 0, 14\G # Query 8: 0.00 QPS, 0.02x concurrency, ID 0xF39B73C76FF04FBF at byte 24550105 # This item is included in the report because it matches --limit. # Scores: V/M = 0.62 # Time range: 2021-03-09T21:12:10 to 2021-03-10T10:30:44 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 197 # Exec time 1 1071s 2s 11s 5s 8s 2s 5s # Lock time 0 30ms 72us 274us 154us 204us 27us 144us # Rows sent 0 576 1 4 2.92 2.90 0.38 2.90 # Rows examine 1 7.34M 19.19k 38.30k 38.15k 36.57k 1.44k 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 320.73k 64 1.87k 1.60k 1.69k 380.90 1.69k # Query size 2 504.89k 1.51k 1.71k 1.57k 1.61k 66.14 1.53k # String: # Databases ********_ru # Last errno 0 # Time 2021-03-09... (1/0%), 2021-03-10... (1/0%)... 14 more # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G User@Host: ********_ru[********_ru] @ localhost [] Id: 134820260 # Schema: ********_ru Last_errno: 0 Killed: 0 SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4\G # Query 9: 0.00 QPS, 0.02x concurrency, ID 0x8D752C1D147240A2 at byte 26453406 # This item is included in the report because it matches --limit. # Scores: V/M = 0.78 # Time range: 2021-03-09T21:03:30 to 2021-03-10T11:28:28 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 165 # Exec time 1 863s 2s 13s 5s 9s 2s 5s # Lock time 0 25ms 48us 1ms 152us 185us 99us 144us # Rows sent 0 326 1 14 1.98 2.90 1.41 0.99 # Rows examine 1 5.71M 9.60k 215.86k 35.43k 36.57k 16.60k 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 2.97M 63 1.56M 13.44k 1.69k 123.52k 62.76 # Query size 0 79.54k 94 515 209.39 346.17 87.19 202.40 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # User@Host: ********_ru[********_ru] @ localhost [] Id: 134876402 SET timestamp=1615364640\G # Query 10: 0.00 QPS, 0.02x concurrency, ID 0xCDB648903A3F252A at byte 25659577 # This item is included in the report because it matches --limit. # Scores: V/M = 0.72 # Time range: 2021-03-09T21:12:54 to 2021-03-10T10:30:52 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 160 # Exec time 1 848s 2s 12s 5s 9s 2s 5s # Lock time 0 24ms 112us 312us 152us 185us 25us 144us # Rows sent 0 186 1 3 1.16 2.90 0.52 0.99 # Rows examine 1 5.97M 25.33k 38.30k 38.22k 36.57k 953.80 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 27.23k 61 1.69k 160.24 1.69k 388.44 62.76 # Query size 1 294.09k 1.06k 1.49k 1.13k 1.20k 69.88 1.09k # String: # Databases ********_ru # Last errno 0 # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ ## # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G User@Host: ********_ru[********_ru] @ localhost [] Id: 134853806 # Schema: ********_ru Last_errno: 0 Killed: 0 SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%')\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%')\G # Query 11: 0.00 QPS, 0.01x concurrency, ID 0xF822AC4AD3192113 at byte 56839776 # This item is included in the report because it matches --limit. # Scores: V/M = 0.76 # Time range: 2021-03-09T21:13:07 to 2021-03-10T10:28:04 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 106 # Exec time 0 587s 2s 11s 6s 9s 2s 5s # Lock time 0 16ms 114us 260us 152us 185us 24us 144us # Rows sent 0 319 3 4 3.01 2.90 0.10 2.90 # Rows examine 0 3.95M 28.25k 38.30k 38.20k 36.57k 918.79 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 252.62k 1.69k 2.14k 1.70k 1.69k 30.47 1.69k # Query size 3 812.87k 2.91k 3.39k 3.16k 3.19k 76.80 3.04k # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4; # Time: 2021-03-10T10:22:40.523065Z # User@Host: ********_ru[********_ru] @ localhost [] Id: 135527110 # Schema: ********_ru Last_errno: 0 Killed: 0 # Query_time: 10.861699 Lock_time: 0.000156 Rows_sent: 3 Rows_examined: 39218 Rows_affected: 0 # Bytes_sent: 1733 SET timestamp=1615371760; SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4\G # Query 12: 0.00 QPS, 0.01x concurrency, ID 0x6DD3696BDCADF86A at byte 24505945 # This item is included in the report because it matches --limit. # Scores: V/M = 0.58 # Time range: 2021-03-09T21:15:37 to 2021-03-10T10:30:14 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 99 # Exec time 0 547s 2s 11s 6s 8s 2s 5s # Lock time 0 16ms 112us 1ms 159us 185us 102us 138us # Rows sent 0 99 1 1 1 1 0 1 # Rows examine 0 3.70M 38.27k 38.30k 38.30k 36.57k 0 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 6.31k 63 64 63.99 62.76 0 62.76 # Query size 2 456.95k 2.01k 2.53k 2.26k 2.27k 80.80 2.27k # String: # Databases ********_ru # Last errno 0 # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%'); # Time: 2021-03-10T08:16:03.899718Z # User@Host: ********_ru[********_ru] @ localhost [] Id: 134815281 # Query_time: 10.703820 Lock_time: 0.000147 Rows_sent: 1 Rows_examined: 39218 Rows_affected: 0 # Bytes_sent: 64 # Bytes_sent: 64 SET timestamp=1615364163; SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%')\G # Query 13: 0.00 QPS, 0.02x concurrency, ID 0x0DA38BE1A8193154 at byte 26548132 # This item is included in the report because it matches --limit. # Scores: V/M = 0.72 # Time range: 2021-03-10T03:17:25 to 2021-03-10T10:30:26 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 88 # Exec time 0 500s 2s 12s 6s 9s 2s 5s # Lock time 0 13ms 110us 237us 150us 185us 23us 144us # Rows sent 0 264 3 3 3 3 0 3 # Rows examine 0 3.29M 38.30k 38.30k 38.30k 38.30k 0 38.30k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 137.08k 1.69k 1.69k 1.69k 1.69k 0 1.69k # Query size 0 154.78k 1.46k 1.55k 1.46k 1.39k 20.45 1.39k # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Time 2021-03-10... (1/1%), 2021-03-10... (1/1%) # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ ### # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4; use ********_ru\G # Query 14: 0.00 QPS, 0.01x concurrency, ID 0xBC22ECB0AAFD2D54 at byte 26520970 # This item is included in the report because it matches --limit. # Scores: V/M = 0.60 # Time range: 2021-03-09T21:00:24 to 2021-03-10T10:30:15 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 78 # Exec time 0 465s 2s 13s 6s 9s 2s 5s # Lock time 0 12ms 112us 215us 148us 194us 23us 138us # Rows sent 0 78 1 1 1 1 0 1 # Rows examine 0 2.92M 38.30k 38.30k 38.30k 38.30k 0 38.30k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 5.26k 64 247 67.30 62.76 22.16 62.76 # Query size 0 115.83k 1.01k 1.11k 1.02k 1.04k 14.72 1012.63 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ ## # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%'); use ********_ru\G # Query 15: 0.00 QPS, 0.01x concurrency, ID 0x29D9EFFEC1AABFA5 at byte 25263046 # This item is included in the report because it matches --limit. # Scores: V/M = 0.57 # Time range: 2021-03-09T21:13:23 to 2021-03-10T10:27:11 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 88 # Exec time 0 447s 2s 11s 5s 8s 2s 5s # Lock time 0 13ms 115us 264us 149us 185us 24us 144us # Rows sent 0 264 3 3 3 3 0 3 # Rows examine 0 3.29M 38.30k 38.30k 38.30k 38.30k 0 38.30k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 174.32k 1.69k 1.69k 1.69k 1.69k 0 1.69k # Query size 2 553.28k 2.46k 2.89k 2.71k 2.76k 69.14 2.62k # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4; # User@Host: ********_ru[********_ru] @ localhost [] Id: 134846362 # Query_time: 11.221176 Lock_time: 0.000136 Rows_sent: 1 Rows_examined: 39218 Rows_affected: 0 # Schema: ********_ru Last_errno: 0 Killed: 0 # Bytes_sent: 64 # Time: 2021-03-10T08:18:44.682212Z SET timestamp=1615364324; SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%')\G # Query 16: 0.00 QPS, 0.01x concurrency, ID 0xE089E155EAD04722 at byte 418686 # This item is included in the report because it matches --limit. # Scores: V/M = 0.02 # Time range: 2021-03-09T21:00:35 to 2021-03-10T10:32:55 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 122 # Exec time 0 378s 3s 5s 3s 3s 262ms 3s # Lock time 0 13ms 40us 262us 102us 176us 48us 93us # Rows sent 0 125 1 4 1.02 0.99 0.26 0.99 # Rows examine 0 1.15M 9.60k 10.34k 9.64k 9.80k 151.06 9.33k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 1.54M 63 1.53M 13.11k 62.76 135.56k 62.76 # Query size 0 84.44k 363 869 467.36 652.75 99.02 441.81 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Time 2021-03-09... (1/0%), 2021-03-10... (1/0%) # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'modzzz_articles_main'\G # SHOW CREATE TABLE `********_ru`.`modzzz_articles_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE 1 AND `modzzz_articles_main`.`status` ='approved' AND CONCAT(`modzzz_articles_main`.`title`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`categories`) LIKE ('%Р.%В.%Кондратенко%'); SET timestamp=1615323635\G # Query 17: 0.00 QPS, 0.01x concurrency, ID 0xDE5CD663B39D138E at byte 25659577 # This item is included in the report because it matches --limit. # Scores: V/M = 0.57 # Time range: 2021-03-09T21:14:46 to 2021-03-10T10:24:26 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 64 # Exec time 0 317s 2s 11s 5s 7s 2s 5s # Lock time 0 9ms 113us 194us 145us 167us 17us 144us # Rows sent 0 64 1 1 1 1 0 1 # Rows examine 0 2.39M 38.30k 38.30k 38.30k 38.30k 0 38.30k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 5.06k 63 64 63.99 62.76 0.00 62.76 # Query size 1 394.37k 2.46k 2.88k 2.72k 2.76k 79.37 2.62k # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%'); # Time: 2021-03-10T08:20:13.792574Z # User@Host: ********_ru[********_ru] @ localhost [] Id: 134851193 # Schema: ********_ru Last_errno: 0 Killed: 0 # Query_time: 11.619568 Lock_time: 0.000330 Rows_sent: 3 Rows_examined: 39218 Rows_affected: 0 # Bytes_sent: 1733 SET timestamp=1615364413; SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4\G # Query 18: 0.00 QPS, 0.01x concurrency, ID 0xF57AEF67D1E35025 at byte 26495644 # This item is included in the report because it matches --limit. # Scores: V/M = 0.84 # Time range: 2021-03-09T21:17:52 to 2021-03-10T10:29:49 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 44 # Exec time 0 272s 3s 13s 6s 11s 2s 5s # Lock time 0 27ms 120us 20ms 611us 185us 3ms 144us # Rows sent 0 133 3 4 3.02 2.90 0.15 2.90 # Rows examine 0 1.64M 28.25k 38.30k 38.07k 36.57k 1.38k 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 154.97k 1.69k 85.58k 3.69k 1.69k 12.52k 1.69k # Query size 0 76.08k 1.48k 1.70k 1.49k 1.46k 35.39 1.46k # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ ###### # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4; use ********_ru; SET timestamp=1615364646\G # Query 19: 0.01 QPS, 0.02x concurrency, ID 0x3646CB46F7452DF6 at byte 55277728 # This item is included in the report because it matches --limit. # Scores: V/M = 0.23 # Time range: 2021-03-10T07:24:29 to 2021-03-10T11:39:23 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 93 # Exec time 0 265s 2s 7s 3s 4s 807ms 3s # Lock time 0 6ms 47us 154us 68us 103us 18us 60us # Rows sent 0 97 1 3 1.04 0.99 0.28 0.99 # Rows examine 0 1.80M 19.19k 38.30k 19.81k 18.47k 3.20k 18.47k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 9.19k 66 1.69k 102.24 65.89 242.96 65.89 # Query size 0 38.60k 308 309 308.78 299.03 0 299.03 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Time 2021-03-10... (1/1%), 2021-03-10... (1/1%)... 5 more # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'modzzz_articles_main'\G # SHOW CREATE TABLE `********_ru`.`modzzz_articles_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE `modzzz_articles_main`.`tags` LIKE '%%' AND `modzzz_articles_main`.`id` !=10238 AND `modzzz_articles_main`.`status` ='approved' AND `modzzz_articles_main`.`allow_view_article_to` ='3'\G # Query 20: 0.00 QPS, 0.01x concurrency, ID 0x1392CE8929BE2998 at byte 39645606 # This item is included in the report because it matches --limit. # Scores: V/M = 2.09 # Time range: 2021-03-10T00:00:10 to 2021-03-10T10:29:50 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 41 # Exec time 0 263s 2s 25s 6s 8s 4s 6s # Lock time 0 6ms 65us 181us 144us 167us 20us 144us # Rows sent 0 49 1 9 1.20 0.99 1.22 0.99 # Rows examine 0 1.79M 38.30k 298.60k 44.65k 36.57k 40.34k 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 2.50k 64 64 64 64 0 64 # Query size 0 48.79k 1.04k 1.05k 1.04k 1012.63 8.50 1012.63 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ ##### # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%'); use ********_ru; SET timestamp=1615367714\G # Query 21: 0.00 QPS, 0.01x concurrency, ID 0xB4AFB5698472C265 at byte 4313436 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.01 # Time range: 2021-03-09T21:03:52 to 2021-03-10T07:48:09 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 75 # Exec time 0 229s 3s 4s 3s 3s 206ms 3s # Lock time 0 8ms 47us 189us 110us 152us 20us 103us # Rows sent 0 563 1 14 7.51 13.83 5.82 4.96 # Rows examine 0 724.48k 9.60k 11.55k 9.66k 9.33k 264.85 9.33k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 5 55.01M 3.90k 1.83M 731.59k 1.61M 631.36k 590.13k # Query size 0 136.89k 1.26k 1.63k 1.33k 1.46k 77.34 1.26k # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'modzzz_articles_main'\G # SHOW CREATE TABLE `********_ru`.`modzzz_articles_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `modzzz_articles_main`.`id` as `id`, `modzzz_articles_main`.`title` as `title`, `modzzz_articles_main`.`uri` as `uri`, `modzzz_articles_main`.`created` as `created`, `modzzz_articles_main`.`when` as `when`, `modzzz_articles_main`.`author_id` as `author_id`, `modzzz_articles_main`.`thumb` as `thumb`, `modzzz_articles_main`.`rate`, `modzzz_articles_main`.`country`, `modzzz_articles_main`.`city`, `modzzz_articles_main`.`anonymous`, `modzzz_articles_main`.`snippet`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`categories`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`video_embed`, `modzzz_articles_main`.`comments_count`, `modzzz_articles_main`.`organization`, `modzzz_articles_main`.`real_author`, `modzzz_articles_main`.`source`, `modzzz_articles_main`.`author_website`, `modzzz_articles_main`.`author_id`, `Profiles`.`NickName` as `NickName` FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE 1 AND `modzzz_articles_main`.`status` ='approved' AND CONCAT(`modzzz_articles_main`.`title`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`categories`) LIKE ('%Проблемы%народного%образования.%НУЖНА%ЛИ%РАБОЧЕМУ%МАТЕМАТИКА?%') ORDER BY `modzzz_articles_main`.`when` DESC LIMIT 0, 14; SET timestamp=1615328883\G # Query 22: 0.00 QPS, 0.00x concurrency, ID 0xFFB4C303CFFF024A at byte 56847955 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.77 # Time range: 2021-03-09T21:18:14 to 2021-03-10T10:30:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 31 # Exec time 0 188s 3s 11s 6s 9s 2s 6s # Lock time 0 5ms 115us 211us 149us 185us 21us 144us # Rows sent 0 93 3 3 3 3 0 3 # Rows examine 0 1.16M 38.30k 38.30k 38.30k 38.30k 0 38.30k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 54.16k 1.69k 1.69k 1.69k 1.69k 0 1.69k # Query size 0 156.34k 2.88k 3.23k 3.01k 3.04k 128.69 2.89k # String: # Databases ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ #### # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4; SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4\G # Query 23: 0.00 QPS, 0.00x concurrency, ID 0x5D501F66106CFDA5 at byte 16977294 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.58 # Time range: 2021-03-09T21:14:46 to 2021-03-10T10:30:06 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 23 # Exec time 0 144s 3s 10s 6s 9s 2s 5s # Lock time 0 5ms 120us 2ms 229us 176us 363us 152us # Rows sent 0 70 3 4 3.04 2.90 0.20 2.90 # Rows examine 0 870.83k 28.25k 38.30k 37.86k 36.57k 1.89k 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Query size 0 118.56k 2.43k 2.80k 2.58k 2.62k 102.80 2.50k # String: # Databases ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ ## # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4; # User@Host: ********_ru[********_ru] @ localhost [] Id: 134671622 # Query_time: 9.954959 Lock_time: 0.000146 Rows_sent: 1 Rows_examined: 39218 Rows_affected: 0 # Schema: ********_ru Last_errno: 0 Killed: 0 # Time: 2021-03-10T07:45:08.070822Z SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%')\G # Query 24: 0.00 QPS, 0.00x concurrency, ID 0xC0AF1B4495949D2F at byte 24494968 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.71 # Time range: 2021-03-10T01:00:09 to 2021-03-10T10:29:23 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 23 # Exec time 0 141s 3s 10s 6s 9s 2s 5s # Lock time 0 6ms 113us 2ms 240us 185us 382us 152us # Rows sent 0 23 1 1 1 1 0 1 # Rows examine 0 880.87k 38.30k 38.30k 38.30k 38.30k 0 38.30k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 1.75k 64 64 64 64 0 64 # Query size 0 99.81k 1.99k 2.33k 2.12k 2.16k 88.25 2.06k # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Time 2021-03-10T08:16:02.983236Z # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ ## # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%'); SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%')\G # Query 25: 0.00 QPS, 0.00x concurrency, ID 0x1776D44B552F1F62 at byte 44635788 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.49 # Time range: 2021-03-09T21:10:24 to 2021-03-10T11:25:14 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 27 # Exec time 0 122s 3s 9s 5s 6s 1s 4s # Lock time 0 4ms 117us 225us 152us 185us 26us 144us # Rows sent 0 50 0 3 1.85 2.90 1.00 0.99 # Rows examine 0 938.41k 0 38.30k 34.76k 36.57k 9.65k 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 35.17k 11 13.79k 1.26k 1.69k 2.54k 62.76 # Query size 0 5.44k 87 288 129.44 234.30 59.32 84.10 # String: # Databases ********_ru # Last errno 0 # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ User@Host: ********_ru[********_ru] @ localhost [] Id: 135253678 use ********_ru\G # Query 26: 0.00 QPS, 0.00x concurrency, ID 0xC5DAA19943AFF9F0 at byte 6523811 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.01 # Time range: 2021-03-09T21:10:14 to 2021-03-10T04:38:57 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 38 # Exec time 0 115s 3s 4s 3s 3s 177ms 3s # Lock time 0 4ms 82us 171us 108us 131us 16us 103us # Rows sent 0 181 1 14 4.76 13.83 5.05 1.96 # Rows examine 0 365.35k 9.60k 9.72k 9.61k 9.33k 0 9.33k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 10.27M 11 1.42M 300.46k 1.26M 422.51k 79.83k # Query size 0 78.58k 1.30k 1.63k 1.40k 1.53k 87.98 1.33k # String: # Databases ********_ru # Last errno 0 # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'modzzz_articles_main'\G # SHOW CREATE TABLE `********_ru`.`modzzz_articles_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G User@Host: ********_ru[********_ru] @ localhost [] Id: 132711250 SELECT `modzzz_articles_main`.`id` as `id`, `modzzz_articles_main`.`title` as `title`, `modzzz_articles_main`.`uri` as `uri`, `modzzz_articles_main`.`created` as `created`, `modzzz_articles_main`.`when` as `when`, `modzzz_articles_main`.`author_id` as `author_id`, `modzzz_articles_main`.`thumb` as `thumb`, `modzzz_articles_main`.`rate`, `modzzz_articles_main`.`country`, `modzzz_articles_main`.`city`, `modzzz_articles_main`.`anonymous`, `modzzz_articles_main`.`snippet`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`categories`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`video_embed`, `modzzz_articles_main`.`comments_count`, `modzzz_articles_main`.`organization`, `modzzz_articles_main`.`real_author`, `modzzz_articles_main`.`source`, `modzzz_articles_main`.`author_website`, `modzzz_articles_main`.`author_id`, `Profiles`.`NickName` as `NickName` FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE 1 AND `modzzz_articles_main`.`status` ='approved' AND CONCAT(`modzzz_articles_main`.`title`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`categories`) LIKE ('%Ольга%ЕРМОЛИНА%') ORDER BY `modzzz_articles_main`.`when` DESC LIMIT 0, 14\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ SELECT `modzzz_articles_main`.`id` as `id`, `modzzz_articles_main`.`title` as `title`, `modzzz_articles_main`.`uri` as `uri`, `modzzz_articles_main`.`created` as `created`, `modzzz_articles_main`.`when` as `when`, `modzzz_articles_main`.`author_id` as `author_id`, `modzzz_articles_main`.`thumb` as `thumb`, `modzzz_articles_main`.`rate`, `modzzz_articles_main`.`country`, `modzzz_articles_main`.`city`, `modzzz_articles_main`.`anonymous`, `modzzz_articles_main`.`snippet`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`categories`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`video_embed`, `modzzz_articles_main`.`comments_count`, `modzzz_articles_main`.`organization`, `modzzz_articles_main`.`real_author`, `modzzz_articles_main`.`source`, `modzzz_articles_main`.`author_website`, `modzzz_articles_main`.`author_id`, `Profiles`.`NickName` as `NickName` FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE 1 AND `modzzz_articles_main`.`status` ='approved' AND CONCAT(`modzzz_articles_main`.`title`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`categories`) LIKE ('%Ольга%ЕРМОЛИНА%') ORDER BY `modzzz_articles_main`.`when` DESC LIMIT 0, 14\G # Query 27: 0.00 QPS, 0.00x concurrency, ID 0x787B5535BE5DB982 at byte 34182143 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.39 # Time range: 2021-03-09T21:18:31 to 2021-03-10T10:22:49 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 22 # Exec time 0 104s 3s 7s 5s 7s 1s 5s # Lock time 0 3ms 115us 208us 156us 185us 23us 156us # Rows sent 0 66 3 3 3 3 0 3 # Rows examine 0 842.57k 38.30k 38.30k 38.30k 38.30k 0 38.30k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 32.16k 1.69k 1.69k 1.69k 1.69k 0 1.69k # Query size 0 99.66k 2.46k 2.80k 2.69k 2.62k 77.50 2.62k # String: # Databases ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4; # Time: 2021-03-10T08:55:11.646238Z # Schema: ********_ru Last_errno: 0 Killed: 0 # User@Host: ********_ru[********_ru] @ localhost [] Id: 135047874 # Query_time: 7.295071 Lock_time: 0.000150 Rows_sent: 1 Rows_examined: 39218 Rows_affected: 0 # Bytes_sent: 64 SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%'); SET timestamp=1615366511\G # Query 28: 0.00 QPS, 0.01x concurrency, ID 0x14A8A2CC4EECBA20 at byte 25436009 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.73 # Time range: 2021-03-10T07:31:57 to 2021-03-10T10:21:19 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 15 # Exec time 0 104s 4s 12s 7s 10s 2s 7s # Lock time 0 2ms 121us 247us 154us 185us 31us 131us # Rows sent 0 15 1 1 1 1 0 1 # Rows examine 0 574.48k 38.30k 38.30k 38.30k 38.30k 0 38.30k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 896 64 64 64 64 0 64 # Query size 0 15.56k 1.04k 1.04k 1.04k 1.04k 0 1.04k # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Time 2021-03-10T09:49:34.685094Z # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ ################ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%'); SET timestamp=1615364365; use ********_ru\G # Query 31: 0.00 QPS, 0.00x concurrency, ID 0xAC310108DCD1FC76 at byte 24486185 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.49 # Time range: 2021-03-09T21:18:39 to 2021-03-10T10:08:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 10 # Exec time 0 75s 3s 10s 8s 9s 2s 8s # Lock time 0 2ms 157us 443us 226us 332us 85us 185us # Rows sent 0 10 1 1 1 1 0 1 # Rows examine 0 382.82k 38.27k 38.31k 38.28k 36.57k 0 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 571 63 64 63.44 62.76 0 62.76 # Query size 0 22.03k 1.67k 1.71k 1.69k 1.69k 25.50 1.69k # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ ####### # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'16258' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%инспектор%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ВАИ%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%генерал-майор%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарной%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%службы%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%В.П.Ветров%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Ветераны%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Тыла%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ВС%')\G # Query 32: 0.00 QPS, 0.00x concurrency, ID 0xBD0DF39BEA21EAFE at byte 3998661 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.01 # Time range: 2021-03-09T21:11:14 to 2021-03-10T11:28:23 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 24 # Exec time 0 74s 3s 3s 3s 3s 142ms 3s # Lock time 0 2ms 47us 172us 98us 152us 41us 86us # Rows sent 0 37 1 14 1.54 0.99 2.57 0.99 # Rows examine 0 235.20k 9.60k 13.51k 9.80k 9.80k 780.07 9.33k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 1.92k 63 66 63.52 62.76 0.55 62.76 # Query size 0 21.96k 413 749 523.02 621.67 87.83 487.09 # String: # Databases ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'modzzz_articles_main'\G # SHOW CREATE TABLE `********_ru`.`modzzz_articles_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G User@Host: ********_ru[********_ru] @ localhost [] Id: 131942275 SELECT COUNT(*) FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE 1 AND `modzzz_articles_main`.`status` ='approved' AND CONCAT(`modzzz_articles_main`.`title`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`categories`) LIKE ('%Игорь%ЯДЫКИН%')\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE 1 AND `modzzz_articles_main`.`status` ='approved' AND CONCAT(`modzzz_articles_main`.`title`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`categories`) LIKE ('%Игорь%ЯДЫКИН%')\G # Query 33: 0.00 QPS, 0.00x concurrency, ID 0x7DC2CB06A7E26562 at byte 8895262 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.01 # Time range: 2021-03-09T21:02:27 to 2021-03-10T06:56:40 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 24 # Exec time 0 73s 3s 3s 3s 3s 204ms 3s # Lock time 0 2ms 42us 223us 99us 152us 45us 95us # Rows sent 0 24 1 1 1 1 0 1 # Rows examine 0 232.00k 9.60k 10.42k 9.67k 9.33k 213.95 9.33k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 1.55k 63 65 63.36 62.76 0 62.76 # Query size 0 98.52k 1.63k 2.13k 1.93k 2.06k 100.35 1.86k # String: # Databases ********_ru # Last errno 0 # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'modzzz_articles_main'\G # SHOW CREATE TABLE `********_ru`.`modzzz_articles_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE 1 AND `modzzz_articles_main`.`status` ='approved' AND CONCAT(`modzzz_articles_main`.`title`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`categories`) LIKE ('%Обсуждение%первого%тома%учебника%новой%истории%колониальных%и%зависимых%стран%'); # Time: 2021-03-10T04:03:22.375498Z # User@Host: ********_ru[********_ru] @ localhost [] Id: 133231235 # Schema: ********_ru Last_errno: 0 Killed: 0 # Query_time: 3.448743 Lock_time: 0.000106 Rows_sent: 2 Rows_examined: 9833 Rows_affected: 0 # Bytes_sent: 177502 SET timestamp=1615349002; SELECT `modzzz_articles_main`.`id` as `id`, `modzzz_articles_main`.`title` as `title`, `modzzz_articles_main`.`uri` as `uri`, `modzzz_articles_main`.`created` as `created`, `modzzz_articles_main`.`when` as `when`, `modzzz_articles_main`.`author_id` as `author_id`, `modzzz_articles_main`.`thumb` as `thumb`, `modzzz_articles_main`.`rate`, `modzzz_articles_main`.`country`, `modzzz_articles_main`.`city`, `modzzz_articles_main`.`anonymous`, `modzzz_articles_main`.`snippet`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`categories`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`video_embed`, `modzzz_articles_main`.`comments_count`, `modzzz_articles_main`.`organization`, `modzzz_articles_main`.`real_author`, `modzzz_articles_main`.`source`, `modzzz_articles_main`.`author_website`, `modzzz_articles_main`.`author_id`, `Profiles`.`NickName` as `NickName` FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE 1 AND `modzzz_articles_main`.`status` ='approved' AND CONCAT(`modzzz_articles_main`.`title`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`categories`) LIKE ('%Обсуждение%первого%тома%учебника%новой%истории%колониальных%и%зависимых%стран%') ORDER BY `modzzz_articles_main`.`when` DESC LIMIT 0, 14\G # Query 34: 0.00 QPS, 0.00x concurrency, ID 0xAA67A47289C5F84F at byte 4024876 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.01 # Time range: 2021-03-09T21:08:14 to 2021-03-10T04:14:33 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 23 # Exec time 0 72s 3s 4s 3s 3s 213ms 3s # Lock time 0 3ms 46us 272us 113us 167us 54us 103us # Rows sent 0 23 1 1 1 1 0 1 # Rows examine 0 220.99k 9.60k 9.72k 9.61k 9.33k 0 9.33k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 1.61k 63 65 63.31 62.76 0 62.76 # Query size 0 12.89k 364 538 425.71 487.09 52.98 420.77 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'modzzz_articles_main'\G # SHOW CREATE TABLE `********_ru`.`modzzz_articles_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE 1 AND `modzzz_articles_main`.`status` ='approved' AND CONCAT(`modzzz_articles_main`.`title`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`categories`) LIKE ('%ОЧАРОВАННЫЙ%СТРАННИК.%Выйдешь%поутру%в%народ%-%душу%лепота%берет!..%'); use ********_ru\G # Query 35: 0.00 QPS, 0.00x concurrency, ID 0xE7B64533273650AD at byte 25033045 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.22 # Time range: 2021-03-10T03:17:09 to 2021-03-10T10:25:57 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 19 # Exec time 0 68s 2s 6s 4s 5s 895ms 3s # Lock time 0 2ms 93us 139us 117us 131us 14us 113us # Rows sent 0 133 7 7 7 7 0 7 # Rows examine 0 766.86k 40.34k 40.79k 40.36k 40.32k 0 40.32k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 55.75k 1.69k 3.00k 2.93k 2.89k 274.72 2.89k # Query size 0 25.42k 964 968 964.15 918.49 2 918.49 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Time 2021-03-10T03:17:10.343604Z # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `Profiles`.`Status` NOT IN('Rejected','Suspended') AND `sys_albums`.`AllowAlbumView` IN('3') AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' ORDER BY `date` DESC LIMIT 0, 7\G # Query 36: 0.00 QPS, 0.00x concurrency, ID 0x810CEB43EF44F8FA at byte 36961604 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.48 # Time range: 2021-03-09T21:12:46 to 2021-03-10T10:33:01 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 16 # Exec time 0 67s 2s 7s 4s 6s 1s 4s # Lock time 0 2ms 70us 181us 96us 119us 25us 89us # Rows sent 0 16 1 1 1 1 0 1 # Rows examine 0 613.65k 38.27k 39.54k 38.35k 36.57k 453.27 36.57k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 948 63 66 63.20 62.76 0.78 62.76 # Query size 0 12.18k 579 785 623.60 719.66 46.78 592.07 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `bx_photos_main` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `Profiles`.`Status` NOT IN('Rejected','Suspended') AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%А.А.%РОДИОНОВ%')\G # Query 37: 0.00 QPS, 0.00x concurrency, ID 0x0EE42781FED5A080 at byte 49794717 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.37 # Time range: 2021-03-09T21:14:43 to 2021-03-10T10:29:42 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 12 # Exec time 0 66s 3s 8s 6s 7s 1s 6s # Lock time 0 2ms 120us 363us 172us 287us 70us 144us # Rows sent 0 12 1 1 1 1 0 1 # Rows examine 0 459.59k 38.30k 38.30k 38.30k 38.30k 0 38.30k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 1.00k 64 64 64 64 0 64 # Query size 0 68.02k 2.05k 2.39k 2.27k 2.27k 104.99 2.27k # String: # Databases ********_ru # Last errno 0 # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%'); # Time: 2021-03-10T09:56:03.575466Z # User@Host: ********_ru[********_ru] @ localhost [] Id: 135380645 # Schema: ********_ru Last_errno: 0 Killed: 0 # Bytes_sent: 63 # Query_time: 7.991122 Lock_time: 0.000147 Rows_sent: 1 Rows_examined: 39194 Rows_affected: 0 SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'21288' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%среди%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%воспитанников%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%военная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринария%'); SET timestamp=1615370163\G # Query 39: 0.00 QPS, 0.00x concurrency, ID 0x79FF64D3398C63A2 at byte 13347763 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.60 # Time range: 2021-03-09T21:18:42 to 2021-03-10T10:12:59 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 12 # Exec time 0 66s 2s 9s 5s 8s 2s 5s # Lock time 0 2ms 115us 178us 146us 167us 18us 152us # Rows sent 0 36 3 3 3 3 0 3 # Rows examine 0 459.59k 38.30k 38.30k 38.30k 38.30k 0 38.30k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 35.54k 1.69k 1.69k 1.69k 1.69k 0 1.69k # Query size 0 119.71k 2.91k 3.27k 3.15k 3.19k 81.73 3.04k # String: # Databases ********_ru # Last errno 0 # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4; # Time: 2021-03-10T07:30:21.561531Z # User@Host: ********_ru[********_ru] @ localhost [] Id: 134555661 # Schema: ********_ru Last_errno: 0 Killed: 0 # Query_time: 8.670028 Lock_time: 0.000174 Rows_sent: 3 Rows_examined: 39218 Rows_affected: 0 # Bytes_sent: 1733 SELECT `bx_photos_main`.`ID` as `id`, `bx_photos_main`.`Title` as `title`, `bx_photos_main`.`Uri` as `uri`, `bx_photos_main`.`Date` as `date`, `bx_photos_main`.`Size` as `size`, `bx_photos_main`.`Views` as `view`, `bx_photos_main`.`Rate`, `bx_photos_main`.`RateCount`, `bx_photos_main`.`Hash`, `bx_photos_main`.`ID`, `sys_albums_objects`.`id_album`, `bx_photos_main`.`Owner` as `ownerId`, `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName` FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `bx_photos_main`.`ID` <>'9894' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%ветеринарная%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%стоматологияi%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Иван%') AND CONCAT(`bx_photos_main`.`Title`, `bx_photos_main`.`Tags`, `bx_photos_main`.`Desc`, `bx_photos_main`.`Categories`) LIKE ('%Макаров%') LIMIT 24, 4; SET timestamp=1615361421\G # Query 40: 0.00 QPS, 0.00x concurrency, ID 0x2C62833C608283CE at byte 25329117 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.28 # Time range: 2021-03-10T03:17:06 to 2021-03-10T10:25:05 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 17 # Exec time 0 64s 2s 6s 4s 5s 1s 4s # Lock time 0 2ms 79us 134us 99us 108us 13us 93us # Rows sent 0 17 1 1 1 1 0 1 # Rows examine 0 526.52k 30.49k 38.30k 30.97k 30.09k 1.53k 30.09k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 938 67 67 67 67 0 67 # Query size 0 10.96k 488 492 488.17 487.09 0 487.09 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'bx_photos_main'\G # SHOW CREATE TABLE `********_ru`.`bx_photos_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums_objects'\G # SHOW CREATE TABLE `********_ru`.`sys_albums_objects`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'sys_albums'\G # SHOW CREATE TABLE `********_ru`.`sys_albums`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `bx_photos_main` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `Profiles`.`Status` NOT IN('Rejected','Suspended') AND `sys_albums`.`AllowAlbumView` IN('3') AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos'\G # Query 43: 0.00 QPS, 0.00x concurrency, ID 0x755652FD2C5DE85E at byte 26916682 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.73 # Time range: 2021-03-10T07:27:52 to 2021-03-10T11:13:05 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 16 # Exec time 0 55s 2s 8s 3s 7s 2s 3s # Lock time 0 1ms 51us 130us 75us 125us 22us 69us # Rows sent 0 18 1 3 1.12 0.99 0.46 0.99 # Rows examine 0 345.26k 19.19k 38.30k 21.58k 36.57k 5.99k 18.47k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 25.28k 64 24.19k 1.40k 65.89 5.39k 65.89 # Query size 0 9.69k 334 605 367.67 441.81 60.17 329.68 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Time 2021-03-10T10:00:21.367948Z # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'modzzz_articles_main'\G # SHOW CREATE TABLE `********_ru`.`modzzz_articles_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE `modzzz_articles_main`.`tags` LIKE '%%' AND `modzzz_articles_main`.`id` !=9618 AND `modzzz_articles_main`.`status` ='approved' AND `modzzz_articles_main`.`allow_view_article_to` ='3'; # Query_time: 3.134163 Lock_time: 0.000057 Rows_sent: 1 Rows_examined: 19651 Rows_affected: 0 SET timestamp=1615364733\G # Query 54: 0.00 QPS, 0.00x concurrency, ID 0x19059DB1CCF0F4F8 at byte 37325011 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.58 # Time range: 2021-03-10T07:24:28 to 2021-03-10T10:09:45 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 12 # Exec time 0 38s 2s 7s 3s 5s 1s 3s # Lock time 28 2s 39us 1s 156ms 705ms 344ms 152us # Rows sent 0 41 1 30 3.42 0.99 7.67 0.99 # Rows examine 0 238.88k 8.66k 38.30k 19.91k 18.47k 5.93k 18.47k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 2.46k 64 1.69k 194.08 65.89 444.02 65.89 # Query size 0 3.61k 231 231 231 231 0 231 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Time 2021-03-10T09:04:53.502188Z # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'modzzz_articles_main'\G # SHOW CREATE TABLE `********_ru`.`modzzz_articles_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE 1 AND `modzzz_articles_main`.`status` ='approved' AND `modzzz_articles_main`.`allow_view_article_to` ='3'\G # Query 55: 0.00 QPS, 0.00x concurrency, ID 0x79AE68F192BA9B65 at byte 2074782 # This item is included in the report because it matches --outliers. # Scores: V/M = 0.03 # Time range: 2021-03-09T21:01:26 to 2021-03-10T06:56:12 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 11 # Exec time 0 36s 3s 4s 3s 3s 308ms 3s # Lock time 0 1ms 51us 182us 102us 144us 42us 105us # Rows sent 0 11 1 1 1 1 0 1 # Rows examine 0 105.62k 9.60k 9.61k 9.60k 9.33k 0 9.33k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 759 63 64 63.25 62.76 0 62.76 # Query size 0 5.06k 391 519 431.50 463.90 37.83 420.77 # String: # Databases ********_ru # Hosts localhost # Last errno 0 # Users ********_ru # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `********_ru` LIKE 'modzzz_articles_main'\G # SHOW CREATE TABLE `********_ru`.`modzzz_articles_main`\G # SHOW TABLE STATUS FROM `********_ru` LIKE 'Profiles'\G # SHOW CREATE TABLE `********_ru`.`Profiles`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM `modzzz_articles_main` left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_articles_main`.`author_id` WHERE 1 AND `modzzz_articles_main`.`status` ='approved' AND CONCAT(`modzzz_articles_main`.`title`, `modzzz_articles_main`.`desc`, `modzzz_articles_main`.`tags`, `modzzz_articles_main`.`categories`) LIKE ('%Орлов%А.А.%'); use ********_ru; SET timestamp=1615324495\G