Symfony Profiler

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.id AS id_1
FROM
  product p0_
  INNER JOIN product_availability p1_ ON (p1_.product_id = p0_.id)
  LEFT JOIN product_connection p2_ ON (p2_.product_id = p0_.id)
WHERE
  p1_.provider_name LIKE ?
  OR p1_.provider_part_number LIKE ?
ORDER BY
  p0_.id DESC
LIMIT
  100

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ INNER JOIN product_availability p1_ ON (p1_.product_id = p0_.id) LEFT JOIN product_connection p2_ ON (p2_.product_id = p0_.id) WHERE p1_.provider_name LIKE '%NFFD 183%' OR p1_.provider_part_number LIKE '%NFFD 183%' ORDER BY p0_.id DESC LIMIT 100;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  INNER JOIN product_availability p1_ ON (p1_.product_id = p0_.id)
  LEFT JOIN product_connection p2_ ON (p2_.product_id = p0_.id)
WHERE
  p1_.provider_name LIKE ?
  OR p1_.provider_part_number LIKE ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_availability p1_ ON (p1_.product_id = p0_.id) LEFT JOIN product_connection p2_ ON (p2_.product_id = p0_.id) WHERE p1_.provider_name LIKE '%NFFD 183%' OR p1_.provider_part_number LIKE '%NFFD 183%';

SELECT
  DISTINCT(brand) AS brand
FROM
  product_availability
WHERE
  brand != ''
ORDER BY
  brand ASC

SELECT DISTINCT(brand) AS brand
                FROM product_availability
                WHERE brand != ''
                ORDER BY brand ASC;

SELECT
  t0.id AS id_1,
  t0.provider_name AS provider_name_2,
  t0.provider_article AS provider_article_3,
  t0.provider_part_number AS provider_part_number_4,
  t0.brand AS brand_5,
  t0.stock AS stock_6,
  t0.price_usd AS price_usd_7,
  t0.price_eur AS price_eur_8,
  t0.price_rub AS price_rub_9,
  t0.price_sale AS price_sale_10,
  t0.product_id AS product_id_11,
  t0.provider_id AS provider_id_12,
  t0.category_id AS category_id_13
FROM
  product_availability t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.provider_name AS provider_name_2, t0.provider_article AS provider_article_3, t0.provider_part_number AS provider_part_number_4, t0.brand AS brand_5, t0.stock AS stock_6, t0.price_usd AS price_usd_7, t0.price_eur AS price_eur_8, t0.price_rub AS price_rub_9, t0.price_sale AS price_sale_10, t0.product_id AS product_id_11, t0.provider_id AS provider_id_12, t0.category_id AS category_id_13 FROM product_availability t0 WHERE t0.product_id = 205726;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1
FROM
  product p0_
  INNER JOIN product_availability p1_ ON (p1_.product_id = p0_.id)
  LEFT JOIN product_connection p2_ ON (p2_.product_id = p0_.id)
WHERE
  (
    p1_.provider_name LIKE ?
    OR p1_.provider_part_number LIKE ?
  )
  AND p0_.id IN (?)
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.name AS name_1 FROM product p0_ INNER JOIN product_availability p1_ ON (p1_.product_id = p0_.id) LEFT JOIN product_connection p2_ ON (p2_.product_id = p0_.id) WHERE (p1_.provider_name LIKE '%NFFD 183%' OR p1_.provider_part_number LIKE '%NFFD 183%') AND p0_.id IN (205726, 205725, 106575, 33969, 33968) ORDER BY p0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.date_connected AS date_connected_2,
  t0.insales_product_id AS insales_product_id_3,
  t0.insales_variant_id AS insales_variant_id_4,
  t0.insales_sku AS insales_sku_5,
  t0.product_id AS product_id_6
FROM
  product_connection t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.date_connected AS date_connected_2, t0.insales_product_id AS insales_product_id_3, t0.insales_variant_id AS insales_variant_id_4, t0.insales_sku AS insales_sku_5, t0.product_id AS product_id_6 FROM product_connection t0 WHERE t0.product_id = 205726;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.global_charge_type AS global_charge_type_3,
  t0.global_charge_value AS global_charge_value_4,
  t0.pricelist_parameters AS pricelist_parameters_5,
  t0.stock_string_replacements AS stock_string_replacements_6,
  t0.category_separator AS category_separator_7
FROM
  provider t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.global_charge_type AS global_charge_type_3, t0.global_charge_value AS global_charge_value_4, t0.pricelist_parameters AS pricelist_parameters_5, t0.stock_string_replacements AS stock_string_replacements_6, t0.category_separator AS category_separator_7 FROM provider t0;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.global_charge_type AS global_charge_type_3,
  t0.global_charge_value AS global_charge_value_4,
  t0.pricelist_parameters AS pricelist_parameters_5,
  t0.stock_string_replacements AS stock_string_replacements_6,
  t0.category_separator AS category_separator_7
FROM
  provider t0
WHERE
  t0.id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.global_charge_type AS global_charge_type_3, t0.global_charge_value AS global_charge_value_4, t0.pricelist_parameters AS pricelist_parameters_5, t0.stock_string_replacements AS stock_string_replacements_6, t0.category_separator AS category_separator_7 FROM provider t0 WHERE t0.id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.hash AS hash_2,
  t0.name AS name_3,
  t0.provider_id AS provider_id_4,
  t0.parent_id AS parent_id_5
FROM
  category t0
WHERE
  t0.id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.name AS name_3, t0.provider_id AS provider_id_4, t0.parent_id AS parent_id_5 FROM category t0 WHERE t0.id IS NULL LIMIT 1;