0.91 ms (16.51%)
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 ŽÉ²‚\n
pc¢Î’ÃÿOGb
"""
b"\x01 ŽÉ°ØgpWz\x16 ðR@܉ "
b"\x01 ŽÉ±»wp6ºöãœa·…Ë "
b"\x01 ɲÄ\e sƒÈ,ç$3so "
b"\x01 ްàk%qp»´©\x17 žá4' "
b"\x01 ްc£\x14 r•d—ÕO\x00 '° "
b"\x01 Ž·á–ls<R\x14 ÖŸùø£ "
b"\x01 Ž·áÙ´sÏ \x1A 2ŸAåH` "
b"\x01 ¯ÿÎ<r»W¯\f 7~„$ "
b"\x01 ް\x00 y‰pî•¥k\x03 nKi\x05 "
b"\x01 ¯ýQšrKŒ1êÔ“|È "
b"\x01 ްa\x05 ëp£©b\x16 |M1\x02 B "
b"\x01 ް¡Ucq«½-\x1A ù›7\x12 ó "
b"\x01 ް¾}\x7F sž®S—5VÂŒý "
b"\x01 ޱ\x07 €±sÛ–ûI¸Šß°\x11 "
b"\x01 °å5>q/²Í5H>\x10 QŽ "
b"\x01 ŽÃÁÅÞqø€ t`«{ß "
b"\x01 ŽÃ’Kqr7—\x18 Ÿa«\x08 \n "
]
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 (0x018EC9B2820A7063A2CE92C3FF4F4762 , 0x018EC9B0D8677057AD7A16F05240DC89 , 0x018EC9B1BB777036BAF6E39C61B785CB , 0x018EC9B2C41B738390C82CE72433736F , 0x018EB0E06B257170BBB4A9179EE13427 , 0x018EB063A31472AD956497D54F0027B0 , 0x018EB7E1966C733CAD5214D69FF9F8A3 , 0x018EB7E1D9B473CFA01A329F41E54860 , 0x018EAFFFCE3C7281BB57AF0C377E8424 , 0x018EB000798970EE95A56B036E4B6905 , 0x018EAFFD519A724B908C31EAD4937CC8 , 0x018EB06105EB70A3A962167C4D310242 , 0x018EB0A1556371ABBD2D1AF99B3712F3 , 0x018EB0BE7D7F739EAE53973556C28CFD , 0x018EB10780B173DB96FB49B88ADFB011 , 0x018EB0E5353E712FB2CD35483E10518D , 0x018EC3C1C5DE71F880207460ABAD7BDF , 0x018EC3924B71723797189F61ADAB080A );
Copy
0.67 ms (12.19%)
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
"AKULU-H "
]
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 = 'AKULU-H' LIMIT 1 ;
Copy
0.59 ms (10.77%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018ec9b2-820a-7063-a2ce-92c3ff4f4762' ), 33.93542098999 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018ec9b0-d867-7057-ad7a-16f05240dc89' ), 33.93542098999 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018ec9b1-bb77-7036-baf6-e39c61b785cb' ), 33.93542098999 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018ec9b2-c41b-7383-90c8-2ce72433736f' ), 33.93542098999 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb0e0-6b25-7170-bbb4-a9179ee13427' ), 11.714120864868 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb063-a314-72ad-9564-97d54f0027b0' ), 9.7441358566284 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb7e1-966c-733c-ad52-14d69ff9f8a3' ), 9.7441358566284 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb7e1-d9b4-73cf-a01a-329f41e54860' ), 9.7441358566284 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eafff-ce3c-7281-bb57-af0c377e8424' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb000-7989-70ee-95a5-6b036e4b6905' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eaffd-519a-724b-908c-31ead4937cc8' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb061-05eb-70a3-a962-167c4d310242' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb0a1-5563-71ab-bd2d-1af99b3712f3' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb0be-7d7f-739e-ae53-973556c28cfd' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb107-80b1-73db-96fb-49b88adfb011' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb0e5-353e-712f-b2cd-35483e10518d' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018ec3c1-c5de-71f8-8020-7460abad7bdf' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018ec392-4b71-7237-9718-9f61adab080a' ), 6.4899020195007 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018ec9b2-820a-7063-a2ce-92c3ff4f4762'
),
33.93542098999
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018ec9b0-d867-7057-ad7a-16f05240dc89'
),
33.93542098999
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018ec9b1-bb77-7036-baf6-e39c61b785cb'
),
33.93542098999
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018ec9b2-c41b-7383-90c8-2ce72433736f'
),
33.93542098999
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018eb0e0-6b25-7170-bbb4-a9179ee13427'
),
11.714120864868
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018eb063-a314-72ad-9564-97d54f0027b0'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018eb7e1-966c-733c-ad52-14d69ff9f8a3'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018eb7e1-d9b4-73cf-a01a-329f41e54860'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018eafff-ce3c-7281-bb57-af0c377e8424'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018eb000-7989-70ee-95a5-6b036e4b6905'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018eaffd-519a-724b-908c-31ead4937cc8'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018eb061-05eb-70a3-a962-167c4d310242'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018eb0a1-5563-71ab-bd2d-1af99b3712f3'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018eb0be-7d7f-739e-ae53-973556c28cfd'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018eb107-80b1-73db-96fb-49b88adfb011'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018eb0e5-353e-712f-b2cd-35483e10518d'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018ec3c1-c5de-71f8-8020-7460abad7bdf'
),
6.4899020195007
),
(
UUID_TO_BIN (
'018ec9b0-4b01-7115-b34f-86d7e35e0f9f'
),
UUID_TO_BIN (
'018ec392-4b71-7237-9718-9f61adab080a'
),
6.4899020195007
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018ec9b2-820a-7063-a2ce-92c3ff4f4762' ), 33.93542098999 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018ec9b0-d867-7057-ad7a-16f05240dc89' ), 33.93542098999 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018ec9b1-bb77-7036-baf6-e39c61b785cb' ), 33.93542098999 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018ec9b2-c41b-7383-90c8-2ce72433736f' ), 33.93542098999 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb0e0-6b25-7170-bbb4-a9179ee13427' ), 11.714120864868 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb063-a314-72ad-9564-97d54f0027b0' ), 9.7441358566284 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb7e1-966c-733c-ad52-14d69ff9f8a3' ), 9.7441358566284 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb7e1-d9b4-73cf-a01a-329f41e54860' ), 9.7441358566284 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eafff-ce3c-7281-bb57-af0c377e8424' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb000-7989-70ee-95a5-6b036e4b6905' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eaffd-519a-724b-908c-31ead4937cc8' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb061-05eb-70a3-a962-167c4d310242' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb0a1-5563-71ab-bd2d-1af99b3712f3' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb0be-7d7f-739e-ae53-973556c28cfd' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb107-80b1-73db-96fb-49b88adfb011' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018eb0e5-353e-712f-b2cd-35483e10518d' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018ec3c1-c5de-71f8-8020-7460abad7bdf' ), 6.4899020195007 ), (UUID_TO_BIN ('018ec9b0-4b01-7115-b34f-86d7e35e0f9f' ), UUID_TO_BIN ('018ec392-4b71-7237-9718-9f61adab080a' ), 6.4899020195007 )
;
Copy