4.27 ms (28.50%)
|
8 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_model ON t0.id = video_model.video_id WHERE video_model.model_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_model ON t0.id = video_model.video_id WHERE video_model.model_id = 18;
|
3.18 ms (21.24%)
|
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 WHERE t0.studio_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 WHERE t0.studio_id = 1;
|
3.09 ms (20.61%)
|
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.featured AS featured_7, t0.short_description AS short_description_8, t0.description AS description_9 FROM category t0 INNER JOIN video_category ON t0.id = video_category.category_id WHERE video_category.video_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.featured AS featured_7, t0.short_description AS short_description_8, t0.description AS description_9 FROM category t0 INNER JOIN video_category ON t0.id = video_category.category_id WHERE video_category.video_id = 9;
|
1.05 ms (7.00%)
|
1 |
SELECT COUNT(*) FROM video t0 WHERE t0.active = ?
SELECT COUNT(*) FROM video t0 WHERE t0.active = 1;
|
0.95 ms (6.32%)
|
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.description AS description_7, t0.cos_address AS cos_address_8, t0.country AS country_9, t0.founded AS founded_10 FROM studio t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.description AS description_7, t0.cos_address AS cos_address_8, t0.country AS country_9, t0.founded AS founded_10 FROM studio t0 WHERE t0.id = 9;
|
0.68 ms (4.53%)
|
1 |
SELECT COUNT(*) FROM model t0 WHERE t0.active = ?
SELECT COUNT(*) FROM model t0 WHERE t0.active = 1;
|
0.57 ms (3.84%)
|
1 |
SELECT COUNT(*) FROM studio t0 WHERE t0.active = ?
SELECT COUNT(*) FROM studio t0 WHERE t0.active = 1;
|
0.44 ms (2.91%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 ORDER BY t0.release_date DESC, t0.id DESC LIMIT 6
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 ORDER BY t0.release_date DESC, t0.id DESC LIMIT 6;
|
0.42 ms (2.81%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.date_of_birth AS date_of_birth_7, t0.nationality AS nationality_8, t0.gender AS gender_9, t0.ethnicity AS ethnicity_10, t0.hair_color AS hair_color_11, t0.eye_color AS eye_color_12, t0.height AS height_13, t0.weight AS weight_14, t0.measurements_hip AS measurements_hip_15, t0.measurements_waist AS measurements_waist_16, t0.measurements_bust AS measurements_bust_17, t0.shoe_size AS shoe_size_18, t0.description AS description_19, t0.views AS views_20 FROM model t0 WHERE t0.active = ? ORDER BY t0.id DESC LIMIT 8
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.date_of_birth AS date_of_birth_7, t0.nationality AS nationality_8, t0.gender AS gender_9, t0.ethnicity AS ethnicity_10, t0.hair_color AS hair_color_11, t0.eye_color AS eye_color_12, t0.height AS height_13, t0.weight AS weight_14, t0.measurements_hip AS measurements_hip_15, t0.measurements_waist AS measurements_waist_16, t0.measurements_bust AS measurements_bust_17, t0.shoe_size AS shoe_size_18, t0.description AS description_19, t0.views AS views_20 FROM model t0 WHERE t0.active = 1 ORDER BY t0.id DESC LIMIT 8;
|
0.33 ms (2.24%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.description AS description_7, t0.cos_address AS cos_address_8, t0.country AS country_9, t0.founded AS founded_10 FROM studio t0 WHERE t0.active = ? LIMIT 6
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.description AS description_7, t0.cos_address AS cos_address_8, t0.country AS country_9, t0.founded AS founded_10 FROM studio t0 WHERE t0.active = 1 LIMIT 6;
|