| 1 |
1.11 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.created_at AS created_at_5, t0.roles AS roles_6, t0.password AS password_7, t0.enabled AS enabled_8, t0.username AS username_9, t0.reset_code AS reset_code_10, t0.reset_requested_at AS reset_requested_at_11, t0.register_code AS register_code_12, t0.register_requested_at AS register_requested_at_13, t0.logged_at_least_one_time AS logged_at_least_one_time_14, t0.parent_id AS parent_id_15, t0.avatar_id AS avatar_id_16, t0.level_id AS level_id_17 FROM `user` t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.created_at AS created_at_5, t0.roles AS roles_6, t0.password AS password_7, t0.enabled AS enabled_8, t0.username AS username_9, t0.reset_code AS reset_code_10, t0.reset_requested_at AS reset_requested_at_11, t0.register_code AS register_code_12, t0.register_requested_at AS register_requested_at_13, t0.logged_at_least_one_time AS logged_at_least_one_time_14, t0.parent_id AS parent_id_15, t0.avatar_id AS avatar_id_16, t0.level_id AS level_id_17 FROM `user` t0 WHERE t0.id = 939;
|
| 2 |
1.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 WHERE t0.id = 2;
|
| 3 |
3.13 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.image AS image_4, t0_.image_path AS image_path_5, t0_.audio_path AS audio_path_6, t0_.enabled AS enabled_7, t0_.image_player_path AS image_player_path_8, t0_.starred AS starred_9 FROM track t0_ INNER JOIN categories_tracks c2_ ON t0_.id = c2_.track_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE t0_.enabled = ? AND c1_.id = ? AND (t0_.name LIKE ? OR t0_.description LIKE ?) ORDER BY t0_.id ASC
Parameters: [
1
2
"%%"
"%%"
]
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.image AS image_4, t0_.image_path AS image_path_5, t0_.audio_path AS audio_path_6, t0_.enabled AS enabled_7, t0_.image_player_path AS image_player_path_8, t0_.starred AS starred_9 FROM track t0_ INNER JOIN categories_tracks c2_ ON t0_.id = c2_.track_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE t0_.enabled = 1 AND c1_.id = 2 AND (t0_.name LIKE '%%' OR t0_.description LIKE '%%') ORDER BY t0_.id ASC;
|
| 4 |
0.35 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.image AS image_4, t0_.image_path AS image_path_5, t0_.audio_path AS audio_path_6, t0_.enabled AS enabled_7, t0_.image_player_path AS image_player_path_8, t0_.starred AS starred_9 FROM track t0_ INNER JOIN categories_tracks c2_ ON t0_.id = c2_.track_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE t0_.enabled = ? AND c1_.id = ? AND (t0_.name LIKE ? OR t0_.description LIKE ?) ORDER BY t0_.id ASC LIMIT 10
Parameters: [
1
2
"%%"
"%%"
]
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.image AS image_4, t0_.image_path AS image_path_5, t0_.audio_path AS audio_path_6, t0_.enabled AS enabled_7, t0_.image_player_path AS image_player_path_8, t0_.starred AS starred_9 FROM track t0_ INNER JOIN categories_tracks c2_ ON t0_.id = c2_.track_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE t0_.enabled = 1 AND c1_.id = 2 AND (t0_.name LIKE '%%' OR t0_.description LIKE '%%') ORDER BY t0_.id ASC LIMIT 10;
|
| 5 |
0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = 8;
|
| 6 |
0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = 9;
|
| 7 |
0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = 10;
|
| 8 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = 11;
|
| 9 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = 12;
|
| 10 |
0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = 13;
|
| 11 |
0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = 14;
|
| 12 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = 15;
|
| 13 |
0.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = 16;
|
| 14 |
0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = 17;
|