0.89 ms (17.40%)
1
SELECT mc . clip_id , mc . film_id , mc . public_key , mc . thumb_path , mc . preview_path , mc . duration , mc . quality , mc . is_vertical , mc . likes , mc . dislikes , mc . views , mc . status , mc . published_at , f1 . title as film_title , f1 . original_title as film_original_title , f1 . poster_path as film_poster_path , f1 . release_year as film_release_year , IFNULL (r . title , f . title ) as title FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc . clip_id = f . clip_id AND f . lang_id = ? LEFT JOIN film f1 ON mc . film_id = f1 . film_id LEFT JOIN movie_clip_translation r ON mc . clip_id = r . clip_id AND r . lang_id = ? WHERE mc . clip_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
1
2
b"\x01 Ž·±nVs¸¿\x10 zTdô;ö "
b"\x01 Ž·±7Wp³¶„$<§ßbP "
b"\x01 Ž·±²Fr´‰@À/–FÖ' "
b"\x01 Žß\x16 ë¸si”]LWéñ˜ "
b"\x01 Žß\x16 ž‡p¹¿S'\x7F x\x03 p{ "
b"\x01 ް§ºGsÕŒš†jDæ¿ù "
b"\x01 ¯ÖÖpçÈÀ’–Ù\x1A "
b"\x01 ްFÐ.s¦ˆ4DovµÚß "
b"\x01 ް×\x16 óqë…Ó;ƒA25 "
b"\x01 ·ˆáÓpôê–¾³e8R "
b"\x01 ÉÕðÞp®¿m\x11 UÚ\x1C "
b"\x01 °¨^p•“ÞÂk[\x08 × "
b"\x01 °r\x00 s}±«t਺?O "
b"\x01 ްÔâ\x1D r7ˆ¹¸=ª*¤4 "
b"\x01 ŽÎ“\x1F ®r!·fê\x0F\x04 Ä×Ö "
b"\x01 ŽÎ”lÒpV©vl‘rï³\x1D "
b"\x01 ¯ÄÄpë¾EQ‹ÐâûB "
b"\x01 ¯¬Kp”Ž\x1E\e Ro\x7F Ö "
b"\x01 ¯›Ås½žõùöðœ©\x13 "
b"\x01 Ž´ƒïšsÛ‹¶^Ûy,‹Ñ "
]
SELECT mc . clip_id , mc . film_id , mc . public_key , mc . thumb_path , mc . preview_path , mc . duration , mc . quality , mc . is_vertical , mc . likes , mc . dislikes , mc . views , mc . status , mc . published_at , f1 . title as film_title , f1 . original_title as film_original_title , f1 . poster_path as film_poster_path , f1 . release_year as film_release_year , IFNULL (r . title , f . title ) as title FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc . clip_id = f . clip_id AND f . lang_id = 1 LEFT JOIN film f1 ON mc . film_id = f1 . film_id LEFT JOIN movie_clip_translation r ON mc . clip_id = r . clip_id AND r . lang_id = 2 WHERE mc . clip_id IN (0x018EB7B16E5673B8BF107A5464F43BF6 , 0x018EB7B1375770B3B684243CA7DF6250 , 0x018EB7B1B24672B48940C02F9646D627 , 0x018EDF16EBB87369945D4C57E9ADF198 , 0x018EDF169E8770B9BF53277F7803707B , 0x018EB0A7BA4773D58C9A866A44E6BFF9 , 0x018EAF81D6D670AD81E7C8C09296D91A , 0x018EB046D02E73A68834446F76B5DADF , 0x018EB0D716F371EB85D33B83AD413235 , 0x018EB788E1D370F490EA96BEB3653852 , 0x018EC9D5F0DE70AEBF6D1155DA1CAD90 , 0x018EB0A89D5E709593DEC26BAD5B08D7 , 0x018EB072009D737DB1AB74E0A8BA3F4F , 0x018EB0D4E21D723788B9B83DAA2AA434 , 0x018ECE931FAE7221B766EA0F04C4D7D6 , 0x018ECE946CD27056A9766C9172EFB31D , 0x018EAF81C4C470EBBE45518BD0E2FB42 , 0x018EAF81AC4B70948D1E1B526F7F90D6 , 0x018EAF819BC573BD9EF5F9F6F09CA913 , 0x018EB483EF9A73DB8BB65EDB792C8BD1 );
Copy
0.83 ms (16.23%)
1
SELECT mc . clip_id , mc . user_id , mc . film_id , mc . public_key , mc . thumb_path , mc . preview_path , mc . duration , mc . quality , mc . is_vertical , mc . likes , mc . dislikes , mc . views , mc . status , mc . published_at , u . username , IFNULL (r . title , f . title ) as title , IFNULL (r . description , f . description ) as description FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc . clip_id = f . clip_id AND f . lang_id = ? LEFT JOIN user u ON mc . user_id = u . user_id LEFT JOIN movie_clip_translation r ON mc . clip_id = r . clip_id AND r . lang_id = ? WHERE mc . public_key = ? LIMIT 1
Parameters :
[
1
2
"YPSuu4T "
]
SELECT mc . clip_id , mc . user_id , mc . film_id , mc . public_key , mc . thumb_path , mc . preview_path , mc . duration , mc . quality , mc . is_vertical , mc . likes , mc . dislikes , mc . views , mc . status , mc . published_at , u . username , IFNULL (r . title , f . title ) as title , IFNULL (r . description , f . description ) as description FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc . clip_id = f . clip_id AND f . lang_id = 1 LEFT JOIN user u ON mc . user_id = u . user_id LEFT JOIN movie_clip_translation r ON mc . clip_id = r . clip_id AND r . lang_id = 2 WHERE mc . public_key = 'YPSuu4T' LIMIT 1 ;
Copy
0.77 ms (14.92%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb7b1-6e56-73b8-bf10-7a5464f43bf6' ), 56.881080627441 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb7b1-3757-70b3-b684-243ca7df6250' ), 56.881080627441 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb7b1-b246-72b4-8940-c02f9646d627' ), 56.881080627441 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018edf16-ebb8-7369-945d-4c57e9adf198' ), 56.881080627441 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018edf16-9e87-70b9-bf53-277f7803707b' ), 56.881080627441 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb0a7-ba47-73d5-8c9a-866a44e6bff9' ), 15.91077709198 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eaf81-d6d6-70ad-81e7-c8c09296d91a' ), 14.38868522644 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb046-d02e-73a6-8834-446f76b5dadf' ), 9.7441358566284 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb0d7-16f3-71eb-85d3-3b83ad413235' ), 9.7441358566284 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb788-e1d3-70f4-90ea-96beb3653852' ), 9.7441358566284 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018ec9d5-f0de-70ae-bf6d-1155da1cad90' ), 8.2858877182007 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb0a8-9d5e-7095-93de-c26bad5b08d7' ), 7.95538854599 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb072-009d-737d-b1ab-74e0a8ba3f4f' ), 7.4181051254272 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb0d4-e21d-7237-88b9-b83daa2aa434' ), 7.4181051254272 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018ece93-1fae-7221-b766-ea0f04c4d7d6' ), 7.4181051254272 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018ece94-6cd2-7056-a976-6c9172efb31d' ), 7.4181051254272 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eaf81-c4c4-70eb-be45-518bd0e2fb42' ), 7.1943426132202 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eaf81-ac4b-7094-8d1e-1b526f7f90d6' ), 7.1943426132202 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eaf81-9bc5-73bd-9ef5-f9f6f09ca913' ), 7.1943426132202 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb483-ef9a-73db-8bb6-5edb792c8bd1' ), 7.1943426132202 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eb7b1-6e56-73b8-bf10-7a5464f43bf6'
),
56.881080627441
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eb7b1-3757-70b3-b684-243ca7df6250'
),
56.881080627441
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eb7b1-b246-72b4-8940-c02f9646d627'
),
56.881080627441
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018edf16-ebb8-7369-945d-4c57e9adf198'
),
56.881080627441
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018edf16-9e87-70b9-bf53-277f7803707b'
),
56.881080627441
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eb0a7-ba47-73d5-8c9a-866a44e6bff9'
),
15.91077709198
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eaf81-d6d6-70ad-81e7-c8c09296d91a'
),
14.38868522644
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eb046-d02e-73a6-8834-446f76b5dadf'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eb0d7-16f3-71eb-85d3-3b83ad413235'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eb788-e1d3-70f4-90ea-96beb3653852'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018ec9d5-f0de-70ae-bf6d-1155da1cad90'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eb0a8-9d5e-7095-93de-c26bad5b08d7'
),
7.95538854599
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eb072-009d-737d-b1ab-74e0a8ba3f4f'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eb0d4-e21d-7237-88b9-b83daa2aa434'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018ece93-1fae-7221-b766-ea0f04c4d7d6'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018ece94-6cd2-7056-a976-6c9172efb31d'
),
7.4181051254272
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eaf81-c4c4-70eb-be45-518bd0e2fb42'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eaf81-ac4b-7094-8d1e-1b526f7f90d6'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eaf81-9bc5-73bd-9ef5-f9f6f09ca913'
),
7.1943426132202
),
(
UUID_TO_BIN (
'018edf17-43bd-7082-9c8a-5d370d8347b0'
),
UUID_TO_BIN (
'018eb483-ef9a-73db-8bb6-5edb792c8bd1'
),
7.1943426132202
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb7b1-6e56-73b8-bf10-7a5464f43bf6' ), 56.881080627441 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb7b1-3757-70b3-b684-243ca7df6250' ), 56.881080627441 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb7b1-b246-72b4-8940-c02f9646d627' ), 56.881080627441 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018edf16-ebb8-7369-945d-4c57e9adf198' ), 56.881080627441 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018edf16-9e87-70b9-bf53-277f7803707b' ), 56.881080627441 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb0a7-ba47-73d5-8c9a-866a44e6bff9' ), 15.91077709198 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eaf81-d6d6-70ad-81e7-c8c09296d91a' ), 14.38868522644 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb046-d02e-73a6-8834-446f76b5dadf' ), 9.7441358566284 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb0d7-16f3-71eb-85d3-3b83ad413235' ), 9.7441358566284 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb788-e1d3-70f4-90ea-96beb3653852' ), 9.7441358566284 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018ec9d5-f0de-70ae-bf6d-1155da1cad90' ), 8.2858877182007 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb0a8-9d5e-7095-93de-c26bad5b08d7' ), 7.95538854599 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb072-009d-737d-b1ab-74e0a8ba3f4f' ), 7.4181051254272 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb0d4-e21d-7237-88b9-b83daa2aa434' ), 7.4181051254272 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018ece93-1fae-7221-b766-ea0f04c4d7d6' ), 7.4181051254272 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018ece94-6cd2-7056-a976-6c9172efb31d' ), 7.4181051254272 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eaf81-c4c4-70eb-be45-518bd0e2fb42' ), 7.1943426132202 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eaf81-ac4b-7094-8d1e-1b526f7f90d6' ), 7.1943426132202 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eaf81-9bc5-73bd-9ef5-f9f6f09ca913' ), 7.1943426132202 ), (UUID_TO_BIN ('018edf17-43bd-7082-9c8a-5d370d8347b0' ), UUID_TO_BIN ('018eb483-ef9a-73db-8bb6-5edb792c8bd1' ), 7.1943426132202 )
;
Copy