Closed pinkumohikan closed 2 years ago
初期スコア
14:53:26.925236 score: 41454(41454 - 0) : pass
スイッチにした
15:40:22.051696 score: 75374(75376 - 2) : pass
15:40:22.051708 deduction: 2 / timeout: 1
15:40:22.051717 <=== sendResult finish
ログ系もどして
15:49:18.930300 score: 68428(68434 - 6) : pass
15:49:18.930324 deduction: 6 / timeout: 1
15:49:18.930340 <=== sendResult finish
nginxにhttp2_max_requestsを設定してhttpsの接続が切れないようにした
15:52:03.430220 score: 69726(69726 - 0) : pass
15:52:03.430234 deduction: 0 / timeout: 1
15:52:03.430250 <=== sendResult finish
17:42:58.788652 score: 118909(118914 - 5) : pass
17:42:58.788669 deduction: 3 / timeout: 24
17:42:58.788714 <=== sendResult finish
$ make kataribe
sudo cat /var/log/nginx/access.log | ./kataribe -conf kataribe.toml | grep --after-context 20 "Top 20 Sort By Total"
Top 20 Sort By Total
Count Total Mean Stddev Min P50.0 P90.0 P95.0 P99.0 Max 2xx 3xx 4xx 5xx TotalBytes MinBytes MeanBytes MaxBytes Request
1527 507.447 0.3323 0.4316 0.000 0.002 1.000 1.001 1.007 1.056 1137 0 390 0 9402403 0 6157 8559 GET /api/trend HTTP/2.0
82342 167.790 0.0020 0.0057 0.000 0.001 0.004 0.007 0.019 0.382 82111 0 231 0 98 0 0 14 POST /api/condition/[a-z0-9-]+
7580 142.142 0.0188 0.0179 0.000 0.015 0.031 0.039 0.074 0.366 7490 0 90 0 19886374 0 2623 4590 GET /api/isu HTTP/2.0
11388 140.283 0.0123 0.0165 0.000 0.009 0.023 0.030 0.061 0.401 10762 0 626 0 54053638 0 4746 6963 GET /api/condition/[a-z0-9-]+
15316 94.214 0.0062 0.0055 0.000 0.005 0.012 0.016 0.026 0.165 14724 0 592 0 206110701 0 13457 135259 GET /api/isu/[a-z0-9-]+
8042 68.648 0.0085 0.0085 0.000 0.007 0.015 0.019 0.032 0.372 7653 0 389 0 43726501 14 5437 8703 GET /api/isu/[a-z0-9-]+/graph
2211 6.559 0.0030 0.0034 0.000 0.002 0.006 0.009 0.015 0.056 1498 0 713 0 8188 0 3 19 POST /api/auth HTTP/2.0
2541 4.142 0.0016 0.0022 0.000 0.001 0.004 0.005 0.010 0.031 1231 0 1310 0 74142 21 29 43 GET /api/user/me HTTP/2.0
60 3.621 0.0604 0.0173 0.001 0.061 0.074 0.081 0.102 0.102 56 0 4 0 7827 15 130 154 POST /api/isu HTTP/2.0
1314 3.363 0.0026 0.0028 0.000 0.002 0.005 0.008 0.015 0.031 1223 0 91 0 1911 0 1 21 POST /api/signout HTTP/2.0
1 0.396 0.3960 0.0000 0.396 0.396 0.396 0.396 0.396 0.396 1 0 0 0 23 23 23 23 POST /initialize HTTP/2.0
1263 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 1263 0 0 0 24080358 19066 19066 19066 GET /assets/index.144d8ca8.css HTTP/2.0
1262 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 1262 0 0 0 33653754 26667 26667 26667 GET /assets/index.23dac98b.js HTTP/2.0
1262 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 1262 0 0 0 4145670 3285 3285 3285 GET /assets/logo_white.svg HTTP/2.0
1262 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 1262 0 0 0 938192254 743417 743417 743417 GET /assets/vendor.ee7444dd.js HTTP/2.0
1261 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 1261 0 0 0 4146168 3288 3288 3288 GET /assets/logo_orange.svg HTTP/2.0
2495 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 2495 0 0 0 1317360 528 528 528 GET / HTTP/2.0
9 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 9 0 0 0 4752 528 528 528 GET /isu/[a-z0-9-]+
6 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 6 0 0 0 3168 528 528 528 GET /isu/[a-z0-9-]+/graph
# 160ms user time, 10ms system time, 31.60M rss, 38.69M vsz
# Current date: Sun Jul 17 09:26:16 2022
# Hostname: ip-172-31-36-253
# Files: logs/20220717_182612/mysql-slow.log
# Overall: 93 total, 61 unique, 4.23 QPS, 0.01x concurrency ______________
# Time range: 2022-07-17 18:23:57 to 18:24:19
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 282ms 0 147ms 3ms 14ms 15ms 91us
# Lock time 37ms 0 27ms 393us 424us 3ms 0
# Rows sent 27 0 25 0.29 0 2.56 0
# Rows examine 43 0 35 0.46 0 3.67 0
# Rows affecte 53 0 28 0.57 0.99 2.83 0
# Bytes sent 2.88k 0 1.63k 31.69 59.77 171.25 10.84
# Query size 905.45k 13 790.36k 9.74k 246.02 78.33k 40.45
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============= ===== ====== ===== ===============
# 1 0x245A814D06B07CEB 0.1465 52.0% 1 0.1465 0.00 INSERT isu
# 2 0x1E3FF025002EC3E9 0.0275 9.8% 1 0.0275 0.00 SELECT mysql.help_keyword
# 3 0xB13D400C8A2303CD 0.0185 6.6% 1 0.0185 0.00 CREATE TABLE isu `isu`
# 4 0x5028C7E1D44486E5 0.0173 6.1% 1 0.0173 0.00 ALTER TABLE isu_condition
# 5 0x22313DA6B4D40EE9 0.0144 5.1% 1 0.0144 0.00 CREATE TABLE isu_association_config `isu_association_config`
# 6 0x454A9EAE94FF551B 0.0136 4.8% 1 0.0136 0.00 CREATE TABLE isu_condition `isu_condition`
# 7 0x1EDCD938F3FE2419 0.0125 4.4% 1 0.0125 0.00 CREATE TABLE user `user`
# 8 0xDEE3EF20F3B5B682 0.0059 2.1% 1 0.0059 0.00 INSERT isu_condition
# 9 0x3675710D3B4B2E82 0.0050 1.8% 1 0.0050 0.00 DROP TABLE isu_association_config `isu_association_config`
# 10 0x358C7309C5D089D9 0.0049 1.7% 1 0.0049 0.00 CREATE
# 11 0x6EFD41F196940589 0.0027 0.9% 1 0.0027 0.00 SELECT information_schema.TABLES
# MISC 0xMISC 0.0129 4.6% 82 0.0002 0.0 <50 ITEMS>
# Query 1: 0 QPS, 0x concurrency, ID 0x245A814D06B07CEB at byte 23234 ____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:24:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 1
# Exec time 52 147ms 147ms 147ms 147ms 147ms 0 147ms
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 52 28 28 28 28 28 0 28
# Bytes sent 1 51 51 51 51 51 0 51
# Query size 87 790.36k 790.36k 790.36k 790.36k 790.36k 0 790.36k
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu'\G
# SHOW CREATE TABLE `isucondition`.`isu`\G
INSERT INTO `isu` VALUES (1,'eb104b95-3532-4828-8550-89da717b9667','リビング玉座','����\0�\0\r0;*-#0F>JIE>DCMWo^MRiSCDa�bisw}~}K]���y�oz}x99xPDPxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx��\0��\"\0���\0\0\0\0\0\0\0\0\0\0 \n\0\0\0}\0!1AQa\"q2���#B��R��$3br� \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz�������������������������������������������������������������������������\0\0\0\0\0\0\0 \n\0\0w\0!1AQaq\"2�B���� #3R�br�\n$4�%�\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz��������������������������������������������������������������������������\0\0\0?\0���Du����ڝm�nA��l!�����j`���w\n菰��n2cIN�\0�6]F���[Jk�YA�/���i/�?���WBf��f�>�}*���\"mԻ�@�����s�R��0��ps�L�I�N_s�sW�B��uZ$�8c�b4�%PE&i3@�Ȥ��4�4Q@Q@Q@Q@!稥��4hz��5�g�~5-Y��m�f���5j��T̬�U�gڧ��Ar�+���ך�*aQ�r}���j�Lʢ���g�Q5��B*R\Z�֒��ƣhe^�i��M��������~d�v�\0�\Z��ҞN!8���l���f��njF<\Z�1��A��M&W>��٨T�R-Zl���ѸRS[����ĔT1�co�5-Rw%�ESQE%\0-%�\0��Q@�P�. ��d�=�T���S�ќ�T��hA̮�*����%��3>ը\\q��7�&�o��~}:��\\v1��!����ޮD��j�J�U�R$d��\0F)Rz�*e@)Ԁj�Q����-�@��4f�4RR�EPEPEPEPQKI@Q@RPEPQE\0�R�PIKI@%-\0���R����1��\n���Ț���j6��՚)Y��֒v �F�U��+N���|���ê��R�Z8��S�E��))�T����)<�ؚhM�fi ��G֚co�0+�v�8�j�5Z��p�5a~�ϥ8�C�����sIE\0QE1�/֓v\\q u�̣���g$�I���CEC)�y��TY�4���Q�EV�aEP斊 �\0���Z���i(��\n(���J(ii(���J\0Z)(���(\0��(\0���\0ZJ(������ZJ\0J)i(\0��J\0(���\n(��Q@Ģ���\n(��&)h���-\0�R�@\r���7h���)�b���I�����,FA�j�o�$\Z�II�5�C<SKV�U=T\Z���\Z�r��3V��~�~4}�?S��fF�QZ�����Nhũ��(����\0J)h���Q@E%���斀�J(h����J(h����3IE 4RQ@II�3L��4f�i(���E%\0QE\0��PQE�J)i(QE\0QE�))i(\0�����ZJ\0))h���(RQE Rb��\0J)h���4�hoZ_�Y!EPIKI@Rc�`-b�\0(��@QE\0������(\0�����4�(�Sh��4��4\0�J)(i(��������Q@�Zm\0�Sis@n�4\0QE�%-&(�\0QE\0QE\0�f�\0(��@�Q@Q@ G�PQE\0RR�@Ģ��@(r:�O;Vr]8��\"�G\"ȁ���,Y��80=���:\Z]��T�K�f��9i�Pz�Z)&CL}CEP��(��(��(�QE\0�RR�IKE\0���\0b��S1IN���4��� �IE\0-%f�\nJZJf�)\0QIE\0RQ@�挚J3@��.i�P�E6���������@QE\0%Q@%-\0�R�b����\0(����J(=�������l��9��������bjZ,GC@�tj�HdS�ˀ��9�Eg�*r \"]��i���zSĤu檤� �O>���T��.(��)�O�`��$e�j����Z��[�~��J7CV�d�è����J(h��\0(���IKIL�����Q@�R\0�������\0J)i)(������-%\0�~�J\0N(����(��4ZJ3E\0QE\0f�(\0�.i�PE6���)3K�\0(�\"�R3Fh�\0QE%\0-Q@錡�\r>���ԩ\"4gr�)C��d��U&��ܽ?�4��4����.�v�֠��֭�ؑB�8��Wԗs(��M\rĠ�?�_��&�0;s��x���~U\0����Д�\\ g]��J@\"�i7�j�y�|�rB�t��*z⅗��*Zhd�pï\"�Y���� �F�QMI�r�jz\Z+=%e��V��\n�4�qe�)�\"?CO�$))h�QKE\0%b�\0J)i)\0��ZC@ E-%\0QE\0QIH�(�bQ�ZJ@QI@IE���4P�h�E�10i)٢�4���� �F\r/4��aFisIր�I�0i\0QIFh��;&���Zb���8��@��挚\0Ͳ��?w!��Z�X��G\'�֍��h��C�g%��FMHFiԕ�!)�/��UwO� �w�\0�P@ �2*���҆N�����Ѫ�m�~�eYs����T7z�$#��ӟ�О[��A�{Uv=�\Z��u�?̉���*�������a��q�5[��`~�HD&��s+/QL4�\Za�]�{�GJO3xVN\r�2��\\\Z�&u��T�CJ���M�����\n~�2�n�5����b�V=U�E2\r\n*�w8<��*�|\Z�$�i�����%P�����%-%\0QE\0%Q@%-% \n(���Q@ ER(��\0����(�R\0�Q@����J(\0���ih�Q�u%\0\'b��M sG\"��19��\\�(3Fhǵ��\"m%XqU�v��#���q���+>Tܸ�:T��e5��F���ӫ6�}���C�ڴjd�ƝŦȂD*{Ө��wC!SV`�����^C�&����F�㸭>$#R��&ހ��O�\0�t4�cz�R\Zw����M�~a�\r5�0��Ь���d��Lmџji9�9�O-��<\Zz���FHN���k��� \rf3���RG;����ð&j,�}Xpy���Q���ާ=*v}Y����\n��2��֥YA��4�%��ᕺ\Z*�>�������>世(��en�S��5wL�X))i(\0��J\0(��C\n(��\n(����)\0�QE\0QE\0&(�P1(���IK�Nh\0��(Q�)(sFi(���J)���QHm4�u-\0G����*��lmá�t�S|e{�����*ۗ�_���L�*;��r���n�,f��y4�#zT����e�yWc ȭ\0��G�� �� `V���-���)�:FH�AT�Y�BQs��W8_bT��1��p^���5hH���-5�i�R)�S��R\0F\"�K^W���f�����]���`s�j���\0~\"�0�j�ɱ\Z*�)�#��X�m%1#����j7WR\rdӔ�9RA�qi*Nk.�Nn�_��)���>������{/CN\"�˟j�%K�хL�#t5���ޚ���R�BqLԢ��˯�%�7^*��%ŢZ(��� E-% њ)(h��4\0�Rf��\nJ(��(�aEPQKIH�QE\0&))�P1�R���(��\0Nih��%-\0QP��h�I���/Z.;\r���J}B���������k�\r$M�ǥY�M��Q�Q����Mj���S��I�pi��@�wdS��|ڝ�ҳ��;Ք�c�Zs\n�-�����O,�>�E�Pd�9r�9��h9n6��3����U �\"�d���ڨ>Ns5+��-��\'WAdV)Z��ϑ�iN=PE�e�M��\"�,J�<?Ŀ��4��l)�n�-�:�;�R+d�C���86|;���+\"���v�2���j�v�O�P^ONƱ�J�V#�\rtN%<0��m�nYC�������Fa�Nthܫ�0�)��\'��h�7n�����\0!�+.���|�*A������H�Q��i~O/�*\\X�Lĩ�+��4�*8ʰ4�Qa��F^��K��Y��z\Zz���v�ɚ�*7CO�Yjކ�I�j����^��[�z����j�L�0����%-�3E%\0�Rf���IE\0QE\0QE\0QE\0���\0Q�(�bb�\ZZk���4�5�w{�U\rGyx_*�*�%� \\/aZF\'$Ѽ��p(�j�jS��@4�kt�T5q�b�9���O�N��6�w�n��+2�q��h�,=j\0qO�Ӱ��P�JF;�HL�ՋI0�CҠ8��\"���cM� �q�P]G�\0-�R��dj���jB21X��.�[��b1V�X�?-��=*������JښpI�}�j˷��b�Q�\n�J̴�:�(�1���Y�yo���Z4�c!SN.�L��أ���\n1���I4�:�������*��v�*���i���r�Ͳ\\.�\Z��-䁰���t5��8Φ;$\\Mj�dj�v�ԟM-c��T%�H��hȩ)�i6�p�YXu曊(z�2�^)�T�A#/CS�-�\"�ï5Ug�*P��9�i��L��)�5*�GCT�C2�56��u��ej�YGq��[=\r5&��f����k!�e�֩I�OIMWV�i�B\nJZ((�R\0�-%%�SsK�\0ZJ(�0\n(��\n(��7k�94�ijL�.I��nnZS������bX�f�w���[-#6x)�v$Z(��\Z��QY�o���r|�a�Pz��R1����)�����h��L�4�#�F�88#���*qV`�IN��\Z��_˦��R�F���B`Ih�%;EY95IN�\r�W���sܴG<~dgGJ�##��kR�]��7����U�RE?�j弽3U\\Q`֭]��`r)j$*z��N��QH\nw��o�5Tը�A�k-���OcZ��X�8GZ��z�>�Y�T?QD����vS�����YK�Ѹ�r�0pEQ<ЬT�qZ)�yI�����P�t�r�L�)��j��ï5\"Χ�*������p�T��aj�b�.�5R[��nE=S$��U�줏��ګc�E������E0%Y���J�+t<�Z*\\S)I�h�A��#/|ԫ2��T8�U�eea�f�Y��\rV�#.�\"�YH�TU�zΤY�q�\0���RCTC�Ӄ���LV.QP,(pi�VE�)�J(��ĥ��������G$���e��4��N��@R�����:i���$Ka���I=i�zӪ�������������)6�Qp��N)��9������ӓ֟�u���{�AL�f7\n\0��mh5����q�\"�i5���y�N\0<�TR(��C/ۿ�mʟ���ޠ=�+Y|��l���Z�M�:75\rY�����ͺ!�8�&��|HW�R�Ш�K�ٓ̌��O��Y&Y�zsڣ�j��l�=���Ú鋹��q2������h$��%�\r���FE�p��)�T=U03���E�Ẽ�U)�4Ņ8-.�iXD;)ɔ`}*LQ���Ŝ��Ɛ�b9\\zS�fP\nB(�P!���x��`��qN������2�I���i����E�e�e�~aPV���]��}kE.丕h�:�84ڲ�(�V*x8�V�ʡ�����t9�U�J�faבP�إ\"������^j�[��ISa�@���oCUi�����r*E�֩���2�=(�`ij\0M8=�*���O#5\r���0:�ȖV��M4��\\���d��Rx����\'qKc�Zh4�U�Ҋ�\ZR٥a�\'<R\nAN\0�K�#&yQ;��\n��3�AQ�Ub��k��9��Ls�\0�8��Fi_;P�\"�9��4r8+u��D0�>u�o�x5�Wt�Bz0ȥ.��bB6�;\Z �{RR(�R;��;i�n�l�;Vf�܆�7Ñ�y����0k*D�#\'��i��I����@:\nr�@��j��d1\\��ԩ:�\0��2��Q�E=l_VV�i���������/���8��E��5���F�S�U;7V\'���Ý�\\\0F}*��q:Vղ���\r�������B�h$��\"�d\ZY��l�k=�H?��Em\ZT�U���\rS�85\r4Ri��N�!��R�@)g�)Sr0y.>�e�?Z��ƭ12*Jsr:Sj�\n)h����\0Jr����h�Ip��Ճr\rgR�9����4�Ҫ�+>Cv�+ҧa�,�=�A\"��T�7�4X\n��̢���ӎI��Z�X�1�jJ�%P�����\nJZ(\0����e�KH�tS�\n+QKKZa(4����`sl���Td�H�\r0�z�Hm�94�QT@T��ys��i����r�6NH�܊�V����rw^\rU�F�B8�mg}ꇐNGI�p���M��_SP6��UK�ë��\Zm�4wd��@��Y���ƳQkR���pqN\rM9��5�#��85E&�Jø��w�RѴ���N�!ɰ�z�S�ny^�J�O��Hn��S%tvf���7��>0zS2ʼnb=)���Ȭ�lS��u^?�@|Ⱦ��@n�}* p�R}Iq]\n�9�R���Π)�T��)��.n�:��T��\rrJJ��)���i�S��84�VeM�#�W�Z�rX�QE1Q@Q@ E-%\'������ҩZ�����ҡ�>��d�p��2o�i���@�h�$���%+u��QE(��\0(��\0��)sLO�)��EC\nN��� �IKF(1KE�EP�B�dUr0H=���ʙ[�����rGF��fWB\nfv��iƘ��R%��!��>�U*��ϔޫT���-��zѺ�����ۈݶ��jyl���=*�X��xx?2�\Z����%�A)qW$E�?6.��T���\ZV�EIHMRb!a�J�����\rX�j�����T�B���f��ⱚ�5���)$��j��{���*FP��@P\0qI;�y�t��M�Gn���\"Hr��M@\rH��@�aM:�SRY�Z�(4�J�d�!�����vS��*locL�w (��\0(��\0(��\0���a�U��Tm���uzT��p���\r*�4�����C��Pz�Y$m��J�M%P���(QE\0QE\"}�uF��N�HciqE!9�PP�M-�(qFh\0�\\b� �Z)h<Ph�!4���U�>m�?t��\n�`w !?�2)Kk�$��v�F ��=\rl�uͬ\r튩V����ϡ�T�; ������QE\'���/�\'��7��q\"���u�Z6���F��̽*$��q}\n��\ZC�y��;\\�ZZC֚&@#��@w(a�f��Bѷ@u⢢���$wT�}�����!��\r�oL����Ѫ3&��y�BZ!����B�Ѕ�\'����j\Z(�t����PPQKIH��\\UB0qWqP\\\';�~�q}�\r- ��%Q@Q@�-�\0֊��*��E_N�q��IG�i/�5 g�4QފБ���6�����QE(��\0(��\0(��\0^M.1N��J��f3Ҝi��\'֕�%Z ��E�)4�ipM�!1E-%`��\'�2��棢�\\�x�g$tnEV-�CH��KJe$��m9ӛ����jۛ9��5Tзc`i)M%Q,(��f�M�#Ѹ�Ԡ�AE&��4��7����cȪ�z���9Gq�T�c�lJF�����m[�o���f�T���u�┕�1њT��Q\\��MAr���:�X���A�i�f�4ڑ�k{S���:�؊蹛CT���0����M�T�1�z�����\"���IE ��S\\nR)ƒ��QRN1\'֜mV�%\"\Z*R��S\\vKF(�!��\0�Z������֊�*$��e���:�&�\0VjFgw�����\ZJV�ITHQE\0QE\0QE\0QE>\0���v�\\p�\\d��A�T�U��ɩ&����Q�T�����;�F)�JCJi1E�i���1H,6�ZJ\0(���&��\"ȭ��3PR��@��h���@QE\0QE~����ץR�:s휡�⢝<��}��Z6�7C)\r-BJ#�����9�5�n�}G-r�gct��^�N�q oQP��E[�\\ǟJ��[E��9�� <)���Ud��i*r�\rJ���\Zi�4�9斤������!Ȼ�i�h�0I����q����*6�v��!Qq\"�z�Q�f+�E���^�2C�2_�jCQ���Ԍ��hw4V�n��!Z��\n^Ԕ�����(\0��(\0��(LӋ3(^R���\0Q���u��F3N�F)��Q�~)�HjM��)1��%;c�n)h���EP!(��d�EP ��(Ѿ��c��~�e�taTj�\0����ҢZ4ˏb�-%C\Zz�Jz�S3-X�%��c5h6j0s!�\nd���?�LV2�塪vE�*8�W\Z���#��#�VqⴻU �l�*�ɐg\"��i�Ӂ�n0�RT��iJw%ǰ��{T�1��Q�J,���hO�ߕ(�OPj�.��jy�ˡ�ԏS����{���Ջ)��R�99p:j6��j�����ze59�fϽ74QVKw~���ȬZ�j$8�z�s�5!�Q��\rAfgz(�GzԁP�E1�\r\0��Oq��GP��E�\n(��\n(��\n(��\'ǭJP3N�/�.)qE\nLS��L�ӱN b��ƞzRRp)�ސ4�N4�R1�R�m0\n(���(�BQE�\n(��\n���K�z��Rۿ�:�l�S%t8�1v�_CM���|�\0z�Н�b5%)��!�h����j�1���5�c��gԓY���Q�Od\nJ���V���\r����U8�Jm\Z��V�^U�x�c���ȩ݄����f���/tU��+BEӃ\neXw�v�R�w����k�QO({SqEɰ���AE��\"R7\r��\0�J����H6�+���c@QNa�����[��Z�r�}�$TI\rG\'�4�Q��MAFi�h��4V��=jD�q�QӐὨbB��J|���)�aEP ��(\0��(�(���R�J(��)v��@��zCJh4\0�M\"�i��\r4�N&�}�F4�u��!������))�R�@ E-%\0QE/\\~��9;��N�Z2 \"?QU}��\Zn�6�zSj�f�&�?�&��No����Y��9QVHR�9�P����qM���rx#�7R�hTf3�zU1���AxW/#֓O��Or��4��В$�w)�ERe*Ha�)\'r�\r�A�)(�4��9�Ma�wDtPh� xs�7�=��OC�cL��P���(կҲ�t�Ks���TH���Q��MHj9>��-��\ZJS��%j@�(��$��J����8��=��(����(��(��Rњ\0�PsN��@�9��L��<R�!)�)��\0Ji4���c���$�E<��h��i��i\0��R�� E-���Fh\0���� ��(-��T��N����RT�EEKJ�ܫ�%( RS���B����p=H�Z\Z��{�}D6�\n(�����(\0��(\0��(X\'h[�W��Ϋqu�ڳ*Ť�[�����uE\'�B0pi1V���1��Z���g�)�\Z�Ԕ����QE\nӶ?�O�fV��0-L��9������S$�k2��~��4��\ZCZ�6�(�HT��\\�t�=�&46�V4��QE\0QE\0^��h��Pt����Θ�����ȧ�\0:c� �ހqI�M;���t�cKHzP!��i��O4��HWi����b�f��i5#IE%\nJZ)�)(���P0�����%Kj3r�Z���O*U|g��[�5�A�T�{�IS����v nQEP��(��(��(��(�\rw�`�rG����zS�[2��[�Ā��l�i� &��*�!��4��aEP �C���k>�ٟ��L�*;�Jd�\r<��ߡ��F{}�M�o�i+RD��)�QE\0QE\0QE\0QE\0hf�QKL��GHOaILB䟥����9���Kڐ�)�Ji4��&3ׁ@h�/\"��`4�M�O�4Ԕ4�\r;��h�<RR(��b�\\R‰������\nJ(�HQE\0QE\0QKI@Q@Q@Q@Q@[�ٔ���^����@��;V��}�Ǧj%�.;(�����M�K\n(��[�?.=��X�<�)l5�{�j9:S����+2ўz�JS��V��ES$(��\0(��\0(��\0(��\0��9��=)1���)�\0R�s�E1旵&h�P��юh�1�A�⓿4�14�b�qL�h�i4�M4�n)\r8�M �M:��cE8\nv1F1RqA?��MIE�\n(��R�@�����C� ���d�Q@Q@Q@Q@h[���{b����|���52ب�Va�G�%Ip13~u40�ө��aEP ����AR�z�{\rn]S�~Zj�(c��e�[�\ZJV�ƒ� J(����(��(��(��(���!撗8�1GiR��j���ZP)@�^����N�`�=���(���@\'z;њJ\0C����)����\0��N��\0CIN4���4�)q�_�!��>��isM&�\0���E��(\0��Z�\nZ) �=��J)i�p��ZC����S�R�P ��(\0��(\0���%Ǩ�)���T��{\rnOx>u>��U˱���5N�v)�M4�\Z�X�QE\n��I�4��[�TӺ�0R���e\"�}�IJ�x�i�d���)�(��\0(��\0(��\0(��\0��3�S�<rj�\0S�) ����p���/JoJ3�\0.i3Fx��qLB�g�3IL�iI⛚\0;QK�P\0��E���4�N&�M\0&�ih� �\r8�q@Ģ����H �Z?�!4Bi)h�2w\nZ(�;%PE��QE\n(��\n(��\n(��/��ۓ�3Tj���\0�Sa�#Ң=�bPh�ՒĢ�(S����|z�\Zܰ(�i��AD\r��6��x�kBXQE(��\0(��\0(��\0(��\0�>�gғ�(��BњL�ր���L��))3�LB�CHM�%*�4�zџʓc�R\Z ��H`M4�M4�\0 �\"�z_�\0 QA�� K��)qG_�!�ӥ\'_�;�S���\'?JJZ\\z�!1E.)\rEPHh4� ���)�QE\0QE\0QE\0QE\0Z�n}�Q\\\r�7�Kjq.=E:�|�}EF�/��*��(�AN����h�T*�q�T��TX��7SIJz�U�QE\0QE\0QE\0QE\0QE\0Zh����h()GZJQ֘%-\'cM;RQ�4S��:{�;S�AC{�y4w���1��N���i��4��_ZCK�M=))�)���Hb�R��� �Hb9��s���GL�J>�% �R�J`Qފ\0mQL���(\0��(\0��(\0��(\0��(�J�Z�u�֫���~�b��X�Խ�[i)i*�QE\n(��\n�PEPEPEPEPEPEP��','いじっぱり','isucon1','2021-06-03 15:58:09.000000','2021-07-04 04:41:50.000000') /*... omitted ...*/\G
# Query 2: 0 QPS, 0x concurrency, ID 0x1E3FF025002EC3E9 at byte 9403 _____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:23:57
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 1
# Exec time 9 27ms 27ms 27ms 27ms 27ms 0 27ms
# Lock time 74 27ms 27ms 27ms 27ms 27ms 0 27ms
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 1 1 1 1 1 1 0 1
# Bytes sent 0 11 11 11 11 11 0 11
# Query size 0 57 57 57 57 57 0 57
# String:
# Databases mysql
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `mysql` LIKE 'help_keyword'\G
# SHOW CREATE TABLE `mysql`.`help_keyword`\G
# EXPLAIN /*!50100 PARTITIONS*/
select count(*) into @discard from `mysql`.`help_keyword`\G
# Query 3: 0 QPS, 0x concurrency, ID 0xB13D400C8A2303CD at byte 17219 ____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:24:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 1
# Exec time 6 19ms 19ms 19ms 19ms 19ms 0 19ms
# Lock time 1 503us 503us 503us 503us 503us 0 503us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 11 11 11 11 11 0 11
# Query size 0 424 424 424 424 424 0 424
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu'\G
# SHOW CREATE TABLE `isucondition`.`isu`\G
CREATE TABLE `isu` (
`id` bigint AUTO_INCREMENT,
`jia_isu_uuid` CHAR(36) NOT NULL UNIQUE,
`name` VARCHAR(255) NOT NULL,
`image` LONGBLOB,
`character` VARCHAR(255),
`jia_user_id` VARCHAR(255) NOT NULL,
`created_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select =utf8mb4 from CURRENT_TIMESTAMP(6),
PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARACTER \G
# Query 4: 0 QPS, 0x concurrency, ID 0x5028C7E1D44486E5 at byte 18473 ____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:24:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 1
# Exec time 6 17ms 17ms 17ms 17ms 17ms 0 17ms
# Lock time 3 1ms 1ms 1ms 1ms 1ms 0 1ms
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 2 77 77 77 77 77 0 77
# Query size 0 256 256 256 256 256 0 256
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
ALTER TABLE isu_condition ADD COLUMN condition_level VARCHAR(255) AS (CASE (LENGTH(`condition`) - LENGTH(REPLACE(`condition`, "=true", ''))) / LENGTH("=true") WHEN 0 THEN "info" WHEN 1 THEN "warning" WHEN 2 THEN "warning" WHEN 3 THEN "critical" END) STORED\G
# Query 5: 0 QPS, 0x concurrency, ID 0x22313DA6B4D40EE9 at byte 19364 ____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:24:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 1
# Exec time 5 14ms 14ms 14ms 14ms 14ms 0 14ms
# Lock time 0 79us 79us 79us 79us 79us 0 79us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 11 11 11 11 11 0 11
# Query size 0 157 157 157 157 157 0 157
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_association_config'\G
# SHOW CREATE TABLE `isucondition`.`isu_association_config`\G
CREATE TABLE `isu_association_config` (
`name` VARCHAR(255) PRIMARY KEY,
`url` VARCHAR(255) NOT NULL UNIQUE
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4\G
# Query 6: 0 QPS, 0x concurrency, ID 0x454A9EAE94FF551B at byte 17878 ____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:24:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 1
# Exec time 4 14ms 14ms 14ms 14ms 14ms 0 14ms
# Lock time 0 140us 140us 140us 140us 140us 0 140us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 11 11 11 11 11 0 11
# Query size 0 360 360 360 360 360 0 360
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
CREATE TABLE `isu_condition` (
`id` bigint AUTO_INCREMENT,
`jia_isu_uuid` CHAR(36) NOT NULL,
`timestamp` DATETIME NOT NULL,
`is_sitting` TINYINT(1) NOT NULL,
`condition` VARCHAR(255) NOT NULL,
`message` VARCHAR(255) NOT NULL,
`created_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6),
PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4\G
# Query 7: 0 QPS, 0x concurrency, ID 0x1EDCD938F3FE2419 at byte 18964 ____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:24:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 1
# Exec time 4 13ms 13ms 13ms 13ms 13ms 0 13ms
# Lock time 0 77us 77us 77us 77us 77us 0 77us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 11 11 11 11 11 0 11
# Query size 0 165 165 165 165 165 0 165
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'user'\G
# SHOW CREATE TABLE `isucondition`.`user`\G
CREATE TABLE `user` (
`jia_user_id` VARCHAR(255) PRIMARY KEY,
`created_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6)
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4\G
# Query 8: 0 QPS, 0x concurrency, ID 0xDEE3EF20F3B5B682 at byte 834997 ___
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:24:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 1
# Exec time 2 6ms 6ms 6ms 6ms 6ms 0 6ms
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 2 60 60 60 60 60 0 60
# Query size 12 110.05k 110.05k 110.05k 110.05k 110.05k 0 110.05k
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
INSERT INTO `isu_condition` VALUES (1,'eb104b95-3532-4828-8550-89da717b9667','2021-06-03 15:59:09',1,'is_dirty=false,is_overweight=false,is_broken=false','わ、わるくないね!','2021-06-03 15:59:09.000000') /*... omitted ...*/\G
# Query 9: 0 QPS, 0x concurrency, ID 0x3675710D3B4B2E82 at byte 16102 ____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:24:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 1
# Exec time 1 5ms 5ms 5ms 5ms 5ms 0 5ms
# Lock time 2 926us 926us 926us 926us 926us 0 926us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 11 11 11 11 11 0 11
# Query size 0 45 45 45 45 45 0 45
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_association_config'\G
# SHOW CREATE TABLE `isucondition`.`isu_association_config`\G
DROP TABLE IF EXISTS `isu_association_config`\G
# Query 10: 0 QPS, 0x concurrency, ID 0x358C7309C5D089D9 at byte 19756 ___
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:24:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 1
# Exec time 1 5ms 5ms 5ms 5ms 5ms 0 5ms
# Lock time 1 579us 579us 579us 579us 579us 0 579us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 1 50 50 50 50 50 0 50
# Query size 0 82 82 82 82 82 0 82
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
CREATE INDEX idx_jia_isu_uuid_timestamp ON isu_condition (jia_isu_uuid, timestamp)\G
# Query 11: 0 QPS, 0x concurrency, ID 0x6EFD41F196940589 at byte 2478 ____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:23:57
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 1
# Exec time 0 3ms 3ms 3ms 3ms 3ms 0 3ms
# Lock time 0 197us 197us 197us 197us 197us 0 197us
# Rows sent 92 25 25 25 25 25 0 25
# Rows examine 81 35 35 35 35 35 0 35
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 56 1.63k 1.63k 1.63k 1.63k 1.63k 0 1.63k
# Query size 0 270 270 270 270 270 0 270
# String:
# Databases mysql
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `information_schema` LIKE 'TABLES'\G
# SHOW CREATE TABLE `information_schema`.`TABLES`\G
# EXPLAIN /*!50100 PARTITIONS*/
select concat('select count(*) into @discard from `',
TABLE_SCHEMA, '`.`', TABLE_NAME, '`')
from information_schema.TABLES where TABLE_SCHEMA<>'INFORMATION_SCHEMA' and TABLE_SCHEMA<>'PERFORMANCE_SCHEMA' and ( ENGINE='MyISAM' or ENGINE='Aria' )\G
Top 20 Sort By Total
Count Total Mean Stddev Min P50.0 P90.0 P95.0 P99.0 Max 2xx 3xx 4xx 5xx TotalBytes MinBytes MeanBytes MaxBytes Request
1 0.471 0.4710 0.0000 0.471 0.471 0.471 0.471 0.471 0.471 1 0 0 0 23 23 23 23 POST /initialize HTTP/2.0
1 0.101 0.1010 0.0000 0.101 0.101 0.101 0.101 0.101 0.101 1 0 0 0 4495 4495 4495 4495 GET /api/trend HTTP/2.0
2 0.047 0.0235 0.0005 0.023 0.024 0.024 0.024 0.024 0.024 2 0 0 0 0 0 0 0 POST /api/auth HTTP/2.0
2 0.014 0.0070 0.0000 0.007 0.007 0.007 0.007 0.007 0.007 0 0 0 2 0 0 0 0 GET /api/isu HTTP/2.0
5 0.012 0.0024 0.0028 0.001 0.001 0.008 0.008 0.008 0.008 5 0 0 0 0 0 0 0 POST /api/condition/[a-z0-9-]+
2 0.007 0.0035 0.0015 0.002 0.005 0.005 0.005 0.005 0.005 2 0 0 0 62 31 31 31 GET /api/user/me HTTP/2.0
3 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 3 0 0 0 9864 3288 3288 3288 GET /assets/logo_orange.svg HTTP/2.0
3 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 3 0 0 0 57198 19066 19066 19066 GET /assets/index.144d8ca8.css HTTP/2.0
3 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 3 0 0 0 9855 3285 3285 3285 GET /assets/logo_white.svg HTTP/2.0
3 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 3 0 0 0 1776 592 592 592 GET /assets/favicon.d0f5f504.svg HTTP/2.0
3 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 3 0 0 0 2230251 743417 743417 743417 GET /assets/vendor.ee7444dd.js HTTP/2.0
3 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 3 0 0 0 80001 26667 26667 26667 GET /assets/index.23dac98b.js HTTP/2.0
5 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 5 0 0 0 2640 528 528 528 GET / HTTP/2.0
Top 20 Sort By Mean
Count Total Mean Stddev Min P50.0 P90.0 P95.0 P99.0 Max 2xx 3xx 4xx 5xx TotalBytes MinBytes MeanBytes MaxBytes Request
1 0.471 0.4710 0.0000 0.471 0.471 0.471 0.471 0.471 0.471 1 0 0 0 23 23 23 23 POST /initialize HTTP/2.0
1 0.101 0.1010 0.0000 0.101 0.101 0.101 0.101 0.101 0.101 1 0 0 0 4495 4495 4495 4495 GET /api/trend HTTP/2.0
2 0.047 0.0235 0.0005 0.023 0.024 0.024 0.024 0.024 0.024 2 0 0 0 0 0 0 0 POST /api/auth HTTP/2.0
# 180ms user time, 10ms system time, 31.73M rss, 38.84M vsz
# Current date: Sun Jul 17 09:27:12 2022
# Hostname: ip-172-31-36-253
# Files: logs/20220717_182706/mysql-slow.log
# Overall: 223 total, 87 unique, 8.26 QPS, 0.02x concurrency _____________
# Time range: 2022-07-17 18:26:18 to 18:26:45
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 448ms 0 144ms 2ms 5ms 11ms 125us
# Lock time 25ms 0 14ms 111us 273us 910us 0
# Rows sent 139 0 28 0.62 0.99 3.25 0
# Rows examine 47.47k 0 1.95k 217.96 1.86k 602.10 0
# Rows affecte 1.29k 0 618 5.93 0.99 55.84 0
# Bytes sent 788.82k 0 757.99k 3.54k 381.65 50.31k 10.84
# Query size 919.96k 8 790.36k 4.13k 420.77 50.79k 31.70
# Boolean:
# QC hit 0% yes, 99% no
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============= ===== ====== ===== ===============
# 1 0x245A814D06B07CEB 0.1438 32.1% 1 0.1438 0.00 INSERT isu
# 2 0x1A3620DEDAEAD803 0.0694 15.5% 25 0.0028 0.00 SELECT isu isu_condition
# 3 0x5028C7E1D44486E5 0.0597 13.3% 1 0.0597 0.00 ALTER TABLE isu_condition
# 4 0xDEE3EF20F3B5B682 0.0308 6.9% 1 0.0308 0.00 INSERT isu_condition
# 5 0x08EBCE5DB9749F07 0.0233 5.2% 1 0.0233 0.00 UPDATE isu
# 6 0xB13D400C8A2303CD 0.0174 3.9% 1 0.0174 0.00 CREATE TABLE isu `isu`
# 7 0x22313DA6B4D40EE9 0.0143 3.2% 1 0.0143 0.00 CREATE TABLE isu_association_config `isu_association_config`
# 8 0x1E3FF025002EC3E9 0.0141 3.1% 1 0.0141 0.00 SELECT mysql.help_keyword
# 9 0x454A9EAE94FF551B 0.0136 3.0% 1 0.0136 0.00 CREATE TABLE isu_condition `isu_condition`
# 10 0x1EDCD938F3FE2419 0.0124 2.8% 1 0.0124 0.00 CREATE TABLE user `user`
# 11 0x99AA0165670CE848 0.0077 1.7% 36 0.0002 0.00 ADMIN PREPARE
# 12 0xD8294721252CC94E 0.0053 1.2% 1 0.0053 0.00 SELECT isu
# 13 0x358C7309C5D089D9 0.0053 1.2% 1 0.0053 0.00 CREATE
# 14 0x2DB9FB7816AA5A1B 0.0050 1.1% 1 0.0050 0.00 SELECT mysql.user
# 15 0x3675710D3B4B2E82 0.0047 1.0% 1 0.0047 0.00 DROP TABLE isu_association_config `isu_association_config`
# MISC 0xMISC 0.0210 4.7% 149 0.0001 0.0 <72 ITEMS>
# Query 1: 0 QPS, 0x concurrency, ID 0x245A814D06B07CEB at byte 22767 ____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 32 144ms 144ms 144ms 144ms 144ms 0 144ms
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 2 28 28 28 28 28 0 28
# Bytes sent 0 51 51 51 51 51 0 51
# Query size 85 790.36k 790.36k 790.36k 790.36k 790.36k 0 790.36k
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu'\G
# SHOW CREATE TABLE `isucondition`.`isu`\G
INSERT INTO `isu` VALUES (1,'eb104b95-3532-4828-8550-89da717b9667','リビング玉座','����\0�\0\r0;*-#0F>JIE>DCMWo^MRiSCDa�bisw}~}K]���y�oz}x99xPDPxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx��\0��\"\0���\0\0\0\0\0\0\0\0\0\0 \n\0\0\0}\0!1AQa\"q2���#B��R��$3br� \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz�������������������������������������������������������������������������\0\0\0\0\0\0\0 \n\0\0w\0!1AQaq\"2�B���� #3R�br�\n$4�%�\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz��������������������������������������������������������������������������\0\0\0?\0���Du����ڝm�nA��l!�����j`���w\n菰��n2cIN�\0�6]F���[Jk�YA�/���i/�?���WBf��f�>�}*���\"mԻ�@�����s�R��0��ps�L�I�N_s�sW�B��uZ$�8c�b4�%PE&i3@�Ȥ��4�4Q@Q@Q@Q@!稥��4hz��5�g�~5-Y��m�f���5j��T̬�U�gڧ��Ar�+���ך�*aQ�r}���j�Lʢ���g�Q5��B*R\Z�֒��ƣhe^�i��M��������~d�v�\0�\Z��ҞN!8���l���f��njF<\Z�1��A��M&W>��٨T�R-Zl���ѸRS[����ĔT1�co�5-Rw%�ESQE%\0-%�\0��Q@�P�. ��d�=�T���S�ќ�T��hA̮�*����%��3>ը\\q��7�&�o��~}:��\\v1��!����ޮD��j�J�U�R$d��\0F)Rz�*e@)Ԁj�Q����-�@��4f�4RR�EPEPEPEPQKI@Q@RPEPQE\0�R�PIKI@%-\0���R����1��\n���Ț���j6��՚)Y��֒v �F�U��+N���|���ê��R�Z8��S�E��))�T����)<�ؚhM�fi ��G֚co�0+�v�8�j�5Z��p�5a~�ϥ8�C�����sIE\0QE1�/֓v\\q u�̣���g$�I���CEC)�y��TY�4���Q�EV�aEP斊 �\0���Z���i(��\n(���J(ii(���J\0Z)(���(\0��(\0���\0ZJ(������ZJ\0J)i(\0��J\0(���\n(��Q@Ģ���\n(��&)h���-\0�R�@\r���7h���)�b���I�����,FA�j�o�$\Z�II�5�C<SKV�U=T\Z���\Z�r��3V��~�~4}�?S��fF�QZ�����Nhũ��(����\0J)h���Q@E%���斀�J(h����J(h����3IE 4RQ@II�3L��4f�i(���E%\0QE\0��PQE�J)i(QE\0QE�))i(\0�����ZJ\0))h���(RQE Rb��\0J)h���4�hoZ_�Y!EPIKI@Rc�`-b�\0(��@QE\0������(\0�����4�(�Sh��4��4\0�J)(i(��������Q@�Zm\0�Sis@n�4\0QE�%-&(�\0QE\0QE\0�f�\0(��@�Q@Q@ G�PQE\0RR�@Ģ��@(r:�O;Vr]8��\"�G\"ȁ���,Y��80=���:\Z]��T�K�f��9i�Pz�Z)&CL}CEP��(��(��(�QE\0�RR�IKE\0���\0b��S1IN���4��� �IE\0-%f�\nJZJf�)\0QIE\0RQ@�挚J3@��.i�P�E6���������@QE\0%Q@%-\0�R�b����\0(����J(=�������l��9��������bjZ,GC@�tj�HdS�ˀ��9�Eg�*r \"]��i���zSĤu檤� �O>���T��.(��)�O�`��$e�j����Z��[�~��J7CV�d�è����J(h��\0(���IKIL�����Q@�R\0�������\0J)i)(������-%\0�~�J\0N(����(��4ZJ3E\0QE\0f�(\0�.i�PE6���)3K�\0(�\"�R3Fh�\0QE%\0-Q@錡�\r>���ԩ\"4gr�)C��d��U&��ܽ?�4��4����.�v�֠��֭�ؑB�8��Wԗs(��M\rĠ�?�_��&�0;s��x���~U\0����Д�\\ g]��J@\"�i7�j�y�|�rB�t��*z⅗��*Zhd�pï\"�Y���� �F�QMI�r�jz\Z+=%e��V��\n�4�qe�)�\"?CO�$))h�QKE\0%b�\0J)i)\0��ZC@ E-%\0QE\0QIH�(�bQ�ZJ@QI@IE���4P�h�E�10i)٢�4���� �F\r/4��aFisIր�I�0i\0QIFh��;&���Zb���8��@��挚\0Ͳ��?w!��Z�X��G\'�֍��h��C�g%��FMHFiԕ�!)�/��UwO� �w�\0�P@ �2*���҆N�����Ѫ�m�~�eYs����T7z�$#��ӟ�О[��A�{Uv=�\Z��u�?̉���*�������a��q�5[��`~�HD&��s+/QL4�\Za�]�{�GJO3xVN\r�2��\\\Z�&u��T�CJ���M�����\n~�2�n�5����b�V=U�E2\r\n*�w8<��*�|\Z�$�i�����%P�����%-%\0QE\0%Q@%-% \n(���Q@ ER(��\0����(�R\0�Q@����J(\0���ih�Q�u%\0\'b��M sG\"��19��\\�(3Fhǵ��\"m%XqU�v��#���q���+>Tܸ�:T��e5��F���ӫ6�}���C�ڴjd�ƝŦȂD*{Ө��wC!SV`�����^C�&����F�㸭>$#R��&ހ��O�\0�t4�cz�R\Zw����M�~a�\r5�0��Ь���d��Lmџji9�9�O-��<\Zz���FHN���k��� \rf3���RG;����ð&j,�}Xpy���Q���ާ=*v}Y����\n��2��֥YA��4�%��ᕺ\Z*�>�������>世(��en�S��5wL�X))i(\0��J\0(��C\n(��\n(����)\0�QE\0QE\0&(�P1(���IK�Nh\0��(Q�)(sFi(���J)���QHm4�u-\0G����*��lmá�t�S|e{�����*ۗ�_���L�*;��r���n�,f��y4�#zT����e�yWc ȭ\0��G�� �� `V���-���)�:FH�AT�Y�BQs��W8_bT��1��p^���5hH���-5�i�R)�S��R\0F\"�K^W���f�����]���`s�j���\0~\"�0�j�ɱ\Z*�)�#��X�m%1#����j7WR\rdӔ�9RA�qi*Nk.�Nn�_��)���>������{/CN\"�˟j�%K�хL�#t5���ޚ���R�BqLԢ��˯�%�7^*��%ŢZ(��� E-% њ)(h��4\0�Rf��\nJ(��(�aEPQKIH�QE\0&))�P1�R���(��\0Nih��%-\0QP��h�I���/Z.;\r���J}B���������k�\r$M�ǥY�M��Q�Q����Mj���S��I�pi��@�wdS��|ڝ�ҳ��;Ք�c�Zs\n�-�����O,�>�E�Pd�9r�9��h9n6��3����U �\"�d���ڨ>Ns5+��-��\'WAdV)Z��ϑ�iN=PE�e�M��\"�,J�<?Ŀ��4��l)�n�-�:�;�R+d�C���86|;���+\"���v�2���j�v�O�P^ONƱ�J�V#�\rtN%<0��m�nYC�������Fa�Nthܫ�0�)��\'��h�7n�����\0!�+.���|�*A������H�Q��i~O/�*\\X�Lĩ�+��4�*8ʰ4�Qa��F^��K��Y��z\Zz���v�ɚ�*7CO�Yjކ�I�j����^��[�z����j�L�0����%-�3E%\0�Rf���IE\0QE\0QE\0QE\0���\0Q�(�bb�\ZZk���4�5�w{�U\rGyx_*�*�%� \\/aZF\'$Ѽ��p(�j�jS��@4�kt�T5q�b�9���O�N��6�w�n��+2�q��h�,=j\0qO�Ӱ��P�JF;�HL�ՋI0�CҠ8��\"���cM� �q�P]G�\0-�R��dj���jB21X��.�[��b1V�X�?-��=*������JښpI�}�j˷��b�Q�\n�J̴�:�(�1���Y�yo���Z4�c!SN.�L��أ���\n1���I4�:�������*��v�*���i���r�Ͳ\\.�\Z��-䁰���t5��8Φ;$\\Mj�dj�v�ԟM-c��T%�H��hȩ)�i6�p�YXu曊(z�2�^)�T�A#/CS�-�\"�ï5Ug�*P��9�i��L��)�5*�GCT�C2�56��u��ej�YGq��[=\r5&��f����k!�e�֩I�OIMWV�i�B\nJZ((�R\0�-%%�SsK�\0ZJ(�0\n(��\n(��7k�94�ijL�.I��nnZS������bX�f�w���[-#6x)�v$Z(��\Z��QY�o���r|�a�Pz��R1����)�����h��L�4�#�F�88#���*qV`�IN��\Z��_˦��R�F���B`Ih�%;EY95IN�\r�W���sܴG<~dgGJ�##��kR�]��7����U�RE?�j弽3U\\Q`֭]��`r)j$*z��N��QH\nw��o�5Tը�A�k-���OcZ��X�8GZ��z�>�Y�T?QD����vS�����YK�Ѹ�r�0pEQ<ЬT�qZ)�yI�����P�t�r�L�)��j��ï5\"Χ�*������p�T��aj�b�.�5R[��nE=S$��U�줏��ګc�E������E0%Y���J�+t<�Z*\\S)I�h�A��#/|ԫ2��T8�U�eea�f�Y��\rV�#.�\"�YH�TU�zΤY�q�\0���RCTC�Ӄ���LV.QP,(pi�VE�)�J(��ĥ��������G$���e��4��N��@R�����:i���$Ka���I=i�zӪ�������������)6�Qp��N)��9������ӓ֟�u���{�AL�f7\n\0��mh5����q�\"�i5���y�N\0<�TR(��C/ۿ�mʟ���ޠ=�+Y|��l���Z�M�:75\rY�����ͺ!�8�&��|HW�R�Ш�K�ٓ̌��O��Y&Y�zsڣ�j��l�=���Ú鋹��q2������h$��%�\r���FE�p��)�T=U03���E�Ẽ�U)�4Ņ8-.�iXD;)ɔ`}*LQ���Ŝ��Ɛ�b9\\zS�fP\nB(�P!���x��`��qN������2�I���i����E�e�e�~aPV���]��}kE.丕h�:�84ڲ�(�V*x8�V�ʡ�����t9�U�J�faבP�إ\"������^j�[��ISa�@���oCUi�����r*E�֩���2�=(�`ij\0M8=�*���O#5\r���0:�ȖV��M4��\\���d��Rx����\'qKc�Zh4�U�Ҋ�\ZR٥a�\'<R\nAN\0�K�#&yQ;��\n��3�AQ�Ub��k��9��Ls�\0�8��Fi_;P�\"�9��4r8+u��D0�>u�o�x5�Wt�Bz0ȥ.��bB6�;\Z �{RR(�R;��;i�n�l�;Vf�܆�7Ñ�y����0k*D�#\'��i��I����@:\nr�@��j��d1\\��ԩ:�\0��2��Q�E=l_VV�i���������/���8��E��5���F�S�U;7V\'���Ý�\\\0F}*��q:Vղ���\r�������B�h$��\"�d\ZY��l�k=�H?��Em\ZT�U���\rS�85\r4Ri��N�!��R�@)g�)Sr0y.>�e�?Z��ƭ12*Jsr:Sj�\n)h����\0Jr����h�Ip��Ճr\rgR�9����4�Ҫ�+>Cv�+ҧa�,�=�A\"��T�7�4X\n��̢���ӎI��Z�X�1�jJ�%P�����\nJZ(\0����e�KH�tS�\n+QKKZa(4����`sl���Td�H�\r0�z�Hm�94�QT@T��ys��i����r�6NH�܊�V����rw^\rU�F�B8�mg}ꇐNGI�p���M��_SP6��UK�ë��\Zm�4wd��@��Y���ƳQkR���pqN\rM9��5�#��85E&�Jø��w�RѴ���N�!ɰ�z�S�ny^�J�O��Hn��S%tvf���7��>0zS2ʼnb=)���Ȭ�lS��u^?�@|Ⱦ��@n�}* p�R}Iq]\n�9�R���Π)�T��)��.n�:��T��\rrJJ��)���i�S��84�VeM�#�W�Z�rX�QE1Q@Q@ E-%\'������ҩZ�����ҡ�>��d�p��2o�i���@�h�$���%+u��QE(��\0(��\0��)sLO�)��EC\nN��� �IKF(1KE�EP�B�dUr0H=���ʙ[�����rGF��fWB\nfv��iƘ��R%��!��>�U*��ϔޫT���-��zѺ�����ۈݶ��jyl���=*�X��xx?2�\Z����%�A)qW$E�?6.��T���\ZV�EIHMRb!a�J�����\rX�j�����T�B���f��ⱚ�5���)$��j��{���*FP��@P\0qI;�y�t��M�Gn���\"Hr��M@\rH��@�aM:�SRY�Z�(4�J�d�!�����vS��*locL�w (��\0(��\0(��\0���a�U��Tm���uzT��p���\r*�4�����C��Pz�Y$m��J�M%P���(QE\0QE\"}�uF��N�HciqE!9�PP�M-�(qFh\0�\\b� �Z)h<Ph�!4���U�>m�?t��\n�`w !?�2)Kk�$��v�F ��=\rl�uͬ\r튩V����ϡ�T�; ������QE\'���/�\'��7��q\"���u�Z6���F��̽*$��q}\n��\ZC�y��;\\�ZZC֚&@#��@w(a�f��Bѷ@u⢢���$wT�}�����!��\r�oL����Ѫ3&��y�BZ!����B�Ѕ�\'����j\Z(�t����PPQKIH��\\UB0qWqP\\\';�~�q}�\r- ��%Q@Q@�-�\0֊��*��E_N�q��IG�i/�5 g�4QފБ���6�����QE(��\0(��\0(��\0^M.1N��J��f3Ҝi��\'֕�%Z ��E�)4�ipM�!1E-%`��\'�2��棢�\\�x�g$tnEV-�CH��KJe$��m9ӛ����jۛ9��5Tзc`i)M%Q,(��f�M�#Ѹ�Ԡ�AE&��4��7����cȪ�z���9Gq�T�c�lJF�����m[�o���f�T���u�┕�1њT��Q\\��MAr���:�X���A�i�f�4ڑ�k{S���:�؊蹛CT���0����M�T�1�z�����\"���IE ��S\\nR)ƒ��QRN1\'֜mV�%\"\Z*R��S\\vKF(�!��\0�Z������֊�*$��e���:�&�\0VjFgw�����\ZJV�ITHQE\0QE\0QE\0QE>\0���v�\\p�\\d��A�T�U��ɩ&����Q�T�����;�F)�JCJi1E�i���1H,6�ZJ\0(���&��\"ȭ��3PR��@��h���@QE\0QE~����ץR�:s휡�⢝<��}��Z6�7C)\r-BJ#�����9�5�n�}G-r�gct��^�N�q oQP��E[�\\ǟJ��[E��9�� <)���Ud��i*r�\rJ���\Zi�4�9斤������!Ȼ�i�h�0I����q����*6�v��!Qq\"�z�Q�f+�E���^�2C�2_�jCQ���Ԍ��hw4V�n��!Z��\n^Ԕ�����(\0��(\0��(LӋ3(^R���\0Q���u��F3N�F)��Q�~)�HjM��)1��%;c�n)h���EP!(��d�EP ��(Ѿ��c��~�e�taTj�\0����ҢZ4ˏb�-%C\Zz�Jz�S3-X�%��c5h6j0s!�\nd���?�LV2�塪vE�*8�W\Z���#��#�VqⴻU �l�*�ɐg\"��i�Ӂ�n0�RT��iJw%ǰ��{T�1��Q�J,���hO�ߕ(�OPj�.��jy�ˡ�ԏS����{���Ջ)��R�99p:j6��j�����ze59�fϽ74QVKw~���ȬZ�j$8�z�s�5!�Q��\rAfgz(�GzԁP�E1�\r\0��Oq��GP��E�\n(��\n(��\n(��\'ǭJP3N�/�.)qE\nLS��L�ӱN b��ƞzRRp)�ސ4�N4�R1�R�m0\n(���(�BQE�\n(��\n���K�z��Rۿ�:�l�S%t8�1v�_CM���|�\0z�Н�b5%)��!�h����j�1���5�c��gԓY���Q�Od\nJ���V���\r����U8�Jm\Z��V�^U�x�c���ȩ݄����f���/tU��+BEӃ\neXw�v�R�w����k�QO({SqEɰ���AE��\"R7\r��\0�J����H6�+���c@QNa�����[��Z�r�}�$TI\rG\'�4�Q��MAFi�h��4V��=jD�q�QӐὨbB��J|���)�aEP ��(\0��(�(���R�J(��)v��@��zCJh4\0�M\"�i��\r4�N&�}�F4�u��!������))�R�@ E-%\0QE/\\~��9;��N�Z2 \"?QU}��\Zn�6�zSj�f�&�?�&��No����Y��9QVHR�9�P����qM���rx#�7R�hTf3�zU1���AxW/#֓O��Or��4��В$�w)�ERe*Ha�)\'r�\r�A�)(�4��9�Ma�wDtPh� xs�7�=��OC�cL��P���(կҲ�t�Ks���TH���Q��MHj9>��-��\ZJS��%j@�(��$��J����8��=��(����(��(��Rњ\0�PsN��@�9��L��<R�!)�)��\0Ji4���c���$�E<��h��i��i\0��R�� E-���Fh\0���� ��(-��T��N����RT�EEKJ�ܫ�%( RS���B����p=H�Z\Z��{�}D6�\n(�����(\0��(\0��(X\'h[�W��Ϋqu�ڳ*Ť�[�����uE\'�B0pi1V���1��Z���g�)�\Z�Ԕ����QE\nӶ?�O�fV��0-L��9������S$�k2��~��4��\ZCZ�6�(�HT��\\�t�=�&46�V4��QE\0QE\0^��h��Pt����Θ�����ȧ�\0:c� �ހqI�M;���t�cKHzP!��i��O4��HWi����b�f��i5#IE%\nJZ)�)(���P0�����%Kj3r�Z���O*U|g��[�5�A�T�{�IS����v nQEP��(��(��(��(�\rw�`�rG����zS�[2��[�Ā��l�i� &��*�!��4��aEP �C���k>�ٟ��L�*;�Jd�\r<��ߡ��F{}�M�o�i+RD��)�QE\0QE\0QE\0QE\0hf�QKL��GHOaILB䟥����9���Kڐ�)�Ji4��&3ׁ@h�/\"��`4�M�O�4Ԕ4�\r;��h�<RR(��b�\\R‰������\nJ(�HQE\0QE\0QKI@Q@Q@Q@Q@[�ٔ���^����@��;V��}�Ǧj%�.;(�����M�K\n(��[�?.=��X�<�)l5�{�j9:S����+2ўz�JS��V��ES$(��\0(��\0(��\0(��\0��9��=)1���)�\0R�s�E1旵&h�P��юh�1�A�⓿4�14�b�qL�h�i4�M4�n)\r8�M �M:��cE8\nv1F1RqA?��MIE�\n(��R�@�����C� ���d�Q@Q@Q@Q@h[���{b����|���52ب�Va�G�%Ip13~u40�ө��aEP ����AR�z�{\rn]S�~Zj�(c��e�[�\ZJV�ƒ� J(����(��(��(��(���!撗8�1GiR��j���ZP)@�^����N�`�=���(���@\'z;њJ\0C����)����\0��N��\0CIN4���4�)q�_�!��>��isM&�\0���E��(\0��Z�\nZ) �=��J)i�p��ZC����S�R�P ��(\0��(\0���%Ǩ�)���T��{\rnOx>u>��U˱���5N�v)�M4�\Z�X�QE\n��I�4��[�TӺ�0R���e\"�}�IJ�x�i�d���)�(��\0(��\0(��\0(��\0��3�S�<rj�\0S�) ����p���/JoJ3�\0.i3Fx��qLB�g�3IL�iI⛚\0;QK�P\0��E���4�N&�M\0&�ih� �\r8�q@Ģ����H �Z?�!4Bi)h�2w\nZ(�;%PE��QE\n(��\n(��\n(��/��ۓ�3Tj���\0�Sa�#Ң=�bPh�ՒĢ�(S����|z�\Zܰ(�i��AD\r��6��x�kBXQE(��\0(��\0(��\0(��\0�>�gғ�(��BњL�ր���L��))3�LB�CHM�%*�4�zџʓc�R\Z ��H`M4�M4�\0 �\"�z_�\0 QA�� K��)qG_�!�ӥ\'_�;�S���\'?JJZ\\z�!1E.)\rEPHh4� ���)�QE\0QE\0QE\0QE\0Z�n}�Q\\\r�7�Kjq.=E:�|�}EF�/��*��(�AN����h�T*�q�T��TX��7SIJz�U�QE\0QE\0QE\0QE\0QE\0Zh����h()GZJQ֘%-\'cM;RQ�4S��:{�;S�AC{�y4w���1��N���i��4��_ZCK�M=))�)���Hb�R��� �Hb9��s���GL�J>�% �R�J`Qފ\0mQL���(\0��(\0��(\0��(\0��(�J�Z�u�֫���~�b��X�Խ�[i)i*�QE\n(��\n�PEPEPEPEPEPEP��','いじっぱり','isucon1','2021-06-03 15:58:09.000000','2021-07-04 04:41:50.000000') /*... omitted ...*/\G
# Query 2: 0 QPS, 0x concurrency, ID 0x1A3620DEDAEAD803 at byte 964137 ___
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:45
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 11 25
# Exec time 15 69ms 2ms 4ms 3ms 3ms 293us 3ms
# Lock time 3 837us 26us 57us 33us 47us 8us 28us
# Rows sent 20 28 1 4 1.12 0.99 0.57 0.99
# Rows examine 99 47.23k 1.88k 1.95k 1.89k 1.86k 0 1.86k
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 1 10.02k 395 725 410.24 381.65 66.24 381.65
# Query size 1 10.41k 423 429 426.36 420.77 0 420.77
# String:
# Databases isucondition
# Hosts 192.168.0.21
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu'\G
# SHOW CREATE TABLE `isucondition`.`isu`\G
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT isu.id, isu_condition.jia_isu_uuid, isu_condition.timestamp, co.condition FROM isu INNER JOIN ( SELECT jia_isu_uuid, MAX(timestamp) as timestamp, `condition` FROM isu_condition GROUP BY jia_isu_uuid ) as isu_condition ON isu.jia_isu_uuid = isu_condition.jia_isu_uuid JOIN isu_condition as co ON isu_condition.timestamp = co.timestamp AND isu_condition.jia_isu_uuid = co.jia_isu_uuid WHERE isu.character = 'いじっぱり'\G
# Query 3: 0 QPS, 0x concurrency, ID 0x5028C7E1D44486E5 at byte 951551 ___
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 13 60ms 60ms 60ms 60ms 60ms 0 60ms
# Lock time 3 927us 927us 927us 927us 927us 0 927us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 46 618 618 618 618 618 0 618
# Bytes sent 0 81 81 81 81 81 0 81
# Query size 0 256 256 256 256 256 0 256
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
ALTER TABLE isu_condition ADD COLUMN condition_level VARCHAR(255) AS (CASE (LENGTH(`condition`) - LENGTH(REPLACE(`condition`, "=true", ''))) / LENGTH("=true") WHEN 0 THEN "info" WHEN 1 THEN "warning" WHEN 2 THEN "warning" WHEN 3 THEN "critical" END) STORED\G
# Query 4: 0 QPS, 0x concurrency, ID 0xDEE3EF20F3B5B682 at byte 834530 ___
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 6 31ms 31ms 31ms 31ms 31ms 0 31ms
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 46 618 618 618 618 618 0 618
# Bytes sent 0 56 56 56 56 56 0 56
# Query size 11 110.05k 110.05k 110.05k 110.05k 110.05k 0 110.05k
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
INSERT INTO `isu_condition` VALUES (1,'eb104b95-3532-4828-8550-89da717b9667','2021-06-03 15:59:09',1,'is_dirty=false,is_overweight=false,is_broken=false','わ、わるくないね!','2021-06-03 15:59:09.000000') /*... omitted ...*/\G
# Query 5: 0 QPS, 0x concurrency, ID 0x08EBCE5DB9749F07 at byte 953815 ___
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 5 23ms 23ms 23ms 23ms 23ms 0 23ms
# Lock time 0 60us 60us 60us 60us 60us 0 60us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 28 28 28 28 28 0 28
# Rows affecte 2 28 28 28 28 28 0 28
# Bytes sent 0 54 54 54 54 54 0 54
# Query size 0 25 25 25 25 25 0 25
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu'\G
# SHOW CREATE TABLE `isucondition`.`isu`\G
UPDATE isu set image = ''\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select image = '' from isu \G
# Query 6: 0 QPS, 0x concurrency, ID 0xB13D400C8A2303CD at byte 17219 ____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:39
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 3 17ms 17ms 17ms 17ms 17ms 0 17ms
# Lock time 1 439us 439us 439us 439us 439us 0 439us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 11 11 11 11 11 0 11
# Query size 0 424 424 424 424 424 0 424
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu'\G
# SHOW CREATE TABLE `isucondition`.`isu`\G
CREATE TABLE `isu` (
`id` bigint AUTO_INCREMENT,
`jia_isu_uuid` CHAR(36) NOT NULL UNIQUE,
`name` VARCHAR(255) NOT NULL,
`image` LONGBLOB,
`character` VARCHAR(255),
`jia_user_id` VARCHAR(255) NOT NULL,
`created_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6),
`updated_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select =utf8mb4 from CURRENT_TIMESTAMP(6),
PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARACTER \G
# Query 7: 0 QPS, 0x concurrency, ID 0x22313DA6B4D40EE9 at byte 18897 ____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 3 14ms 14ms 14ms 14ms 14ms 0 14ms
# Lock time 0 89us 89us 89us 89us 89us 0 89us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 11 11 11 11 11 0 11
# Query size 0 157 157 157 157 157 0 157
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_association_config'\G
# SHOW CREATE TABLE `isucondition`.`isu_association_config`\G
CREATE TABLE `isu_association_config` (
`name` VARCHAR(255) PRIMARY KEY,
`url` VARCHAR(255) NOT NULL UNIQUE
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4\G
# Query 8: 0 QPS, 0x concurrency, ID 0x1E3FF025002EC3E9 at byte 9403 _____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:18
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 3 14ms 14ms 14ms 14ms 14ms 0 14ms
# Lock time 56 14ms 14ms 14ms 14ms 14ms 0 14ms
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 1 1 1 1 1 0 1
# Bytes sent 0 11 11 11 11 11 0 11
# Query size 0 57 57 57 57 57 0 57
# String:
# Databases mysql
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `mysql` LIKE 'help_keyword'\G
# SHOW CREATE TABLE `mysql`.`help_keyword`\G
# EXPLAIN /*!50100 PARTITIONS*/
select count(*) into @discard from `mysql`.`help_keyword`\G
# Query 9: 0 QPS, 0x concurrency, ID 0x454A9EAE94FF551B at byte 17878 ____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 3 14ms 14ms 14ms 14ms 14ms 0 14ms
# Lock time 0 117us 117us 117us 117us 117us 0 117us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 11 11 11 11 11 0 11
# Query size 0 360 360 360 360 360 0 360
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
CREATE TABLE `isu_condition` (
`id` bigint AUTO_INCREMENT,
`jia_isu_uuid` CHAR(36) NOT NULL,
`timestamp` DATETIME NOT NULL,
`is_sitting` TINYINT(1) NOT NULL,
`condition` VARCHAR(255) NOT NULL,
`message` VARCHAR(255) NOT NULL,
`created_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6),
PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4\G
# Query 10: 0 QPS, 0x concurrency, ID 0x1EDCD938F3FE2419 at byte 18497 ___
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 2 12ms 12ms 12ms 12ms 12ms 0 12ms
# Lock time 0 81us 81us 81us 81us 81us 0 81us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 11 11 11 11 11 0 11
# Query size 0 165 165 165 165 165 0 165
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'user'\G
# SHOW CREATE TABLE `isucondition`.`user`\G
CREATE TABLE `user` (
`jia_user_id` VARCHAR(255) PRIMARY KEY,
`created_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6)
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4\G
# Query 11: 7.20 QPS, 0.00x concurrency, ID 0x99AA0165670CE848 at byte 954077
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2022-07-17 18:26:40 to 18:26:45
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 16 36
# Exec time 1 8ms 89us 969us 212us 515us 154us 159us
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 1 11.12k 52 721 316.36 592.07 155.60 313.99
# Query size 0 1.05k 30 30 30 30 0 30
# String:
# Databases isucondition
# Hosts 192.168.0.21 (27/75%), 192.168.0.41 (9/25%)
# Users isucon
# Query_time distribution
# 1us
# 10us #
# 100us ################################################################
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
administrator command: Prepare\G
# Query 12: 0 QPS, 0x concurrency, ID 0xD8294721252CC94E at byte 953227 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 1 5ms 5ms 5ms 5ms 5ms 0 5ms
# Lock time 1 316us 316us 316us 316us 316us 0 316us
# Rows sent 20 28 28 28 28 28 0 28
# Rows examine 0 28 28 28 28 28 0 28
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 96 757.99k 757.99k 757.99k 757.99k 757.99k 0 757.99k
# Query size 0 36 36 36 36 36 0 36
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu'\G
# SHOW CREATE TABLE `isucondition`.`isu`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT jia_isu_uuid, image from isu\G
# Query 13: 0 QPS, 0x concurrency, ID 0x358C7309C5D089D9 at byte 19289 ___
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 1 5ms 5ms 5ms 5ms 5ms 0 5ms
# Lock time 3 758us 758us 758us 758us 758us 0 758us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 50 50 50 50 50 0 50
# Query size 0 82 82 82 82 82 0 82
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
CREATE INDEX idx_jia_isu_uuid_timestamp ON isu_condition (jia_isu_uuid, timestamp)\G
# Query 14: 0 QPS, 0x concurrency, ID 0x2DB9FB7816AA5A1B at byte 1939 ____
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:18
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 1 5ms 5ms 5ms 5ms 5ms 0 5ms
# Lock time 0 222us 222us 222us 222us 222us 0 222us
# Rows sent 0 1 1 1 1 1 0 1
# Rows examine 0 7 7 7 7 7 0 7
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 63 63 63 63 63 0 63
# Query size 0 79 79 79 79 79 0 79
# String:
# Databases mysql
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `mysql` LIKE 'user'\G
# SHOW CREATE TABLE `mysql`.`user`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT count(*) FROM mysql.user WHERE user='root' and password='' and plugin=''\G
# Query 15: 0 QPS, 0x concurrency, ID 0x3675710D3B4B2E82 at byte 16102 ___
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2022-07-17 18:26:39
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 1 5ms 5ms 5ms 5ms 5ms 0 5ms
# Lock time 3 828us 828us 828us 828us 828us 0 828us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 11 11 11 11 11 0 11
# Query size 0 45 45 45 45 45 0 45
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_association_config'\G
# SHOW CREATE TABLE `isucondition`.`isu_association_config`\G
DROP TABLE IF EXISTS `isu_association_config`\G
Top 20 Sort By Total
Count Total Mean Stddev Min P50.0 P90.0 P95.0 P99.0 Max 2xx 3xx 4xx 5xx TotalBytes MinBytes MeanBytes MaxBytes Request
1942 700.024 0.3605 0.4463 0.000 0.004 1.001 1.003 1.015 1.066 1376 0 566 0 12211314 0 6288 10651 GET /api/trend HTTP/2.0
110472 307.424 0.0028 0.0050 0.000 0.001 0.007 0.012 0.023 0.104 110418 0 54 0 70 0 0 14 POST /api/condition/[a-z0-9-]+
12426 200.929 0.0162 0.0176 0.000 0.011 0.037 0.049 0.079 0.306 11883 0 543 0 62305241 0 5014 7314 GET /api/condition/[a-z0-9-]+
6458 189.169 0.0293 0.0257 0.000 0.022 0.058 0.071 0.107 0.650 6377 0 81 0 16648911 0 2578 4666 GET /api/isu HTTP/2.0
13536 123.331 0.0091 0.0095 0.000 0.006 0.021 0.027 0.044 0.276 13022 0 514 0 177796948 14 13135 135259 GET /api/isu/[a-z0-9-]+
4544 55.788 0.0123 0.0153 0.000 0.008 0.027 0.036 0.059 0.321 4203 0 341 0 23427091 0 5155 9232 GET /api/isu/[a-z0-9-]+/graph
2030 8.332 0.0041 0.0053 0.000 0.002 0.010 0.014 0.026 0.072 1406 0 624 0 7176 0 3 19 POST /api/auth HTTP/2.0
2405 6.375 0.0027 0.0043 0.000 0.001 0.007 0.010 0.020 0.068 1172 0 1233 0 69152 21 28 46 GET /api/user/me HTTP/2.0
89 6.109 0.0686 0.0178 0.002 0.065 0.086 0.101 0.123 0.123 85 0 4 0 11838 15 133 157 POST /api/isu HTTP/2.0
1237 4.678 0.0038 0.0053 0.000 0.002 0.009 0.014 0.025 0.068 1157 0 80 0 1680 0 1 21 POST /api/signout HTTP/2.0
1 0.415 0.4150 0.0000 0.415 0.415 0.415 0.415 0.415 0.415 1 0 0 0 23 23 23 23 POST /initialize HTTP/2.0
1216 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 1216 0 0 0 3994560 3285 3285 3285 GET /assets/logo_white.svg HTTP/2.0
1216 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 1216 0 0 0 32427072 26667 26667 26667 GET /assets/index.23dac98b.js HTTP/2.0
1216 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 1216 0 0 0 719872 592 592 592 GET /assets/favicon.d0f5f504.svg HTTP/2.0
1216 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 1216 0 0 0 903995072 743417 743417 743417 GET /assets/vendor.ee7444dd.js HTTP/2.0
1215 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 1215 0 0 0 3994920 3288 3288 3288 GET /assets/logo_orange.svg HTTP/2.0
1216 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 1216 0 0 0 23184256 19066 19066 19066 GET /assets/index.144d8ca8.css HTTP/2.0
11 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 11 0 0 0 5808 528 528 528 GET /isu/[a-z0-9-]+
5 0.000 0.0000 0.0000 0.000 0.000 0.000 0.000 0.000 0.000 5 0 0 0 2640 528 528 528 GET /isu/[a-z0-9-]+/graph
# 52.9s user time, 330ms system time, 33.40M rss, 40.59M vsz
# Current date: Sun Jul 17 09:31:29 2022
# Hostname: ip-172-31-36-253
# Files: logs/20220717_183021/mysql-slow.log
# Overall: 456.87k total, 99 unique, 4.97k QPS, 1.46x concurrency ________
# Time range: 2022-07-17 18:28:33 to 18:30:05
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 134s 0 979ms 293us 287us 6ms 33us
# Lock time 2s 0 15ms 5us 18us 104us 0
# Rows sent 8.60M 0 2.15k 19.75 0.99 144.12 0
# Rows examine 21.83M 0 152.97k 50.10 0.99 1.54k 0
# Rows affecte 152.89k 0 1000 0.34 0 15.20 0
# Bytes sent 1.34G 0 757.99k 3.09k 755.64 21.15k 69.19
# Query size 47.18M 6 790.36k 108.29 130.47 2.49k 31.70
# Boolean:
# QC hit 22% yes, 77% no
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============= ====== ====== ===== ==============
# 1 0x1A3620DEDAEAD803 46.6829 34.8% 1600 0.0292 0.28 SELECT isu isu_condition
# 2 0xF3E2A0049B030C70 43.1063 32.2% 10060 0.0043 0.01 SELECT isu_condition
# 3 0x99AA0165670CE848 16.3353 12.2% 144483 0.0001 0.00 ADMIN PREPARE
# 4 0x23D19AC409FD97AF 8.6388 6.4% 33504 0.0003 0.11 SELECT isu_condition
# 5 0x25657C305C0ED778 5.7031 4.3% 241 0.0237 0.10 INSERT isu_condition
# 6 0x83E8898FB5772002 5.0474 3.8% 4759 0.0011 0.09 SELECT isu_condition
# 7 0xA2D1B74705103105 1.9548 1.5% 38992 0.0001 0.00 SELECT user
# MISC 0xMISC 6.5216 4.9% 223227 0.0000 0.0 <92 ITEMS>
# Query 1: 25 QPS, 0.73x concurrency, ID 0x1A3620DEDAEAD803 at byte 150274676
# Scores: V/M = 0.28
# Time range: 2022-07-17 18:29:01 to 18:30:05
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1600
# Exec time 34 47s 24us 979ms 29ms 230ms 90ms 3ms
# Lock time 3 77ms 0 8ms 48us 63us 290us 25us
# Rows sent 0 5.47k 1 9 3.50 6.98 1.84 2.90
# Rows examine 61 13.32M 0 152.97k 8.53k 65.68k 24.47k 1.26k
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 1.02M 395 1.25k 670.92 1012.63 202.12 592.07
# Query size 1 666.19k 423 429 426.36 420.77 0 420.77
# Boolean:
# QC hit 7% yes, 92% no
# String:
# Databases isucondition
# Hosts 192.168.0.21
# Users isucon
# Query_time distribution
# 1us
# 10us #######
# 100us #######
# 1ms ################################################################
# 10ms #############
# 100ms ######
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu'\G
# SHOW CREATE TABLE `isucondition`.`isu`\G
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT isu.id, isu_condition.jia_isu_uuid, isu_condition.timestamp, co.condition FROM isu INNER JOIN ( SELECT jia_isu_uuid, MAX(timestamp) as timestamp, `condition` FROM isu_condition GROUP BY jia_isu_uuid ) as isu_condition ON isu.jia_isu_uuid = isu_condition.jia_isu_uuid JOIN isu_condition as co ON isu_condition.timestamp = co.timestamp AND isu_condition.jia_isu_uuid = co.jia_isu_uuid WHERE isu.character = 'ずぶとい'\G
# Query 2: 164.92 QPS, 0.71x concurrency, ID 0xF3E2A0049B030C70 at byte 64011507
# Scores: V/M = 0.01
# Time range: 2022-07-17 18:29:00 to 18:30:01
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 10060
# Exec time 32 43s 132us 302ms 4ms 11ms 7ms 3ms
# Lock time 15 350ms 9us 10ms 34us 57us 164us 19us
# Rows sent 93 8.05M 0 2.15k 839.21 1.69k 534.00 755.64
# Rows examine 36 8.05M 0 2.15k 839.21 1.69k 534.00 755.64
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 87 1.18G 589 337.58k 122.56k 257.47k 78.03k 112.33k
# Query size 3 1.51M 148 157 157.00 151.03 0.07 151.03
# String:
# Databases isucondition
# Hosts 192.168.0.21 (6028/59%)... 1 more
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us #############
# 1ms ################################################################
# 10ms ######
# 100ms #
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = 'cca09c1e-7a06-4371-bb4a-540b6947b0d2' AND `timestamp` < '2021-08-18 11:05:01' ORDER BY `timestamp` DESC\G
# Query 3: 2.12k QPS, 0.24x concurrency, ID 0x99AA0165670CE848 at byte 157138839
# Scores: V/M = 0.00
# Time range: 2022-07-17 18:28:56 to 18:30:04
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 31 144483
# Exec time 12 16s 35us 28ms 113us 176us 340us 76us
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 4 66.80M 52 131.86k 484.80 652.75 3.57k 136.99
# Query size 8 4.13M 30 30 30 30 0 30
# String:
# Databases isucondition
# Hosts 192.168.0.41 (93365/64%)... 1 more
# Users isucon
# Query_time distribution
# 1us
# 10us ################################################################
# 100us ####################
# 1ms #
# 10ms #
# 100ms
# 1s
# 10s+
administrator command: Prepare\G
# Query 4: 549.25 QPS, 0.14x concurrency, ID 0x23D19AC409FD97AF at byte 150270702
# Scores: V/M = 0.11
# Time range: 2022-07-17 18:29:00 to 18:30:01
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 7 33504
# Exec time 6 9s 12us 357ms 257us 287us 5ms 103us
# Lock time 24 554ms 0 15ms 16us 38us 124us 11us
# Rows sent 0 32.28k 0 1 0.99 0.99 0.11 0.99
# Rows examine 0 16.57k 0 1 0.51 0.99 0.50 0.99
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 1 23.51M 589 778 735.88 755.64 20.82 719.66
# Query size 8 3.99M 125 125 125 125 0 125
# Boolean:
# QC hit 48% yes, 51% no
# String:
# Databases isucondition
# Hosts 192.168.0.41
# Users isucon
# Query_time distribution
# 1us
# 10us ###########################################################
# 100us ################################################################
# 1ms #
# 10ms #
# 100ms #
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = 'aa0979e9-5f5e-43b8-bc8d-68731ae069f8' ORDER BY `timestamp` DESC LIMIT 1\G
# Query 5: 4.02 QPS, 0.10x concurrency, ID 0x25657C305C0ED778 at byte 150332322
# Scores: V/M = 0.10
# Time range: 2022-07-17 18:29:01 to 18:30:01
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 241
# Exec time 4 6s 4ms 606ms 24ms 42ms 49ms 14ms
# Lock time 33 764ms 233us 14ms 3ms 7ms 2ms 2ms
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 99 152.02k 10 1000 645.94 964.41 203.14 592.07
# Bytes sent 0 13.30k 53 58 56.53 56.92 1.44 56.92
# Query size 47 22.19M 1.61k 148.89k 94.30k 143.37k 29.83k 88.02k
# String:
# Databases isucondition
# Hosts 192.168.0.41 (121/50%), 192.168.0.21 (120/49%)
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ######################
# 10ms ################################################################
# 100ms ##
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
INSERT INTO `isu_condition` (`jia_isu_uuid`, `timestamp`, `is_sitting`, `condition`, `message`) VALUES ('6053e708-5b64-4977-a663-a1973ddbeda4', '2021-08-29 09:06:06', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい!'),('6053e708-5b64-4977-a663-a1973ddbeda4', '2021-08-29 09:07:11', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい!'),('6053e708-5b64-4977-a663-a1973ddbeda4', '2021-08-29 09:08:06', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい!'),('6053e708-5b64-4977-a663-a1973ddbeda4', '2021-08-29 09:09:10', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい!'),('6053e708-5b64-4977-a663-a1973ddbeda4', '2021-08-29 09:10:15', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい!'),('6053e708-5b64-4977-a663-a1973ddbeda4', '2021-08-29 09:11:09', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい!'),('6053e708-5b64-4977-a663-a1973ddbeda4', '2021-08-29 09:12:11', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい!'),('6053e708-5b64-4977-a663-a1973ddbeda4', '2021-08-29 09:13:15', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい!'),('6053e708-5b64-4977-a663-a1973ddbeda4', '2021-08-29 09:14:07', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい!'),('6053e708-5b64-4977-a663-a1973ddbeda4', '2021-08-29 09:15:06', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 09:12:27', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 09:13:24', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 09:14:18', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 09:15:25', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 09:16:28', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 09:17:25', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 09:18:25', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 09:19:23', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 09:20:20', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 09:21:19', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('28e360a5-af7c-44c4-b056-738714db7401', '2021-08-29 09:27:26', 1, 'is_dirty=false,is_overweight=false,is_broken=true', '直して!'),('28e360a5-af7c-44c4-b056-738714db7401', '2021-08-29 09:28:26', 1, 'is_dirty=false,is_overweight=false,is_broken=true', '直して!'),('28e360a5-af7c-44c4-b056-738714db7401', '2021-08-29 09:29:30', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直して!'),('28e360a5-af7c-44c4-b056-738714db7401', '2021-08-29 09:30:33', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直して!'),('28e360a5-af7c-44c4-b056-738714db7401', '2021-08-29 09:31:27', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直して!'),('28e360a5-af7c-44c4-b056-738714db7401', '2021-08-29 09:32:33', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直して!'),('28e360a5-af7c-44c4-b056-738714db7401', '2021-08-29 09:33:31', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直して!'),('28e360a5-af7c-44c4-b056-738714db7401', '2021-08-29 09:34:30', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直して!'),('28e360a5-af7c-44c4-b056-738714db7401', '2021-08-29 09:35:25', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直して!'),('28e360a5-af7c-44c4-b056-738714db7401', '2021-08-29 09:36:33', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直して!'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 09:32:06', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 09:33:02', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 09:34:04', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 09:35:03', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 09:36:09', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 09:37:06', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 09:38:11', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 09:39:07', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 09:40:10', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 09:41:07', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 09:28:13', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 09:29:15', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 09:30:10', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 09:31:14', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 09:32:10', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 09:33:09', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 09:34:09', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 09:35:16', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 09:36:14', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 09:37:17', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('dd1bf8c6-92a4-4ff1-9a47-d61341a7336f', '2021-08-29 09:30:57', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直していただけますか?'),('dd1bf8c6-92a4-4ff1-9a47-d61341a7336f', '2021-08-29 09:31:48', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直していただけますか?'),('dd1bf8c6-92a4-4ff1-9a47-d61341a7336f', '2021-08-29 09:32:47', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直していただけますか?'),('dd1bf8c6-92a4-4ff1-9a47-d61341a7336f', '2021-08-29 09:33:51', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直していただけますか?'),('dd1bf8c6-92a4-4ff1-9a47-d61341a7336f', '2021-08-29 09:34:48', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直していただけますか?'),('dd1bf8c6-92a4-4ff1-9a47-d61341a7336f', '2021-08-29 09:35:49', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直していただけますか?'),('dd1bf8c6-92a4-4ff1-9a47-d61341a7336f', '2021-08-29 09:36:50', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直していただけますか?'),('dd1bf8c6-92a4-4ff1-9a47-d61341a7336f', '2021-08-29 09:37:55', 1, 'is_dirty=false,is_overweight=false,is_broken=true', '直していただけますか?'),('dd1bf8c6-92a4-4ff1-9a47-d61341a7336f', '2021-08-29 09:38:50', 1, 'is_dirty=false,is_overweight=false,is_broken=true', '直していただけますか?'),('dd1bf8c6-92a4-4ff1-9a47-d61341a7336f', '2021-08-29 09:39:48', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直していただけますか?'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 09:27:04', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 09:28:06', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 09:29:03', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 09:30:08', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 09:31:03', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 09:32:07', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 09:33:00', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 09:34:00', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 09:35:05', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 09:36:07', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('7e9c1ff7-6a08-40a2-87fe-51dc558ca528', '2021-08-29 09:26:23', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('7e9c1ff7-6a08-40a2-87fe-51dc558ca528', '2021-08-29 09:27:23', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('7e9c1ff7-6a08-40a2-87fe-51dc558ca528', '2021-08-29 09:28:26', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('7e9c1ff7-6a08-40a2-87fe-51dc558ca528', '2021-08-29 09:29:22', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('7e9c1ff7-6a08-40a2-87fe-51dc558ca528', '2021-08-29 09:30:19', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('7e9c1ff7-6a08-40a2-87fe-51dc558ca528', '2021-08-29 09:31:18', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('7e9c1ff7-6a08-40a2-87fe-51dc558ca528', '2021-08-29 09:32:27', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('7e9c1ff7-6a08-40a2-87fe-51dc558ca528', '2021-08-29 09:33:24', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('7e9c1ff7-6a08-40a2-87fe-51dc558ca528', '2021-08-29 09:34:21', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('7e9c1ff7-6a08-40a2-87fe-51dc558ca528', '2021-08-29 09:35:22', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 09:24:32', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 09:25:39', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 09:26:36', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 09:27:39', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 09:28:36', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 09:29:40', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 09:30:40', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 09:31:34', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 09:32:31', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 09:33:34', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 09:42:24', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 09:43:28', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 09:44:24', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 09:45:21', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 09:46:25', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 09:47:28', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 09:48:24', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 09:49:28', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 09:50:30', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 09:51:20', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('44b88843-d4c2-45ec-8fb6-f17fbeda8a26', '2021-08-29 09:46:05', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'こわれたね〜'),('44b88843-d4c2-45ec-8fb6-f17fbeda8a26', '2021-08-29 09:47:10', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'こわれたね〜'),('44b88843-d4c2-45ec-8fb6-f17fbeda8a26', '2021-08-29 09:48:08', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'こわれたね〜'),('44b88843-d4c2-45ec-8fb6-f17fbeda8a26', '2021-08-29 09:49:04', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'こわれたね〜'),('44b88843-d4c2-45ec-8fb6-f17fbeda8a26', '2021-08-29 09:50:07', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'こわれたね〜'),('44b88843-d4c2-45ec-8fb6-f17fbeda8a26', '2021-08-29 09:51:05', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'こわれたね〜'),('44b88843-d4c2-45ec-8fb6-f17fbeda8a26', '2021-08-29 09:52:03', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'こわれたね〜'),('44b88843-d4c2-45ec-8fb6-f17fbeda8a26', '2021-08-29 09:53:03', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'こわれたね〜'),('44b88843-d4c2-45ec-8fb6-f17fbeda8a26', '2021-08-29 09:54:09', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'こわれたね〜'),('44b88843-d4c2-45ec-8fb6-f17fbeda8a26', '2021-08-29 09:55:07', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'こわれたね〜'),('30ddb675-196c-4641-a7ce-4ea74c9721af', '2021-08-29 09:53:57', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('30ddb675-196c-4641-a7ce-4ea74c9721af', '2021-08-29 09:54:48', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('30ddb675-196c-4641-a7ce-4ea74c9721af', '2021-08-29 09:55:50', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('30ddb675-196c-4641-a7ce-4ea74c9721af', '2021-08-29 09:56:51', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('30ddb675-196c-4641-a7ce-4ea74c9721af', '2021-08-29 09:57:54', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('30ddb675-196c-4641-a7ce-4ea74c9721af', '2021-08-29 09:58:56', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('30ddb675-196c-4641-a7ce-4ea74c9721af', '2021-08-29 09:59:49', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('30ddb675-196c-4641-a7ce-4ea74c9721af', '2021-08-29 10:00:47', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('30ddb675-196c-4641-a7ce-4ea74c9721af', '2021-08-29 10:01:48', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('30ddb675-196c-4641-a7ce-4ea74c9721af', '2021-08-29 10:02:51', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 10:11:54', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 10:12:57', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 10:14:04', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 10:14:55', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 10:16:04', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 10:16:58', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 10:17:55', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 10:18:56', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 10:19:58', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 10:20:55', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('99f0806c-5808-4041-bdb6-b363306460eb', '2021-08-29 10:17:58', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れちゃった!'),('99f0806c-5808-4041-bdb6-b363306460eb', '2021-08-29 10:18:58', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れちゃった!'),('99f0806c-5808-4041-bdb6-b363306460eb', '2021-08-29 10:19:57', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れちゃった!'),('99f0806c-5808-4041-bdb6-b363306460eb', '2021-08-29 10:20:56', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れちゃった!'),('99f0806c-5808-4041-bdb6-b363306460eb', '2021-08-29 10:21:55', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れちゃった!'),('99f0806c-5808-4041-bdb6-b363306460eb', '2021-08-29 10:22:57', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れちゃった!'),('99f0806c-5808-4041-bdb6-b363306460eb', '2021-08-29 10:24:01', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れちゃった!'),('99f0806c-5808-4041-bdb6-b363306460eb', '2021-08-29 10:25:00', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れちゃった!'),('99f0806c-5808-4041-bdb6-b363306460eb', '2021-08-29 10:26:01', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れちゃった!'),('99f0806c-5808-4041-bdb6-b363306460eb', '2021-08-29 10:27:05', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れちゃった!'),('32beceb1-42f6-4fe8-b165-8e9d72309cc1', '2021-08-29 10:27:37', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいよ!'),('32beceb1-42f6-4fe8-b165-8e9d72309cc1', '2021-08-29 10:28:42', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいよ!'),('32beceb1-42f6-4fe8-b165-8e9d72309cc1', '2021-08-29 10:29:35', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいよ!'),('32beceb1-42f6-4fe8-b165-8e9d72309cc1', '2021-08-29 10:30:42', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいよ!'),('32beceb1-42f6-4fe8-b165-8e9d72309cc1', '2021-08-29 10:31:41', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいよ!'),('32beceb1-42f6-4fe8-b165-8e9d72309cc1', '2021-08-29 10:32:39', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいよ!'),('32beceb1-42f6-4fe8-b165-8e9d72309cc1', '2021-08-29 10:33:39', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいよ!'),('32beceb1-42f6-4fe8-b165-8e9d72309cc1', '2021-08-29 10:34:37', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいよ!'),('32beceb1-42f6-4fe8-b165-8e9d72309cc1', '2021-08-29 10:35:37', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいよ!'),('32beceb1-42f6-4fe8-b165-8e9d72309cc1', '2021-08-29 10:36:45', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいよ!'),('c32cfc49-48ca-43e6-be05-cf747564560e', '2021-08-29 10:30:07', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '掃除の時間かな〜'),('c32cfc49-48ca-43e6-be05-cf747564560e', '2021-08-29 10:31:04', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '掃除の時間かな〜'),('c32cfc49-48ca-43e6-be05-cf747564560e', '2021-08-29 10:32:08', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '掃除の時間かな〜'),('c32cfc49-48ca-43e6-be05-cf747564560e', '2021-08-29 10:33:07', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '掃除の時間かな〜'),('c32cfc49-48ca-43e6-be05-cf747564560e', '2021-08-29 10:34:12', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '掃除の時間かな〜'),('c32cfc49-48ca-43e6-be05-cf747564560e', '2021-08-29 10:35:11', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '掃除の時間かな〜'),('c32cfc49-48ca-43e6-be05-cf747564560e', '2021-08-29 10:36:04', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '掃除の時間かな〜'),('c32cfc49-48ca-43e6-be05-cf747564560e', '2021-08-29 10:37:08', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '掃除の時間かな〜'),('c32cfc49-48ca-43e6-be05-cf747564560e', '2021-08-29 10:38:08', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '掃除の時間かな〜'),('c32cfc49-48ca-43e6-be05-cf747564560e', '2021-08-29 10:39:06', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '掃除の時間かな〜'),('91c4dc70-f5dd-40ee-b201-61f80b18ab07', '2021-08-29 10:32:29', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいぜ!'),('91c4dc70-f5dd-40ee-b201-61f80b18ab07', '2021-08-29 10:33:27', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいぜ!'),('91c4dc70-f5dd-40ee-b201-61f80b18ab07', '2021-08-29 10:34:22', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいぜ!'),('91c4dc70-f5dd-40ee-b201-61f80b18ab07', '2021-08-29 10:35:30', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいぜ!'),('91c4dc70-f5dd-40ee-b201-61f80b18ab07', '2021-08-29 10:36:30', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいぜ!'),('91c4dc70-f5dd-40ee-b201-61f80b18ab07', '2021-08-29 10:37:27', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいぜ!'),('91c4dc70-f5dd-40ee-b201-61f80b18ab07', '2021-08-29 10:38:32', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいぜ!'),('91c4dc70-f5dd-40ee-b201-61f80b18ab07', '2021-08-29 10:39:25', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいぜ!'),('91c4dc70-f5dd-40ee-b201-61f80b18ab07', '2021-08-29 10:40:31', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいぜ!'),('91c4dc70-f5dd-40ee-b201-61f80b18ab07', '2021-08-29 10:41:29', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いいぜ!'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 10:32:09', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 10:33:09', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 10:34:06', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 10:35:02', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 10:36:09', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 10:37:06', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 10:38:05', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 10:39:08', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 10:40:10', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4f7b6a92-ecf9-4f9b-a4f0-d7a2a76bb0f1', '2021-08-29 10:41:05', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'ど、どいてもらえますか...?'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 10:38:52', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 10:39:55', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 10:40:53', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 10:41:48', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 10:42:56', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 10:43:55', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 10:44:46', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 10:45:47', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 10:46:48', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 10:47:50', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('8cbd759e-b4ac-4c33-b129-6fe3698b4f43', '2021-08-29 10:39:48', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重さを自覚してよね'),('8cbd759e-b4ac-4c33-b129-6fe3698b4f43', '2021-08-29 10:40:45', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重さを自覚してよね'),('8cbd759e-b4ac-4c33-b129-6fe3698b4f43', '2021-08-29 10:41:42', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重さを自覚してよね'),('8cbd759e-b4ac-4c33-b129-6fe3698b4f43', '2021-08-29 10:42:50', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重さを自覚してよね'),('8cbd759e-b4ac-4c33-b129-6fe3698b4f43', '2021-08-29 10:43:47', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重さを自覚してよね'),('8cbd759e-b4ac-4c33-b129-6fe3698b4f43', '2021-08-29 10:44:45', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重さを自覚してよね'),('8cbd759e-b4ac-4c33-b129-6fe3698b4f43', '2021-08-29 10:45:48', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重さを自覚してよね'),('8cbd759e-b4ac-4c33-b129-6fe3698b4f43', '2021-08-29 10:46:44', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重さを自覚してよね'),('8cbd759e-b4ac-4c33-b129-6fe3698b4f43', '2021-08-29 10:47:50', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重さを自覚してよね'),('8cbd759e-b4ac-4c33-b129-6fe3698b4f43', '2021-08-29 10:48:43', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重さを自覚してよね'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 10:50:41', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 10:51:43', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 10:52:34', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 10:53:40', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 10:54:33', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 10:55:37', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 10:56:39', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 10:57:38', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 10:58:39', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 10:59:35', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('47257e90-c0ad-49ce-8cf5-1c8e065ad8d7', '2021-08-29 10:52:46', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じだよ〜'),('47257e90-c0ad-49ce-8cf5-1c8e065ad8d7', '2021-08-29 10:53:44', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じだよ〜'),('47257e90-c0ad-49ce-8cf5-1c8e065ad8d7', '2021-08-29 10:54:46', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じだよ〜'),('47257e90-c0ad-49ce-8cf5-1c8e065ad8d7', '2021-08-29 10:55:52', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じだよ〜'),('47257e90-c0ad-49ce-8cf5-1c8e065ad8d7', '2021-08-29 10:56:53', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じだよ〜'),('47257e90-c0ad-49ce-8cf5-1c8e065ad8d7', '2021-08-29 10:57:47', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じだよ〜'),('47257e90-c0ad-49ce-8cf5-1c8e065ad8d7', '2021-08-29 10:58:44', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じだよ〜'),('47257e90-c0ad-49ce-8cf5-1c8e065ad8d7', '2021-08-29 10:59:52', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じだよ〜'),('47257e90-c0ad-49ce-8cf5-1c8e065ad8d7', '2021-08-29 11:00:45', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じだよ〜'),('47257e90-c0ad-49ce-8cf5-1c8e065ad8d7', '2021-08-29 11:01:43', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じだよ〜'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 10:54:20', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 10:55:27', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 10:56:24', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 10:57:28', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 10:58:25', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 10:59:22', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 11:00:18', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 11:01:24', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 11:02:21', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 11:03:26', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('45c12530-1fcb-452f-8a3d-c08014d7bc8c', '2021-08-29 10:56:12', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'ま、いいんじゃない?'),('45c12530-1fcb-452f-8a3d-c08014d7bc8c', '2021-08-29 10:57:09', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'ま、いいんじゃない?'),('45c12530-1fcb-452f-8a3d-c08014d7bc8c', '2021-08-29 10:58:12', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'ま、いいんじゃない?'),('45c12530-1fcb-452f-8a3d-c08014d7bc8c', '2021-08-29 10:59:06', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'ま、いいんじゃない?'),('45c12530-1fcb-452f-8a3d-c08014d7bc8c', '2021-08-29 11:00:09', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'ま、いいんじゃない?'),('45c12530-1fcb-452f-8a3d-c08014d7bc8c', '2021-08-29 11:01:11', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'ま、いいんじゃない?'),('45c12530-1fcb-452f-8a3d-c08014d7bc8c', '2021-08-29 11:02:08', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'ま、いいんじゃない?'),('45c12530-1fcb-452f-8a3d-c08014d7bc8c', '2021-08-29 11:03:06', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'ま、いいんじゃない?'),('45c12530-1fcb-452f-8a3d-c08014d7bc8c', '2021-08-29 11:04:02', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'ま、いいんじゃない?'),('45c12530-1fcb-452f-8a3d-c08014d7bc8c', '2021-08-29 11:05:10', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'ま、いいんじゃない?'),('48df21b5-92ac-4ae0-89d7-9b8a5347ce08', '2021-08-29 10:54:26', 1, 'is_dirty=true,is_overweight=false,is_broken=true', '汚れてるし壊れちゃった!'),('48df21b5-92ac-4ae0-89d7-9b8a5347ce08', '2021-08-29 10:55:20', 1, 'is_dirty=true,is_overweight=false,is_broken=true', '汚れてるし壊れちゃった!'),('48df21b5-92ac-4ae0-89d7-9b8a5347ce08', '2021-08-29 10:56:19', 1, 'is_dirty=true,is_overweight=false,is_broken=true', '汚れてるし壊れちゃった!'),('48df21b5-92ac-4ae0-89d7-9b8a5347ce08', '2021-08-29 10:57:28', 0, 'is_dirty=true,is_overweight=false,is_broken=true', '汚れてるし壊れちゃった!'),('48df21b5-92ac-4ae0-89d7-9b8a5347ce08', '2021-08-29 10:58:21', 1, 'is_dirty=true,is_overweight=false,is_broken=true', '汚れてるし壊れちゃった!'),('48df21b5-92ac-4ae0-89d7-9b8a5347ce08', '2021-08-29 10:59:24', 1, 'is_dirty=true,is_overweight=false,is_broken=true', '汚れてるし壊れちゃった!'),('48df21b5-92ac-4ae0-89d7-9b8a5347ce08', '2021-08-29 11:00:20', 1, 'is_dirty=true,is_overweight=false,is_broken=true', '汚れてるし壊れちゃった!'),('48df21b5-92ac-4ae0-89d7-9b8a5347ce08', '2021-08-29 11:01:22', 1, 'is_dirty=true,is_overweight=false,is_broken=true', '汚れてるし壊れちゃった!'),('48df21b5-92ac-4ae0-89d7-9b8a5347ce08', '2021-08-29 11:02:24', 1, 'is_dirty=true,is_overweight=false,is_broken=true', '汚れてるし壊れちゃった!'),('48df21b5-92ac-4ae0-89d7-9b8a5347ce08', '2021-08-29 11:03:27', 1, 'is_dirty=true,is_overweight=false,is_broken=true', '汚れてるし壊れちゃった!'),('8b2e1f1d-6fd7-4377-81aa-4b711d9e9249', '2021-08-29 11:02:36', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じ〜'),('8b2e1f1d-6fd7-4377-81aa-4b711d9e9249', '2021-08-29 11:03:41', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じ〜'),('8b2e1f1d-6fd7-4377-81aa-4b711d9e9249', '2021-08-29 11:04:35', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じ〜'),('8b2e1f1d-6fd7-4377-81aa-4b711d9e9249', '2021-08-29 11:05:39', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じ〜'),('8b2e1f1d-6fd7-4377-81aa-4b711d9e9249', '2021-08-29 11:06:40', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じ〜'),('8b2e1f1d-6fd7-4377-81aa-4b711d9e9249', '2021-08-29 11:07:35', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じ〜'),('8b2e1f1d-6fd7-4377-81aa-4b711d9e9249', '2021-08-29 11:08:37', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じ〜'),('8b2e1f1d-6fd7-4377-81aa-4b711d9e9249', '2021-08-29 11:09:35', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じ〜'),('8b2e1f1d-6fd7-4377-81aa-4b711d9e9249', '2021-08-29 11:10:43', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じ〜'),('8b2e1f1d-6fd7-4377-81aa-4b711d9e9249', '2021-08-29 11:11:37', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じ〜'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 11:02:22', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 11:03:23', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 11:04:21', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 11:05:24', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 11:06:24', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 11:07:22', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 11:08:20', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 11:09:22', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 11:10:30', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('577bf639-c91d-4432-af9c-1f48fcfd246f', '2021-08-29 11:11:24', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0e4f8fb5-51ff-4eef-8b21-f4d52340803b', '2021-08-29 11:05:18', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('0e4f8fb5-51ff-4eef-8b21-f4d52340803b', '2021-08-29 11:06:20', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('0e4f8fb5-51ff-4eef-8b21-f4d52340803b', '2021-08-29 11:07:24', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('0e4f8fb5-51ff-4eef-8b21-f4d52340803b', '2021-08-29 11:08:23', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('0e4f8fb5-51ff-4eef-8b21-f4d52340803b', '2021-08-29 11:09:26', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('0e4f8fb5-51ff-4eef-8b21-f4d52340803b', '2021-08-29 11:10:22', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('0e4f8fb5-51ff-4eef-8b21-f4d52340803b', '2021-08-29 11:11:25', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('0e4f8fb5-51ff-4eef-8b21-f4d52340803b', '2021-08-29 11:12:24', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('0e4f8fb5-51ff-4eef-8b21-f4d52340803b', '2021-08-29 11:13:21', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('0e4f8fb5-51ff-4eef-8b21-f4d52340803b', '2021-08-29 11:14:19', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 11:28:49', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 11:29:50', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 11:30:48', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 11:31:44', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 11:32:50', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 11:33:49', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 11:34:46', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 11:35:49', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 11:36:42', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 11:37:40', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('f904b391-67c1-4d87-aef5-85460ba24eb6', '2021-08-29 11:30:59', 1, 'is_dirty=false,is_overweight=false,is_broken=true', '直してほしいな〜'),('f904b391-67c1-4d87-aef5-85460ba24eb6', '2021-08-29 11:32:01', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直してほしいな〜'),('f904b391-67c1-4d87-aef5-85460ba24eb6', '2021-08-29 11:33:05', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直してほしいな〜'),('f904b391-67c1-4d87-aef5-85460ba24eb6', '2021-08-29 11:33:59', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直してほしいな〜'),('f904b391-67c1-4d87-aef5-85460ba24eb6', '2021-08-29 11:35:07', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直してほしいな〜'),('f904b391-67c1-4d87-aef5-85460ba24eb6', '2021-08-29 11:36:01', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直してほしいな〜'),('f904b391-67c1-4d87-aef5-85460ba24eb6', '2021-08-29 11:37:01', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直してほしいな〜'),('f904b391-67c1-4d87-aef5-85460ba24eb6', '2021-08-29 11:37:59', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直してほしいな〜'),('f904b391-67c1-4d87-aef5-85460ba24eb6', '2021-08-29 11:39:05', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直してほしいな〜'),('f904b391-67c1-4d87-aef5-85460ba24eb6', '2021-08-29 11:40:05', 0, 'is_dirty=false,is_overweight=false,is_broken=true', '直してほしいな〜'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 11:36:11', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 11:37:10', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 11:38:07', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 11:39:10', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 11:40:09', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 11:41:03', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 11:42:07', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 11:43:07', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 11:44:01', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 11:45:02', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('acd545e6-b8fc-459e-8552-2b486a04ee42', '2021-08-29 11:39:46', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('acd545e6-b8fc-459e-8552-2b486a04ee42', '2021-08-29 11:40:41', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('acd545e6-b8fc-459e-8552-2b486a04ee42', '2021-08-29 11:41:46', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('acd545e6-b8fc-459e-8552-2b486a04ee42', '2021-08-29 11:42:46', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('acd545e6-b8fc-459e-8552-2b486a04ee42', '2021-08-29 11:43:42', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('acd545e6-b8fc-459e-8552-2b486a04ee42', '2021-08-29 11:44:51', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('acd545e6-b8fc-459e-8552-2b486a04ee42', '2021-08-29 11:45:50', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('acd545e6-b8fc-459e-8552-2b486a04ee42', '2021-08-29 11:46:48', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('acd545e6-b8fc-459e-8552-2b486a04ee42', '2021-08-29 11:47:41', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('acd545e6-b8fc-459e-8552-2b486a04ee42', '2021-08-29 11:48:41', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 11:43:35', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 11:44:37', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 11:45:32', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 11:46:31', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 11:47:36', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 11:48:30', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 11:49:34', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 11:50:40', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 11:51:40', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 11:52:31', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('aa0979e9-5f5e-43b8-bc8d-68731ae069f8', '2021-08-29 11:50:59', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚いけど我慢です!'),('aa0979e9-5f5e-43b8-bc8d-68731ae069f8', '2021-08-29 11:52:00', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚いけど我慢です!'),('aa0979e9-5f5e-43b8-bc8d-68731ae069f8', '2021-08-29 11:52:53', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚いけど我慢です!'),('aa0979e9-5f5e-43b8-bc8d-68731ae069f8', '2021-08-29 11:53:56', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚いけど我慢です!'),('aa0979e9-5f5e-43b8-bc8d-68731ae069f8', '2021-08-29 11:55:01', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚いけど我慢です!'),('aa0979e9-5f5e-43b8-bc8d-68731ae069f8', '2021-08-29 11:55:53', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚いけど我慢です!'),('aa0979e9-5f5e-43b8-bc8d-68731ae069f8', '2021-08-29 11:56:58', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚いけど我慢です!'),('aa0979e9-5f5e-43b8-bc8d-68731ae069f8', '2021-08-29 11:57:52', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚いけど我慢です!'),('aa0979e9-5f5e-43b8-bc8d-68731ae069f8', '2021-08-29 11:58:51', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚いけど我慢です!'),('aa0979e9-5f5e-43b8-bc8d-68731ae069f8', '2021-08-29 11:59:54', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚いけど我慢です!'),('6c1ab8c8-74bc-459b-ac28-975c868443e8', '2021-08-29 11:58:20', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('6c1ab8c8-74bc-459b-ac28-975c868443e8', '2021-08-29 11:59:21', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('6c1ab8c8-74bc-459b-ac28-975c868443e8', '2021-08-29 12:00:13', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('6c1ab8c8-74bc-459b-ac28-975c868443e8', '2021-08-29 12:01:13', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('6c1ab8c8-74bc-459b-ac28-975c868443e8', '2021-08-29 12:02:21', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('6c1ab8c8-74bc-459b-ac28-975c868443e8', '2021-08-29 12:03:15', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('6c1ab8c8-74bc-459b-ac28-975c868443e8', '2021-08-29 12:04:14', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('6c1ab8c8-74bc-459b-ac28-975c868443e8', '2021-08-29 12:05:23', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('6c1ab8c8-74bc-459b-ac28-975c868443e8', '2021-08-29 12:06:17', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('6c1ab8c8-74bc-459b-ac28-975c868443e8', '2021-08-29 12:07:20', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです〜'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 11:58:54', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 11:59:53', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 12:00:46', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 12:01:51', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 12:02:54', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 12:03:52', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 12:04:47', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 12:05:54', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 12:06:53', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('4964bbbd-2ca6-473e-98b7-1e04c26c35e8', '2021-08-29 12:07:47', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('f4280ae5-7cbb-47ac-9eda-96115e0cf5c3', '2021-08-29 11:59:57', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('f4280ae5-7cbb-47ac-9eda-96115e0cf5c3', '2021-08-29 12:00:59', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('f4280ae5-7cbb-47ac-9eda-96115e0cf5c3', '2021-08-29 12:01:53', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('f4280ae5-7cbb-47ac-9eda-96115e0cf5c3', '2021-08-29 12:02:59', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('f4280ae5-7cbb-47ac-9eda-96115e0cf5c3', '2021-08-29 12:03:56', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('f4280ae5-7cbb-47ac-9eda-96115e0cf5c3', '2021-08-29 12:05:00', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('f4280ae5-7cbb-47ac-9eda-96115e0cf5c3', '2021-08-29 12:05:57', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('f4280ae5-7cbb-47ac-9eda-96115e0cf5c3', '2021-08-29 12:06:56', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('f4280ae5-7cbb-47ac-9eda-96115e0cf5c3', '2021-08-29 12:07:56', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('f4280ae5-7cbb-47ac-9eda-96115e0cf5c3', '2021-08-29 12:08:58', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:12:41', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:13:42', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:14:44', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:15:47', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:16:40', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:17:46', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:18:42', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:19:40', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:20:45', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:21:45', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('f5a5fa57-5b7b-4b80-8664-cd0551dc4bad', '2021-08-29 12:23:04', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです。'),('f5a5fa57-5b7b-4b80-8664-cd0551dc4bad', '2021-08-29 12:24:03', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです。'),('f5a5fa57-5b7b-4b80-8664-cd0551dc4bad', '2021-08-29 12:25:03', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです。'),('f5a5fa57-5b7b-4b80-8664-cd0551dc4bad', '2021-08-29 12:26:05', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです。'),('f5a5fa57-5b7b-4b80-8664-cd0551dc4bad', '2021-08-29 12:27:12', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです。'),('f5a5fa57-5b7b-4b80-8664-cd0551dc4bad', '2021-08-29 12:28:07', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです。'),('f5a5fa57-5b7b-4b80-8664-cd0551dc4bad', '2021-08-29 12:29:06', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです。'),('f5a5fa57-5b7b-4b80-8664-cd0551dc4bad', '2021-08-29 12:30:05', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです。'),('f5a5fa57-5b7b-4b80-8664-cd0551dc4bad', '2021-08-29 12:31:10', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです。'),('f5a5fa57-5b7b-4b80-8664-cd0551dc4bad', '2021-08-29 12:32:06', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです。'),('a47d07a0-a6f6-46d0-a0fb-7be05bbf57dd', '2021-08-29 12:05:51', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('a47d07a0-a6f6-46d0-a0fb-7be05bbf57dd', '2021-08-29 12:06:49', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('a47d07a0-a6f6-46d0-a0fb-7be05bbf57dd', '2021-08-29 12:07:53', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('a47d07a0-a6f6-46d0-a0fb-7be05bbf57dd', '2021-08-29 12:08:53', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('a47d07a0-a6f6-46d0-a0fb-7be05bbf57dd', '2021-08-29 12:09:46', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('a47d07a0-a6f6-46d0-a0fb-7be05bbf57dd', '2021-08-29 12:10:49', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('a47d07a0-a6f6-46d0-a0fb-7be05bbf57dd', '2021-08-29 12:11:46', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('a47d07a0-a6f6-46d0-a0fb-7be05bbf57dd', '2021-08-29 12:12:47', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('a47d07a0-a6f6-46d0-a0fb-7be05bbf57dd', '2021-08-29 12:13:51', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('a47d07a0-a6f6-46d0-a0fb-7be05bbf57dd', '2021-08-29 12:14:50', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れたし拭いて!'),('9919cd08-b39d-4e5e-b25e-b3d41d465cd1', '2021-08-29 12:26:52', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '清掃と負荷の軽減をすべきかと'),('9919cd08-b39d-4e5e-b25e-b3d41d465cd1', '2021-08-29 12:27:56', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '清掃と負荷の軽減をすべきかと'),('9919cd08-b39d-4e5e-b25e-b3d41d465cd1', '2021-08-29 12:29:00', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '清掃と負荷の軽減をすべきかと'),('9919cd08-b39d-4e5e-b25e-b3d41d465cd1', '2021-08-29 12:29:54', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '清掃と負荷の軽減をすべきかと'),('9919cd08-b39d-4e5e-b25e-b3d41d465cd1', '2021-08-29 12:30:56', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '清掃と負荷の軽減をすべきかと'),('9919cd08-b39d-4e5e-b25e-b3d41d465cd1', '2021-08-29 12:31:57', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '清掃と負荷の軽減をすべきかと'),('9919cd08-b39d-4e5e-b25e-b3d41d465cd1', '2021-08-29 12:32:57', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '清掃と負荷の軽減をすべきかと'),('9919cd08-b39d-4e5e-b25e-b3d41d465cd1', '2021-08-29 12:33:59', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '清掃と負荷の軽減をすべきかと'),('9919cd08-b39d-4e5e-b25e-b3d41d465cd1', '2021-08-29 12:34:57', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '清掃と負荷の軽減をすべきかと'),('9919cd08-b39d-4e5e-b25e-b3d41d465cd1', '2021-08-29 12:35:56', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '清掃と負荷の軽減をすべきかと'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:28:47', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:29:43', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:30:48', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:31:44', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:32:49', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:33:44', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:34:47', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:35:47', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:36:43', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('fc3462dd-8211-49bd-b98f-14ac45935f4a', '2021-08-29 12:37:48', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 12:32:01', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 12:32:55', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 12:33:57', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 12:35:01', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 12:35:59', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 12:37:00', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 12:38:03', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 12:38:57', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 12:40:01', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('0b12f33a-d0ce-4bcc-9601-e47aa54f62e8', '2021-08-29 12:40:58', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '早く拭いてもらえます?'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 12:30:42', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 12:31:42', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 12:32:38', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 12:33:34', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 12:34:36', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 12:35:39', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 12:36:35', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 12:37:41', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 12:38:38', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('f555e76f-7c13-4a87-9c02-e33050f30af1', '2021-08-29 12:39:34', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重たいです!'),('cfb73bcd-bd3e-4384-84a6-0e87de551979', '2021-08-29 12:42:09', 1, 'is_dirty=true,is_overweight=true,is_broken=true', '最悪!'),('cfb73bcd-bd3e-4384-84a6-0e87de551979', '2021-08-29 12:43:14', 1, 'is_dirty=true,is_overweight=true,is_broken=true', '最悪!'),('cfb73bcd-bd3e-4384-84a6-0e87de551979', '2021-08-29 12:44:09', 1, 'is_dirty=true,is_overweight=true,is_broken=true', '最悪!'),('cfb73bcd-bd3e-4384-84a6-0e87de551979', '2021-08-29 12:45:17', 1, 'is_dirty=true,is_overweight=true,is_broken=true', '最悪!'),('cfb73bcd-bd3e-4384-84a6-0e87de551979', '2021-08-29 12:46:17', 1, 'is_dirty=true,is_overweight=true,is_broken=true', '最悪!'),('cfb73bcd-bd3e-4384-84a6-0e87de551979', '2021-08-29 12:47:14', 1, 'is_dirty=true,is_overweight=true,is_broken=true', '最悪!'),('cfb73bcd-bd3e-4384-84a6-0e87de551979', '2021-08-29 12:48:19', 1, 'is_dirty=true,is_overweight=true,is_broken=true', '最悪!'),('cfb73bcd-bd3e-4384-84a6-0e87de551979', '2021-08-29 12:49:17', 1, 'is_dirty=true,is_overweight=true,is_broken=true', '最悪!'),('cfb73bcd-bd3e-4384-84a6-0e87de551979', '2021-08-29 12:50:09', 1, 'is_dirty=true,is_overweight=true,is_broken=true', '最悪!'),('cfb73bcd-bd3e-4384-84a6-0e87de551979', '2021-08-29 12:51:17', 1, 'is_dirty=true,is_overweight=true,is_broken=true', '最悪!'),('c1c45df8-ef57-422c-b118-105ba60b13b7', '2021-08-29 12:50:03', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いけどがんばります!'),('c1c45df8-ef57-422c-b118-105ba60b13b7', '2021-08-29 12:51:07', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いけどがんばります!'),('c1c45df8-ef57-422c-b118-105ba60b13b7', '2021-08-29 12:52:01', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いけどがんばります!'),('c1c45df8-ef57-422c-b118-105ba60b13b7', '2021-08-29 12:53:07', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いけどがんばります!'),('c1c45df8-ef57-422c-b118-105ba60b13b7', '2021-08-29 12:54:10', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いけどがんばります!'),('c1c45df8-ef57-422c-b118-105ba60b13b7', '2021-08-29 12:55:06', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いけどがんばります!'),('c1c45df8-ef57-422c-b118-105ba60b13b7', '2021-08-29 12:56:06', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いけどがんばります!'),('c1c45df8-ef57-422c-b118-105ba60b13b7', '2021-08-29 12:57:09', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いけどがんばります!'),('c1c45df8-ef57-422c-b118-105ba60b13b7', '2021-08-29 12:58:10', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いけどがんばります!'),('c1c45df8-ef57-422c-b118-105ba60b13b7', '2021-08-29 12:59:09', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いけどがんばります!'),('e4e45c41-3286-41ee-9e9c-e855aa0f248e', '2021-08-29 12:49:27', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'おもたいよ...'),('e4e45c41-3286-41ee-9e9c-e855aa0f248e', '2021-08-29 12:50:28', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'おもたいよ...'),('e4e45c41-3286-41ee-9e9c-e855aa0f248e', '2021-08-29 12:51:36', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'おもたいよ...'),('e4e45c41-3286-41ee-9e9c-e855aa0f248e', '2021-08-29 12:52:33', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'おもたいよ...'),('e4e45c41-3286-41ee-9e9c-e855aa0f248e', '2021-08-29 12:53:30', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'おもたいよ...'),('e4e45c41-3286-41ee-9e9c-e855aa0f248e', '2021-08-29 12:54:31', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'おもたいよ...'),('e4e45c41-3286-41ee-9e9c-e855aa0f248e', '2021-08-29 12:55:30', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'おもたいよ...'),('e4e45c41-3286-41ee-9e9c-e855aa0f248e', '2021-08-29 12:56:28', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'おもたいよ...'),('e4e45c41-3286-41ee-9e9c-e855aa0f248e', '2021-08-29 12:57:37', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'おもたいよ...'),('e4e45c41-3286-41ee-9e9c-e855aa0f248e', '2021-08-29 12:58:35', 1, 'is_dirty=false,is_overweight=true,is_broken=false', 'おもたいよ...'),('8f79c950-6b08-470c-90d7-774d78dd70b3', '2021-08-29 12:47:52', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いしどいて!'),('8f79c950-6b08-470c-90d7-774d78dd70b3', '2021-08-29 12:48:59', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いしどいて!'),('8f79c950-6b08-470c-90d7-774d78dd70b3', '2021-08-29 12:49:53', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いしどいて!'),('8f79c950-6b08-470c-90d7-774d78dd70b3', '2021-08-29 12:51:00', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いしどいて!'),('8f79c950-6b08-470c-90d7-774d78dd70b3', '2021-08-29 12:52:01', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いしどいて!'),('8f79c950-6b08-470c-90d7-774d78dd70b3', '2021-08-29 12:52:55', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いしどいて!'),('8f79c950-6b08-470c-90d7-774d78dd70b3', '2021-08-29 12:53:59', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いしどいて!'),('8f79c950-6b08-470c-90d7-774d78dd70b3', '2021-08-29 12:54:53', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いしどいて!'),('8f79c950-6b08-470c-90d7-774d78dd70b3', '2021-08-29 12:55:55', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いしどいて!'),('8f79c950-6b08-470c-90d7-774d78dd70b3', '2021-08-29 12:57:00', 1, 'is_dirty=false,is_overweight=true,is_broken=false', '重いしどいて!'),('fb7d996c-1fc5-4d4d-8ffd-1218222d0636', '2021-08-29 12:47:39', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし重たーい!'),('fb7d996c-1fc5-4d4d-8ffd-1218222d0636', '2021-08-29 12:48:32', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし重たーい!'),('fb7d996c-1fc5-4d4d-8ffd-1218222d0636', '2021-08-29 12:49:37', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし重たーい!'),('fb7d996c-1fc5-4d4d-8ffd-1218222d0636', '2021-08-29 12:50:36', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし重たーい!'),('fb7d996c-1fc5-4d4d-8ffd-1218222d0636', '2021-08-29 12:51:35', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし重たーい!'),('fb7d996c-1fc5-4d4d-8ffd-1218222d0636', '2021-08-29 12:52:32', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし重たーい!'),('fb7d996c-1fc5-4d4d-8ffd-1218222d0636', '2021-08-29 12:53:38', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし重たーい!'),('fb7d996c-1fc5-4d4d-8ffd-1218222d0636', '2021-08-29 12:54:33', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし重たーい!'),('fb7d996c-1fc5-4d4d-8ffd-1218222d0636', '2021-08-29 12:55:35', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし重たーい!'),('fb7d996c-1fc5-4d4d-8ffd-1218222d0636', '2021-08-29 12:56:40', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし重たーい!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 12:52:22', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 12:53:25', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 12:54:18', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 12:55:28', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 12:56:28', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 12:57:23', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 12:58:24', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 12:59:28', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 13:00:18', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('d25d8e5e-e402-4a49-85ba-875012688f63', '2021-08-29 13:01:28', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'これからもがんばっていきましょう!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 12:56:02', 1, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 12:57:11', 1, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 12:58:02', 1, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 12:59:06', 1, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 13:00:07', 1, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 13:01:10', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 13:02:07', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 13:03:02', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 13:04:04', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('52cd440f-7358-4d37-9610-3f53c5cd2fbc', '2021-08-29 13:05:08', 0, 'is_dirty=true,is_overweight=false,is_broken=false', 'よごれたままなら暴れちゃうぞ!'),('9cec9458-3aa9-4bb9-a9cc-62a1f0d57cd3', '2021-08-29 12:56:08', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('9cec9458-3aa9-4bb9-a9cc-62a1f0d57cd3', '2021-08-29 12:57:01', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('9cec9458-3aa9-4bb9-a9cc-62a1f0d57cd3', '2021-08-29 12:58:05', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('9cec9458-3aa9-4bb9-a9cc-62a1f0d57cd3', '2021-08-29 12:59:01', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('9cec9458-3aa9-4bb9-a9cc-62a1f0d57cd3', '2021-08-29 13:00:07', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('9cec9458-3aa9-4bb9-a9cc-62a1f0d57cd3', '2021-08-29 13:01:05', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('9cec9458-3aa9-4bb9-a9cc-62a1f0d57cd3', '2021-08-29 13:02:03', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('9cec9458-3aa9-4bb9-a9cc-62a1f0d57cd3', '2021-08-29 13:03:06', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('9cec9458-3aa9-4bb9-a9cc-62a1f0d57cd3', '2021-08-29 13:04:07', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('9cec9458-3aa9-4bb9-a9cc-62a1f0d57cd3', '2021-08-29 13:05:09', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 13:03:32', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 13:04:38', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 13:05:32', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 13:06:31', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 13:07:38', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 13:08:35', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 13:09:36', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 13:10:38', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 13:11:34', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('6abc69b1-2fdf-447c-b5e9-9709ad7b8dc8', '2021-08-29 13:12:38', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです!'),('7f2a9f36-ec89-4d7b-9a64-9193d7e95304', '2021-08-29 13:01:07', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'わ、わるくないね!'),('7f2a9f36-ec89-4d7b-9a64-9193d7e95304', '2021-08-29 13:02:04', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'わ、わるくないね!'),('7f2a9f36-ec89-4d7b-9a64-9193d7e95304', '2021-08-29 13:03:05', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'わ、わるくないね!'),('7f2a9f36-ec89-4d7b-9a64-9193d7e95304', '2021-08-29 13:04:02', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'わ、わるくないね!'),('7f2a9f36-ec89-4d7b-9a64-9193d7e95304', '2021-08-29 13:05:04', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'わ、わるくないね!'),('7f2a9f36-ec89-4d7b-9a64-9193d7e95304', '2021-08-29 13:06:03', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'わ、わるくないね!'),('7f2a9f36-ec89-4d7b-9a64-9193d7e95304', '2021-08-29 13:07:01', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'わ、わるくないね!'),('7f2a9f36-ec89-4d7b-9a64-9193d7e95304', '2021-08-29 13:08:04', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'わ、わるくないね!'),('7f2a9f36-ec89-4d7b-9a64-9193d7e95304', '2021-08-29 13:09:07', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'わ、わるくないね!'),('7f2a9f36-ec89-4d7b-9a64-9193d7e95304', '2021-08-29 13:10:03', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'わ、わるくないね!'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 13:06:58', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 13:07:59', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 13:09:07', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 13:10:06', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 13:11:03', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 13:11:58', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 13:13:08', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 13:14:03', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 13:15:02', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('ff18f7df-0862-47e4-84a8-b33d5237f669', '2021-08-29 13:16:05', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'い、いい感じです...'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 13:08:16', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 13:09:13', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 13:10:14', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 13:11:13', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 13:12:14', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 13:13:12', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 13:14:10', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 13:15:07', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 13:16:15', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。'),('1b20ab02-aed9-40d6-a3b4-76152f8f55a2', '2021-08-29 13:17:10', 0, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れています。')\G
# Query 6: 78.02 QPS, 0.08x concurrency, ID 0x83E8898FB5772002 at byte 64018429
# Scores: V/M = 0.09
# Time range: 2022-07-17 18:29:00 to 18:30:01
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 4759
# Exec time 3 5s 33us 306ms 1ms 1ms 9ms 490us
# Lock time 8 185ms 0 8ms 38us 60us 200us 20us
# Rows sent 4 406.04k 0 206 87.37 143.84 41.33 88.31
# Rows examine 1 404.39k 0 206 87.01 143.84 41.55 88.31
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 4 61.61M 589 35.98k 13.26k 22.45k 6.13k 13.78k
# Query size 1 873.72k 188 188 188 188 0 188
# Boolean:
# QC hit 0% yes, 99% no
# String:
# Databases isucondition
# Hosts 192.168.0.21 (2895/60%)... 1 more
# Users isucon
# Query_time distribution
# 1us
# 10us #
# 100us ################################################################
# 1ms ######
# 10ms #
# 100ms #
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = '6c1ab8c8-74bc-459b-ac28-975c868443e8' AND `timestamp` BETWEEN '2021-08-13 00:00:00' AND '2021-08-13 23:59:59' ORDER BY `timestamp` ASC\G
# Query 7: 639.21 QPS, 0.03x concurrency, ID 0xA2D1B74705103105 at byte 156941240
# Scores: V/M = 0.00
# Time range: 2022-07-17 18:29:00 to 18:30:01
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 8 38992
# Exec time 1 2s 8us 27ms 50us 84us 239us 28us
# Lock time 0 3ms 0 609us 0 0 3us 0
# Rows sent 0 38.08k 1 1 1 1 0 1
# Rows examine 0 109 0 1 0.00 0 0.05 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 2.64M 71 71 71 71 0 71
# Query size 5 2.42M 58 74 64.95 69.19 3.98 62.76
# Boolean:
# QC hit 99% yes, 0% no
# String:
# Databases isucondition
# Hosts 192.168.0.41 (23661/60%)... 1 more
# Users isucon
# Query_time distribution
# 1us #
# 10us ################################################################
# 100us ##
# 1ms #
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'user'\G
# SHOW CREATE TABLE `isucondition`.`user`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM `user` WHERE `jia_user_id` = 'heuristic_poincare'\G
https://github.com/pinkumohikan/isucon-practice-20220716/pull/19 をマージした結果、16.5万ぐらい
最終スコア
20:44:59.743091 score: 644020(644022 - 2) : pass
20:44:59.743118 deduction: 0 / timeout: 21
20:44:59.743157 <=== sendResult finish
https://github.com/pinkumohikan/isucon-practice-20220716/issues/1 に続きday 2