Query Metrics
51
Database Queries
14
Different statements
183.19 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 8.05 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:
[
"5"
]
|
| 2 | 29.77 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.machine_name AS machine_name_3, t0.description AS description_4, t0.widget AS widget_5, t0.role AS role_6, t0.target AS target_7, t0.default_value AS default_value_8, t0.default_url AS default_url_9 FROM setting t0 WHERE t0.target = ?
Parameters:
[
"Shop"
]
|
| 3 | 0.53 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = ? AND t0.setting_id = ? LIMIT 1
Parameters:
[ 5 1 ] |
| 4 | 0.29 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = ? AND t0.setting_id = ? LIMIT 1
Parameters:
[ 5 4 ] |
| 5 | 0.28 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = ? AND t0.setting_id = ? LIMIT 1
Parameters:
[ 5 6 ] |
| 6 | 0.31 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = ? AND t0.setting_id = ? LIMIT 1
Parameters:
[ 5 7 ] |
| 7 | 0.29 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = ? AND t0.setting_id = ? LIMIT 1
Parameters:
[ 5 8 ] |
| 8 | 0.29 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = ? AND t0.setting_id = ? LIMIT 1
Parameters:
[ 5 9 ] |
| 9 | 4.97 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = ? AND t0.setting_id = ? LIMIT 1
Parameters:
[ 5 10 ] |
| 10 | 0.50 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = ? AND t0.setting_id = ? LIMIT 1
Parameters:
[ 5 11 ] |
| 11 | 0.29 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = ? AND t0.setting_id = ? LIMIT 1
Parameters:
[ 5 12 ] |
| 12 | 4.27 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:
[ 5 0 1 "100" ] |
| 13 | 6.93 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex AS hex_3, t0.wtt_id AS wtt_id_4 FROM color t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 14 | 4.76 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
1418
]
|
| 15 | 6.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.wtt_id AS wtt_id_3 FROM manufacturer t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 16 | 0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.wtt_id AS wtt_id_3, t0.type AS type_4 FROM category t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 17 | 13.70 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex AS hex_3, t0.wtt_id AS wtt_id_4 FROM color t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 18 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex AS hex_3, t0.wtt_id AS wtt_id_4 FROM color t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 19 | 7.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
150
]
|
| 20 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.wtt_id AS wtt_id_3, t0.type AS type_4 FROM category t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 21 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
25
]
|
| 22 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.wtt_id AS wtt_id_3, t0.type AS type_4 FROM category t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 23 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 24 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
153
]
|
| 25 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
37
]
|
| 26 | 2.54 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
79
]
|
| 27 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex AS hex_3, t0.wtt_id AS wtt_id_4 FROM color t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 28 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex AS hex_3, t0.wtt_id AS wtt_id_4 FROM color t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 29 | 2.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
80
]
|
| 30 | 6.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
42
]
|
| 31 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex AS hex_3, t0.wtt_id AS wtt_id_4 FROM color t0 WHERE t0.id = ?
Parameters:
[
12
]
|
| 32 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
45
]
|
| 33 | 3.99 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
35
]
|
| 34 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
1145
]
|
| 35 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
43
]
|
| 36 | 3.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
68
]
|
| 37 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
1216
]
|
| 38 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
74
]
|
| 39 | 3.03 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex AS hex_3, t0.wtt_id AS wtt_id_4 FROM color t0 WHERE t0.id = ?
Parameters:
[
16
]
|
| 40 | 7.85 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
1050
]
|
| 41 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
1164
]
|
| 42 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.wtt_id AS wtt_id_3, t0.type AS type_4 FROM category t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 43 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex AS hex_3, t0.wtt_id AS wtt_id_4 FROM color t0 WHERE t0.id = ?
Parameters:
[
30
]
|
| 44 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.label AS label_5, t0.wtt_id AS wtt_id_6, t0.manufacturer_id AS manufacturer_id_7, t0.category_id AS category_id_8 FROM model t0 WHERE t0.id = ?
Parameters:
[
612
]
|
| 45 | 4.21 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.wtt_id AS wtt_id_2, c0_.type AS type_3 FROM category c0_
Parameters:
[] |
| 46 | 26.45 ms |
SELECT o0_.id AS id_0, o0_.attribute_value AS attribute_value_1, o0_.name AS name_2, o0_.price AS price_3, o0_.target AS target_4, o0_.category_id AS category_id_5, o0_.attribute_id AS attribute_id_6 FROM option o0_ ORDER BY o0_.category_id ASC
Parameters:
[] |
| 47 | 0.60 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.wtt_id AS wtt_id_3, t0.type AS type_4 FROM category t0 INNER JOIN shop_category ON t0.id = shop_category.category_id WHERE shop_category.shop_id = ?
Parameters:
[
5
]
|
| 48 | 0.29 ms |
SELECT t0.id AS id_1, t0.attribute_value AS attribute_value_2, t0.name AS name_3, t0.price AS price_4, t0.target AS target_5, t0.category_id AS category_id_6, t0.attribute_id AS attribute_id_7 FROM option t0 INNER JOIN option_shop ON t0.id = option_shop.option_id WHERE option_shop.shop_id = ?
Parameters:
[
5
]
|
| 49 | 0.32 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.url AS url_3, t0.shop_id AS shop_id_4, t0.setting_id AS setting_id_5 FROM shop_setting t0 WHERE t0.shop_id = ?
Parameters:
[
5
]
|
| 50 | 20.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.machine_name AS machine_name_3, t0.description AS description_4, t0.widget AS widget_5, t0.role AS role_6, t0.target AS target_7, t0.default_value AS default_value_8, t0.default_url AS default_url_9 FROM setting t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 51 | 8.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.machine_name AS machine_name_3, t0.description AS description_4, t0.widget AS widget_5, t0.role AS role_6, t0.target AS target_7, t0.default_value AS default_value_8, t0.default_url AS default_url_9 FROM setting t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\Setting | No errors. |
| App\Entity\Model | No errors. |
| App\Entity\Manufacturer | No errors. |
| App\Entity\Color | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Attribute | No errors. |
| App\Entity\CategorySetting | No errors. |