Symfony Profiler

SELECT
  COUNT(*)
FROM
  (
    SELECT
      DISTINCT p.id_number,
      p.id,
      p.id procedure_id,
      p.registration_number,
      p.status,
      p.title,
      l.starting_price,
      p.original_price,
      p.currency,
      p.type,
      p.organizer_full_name,
      p.section,
      o.full_title_organization,
      o.inn,
      o.id organizer_id,
      p.customer_info_full_title_organization,
      p.customer_info_address,
      p.customer_info_email,
      p.customer_info_phone,
      p.customer_info_inn,
      p.registration_number,
      p.customer_info_last_name,
      p.customer_info_first_name,
      p.customer_info_patronymic,
      p.organizer_info_full_title_organization,
      p.organizer_info_first_name,
      p.organizer_info_last_name,
      p.organizer_info_patronymic,
      p.procedure_method_id,
      p.closed_purchase,
      ppm.title procedure_method_title,
      p.created_at,
      pn.publication_date_time,
      a.start_trading_date,
      l.start_date_of_applications,
      l.closing_date_of_applications,
      l.summing_up_applications,
      l.summing_up_date,
      l.review_bids_date,
      CASE p.status
      WHEN ? THEN
        1
      ELSE
        2
      END AS status_order
    FROM
      procedures p
      INNER JOIN profile_profiles profile ON p.profile_id = profile.id
      INNER JOIN profile_organizations o ON p.organization_id = o.id
      INNER JOIN lots l ON p.id = l.procedure_id
      LEFT JOIN profile_procedure_methods ppm ON p.procedure_method_id = ppm.id
      LEFT JOIN auctions a ON l.id = a.lot_id
      INNER JOIN purchase_notices pn ON l.id = pn.lot_id
      AND pn.type_notice = 'NOTICE_TYPE'
      INNER JOIN purchase_notice_lots pnl ON l.id = pnl.parent_lot_id
      INNER JOIN purchase_notice_lot_items pnli ON pnli.purchase_lot_id = pnl.id
    WHERE
      (pn.active IS NOT FALSE)
      AND (pn.status = ?)
      AND (p.status != ?)
      AND (
        ppm.type IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      )
      AND (p.closed_purchase = FALSE)
  ) tmp

SELECT COUNT(*) FROM (SELECT DISTINCT p.id_number, p.id, p.id procedure_id, p.registration_number, p.status, p.title, l.starting_price, p.original_price, p.currency, p.type, p.organizer_full_name, p.section, o.full_title_organization, o.inn, o.id organizer_id, p.customer_info_full_title_organization, p.customer_info_address, p.customer_info_email, p.customer_info_phone, p.customer_info_inn, p.registration_number, p.customer_info_last_name, p.customer_info_first_name, p.customer_info_patronymic, p.organizer_info_full_title_organization, p.organizer_info_first_name, p.organizer_info_last_name, p.organizer_info_patronymic, p.procedure_method_id, p.closed_purchase, ppm.title procedure_method_title, p.created_at, pn.publication_date_time, a.start_trading_date, l.start_date_of_applications, l.closing_date_of_applications, l.summing_up_applications, l.summing_up_date, l.review_bids_date, CASE p.status WHEN 'STATUS_ACCEPTING_APPLICATIONS' THEN 1 ELSE 2 END AS status_order FROM procedures p INNER JOIN profile_profiles profile ON p.profile_id = profile.id INNER JOIN profile_organizations o ON p.organization_id = o.id INNER JOIN lots l ON p.id = l.procedure_id LEFT JOIN profile_procedure_methods ppm ON p.procedure_method_id = ppm.id LEFT JOIN auctions a ON l.id = a.lot_id INNER JOIN purchase_notices pn ON l.id = pn.lot_id AND pn.type_notice = 'NOTICE_TYPE' INNER JOIN purchase_notice_lots pnl ON l.id = pnl.parent_lot_id INNER JOIN purchase_notice_lot_items pnli ON pnli.purchase_lot_id = pnl.id WHERE (pn.active IS NOT FALSE) AND (pn.status = 'STATUS_PUBLISHED') AND (p.status != 'STATUS_ARCHIVED') AND (ppm.type IN ('REQUEST_OFFERS', 'REQUEST_PRICE', 'CONTEST', 'MAKE_OFFERS', 'REQUEST_QUOTATION', 'QUOTATION_MAKE_OFFERS', 'COMPETITIVE_SELECTION', 'PREQUALIFICATION', 'MINI_PURCHASE', 'STOCK_MARKET', 'AUCTION', 'AUCTION_DOWN')) AND (p.closed_purchase = FALSE)) tmp;

SELECT
  DISTINCT p.id_number,
  p.id,
  p.id procedure_id,
  p.registration_number,
  p.status,
  p.title,
  l.starting_price,
  p.original_price,
  p.currency,
  p.type,
  p.organizer_full_name,
  p.section,
  o.full_title_organization,
  o.inn,
  o.id organizer_id,
  p.customer_info_full_title_organization,
  p.customer_info_address,
  p.customer_info_email,
  p.customer_info_phone,
  p.customer_info_inn,
  p.registration_number,
  p.customer_info_last_name,
  p.customer_info_first_name,
  p.customer_info_patronymic,
  p.organizer_info_full_title_organization,
  p.organizer_info_first_name,
  p.organizer_info_last_name,
  p.organizer_info_patronymic,
  p.procedure_method_id,
  p.closed_purchase,
  ppm.title procedure_method_title,
  p.created_at,
  pn.publication_date_time,
  a.start_trading_date,
  l.start_date_of_applications,
  l.closing_date_of_applications,
  l.summing_up_applications,
  l.summing_up_date,
  l.review_bids_date,
  CASE p.status
  WHEN ? THEN
    1
  ELSE
    2
  END AS status_order
FROM
  procedures p
  INNER JOIN profile_profiles profile ON p.profile_id = profile.id
  INNER JOIN profile_organizations o ON p.organization_id = o.id
  INNER JOIN lots l ON p.id = l.procedure_id
  LEFT JOIN profile_procedure_methods ppm ON p.procedure_method_id = ppm.id
  LEFT JOIN auctions a ON l.id = a.lot_id
  INNER JOIN purchase_notices pn ON l.id = pn.lot_id
  AND pn.type_notice = 'NOTICE_TYPE'
  INNER JOIN purchase_notice_lots pnl ON l.id = pnl.parent_lot_id
  INNER JOIN purchase_notice_lot_items pnli ON pnli.purchase_lot_id = pnl.id
WHERE
  (pn.active IS NOT FALSE)
  AND (pn.status = ?)
  AND (p.status != ?)
  AND (
    ppm.type IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND (p.closed_purchase = FALSE)
ORDER BY
  status_order ASC,
  l.start_date_of_applications DESC,
  p.id_number DESC
LIMIT
  9

SELECT DISTINCT p.id_number, p.id, p.id procedure_id, p.registration_number, p.status, p.title, l.starting_price, p.original_price, p.currency, p.type, p.organizer_full_name, p.section, o.full_title_organization, o.inn, o.id organizer_id, p.customer_info_full_title_organization, p.customer_info_address, p.customer_info_email, p.customer_info_phone, p.customer_info_inn, p.registration_number, p.customer_info_last_name, p.customer_info_first_name, p.customer_info_patronymic, p.organizer_info_full_title_organization, p.organizer_info_first_name, p.organizer_info_last_name, p.organizer_info_patronymic, p.procedure_method_id, p.closed_purchase, ppm.title procedure_method_title, p.created_at, pn.publication_date_time, a.start_trading_date, l.start_date_of_applications, l.closing_date_of_applications, l.summing_up_applications, l.summing_up_date, l.review_bids_date, CASE p.status WHEN 'STATUS_ACCEPTING_APPLICATIONS' THEN 1 ELSE 2 END AS status_order FROM procedures p INNER JOIN profile_profiles profile ON p.profile_id = profile.id INNER JOIN profile_organizations o ON p.organization_id = o.id INNER JOIN lots l ON p.id = l.procedure_id LEFT JOIN profile_procedure_methods ppm ON p.procedure_method_id = ppm.id LEFT JOIN auctions a ON l.id = a.lot_id INNER JOIN purchase_notices pn ON l.id = pn.lot_id AND pn.type_notice = 'NOTICE_TYPE' INNER JOIN purchase_notice_lots pnl ON l.id = pnl.parent_lot_id INNER JOIN purchase_notice_lot_items pnli ON pnli.purchase_lot_id = pnl.id WHERE (pn.active IS NOT FALSE) AND (pn.status = 'STATUS_PUBLISHED') AND (p.status != 'STATUS_ARCHIVED') AND (ppm.type IN ('REQUEST_OFFERS', 'REQUEST_PRICE', 'CONTEST', 'MAKE_OFFERS', 'REQUEST_QUOTATION', 'QUOTATION_MAKE_OFFERS', 'COMPETITIVE_SELECTION', 'PREQUALIFICATION', 'MINI_PURCHASE', 'STOCK_MARKET', 'AUCTION', 'AUCTION_DOWN')) AND (p.closed_purchase = FALSE) ORDER BY status_order ASC, l.start_date_of_applications DESC, p.id_number DESC LIMIT 9;

SELECT
  t.key,
  t.value
FROM
  translates t
  INNER JOIN languages l ON t.language_id = l.id
WHERE
  (l.code = ?)
  AND (t.status = ?)
ORDER BY
  t.key ASC

SELECT t.key, t.value FROM translates t INNER JOIN languages l ON t.language_id = l.id WHERE (l.code = 'ru') AND (t.status = 'STATUS_ACTIVE') ORDER BY t.key ASC;