Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.year AS year_2,
  c0_.description AS description_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  c0_.km AS km_6,
  c0_.patent AS patent_7,
  c0_.price_purchase AS price_purchase_8,
  c0_.price_sale AS price_sale_9,
  c0_.price_currency_purchase AS price_currency_purchase_10,
  c0_.price_currency_sale AS price_currency_sale_11,
  c0_.features AS features_12,
  c0_.status AS status_13,
  c0_.engine_number AS engine_number_14,
  c0_.chassis_number AS chassis_number_15,
  c0_.type AS type_16,
  c0_.settlement AS settlement_17,
  c0_.position AS position_18,
  c0_.features_infoauto AS features_infoauto_19,
  c0_.color AS color_20,
  c0_.is_opportunity AS is_opportunity_21,
  c0_.is_0km AS is_0km_22,
  c0_.is_immediate_delivery AS is_immediate_delivery_23,
  c0_.is_consignacion AS is_consignacion_24,
  c0_.is_active AS is_active_25,
  c0_.updated_by_id AS updated_by_id_26,
  c0_.brand_id AS brand_id_27,
  c0_.branches_id AS branches_id_28,
  c0_.destination_id AS destination_id_29
FROM
  car c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.year AS year_2, c0_.description AS description_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.km AS km_6, c0_.patent AS patent_7, c0_.price_purchase AS price_purchase_8, c0_.price_sale AS price_sale_9, c0_.price_currency_purchase AS price_currency_purchase_10, c0_.price_currency_sale AS price_currency_sale_11, c0_.features AS features_12, c0_.status AS status_13, c0_.engine_number AS engine_number_14, c0_.chassis_number AS chassis_number_15, c0_.type AS type_16, c0_.settlement AS settlement_17, c0_.position AS position_18, c0_.features_infoauto AS features_infoauto_19, c0_.color AS color_20, c0_.is_opportunity AS is_opportunity_21, c0_.is_0km AS is_0km_22, c0_.is_immediate_delivery AS is_immediate_delivery_23, c0_.is_consignacion AS is_consignacion_24, c0_.is_active AS is_active_25, c0_.updated_by_id AS updated_by_id_26, c0_.brand_id AS brand_id_27, c0_.branches_id AS branches_id_28, c0_.destination_id AS destination_id_29 FROM car c0_;

SELECT
  c0_.id AS id_0,
  c0_.first_name AS first_name_1,
  c0_.last_name AS last_name_2,
  c0_.condicion_fiscal AS condicion_fiscal_3,
  c0_.dni AS dni_4,
  c0_.telephone AS telephone_5,
  c0_.cellphone AS cellphone_6,
  c0_.address AS address_7,
  c0_.address_number AS address_number_8,
  c0_.address_floor AS address_floor_9,
  c0_.address_apartment AS address_apartment_10,
  c0_.location AS location_11,
  c0_.state AS state_12,
  c0_.origin AS origin_13,
  c0_.description AS description_14,
  c0_.notify_by_email AS notify_by_email_15,
  c0_.notify_by_whatsapp AS notify_by_whatsapp_16,
  c0_.notify_vehicle_entry AS notify_vehicle_entry_17,
  c0_.notify_criteria AS notify_criteria_18,
  c0_.created_at AS created_at_19,
  c0_.updated_at AS updated_at_20,
  c0_.email AS email_21,
  c0_.licence_venc AS licence_venc_22,
  c0_.user_id AS user_id_23
FROM
  client c0_
  LEFT JOIN user u1_ ON c0_.user_id = u1_.id
WHERE
  u1_.profile_id = 2
ORDER BY
  c0_.first_name ASC

SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.condicion_fiscal AS condicion_fiscal_3, c0_.dni AS dni_4, c0_.telephone AS telephone_5, c0_.cellphone AS cellphone_6, c0_.address AS address_7, c0_.address_number AS address_number_8, c0_.address_floor AS address_floor_9, c0_.address_apartment AS address_apartment_10, c0_.location AS location_11, c0_.state AS state_12, c0_.origin AS origin_13, c0_.description AS description_14, c0_.notify_by_email AS notify_by_email_15, c0_.notify_by_whatsapp AS notify_by_whatsapp_16, c0_.notify_vehicle_entry AS notify_vehicle_entry_17, c0_.notify_criteria AS notify_criteria_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.email AS email_21, c0_.licence_venc AS licence_venc_22, c0_.user_id AS user_id_23 FROM client c0_ LEFT JOIN user u1_ ON c0_.user_id = u1_.id WHERE u1_.profile_id = 2 ORDER BY c0_.first_name ASC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  client c0_

SELECT count(c0_.id) AS sclr_0 FROM client c0_;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.year AS year_2,
  c0_.description AS description_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  c0_.km AS km_6,
  c0_.patent AS patent_7,
  c0_.price_purchase AS price_purchase_8,
  c0_.price_sale AS price_sale_9,
  c0_.price_currency_purchase AS price_currency_purchase_10,
  c0_.price_currency_sale AS price_currency_sale_11,
  c0_.features AS features_12,
  c0_.status AS status_13,
  c0_.engine_number AS engine_number_14,
  c0_.chassis_number AS chassis_number_15,
  c0_.type AS type_16,
  c0_.settlement AS settlement_17,
  c0_.position AS position_18,
  c0_.features_infoauto AS features_infoauto_19,
  c0_.color AS color_20,
  c0_.is_opportunity AS is_opportunity_21,
  c0_.is_0km AS is_0km_22,
  c0_.is_immediate_delivery AS is_immediate_delivery_23,
  c0_.is_consignacion AS is_consignacion_24,
  c0_.is_active AS is_active_25,
  c0_.updated_by_id AS updated_by_id_26,
  c0_.brand_id AS brand_id_27,
  c0_.branches_id AS branches_id_28,
  c0_.destination_id AS destination_id_29
FROM
  car c0_
WHERE
  c0_.status <> 'sold'
  AND c0_.status <> 'to swap'
  AND c0_.status <> 'swapped'
  AND c0_.price_sale <> 'NULL'
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.year AS year_2, c0_.description AS description_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.km AS km_6, c0_.patent AS patent_7, c0_.price_purchase AS price_purchase_8, c0_.price_sale AS price_sale_9, c0_.price_currency_purchase AS price_currency_purchase_10, c0_.price_currency_sale AS price_currency_sale_11, c0_.features AS features_12, c0_.status AS status_13, c0_.engine_number AS engine_number_14, c0_.chassis_number AS chassis_number_15, c0_.type AS type_16, c0_.settlement AS settlement_17, c0_.position AS position_18, c0_.features_infoauto AS features_infoauto_19, c0_.color AS color_20, c0_.is_opportunity AS is_opportunity_21, c0_.is_0km AS is_0km_22, c0_.is_immediate_delivery AS is_immediate_delivery_23, c0_.is_consignacion AS is_consignacion_24, c0_.is_active AS is_active_25, c0_.updated_by_id AS updated_by_id_26, c0_.brand_id AS brand_id_27, c0_.branches_id AS branches_id_28, c0_.destination_id AS destination_id_29 FROM car c0_ WHERE c0_.status <> 'sold' AND c0_.status <> 'to swap' AND c0_.status <> 'swapped' AND c0_.price_sale <> 'NULL' ORDER BY c0_.name ASC;

SELECT
  u0_.id AS id_0,
  u0_.first_name AS first_name_1,
  u0_.last_name AS last_name_2,
  u0_.email AS email_3,
  u0_.roles AS roles_4,
  u0_.password AS password_5,
  u0_.image AS image_6,
  u0_.created_at AS created_at_7,
  u0_.updated_at AS updated_at_8,
  u0_.agency_days_notification AS agency_days_notification_9,
  u0_.allow_user AS allow_user_10,
  u0_.allow_clients AS allow_clients_11,
  u0_.allow_vehicles AS allow_vehicles_12,
  u0_.allow_vehicles_buys AS allow_vehicles_buys_13,
  u0_.allow_vehicles_sales AS allow_vehicles_sales_14,
  u0_.allow_vehicles_resales AS allow_vehicles_resales_15,
  u0_.allow_agency AS allow_agency_16,
  u0_.allow_administration AS allow_administration_17,
  u0_.allow_transfers AS allow_transfers_18,
  u0_.allow_system AS allow_system_19,
  u0_.cellphone AS cellphone_20,
  u0_.profile_id AS profile_id_21
FROM
  user u0_
ORDER BY
  u0_.first_name ASC

SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.email AS email_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.image AS image_6, u0_.created_at AS created_at_7, u0_.updated_at AS updated_at_8, u0_.agency_days_notification AS agency_days_notification_9, u0_.allow_user AS allow_user_10, u0_.allow_clients AS allow_clients_11, u0_.allow_vehicles AS allow_vehicles_12, u0_.allow_vehicles_buys AS allow_vehicles_buys_13, u0_.allow_vehicles_sales AS allow_vehicles_sales_14, u0_.allow_vehicles_resales AS allow_vehicles_resales_15, u0_.allow_agency AS allow_agency_16, u0_.allow_administration AS allow_administration_17, u0_.allow_transfers AS allow_transfers_18, u0_.allow_system AS allow_system_19, u0_.cellphone AS cellphone_20, u0_.profile_id AS profile_id_21 FROM user u0_ ORDER BY u0_.first_name ASC;

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.roles AS roles_5,
  t0.password AS password_6,
  t0.image AS image_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.agency_days_notification AS agency_days_notification_10,
  t0.allow_user AS allow_user_11,
  t0.allow_clients AS allow_clients_12,
  t0.allow_vehicles AS allow_vehicles_13,
  t0.allow_vehicles_buys AS allow_vehicles_buys_14,
  t0.allow_vehicles_sales AS allow_vehicles_sales_15,
  t0.allow_vehicles_resales AS allow_vehicles_resales_16,
  t0.allow_agency AS allow_agency_17,
  t0.allow_administration AS allow_administration_18,
  t0.allow_transfers AS allow_transfers_19,
  t0.allow_system AS allow_system_20,
  t0.cellphone AS cellphone_21,
  t0.profile_id AS profile_id_22
FROM
  user t0
WHERE
  t0.id = ?

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.roles AS roles_5, t0.password AS password_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.agency_days_notification AS agency_days_notification_10, t0.allow_user AS allow_user_11, t0.allow_clients AS allow_clients_12, t0.allow_vehicles AS allow_vehicles_13, t0.allow_vehicles_buys AS allow_vehicles_buys_14, t0.allow_vehicles_sales AS allow_vehicles_sales_15, t0.allow_vehicles_resales AS allow_vehicles_resales_16, t0.allow_agency AS allow_agency_17, t0.allow_administration AS allow_administration_18, t0.allow_transfers AS allow_transfers_19, t0.allow_system AS allow_system_20, t0.cellphone AS cellphone_21, t0.profile_id AS profile_id_22 FROM user t0 WHERE t0.id = 11;

SELECT
  count(u0_.id) AS sclr_0
FROM
  user u0_

SELECT count(u0_.id) AS sclr_0 FROM user u0_;

SELECT
  count(c0_.id) AS sclr_0
FROM
  car c0_
WHERE
  c0_.status NOT IN ('sold', 'swapped')

SELECT count(c0_.id) AS sclr_0 FROM car c0_ WHERE c0_.status NOT IN ('sold', 'swapped');

SELECT
  count(b0_.id) AS sclr_0
FROM
  brand b0_

SELECT count(b0_.id) AS sclr_0 FROM brand b0_;