4.02 ms (27.43%)
|
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.70 ms (25.26%)
|
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;
|
2.52 ms (17.19%)
|
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;
|
1.17 ms (8.00%)
|
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.76 ms (5.17%)
|
1 |
SELECT COUNT(*) FROM video t0 WHERE t0.active = ?
SELECT COUNT(*) FROM video t0 WHERE t0.active = 1;
|
0.59 ms (4.00%)
|
1 |
SELECT COUNT(*) FROM studio t0 WHERE t0.active = ?
SELECT COUNT(*) FROM studio t0 WHERE t0.active = 1;
|
0.56 ms (3.79%)
|
1 |
SELECT COUNT(*) FROM model t0 WHERE t0.active = ?
SELECT COUNT(*) FROM model t0 WHERE t0.active = 1;
|
0.50 ms (3.40%)
|
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.44 ms (3.02%)
|
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.40 ms (2.74%)
|
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;
|