Query Metrics
13
Database Queries
5
Different statements
4.05 ms
Query time
0
Invalid entities
30
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.version AS version_4, t0.author AS author_5, t0.description AS description_6, t0.license AS license_7, t0.state AS state_8, t0.path AS path_9, t0.manifest AS manifest_10, t0.pteroca_min_version AS pteroca_min_version_11, t0.pteroca_max_version AS pteroca_max_version_12, t0.enabled_at AS enabled_at_13, t0.disabled_at AS disabled_at_14, t0.fault_reason AS fault_reason_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM plugin t0 WHERE t0.state = ? ORDER BY t0.name ASC
Parameters:
[
"enabled"
]
|
||||||||||||||||||||||||||
| 2 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.featured AS featured_4, t0.description AS description_5, t0.image_path AS image_path_6, t0.deleted_at AS deleted_at_7 FROM category t0 WHERE t0.deleted_at IS NULL ORDER BY t0.priority ASC, t0.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||
| 3 | 0.23 ms |
SELECT t0.description AS description_1, t0.is_active AS is_active_2, t0.priority AS priority_3, t0.featured AS featured_4, t0.image_path AS image_path_5, t0.banner_path AS banner_path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.id AS id_10, t0.name AS name_11, t0.disk_space AS disk_space_12, t0.memory AS memory_13, t0.io AS io_14, t0.cpu AS cpu_15, t0.threads AS threads_16, t0.db_count AS db_count_17, t0.swap AS swap_18, t0.backups AS backups_19, t0.ports AS ports_20, t0.schedules AS schedules_21, t0.nodes AS nodes_22, t0.nest AS nest_23, t0.eggs AS eggs_24, t0.eggs_configuration AS eggs_configuration_25, t0.allow_change_egg AS allow_change_egg_26, t0.allow_auto_renewal AS allow_auto_renewal_27, t0.allow_user_select_location AS allow_user_select_location_28, t0.category_id AS category_id_29 FROM product t0 WHERE t0.category_id = ? AND t0.is_active = ? AND t0.deleted_at IS NULL ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[ 1 1 ]
|
||||||||||||||||||||||||||
| 4 | 0.24 ms |
SELECT t0.description AS description_1, t0.is_active AS is_active_2, t0.priority AS priority_3, t0.featured AS featured_4, t0.image_path AS image_path_5, t0.banner_path AS banner_path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.id AS id_10, t0.name AS name_11, t0.disk_space AS disk_space_12, t0.memory AS memory_13, t0.io AS io_14, t0.cpu AS cpu_15, t0.threads AS threads_16, t0.db_count AS db_count_17, t0.swap AS swap_18, t0.backups AS backups_19, t0.ports AS ports_20, t0.schedules AS schedules_21, t0.nodes AS nodes_22, t0.nest AS nest_23, t0.eggs AS eggs_24, t0.eggs_configuration AS eggs_configuration_25, t0.allow_change_egg AS allow_change_egg_26, t0.allow_auto_renewal AS allow_auto_renewal_27, t0.allow_user_select_location AS allow_user_select_location_28, t0.category_id AS category_id_29 FROM product t0 WHERE t0.category_id = ? AND t0.is_active = ? AND t0.deleted_at IS NULL ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[ 2 1 ]
|
||||||||||||||||||||||||||
| 5 | 0.12 ms |
SELECT t0.description AS description_1, t0.is_active AS is_active_2, t0.priority AS priority_3, t0.featured AS featured_4, t0.image_path AS image_path_5, t0.banner_path AS banner_path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.id AS id_10, t0.name AS name_11, t0.disk_space AS disk_space_12, t0.memory AS memory_13, t0.io AS io_14, t0.cpu AS cpu_15, t0.threads AS threads_16, t0.db_count AS db_count_17, t0.swap AS swap_18, t0.backups AS backups_19, t0.ports AS ports_20, t0.schedules AS schedules_21, t0.nodes AS nodes_22, t0.nest AS nest_23, t0.eggs AS eggs_24, t0.eggs_configuration AS eggs_configuration_25, t0.allow_change_egg AS allow_change_egg_26, t0.allow_auto_renewal AS allow_auto_renewal_27, t0.allow_user_select_location AS allow_user_select_location_28, t0.category_id AS category_id_29 FROM product t0 WHERE t0.category_id = ? AND t0.is_active = ? AND t0.deleted_at IS NULL ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[ 3 1 ]
|
||||||||||||||||||||||||||
| 6 | 0.11 ms |
SELECT t0.description AS description_1, t0.is_active AS is_active_2, t0.priority AS priority_3, t0.featured AS featured_4, t0.image_path AS image_path_5, t0.banner_path AS banner_path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.id AS id_10, t0.name AS name_11, t0.disk_space AS disk_space_12, t0.memory AS memory_13, t0.io AS io_14, t0.cpu AS cpu_15, t0.threads AS threads_16, t0.db_count AS db_count_17, t0.swap AS swap_18, t0.backups AS backups_19, t0.ports AS ports_20, t0.schedules AS schedules_21, t0.nodes AS nodes_22, t0.nest AS nest_23, t0.eggs AS eggs_24, t0.eggs_configuration AS eggs_configuration_25, t0.allow_change_egg AS allow_change_egg_26, t0.allow_auto_renewal AS allow_auto_renewal_27, t0.allow_user_select_location AS allow_user_select_location_28, t0.category_id AS category_id_29 FROM product t0 WHERE t0.category_id = ? AND t0.is_active = ? AND t0.deleted_at IS NULL ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[ 6 1 ]
|
||||||||||||||||||||||||||
| 7 | 0.09 ms |
SELECT t0.description AS description_1, t0.is_active AS is_active_2, t0.priority AS priority_3, t0.featured AS featured_4, t0.image_path AS image_path_5, t0.banner_path AS banner_path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.id AS id_10, t0.name AS name_11, t0.disk_space AS disk_space_12, t0.memory AS memory_13, t0.io AS io_14, t0.cpu AS cpu_15, t0.threads AS threads_16, t0.db_count AS db_count_17, t0.swap AS swap_18, t0.backups AS backups_19, t0.ports AS ports_20, t0.schedules AS schedules_21, t0.nodes AS nodes_22, t0.nest AS nest_23, t0.eggs AS eggs_24, t0.eggs_configuration AS eggs_configuration_25, t0.allow_change_egg AS allow_change_egg_26, t0.allow_auto_renewal AS allow_auto_renewal_27, t0.allow_user_select_location AS allow_user_select_location_28, t0.category_id AS category_id_29 FROM product t0 WHERE t0.category_id = ? AND t0.is_active = ? AND t0.deleted_at IS NULL ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[ 4 1 ]
|
||||||||||||||||||||||||||
| 8 | 0.24 ms |
SELECT t0.description AS description_1, t0.is_active AS is_active_2, t0.priority AS priority_3, t0.featured AS featured_4, t0.image_path AS image_path_5, t0.banner_path AS banner_path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.id AS id_10, t0.name AS name_11, t0.disk_space AS disk_space_12, t0.memory AS memory_13, t0.io AS io_14, t0.cpu AS cpu_15, t0.threads AS threads_16, t0.db_count AS db_count_17, t0.swap AS swap_18, t0.backups AS backups_19, t0.ports AS ports_20, t0.schedules AS schedules_21, t0.nodes AS nodes_22, t0.nest AS nest_23, t0.eggs AS eggs_24, t0.eggs_configuration AS eggs_configuration_25, t0.allow_change_egg AS allow_change_egg_26, t0.allow_auto_renewal AS allow_auto_renewal_27, t0.allow_user_select_location AS allow_user_select_location_28, t0.category_id AS category_id_29 FROM product t0 WHERE t0.category_id IS NULL AND t0.is_active = ? AND t0.deleted_at IS NULL ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||
| 9 | 0.61 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.unit AS unit_4, t0.price AS price_5, t0.deleted_at AS deleted_at_6, t0.product_id AS product_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||
| 10 | 0.10 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.unit AS unit_4, t0.price AS price_5, t0.deleted_at AS deleted_at_6, t0.product_id AS product_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||
| 11 | 0.35 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.unit AS unit_4, t0.price AS price_5, t0.deleted_at AS deleted_at_6, t0.product_id AS product_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||
| 12 | 0.09 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.unit AS unit_4, t0.price AS price_5, t0.deleted_at AS deleted_at_6, t0.product_id AS product_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||||||
| 13 | 1.29 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.unit AS unit_4, t0.price AS price_5, t0.deleted_at AS deleted_at_6, t0.product_id AS product_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
4
]
|
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\Core\Entity\ProductPrice | 17 |
| App\Core\Entity\Category | 5 |
| App\Core\Entity\Product | 5 |
| App\Core\Entity\Plugin | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Core\Entity\Plugin | No errors. |
| App\Core\Entity\Category | No errors. |
| App\Core\Entity\Product | No errors. |
| App\Core\Entity\ProductPrice | No errors. |