0.86 ms (17.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
"hpTjiIN "
]
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 = 'hpTjiIN' LIMIT 1 ;
Copy
0.84 ms (17.03%)
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 ½||´r¸\x00 íKp\e •g "
b"\x01 ޽ƒÖÓq‹Œ×·Dô×”\x17 "
b"\x01 ½~g\x12 rXj„$ºÑ_í "
b"\x01 ޽ƒ†ºqó§%SΧŸk\x13 "
b"\x01 ½qÀqz§rG~Š)Ï\x18 "
b"\x01 ½\x1A årÀÞ¤|éDXè "
b"\x01 ޽€¡"r—Ÿ\x03\x11\f ™=M\x15 "
b"\x01 ޽‚=kptšZÊú–”£Ž "
b"\x01 ½é·sŽ¥–}ó²\r Qõ "
b"\x01 ޝ«q\x1E r]Ÿ%kå\e ‰Î˜ "
b"\x01 ¯«ß1qÒŽ4Ñõ!Ë& "
b"\x01 ޝàËlq…šX|p\x1F ñ ø "
b"\x01 ޝ¼Ý7q扩ULÈêEM "
b"\x01 ޝ»ËÎs\x02 €,X¡´ïé| "
b"\x01 ¯»ôËqð½×õ~o\e ì "
b"\x01 ް_"óq©¦â]Ímò\x19 ý "
b"\x01 Ž°ÑœMsµƒç¸pŠt#£ "
b"\x01 ŽÃŒÀ˜pѳ{ VE\x0F àñ "
b"\x01 Îm\r £r\x1D ¯¸“\x11 'E "
b"\x01 ß\x16\v Öq§\x1D Uœí¢( "
]
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 (0x018EBD7C7CB472B88100ED4B701B9567 , 0x018EBD83D6D3718B8CD7B744F4D79417 , 0x018EBD7E671272589D6A8424BAD15FED , 0x018EBD8386BA71F3A72553CEA79F6B13 , 0x018EBD8171C0717AA772477E8A29CF18 , 0x018EBD811AE572C0ADDEA47CE94458E8 , 0x018EBD80A12272979F03110C993D4D15 , 0x018EBD823D6B70749A5ACAFA9694A38E , 0x018EBD81E9B7738DA5967DF3B20D51F5 , 0x018EAFAB711E725D9F256BE51B89CE98 , 0x018EAFABDF3171D28D34D1F521CB2681 , 0x018EAFE0CB6C71859A587C701FF120F8 , 0x018EAFBCDD3771E689A9554CC8EA454D , 0x018EAFBBCBCE7302802C58A1B4EFE97C , 0x018EAFBBF4CB71F0BDD7F57E6F8F1BEC , 0x018EB05F22F371A9A6E25DCD6DF219FD , 0x018EB0D19C4D73B583E7B8708A7423A3 , 0x018EC38CC09870D1B37B2056450FE0F1 , 0x018ECE6D0DA3721DAFB89311278F458E , 0x018EDF160BD671A79F1D9D559CEDA228 );
Copy
0.59 ms (11.86%)
1
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd7c-7cb4-72b8-8100-ed4b701b9567' ), 26.550331115723 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd83-d6d3-718b-8cd7-b744f4d79417' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd7e-6712-7258-9d6a-8424bad15fed' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd83-86ba-71f3-a725-53cea79f6b13' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd81-71c0-717a-a772-477e8a29cf18' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd81-1ae5-72c0-adde-a47ce94458e8' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd80-a122-7297-9f03-110c993d4d15' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd82-3d6b-7074-9a5a-cafa9694a38e' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd81-e9b7-738d-a596-7df3b20d51f5' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eafab-711e-725d-9f25-6be51b89ce98' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eafab-df31-71d2-8d34-d1f521cb2681' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eafe0-cb6c-7185-9a58-7c701ff120f8' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eafbc-dd37-71e6-89a9-554cc8ea454d' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eafbb-cbce-7302-802c-58a1b4efe97c' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eafbb-f4cb-71f0-bdd7-f57e6f8f1bec' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eb05f-22f3-71a9-a6e2-5dcd6df219fd' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eb0d1-9c4d-73b5-83e7-b8708a7423a3' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ec38c-c098-70d1-b37b-2056450fe0f1' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ece6d-0da3-721d-afb8-9311278f458e' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018edf16-0bd6-71a7-9f1d-9d559ceda228' ), 6.9930553436279 )
INSERT IGNORE INTO `movie_clip_has_related` (
`clip_id` , `related_id` , `relevance`
)
VALUES
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018ebd7c-7cb4-72b8-8100-ed4b701b9567'
),
26.550331115723
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018ebd83-d6d3-718b-8cd7-b744f4d79417'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018ebd7e-6712-7258-9d6a-8424bad15fed'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018ebd83-86ba-71f3-a725-53cea79f6b13'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018ebd81-71c0-717a-a772-477e8a29cf18'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018ebd81-1ae5-72c0-adde-a47ce94458e8'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018ebd80-a122-7297-9f03-110c993d4d15'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018ebd82-3d6b-7074-9a5a-cafa9694a38e'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018ebd81-e9b7-738d-a596-7df3b20d51f5'
),
14.836210250854
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018eafab-711e-725d-9f25-6be51b89ce98'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018eafab-df31-71d2-8d34-d1f521cb2681'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018eafe0-cb6c-7185-9a58-7c701ff120f8'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018eafbc-dd37-71e6-89a9-554cc8ea454d'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018eafbb-cbce-7302-802c-58a1b4efe97c'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018eafbb-f4cb-71f0-bdd7-f57e6f8f1bec'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018eb05f-22f3-71a9-a6e2-5dcd6df219fd'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018eb0d1-9c4d-73b5-83e7-b8708a7423a3'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018ec38c-c098-70d1-b37b-2056450fe0f1'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018ece6d-0da3-721d-afb8-9311278f458e'
),
6.9930553436279
),
(
UUID_TO_BIN (
'018ebd84-5dd5-7250-a7b5-17dd2e89d108'
),
UUID_TO_BIN (
'018edf16-0bd6-71a7-9f1d-9d559ceda228'
),
6.9930553436279
)
Copy
INSERT IGNORE INTO `movie_clip_has_related` (`clip_id` , `related_id` , `relevance` )
VALUES (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd7c-7cb4-72b8-8100-ed4b701b9567' ), 26.550331115723 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd83-d6d3-718b-8cd7-b744f4d79417' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd7e-6712-7258-9d6a-8424bad15fed' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd83-86ba-71f3-a725-53cea79f6b13' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd81-71c0-717a-a772-477e8a29cf18' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd81-1ae5-72c0-adde-a47ce94458e8' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd80-a122-7297-9f03-110c993d4d15' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd82-3d6b-7074-9a5a-cafa9694a38e' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ebd81-e9b7-738d-a596-7df3b20d51f5' ), 14.836210250854 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eafab-711e-725d-9f25-6be51b89ce98' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eafab-df31-71d2-8d34-d1f521cb2681' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eafe0-cb6c-7185-9a58-7c701ff120f8' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eafbc-dd37-71e6-89a9-554cc8ea454d' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eafbb-cbce-7302-802c-58a1b4efe97c' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eafbb-f4cb-71f0-bdd7-f57e6f8f1bec' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eb05f-22f3-71a9-a6e2-5dcd6df219fd' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018eb0d1-9c4d-73b5-83e7-b8708a7423a3' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ec38c-c098-70d1-b37b-2056450fe0f1' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018ece6d-0da3-721d-afb8-9311278f458e' ), 6.9930553436279 ), (UUID_TO_BIN ('018ebd84-5dd5-7250-a7b5-17dd2e89d108' ), UUID_TO_BIN ('018edf16-0bd6-71a7-9f1d-9d559ceda228' ), 6.9930553436279 )
;
Copy