| 1 |
7.10 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.locale AS locale_7, t0.favorite_apps AS favorite_apps_8 FROM user t0 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.firstname AS firstname_5, t0.lastname AS lastname_6, t0.locale AS locale_7, t0.favorite_apps AS favorite_apps_8 FROM user t0 WHERE t0.id = 16;
|
| 2 |
13.58 ms |
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.zipcode AS zipcode_3, r0_.city AS city_4, r0_.phone AS phone_5, r0_.email AS email_6, r0_.siret AS siret_7, r0_.tva_number AS tva_number_8, r0_.created_at AS created_at_9, r0_.type AS type_10, r0_.status AS status_11, r0_.commercial_zone AS commercial_zone_12, r0_.country AS country_13, r0_.verify_by_bd AS verify_by_bd_14, r0_.verify_by_na AS verify_by_na_15, r0_.verify_by_rl AS verify_by_rl_16, r0_.admin_comment AS admin_comment_17, r0_.close AS close_18, r0_.type_profile AS type_profile_19, r0_.reseau AS reseau_20, r0_.groupe AS groupe_21, r0_.imported AS imported_22, r0_.sap_code AS sap_code_23, r0_.activity_id AS activity_id_24, r0_.rachat_matiere_id AS rachat_matiere_id_25, r0_.network_id AS network_id_26, r0_.retailer_group_id AS retailer_group_id_27 FROM retailer r0_ WHERE r0_.status = ? ORDER BY r0_.name ASC
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.zipcode AS zipcode_3, r0_.city AS city_4, r0_.phone AS phone_5, r0_.email AS email_6, r0_.siret AS siret_7, r0_.tva_number AS tva_number_8, r0_.created_at AS created_at_9, r0_.type AS type_10, r0_.status AS status_11, r0_.commercial_zone AS commercial_zone_12, r0_.country AS country_13, r0_.verify_by_bd AS verify_by_bd_14, r0_.verify_by_na AS verify_by_na_15, r0_.verify_by_rl AS verify_by_rl_16, r0_.admin_comment AS admin_comment_17, r0_.close AS close_18, r0_.type_profile AS type_profile_19, r0_.reseau AS reseau_20, r0_.groupe AS groupe_21, r0_.imported AS imported_22, r0_.sap_code AS sap_code_23, r0_.activity_id AS activity_id_24, r0_.rachat_matiere_id AS rachat_matiere_id_25, r0_.network_id AS network_id_26, r0_.retailer_group_id AS retailer_group_id_27 FROM retailer r0_ WHERE r0_.status = 1 ORDER BY r0_.name ASC;
|
| 3 |
0.89 ms |
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.zipcode AS zipcode_3, r0_.city AS city_4, r0_.phone AS phone_5, r0_.email AS email_6, r0_.siret AS siret_7, r0_.tva_number AS tva_number_8, r0_.created_at AS created_at_9, r0_.type AS type_10, r0_.status AS status_11, r0_.commercial_zone AS commercial_zone_12, r0_.country AS country_13, r0_.verify_by_bd AS verify_by_bd_14, r0_.verify_by_na AS verify_by_na_15, r0_.verify_by_rl AS verify_by_rl_16, r0_.admin_comment AS admin_comment_17, r0_.close AS close_18, r0_.type_profile AS type_profile_19, r0_.reseau AS reseau_20, r0_.groupe AS groupe_21, r0_.imported AS imported_22, r0_.sap_code AS sap_code_23, r0_.activity_id AS activity_id_24, r0_.rachat_matiere_id AS rachat_matiere_id_25, r0_.network_id AS network_id_26, r0_.retailer_group_id AS retailer_group_id_27 FROM retailer r0_ WHERE r0_.activity_id = ? ORDER BY r0_.name ASC
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.zipcode AS zipcode_3, r0_.city AS city_4, r0_.phone AS phone_5, r0_.email AS email_6, r0_.siret AS siret_7, r0_.tva_number AS tva_number_8, r0_.created_at AS created_at_9, r0_.type AS type_10, r0_.status AS status_11, r0_.commercial_zone AS commercial_zone_12, r0_.country AS country_13, r0_.verify_by_bd AS verify_by_bd_14, r0_.verify_by_na AS verify_by_na_15, r0_.verify_by_rl AS verify_by_rl_16, r0_.admin_comment AS admin_comment_17, r0_.close AS close_18, r0_.type_profile AS type_profile_19, r0_.reseau AS reseau_20, r0_.groupe AS groupe_21, r0_.imported AS imported_22, r0_.sap_code AS sap_code_23, r0_.activity_id AS activity_id_24, r0_.rachat_matiere_id AS rachat_matiere_id_25, r0_.network_id AS network_id_26, r0_.retailer_group_id AS retailer_group_id_27 FROM retailer r0_ WHERE r0_.activity_id = 14 ORDER BY r0_.name ASC;
|
| 4 |
0.34 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.firstname AS firstname_4, u0_.lastname AS lastname_5, u0_.locale AS locale_6, u0_.favorite_apps AS favorite_apps_7 FROM user u0_
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.firstname AS firstname_4, u0_.lastname AS lastname_5, u0_.locale AS locale_6, u0_.favorite_apps AS favorite_apps_7 FROM user u0_;
|
| 5 |
0.95 ms |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.active AS active_2, m0_.position AS position_3, m0_.is_vrac AS is_vrac_4, m0_.always_bad AS always_bad_5, m0_.created_at AS created_at_6, m0_.parent_id AS parent_id_7 FROM material_type m0_ WHERE m0_.active = ? ORDER BY m0_.parent_id ASC, m0_.position ASC, m0_.name ASC
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.active AS active_2, m0_.position AS position_3, m0_.is_vrac AS is_vrac_4, m0_.always_bad AS always_bad_5, m0_.created_at AS created_at_6, m0_.parent_id AS parent_id_7 FROM material_type m0_ WHERE m0_.active = 1 ORDER BY m0_.parent_id ASC, m0_.position ASC, m0_.name ASC;
|
| 6 |
0.16 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1 FROM box_category b0_
SELECT b0_.id AS id_0, b0_.name AS name_1 FROM box_category b0_;
|
| 7 |
0.32 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.created_at AS created_at_2, b0_.width AS width_3, b0_.height AS height_4, b0_.depth AS depth_5, b0_.weight AS weight_6, b0_.empty_stack_number AS empty_stack_number_7, b0_.tracer_box_no AS tracer_box_no_8, b0_.tracer_activated AS tracer_activated_9, b0_.reference AS reference_10, b0_.box_brand_id AS box_brand_id_11, b0_.box_profiling_id AS box_profiling_id_12, b0_.box_category_id AS box_category_id_13 FROM box b0_
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.created_at AS created_at_2, b0_.width AS width_3, b0_.height AS height_4, b0_.depth AS depth_5, b0_.weight AS weight_6, b0_.empty_stack_number AS empty_stack_number_7, b0_.tracer_box_no AS tracer_box_no_8, b0_.tracer_activated AS tracer_activated_9, b0_.reference AS reference_10, b0_.box_brand_id AS box_brand_id_11, b0_.box_profiling_id AS box_profiling_id_12, b0_.box_category_id AS box_category_id_13 FROM box b0_;
|