Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM settings t0 WHERE t0.id = 'app.host';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.icon AS icon_4,
  p0_.lft AS lft_5,
  p0_.rgt AS rgt_6,
  p0_.depth AS depth_7
FROM
  product_category p0_
ORDER BY
  p0_.depth ASC,
  p0_.lft ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ ORDER BY p0_.depth ASC, p0_.lft ASC;

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.slug AS slug_2,
  u0_.description AS description_3,
  u0_.logo AS logo_4,
  u0_.image AS image_5,
  u0_.tin AS tin_6,
  u0_.street AS street_7,
  u0_.postal_code AS postal_code_8,
  u0_.city AS city_9,
  u0_.company_data_visible AS company_data_visible_10,
  u0_.bank_account_number AS bank_account_number_11,
  u0_.is_custom_subdomain AS is_custom_subdomain_12,
  u0_.custom_domain_name AS custom_domain_name_13,
  u0_.id_user AS id_user_14
FROM
  user_company u0_
  INNER JOIN user u1_ ON u0_.id_user = u1_.id
WHERE
  u1_.is_active = 1

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.slug AS slug_2, u0_.description AS description_3, u0_.logo AS logo_4, u0_.image AS image_5, u0_.tin AS tin_6, u0_.street AS street_7, u0_.postal_code AS postal_code_8, u0_.city AS city_9, u0_.company_data_visible AS company_data_visible_10, u0_.bank_account_number AS bank_account_number_11, u0_.is_custom_subdomain AS is_custom_subdomain_12, u0_.custom_domain_name AS custom_domain_name_13, u0_.id_user AS id_user_14 FROM user_company u0_ INNER JOIN user u1_ ON u0_.id_user = u1_.id WHERE u1_.is_active = 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.short_description AS short_description_3,
  p0_.description AS description_4,
  p0_.ean AS ean_5,
  p0_.sku AS sku_6,
  p0_.price AS price_7,
  p0_.vat AS vat_8,
  p0_.gross_price AS gross_price_9,
  p0_.stock_quantity AS stock_quantity_10,
  p0_.gross_weight AS gross_weight_11,
  p0_.package_width AS package_width_12,
  p0_.package_height AS package_height_13,
  p0_.package_length AS package_length_14,
  p0_.shipping_type AS shipping_type_15,
  p0_.is_active AS is_active_16,
  p0_.added_at AS added_at_17,
  p0_.id_product_category AS id_product_category_18,
  p0_.id_added_by_user AS id_added_by_user_19
FROM
  product p0_
  INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id
  INNER JOIN product_category p2_ ON p0_.id_product_category = p2_.id
WHERE
  p0_.is_active = 1
  AND u1_.is_active = 1
  AND p2_.lft >= ?
  AND p2_.rgt <= ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.ean AS ean_5, p0_.sku AS sku_6, p0_.price AS price_7, p0_.vat AS vat_8, p0_.gross_price AS gross_price_9, p0_.stock_quantity AS stock_quantity_10, p0_.gross_weight AS gross_weight_11, p0_.package_width AS package_width_12, p0_.package_height AS package_height_13, p0_.package_length AS package_length_14, p0_.shipping_type AS shipping_type_15, p0_.is_active AS is_active_16, p0_.added_at AS added_at_17, p0_.id_product_category AS id_product_category_18, p0_.id_added_by_user AS id_added_by_user_19 FROM product p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id INNER JOIN product_category p2_ ON p0_.id_product_category = p2_.id WHERE p0_.is_active = 1 AND u1_.is_active = 1 AND p2_.lft >= 2 AND p2_.rgt <= 5;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.id_product AS id_product_3
FROM
  product_image t0
WHERE
  t0.id_product = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.image AS image_2, t0.id_product AS id_product_3 FROM product_image t0 WHERE t0.id_product = 1 ORDER BY t0.id ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.icon AS icon_4,
  p0_.lft AS lft_5,
  p0_.rgt AS rgt_6,
  p0_.depth AS depth_7
FROM
  product_category p0_
WHERE
  p0_.lft < ?
  AND p0_.rgt > ?
ORDER BY
  p0_.lft DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ WHERE p0_.lft < 3 AND p0_.rgt > 4 ORDER BY p0_.lft DESC;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.id_product AS id_product_3
FROM
  product_image t0
WHERE
  t0.id_product = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.image AS image_2, t0.id_product AS id_product_3 FROM product_image t0 WHERE t0.id_product = 2 ORDER BY t0.id ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.icon AS icon_4,
  p0_.lft AS lft_5,
  p0_.rgt AS rgt_6,
  p0_.depth AS depth_7
FROM
  product_category p0_
WHERE
  p0_.lft < ?
  AND p0_.rgt > ?
ORDER BY
  p0_.lft DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ WHERE p0_.lft < 3 AND p0_.rgt > 4 ORDER BY p0_.lft DESC;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.email AS email_4,
  t0.type AS type_5,
  t0.is_active AS is_active_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.type AS type_5, t0.is_active AS is_active_6 FROM user t0 WHERE t0.id = '3';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.logo AS logo_5,
  t0.image AS image_6,
  t0.tin AS tin_7,
  t0.street AS street_8,
  t0.postal_code AS postal_code_9,
  t0.city AS city_10,
  t0.company_data_visible AS company_data_visible_11,
  t0.bank_account_number AS bank_account_number_12,
  t0.is_custom_subdomain AS is_custom_subdomain_13,
  t0.custom_domain_name AS custom_domain_name_14,
  t0.id_user AS id_user_15
FROM
  user_company t0
WHERE
  t0.id_user = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.logo AS logo_5, t0.image AS image_6, t0.tin AS tin_7, t0.street AS street_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.company_data_visible AS company_data_visible_11, t0.bank_account_number AS bank_account_number_12, t0.is_custom_subdomain AS is_custom_subdomain_13, t0.custom_domain_name AS custom_domain_name_14, t0.id_user AS id_user_15 FROM user_company t0 WHERE t0.id_user = '3';