Query Metrics
76
Database Queries
7
Different statements
28.57 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25.44 ms (89.03%) |
69 |
SELECT t0.id AS id_1, t0.imported_id AS imported_id_2, t0.priority AS priority_3, t0.status AS status_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icon AS icon_8, t0.thumbnail AS thumbnail_9, t0.image AS image_10, t0.labels AS labels_11, t0.descriptions AS descriptions_12, t0.is_available AS is_available_13, t0.start_time AS start_time_14, t0.end_time AS end_time_15, t0.price AS price_16, t0.quantity AS quantity_17, t0.product_id AS product_id_18, t0.unit_id AS unit_id_19, t0.created_by AS created_by_20, t0.updated_by AS updated_by_21 FROM product_item t0 WHERE t0.product_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
0.75 ms (2.63%) |
2 |
SELECT t0.id AS id_1, t0.imported_id AS imported_id_2, t0.priority AS priority_3, t0.status AS status_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.labels AS labels_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM unit t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
0.57 ms (1.98%) |
1 |
SELECT t0.name AS name_1, t0.email AS email_2, t0.invoice AS invoice_3, t0.quote AS quote_4, t0.show_rib_in_invoice AS show_rib_in_invoice_5, t0.show_rib_in_quote AS show_rib_in_quote_6, t0.smtp_username AS smtp_username_7, t0.smtp_password AS smtp_password_8, t0.smtp_host AS smtp_host_9, t0.smtp_port AS smtp_port_10, t0.is_registration_external AS is_registration_external_11, t0.id AS id_12, t0.imported_id AS imported_id_13, t0.priority AS priority_14, t0.status AS status_15, t0.is_active AS is_active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.bic AS bic_19, t0.iban AS iban_20, t0.siret AS siret_21, t0.gender AS gender_22, t0.first_name AS first_name_23, t0.last_name AS last_name_24, t0.telephone AS telephone_25, t0.logo AS logo_26, t0.logo_light AS logo_light_27, t0.logo_dark AS logo_dark_28, t0.icon AS icon_29, t0.favicon AS favicon_30, t0.address AS address_31, t0.city AS city_32, t0.country AS country_33, t0.zip_code AS zip_code_34, t0.titles AS titles_35, t0.on_maintenance AS on_maintenance_36, t0.home_page_id AS home_page_id_37, t0.about_us_page_id AS about_us_page_id_38, t0.gallery_page_id AS gallery_page_id_39, t0.schedule_page_id AS schedule_page_id_40, t0.team_page_id AS team_page_id_41, t0.register_page_id AS register_page_id_42, t0.testimonials_page_id AS testimonials_page_id_43, t0.news_page_id AS news_page_id_44, t0.contact_page_id AS contact_page_id_45, t0.maintenance_page_id AS maintenance_page_id_46, t0.currency_id AS currency_id_47, t0.created_by AS created_by_48, t0.updated_by AS updated_by_49 FROM setting t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.55 ms (1.91%) |
1 |
SELECT t0.id AS id_1, t0.imported_id AS imported_id_2, t0.priority AS priority_3, t0.status AS status_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icon AS icon_8, t0.thumbnail AS thumbnail_9, t0.image AS image_10, t0.labels AS labels_11, t0.descriptions AS descriptions_12, t0.is_available AS is_available_13, t0.start_time AS start_time_14, t0.end_time AS end_time_15, t0.price AS price_16, t0.product_category_id AS product_category_id_17, t0.unit_id AS unit_id_18, t0.created_by AS created_by_19, t0.updated_by AS updated_by_20 FROM product t0 WHERE t0.is_available = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
0.49 ms (1.72%) |
1 |
SELECT t0.id AS id_1, t0.imported_id AS imported_id_2, t0.priority AS priority_3, t0.status AS status_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.labels AS labels_8, t0.number AS number_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM day t0 WHERE t0.is_active = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
0.45 ms (1.56%) |
1 |
SELECT t0.id AS id_1, t0.imported_id AS imported_id_2, t0.priority AS priority_3, t0.status AS status_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.labels AS labels_8, t0.image AS image_9, t0.is_available AS is_available_10, t0.parent_id AS parent_id_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13 FROM product_category t0 WHERE t0.is_available = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
0.33 ms (1.16%) |
1 |
SELECT t0.id AS id_1, t0.imported_id AS imported_id_2, t0.priority AS priority_3, t0.status AS status_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.labels AS labels_8, t0.image AS image_9, t0.is_available AS is_available_10, t0.parent_id AS parent_id_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13 FROM product_category t0 WHERE t0.id = ?
Parameters:
[
0
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Setting | No errors. |
App\Entity\Page | No errors. |
App\Entity\Currency | No errors. |
App\Entity\User | No errors. |
App\Entity\SocialNetwork | No errors. |
App\Entity\ProductCategory | No errors. |
App\Entity\Product | No errors. |
App\Entity\Unit | No errors. |
App\Entity\ProductItem | No errors. |
App\Entity\Day | No errors. |
App\Entity\DayItem | No errors. |
App\Entity\PurchaseItem | No errors. |