GET https://app103.fr/autocomplete/product?page=2&query=drc

Query Metrics

4 Database Queries
4 Different statements
32.74 ms Query time
0 Invalid entities
20 Managed entities

Queries

Group similar statements

# Time Info
1 0.83 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = ?
Parameters:
[
  11
]
2 18.00 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT p0_.code AS code_0, p0_.display_name AS display_name_1, p0_.lwin AS lwin_2, p0_.site AS site_3, p0_.seller_price_qty AS seller_price_qty_4, p0_.price AS price_5, p0_.merged_uuids AS merged_uuids_6, p0_.has_lwin_suggests AS has_lwin_suggests_7, p0_.from_import AS from_import_8, p0_.bundle AS bundle_9, p0_.id AS id_10, p0_.uuid AS uuid_11, p0_.name AS name_12, p0_.status AS status_13 FROM product p0_ WHERE p0_.status = ? AND (p0_.name LIKE ? OR p0_.display_name LIKE ? OR p0_.code LIKE ?) GROUP BY p0_.id ORDER BY p0_.name ASC) dctrn_table
Parameters:
[
  1
  "%drc%"
  "%drc%"
  "%drc%"
]
3 12.98 ms
SELECT DISTINCT id_10 FROM (SELECT DISTINCT id_10, name_12 FROM (SELECT p0_.code AS code_0, p0_.display_name AS display_name_1, p0_.lwin AS lwin_2, p0_.site AS site_3, p0_.seller_price_qty AS seller_price_qty_4, p0_.price AS price_5, p0_.merged_uuids AS merged_uuids_6, p0_.has_lwin_suggests AS has_lwin_suggests_7, p0_.from_import AS from_import_8, p0_.bundle AS bundle_9, p0_.id AS id_10, p0_.uuid AS uuid_11, p0_.name AS name_12, p0_.status AS status_13 FROM product p0_ WHERE p0_.status = ? AND (p0_.name LIKE ? OR p0_.display_name LIKE ? OR p0_.code LIKE ?) GROUP BY p0_.id) dctrn_result_inner ORDER BY name_12 ASC) dctrn_result LIMIT 10 OFFSET 10
Parameters:
[
  1
  "%drc%"
  "%drc%"
  "%drc%"
]
4 0.94 ms
SELECT p0_.code AS code_0, p0_.display_name AS display_name_1, p0_.lwin AS lwin_2, p0_.site AS site_3, p0_.seller_price_qty AS seller_price_qty_4, p0_.price AS price_5, p0_.merged_uuids AS merged_uuids_6, p0_.has_lwin_suggests AS has_lwin_suggests_7, p0_.from_import AS from_import_8, p0_.bundle AS bundle_9, p0_.id AS id_10, p0_.uuid AS uuid_11, p0_.name AS name_12, p0_.status AS status_13, p0_.country_id AS country_id_14, p0_.region_id AS region_id_15, p0_.sub_region_id AS sub_region_id_16, p0_.color_id AS color_id_17, p0_.type_id AS type_id_18, p0_.sub_type_id AS sub_type_id_19, p0_.entity_id AS entity_id_20, p0_.classification_id AS classification_id_21, p0_.line_id AS line_id_22, p0_.producer_id AS producer_id_23 FROM product p0_ WHERE p0_.status = ? AND (p0_.name LIKE ? OR p0_.display_name LIKE ? OR p0_.code LIKE ?) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY p0_.id ORDER BY p0_.name ASC
Parameters:
[
  1
  "%drc%"
  "%drc%"
  "%drc%"
  2810
  2811
  2812
  5590
  2813
  2809
  4286
  4356
  4359
  5217
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Product\Product 10
App\Entity\Product\Color 2
App\Entity\Product\Type 2
App\Entity\Property\Property 2
App\Entity\Product\Classification 2
App\Entity\User 1
App\Entity\Company 1