Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_valid AS is_valid_5,
  t0.is_verified AS is_verified_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = 6379;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  role t0
  INNER JOIN role_user ON t0.id = role_user.role_id
WHERE
  role_user.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = 6379;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.created_at AS created_at_4,
  t0.email AS email_5,
  t0.description AS description_6,
  t0.is_valid AS is_valid_7,
  t0.full_name AS full_name_8,
  t0.tel AS tel_9,
  t0.address AS address_10,
  t0.city AS city_11,
  t0.ice AS ice_12,
  t0.rc AS rc_13,
  t0.simulate_username AS simulate_username_14,
  t0.simulate_password AS simulate_password_15,
  t0.cover_image AS cover_image_16,
  t0.path_rcimage AS path_rcimage_17,
  t0.path_ice_image AS path_ice_image_18,
  t0.path_ifimage AS path_ifimage_19,
  t0.identifiant_fiscale AS identifiant_fiscale_20,
  t0.user_id AS user_id_21
FROM
  vendor t0
WHERE
  t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.email AS email_5, t0.description AS description_6, t0.is_valid AS is_valid_7, t0.full_name AS full_name_8, t0.tel AS tel_9, t0.address AS address_10, t0.city AS city_11, t0.ice AS ice_12, t0.rc AS rc_13, t0.simulate_username AS simulate_username_14, t0.simulate_password AS simulate_password_15, t0.cover_image AS cover_image_16, t0.path_rcimage AS path_rcimage_17, t0.path_ice_image AS path_ice_image_18, t0.path_ifimage AS path_ifimage_19, t0.identifiant_fiscale AS identifiant_fiscale_20, t0.user_id AS user_id_21 FROM vendor t0 WHERE t0.user_id = 6379 LIMIT 1;

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.reference AS reference_1
FROM
  `order` o0_
  LEFT JOIN document d1_ ON o0_.id = d1_.id
WHERE
  (
    o0_.status <> 'canceled'
    OR o0_.status IS NULL
  )
  AND (o0_.deleted_at IS NULL)
ORDER BY
  o0_.reference DESC
LIMIT
  10 OFFSET 50

SELECT DISTINCT o0_.id AS id_0, o0_.reference AS reference_1 FROM `order` o0_ LEFT JOIN document d1_ ON o0_.id = d1_.id WHERE (o0_.status <> 'canceled' OR o0_.status IS NULL) AND (o0_.deleted_at IS NULL) ORDER BY o0_.reference DESC LIMIT 10 OFFSET 50;

SELECT
  o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.description AS description_2,
  o0_.first_name AS first_name_3,
  o0_.last_name AS last_name_4,
  o0_.company_name AS company_name_5,
  o0_.address AS address_6,
  o0_.city AS city_7,
  o0_.country AS country_8,
  o0_.department AS department_9,
  o0_.postcode AS postcode_10,
  o0_.email AS email_11,
  o0_.tel AS tel_12,
  o0_.comment AS comment_13,
  o0_.status AS status_14,
  o0_.source AS source_15,
  o0_.delivery_at AS delivery_at_16,
  o0_.recovery_at AS recovery_at_17,
  o0_.old_order_number AS old_order_number_18,
  o0_.reduction AS reduction_19,
  o0_.distance AS distance_20,
  o0_.payed_amount AS payed_amount_21,
  o0_.start_processing_at AS start_processing_at_22,
  o0_.delivery_type AS delivery_type_23,
  o0_.start_delivery_at AS start_delivery_at_24,
  o0_.is_to_do AS is_to_do_25,
  o0_.collect_address AS collect_address_26,
  o0_.shipping_address AS shipping_address_27,
  o0_.collect_tel AS collect_tel_28,
  o0_.is_heavy AS is_heavy_29,
  o0_.shipping_tips AS shipping_tips_30,
  o0_.wallet_payment_amount AS wallet_payment_amount_31,
  o0_.is_checked AS is_checked_32,
  o0_.token_stripe AS token_stripe_33,
  o0_.order_type AS order_type_34,
  o0_.deleted_at AS deleted_at_35,
  o0_.created_by AS created_by_36,
  o0_.reference AS reference_37,
  d1_.type AS type_38,
  o0_.dtype AS dtype_39,
  o0_.customer_id AS customer_id_40,
  o0_.demande_fund_id AS demande_fund_id_41,
  o0_.shipping_method_id AS shipping_method_id_42,
  o0_.agent_id AS agent_id_43,
  o0_.payment_method_id AS payment_method_id_44,
  o0_.coupon_id AS coupon_id_45,
  o0_.agent_to_do_id AS agent_to_do_id_46,
  o0_.city_region_shipping_id AS city_region_shipping_id_47,
  o0_.city_region_collect_id AS city_region_collect_id_48,
  o0_.vendor_id AS vendor_id_49,
  o0_.store_id AS store_id_50,
  o0_.shipment_id AS shipment_id_51,
  o0_.invoice_id AS invoice_id_52,
  o0_.cash_box_order_id AS cash_box_order_id_53
FROM
  `order` o0_
  LEFT JOIN document d1_ ON o0_.id = d1_.id
WHERE
  (
    (
      o0_.status <> 'canceled'
      OR o0_.status IS NULL
    )
    AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND (o0_.deleted_at IS NULL)
ORDER BY
  o0_.reference DESC

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.description AS description_2, o0_.first_name AS first_name_3, o0_.last_name AS last_name_4, o0_.company_name AS company_name_5, o0_.address AS address_6, o0_.city AS city_7, o0_.country AS country_8, o0_.department AS department_9, o0_.postcode AS postcode_10, o0_.email AS email_11, o0_.tel AS tel_12, o0_.comment AS comment_13, o0_.status AS status_14, o0_.source AS source_15, o0_.delivery_at AS delivery_at_16, o0_.recovery_at AS recovery_at_17, o0_.old_order_number AS old_order_number_18, o0_.reduction AS reduction_19, o0_.distance AS distance_20, o0_.payed_amount AS payed_amount_21, o0_.start_processing_at AS start_processing_at_22, o0_.delivery_type AS delivery_type_23, o0_.start_delivery_at AS start_delivery_at_24, o0_.is_to_do AS is_to_do_25, o0_.collect_address AS collect_address_26, o0_.shipping_address AS shipping_address_27, o0_.collect_tel AS collect_tel_28, o0_.is_heavy AS is_heavy_29, o0_.shipping_tips AS shipping_tips_30, o0_.wallet_payment_amount AS wallet_payment_amount_31, o0_.is_checked AS is_checked_32, o0_.token_stripe AS token_stripe_33, o0_.order_type AS order_type_34, o0_.deleted_at AS deleted_at_35, o0_.created_by AS created_by_36, o0_.reference AS reference_37, d1_.type AS type_38, o0_.dtype AS dtype_39, o0_.customer_id AS customer_id_40, o0_.demande_fund_id AS demande_fund_id_41, o0_.shipping_method_id AS shipping_method_id_42, o0_.agent_id AS agent_id_43, o0_.payment_method_id AS payment_method_id_44, o0_.coupon_id AS coupon_id_45, o0_.agent_to_do_id AS agent_to_do_id_46, o0_.city_region_shipping_id AS city_region_shipping_id_47, o0_.city_region_collect_id AS city_region_collect_id_48, o0_.vendor_id AS vendor_id_49, o0_.store_id AS store_id_50, o0_.shipment_id AS shipment_id_51, o0_.invoice_id AS invoice_id_52, o0_.cash_box_order_id AS cash_box_order_id_53 FROM `order` o0_ LEFT JOIN document d1_ ON o0_.id = d1_.id WHERE ((o0_.status <> 'canceled' OR o0_.status IS NULL) AND o0_.id IN (5370, 5369, 5368, 5367, 5366, 5361, 5360, 5362, 5359, 5358)) AND (o0_.deleted_at IS NULL) ORDER BY o0_.reference DESC;

SELECT
  count(o0_.id) AS sclr_0
FROM
  `order` o0_
  LEFT JOIN document d1_ ON o0_.id = d1_.id
WHERE
  (
    o0_.status <> 'canceled'
    OR o0_.status IS NULL
  )
  AND (o0_.deleted_at IS NULL)

SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ LEFT JOIN document d1_ ON o0_.id = d1_.id WHERE (o0_.status <> 'canceled' OR o0_.status IS NULL) AND (o0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.email AS email_3,
  t0.created_at AS created_at_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.address AS address_7,
  t0.city AS city_8,
  t0.phone AS phone_9,
  t0.company_name AS company_name_10,
  t0.address_indication AS address_indication_11,
  t0.country AS country_12,
  t0.post_code AS post_code_13,
  t0.gender AS gender_14,
  t0.date_of_birth AS date_of_birth_15,
  t0.sponsorship_code AS sponsorship_code_16,
  t0.image AS image_17,
  t0.can_receive_mails AS can_receive_mails_18,
  t0.can_receive_sms AS can_receive_sms_19,
  t0.blind_password AS blind_password_20,
  t0.deleted_at AS deleted_at_21,
  t0.collect_address AS collect_address_22,
  t0.shipping_address AS shipping_address_23,
  t0.collect_lat AS collect_lat_24,
  t0.collect_lng AS collect_lng_25,
  t0.shipping_lng AS shipping_lng_26,
  t0.code AS code_27,
  t0.reference AS reference_28,
  t0.identity_number AS identity_number_29,
  t0.is_actif AS is_actif_30,
  t0.customer_group_id AS customer_group_id_31,
  t0.user_id AS user_id_32,
  t0.vendor_id AS vendor_id_33,
  t0.city_region_id AS city_region_id_34,
  t0.store_id AS store_id_35
FROM
  customer t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.description AS description_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.address AS address_7, t0.city AS city_8, t0.phone AS phone_9, t0.company_name AS company_name_10, t0.address_indication AS address_indication_11, t0.country AS country_12, t0.post_code AS post_code_13, t0.gender AS gender_14, t0.date_of_birth AS date_of_birth_15, t0.sponsorship_code AS sponsorship_code_16, t0.image AS image_17, t0.can_receive_mails AS can_receive_mails_18, t0.can_receive_sms AS can_receive_sms_19, t0.blind_password AS blind_password_20, t0.deleted_at AS deleted_at_21, t0.collect_address AS collect_address_22, t0.shipping_address AS shipping_address_23, t0.collect_lat AS collect_lat_24, t0.collect_lng AS collect_lng_25, t0.shipping_lng AS shipping_lng_26, t0.code AS code_27, t0.reference AS reference_28, t0.identity_number AS identity_number_29, t0.is_actif AS is_actif_30, t0.customer_group_id AS customer_group_id_31, t0.user_id AS user_id_32, t0.vendor_id AS vendor_id_33, t0.city_region_id AS city_region_id_34, t0.store_id AS store_id_35 FROM customer t0 WHERE t0.id = 5493 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.address AS address_6,
  t0.photo_identity AS photo_identity_7,
  t0.gender AS gender_8,
  t0.identity_number AS identity_number_9,
  t0.deleted_at AS deleted_at_10,
  t0.user_id AS user_id_11,
  t0.agent_type_id AS agent_type_id_12,
  t0.store_id AS store_id_13,
  t0.agent_objective_id AS agent_objective_id_14
FROM
  agent t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.photo_identity AS photo_identity_7, t0.gender AS gender_8, t0.identity_number AS identity_number_9, t0.deleted_at AS deleted_at_10, t0.user_id AS user_id_11, t0.agent_type_id AS agent_type_id_12, t0.store_id AS store_id_13, t0.agent_objective_id AS agent_objective_id_14 FROM agent t0 WHERE t0.id = 29 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_valid AS is_valid_5,
  t0.is_verified AS is_verified_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = 6401;

SELECT
  t0.id AS id_1,
  t0.start_at AS start_at_2,
  t0.end_at AS end_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.store_id AS store_id_5
FROM
  cash_box_order t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.deleted_at AS deleted_at_4, t0.store_id AS store_id_5 FROM cash_box_order t0 WHERE t0.id = 694;

SELECT
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.description AS description_4,
  t0.quantity AS quantity_5,
  t0.price AS price_6,
  t0.reduction AS reduction_7,
  t0.product_id AS product_id_8,
  t0.parent_order_id AS parent_order_id_9,
  t0.pack_engagement_id AS pack_engagement_id_10,
  t0.shipment_item_id AS shipment_item_id_11,
  t0.dtype,
  t1.movement_type AS movement_type_12,
  t1.movement_objectif AS movement_objectif_13,
  t1.article_id AS article_id_14,
  t1.document_id AS document_id_15
FROM
  order_item t0
  LEFT JOIN stock t1 ON t0.id = t1.id
WHERE
  t0.parent_order_id = ?

SELECT t0.id AS id_2, t0.created_at AS created_at_3, t0.description AS description_4, t0.quantity AS quantity_5, t0.price AS price_6, t0.reduction AS reduction_7, t0.product_id AS product_id_8, t0.parent_order_id AS parent_order_id_9, t0.pack_engagement_id AS pack_engagement_id_10, t0.shipment_item_id AS shipment_item_id_11, t0.dtype, t1.movement_type AS movement_type_12, t1.movement_objectif AS movement_objectif_13, t1.article_id AS article_id_14, t1.document_id AS document_id_15 FROM order_item t0 LEFT JOIN stock t1 ON t0.id = t1.id WHERE t0.parent_order_id = 5370;

SELECT
  t0.id AS id_3,
  t0.name AS name_4,
  t0.image AS image_5,
  t0.price AS price_6,
  t0.description AS description_7,
  t0.old_price AS old_price_8,
  t0.quantity AS quantity_9,
  t0.product_type AS product_type_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.meta_keywords AS meta_keywords_13,
  t0.slug AS slug_14,
  t0.created_at AS created_at_15,
  t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16,
  t0.percent_reduction AS percent_reduction_17,
  t0.sku_code AS sku_code_18,
  t0.short_description AS short_description_19,
  t0.is_published AS is_published_20,
  t0.sku_code_shop AS sku_code_shop_21,
  t0.end_at AS end_at_22,
  t0.type_reduction AS type_reduction_23,
  t0.value_reduction AS value_reduction_24,
  t0.subscription_monthly_price AS subscription_monthly_price_25,
  t0.subscription_yearly_price AS subscription_yearly_price_26,
  t0.deleted_at AS deleted_at_27,
  t0.label_price_from AS label_price_from_28,
  t0.subscription_duration AS subscription_duration_29,
  t0.promotion_id AS promotion_id_30,
  t0.vendor_id AS vendor_id_31,
  t0.brand_id AS brand_id_32,
  t0.parent_category_id AS parent_category_id_33,
  t0.cloned_product_id AS cloned_product_id_34,
  t0.store_id AS store_id_35,
  t0.dtype,
  t1.regular_price AS regular_price_36
FROM
  product t0
  LEFT JOIN article t1 ON t0.id = t1.id
  LEFT JOIN shop_product t2 ON t0.id = t2.id
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_3, t0.name AS name_4, t0.image AS image_5, t0.price AS price_6, t0.description AS description_7, t0.old_price AS old_price_8, t0.quantity AS quantity_9, t0.product_type AS product_type_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16, t0.percent_reduction AS percent_reduction_17, t0.sku_code AS sku_code_18, t0.short_description AS short_description_19, t0.is_published AS is_published_20, t0.sku_code_shop AS sku_code_shop_21, t0.end_at AS end_at_22, t0.type_reduction AS type_reduction_23, t0.value_reduction AS value_reduction_24, t0.subscription_monthly_price AS subscription_monthly_price_25, t0.subscription_yearly_price AS subscription_yearly_price_26, t0.deleted_at AS deleted_at_27, t0.label_price_from AS label_price_from_28, t0.subscription_duration AS subscription_duration_29, t0.promotion_id AS promotion_id_30, t0.vendor_id AS vendor_id_31, t0.brand_id AS brand_id_32, t0.parent_category_id AS parent_category_id_33, t0.cloned_product_id AS cloned_product_id_34, t0.store_id AS store_id_35, t0.dtype, t1.regular_price AS regular_price_36 FROM product t0 LEFT JOIN article t1 ON t0.id = t1.id LEFT JOIN shop_product t2 ON t0.id = t2.id WHERE t0.id = 3 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_3,
  t0.name AS name_4,
  t0.image AS image_5,
  t0.price AS price_6,
  t0.description AS description_7,
  t0.old_price AS old_price_8,
  t0.quantity AS quantity_9,
  t0.product_type AS product_type_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.meta_keywords AS meta_keywords_13,
  t0.slug AS slug_14,
  t0.created_at AS created_at_15,
  t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16,
  t0.percent_reduction AS percent_reduction_17,
  t0.sku_code AS sku_code_18,
  t0.short_description AS short_description_19,
  t0.is_published AS is_published_20,
  t0.sku_code_shop AS sku_code_shop_21,
  t0.end_at AS end_at_22,
  t0.type_reduction AS type_reduction_23,
  t0.value_reduction AS value_reduction_24,
  t0.subscription_monthly_price AS subscription_monthly_price_25,
  t0.subscription_yearly_price AS subscription_yearly_price_26,
  t0.deleted_at AS deleted_at_27,
  t0.label_price_from AS label_price_from_28,
  t0.subscription_duration AS subscription_duration_29,
  t0.promotion_id AS promotion_id_30,
  t0.vendor_id AS vendor_id_31,
  t0.brand_id AS brand_id_32,
  t0.parent_category_id AS parent_category_id_33,
  t0.cloned_product_id AS cloned_product_id_34,
  t0.store_id AS store_id_35,
  t0.dtype,
  t1.regular_price AS regular_price_36
FROM
  product t0
  LEFT JOIN article t1 ON t0.id = t1.id
  LEFT JOIN shop_product t2 ON t0.id = t2.id
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_3, t0.name AS name_4, t0.image AS image_5, t0.price AS price_6, t0.description AS description_7, t0.old_price AS old_price_8, t0.quantity AS quantity_9, t0.product_type AS product_type_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16, t0.percent_reduction AS percent_reduction_17, t0.sku_code AS sku_code_18, t0.short_description AS short_description_19, t0.is_published AS is_published_20, t0.sku_code_shop AS sku_code_shop_21, t0.end_at AS end_at_22, t0.type_reduction AS type_reduction_23, t0.value_reduction AS value_reduction_24, t0.subscription_monthly_price AS subscription_monthly_price_25, t0.subscription_yearly_price AS subscription_yearly_price_26, t0.deleted_at AS deleted_at_27, t0.label_price_from AS label_price_from_28, t0.subscription_duration AS subscription_duration_29, t0.promotion_id AS promotion_id_30, t0.vendor_id AS vendor_id_31, t0.brand_id AS brand_id_32, t0.parent_category_id AS parent_category_id_33, t0.cloned_product_id AS cloned_product_id_34, t0.store_id AS store_id_35, t0.dtype, t1.regular_price AS regular_price_36 FROM product t0 LEFT JOIN article t1 ON t0.id = t1.id LEFT JOIN shop_product t2 ON t0.id = t2.id WHERE t0.id = 8 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.amount AS amount_3,
  t0.state AS state_4,
  t0.description AS description_5,
  t0.payer_first_name AS payer_first_name_6,
  t0.payer_last_name AS payer_last_name_7,
  t0.bank_name AS bank_name_8,
  t0.bank_account_number AS bank_account_number_9,
  t0.reference AS reference_10,
  t0.payment_method_id AS payment_method_id_11,
  t0.related_order_id AS related_order_id_12
FROM
  payment t0
WHERE
  t0.related_order_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.amount AS amount_3, t0.state AS state_4, t0.description AS description_5, t0.payer_first_name AS payer_first_name_6, t0.payer_last_name AS payer_last_name_7, t0.bank_name AS bank_name_8, t0.bank_account_number AS bank_account_number_9, t0.reference AS reference_10, t0.payment_method_id AS payment_method_id_11, t0.related_order_id AS related_order_id_12 FROM payment t0 WHERE t0.related_order_id = 5370;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.code AS code_5,
  t0.is_enabled AS is_enabled_6,
  t0.created_at AS created_at_7,
  t0.position AS position_8,
  t0.type AS type_9,
  t0.secret_key AS secret_key_10,
  t0.public_key AS public_key_11,
  t0.display_on AS display_on_12
FROM
  payment_method t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.code AS code_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.position AS position_8, t0.type AS type_9, t0.secret_key AS secret_key_10, t0.public_key AS public_key_11, t0.display_on AS display_on_12 FROM payment_method t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.email AS email_3,
  t0.created_at AS created_at_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.address AS address_7,
  t0.city AS city_8,
  t0.phone AS phone_9,
  t0.company_name AS company_name_10,
  t0.address_indication AS address_indication_11,
  t0.country AS country_12,
  t0.post_code AS post_code_13,
  t0.gender AS gender_14,
  t0.date_of_birth AS date_of_birth_15,
  t0.sponsorship_code AS sponsorship_code_16,
  t0.image AS image_17,
  t0.can_receive_mails AS can_receive_mails_18,
  t0.can_receive_sms AS can_receive_sms_19,
  t0.blind_password AS blind_password_20,
  t0.deleted_at AS deleted_at_21,
  t0.collect_address AS collect_address_22,
  t0.shipping_address AS shipping_address_23,
  t0.collect_lat AS collect_lat_24,
  t0.collect_lng AS collect_lng_25,
  t0.shipping_lng AS shipping_lng_26,
  t0.code AS code_27,
  t0.reference AS reference_28,
  t0.identity_number AS identity_number_29,
  t0.is_actif AS is_actif_30,
  t0.customer_group_id AS customer_group_id_31,
  t0.user_id AS user_id_32,
  t0.vendor_id AS vendor_id_33,
  t0.city_region_id AS city_region_id_34,
  t0.store_id AS store_id_35
FROM
  customer t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.description AS description_2, t0.email AS email_3, t0.created_at AS created_at_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.address AS address_7, t0.city AS city_8, t0.phone AS phone_9, t0.company_name AS company_name_10, t0.address_indication AS address_indication_11, t0.country AS country_12, t0.post_code AS post_code_13, t0.gender AS gender_14, t0.date_of_birth AS date_of_birth_15, t0.sponsorship_code AS sponsorship_code_16, t0.image AS image_17, t0.can_receive_mails AS can_receive_mails_18, t0.can_receive_sms AS can_receive_sms_19, t0.blind_password AS blind_password_20, t0.deleted_at AS deleted_at_21, t0.collect_address AS collect_address_22, t0.shipping_address AS shipping_address_23, t0.collect_lat AS collect_lat_24, t0.collect_lng AS collect_lng_25, t0.shipping_lng AS shipping_lng_26, t0.code AS code_27, t0.reference AS reference_28, t0.identity_number AS identity_number_29, t0.is_actif AS is_actif_30, t0.customer_group_id AS customer_group_id_31, t0.user_id AS user_id_32, t0.vendor_id AS vendor_id_33, t0.city_region_id AS city_region_id_34, t0.store_id AS store_id_35 FROM customer t0 WHERE t0.id = 5492 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.address AS address_6,
  t0.photo_identity AS photo_identity_7,
  t0.gender AS gender_8,
  t0.identity_number AS identity_number_9,
  t0.deleted_at AS deleted_at_10,
  t0.user_id AS user_id_11,
  t0.agent_type_id AS agent_type_id_12,
  t0.store_id AS store_id_13,
  t0.agent_objective_id AS agent_objective_id_14
FROM
  agent t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.photo_identity AS photo_identity_7, t0.gender AS gender_8, t0.identity_number AS identity_number_9, t0.deleted_at AS deleted_at_10, t0.user_id AS user_id_11, t0.agent_type_id AS agent_type_id_12, t0.store_id AS store_id_13, t0.agent_objective_id AS agent_objective_id_14 FROM agent t0 WHERE t0.id = 25 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_valid AS is_valid_5,
  t0.is_verified AS is_verified_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = 6396;

SELECT
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.description AS description_4,
  t0.quantity AS quantity_5,
  t0.price AS price_6,
  t0.reduction AS reduction_7,
  t0.product_id AS product_id_8,
  t0.parent_order_id AS parent_order_id_9,
  t0.pack_engagement_id AS pack_engagement_id_10,
  t0.shipment_item_id AS shipment_item_id_11,
  t0.dtype,
  t1.movement_type AS movement_type_12,
  t1.movement_objectif AS movement_objectif_13,
  t1.article_id AS article_id_14,
  t1.document_id AS document_id_15
FROM
  order_item t0
  LEFT JOIN stock t1 ON t0.id = t1.id
WHERE
  t0.parent_order_id = ?

SELECT t0.id AS id_2, t0.created_at AS created_at_3, t0.description AS description_4, t0.quantity AS quantity_5, t0.price AS price_6, t0.reduction AS reduction_7, t0.product_id AS product_id_8, t0.parent_order_id AS parent_order_id_9, t0.pack_engagement_id AS pack_engagement_id_10, t0.shipment_item_id AS shipment_item_id_11, t0.dtype, t1.movement_type AS movement_type_12, t1.movement_objectif AS movement_objectif_13, t1.article_id AS article_id_14, t1.document_id AS document_id_15 FROM order_item t0 LEFT JOIN stock t1 ON t0.id = t1.id WHERE t0.parent_order_id = 5369;