Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_point_of_sale p0_ WHERE 1 = 1

[]

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  prim_point_of_sale p0_
WHERE
  1 = 1

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_point_of_sale p0_ WHERE 1 = 1;

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1 FROM prim_point_of_sale p0_ WHERE 1 = 1 ORDER BY p0_.name ASC LIMIT 15

[]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.name AS name_1
FROM
  prim_point_of_sale p0_
WHERE
  1 = 1
ORDER BY
  p0_.name ASC
LIMIT
  15

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1 FROM prim_point_of_sale p0_ WHERE 1 = 1 ORDER BY p0_.name ASC LIMIT 15;

SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.slug AS slug_2, p0_.code AS code_3, p0_.name AS name_4, p0_.vat AS vat_5, p0_.fiscal_code AS fiscal_code_6, p0_.address AS address_7, p0_.city AS city_8, p0_.zip AS zip_9, p0_.country AS country_10, p0_.email AS email_11, p0_.phone AS phone_12, p0_.directory_path AS directory_path_13, p0_.logo_path AS logo_path_14, p0_.latitude AS latitude_15, p0_.longitude AS longitude_16 FROM prim_point_of_sale p0_ WHERE 1 = 1 AND p0_.id IN (?, ?, ?, ?) ORDER BY p0_.name ASC

[
  "1"
  "2"
  "4"
  "3"
]

SELECT
  p0_.id AS id_0,
  p0_.is_active AS is_active_1,
  p0_.slug AS slug_2,
  p0_.code AS code_3,
  p0_.name AS name_4,
  p0_.vat AS vat_5,
  p0_.fiscal_code AS fiscal_code_6,
  p0_.address AS address_7,
  p0_.city AS city_8,
  p0_.zip AS zip_9,
  p0_.country AS country_10,
  p0_.email AS email_11,
  p0_.phone AS phone_12,
  p0_.directory_path AS directory_path_13,
  p0_.logo_path AS logo_path_14,
  p0_.latitude AS latitude_15,
  p0_.longitude AS longitude_16
FROM
  prim_point_of_sale p0_
WHERE
  1 = 1
  AND p0_.id IN (?, ?, ?, ?)
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.slug AS slug_2, p0_.code AS code_3, p0_.name AS name_4, p0_.vat AS vat_5, p0_.fiscal_code AS fiscal_code_6, p0_.address AS address_7, p0_.city AS city_8, p0_.zip AS zip_9, p0_.country AS country_10, p0_.email AS email_11, p0_.phone AS phone_12, p0_.directory_path AS directory_path_13, p0_.logo_path AS logo_path_14, p0_.latitude AS latitude_15, p0_.longitude AS longitude_16 FROM prim_point_of_sale p0_ WHERE 1 = 1 AND p0_.id IN ('1', '2', '4', '3') ORDER BY p0_.name ASC;

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.point_of_sale_id = ?

[
  "1"
]

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.role AS role_3,
  t0.user_id AS user_id_4,
  t0.point_of_sale_id AS point_of_sale_id_5
FROM
  prim_join_table_user_pos t0
WHERE
  t0.point_of_sale_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.point_of_sale_id = '1';

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.point_of_sale_id = ?

[
  "2"
]

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.role AS role_3,
  t0.user_id AS user_id_4,
  t0.point_of_sale_id AS point_of_sale_id_5
FROM
  prim_join_table_user_pos t0
WHERE
  t0.point_of_sale_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.point_of_sale_id = '2';

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_offer AS is_offer_3, t0.qty AS qty_4, t0.price AS price_5, t0.price_offer AS price_offer_6, t0.catalogue_product_id AS catalogue_product_id_7, t0.point_of_sale_id AS point_of_sale_id_8 FROM prim_join_table_pos_catalogue_product t0 WHERE t0.point_of_sale_id = ?

[
  "2"
]

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.is_offer AS is_offer_3,
  t0.qty AS qty_4,
  t0.price AS price_5,
  t0.price_offer AS price_offer_6,
  t0.catalogue_product_id AS catalogue_product_id_7,
  t0.point_of_sale_id AS point_of_sale_id_8
FROM
  prim_join_table_pos_catalogue_product t0
WHERE
  t0.point_of_sale_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_offer AS is_offer_3, t0.qty AS qty_4, t0.price AS price_5, t0.price_offer AS price_offer_6, t0.catalogue_product_id AS catalogue_product_id_7, t0.point_of_sale_id AS point_of_sale_id_8 FROM prim_join_table_pos_catalogue_product t0 WHERE t0.point_of_sale_id = '2';

SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.point_of_sale_id = ?

[
  "2"
]

SELECT
  t0.id AS id_1,
  t0.receipt_path AS receipt_path_2,
  t0.is_closed AS is_closed_3,
  t0.assign_date AS assign_date_4,
  t0.withdraw_date AS withdraw_date_5,
  t0.iqp_code_id AS iqp_code_id_6,
  t0.prize_id AS prize_id_7,
  t0.campaign_id AS campaign_id_8,
  t0.user_id AS user_id_9,
  t0.point_of_sale_id AS point_of_sale_id_10
FROM
  prim_campaign_ticket t0
WHERE
  t0.point_of_sale_id = ?

SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.point_of_sale_id = '2';

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.company AS company_4, t0.address AS address_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.image_path AS image_path_8, t0.directory_path AS directory_path_9, t0.alert_email AS alert_email_10, t0.notes AS notes_11, t0.iqp_code_id AS iqp_code_id_12, t0.maintenance_category_id AS maintenance_category_id_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM prim_maintenance t0 WHERE t0.point_of_sale_id = ?

[
  "2"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.company AS company_4,
  t0.address AS address_5,
  t0.lat AS lat_6,
  t0.lng AS lng_7,
  t0.image_path AS image_path_8,
  t0.directory_path AS directory_path_9,
  t0.alert_email AS alert_email_10,
  t0.notes AS notes_11,
  t0.iqp_code_id AS iqp_code_id_12,
  t0.maintenance_category_id AS maintenance_category_id_13,
  t0.point_of_sale_id AS point_of_sale_id_14
FROM
  prim_maintenance t0
WHERE
  t0.point_of_sale_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.company AS company_4, t0.address AS address_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.image_path AS image_path_8, t0.directory_path AS directory_path_9, t0.alert_email AS alert_email_10, t0.notes AS notes_11, t0.iqp_code_id AS iqp_code_id_12, t0.maintenance_category_id AS maintenance_category_id_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM prim_maintenance t0 WHERE t0.point_of_sale_id = '2';

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.point_of_sale_id = ?

[
  "4"
]

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.role AS role_3,
  t0.user_id AS user_id_4,
  t0.point_of_sale_id AS point_of_sale_id_5
FROM
  prim_join_table_user_pos t0
WHERE
  t0.point_of_sale_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.point_of_sale_id = '4';

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.point_of_sale_id = ?

[
  "3"
]

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.role AS role_3,
  t0.user_id AS user_id_4,
  t0.point_of_sale_id AS point_of_sale_id_5
FROM
  prim_join_table_user_pos t0
WHERE
  t0.point_of_sale_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.point_of_sale_id = '3';