Symfony Profiler

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.id AS id_12,
  t0.full_name AS full_name_13,
  t0.code_melli AS code_melli_14,
  t0.mobile AS mobile_15,
  t0.mail AS mail_16,
  t0.insert_date AS insert_date_17,
  t0.api_key AS api_key_18,
  t0.pic_ext AS pic_ext_19,
  t0.updated_at AS updated_at_20,
  t0.medical_council_code AS medical_council_code_21,
  t0.drugstore_code AS drugstore_code_22,
  t0.drugstore_originator AS drugstore_originator_23,
  t0.drugstore_license AS drugstore_license_24,
  t0.drugstore_license_pic_ext AS drugstore_license_pic_ext_25,
  t0.drugstore_hix AS drugstore_hix_26,
  t0.drugstore_gln AS drugstore_gln_27,
  t0.birth_date AS birth_date_28,
  t0.status AS status_29,
  t0.is_male AS is_male_30,
  t0.is_information_complete AS is_information_complete_31,
  t0.description AS description_32,
  t0.operator_job_title AS operator_job_title_33,
  t0.auth_code AS auth_code_34,
  t0.trusted_version AS trusted_version_35,
  t0.balance AS balance_36,
  t0.operator_all_categories AS operator_all_categories_37,
  t0.operator_all_license_owners AS operator_all_license_owners_38,
  t0.cart_count AS cart_count_39,
  t0.city_id AS city_id_40,
  t0.type_id AS type_id_41
FROM
  user t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.code_melli AS code_melli_14, t0.mobile AS mobile_15, t0.mail AS mail_16, t0.insert_date AS insert_date_17, t0.api_key AS api_key_18, t0.pic_ext AS pic_ext_19, t0.updated_at AS updated_at_20, t0.medical_council_code AS medical_council_code_21, t0.drugstore_code AS drugstore_code_22, t0.drugstore_originator AS drugstore_originator_23, t0.drugstore_license AS drugstore_license_24, t0.drugstore_license_pic_ext AS drugstore_license_pic_ext_25, t0.drugstore_hix AS drugstore_hix_26, t0.drugstore_gln AS drugstore_gln_27, t0.birth_date AS birth_date_28, t0.status AS status_29, t0.is_male AS is_male_30, t0.is_information_complete AS is_information_complete_31, t0.description AS description_32, t0.operator_job_title AS operator_job_title_33, t0.auth_code AS auth_code_34, t0.trusted_version AS trusted_version_35, t0.balance AS balance_36, t0.operator_all_categories AS operator_all_categories_37, t0.operator_all_license_owners AS operator_all_license_owners_38, t0.cart_count AS cart_count_39, t0.city_id AS city_id_40, t0.type_id AS type_id_41 FROM user t0 WHERE t0.id = 16 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.type AS type_1,
  c0_.status AS status_2,
  c0_.send_type AS send_type_3,
  c0_.date_insert AS date_insert_4,
  c0_.date_drugstore_verify AS date_drugstore_verify_5,
  c0_.date_payment AS date_payment_6,
  c0_.date_delivery AS date_delivery_7,
  c0_.date_checkout AS date_checkout_8,
  c0_.sum_price AS sum_price_9,
  c0_.tariff_price AS tariff_price_10,
  c0_.courier_price AS courier_price_11,
  c0_.final_price AS final_price_12,
  c0_.description AS description_13,
  c0_.user_description AS user_description_14,
  c0_.address_text AS address_text_15,
  ST_AsBinary(c0_.address_position) AS address_position_16,
  c0_.address_phone AS address_phone_17,
  u1_.username AS username_18,
  u1_.username_canonical AS username_canonical_19,
  u1_.email AS email_20,
  u1_.email_canonical AS email_canonical_21,
  u1_.enabled AS enabled_22,
  u1_.salt AS salt_23,
  u1_.password AS password_24,
  u1_.last_login AS last_login_25,
  u1_.confirmation_token AS confirmation_token_26,
  u1_.password_requested_at AS password_requested_at_27,
  u1_.roles AS roles_28,
  u1_.id AS id_29,
  u1_.full_name AS full_name_30,
  u1_.code_melli AS code_melli_31,
  u1_.mobile AS mobile_32,
  u1_.mail AS mail_33,
  u1_.insert_date AS insert_date_34,
  u1_.api_key AS api_key_35,
  u1_.pic_ext AS pic_ext_36,
  u1_.updated_at AS updated_at_37,
  u1_.medical_council_code AS medical_council_code_38,
  u1_.drugstore_code AS drugstore_code_39,
  u1_.drugstore_originator AS drugstore_originator_40,
  u1_.drugstore_license AS drugstore_license_41,
  u1_.drugstore_license_pic_ext AS drugstore_license_pic_ext_42,
  u1_.drugstore_hix AS drugstore_hix_43,
  u1_.drugstore_gln AS drugstore_gln_44,
  u1_.birth_date AS birth_date_45,
  u1_.status AS status_46,
  u1_.is_male AS is_male_47,
  u1_.is_information_complete AS is_information_complete_48,
  u1_.description AS description_49,
  u1_.operator_job_title AS operator_job_title_50,
  u1_.auth_code AS auth_code_51,
  u1_.trusted_version AS trusted_version_52,
  u1_.balance AS balance_53,
  u1_.operator_all_categories AS operator_all_categories_54,
  u1_.operator_all_license_owners AS operator_all_license_owners_55,
  u1_.cart_count AS cart_count_56,
  c0_.address_city_id AS address_city_id_57,
  c0_.patient_id AS patient_id_58,
  c0_.drugstore_id AS drugstore_id_59,
  c0_.address_id AS address_id_60,
  c0_.deliver_type_id AS deliver_type_id_61,
  u1_.city_id AS city_id_62,
  u1_.type_id AS type_id_63
FROM
  cart c0_
  INNER JOIN user u1_ ON c0_.drugstore_id = u1_.id
WHERE
  c0_.id = ?
  AND c0_.patient_id = ?
  AND c0_.status = ?

SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.status AS status_2, c0_.send_type AS send_type_3, c0_.date_insert AS date_insert_4, c0_.date_drugstore_verify AS date_drugstore_verify_5, c0_.date_payment AS date_payment_6, c0_.date_delivery AS date_delivery_7, c0_.date_checkout AS date_checkout_8, c0_.sum_price AS sum_price_9, c0_.tariff_price AS tariff_price_10, c0_.courier_price AS courier_price_11, c0_.final_price AS final_price_12, c0_.description AS description_13, c0_.user_description AS user_description_14, c0_.address_text AS address_text_15, ST_AsBinary(c0_.address_position) AS address_position_16, c0_.address_phone AS address_phone_17, u1_.username AS username_18, u1_.username_canonical AS username_canonical_19, u1_.email AS email_20, u1_.email_canonical AS email_canonical_21, u1_.enabled AS enabled_22, u1_.salt AS salt_23, u1_.password AS password_24, u1_.last_login AS last_login_25, u1_.confirmation_token AS confirmation_token_26, u1_.password_requested_at AS password_requested_at_27, u1_.roles AS roles_28, u1_.id AS id_29, u1_.full_name AS full_name_30, u1_.code_melli AS code_melli_31, u1_.mobile AS mobile_32, u1_.mail AS mail_33, u1_.insert_date AS insert_date_34, u1_.api_key AS api_key_35, u1_.pic_ext AS pic_ext_36, u1_.updated_at AS updated_at_37, u1_.medical_council_code AS medical_council_code_38, u1_.drugstore_code AS drugstore_code_39, u1_.drugstore_originator AS drugstore_originator_40, u1_.drugstore_license AS drugstore_license_41, u1_.drugstore_license_pic_ext AS drugstore_license_pic_ext_42, u1_.drugstore_hix AS drugstore_hix_43, u1_.drugstore_gln AS drugstore_gln_44, u1_.birth_date AS birth_date_45, u1_.status AS status_46, u1_.is_male AS is_male_47, u1_.is_information_complete AS is_information_complete_48, u1_.description AS description_49, u1_.operator_job_title AS operator_job_title_50, u1_.auth_code AS auth_code_51, u1_.trusted_version AS trusted_version_52, u1_.balance AS balance_53, u1_.operator_all_categories AS operator_all_categories_54, u1_.operator_all_license_owners AS operator_all_license_owners_55, u1_.cart_count AS cart_count_56, c0_.address_city_id AS address_city_id_57, c0_.patient_id AS patient_id_58, c0_.drugstore_id AS drugstore_id_59, c0_.address_id AS address_id_60, c0_.deliver_type_id AS deliver_type_id_61, u1_.city_id AS city_id_62, u1_.type_id AS type_id_63 FROM cart c0_ INNER JOIN user u1_ ON c0_.drugstore_id = u1_.id WHERE c0_.id = 1838 AND c0_.patient_id = 16 AND c0_.status = 0;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.`count` AS count_3,
  t0.sum_price AS sum_price_4,
  t0.description AS description_5,
  t0.respite AS respite_6,
  t0.award AS award_7,
  t0.date_expire AS date_expire_8,
  t0.cart_id AS cart_id_9,
  t0.item_id AS item_id_10
FROM
  cart_item t0
WHERE
  t0.cart_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.`count` AS count_3, t0.sum_price AS sum_price_4, t0.description AS description_5, t0.respite AS respite_6, t0.award AS award_7, t0.date_expire AS date_expire_8, t0.cart_id AS cart_id_9, t0.item_id AS item_id_10 FROM cart_item t0 WHERE t0.cart_id = 1838;

SELECT
  t0.id AS id_1,
  t0.name_en AS name_en_2,
  t0.name_fa AS name_fa_3,
  t0.brand_en AS brand_en_4,
  t0.brand_fa AS brand_fa_5,
  t0.name_brand_en AS name_brand_en_6,
  t0.name_brand_fa AS name_brand_fa_7,
  t0.erx_code AS erx_code_8,
  t0.erx_code_base AS erx_code_base_9,
  t0.rx_behdasht AS rx_behdasht_10,
  t0.generic_code AS generic_code_11,
  t0.mother_code AS mother_code_12,
  t0.licence_owner AS licence_owner_13,
  t0.brand_owner AS brand_owner_14,
  t0.brand_owner_country AS brand_owner_country_15,
  t0.producer AS producer_16,
  t0.producer_country AS producer_country_17,
  t0.name_interactive AS name_interactive_18,
  t0.packing AS packing_19,
  t0.form AS form_20,
  t0.pregnancy_category AS pregnancy_category_21,
  t0.other AS other_22,
  t0.features AS features_23,
  t0.video_id AS video_id_24,
  t0.last_price AS last_price_25,
  t0.only_doctor_user AS only_doctor_user_26,
  t0.status AS status_27,
  t0.license_owner_id AS license_owner_id_28
FROM
  item t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_en AS name_en_2, t0.name_fa AS name_fa_3, t0.brand_en AS brand_en_4, t0.brand_fa AS brand_fa_5, t0.name_brand_en AS name_brand_en_6, t0.name_brand_fa AS name_brand_fa_7, t0.erx_code AS erx_code_8, t0.erx_code_base AS erx_code_base_9, t0.rx_behdasht AS rx_behdasht_10, t0.generic_code AS generic_code_11, t0.mother_code AS mother_code_12, t0.licence_owner AS licence_owner_13, t0.brand_owner AS brand_owner_14, t0.brand_owner_country AS brand_owner_country_15, t0.producer AS producer_16, t0.producer_country AS producer_country_17, t0.name_interactive AS name_interactive_18, t0.packing AS packing_19, t0.form AS form_20, t0.pregnancy_category AS pregnancy_category_21, t0.other AS other_22, t0.features AS features_23, t0.video_id AS video_id_24, t0.last_price AS last_price_25, t0.only_doctor_user AS only_doctor_user_26, t0.status AS status_27, t0.license_owner_id AS license_owner_id_28 FROM item t0 WHERE t0.id = 321083;

SELECT
  t0.id AS id_1,
  t0.sale_code AS sale_code_2,
  t0.exist AS exist_3,
  t0.last_percent_price AS last_percent_price_4,
  t0.last_custom_price AS last_custom_price_5,
  t0.broadcast_code AS broadcast_code_6,
  t0.broadcast_name AS broadcast_name_7,
  t0.respite AS respite_8,
  t0.award AS award_9,
  t0.date_expire AS date_expire_10,
  t0.date_update AS date_update_11,
  t0.inventory AS inventory_12,
  t0.item_id AS item_id_13,
  t0.drugstore_id AS drugstore_id_14
FROM
  item_drugstore t0
WHERE
  t0.item_id = ?
  AND t0.drugstore_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.sale_code AS sale_code_2, t0.exist AS exist_3, t0.last_percent_price AS last_percent_price_4, t0.last_custom_price AS last_custom_price_5, t0.broadcast_code AS broadcast_code_6, t0.broadcast_name AS broadcast_name_7, t0.respite AS respite_8, t0.award AS award_9, t0.date_expire AS date_expire_10, t0.date_update AS date_update_11, t0.inventory AS inventory_12, t0.item_id AS item_id_13, t0.drugstore_id AS drugstore_id_14 FROM item_drugstore t0 WHERE t0.item_id = 321083 AND t0.drugstore_id = 2 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  cart
SET
  sum_price = ?,
  courier_price = ?,
  final_price = ?
WHERE
  id = ?

UPDATE cart SET sum_price = '327000', courier_price = '0', final_price = '327000' WHERE id = 1838;

UPDATE
  cart_item
SET
  price = ?,
  `count` = ?,
  sum_price = ?
WHERE
  id = ?

UPDATE cart_item SET price = '65400', `count` = 150, sum_price = '327000' WHERE id = 1931;

"COMMIT"

"COMMIT";

SELECT
  c0_.id AS id_0,
  c0_.type AS type_1,
  c0_.status AS status_2,
  c0_.send_type AS send_type_3,
  c0_.date_insert AS date_insert_4,
  c0_.date_drugstore_verify AS date_drugstore_verify_5,
  c0_.date_payment AS date_payment_6,
  c0_.date_delivery AS date_delivery_7,
  c0_.date_checkout AS date_checkout_8,
  c0_.sum_price AS sum_price_9,
  c0_.tariff_price AS tariff_price_10,
  c0_.courier_price AS courier_price_11,
  c0_.final_price AS final_price_12,
  c0_.description AS description_13,
  c0_.user_description AS user_description_14,
  c0_.address_text AS address_text_15,
  ST_AsBinary(c0_.address_position) AS address_position_16,
  c0_.address_phone AS address_phone_17,
  u1_.username AS username_18,
  u1_.username_canonical AS username_canonical_19,
  u1_.email AS email_20,
  u1_.email_canonical AS email_canonical_21,
  u1_.enabled AS enabled_22,
  u1_.salt AS salt_23,
  u1_.password AS password_24,
  u1_.last_login AS last_login_25,
  u1_.confirmation_token AS confirmation_token_26,
  u1_.password_requested_at AS password_requested_at_27,
  u1_.roles AS roles_28,
  u1_.id AS id_29,
  u1_.full_name AS full_name_30,
  u1_.code_melli AS code_melli_31,
  u1_.mobile AS mobile_32,
  u1_.mail AS mail_33,
  u1_.insert_date AS insert_date_34,
  u1_.api_key AS api_key_35,
  u1_.pic_ext AS pic_ext_36,
  u1_.updated_at AS updated_at_37,
  u1_.medical_council_code AS medical_council_code_38,
  u1_.drugstore_code AS drugstore_code_39,
  u1_.drugstore_originator AS drugstore_originator_40,
  u1_.drugstore_license AS drugstore_license_41,
  u1_.drugstore_license_pic_ext AS drugstore_license_pic_ext_42,
  u1_.drugstore_hix AS drugstore_hix_43,
  u1_.drugstore_gln AS drugstore_gln_44,
  u1_.birth_date AS birth_date_45,
  u1_.status AS status_46,
  u1_.is_male AS is_male_47,
  u1_.is_information_complete AS is_information_complete_48,
  u1_.description AS description_49,
  u1_.operator_job_title AS operator_job_title_50,
  u1_.auth_code AS auth_code_51,
  u1_.trusted_version AS trusted_version_52,
  u1_.balance AS balance_53,
  u1_.operator_all_categories AS operator_all_categories_54,
  u1_.operator_all_license_owners AS operator_all_license_owners_55,
  u1_.cart_count AS cart_count_56,
  c0_.address_city_id AS address_city_id_57,
  c0_.patient_id AS patient_id_58,
  c0_.drugstore_id AS drugstore_id_59,
  c0_.address_id AS address_id_60,
  c0_.deliver_type_id AS deliver_type_id_61,
  u1_.city_id AS city_id_62,
  u1_.type_id AS type_id_63
FROM
  cart c0_
  INNER JOIN user u1_ ON c0_.drugstore_id = u1_.id
WHERE
  c0_.patient_id = ?
  AND c0_.status = ?

SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.status AS status_2, c0_.send_type AS send_type_3, c0_.date_insert AS date_insert_4, c0_.date_drugstore_verify AS date_drugstore_verify_5, c0_.date_payment AS date_payment_6, c0_.date_delivery AS date_delivery_7, c0_.date_checkout AS date_checkout_8, c0_.sum_price AS sum_price_9, c0_.tariff_price AS tariff_price_10, c0_.courier_price AS courier_price_11, c0_.final_price AS final_price_12, c0_.description AS description_13, c0_.user_description AS user_description_14, c0_.address_text AS address_text_15, ST_AsBinary(c0_.address_position) AS address_position_16, c0_.address_phone AS address_phone_17, u1_.username AS username_18, u1_.username_canonical AS username_canonical_19, u1_.email AS email_20, u1_.email_canonical AS email_canonical_21, u1_.enabled AS enabled_22, u1_.salt AS salt_23, u1_.password AS password_24, u1_.last_login AS last_login_25, u1_.confirmation_token AS confirmation_token_26, u1_.password_requested_at AS password_requested_at_27, u1_.roles AS roles_28, u1_.id AS id_29, u1_.full_name AS full_name_30, u1_.code_melli AS code_melli_31, u1_.mobile AS mobile_32, u1_.mail AS mail_33, u1_.insert_date AS insert_date_34, u1_.api_key AS api_key_35, u1_.pic_ext AS pic_ext_36, u1_.updated_at AS updated_at_37, u1_.medical_council_code AS medical_council_code_38, u1_.drugstore_code AS drugstore_code_39, u1_.drugstore_originator AS drugstore_originator_40, u1_.drugstore_license AS drugstore_license_41, u1_.drugstore_license_pic_ext AS drugstore_license_pic_ext_42, u1_.drugstore_hix AS drugstore_hix_43, u1_.drugstore_gln AS drugstore_gln_44, u1_.birth_date AS birth_date_45, u1_.status AS status_46, u1_.is_male AS is_male_47, u1_.is_information_complete AS is_information_complete_48, u1_.description AS description_49, u1_.operator_job_title AS operator_job_title_50, u1_.auth_code AS auth_code_51, u1_.trusted_version AS trusted_version_52, u1_.balance AS balance_53, u1_.operator_all_categories AS operator_all_categories_54, u1_.operator_all_license_owners AS operator_all_license_owners_55, u1_.cart_count AS cart_count_56, c0_.address_city_id AS address_city_id_57, c0_.patient_id AS patient_id_58, c0_.drugstore_id AS drugstore_id_59, c0_.address_id AS address_id_60, c0_.deliver_type_id AS deliver_type_id_61, u1_.city_id AS city_id_62, u1_.type_id AS type_id_63 FROM cart c0_ INNER JOIN user u1_ ON c0_.drugstore_id = u1_.id WHERE c0_.patient_id = 16 AND c0_.status = 0;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.`count` AS count_3,
  t0.sum_price AS sum_price_4,
  t0.description AS description_5,
  t0.respite AS respite_6,
  t0.award AS award_7,
  t0.date_expire AS date_expire_8,
  t0.cart_id AS cart_id_9,
  t0.item_id AS item_id_10
FROM
  cart_item t0
WHERE
  t0.cart_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.`count` AS count_3, t0.sum_price AS sum_price_4, t0.description AS description_5, t0.respite AS respite_6, t0.award AS award_7, t0.date_expire AS date_expire_8, t0.cart_id AS cart_id_9, t0.item_id AS item_id_10 FROM cart_item t0 WHERE t0.cart_id = 1822;

SELECT
  t0.id AS id_1,
  t0.name_en AS name_en_2,
  t0.name_fa AS name_fa_3,
  t0.brand_en AS brand_en_4,
  t0.brand_fa AS brand_fa_5,
  t0.name_brand_en AS name_brand_en_6,
  t0.name_brand_fa AS name_brand_fa_7,
  t0.erx_code AS erx_code_8,
  t0.erx_code_base AS erx_code_base_9,
  t0.rx_behdasht AS rx_behdasht_10,
  t0.generic_code AS generic_code_11,
  t0.mother_code AS mother_code_12,
  t0.licence_owner AS licence_owner_13,
  t0.brand_owner AS brand_owner_14,
  t0.brand_owner_country AS brand_owner_country_15,
  t0.producer AS producer_16,
  t0.producer_country AS producer_country_17,
  t0.name_interactive AS name_interactive_18,
  t0.packing AS packing_19,
  t0.form AS form_20,
  t0.pregnancy_category AS pregnancy_category_21,
  t0.other AS other_22,
  t0.features AS features_23,
  t0.video_id AS video_id_24,
  t0.last_price AS last_price_25,
  t0.only_doctor_user AS only_doctor_user_26,
  t0.status AS status_27,
  t0.license_owner_id AS license_owner_id_28
FROM
  item t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_en AS name_en_2, t0.name_fa AS name_fa_3, t0.brand_en AS brand_en_4, t0.brand_fa AS brand_fa_5, t0.name_brand_en AS name_brand_en_6, t0.name_brand_fa AS name_brand_fa_7, t0.erx_code AS erx_code_8, t0.erx_code_base AS erx_code_base_9, t0.rx_behdasht AS rx_behdasht_10, t0.generic_code AS generic_code_11, t0.mother_code AS mother_code_12, t0.licence_owner AS licence_owner_13, t0.brand_owner AS brand_owner_14, t0.brand_owner_country AS brand_owner_country_15, t0.producer AS producer_16, t0.producer_country AS producer_country_17, t0.name_interactive AS name_interactive_18, t0.packing AS packing_19, t0.form AS form_20, t0.pregnancy_category AS pregnancy_category_21, t0.other AS other_22, t0.features AS features_23, t0.video_id AS video_id_24, t0.last_price AS last_price_25, t0.only_doctor_user AS only_doctor_user_26, t0.status AS status_27, t0.license_owner_id AS license_owner_id_28 FROM item t0 WHERE t0.id = 73051;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  user
SET
  cart_count = ?
WHERE
  id = ?

UPDATE user SET cart_count = 6 WHERE id = 16;

"COMMIT"

"COMMIT";