Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.registration_token AS registration_token_7,
  t0.security_token AS security_token_8,
  t0.active AS active_9,
  t0.admin AS admin_10,
  t0.phone AS phone_11,
  t0.fax AS fax_12,
  t0.mobile AS mobile_13,
  t0.erp_reference AS erp_reference_14,
  t0.news_read_on AS news_read_on_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.employee_of AS employee_of_18,
  t19.id AS id_20,
  t19.name AS name_21,
  t19.tax_id AS tax_id_22,
  t19.verified AS verified_23,
  t19.address_id AS address_id_24,
  t19.user_id AS user_id_25,
  t0.contact_through AS contact_through_26,
  t27.id AS id_28,
  t27.created AS created_29,
  t27.updated AS updated_30,
  t27.email AS email_31,
  t27.first_name AS first_name_32,
  t27.last_name AS last_name_33,
  t27.area AS area_34,
  t27.phone AS phone_35,
  t27.image AS image_36
FROM
  user t0
  LEFT JOIN contact_validation t19 ON t19.user_id = t0.id
  LEFT JOIN company_person t27 ON t0.contact_through = t27.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.registration_token AS registration_token_7, t0.security_token AS security_token_8, t0.active AS active_9, t0.admin AS admin_10, t0.phone AS phone_11, t0.fax AS fax_12, t0.mobile AS mobile_13, t0.erp_reference AS erp_reference_14, t0.news_read_on AS news_read_on_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.employee_of AS employee_of_18, t19.id AS id_20, t19.name AS name_21, t19.tax_id AS tax_id_22, t19.verified AS verified_23, t19.address_id AS address_id_24, t19.user_id AS user_id_25, t0.contact_through AS contact_through_26, t27.id AS id_28, t27.created AS created_29, t27.updated AS updated_30, t27.email AS email_31, t27.first_name AS first_name_32, t27.last_name AS last_name_33, t27.area AS area_34, t27.phone AS phone_35, t27.image AS image_36 FROM user t0 LEFT JOIN contact_validation t19 ON t19.user_id = t0.id LEFT JOIN company_person t27 ON t0.contact_through = t27.id WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tax_id AS tax_id_3,
  t0.currency AS currency_4,
  t0.language AS language_5,
  t0.verified AS verified_6,
  t0.blocked AS blocked_7,
  t0.discount AS discount_8,
  t0.logo AS logo_9,
  t0.erp_reference AS erp_reference_10,
  t0.certification AS certification_11,
  t0.recipients AS recipients_12,
  t0.address_id AS address_id_13,
  t0.delivery_address_id AS delivery_address_id_14,
  t0.billing_address_id AS billing_address_id_15,
  t0.distributor_id AS distributor_id_16,
  t0.type
FROM
  company t0
WHERE
  t0.id = ?
  AND t0.type IN ('core_company', 'company')

SELECT t0.id AS id_1, t0.name AS name_2, t0.tax_id AS tax_id_3, t0.currency AS currency_4, t0.language AS language_5, t0.verified AS verified_6, t0.blocked AS blocked_7, t0.discount AS discount_8, t0.logo AS logo_9, t0.erp_reference AS erp_reference_10, t0.certification AS certification_11, t0.recipients AS recipients_12, t0.address_id AS address_id_13, t0.delivery_address_id AS delivery_address_id_14, t0.billing_address_id AS billing_address_id_15, t0.distributor_id AS distributor_id_16, t0.type FROM company t0 WHERE t0.id = 1 AND t0.type IN ('core_company', 'company');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tax_id AS tax_id_3,
  t0.currency AS currency_4,
  t0.language AS language_5,
  t0.verified AS verified_6,
  t0.blocked AS blocked_7,
  t0.discount AS discount_8,
  t0.logo AS logo_9,
  t0.erp_reference AS erp_reference_10,
  t0.certification AS certification_11,
  t0.recipients AS recipients_12,
  t0.address_id AS address_id_13,
  t0.delivery_address_id AS delivery_address_id_14,
  t0.billing_address_id AS billing_address_id_15,
  t0.distributor_id AS distributor_id_16,
  t0.type
FROM
  company t0
WHERE
  t0.id = ?
  AND t0.type IN ('company')

SELECT t0.id AS id_1, t0.name AS name_2, t0.tax_id AS tax_id_3, t0.currency AS currency_4, t0.language AS language_5, t0.verified AS verified_6, t0.blocked AS blocked_7, t0.discount AS discount_8, t0.logo AS logo_9, t0.erp_reference AS erp_reference_10, t0.certification AS certification_11, t0.recipients AS recipients_12, t0.address_id AS address_id_13, t0.delivery_address_id AS delivery_address_id_14, t0.billing_address_id AS billing_address_id_15, t0.distributor_id AS distributor_id_16, t0.type FROM company t0 WHERE t0.id = 5 AND t0.type IN ('company');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.active AS active_4,
  t0.type AS type_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
groups
  t0
  INNER JOIN user_group ON t0.id = user_group.group_id
WHERE
  user_group.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.active AS active_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM groups t0 INNER JOIN user_group ON t0.id = user_group.group_id WHERE user_group.user_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.active AS active_4,
  t0.type AS type_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
groups
  t0
  INNER JOIN core_company_group ON t0.id = core_company_group.group_id
WHERE
  core_company_group.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.active AS active_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM groups t0 INNER JOIN core_company_group ON t0.id = core_company_group.group_id WHERE core_company_group.company_id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.logo AS logo_3,
  t0.theme AS theme_4,
  t0.order_confirmation_recipients AS order_confirmation_recipients_5,
  t0.website AS website_6,
  t0.address AS address_7,
  t0.company AS company_8,
  t0.maintenance_enabled AS maintenance_enabled_9,
  t0.maintenance_message AS maintenance_message_10,
  t0.settings AS settings_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.default_contact AS default_contact_14,
  t15.id AS id_16,
  t15.created AS created_17,
  t15.updated AS updated_18,
  t15.email AS email_19,
  t15.first_name AS first_name_20,
  t15.last_name AS last_name_21,
  t15.area AS area_22,
  t15.phone AS phone_23,
  t15.image AS image_24
FROM
  site t0
  LEFT JOIN company_person t15 ON t0.default_contact = t15.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.theme AS theme_4, t0.order_confirmation_recipients AS order_confirmation_recipients_5, t0.website AS website_6, t0.address AS address_7, t0.company AS company_8, t0.maintenance_enabled AS maintenance_enabled_9, t0.maintenance_message AS maintenance_message_10, t0.settings AS settings_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.default_contact AS default_contact_14, t15.id AS id_16, t15.created AS created_17, t15.updated AS updated_18, t15.email AS email_19, t15.first_name AS first_name_20, t15.last_name AS last_name_21, t15.area AS area_22, t15.phone AS phone_23, t15.image AS image_24 FROM site t0 LEFT JOIN company_person t15 ON t0.default_contact = t15.id WHERE t0.id = 1 LIMIT 1;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'de' AND e0_.object_class = 'Roothirsch\\CoreBundle\\Site\\Entity\\Site';

SELECT
  t0.id AS id_1,
  t0.language_name AS language_name_2,
  t0.language_key AS language_key_3,
  t0.is_default_language AS is_default_language_4,
  t0.image AS image_5
FROM
  translation_language t0
WHERE
  t0.language_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language_name AS language_name_2, t0.language_key AS language_key_3, t0.is_default_language AS is_default_language_4, t0.image AS image_5 FROM translation_language t0 WHERE t0.language_key = 'de' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.state AS state_2,
  t0.title AS title_3,
  t0.label AS label_4,
  t0.unit_price AS unit_price_5,
  t0.amount AS amount_6,
  t0.optional AS optional_7,
  t0.articles AS articles_8,
  t0.price_adjustments AS price_adjustments_9,
  t0.additional_discounts AS additional_discounts_10,
  t0.surcharges AS surcharges_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.type_id AS type_id_14,
  t0.estimate_id AS estimate_id_15
FROM
  shop_estimate_position t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.state AS state_2, t0.title AS title_3, t0.label AS label_4, t0.unit_price AS unit_price_5, t0.amount AS amount_6, t0.optional AS optional_7, t0.articles AS articles_8, t0.price_adjustments AS price_adjustments_9, t0.additional_discounts AS additional_discounts_10, t0.surcharges AS surcharges_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.type_id AS type_id_14, t0.estimate_id AS estimate_id_15 FROM shop_estimate_position t0 WHERE t0.id = '64504';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.preview AS preview_5,
  t0.cart_display_mode AS cart_display_mode_6,
  t0.price AS price_7,
  t0.stock AS stock_8,
  t0.type,
  t0.product_id AS product_id_9
FROM
  pim_product t0
WHERE
  t0.id = ?
  AND t0.type IN ('product', 'article')

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.description AS description_4, t0.preview AS preview_5, t0.cart_display_mode AS cart_display_mode_6, t0.price AS price_7, t0.stock AS stock_8, t0.type, t0.product_id AS product_id_9 FROM pim_product t0 WHERE t0.id = 409 AND t0.type IN ('product', 'article');

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.tree_root AS tree_root_8,
  t0.parent_id AS parent_id_9
FROM
  pim_category t0
  INNER JOIN pim_product_categories ON t0.id = pim_product_categories.category_id
WHERE
  pim_product_categories.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.tree_root AS tree_root_8, t0.parent_id AS parent_id_9 FROM pim_category t0 INNER JOIN pim_product_categories ON t0.id = pim_product_categories.category_id WHERE pim_product_categories.product_id = 409;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  pim_attribute_group t0
  INNER JOIN pim_category_product_attribute_groups ON t0.id = pim_category_product_attribute_groups.attribute_group_id
WHERE
  pim_category_product_attribute_groups.category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM pim_attribute_group t0 INNER JOIN pim_category_product_attribute_groups ON t0.id = pim_category_product_attribute_groups.attribute_group_id WHERE pim_category_product_attribute_groups.category_id = 10;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '409' AND e0_.locale = 'de' AND e0_.object_class = 'Roothirsch\\PimBundle\\Entity\\Product';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.name AS name_3,
  t0.data AS data_4,
  t0.value AS value_5,
  t0.amount AS amount_6,
  t0.amount_format AS amount_format_7,
  t0.price AS price_8,
  t0.total AS total_9,
  t0.article AS article_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.position_id AS position_id_13
FROM
  shop_estimate_position_attribute t0
WHERE
  t0.position_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.data AS data_4, t0.value AS value_5, t0.amount AS amount_6, t0.amount_format AS amount_format_7, t0.price AS price_8, t0.total AS total_9, t0.article AS article_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.position_id AS position_id_13 FROM shop_estimate_position_attribute t0 WHERE t0.position_id = 64504 ORDER BY t0.name ASC;