0.81 ms (15.65%)
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 ¯{asÁi/F+‘õ "
b"\x01 ¯ž\x0E ?pu¶,ŠFòŽè "
b"\x01 ¯°ÜpÕ”?\t Ûfî&‡ "
b"\x01 ¯ÔÚpH†´ØGpJ\t M "
b"\x01 ¯åÁq »¿Û¤½Uë¿ "
b"\x01 ¯M›p\t ‚wé™CŒ\x0F Î "
b"\x01 ¯hDq\x14 ŽÊÈA_ü°÷ "
b"\x01 ޝž)§p€‡\x17 /\x1C rÃ\x15 ¡ "
b"\x01 ޝžC\x16 pQŽr\x13 ¸a‘«E "
b"\x01 ޝž^\f s\x0F €V22\x1D\x02 ø| "
b"\x01 ¯ž|½qSбsf^"ð "
b"\x01 ޝŒÜãp\x0E € Íà±be\t "
b"\x01 ްŽ2Þr@» aˆëLþÇ "
b"\x01 ޝ¤´Är™›\x05 Ú¨L\x16 Í• "
b"\x01 ްÊicr£»#0üe&&ý "
b"\x01 Ž·_AkpÔ‚\x03\v ‡Ñ=‹P "
b"\x01 ްÄ/rM‰Þ7\f G£÷Á "
b"\x01 ްÄê\x1C r;¼)C~Ùœi³ "
]
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 (0x018EAF9D7B6173C19F692F462B918FF5 , 0x018EAF9E0E3F7075B62C8A46F29D8DE8 , 0x018EAF9DB0DC70D5943F09DB66EE2687 , 0x018EAF9DD4DA704886B4D847704A094D , 0x018EAF9DE5C171A0BBBFDBA4BD55EBBF , 0x018EAF9D4D9B70098277E999438C0FCE , 0x018EAF9D684471148DCAC8415FFCB0F7 , 0x018EAF9E29A7708087172F1C72C315A1 , 0x018EAF9E431670518E7213B86191AB45 , 0x018EAF9E5E0C730F805632321D02F87C , 0x018EAF9E7CBD71538A81B173665E22F0 , 0x018EAF8CDCE3700E80A0CDE0B1626509 , 0x018EB08E32DE7240BBA06188EB4CFEC7 , 0x018EAFA4B4C472999B05DAA84C16CD95 , 0x018EB0CA696372A3BB2330FC652626FD , 0x018EB75F416B70D482030B87D13D8B50 , 0x018EB0C4AD2F724D89DE370C47A3F7C1 , 0x018EB0C4EA1C723BBC29437ED99C69B3 );
Copy
0.76 ms (14.62%)
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
"aI2mxSw "
]
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 = 'aI2mxSw' LIMIT 1 ;
Copy
0.76 ms (14.56%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9d-7b61-73c1-9f69-2f462b918ff5' ), 38.336776733398 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9e-0e3f-7075-b62c-8a46f29d8de8' ), 38.336776733398 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9d-b0dc-70d5-943f-09db66ee2687' ), 38.336776733398 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9d-d4da-7048-86b4-d847704a094d' ), 33.154499053955 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9d-e5c1-71a0-bbbf-dba4bd55ebbf' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9d-4d9b-7009-8277-e999438c0fce' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9d-6844-7114-8dca-c8415ffcb0f7' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9e-29a7-7080-8717-2f1c72c315a1' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9e-4316-7051-8e72-13b86191ab45' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9e-5e0c-730f-8056-32321d02f87c' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9e-7cbd-7153-8a81-b173665e22f0' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf8c-dce3-700e-80a0-cde0b1626509' ), 10.539752960205 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eb08e-32de-7240-bba0-6188eb4cfec7' ), 10.539752960205 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eafa4-b4c4-7299-9b05-daa84c16cd95' ), 9.7441358566284 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eb0ca-6963-72a3-bb23-30fc652626fd' ), 9.7441358566284 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eb75f-416b-70d4-8203-0b87d13d8b50' ), 9.7441358566284 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eb0c4-ad2f-724d-89de-370c47a3f7c1' ), 5.1822781562805 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eb0c4-ea1c-723b-bc29-437ed99c69b3' ), 5.1822781562805 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eaf9d-7b61-73c1-9f69-2f462b918ff5'
),
38.336776733398
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eaf9e-0e3f-7075-b62c-8a46f29d8de8'
),
38.336776733398
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eaf9d-b0dc-70d5-943f-09db66ee2687'
),
38.336776733398
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eaf9d-d4da-7048-86b4-d847704a094d'
),
33.154499053955
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eaf9d-e5c1-71a0-bbbf-dba4bd55ebbf'
),
26.161443710327
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eaf9d-4d9b-7009-8277-e999438c0fce'
),
26.161443710327
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eaf9d-6844-7114-8dca-c8415ffcb0f7'
),
26.161443710327
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eaf9e-29a7-7080-8717-2f1c72c315a1'
),
26.161443710327
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eaf9e-4316-7051-8e72-13b86191ab45'
),
26.161443710327
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eaf9e-5e0c-730f-8056-32321d02f87c'
),
26.161443710327
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eaf9e-7cbd-7153-8a81-b173665e22f0'
),
26.161443710327
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eaf8c-dce3-700e-80a0-cde0b1626509'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eb08e-32de-7240-bba0-6188eb4cfec7'
),
10.539752960205
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eafa4-b4c4-7299-9b05-daa84c16cd95'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eb0ca-6963-72a3-bb23-30fc652626fd'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eb75f-416b-70d4-8203-0b87d13d8b50'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eb0c4-ad2f-724d-89de-370c47a3f7c1'
),
5.1822781562805
),
(
UUID_TO_BIN (
'018eaf9d-f878-72ac-a6ed-789b6c9efd81'
),
UUID_TO_BIN (
'018eb0c4-ea1c-723b-bc29-437ed99c69b3'
),
5.1822781562805
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9d-7b61-73c1-9f69-2f462b918ff5' ), 38.336776733398 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9e-0e3f-7075-b62c-8a46f29d8de8' ), 38.336776733398 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9d-b0dc-70d5-943f-09db66ee2687' ), 38.336776733398 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9d-d4da-7048-86b4-d847704a094d' ), 33.154499053955 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9d-e5c1-71a0-bbbf-dba4bd55ebbf' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9d-4d9b-7009-8277-e999438c0fce' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9d-6844-7114-8dca-c8415ffcb0f7' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9e-29a7-7080-8717-2f1c72c315a1' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9e-4316-7051-8e72-13b86191ab45' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9e-5e0c-730f-8056-32321d02f87c' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf9e-7cbd-7153-8a81-b173665e22f0' ), 26.161443710327 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eaf8c-dce3-700e-80a0-cde0b1626509' ), 10.539752960205 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eb08e-32de-7240-bba0-6188eb4cfec7' ), 10.539752960205 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eafa4-b4c4-7299-9b05-daa84c16cd95' ), 9.7441358566284 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eb0ca-6963-72a3-bb23-30fc652626fd' ), 9.7441358566284 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eb75f-416b-70d4-8203-0b87d13d8b50' ), 9.7441358566284 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eb0c4-ad2f-724d-89de-370c47a3f7c1' ), 5.1822781562805 ), (UUID_TO_BIN ('018eaf9d-f878-72ac-a6ed-789b6c9efd81' ), UUID_TO_BIN ('018eb0c4-ea1c-723b-bc29-437ed99c69b3' ), 5.1822781562805 )
;
Copy