Query Metrics
4
Database Queries
4
Different statements
32.74 ms
Query time
0
Invalid entities
20
Managed entities
Queries
#▲ | 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 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Company | No errors. |
App\Entity\Product\Offer | No errors. |
App\Entity\Product\FavouriteOffer | No errors. |
App\Entity\Offer\OfferProposal | No errors. |
App\Entity\Offer\OfferUserConsult | No errors. |
App\Entity\Product\Product | No errors. |
App\Entity\Country | No errors. |
App\Entity\Region | No errors. |
App\Entity\SubRegion | No errors. |
App\Entity\Product\Color | No errors. |
App\Entity\Product\Type | No errors. |
App\Entity\Product\SubType | No errors. |
App\Entity\Property\Property | No errors. |
App\Entity\Product\Classification | No errors. |
App\Entity\Product\Line | No errors. |
App\Entity\Property\Producer | No errors. |
App\Entity\Product\VintageSettings | No errors. |
App\Entity\Product\Vintage | No errors. |
App\Entity\Product\Appellation | No errors. |
App\Entity\Product\Dictionary | No errors. |
App\Entity\Product\Acronym | No errors. |