1.38 ms (2.72%)
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 ްT„Õq\x11 ‰j’Ó \f Ž› "
b"\x01 ްTÑÕp\x11 “åîÝ\f ¤D? "
b"\x01 ްTéŠs™²í²'uÃ8\x0F "
b"\x01 ްËÔxrl¥Ö&D\x14\x16 Ъ "
b"\x01 Ž·‚íÅs›²í\x0F ÖñIí€ "
b"\x01 Žã誓pñ\x06 ›Ó”\v c "
b"\x01 °r\x00 s}±«t਺?O "
b"\x01 ްqð/r\x04 £)MR\x00 ŠH\x00 "
b"\x01 ްr\x12 ~qr®!`\x1E\x1E ìÏú "
b"\x01 ް¦å\x04 s…ºžOz\x04 ¾W\x0E "
b"\x01 °\çr<„Ó,LÅÒÌ) "
b"\x01 ޴ލßsCƒé¾Ñ»cw÷ "
b"\x01 Ž´«ßÞqc”ìêÜ-€û\x11 "
b"\x01 ŽÈë(Àq\x02 ¿ÛÊûɬ¯} "
b"\x01 Ž×”DãpÖ¢2*ûoã\x08 ô "
b"\x01 Îq2tp勎«\\x08 …u "
b"\x01 Ž×&Y(q š¢@Pï!ž¬ "
b"\x01 ŽÎtÀòp¼š]Vk\x19 r\x1C\x05 "
]
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 (0x018EB05484D57111896A92D3200C8E9B , 0x018EB054D1D5701193E5EEDD0CA4443F , 0x018EB054E98A7399B2EDB22775C3380F , 0x018EB0CBD478726CA5D626441416D0AA , 0x018EB782EDC5739BB2ED0FD6F149ED80 , 0x018EE3E8AA9370F1AD069BD3940BAD63 , 0x018EB072009D737DB1AB74E0A8BA3F4F , 0x018EB071F02F7204A3294D52008A4800 , 0x018EB072127E7172AE21601E1EECCFFA , 0x018EB0A6E5047385BA9E4F7A04BE570E , 0x018EB09D5CE7723C84D32C4CC5D2CC29 , 0x018EB48EA8DF734383E9BED1BB6377F7 , 0x018EB4ABDFDE716394ECEADC2D80FB11 , 0x018EC8EB28C07102BFDBCAFBC9ACAF7D , 0x018ED79444E370D6A2322AFB6FE308F4 , 0x018ECE71327470E58B8DC2AB5C088575 , 0x018ED726592871209AA24050EF219EAC , 0x018ECE74C0F270BC9A5D566B19721C05 );
Copy
0.94 ms (1.86%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb054-84d5-7111-896a-92d3200c8e9b' ), 16.571775436401 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb054-d1d5-7011-93e5-eedd0ca4443f' ), 16.571775436401 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb054-e98a-7399-b2ed-b22775c3380f' ), 16.571775436401 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb0cb-d478-726c-a5d6-26441416d0aa' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb782-edc5-739b-b2ed-0fd6f149ed80' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018ee3e8-aa93-70f1-ad06-9bd3940bad63' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb072-009d-737d-b1ab-74e0a8ba3f4f' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb071-f02f-7204-a329-4d52008a4800' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb072-127e-7172-ae21-601e1eeccffa' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb0a6-e504-7385-ba9e-4f7a04be570e' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb09d-5ce7-723c-84d3-2c4cc5d2cc29' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb48e-a8df-7343-83e9-bed1bb6377f7' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb4ab-dfde-7163-94ec-eadc2d80fb11' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018ec8eb-28c0-7102-bfdb-cafbc9acaf7d' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018ed794-44e3-70d6-a232-2afb6fe308f4' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018ece71-3274-70e5-8b8d-c2ab5c088575' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018ed726-5928-7120-9aa2-4050ef219eac' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018ece74-c0f2-70bc-9a5d-566b19721c05' ), 8.2858877182007 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018eb054-84d5-7111-896a-92d3200c8e9b'
),
16.571775436401
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018eb054-d1d5-7011-93e5-eedd0ca4443f'
),
16.571775436401
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018eb054-e98a-7399-b2ed-b22775c3380f'
),
16.571775436401
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018eb0cb-d478-726c-a5d6-26441416d0aa'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018eb782-edc5-739b-b2ed-0fd6f149ed80'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018ee3e8-aa93-70f1-ad06-9bd3940bad63'
),
9.7441358566284
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018eb072-009d-737d-b1ab-74e0a8ba3f4f'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018eb071-f02f-7204-a329-4d52008a4800'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018eb072-127e-7172-ae21-601e1eeccffa'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018eb0a6-e504-7385-ba9e-4f7a04be570e'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018eb09d-5ce7-723c-84d3-2c4cc5d2cc29'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018eb48e-a8df-7343-83e9-bed1bb6377f7'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018eb4ab-dfde-7163-94ec-eadc2d80fb11'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018ec8eb-28c0-7102-bfdb-cafbc9acaf7d'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018ed794-44e3-70d6-a232-2afb6fe308f4'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018ece71-3274-70e5-8b8d-c2ab5c088575'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018ed726-5928-7120-9aa2-4050ef219eac'
),
8.2858877182007
),
(
UUID_TO_BIN (
'018eb054-ab8c-71b3-bb71-705b19a2a5c6'
),
UUID_TO_BIN (
'018ece74-c0f2-70bc-9a5d-566b19721c05'
),
8.2858877182007
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb054-84d5-7111-896a-92d3200c8e9b' ), 16.571775436401 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb054-d1d5-7011-93e5-eedd0ca4443f' ), 16.571775436401 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb054-e98a-7399-b2ed-b22775c3380f' ), 16.571775436401 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb0cb-d478-726c-a5d6-26441416d0aa' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb782-edc5-739b-b2ed-0fd6f149ed80' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018ee3e8-aa93-70f1-ad06-9bd3940bad63' ), 9.7441358566284 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb072-009d-737d-b1ab-74e0a8ba3f4f' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb071-f02f-7204-a329-4d52008a4800' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb072-127e-7172-ae21-601e1eeccffa' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb0a6-e504-7385-ba9e-4f7a04be570e' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb09d-5ce7-723c-84d3-2c4cc5d2cc29' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb48e-a8df-7343-83e9-bed1bb6377f7' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018eb4ab-dfde-7163-94ec-eadc2d80fb11' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018ec8eb-28c0-7102-bfdb-cafbc9acaf7d' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018ed794-44e3-70d6-a232-2afb6fe308f4' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018ece71-3274-70e5-8b8d-c2ab5c088575' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018ed726-5928-7120-9aa2-4050ef219eac' ), 8.2858877182007 ), (UUID_TO_BIN ('018eb054-ab8c-71b3-bb71-705b19a2a5c6' ), UUID_TO_BIN ('018ece74-c0f2-70bc-9a5d-566b19721c05' ), 8.2858877182007 )
;
Copy
0.69 ms (1.37%)
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
"S8nQKl4 "
]
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 = 'S8nQKl4' LIMIT 1 ;
Copy