Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name_compagny AS name_compagny_2,
  t0.birthday_compagny AS birthday_compagny_3,
  t0.adress_compagny AS adress_compagny_4,
  t0.postal_code_compagny AS postal_code_compagny_5,
  t0.city_compagny AS city_compagny_6,
  t0.country_compagny AS country_compagny_7,
  t0.description_compagny AS description_compagny_8,
  t0.identification_number_compagny AS identification_number_compagny_9,
  t0.first_price AS first_price_10,
  t0.rcs AS rcs_11,
  t0.pourcentage_fees AS pourcentage_fees_12,
  t0.legal_type AS legal_type_13,
  t0.amount_limit_min_deposit AS amount_limit_min_deposit_14,
  t0.pourcentage_deposit AS pourcentage_deposit_15,
  t0.accepted_deposit AS accepted_deposit_16,
  t0.user_id AS user_id_17,
  t0.domain_activity_id AS domain_activity_id_18,
  t0.picture_profil_compagny_id AS picture_profil_compagny_id_19,
  t0.job_id AS job_id_20,
  t0.department_compagny_id AS department_compagny_id_21
FROM
  compagny_info t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_compagny AS name_compagny_2, t0.birthday_compagny AS birthday_compagny_3, t0.adress_compagny AS adress_compagny_4, t0.postal_code_compagny AS postal_code_compagny_5, t0.city_compagny AS city_compagny_6, t0.country_compagny AS country_compagny_7, t0.description_compagny AS description_compagny_8, t0.identification_number_compagny AS identification_number_compagny_9, t0.first_price AS first_price_10, t0.rcs AS rcs_11, t0.pourcentage_fees AS pourcentage_fees_12, t0.legal_type AS legal_type_13, t0.amount_limit_min_deposit AS amount_limit_min_deposit_14, t0.pourcentage_deposit AS pourcentage_deposit_15, t0.accepted_deposit AS accepted_deposit_16, t0.user_id AS user_id_17, t0.domain_activity_id AS domain_activity_id_18, t0.picture_profil_compagny_id AS picture_profil_compagny_id_19, t0.job_id AS job_id_20, t0.department_compagny_id AS department_compagny_id_21 FROM compagny_info t0 WHERE t0.id = '2';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.price_ht AS price_ht_2,
  p0_.price_ttc AS price_ttc_3,
  p0_.description AS description_4,
  p0_.min_pers AS min_pers_5,
  p0_.max_pers AS max_pers_6,
  p0_.option_print_interval_person AS option_print_interval_person_7,
  p0_.ask_deposit AS ask_deposit_8,
  p0_.tax_id AS tax_id_9
FROM
  package_compagny p0_
  INNER JOIN package_compagny_compagny_info p2_ ON p0_.id = p2_.package_compagny_id
  INNER JOIN compagny_info c1_ ON c1_.id = p2_.compagny_info_id
WHERE
  c1_.id = ?
ORDER BY
  p0_.price_ttc DESC
LIMIT
  12

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_ht AS price_ht_2, p0_.price_ttc AS price_ttc_3, p0_.description AS description_4, p0_.min_pers AS min_pers_5, p0_.max_pers AS max_pers_6, p0_.option_print_interval_person AS option_print_interval_person_7, p0_.ask_deposit AS ask_deposit_8, p0_.tax_id AS tax_id_9 FROM package_compagny p0_ INNER JOIN package_compagny_compagny_info p2_ ON p0_.id = p2_.package_compagny_id INNER JOIN compagny_info c1_ ON c1_.id = p2_.compagny_info_id WHERE c1_.id = 2 ORDER BY p0_.price_ttc DESC LIMIT 12;

SELECT
  count(p0_.id) AS sclr_0
FROM
  package_compagny p0_
  INNER JOIN package_compagny_compagny_info p2_ ON p0_.id = p2_.package_compagny_id
  INNER JOIN compagny_info c1_ ON c1_.id = p2_.compagny_info_id
WHERE
  c1_.id = ?

SELECT count(p0_.id) AS sclr_0 FROM package_compagny p0_ INNER JOIN package_compagny_compagny_info p2_ ON p0_.id = p2_.package_compagny_id INNER JOIN compagny_info c1_ ON c1_.id = p2_.compagny_info_id WHERE c1_.id = 2;

SELECT
  MIN(p0_.price_ttc) AS sclr_0,
  MAX(p0_.price_ttc) AS sclr_1
FROM
  package_compagny p0_
  INNER JOIN package_compagny_compagny_info p2_ ON p0_.id = p2_.package_compagny_id
  INNER JOIN compagny_info c1_ ON c1_.id = p2_.compagny_info_id
WHERE
  c1_.id = ?

SELECT MIN(p0_.price_ttc) AS sclr_0, MAX(p0_.price_ttc) AS sclr_1 FROM package_compagny p0_ INNER JOIN package_compagny_compagny_info p2_ ON p0_.id = p2_.package_compagny_id INNER JOIN compagny_info c1_ ON c1_.id = p2_.compagny_info_id WHERE c1_.id = 2;

SELECT
  MIN(p0_.min_pers) AS sclr_0,
  MAX(p0_.max_pers) AS sclr_1
FROM
  package_compagny p0_
  INNER JOIN package_compagny_compagny_info p2_ ON p0_.id = p2_.package_compagny_id
  INNER JOIN compagny_info c1_ ON c1_.id = p2_.compagny_info_id
WHERE
  c1_.id = ?

SELECT MIN(p0_.min_pers) AS sclr_0, MAX(p0_.max_pers) AS sclr_1 FROM package_compagny p0_ INNER JOIN package_compagny_compagny_info p2_ ON p0_.id = p2_.package_compagny_id INNER JOIN compagny_info c1_ ON c1_.id = p2_.compagny_info_id WHERE c1_.id = 2;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.name AS name_6,
  t0.firstname AS firstname_7,
  t0.birthday AS birthday_8,
  t0.adress AS adress_9,
  t0.postal_code AS postal_code_10,
  t0.city AS city_11,
  t0.country AS country_12,
  t0.phone AS phone_13,
  t0.pseudonym AS pseudonym_14,
  t0.registration_date AS registration_date_15,
  t0.statut_id AS statut_id_16,
  t0.compagny_id AS compagny_id_17,
  t0.bank_id AS bank_id_18,
  t0.profil_picture_id AS profil_picture_id_19,
  t0.notation_id AS notation_id_20,
  t0.statistic_id AS statistic_id_21
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.roles AS roles_5, t0.name AS name_6, t0.firstname AS firstname_7, t0.birthday AS birthday_8, t0.adress AS adress_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.country AS country_12, t0.phone AS phone_13, t0.pseudonym AS pseudonym_14, t0.registration_date AS registration_date_15, t0.statut_id AS statut_id_16, t0.compagny_id AS compagny_id_17, t0.bank_id AS bank_id_18, t0.profil_picture_id AS profil_picture_id_19, t0.notation_id AS notation_id_20, t0.statistic_id AS statistic_id_21 FROM user t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.number_clic AS number_clic_2,
  t0.number_contact AS number_contact_3,
  t0.invoiced_monthly_turnover AS invoiced_monthly_turnover_4,
  t0.monthly_turnover_collected AS monthly_turnover_collected_5,
  t0.invoiced_quarterly_turnover AS invoiced_quarterly_turnover_6,
  t0.quarterly_turnover_collected AS quarterly_turnover_collected_7,
  t0.invoiced_half_yearly_turnover AS invoiced_half_yearly_turnover_8,
  t0.half_yearly_turnover_collected AS half_yearly_turnover_collected_9,
  t0.annual_turnover_invoiced AS annual_turnover_invoiced_10,
  t0.annual_turnover_collected AS annual_turnover_collected_11,
  t0.monthly_commission_due AS monthly_commission_due_12,
  t0.monthly_commission_paid AS monthly_commission_paid_13,
  t0.quarterly_commission_due AS quarterly_commission_due_14,
  t0.quarterly_commission_paid AS quarterly_commission_paid_15,
  t0.semi_annual_commission_due AS semi_annual_commission_due_16,
  t0.semi_annual_commission_paid AS semi_annual_commission_paid_17,
  t0.annual_commission_due AS annual_commission_due_18,
  t0.annual_commission_paid AS annual_commission_paid_19,
  t0.monthly_commission_collected AS monthly_commission_collected_20,
  t0.quarterly_commission_collected AS quarterly_commission_collected_21,
  t0.semi_annual_commission_collected AS semi_annual_commission_collected_22,
  t0.annual_commission_collected AS annual_commission_collected_23,
  t0.monthly_commission_mango_pay_due AS monthly_commission_mango_pay_due_24,
  t0.quarterly_commission_mango_pay_due AS quarterly_commission_mango_pay_due_25,
  t0.semi_annual_commission_mango_pay_due AS semi_annual_commission_mango_pay_due_26,
  t0.annual_commission_mango_pay_due AS annual_commission_mango_pay_due_27,
  t0.monthly_commission_mango_pay_paid AS monthly_commission_mango_pay_paid_28,
  t0.quarterly_commission_mango_pay_paid AS quarterly_commission_mango_pay_paid_29,
  t0.semi_annual_commission_mango_pay_paid AS semi_annual_commission_mango_pay_paid_30,
  t0.annual_commission_mango_pay_paid AS annual_commission_mango_pay_paid_31,
  t0.monthly_profit AS monthly_profit_32,
  t0.quarterly_profit AS quarterly_profit_33,
  t0.semi_annual_profit AS semi_annual_profit_34,
  t0.annual_profit AS annual_profit_35,
  t0.profit_since_foundation AS profit_since_foundation_36,
  t0.amount_paid AS amount_paid_37,
  t0.amount_not_paid AS amount_not_paid_38,
  t0.monthly_refund AS monthly_refund_39,
  t0.quarterly_refund AS quarterly_refund_40,
  t0.semi_annual_refund AS semi_annual_refund_41,
  t0.annual_refund AS annual_refund_42
FROM
  statistic t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number_clic AS number_clic_2, t0.number_contact AS number_contact_3, t0.invoiced_monthly_turnover AS invoiced_monthly_turnover_4, t0.monthly_turnover_collected AS monthly_turnover_collected_5, t0.invoiced_quarterly_turnover AS invoiced_quarterly_turnover_6, t0.quarterly_turnover_collected AS quarterly_turnover_collected_7, t0.invoiced_half_yearly_turnover AS invoiced_half_yearly_turnover_8, t0.half_yearly_turnover_collected AS half_yearly_turnover_collected_9, t0.annual_turnover_invoiced AS annual_turnover_invoiced_10, t0.annual_turnover_collected AS annual_turnover_collected_11, t0.monthly_commission_due AS monthly_commission_due_12, t0.monthly_commission_paid AS monthly_commission_paid_13, t0.quarterly_commission_due AS quarterly_commission_due_14, t0.quarterly_commission_paid AS quarterly_commission_paid_15, t0.semi_annual_commission_due AS semi_annual_commission_due_16, t0.semi_annual_commission_paid AS semi_annual_commission_paid_17, t0.annual_commission_due AS annual_commission_due_18, t0.annual_commission_paid AS annual_commission_paid_19, t0.monthly_commission_collected AS monthly_commission_collected_20, t0.quarterly_commission_collected AS quarterly_commission_collected_21, t0.semi_annual_commission_collected AS semi_annual_commission_collected_22, t0.annual_commission_collected AS annual_commission_collected_23, t0.monthly_commission_mango_pay_due AS monthly_commission_mango_pay_due_24, t0.quarterly_commission_mango_pay_due AS quarterly_commission_mango_pay_due_25, t0.semi_annual_commission_mango_pay_due AS semi_annual_commission_mango_pay_due_26, t0.annual_commission_mango_pay_due AS annual_commission_mango_pay_due_27, t0.monthly_commission_mango_pay_paid AS monthly_commission_mango_pay_paid_28, t0.quarterly_commission_mango_pay_paid AS quarterly_commission_mango_pay_paid_29, t0.semi_annual_commission_mango_pay_paid AS semi_annual_commission_mango_pay_paid_30, t0.annual_commission_mango_pay_paid AS annual_commission_mango_pay_paid_31, t0.monthly_profit AS monthly_profit_32, t0.quarterly_profit AS quarterly_profit_33, t0.semi_annual_profit AS semi_annual_profit_34, t0.annual_profit AS annual_profit_35, t0.profit_since_foundation AS profit_since_foundation_36, t0.amount_paid AS amount_paid_37, t0.amount_not_paid AS amount_not_paid_38, t0.monthly_refund AS monthly_refund_39, t0.quarterly_refund AS quarterly_refund_40, t0.semi_annual_refund AS semi_annual_refund_41, t0.annual_refund AS annual_refund_42 FROM statistic t0 WHERE t0.id = 3;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  statistic
SET
  number_clic = ?
WHERE
  id = ?

UPDATE statistic SET number_clic = 88 WHERE id = 3;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.gallery_title AS gallery_title_2,
  t0.date_creating AS date_creating_3,
  t0.gallery_description AS gallery_description_4,
  t0.select_header_slide AS select_header_slide_5,
  t0.user_property_id AS user_property_id_6
FROM
  gallery_photo t0
WHERE
  t0.user_property_id = ?

SELECT t0.id AS id_1, t0.gallery_title AS gallery_title_2, t0.date_creating AS date_creating_3, t0.gallery_description AS gallery_description_4, t0.select_header_slide AS select_header_slide_5, t0.user_property_id AS user_property_id_6 FROM gallery_photo t0 WHERE t0.user_property_id = 3;

SELECT
  t0.id AS id_1,
  t0.global_note AS global_note_2,
  t0.number_notation AS number_notation_3,
  t0.total_notation AS total_notation_4
FROM
  notation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.global_note AS global_note_2, t0.number_notation AS number_notation_3, t0.total_notation AS total_notation_4 FROM notation t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.picture_profile AS picture_profile_2
FROM
  profil_picture t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.picture_profile AS picture_profile_2 FROM profil_picture t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.picture_profile AS picture_profile_2
FROM
  profil_picture t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.picture_profile AS picture_profile_2 FROM profil_picture t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.gallery_title AS gallery_title_2,
  t0.date_creating AS date_creating_3,
  t0.gallery_description AS gallery_description_4,
  t0.user_property_id AS user_property_id_5
FROM
  gallery_video t0
WHERE
  t0.user_property_id = ?

SELECT t0.id AS id_1, t0.gallery_title AS gallery_title_2, t0.date_creating AS date_creating_3, t0.gallery_description AS gallery_description_4, t0.user_property_id AS user_property_id_5 FROM gallery_video t0 WHERE t0.user_property_id = 3;