| 1 |
1.27 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.image AS image_7, t0.active AS active_8, t0.degree AS degree_9, t0.description AS description_10, t0.monthly_hours AS monthly_hours_11, t0.holiday_hours AS holiday_hours_12, t0.hourly_wage AS hourly_wage_13, t0.lang AS lang_14, t0.birth_date AS birth_date_15, t0.work_since AS work_since_16, t0.app_design AS app_design_17, t0.app_sidebar_type AS app_sidebar_type_18, t0.app_sidebar_spread AS app_sidebar_spread_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.currency_id AS currency_id_22, t0.team_id AS team_id_23, t24.id AS id_25, t24.city AS city_26, t24.phone AS phone_27, t24.street_name AS street_name_28, t24.street_number AS street_number_29, t24.zip AS zip_30, t24.ident_number AS ident_number_31, t24.vat_number AS vat_number_32, t24.created_at AS created_at_33, t24.updated_at AS updated_at_34, t24.user_id AS user_id_35, t24.country_id AS country_id_36, t37.id AS id_38, t37.first_name AS first_name_39, t37.last_name AS last_name_40, t37.number AS number_41, t37.code AS code_42, t37.iban AS iban_43, t37.created_at AS created_at_44, t37.updated_at AS updated_at_45, t37.user_id AS user_id_46 FROM user t0 LEFT JOIN address t24 ON t24.user_id = t0.id LEFT JOIN bank_account t37 ON t37.user_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.email AS email_2,
t0.roles AS roles_3,
t0.password AS password_4,
t0.first_name AS first_name_5,
t0.last_name AS last_name_6,
t0.image AS image_7,
t0.active AS active_8,
t0.degree AS degree_9,
t0.description AS description_10,
t0.monthly_hours AS monthly_hours_11,
t0.holiday_hours AS holiday_hours_12,
t0.hourly_wage AS hourly_wage_13,
t0.lang AS lang_14,
t0.birth_date AS birth_date_15,
t0.work_since AS work_since_16,
t0.app_design AS app_design_17,
t0.app_sidebar_type AS app_sidebar_type_18,
t0.app_sidebar_spread AS app_sidebar_spread_19,
t0.created_at AS created_at_20,
t0.updated_at AS updated_at_21,
t0.currency_id AS currency_id_22,
t0.team_id AS team_id_23,
t24.id AS id_25,
t24.city AS city_26,
t24.phone AS phone_27,
t24.street_name AS street_name_28,
t24.street_number AS street_number_29,
t24.zip AS zip_30,
t24.ident_number AS ident_number_31,
t24.vat_number AS vat_number_32,
t24.created_at AS created_at_33,
t24.updated_at AS updated_at_34,
t24.user_id AS user_id_35,
t24.country_id AS country_id_36,
t37.id AS id_38,
t37.first_name AS first_name_39,
t37.last_name AS last_name_40,
t37.number AS number_41,
t37.code AS code_42,
t37.iban AS iban_43,
t37.created_at AS created_at_44,
t37.updated_at AS updated_at_45,
t37.user_id AS user_id_46
FROM
user t0
LEFT JOIN address t24 ON t24.user_id = t0.id
LEFT JOIN bank_account t37 ON t37.user_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.image AS image_7, t0.active AS active_8, t0.degree AS degree_9, t0.description AS description_10, t0.monthly_hours AS monthly_hours_11, t0.holiday_hours AS holiday_hours_12, t0.hourly_wage AS hourly_wage_13, t0.lang AS lang_14, t0.birth_date AS birth_date_15, t0.work_since AS work_since_16, t0.app_design AS app_design_17, t0.app_sidebar_type AS app_sidebar_type_18, t0.app_sidebar_spread AS app_sidebar_spread_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.currency_id AS currency_id_22, t0.team_id AS team_id_23, t24.id AS id_25, t24.city AS city_26, t24.phone AS phone_27, t24.street_name AS street_name_28, t24.street_number AS street_number_29, t24.zip AS zip_30, t24.ident_number AS ident_number_31, t24.vat_number AS vat_number_32, t24.created_at AS created_at_33, t24.updated_at AS updated_at_34, t24.user_id AS user_id_35, t24.country_id AS country_id_36, t37.id AS id_38, t37.first_name AS first_name_39, t37.last_name AS last_name_40, t37.number AS number_41, t37.code AS code_42, t37.iban AS iban_43, t37.created_at AS created_at_44, t37.updated_at AS updated_at_45, t37.user_id AS user_id_46 FROM user t0 LEFT JOIN address t24 ON t24.user_id = t0.id LEFT JOIN bank_account t37 ON t37.user_id = t0.id WHERE t0.id = 779;
|
| 2 |
0.87 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM activity a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id
SELECT COUNT(a0_.id) AS sclr_0 FROM activity a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id;
|
| 3 |
0.22 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM activity a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id
SELECT COUNT(a0_.id) AS sclr_0 FROM activity a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id;
|
| 4 |
0.21 ms |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.content AS content_2, a0_.estimation AS estimation_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.first_name AS first_name_10, u1_.last_name AS last_name_11, u1_.image AS image_12, u1_.active AS active_13, u1_.degree AS degree_14, u1_.description AS description_15, u1_.monthly_hours AS monthly_hours_16, u1_.holiday_hours AS holiday_hours_17, u1_.hourly_wage AS hourly_wage_18, u1_.lang AS lang_19, u1_.birth_date AS birth_date_20, u1_.work_since AS work_since_21, u1_.app_design AS app_design_22, u1_.app_sidebar_type AS app_sidebar_type_23, u1_.app_sidebar_spread AS app_sidebar_spread_24, u1_.created_at AS created_at_25, u1_.updated_at AS updated_at_26, a0_.user_id AS user_id_27, u1_.currency_id AS currency_id_28, u1_.team_id AS team_id_29 FROM activity a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id LIMIT 12 OFFSET 12
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.content AS content_2, a0_.estimation AS estimation_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.first_name AS first_name_10, u1_.last_name AS last_name_11, u1_.image AS image_12, u1_.active AS active_13, u1_.degree AS degree_14, u1_.description AS description_15, u1_.monthly_hours AS monthly_hours_16, u1_.holiday_hours AS holiday_hours_17, u1_.hourly_wage AS hourly_wage_18, u1_.lang AS lang_19, u1_.birth_date AS birth_date_20, u1_.work_since AS work_since_21, u1_.app_design AS app_design_22, u1_.app_sidebar_type AS app_sidebar_type_23, u1_.app_sidebar_spread AS app_sidebar_spread_24, u1_.created_at AS created_at_25, u1_.updated_at AS updated_at_26, a0_.user_id AS user_id_27, u1_.currency_id AS currency_id_28, u1_.team_id AS team_id_29 FROM activity a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id LIMIT 12 OFFSET 12;
|
| 5 |
1.68 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.begin AS begin_3, t0.end AS end_4, t0.duration AS duration_5, t0.price AS price_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.activity_id AS activity_id_9, t0.user_id AS user_id_10, t0.time_record_category_id AS time_record_category_id_11 FROM time_record t0 WHERE t0.activity_id = ?
SELECT t0.id AS id_1, t0.content AS content_2, t0.begin AS begin_3, t0.end AS end_4, t0.duration AS duration_5, t0.price AS price_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.activity_id AS activity_id_9, t0.user_id AS user_id_10, t0.time_record_category_id AS time_record_category_id_11 FROM time_record t0 WHERE t0.activity_id = 15;
|
| 6 |
0.16 ms |
SELECT t0.id AS id_1, t0.city AS city_2, t0.phone AS phone_3, t0.street_name AS street_name_4, t0.street_number AS street_number_5, t0.zip AS zip_6, t0.ident_number AS ident_number_7, t0.vat_number AS vat_number_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11, t0.country_id AS country_id_12 FROM address t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.city AS city_2, t0.phone AS phone_3, t0.street_name AS street_name_4, t0.street_number AS street_number_5, t0.zip AS zip_6, t0.ident_number AS ident_number_7, t0.vat_number AS vat_number_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11, t0.country_id AS country_id_12 FROM address t0 WHERE t0.user_id = 793;
|
| 7 |
0.40 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.number AS number_4, t0.code AS code_5, t0.iban AS iban_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM bank_account t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.number AS number_4, t0.code AS code_5, t0.iban AS iban_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM bank_account t0 WHERE t0.user_id = 793;
|
| 8 |
0.37 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.begin AS begin_3, t0.end AS end_4, t0.duration AS duration_5, t0.price AS price_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.activity_id AS activity_id_9, t0.user_id AS user_id_10, t0.time_record_category_id AS time_record_category_id_11 FROM time_record t0 WHERE t0.activity_id = ?
SELECT t0.id AS id_1, t0.content AS content_2, t0.begin AS begin_3, t0.end AS end_4, t0.duration AS duration_5, t0.price AS price_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.activity_id AS activity_id_9, t0.user_id AS user_id_10, t0.time_record_category_id AS time_record_category_id_11 FROM time_record t0 WHERE t0.activity_id = 16;
|
| 9 |
0.28 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.begin AS begin_3, t0.end AS end_4, t0.duration AS duration_5, t0.price AS price_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.activity_id AS activity_id_9, t0.user_id AS user_id_10, t0.time_record_category_id AS time_record_category_id_11 FROM time_record t0 WHERE t0.activity_id = ?
SELECT t0.id AS id_1, t0.content AS content_2, t0.begin AS begin_3, t0.end AS end_4, t0.duration AS duration_5, t0.price AS price_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.activity_id AS activity_id_9, t0.user_id AS user_id_10, t0.time_record_category_id AS time_record_category_id_11 FROM time_record t0 WHERE t0.activity_id = 17;
|
| 10 |
0.22 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.begin AS begin_3, t0.end AS end_4, t0.duration AS duration_5, t0.price AS price_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.activity_id AS activity_id_9, t0.user_id AS user_id_10, t0.time_record_category_id AS time_record_category_id_11 FROM time_record t0 WHERE t0.activity_id = ?
SELECT t0.id AS id_1, t0.content AS content_2, t0.begin AS begin_3, t0.end AS end_4, t0.duration AS duration_5, t0.price AS price_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.activity_id AS activity_id_9, t0.user_id AS user_id_10, t0.time_record_category_id AS time_record_category_id_11 FROM time_record t0 WHERE t0.activity_id = 18;
|