Query Metrics
2
Database Queries
2
Different statements
47.57 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.80 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.wtt_id AS wtt_id_4, t0.wtt_name AS wtt_name_5, t0.logo AS logo_6, t0.config AS config_7, t0.apikey AS apikey_8, t0.login_hash AS login_hash_9, t0.channel AS channel_10, t0.mail_copy AS mail_copy_11, t0.active AS active_12 FROM shop t0 WHERE t0.id = ?
Parameters:
[
"14"
]
|
| 2 | 46.77 ms |
SELECT s0_.id AS id_0, s0_.rank AS rank_1, s0_.qty AS qty_2, s0_.price AS price_3, s0_.grade AS grade_4, s0_.source_grade AS source_grade_5, s0_.public_price AS public_price_6, s0_.enabled AS enabled_7, s0_.updated AS updated_8, s0_.override AS override_9, s0_.option_price AS option_price_10, s0_.shop_id AS shop_id_11, s0_.model_id AS model_id_12, s0_.color_id AS color_id_13, s0_.product_id AS product_id_14 FROM stock s0_ INNER JOIN model m1_ ON s0_.model_id = m1_.id INNER JOIN manufacturer m2_ ON m1_.manufacturer_id = m2_.id INNER JOIN color c3_ ON s0_.color_id = c3_.id INNER JOIN category c4_ ON m1_.category_id = c4_.id WHERE s0_.shop_id = ? AND s0_.qty <> ? AND s0_.enabled = ? AND s0_.price > ? ORDER BY s0_.price ASC
Parameters:
[ 14 0 1 "100" ] |
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\Shop | No errors. |
| App\Entity\User |
|
| App\Entity\Order | No errors. |
| App\Entity\Stock | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\ShopSetting | No errors. |
| App\Entity\Imei | No errors. |
| App\Entity\Coupon | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Option | No errors. |
| App\Entity\Status | No errors. |
| App\Entity\Model | No errors. |
| App\Entity\Manufacturer | No errors. |
| App\Entity\Color | No errors. |
| App\Entity\Product | No errors. |