4.23 ms (19.20%)
2
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . full_name AS full_name_3 FROM lang t0 WHERE t0 . name = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . full_name AS full_name_3 FROM lang t0 WHERE t0 . name = 'ru' LIMIT 1 ;
Copy
3.50 ms (15.89%)
1
SELECT u0_ . id AS id_0 , u0_ . name AS name_1 , u0_ . surname AS surname_2 , u0_ . birthday AS birthday_3 , u0_ . gender AS gender_4 , u0_ . img AS img_5 , u0_ . phone_number AS phone_number_6 , u0_ . balance AS balance_7 , u0_ . work_experience AS work_experience_8 , u0_ . self AS self_9 , u0_ . role AS role_10 , u0_ . token AS token_11 , u0_ . latitude AS latitude_12 , u0_ . longitude AS longitude_13 , u0_ . push_token AS push_token_14 , u0_ . work_imgs AS work_imgs_15 , u0_ . city_name AS city_name_16 , u0_ . register_date AS register_date_17 , u0_ . ban_text AS ban_text_18 , u0_ . b AS b_19 , u0_ . city_id AS city_id_20 , u0_ . lang_id AS lang_id_21 FROM user u0_ INNER JOIN user_category u2_ ON u0_ . id = u2_ . user_id INNER JOIN category c1_ ON c1_ . id = u2_ . category_id WHERE c1_ . id = ? AND u0_ . role = ?
SELECT u0_ . id AS id_0 , u0_ . name AS name_1 , u0_ . surname AS surname_2 , u0_ . birthday AS birthday_3 , u0_ . gender AS gender_4 , u0_ . img AS img_5 , u0_ . phone_number AS phone_number_6 , u0_ . balance AS balance_7 , u0_ . work_experience AS work_experience_8 , u0_ . self AS self_9 , u0_ . role AS role_10 , u0_ . token AS token_11 , u0_ . latitude AS latitude_12 , u0_ . longitude AS longitude_13 , u0_ . push_token AS push_token_14 , u0_ . work_imgs AS work_imgs_15 , u0_ . city_name AS city_name_16 , u0_ . register_date AS register_date_17 , u0_ . ban_text AS ban_text_18 , u0_ . b AS b_19 , u0_ . city_id AS city_id_20 , u0_ . lang_id AS lang_id_21 FROM user u0_ INNER JOIN user_category u2_ ON u0_ . id = u2_ . user_id INNER JOIN category c1_ ON c1_ . id = u2_ . category_id WHERE c1_ . id = 36 AND u0_ . role = 2 ;
Copy
3.29 ms (14.91%)
1
SELECT COUNT (* ) FROM orders_performers t0 WHERE t0 . performers_id = ? AND t0 . status = ?
SELECT COUNT (* ) FROM orders_performers t0 WHERE t0 . performers_id = 483 AND t0 . status = 3 ;
Copy
2.83 ms (12.84%)
1
SELECT u0_ . id AS id_0 , u0_ . name AS name_1 , u0_ . surname AS surname_2 , u0_ . birthday AS birthday_3 , u0_ . gender AS gender_4 , u0_ . img AS img_5 , u0_ . phone_number AS phone_number_6 , u0_ . balance AS balance_7 , u0_ . work_experience AS work_experience_8 , u0_ . self AS self_9 , u0_ . role AS role_10 , u0_ . token AS token_11 , u0_ . latitude AS latitude_12 , u0_ . longitude AS longitude_13 , u0_ . push_token AS push_token_14 , u0_ . work_imgs AS work_imgs_15 , u0_ . city_name AS city_name_16 , u0_ . register_date AS register_date_17 , u0_ . ban_text AS ban_text_18 , u0_ . b AS b_19 , u0_ . city_id AS city_id_20 , u0_ . lang_id AS lang_id_21 FROM user u0_ INNER JOIN user_category u2_ ON u0_ . id = u2_ . user_id INNER JOIN category c1_ ON c1_ . id = u2_ . category_id WHERE c1_ . id = ? AND u0_ . role = ? AND u0_ . id IN (? )
SELECT u0_ . id AS id_0 , u0_ . name AS name_1 , u0_ . surname AS surname_2 , u0_ . birthday AS birthday_3 , u0_ . gender AS gender_4 , u0_ . img AS img_5 , u0_ . phone_number AS phone_number_6 , u0_ . balance AS balance_7 , u0_ . work_experience AS work_experience_8 , u0_ . self AS self_9 , u0_ . role AS role_10 , u0_ . token AS token_11 , u0_ . latitude AS latitude_12 , u0_ . longitude AS longitude_13 , u0_ . push_token AS push_token_14 , u0_ . work_imgs AS work_imgs_15 , u0_ . city_name AS city_name_16 , u0_ . register_date AS register_date_17 , u0_ . ban_text AS ban_text_18 , u0_ . b AS b_19 , u0_ . city_id AS city_id_20 , u0_ . lang_id AS lang_id_21 FROM user u0_ INNER JOIN user_category u2_ ON u0_ . id = u2_ . user_id INNER JOIN category c1_ ON c1_ . id = u2_ . category_id WHERE c1_ . id = 36 AND u0_ . role = 2 AND u0_ . id IN (483 );
Copy
2.00 ms (9.05%)
1
SELECT DISTINCT u0_ . id AS id_0 FROM user u0_ INNER JOIN user_category u2_ ON u0_ . id = u2_ . user_id INNER JOIN category c1_ ON c1_ . id = u2_ . category_id WHERE c1_ . id = ? AND u0_ . role = ? LIMIT 10
SELECT DISTINCT u0_ . id AS id_0 FROM user u0_ INNER JOIN user_category u2_ ON u0_ . id = u2_ . user_id INNER JOIN category c1_ ON c1_ . id = u2_ . category_id WHERE c1_ . id = 36 AND u0_ . role = 2 LIMIT 10 ;
Copy
1.81 ms (8.18%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . img AS img_3 , t0 . parent_id AS parent_id_4 , t0 . is_deleted AS is_deleted_5 , t0 . parent_id AS parent_id_6 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . img AS img_3 , t0 . parent_id AS parent_id_4 , t0 . is_deleted AS is_deleted_5 , t0 . parent_id AS parent_id_6 FROM category t0 WHERE t0 . id = 36 ;
Copy
1.54 ms (6.98%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . img AS img_3 , t0 . parent_id AS parent_id_4 , t0 . is_deleted AS is_deleted_5 , t0 . parent_id AS parent_id_6 FROM category t0 INNER JOIN user_category ON t0 . id = user_category . category_id WHERE user_category . user_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . img AS img_3 , t0 . parent_id AS parent_id_4 , t0 . is_deleted AS is_deleted_5 , t0 . parent_id AS parent_id_6 FROM category t0 INNER JOIN user_category ON t0 . id = user_category . category_id WHERE user_category . user_id = 483 ;
Copy
1.15 ms (5.22%)
1
SELECT count (DISTINCT u0_ . id ) AS sclr_0 FROM user u0_ INNER JOIN user_category u2_ ON u0_ . id = u2_ . user_id INNER JOIN category c1_ ON c1_ . id = u2_ . category_id WHERE c1_ . id = ? AND u0_ . role = ?
SELECT count (DISTINCT u0_ . id ) AS sclr_0 FROM user u0_ INNER JOIN user_category u2_ ON u0_ . id = u2_ . user_id INNER JOIN category c1_ ON c1_ . id = u2_ . category_id WHERE c1_ . id = 36 AND u0_ . role = 2 ;
Copy
0.92 ms (4.17%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . category_id AS category_id_3 , t0 . lang_id AS lang_id_4 FROM category_translate t0 WHERE t0 . category_id = ? AND t0 . lang_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . category_id AS category_id_3 , t0 . lang_id AS lang_id_4 FROM category_translate t0 WHERE t0 . category_id = 36 AND t0 . lang_id = 2 LIMIT 1 ;
Copy
0.79 ms (3.57%)
1
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . grade AS grade_3 , t0 . descr AS descr_4 , t0 . user_id AS user_id_5 , t0 . performer_id AS performer_id_6 , t0 . orders_id AS orders_id_7 FROM review t0 WHERE t0 . performer_id = ?
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . grade AS grade_3 , t0 . descr AS descr_4 , t0 . user_id AS user_id_5 , t0 . performer_id AS performer_id_6 , t0 . orders_id AS orders_id_7 FROM review t0 WHERE t0 . performer_id = 483 ;
Copy