Query Metrics
124
Database Queries
8
Different statements
2431.20 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1205.00 ms (49.56%) |
31 |
SELECT t0.id AS id_1, t0.product_declinaison_ref AS product_declinaison_ref_2, t0.price AS price_3, t0.visibility AS visibility_4, t0.date_add AS date_add_5, t0.date_upd AS date_upd_6, t0.product_declinaison_id AS product_declinaison_id_7, t0.cost AS cost_8, t0.stock AS stock_9, t0.warehouse_location AS warehouse_location_10, t0.ean AS ean_11, t0.product_id AS product_id_12 FROM products_declinaison t0 WHERE t0.product_declinaison_ref = ? LIMIT 1
Parameters:
[
"2604150844200"
]
|
|
1192.42 ms (49.05%) |
31 |
SELECT t0.id AS id_1, t0.product_declinaison_ref AS product_declinaison_ref_2, t0.price AS price_3, t0.visibility AS visibility_4, t0.date_add AS date_add_5, t0.date_upd AS date_upd_6, t0.product_declinaison_id AS product_declinaison_id_7, t0.cost AS cost_8, t0.stock AS stock_9, t0.warehouse_location AS warehouse_location_10, t0.ean AS ean_11, t0.product_id AS product_id_12 FROM products_declinaison t0 WHERE t0.ean = ? LIMIT 1
Parameters:
[
"2604150844200"
]
|
|
17.94 ms (0.74%) |
29 |
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.product_ref AS product_ref_3, t0.product_name AS product_name_4, t0.price AS price_5, t0.visibility AS visibility_6, t0.weight AS weight_7, t0.show_description AS show_description_8, t0.description AS description_9, t0.supplier AS supplier_10, t0.url_key AS url_key_11, t0.meta_title AS meta_title_12, t0.codification AS codification_13, t0.exclus_web AS exclus_web_14, t0.new_co AS new_co_15, t0.tax_id AS tax_id_16, t0.date_add AS date_add_17, t0.date_upd AS date_upd_18 FROM products t0 WHERE t0.id = ?
Parameters:
[
18134
]
|
|
13.23 ms (0.54%) |
29 |
SELECT t0.id AS id_1, t0.image_id AS image_id_2, t0.image_type AS image_type_3, t0.position AS position_4, t0.active AS active_5, t0.path AS path_6, t0.product_id AS product_id_7 FROM images t0 WHERE t0.product_id = ?
Parameters:
[
18134
]
|
|
0.78 ms (0.03%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.active AS active_8 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
17
]
|
|
0.76 ms (0.03%) |
1 |
SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.product_reference AS product_reference_3, t0.stock AS stock_4, t0.stock_added AS stock_added_5, t0.stock_total AS stock_total_6, t0.date_add AS date_add_7, t0.date_add_in_store AS date_add_in_store_8, t0.stock_in_store AS stock_in_store_9, t0.stock_added_in_store AS stock_added_in_store_10, t0.stock_total_in_store AS stock_total_in_store_11, t0.id_stock_mvt_id AS id_stock_mvt_id_12 FROM stock_mvt_detail t0 WHERE t0.id_stock_mvt_id = ?
Parameters:
[
4233
]
|
|
0.59 ms (0.02%) |
1 |
SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = ? LIMIT 1
Parameters:
[
"10"
]
|
|
0.47 ms (0.02%) |
1 |
SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.date_add AS date_add_3, t0.date_store_reception AS date_store_reception_4, t0.uniqid AS uniqid_5, t0.mvt_type AS mvt_type_6 FROM stock_mvt t0 WHERE t0.id = ?
Parameters:
[
"4233"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| dashboard | doctrine.dbal.dashboard_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\User | No errors. |
| App\Entity\HistoryAction | No errors. |
| App\Entity\Gifts | No errors. |
| App\Entity\GiftHistory | No errors. |
| App\Entity\Store | No errors. |
| App\Entity\StockMvt | No errors. |
| App\Entity\StockMvtDetail | No errors. |
| App\Entity\ProductsDeclinaison | No errors. |
| App\Entity\Products | No errors. |
| App\Entity\Images | No errors. |