Symfony Profiler

SELECT
  d0_.id AS id_0,
  d0_.request_id AS request_id_1,
  d0_.quote_id AS quote_id_2,
  d0_.invoice_id AS invoice_id_3,
  d0_.client_id AS client_id_4,
  d0_.operator_id AS operator_id_5,
  d0_.broker_id AS broker_id_6,
  d0_.routing AS routing_7,
  d0_.departure_date AS departure_date_8,
  d0_.sale_amount AS sale_amount_9,
  d0_.cost_amount AS cost_amount_10,
  d0_.client_paid AS client_paid_11,
  d0_.client_due AS client_due_12,
  d0_.operator_paid AS operator_paid_13,
  d0_.operator_due AS operator_due_14,
  d0_.fdr_sent AS fdr_sent_15,
  d0_.status AS status_16,
  d0_.direct_entry AS direct_entry_17,
  d0_.notes AS notes_18,
  d0_.created_at AS created_at_19,
  d0_.updated_at AS updated_at_20
FROM
  deals d0_
ORDER BY
  d0_.departure_date ASC
LIMIT
  200

SELECT d0_.id AS id_0, d0_.request_id AS request_id_1, d0_.quote_id AS quote_id_2, d0_.invoice_id AS invoice_id_3, d0_.client_id AS client_id_4, d0_.operator_id AS operator_id_5, d0_.broker_id AS broker_id_6, d0_.routing AS routing_7, d0_.departure_date AS departure_date_8, d0_.sale_amount AS sale_amount_9, d0_.cost_amount AS cost_amount_10, d0_.client_paid AS client_paid_11, d0_.client_due AS client_due_12, d0_.operator_paid AS operator_paid_13, d0_.operator_due AS operator_due_14, d0_.fdr_sent AS fdr_sent_15, d0_.status AS status_16, d0_.direct_entry AS direct_entry_17, d0_.notes AS notes_18, d0_.created_at AS created_at_19, d0_.updated_at AS updated_at_20 FROM deals d0_ ORDER BY d0_.departure_date ASC LIMIT 200;

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.title AS title_6,
  t0.role AS role_7,
  t0.language AS language_8,
  t0.password_hash AS password_hash_9,
  t0.signature_html AS signature_html_10,
  t0.active AS active_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13
FROM
  brokers 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.phone AS phone_5, t0.title AS title_6, t0.role AS role_7, t0.language AS language_8, t0.password_hash AS password_hash_9, t0.signature_html AS signature_html_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM brokers t0 WHERE t0.id = 1;

SELECT
  currency,
  COALESCE(
    SUM(sale_amount),
    0
  ) AS revenue,
  COALESCE(
    SUM(sale_amount - cost_amount),
    0
  ) AS margin
FROM
  deals
WHERE
  status IN ('in_progress', 'completed')
  AND MONTH(created_at)= MONTH(
    CURDATE()
  )
  AND YEAR(created_at)= YEAR(
    CURDATE()
  )
GROUP BY
  currency

SELECT currency, COALESCE(SUM(sale_amount),0) AS revenue, COALESCE(SUM(sale_amount-cost_amount),0) AS margin FROM deals WHERE status IN ('in_progress','completed') AND MONTH(created_at)=MONTH(CURDATE()) AND YEAR(created_at)=YEAR(CURDATE()) GROUP BY currency;

SELECT
  COALESCE(
    SUM(sale_amount),
    0
  )
FROM
  deals
WHERE
  status IN ('in_progress', 'completed')
  AND MONTH(created_at)= MONTH(
    CURDATE()
  )
  AND YEAR(created_at)= YEAR(
    CURDATE()
  )

SELECT COALESCE(SUM(sale_amount),0) FROM deals WHERE status IN ('in_progress','completed') AND MONTH(created_at)=MONTH(CURDATE()) AND YEAR(created_at)=YEAR(CURDATE());

SELECT
  t0.id AS id_1,
  t0.prospect_id AS prospect_id_2,
  t0.name AS name_3,
  t0.company AS company_4,
  t0.email AS email_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.country AS country_8,
  t0.preferred_lang AS preferred_lang_9,
  t0.notes AS notes_10,
  t0.first_invoice_date AS first_invoice_date_11,
  t0.total_revenue AS total_revenue_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14
FROM
  clients t0

SELECT t0.id AS id_1, t0.prospect_id AS prospect_id_2, t0.name AS name_3, t0.company AS company_4, t0.email AS email_5, t0.phone AS phone_6, t0.address AS address_7, t0.country AS country_8, t0.preferred_lang AS preferred_lang_9, t0.notes AS notes_10, t0.first_invoice_date AS first_invoice_date_11, t0.total_revenue AS total_revenue_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM clients t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.aoc AS aoc_3,
  t0.contact_name AS contact_name_4,
  t0.contact_phone AS contact_phone_5,
  t0.email_primary AS email_primary_6,
  t0.emails_additional AS emails_additional_7,
  t0.country AS country_8,
  t0.base_icao AS base_icao_9,
  t0.address AS address_10,
  t0.fleet_details AS fleet_details_11,
  t0.categories AS categories_12,
  t0.partnership AS partnership_13,
  t0.documents_status AS documents_status_14,
  t0.commercial_notes AS commercial_notes_15,
  t0.active AS active_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18
FROM
  operators t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.aoc AS aoc_3, t0.contact_name AS contact_name_4, t0.contact_phone AS contact_phone_5, t0.email_primary AS email_primary_6, t0.emails_additional AS emails_additional_7, t0.country AS country_8, t0.base_icao AS base_icao_9, t0.address AS address_10, t0.fleet_details AS fleet_details_11, t0.categories AS categories_12, t0.partnership AS partnership_13, t0.documents_status AS documents_status_14, t0.commercial_notes AS commercial_notes_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM operators t0;

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.title AS title_6,
  t0.role AS role_7,
  t0.language AS language_8,
  t0.password_hash AS password_hash_9,
  t0.signature_html AS signature_html_10,
  t0.active AS active_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13
FROM
  brokers t0
WHERE
  t0.active = ?
ORDER BY
  t0.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.phone AS phone_5, t0.title AS title_6, t0.role AS role_7, t0.language AS language_8, t0.password_hash AS password_hash_9, t0.signature_html AS signature_html_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM brokers t0 WHERE t0.active = 1 ORDER BY t0.first_name ASC;

SELECT
  id,
  invoice_number
FROM
  invoices
WHERE
  id IN (75, 76)

SELECT id, invoice_number FROM invoices WHERE id IN (75,76);

SELECT
  COUNT(*)
FROM
  deals
WHERE
  status = 'in_progress'

SELECT COUNT(*) FROM deals WHERE status='in_progress';

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.title AS title_6,
  t0.role AS role_7,
  t0.language AS language_8,
  t0.password_hash AS password_hash_9,
  t0.signature_html AS signature_html_10,
  t0.active AS active_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13
FROM
  brokers t0

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.title AS title_6, t0.role AS role_7, t0.language AS language_8, t0.password_hash AS password_hash_9, t0.signature_html AS signature_html_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM brokers t0;

SELECT
  COALESCE(
    SUM(sale_amount - cost_amount),
    0
  )
FROM
  deals
WHERE
  status IN ('in_progress', 'completed')
  AND MONTH(created_at)= MONTH(
    CURDATE()
  )
  AND YEAR(created_at)= YEAR(
    CURDATE()
  )

SELECT COALESCE(SUM(sale_amount-cost_amount),0) FROM deals WHERE status IN ('in_progress','completed') AND MONTH(created_at)=MONTH(CURDATE()) AND YEAR(created_at)=YEAR(CURDATE());

SELECT
  COUNT(*)
FROM
  deals
WHERE
  status = 'completed'

SELECT COUNT(*) FROM deals WHERE status='completed';

SELECT
  id,
  name
FROM
  operators
WHERE
  id IN (5)

SELECT id, name FROM operators WHERE id IN (5);